Beda del mySQL

[HJones]

Sveiki, susidūriau su bėda, kurios nemoku paaiškint

[02:26:38] CMySQLHandler::Query(SELECT * FROM `zaidejai` WHERE Vardas = 'Harry_Jones' AND Slaptazodis = 'bybiuostyk' LIMIT 1) - Successfully executed.


[02:26:38] >> mysql_store_result( Connection handle: 1 )


[02:26:38] CMySQLHandler::StoreResult() - Result was stored.


[02:26:38] >> mysql_fetch_field_row( Connection handle: 1 )


[02:26:38] CMySQLHandler::FetchField(Slaptazodis) - You cannot call this function now. (Reason: Fields/Rows are empty.)


[02:26:38] >> mysql_free_result( Connection handle: 1 )


[02:26:38] CMySQLHandler::FreeResult() - Result was successfully free'd.

	if(dialogid == 4){

		if(response){

			new query[128];

			format(query, sizeof(query), "SELECT * FROM `zaidejai` WHERE Vardas = '%s' AND Slaptazodis = '%s' LIMIT 1", getName(playerid), inputtext);

			mysql_query(query);

			mysql_store_result();

			mysql_fetch_field_row(uInfo[playerid][Slaptazodis], "Slaptazodis");

			mysql_free_result();

			if(strcmp(inputtext, uInfo[playerid][Slaptazodis])){

				SendClientMessage(playerid, -1, "{FF0000}PASS OKEY");

			} else{

				SendClientMessage(playerid, -1, "{FF0000}PASS WRONG");				

			}

		}

	}

[Agnius]

Naudok 

 

if (mysql_num_rows()) {

  // password ok

} else {

 // password wrong

}

[manogugas]

Nu neranda tokios eilutės, ir tavo būdu darant tai slaptažodis turėtų būt išvis nekoduojamas, tekstas tiesiog tai nelabai gerai. Nes tu ieškai eilutės su tokiu vardu ir tokiu spaltažodžiu tai, jei jis neteisingas neras tavo eilutės.

[HJones]

Dekui abiems. Bandau prisimint mysql po 8 men tai daug zioplu klaidu darau