PDA

View Full Version : The Itemshop v5 (Original)


Pages : [1] 2

Vivi Ornitier
04-29-2002, 10:00 PM
Again, I'm posting this for a friend. He is the original itemshop creator. (see this thread (https://vborg.vbsupport.ru/showthread.php?s=&threadid=35156)):

Let's start with the beginning. You may wonder why this thread has the word original in its name. Well, there are too many itemshops out there. So here's a short version of the itemshop history:

First of all, afterlab had the idea of an itemshop, which he also did, but it was pure text. People would have to talk to him to buy items, and he would have to manually substract the points.
Then, as a member of ffr, i started talking about how easy and convenient it would be to have an automated itemshop. People just click on the link, and the item is added, points substracted. Later that day, i did the very first version of the itemshop. Nothing big, just a buy function. The items were stored in an array.
I had released my itemshop on vb.org and afterlab was pretty unsatisfied that i hadn't given him any credit for the original idea. Actually i didn't even consider the itemshop a hack, it was more of a joke, something i had made for fun. I had no idea it would become so popular.
2 days later, version 4: This one had error pages, improved buy and sell function. I was planning a database powered itemshop, with admin cp interface.
afterlab then pretty much copied my code 3 times, and released his first version "with item categories". It felt pretty unfair, while i was struggling to do something way more advanced, he was getting all the credit for something that was still 85% mine.
then my computer broke, just as I was working on the admin cp of my database version. I was also planning to do the battle system hack.
in the meantime, about one week later, afterlab released his itemshop 3 i think, database powered.
couple of weeks later afterlab started all the battle system stuff.
about 2 months after my computer crashed, it got finally fixed, and i began to work to complete my own itemshop.
So well, here it is.

nice story, isn't it? ;)

here's a quick list of features:

Database driven
Full Template Set (everything that is outputted is generted through templates)
Infinite items categories and items
Items and category descriptions
Stock (idea by Crono)
Detailed items/categories/shops stats (number of sold items, profit)
All the item and category adding/editing/deleting and option editing is done through the cp.
Special icon column for different item display possibilities
!!!! Personal Shops !!! (members can create their own shops and sell items. You can specify how much it costs through the cp. while each category has it's own slot, all the personal shops work under one slot. That means, you can only have one item from all the personal shops)
An own donation system included

what it adds:

The itemshop adds 4 tables to the vbulletin database:

[items] - This is where all the items are stored
[items_cats] - This is where all the categories are stored
[items_options] - This is where the configuration data is stored
[items_user] - This is where all the user stuff and items he bought, are stored


26 templates to the main template set:

itemshop
itemshop_buypers
itemshop_delpers
itemshop_donate
itemshop_donate-error
itemshop_donate-more
itemshop_donate-self
itemshop_donate-thanks
itemshop_error-nosell
itemshop_error-noshop
itemshop_info
itemshop_its
itemshop_itsbits
itemshop_own
itemshop_pers
itemshop_persform
itemshop_personal
itemshop_pheader
itemshop_redir-del
itemshop_redir-edit
itemshop_redir-sell
itemshop_redir-thanks
itemshop_tablebottom
itemshop_tablemiddle
itemshop_tabletop
itemshop_view

Like i said, anything there is to edit can be edited through templates

File and Template Modifications:
there are 4 file modifications, but only one of them is neccessary.
and one template modification: postbit, wherever you want the donation link to be.
important!!!!: remember to change your points field and remove any old itemshop templates!!!

Installation method
First of all, be sure to back up your database!! This is a fairly large hack. Adds a lot of stuff to the database.

the installation is done through the install script install_itemshop.php. It will guide you through 5 easy steps.
the only manual edits you'll have to do are the ones above, file and template edits.

Included Files

readme.htm - general information
root/itemshop.php - main itemshop file
admin/itemadmin.php - itemshop admin interface
admin/install_itemshop.php - itemshop installation file
images/itemshop - itemshop image file. This is where you will have to upload all coresponding graphics.

Contact Information
mail: gheghe@rnc.ro
aim: MewtwoAlx

If you wish to colaborate with me in continuing this hack or to add item descriptions for further versions please contact me.
This hack can easily be used not only for rpg boards.. As an example: you add computer categories: cpu, hdd, monitor etc, replace points with $ and let people on your forum build themselves a computer!


I've already got a list of stuff i gotta update in the next version, but if there's any request feel free to ask.
The shop is 100% functional, but i want to improve stuff, make it more efficient.

[And please, before releasing any new mod/edit/version to this hack ask for permission] - If you agree to that condition you are allowed to freely use and distribute the zip below, as long asthe copyright and author information remains intact.
By not agreeing, you are not allowed to use this hack, nor will you get any support.
- Thank you! That was just to prevent my hours hard work on the itemshop to be stolen

Whoa, that was a lot of typing! I hope you like it! Attached file below.


screenshots attached:
https://vborg.vbsupport.ru/showthread.php?postid=246268#post246268

https://vborg.vbsupport.ru/showthread.php?postid=246277#post246277


*** update
all bugs reported by Kaelon are fixed.
i've also added some extra stuff:
ascending or descending order
postbit edit: well, for the postbit, i couldn't just put the imgs, cause all the items of the same type have the same image. so i put the image and a link to a separate item info page.
1 new template required for the item info page.
added remove feature in installation script. ( note: it will simply drop the tables and remove the templates).
75% faster!!! and less stress on your server
***

***
new update: bank hack integrated!!!
***

***

Dark Odin
04-30-2002, 09:05 PM
Screenshots?

afterlab
04-30-2002, 09:05 PM
LOL.. Well nonetheless, it's better then your last one.

Vivi Ornitier
04-30-2002, 09:08 PM
no need for screenshots. pretty much looks like all the other itemshops. Just better. way better.

:knockedout: lol??? aww well, i'm getting better at coding.

Dark Odin
04-30-2002, 09:11 PM
I wanna see how way better. :)

afterlab
04-30-2002, 09:12 PM
Thanks for the itemshop history you added into the hack readme. I wish good luck to anyone who attempts to install this.

Vivi Ornitier
04-30-2002, 09:25 PM
lol... reading that history thing, it is pretty funny. I sound like an 8 year old. :)

but no need to be sarcastic about installing it. Belive me, it does work.

screenshots part1

snyx
04-30-2002, 09:33 PM
sorry, but I just don't understand this hack?! its a itemshop where you buy stuff? okay... well whats the point? how do you tell if a user has bought something? how to you make currency to buy these items? sorry but im just a little behind :D

Vivi Ornitier
04-30-2002, 09:40 PM
Originally posted by snyx
sorry, but I just don't understand this hack?! its a itemshop where you buy stuff? okay... well whats the point? how do you tell if a user has bought something? how to you make currency to buy these items? sorry but im just a little behind :D

well, the items are displayed in the postbit template (which i forgot to do, btw. i'll have it done tomorrow. it's too late now). You make money by posting. The amount of money that is added is also specified in the cp.
It's pretty fun. All the rpg boads want thiskind of stuff.
And not only rpg boards. take my example above. make a couple of categories > computer components. then change the points to dolars. member will be able to buy their own computer, piece by piece.


Originally posted by xiphoid
You do sound like a 8 year old in that little story, but I understand why you wrote it. Thank you for explaining, and I am considering this one for installation.

I am doubting on a few things though:

First you say: This is easy 5 steps, ..
Then I read: only files & templates have to be done manually.
err?

First I read: No need for screenshots, nothing has changed.
Then I read: but it looks better, way better!
err? Isn't it worth a screenshot or 2 in action then? Or a site where we can browse through as a guest (or test account)?

You talk about a battle thingy, is it included in this release? And if not, can we expect it soon? And what are possible other features you are currently working on?

Has this been tested on several boards, and which versions if I may ask?

- not trying to sound harsh here, just have questions! -

well, the installer adds the tables and templates. but you have to do the file edits.

the looks haven't changed very much, just the script itself.
it has been tested on 3 boards, and it should work on all vb versions.


screenshots part2

Floris
04-30-2002, 09:42 PM
You do sound like a 8 year old in that little story, but I understand why you wrote it. Thank you for explaining, and I am considering this one for installation.

I am doubting on a few things though:

First you say: This is easy 5 steps, ..
Then I read: only files & templates have to be done manually.
err?

First I read: No need for screenshots, nothing has changed.
Then I read: but it looks better, way better!
err? Isn't it worth a screenshot or 2 in action then? Or a site where we can browse through as a guest (or test account)?

You talk about a battle thingy, is it included in this release? And if not, can we expect it soon? And what are possible other features you are currently working on?

Has this been tested on several boards, and which versions if I may ask?

- not trying to sound harsh here, just have questions! -

JulianD
04-30-2002, 09:56 PM
It seems very impressive! I'm gonna try to install it later... Thanks!

Webmasta XT
04-30-2002, 10:00 PM
This is amazing.. Way Better than all the other ItemShops.. :)

Floris
04-30-2002, 10:05 PM
I just installed apache, mysql, php on my localhost, and then installed vbulletin 2.2.5 clean from the .zip file, then i run your installation script and did the manual file changes.
I couldn't do the template changes,
because all the templates were removed and I had MANY [change original] links, with empty content, and not title in front of it.
The site doesn't work anymore now.

NTLDR
04-30-2002, 10:17 PM
Looks very good, I may try intstalling this one :D Is this the same as the one used on your board?

Vivi Ornitier
04-30-2002, 10:18 PM
Originally posted by xiphoid
I just installed apache, mysql, php on my localhost, and then installed vbulletin 2.2.5 clean from the .zip file, then i run your installation script and did the manual file changes.
I couldn't do the template changes,
because all the templates were removed and I had MANY [change original] links, with empty content, and not title in front of it.
The site doesn't work anymore now.


hmmm..... i just tried a clean 225 install and it worked fine.
I got the template installation function from bane's installer. so if vbstats and any other similar hack works, so should this.
i have tested it over and over and install script worked fine for me.

AnkisethGallant
04-30-2002, 10:37 PM
This is boss, but what can I use this for if I'm not getting a battle system? I REALLY want this, but I can't find a use. Any suggestions? My site is music oriented.

Neo
04-30-2002, 10:46 PM
Good Job Vivi :)

Nice of you to put this images in aswell for people.

Ruth
05-01-2002, 12:35 AM
nice work Vivi,

may i suggest to you, to combine this with secure downloads script (http://www.shackrats-hideout.com/sdownload/index.php?catid=48) , so users can download files using their points, and upload files and get points.

cheers, :)

AnkisethGallant
05-01-2002, 01:10 AM
HELP! It's not working. A few things:
What is the thing about the field for for the money?
When I clicked donate, it had an error.
Some help here? What is the code to put the money on the post bit? How do I change the name of the points?

EDIT: Also, I'm guessing I have to add the link to the main page for it?

hypedave
05-01-2002, 01:13 AM
Originally posted by Ruth
nice work Vivi,

may i suggest to you, to combine this with secure downloads script (http://www.shackrats-hideout.com/sdownload/index.php?catid=48) , so users can download files using their points, and upload files and get points.

cheers, :)


very good suggestion

DFX
05-01-2002, 01:20 AM
Are there any battle hacks that work with this, and recognize the weapons and armor and go by their actual attack and defensive properties?

AnkisethGallant
05-01-2002, 01:21 AM
------------------------------
Warning: Variable passed to each() is not an array or object in /home/virtual/site8/fst/var/www/html/boards/admin/itemadmin.php on line 147

Items updated!
-------------------------

-------------------------
Database error in vBulletin 2.2.5:

Invalid SQL: SELECT item1,points1,description1,icon1 FROM items_user WHERE userid=1
mysql error: Unknown column 'item1' in 'field list'

mysql error number: 1054

Date: Tuesday 30th of April 2002 09:24:31 PM
Script: http://www.punkmusicrocks.com/boards/boards/itemshop.php?action=main
Referer: http://www.punkmusicrocks.com/boards/index.php?
---------------------------------

What about those two things?

It also won't let me edit items.

Velocd
05-01-2002, 01:34 AM
Damnit, just when I thought it was gone and I would be few out of those who still had the original. But now this is released...:(

J/k. But I did work so hard to integrate the previous one, adding buy buttons and other things. But hey, you added a stock feature, thats pretty sweet. I may have to wait till the weekend to install this one.

* Velocd hits install button

AnkisethGallant
05-01-2002, 02:07 AM
Why isn't anyone helping?!?!?

Velocd
05-01-2002, 03:09 AM
/me shrugs
/me points at Vivi

AnkisethGallant
05-01-2002, 03:19 AM
It's ALL fixed now.

Is there a way to control the stock of a specific item?
Also, personal shops can create their own items, shouldn't they sell what's in the inventory, and what they've already bought?
And, Is it possible to allow a user to carry a bigger number of a category than just one item?

BigJohnson
05-01-2002, 03:35 AM
very nice hack and are u still working on the battle hack and will you incorporate it with this hack so you can use weapons etc...

Kaelon
05-01-2002, 03:38 AM
Very nice hack, Vivi. I set up a private test forum - a fresh, clean install of 2.2.5, and mostly everything looks like it is functioning properly on the admin backend. I run into the first error at the "Donate" function. It looks like your hack doesn't escape apostrophe's appropriately. There are also some other bugs that I have itemized below for your reference.

1. No Apostrophe Escape


Database error in vBulletin 2.2.5:

Invalid SQL: UPDATE items SET stock='5' WHERE name='Cat's Claws'
mysql error: You have an error in your SQL syntax near 's Claws'' at line 1

mysql error number: 1064

-- snip --

Referer:

I fixed the above problem by simply removing any problem items that used apostrophes ('). We also get the same errors when you try to add any Item whose name OR description have either an apostrophe or a quote (").

2. Donate Error

Your donate URL, as you specified it in postbits, is incorrect. The correct URL, whether or not you use JavaScript, should be as follows:

<a href="itemshop.php?action=donate&user=$post[userid]">Donate</a>

Previously, you didn't have the $post[userid] variable, and instead just referenced [userid]. Changing this fixed it for me.

3. Sold Item Graphic Remains

When you sell an item, the graphic for the previous (sold) item remains even though you have no item listed in the appropriate slot. When you purchase a new item, fortunately, the new item graphic icon replaces the old item graphic. This can be fixed if you clear out the value for your categorical icon in use.

I'll continue testing and let you know if I run into anything else.

Juan

Kaelon
05-01-2002, 04:53 AM
Basically, aside from that above, this hack is working very nicely. I must hand it to you, Vivi - a job very well done. I think I can figure out the postbit code to show items purchased by the player by simply looking at the other templates, but I look forward to seeing how you do it.

Juan/Kaelon

Edit: Actually, nope, the other templates didn't have any postbit examples I could stick in, so I'll wait for you to include your postbit. =)

Vivi Ornitier
05-01-2002, 06:36 AM
thank you for pointing that out Kaelon. I'll fix it all.
I'll also do the postbit today.

I'm sorry for not making it clear, but the shinra points hack is required. After installing the shop, you need to go to your admin cp, and under the itemshop section, Edit options. Make sure the correct point field is specified there. That's where you control stock: minimum stock, maximum stock and stock reset time.

itemshop are identified by the userid of their owner, so having multiple personal shops is impossible.

Erwin
05-01-2002, 07:02 AM
Your previous itemshop was quite simple and functional - I'm going to stick with it. :) Good job on this one, but I like the fact that I can use the stock custom userfields with the previous version - easy for me to build other hacks upon it. Keep up with the great hacks!

Kaelon
05-01-2002, 08:11 AM
Great! Thanks, Vivi!

Just let me know once you've got the postbit included, fixes added and where I can nab it.

Again, excellent hack. I particularly love the flexibility to add categories (in effect, shops). Congratulations.

Kaelon

FFMania
05-01-2002, 09:23 AM
I have problem here......

When I follow the instruction in editing both newreply.php and newthread.php.....the result is not really good.

Instead of what I have set (2 Points Per Reply and 5 points per new thread) it turns out to be 7 points per reply and 10 points per new thread.....I never modify anything....the itemshop script did it by itself? 0_o

And it also...stop the post counts from working.....for me at least...what should I do now?

And oh, I have the points hack, points addon, donate points and star hacks installed btw....so plz help me out...I am confused now ;) thx in advance :)

ceo_tfw
05-01-2002, 12:13 PM
great hack, I have installed it and I had a few errors but with a little editing with my php3 files now it is up and running great,

I must say that it drives your members to post more,, yeehaaa

Vivi Ornitier
05-01-2002, 12:17 PM
thanks Kaelon! :)

file updated.


FF Mania: you set the value in the admin cp.
the default value in the admin cp is 5.

you edited the file and added 2 and 5:
2+5=7
5+5=10

use the admin cp. ;)

AnkisethGallant
05-01-2002, 07:23 PM
So, if we get the points hack (which one?), we'll be able to change stock.

What about personal shops? Is there any way to control it, where users can only resell items they bought?

Also, is it possible to change it where you can buy more than one item in a category?

Vivi Ornitier
05-01-2002, 07:30 PM
Originally posted by AnkisethGallant
So, if we get the points hack (which one?), we'll be able to change stock.

What about personal shops? Is there any way to control it, where users can only resell items they bought?

Also, is it possible to change it where you can buy more than one item in a category?

the itemshop basically works without the shinra points system.
It only needs a custom user field for the points.

stock is controllable through the admin cp.

in the personal shops, people create their own items. they can't resell items. and right now, it's impossible to buy more items in one category


bank screenshot attached

AnkisethGallant
05-01-2002, 07:33 PM
Alright. If I knew how to hack, I'd work on that, adding the ability to resell.

How do I control stock in the CP, I don't see it anywhere.

Vivi Ornitier
05-01-2002, 07:42 PM
Edit Options part :rambo:

ender
05-01-2002, 07:45 PM
What's the bank screenshot? Is that something coming in a future version?

Also, in functions.php you use $bbuserinfo[userid], that will only check the user browsing the forum and consequently it will display all he owns on every post no matter what the user.

The correct function would be: $post[userid]

AnkisethGallant
05-01-2002, 07:47 PM
I know that controls overall stock, but I want to change the stock for each particular item, to make some items rarer than others.

ceo_tfw
05-01-2002, 07:57 PM
Here is what it looks like on my site, my members love it, they say a great addition

AnkisethGallant
05-01-2002, 08:02 PM
Looks pretty good, hilariously looking images for your items.

If anyone could help me, I'd praise you and plug your site at my forums. What I need is:
To fix personal shops to only resell their items.
To be able to buy multiple items in a category.

ender
05-01-2002, 08:10 PM
To fix the negative donation replace your ###Donate### section in itemshop.php with this. FYI, this also penalizes anyone who tries to enter a negative amount 10 points.

Replace the ### Donate ### section with this in itemshop.php.
// ###################### donate #######################

if($action==donate && isset($user)) {
if ($bbuserinfo['userid']==0) {
eval("dooutput(\"".gettemplate("error_notreg")."\");");
} else {
if($user == $bbuserinfo[userid]) {
eval("dooutput(\"".gettemplate("itemshop_donate-self")."\");");
exit;
} else {
if($points > 0) {
eval("dooutput(\"".gettemplate("itemshop_donate")."\");");
exit;
} else {
eval("dooutput(\"".gettemplate("itemshop_donate-error")."\");");
exit;
}
}
}
}
if (isset($iddonate)) {
if($amount < 1) {
eval("dooutput(\"".gettemplate("itemshop_donate-less")."\");");
$penalty = ($points - 10);
$DB_site->query("UPDATE userfield SET $pointfield='$penalty' WHERE userid=$bbuserinfo[userid]");
exit;
}
if($points >= $amount) {
$dpointss=$DB_site->query_first("SELECT $pointfield FROM userfield WHERE userid=$iddonate");
$dpoints = (int) $dpointss[$pointfield];
$donated = ($dpoints + $amount);
$substr = ($points - $amount);
$DB_site->query("UPDATE userfield SET $pointfield='$donated' WHERE userid=$iddonate");
$DB_site->query("UPDATE userfield SET $pointfield='$substr' WHERE userid=$bbuserinfo[userid]");
eval("dooutput(\"".gettemplate("itemshop_donate-thanks")."\");");
exit;
} else {
eval("dooutput(\"".gettemplate("itemshop_donate-more")."\");");
exit;
}
}

Make the template: itemshop_donate-less
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
$metarefresh
<title>$bbtitle - Itemshop</title>
$headinclude
</head>
<body>
<table border="0" cellpadding="0" cellspacing="0" width="100%" height="100%">
<tr>
<td valign="middle" align="center">
<smallfont>You are trying to donate a negative amount! Stealing is not allowed! You have been penalized $10.</smallfont></td>
</tr>
</table>

Vivi Ornitier
05-01-2002, 08:49 PM
the bank is already there. no future project. it's working.

heretic
05-01-2002, 09:53 PM
very nice...and you don't mind if I modify it, right ;)

ender
05-01-2002, 10:23 PM
Vivi, you need to update the installion script to delete the bank templates.

AnkisethGallant
05-01-2002, 10:55 PM
Sounds like it's all working good, but does anyone have any suggestions for my problems?

Is the bank useful, besides getting everyone richer?

Also, What changes do I have to do to go from Itemshop 5.0 to 5.2?

ender
05-01-2002, 11:17 PM
You just need to upload the new files.

Vivi: It's possible to permanently mess up the personal shop system. If you buy a personal shop, then delete that shop, then buy a personal shop again it will not work because the ids are auto_incremented. I'm not good at coding so it's a little hard for me to understand the layout of the system but my guess would be that the display mechanism is working on an increment method as well and when it sees: 1,2,3,5 it will only display 1,2,3 because it missed 4 and stopped prematurely.

My guess would be that if one person deletes their shop after a few people make stead it will stop displaying everyone.

Webmasta XT
05-01-2002, 11:25 PM
Vivi, One more thing, and nice hack, the thing is how can It display members Items on Postbit, like the old Itemshops??

AnkisethGallant
05-01-2002, 11:38 PM
Nice question, I meant to ask that Webmasta.

I might update to 5.2 then. That still doesn't help my previous questions, any ideas anyone?

geniuscrew
05-02-2002, 01:16 AM
I got an error :(

Invalid SQL: SELECT * FROM items WHERE cat= ORDER BY name
mysql error: You have an error in your SQL syntax near 'ORDER BY name ' at line 1

Can somebody help?

Thanx

Kaelon
05-02-2002, 01:25 AM
This sounds like a fairly serious problem.

Vivi: It's possible to permanently mess up the personal shop system. If you buy a personal shop, then delete that shop, then buy a personal shop again it will not work because the ids are auto_incremented. I'm not good at coding so it's a little hard for me to understand the layout of the system but my guess would be that the display mechanism is working on an increment method as well and when it sees: 1,2,3,5 it will only display 1,2,3 because it missed 4 and stopped prematurely.

My guess would be that if one person deletes their shop after a few people make stead it will stop displaying everyone.

Any way to fix it?

Kaelon

AnkisethGallant
05-02-2002, 01:29 AM
Geniuscrew, I'd double-check your tables, and make sure all your Items and categories are done correctly. I'm not real good at this, but that's my guess.

geniuscrew
05-02-2002, 01:31 AM
The error email says the referrer is itemshop.php - could it still be my fault ? 0:-)

thanx

AnkisethGallant
05-02-2002, 01:44 AM
I highly doubt it, but it's probably trying to call an errored table or template or item. I'd check what I said, if that doesn't work, yell at Vivi.

AnkisethGallant
05-02-2002, 02:45 AM
This thing was working good...
Database error in vBulletin 2.2.5:

Invalid SQL: SELECT field5 FROM user WHERE userid=
mysql error: You have an error in your SQL syntax near '' at line 1

mysql error number: 1064

Date: Wednesday 01st of May 2002 10:45:26 PM
Script: http://www.punkmusicrocks.com/boards/boards/itemshop.php
Referer:

What is up with that?

ALSO: Do I have to change any of the templates or anything if I DON'T use the points hack?

Velocd
05-02-2002, 03:37 AM
/me notices in a earlier post that FFrepublic mewtwo is Vivi *gasp*

Don't use the points hack??? How do you expect to buy items, remember it does not work with Lesanes integrated pointsystem and itemshop. You probably would have to modify some code to get it to work without points..but I can't imagine how you would buy items then..

ender
05-02-2002, 04:22 AM
FYI, I integrated this hack to work with the Store Hack by Lesane by finding all instances of userfield in itemshop.php and replacing it with user. Then in the admin panel change the field name to storep.

Velocd
05-02-2002, 04:37 AM
Interesting....(I think)

Question to Vivi: I still have the original itemshop hack of yours, is there anyway to safely remove or modify the original one with the new one without having to delete everyones items?

Vivi Ornitier
05-02-2002, 06:55 AM
To anser previous questions: THE PERSONAL SHOPS DO WORK. the category id is auto_increment, the ownerid isn't.

you can run it without the points installed, it just needs a custom user field.

Velocd: No, it is not possible to keep the earlier items.

BTW, the new script has a few bugs, but i'm leaving today, i'll be back on tuesday! Until then i'll remove the attachement in the first post.

Check back tuesday. :rambo:

Kaelon
05-02-2002, 09:07 AM
Awww, you removed it! :p Well, if you noticed bugs, it's probably better to do that =).

I look forward to seeing a fixed version when you next release it.

Kaelon

FFMania
05-02-2002, 09:25 AM
Need another help here ;)....what code should I include in postbit template in order to show the items and stuff which they have bought? >_<

geniuscrew
05-02-2002, 10:41 AM
Help Help

/me cries referring to earlier post *

That SQL statement, it looks like something to do with the variables in it (the one's that have the dollar sign before them) since those don't show in the error :-/

geniuscrew
05-02-2002, 02:05 PM
It's seems to be working on this computer for some reason - is it possible to show *all* the items you have in the post bit and also on the main itemshop page?

Thanx

geniuscrew
05-02-2002, 02:54 PM
Originally posted by FFMania
Need another help here ;)....what code should I include in postbit template in order to show the items and stuff which they have bought? >_<

IU'm sure it said $post[items] but it's not working for me either :-/ Oh well, until next Tuesday

Forgot to say that it's a brilliant hack, Vivi!

ender
05-02-2002, 05:24 PM
Yes, the personal shops will still work but if you delete and recreate it won't display. However, you can, of course, direct link, but that defeats the purpose.

AnkisethGallant
05-02-2002, 07:36 PM
Can anyone help me with what I was asking, about allowing users to buy multiple items from a category, and about making personal shops only resell items?

I'm still having the problem with:
Database error in vBulletin 2.2.5:

Invalid SQL: SELECT field5 FROM user WHERE userid=
mysql error: You have an error in your SQL syntax near '' at line 1

mysql error number: 1064

Date: Thursday 02nd of May 2002 05:40:31 PM
Script: http://www.punkmusicrocks.com/boards/boards/itemshop.php
Referer:

What's going on here? Why is it not working? Everything is in right.

AnkisethGallant
05-03-2002, 03:48 AM
Is there a way to take out restocking permanently?

AnkisethGallant
05-03-2002, 06:53 PM
Is there anyone here that can help me with that error? Anybody?

geniuscrew
05-03-2002, 07:43 PM
i'm not that good at PHP - mine started working after i tried it from a different PC.

is this your only custom field?

AnkisethGallant
05-03-2002, 08:24 PM
It's my second one, but I have it set as field5, because the points hack was already programmed for five, it was easier that way. I checked the store, it's pointed to field5.

geniuscrew
05-03-2002, 10:44 PM
i dunno to be honest - sorry :-/

Have you tried it from a different computer?

AnkisethGallant
05-03-2002, 11:25 PM
Yes, and it still has an error. I've tried re-installing itemshop.php, and I've reinstalled all the tables. I haven't touched the templates or anything either.

Velocd
05-04-2002, 02:31 AM
Here are some very good REQUESTS TO VIVI for the fixed-itemshop he plans to release on Tuesday:

Important:
1. Pleeeaaasssseee make it so itemshops are in their own page, like you had in the first itemshop. I was disappointed to see all the items on one long page, its not as appealing that way. Also when they do "loop" on the itemshop page, it also shows the header buttons over again.

2. User can choose an icon for their custom item in their personal item shop. Maybe a drop down list beside the item description field where they could select an icon.

3. Category specific personal-items, for example, if the default itemshop has 3 types of items (helmet, weapon, shield), then when a user creates their own shop the only items they can make are either helmets, weapons, shields. This way when someone buys an item from a personal shop, it won't create another field for the new item, it will simply place it in the original spot under that type.

4. How do you display items in the postbit? Like the previous itemshop, are they still located in a profile field? Because displaying the item in the postbit is muy importante.

Would be nice:
1. User can select a URL image for their personal item shop, that could be displayed on their itemshop page. (centered at top).

-----------------

The ones under important I think are crucial to have, as it gives it a wayyy more appealing style. Some of these you may have already decided to do or fix (if its a bug). I just hope you can integrate some of these in your upcoming version. :D

Neo
05-04-2002, 03:03 AM
Wow... well I am sure he has alot to do.. dont push him or he my not re-release it at all..

Velocd
05-04-2002, 06:07 AM
Yeah you're right about that, so I won't bother him anymore. I simply wanted to suggest a few things ^_^

AnkisethGallant
05-04-2002, 06:40 AM
While you're thinking about the Itemshop, why not think on how to solve my problem?!?!?!? I want to use this thing, but it's not working.

(the error is in a previous post of mine)

FFMania
05-04-2002, 06:44 AM
What Velocd suggested were the important stuff which everyone would love to use :D I hope Vivi is going to consider the points which were suggested by Velocd, and I forgot to say that this is a great hack! :D

AnkisethGallant
05-04-2002, 02:41 PM
I like his first suggestion, and the one about making users have to pick items in the same category. However, I think that users should only be able to resell items they have bought, because if users just get to make up items, that would kinda suck in my opinion.

Webmasta XT
05-04-2002, 07:50 PM
Originally posted by Webmasta XT
Vivi, One more thing, and nice hack, the thing is how can It display members Items on Postbit, like the old Itemshops??

Can ANyone Answere my question please? :dead:

AnkisethGallant
05-04-2002, 08:04 PM
I'd try and help you, but I can't even use my itemshop. I'd look for the code that lists them items on the itemshop screen, I don't know much about this sort of thing, so I have no idea.

Here's the error I'm getting in mine:
Database error in vBulletin 2.2.5:

Invalid SQL: SELECT field5 FROM user WHERE userid=
mysql error: You have an error in your SQL syntax near '' at line 1

mysql error number: 1064

Date: Thursday 02nd of May 2002 05:40:31 PM
Script: http://www.punkmusicrocks.com/board...ds/itemshop.php
Referer:
Any suggestions?

Velocd
05-04-2002, 08:45 PM
Originally posted by AnkisethGallant


However, I think that users should only be able to resell items they have bought, because if users just get to make up items, that would kinda suck in my opinion.

I think that would be an excellent idea also, because if the stock goes down in the regular itemshop of a certain item, you can sell that item (if you have it) for higher in your itemshop to make profit off of it. I was confused at the making of items when I first saw it, but maybe if it were possible to pay a high price, you could make your own item.

Originally posted by Webmasta XT


Can ANyone Answere my question please? :dead:

I suggested this and I'm sure Vivi already knows about the problem. In his next version you should be able to see items in the postbit (hopefully ;))

Originally posted by AnkisethGallant


Database error in vBulletin 2.2.5:

Invalid SQL: SELECT field5 FROM user WHERE userid=
mysql error: You have an error in your SQL syntax near '' at line 1

mysql error number: 1064

Date: Thursday 02nd of May 2002 05:40:31 PM
Script: http://www.punkmusicrocks.com/board...ds/itemshop.php
Referer:


#1. Make sure you don't have any of the custom fields used from the previous itemshop hack, if you installed it. This includes "weapon", "helmet", etc. I found this to be a problem with me when I tried to install the new itemshop, so I removed those fields.

#2. Field5 is your point field, correct?

And...get back to me if that doesn't fix it.

AnkisethGallant
05-04-2002, 08:48 PM
This is the only itemshop I have, so I've passed #1 with flying colors.
field5 is my point field, and I have it set to field5 in the items option.

Now I am getting back to you, because that doesn't fix it.

Velocd
05-05-2002, 12:31 AM
Uninstall the whole thing, and try again but more carefully. Thats the only advice I have for you, because I'm not too sure where the problem might be residing. Uninstall the tables and templates from phpmyadmin, then revert php file changes. Though I recommend you just wait till Vivi releases the updated version, since it may very well fix your problem. And if this next version requires a fresh installation, you will have to remove it anyway.

AnkisethGallant
05-05-2002, 12:33 AM
Alright, but right now I can't upload files to my server because of a problem.

Since Vivi made it to where the templates are made as original, how do you delete them?

Velocd
05-05-2002, 05:34 AM
Go into phpmyadmin, and you will have to delete them manually from there. (goto table: template, then click on browse, and then manually delete all templates with prefix itemshop.) I'm not very good with queries yet, but I'm sure somebody could make you one that removes all the templates with one swift step. :D

AnkisethGallant
05-05-2002, 06:12 PM
Don't worry, I already figured that out before you said anything.

I think I may be actually getting the hang of the whole PHP & MySQL thing....................or not.

Xyber
05-06-2002, 08:19 PM
bump

why'd u remove the download link? not every1 needs assistance in installing stuff o_O

ender
05-06-2002, 08:28 PM
He's gone until Tuesday. He removed it until he gets back.

AnkisethGallant
05-06-2002, 08:52 PM
Does anyone know for a fact which updates he's putting into the new version?

geniuscrew
05-06-2002, 10:56 PM
Wish I knew ;)

Btw, Did you manage to get your itemshop working Antiseth?

AnkisethGallant
05-06-2002, 10:57 PM
No. I just took out everything and decided to wait until the new version, since it will have more stuff anyway. I didn't have the shop open to users as it was, so there was no loss.

geniuscrew
05-06-2002, 11:05 PM
Sounds like a dumb question, and probably no point now, but did you install the two point hacks prior to installing itemshop?

AnkisethGallant
05-06-2002, 11:08 PM
I only installed the Points hack from Palmer OfShinra, why, was there another thing I had to install?

geniuscrew
05-06-2002, 11:13 PM
I dunno if it might have made any difference, but I also installed the add-on to it, which lets you earn points by posting

AnkisethGallant
05-06-2002, 11:16 PM
Vivi included that in the itemshop hack, and he even made a field in the Admin CP where you could edit how much they got. I don't think it matters if it was previously installed.

geniuscrew
05-06-2002, 11:23 PM
the add-on made by Iguacu (or something like that)

Add on (https://vborg.vbsupport.ru/showthread.php?s=&threadid=35926&highlight=points)

That's what I installed after installing the point hack - i suppose if you're not busy it's worth a try, although I dunno why it would make a difference :ermm:

Also hover over your "www" bit under one of your posts, i think the URL is wrong

OK I'll go now cuz i dunno what i'm talking about

Velocd
05-07-2002, 12:16 AM
I don't know what your talking about either. Vivi's new item shop will integrate Iguacu's addon. I just can't wait to install this updated version, I hope he fixed some of the problems before :D

geniuscrew
05-07-2002, 12:39 AM
See, I knew I was crazy -

Doesn't hurt to try to help though ;) :p

dadymac
05-07-2002, 08:43 AM
so how hard would it be to get this to point to the db that lesane used for his store to have one general money for those who have it installed?

E
05-07-2002, 10:53 AM
*sees its Tuesday... vivi is lookin at thread*
*grins*

AnkisethGallant
05-07-2002, 12:22 PM
I'm going to school, I hope Vivi has it done when I get back.

And if you read this Vivi, would you post a list of the new updates? Thanks.

Vivi Ornitier
05-07-2002, 01:55 PM
I'm attaching the new version.

fixed the reported bugs. postbit works. more efficient.

****
BEFORE YOU INSTALL, REMOVE ALL PREVIOUS INSTALLATIONS!
AFTER INSTALLATION, REVERT ANY LEFT ITEMSHOP TEMPLATES!
****

I have tested this on a clean vb copy and it works.

snack
05-07-2002, 05:12 PM
Ok found a bug with the fast reply box!

If you have it and you refresh the page it will automatic gives you points... can you fix it?

Do anyone notice ??

I tried with different usernames and when i refresh that page with the fast reply box hack it automatic gives me points!

snack
05-07-2002, 05:13 PM
Yea this post reply box located on the bottom of the page some how it gives points when you refresh page i dunno why

dadymac
05-07-2002, 09:13 PM
i was installing the new version, and accidently closed the window where it told me what to stick into my post bit

was it post[items] ?

dadymac
05-07-2002, 09:13 PM
nm, found it in the install file, duh on my part.

dadymac
05-07-2002, 09:22 PM
oh, can u change the interests on the bank?? i thnk 10percent is way too much, some of my members already have like 2000 points and 10% would totally be too much.

dadymac
05-07-2002, 09:42 PM
also, if you try to buy the same item, u keep the same one, your money is intact at the right amount, but it shows one more for the sold counter. it also says thanks for shopping, but im guessint that would req another template.

E
05-07-2002, 10:02 PM
how do u buy items?

E
05-07-2002, 10:17 PM
and i cant find the templates too edit.....
anyway of makin them instead of going to default templates... they goto Custom templates...?

E
05-07-2002, 10:21 PM
or i could just add them by hand.. hmm ill read thru the install file

Webmasta XT
05-08-2002, 10:18 AM
is there a way I can change the way the PostBit displays Items?? I wanna put a label at the top.. such as Weapon, Item, Armor at the top so they can know which one is which!! plz help..

E
05-08-2002, 10:24 AM
i was wondering the same.... i looked into the database... and i see in user there is item1 item2 + item3 and evrythign else 1,2,3 i have 3 categorys so i figuired they would be it............. but
it just shows this "Resource id #8" or another number..... ??

E
05-08-2002, 10:47 AM
Oh nevermind.. i found out how to do it.... i was using user instead of item_user

AtmosPhere
05-08-2002, 11:19 AM
Is there anyway of showing the points on the posbit?
I also use Lesanes store hack along side itemshop and i want itemshops "gil" to appear under LesaneStores Points in my postbit, Please advise on how to go about this

Vivi Ornitier
05-08-2002, 11:31 AM
well, you can change the way items are displayed in the postbit in the functions.php part. you can use $catstuff[name] to display the name.

as for the points field.... $post[fieldx] i think, where x is the number of your field.

Velocd
05-08-2002, 01:58 PM
Originally posted by dadymac
oh, can u change the interests on the bank?? i thnk 10percent is way too much, some of my members already have like 2000 points and 10% would totally be too much.

&

Originally posted by Webmasta XT
is there a way I can change the way the PostBit displays Items?? I wanna put a label at the top.. such as Weapon, Item, Armor at the top so they can know which one is which!! plz help..

It shouldn't be too hard, just look in the templates/php files. I have yet to install this new version, but I plan to do so tonight.

Originally posted by snack
Yea this post reply box located on the bottom of the page some how it gives points when you refresh page i dunno why

Yes this is a problem with the original point system add-on by posting. But Vivi made fixed the code himself in the original add-on, so this itemshop shouldn't have a problem. If so still, then replace:

$DB_site->query("UPDATE user SET
".iif ($foruminfo[countposts],"posts=posts+1,","")."
$dotitle"."lastpost='".time()."' WHERE userid='$bbuserinfo[userid]'");



In newthread.php and newreply.php, with this:


$DB_site->query("UPDATE userfield SET
fieldX=fieldX+? WHERE userid='$bbuserinfo[userid]'");

Mike Gaidin
05-08-2002, 03:04 PM
Is there anyway to make the Points Field part of the Itemshop Admin options bigger? Right now I can only put in 6 characters into the box and I need seven. I tried to enter field26, but it changed it to field2. Please assist.

snack
05-08-2002, 04:42 PM
Originally posted by Velocd


&



It shouldn't be too hard, just look in the templates/php files. I have yet to install this new version, but I plan to do so tonight.



Yes this is a problem with the original point system add-on by posting. But Vivi made fixed the code himself in the original add-on, so this itemshop shouldn't have a problem. If so still, then replace:

$DB_site->query("UPDATE user SET
".iif ($foruminfo[countposts],"posts=posts+1,","")."
$dotitle"."lastpost='".time()."' WHERE userid='$bbuserinfo[userid]'");



In newthread.php and newreply.php, with this:


$DB_site->query("UPDATE userfield SET
fieldX=fieldX+? WHERE userid='$bbuserinfo[userid]'");


It doesnt work, I changed the codes then refresh that page 3 points was added on =P hehe

Marshalus
05-08-2002, 11:50 PM
There needs to be some kind of admin panel for this, that would allow the admins to check what users have in the bank, what they own, and more options.

Also, be able to edit what users have.

Just a request :D

Marshalus
05-08-2002, 11:54 PM
Also, instead of post[item] is there a way to make a new page, or add it to the members information page, that would list what users have for normal users.

My shop has like 8 or 9 catagories, and my postbits would get really huge.

dadymac
05-09-2002, 03:05 AM
question : (not crictizing at all) if this is a step towards the battle hack, how hard will it be to give the items attributes??

Velocd
05-09-2002, 04:06 AM
Who said it was a step towards the battle system? Well actually, I guess you could say it being silly to have an itemshop without a battlesystem, but I'm not sure anyone but Afterlab is developing a battlesystem (ofcourse I *probably* am wrong). Giving item attributes is possible, but depends on the level of experience by the coder. An experienced coder with good knowledge of MySQL/PHP could probably do it, and I'm sure if he had time, Vivi could do it.

Marshalus
05-09-2002, 04:11 AM
I hope so.

Vivi, I just wanted to let you know that my site members LOVE this hack. http://www.federationstudios.net/forums/itemshop.php check out the stuff we're selling ;)

Anyway, a battle hack would be great to incorporate into this, as right now I'm planning to do all of the battles on my forums by hand, a sort of "D&D" style match up.

snack
05-09-2002, 04:30 AM
Anyone know how to fix the problem... my board keep giving out points when people refresh the pages ...

E
05-09-2002, 07:23 AM
Marshalus too get the items too display somewhere else ill tell u what i did

Put This Query in Functions where the post one goes
$items=$DB_site->query_first("SELECT * FROM items_user WHERE userid=$bbuserinfo[userid]")

now wherever u want it to display the users items do this

If Category One Is Weapons.. then u'd type:
Users Weapon
$items[item1]
In A Template whereeverr u want it to display

If u want it to display the item from category 2... u use item2 instead of item1

hope that helps

Vivi Ornitier
05-09-2002, 01:16 PM
the code to get items is already in functions. you just have to modify the html output in that part, and display them where you want on your site.


Giving item attributes is possible, but depends on the level of experience by the coder. An experienced coder with good knowledge of MySQL/PHP could probably do it, and I'm sure if he had time, Vivi could do it.

already ahead of you, but i will not be releasing anything. I'll keep it to myself.

Marshalus
05-09-2002, 02:42 PM
Originally posted by Vivi Ornitier
already ahead of you, but i will not be releasing anything. I'll keep it to myself.

Doh! How much $$ would it cost to pursuade you otherwise?

Marshalus
05-09-2002, 05:59 PM
Originally posted by E
Marshalus too get the items too display somewhere else ill tell u what i did...

You forgot the ; at the end ;)

dadymac
05-09-2002, 07:40 PM
Originally posted by Marshalus


Doh! How much $$ would it cost to pursuade you otherwise?

snack
05-10-2002, 12:05 AM
Does anyone hav ethe same problem? when a page refresh the person get points???

Marshalus
05-10-2002, 12:45 AM
Hey Vivi, whats the status of the updates?

Marshalus
05-10-2002, 04:55 AM
Does the system restock it self automatically, or is there something I need to do for it to work?

snack
05-10-2002, 05:10 PM
In the personal shop... the user can add stuff but theres no pic???

AtmosPhere
05-10-2002, 11:59 PM
May i suggest an add on for the current itemshop? A feature that can add/decrease Gil?
I want to give users awards etc.

Velocd
05-11-2002, 05:11 AM
Note to Marshalus: Stop double posting (gets annoying)

As for suggestions, I still have 2 that I would literally DIE for to see on this itemshop, mostly to deal with the personal itemshop really.

#1. PLEASE make it so users cannot create their own items, but can only sell the items they currently have. There is nothing from stopping a user creating total spammish items with profanity names, etc. It just isn't that great of an idea for users to create their own and sell them, but maybe though for a certain price a user could create his own item.

#2. (this is ignoring #1) How about letting the user choose an icon for their custom item?? This would be very cool, and really is needed ^_^ Maybe a dropdown list with a list of the icon names, and a picture to the side.

BUG: I've noticed with the whole looping thing in the itemshop, that on some pages like the personal item shop pages it will loop everything over again, like there will be two image logo's, two header button bars, 2 footers, etc.

Anyway, those suggestions I made above would be awesome to have, and I even tried to code them myself but it's much more difficult for me trying to disect your code them if I were to build it myself from scratch.

Regards,
Velocd

snack
05-11-2002, 06:51 AM
Also a bug when a person refresh the page it gives them points...

Velocd
05-11-2002, 01:45 PM
I'm not having that problem, but that is because I skipped the modifications he had in the newreply/newthread.php, and used the old point system add-on instead.

https://vborg.vbsupport.ru/showthread.php?s=&threadid=36946&highlight=rerelease

Vivi Ornitier
05-11-2002, 07:26 PM
i'm waaay to busy to do anything else right now. I'm working hard on my site, which i'm gonna release soon, not to mention the forums.

One quik update here: i noticed that the functions.php can add couple hundreds of queries depending on the number of posts in a thread.here's the fix:

find in showthread.php (twice):
LEFT JOIN userfield ON userfield.userid=user.userid

below it add
LEFT JOIN items_user ON items_user.userid=user.userid

[b]change the functions.php part to:
if($post[item0]!='No Item') {
$post[items] .= "<a href=\"itemshop.php?action=view&id=$post[itid0]\"><img src=\"{imagesfolder}/itemshop/prs.gif\" border=\"0\"></a> ";
} else {
$post[items] .= "<img src=\"{imagesfolder}/itemshop/No Item.gif\" border=\"0\"> ";
}


$nr=1;
while ($nr <= 3) {
$xc="item$nr";
if($post[$xc]!='No Item') {
$xvv = "item$nr";
$xv = "itid$nr";
$xvvv = "icon$nr";
if(empty($post[$xvvv])) {
$post[items] .= "<a href=\"itemshop.php?action=view&id=$post[$xv]\"><img src=\"{imagesfolder}/itemshop/$post[$xvv].gif\" border=\"0\"></a> ";
} else {
$post[items] .= "<a href=\"itemshop.php?action=view&id=$post[$xv]\"><img src=\"{imagesfolder}/itemshop/$post[$xvvv].gif\" border=\"0\"></a> ";
}
} else {
$post[items] .= "<img src=\"{imagesfolder}/itemshop/No Item.gif\" border=\"0\"> ";
}
$nr++;
}

dadymac
05-12-2002, 12:11 AM
can u post the code we are supposed to change from admin/functions.php since all u gave us was the install file and its a butt to look for with all the extra \ and php commands in there.

Vivi Ornitier
05-12-2002, 11:27 AM
run install_itemshop.php?step4

snack
05-13-2002, 01:23 AM
UMMm when i add new catagories... it shows in the item shop but not in the user profile when they post!

snack
05-14-2002, 05:24 PM
How do i uninstall the point hack thats with the itemshop v5 install? so i can install the old point hack?

Brianna
05-18-2002, 12:36 AM
Originally posted by J-OST
Is there anyway to make the Points Field part of the Itemshop Admin options bigger? Right now I can only put in 6 characters into the box and I need seven. I tried to enter field26, but it changed it to field2. Please assist.

I get the same problem :S

Go into your MySQL Database and select the "items_options" table... check on the field "pointfield" and click on the change button... then it should take you to another page where you can change the length of the variable, it's set to 6 for me, change it to 7 ;)

*Hopes he did this right* I'm quite new to all of this ^^ but that's not too hard is it? hehe http://forums.crystaldimensions.com/images/smilies/bounce.gif http://forums.crystaldimensions.com/images/smilies/hide.gif

Mike Gaidin
05-18-2002, 03:12 AM
Thanks! I will try this.

Velocd
05-18-2002, 05:50 AM
Originally posted by snack
How do i uninstall the point hack thats with the itemshop v5 install? so i can install the old point hack?

last I checked this Itemshop uses the Shinra Online Point System, which is the only one really out there. So I think you're either alittle unclear or too vague

Neo
05-18-2002, 05:55 AM
I released one aswell.. its smaller and runs fatser than the shinra online one.

snack
05-21-2002, 08:47 PM
ONE MAJOR PROBLEM... when i add a new catagory. it shows on the itemshop the items you brought, but it doesnt show on the user profile... like when they post it only show four of there itemshop...

E
05-23-2002, 08:48 AM
ima make my own shop...
easier to customize that way

DarkDraco07
05-24-2002, 07:11 AM
on the edit item page where it shows all the sellable items, the icons for the main itemshops work but when i try to add one to a users item nothing happens. can someone find a fix for this?

UGate
05-24-2002, 04:51 PM
Database error in vBulletin 2.2.4:

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

mysql error number: 1054

Date: Friday 24th of May 2002 07:51:29 PM
Script: http://www.undergroundgate.com/ugate/forums/ugate/forums/itemshop.php?action=donate&user=3
Referer:

DarkDraco07
05-24-2002, 04:53 PM
um, can anyone help????

UGate
05-24-2002, 04:59 PM
i need Help !

DarkDraco07
05-24-2002, 05:14 PM
no i do!!!

snack
05-24-2002, 05:16 PM
The Itemshop only load 4 icons on the user profile how do i make it load all of the icons... i have like 6 - 8 icon area it only load 4 of them??

snack
05-24-2002, 05:23 PM
How do you change the bank interest?

DarkDraco07
05-24-2002, 05:49 PM
yea, i think 10% is too much i want to make it 5 or 6

snack
05-24-2002, 06:20 PM
yUpz... anyone know how to change it?

DarkDraco07
05-26-2002, 08:06 PM
hello?????????

Lucrecia
05-26-2002, 10:18 PM
I still don't see where you can buy or sell items Also, whenever I try to donate any points, it say cannot display page after I put in how many points to donate and click on Donate!

geniuscrew
05-27-2002, 12:24 PM
Hey ppl

I need help with this shop.

Firstly the items aren't showing up in the post bit at all - i'm using $post[items].

Secondly what's the items_user table for? I understand it holds items but I have bought 2 items, but it doesn't show up in the table however (show up) it does for other people.

Please help - thanx

Vivi Ornitier
05-27-2002, 04:34 PM
I am sorry people, but i have decided not to give support for this hack anymore. I'm verry busy with both school & my own site, and do not have the time for this.

If you can fix problems & make it work by yourself, good for you. If not, try asking people who can.

Thank you.

DarkDraco07
05-28-2002, 03:06 PM
i have found a major bug.
when you buy an item from your own shop you dont lose money

UltimaKing
06-02-2002, 02:09 AM
Uhh, can anyone get images to work in people's personnal shops?

snack
06-03-2002, 02:29 AM
Anyone know how to set the bank interest a little lower? because 10 percent is too much =P

geniuscrew
06-03-2002, 03:24 PM
What's the variable you use to display stuff in the postbit
? Mine doesn't seem to work :-/

Travis641
06-04-2002, 12:36 AM
I can't get anything to show up in postbit either. :confused:

ULTIMATESSJ
06-05-2002, 09:04 AM
one problem i had with the old itemshop was finding the items, it was pretty time comsuming looking everywhere for the items, does anyone have a zip with some items i could use?, any items would do

DarkDraco07
06-05-2002, 03:22 PM
lets all give up. noones gonna help

UltimaKing
06-05-2002, 09:34 PM
I would give up, but then all my members would hunt me down and kill me :laugh:


I just need to get people's images to show up for their personnal shops ;) Right now it just shows up as blank gif even when I type in the image name. o_O

DarkDraco07
06-06-2002, 03:03 PM
im tryin to get the item shop fixed so people cant buy their own items. people are making 99999999 priced items and buying them from their own store so theyll gain money. im about to take the custom shops out

dong
06-12-2002, 12:55 PM
Originally posted by ender
FYI, I integrated this hack to work with the Store Hack by Lesane by finding all instances of userfield in itemshop.php and replacing it with user. Then in the admin panel change the field name to storep.

yea, this works excellent with the store hack
now i only want to resell my items and not allow members to create new items, and be able to choose multiple items from 1 catagory
maybe if i figure out a rehack i post it here

nice hack Vivi, tobad u dont support it anymore

CloudSlash
06-12-2002, 04:42 PM
will this work with 2.2.6

Vivi Ornitier
06-12-2002, 07:17 PM
i've stopped offering support for this long time ago. I'm completely redoing my own itemshop to work with the battle system i'm creating, but i'm not going to release any of them.

A friend of mine is gonna release a new version of the itemshop soon i think. He's working on it.

DarkDraco07
06-13-2002, 09:41 PM
Originally posted by CloudSlash
will this work with 2.2.6

yes it will. i upgraded to 2.2.6 and it works fine

Atian
06-23-2002, 12:16 AM
erm can anyone help? i cant the images to work on the postbit..i dont care if vivi stopped giving support,i made my own version and it works with the battle system im making o_O;; if anyone helps me then ill release it,if not then no battle system for you people :p j/k i will release it anyway...

Grealm
06-23-2002, 04:03 AM
ok.. anyone wants to help me here? ive successfully installed this hack, but when i get to this point right here:

"7. Still in the admin cp, select 'itemshop' > 'edit options' from the side menu. Be sure the field here corresponds to the one you added above!"

i cant seem to see the itemshop on the admin cp.. anyone? please..

Grealm
06-24-2002, 01:39 AM
umm.. i really like this hack, but no1 seems to willing to help us here.. very disappointing. :(

Keta
06-24-2002, 07:35 PM
isn't this just the same as lesane's store?

Grealm
06-25-2002, 12:56 AM
dunno.. but i seems to having problem.. and how come it wont show the points and how do they get points? please some1..

Chris M
06-28-2002, 10:52 AM
Error :

Im running vB 2.2.6, and when I try to add the code to functions.php, I get this error :

Parse error: parse error in /home2/thelyceu/public_html/kumantek/forum/admin/functions.php on line 842

Fatal error: Call to undefined function: vbsetcookie() in /home2/thelyceu/public_html/kumantek/forum/admin/sessions.php on line 183

Satan

SHoeSTeR
06-29-2002, 12:05 AM
postbit template

--------------------------
##### add this next to your points link:
<a href="#" onclick="javascript:window.open('itemshop.php?action=donate&user=$post[userid]', '', 'toolbar=no,scrollbars=no,resizable=no,width=300,h eight=50');">Donate</a>
##### add this where you want your items to appear:
$post[items]
--------------------------

I don't get that part =/

Link14716
07-03-2002, 06:57 PM
Does this hack with with the store hack?

Chris M
07-03-2002, 07:28 PM
@SHoeSTeR - You did create a new Profile Field didnt you?

Create it so the user cannot edit it...

Now, find the id of the field, and put :
$post[fieldx]
(x being the field id)
in the postbit template where you want...

I recommend Adding this:
Points: $post[fieldx]
after
$post[posts]
You just then add :
<a href="#" onclick="java script:window.open('itemshop.php?action=donate&user=$post[userid]', '', 'toolbar=no,scrollbars=no,resizable=no,width=300,h eight=50');">Donate</a>
after
Points: $post[fieldx]
and then
$post[items]
wherever you want the items to show up...

@Link14716 - No...

Suggestion : Can you make it so more than one item can be bought from each store?

Satan

Velocd
07-03-2002, 07:35 PM
Originally posted by Link14716
Does this hack with with the store hack?

oro....*dies* I bet this question has been asked at least 3 or 4 times in this whole thread, you should search around a bit first. Or even better, I think the next time anybody releases a point/karma/store hack, it should have a FAQ (if applicable)saying it's not compatible with lesanes store ;)

hypedave
07-05-2002, 04:56 AM
jus installed and i got this error when I went to /forums/itemshop.php

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 12:53:32 AM

proxyMX
07-05-2002, 03:56 PM
I found this hack exellent in my last forums. and will be installing it in my new trek rp forums. I think its a great peice of work and sorry to say lesanne, but i do prefer this to lesannes hack. Purely the fact that you can customise items and shop them in the postibt puts this hack ahead of the rest. Im anticpating V6 for Vb3

proxyMX
07-05-2002, 09:03 PM
1: Whenever i post a new thread i get this error:
Database error in vBulletin 2.2.6:

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

mysql error number: 1054

Date: Friday 05th of July 2002 04:53:42 PM
Script: http://www.proxymx.com/forums/forums/itemshop.php?action=donate&user=1
Referer:

And i also get this error when i try and post replies, there is no numbers comming up next to points in the postbit and it also happens whenever i click donate.
Please tell me where im going wrong

Chris M
07-05-2002, 09:07 PM
Well...

Have you made the user profile field?

If so, have you changed the option in the itemshop options, where it says field5?

If the field id isnt 5, it wont work until you change it to fieldx, where x is the id of the field for the points/credits/money...

Satan

proxyMX
07-05-2002, 09:32 PM
i created a user feild called points and then i changed the options to points and then i also changed the postbit to points. But nothing. i still get these weird and annoying messages

g-force2k2
07-05-2002, 09:37 PM
you have to make sure that the userfield is correct... go to modify profilefields and left click the edit button of the points and paste it in the browser... whatever the field# is in the browser has to be the one for the points hope that helps :)

g-force2k2

Chris M
07-05-2002, 09:50 PM
Yeh...

Thats what I was trying to say...

Satan

hypedave
07-05-2002, 09:53 PM
Originally posted by g-force2k2
you have to make sure that the userfield is correct... go to modify profilefields and left click the edit button of the points and paste it in the browser... whatever the field# is in the browser has to be the one for the points hope that helps :)

g-force2k2


thankyou that fixed my problem

hypedave
07-05-2002, 09:56 PM
when I go to the admin cp user.php gives me the following error

Database error in vBulletin Control Panel 2.2.6:

Invalid SQL: SELECT *,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 05:53:23 PM

proxyMX
07-05-2002, 09:59 PM
Thanks Geforce2k i hope you dont mind if i add you to my buddylist, youve been a huge help to me on several occasions so far!

g-force2k2
07-05-2002, 10:02 PM
hey np proxyMX ever need anything drop me a line ;) thats what im here for :) I know Mewtwo has stopped offering support for this hack but i'll try my best to support anyone that needs help although i don't even use the hack :P

g-force2k2

g-force2k2
07-05-2002, 10:05 PM
hyperdave does are you sure that its from the itemshop hack? seems more to do with an avatar hack?

g-force2k2

hypedave
07-05-2002, 10:12 PM
Originally posted by g-force2k2
hyperdave does are you sure that its from the itemshop hack? seems more to do with an avatar hack?

g-force2k2

yes im positve its from the itemshop hack, im starting to think that the install file written for this did not ad certain tables in vb 2.2.6, I dunno, its such a useful hack for my RPG.MMORG forum till I hate to jus unistall this, cause I like the feature where you can purchase armor etc. but im positive I have no avatar hacks installed,

g-force2k2
07-05-2002, 10:12 PM
hyperdave

oepn admin/user.php

find:

SELECT *,FROM_UNIXTIME(joindate) AS joindate,FROM_UNIXTIME(lastvisit) AS lastvisit,FROM_UNIXTIME

replace with:

SELECT user.*,FROM_UNIXTIME(joindate) AS joindate,FROM_UNIXTIME(lastvisit) AS lastvisit,FROM_UNIXTIME

see if that fixes your problem :)

g-force2k2

hypedave
07-05-2002, 10:22 PM
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

g-force2k2
07-05-2002, 10:35 PM
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

proxyMX
07-06-2002, 02:50 AM
The items will not show in the posbit.

Seifer
07-06-2002, 04:15 AM
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]

proxyMX
07-06-2002, 02:34 PM
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
$post [items]
Why wont it work?

Chris M
07-06-2002, 02:48 PM
Take out the space...

Satan

proxyMX
07-06-2002, 02:50 PM
in my forums there is no space.
And i tested the placing a space thing, it actually brigns up something
"Array [items]"

proxyMX
07-06-2002, 03:55 PM
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.

Brianna
07-08-2002, 03:24 AM
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...

Vivi Ornitier
07-08-2002, 10:33 AM
Originally posted by proxyMX
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
$post [items]
Why wont it work?

I don't damn care if you like my hack or don't. Wanna know why i stopped giving support for this? Cause you people are VERY ANNOYING! Yes, you can't read 3 lines of instructions, then run ahead and complain that the hack sucks. Most errors you report are caused by incorrect installation and/or other hacks. I have tested it, and it works perfectly for me. YOU PEOPLE ARE LAZY. I don't expect you to read all the posts in this thread (which could actually solve your problem), but AT LEAST have the decency of properly reading the installation instructions.

FINAL POSTBIT FIX:
since i did a join on the items_user table, you can use any field in that table as $post[whatever].

Brianna
07-09-2002, 11:37 PM
Originally posted by Vivi Ornitier


I don't damn care if you like my hack or don't. Wanna know why i stopped giving support for this? Cause you people are VERY ANNOYING! Yes, you can't read 3 lines of instructions, then run ahead and complain that the hack sucks. Most errors you report are caused by incorrect installation and/or other hacks. I have tested it, and it works perfectly for me. YOU PEOPLE ARE LAZY. I don't expect you to read all the posts in this thread (which could actually solve your problem), but AT LEAST have the decency of properly reading the installation instructions.

FINAL POSTBIT FIX:
since i did a join on the items_user table, you can use any field in that table as $post[whatever].

What version was this that you tested it on? I have version 2.2.5 and it works fine, other than the interest not incrementing, which isn't a big deal, but this problem I had with the template system being messed up happened at another person's forums as well.

I followed it step by step... Now I do have other hacks; but everything was fine until I installed this one: could the problem be a mixture of this hack and another that might clash with eachother?

Of course, I do not mind if you do not help me out here; I read through every post in this thread before posting my problem (knowing my idiocity I could have overlooked it being mentioned, but as far as I know I did not see it), anyways yes it was quite annoying, and I can understand your frustration completely...

Link14716
07-11-2002, 12:54 AM
Hmm....

Can anyone help me?

When I make a new catagory, it won't show up in the postbit. I have tried to edit the functions.php part, but to no avail. Can anyone post how to show all of the items you have in the postbit?

dadymac
07-11-2002, 04:00 AM
just wanted to say i have this hack installed along with 15 or so other hacks, even integrated this with lesanes, and i didnt have to do one single extra thing other than the instructions.

great hack, sorry you have to deal with comments like we all see here.

Link14716
07-12-2002, 02:07 AM
I did the same as you, but the issue comes when yu add a new catagory and buy an item. The item that you buy in the new catagory doesn't show up in the postbit, but the other 4 do.

E
07-12-2002, 02:12 AM
blah i made my own version of this... where items actually do things.... and u can have up to 3 weapons and 3 armour...

xxskullxx
07-12-2002, 04:55 AM
I have this hack installed on my (2.2.6) site without any problems whatsoever. It installed fine along side of alot of different hacks. I think Vivi did a great job.

Cheers!

GamerNext
07-13-2002, 02:42 AM
I'm having all my problems with the field thing and putting it in post bit.

Database error in vBulletin 2.2.6:

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

mysql error number: 1054

Date: Friday 12th of July 2002 11:37:05 PM
Script: http://www.gamernext.com/boards/boards/newreply.php
Referer: http://www.gamernext.com/boards/newreply.php?action=newreply&threadid=293

I have no idea what to do and it's all to do with the field number.

Grealm
07-13-2002, 02:59 PM
i heard this hack have a bug if u buy ur personal shop..?

Vivi Ornitier
07-13-2002, 03:53 PM
Originally posted by GamerNext
I'm having all my problems with the field thing and putting it in post bit.

Database error in vBulletin 2.2.6:

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

mysql error number: 1054

Date: Friday 12th of July 2002 11:37:05 PM
Script: http://www.gamernext.com/boards/boards/newreply.php
Referer: http://www.gamernext.com/boards/newreply.php?action=newreply&threadid=293

I have no idea what to do and it's all to do with the field number.

now this is what i'm talking about. read through the instructions.
the "add a new userfield" part.

I did the same as you, but the issue comes when yu add a new catagory and buy an item. The item that you buy in the new catagory doesn't show up in the postbit, but the other 4 do.
read my post above.


What version was this that you tested it on? I have version 2.2.5 and it works fine, other than the interest not incrementing, which isn't a big deal, but this problem I had with the template system being messed up happened at another person's forums as well.

I followed it step by step... Now I do have other hacks; but everything was fine until I installed this one: could the problem be a mixture of this hack and another that might clash with eachother?

Of course, I do not mind if you do not help me out here; I read through every post in this thread before posting my problem (knowing my idiocity I could have overlooked it being mentioned, but as far as I know I did not see it), anyways yes it was quite annoying, and I can understand your frustration completely...

if everyone on this board would be like you.....

Vinney
07-13-2002, 04:36 PM
Could someone tell me how i would go about adding an extra varibale to each item. i run a car forum ... and my shop is going to be based upon car modifications .... which add up to a total BHP

I want to be able to rate each item with a defined BHP ?

How can i do this ???

GamerNext
07-13-2002, 06:23 PM
Vivi, I really appreciate you coming back and giving support. Thanks man.

But, I believe I did everything right and it still is messed up. When I go to edit options for the Item Shop, I set the field to "field13" which is the correct field for Points:. I've set everything right and it's field13 in the postbit. But, when I change the field in edit options of Item Shop, it goes back to 1. So now everyone's biography is showing the point number. It's like it's not saving field13. Please help man.

Grealm
07-16-2002, 02:25 AM
one more question: how do u add an items to show on your posbits? our forum's maximum is 3 items only.. is there anyway we can change that? if it's possible how?

this is the only question that hasnt been answered..

Vivi Ornitier
07-16-2002, 09:21 AM
Originally posted by GamerNext
Vivi, I really appreciate you coming back and giving support. Thanks man.

But, I believe I did everything right and it still is messed up. When I go to edit options for the Item Shop, I set the field to "field13" which is the correct field for Points:. I've set everything right and it's field13 in the postbit. But, when I change the field in edit options of Item Shop, it goes back to 1. So now everyone's biography is showing the point number. It's like it's not saving field13. Please help man.

for anyone that's getting that error: run this query
ALTER TABLE `items_options` CHANGE `pointfield` `pointfield` VARCHAR(20) NOT NULL

Atian
07-16-2002, 04:41 PM
im more than sure its because you messed up the intallation...ive tested these more than 4 times in different boards i dint get a single error from it....wich leads to my conclusion that you messed it up,if vivi and/or mewtwo dont mind i can give some support for these sh*t....

and i made the query like these

ALTER TABLE `items_options` CHANGE `pointfield` `pointfield` VARCHAR(78) NOT NULL

since i have alot of fields and stuff,vivi knows how these works......

Grealm
07-16-2002, 10:04 PM
Originally posted by Grealm
one more question: how do u add an items to show on your posbits? our forum's maximum is 3 items only.. is there anyway we can change that? if it's possible how?

this is the only question that hasnt been answered..

anyone have an answer on this?

mei
07-19-2002, 12:32 AM
my only question is, my points hack wont work with the item shop XD... suggestions?

[edit] har har im just slow at installing hacks.. don't blame me -.-; i fixed it XD

Mephisteus
07-19-2002, 02:20 PM
There is an bug in the donate, if you fill in -X (x is the number) then the "donator" gets +X and the "receiver' -X

Here is the fix for that. also ads an new template

You'll need vbHacker (https://vborg.vbsupport.ru/showthread.php?s=&threadid=36378)

Atian
07-20-2002, 12:15 AM
Originally posted by Grealm


anyone have an answer on this?

Run these query

ALTER TABLE `database_name`.`items` CHANGE `cat` `cat` INT(7) DEFAULT '0' NOT NULL

Change databse_name to your database name and (7) to the number of items you wan to be displayed

Grealm
07-20-2002, 02:36 PM
Originally posted by Atian

Change databse_name to your database name and (7) to the number of items you wan to be displayed

nvm.. :D

Grealm
07-20-2002, 02:42 PM
umm.. that didnt work.. still 3 items on the postbit:(

Link14716
07-20-2002, 04:48 PM
For all you that can't real the above post to find what this is a fix for:

THIS IS THE CUSTOM CATAGORY POSTBIT FIX

It's all with the functions.php code.
In admin/functions.php
Replace:
global $DB_site;
$nr=1;
while ($nr <= 50) {
$catstuff=$DB_site->query_first("SELECT * FROM items_cats WHERE id=$nr");
$its=$DB_site->query("SELECT * FROM items WHERE cat=$nr ORDER BY name $asds");
if(sizeof($catstuff)==16) {
if($catstuff[type]==1) {
$uid=$DB_site->query_first("SELECT item0,points0,description0,icon0,itid0 FROM items_user WHERE userid=$post[userid]");
if($uid[0]!='No Item') {
$post[items] .= "<a href=\"itemshop.php?action=view&id=$uid[4]\"><img src=\"https://vborg.vbsupport.ru/images/itemshop/prs.gif\" border=\"0\"></a> ";
} else {
$post[items] .= "<img src=\"https://vborg.vbsupport.ru/images/itemshop/No Item.gif\" border=\"0\"> ";
}
} else {
$uid=$DB_site->query_first("SELECT item$nr,points$nr,description$nr,icon$nr,itid$nr FROM items_user WHERE userid=$post[userid]");
if($uid[0]!='No Item') {
if(empty($uid[3])) {
$post[items] .= "<a href=\"itemshop.php?action=view&id=$uid[4]\"><img src=\"https://vborg.vbsupport.ru/images/itemshop/$uid[0].gif\" border=\"0\"></a> ";
} else {
$post[items] .= "<a href=\"itemshop.php?action=view&id=$uid[4]\"><img src=\"https://vborg.vbsupport.ru/images/itemshop/$uid[3].gif\" border=\"0\"></a> ";
}
} else {
$post[items] .= "<img src=\"https://vborg.vbsupport.ru/images/itemshop/No Item.gif\" border=\"0\"> ";
}
}
} else {
break;
}

$nr++;
}

With:
global $DB_site;
//$nr=1;
//$cats=$DB_site->query_first("SELECT * FROM items_cats WHERE id=$nr");
//$catstuff=$DB_site->query("SELECT * FROM items_cats");
//$its=$DB_site->query("SELECT * FROM items WHERE cat=$nr ORDER BY name $asds");


$cats=$DB_site->query("SELECT * FROM items_cats ORDER by catorder");

while ($catstuff = $DB_site->fetch_array($cats)) {

$nr=$catstuff['id'];

$its=$DB_site->query("SELECT * FROM items WHERE cat=$nr ORDER BY name $asds");

if($catstuff[type]==1)
{
$uid=$DB_site->query_first("SELECT item0,points0,description0,icon0,itid0 FROM items_user WHERE userid=$post[userid]");
if($uid[0]!='No Item')
{
$post[items] .= "<a href=\"itemshop.php?action=view&id=$uid[4]\"><img src=\"images/itemshop/prs.gif\" border=\"0\"></a> ";
}
else {
$post[items] .= "<img src=\"images/itemshop/No Item.gif\" border=\"0\"> ";
}
}
else {
$uid=$DB_site->query_first("SELECT item$nr,points$nr,description$nr,icon$nr,itid$nr FROM items_user WHERE userid=$post[userid]");
if($uid[0]!='No Item')
{
if(empty($uid[3]))
{
$post[items] .= "<a href=\"itemshop.php?action=view&id=$uid[4]\"><img src=\"images/itemshop/$uid[0].gif\" border=\"0\"></a> ";
}
else {
$post[items] .= "<a href=\"itemshop.php?action=view&id=$uid[4]\"><img src=\"images/itemshop/$uid[3].gif\" border=\"0\"></a> ";
}
}
else {
$post[items] .= "<img src=\"images/itemshop/No Item.gif\" border=\"0\"> ";
}
}

}

That should do it.

NOTE: I did not make this code, a friend of mine did.

Grealm
07-21-2002, 01:08 AM
thanks.. that works perfect :)

Lovaboye
07-25-2002, 12:39 AM
I truely love it when liars post and say "i Got it working, "it works fine for me" when if you look at their forum they don't have the itemslist under the peoples names, thus not having it installed correcly!

The main problem that is bugging everyone is that

$post[items]

Doesnt show up on the thread, is their an alternate way of making it show up? Caue i can make a taable myself, i just need the info to make the table, since "$post[items]" isnt the correct item to put in postbit, does anyone know the correct item? Or just the info that enables the items box to appear?

This is truelly a great hack, i commend the author on ts behalf, but this problem is very annoying to alot of people, and whoever has fixed the prob should share the solution!

proxyMX
07-25-2002, 02:15 AM
Vivi, stop your whining,
"Cause you people are VERY ANNOYING! "
Hmm, you know what i find very annoying, You .And vivi, for your information about our "Laziness" It seems your coding is the one thats lazy, the problem most (and i HAVE read every post and provided people with a solution) people are having is with the items showing up in the postbit. There is an error in the categories thats why, If you delete a category then add a new one, it wont show that categories items, or something like that, But if you don't delete the category, and modify and delete the selected items in it, it works fine. But this hack was just to much hassel, i uninstalled it. Please dont peeve me off with your rants vivi, I really dont find you impressive at all.

EVERYONE WITH AN $post [items] CHECK THE BETTER FIX A FEW POSTS UP ONLY USE THIS IF THAT DIDNT WORK.

Theres some sort of weird muck up in the categories. If you have created a new category, all the items in that category will not show on your postbit. There is a way around this, and i posted it at an earlier page, but ill copy it here.
NOTE: Scroll down to the RED TEXT if you have not deleted any categories, If you have,follow all the steps bellow.

If you are fresh installing, run the install script, and after its done, go from step 4

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 in the bottom left hand corner 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!]

*********Custom Items Bug*********
I have found if you delete ANY of the categories then create a new one in place of em, the items from the new category DO NOT show up. So what to do is simply delete all the items in each EXISITING 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.

Took me a while to figure that out, and i may not even be right, but i think this may be the problem for many, i dont know why that happens. Perhaps the Delete Category option should be ignored by all users until a fixed version is released

If you need more help on these steps or need other support please message me on vbulletin.org. I will be happy to help to the best of my v limited abilities, I know how annoying these things can be :bunny:

Its ashame the hack has soo many errors, its a great concept, Oh well, ill just use Lesanes exellente store hack.

edit: Added earlier post step by step fix to the post.
edit: Removed some more heated comments in reply to vivi's rudeness.
edit: Added secondary steps for fresh installers.

Ninth Dimension
07-25-2002, 02:35 AM
Originally posted by Lovaboye
This is truelly a great hack, i commend the author on ts behalf, but this problem is very annoying to alot of people, and whoever has fixed the prob should share the solution! I think this is the same problem as I had, you can find the soloution here (https://vborg.vbsupport.ru/showthread.php?postid=274419#post274419) (above)

Ninth Dimension
07-25-2002, 02:40 AM
BTW, I installed this hack, and it worked fantasticly (after making the changes suggested) - i'm looking forward to any addons that might come out for this, as well as the ability to split the diffrent categories into diffrent pages.

Anyway, well done :)

Lovaboye
07-25-2002, 02:44 AM
ok ok people, this is the problem, this hack is ultra sensitive, its like a new route canal, and other installed hacks are a cold rush of air.

If you have other hacks installed, its mosts likely this wont work! This hack was made super sensitive and we need someone to unsensidize it,

I have installed a fresh copy of vb, then istalled the hack, bbom, perfect. then i changed one thing in a file, boom hacks fudges up, then when i make everything default again the problem stays the same, it doesnt go back. If your having trouble with this hack dont worry, it wasnt made with the idea that ppl might have other hacks on their board. So just 4get about this.

proxyMX
07-25-2002, 02:44 AM
Im glad to see it worked for someone. I think its pretty much hassel free if you read the instructions carefully and run it with its default items, its as soon as you try and customise it that problems arrise.

Lovaboye
07-25-2002, 02:47 AM
ok, i never customized it, i never said i did, i let it be, but the items wont show up

proxyMX
07-25-2002, 02:51 AM
:ermm: Well, read step 4 of the guide and make sure that your Field is correct by mouse overing the edit button in the User Fields thang. Be sure the fields match, and if that dosent work, then maybe you installed it wrooong

Lovaboye
07-25-2002, 03:03 AM
everythng works, i see the $ i just dont see the items, they are not shown

proxyMX
07-25-2002, 03:07 AM
if its not fixed by the above, i dont know whats wrong with it, It should be something to do with the user field, EG, you may think that because the field selected is 5th from the top, that it would be field 5, however, if you rollover edit it shows you the true field number at the end of the url in the bottom left load bar. Mines was 8. This in theory should fix the problem, if not follow the whole of the procedure shown on the prev page step by step, that fixed the same problem for me,.

Lovaboye
07-25-2002, 03:08 AM
that number only correesponds to the points/money, it doesnt do anything to if the items show up or not.

proxyMX
07-25-2002, 03:14 AM
your right, im thiniking of something different,
If you have not deleted any of the categories, or customised it in anyway, i cant help you, all i can suggest is that you either,
Fresh install the WHOLE vbulletin board.
OR
Go over the code then follow the steps i provided.
Sorry :(

Link14716
07-26-2002, 04:49 PM
I have this hack installed with tons of other hacks and it works perfectly. No wonder Vivi is pissed off at this thread. Goddamn, read the instructions and it will ++++ing work.

For those who can't, put:
$post[items]
that in your postbit template! Yes that and only that! Maybe a <br> tag after, but all you need is that damnit!

If you mean show ALL of the items, look here (https://vborg.vbsupport.ru/showthread.php?postid=274419#post274419) as I HAVE posted the solution.

Link14716
07-26-2002, 05:07 PM
Originally posted by proxyMX
*********Custom Items Bug*********
I have found if you delete ANY of the categories then create a new one in place of em, the items from the new category DO NOT show up. So what to do is simply delete all the items in each EXISITING 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.

Took me a while to figure that out, and i may not even be right, but i think this may be the problem for many, i dont know why that happens. Perhaps the Delete Category option should be ignored by all users until a fixed version is released

If you need more help on these steps or need other support please message me on vbulletin.org. I will be happy to help to the best of my v limited abilities, I know how annoying these things can be :bunny:

Its ashame the hack has soo many errors, its a great concept, Oh well, ill just use Lesanes exellente store hack.

edit: Added earlier post step by step fix to the post.
edit: Removed some more heated comments in reply to vivi's rudeness.
edit: Added secondary steps for fresh installers.

Dude.... LOOK AT MY ABOVE POST HERE (https://vborg.vbsupport.ru/showthread.php?postid=274419#post274419)! THAT IS THE FIX! DO WHAT THAT POST SAYS AND THE STUPID CUSTOM ITEMS WILL SHOW! DAMN PEOPLE! I SEE WHY SOME PEOPLE DON'T WANT TO READ ALL OF THEPOSTS BUT WHEN THE FIX IS ONLY 3 POSTS ABOVE YOURS..... GOD PEOPLE!

Now, let me go eat something and calm down....

Link14716
07-26-2002, 05:19 PM
Originally posted by Lovaboye
I truely love it when liars post and say "i Got it working, "it works fine for me" when if you look at their forum they don't have the itemslist under the peoples names, thus not having it installed correcly!

The main problem that is bugging everyone is that

$post[items]

Doesnt show up on the thread, is their an alternate way of making it show up? Caue i can make a taable myself, i just need the info to make the table, since "$post[items]" isnt the correct item to put in postbit, does anyone know the correct item? Or just the info that enables the items box to appear?

This is truelly a great hack, i commend the author on ts behalf, but this problem is very annoying to alot of people, and whoever has fixed the prob should share the solution!

Well, if a user has no items, only a few 1 pixel transparent image shows up, think, think.

proxyMX
07-26-2002, 06:17 PM
i cant beleive it, Everyeones ranting on about how i didint read the post, If YOU looked two pages back from your stinkin post youll see i posted the same thing i posted after your one. So clearly you didnt read The posts properly go back to page 14.

Btw thanks to whoever made the fix, sure its a great help to all the strife that has caused

What is seriously annoying me is that everyone is accusing everyone of not reading posts, when they are guilty of the crime themselves

Im going to re-install this, Hoping it will work properly, if it dosent someones gonna die, because ive just fine tweaked the forums, i will update the code with the fixes suggested by the fix.

Edited: I double Posted, sorry

Link14716
07-26-2002, 06:23 PM
Originally posted by proxyMX
What is seriously annoying me is that everyone is accusing everyone of not reading posts, when they are guilty of the crime themselves

Im going to re-install this, Hoping it will work properly, if it dosent someones gonna die, because ive just fine tweaked the forums, i will update the code with the fixes suggested by the fix.

Ok, anyways, I am not concerned about posts that are pages back, I am just mad when people don't read the fix that is in the long post right above it.

Yes, re-install it if you un-installed it. Great hack, especially with the fixes.