Bytsis, I did a full RPG reset (I put YES to EVERYTHING) and it did not clear the battle_stats table (I tried twice, both times the data was not erased/dropped).

On a side note: can anyone tell me how to credit users battle arena money for reffering people? I know that with the Store hack (by Lesane) you can set the ammount to give to your users, but since I am a newbie to PHP I am not sure what to do to make it also give you battle arena currency when you reffer someone.

bitsys,

for now just the word from gil to gold

then later the system you and I talked about... the above would be quick fix I hope ;)

Found Error,

When I setup a dual with someone and attack... I hit the attack button and it says the following..

Invalid SQL: SELECT field6 FROM userfield WHERE userid='13'
mysql error: Unknown column 'field6' in 'field list'

The data is not supposed to be dropped, it is only supposed to be reset. By reset, I mean that the fields should be set to 0 (all except the userid field). Did your members' battle stats get reset to 0-0-0-0? Or did they retain their old battle records?

To verify that the table has been reset, you can run this query
and compare the data in the table after running the query with the data in the table before running the query.

Hmm, I would assume you could do a mass template esit in the admin cp. Replace "gil" with "gold", right? I guess I could go make a list and location of each place where the word "gil" is used, but that seems like too much work for such a simple problem. Have you tried anything yet to switch it?

1. Go to your admin panel
2. Go to modify user profile fields
3. Find the RPG Name profile field
4. Right click over the edit link and go to copy shortcut
6. Copy it in your browser
7. Near the end there will be a number. Remember that number
8. Go to edit the battle options
9. In the top option put in field# and replace number with the number you recorded in step 7.

Let me know if that helps.

It doesnt reset it. It said it did, but I checked and the data was still there. So I dropped that table, created it again, ran install_itemshop_items.php and run the DB Fix and I got it all working.

Uhm i have a problem
See at the attachement
When i will fight my opponent have o Points everywhere
but see self

Run DB Fix and tell me what it says.

seems the hack can't parse names with ' in them,

What file is that from?

EDIT: Nvm, I found it in battle.php. See the first post for an updated .zip file with the fixed battle.php.

ok thanks :)

Any chance of a random event type thing like on neopets? For example.. You can configure events so they have a 1/900 chance of happening. For example.. you could create an event that was like.. "You trip over a tree root and hit the ground with a thud, -5 hp!" Or "You notice a dagger stuck in the tree to the right of you, You pull it out after some struggling, You gained Rusty Dagger!"

Also jobs... Mabye the admin could specify a job.. lets say mining. You could click on the Gold miner job. It brought you to a page with a work symbol on it that you have to click once every ten seconds.. then after 100 clicks a specified action happens.. and random events could be hooked in there too.

Like? :D