Evgesha2021
Умник
Доброго времени суток, добавлял систему номеров для т/с и описание персонажа, но столкнулся с тем что номера не заносяться в БД, а также как бы загружать этот текст при заходе на сервер?
А вот с описанием всё норм
Скриншот БД описания
При загрузке Описание тоже прописано
PHP:
CMD:numbers(playerid, params[])//Numbers
{
new string[144], carID2 = GetPlayerVehicleID(playerid);
if(CarInfo[playerid][carNumbers] == 1) return SendClientMessage(playerid,-1,!"На транспорте уже есть номера!");
if(sscanf(params, "s[32]", params[0])) return SendClientMessage(playerid, -1, !"Используйте: /numbers [Ваш номер]");
format(string,sizeof(string),("[%s]"),params[0]);
textID[carID2] = Create3DTextLabel(string,-1,0.0,0.0,0.0,15.0,0);
Attach3DTextLabelToVehicle(textID[carID2],carID2,0.0,-2.85,-0.15);
CarInfo[playerid][carNumbers] = 1;
SendClientMessage(playerid,-1,!"Вы установили номера на транспорт!");
mysql_format(dbHandle,QUERY,400,"UPDATE `cars` SET `numbers`='%s' WHERE id = '%i'",params[0],CarInfo[playerid][carID][0]);
mysql_tquery(dbHandle,QUERY,"","");
SavePlayer(playerid);
SaveCar(playerid);
return 1;
}
Чтобы видеть скрытое содержание Зарегистрируйтесь на форуме!
PHP:
case 1566:
{
new i = GetPVarInt(playerid,"_changecar")-1;
if(!GetPVarInt(playerid,"_changecar")) return true;
if(!response) return SendClientMessage(playerid,COLOR_GREY,"Вы отказались от сделки"), SendClientMessage(i,COLOR_GREY,"Игрок отказался от сделки"), DeletePVar(i,"changecar"), DeletePVar(i,"changecar_price"), DeletePVar(i,"changecar_"), DeletePVar(playerid,"_changecar");
if(!HGet(i) && !KGet(i)) return SendClientMessage(playerid,COLOR_GREY,"У игрока нет дома!"), DeletePVar(i,"changecar"), DeletePVar(i,"changecar_price"), DeletePVar(i,"changecar_"), DeletePVar(playerid,"_changecar");
if(!HGet(playerid) && !KGet(playerid)) return SendClientMessage(playerid,COLOR_GREY,"У Вас нет дома!"), DeletePVar(i,"changecar"), DeletePVar(i,"changecar_price"), DeletePVar(i,"changecar_"), DeletePVar(playerid,"_changecar");
if(!ProxDetectorS(8.0, playerid, i)) return SendClientMessage(playerid, COLOR_GREY, "Игрок слишком далеко от вас!"), DeletePVar(i,"changecar"), DeletePVar(i,"changecar_price"), DeletePVar(i,"changecar_"), DeletePVar(playerid,"_changecar");
if(User[playerid][pCash] < GetPVarInt(i,"changecar_price"))return SendClientMessage(playerid, COLOR_GREY, "У Вас нет столько денег на руках!"), DeletePVar(i,"changecar"), DeletePVar(i,"changecar_price"), DeletePVar(i,"changecar_"), DeletePVar(playerid,"_changecar");
User[playerid][pCash] -= GetPVarInt(i,"changecar_price");
User[i][pCash] += GetPVarInt(i,"changecar_price");
SetPVarInt(i,"carid",CarInfo[playerid][carID][0]);
SetPVarInt(i,"car",CarInfo[playerid][carModel][0]);
SetPVarInt(i,"numbers",CarInfo[playerid][carNumbers][0]); // tyt
SetPVarInt(i,"color_1",CarInfo[playerid][carColor_one][0]);
SetPVarInt(i,"color_2",CarInfo[playerid][carColor_two][0]);
SetPVarInt(i,"procents",CarInfo[playerid][carPercent][0]);
SetPVarInt(i,"vehcoms_0",CarInfo[playerid][carVehcom_1][0]);
SetPVarInt(i,"vehcoms_1",CarInfo[playerid][carVehcom_2][0]);
SetPVarInt(i,"vehcoms_2",CarInfo[playerid][carVehcom_3][0]);
SetPVarInt(i,"vehcoms_3",CarInfo[playerid][carVehcom_4][0]);
SetPVarInt(i,"vehcoms_4",CarInfo[playerid][carVehcom_5][0]);
SetPVarInt(i,"vehcoms_5",CarInfo[playerid][carVehcom_6][0]);
SetPVarInt(i,"vehcoms_6",CarInfo[playerid][carVehcom_7][0]);
SetPVarInt(i,"vehcoms_7",CarInfo[playerid][carVehcom_8][0]);
SetPVarInt(i,"vehcoms_8",CarInfo[playerid][carVehcom_9][0]);
SetPVarInt(i,"vehcoms_9",CarInfo[playerid][carVehcom_10][0]);
SetPVarInt(i,"vehcoms_10",CarInfo[playerid][carVehcom_11][0]);
SetPVarInt(i,"vehcoms_11",CarInfo[playerid][carVehcom_12][0]);
SetPVarInt(i,"vehcoms_12",CarInfo[playerid][carVehcom_13][0]);
SetPVarInt(i,"vehcoms_13",CarInfo[playerid][carVehcom_14][0]);
SetPVarInt(i,"house_car",house_car[playerid]);
CarInfo[playerid][carID][0] = CarInfo[i][carID][0];
CarInfo[playerid][carModel][0] = CarInfo[i][carModel][0];
CarInfo[playerid][carNumbers][0] = CarInfo[i][carNumbers][0]; // tyt
CarInfo[playerid][carColor_one][0] = CarInfo[i][carColor_one][0];
CarInfo[playerid][carColor_two][0] = CarInfo[i][carColor_two][0];
CarInfo[playerid][carPercent][0] = CarInfo[i][carPercent][0];
CarInfo[playerid][carVehcom_1][0] = CarInfo[i][carVehcom_1][0];
CarInfo[playerid][carVehcom_2][0] = CarInfo[i][carVehcom_2][0];
CarInfo[playerid][carVehcom_3][0] = CarInfo[i][carVehcom_3][0];
CarInfo[playerid][carVehcom_4][0] = CarInfo[i][carVehcom_4][0];
CarInfo[playerid][carVehcom_5][0] = CarInfo[i][carVehcom_5][0];
CarInfo[playerid][carVehcom_6][0] = CarInfo[i][carVehcom_6][0];
CarInfo[playerid][carVehcom_7][0] = CarInfo[i][carVehcom_7][0];
CarInfo[playerid][carVehcom_8][0] = CarInfo[i][carVehcom_8][0];
CarInfo[playerid][carVehcom_9][0] = CarInfo[i][carVehcom_9][0];
CarInfo[playerid][carVehcom_10][0] = CarInfo[i][carVehcom_10][0];
CarInfo[playerid][carVehcom_11][0] = CarInfo[i][carVehcom_11][0];
CarInfo[playerid][carVehcom_12][0] = CarInfo[i][carVehcom_12][0];
CarInfo[playerid][carVehcom_13][0] = CarInfo[i][carVehcom_13][0];
CarInfo[playerid][carVehcom_14][0] = CarInfo[i][carVehcom_14][0];
house_car[playerid] = house_car[i];
CarInfo[i][carID][0] = GetPVarInt(i,"carid");
CarInfo[i][carModel][0] = GetPVarInt(i,"car");
CarInfo[i][carNumbers][0] = GetPVarInt(i,"numbers"); // tyt
CarInfo[i][carColor_one][0] = GetPVarInt(i,"color_1");
CarInfo[i][carColor_two][0] = GetPVarInt(i,"color_2");
CarInfo[i][carPercent][0] = GetPVarInt(i,"procents");
CarInfo[i][carVehcom_1][0] = GetPVarInt(i,"vehcoms_0");
CarInfo[i][carVehcom_2][0] = GetPVarInt(i,"vehcoms_1");
CarInfo[i][carVehcom_3][0] = GetPVarInt(i,"vehcoms_2");
CarInfo[i][carVehcom_4][0] = GetPVarInt(i,"vehcoms_3");
CarInfo[i][carVehcom_5][0] = GetPVarInt(i,"vehcoms_4");
CarInfo[i][carVehcom_6][0] = GetPVarInt(i,"vehcoms_5");
CarInfo[i][carVehcom_7][0] = GetPVarInt(i,"vehcoms_6");
CarInfo[i][carVehcom_8][0] = GetPVarInt(i,"vehcoms_7");
CarInfo[i][carVehcom_9][0] = GetPVarInt(i,"vehcoms_8");
CarInfo[i][carVehcom_10][0] = GetPVarInt(i,"vehcoms_9");
CarInfo[i][carVehcom_11][0] = GetPVarInt(i,"vehcoms_10");
CarInfo[i][carVehcom_12][0] = GetPVarInt(i,"vehcoms_11");
CarInfo[i][carVehcom_13][0] = GetPVarInt(i,"vehcoms_12");
CarInfo[i][carVehcom_14][0] = GetPVarInt(i,"vehcoms_13");
house_car[i] = GetPVarInt(i,"house_car");
mysql_format(dbHandle,QUERY,400,"UPDATE `cars` SET owner = '%e' WHERE id = '%i'",Name(playerid),CarInfo[playerid][carID][0]);
mysql_tquery(dbHandle,QUERY,"","");
SavePlayer(playerid);
new str[144];
format(str,sizeof(str), "Вы обменяли машину с %s. Ваша доплата %i вирт!",User[i][pName], GetPVarInt(i,"changecar_price"));
SendClientMessage(playerid,COLOR_WHITE,str);
format(str,sizeof(str), "Вы обменяли машину с %s. Доплата %i вирт!",User[playerid][pName], GetPVarInt(i,"changecar_price"));
SendClientMessage(i,COLOR_WHITE,str);
SaveCar(playerid), SaveCar(i);
DeletePVar(i,"changecar");
DeletePVar(i,"changecar_price");
DeletePVar(i,"changecar_");
MONEY_TD(playerid);
return DeletePVar(playerid,"_changecar");
}
PHP:
enum carInfo
{
carID[3],
carModel[3],
carNumbers[8],
carColor_one[3],
carColor_two[3],
carPercent[3],
Float:carFuel[3],
carVehcom_1[3],
carVehcom_2[3],
carVehcom_3[3],
carVehcom_4[3],
carVehcom_5[3],
carVehcom_6[3],
carVehcom_7[3],
carVehcom_8[3],
carVehcom_9[3],
carVehcom_10[3],
carVehcom_11[3],
carVehcom_12[3],
carVehcom_13[3],
carVehcom_14[3]
};
PHP:
case 42:
{
if(!r)
{
return printf("[Error] Информация о машинах игрока в BD не найдена");
}
new temp[0x9e];
for(x = 0; x < r; x++)
{
mysql_format(dbHandle, QUERY, sizeof(QUERY), "UPDATE `cars` SET ");
format(temp,sizeof(temp),"`model`= '%i',",CarInfo[playerid][carModel][x]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`numbers`= '%s',",CarInfo[playerid][carNumbers][x]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`color_one`= '%i',",CarInfo[playerid][carColor_one][x]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`color_two`= '%i',",CarInfo[playerid][carColor_two][x]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`percent`= '%i',",CarInfo[playerid][carPercent][x]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`fuel`= '%f',",CarInfo[playerid][carFuel][x]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`vehcom_1`= '%i',",CarInfo[playerid][carVehcom_1][x]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`vehcom_2`= '%i',",CarInfo[playerid][carVehcom_2][x]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`vehcom_3`= '%i',",CarInfo[playerid][carVehcom_3][x]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`vehcom_4`= '%i',",CarInfo[playerid][carVehcom_4][x]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`vehcom_5`= '%i',",CarInfo[playerid][carVehcom_5][x]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`vehcom_6`= '%i',",CarInfo[playerid][carVehcom_6][x]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`vehcom_7`= '%i',",CarInfo[playerid][carVehcom_7][x]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`vehcom_8`= '%i',",CarInfo[playerid][carVehcom_8][x]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`vehcom_9`= '%i',",CarInfo[playerid][carVehcom_9][x]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`vehcom_10`= '%i',",CarInfo[playerid][carVehcom_10][x]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`vehcom_11`= '%i',",CarInfo[playerid][carVehcom_11][x]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`vehcom_12`= '%i',",CarInfo[playerid][carVehcom_12][x]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`vehcom_13`= '%i',",CarInfo[playerid][carVehcom_13][x]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp),"`vehcom_14`= '%i'",CarInfo[playerid][carVehcom_14][x]), strcat(QUERY,temp,sizeof(QUERY));
format(temp,sizeof(temp)," WHERE id = '%i'",CarInfo[playerid][carID][x]), strcat(QUERY,temp,sizeof(QUERY));
mysql_tquery(dbHandle, QUERY, "", "");
}
printf("[Сохранение] Транспорт %s | %i,%i,%i сохранён", User[playerid][pName],CarInfo[playerid][carModel][0],CarInfo[playerid][carModel][1],CarInfo[playerid][carModel][2]);
}
PHP:
//Описание
CMD:desc(playerid, params[])
{
if(isnull(params)) return SendClientMessage(playerid, -1, "Введите: /desc [Описание]"); // Если человек оставил поле "Описание пустым" то выводим это сообщение
if(desc_text[playerid] != Text3D:-1) return SendClientMessage(playerid, -1, "У вас уже стоит описание. Для удаление используйте: /delldesc"); // Проверка на то, создано ли у игрока описание или нет
desc_text[playerid] = Create3DTextLabel(params, 0xFFFFFFDD, 0.0, 0.0, 12000.0, 3, 0, 1);
Attach3DTextLabelToPlayer(desc_text[playerid], playerid, 0.0, 0.0, -0.8);
new string[MAX_CHATBUBBLE_LENGTH+1];
static const fmt_query[] = "UPDATE `accounts` SET `pDesc` = '%s' WHERE `Name` = '%e'";
new query[sizeof(fmt_query)+(-2+32)+(-2+MAX_PLAYER_NAME)];
mysql_format(dbHandle, query, sizeof(query), fmt_query, params[0], User[playerid][pName]);
mysql_tquery(dbHandle, query, "", "");
SavePlayer(playerid);
format(string, sizeof(string), "Вы создали описание персонажа: %s", params); // Если человек ввёл что-то в поле "Описание" то ставим данный текст как описание и выводим данное сообщение
SendClientMessage(playerid, -1, string);
return 1;
}new Text3D:desc_text[MAX_PLAYERS] = {Text3D:-1, ...};
PHP:
enum pInfo
{
pName[50],
pKey[128],
pChas,
pMin,
pLogin,
pEmail[128],
pLevel,
pDesc, // tyt
pAdmin,
pHelper,
pJobHeal,
pJobHealLeader,
pMestoJail,
pIp[128],
pvIp[128],
pIpReg[128],
pHousecash,
pCheckip,
pText,
pKeyip[128],
Float:pHP,
pKeys,
Float: Satiety,
pDataReg[128],
pData,
pDonateRank,
pMats,
pSex,
pArrested,
pMuted,
pBan,
pMutedr,
pCrimes,
pExp,
pCash,
pWantedDeaths,
pPayCheck,
pJailTime,
pDrugs,
pLeader,
pMember,
pRank,
pChar[6],
pChars[32],
pJob,
pModel,
pPnumber,
pDirectory,
pVhoddata,
pVhodMes,
pVhodchas,
pVhodminute,
pCarLic,
pFlyLic,
pBoatLic,
pFishLic,
pGunLic,
pBizLic,
pLicTaxi,
pNkeys,
pAvtomas,
pZakonp,
pAddiction,
pNarcoLomka,
pPayDayHad,
pTut,
pWarns,
punWarns,
pFuel,
pMarriedTo[128],
pDrug[128],
pMushrooms,
Float:pFishes,
pFishesPach,
pBank,
pDonateAccount,
pMobile,
pDolg,
pKrisha,
pUseKrisha,
pWantedLevel,
kLibWeapon[weapon_info],
pGunSkill[6],
pGunSkills[32],
ptaxiexp,
ptaxilvl,
pGunfbiTime,
pGun51Time,
pGunlspdTime,
pGunaviaTime,
pBoxstyle,
pKstyle,
pKickstyle,
pBoxSkill,
pKongfuSkill,
pKickboxSkill,
pPSkill,
pPProc,
pPMGruz,
pDLevel,
pDExp,
pDMgruz,
pDgruz,
pOnline[128],
pOnlineLid[128],
Float:pPos_x,
Float:pPos_y,
Float:pPos_z,
pSkilla,
pLighter,
pCigarettes,
pRecognition,
pRobHouse,
pActivemail,
SalonCar,
SalonTime,
pDrivingSkill,
pProdsSkill[2],
pMusicPlay,
pGoogle,
pGoogleAuth[17],
pAreaskut,
pPromoUse,
pGifts,
pTimeGift,
p_boat, p_boat_color[2],
pAptechka,
pKarta,
pMask,
pMaskON,
pDecor,
pDecorPlayer,
pDecorPlayerSlot,
pYoutube,
pVzlom,
pAvig,
pLvig,
pLoadText,
pZapretTextDraw,
//контейнеры
pPriz,
//
pCherepaxa,
pKuriza,
pKostum,
pSamalet,
pKrilya,
pFuragka,
pSwat,
pDredi,
pKentavr,
pShar,
pBoombox,
pKatana,
pShit,
pCase2,
pDemon,
pSerfing,
pZombi,
pRoga,
pRespirator,
pTrost,
pLopata,
pBita,
pPovyazka,
pSkate,
//end
//tun
tuningvip1[4],
tuningvip2[4],
tuningvip3[3],
///end
pSkrepka,
pRepAdmin,
pMedCard,
pTablet,
pZapis,
//quest
pQuest1[4],
pQuest2[4],
pQuest3[4],
pQuest4[4],
pQuest5[2],
//временные переменные
pDeny,
pZapretBolka,
pZapretProgress,
pVzlomBank,
pZapiska,
pDuty,
pADuty,
pAdminKey,
//
pFamilyMember,
pFamilyRank,
Text3D:pFamilyText,
pSpawnChange,
accessories [ 8 ],
accessories_used [ 8 ],
PlayerFollow,
pBeg[5],
bool: PlayerUseMesh,
bool: PlayerWorks,
bool: PlayerWorkLes,
bool: acDied,
acWeaponTick,
ac_Weapon[13],//Анти Ган
ac_Ammo[13]//Анти Аммо
};
PHP:
///описание
if(desc_text[playerid] != Text3D:-1) // Удаляем описание с сервера
{
Delete3DTextLabel(desc_text[playerid]);
desc_text[playerid] = Text3D:-1;
}
PHP:
stock SavePlayer(i)
{
new time = GetTickCount();
if(GetPVarInt(i,"player_save") || !User[i][pLogin]) return true;
SetPVarInt(i,"player_save",1);
new year, month, day;
getdate(year, month, day);
format(User[i][pGunSkills],30,"%i, %i, %i, %i, %i ,%i",User[i][pGunSkill][0],User[i][pGunSkill][1],User[i][pGunSkill][2],User[i][pGunSkill][3],User[i][pGunSkill][4],User[i][pGunSkill][5]);
format(User[i][pChars],30,"%i, %i, %i, %i, %i ,%i",User[i][pChar][0],User[i][pChar][1],User[i][pChar][2],User[i][pChar][3],User[i][pChar][4],User[i][pChar][5]);
new t_query[1600];
mysql_format(dbHandle, t_query, sizeof(t_query), "UPDATE `accounts` SET `pLevel` = '%d',`pDesc` = '%s',`pHelper` = '%d',`pJobHeal` = '%d',`pJobHealLeader` = '%d',`pMestoJail` = '%d',`pHousecash` = '%d',`pCheckip` = '%d', \
`pHP` = '%f',`pSatiety` = '%.2f',`pDonateRank` = '%d',`pMats` = '%d',`pSex` = '%d',`pArrested` = '%d',`pMuted` = '%d',`pCrimes` = '%d',`pExp` = '%d',`pCash` = '%d',`pWantedDeaths` = '%d', \
`pPayCheck` = '%d',`pJailTime` = '%d',`pDrugs` = '%d',`pLeader` = '%d',`pMember` = '%d' WHERE `Name` = '%e'",
User[i][pLevel], User[i][pHelper], User[i][pJobHeal], User[i][pJobHealLeader], User[i][pMestoJail], User[i][pHousecash], User[i][pCheckip], User[i][pHP], User[i][Satiety], User[i][pDonateRank],
User[i][pMats], User[i][pSex], User[i][pArrested], User[i][pMuted], User[i][pCrimes], User[i][pExp], User[i][pCash], User[i][pWantedDeaths], User[i][pPayCheck], User[i][pJailTime],
User[i][pDrugs], User[i][pLeader], User[i][pMember], User[i][pName]);
mysql_tquery(dbHandle, t_query, "", "");
t_query = "";
mysql_format(dbHandle, t_query, sizeof(t_query), "UPDATE `accounts` SET `pRank` = '%d',`pChars` = '%s',`pJob` = '%d',`pModel` = '%d',`pPnumber` = '%d',`pDirectory` = '%d',`pVhoddata` = '%d',`pVhodMes` = '%d', \
`pVhodchas` = '%d',`pVhodminute` = '%d',`pCarLic` = '%d',`pFlyLic` = '%d',`pBoatLic` = '%d',`pFishLic` = '%d',`pGunLic` = '%d',`pBizLic` = '%d',`pZakonp` = '%d', \
`pText` = '%d',`pAddiction` = '%d',`pNarcoLomka` = '%d',`pPayDayHad` = '%d',`pTut` = '%d',`pWarns` = '%d' WHERE `Name` = '%e'",
User[i][pRank], User[i][pChars], User[i][pJob], User[i][pModel], User[i][pPnumber],User[i][pDirectory], User[i][pVhoddata], User[i][pVhodMes],
User[i][pVhodchas], User[i][pVhodminute], User[i][pCarLic], User[i][pFlyLic], User[i][pBoatLic],User[i][pFishLic], User[i][pGunLic], User[i][pBizLic],
User[i][pZakonp], User[i][pText], User[i][pAddiction], User[i][pNarcoLomka], User[i][pPayDayHad],User[i][pTut], User[i][pWarns], User[i][pName]);
mysql_tquery(dbHandle, t_query, "", "");
t_query = "";
mysql_format(dbHandle, t_query, sizeof(t_query), "UPDATE `accounts` SET `punWarns` = '%d',`pFuel` = '%d',`pMarriedTo` = '%s', `pMushrooms` = '%d',`pFishes` = '%f',`pBank` = '%d',`pMobile` = '%d',`pDolg` = '%d',`pKrisha` = '%d',`pUseKrisha` = '%d', \
`pWantedLevel` = '%d',`pGunSkills` = '%s',`ptaxiexp` = '%d',`ptaxilvl` = '%d',`pBoxSkill` = '%d',`pKongfuSkill` = '%d',`pKickboxSkill` = '%d',`pDLevel` = '%d',`pDExp` = '%d' WHERE `Name` = '%e'",
User[i][punWarns], User[i][pFuel], User[i][pMarriedTo], User[i][pMushrooms], User[i][pFishes],User[i][pBank], User[i][pMobile], User[i][pDolg], User[i][pKrisha],
User[i][pUseKrisha], User[i][pWantedLevel], User[i][pGunSkills], User[i][ptaxiexp], User[i][ptaxilvl],
User[i][pBoxSkill], User[i][pKongfuSkill], User[i][pKickboxSkill], User[i][pDLevel], User[i][pDExp], User[i][pName]);
mysql_tquery(dbHandle, t_query, "", "");
t_query = "";
mysql_format(dbHandle, t_query, sizeof(t_query), "UPDATE `accounts` SET `pDMgruz` = '%d',`pPSkill` = '%d',`pPProc` = '%d',`pPMGruz` = '%d',`pDonateAccount` = '%d',`pOnline` = '%02d/%02d/%02d',`pChas` = '%d',`pMin` = '%d',`pOnlineLid` = '%02d:%02d',`pSkilla` = '%d',`prods_skill` = '%d',`prods_exp` = '%d',`pLighter` = '%d',`pCigarettes` = '%d',`pRecognition` = '%d',`pRobHouse` = '%d',`pFishesPach` = '%d',`pDrivingSkill` = '%d',`pGoogle` = '%d', \
`pGoogleAuth` = '%s' WHERE `Name` = '%e'",
User[i][pDMgruz], User[i][pPSkill], User[i][pPProc], User[i][pPMGruz], User[i][pDonateAccount], day, month, year, User[i][pChas], User[i][pMin],User[i][pChas],
User[i][pMin],User[i][pSkilla], User[i][pProdsSkill][0], User[i][pProdsSkill][1], User[i][pLighter], User[i][pCigarettes], User[i][pRecognition],
User[i][pRobHouse], User[i][pFishesPach], User[i][pDrivingSkill], User[i][pGoogle], User[i][pGoogleAuth], User[i][pName]);
mysql_tquery(dbHandle, t_query, "", "");
t_query = "";
mysql_format(dbHandle, t_query, sizeof(t_query), "UPDATE `accounts` SET `pGifts` = '%d',`pEmail` = '%s', `activate_mail` = '%i', `pAptechka` = '%d', `fam_m` = '%d', `spawnchange` = '%d', `fam_r` = '%d' WHERE `Name` = '%e'", User[i][pGifts], User[i][pEmail], User[i][pActivemail], User[i][pAptechka], User[i][pFamilyMember], User[i][pSpawnChange], User[i][pFamilyRank], User[i][pName]);
mysql_tquery(dbHandle, t_query, "", "");
DeletePVar(i, "player_save");
printf("[Save Accounts] %s Good! (in %d <ms>)", User[i][pName], GetTickCount() - time);
return 1;
}
PHP:
stock SaveCar(i)
{
mysql_format(dbHandle,QUERY,256,"SELECT * FROM `cars` WHERE `owner` = '%s'", User[i][pName]), mysql_tquery(dbHandle,QUERY,"OnMySQL_QUERY","iis",42,i,"");
return 1;
}
Чтобы видеть скрытое содержание Зарегистрируйтесь на форуме!
При загрузке Описание тоже прописано
Вложения
Последнее редактирование: