vb.org Archive
Page 6 of 47 « First 45 6 7816 Last »
Show 40 post(s) from this thread on one page

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)

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

PHP Code:
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.

Quote:
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...
PHP Code:
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: [url]http://www.punkmusicrocks.com/boards/boards/itemshop.php[/url]
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?


All times are GMT. The time now is 09:43 AM.
Page 6 of 47 « First 45 6 7816 Last »
Show 40 post(s) from this thread on one page

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.01408 seconds
  • Memory Usage 1,739KB
  • 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
  • (2)bbcode_php_printable
  • (1)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