Locked Myself Out

[HayleyP]

So, yeah. I did something really stupid. I was trying to change my password on my test forum and well, long story short I'm now locked out of my own forum :\ I can't register a new account and make them admin because my forums are turned off. When I try and get my password reset thing sent to me I can't see the CAPTCHA image (apparently because my forums are turned off). Is there any way I can reset my password via phpMyAdmin? Or at least a way to turn them back on? Thanks

--------------- Added 1250211502 at 1250211502 ---------------

Ok, so I got them turned back on but I can't register a new account or send myself a password reset email because captcha isn't working for some reason.. I also tried copying my password from my fully functional (not test) forum (from phpMyAdmin) and pasting it as this account's password but it still isn't working.

[Jinovich]

Run this query on your DB. It should disable the human verification.

UPDATE `setting` SET `value` = '0' WHERE `setting`.`varname` = 'hv_type' LIMIT 1 ;

[HayleyP]

I did that and image verification is still there..

[Winterworks]

Pretty sure there's an option in phpMyAdmin to enable registration again, or something. Take a quick peek for it. I'll try to look too.

[Lynne]

I replied to your thread over on vb.com about registering a new user and using tools.php to promote that user to an admin. Then reset your admin password.

[HayleyP]

Registration is enabled. I can't register, though because my image verification isn't working properly for some reason so it won't let me.

[Lynne]

When you tried to disable image verification per post 2, did you get an error? If you use a prefix, then you need to add your prefix to the beginning of the table name.

[HayleyP]

No, I didn't get an error.

[Lynne]

Do you have access to phpMyAdmin to check the setting manually? And did you do a Force Refresh on the registration page after you turned it off?

[HayleyP]

I do. Whereabouts is image verification in the db? And what should it be in order for it to be off?

[Lynne]

Post 2 has that info.

table - setting
varname = hv_type
value = 0

[HayleyP]

Yeah I checked and it's set to 0. Sigh.. haha

[Lynne]

And you still see the images when you try to register? Do you have any modifications? Perhaps we should turn those off. Disable them from your config.php file:
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

define('DISABLE_HOOKS', true);

[Senti.Jatt]

why don't you try to manually add a user in phpmyadmin and then run tools.php to get back administrator access??

[HayleyP]

Done that. Still not working.

[Dismounted]

Find an MD5 hashing utility (there are probably ones that work online).
Hash a temporary password.
Look in the user table. Note down the "salt" field next to your name.
Take the output of step 2 and add the "salt" onto the end of it.
Put this assortment of characters into the MD5 utility again, and hash it.
Place the output of this into the "password" field.
Login to your forum and change your password.

[HayleyP]

THANK YOU. That worked perfectly.