destroyer555

Re: [mc code V2]Updated Lottery Great mod! +1 from me :-)

Re: problem when selling items my items are screwed up badly when i try to buy an item from the market i get this aswell :cry: QUERY ERROR: 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 'FROM `itemmarket` im LEFT JOIN `items` i ' at line 3 Query was SELECT `imID`,`imITEM`,`imADDER`,`imPRICE`,`imCURRENCY`, FROM `itemmarket` im LEFT JOIN `items` i ON i.itmid = 0 WHERE imID = 79

Re: problem when selling items so what should i put instead and in which query in itemselllogs?

when i sell items i get this You sold 1000 Small Medikit(s) for $300000QUERY ERROR: 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 'orange'>Small Medikit(s) for $300000')' at line 4 Query was INSERT INTO itemselllogs (isID,isUSER,isITEM,isTOTALPRICE,isQTY,isTIME,isCONTENT) VALUES ('', 1, 12, 300000, 1000, unix_timestamp(),'Alex sold 1000 Small Medikit(s) for $300000')

Re: problem creating new shops fixed now thanks

Re: problem creating new shops what? i dont understand anything about query codes :|

Re: problem creating new shops so can you give me the code to put please?

Re: problem creating new shops do u mean this? Field Type Collation Attributes Null Default Extra Action shopID int(11) No auto_increment Browse distinct values Change Drop Primary Unique Index Fulltext shopLOCATION int(11) No 0 Browse distinct values Change Drop Primary Unique Index Fulltext shopNAME varchar(255) latin1_swedish_ci No Browse distinct values Change Drop Primary Unique Index Fulltext shopDESCRIPTION text latin1_swedish_ci No Browse distinct values Change Drop Primary Unique Index Fulltext   sorry i dont know anything about tables :oops:

Re: problem creating new shops done can someone help now please? :oops:

i own a v2 game and i after i added a new city i went to add a new shop but it wouldnt let me it showed this error QUERY ERROR: Column count doesn't match value count at row 1 Query was INSERT INTO shops VALUES('',6,'test','test',0) please help if you can thanks!