Smulyz

eroarea 

C:/Users/Hawai/OneDrive/Desktop/GM PRINCIPAL/gamemodes/main.pwn(304) : warning 203: symbol is never used: "setadmin"
Pawn compiler 3.10.10              Copyright (c) 1997-2006, ITB CompuPhase

Header size:           4424 bytes
Code size:           175064 bytes
Data size:         17121792 bytes
Stack/heap size:      16384 bytes; estimated max. usage=1279 cells (5116 bytes)
Total requirements:17317664 bytes

1 Warning.
[Finished in 1.7s]

linia

CMD:setadmin(playerid, params[])
{
    if(PlayerInfo[playerid][pAdmin] < 6)
        return SendClientMessage(playerid, 0xB1BFCC80, "Eroare: Nu ai gradul administrativ necesar.");
    
    new id, admin, string[64];
    if(sscanf(params, "ud", id, admin))
        return SendClientMessage(playerid, 0xB1BFCC80, "SYNTAX: /setadmin <ID/Name> <Admin Level (0-7)>");
    
    if(admin < 0 || admin > 7)
        return SendClientMessage(playerid, -1, "Invalid Admin Level.");
    
    format(string, sizeof(string), "Felicitari! Ai fost promovat la admin %d.", admin);
    SendClientMessage(id, -1, string);
    
    new query[100];
    PlayerInfo[playerid][pAdmin] = admin;
    mysql_format(SQL, query, sizeof(query), "UPDATE `accounts` SET `Admin` = '%d' WHERE `ID` = '%d'", PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][pSQLID]);
    mysql_tquery(SQL, query);
    
    return 1;
}

1 hour ago, Akan said:

Da-mi discord-ul tau ca imi e mai usor sa te ajut asa decat sa las 100 de reply-uri aici.

+1 cel mai de treabă băiat

Smulyz#2726

linia de la cod

mysql_format(SQL, gQuery, 128, "select = from accounts where Name = '%s' limit 1", GetName(playerid));

erorile

C:/Users/Hawai/OneDrive/Desktop/GM PRINCIPAL/gamemodes/main.pwn(111) : warning 236: unknown parameter in substitution (incorrect #define pattern)
C:/Users/Hawai/OneDrive/Desktop/GM PRINCIPAL/gamemodes/main.pwn(111) : warning 236: unknown parameter in substitution (incorrect #define pattern)
C:/Users/Hawai/OneDrive/Desktop/GM PRINCIPAL/gamemodes/main.pwn(111) : error 029: invalid expression, assumed zero
C:/Users/Hawai/OneDrive/Desktop/GM PRINCIPAL/gamemodes/main.pwn(111) : error 029: invalid expression, assumed zero
C:/Users/Hawai/OneDrive/Desktop/GM PRINCIPAL/gamemodes/main.pwn(111) : warning 215: expression has no effect
C:/Users/Hawai/OneDrive/Desktop/GM PRINCIPAL/gamemodes/main.pwn(111) : error 001: expected token: ";", but found "]"
C:/Users/Hawai/OneDrive/Desktop/GM PRINCIPAL/gamemodes/main.pwn(111) : fatal error 107: too many error messages on one line

a k

asa 

new 
   MySQL:SQL, Iterator:playerLogged<MAX_PLAYERS>;
   new gQuery[1024];
 

sau asa

new 
   MySQL:SQL, Iterator:playerLogged<MAX_PLAYERS>;
   
   new gQuery[1024];

?

am pus-o langa

new 
   MySQL:SQL, Iterator:playerLogged<MAX_PLAYERS>;

e bn 

aaaaa gata am aflat

imi poti da exemplu de cum sa o definesc ?
 

8 minutes ago, Akan said:

Linia respectiva trebuie sa arate in felul urmator:

if(mysql_errno(SQL) != 0) print("[MySQL]: Baza de date nu s-a putut conecta cu succes.");

Si inlocuiesti tu SQL cu numele variabilei tale pentru baza de date.

Acum imi da erorile astea 

C:/Users/Hawai/OneDrive/Desktop/GM PRINCIPAL/gamemodes/main.pwn(106) : error 017: undefined symbol "gQuery"
C:/Users/Hawai/OneDrive/Desktop/GM PRINCIPAL/gamemodes/main.pwn(106) : warning 215: expression has no effect
C:/Users/Hawai/OneDrive/Desktop/GM PRINCIPAL/gamemodes/main.pwn(106) : error 001: expected token: ";", but found "]"
C:/Users/Hawai/OneDrive/Desktop/GM PRINCIPAL/gamemodes/main.pwn(106) : error 029: invalid expression, assumed zero
C:/Users/Hawai/OneDrive/Desktop/GM PRINCIPAL/gamemodes/main.pwn(106) : fatal error 107: too many error messages on one line
 

linia de cod|:

gQuery[0] = EOS;

linile de jos

mysql_format(SQL, gQuery, 128, "select = from accounts where Name = '%s' limit 1", GetName(playerid));
    mysql_tquery(SQL, gQuery, "checkAccount", "i", playerid);

linia de cod:

if(mysql_errno(!= 0))(!= 0) print("[MySQL]: Baza de date nu s-a putut conecta cu succes.");

erorile:

C:/Users/Hawai/OneDrive/Desktop/GM PRINCIPAL/gamemodes/main.pwn(85) : error 029: invalid expression, assumed zero
C:/Users/Hawai/OneDrive/Desktop/GM PRINCIPAL/gamemodes/main.pwn(85) : warning 215: expression has no effect
C:/Users/Hawai/OneDrive/Desktop/GM PRINCIPAL/gamemodes/main.pwn(85) : error 001: expected token: ";", but found ")"
C:/Users/Hawai/OneDrive/Desktop/GM PRINCIPAL/gamemodes/main.pwn(85) : error 029: invalid expression, assumed zero
C:/Users/Hawai/OneDrive/Desktop/GM PRINCIPAL/gamemodes/main.pwn(85) : fatal error 107: too many error messages on one line

versiunea mysql r41-4

un tutorial pt comanda /stats explicat bine 

Smulyz#2726

Nu știu sincer, cum pot sa vad

Tot la fel

Așa pusesem la început

 MySQL_format(SQL, gQuery, 128, "select = from accounts where Name = '%s' limit 1", GetName(playerid);
    MySQL_tquery(SQL, gQuery, "checkAccount", "i", playerid);

M am corectat și tot îmi dă aceste erori sau poate am greșit eu îți dau acm ce am corectat

unde pot sa vad ?
 

47 minutes ago, Vicentzo- said:

Salut, arata unde ai definit hande-ul (variabila SQL) , expected tag "MySQL", but found "MySql" aceasta eroare ti-o da probabil ca ai definit in felul urmator

new MySql:SQL // varianta incorecta

new MySQL:SQL // varianta buna

incearca sa te corectezi acolo si vezi ce erori iti mai da

new 
    MySql:SQL, Iterator:playerLogged<MAX_PLAYERS>, gQuery[1024], gString[1024];
daca la asta te referi

Mda am modificat da tot aceleași erorii

SQL = mysql_format("localhost", "root", "", "GM_PRINCIPAL");     {84}

mysql_format(SQL, gQuery, 128, "select = from accounts where Name = '%s' limit 1", GetName((playerid);    {108}
    mysql_tquery(SQL, gQuery, "checkAccount", "i", playerid);     {109}

C:/Users/Hawai/OneDrive/Desktop/GM PRINCIPAL/gamemodes/main.pwn(84) : error 035: argument type mismatch (argument 1)
C:/Users/Hawai/OneDrive/Desktop/GM PRINCIPAL/gamemodes/main.pwn(84) : warning 213: tag mismatch: expected tag "MySql", but found none ("_")
C:/Users/Hawai/OneDrive/Desktop/GM PRINCIPAL/gamemodes/main.pwn(108) : warning 236: unknown parameter in substitution (incorrect #define pattern)
C:/Users/Hawai/OneDrive/Desktop/GM PRINCIPAL/gamemodes/main.pwn(108) : warning 236: unknown parameter in substitution (incorrect #define pattern)
C:/Users/Hawai/OneDrive/Desktop/GM PRINCIPAL/gamemodes/main.pwn(108) : warning 213: tag mismatch: expected tag "MySQL", but found "MySql"
C:/Users/Hawai/OneDrive/Desktop/GM PRINCIPAL/gamemodes/main.pwn(108) : error 029: invalid expression, assumed zero
C:/Users/Hawai/OneDrive/Desktop/GM PRINCIPAL/gamemodes/main.pwn(108) : error 029: invalid expression, assumed zero
C:/Users/Hawai/OneDrive/Desktop/GM PRINCIPAL/gamemodes/main.pwn(108) : warning 215: expression has no effect
C:/Users/Hawai/OneDrive/Desktop/GM PRINCIPAL/gamemodes/main.pwn(108) : error 001: expected token: ";", but found "]"
C:/Users/Hawai/OneDrive/Desktop/GM PRINCIPAL/gamemodes/main.pwn(108) : fatal error 107: too many error messages on one line

Compilation aborted.

Pawn compiler 3.10.10              Copyright (c) 1997-2006, ITB CompuPhase

5 Errors.
[Finished in 939ms]  

fac un sistem de register si login cu o baza de date si vr sa dau compile da nu merge, v-am lasat erorile mai sus daca m-ar putea  ajuta cnv as-i fii recunoscator