По MySQL

[денис161]

Доброе утро Вопрос заключается вот в чем...Не так давно решил перевести мод на MySQL все хорошо но...возникла проблема с записью текста...(IP игрока,Майл,Онлайн)Вот сохранение:

new sendername[24];
		GetPlayerName(playerid,sendername,24);
		new str[2048];
		new playersip[256];
		GetPlayerIp(playerid,playersip,sizeof(playersip));
		new year, month, day;
		getdate(year, month, day);
		new strstre[100];
		format(strstre,sizeof(strstre),"%d/%d/%d",day,month,year);
		format(str,sizeof(str),"UPDATE `players` SET `Online` = '%s',`pvIp` = '%s',`Mail` = '%s',`pLevel` = '%d',`pPhousekey` = '%d',`pPbiskey` = '%d',`pAdmin` = '%d',`pHeadValue` = '%d',`pCar` = '%d', ",
		strstre,playersip,PINFO[playerid][pMail],PINFO[playerid][pLevel],
		PINFO[playerid][pPhousekey],PINFO[playerid][pPbiskey],
		PINFO[playerid][pAdmin],
		PINFO[playerid][pHeadValue],
		PINFO[playerid][pCar]);
		// mysql_function_query(connects, str, false, "", "");

		format(str,sizeof(str),"%s `pDonateRank` = '%d',`pSex` = '%d',`pMuted` = '%d',`pExp` = '%d',`pCash` = '%d',`pKills` = '%d',`pJailed` = '%d',`pJailTime` = '%d',`pMats` = '%d',`pDrugs` = '%d',`pLeader` = '%d',`pMember` = '%d', ",str,
		PINFO[playerid][pDonateRank],PINFO[playerid][pSex],
		PINFO[playerid][pMuted],PINFO[playerid][pExp],
		PINFO[playerid][pCash],PINFO[playerid][pKills],
		PINFO[playerid][pJailed],PINFO[playerid][pJailTime],
		PINFO[playerid][pMats],PINFO[playerid][pDrugs],
		PINFO[playerid][pLeader],PINFO[playerid][pMember]);
		// mysql_function_query(connects, str, false, "", "");

		format(str,sizeof(str),"%s `pRank` = '%d',`pJob` = '%d',`pFlyLic` = '%d',`pBoatLic` = '%d',`pFishLic` = '%d',`pGunLic` = '%d', ",str,
		PINFO[playerid][pRank],PINFO[playerid][pJob],
		PINFO[playerid][pFlyLic],PINFO[playerid][pBoatLic],
		PINFO[playerid][pFishLic],PINFO[playerid][pGunLic]);
		// mysql_function_query(connects, str, false, "", "");

		format(str,sizeof(str),"%s `pSDPistol` = '%d',`pDesertEagle` = '%d',`pShotGun` = '%d',`pMP5` = '%d',`pAK47` = '%d',`pM4` = '%d',`pChar` = '%d',`pModel` = '%d', ",str,
		PINFO[playerid][pSDPistol],PINFO[playerid][pDesertEagle],
		PINFO[playerid][pShotGun],PINFO[playerid][pMP5],
		PINFO[playerid][pAK47],PINFO[playerid][pM4],
		PINFO[playerid][pChar],PINFO[playerid][pModel]);
		// mysql_function_query(connects, str, false, "", "");

		format(str,sizeof(str),"%s `pPnumber` = '%d',`pWarns` = '%d',`pFuel` = '%d', ",str,
		PINFO[playerid][pPnumber],PINFO[playerid][pWarns],PINFO[playerid][pFuel]);
		// mysql_function_query(connects, str, false, "", "");

		format(str,sizeof(str),"%s `pMarried` = '%d',`pMuteTime` = '%d',`pBoxSkill` = '%d', ",str,
		PINFO[playerid][pMarried],PINFO[playerid][pMuteTime],
		PINFO[playerid][pBoxSkill]);
		// mysql_function_query(connects, str, false, "", "");

		format(str,sizeof(str),"%s `pNarcoLomka` = '%d',`pReason` = '%s',`Pos_x` = '%f',`Pos_y` = '%f',`Pos_z` = '%f',`pReg` = '%d', ",str,
		PINFO[playerid][pNarcoLomka],PINFO[playerid][pReason],
		PINFO[playerid][pPos_x],PINFO[playerid][pPos_y],
		PINFO[playerid][pPos_z],PINFO[playerid][pReg]);
		// mysql_function_query(connects, str, false, "", "");

		format(str,sizeof(str),"%s `pWanted` = '%d',`pTut` = '%d' WHERE `Name` = '%e'",str,
		PINFO[playerid][pWanted],
		PINFO[playerid][pTut],sendername);
		mysql_function_query(g_CH, str, false, "", "");

Ячейки в БД вообще пустые...Знающие люди прошу помощи...

---------- Post added at 07:12 ---------- Previous post was at 05:27 ----------

Delete разобрался...