phpadsnew help please?

[phonexpo]

Hi,

I moved to a new server at the weekend. My forum and main site is fine, but my forum banners are not showing.The banner codes are in the header, but the main problem is I can't get into my phpadsnew CP. I tried every password/username that I use and I still can't get in.

I read the phpadsnew admin manual and it says;

I forgot my password, how can I retrieve it?



The username and password of the administrator are stored inside the database and is encrypted using a one-way MD5 hash. This means it is impossible to retrieve a lost password. However it is possible to set the password to a default value which you then can use to login. After using the default password to log into the administrator interface you need to change the password again. To set the password to the default you need to access the database directly using the mysql commandline interface or another tool such as phpMyAdmin and execute the following SQL query:

UPDATE phpads_config SET admin_pw =  '5ebe2294ecd0e0f08eab7690d2a6ee69';

If you used a different table prefix during the installation of phpAdsNew, please make sure you use the correct table name. After executing this query you can log into the admin interface using your old username and the password ?

secret? (without the quotes).

I tried the above but still no luck. I'm not 100% how to run a query, but I think I done it right.

Any advice please?

TIA

Patrick