[Bitsys]

corsacrazy:
Did you read https://vborg.vbsupport.ru/showthrea...672#post328672 yet?

Originally posted by assassingod
Installed on 2.2.9, testing battle out now. Receive this error when trying to delete recently added 'type'

[sql]
Invalid SQL: UPDATE user SET rpgtype='0',rpgclass='0' WHERE type='4'
mysql error: Unknown column 'type' in 'where clause'

mysql error number: 1054[/sql]

Fixed. There are two ways of correcting it. You can download the corrected "rpgadmin.php" file attached to this post and re-upload it to your admin directory, or you can do the following:

In rpgadmin.php, find:

PHP Code:

// ###################### deletetype ####################### 


Below that (6 lines), find:

PHP Code:

$DB_site->query("UPDATE user SET rpgtype='0',rpgclass='0' WHERE type='$typeid'"); 


And replace it with:

PHP Code:

$DB_site->query("UPDATE user SET rpgtype='0',rpgclass='0' WHERE rpgtype='$typeid'"); 


Thanks for finding that one . I am surprised someone didn't find it sooner.

Here is the updated file: