Help in adding Query SQL

[Jedzkie]

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]

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