Jump to content
  • 0

Erori la compilare


rAcs

Question

Erorile: 

C:\Users\user\Desktop\rAcs Project\gamemodes\racs.pwn(39) : warning 213: tag mismatch
C:\Users\user\Desktop\rAcs Project\gamemodes\racs.pwn(59) : warning 213: tag mismatch
C:\Users\user\Desktop\rAcs Project\gamemodes\racs.pwn(60) : warning 213: tag mismatch
C:\Users\user\Desktop\rAcs Project\gamemodes\racs.pwn(74) : warning 213: tag mismatch
C:\Users\user\Desktop\rAcs Project\gamemodes\racs.pwn(75) : warning 213: tag mismatch
C:\Users\user\Desktop\rAcs Project\gamemodes\racs.pwn(75) : error 076: syntax error in the expression, or invalid function call
C:\Users\user\Desktop\rAcs Project\gamemodes\racs.pwn(93) : warning 213: tag mismatch
C:\Users\user\Desktop\rAcs Project\gamemodes\racs.pwn(94) : warning 213: tag mismatch
C:\Users\user\Desktop\rAcs Project\gamemodes\racs.pwn(117) : warning 213: tag mismatch
C:\Users\user\Desktop\rAcs Project\gamemodes\racs.pwn(118) : warning 213: tag mismatch
C:\Users\user\Desktop\rAcs Project\gamemodes\racs.pwn(126) : warning 213: tag mismatch
C:\Users\user\Desktop\rAcs Project\gamemodes\racs.pwn(127) : warning 213: tag mismatch
C:\Users\user\Desktop\rAcs Project\gamemodes\racs.pwn(149) : error 017: undefined symbol "cache_get_field_content_int"
C:\Users\user\Desktop\rAcs Project\gamemodes\racs.pwn(150) : error 017: undefined symbol "cache_get_field_content_int"
C:\Users\user\Desktop\rAcs Project\gamemodes\racs.pwn(152) : error 017: undefined symbol "cache_get_field_content"
C:\Users\user\Desktop\rAcs Project\gamemodes\racs.pwn(153) : error 017: undefined symbol "cache_get_field_content"
C:\Users\user\Desktop\rAcs Project\gamemodes\racs.pwn(154) : error 017: undefined symbol "cache_get_field_content"
Pawn compiler 3.2.3664	 	 	Copyright (c) 1997-2006, ITB CompuPhase

Linii:

39 - SQL = mysql_connect("localhost", "root", "racs_db", "");
59 - mysql_format(SQL, gQuery, sizeof(gQuery), "SELECT * FROM `users` WHERE `Name`='%s' LIMIT 1", GetName(playerid));
60 - mysql_tquery(SQL, gQuery, "checkAccount", "i", playerid);
74 - mysql_format(SQL, gQuery, sizeof(gQuery), "INSERT INTO 'users' ('Name', 'Password') VALUES ('%s', '%s')", GetName(playerid), inputtext);
75 - mysql_tquery(SQL, gQuery, insertAccount, "i" , playerid);
93 - mysql_format(SQL, gQuery, sizeof(gQuery), "UPDATE 'users' SET 'Email'='%s' WHERE 'ID'='%d'", inputtext, PlayerInfo[playerid][pSQLID]);
94 - mysql_tquery(SQL, gQuery, "", "");
117 - mysql_format(SQL, gQuery, sizeof(gQuery), "UPDATE 'users' SET 'Gender'='%d' WHERE 'ID'='%d'", PlayerInfo[playerid][pGender], PlayerInfo[playerid][pSQLID]);
118 - mysql_tquery(SQL, gQuery, "", "");
126 - mysql_format(SQL, gQuery, sizeof(gQuery), "SELECT * FROM `users` WHERE `Name`='%s' AND 'Password'='%s' LIMIT 1", GetName(playerid), inputtext);
127 - mysql_tquery(SQL, gQuery, "onLogin", "i", playerid);
149 - PlayerInfo[playerid][pSQLID] = cache_get_field_content_int(0, "ID");
150 - PlayerInfo[playerid][pGender] = cache_get_field_content_int(0, "Gender");
152 - cache_get_field_content(0, "Name", result); format(PlayerInfo[pName], MAX_PLAYER_NAME, result);
153 - cache_get_field_content(0, "Password", result); format(PlayerInfo[pPassword], 32, result);
154 - cache_get_field_content(0, "Email", result); format(PlayerInfo[pEmail], 32, result);

De la 39 pana la 127 presupun ca greseala vine de la SQL?

La restul nu stiu de ce.

Link to comment
Share on other sites

8 answers to this question

Recommended Posts

  • 0
6 minutes ago, Banditul said:

Din cate vad scriptul este facut cu mysql r39 dar tu in pawno > includes ai mysql r40+

https://github.com/pBlueG/SA-MP-MySQL/releases/tag/R39-6

Asta daca nu cumva incerci sa faci update la mysql r40+

Asta sa fie problema? Nu am crezut ca poate afecta faptul ca am r40+ si comenzile difera. 

Intr-adevar ai dreptate. 

Edited by rAcs
Link to comment
Share on other sites

  • 0
Just now, Banditul said:

Din pacate maddinat0r a schimbat numele functilor, sintaxa si alte cateva lucruri in versiunea r40

Intrebare: Este mai bun r40+ decat r39.6?

EDIT: Am bagat r39, iar acum am doar o eroare. 

error 076: syntax error in the expression, or invalid function call

mysql_tquery(SQL, gQuery, insertAccount, "i" , playerid);

Link to comment
Share on other sites

  • 0
Acum 20 minute, rAcs a spus:

Intrebare: Este mai bun r40+ decat r39.6?

EDIT: Am bagat r39, iar acum am doar o eroare. 

error 076: syntax error in the expression, or invalid function call

mysql_tquery(SQL, gQuery, insertAccount, "i" , playerid);

mysql_tquery(SQL, gQuery, "insertAccount", "i" , playerid);

Si functia trebuie sa fie intre apostrof

Daca nu vei folosi ce scrie la new features atunci nu ai nevoie de update https://github.com/pBlueG/SA-MP-MySQL/releases/tag/R40

Eu unul gasec mai usor de lucrat cu mysql r40, mi se pare mai curat la partea in care folosesc cache_get_value_name pentru ca pentru  int/float nu mai trebuie sa faci

new int = cache_get_content_int(row, "int");

acum faci asta

new int;
cache_get_value_name(row, "int", int);

Ceea ce mi se pare mai clar

  • Like 1
Link to comment
Share on other sites

  • 0
5 minutes ago, Banditul said:

Si funcția trebuie să fie între apostrof

Dacă nu vei folosi ce scrie la noile caracteristici atunci nu ai nevoie de actualizare  https://github.com/pBlueG/SA-MP-MySQL/releases/tag/R40

Eu unul gasec mai ușor de lucrat cu mysql r40, mi se pare mai curat la partea în care folosesc cache_get_value_name ca pentru int / float nu mai trebuie să faci

acum faci asta

Ceea ce mi se pare mai clar

Multumesc frumos. Pe linkul tau pot vedea si trecerea de la vechile comenzi la noile?

Link to comment
Share on other sites

  • 0
Acum 5 minute, rAcs a spus:

Multumesc frumos. Pe linkul tau pot vedea si trecerea de la vechile comenzi la noile?

http://forum.sa-mp.com/showthread.php?t=616103

Asta e topicul pe care l-am folosit drept referinta pentru update

http://wiki.sa-mp.com/wiki/MySQL

http://wiki.sa-mp.com/wiki/MySQL/R33

Deasemenea aceste 2 linkuri de wiki pentru a stii ce face functia si sa ii caut echivalentul (sa fie mai usor la update) 

Edit: Aici ai un exemplu de login/register: https://github.com/pBlueG/SA-MP-MySQL/blob/master/example_scripts/login_system-cache.pwn

Edited by Banditul
  • Like 1
Link to comment
Share on other sites

  • 0
Acum 43 minute, Banditul a spus:

http://forum.sa-mp.com/showthread.php?t=616103

Asta e subiectul pe care l-am folosit drept referinta pentru actualizare

http://wiki.sa-mp.com/wiki/MySQL

http://wiki.sa-mp.com/wiki/MySQL/R33

Deasemenea aceste 2 linkuri de wiki pentru a afla ce fac functia si sa caute echivalentul (sa fie mai usor la actualizare) 

Editați: Aici aveți un exemplu de conectare / înregistrare:  https://github.com/pBlueG/SA-MP-MySQL/blob/master/example_scripts/login_system-cache.pwn

Multumesc frumos de ajutor.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. For more details you can also review our Terms of Use and Privacy Policy.