[MYSQL][Problema Run Time Eror 19]

[bebras]

...negi pats nematai? Du stulpeliai, du kintamieji, o %s tik vienas.

format(query,sizeof(query),"INSERT INTO `"TABLENAME"` (Vardas,Slaptazodis) VALUES ('%s','%s')",vardas,inputtext);

[SaSkript]

 

...negi pats nematai? Du stulpeliai, du kintamieji, o %s tik vienas.

format(query,sizeof(query),"INSERT INTO `"TABLENAME"` (Vardas,Slaptazodis) VALUES ('%s','%s')",vardas,inputtext);

Žioplumo klaida... Tuoj patestuosiu :X

[SaSkript]

Viskas gerai, bet nei saugoja, nei krauna, visur rodo po 0, nu per mysql, ten kur pinigai, xp = 0.. Kodas:

stock KrautiInfo(playerid)

{

new name[MAX_PLAYER_NAME],query[70];

GetPlayerName(playerid,name,sizeof(name));

format(query,sizeof(query),"SELECT * FROM zaidejai WHERE Vardas = '%s'",name);

mysql_query(query);

mysql_store_result();

if(mysql_num_rows() == 1)

{

GetPlayerPos(playerid,pInfo[playerid][X],pInfo[playerid][Y],pInfo[playerid][Z]);

new tmp[32];

mysql_fetch_field_row(tmp,"ID"); pInfo[playerid][iD] = strval(tmp);

mysql_fetch_field_row(pInfo[playerid][Vardas],"Vardas");

mysql_fetch_field_row(tmp,"Pinigai"); pInfo[playerid][Pinigai]= strval(tmp);

mysql_fetch_field_row(tmp,"Xp"); pInfo[playerid][Xp] = strval(tmp);

mysql_fetch_field_row(tmp,"Darbas"); pInfo[playerid][Darbas] = strval(tmp);

mysql_fetch_field_row(tmp,"Hp"); pInfo[playerid][Hp] = floatstr(tmp);

mysql_fetch_field_row(tmp,"X"); pInfo[playerid][X] = floatstr(tmp);

mysql_fetch_field_row(tmp,"Y"); pInfo[playerid][Y] = floatstr(tmp);

mysql_fetch_field_row(tmp,"Z"); pInfo[playerid][Z] = floatstr(tmp);

}

mysql_free_result();

return 1;

}

 

stock SaugotiInfo(playerid)

{

new query[100];

format(query,sizeof(query),"UPDATE zaidejai SET Pinigai = %d, Xp = %d, Darbas = %d, Hp = %f WHERE ID = %d",

pInfo[playerid][Pinigai],pInfo[playerid][Xp],pInfo[playerid][Darbas],pInfo[playerid][Hp],pInfo[playerid][iD]);

mysql_query(query);

return 1;

}

 

 

[bebras]

O ką log'as byloja?

 

Teorija: tavo kintamieji tušti.

[SaSkript]

O ką log'as byloja?

 

Teorija: tavo kintamieji tušti.

Taip:

[15:34:13] CMySQLHandler::FetchField(ID) - You cannot call this function now. (Reason: Fields/Rows are empty.)

 

[15:34:13] >> mysql_fetch_field_row( Connection handle: 1 )

 

[15:34:13] CMySQLHandler::FetchField(Vardas) - You cannot call this function now. (Reason: Fields/Rows are empty.)

 

[15:34:13] >> mysql_fetch_field_row( Connection handle: 1 )

 

[15:34:13] CMySQLHandler::FetchField(Pinigai) - You cannot call this function now. (Reason: Fields/Rows are empty.)

 

[15:34:14] >> mysql_fetch_field_row( Connection handle: 1 )

 

[15:34:14] CMySQLHandler::FetchField(Xp) - You cannot call this function now. (Reason: Fields/Rows are empty.)

 

[15:34:14] >> mysql_fetch_field_row( Connection handle: 1 )

 

[15:34:14] CMySQLHandler::FetchField(Darbas) - You cannot call this function now. (Reason: Fields/Rows are empty.)

 

[15:34:14] >> mysql_fetch_field_row( Connection handle: 1 )

 

[15:34:14] CMySQLHandler::FetchField(Hp) - You cannot call this function now. (Reason: Fields/Rows are empty.)

 

[15:34:14] >> mysql_fetch_field_row( Connection handle: 1 )

 

[15:34:14] CMySQLHandler::FetchField(X) - You cannot call this function now. (Reason: Fields/Rows are empty.)

 

[15:34:14] >> mysql_fetch_field_row( Connection handle: 1 )

 

[15:34:14] CMySQLHandler::FetchField(Y) - You cannot call this function now. (Reason: Fields/Rows are empty.)

 

[15:34:14] >> mysql_fetch_field_row( Connection handle: 1 )

 

[15:34:14] CMySQLHandler::FetchField(Z) - You cannot call this function now. (Reason: Fields/Rows are empty.)

 

[15:34:14] >> mysql_free_result( Connection handle: 1 )

 

[15:34:14] CMySQLHandler::FreeResult() - Result was successfully free'd.

 

[15:34:19] >> mysql_query( Connection handle: 1 )

 

[15:34:19] CMySQLHandler::Query(UPDATE zaidejai SET Pinigai = 0, Xp = 0, Darbas = 0, Hp = 0.000000 WHERE ID = 0) - Successfully executed.

 

O kaip padaryti, kad nebūtų tušti?

[bebras]

Pats paprasčiausias veiksmas Pawn.. verčių priskyrimas.

pInfo[playerid][Pinigai] = 64741684;
pInfo[playerid][Hp] = 54.0;

[SaSkript]

 

Pats paprasčiausias veiksmas Pawn.. verčių priskyrimas.

pInfo[playerid][Pinigai] = 64741684;
pInfo[playerid][Hp] = 54.0;

O ačiū, patestuosiu rakink tema