Help on 'rand' in Query SQL

[Jedzkie 58]

hi how can I randomly set cash point to my account using query_sql?

 

example:

query_sql ("UPDATE `cash` SET `cash_point` = cash_point + rand(100,1000) WHERE `account_id` = '"+getcharid(3)+"'");

 

if i use the item, this is the error. DB error - Operand should contain 1 column(s)

 

Thanks!

[KirieZ 88]

@@Frost When you run a SELECT query, you must pass variables to store the returned data.

query_sql("SELECT `cash_point` FROM `cash` WHERE `account_id` = "+getcharid(3), .@newCash);dispbottom "Now you have " + .@newCash;

[Garr 117]

query_sql ("UPDATE `cash` SET `cash_point` = " + rand(100,1000) + " WHERE `account_id` = " + getcharid(3));

[evilpuncker 503]

 

query_sql ("UPDATE `cash` SET `cash_point` = " + rand(100,1000) + " WHERE `account_id` = " + getcharid(3));

 

please note that it will just change the current (entire) value to a random amount, instead of increasing it

[Garr 117]

Well, he did say "randomly set", not "randomly increase", thus I changed it accordingly

[Jedzkie 58]

 

 

query_sql ("UPDATE `cash` SET `cash_point` = " + rand(100,1000) + " WHERE `account_id` = " + getcharid(3));

 

please note that it will just change the current (entire) value to a random amount, instead of increasing it

 

actually you're right, i forgot to say that randomly increase, but i already fixed it. Thanks BTW

 

Well, he did say "randomly set", not "randomly increase", thus I changed it accordingly

 

Hi Garr! thanks for the quick response, how about a message to tell how much Points you get?

 

Edit:

NvM I figured it out the message of how many points you get, but I want to add another message that tells what is the total points in your account.

 

example: query_sql("SELECT `cash_point` FROM `cash` WHERE `account_id` = "+getcharid(3));

 

is this right? i have a error message after executing this script. 'script:query_sql: Too many columns. discarding last 1 columns.'

Edited September 2, 2015 by Frost

[Jedzkie 58]

 

@@Frost When you run a SELECT query, you must pass variables to store the returned data.

query_sql("SELECT `cash_point` FROM `cash` WHERE `account_id` = "+getcharid(3), .@newCash);dispbottom "Now you have " + .@newCash;

 

Thanks!