1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
The problem with saving data in mysql.
MaySee
Little Clucker
**
Posts: 14
Threads: 3
Joined: Oct 2011
Reputation: 0
#1

21.07.2013, 19:11
Hello, I have a problem with mysql plugin to BlueG R6, namely... code in the database does not return the full value of the database so that nothing saves and record the passage occurs only char_health table. Any suggestions?

Code with PWN.
Code:
public SavePlayerStats(playerid, what)
{
	if(!Logged[playerid])
	{
	    return 1;
	}
	new query[512], main_query[1024];
	
	format(main_query, sizeof(main_query), "UPDATE `hrp_char` SET");
	if(what & SAVE_PLAYER_BASIC)
	{
   		format(query, sizeof(query), " `char_hours` = %d, `char_minutes` = %d, `char_skin` = %d, `char_health` = '%f', `char_cash` = %d, `char_bankcash` = %d, `char_banknumb` = %d, `char_warns` = %d, `char_bw` = %d, `char_aj` = %d, `char_crash` = %d, `char_block` = %d, `char_hoteluid` = %d, `char_pdp` = %d, `char_documents` = %d, `char_lastpay` = %d, `char_job` = %d, `char_arrest` = %d, `char_arresttime` = %d, `char_spawnplace` = %d, `char_house` = %d, `char_fightstyle` = %d",
		PlayerCache[playerid][pHours],
		PlayerCache[playerid][pMinutes],
			
		PlayerCache[playerid][pSkin],
		PlayerCache[playerid][pHealth],

		PlayerCache[playerid][pCash],
		PlayerCache[playerid][pBankCash],
		PlayerCache[playerid][pBankNumber],
			
		PlayerCache[playerid][pWarns],
			
		PlayerCache[playerid][pBW],
		PlayerCache[playerid][pAJ],
			
		PlayerCache[playerid][pCrash],
			
		PlayerCache[playerid][pBlock],
		PlayerCache[playerid][pHotel],
			
		PlayerCache[playerid][pPDP],
			
		PlayerCache[playerid][pDocuments],
			
		PlayerCache[playerid][pLastPay],
		PlayerCache[playerid][pJob],

		PlayerCache[playerid][pArrest],
		PlayerCache[playerid][pArrestTime],
			
		PlayerCache[playerid][pSpawnPlace],
		PlayerCache[playerid][pHouse],

		PlayerCache[playerid][pFightingStyle]);

		if(strlen(main_query) > 32)
		{
  			strcat(main_query, ",", sizeof(main_query));
		}
		strcat(main_query, query, sizeof(main_query));
	}
	if(what & SAVE_PLAYER_POS)
	{
     	format(main_query, sizeof(main_query), "UPDATE `hrp_char` SET");
   		format(query, sizeof(query), " `char_int` = %d, `char_vw` = %d, `char_posx` = %f, `char_posy` = %f, `char_posz` = %f",
		PlayerCache[playerid][pInt],
		PlayerCache[playerid][pVW],
		PlayerCache[playerid][pPosX],
  		PlayerCache[playerid][pPosY],
  		PlayerCache[playerid][pPosZ]);

		if(strlen(main_query) > 32)
		{
  			strcat(main_query, ",", sizeof(main_query));
		}
		strcat(main_query, query, sizeof(main_query));
	}
	if(what & SAVE_PLAYER_BIZ)
	{
        format(main_query, sizeof(main_query), "UPDATE `hrp_char` SET");
	    mysql_real_escape_string(PlayerCache[playerid][pBizTitle], PlayerCache[playerid][pBizTitle]);
   		format(query, sizeof(query), " `char_bizuid` = %d, `char_bizperm` = %d, `char_biztitle` = %s, `char_bizpayment` = %d, `char_bizskin` = %d",
	    PlayerCache[playerid][pBizUID],
	    PlayerCache[playerid][pBizPerm],
	    PlayerCache[playerid][pBizTitle],
		PlayerCache[playerid][pBizPayment],
		PlayerCache[playerid][pBizSkin]);

		if(strlen(main_query) > 32)
		{
  			strcat(main_query, ",", sizeof(main_query));
		}
		strcat(main_query, query, sizeof(main_query));
	}
	if(what & SAVE_PLAYER_ORG)
	{
        format(main_query, sizeof(main_query), "UPDATE `hrp_char` SET");
	    mysql_real_escape_string(PlayerCache[playerid][pOrgTitle], PlayerCache[playerid][pOrgTitle]);
   		format(query, sizeof(query), " `char_orguid` = %d, `char_orgperm` = %d, `char_orgtitle` = %s, `char_orgpayment` = %d, `char_orgskin` = %d",
	    PlayerCache[playerid][pOrgUID],
	    PlayerCache[playerid][pOrgPerm],
	    PlayerCache[playerid][pOrgTitle],
		PlayerCache[playerid][pOrgPayment],
		PlayerCache[playerid][pOrgSkin]);

		if(strlen(main_query) > 32)
		{
  			strcat(main_query, ",", sizeof(main_query));
		}
	  	strcat(main_query, query, sizeof(main_query));
	}
	if(what & SAVE_PLAYER_FACTION)
	{
     	format(main_query, sizeof(main_query), "UPDATE `hrp_char` SET");
	    mysql_real_escape_string(PlayerCache[playerid][pFacTitle], PlayerCache[playerid][pFacTitle]);
   		format(query, sizeof(query), " `char_facuid` = %d, `char_facperm`= %d, `char_factitle` = %s, `char_facpayment` = %d, `char_facskin` = %d",
	    PlayerCache[playerid][pFacUID],
   		PlayerCache[playerid][pFacPerm],
   		PlayerCache[playerid][pFacTitle],
		PlayerCache[playerid][pFacPayment],
		PlayerCache[playerid][pFacSkin]);

		if(strlen(main_query) > 32)
		{
  			strcat(main_query, ",", sizeof(main_query));
		}
		strcat(main_query, query, sizeof(main_query));
	}
	if(what & SAVE_PLAYER_SKILLS)
	{
        format(main_query, sizeof(main_query), "UPDATE `hrp_char` SET");
   		format(query, sizeof(query), " `char_driving` = %f, `char_swimming` = %f, `char_shooting` = %f, `char_fishing` = %f, `char_strength` = %f, `char_dependence` = %f",
	    PlayerCache[playerid][pDriving],
	    PlayerCache[playerid][pSwimming],
	    PlayerCache[playerid][pShooting],
		PlayerCache[playerid][pFishing],
		PlayerCache[playerid][pStrength],
		PlayerCache[playerid][pDependence]);
		    
		if(strlen(main_query) > 32)
		{
  			strcat(main_query, ",", sizeof(main_query));
		}
		strcat(main_query, query, sizeof(main_query));
	}
	format(query, sizeof(query), " WHERE char_uid = '%d' LIMIT 1", PlayerCache[playerid][pUID]);
	strcat(main_query, query, sizeof(main_query));

	mysql_query(main_query);
	return 1;
}
Find
Reply
MaySee
Little Clucker
**
Posts: 14
Threads: 3
Joined: Oct 2011
Reputation: 0
#2

22.07.2013, 09:05
whoever?
Find
Reply
Misiur
High-roller
*****
Posts: 2,528
Threads: 124
Joined: Jul 2009
Reputation: 0
#3

22.07.2013, 09:16
Most recent release of mysql plugin is R31. Furthermore R6 doesn't support caching, so it can and will create security vunerabilities (DOS and similar) on your server. Additionaly, read about foreign table keys, because your table structure (fields with fac prefix) should be changed.

Show your mysql_log, or add debug:
pawn Code:
//before
mysql_query(main_query);
//add
printf("Database query: %s", main_query);
Find
Reply
MaySee
Little Clucker
**
Posts: 14
Threads: 3
Joined: Oct 2011
Reputation: 0
#4

22.07.2013, 11:10
I created a business, but when the server is turned off completely disappeared from the database. In addition, do not update the entire table of figures, only that part of the passage.

server_log
Code:
[13:09:29] Database query: UPDATE `hrp_char` SET `char_bizuid` = 13, `char_bizperm` = 63, `char_biztitle` = 0, `char_bizpayment` = 0, `char_bizskin` = 0 WHERE char_uid = '2' LIMIT 1
[13:09:42] *** Audio Plugin: Paulie_Curezzo (ID: 0) has disconnected
[13:09:42] Database query: UPDATE `hrp_char` SET `char_int` = 0, `char_vw` = 0, `char_posx` = 823.523376, `char_posy` = -1360.266235, `char_posz` = -0.507812 WHERE char_uid = '2' LIMIT 1
[13:09:42] Database query: UPDATE `hrp_char` SET `char_driving` = 0.000000, `char_swimming` = 0.000000, `char_shooting` = 0.000000, `char_fishing` = 0.000000, `char_strength` = 15.000000, `char_dependence` = 0.000000 WHERE char_uid = '2' LIMIT 1
[13:09:43] [part] Paulie_Curezzo has left the server (0:1)
mysql_log
Code:
[13:09:21] CMySQLHandler::Query(UPDATE `hrp_business` SET business_name = 'test', business_cash = '0', business_type = '7', business_value1 = '0', business_value2 = '0', business_lasttax = '0', business_dotation = '0', business_points = '0' WHERE business_uid = '13' LIMIT 1) - Successfully executed.

[13:09:29] >> mysql_real_escape_string( Connection handle: 1 )

[13:09:29] CMySQLHandler::EscapeString(0); - Escaped 1 characters to 0.

[13:09:29] >> mysql_query( Connection handle: 1 )

[13:09:29] CMySQLHandler::Query(UPDATE `hrp_char` SET `char_bizuid` = 13, `char_bizperm` = 63, `char_biztitle` = 0, `char_bizpayment` = 0, `char_bizskin` = 0 WHERE char_uid = '2' LIMIT 1) - Successfully executed.

[13:09:42] >> mysql_query( Connection handle: 1 )

[13:09:42] CMySQLHandler::Query(UPDATE `hrp_char` SET `char_int` = 0, `char_vw` = 0, `char_posx` = 823.523376, `char_posy` = -1360.266235, `char_posz` = -0.507812 WHERE char_uid = '2' LIMIT 1) - Successfully executed.

[13:09:42] >> mysql_query( Connection handle: 1 )

[13:09:42] CMySQLHandler::Query(UPDATE `hrp_char` SET char_online = '0' WHERE char_uid = '2' LIMIT 1) - Successfully executed.

[13:09:42] >> mysql_real_escape_string( Connection handle: 1 )

[13:09:42] CMySQLHandler::EscapeString(0); - Escaped 1 characters to 0.

[13:09:42] >> mysql_real_escape_string( Connection handle: 1 )

[13:09:42] CMySQLHandler::EscapeString(); - Escaped 0 characters to .

[13:09:42] >> mysql_real_escape_string( Connection handle: 1 )

[13:09:42] CMySQLHandler::EscapeString(); - Escaped 0 characters to .

[13:09:42] >> mysql_query( Connection handle: 1 )

[13:09:43] CMySQLHandler::Query(UPDATE `hrp_char` SET `char_driving` = 0.000000, `char_swimming` = 0.000000, `char_shooting` = 0.000000, `char_fishing` = 0.000000, `char_strength` = 15.000000, `char_dependence` = 0.000000 WHERE char_uid = '2' LIMIT 1) - Successfully executed.
PS. The script runs in Windows.
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help