SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Plugin Development

Reply
 
Thread Tools Display Modes
Old 06/08/2012, 11:19 AM   #2701
Garsino
Huge Clucker
 
Garsino's Avatar
 
Join Date: Mar 2012
Location: Norway
Posts: 232
Reputation: 116
Default Re: [REL] MySQL Plugin (R7 released)

Can anyone compile this plugin for Debian?
__________________
Garsino is offline   Reply With Quote
Old 06/08/2012, 06:57 PM   #2702
xxmitsu
Gangsta
 
Join Date: Feb 2009
Posts: 629
Reputation: 35
Default Re: [REL] MySQL Plugin (R7 released)

Have you tried http://mirror1.egaming.ro/MySQL/ or http://www.egaming.ro/MySQL/ ?
__________________
aka xanto - Retired - Former eGaming.ro technical staff.
xxmitsu is offline   Reply With Quote
Old 06/08/2012, 09:38 PM   #2703
Garsino
Huge Clucker
 
Garsino's Avatar
 
Join Date: Mar 2012
Location: Norway
Posts: 232
Reputation: 116
Default Re: [REL] MySQL Plugin (R7 released)

Quote:
Originally Posted by xxmitsu View Post
Thanks!! Exactly what I was looking for
__________________
Garsino is offline   Reply With Quote
Old 08/08/2012, 09:55 AM   #2704
andmeida10
High-roller
 
andmeida10's Avatar
 
Join Date: Jan 2010
Location: Aveiro - Portugal
Posts: 1,218
Reputation: 27
Default Re: [REL] MySQL Plugin (R7 released)

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);
__________________
andmeida10 is offline   Reply With Quote
Old 08/08/2012, 10:18 AM   #2705
IstuntmanI
High-roller
 
IstuntmanI's Avatar
 
Join Date: Mar 2009
Posts: 1,641
Reputation: 220
Default Re: [REL] MySQL Plugin (R7 released)

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: http://forum.sa-mp.com/showthread.php?t=337810
2. Your line is too long, divide it in 2 or more lines.
__________________


IstuntmanI is offline   Reply With Quote
Old 08/08/2012, 12:52 PM   #2706
Shiny_David
Huge Clucker
 
Join Date: Jun 2011
Posts: 257
Reputation: 12
Default Respuesta: [REL] MySQL Plugin (R7 released)

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 (c) 1997-2006, ITB CompuPhase


6 Errors.
I compilate with user nemesis script and the include of version R7
__________________
01001110
Shiny_David is offline   Reply With Quote
Old 08/08/2012, 04:21 PM   #2707
Sanady
High-roller
 
Sanady's Avatar
 
Join Date: May 2012
Location: Los Santos
Posts: 1,063
Reputation: 50
Default Re: [REL] MySQL Plugin (R7 released)

Better use older version this new version is sh*t!!
__________________
Sanady is offline   Reply With Quote
Old 08/08/2012, 04:23 PM   #2708
kurta999
Gangsta
 
kurta999's Avatar
 
Join Date: Apr 2009
Location: Alsˇszeli, Hungary
Posts: 921
Reputation: 320
Default Re: [REL] MySQL Plugin (R7 released)

This is not shit, you're shit!
You didn't understood how it works!
kurta999 is online now   Reply With Quote
Old 08/08/2012, 04:30 PM   #2709
Sanady
High-roller
 
Sanady's Avatar
 
Join Date: May 2012
Location: Los Santos
Posts: 1,063
Reputation: 50
Default Re: [REL] MySQL Plugin (R7 released)

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!
__________________
Sanady is offline   Reply With Quote
Old 08/08/2012, 05:52 PM   #2710
IstuntmanI
High-roller
 
IstuntmanI's Avatar
 
Join Date: Mar 2009
Posts: 1,641
Reputation: 220
Default Re: [REL] MySQL Plugin (R7 released)

Quote:
Originally Posted by Sanady View Post
Please stop insulting me!
You insulted first, an awesome work.

MySQL R7 is the best released, it is the fastest (cache), but few bugs left, almost all fixed on R7-2. So shut up. If you don't understand something you don't have to say that that thing is shit.
__________________


IstuntmanI is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Google Project: Glass int3s0 Everything and Nothing 99 26/02/2013 05:22 PM
MySQL Plugin R5 plugin problem dud Scripting Help 12 05/12/2011 07:28 PM
Strikens Mysql vs BlueG's Mysql plugin PrawkC Scripting Help 4 30/09/2011 10:30 AM
[help][plugin] Can't load mysql plugin mariomako Help Archive 8 16/07/2011 02:37 PM
mysql plugin. loading plugin failed ikkentim Help Archive 2 10/02/2011 03:32 PM


All times are GMT. The time now is 11:17 PM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.