I get an error when trying to open itemshop.php

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

mysql error number: 1054

And also an error when i try to open heal.php

Invalid SQL: SELECT items_user.bankval, userfield.field5 FROM items_user, userfield WHERE items_user.userid='1' AND userfield.userid='1'
mysql error: Unknown column 'userfield.field5' in 'field list'

mysql error number: 1054

I installed both rpg and items.
And also it shows i am in battle and that battle does not exist, how i can delete that.

vb ver 2.2.8
hack ver.56

Are you on a free/shared server? Did you try re-uploading battlefight.php? The cause of that error is the user item loop. I have never had that error on my forums, but a temporary fix is to do the following (I think):

In battlefight.php, find twice:
and BELOW it, add:
There are two places you need to do this. They should be right after one another and should look very similar.

Let me know if that helps.

Something did not go right when you ran install_itemshop_items.php. Either that, or you have not properly filled in the point field name in the "Edit Itemshop Options" menu in the admin cp. To figure out what went wrong, in the admin cp go to the modify user profile fields screen and check for a field called Points. If there is not a field called points, then create a new one called "points" and make it hidden to the user, not required, and not editable. After adding it, use the following instructions to get it working:
If there is already a field called Points, then use the above instructions to get it working. If none of this works, then let me know.

Could you explain a little more about the battle problem?

Oka that fixed the itemshop and heal problem.

Me and my friend decided to battle and when we were on the battle I was going first and i did not have anything so i had to attack with my bare fists and when i clicked attack an error showed up so i reinstalled the hack about 3 times after that and it still shows that im in battle.
I even deleted the battle entries from the sql databas and its still the same =/

You battle status is based on a field in the `user` table called 'inbattle'. To participate in battles again, change it's value back to 0. You can do this in phpmyadmin by going to the `user` table, browsing till you find your name and your opponents name, and changing the 'inbattle' field to 0.

Oka that fixed the battle prob but there is one more in the moderator.php
Warning: SAFE MODE Restriction in effect. The script whose uid is 48 is not allowed to access ./global.php owned by uid 10018 in /usr/local/psa/home/vhosts/ffrealms.net/httpdocs/moderator.php on line 14

I am not too sure about that error. It might have something to do with your hosts settings. I also notcied that you just installed this hack or another version of it on top of a previous version of it. You have duplicates in you itemshop and your postbit item loop is timing out, indicated by the "Timeout 200" message in the postbits. You would be better off removing the hack and re-applying it on a TEST board, since a test board is easy to delete and re-install.

how do i un-install v .55?

Umm...install it in reverse?

Seriously though, you have several options:

1. If you want to upgrade to the new version, then get Beyond Compare 2 from www.scootersoftware.com. Then, open up the two install files side-by-side (the ones ending with .hack from version 0.55 and 0.56) and make the necessary changes based on the differences in the two files.

2. If you want to uninstall and re-apply, then replace all of your hacked files with the backup files you were supposed to make when you installed the hack the first time. Then, go in to your database and remove tables that begin with "battle", "items", or "rpg". Next, remove any profile fields you (or the hack) added. Next, delete all templates in your template table that begin with "battle", "itemshop", or "rpg_". Last, remove the added fields from the template "modifyprofile" that were added by the hack. You should then be set to re-apply the hack!

Easy as that!

It's not that easy....How are we supposed to tell what files we need to edit? And there's soooo many edits? There is no update file? WHY??!!!