SA-MP Forums Archive
[GameMode] Finest Freeroam [MySql] - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Gamemode Scripts (https://sampforum.blast.hk/forumdisplay.php?fid=71)
+--- Thread: [GameMode] Finest Freeroam [MySql] (/showthread.php?tid=204163)

Pages: 1 2

Finest Freeroam [MySql] - [WF]Demon - 28.12.2010

Deleted.

Re: Finest Freeroam [MySql] - Retardedwolf - 28.12.2010

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

Re: Finest Freeroam [MySql] - CompSpud - 28.12.2010

any more info on the script and features please?

Re: Finest Freeroam [MySql] - [WF]Demon - 29.12.2010

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

Re: Finest Freeroam [MySql] - TheArcher - 29.12.2010

It looks awesome well i'll test it

Re: Finest Freeroam [MySql] - marmigs - 29.12.2010

Can someone put the mysql dump online?

Re: Finest Freeroam [MySql] - (LifeStealeR) - 29.12.2010

awensome . i will take a look.

Re: Finest Freeroam [MySql] - [WF]Demon - 29.12.2010

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

Re: Finest Freeroam [MySql] - marmigs - 30.12.2010

Where I can find the mysql database??

Re: Finest Freeroam [MySql] - HyperZ - 30.12.2010

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)


Re: Finest Freeroam [MySql] - Zh3r0 - 30.12.2010

We are not blind you know...

Re: Finest Freeroam [MySql] - FreshDoubleX - 30.12.2010

Please upload mysql database structure too !

Re: Finest Freeroam [MySql] - Calgon - 30.12.2010

Quote:
Originally Posted by Zh3r0
Посмотреть сообщение
We are not blind you know...
We aren't blind? Oh.

Re: Finest Freeroam [MySql] - TheRob - 30.12.2010

Well done.

Re: Finest Freeroam [MySql] - [WF]Demon - 31.12.2010

Thanks for all your comments and

Quote:

We are not blind you know...
What?

Re: Finest Freeroam [MySql] - kamalhood - 31.12.2010

cannot read from file: "globalvar"

help me...

Re: Finest Freeroam [MySql] - [WF]Demon - 31.12.2010

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


Re: Finest Freeroam [MySql] - Noss* - 31.12.2010

Quote:
Originally Posted by Calgon
Посмотреть сообщение
We aren't blind? Oh.
? What?

Re: Finest Freeroam [MySql] - scottygraham1990 - 01.01.2011

hey there is 2 errors in the script

Re: Finest Freeroam [MySql] - GooMan - 01.01.2011

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