[andmeida10]

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