Map Checker (No Multi Map)

-   script  NO_MULTI_MAP    FAKE_NPC,{

OnPCLoadMapEvent:
    if(getgmlevel() >= .gm_id){
        end;
    }
    query_sql("SELECT `last_unique_id` FROM `login` WHERE `account_id` = "+getcharid(3)+"",@lud);
    getmapxy @map$,@x,@y,0;
    for (set .@i,0; .@i < getarraysize(.restrictMaps$); set .@i,.@i+1){
        if ( @map$ == .restrictMaps$[.@i] ){
            set @nmp, query_sql "SELECT * FROM `no_multi_map` WHERE `u_id` = `"+ @lud +" AND `hasClient` = 1 AND `mapname` = `"+ @map$+"";
            if(@nmp > 0){
                warp "new_3-1",53,111;
                dispbottom( "[Notice] Multi-Client is not allowed on "+ @map$ +" ", 0xFF6600 );
                end;
            }else if(@nmp == 0){
                query_sql "UPDATE TABLE `no_multi_map` SET `hasClient` = 1, `mapname` = `"+ @map$ +"` WHERE `u_id` = `"+ @lud +";";
                end;
            }else{
                dispbottom( "[Notice] Unknown Error Occured! Please Report this to Administrator.", 0xFF6600 );
                end;
            }
        }
    }
    query_sql "UPDATE TABLE `no_multi_map` SET `hasClient` = 0 WHERE `u_id` = `"+ @lud +" AND `mapname` = `"+ @map$+"";
end;

OnPCLogOutEvent:
    query_sql("SELECT `last_unique_id` FROM `login` WHERE `account_id` = "+getcharid(3)+"",@lud);
    set @nmp, query_sql "SELECT * FROM `no_multi_map` WHERE `u_id` = `"+ @lud +" AND `hasClient` = 1";
    query_sql "UPDATE TABLE `no_multi_map` SET `hasClient` = 0 WHERE `u_id` = `"+ @lud +" AND `mapname` = `"+ @map$+"";
end;

OnInit:
    .gm_id  = 99;
    setarray .restrictMaps$[0],"prontera","geffen";
    query_sql "CREATE TABLE IF NOT EXIST `no_multi_map` (`mapname` TEXT NOT NULL, `u_id` TEXT NOT NULL, `hasClient` UNSIGNED INT NOT NULL) ENGINE=MyISAM";
    end;
}