mysql darbuotojų atvaizdavimas

[Funkis]

mysql_query("SELECT pName,WorkId,WorkContract,WorkPoints FROM users WHERE WorkId > '0'");
					mysql_store_result();
					new wName[MAX_PLAYER_NAME], jobId, wPoints, wContract, x, resultline[40], str[220], fstr[500], dStatus[20];
					while(mysql_fetch_row_format(resultline))
					{
						sscanf(resultline,"p<|>{ii}s[24]iii",wName, jobId, wContract, wPoints);
						if(player[playerid][pWorkLeader] == jobId)
						{
						    x++;
							if(GetPlayeridMid(wName) != INVALID_PLAYER_ID) { dStatus = "prisijungęs"; } else { dStatus = "atsijunges"; }
							format(str, sizeof(str),"%s %i %s", wName, wPoints, wContract);
							strcat(fstr, str);
						}
					}
					ShowPlayerDialog(playerid,870,DIALOG_STYLE_LIST,"Frakcijos darbuotojai",fstr,"Rinktis","Atgal");
					mysql_free_result();
					return 1;

[11:06:14] CMySQLHandler::Query(SELECT pName,WorkId,WorkContract,WorkPoints FROM users WHERE WorkId > '0') - Successfully executed.

[11:06:14] >> mysql_store_result( Connection handle: 1 )

[11:06:14] CMySQLHandler::StoreResult() - Result was stored.

[11:06:14] >> mysql_fetch_row_format( Connection handle: 1 )

[11:06:14] CMySQLHandler::FetchRow() - Return: Iam_Satan|6|0|1

[11:06:14] >> mysql_fetch_row_format( Connection handle: 1 )

[11:06:14] CMySQLHandler::FetchRow() - Return: Iam_Satans|6|0|0

[11:06:14] >> mysql_fetch_row_format( Connection handle: 1 )

[11:06:14] >> mysql_free_result( Connection handle: 1 )

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

Dialog'as neatsiranda.

[bebras]

Bandei po ciklo išprintint x? 

[Funkis]

0 printina

[bebras]

 

 

Pastebėjau kad tuščios lentelės(no text) nepasirodo.

 

Tiesiog pridėk po ciklo, 

if(!x)
  SendClientMessage(playerid, -1, "Srry, nieko nėra. Try again later.");

[Funkis]

Yup, gaunu zinute, bet mysql su tuo darbo id, kaip ir lyderio esu nustates zaideja, tia kodel man jo neparodo? :?

[bebras]

Pakalbėkime apie sscanf eilutę.

sscanf(resultline,"p<|>{ii}s[24]iii"

Kam tu excludini pirmus du skaičius?  Jei tau jų nereikia, tu jų tiesiog nepasirink. Kiek matau savo užklausoj tu to ir nedarai

[Funkis]

mysql_query("SELECT pName,WorkId,WorkContract,WorkPoints FROM users WHERE WorkId > '0'");

mysql_store_result();

new wName[MAX_PLAYER_NAME], jobId, wPoints, wContract, x, resultline[40], str[220], fstr[500], dStatus[20];

while(mysql_fetch_row_format(resultline))

{

sscanf(resultline,"p<|>s[24]iii",wName, jobId, wContract, wPoints);

if(player[playerid][pWorkLeader] == jobId)

{

x++;

if(GetPlayeridMid(wName) != INVALID_PLAYER_ID) { dStatus = "prisijungæs"; } else { dStatus = "atsijunges"; }

format(str, sizeof(str),"%s %i %s", wName, wPoints, wContract);

strcat(fstr, str);

}

if(!x)

SendClientMessage(playerid, -1, "Srry, nieko nera. Try again later.");

ShowPlayerDialog(playerid,870,DIALOG_STYLE_LIST,"Frakcijos darbuotojai",fstr,"Rinktis","Atgal");

mysql_free_result();

return 1;

Redaguota Sausio 27, 2015, nario Funkis

[bebras]

Sakiau (!x) dėt po ciklu, tokiems atvejams kai nėra duomenų..

 

 

Kokios dabar problemos? Gal tiesiog tavo darbas žaidime netinkamas? Tai yra NE 6?

[Funkis]

 

Tai, kad viskas lyg ir turėtų būti gerai? :?

[bebras]

Dėl šventos ramybės išprintink tiek pakrautą ID tiek savo.

[Funkis]

okay, jau kažkas panašaus, bet mysql yra 2 žaidėjai su 6 workid, rodo tik vieną.

 

Leader id tikrai sutampa su jobid, printinau.

[03:26:56] WORK LEAD ID: 6, JobId: 6

[bebras]

Ir kiek kartų tai išprintina?

 

Kaip dabar kodas atrodo?

[Funkis]

Ir kiek kartų tai išprintina?

 

Kaip dabar kodas atrodo?

case 1:
	            {
             		mysql_query("SELECT pName,WorkId,WorkContract,WorkPoints FROM users WHERE WorkId > '0'");
					mysql_store_result();
					new wName[MAX_PLAYER_NAME], jobId, wPoints, wContract, x, resultline[40], str[220], fstr[500], dStatus[20];
					while(mysql_fetch_row_format(resultline))
					{
						sscanf(resultline,"p<|>s[24]iii",wName, jobId, wContract, wPoints);
						if(player[playerid][pWorkLeader] == jobId)
						{
						    x++;
							if(GetPlayeridMid(wName) != INVALID_PLAYER_ID) { dStatus = "prisijungęs"; } else { dStatus = "atsijunges"; }
							format(str, sizeof(str),"%s, %i, %s		\n", wName, wPoints, likusdata(wContract));
							strcat(fstr, str);
							printf("%s printed worker", wName);
						}
						
						printf("WORK LEAD ID: %i, JobId: %i",player[playerid][pWorkLeader], jobId );
						
						if(!x)
  							SendClientMessage(playerid, -1, "Srry, nieko nera. Try again later.");
  							
						ShowPlayerDialog(playerid,870,DIALOG_STYLE_LIST,"Darbuotojas, įsp. skaičius, liko kontrakto",fstr,"Rinktis","Atgal");
						mysql_free_result();
						return 1;
					}
	            }

[03:26:56] Iam_Satan printed worker
[03:26:56] WORK LEAD ID: 6, JobId: 6

[bebras]

KODĖL ShowPlayerDialog ir mysql_free_result yra cikle? Tu bent kiek nors mastai kas vyksta? :/