Jump to content
MakeWebGames

Need Help With Items And Create Or Error :-(


gulley

Recommended Posts

:-(

I Keep Getting Them To Errors And No Will Help Me Fix Them :(

Will you help Me Fix Them

Error One Is In Items

When I Try To Use

Med Refils

Or

E Refills

Or Packs

I Get


 QUERY ERROR: You have an error in your SQL syntax; c
heck the manual that corresponds to your MySQL server 
version for the right syntax to use near '= '0' WHERE userid=1' at line 1
Query was UPDATE `users` SET = '0' WHERE userid=1 

Error two Is when i try to create a new user

(e.g) Bot

QUERY ERROR: Column count doesn't match value count at row 1
Query was INSERT INTO users (username, login_name, 
userpass, level, money, shells, crystals, turns, donatordays, 
user_level, energy, maxenergy, will, maxwill, brave, 
maxbrave, hp, maxhp, location, gender, signedup, 
email, bankmoney) VALUES( 'Bot ', 'Bot ', md5('Bot')
, 100, 100, 0, 0, 0, 210, 210, 100, 100, 203, 203, 5050, 5050, 1, 'Male', unix_timestamp(), 'Bot', -1)

If There Is Anyone Out There Is Willing to Help ME :-D

My Email Is

[email protected]

Owner Of www.pimpbattles.com

Thanks

Link to comment
Share on other sites

Re: Need Help With Items And Create Or Error :-(

 

QUERY ERROR: You have an error in your SQL syntax; c
heck the manual that corresponds to your MySQL server 
version for the right syntax to use near '= '0' WHERE userid=1' at line 1
Query was UPDATE `users` SET ?????????= '0' WHERE userid=1 

 

what are you setting to 0 lol

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...