Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public OnPlayerConnect(playerid)
- {
- GetPlayerName(playerid, NombreJugador[playerid], MAX_PLAYER_NAME);
- new bool:baneado;
- new bool:desbanear;
- new expire;
- new timestamp;
- new DB_Query[158], Cache:ResultCache_;
- mysql_format(Database, DB_Query, sizeof(DB_Query), "SELECT * FROM bans WHERE name='%s' LIMIT 1",
- NombreJugador[playerid]
- );
- ResultCache_ = mysql_query(Database, DB_Query);
- if(cache_num_rows()){
- timestamp = gettime();
- cache_get_value_name_int(0, "expire", expire);
- if(expire > timestamp){
- baneado = true;
- desbanear = true;
- if(baneado){
- if(desbanear){
- //new DB_Query[159];
- mysql_format(Database, DB_Query, sizeof(DB_Query), "DELETE FROM bans WHERE name='%s'",
- NombreJugador[playerid]
- );
- //mysql_pquery(Database, DB_Query);
- }
- else{
- new faltante = expire - timestamp;
- new secs, mins, hours, days;
- while(faltante > 0){
- if(faltante > 216000){
- days++;
- faltante -= 216000;
- }
- else if(faltante > 3600){
- hours++;
- faltante -= 3600;
- }
- else if(faltante > 60){
- mins++;
- faltante -= 60;
- }
- else{
- secs = faltante;
- }
- }
- new string[144];
- format(string, sizeof(string), "Serás desbaneado en %d días, %d horas, %d minutos, %d segundos", days, hours, mins, secs);
- SendClientMessage(playerid, 0xea0148, string);
- Kick(playerid);
- }
- }
- }
- }
- cache_delete(ResultCache_);
- return 1;
- // Here goes the code of Login / Register
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement