[GameMode] Finest Freeroam [MySql]
#17

Sorry About that just save this to GlobalVar.inc
pawn Код:
#include <a_samp>
#include <a_mysql>
forward IsPlayerServerAdmin(playerid); //Checks if the player's admin level is 1 or more
forward IsPlayerServerLevel(playerid, levelneeded); //Checks if the player's admin level is equal to or more then what is requested
forward IsPlayerInJail(playerid); //Checks if the player is jailed
//forward DoesPlayerHaveRank(playerid, rank); //Checks if a player has more then or equal to a rank required

public IsPlayerServerAdmin(playerid)
{
    new pname[MAX_PLAYER_NAME];
    GetPlayerName(playerid, pname, sizeof(pname));
    new ename[24];
    mysql_real_escape_string(pname, ename);
    new adl, retr[150];
    format(retr, sizeof(retr), "SELECT Level FROM accounts WHERE Username='%s'", ename);
    mysql_query(retr);
    mysql_store_result();
    adl = mysql_fetch_int();
    mysql_free_result();
    if(adl >= 1) return true;
    else return false;
}
public IsPlayerServerLevel(playerid, levelneeded)
{
    new pname[MAX_PLAYER_NAME];
    GetPlayerName(playerid, pname, sizeof(pname));
    new ename[24];
    mysql_real_escape_string(pname, ename);
    new adl, retr[150];
    format(retr, sizeof(retr), "SELECT Level FROM accounts WHERE Username='%s'", ename);
    mysql_query(retr);
    mysql_store_result();
    adl = mysql_fetch_int();
    mysql_free_result();
    if(adl >= levelneeded) return true;
    else return false;
}
public IsPlayerInJail(playerid)
{
    new pname[MAX_PLAYER_NAME];
    GetPlayerName(playerid, pname, sizeof(pname));
    new ename[24];
    mysql_real_escape_string(pname, ename);
    new jld, retr[150];
    format(retr, sizeof(retr), "SELECT Jailed FROM accounts WHERE Username='%s'", ename);
    mysql_query(retr);
    mysql_store_result();
    jld = mysql_fetch_int();
    mysql_free_result();
    if(jld >= 1) return true;
    else return false;
}
Reply


Messages In This Thread
Finest Freeroam [MySql] - by [WF]Demon - 28.12.2010, 23:44
Re: Finest Freeroam [MySql] - by Retardedwolf - 28.12.2010, 23:49
Re: Finest Freeroam [MySql] - by CompSpud - 28.12.2010, 23:56
Re: Finest Freeroam [MySql] - by [WF]Demon - 29.12.2010, 00:17
Re: Finest Freeroam [MySql] - by TheArcher - 29.12.2010, 00:38
Re: Finest Freeroam [MySql] - by marmigs - 29.12.2010, 11:39
Re: Finest Freeroam [MySql] - by (LifeStealeR) - 29.12.2010, 17:49
Re: Finest Freeroam [MySql] - by [WF]Demon - 29.12.2010, 17:54
Re: Finest Freeroam [MySql] - by marmigs - 30.12.2010, 10:17
Re: Finest Freeroam [MySql] - by HyperZ - 30.12.2010, 11:12
Re: Finest Freeroam [MySql] - by Zh3r0 - 30.12.2010, 12:20
Re: Finest Freeroam [MySql] - by FreshDoubleX - 30.12.2010, 12:53
Re: Finest Freeroam [MySql] - by Calgon - 30.12.2010, 12:54
Re: Finest Freeroam [MySql] - by TheRob - 30.12.2010, 13:23
Re: Finest Freeroam [MySql] - by [WF]Demon - 31.12.2010, 03:09
Re: Finest Freeroam [MySql] - by kamalhood - 31.12.2010, 09:27
Re: Finest Freeroam [MySql] - by [WF]Demon - 31.12.2010, 18:55
Re: Finest Freeroam [MySql] - by Noss* - 31.12.2010, 19:00
Re: Finest Freeroam [MySql] - by scottygraham1990 - 01.01.2011, 19:18
Re: Finest Freeroam [MySql] - by GooMan - 01.01.2011, 23:13
Re: Finest Freeroam [MySql] - by Greenpiece - 01.01.2011, 23:14
Re: Finest Freeroam [MySql] - by [WF]Demon - 07.01.2011, 01:45
Re: Finest Freeroam [MySql] - by Greenpiece - 08.01.2011, 03:49
Re: Finest Freeroam [MySql] - by BASITJALIL - 11.03.2011, 07:49
Re: Finest Freeroam [MySql] - by [WF]Demon - 11.03.2011, 07:53
Re: Finest Freeroam [MySql] - by Ironboy - 11.03.2011, 08:01
Re: Finest Freeroam [MySql] - by BASITJALIL - 11.03.2011, 08:11
Re: Finest Freeroam [MySql] - by Markx - 11.03.2011, 08:37
Re: Finest Freeroam [MySql] - by [WF]Demon - 11.03.2011, 09:15

Forum Jump:


Users browsing this thread: 1 Guest(s)