i have a little prob, the hack installed allright and everything is working apart from 2things, in the vbulletin control panel theres the same stuff but doubled and you cant choose your class, and in i also have a problem in a showthread.php, when its not edited my board works fine, but when i edit it when i go into a post the author+text dont show. Any ideas?

See https://vborg.vbsupport.ru/showthrea...093#post423093

After fixing the template, let me know if it still doesn't let you choose your class.

Send me your showthread.php (the edited one) and I will make sure all of the edits were done properly.

Oh no!!!! we were just about to have a tournament when a MYSQL error sprung up! you get it when you are challenged and you click "Here" to go into your battle! It says somthing about "Field5" anything?

Here is the error

Database error in vBulletin 2.3.0:

Invalid SQL: SELECT items_user.item5,items_user.itid5,items.type FROM items_user
LEFT JOIN items ON items.itemid=items_user.itid5
WHERE userid='1'
mysql error: Unknown column 'items_user.item5' in 'field list'

mysql error number: 1054

Date: Sunday 31st of August 2003 01:05:03 AM
Script: http://www.crossingcentral.com/forum...ttlenumber=201
Referer: http://www.crossingcentral.com/forum...battlekey=none
Repair Report: This type of error cannot be automatically repaired.

Okay, i just checked the Items_User thing in the Mysqladmin

and it goes from
Userid
all the way to
Itid3

Am i missing the ones all the way up to 5? and what SQL Query would i use to solve it?
Oh and i think the reason for this is because we turned off the battle system for 15 minutes? not sure though

this error has been addressed before it's easy to fix ..

got your admin cp, go to "User Profile Fields"

look for
Points No Yes No 250 25 [edit] [remove]

run mouse over edit, make a note of what field number it says, default is field 5 normally.

goto your Itemshop section, Edit Options,

read where it says, Point Field

change the field info to the id that you saw when you hovered your mouse over the "Points No Yes No 250 25 [edit] [remove]" edit button.

you might have it like field6 or something so you would just change it to that, and your error will be fixed ;)

hope that helps :)

I wonder... would it be possible for users to set up their own characters? Perhaps each user automatically gets about 20 to 25 spending points for the statistics (reg att, reg def, mag att, mag def, speed, and evade), with each stat having a limit of 6 or 7 points each. I thought it through myself, but I'm not exactly sure how to set up an error page when a user tries to spend more points than the set number.

Also, has anyone else had a problem inactive battles not expiring after 24 hours?

PixelFX they are both 5 but the url just says the number "5" and the itemshop options say "Field5" dhould i make the itemshop options say just plain "5"

Go to the Edit Items menu in the admin cp. Find the item category that has an ID of 5. Is it a personal itemshop? Also, what is the name of the category and how was it added?

That would be a little hard to implement in the current system, since those stats are generated on the fly and aren't stored in the database anywhere.

Inactive battles aren't supposed to automatically expire. They will only be removed when you run the Pruning script and they have been inactive for the specified amount of time.

Upgraded to v 0.68 and I get 'Invalid battle or password ' when trying to enter a battle..