vb.org Archive
Page 5 of 11 « First 34 5 67 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)
-   -   Vivi's Item Shop Point System Intagrated Into Lesanes Store Hack (https://vborg.vbsupport.ru/showthread.php?t=41845)

DemiNeo0101 08-05-2002 05:30 PM
Quote:
Originally posted by Apok2002
This seems to be a reoccuring issue. For the following:

Code:

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

mysql error number: 1054

Date: Sunday 04th of August 2002 07:12:28 PM
Script: http://www.ez-company.net/forums/forums/newreply.php
Referer: http://www.ez-company.net/forums/sho...3157#post33157
You said the error is a result of not installing the Store Hack? Are you referring to Lesane's Store Hack? Or a different one?

I've HAD Lesane's store hack installed for a few months now, w/ no problems. I installed this itemshop feature (which I dig)...and now when I try to post, I get the above error. The store hack IS installed (if you are referring to Lesane's).

So what is the fix? To install a different store hack? Reinstall Lesane's? The Itemshop seems to be working perfectly, other than causing a serious mess w/ not being able to post...which of course...is a very big issue. hehe

Please help.
In your post after this you said you reverted newthread.php and newreply.php to the originals. do you still have backups? If you do edit them and find every existence of field list and replace it with user.

proxyMX 08-05-2002 05:34 PM
Lesane, i dont know if it is an improvement of your store or not, i was under the impression, but was never actually TOLD it was.

proxyMX 08-05-2002 05:38 PM
In Lesanes store php file, simply create a link to the Itemshop, integrating the two shops. Then use the integration hack to use the same points system. :P Or use includes.

Apok2002 08-05-2002 06:55 PM
Demi:
Quote:
In your post after this you said you reverted newthread.php and newreply.php to the originals. do you still have backups? If you do edit them and find every existence of field list and replace it with user.
Should edit them as you have said? Does it make a difference? Right now, I'm using the original newreply.php and newthread.php. It appears to be working fine w/ a few exceptions.

One of which, is that all new catagories are catid=0. So even if there are 10 personal shops total (from various members), they all say catid=0, (when hover over the edit, sell, buy, etc...), which of course will ONLY display 1 personal item under the "User's Current Status" display, instead of creating fields for each of the new catagories (personal shops).

Something odd though, is that I can buy a personal item from each shop, and they will appear w/i the postbit as individual items...just not in the Itemshop menu under "User's Current Status". Also...they only use the "No Item.gif" (the white "P") regardless of the graphic you choose for it.

I just installed this yesterday, so I'm expecting a few headaches to get it working right. :) Anyone have any suggestions about the above? Are there SUPPOSED to be different catid's for personal shops? Or does "0" mean that it IS a personal shop, regardless of how many are actually created?

Apok2002 08-05-2002 06:56 PM
Oh...also...anyone know how to change the interest rate to a different %? And WHEN does it calculate the interest? I thought it would be midnight, when the new day rolled around...but nothing happened.

countryboy713 08-06-2002 12:42 AM
im getting this error

Quote:
Database error in vBulletin 2.2.6:

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

mysql error number: 1054

Date: Monday 05th of August 2002 09:40:11 PM
Script: http://www.digitalkore.net/forums/forums/itemshop.php
Referer: http://www.mywebreseller.com:2086/scripts/command
i get this when trying to access the itemshop. can anyone tell me how to fix it?

thanks

countryboy713 08-06-2002 12:57 AM
nvm, i fixed it. didnt realize that under the options it had to be "5" instead of "field5"

DemiNeo0101 08-06-2002 01:35 PM
Quote:
Originally posted by proxyMX
In Lesanes store php file, simply create a link to the Itemshop, integrating the two shops. Then use the integration hack to use the same points system. :P Or use includes.
You can add The Item shop and Bank into lesanes store alot easyer with 2 mysql query:

Item Shop:
Code:
INSERT INTO store VALUES (NULL, 'itemshop', '<a href="Itemshop.php">ItemShop</a>', '0', '0', 'someimage.gif', 'Buy All the items you want!', 'N','0');
Bank:
Code:
INSERT INTO store VALUES (13, 'bank', '<a href="itemshop.php?action=bank"><b>The Bank</a></font>', '0', 0, 'images/100.gif', 'With this action you can use our bank to store your money so it can not be robed, also gain money for keeping it in there...', 'Y', 0);

DemiNeo0101 08-06-2002 01:38 PM
Quote:
Originally posted by countryboy713
im getting this error



i get this when trying to access the itemshop. can anyone tell me how to fix it?

thanks
In my first few threads if you were to read them i said to Edit Itemshop.php and find
field list

replace it with

user


then goto your itemshop config ans change field5 to storep

[D]Vincent 08-06-2002 01:41 PM
Apok2002 I believe it gives you your money every 24 hours since you put it in the bank, if you mess with it like deposit or withdraw then I believe it resets.


All times are GMT. The time now is 09:15 AM.
Page 5 of 11 « First 34 5 67 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.01399 seconds
  • Memory Usage 1,746KB
  • 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
  • (3)bbcode_code_printable
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (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