how to do SQL Querying

[Ninja]

Just wanna ask how to do SQL Querying. to be specific How to make an SQL Query to get a character's CharID from SQLdb?

help will be very much appreciated.

[Emistry]

well you can refer to this

http://dev.mysql.com/doc/refman/5.0/en/select.html

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

[Ninja]

I see. looking at script.c for query_sql, does it also allow you to write data into it?

like

UPDATE `ragnarok`.`char` SET `name`='Jezznar' WHERE `char_id`='150002';

will this be possible?

[Emistry]

all SQL related stuff is working....

so far i didnt see any of it didnt work....

[Ninja]

alright. and by the way, I was wondering why this was moved in the scripting section? @_@

well, thanks anyway I was supposed to write a separate one for scripting since I also need to know

how to do it in the source side.

and thanks for the answers

[Emistry]

i though you are just requesting this to work in a NPC/Script so i move this to script support..

if you want to do it in source part..

you can refer to some example , ( picked randomly inside the src files )

//Update DB
if( SQL_ERROR == Sql_Query(sql_handle, "UPDATE `%s` SET `online`='1' WHERE `char_id`='%d' LIMIT 1", char_db, char_id) )
 Sql_ShowDebug(sql_handle);

[Ninja]

this really helps. my freakin' VS2010 kinda crashes 9/10 of the time so I had to do the last resort~ and that's ask in the support section.

anyway big thanks!