MartinKen
Новичок
здравствуйте, пытаюсь перенести свой старый gm, который работает на dini на mysql, я сделал все как надо, взял пример с другого gm, который работает на mysql, но мой gm не сохраняет данные, только имя игрока..
OnPlayerRegister
SavePlayer
OnPlayerLoginToServer
OnPlayerRegister
Код:
publics: OnPlayerRegister(playerid)
{
new string[32];
new query[512];
if(IsPlayerConnected(playerid))
{
query = "UPDATE `accounts` SET ";
acc_int_strcat(query,sizeof(query), "pLogin",1);
acc_int_strcat(query,sizeof(query), "pLevel",1);
acc_int_strcat(query,sizeof(query), "pExp",1);
acc_int_strcat(query,sizeof(query), "pSex",Player[playerid][pSex]);
acc_int_strcat(query,sizeof(query), "pAge",20);
acc_int_strcat(query,sizeof(query), "pSkin",10);
acc_int_strcat(query,sizeof(query), "pCash",50000);
acc_int_strcat(query,sizeof(query), "pMaterials",0);
acc_int_strcat(query,sizeof(query), "pAdmin",0);
acc_int_strcat(query,sizeof(query), "pHelper",0);
acc_int_strcat(query,sizeof(query), "pRegistered",1);
acc_int_strcat(query,sizeof(query), "pArmorShield",0); // ES GAASWORE !!!!
acc_int_strcat(query,sizeof(query), "pRadioSt",0);
acc_int_strcat(query,sizeof(query), "pFanari",0); // ES GAASWORE !!!!
acc_int_strcat(query,sizeof(query), "pVerified",0);
acc_int_strcat(query,sizeof(query), "pPinCode",0); // ES GAASWORE !!!!
acc_int_strcat(query,sizeof(query), "pMobile",0);// ES GAASWORE !!!!
acc_int_strcat(query,sizeof(query), "pPhnumber", 100000+random(999999));// ES GAASWORE !!!!
acc_int_strcat(query,sizeof(query), "pFaceMask",0);
acc_int_strcat(query,sizeof(query), "pCig",0);
acc_int_strcat(query,sizeof(query), "pLighter",0);
acc_int_strcat(query,sizeof(query), "pCoca",0);
acc_int_strcat(query,sizeof(query), "pSnickers",0);
acc_int_strcat(query,sizeof(query), "pWatch",0);
acc_int_strcat(query,sizeof(query), "pGps",0);
acc_int_strcat(query,sizeof(query), "pMasterCard",0);
acc_int_strcat(query,sizeof(query), "pWarn",0);
acc_int_strcat(query,sizeof(query), "pRealName",0);
acc_int_strcat(query,sizeof(query), "pApple",0);
acc_int_strcat(query,sizeof(query), "pSprunk",0);
acc_int_strcat(query,sizeof(query), "pPiradoba",0);
acc_int_strcat(query,sizeof(query), "pBaned",0);
acc_str_strcat(query,sizeof(query), "pBanReason","None");
acc_int_strcat(query,sizeof(query), "pHouse",999);
acc_int_strcat(query,sizeof(query), "pBussinesKey",0);
acc_int_strcat(query,sizeof(query), "pCompanyKey",0);
acc_int_strcat(query,sizeof(query), "pCars",0);
acc_int_strcat(query,sizeof(query), "pHat",0);
acc_float_strcat(query,sizeof(query), "pLastPosX",0);
acc_float_strcat(query,sizeof(query), "pLastPosY",0);
acc_float_strcat(query,sizeof(query), "pLastPosZ",0);
acc_float_strcat(query,sizeof(query), "pLastFacing",0);
acc_float_strcat(query,sizeof(query), "pHatRotY",0);
acc_float_strcat(query,sizeof(query), "pHatRotZ",0);
acc_int_strcat(query,sizeof(query), "pInt",0);
acc_int_strcat(query,sizeof(query), "pModel",0);
acc_int_strcat(query,sizeof(query), "pChangeSpawn",0);
acc_int_strcat(query,sizeof(query), "pMember",0);
acc_int_strcat(query,sizeof(query), "pRank",0);
acc_int_strcat(query,sizeof(query), "pBag",0);
acc_int_strcat(query,sizeof(query), "pMenuStyle",0);
acc_int_strcat(query,sizeof(query), "pLeader",0);
acc_int_strcat(query,sizeof(query), "pRang",0);
acc_int_strcat(query,sizeof(query), "pDropTime",0);
acc_int_strcat(query,sizeof(query), "pJob",0);
acc_int_strcat(query,sizeof(query), "pDrivingLic",0);
acc_int_strcat(query,sizeof(query), "pFarmSkill",0);
acc_int_strcat(query,sizeof(query), "pCarJackerSkill",0);
acc_int_strcat(query,sizeof(query), "pBusDriverSkill",0);
acc_int_strcat(query,sizeof(query), "pLumberCutterSkill",0);
acc_int_strcat(query,sizeof(query), "pWRALSkill",0);
acc_int_strcat(query,sizeof(query), "pTrasherSkill",0);
acc_int_strcat(query,sizeof(query), "pAPCrateSkill",0);
acc_int_strcat(query,sizeof(query), "Last",0);
acc_int_strcat(query,sizeof(query), "pBank",0);
acc_int_strcat(query,sizeof(query), "pBalance",0);
acc_float_strcat(query,sizeof(query), "pFuel",0.0);
acc_float_strcat(query,sizeof(query), "pHealth",0.0);
acc_float_strcat(query,sizeof(query), "pArmour",0.0);
new sendername[MAX_PLAYER_NAME];
new playersip[32];
GetPlayerIp(playerid,playersip,sizeof(playersip));
GetPlayerName(playerid,sendername,sizeof(sendername));
strdel(query, strlen(query)-1, strlen(query));
acc_str_strcat(query, sizeof(query), "pIpReg", playersip);
format(string,sizeof(string)," WHERE `Name` = '%s'",sendername);
strcat(query, string);
mysql_tquery(connects, query, "", "");
SCM(playerid, COLOR_RED,"OnPlayerRegister");
if(strlen(query) >= 1024) printf("Yuradgeba! Akaunti %s Ver Daaregi",sendername);
OnPlayerLoginToServer(playerid);
}
return true;
}SavePlayer
Код:
publics: SavePlayer(playerid)
{
new query[512];
new string[32];
if(IsPlayerConnected(playerid))
{
if(Player[playerid][pLogin] == 1)
{
query = "UPDATE `accounts` SET ";
acc_int_strcat(query, sizeof(query), "pLogin", Player[playerid][pLogin]);
acc_int_strcat(query, sizeof(query), "pLevel", Player[playerid][pLevel]);
acc_int_strcat(query,sizeof(query), "pExp",Player[playerid][pExp]);
acc_int_strcat(query,sizeof(query), "pSex",Player[playerid][pSex]);
acc_int_strcat(query,sizeof(query), "pAge",Player[playerid][pAge]);
acc_int_strcat(query,sizeof(query), "pSkin",Player[playerid][pSkin]);
acc_int_strcat(query,sizeof(query), "pCash",Player[playerid][pCash]);
acc_int_strcat(query,sizeof(query), "pMaterials",Player[playerid][pMaterials]);
acc_int_strcat(query,sizeof(query), "pAdmin",Player[playerid][pAdmin]);
acc_int_strcat(query,sizeof(query), "pHelper",Player[playerid][pHelper]);
acc_int_strcat(query,sizeof(query), "pRegistered",Player[playerid][pRegistered]);
acc_int_strcat(query,sizeof(query), "pArmorShield",Player[playerid][pArmorShield]);
acc_int_strcat(query,sizeof(query), "pRadioSt",Player[playerid][pRadioSt]);
acc_int_strcat(query,sizeof(query), "pFanari",Player[playerid][pFanari]);
acc_int_strcat(query,sizeof(query), "pVerified",Player[playerid][pVerified]);
acc_int_strcat(query,sizeof(query), "pPinCode",Player[playerid][pPinCode]);
acc_int_strcat(query,sizeof(query), "pMobile",Player[playerid][pMobile]);
acc_int_strcat(query,sizeof(query), "pPhnumber",Player[playerid][pPhnumber]);
acc_int_strcat(query,sizeof(query), "pFaceMask",Player[playerid][pFaceMask]);
acc_int_strcat(query,sizeof(query), "pCig",Player[playerid][pCig]);
acc_int_strcat(query,sizeof(query), "pLighter",Player[playerid][pLighter]);
acc_int_strcat(query,sizeof(query), "pCoca",Player[playerid][pCoca]);
acc_int_strcat(query,sizeof(query), "pSnickers",Player[playerid][pSnickers]);
acc_int_strcat(query,sizeof(query), "pWatch",Player[playerid][pWatch]);
acc_int_strcat(query,sizeof(query), "pGps",Player[playerid][pGps]);
acc_int_strcat(query,sizeof(query), "pMasterCard",Player[playerid][pMasterCard]);
acc_int_strcat(query,sizeof(query), "pWarn",Player[playerid][pWarn]);
acc_int_strcat(query,sizeof(query), "pRealName",Player[playerid][pRealName]);
acc_int_strcat(query,sizeof(query), "pApple",Player[playerid][pApple]);
acc_int_strcat(query,sizeof(query), "pSprunk",Player[playerid][pSprunk]);
acc_int_strcat(query,sizeof(query), "pPiradoba",Player[playerid][pPiradoba]);
acc_int_strcat(query,sizeof(query), "pBaned",Player[playerid][pBaned]);
acc_str_strcat(query,sizeof(query), "pBanReason",Player[playerid][pBanReason]);
acc_int_strcat(query,sizeof(query), "pHouse",Player[playerid][pHouse]);
acc_int_strcat(query,sizeof(query), "pBussinesKey",Player[playerid][pBussinesKey]);
acc_int_strcat(query,sizeof(query), "pCompanyKey",Player[playerid][pCompanyKey]);
acc_int_strcat(query,sizeof(query), "pCars",Player[playerid][pCars]);
acc_int_strcat(query,sizeof(query), "pHat",Player[playerid][pHat]);
acc_float_strcat(query,sizeof(query), "pLastPosX",Player[playerid][pLastPosX]);
acc_float_strcat(query,sizeof(query), "pLastPosY",Player[playerid][pLastPosY]);
acc_float_strcat(query,sizeof(query), "pLastPosZ",Player[playerid][pLastPosZ]);
acc_float_strcat(query,sizeof(query), "pLastFacing",Player[playerid][pLastFacing]);
acc_float_strcat(query,sizeof(query), "pHatRotY",Player[playerid][pHatRotY]);
acc_float_strcat(query,sizeof(query), "pHatRotZ",Player[playerid][pHatRotZ]);
acc_int_strcat(query,sizeof(query), "pInt",Player[playerid][pInt]);
acc_int_strcat(query,sizeof(query), "pModel",Player[playerid][pModel]);
acc_int_strcat(query,sizeof(query), "pChangeSpawn",Player[playerid][pChangeSpawn]);
acc_int_strcat(query,sizeof(query), "pMember",Player[playerid][pMember]);
acc_int_strcat(query,sizeof(query), "pRank",Player[playerid][pRank]);
acc_int_strcat(query,sizeof(query), "pBag",Player[playerid][pBag]);
acc_int_strcat(query,sizeof(query), "pMenuStyle",Player[playerid][pMenuStyle]);
acc_int_strcat(query,sizeof(query), "pLeader",Player[playerid][pLeader]);
acc_int_strcat(query,sizeof(query), "pRang",Player[playerid][pRang]);
acc_int_strcat(query,sizeof(query), "pDropTime",Player[playerid][pDropTime]);
acc_int_strcat(query,sizeof(query), "pJob",Player[playerid][pJob]);
acc_int_strcat(query,sizeof(query), "pDrivingLic",Player[playerid][pDrivingLic]);
acc_int_strcat(query,sizeof(query), "pFarmSkill",Player[playerid][pFarmSkill]);
acc_int_strcat(query,sizeof(query), "pCarJackerSkill",Player[playerid][pCarJackerSkill]);
acc_int_strcat(query,sizeof(query), "pBusDriverSkill",Player[playerid][pBusDriverSkill]);
acc_int_strcat(query,sizeof(query), "pLumberCutterSkill",Player[playerid][pLumberCutterSkill]);
acc_int_strcat(query,sizeof(query), "pWRALSkill",Player[playerid][pWRALSkill]);
acc_int_strcat(query,sizeof(query), "pTrasherSkill",Player[playerid][pTrasherSkill]);
acc_int_strcat(query,sizeof(query), "pAPCrateSkill",Player[playerid][pAPCrateSkill]);
acc_int_strcat(query,sizeof(query), "Last",Player[playerid][Last]);
acc_int_strcat(query,sizeof(query), "pBank",Player[playerid][pBank]);
acc_int_strcat(query,sizeof(query), "pBalance",Player[playerid][pBalance]);
acc_float_strcat(query,sizeof(query), "pFuel",Player[playerid][pFuel]);
acc_float_strcat(query,sizeof(query), "pHealth",Player[playerid][pHealth]);
acc_float_strcat(query,sizeof(query), "pArmour",Player[playerid][pArmour]);
//Player[playerid][pCash] = Money(playerid);
// new strstre[50];
new sendername[MAX_PLAYER_NAME];
GetPlayerName(playerid,sendername,sizeof(sendername));
strdel(query, strlen(query)-1, strlen(query));
format(string,sizeof(string)," WHERE `Name` = '%s'",sendername);
strcat(query, string);
mysql_tquery(connects, query, "", "");
if(strlen(query) >= 128) printf("Yuradgeba! Akaunti %s Ver Sheinaxa",sendername);
SCM(playerid, COLOR_RED,"OE 3 SAve");
}
}
return true;
}OnPlayerLoginToServer
Код:
static OnPlayerLoginToServer(playerid) //LoginServer
{
new string[512];
format(string, sizeof(string), "SELECT * FROM `accounts` WHERE name = '%s'",Name(playerid));
mysql_query(connects,string);
new rows;
cache_get_row_count(rows);
for new i = 0;i < rows; i++ do
{
cache_get_value_name_int(i,"pID", PlayerIDs[playerid]);
cache_get_value_name_int(i, "pLogin", Player[playerid][pLogin]);
cache_get_value_name_int(i, "pLevel", Player[playerid][pLevel]);
cache_get_value_name_int(i, "pExp",Player[playerid][pExp]);
cache_get_value_name_int(i, "pSex",Player[playerid][pSex]);
cache_get_value_name_int(i, "pAge",Player[playerid][pAge]);
cache_get_value_name_int(i, "pSkin",Player[playerid][pSkin]);
cache_get_value_name_int(i, "pCash",Player[playerid][pCash]);
cache_get_value_name_int(i, "pMaterials",Player[playerid][pMaterials]);
cache_get_value_name_int(i, "pAdmin",Player[playerid][pAdmin]);
cache_get_value_name_int(i, "pHelper",Player[playerid][pHelper]);
cache_get_value_name_int(i, "pRegistered",Player[playerid][pRegistered]);
cache_get_value_name(i,"pIpReg", Player[playerid][pIpReg], 64);
cache_get_value_name_int(i, "pArmorShield",Player[playerid][pArmorShield]);
cache_get_value_name_int(i, "pRadioSt",Player[playerid][pRadioSt]);
cache_get_value_name_int(i, "pFanari",Player[playerid][pFanari]);
cache_get_value_name_int(i, "pVerified",Player[playerid][pVerified]);
cache_get_value_name_int(i, "pPinCode",Player[playerid][pPinCode]);
cache_get_value_name_int(i, "pMobile",Player[playerid][pMobile]);
cache_get_value_name_int(i, "pPhnumber",Player[playerid][pPhnumber]);
cache_get_value_name_int(i, "pFaceMask",Player[playerid][pFaceMask]);
cache_get_value_name_int(i, "pCig",Player[playerid][pCig]);
cache_get_value_name_int(i, "pLighter",Player[playerid][pLighter]);
cache_get_value_name_int(i, "pCoca",Player[playerid][pCoca]);
cache_get_value_name_int(i, "pSnickers",Player[playerid][pSnickers]);
cache_get_value_name_int(i, "pWatch",Player[playerid][pWatch]);
cache_get_value_name_int(i, "pGps",Player[playerid][pGps]);
cache_get_value_name_int(i, "pMasterCard",Player[playerid][pMasterCard]);
cache_get_value_name_int(i, "pWarn",Player[playerid][pWarn]);
cache_get_value_name_int(i, "pRealName",Player[playerid][pRealName]);
cache_get_value_name_int(i, "pApple",Player[playerid][pApple]);
cache_get_value_name_int(i, "pSprunk",Player[playerid][pSprunk]);
cache_get_value_name_int(i, "pPiradoba",Player[playerid][pPiradoba]);
cache_get_value_name_int(i, "pBaned",Player[playerid][pBaned]);
cache_get_value_name(i, "pBanReason",Player[playerid][pBanReason], 64);
cache_get_value_name_int(i, "pHouse",Player[playerid][pHouse]);
cache_get_value_name_int(i, "pBussinesKey",Player[playerid][pBussinesKey]);
cache_get_value_name_int(i, "pCompanyKey",Player[playerid][pCompanyKey]);
cache_get_value_name_int(i, "pCars",Player[playerid][pCars]);
cache_get_value_name_int(i, "pHat",Player[playerid][pHat]);
cache_get_value_name_float(i, "pLastPosX",Player[playerid][pLastPosX]);
cache_get_value_name_float(i, "pLastPosY",Player[playerid][pLastPosY]);
cache_get_value_name_float(i, "pLastPosZ",Player[playerid][pLastPosZ]);
cache_get_value_name_float(i, "pLastFacing",Player[playerid][pLastFacing]);
cache_get_value_name_float(i, "pHatRotY",Player[playerid][pHatRotY]);
cache_get_value_name_float(i, "pHatRotZ",Player[playerid][pHatRotZ]);
cache_get_value_name_int(i, "pInt",Player[playerid][pInt]);
cache_get_value_name_int(i, "pModel",Player[playerid][pModel]);
cache_get_value_name_int(i, "pChangeSpawn",Player[playerid][pChangeSpawn]);
cache_get_value_name_int(i, "pMember",Player[playerid][pMember]);
cache_get_value_name_int(i, "pRank",Player[playerid][pRank]);
cache_get_value_name_int(i, "pBag",Player[playerid][pBag]);
cache_get_value_name_int(i, "pMenuStyle",Player[playerid][pMenuStyle]);
cache_get_value_name_int(i, "pLeader",Player[playerid][pLeader]);
cache_get_value_name_int(i, "pRang",Player[playerid][pRang]);
cache_get_value_name_int(i, "pDropTime",Player[playerid][pDropTime]);
cache_get_value_name_int(i, "pJob",Player[playerid][pJob]);
cache_get_value_name_int(i, "pDrivingLic",Player[playerid][pDrivingLic]);
cache_get_value_name_int(i, "pFarmSkill",Player[playerid][pFarmSkill]);
cache_get_value_name_int(i, "pCarJackerSkill",Player[playerid][pCarJackerSkill]);
cache_get_value_name_int(i, "pBusDriverSkill",Player[playerid][pBusDriverSkill]);
cache_get_value_name_int(i, "pLumberCutterSkill",Player[playerid][pLumberCutterSkill]);
cache_get_value_name_int(i, "pWRALSkill",Player[playerid][pWRALSkill]);
cache_get_value_name_int(i, "pTrasherSkill",Player[playerid][pTrasherSkill]);
cache_get_value_name_int(i, "pAPCrateSkill",Player[playerid][pAPCrateSkill]);
cache_get_value_name_int(i, "Last",Player[playerid][Last]);
cache_get_value_name_int(i, "pBank",Player[playerid][pBank]);
cache_get_value_name_int(i, "pBalance",Player[playerid][pBalance]);
cache_get_value_name_float(i, "pFuel",Player[playerid][pFuel]);
cache_get_value_name_float(i, "pHealth",Player[playerid][pHealth]);
cache_get_value_name_float(i, "pArmour",Player[playerid][pArmour]);
}
//mysql_free_result();
Player[playerid][pLogin] = 1;
format(string, sizeof(string), "UPDATE accounts SET pLogin = '%d' WHERE name = '%s'",Player[playerid][pLogin],Name(playerid));
mysql_query(connects,string);
SpawnPlayer(playerid);
//SaveAccounts();
/* ---------------------------------------------------------------------- */
SetPlayerScore(playerid, Player[playerid][pLevel]);
StopAudioStreamForPlayer(playerid);
SCM(playerid, COLOR_RED,"OE OnPlayerLoginToServer");
/* ---------------------------------------------------------------------- */
return true;
}Вложения
Последнее редактирование модератором: