La OnPlayerConnect pune asta [pawn]public OnPlayerConnect(playerid) { new String[300]; new PlayerName[30]; GetPlayerName(playerid,PlayerName,sizeof(PlayerName)); new PlayerIP[30]; GetPlayerIp(playerid,PlayerIP,sizeof(PlayerIP)); format(String,sizeof(String),"SELECT * FROM Bans WHERE Name = '%s' OR IP = '%s'",PlayerName,PlayerIP); DatabaseResult = db_query(Database,String); if(db_num_rows(DatabaseResult)) { db_get_field_assoc(DatabaseResult,"Time",String,10); if(strval(String) > gettime()) { SendClientMessage(playerid,0x999999FF,"You are banned from this server."); db_get_field_assoc(DatabaseResult,"Name",String,30); format(String,sizeof(String),"Name: %s",String); SendClientMessage(playerid,0xFF0000FF,String); db_get_field_assoc(DatabaseResult,"IP",String,30); format(String,sizeof(String),"IP: %s",String); SendClientMessage(playerid,0xFF0000FF,String); db_get_field_assoc(DatabaseResult,"BannerName",String,30); format(String,sizeof(String),"Banner: %s",String); SendClientMessage(playerid,0xFF0000FF,String); db_get_field_assoc(DatabaseResult,"Time",String,10); format(String,sizeof(String),"Time: %s",TB_ConvertTime(strval(String) - gettime())); SendClientMessage(playerid,0xFF0000FF,String); db_get_field_assoc(DatabaseResult,"Reason",String,30); format(String,sizeof(String),"Reason: %s",String); SendClientMessage(playerid,0xFF0000FF,String); db_get_field_assoc(DatabaseResult,"Date",String,30); format(String,sizeof(String),"Date: %s",String); SendClientMessage(playerid,0xFF0000FF,String); db_free_result(DatabaseResult); SendClientMessage(playerid,0x999999FF,"If you want be unbanned before time write request at website www.ecila.ro"); TB_KickPlayer(playerid); return 1; } if(strval(String) < gettime()) { db_free_result(DatabaseResult); format(String,sizeof(String),"DELETE FROM Bans WHERE Name = '%s' OR IP = '%s'",PlayerName,PlayerIP); DatabaseResult = db_query(Database,String); } } db_free_result(DatabaseResult); return 1; }[/pawn] Iar la TB_BanPlayerByID pune asta [pawn]stock TB_BanPlayerByID(BannedID,Time,Reason[],BannerID) { new String[300]; new BannedName[30]; GetPlayerName(BannedID,BannedName,sizeof(BannedName)); new BannedIP[30]; GetPlayerIp(BannedID,BannedIP,sizeof(BannedIP)); new BannerName[30]; GetPlayerName(BannerID,BannerName,sizeof(BannerName)); new Year; new Month; new Day; getdate(Year,Month,Day); new Hour; new Minute; new Second; gettime(Hour,Minute,Second); format(String,sizeof(String),"%02d/%02d/%02d %02d:%02d:%02d",Day,Month,Day,Hour,Minute,Second); if(IsPlayerConnected(BannerID)) { format(String,sizeof(String),"INSERT INTO Bans VALUES('%s','%s','%s','%d','%s','%s')",BannedName,BannedIP,BannerName,Time + gettime(),Reason,String); DatabaseResult = db_query(Database,String); // format(String,sizeof(String),"{33ff33}Player{a3a3a3} %s (ID: %d)\n {33ff33}Has been banned by administrator{ff0015} %s (ID: %d)\n{33ff33} for Days{ff002f} %s.\n{ffff00} Reason: %s",BannedName,BannedID,BannerName,BannerID,TB_ConvertTime(Time),Reason); ClearChat(BannedID); format(String,sizeof(String),"{33ff33}Player{a3a3a3} %s (ID: %d) {33ff33}Has been banned by administrator{ff0015} %s (ID: %d)",BannedName,BannedID,BannerName,BannerID); SendClientMessageToAll(0xFF0000FF, String); format(String,sizeof(String), "{33ff33}for Days{ff002f} %s.", TB_ConvertTime(Time)); SendClientMessageToAll(0xFF0000FF, String); format(String,sizeof(String), "{ffff00}Reason: %s", Reason); SendClientMessageToAll(0xFF0000FF, String); } if(!IsPlayerConnected(BannerID)) { format(String,sizeof(String),"INSERT INTO Bans VALUES('%s','%s','Server','%d','%s','%s')",BannedName,BannedIP,Time + gettime(),Reason,String); DatabaseResult = db_query(Database,String); format(String,sizeof(String),"Player %s (ID: %d) has been banned by Server for Days %s. Reason: %s",BannedName,BannedID,TB_ConvertTime(Time),Reason); format(String,sizeof(String),"{33ff33}Player{a3a3a3} %s (ID: %d) {33ff33}Has been banned by administrator{ff0015} %s (ID: %d)",BannedName,BannedID,BannerName,BannerID); SendClientMessageToAll(0xFF0000FF, String); //format(String,sizeof(String), "{33ff33}for Days{ff002f} %s.{ffff00} Reason: %s", TB_ConvertTime(Time),Reason); } db_free_result(DatabaseResult); TB_KickPlayer(BannedID); return 1; }[/pawn] Si la TB_KickPlayer pune [pawn]stock TB_KickPlayer(playerid) { SetTimerEx("TP_KickPublic", 1000, 0, "d", playerid); }[/pawn]