Select vardas where Pavaduotojas....

[Southland`]

[18:02:43] [DEBUG] mysql_query - connection: 1, query: "SELECT `vardas` FROM `users` WHERE Pavaduotojas = 1", use_cache: true
[18:02:43] [DEBUG] CMySQLQuery::CMySQLQuery() - constructor called
[18:02:43] [DEBUG] CMySQLQuery::Execute[()] - starting query execution
[18:02:43] [DEBUG] CMySQLQuery::Execute[()] - query was successful
[18:02:43] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[18:02:43] [DEBUG] CMySQLHandle::SaveActiveResult - cache saved with ID = 1
[18:02:43] [DEBUG] CMySQLQuery::~CMySQLQuery() - deconstructor called
[18:02:43] [DEBUG] cache_get_field_name - field_index: 0, connection: 1
[18:02:43] [DEBUG] CMySQLResult::GetFieldName - index: '0', name: "vardas"
[18:02:43] [DEBUG] cache_get_row_count - connection: 1

					new pavID[50];
					format(query,400,"SELECT `vardas` FROM `users` WHERE Pavaduotojas = %i", playerDB[playerid][plead]);
	    			new Cache:xData = mysql_query(SQL,query);
	    			format(pavID, 50, "%s", cache_get_field_name( 0, "vardas" ));
					if(cache_get_row_count() == 1){
						new msg[200];
						format(msg, 200, "{ffffff}Ar tikrai norite nušalinti firmos pavaduotoją {FF8000}%s{ffffff} nuo pareigų?", pavID);
						ShowPlayerDialog(playerid, DPULTAS+7, DIALOG_STYLE_MSGBOX, "Pavaduotojo nušalinimas", msg, "Taip", "Atgal");
					}
					else{
						K(playerid, COLOR_RED, "Pavaduotojo šiojo firmoje nėra paskirto.");
					}
					cache_delete( xData );

Plead lygus 1, tiek DB tiek serveryje, o DB Pavaduotojas yra lygus taip pat 1, bet kažkas nenori suveikti.

 

ES^ padejo. AČIŪ

Redaguota Lapkričio 30, 2015, nario fDramblius