question about scripts

[xrein]

is there a script that allow me to connect to database so that i can select all data i need then display it on the npc??

 

thanks

 

---

im planning to make a npc that use @slaveclone then slaveclone all existing characters on the database

[Euphy]

Query_sql

[xrein]

thanks for the fast reply, but what is the use of the next variables after the sql query??

here is my code, but when i clicked my npc it wont talk haha

 

 

    set .@nb, query_sql("SELECT `name`, `account_id` FROM `char` ORDER BY `account_id` ASC LIMIT 5", .@name$, .@account_id);

    mes "[Character List]";

    for(set .@i,1; .@i <= .@nb; set .@i,.@i+1){

        mes .@i+". "+.@name$[0]+" ("+.@account_id[0]+")";

    }

[Capuche]

The first value start at index 0 to index ( .@nb - 1 ) in yours variables so you need

for(set .@i,0; .@i < .@nb; set .@i,.@i+1){
	mes (.@i+1)+". "+.@name$[.@i]+" ("+.@account_id[.@i]+")";
}

[xrein]

wow, thanks sir capuche

 

how about dynamic menu??

is it possible to make a dynamic menu using for loop?

[Capuche]

A menu to select one name?

for(set .@i,0; .@i < .@nb; set .@i,.@i+1){
	mes (.@i+1)+". "+.@name$[.@i]+" ("+.@account_id[.@i]+")";
	.@menu$ = .@menu$ + "+.@name$[.@i]+" ("+.@account_id[.@i]+"):";
}
.@s = select( .@menu$ ) -1;