Page 2 of 3
Re: help need to change currency
Posted: Tue Nov 03, 2009 6:53 am
by volkswest
I bought the script from a bloke in in the states, and installed in my server, yes the payment goes to my email address, that I added to my paypal acount. I dont know what you mean when you say Did the code also configure mysql for you too? the thing is that the payment shows up in $ USD instead of £ GBP. Thanks
Re: help need to change currency
Posted: Tue Nov 03, 2009 1:14 pm
by Eric!
What paypal method is your site using to bill people and accept payments?
Do you have phpmyadmin on your server? This tool is an easy way to view and edit your mysql database. Ask your host provider for it. You can use it to explore your database configuration and values. Maybe you'll see what the programmer was talking about.
Re: help need to change currency
Posted: Tue Nov 03, 2009 3:09 pm
by volkswest
The website payment method is both £ GBP and $USD. Yes I have phpmyadmin on my server and can access this through cpanel, can you please tell me how to explore your database configuration and values so I can change the currency to £ GBP.
Eric if you look at the website and click on the banner that says advertise here, then click on the buynow where it says £8.33 it takes you to paypal and the currency is in £. (WHICH I MANAGED TO CHANGE)
but if you click on prices then 1 ads for 7 days featured, click submit, it takes you to paypal but the currency is in $ USD, this is the thing I'm stuck on, can you sort the problem out if I pay you please???? thanks again.
Re: help need to change currency
Posted: Tue Nov 03, 2009 4:07 pm
by Eric!
Well, I always need money, I just don't have a lot of time. And you are almost there. Go into phpmyadmin, select the database on the left, then look at the table names and find the table and field your programmer said to change. Hopefully that's all you need to do.
You might also need to reconfigure your paypal buttons to use pounds too, but without seeing the full setup it is hard to say. So start with what your bloke told you to change.
Re: help need to change currency
Posted: Tue Nov 03, 2009 4:58 pm
by volkswest
Eric, The bloke from the USA just said it was in the mysql, and nothing else. I looked in the phpmy admin, clicked on the database then prices and got the following.
Indexes: Documentation Keyname Type Cardinality Action Field
PRIMARY PRIMARY 6 Edit Drop PriceID
PriceID INDEX None Edit Drop PriceID
The following indexes appear to be equal and one of them should be removed: PRIMARY, PriceID
I dont know if I'm looking in the right place though?? How do I do a search in SQL for the currency??
Re: help need to change currency
Posted: Tue Nov 03, 2009 5:07 pm
by pickle
Browse that table & see what the values are for the currency. You might need to edit each record in that table.
Re: help need to change currency
Posted: Tue Nov 03, 2009 5:21 pm
by volkswest
I have looked and cant see anything for currency, I'm afraid you are loosing me now.
Re: help need to change currency
Posted: Tue Nov 03, 2009 5:28 pm
by pickle
In phpmyadmin, when you look at a table, your initial view is of the table structure. There are tabs along the top - the first of which is "Browse". Clicking on that will show you all the data in the table. The prices might be listed there.
Judging by the column names (namely "PriceID"), I'm not sure the actual prices will be stored in this table, but it's worth a look.
Re: help need to change currency
Posted: Tue Nov 03, 2009 5:42 pm
by volkswest
Under structure there is a field called price and at the side of this it has type float(10,2)
I'm I in the wrong place??
Re: help need to change currency
Posted: Tue Nov 03, 2009 5:57 pm
by pickle
Nope - that sounds exactly like the place you'd want to be if you're updating the price - the actual number you charge people. If you go to "Browse", you'll see all your prices. Clicking the pencil beside a particular row will allow you to change the price.
However, that's not the place you need to be if you want to change the dollar symbol to the sterling. That might not be in the database.
Re: help need to change currency
Posted: Tue Nov 03, 2009 6:37 pm
by volkswest
I think you are right, I think it is in that code for the payment page? might be wrong though?
Re: help need to change currency
Posted: Tue Nov 03, 2009 8:45 pm
by Eric!
It's not in the code that you posted, at least there's nothing obvious there. So that leaves us to guess there's some currency selection in your database only because the guy who wrote it said so.
It can also be embedded in your paypal buttons or set as your primary currency. It could just as easily be in the code somewhere as there are a lot of variables in there that could define your currrency settings too. We are the blind leading the blind.
Can you get more details from him or demand a refund or a fix?
Also are the currency values really being changed or is the problem only with the displayed symbol? For example if I buy something for £1 does paypal and your database show a value of 1?
Re: help need to change currency
Posted: Wed Nov 04, 2009 7:41 am
by volkswest
Eric I did what you said and my brother sent a payment through via paypal, below are the results.
Hello Shane Dean,
You received a payment of $1.30 USD from Be
So it looks like the paypal button thats putting in USD instead of £ GBP.
I'm very confused about this matter.
I bought the script as is, and thought it would be easy to fix (how wrong was I?)
Re: help need to change currency
Posted: Wed Nov 04, 2009 7:55 am
by Eric!
It sounds like you need a programmer to go through your setup to find out where the currrency type is defined. Did you generate the html code for the paypal buttons?
Re: help need to change currency
Posted: Wed Nov 04, 2009 8:50 am
by volkswest
No the paypal buttons were already in the script, I have emailed the bloke again to ask him about it and will let you know as soon as he gets back to me, again thanks.