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)

Webmasta XT 05-04-2002 07:50 PM

Quote:

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:
Quote:

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

Quote:

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.

Quote:

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 ;))

Quote:

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.


All times are GMT. The time now is 10:14 AM.

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.02234 seconds
  • Memory Usage 1,740KB
  • 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
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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