mysql r5
#1

PHP код:
new jobIdwPointsworkRankwContractresultline[40], dStatus[20];
                        if(
GetPlayeridMid(spName[playerid]) != INVALID_PLAYER_ID) { dStatus "prisijungęs"; } else { dStatus "atsijungęs"; }
                        
format(g_szBuffersizeof(g_szBuffer),"SELECT WorkId,WorkContract,WorkWarns,WorkRank FROM users WHERE pName = '%s'"spName[playerid]);
                        
mysql_query(g_szBuffer);
                        
mysql_store_result();
                        
                        
sscanf(resultline,"p<|>iiii"jobIdwContractwPointsworkRank);
                        
printf("%i job id %i contract %i wPoints %i rank",jobIdwContractwPointsworkRank );
                        
                        
format(g_szBuffersizeof(g_szBuffer), "{ffffff}Informacija apie darbuotoją:\n \n{d8a9ff}•{ffffff} %s darbuotojas ( {d8a9ff}%s{ffffff} ),\n{d8a9ff}•{ffffff} darbuotojo turimi įsp. {d8a9ff}%i{ffffff},\n{d8a9ff}•{ffffff} Kontraktas baigiasi {d8a9ff}%s{ffffff},\n{d8a9ff}•{ffffff} ћaidėjo būsena {d8a9ff}%s{ffffff}",spName[playerid],getPlayerRank(jobIdworkRank),wPointslikusdata(wContract), dStatus);
                        
ShowPlayerDialog(playerid872DIALOG_STYLE_MSGBOX ,"Informacija apie darbuotoją"g_szBuffer"Atgal""");
                        
mysql_free_result(); 
I dont know why, but the jobId is getting 0, but in mysql it is setted to 6.
Reply


Messages In This Thread
mysql r5 - by bogushas - 06.02.2015, 06:08
AW: mysql r5 - by Saize - 06.02.2015, 06:47
Re: mysql r5 - by bogushas - 06.02.2015, 06:49
AW: mysql r5 - by Saize - 06.02.2015, 06:51
Re: mysql r5 - by Knappen - 06.02.2015, 10:40

Forum Jump:


Users browsing this thread: 1 Guest(s)