[xXNurioXx]

Hola, tengo este problema y no entiendo muy bien como va esto:

Codigo:

Код:

public OnGameModeInit()
{
dbhandle = mysql_connect("localhost","root","samp","******");


}

public OnGameModeExit()
{
	mysql_close();
	return 1;
}

public OnPlayerConnect(playerid)



	new query[512];
	GetPlayerName(playerid,name,sizeof(name));
	format(query,sizeof(query),"INSERT INTO usuarios (name,skin,moeny) VALUES ('%s','%s','%s') ",name,GetPlayerSkin(playerid),GetPlayerMoney(playerid));
	mysql_function_query(dbhandle,query,false,"","");
	return 1;
}

El error:

Код:

C:\Users\root\Desktop\MyPawno\mysql.pwn(54) : error 003: declaration of a local variable must appear in a compound block
C:\Users\root\Desktop\MyPawno\mysql.pwn(58) : error 010: invalid function or declaration
C:\Users\root\Desktop\MyPawno\mysql.pwn(39) : warning 204: symbol is assigned a value that is never used: "dbhandle"
Pawn compiler 3.2.3664	 	 	Copyright © 1997-2006, ITB CompuPhase


2 Errors.

Ayuda por favor

[Swedky]

No sй mucho sobre MySQL, pero sй en dуnde hay errores.

Tu error estб en que la variable 'dbhandle' debes ser creada, y como global. Soluciуn:

pawn Код:

new dbhandle; // Creamos la variable tipo global

public OnGameModeInit()
{
    dbhandle = mysql_connect("localhost","root","samp","******");
    return 1;
}

public OnGameModeExit()
{
    mysql_close();
    return 1;
}

public OnPlayerConnect(playerid)
{ // Aquн te faltу abrir esta llave.
    new query[512];
    GetPlayerName(playerid,name,sizeof(name));
    format(query,sizeof(query),"INSERT INTO usuarios (name,skin,moeny) VALUES ('%s','%s','%s') ",name,GetPlayerSkin(playerid),GetPlayerMoney(playerid));
    mysql_function_query(dbhandle,query,false,"","");
    return 1;
}

[xXNurioXx]

Quote:

Originally Posted by EnzoMetlc No sй mucho sobre MySQL, pero sй en dуnde hay errores. Tu error estб en que la variable 'dbhandle' debes ser creada, y como global. Soluciуn: pawn Код: new dbhandle; // Creamos la variable tipo global public OnGameModeInit() {     dbhandle = mysql_connect("localhost","root","samp","******");     return 1; } public OnGameModeExit() {     mysql_close();     return 1; } public OnPlayerConnect(playerid) { // Aquн te faltу abrir esta llave.     new query[512];     GetPlayerName(playerid,name,sizeof(name));     format(query,sizeof(query),"INSERT INTO usuarios (name,skin,moeny) VALUES ('%s','%s','%s') ",name,GetPlayerSkin(playerid),GetPlayerMoney(playerid));     mysql_function_query(dbhandle,query,false,"","");     return 1; }

ahora me da esto D:

Код:

C:\Users\root\Desktop\MyPawno\mysql.pwn(52) : error 017: undefined symbol "name"
C:\Users\root\Desktop\MyPawno\mysql.pwn(52) : error 017: undefined symbol "name"
C:\Users\root\Desktop\MyPawno\mysql.pwn(52) : error 029: invalid expression, assumed zero
C:\Users\root\Desktop\MyPawno\mysql.pwn(52) : fatal error 107: too many error messages on one line

Compilation aborted.Pawn compiler 3.2.3664	 	 	Copyright © 1997-2006, ITB CompuPhase


4 Errors.

[juandiegox]

Quote:

Originally Posted by xXNurioXx ahora me da esto D: Код: C:\Users\root\Desktop\MyPawno\mysql.pwn(52) : error 017: undefined symbol "name" C:\Users\root\Desktop\MyPawno\mysql.pwn(52) : error 017: undefined symbol "name" C:\Users\root\Desktop\MyPawno\mysql.pwn(52) : error 029: invalid expression, assumed zero C:\Users\root\Desktop\MyPawno\mysql.pwn(52) : fatal error 107: too many error messages on one line Compilation aborted.Pawn compiler 3.2.3664 Copyright © 1997-2006, ITB CompuPhase 4 Errors.

En Esta parte.. reemplazala por este..

pawn Код:

public OnPlayerConnect(playerid)
{ // Aquн te faltу abrir esta llave.
    new query[512], name[MAX_PLAYER_NAME];
    GetPlayerName(playerid,name,sizeof(name));
    format(query,sizeof(query),"INSERT INTO usuarios (name,skin,moeny) VALUES ('%s','%s','%s') ",name,GetPlayerSkin(playerid),GetPlayerMoney(playerid));
    mysql_function_query(dbhandle,query,false,"","");
    return 1;
}

[xXNurioXx]

Quote:

Originally Posted by juandiegox En Esta parte.. reemplazala por este.. pawn Код: public OnPlayerConnect(playerid) { // Aquн te faltу abrir esta llave.     new query[512], name[MAX_PLAYER_NAME];     GetPlayerName(playerid,name,sizeof(name));     format(query,sizeof(query),"INSERT INTO usuarios (name,skin,moeny) VALUES ('%s','%s','%s') ",name,GetPlayerSkin(playerid),GetPlayerMoney(playerid));     mysql_function_query(dbhandle,query,false,"","");     return 1; }

Ok, gracias pero ahora en la base de datos no se crea nada! que pasa? D:

[xXNurioXx]

Ayuda pliz

Vale ya se porque no va, me dice esto: