bBan.inc v2

stock bBan_Check(playerid)
{
new msg[120];
format(msg,sizeof(msg),"SELECT * FROM lbans WHERE Uzbanintas='%s'",pName(playerid));
mysql_query(msg);
mysql_store_result();
 	while(mysql_retrieve_row())
 	{
 	new result[50];
 	mysql_fetch_field_row(result,"Ikikada");
  new time = strval(result);
if(time >= gettime()) {
format(msg,120,"J?s¸ ban baigsis %s",date(time, 1));
SendClientMessage(playerid,-1,msg);
format(msg,120,"Ban prieþastis: %s",b_GautiPriezasti(playerid));
SendClientMessage(playerid,-1,msg);
SetTimerEx("Kickas", 1000, false, "e", playerid);
}
if(time < gettime() )
{
format(msg,sizeof(msg),"DELETE FROM lbans WHERE Uzbanintas='%s'",pName(playerid));
mysql_query(msg);
}
}
return 1;
}

stock b_GautiPriezasti(playerid)
{
new msg[100];
format(msg,sizeof(msg),"SELECT * FROM lbans WHERE Uzbanintas='%s'",pName(playerid));
mysql_query(msg);
mysql_store_result();
 new result[150],priezastis1[150];
 	while(mysql_retrieve_row())
 	{
 	mysql_fetch_field_row(result,"Priezast");
 	format(priezastis1,sizeof(priezastis1),"%s",result);
 	}
 	return priezastis1;
 	}

stock b_Ban(playerid,valandos,priezastis[],bannerID)
{
new time,query[250];
time = gettime() + valandos * 3600;
format(query,300,"INSERT INTO lbans (Uzbanintas,Ikikada,Priezast,Kasban) VALUES ('%s','%d','%s','%s')",pName(playerid),time,priezastis,pName(bannerID));
mysql_query(query);
SetTimerEx("Kickas", 1000, false, "e", playerid);
}
forward Kickas(playerid);
public Kickas(playerid)
{
Kick(playerid);
}

stock date( timestamp, _form=0 )
{
    /*
        ~ convert a Timestamp to a Date.
        ~ 10.07.2009

        date( 1247182451 )  will print >> 09.07.2009-23:34:11
        date( 1247182451, 1) will print >> 09/07/2009, 23:34:11
        date( 1247182451, 2) will print >> July 09, 2009, 23:34:11
        date( 1247182451, 3) will print >> 9 Jul 2009, 23:34
    */
    new year=1970, day=0, month=0, hour=0, mins=0, sec=0;

    new days_of_month[12] = { 31,28,31,30,31,30,31,31,30,31,30,31 };
    new names_of_month[12][10] = {"January","February","March","April","May","June","July","August","September","October","November","December"};
    new returnstring[32];

    while(timestamp>31622400){
        timestamp -= 31536000;
        if ( ((year % 4 == 0) && (year % 100 != 0)) || (year % 400 == 0) ) timestamp -= 86400;
        year++;
    }

    if ( ((year % 4 == 0) && (year % 100 != 0)) || (year % 400 == 0) )
        days_of_month[1] = 29;
    else
        days_of_month[1] = 28;


    while(timestamp>86400){
        timestamp -= 86400, day++;
        if(day==days_of_month[month]) day=0, month++;
    }

    while(timestamp>60){
        timestamp -= 60, mins++;
        if( mins == 60) mins=0, hour++;
    }

    sec=timestamp;

    switch( _form ){
        case 1: format(returnstring, 31, "%02d/%02d/%d %02d:%02d:%02d", day+1, month+1, year, hour, mins, sec);
        case 2: format(returnstring, 31, "%s %02d, %d, %02d:%02d:%02d", names_of_month[month],day+1,year, hour, mins, sec);
        case 3: format(returnstring, 31, "%d %c%c%c %d, %02d:%02d", day+1,names_of_month[month][0],names_of_month[month][1],names_of_month[month][2], year,hour,mins);

        default: format(returnstring, 31, "%02d.%02d.%d-%02d:%02d:%02d", day+1, month+1, year, hour, mins, sec);
    }

    return returnstring;
}