Resetting RPG users SQL error

[carpy]

This is mainly for Yoherz or anyone who has their own forum with this RPG hack installed. You guys are my last hope for fixing my own RPG. I've searched and searched for hours now on vbulletin.org and have come up empty. The author doesn't provide support now so I hope someone here knows something.

When I use the admincp to try to Reset All the RPG Users, I get a database error

Invalid SQL:

			UPDATE `rpg_user`
			SET
				`wins` = '0', `losses` = '0', `draws` = '0', `retreats` = '0',`xp` = '0'`alignmentid` = '1', `classid` = '1', `genderid` = '1', `raceid` = '1', `typeid` = '1';

MySQL Error  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'alignmentid` = '1', `classid` = '1', `genderid` = '1', `raceid` = '1', `typeid` ' at line 3

Its coming from rpg_maintenance.php

I completely uninstalled/reinstalled the mod including deleting the tables manually from the database. This redid everything EXCEPT all the users show up as "N/A" now and when they reset and recreate a new character, the same Null stats show up.

Is there a code modification or update I missed? By the way I have RPG v3.5.1 Update 2

[Yoherz]

I'm really not a coder. I have no clue.....
My only suggestion would be to uninstall it. Like completely wipe every last bit of data of the RPG there is. Then install the newest version. I think its v3.6.1 or something. Pacman is really the only one of us admin that knows coding.

[carpy]

The funny part is. His uninstall.php doesn't actually do anything. All the tables it says it removed, are still there. So I guess I"m gonna have to find a way to search through the entire database for anything that says "rpg".

[Tidus Blade]

umm i dunno if this helps but sometimes when I get errors I delete everything from my cache and temporary files or private data or restart the browser and then stuff are working again...

[Yoherz]

That's a good point, Tidus. It shouldn't be too hard to delete the RPG and then delete the cookies and private data and such. After that, just reinstall the RPG and it should be fine.

[carpy]

Well its not working. I'm deleting everything the installer puts in, but when its reinstalled, I go to Seach Characters, there's 261 "N/A"s right after I do a fresh install even after overwriting all the files in the ftp. So that is somehow still tagging each user. Its gotta be hidden in a table somewhere but I can't find it.

I've been at this for 9 hours now. I wish the freakin author of the hack would've written the Reset code correctly.

[Tidus Blade]

did you PM pacman?

[Yoherz]

That's probably not a good idea. Just wait until he see's this. I'm sure Pacman will be able to help you. He knows like 5 different coding programs, if not more.

Anywho. Yes, it should show them all as N/A since you deleted all of the member's characters. Once you make a new character, then it'll change. My guess is that once it doesn't show anything RPG related whatsoever on the members, then it's all deleted. Otherwise, just keep deleting RPG things until that happens.

[Pacman]

There is a Syntax error in the code you gave, a "," is missing here.

`xp` = '0'`alignmentid` = '1'

it should look like this:

UPDATE `rpg_user`
			SET
				`wins` = '0', `losses` = '0', `draws` = '0', `retreats` = '0',`xp` = '0',`alignmentid` = '1', `classid` = '1', `genderid` = '1', `raceid` = '1', `typeid` = '1';

That is why it says this:

for the right syntax to use near 'alignmentid` = '1', `classid` = '1', `genderid` = '1', `raceid` = '1', `typeid` '

If you notice it only starts saying alignmentid... so starting here is gets the error...

I suggest you open the file and JUST ADD the ",".
If you not sure where to look, let me know... and I'll tell you... just put the code here...

I usually always come here see threads, but you can PM me, to look at the problem faster...

[Yoherz]

Good old coder.....I mean Pacman.
I knew he would be able to fix it.