Thanks alot for answering my questions! There are some problems that persist though... I am not able to Mass XP the users anymore. Moderators and Admins have very low XP, trying to re-set the values doesn`t have any effect. Trying to update the RPG user tables only returns information that Admin user was updated, no-one else... Ah well, I`ll fool around a little more and see if I get any wiser.
Here is the latest error message, when trying to re-install the mod:
Code:
Database error in vBulletin 3.5.4:
Invalid SQL:
ALTER TABLE `vb_administrator`
ADD `rpgadminperms` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0';
MySQL Error : Duplicate column name 'rpgadminperms'
Error Number : 1060
Date : Monday, May 29th 2006 @ 07:33:08 PM
Edit: Okay, I found out that I needed to edit my config.php file and allow myself to run SQL queries from the Admin CP. Using commands like "ALTER TABLE vb_administrator DROP rpgadminperms" on similar syntas for vb_user rpg, items, inventory and vb_usergroup drop rpgpermissions... But, I still don?t understand the last error message I get, which is the part where it`s trying to feed info the rpg_alignments, rpg_battlemusic etc. tables...
Now I have deleted all the vb_rpg_* tables using the "DROP TABLE vb_rpg_alignments" and so on - but the install script still stops and says there is a duplicate key entry or whatever... Which I don`t understand, cuz I have deleted all the tables, and they should have been reconstructed in empty form... Please help!