yes, you can do some sort of trick, though, running query_sql repeatedly might eats your server resources
I don't really recommend though
- script kdhfksfjs FAKE_NPC,{
OnInit:
query_sql "create table if not exists disconnect_char( account_id int(11) primary key, char_id int(11), name varchar(23) ) engine = innodb;";
while ( true ) {
.@nb = query_sql( "select * from disconnect_char", .@aid, .@cid, .@name$ );
for ( .@i = 0; .@i < .@nb; .@i++ ) {
if ( .@aid[.@i] ) {
if ( isloggedin( .@aid[.@i] ) ) {
atcommand "@kick "+ rid2name( .@aid[.@i] );
debugmes "the player AID "+ .@aid[.@i] +" has been kick.";
}
else
debugmes "the player AID "+ .@aid[.@i] +" is not online";
query_sql "delete from disconnect_char where account_id = "+ .@aid[.@i];
}
else if ( .@cid[.@i] ) {
if ( query_sql( "select account_id from `char` where char_id = "+ .@cid[.@i], .@taid ) ) {
if ( isloggedin( .@taid ) ) {
atcommand "@kick "+ rid2name( .@taid );
debugmes "the player CID "+ .@cid[.@i] +" has been kick.";
}
else
debugmes "the player CID "+ .@cid[.@i] +" is not online";
}
else
debugmes "the player CID "+ .@cid[.@i] +" doesn't exist";
query_sql "delete from disconnect_char where char_id = "+ .@cid[.@i];
}
else if ( .@name$[.@i] ) {
if ( query_sql( "select account_id from `char` where name = '"+ escape_sql(.@name$[.@i]) +"'", .@taid ) ) {
if ( isloggedin( .@taid ) ) {
atcommand "@kick "+ rid2name( .@taid );
debugmes "the player name "+ .@name$[.@i] +" has been kick.";
}
else
debugmes "the player name "+ .@name$[.@i] +" is not online";
}
else
debugmes "the player name "+ .@name$[.@i] +" doesn't exist";
query_sql "delete from disconnect_char where name = '"+ escape_sql(.@name$[.@i]) +"'";
}
}
sleep 5000;
}
}..
its inside `vendings` tableand the buffs is `sc_data`