Доступ к архиву

Переход в группу "Пользователь"

300.00 ₽
Одноразовый платёж
Быстрый переход в группу "Пользователи", без надобности написания постов и ожидания.

Покупка дает возможность:
Быть полноправным участником форума
Нормальное копирование кода
Создавать темы
Скачивать файлы
Доступ к архиву Pawno-Info

mysq проблема с сохранением акаунтов

Статус
В этой теме нельзя размещать новые ответы.

Braga67

Новичок
проблема в том что я вырезал из скрилакса систему регистрации все работает хорошо но одна проблема все же есть когда я выдаю себе админку то она после перезахода слетает перенес я значение pAdmin в другой столбец все стало работать хорошо но как же быть с другими переменными подскажите пожалуйста паблик сохранения ниже посмотрите пожалуйста может где ошибка P.S pAdmin был в самом первом столбце после pZapkey
HTML:
/*stock OnPlayerSave(playerid)
{
	if(gPlayerLogged[playerid] == true && IsPlayerConnected(playerid))
	{
 		if(saveplayer[playerid] != 0) return true;
	    saveplayer[playerid] = 5;
	    new sendername[24];
		GetPlayerName(playerid,sendername,24);
		new str[2100];

		mysql_format(connects,str,sizeof(str),"UPDATE `Accounts` SET `pLevel` = '%d',`pPhousekey` = '%d',`pPbiskey` = '%d',`pZapkey` = '%d',`pFuelcar` = '%f',`pCar` = '%d',`pHelper` = '%d',`pAvtomas` = '%d' WHERE `Name` = '%s'",
		PlayerInfo[playerid][pLevel],PlayerInfo[playerid][pFuelcar],
		PlayerInfo[playerid][pPhousekey],PlayerInfo[playerid][pPbiskey],
		PlayerInfo[playerid][pZapkey],
		PlayerInfo[playerid][pCar], PlayerInfo[playerid][pHelper],
		PlayerInfo[playerid][pAvtomas],sendername);
        mysql_function_query(connects, str, false, "", "");


		mysql_format(connects,str,sizeof(str),"UPDATE `Accounts` SET `pReg` = '%d',`pSex` = '%d',`pMuted` = '%d',`pExp` = '%d',`pCash` = '%d',`pKills` = '%d',`pJailed` = '%d',`pJailTime` = '%d',`pMats` = '%d',`pDrugs` = '%d',\
		`pZag` = '%d',`pMestoJail` = '%d',`pLeader` = '%d',`pMember` = '%d' WHERE `Name` = '%s'",
		PlayerInfo[playerid][pReg],PlayerInfo[playerid][pSex],
		PlayerInfo[playerid][pMuted],PlayerInfo[playerid][pExp],
		PlayerInfo[playerid][pCash],PlayerInfo[playerid][pKills],
		PlayerInfo[playerid][pJailed],PlayerInfo[playerid][pJailTime],
		PlayerInfo[playerid][pMats],PlayerInfo[playerid][pDrugs],
		PlayerInfo[playerid][pZag],PlayerInfo[playerid][pMestoJail],
		PlayerInfo[playerid][pLeader],PlayerInfo[playerid][pMember],sendername);
        mysql_function_query(connects, str, false, "", "");


		mysql_format(connects,str,sizeof(str),"UPDATE `Accounts` SET `pRank` = '%d',`pVig` = '%d',`pJob` = '%d',`pVodPrava` = '%d',\
		`pBizLic` = '%d',`pFlyLic` = '%d',`pBoatLic` = '%d',`pFishLic` = '%d',`pGunLic` = '%d' WHERE `Name` = '%s'",
		PlayerInfo[playerid][pRank],PlayerInfo[playerid][pVig],
		PlayerInfo[playerid][pJob],
		PlayerInfo[playerid][pVodPrava],PlayerInfo[playerid][pBizLic],
		PlayerInfo[playerid][pFlyLic],PlayerInfo[playerid][pBoatLic],
		PlayerInfo[playerid][pFishLic],PlayerInfo[playerid][pGunLic],sendername);
        mysql_function_query(connects, str, false, "", "");


		mysql_format(connects,str,sizeof(str),"UPDATE `Accounts` SET `pSDPistol` = '%d',`pDesertEagle` = '%d',`pShotGun` = '%d',`pMP5` = '%d',`pAK47` = '%d',`pM4` = '%d',`pChar` = '%d',`pModel` = '%d' WHERE `Name` = '%s'",
		PlayerInfo[playerid][pSDPistol],PlayerInfo[playerid][pDesertEagle],
		PlayerInfo[playerid][pShotGun],PlayerInfo[playerid][pMP5],
		PlayerInfo[playerid][pAK47],PlayerInfo[playerid][pM4],
		PlayerInfo[playerid][pChar],PlayerInfo[playerid][pModel],sendername);
        mysql_function_query(connects, str, false, "", "");


		mysql_format(connects,str,sizeof(str),"UPDATE `Accounts` SET `pPnumber` = '%d',`pPayDayHad` = '%d',`pPayDay` = '%d',`pPayCheck` = '%d',`pWarns` = '%d',`punWarns` = '%d',\
		`punWarnstime` = '%d',`pFuel` = '%d',`pRobTime` = '%d',`pReportTime` = '%d',`pVoprosTime` = '%d' WHERE `Name` = '%s'",
		PlayerInfo[playerid][pPnumber],PlayerInfo[playerid][pPayDayHad],
		PlayerInfo[playerid][pPayDay],PlayerInfo[playerid][pPayCheck],
		PlayerInfo[playerid][pWarns],PlayerInfo[playerid][punWarns],
		PlayerInfo[playerid][punWarnstime],PlayerInfo[playerid][pFuel],
 		PlayerInfo[playerid][pRobTime],PlayerInfo[playerid][pReportTime],
		PlayerInfo[playerid][pVoprosTime],PlayerInfo[playerid][pVerevka],sendername);
        mysql_function_query(connects, str, false, "", "");


		mysql_format(connects,str,sizeof(str),"UPDATE `Accounts` SET `pAutoSkill` = '%d',`pMuteTime` = '%d',`pMobile` = '%d',`pBank` = '%d',`pLocked` = '%d',`pBoxSkill` = '%d',`pKongfuSkill` = '%d',`pKickboxSkill` = '%d',\
		`pBoxstyle` = '%d',`pKstyle` = '%d',`pKickstyle` = '%d' WHERE `Name` = '%s'",
		PlayerInfo[playerid][pAutoSkill],
		PlayerInfo[playerid][pMuteTime],PlayerInfo[playerid][pMobile],
		PlayerInfo[playerid][pBank],PlayerInfo[playerid][pLocked],
		PlayerInfo[playerid][pBoxSkill],PlayerInfo[playerid][pKongfuSkill],
		PlayerInfo[playerid][pKickboxSkill],PlayerInfo[playerid][pBoxstyle],
		PlayerInfo[playerid][pKstyle],PlayerInfo[playerid][pKickstyle],sendername);
        mysql_function_query(connects, str, false, "", "");


		mysql_format(connects,str,sizeof(str),"UPDATE `Accounts` SET `pPosX` = '%f',`pPosY` = '%f',`pPosZ` = '%f',`pVirtWorld` = '%d',`pInt` = '%d',`pSavePos` = '%d',`pHP` = '%f',`pArm` = '%f',`pIp` = '%s',`pvIp` = '%s',`pIpReg` = '%s' WHERE `Name` = '%s'",
		PlayerInfo[playerid][pPosX],PlayerInfo[playerid][pPosY],
		PlayerInfo[playerid][pPosZ],PlayerInfo[playerid][pVirtWorld],
		PlayerInfo[playerid][pInt],PlayerInfo[playerid][pSavePos],
		PlayerInfo[playerid][pHP],PlayerInfo[playerid][pArm],
		PlayerInfo[playerid][pIp],PlayerInfo[playerid][pvIp],
		PlayerInfo[playerid][pIpReg],sendername);
	 	GetPlayerHealth(playerid,PlayerInfo[playerid][pHP]);
        mysql_function_query(connects, str, false, "", "");


       	mysql_format(connects,str,sizeof(str),"UPDATE `Accounts` SET `pSlot1` = '%d',`pSlot2` = '%d',`pSlot3` = '%d',`pSlot4` = '%d',`pSlot5` = '%d',`pSlot6` = '%d',`pSlot7` = '%d',`pSlotammo1` = '%d',`pSlotammo2` = '%d',`pSlotammo3` = '%d',`pSlotammo4` = '%d',`pSlotammo5` = '%d',`pSlotammo6` = '%d',\
		`pSlotammo7` = '%d',`pWeapon` = '%d' WHERE `Name` = '%s'",
		PlayerInfo[playerid][pSlot1],PlayerInfo[playerid][pSlot2],
        PlayerInfo[playerid][pSlot3],PlayerInfo[playerid][pSlot4],
		PlayerInfo[playerid][pSlot5],PlayerInfo[playerid][pSlot6],
		PlayerInfo[playerid][pSlot7], PlayerInfo[playerid][pSlotammo1],
		PlayerInfo[playerid][pSlotammo2],PlayerInfo[playerid][pSlotammo3],
		PlayerInfo[playerid][pSlotammo4],PlayerInfo[playerid][pSlotammo5],
		PlayerInfo[playerid][pSlotammo6],PlayerInfo[playerid][pSlotammo7],
		PlayerInfo[playerid][pWeapon],sendername);
       	mysql_function_query(connects, str, false, "", "");


		mysql_format(connects,str,sizeof(str),"UPDATE `Accounts` SET `pNumbercar` = '%s',`pCvet` = '%d',`pPokraska` = '%d',`pZvonok` = '%d',`pText` = '%d',`pDataReg` = '%d',`pRp` = '%d',`pTut` = '%d',`pDonatechet` = '%d',`pDonateRank` = '%d',`pDonatemoney` = '%d',\
		`pDolg` = '%d',`pKrisha` = '%d',`pUseKrisha` = '%d',`pNoSpcars` = '%d',`pVoennik` = '%d',",
		PlayerInfo[playerid][pNumbercar],PlayerInfo[playerid][pCvet],
		PlayerInfo[playerid][pPokraska],PlayerInfo[playerid][pZvonok],
		PlayerInfo[playerid][pText],PlayerInfo[playerid][pDataReg],
		PlayerInfo[playerid][pRp],PlayerInfo[playerid][pTut],
		PlayerInfo[playerid][pDonatechet],PlayerInfo[playerid][pDonateRank],
		PlayerInfo[playerid][pDonatemoney],PlayerInfo[playerid][pDolg],
		PlayerInfo[playerid][pKrisha],PlayerInfo[playerid][pUseKrisha],
		PlayerInfo[playerid][pNoSpcars],PlayerInfo[playerid][pVoennik]);
       // mysql_function_query(connects, str, false, "", "");


		mysql_format(connects,str,sizeof(str),"%s `pZvezdi` = '%d',`pWanted` = '%d',`pArrested` = '%d',`pWantedDeaths` = '%d',`pFerma` = '%d',`pFermazarobotok` = '%d',`pFermajob` = '%d',`pNarcoZavisimost` = '%d',`pNarcoLomka` = '%d' WHERE `Name` = '%s'",str,
		PlayerInfo[playerid][pZvezdi],PlayerInfo[playerid][pWanted],
		PlayerInfo[playerid][pArrested],PlayerInfo[playerid][pWantedDeaths],
		PlayerInfo[playerid][pFerma],PlayerInfo[playerid][pFermazarobotok],
		PlayerInfo[playerid][pFermajob],PlayerInfo[playerid][pNarcoZavisimost],
		PlayerInfo[playerid][pNarcoLomka],sendername);
        mysql_function_query(connects, str, false, "", "");


		mysql_format(connects,str,sizeof(str),"UPDATE `Accounts` SET `pToys` = '%d',`pToysProz` = '%d',`pDeaths` = '%d',`pAdmin` = '%d',`pPhoneBook` = '%d',\
		`pDirectory` = '%d',`pProz` = '%d',`pDLevel` = '%d',`pDExp` = '%d',`pDMgruz` = '%d',`pDgruz` = '%d', ",
		PlayerInfo[playerid][pToys],PlayerInfo[playerid][pToysProz],
		PlayerInfo[playerid][pDeaths],PlayerInfo[playerid][pAdmin],
		PlayerInfo[playerid][pPhoneBook],PlayerInfo[playerid][pDirectory],
		PlayerInfo[playerid][pProz],PlayerInfo[playerid][pDLevel],
		PlayerInfo[playerid][pDExp],PlayerInfo[playerid][pDMgruz],
		PlayerInfo[playerid][pDgruz]);
		//mysql_function_query(connects, str, false, "", "");


		mysql_format(connects,str,sizeof(str),"%s `pBolnica` = '%d',`pLechenie` = '%d',`pKoika` = '%d',`pHeal` = '%d',`pEnergy` = '%f',`pDostup` = '%d',`pZakonp` = '%d',`pHousecash` = '%d' WHERE `Name` = '%s'",str,
		PlayerInfo[playerid][pBolnica],PlayerInfo[playerid][pLechenie],
		PlayerInfo[playerid][pKoika],PlayerInfo[playerid][pHeal],
		PlayerInfo[playerid][pEnergy], PlayerInfo[playerid][pDostup],
		PlayerInfo[playerid][pZakonp],PlayerInfo[playerid][pHousecash],sendername);
        mysql_function_query(connects, str, false, "", "");
		printf("Àêêàóíò %s áûë óñïåøíî ñîõðàí¸í.(%d)",sendername,strlen(str));
	}
	else printf("Îøèáêà ñîõðàí¸íèÿ.");
	return true;
}*/
 
Последнее редактирование:
Статус
В этой теме нельзя размещать новые ответы.
Сверху Снизу