Vivi's Item Shop Point System Intagrated Into Lesanes Store Hack

This Hack is a FULL BATTLE HACK now. It has items intregation(swords add to damage) and lesanes store intregation.

This Hack has been Takin off due to Galeforces Rudness. Complain to him. Not me! Read more here: https://vborg.vbsupport.ru/showthrea...678#post297678

[DemiNeo0101]

Originally posted by Apok2002
This seems to be a reoccuring issue. For the following:

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]

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]

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]

Demi:

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]

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]

im getting this error

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]

nvm, i fixed it. didnt realize that under the options it had to be "5" instead of "field5"

[DemiNeo0101]

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:

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:

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]

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]

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.