[Plugin] [REL] MySQL Plugin (Now on github!)

I can not download it. Give me a mirror, plz(Win)
Reply

MIRROR PLEASE! LINK IS BROKEN!!!!!
Reply

Link is not working. If anyone has the file, please do share.
Reply

http://mirror1.egaming.ro/MySQL/ or http://www.egaming.ro/MySQL/
Reply

Again, Hello! Do you run the download link? And then again, I can not download!
Reply

Are you using mysql_format ? There's a known problem with that function in R7-2
Reply

Can I run the R7 on Centos 5? If yes, do provide a plugin compiled on the system.
Reply

pawn Код:
mysql_close()
Above causes the server to hang on Debian, tried both plugins compiled on Debian.. any ideas?
Server needs to be restarted alot, but it cannot with this problem.

(Tested on a wide range of scripts, they all hang)
Reply

I haven't had any of these problems on my test windows server :S
Reply

I just found out the hard way; if you get an unexpected crash during a query, and mysql_log doesn't show it being executed nor does CrashDetect say anything you might want to check the parameters you send to your threaded function. If you have more indentifiers than parameters it crashes (for me).

Example:

pawn Код:
mysql_function_query(dbHandle, szQuery, false, "somethread", "isffff", 0, "blah"); // you miss four float parameters.
Reply

Awesome Dude
Reply

I cant make this work on Centos.

Gamemode connects to the database but after not work..

Dont appear login window and no other command etc...Anyone know how to fix this? My gamemode work win windows but in centos not.

Regards
Reply

Can anyone compile this plugin for Debian?
Reply

Have you tried http://mirror1.egaming.ro/MySQL/ or http://www.egaming.ro/MySQL/ ?
Reply

Quote:
Originally Posted by xxmitsu
View Post
Thanks!! Exactly what I was looking for
Reply

Hi everyone..

When i try to compile in PAWNO, it gives me that:

pawn Code:
MIBLS.pwn(2175) : error 017: undefined symbol "mysql_query"
MIBLS.pwn(4047) : error 017: undefined symbol "mysql_query"

Line of the codes:


pawn Code:
printf("Strlen(MyConnect) = %d", strlen(MyConnect));
    mysql_query(MyConnect);//Line 2175

//------------------------------------------------------


        format(query, sizeof(query), "SELECT IP FROM 'playerdata' WHERE user = '%s' LIMIT 1", pname);
    mysql_query(query);//Line 4047
And it:

pawn Code:
MIBLS.pwn(35236) : error 037: invalid string (possibly non-terminated string)
MIBLS.pwn(35236) : error 017: undefined symbol "INSERT"
MIBLS.pwn(35236) : error 017: undefined symbol "INTO"
MIBLS.pwn(35236) : fatal error 107: too many error messages on one line

The code is:


pawn Code:
new query[900], pname[MAX_PLAYER_NAME];
    GetPlayerName(playerid, pname, sizeof(pname));
    new Numero = 1000 + random(8999);//The next line lis the line 35236 (error line)
    format(query, sizeof(query), "INSERT INTO playerdata (
    user,
    Level,
    Senha,
    Drogas,
    TempoPizza,
    TempoAssaltoCaixa,
    ObtendoMaterial,
    Recarregando,
    Multa,
    Calado,
    Material,
    DetetiveSkill,
    CamSkill,
    SegSkill,
    ChaveCarro,
    Emprego,
    ChaveCasa,
    ChaveEmpresa,
    Isca,
    Alicate,
    LevelPesca,
    Banco,
    Aposta,
    ContEmp,
    TempoSeg,
    Admin,
    AdvSkill,
    MecSkill,
    LixSkill,
    Pena,
    Autorizacao,
    Fianca,
    FiancaOn,
    NP,
    Cargo,
    Membro,
    Preso,
    Matou,
    Morreu,
    Lider,
    Servico,
    Farda,
    Membro,
    Teste,
    FlyLic,
    NauLic,
    PesLic,
    ArmLic,
    CarLic,
    Ooc,
    AdmOoc,
    Tutorial,
    Origem,
    Votou,
    Tiki,
    Skin,
    Entrou,
    Sexo,
    Dolar,
    Telefone,
    Agenda,
    HoraConect,
    Experiencia,
    Bomba,
    PremioC,
    Hosp,
    Ponto,
    TempoJogado,
    VIP,
    Nascer,
    ChaveAlugel,
    ValorAluguel,
    Aviso
    )
    VALUES
    (
    '%s',
    1,
    SHA1('%s'),
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    999,
    0,
    999,
    999,
    0,
    0,
    0,
    500,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    1,
    0,
    10000,
    '%d',
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    999,
    0,
    0)
    "
, pname, passwordstring, Numero);
    mysql_query(query);
Reply

Quote:
Originally Posted by andmeida10
View Post
Hi everyone..

When i try to compile in PAWNO, it gives me that:

pawn Code:
MIBLS.pwn(2175) : error 017: undefined symbol "mysql_query"
MIBLS.pwn(4047) : error 017: undefined symbol "mysql_query"

Line of the codes:


pawn Code:
printf("Strlen(MyConnect) = %d", strlen(MyConnect));
    mysql_query(MyConnect);//Line 2175

//------------------------------------------------------


        format(query, sizeof(query), "SELECT IP FROM 'playerdata' WHERE user = '%s' LIMIT 1", pname);
    mysql_query(query);//Line 4047
And it:

pawn Code:
MIBLS.pwn(35236) : error 037: invalid string (possibly non-terminated string)
MIBLS.pwn(35236) : error 017: undefined symbol "INSERT"
MIBLS.pwn(35236) : error 017: undefined symbol "INTO"
MIBLS.pwn(35236) : fatal error 107: too many error messages on one line

The code is:


pawn Code:
new query[900], pname[MAX_PLAYER_NAME];
    GetPlayerName(playerid, pname, sizeof(pname));
    new Numero = 1000 + random(8999);//The next line lis the line 35236 (error line)
    format(query, sizeof(query), "INSERT INTO playerdata (
    user,
    Level,
    Senha,
    Drogas,
    TempoPizza,
    TempoAssaltoCaixa,
    ObtendoMaterial,
    Recarregando,
    Multa,
    Calado,
    Material,
    DetetiveSkill,
    CamSkill,
    SegSkill,
    ChaveCarro,
    Emprego,
    ChaveCasa,
    ChaveEmpresa,
    Isca,
    Alicate,
    LevelPesca,
    Banco,
    Aposta,
    ContEmp,
    TempoSeg,
    Admin,
    AdvSkill,
    MecSkill,
    LixSkill,
    Pena,
    Autorizacao,
    Fianca,
    FiancaOn,
    NP,
    Cargo,
    Membro,
    Preso,
    Matou,
    Morreu,
    Lider,
    Servico,
    Farda,
    Membro,
    Teste,
    FlyLic,
    NauLic,
    PesLic,
    ArmLic,
    CarLic,
    Ooc,
    AdmOoc,
    Tutorial,
    Origem,
    Votou,
    Tiki,
    Skin,
    Entrou,
    Sexo,
    Dolar,
    Telefone,
    Agenda,
    HoraConect,
    Experiencia,
    Bomba,
    PremioC,
    Hosp,
    Ponto,
    TempoJogado,
    VIP,
    Nascer,
    ChaveAlugel,
    ValorAluguel,
    Aviso
    )
    VALUES
    (
    '%s',
    1,
    SHA1('%s'),
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    999,
    0,
    999,
    999,
    0,
    0,
    0,
    500,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    1,
    0,
    10000,
    '%d',
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    0,
    999,
    0,
    0)
    "
, pname, passwordstring, Numero);
    mysql_query(query);
1. mysql_query has been changed to mysql_function_query, check the syntax, also, there is a tutorial: https://sampforum.blast.hk/showthread.php?tid=337810
2. Your line is too long, divide it in 2 or more lines.
Reply

i have a six errors:
Quote:

C:\Users\David\Instaladores\GTA_SAN_ANDREAS\Samp Server\gamemodes\ClanArcade.pwn(174) : error 017: undefined symbol "mysql_query_callback"
C:\Users\David\Instaladores\GTA_SAN_ANDREAS\Samp Server\gamemodes\ClanArcade.pwn(18 : error 017: undefined symbol "mysql_query_callback"
C:\Users\David\Instaladores\GTA_SAN_ANDREAS\Samp Server\gamemodes\ClanArcade.pwn(573) : error 017: undefined symbol "mysql_fetch_int"
C:\Users\David\Instaladores\GTA_SAN_ANDREAS\Samp Server\gamemodes\ClanArcade.pwn(676) : error 017: undefined symbol "mysql_query_callback"
C:\Users\David\Instaladores\GTA_SAN_ANDREAS\Samp Server\gamemodes\ClanArcade.pwn(685) : error 017: undefined symbol "mysql_query_callback"
C:\Users\David\Instaladores\GTA_SAN_ANDREAS\Samp Server\gamemodes\ClanArcade.pwn(69 : error 017: undefined symbol "mysql_query"
Pawn compiler 3.2.3664 Copyright © 1997-2006, ITB CompuPhase


6 Errors.

I compilate with user nemesis script and the include of version R7
Reply

Better use older version this new version is sh*t!!
Reply

Quote:
Originally Posted by kurta999
View Post
This is not shit, you're shit!
You didn't understood how it works!
Please stop insulting me!
Reply


Forum Jump:


Users browsing this thread: 3 Guest(s)