I am creating a script for the server rank first put into it an appearance, most need a command to let this fixed appearance until reset the rank of pvp, even if he exchange hat stays with her.
setlook 4, 3218;
leaves the fixed item until reset the rank again
OnPCLoginEvent: query_sql "SELECT `nome`, `lider` FROM `pvp_arenas` WHERE `lider`= '1'",@nome$,@lider; if(@lider == 1) { query_sql "SELECT `lider` FROM `char` WHERE `name`='"+strcharinfo(0)+"'",@premio; if(@premio == 1) { getitem 665,1; dispbottom "Hii !!!."; query_sql "UPDATE `char` set `lider` = '0'"; setlook 4, 3218; } } end;
I am creating a script for the server rank first put into it an appearance, most need a command to let this fixed appearance until reset the rank of pvp, even if he exchange hat stays with her.
setlook 4, 3218;
leaves the fixed item until reset the rank again
OnPCLoginEvent: query_sql "SELECT `nome`, `lider` FROM `pvp_arenas` WHERE `lider`= '1'",@nome$,@lider; if(@lider == 1) { query_sql "SELECT `lider` FROM `char` WHERE `name`='"+strcharinfo(0)+"'",@premio; if(@premio == 1) { getitem 665,1; dispbottom "Hii !!!."; query_sql "UPDATE `char` set `lider` = '0'"; setlook 4, 3218; } } end;Share this post
Link to post
Share on other sites