Help in adding Query SQL

[Jedzkie 58]

Hi!

 

Can someone help me adding sql query in this script? and adding gm menu like adding items on a specific account then logs in my sql who add that item.

 

Thanks!

 

http://pastebin.com/raw.php?i=ULJ8QJTh

[Winterfox 83]

You could checkout the script documentation first before you ask since it is well documented. You can find it here: https://github.com/HerculesWS/Hercules/blob/master/doc/script_commands.txt

 

The answer you are searching for is:

 

*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 (the array size).

 

Note that 'query_sql' runs on the main database while 'query_logsql' runs 

on the log database.

 

Example:

.@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]+")";

Edited June 30, 2015 by Winterfox