[[WF]Demon]

Deleted.

[Retardedwolf]

Thanks, it could teach me a good deal of MySQL.

[CompSpud]

any more info on the script and features please?

[[WF]Demon]

Updated the first post, please redownload as i forgot to add in the filterscript for the objects.

[TheArcher]

It looks awesome well i'll test it

[marmigs]

Can someone put the mysql dump online?

[(LifeStealeR)]

awensome . i will take a look.

[[WF]Demon]

Thanks all for your comments, please test it and get back to me!

[marmigs]

Where I can find the mysql database??

[HyperZ]

Server crashing n mysql error

Quote:

[04:26:54] --------------------------- [04:26:54] MySQL Debugging activated (12/30/10) [04:26:54] --------------------------- [04:26:54] [04:26:54] >> mysql_close( Connection handle: 1 ) [04:26:54] CMySQLHandler::~CMySQLHandler() - deconstructor called. [04:26:54] CMySQLHandler::FreeResult() - There is nothing to free (Reason: Connection is dead) [04:26:54] CMySQLHandler:isconnect() - You cannot call this function now. (Reason: Connection is dead)

[Zh3r0]

We are not blind you know...

[FreshDoubleX]

Please upload mysql database structure too !

[Calgon]

Quote:

Originally Posted by Zh3r0 We are not blind you know...

We aren't blind? Oh.

[TheRob]

Well done.

[[WF]Demon]

Thanks for all your comments and

Quote:

We are not blind you know...

What?

[kamalhood]

cannot read from file: "globalvar"

help me...

[[WF]Demon]

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;
}

[Noss*]

Quote:

Originally Posted by Calgon We aren't blind? Oh.

? What?

[scottygraham1990]

hey there is 2 errors in the script

[GooMan]

Filterscript acars?

No Errors in Script but:

Quote:

-------------------------- SA-MP Server: 0.3c Exception At Address: 0x004A2D7B Registers: EAX: 0x0017FD68 EBX: 0x055828DC ECX: 0x00000000 EDX: 0x00405910 ESI: 0x00000000 EDI: 0x02551278 EBP: 0x0017FD78 ESP: 0x0017FD50 EFLAGS: 0x00010286 Stack: +0000: 0x02551278 0x02551278 0x055828DC 0xFFFFFFFF +0010: 0x0017FD50 0x0017F940 0x0017FEA4 0x004A6BC4 +0020: 0x004C1208 0xFFFFFFFF 0x05583CC0 0x0040591D +0030: 0x00000000 0x00401096 0x02551278 0x0659E3C0 +0040: 0x055DAFB4 0x00402BB3 0x02551278 0x0000000B +0050: 0x0017FDB8 0x0659E3C0 0x040CE230 0x00000000 +0060: 0x00000000 0x02551278 0x00000000 0x00FC3408 +0070: 0x00FC340C 0x00FC386C 0x00081470 0x00FC3418 +0080: 0x00081470 0x055828DC 0x055DAFB4 0x00000000 +0090: 0x05580020 0x000586D8 0x00490BAA 0x02551278 +00A0: 0x0017FE18 0x00000008 0x02608E08 0x77800C79 +00B0: 0x3BBFFB8E 0x024F0F40 0x040CE230 0x00000008 +00C0: 0x024F0F40 0x040CE250 0x000001F4 0x0049B994 +00D0: 0x00000005 0x778011C6 0x77801661 0x00000000 +00E0: 0x3BBFFB8E 0x0049820C 0x00000000 0x00001771 +00F0: 0x0017FF88 0x7EFDE000 0x0000E000 0x00010100 +0100: 0x000001F4 0x00001E61 0x000000C8 0x00001224 +0110: 0x02608E08 0x656D6167 0x65646F6D 0x00003531 +0120: 0x004CA014 0x004CA010 0x7EFDE000 0x004B4C90 +0130: 0x0017FE70 0x0017FE6C 0x0017FF78 0x004A6BC4 -------------------------- SA-MP Server: 0.3c Exception At Address: 0x004A2D7B Registers: EAX: 0x0017FD68 EBX: 0x052D2824 ECX: 0x00000000 EDX: 0x00405910 ESI: 0x00000000 EDI: 0x02131278 EBP: 0x0017FD78 ESP: 0x0017FD50 EFLAGS: 0x00010286 Stack: +0000: 0x02131278 0x02131278 0x052D2824 0xFFFFFFFF +0010: 0x0017FD50 0x0017F940 0x0017FEA4 0x004A6BC4 +0020: 0x004C1208 0xFFFFFFFF 0x052D3C08 0x0040591D +0030: 0x00000000 0x00401096 0x02131278 0x0539E6CC +0040: 0x05322540 0x00402BB3 0x02131278 0x0000000B +0050: 0x0017FDB8 0x0539E6CC 0x021DE998 0x00000000 +0060: 0x00000000 0x02131278 0x00000000 0x0007C188 +0070: 0x0007C18C 0x0007C5EC 0x000785F0 0x0007C198 +0080: 0x000785F0 0x052D2824 0x05322540 0x00000000 +0090: 0x052D0020 0x0004FD1C 0x00490BAA 0x02131278 +00A0: 0x0017FE18 0x00000008 0x021D8E08 0x77800C79 +00B0: 0x3BBFFDE6 0x020D0F40 0x021DE998 0x00000008 +00C0: 0x020D0F40 0x021DE9B8 0x000001F4 0x0049B994 +00D0: 0x00000005 0x778011C6 0x77801661 0x00000000 +00E0: 0x3BBFFDE6 0x0049820C 0x00000000 0x00001771 +00F0: 0x0017FF88 0x7EFDE000 0x0000E000 0x00010100 +0100: 0x000001F4 0x00001E61 0x000000C8 0x00000794 +0110: 0x021D8E08 0x656D6167 0x65646F6D 0x00003531 +0120: 0x004CA014 0x004CA010 0x7EFDE000 0x004B4C90 +0130: 0x0017FE70 0x0017FE6C 0x0017FF78 0x004A6BC4 -------------------------- SA-MP Server: 0.3c Exception At Address: 0x004A2D7B Registers: EAX: 0x0017FD68 EBX: 0x05392824 ECX: 0x00000000 EDX: 0x00405910 ESI: 0x00000000 EDI: 0x020D1278 EBP: 0x0017FD78 ESP: 0x0017FD50 EFLAGS: 0x00010286 Stack: +0000: 0x020D1278 0x020D1278 0x05392824 0xFFFFFFFF +0010: 0x0017FD50 0x0017F940 0x0017FEA4 0x004A6BC4 +0020: 0x004C1208 0xFFFFFFFF 0x05393C08 0x0040591D +0030: 0x00000000 0x00401096 0x020D1278 0x0545E6CC +0040: 0x053E2540 0x00402BB3 0x020D1278 0x0000000B +0050: 0x0017FDB8 0x0545E6CC 0x0268E998 0x00000000 +0060: 0x00000000 0x020D1278 0x00000000 0x0007C188 +0070: 0x0007C18C 0x0007C5EC 0x000785F0 0x0007C198 +0080: 0x000785F0 0x05392824 0x053E2540 0x00000000 +0090: 0x05390020 0x0004FD1C 0x00490BAA 0x020D1278 +00A0: 0x0017FE18 0x00000008 0x02688E08 0x77800C79 +00B0: 0x3BC004EE 0x02070F40 0x0268E998 0x00000008 +00C0: 0x02070F40 0x0268E9B8 0x00000000 0x0049B994 +00D0: 0x00000005 0x778011C6 0x77801661 0x00000000 +00E0: 0x3BC004EE 0x0049820C 0x00000000 0x00001771 +00F0: 0x0017FF88 0x7EFDE000 0x0000E000 0x00010100 +0100: 0x000001F4 0x00004BE0 0x000000C8 0x00001224 +0110: 0x02688E08 0x656D6167 0x65646F6D 0x00003531 +0120: 0x004CA014 0x004CA010 0x7EFDE000 0x004B4C90 +0130: 0x0017FE70 0x0017FE6C 0x0017FF78 0x004A6BC4