SA-MP Forums Archive
[Plugin] [REL] MySQL Plugin (Now on github!) - 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: Plugin Development (https://sampforum.blast.hk/forumdisplay.php?fid=18)
+--- Thread: [Plugin] [REL] MySQL Plugin (Now on github!) (/showthread.php?tid=56564)

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128

Re: [REL] MySQL Plugin (R7 released) - Zver - 24.07.2012

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

Re: [REL] MySQL Plugin (R7 released) - Tiory099 - 28.07.2012

MIRROR PLEASE! LINK IS BROKEN!!!!!

Re: [REL] MySQL Plugin (R7 released) - Arca - 28.07.2012

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

Re: [REL] MySQL Plugin (R7 released) - xxmitsu - 29.07.2012

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

Re: [REL] MySQL Plugin (R7 released) - Mr_Kent - 30.07.2012

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

Re: [REL] MySQL Plugin (R7 released) - xxmitsu - 03.08.2012

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

Re: [REL] MySQL Plugin (R7 released) - Marv! - 03.08.2012

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

Re: [REL] MySQL Plugin (R7 released) - iTorran - 04.08.2012

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)

Re: [REL] MySQL Plugin (R7 released) - Memoryz - 04.08.2012

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

Re: [REL] MySQL Plugin (R7 released) - playbox12 - 04.08.2012

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.


Re: [REL] MySQL Plugin (R7 released) - KatieNGG - 04.08.2012

Awesome Dude

Re: [REL] MySQL Plugin (R7 released) - misticini - 04.08.2012

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

Re: [REL] MySQL Plugin (R7 released) - Garsino - 06.08.2012

Can anyone compile this plugin for Debian?

Re: [REL] MySQL Plugin (R7 released) - xxmitsu - 06.08.2012

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

Re: [REL] MySQL Plugin (R7 released) - Garsino - 06.08.2012

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

Re: [REL] MySQL Plugin (R7 released) - andmeida10 - 08.08.2012

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


Re: [REL] MySQL Plugin (R7 released) - IstuntmanI - 08.08.2012

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.

Respuesta: [REL] MySQL Plugin (R7 released) - Shiny_David - 08.08.2012

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

Re: [REL] MySQL Plugin (R7 released) - Sanady - 08.08.2012

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

Re: [REL] MySQL Plugin (R7 released) - Sanady - 08.08.2012

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!