Jump to content
  • 0

query_sql not working in latest GIT


Dissidia

Question


  • Group:  Members
  • Topic Count:  155
  • Topics Per Day:  0.03
  • Content Count:  535
  • Reputation:   23
  • Joined:  11/19/11
  • Last Seen:  

set .@gotm_register,query_sql("SELECT `points` FROM `gotm` WHERE (`guild_id` = "+.@guild_id+") LIMIT 1",.@gotm_pts);
 
if(.@gotm_register)
query_sql "update `gotm` SET `points`='"+.@gotm_score+"' WHERE `guild_id`='"+.@guild_id+"'";
else
query_sql("insert into gotm (guild_name, guild_id, points) values ('"+.@gotm_gname$+"','"+.@guild_id+"', '"+.@gotm_score+"')");

 

 
after I update my server into latest, this script did not work anymore. what is the changes? please help me thanks..
Edited by Dissidia
Link to comment
Share on other sites

4 answers to this question

Recommended Posts

  • 0

  • Group:  Members
  • Topic Count:  26
  • Topics Per Day:  0.01
  • Content Count:  350
  • Reputation:   43
  • Joined:  09/07/12
  • Last Seen:  

what are you try to achieve here?

Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  155
  • Topics Per Day:  0.03
  • Content Count:  535
  • Reputation:   23
  • Joined:  11/19/11
  • Last Seen:  

I did not post my full script. just that..is there any changes in query_sql in previous commit sir?

Link to comment
Share on other sites

  • 0

  • Group:  Developer
  • Topic Count:  36
  • Topics Per Day:  0.01
  • Content Count:  587
  • Reputation:   431
  • Joined:  01/26/16
  • Last Seen:  

Latest change to query_sql happened 3 days ago in this commit. It changes the command's return value when no data is received.

Seems like your script relies on query_sql's old behavior.

 

How about changing

if(.@gotm_register)

into

if(!.@gotm_register)
Edited by secretdataz
Link to comment
Share on other sites

  • 0

  • Group:  Members
  • Topic Count:  155
  • Topics Per Day:  0.03
  • Content Count:  535
  • Reputation:   23
  • Joined:  11/19/11
  • Last Seen:  

thanks. I will try it sir..

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
Answer this question...

×   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...