vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   The Itemshop v5 (Original) (https://vborg.vbsupport.ru/showthread.php?t=38090)

Davey 12-06-2002 02:55 PM

Quote:

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.
Perhaps you could help.
I dunno what I done wrong, but the bank doesn't work with Lesane's Store hack 2.0.
I'm using vBulletin version 2.2.9, PHP version 4.2.3 and MySQL version 4.0.0-alpha.
I installed in this order:
  • Store hack 2.0.
  • Itemshop 5.
  • itemshop.php integrated with store.
My userid is 1, but when I donate (through AdminCP) to 'Bank' (userid 3), no money is *actually* donated.
Here is a screenshot of the bank with 'Bank' having no money:

[ender]: Have you got any suggestions that will solve this?
Or anyone for that matter who can help.
Thanks.

Dave.

Davey 12-06-2002 03:10 PM

And it works for userid 1 (me).
The screenshot above is of it not working with userid 3 'Bank'.
Here's a screenshot of it working for me:

I cannot understand what's going on.
Now it's getting confusing. I thought I installed it fine.

Dave.

tdphillipsjr 12-06-2002 05:35 PM

Make sure that this:

PHP Code:

  $postbits .= getpostbit($post); 

Is in your showthread.php file, somewhere beneath this big, ugly query... not directly under it, but under it.

PHP Code:

$posts=$DB_site->query("
SELECT
post.*,post.username AS postusername,post.ipaddress AS ip,user.*,userfield.*,"
.iif($forum[allowicons],'icon.title as icontitle,icon.iconpath,','')."
attachment.attachmentid,attachment.filename,attachment.visible AS attachmentvisible,attachment.counter
"
.iif($avatarenabled,",avatar.avatarpath,NOT ISNULL(customavatar.avatardata) AS hascustomavatar,customavatar.dateline AS avatardateline","")."
FROM post
"
.iif($forum[allowicons],'LEFT JOIN icon ON icon.iconid=post.iconid','')."
LEFT JOIN user ON user.userid=post.userid
LEFT JOIN userfield ON userfield.userid=user.userid
"
.iif ($avatarenabled,"LEFT JOIN avatar ON avatar.avatarid=user.avatarid
                       LEFT JOIN customavatar ON customavatar.userid=user.userid"
,"")."
LEFT JOIN attachment ON attachment.attachmentid=post.attachmentid
WHERE 
$postids
ORDER BY dateline 
$postorder
"
); 

If it's not, that's probably the problem. If it is then try this... go to your admin/functions folder.

!!!!BACK IT UP BEFORE MAKING ANY CHANGED!!!!

right after this line

PHP Code:

    if ($post[userid]!=0) { 

Put in this

PHP Code:

 $posterid $post['userid']; 

After that, go to the template in question and replace:

PHP Code:

<a href="#" onclick="java script:window.open('itemshop.php?action=donate&user=$post[userid]', '', 'toolbar=no,scrollbars=no,resizable=no,width=200,height=50');">Donate</a

with

PHP Code:

<a href="#" onclick="java script:window.open('itemshop.php?action=donate&user=$posterid', '', 'toolbar=no,scrollbars=no,resizable=no,width=200,height=50');">Donate</a

Just make sure you back things up in case something bad happens.

Davey 12-06-2002 06:50 PM

That did nothing at all.
I logged in as 'Bank'. I had '1000000000'.
I then deposited it ALL and it was the same:
Quote:

User Stats
Points: 0
Bank Deposit:
Dave.

Ember 12-06-2002 07:23 PM

I dont know wether to install this hack or not, there seem to be a lot of errors there!

Mijae 12-06-2002 10:16 PM

Didnt work for me either :P

Ember 12-08-2002 06:18 PM

Didnt work for me, I got loads of errors....

Shame though, looks like a good hack! http://forums.camwars.net can anyone help?

Ember 12-08-2002 06:20 PM

Nevermind, i uninstalled it.... not worth the trouble i dont think!

user360 12-14-2002 10:09 PM

could anyone get this working

neolithic 12-19-2002 04:43 AM

NT

Dan 12-26-2002 11:09 PM

I got this email twice


Quote:

Database error in vBulletin 2.2.9:

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

mysql error number: 1064

Date: Thursday 26th of December 2002 01:56:24 PM
Script: http://eternalgamers.com/forums//for...ction=view&id=
Referer: http://eternalgamers.com/forums/show...?s=&postid=274
Any help here?

alanvo 01-17-2003 05:37 PM

I got this in when I try creating a new thread...

Unknown column 'storep' in 'field list'

alanvo 01-21-2003 01:37 AM

I have more than one style on my site...and when i install, only the default style got new templates added...how can i add it to my other styles?

alanvo 01-23-2003 05:13 PM

bump....

Mrpolish 01-26-2003 06:57 PM

Is there any way to not give gold per post in a selected forum (like spam) ?

Blitz King 02-09-2003 12:57 PM

Quote:

Originally posted by alanvo
I have more than one style on my site...and when i install, only the default style got new templates added...how can i add it to my other styles?
Ok. To solve this you go into your AdminCP and go to styles. Then go to the one you want to set to use the itemshop templates, and click on 'Properties'. Then where it says 'Template Set', set it to Default and it should work.

Xyphen 03-07-2003 11:20 PM

Nice hack, I use it with the Battle System.

Jitway 03-08-2003 03:15 AM

Quote:

Originally posted by v0id
Code:

<!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">
<form action="$PHP_SELF" method=post>
<input type="hidden" name="iddonate" value="$user">
<input type="text" class="bginput" name="amount" value="0">
<input type="submit" class="bginput" value="Donate!"></form></td>
  </tr>
</table>

that is my itemshop_donate template, looks fine to me.

Ok for all those with the donate problem I changed <input type="hidden" name="iddonate" value="$user"> to <input type="hidden" name="iddonate" value="userid "> and it works great now. Go figure! :laugh:

archangelsk 03-24-2003 05:42 PM

don't do rake's update. he changes a part in showthread.php, which has nothing to do with the hack.

Kiss72dbz 03-28-2003 09:36 PM

Umm how would I post items individually...Like If I wanted to post weapons only or accessories only...

trafix 03-28-2003 11:21 PM

can this be installed with store hack or is it worth installing with the store?

i cant see that i need this hack.

Holidazed 04-10-2003 02:05 AM

Can somebody PLEASE export your items, items_cats, items_options & items_user tables in your database. The hack here has no items in it and I am confused as to how to add them. It would be much easier to import the tables from a already populated items list.

PLEASE??

kevinnguyen 04-15-2003 06:12 PM

y the items that i bought doesnt appear in the postbit even though i added $post[items] in the postbit template?
help please

kevinnguyen 04-15-2003 06:26 PM

Quote:

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.
thanx man *thumbs up*

Jakor Sevel 04-20-2003 01:10 AM

can anyone tell me if there's a addon for vivi's itemshop that has it so that it doesnt' just show the picture of the item in the postbit, but says the weapon name and the picture? Thanks to anyone who can point me in the right direction.

Sylvus 04-22-2003 04:25 PM

After fixing the query issues, removing the donate and custom shops, lowering the bank %, it's a nice little addition. After getting around the "select field5" error, it's been running well enough.

I'm working on a modification that will list shops within the Item Shop. So instead of seeing all items on one page, you'll see links to Weapon Shop, Armor Shop, Potion Dealer, etc. Within you can purchase your equipment.

Had to add new items as well. Pulled in all items from Baldur's Gate, Baldur's Gate 2, Icewind Dale and Icewind Dale 2 for purchasing.

Those FF items just don't cut it. :)

Syl...

rake 04-22-2003 07:13 PM

Quote:

03-24-03 at 07:42 PM archangelsk said this in Post #419
don't do rake's update. he changes a part in showthread.php, which has nothing to do with the hack.
Are you willing to bet? It has everything to do with the itemshop. ;)

Zelda-King 04-26-2003 03:52 PM

The withdrawing function could use some work, like being able to withdraw all (when you have 1000s of points) and the ability to specify how much you're putting in or taking out. Also, we should be able to buy more than one item.

Sylvus 04-27-2003 01:07 AM

How can one go about showing a users number of posts in the Itemshop template?

$post[posts] shows nothing.

Shouldn't any variable work in any template?

Syl...

rake 04-27-2003 06:57 AM

$bbuserinfo[posts] is the variable. ;)

Zelda-King 04-29-2003 02:08 PM

Oh yeah, we could do with the ability to edit the interest rate for the bank.

Ryoku 05-03-2003 11:00 PM

Man! this is a awsome script, the best itemshop script eva. I just install it and cant believe how easy it was. Most of the work are done for u in the install file. There only a couple stuff that needed to be added to somefile.
I rate this script 10/10 ;) .
BTW i didnt use the itemshop point system. I use points system . Both work perfectly together. There are addon for points system and u can use itemshop with points system. So it awsome.

Nice job! on the hack.

ps - On the next one can u add a bank :banana:

Zelda-King 05-04-2003 11:17 AM

Hmm, could it be set so people could add their own custom icons for their custom stores? It's just tedious having to submit images for an administrator to upload to the server. Especially when the demand for custom shops is quite high.

EDIT: I can't even add icons for personal shops myself! I upload the images, put the name in the admin cp, and nothing... though the regular shop works fine. Is it supposed to be like this? Just people're asking.

Ryoku 05-04-2003 11:24 AM

o i didnt see the banks was already included in the itemshop.

Sylvus 05-04-2003 02:39 PM

Thanks Rake for your help here and on the Official VB site :)

Syl...

Sylvus 05-06-2003 02:33 AM

Update:

Modified the Item Shop to support 3rd Edition Dungeons and Dragons rather than Final Fantasy stuff.

Includes:

3rd Edition Experience Tables
Gold distributed as you gain each level based on the 3rd Edition Character Creator released by WoTC. (Ie, Level 1 character receives 100gp to buy items, 2nd level 900gp, etc). No more gold for each post, although you can still do this if you want.

A member receives 10xp per day registered times 10 for a total of 100xp per day.

Any post made is added to this experience total.

3rd Edition Exp table:

1st Level - 0 xp - 100gp
2nd level - 1000xp (10 days registered) - 900gp
3rd level - 3000xp (30 days registered) - 2700gp
4th level - 6000xp (60 days registered) - 5400gp
5th level - 10000xp (100 days registered) - 9000gp

and so forth.

The longer a member has been part of your site, the more experience they will have, the higher level they will be and the more gold they will get to purchase items.

I made some changes because giving gold per post is asking for spam so it was modified to give gold based on how long you've been part of the forum.

This is my first hack, so I have yet to receive permission from the author of the Item Shop and # of Days Registered author regarding these modifications and if I can release it as a hack/addition.

Not sure if anyone would be interested, as it seems many are Final Fantasy fans.

Syl...

Reno 05-06-2003 12:37 PM

Is this compatible with vB 2.3 even if it's for vB 2.2.5?

Zelda-King 05-10-2003 11:31 AM

I feel it's best to warn people that this hack increased the number of queries on the showthread page from about 35 to 150.

Sylvus 05-10-2003 08:19 PM

Did you install the original Item Shop Zelda-King? There are posts made (pages 14 or 15) that will cut these queries out and drop their number.

On another note, how do you find out how many queries a page is generating?

Syl...

gmarik 05-18-2003 02:46 PM

Quote:

05-06-03 at 05:37 PM Reno said this in Post #437
Is this compatible with vB 2.3 even if it's for vB 2.2.5?

Is it?

Marco


All times are GMT. The time now is 08:32 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01948 seconds
  • Memory Usage 1,839KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (6)bbcode_php_printable
  • (8)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete