- 0
Войдите для возможности подписаться
Подписчики
0
Нет сохранения в бд
Вопрос от
Андрей Лазарев
,
Вопросы
Лучший ответ
Спасибо я все испаравил просто тупо убрал сохранение системы потребностей и в структуре бд прописал все по 100 тем самым игрок при спавне ничего не требует а в процессе игры потом все прийдется пополнять по мере потребности
Эта тема закрыта для публикации ответов.
Войдите для возможности подписаться
Подписчики
0
-
Последние посетители 0 пользователей онлайн
Ни одного зарегистрированного пользователя не просматривает данную страницу
-
Похожий контент
-
От Aleksey98
Необходим человек: который сможет написать систему тюнинга!
как на крупных проектах типа: Arizona и Radmir
И еще требуется Мапперы на новый топовый проект!
Связь : https://vk.com/id289498732
-
От Mister Odin
new
g_teleport_list[39][E_TELEPORT_LIST] = { {"Спавн пгт.Батырево", 1802.3612, 2508.4824, 15.8887}, {"Спавн г.Арзамас", -113.5887, 977.7222, 12.0346}, {"Спавн г.Южный", 2744.2770, -2446.7246, 21.8988}, {"Центральный банк", 1852.020385,2040.791381,15.892713}, {"Рублёвка", -837.7783, 888.6161, 12.7232}, {"Казино", 1332.4252, 2358.7014, 17.6641}, {"Битва за контейнеры", 614.5167, 1722.3566, 12.0709}, {"Автосалон низкого класса", 2493.9616, -722.9544, 12.3315}, {"Автосалон среднего класса", 1407.7449, 455.4801, 13.1630}, {"Автосалон высокого класса", -14.0637, 2614.5664, 10.9892}, {"Мотосалон Harley Davidson", 785.720153, 750.465087, 12.000024}, {"Автошкола", 1909.174438,2227.679687,15.708162}, {"Военкомат", 1916.778564,2302.411376,15.574637}, {"Правительство области", -139.140975,593.789611,12.145712}, {"Отдел полиции №1 (ГИБДД)", 1906.805786,-2234.382812,11.257631}, {"Отдел полиции №2 (УМВД)", 2581.309326,-2416.139892,21.960090}, {"Отдел ФСБ", 1823.904663,2095.636718,15.848405}, {"Городская больница г.Арзамас", -285.797210,581.851562,12.120290}, {"СМИ", -317.708038,821.221679,13.051450}, {"Воинская часть", 1703.197265,1678.025878,15.279437}, {"Арзамасская ОПГ", 438.705322,1046.505126,12.002637}, {"Батыревская ОПГ", 1941.203857,2161.006591,15.705187}, {"Лыткаринская ОПГ", -2346.002441,75.257041,21.002962}, {"Шахта", 2381.5727, 1726.4451, -2.1506}, {"Завод", -1062.6697, 2204.1894, 38.0964}, {"Инкосация", 1864.1374, 2011.7136, 15.8546}, {"Транспортная Компания", 2362.1115, 1972.5627, 15.5530}, {"База механиков", 1840.918090,-118.025146,15.695312}, {"Курьерская служба доставки", 2764.509765,-2396.882568,21.890625}, {"Аренда автобуса(Южный)", 2771.041992,-2454.780761,21.845964}, {"Аренда автобуса(Арзамас)", -127.487670,943.652648,12.142824}, {"Аренда автобуса(Батырево)", 1798.986328,2529.591552,15.664262}, {"Гоночная трасса", -1568.7784, 1611.8305, 36.3971}, {"Дом на горе", -789.5397, -456.7479, 741.1422}, {"СТО и тюнинг-ателье", 1856.1375, -122.3266, 15.6888}, {"Аренда транспорта пгт.Батырево", 1763.641723,2255.673339,15.865348}, {"Аренда транспорта г.Арзамас", -36.923530,1360.673583,12.002090}, {"Аренда транспорта г.Южный", 1966.599975,-2603.943603,10.820312}, {"Тайный интерьер в Лыткарино", -2424.5818, 2846.3291, 40.7908} };
-
Опубликовано · Жалоба
Помогите пожалуйста выявил причину что при заходе намсервер у игрока нет вод уд он сдает на права все отлично но прирестарте или перезаходе на сервер водительского удостоверения нет и все приходится сдавать с самого начала да и с деньгами таже самая проблемма все возращается к начальному капиталу который указан в бд
//Сохранение аккаунта
stock SaveAccount(playerid)
{
if(!PlayerLogged[playerid]) return true;
new src[128];
/////////////////////////////////
format(query,sizeof(query),"UPDATE "TABLE_ACCOUNT" SET ");
format(src,sizeof(src),"ip='%s',", PlayerInfo[playerid][pPlIP]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"level=%d,",PlayerInfo[playerid][pLevel]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"admin=%d,",PlayerInfo[playerid][pAdmin]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"sex=%d,",PlayerInfo[playerid][pSex]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"ippassword='%s',",PlayerInfo[playerid][pIpPassword]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"model=%d,",PlayerInfo[playerid][pModel]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"loach=%d,",PlayerInfo[playerid][pChar]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cash=%d,",PlayerInfo[playerid][pCash]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"bank=%d,",PlayerInfo[playerid][pBank]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"mute=%d,",PlayerInfo[playerid][pMuted]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"warn=%d,",PlayerInfo[playerid][pWarn]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"warntime=%d,",PlayerInfo[playerid][pWarnTime]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"leader=%d,",PlayerInfo[playerid][pLeader]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"member=%d,",PlayerInfo[playerid][pMember]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"rank=%d,",PlayerInfo[playerid][pRank]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"pick=%d,",PlayerInfo[playerid][pPick]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"exp=%d,",PlayerInfo[playerid][pExp]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"news=%d,",PlayerInfo[playerid][pNews]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"morgan='%i',",PlayerInfo[playerid][pMorgan]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"morgantime='%i',",PlayerInfo[playerid][pMorganTime]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"crimes=%d,",PlayerInfo[playerid][pCrimes]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"wanted=%d,",PlayerInfo[playerid][pWanted]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"wantedtime=%d,",PlayerInfo[playerid][pWantedTime]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"wantedwho='%s',",PlayerInfo[playerid][pWantedWho]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"wantedreason='%s',",PlayerInfo[playerid][pWantedReason]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"job=%d,",PlayerInfo[playerid][pJob]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"checktime=%d,",PlayerInfo[playerid][pCheckTime]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"drugs=%d,",PlayerInfo[playerid][pDrugs]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"mats=%d,",PlayerInfo[playerid][pMats]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"heal='%f',",PlayerInfo[playerid][pHeal]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"married=%d,",PlayerInfo[playerid][pMarried]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"whomarried='%s',",PlayerInfo[playerid][pWhoMarried]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"paycheck='%i',",PlayerInfo[playerid][pPayCheck]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"fishing='%i',",PlayerInfo[playerid][pFish]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"lottery='%i',",PlayerInfo[playerid][pLottery]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"vip='%i',",PlayerInfo[playerid][pVIP]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"time='%i',",PlayerInfo[playerid][pTime]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"fstyle='%i',",PlayerInfo[playerid][pFightStyle]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"credits='%i',",PlayerInfo[playerid][pCredits]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"totalcredits='%i',",PlayerInfo[playerid][pTotalCredits]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"skin1='%i',",PlayerInfo[playerid][pSkin1]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"skin2='%i',",PlayerInfo[playerid][pSkin2]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"skin3='%i',",PlayerInfo[playerid][pSkin3]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"spawnchange='%i',",PlayerInfo[playerid][pSpawnChange]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"sdpistol='%i',",PlayerInfo[playerid][pGunSkill][0]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"deserteagle='%i',",PlayerInfo[playerid][pGunSkill][1]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"shotgun='%i',",PlayerInfo[playerid][pGunSkill][2]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"mp5='%i',",PlayerInfo[playerid][pGunSkill][3]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"ak47='%i',",PlayerInfo[playerid][pGunSkill][4]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"m4='%i',",PlayerInfo[playerid][pGunSkill][5]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"rpr='%i',",PlayerInfo[playerid][pRPR]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"glasses='%d',",PlayerInfo[playerid][pGlasses]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"satiety='%i',",PlayerInfo[playerid][pSatiety]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"pZhazhda='%i',",PlayerInfo[playerid][pZhazhda]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"pBanya='%i',",PlayerInfo[playerid][pBanya]);//pBanya
strcat(query,src,sizeof(query));
format(src,sizeof(src),"Gigiena='%i',",PlayerInfo[playerid][pGigiena]);//pGigiena
strcat(query,src,sizeof(query));
format(src,sizeof(src),"Piss='%i',",PlayerInfo[playerid][pPiss]);//Piss
strcat(query,src,sizeof(query));
format(src,sizeof(src),"Putlist='%i',",PlayerInfo[playerid][pPutlist]);//Putlist
strcat(query,src,sizeof(query));
format(src,sizeof(src),"rprgive='%i',",PlayerInfo[playerid][pRPRGive]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"healths='%f',",PlayerInfo[playerid][pHealthS]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"sportexp='%i',",PlayerInfo[playerid][pSportEXP]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"online='%i',",PlayerInfo[playerid][pOnline]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"zakon='%i',",PlayerInfo[playerid][pZakon]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"bolezn='%i',",PlayerInfo[playerid][pBolezn]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"ipcheck='%i',",PlayerInfo[playerid][ProverkaIP]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"hospital='%i',",PlayerInfo[playerid][pHospital]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"watch='%i',",PlayerInfo[playerid][pWatch]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"ciggare='%i',",PlayerInfo[playerid][pCiggare]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"sprunk='%i',",PlayerInfo[playerid][pSprunk]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"mask='%i',",PlayerInfo[playerid][pMask]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"phonebalance='%i',",PlayerInfo[playerid][pPhoneBalance]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"truckskill='%i',",PlayerInfo[playerid][pTruckSkill]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"spawn='%i',",PlayerInfo[playerid][pSpawn]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"vb='%i',",PlayerInfo[playerid][pVb]);
strcat(query,src,sizeof(query));
format(PlayerInfo[playerid][pPhones],16,"%i, %i, %i",
PlayerInfo[playerid][pPhone][0],PlayerInfo[playerid][pPhone][1], PlayerInfo[playerid][pPhone][2]);
format(src,sizeof(src),"phone='%s',",PlayerInfo[playerid][pPhones]);
strcat(query,src,sizeof(query));
format(PlayerInfo[playerid][pLic],40,"%i, %i, %i, %i, %i",
PlayerInfo[playerid][pLic][0],PlayerInfo[playerid][pLic][1],PlayerInfo[playerid][pLic][2]
,PlayerInfo[playerid][pLic][3],PlayerInfo[playerid][pLic][4]);
format(src,sizeof(src),"lic='%s',",PlayerInfo[playerid][pLic]);
strcat(query,src,sizeof(query));
format(PlayerInfo[playerid][pWorkBook], 40, "%i, %i, %i, %i, %i, %i",
PlayerInfo[playerid][pWB][0], PlayerInfo[playerid][pWB][1],PlayerInfo[playerid][pWB][2]
,PlayerInfo[playerid][pWB][3],PlayerInfo[playerid][pWB][4], PlayerInfo[playerid][pWB][5]);
format(src,sizeof(src),"workbook='%s',",PlayerInfo[playerid][pWorkBook]);
strcat(query,src,sizeof(query));
if(GetPVarInt(playerid, "GunCheat") == 0)
{
for(new i = 0; i < 13; i++)
{
GetPlayerWeaponData(playerid, i, PlayerInfo[playerid][pGun], PlayerInfo[playerid][pAmmo]);
}
format(PlayerInfo[playerid][pGuns],40,"%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d",
PlayerInfo[playerid][pGun][0],PlayerInfo[playerid][pGun][1],PlayerInfo[playerid][pGun][2],
PlayerInfo[playerid][pGun][3],PlayerInfo[playerid][pGun][4],PlayerInfo[playerid][pGun][5],
PlayerInfo[playerid][pGun][6],PlayerInfo[playerid][pGun][7],PlayerInfo[playerid][pGun][8],
PlayerInfo[playerid][pGun][9],PlayerInfo[playerid][pGun][10],PlayerInfo[playerid][pGun][11],PlayerInfo[playerid][pGun][12]);
format(src,sizeof(src),"guns='%s',",PlayerInfo[playerid][pGuns]);
strcat(query,src,sizeof(query));
format(PlayerInfo[playerid][pAmmos],160,"%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d",
PlayerInfo[playerid][pAmmo][0],PlayerInfo[playerid][pAmmo][1],PlayerInfo[playerid][pAmmo][2],
PlayerInfo[playerid][pAmmo][3],PlayerInfo[playerid][pAmmo][4],PlayerInfo[playerid][pAmmo][5],
PlayerInfo[playerid][pAmmo][6],PlayerInfo[playerid][pAmmo][7],PlayerInfo[playerid][pAmmo][8],
PlayerInfo[playerid][pAmmo][9],PlayerInfo[playerid][pAmmo][10],PlayerInfo[playerid][pAmmo][11],PlayerInfo[playerid][pAmmo][12]);
format(src,sizeof(src),"ammos='%s',",PlayerInfo[playerid][pAmmos]);
}
strcat(query,src,sizeof(query));
format(src,sizeof(src),"skills='%d'",PlayerInfo[playerid][pGunSkill][6]);
strcat(query,src,sizeof(query));
new playername[32];
GetPlayerName(playerid,playername,32);
format(src,sizeof(src)," WHERE name='%s'",playername);
strcat(query,src,sizeof(query));
mysql_function_query(ConBD, query, true, "", "");
SaveAllMyCar(playerid);
return true;
}
если понадобятся еще какието данные скажите предоставлю так как не имею понятия какие еще нужны
Поделиться сообщением
Ссылка на сообщение