_Dynosawr_ Posted June 7, 2012 Group: Members Topic Count: 11 Topics Per Day: 0.00 Content Count: 69 Reputation: 10 Joined: 05/14/12 Last Seen: June 26, 2012 Share Posted June 7, 2012 (edited) Hey, I wrote this script and the query_sql command isn't working correctly. I hope someone knows what's wrong with it. http://pastebin.com/raw.php?i=ZSF9Dfrw Edited June 7, 2012 by Joey Quote Link to comment Share on other sites More sharing options...
en_dev Posted June 7, 2012 Group: Members Topic Count: 7 Topics Per Day: 0.00 Content Count: 113 Reputation: 5 Joined: 06/06/12 Last Seen: December 25, 2013 Share Posted June 7, 2012 try this, query_sql "UPDATE `char` SET `name` = '"+.@newname$+"' WHERE `char_id` = '"+getcharid(0)+"'"; Quote Link to comment Share on other sites More sharing options...
_Dynosawr_ Posted June 7, 2012 Group: Members Topic Count: 11 Topics Per Day: 0.00 Content Count: 69 Reputation: 10 Joined: 05/14/12 Last Seen: June 26, 2012 Author Share Posted June 7, 2012 OMG I LOVE YOU! THANKS <33333333 PS: That means it worked. Quote Link to comment Share on other sites More sharing options...
en_dev Posted June 7, 2012 Group: Members Topic Count: 7 Topics Per Day: 0.00 Content Count: 113 Reputation: 5 Joined: 06/06/12 Last Seen: December 25, 2013 Share Posted June 7, 2012 oh ahaha, np. It was just a guess, lol ;P Quote Link to comment Share on other sites More sharing options...
GreenBox Posted June 7, 2012 Group: Members Topic Count: 9 Topics Per Day: 0.00 Content Count: 303 Reputation: 101 Joined: 11/13/11 Last Seen: October 11, 2023 Share Posted June 7, 2012 Just to explain, you can use backticks(`) only to escape object names(tables, columns, etc). You must use quote(') for strings 1 Quote Link to comment Share on other sites More sharing options...
_Dynosawr_ Posted June 8, 2012 Group: Members Topic Count: 11 Topics Per Day: 0.00 Content Count: 69 Reputation: 10 Joined: 05/14/12 Last Seen: June 26, 2012 Author Share Posted June 8, 2012 Ahhh okay, thanks Quote Link to comment Share on other sites More sharing options...
Question
_Dynosawr_
Hey, I wrote this script and the query_sql command isn't working correctly. I hope someone knows what's wrong with it.
http://pastebin.com/raw.php?i=ZSF9Dfrw
Edited by JoeyLink to comment
Share on other sites
5 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.