Author Topic: Cards - Random Item  (Read 13720 times)

Offline Max

Re: Cards - Random Item
« Reply #15 on: March 26, 2007, 08:58:38 pm »
what version of shop and smf are you running? just in case

SMF 1.1.2... Latest version of SMF Shop. 3.0 (Build 12)

Also  'decreased your time online' dosent work either with the joker!
« Last Edit: March 26, 2007, 09:00:09 pm by Max »

Offline inkstains

Re: Cards - Random Item
« Reply #16 on: March 26, 2007, 09:07:39 pm »
that should work umm which code did you use? make sure to use the latest code in the latest post http://www.daniel15.com/forum/index.php/topic,709.msg3843.html#msg3843

Offline jdv

Re: Cards - Random Item
« Reply #17 on: April 10, 2007, 08:36:01 pm »
Database Error
Please try again. If you come back to this error screen, report the error to an administrator.

I bought a CARD on my inventory to try my luck .. but that message showed.

Offline Jen

Re: Cards - Random Item
« Reply #18 on: April 13, 2007, 05:24:52 am »
This installed fine but when I went to use my item, I got this

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE ID_MEMBER = 1' at line 1
File: /home/content/t/h/e/thegame212/html/board/Sources/shop/items/Cards.php
Line: 109



Here is the code on that line

                                       $result = db_query("UPDATE {$db_prefix}members SET totalTimeLoggedIn = totalTimeLoggedIn - {$value1} WHERE ID_MEMBER = {$ID_MEMBER}", __FILE__, __LINE__);



EDIT: Sorry, I figured it out. :)
« Last Edit: April 13, 2007, 12:30:26 pm by Jen »

Offline inkstains

Re: Cards - Random Item
« Reply #19 on: April 13, 2007, 01:27:12 pm »
Database Error
Please try again. If you come back to this error screen, report the error to an administrator.

I bought a CARD on my inventory to try my luck .. but that message showed.

i believe thats an issue with your database not the card item can you confirm?

This installed fine but when I went to use my item, I got this

You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE ID_MEMBER = 1' at line 1
File: /home/content/t/h/e/thegame212/html/board/Sources/shop/items/Cards.php
Line: 109



Here is the code on that line

                                       $result = db_query("UPDATE {$db_prefix}members SET totalTimeLoggedIn = totalTimeLoggedIn - {$value1} WHERE ID_MEMBER = {$ID_MEMBER}", __FILE__, __LINE__);



EDIT: Sorry, I figured it out. :)

what was the answer?

Offline Jen

Re: Cards - Random Item
« Reply #20 on: April 13, 2007, 10:34:58 pm »
It was an interferring mod. I didn't need that mod anyways as it was just a test so I uninstalled it.

Offline David

Re: Cards - Random Item
« Reply #21 on: April 14, 2007, 07:09:20 am »
For future reference what was the mod?

Offline Jen

Re: Cards - Random Item
« Reply #22 on: April 14, 2007, 07:11:21 am »
Oops, thought I posted that..It was the

Users Online Today Mod 1.4.0

Offline perplexed

Re: Cards - Random Item
« Reply #23 on: April 14, 2007, 11:18:06 pm »
I have that mod installed too but mine is giving me no problems with this item :)
Estne volumen in toga, an solum tibi libet me videre?

Offline Jen

Re: Cards - Random Item
« Reply #24 on: April 14, 2007, 11:29:31 pm »
Yeah, not sure, I just did a fresh install of everything and all is well now.

Offline perplexed

Re: Cards - Random Item
« Reply #25 on: April 21, 2007, 06:55:44 pm »
I used this item today and got an error in the log:

8: Undefined variable: cardIs
File: /home/*****/public_html/forum/Sources/shop/items/Cards.php
Line: 102

I got a joker if that helps, seemed to work properly, but just noticed the error
« Last Edit: April 21, 2007, 07:58:34 pm by perplexed »
Estne volumen in toga, an solum tibi libet me videre?

Offline Xarcell

Re: Cards - Random Item
« Reply #26 on: June 13, 2007, 12:03:02 pm »
Nice item...

Offline ShadowStriker

Re: Cards - Random Item
« Reply #27 on: June 16, 2007, 09:43:23 am »
Whats wrong with the code since we cant use it?

Offline ShadowStriker

Re: Cards - Random Item
« Reply #28 on: June 16, 2007, 09:53:55 am »
When you use the item it says "This item requires further input. Please complete the fields below, and then press "Use Item" and there is another use button, and you have to press that for it to work.

Offline David

Re: Cards - Random Item
« Reply #29 on: June 16, 2007, 10:32:36 am »
When you install the item in the shop admin you should fill in some data fields...the error you are discussing is there because you installed the item with those fields empty. You might be able to edit the item and add the missing data via the shop admin...I haven't tried it with this particular item...or you might have to delete it then add it again this time filling in the data fields.