hyperdave

oepn admin/user.php

find:

replace with:

see if that fixes your problem :)

g-force2k2

nope it still the same error, I dunno,

now when I pull up
/forums/intemshop.php , I get this eror

Database error in vBulletin 2.2.6:

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

mysql error number: 1054

Date: Friday 05th of July 2002 06:15:52 PM

and then /admin/user.php gives me this error

Database error in vBulletin Control Panel 2.2.6:

Invalid SQL: SELECT user.*,FROM_UNIXTIME(joindate) AS joindate,FROM_UNIXTIME(lastvisit) AS lastvisit,FROM_UNIXTIME(lastactivity) AS lastactivity,FROM_UNIXTIME(lastpost) AS lastpost,FROM_UNIXTIME(awaydate) AS awaydate
avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar
FROM user
LEFT JOIN avatar ON avatar.avatarid=user.avatarid
LEFT JOIN customavatar ON customavatar.userid=user.userid
WHERE user.userid=1
mysql error: You have an error in your SQL syntax near 'avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar
' at line 2

mysql error number: 1064

Date: Friday 05th of July 2002 06:19:01 PM
Referer: http://sub.domain.com/admin/index.php?


I dunno

well the points field is either fuxored or off ;\ and the try and just replace the admin/user.php with the backup of it and see if the shop is still functional...

g-force2k2

The items will not show in the posbit.

I installed it on my testboard without a problem, but it's really not what I was looking for. I would like it 100% if:

You could have an option to post each item, like say I bought a wep, an armor and an item. In the postbit, I could put this:

Weapon: $post[weapon]
Armor: $postst[armor]

It seems that no one has any feasable solution to the problem so many of us are having. What frustrates me is when people make hacks, dont think em through properly and just release him, and obviously the Itemshop 5 has been a problematic release. Perhaps some more testing wouldnt have harmed anyone? And if anyone know how to fix this problem, im sure alot of us would be gratefull.
In the Postbit where you place
Why wont it work?

Take out the space...

Satan

in my forums there is no space.
And i tested the placing a space thing, it actually brigns up something
"Array [items]"

Find out the problem

At first it seemed like a miracle, but heres what i done step by step to get the images to show.

Step 1:
Start up the install script again and first REMOVE the templates and tables using the script.

Step 2:
Go through the script again and let it set up the tables etc

Step 3:
Skip the file alterations

Step 4:
Go to your itemshop and direct it to the proper user field
(I installed the SHinra Hack because it provides better moderation functions. But even if youve got this installed you must do the same)
[To find out what field is what simply go to the Modify area of the user profile fields and then hover your mouse over edit. The last number of the line is the field number.]

Step 5:
Simply go into your item shop and then buy some stuff, and watch it appear in the post bit.
[Note, Custom items should appear too!]

mods can you please move this post to the Itemshop 5 area pwease
sowwy

Custom Items Bug
The above by myself shows how to do it. However, ive found if you delete ANY of the categories then create a new one in place of em, the items DO NOT show up. So what to do is simply delete all the items in each category, and then replace them with your own custom items. Then if you require any more categories you can add em on, but you cannot delete any of the orginial four, it mucks it up.

heh, my problem kicked my admin cp's arse x_X

when i go to edit templates, any template that has not been modified from it's original it just says "[Change Original]" and no titles for any of them... when I click on that for any line, it opens up a blank template... I am screwed. Not too mention interest on the bank does not work at all.

VERY nice looking hack, but it's not worth it cos uninstalling is gonna be ten times worse than installation was...