I know that this topic has been asked alot. I do have 0 base knowledge about SQL except for the fact that I know SQL stores server data like string, integer variables and etc. I want to know a lot more about rA scripting with a mix SQL Query.
For example, I want to add a new table in SQL that handles string variables and the new SQL Table will be called in scripts to check if the string variable is already in use.
---------------------------------------
*query_sql("your MySQL query"{, <array variable>{, <array variable>{, ...}}});
*query_logsql("your MySQL query"{, <array variable>{, <array variable>{, ...}}});
Executes an SQL query. A 'select' query can fill array variables with up to 128 rows of values,
and will return the number of rows (i.e. array size).
Note that 'query_sql' runs on the main database while 'query_logsql' runs on the log database.
Example:
set @nb, query_sql("select name,fame from `char` ORDER BY fame DESC LIMIT 5", @name$, @fame);
mes "Hall Of Fame: TOP5";
mes "1."+@name$[0]+"("+@fame[0]+")"; // Will return a person with the biggest fame value.
mes "2."+@name$[1]+"("+@fame[1]+")";
mes "3."+@name$[2]+"("+@fame[2]+")";
mes "4."+@name$[3]+"("+@fame[3]+")";
mes "5."+@name$[4]+"("+@fame[4]+")";
---------------------------------------
I have read that part in the script_commands.txt but I want to see more examples. Thank you.
Question
arzzzae
I know that this topic has been asked alot. I do have 0 base knowledge about SQL except for the fact that I know SQL stores server data like string, integer variables and etc. I want to know a lot more about rA scripting with a mix SQL Query.
For example, I want to add a new table in SQL that handles string variables and the new SQL Table will be called in scripts to check if the string variable is already in use.
I have read that part in the script_commands.txt but I want to see more examples. Thank you.Link to comment
Share on other sites
14 answers to this question
Recommended Posts