Перейти к содержанию
Единые правила форума (ЕПФ)
Авторизация  
Подписчики 0
АЛЕКСАНДР МАМАЕВ

ошибка MySQL

Автор АЛЕКСАНДР МАМАЕВ, в Архив Вопросов/Проблем/Ошибок

Рекомендуемые сообщения

АЛЕКСАНДР МАМАЕВ    0

АЛЕКСАНДР МАМАЕВ
Опубликовано (изменено)

@gegelo,

public LoadPlayerData(playerid)
{
	new rows, fields, temp[20],login_ip[32];
    cache_get_data(rows, fields);
    if(rows)
	{
		cache_get_field_content(0, "id", temp), PLAYER_DATA[playerid][data_ID] = strval (temp);
		cache_get_field_content(0, "money", temp), PLAYER_DATA[playerid][data_MONEY] = strval (temp);
		cache_get_field_content(0, "donate", temp), PLAYER_DATA[playerid][data_DONATE] = strval (temp);
		cache_get_field_content(0, "sex", temp), PLAYER_DATA[playerid][data_SEX] = strval (temp);
		cache_get_field_content(0, "skin", temp), PLAYER_DATA[playerid][data_SKIN] = strval (temp);
		cache_get_field_content(0, "lvl", temp), PLAYER_DATA[playerid][data_LVL] = strval (temp);
		cache_get_field_content(0, "exp", temp), PLAYER_DATA[playerid][data_EXP] = strval (temp);
		cache_get_field_content(0, "member", temp), PLAYER_DATA[playerid][data_MEMBER] = strval (temp);
		cache_get_field_content(0, "podmember", temp), PLAYER_DATA[playerid][data_PODMEMBER] = strval (temp);
		cache_get_field_content(0, "rank", temp), PLAYER_DATA[playerid][data_RANK] = strval (temp);
		cache_get_field_content(0, "skinm", temp), PLAYER_DATA[playerid][data_SKINM] = strval (temp);
		cache_get_field_content(0, "leader", temp), PLAYER_DATA[playerid][data_LEADER] = strval (temp);
		cache_get_field_content(0, "admlvl", temp), PLAYER_DATA[playerid][data_ADMLVL] = strval (temp);
		cache_get_field_content(0, "register_ip", PLAYER_DATA[playerid][data_REGISTER_IP], dbHandle, 32);
		cache_get_field_content(0, "login_ip", login_ip, dbHandle, 32);
		cache_get_field_content(0, "regdate_day", temp), PLAYER_DATA[playerid][data_REGDATE_DAY] = strval (temp);
		cache_get_field_content(0, "regdate_month", temp), PLAYER_DATA[playerid][data_REGDATE_MONTH] = strval (temp);
		cache_get_field_content(0, "regdate_year", temp), PLAYER_DATA[playerid][data_REGDATE_YEAR] = strval (temp);
		cache_get_field_content(0, "mute", temp), PLAYER_DATA[playerid][data_MUTE] = strval (temp);
		cache_get_field_content(0, "mutetime", temp), PLAYER_DATA[playerid][data_MUTETIME] = strval (temp);
		cache_get_field_content(0, "warn", temp), PLAYER_DATA[playerid][data_WARN] = strval (temp);
		cache_get_field_content(0, "warntime", temp), PLAYER_DATA[playerid][data_WARNTIME] = strval (temp);
		cache_get_field_content(0, "salary", temp), PLAYER_DATA[playerid][data_SALARY] = strval (temp);
		cache_get_field_content(0, "bank", temp), PLAYER_DATA[playerid][data_BANK] = strval (temp);
		cache_get_field_content(0, "licb", temp), PLAYER_DATA[playerid][data_LICB] = strval (temp);
		cache_get_field_content(0, "licg", temp), PLAYER_DATA[playerid][data_LICG] = strval (temp);
		cache_get_field_content(0, "business", temp), PLAYER_DATA[playerid][data_BUSINESS] = strval (temp);
		cache_get_field_content(0, "house", temp), PLAYER_DATA[playerid][data_HOUSE] = strval (temp);
		cache_get_field_content(0, "kv", temp), PLAYER_DATA[playerid][data_KV] = strval (temp);
        cache_get_field_content(0, "padik", temp), PLAYER_DATA[playerid][data_PADIK] = strval (temp);
	    cache_get_field_content(0, "ab", temp), PLAYER_DATA[playerid][data_AB] = strval (temp);
   		cache_get_field_content(0, "car_1", temp), PLAYER_DATA[playerid][data_CAR][0] = strval (temp);
		cache_get_field_content(0, "carfuel_1", temp), PLAYER_DATA[playerid][data_CARFUEL][0] = strval (temp);
		cache_get_field_content(0, "car_color1_1", temp), PLAYER_DATA[playerid][data_CAR_COLOR1][0] = strval (temp);
		cache_get_field_content(0, "car_color2_1", temp), PLAYER_DATA[playerid][data_CAR_COLOR2][0] = strval (temp);
		cache_get_field_content(0, "car_2", temp), PLAYER_DATA[playerid][data_CAR][1] = strval (temp);
		cache_get_field_content(0, "carfuel_2", temp), PLAYER_DATA[playerid][data_CARFUEL][1] = strval (temp);
		cache_get_field_content(0, "car_color1_2", temp), PLAYER_DATA[playerid][data_CAR_COLOR1][1] = strval (temp);
		cache_get_field_content(0, "car_color2_2", temp), PLAYER_DATA[playerid][data_CAR_COLOR2][1] = strval (temp);
		cache_get_field_content(0, "car_3", temp), PLAYER_DATA[playerid][data_CAR][2] = strval (temp);
		cache_get_field_content(0, "carfuel_3", temp), PLAYER_DATA[playerid][data_CARFUEL][2] = strval (temp);
		cache_get_field_content(0, "car_color1_3", temp), PLAYER_DATA[playerid][data_CAR_COLOR1][2] = strval (temp);
		cache_get_field_content(0, "car_color2_3", temp), PLAYER_DATA[playerid][data_CAR_COLOR2][2] = strval (temp);
		cache_get_field_content(0, "car_4", temp), PLAYER_DATA[playerid][data_CAR][3] = strval (temp);
		cache_get_field_content(0, "carfuel_4", temp), PLAYER_DATA[playerid][data_CARFUEL][3] = strval (temp);
		cache_get_field_content(0, "car_color1_4", temp), PLAYER_DATA[playerid][data_CAR_COLOR1][3] = strval (temp);
		cache_get_field_content(0, "car_color2_4", temp), PLAYER_DATA[playerid][data_CAR_COLOR2][3] = strval (temp);
	    cache_get_field_content(0, "patr", temp), PLAYER_DATA[playerid][data_PATR] = strval (temp);
	    cache_get_field_content(0, "drugs", temp), PLAYER_DATA[playerid][data_NARKO] = strval (temp);
    	cache_get_field_content(0, "wanted", temp), PLAYER_DATA[playerid][data_WANTED] = strval (temp);
		cache_get_field_content(0, "number", temp), PLAYER_DATA[playerid][data_NUMBER] = strval (temp);
		cache_get_field_content(0, "number_m", temp), PLAYER_DATA[playerid][data_NUMBER_M] = strval (temp);
		cache_get_field_content(0, "jail", temp), PLAYER_DATA[playerid][data_JAIL] = strval (temp);
		cache_get_field_content(0, "jailtime", temp), PLAYER_DATA[playerid][data_JAILTIME] = strval (temp);
		cache_get_field_content(0, "phone", temp), PLAYER_DATA[playerid][data_PHONE] = strval (temp);
		cache_get_field_content(0, "hp", temp), PLAYER_DATA[playerid][data_HP] = strval (temp);
		cache_get_field_content(0, "arm", temp), PLAYER_DATA[playerid][data_ARM] = strval (temp);
		cache_get_field_content(0, "med", temp), PLAYER_DATA[playerid][data_MED] = strval (temp);
		cache_get_field_content(0, "spawn", temp), PLAYER_DATA[playerid][data_SPAWN] = strval (temp);
		cache_get_field_content(0, "hospital", temp), PLAYER_DATA[playerid][data_HOSPITAL] = strval (temp);
		cache_get_field_content(0, "job", temp), PLAYER_DATA[playerid][data_JOB] = strval (temp);
	    cache_get_field_content(0, "polit", temp), PLAYER_DATA[playerid][data_POLIT] = strval (temp);
        cache_get_field_content(0, "gun0", temp), PLAYER_DATA[playerid][data_GUN][0] = strval (temp);
		cache_get_field_content(0, "gun1", temp), PLAYER_DATA[playerid][data_GUN][1] = strval (temp);
		cache_get_field_content(0, "gun2", temp), PLAYER_DATA[playerid][data_GUN][2] = strval (temp);
		cache_get_field_content(0, "gun3", temp), PLAYER_DATA[playerid][data_GUN][3] = strval (temp);
		cache_get_field_content(0, "gun4", temp), PLAYER_DATA[playerid][data_GUN][4] = strval (temp);
		cache_get_field_content(0, "gun5", temp), PLAYER_DATA[playerid][data_GUN][5] = strval (temp);
		cache_get_field_content(0, "gun6", temp), PLAYER_DATA[playerid][data_GUN][6] = strval (temp);
		cache_get_field_content(0, "gun7", temp), PLAYER_DATA[playerid][data_GUN][7] = strval (temp);
		cache_get_field_content(0, "gun8", temp), PLAYER_DATA[playerid][data_GUN][8] = strval (temp);
		cache_get_field_content(0, "gun9", temp), PLAYER_DATA[playerid][data_GUN][9] = strval (temp);
		cache_get_field_content(0, "gun10", temp), PLAYER_DATA[playerid][data_GUN][10] = strval (temp);
		cache_get_field_content(0, "gun11", temp), PLAYER_DATA[playerid][data_GUN][11] = strval (temp);
		cache_get_field_content(0, "gun12", temp), PLAYER_DATA[playerid][data_GUN][12] = strval (temp);
		cache_get_field_content(0, "ammo0", temp), PLAYER_DATA[playerid][data_AMMO][0] = strval (temp);
		cache_get_field_content(0, "ammo1", temp), PLAYER_DATA[playerid][data_AMMO][1] = strval (temp);
		cache_get_field_content(0, "ammo2", temp), PLAYER_DATA[playerid][data_AMMO][2] = strval (temp);
		cache_get_field_content(0, "ammo3", temp), PLAYER_DATA[playerid][data_AMMO][3] = strval (temp);
		cache_get_field_content(0, "ammo4", temp), PLAYER_DATA[playerid][data_AMMO][4] = strval (temp);
		cache_get_field_content(0, "ammo5", temp), PLAYER_DATA[playerid][data_AMMO][5] = strval (temp);
		cache_get_field_content(0, "ammo6", temp), PLAYER_DATA[playerid][data_AMMO][6] = strval (temp);
		cache_get_field_content(0, "ammo7", temp), PLAYER_DATA[playerid][data_AMMO][7] = strval (temp);
		cache_get_field_content(0, "ammo8", temp), PLAYER_DATA[playerid][data_AMMO][8] = strval (temp);
		cache_get_field_content(0, "ammo9", temp), PLAYER_DATA[playerid][data_AMMO][9] = strval (temp);
		cache_get_field_content(0, "ammo10", temp), PLAYER_DATA[playerid][data_AMMO][10] = strval (temp);
		cache_get_field_content(0, "ammo11", temp), PLAYER_DATA[playerid][data_AMMO][11] = strval (temp);
		cache_get_field_content(0, "ammo12", temp), PLAYER_DATA[playerid][data_AMMO][12] = strval (temp);
 	    cache_get_field_content(0, "golos", temp), PLAYER_DATA[playerid][data_GOLOS] = strval (temp);
        cache_get_field_content(0, "pistol_skill", temp), PLAYER_DATA[playerid][data_PISTOL] = strval (temp);
		cache_get_field_content(0, "sdpistol_skill", temp), PLAYER_DATA[playerid][data_SDPISTOL] = strval (temp);
		cache_get_field_content(0, "deagle_skill", temp), PLAYER_DATA[playerid][data_DEAGLE] = strval (temp);
		cache_get_field_content(0, "shotgun_skill", temp), PLAYER_DATA[playerid][data_SHOTGUN] = strval (temp);
		cache_get_field_content(0, "mp5_skill", temp), PLAYER_DATA[playerid][data_MP5] = strval (temp);
		cache_get_field_content(0, "ak47_skill", temp), PLAYER_DATA[playerid][data_AK47] = strval (temp);
		cache_get_field_content(0, "rifle_skill", temp), PLAYER_DATA[playerid][data_SNIPERRIFLE] = strval (temp);
		cache_get_field_content(0, "zakon", temp), PLAYER_DATA[playerid][data_ZAKON] = strval (temp);
		cache_get_field_content(0, "promocode", temp), PLAYER_DATA[playerid][data_PROMOCODE] = strval (temp);
		cache_get_field_content(0, "vip", temp), PLAYER_DATA[playerid][data_VIP] = strval (temp);
		cache_get_field_content(0, "viptime", temp), PLAYER_DATA[playerid][data_VIPTIME] = strval (temp);
		cache_get_field_content(0, "time", temp), PLAYER_DATA[playerid][data_TIME] = strval (temp);
        cache_get_field_content(0, "admcode", temp), PLAYER_DATA[playerid][data_ECODE] = strval (temp);
		cache_get_field_content(0, "car_POSX_1", temp), PLAYER_DATA[playerid][data_CARX][0] = strval (temp);
		cache_get_field_content(0, "car_POSY_1", temp), PLAYER_DATA[playerid][data_CARY][0] = strval (temp);
		cache_get_field_content(0, "car_POSZ_1", temp), PLAYER_DATA[playerid][data_CARZ][0] = strval (temp);
		cache_get_field_content(0, "car_POSR_1", temp), PLAYER_DATA[playerid][data_CARANGLE][0] = strval (temp);
		cache_get_field_content(0, "car_POSX_2", temp), PLAYER_DATA[playerid][data_CARX][1] = strval (temp);
		cache_get_field_content(0, "car_POSY_2", temp), PLAYER_DATA[playerid][data_CARY][1] = strval (temp);
		cache_get_field_content(0, "car_POSZ_2", temp), PLAYER_DATA[playerid][data_CARZ][1] = strval (temp);
		cache_get_field_content(0, "car_POSR_2", temp), PLAYER_DATA[playerid][data_CARANGLE][1] = strval (temp);
		cache_get_field_content(0, "car_POSX_3", temp), PLAYER_DATA[playerid][data_CARX][2] = strval (temp);
		cache_get_field_content(0, "car_POSY_3", temp), PLAYER_DATA[playerid][data_CARY][2] = strval (temp);
		cache_get_field_content(0, "car_POSZ_3", temp), PLAYER_DATA[playerid][data_CARZ][2] = strval (temp);
		cache_get_field_content(0, "car_POSR_3", temp), PLAYER_DATA[playerid][data_CARANGLE][2] = strval (temp);
		cache_get_field_content(0, "car_POSX_4", temp), PLAYER_DATA[playerid][data_CARX][3] = strval (temp);
		cache_get_field_content(0, "car_POSY_4", temp), PLAYER_DATA[playerid][data_CARY][3] = strval (temp);
		cache_get_field_content(0, "car_POSZ_4", temp), PLAYER_DATA[playerid][data_CARZ][3] = strval (temp);
		cache_get_field_content(0, "car_POSR_4", temp), PLAYER_DATA[playerid][data_CARANGLE][3] = strval (temp);
		cache_get_field_content(0, "car_NUMBER_1", car_NUMBER[playerid][0], dbHandle, 64);
		cache_get_field_content(0, "car_NUMBER_2", car_NUMBER[playerid][1], dbHandle, 64);
		cache_get_field_content(0, "car_NUMBER_3", car_NUMBER[playerid][2], dbHandle, 64);
		cache_get_field_content(0, "car_NUMBER_4", car_NUMBER[playerid][3], dbHandle, 64);
		cache_get_field_content(0, "lastvisit", PLAYER_DATA[playerid][data_LASTVISIT], dbHandle, 64);
		cache_get_field_content(0, "ckick", temp), PLAYER_DATA[playerid][data_CKICK] = strval (temp);
		cache_get_field_content(0, "cban", temp), PLAYER_DATA[playerid][data_CBAN] = strval (temp);
		cache_get_field_content(0, "cjail", temp), PLAYER_DATA[playerid][data_CJAIL] = strval (temp);
		cache_get_field_content(0, "creport", temp), PLAYER_DATA[playerid][data_CREPORT] = strval (temp);
		cache_get_field_content(0, "cmute", temp), PLAYER_DATA[playerid][data_CMUTE] = strval (temp);
		cache_get_field_content(0, "cslap", temp), PLAYER_DATA[playerid][data_CSLAP] = strval (temp);
		cache_get_field_content(0, "cveh", temp), PLAYER_DATA[playerid][data_CVEH] = strval (temp);
		cache_get_field_content(0, "m_online", temp), PLAYER_DATA[playerid][data_MONLINE] = strval (temp);
		cache_get_field_content(0, "n_online", temp), PLAYER_DATA[playerid][data_NONLINE] = strval (temp);
		cache_get_field_content(0, "cadmtext", temp), PLAYER_DATA[playerid][data_CADMTEXT] = strval (temp);
		cache_get_field_content(0, "a_online", temp), PLAYER_DATA[playerid][data_AONLINE] = strval (temp);
	    cache_get_field_content(0, "admin_ban_time", temp), admin_ban_time[playerid] = strval (temp);
		cache_get_field_content(0, "mileage_1", temp), PLAYER_DATA[playerid][data_MILEAGE][0] = strval (temp);
		cache_get_field_content(0, "mileage_2", temp), PLAYER_DATA[playerid][data_MILEAGE][1] = strval (temp);
		cache_get_field_content(0, "mileage_3", temp), PLAYER_DATA[playerid][data_MILEAGE][2] = strval (temp);
		cache_get_field_content(0, "mileage_4", temp), PLAYER_DATA[playerid][data_MILEAGE][3] = strval (temp);
		cache_get_field_content(0, "pass", temp), PLAYER_DATA[playerid][data_PASS] = strval (temp);
		cache_get_field_content(0, "pass_s", temp), PLAYER_DATA[playerid][data_PASS_S] = strval (temp);
		cache_get_field_content(0, "pass_n", temp), PLAYER_DATA[playerid][data_PASS_N] = strval (temp);
		cache_get_field_content(0, "age", temp), PLAYER_DATA[playerid][data_AGE] = strval (temp);
        cache_get_field_content(0, "pass_date", PLAYER_DATA[playerid][data_PASS_DATE], dbHandle, 32);
        cache_get_field_content(0, "car_TUNING_1", car_TUNING[playerid][0], dbHandle, 128);
        cache_get_field_content(0, "car_TUNING_2", car_TUNING[playerid][1], dbHandle, 128);
        cache_get_field_content(0, "car_TUNING_3", car_TUNING[playerid][2], dbHandle, 128);
        cache_get_field_content(0, "car_TUNING_4", car_TUNING[playerid][3], dbHandle, 128);
        cache_get_field_content(0, "data_x", temp), PLAYER_DATA[playerid][data_X] = strval (temp);
		cache_get_field_content(0, "data_y", temp), PLAYER_DATA[playerid][data_Y] = strval (temp);
		cache_get_field_content(0, "data_z", temp), PLAYER_DATA[playerid][data_Z] = strval (temp);
		cache_get_field_content(0, "world_car1", temp), PLAYER_DATA[playerid][data_WORLD_CAR][0] = strval (temp);
		cache_get_field_content(0, "world_car2", temp), PLAYER_DATA[playerid][data_WORLD_CAR][1] = strval (temp);
		cache_get_field_content(0, "world_car3", temp), PLAYER_DATA[playerid][data_WORLD_CAR][2] = strval (temp);
		cache_get_field_content(0, "world_car4", temp), PLAYER_DATA[playerid][data_WORLD_CAR][3] = strval (temp);
		cache_get_field_content(0, "pSiga", temp), PLAYER_DATA[playerid][data_pSiga] = strval (temp);
		cache_get_field_content(0, "pSpal", temp), PLAYER_DATA[playerid][data_pSpal] = strval (temp);
		cache_get_field_content(0, "pSgf", temp), PLAYER_DATA[playerid][data_pSgf] = strval (temp);
		cache_get_field_content(0, "Hunger", temp), PLAYER_DATA[playerid][data_Hunger] = strval (temp);
		cache_get_field_content(0, "Thirst", temp), PLAYER_DATA[playerid][data_Thirst] = strval (temp);
		cache_get_field_content(0, "Piss", temp), PLAYER_DATA[playerid][data_Piss] = strval (temp);
		cache_get_field_content(0, "Sleep", temp), PLAYER_DATA[playerid][data_Sleep] = strval (temp);
		cache_get_field_content(0, "tros", temp), PLAYER_DATA[playerid][data_tros] = strval (temp);
		cache_get_field_content(0, "voenbilet", temp), PLAYER_DATA[playerid][data_voenbilet] = strval (temp);
		cache_get_field_content(0, "ud", temp), PLAYER_DATA[playerid][data_ud] = strval (temp);
		cache_get_field_content(0, "udhp", temp), PLAYER_DATA[playerid][data_udhp] = strval (temp);
		cache_get_field_content(0, "worms", temp), PLAYER_DATA[playerid][data_worms] = strval (temp);
		cache_get_field_content(0, "z", temp), PLAYER_DATA[playerid][data_ZCHAT] = strval (temp);
		cache_get_field_content(0, "gr", temp), PLAYER_DATA[playerid][data_GR] = strval (temp);
		cache_get_field_content(0, "qq", temp), PLAYER_DATA[playerid][data_QQ] = strval (temp);
		cache_get_field_content(0, "ktp", temp), PLAYER_DATA[playerid][data_KTP] = strval (temp);
		cache_get_field_content(0, "kstp", temp), PLAYER_DATA[playerid][data_KSTP] = strval (temp);
		cache_get_field_content(0, "sl", temp), PLAYER_DATA[playerid][data_SL] = strval (temp);
		cache_get_field_content(0, "zm", temp), PLAYER_DATA[playerid][data_ZM] = strval (temp);
		cache_get_field_content(0, "vjail", temp), PLAYER_DATA[playerid][data_VJAIL] = strval (temp);
		cache_get_field_content(0, "spaw", temp), PLAYER_DATA[playerid][data_SPAW] = strval (temp);
		cache_get_field_content(0, "ota", temp), PLAYER_DATA[playerid][data_OTA] = strval (temp);
     	cache_get_field_content(0, "res", temp), PLAYER_DATA[playerid][data_RES] = strval (temp);
		cache_get_field_content(0, "resc", temp), PLAYER_DATA[playerid][data_RESC] = strval (temp);
		cache_get_field_content(0, "rescar", temp), PLAYER_DATA[playerid][data_RESCAR] = strval (temp);
		cache_get_field_content(0, "tpcar", temp), PLAYER_DATA[playerid][data_TPCAR] = strval (temp);
		cache_get_field_content(0, "tpcark", temp), PLAYER_DATA[playerid][data_TPCARK] = strval (temp);
		cache_get_field_content(0, "dveh", temp), PLAYER_DATA[playerid][data_DVEH] = strval (temp);
		cache_get_field_content(0, "alldveh", temp), PLAYER_DATA[playerid][data_ALLDVEH] = strval (temp);
		cache_get_field_content(0, "ory", temp), PLAYER_DATA[playerid][data_ORY] = strval (temp);
		cache_get_field_content(0, "swarn", temp), PLAYER_DATA[playerid][data_SWARN] = strval (temp);
		cache_get_field_content(0, "rban", temp), PLAYER_DATA[playerid][data_RBAN] = strval (temp);
		cache_get_field_content(0, "cc", temp), PLAYER_DATA[playerid][data_CC] = strval (temp);
		cache_get_field_content(0, "nik", temp), PLAYER_DATA[playerid][data_NIK] = strval (temp);
	    cache_get_field_content(0, "zapr", temp), PLAYER_DATA[playerid][data_ZAPR] = strval (temp);
        cache_get_field_content(0, "selfipalk", temp), PLAYER_DATA[playerid][data_SELFPALK] = strval (temp);
	    cache_get_field_content(0, "vig", temp), PLAYER_DATA[playerid][data_VIG] = strval (temp);
	   
        sscanf(car_TUNING[playerid][0], "p<,>iiiiiiiii", PLAYER_DATA[playerid][data_TUNING_ID_1][0], PLAYER_DATA[playerid][data_TUNING_ID_1][1], PLAYER_DATA[playerid][data_TUNING_ID_1][2], PLAYER_DATA[playerid][data_TUNING_ID_1][3], PLAYER_DATA[playerid][data_TUNING_ID_1][4], PLAYER_DATA[playerid][data_TUNING_ID_1][5], PLAYER_DATA[playerid][data_TUNING_ID_1][6], PLAYER_DATA[playerid][data_TUNING_ID_1][7], PLAYER_DATA[playerid][data_TUNING_ID_1][8]);
        sscanf(car_TUNING[playerid][1], "p<,>iiiiiiiii", PLAYER_DATA[playerid][data_TUNING_ID_2][0], PLAYER_DATA[playerid][data_TUNING_ID_2][1], PLAYER_DATA[playerid][data_TUNING_ID_2][2], PLAYER_DATA[playerid][data_TUNING_ID_2][3], PLAYER_DATA[playerid][data_TUNING_ID_2][4], PLAYER_DATA[playerid][data_TUNING_ID_2][5], PLAYER_DATA[playerid][data_TUNING_ID_2][6], PLAYER_DATA[playerid][data_TUNING_ID_2][7], PLAYER_DATA[playerid][data_TUNING_ID_2][8]);
        sscanf(car_TUNING[playerid][2], "p<,>iiiiiiiii", PLAYER_DATA[playerid][data_TUNING_ID_3][0], PLAYER_DATA[playerid][data_TUNING_ID_3][1], PLAYER_DATA[playerid][data_TUNING_ID_3][2], PLAYER_DATA[playerid][data_TUNING_ID_3][3], PLAYER_DATA[playerid][data_TUNING_ID_3][4], PLAYER_DATA[playerid][data_TUNING_ID_3][5], PLAYER_DATA[playerid][data_TUNING_ID_3][6], PLAYER_DATA[playerid][data_TUNING_ID_3][7], PLAYER_DATA[playerid][data_TUNING_ID_3][8]);
        sscanf(car_TUNING[playerid][3], "p<,>iiiiiiiii", PLAYER_DATA[playerid][data_TUNING_ID_4][0], PLAYER_DATA[playerid][data_TUNING_ID_4][1], PLAYER_DATA[playerid][data_TUNING_ID_4][2], PLAYER_DATA[playerid][data_TUNING_ID_4][3], PLAYER_DATA[playerid][data_TUNING_ID_4][4], PLAYER_DATA[playerid][data_TUNING_ID_4][5], PLAYER_DATA[playerid][data_TUNING_ID_4][6], PLAYER_DATA[playerid][data_TUNING_ID_4][7], PLAYER_DATA[playerid][data_TUNING_ID_4][8]);
        
		new visit_str[128];
		format(visit_str, sizeof visit_str, "Urban History Role Play: {FFFFFF}Последний вход в аккаунт был выполнен: {DCF58A}< %s >", PLAYER_DATA[playerid][data_LASTVISIT]);
		SendClientMessage(playerid, 0x5BA0D4AA, visit_str);
    	
    	for(new i = 0; i < 13; i++)
		{
		    if(PLAYER_DATA[playerid][data_GUN][i] != 0 && PLAYER_DATA[playerid][data_AMMO][i] != 0) GivePlayerWeapon(playerid, PLAYER_DATA[playerid][data_GUN][i], PLAYER_DATA[playerid][data_AMMO][i]);
		}
		new c_[MAX_PLAYERS] = 0;
		for(new c; c < 4; c++)
		{
		    if(PLAYER_DATA[playerid][data_CAR] != 0) c_[playerid] ++;
		}
		if(c_[playerid])
			SendClientMessage(playerid, COLOR_ORANGE, "Вы являетесь владельцем автомобиля. Чтобы загрузить автомобиль в игру, используйте /fixcar");

		if(PLAYER_DATA[playerid][data_VIP] != 0)
		{
			if(gettime() >= PLAYER_DATA[playerid][data_VIPTIME])
	        {
				SendClientMessage(playerid, COLOR_ORANGE, "Срок действия Вашего VIP аккаунта закончился");
				PLAYER_DATA[playerid][data_VIP] = 0;
				PLAYER_DATA[playerid][data_VIPTIME] = 0;
			}
			else
			{
				new format_vip_text[128];

				format(format_vip_text, sizeof format_vip_text, "На Вашем аккаунте имеется VIP статус на %d дней. Истекает: %s", ((PLAYER_DATA[playerid][data_VIPTIME] - gettime()) / 86400) + 1, date("%dd.%mm.%yyyy / %hh:%ii:%ss", PLAYER_DATA[playerid][data_VIPTIME]));
				SendClientMessage(playerid, COLOR_ORANGE, format_vip_text);
			}
		}
      if(PLAYER_DATA[playerid][data_ADMLVL] >= 1)
{
            ShowPlayerDialogFix(playerid, dialog_ALOGIN, DIALOG_STYLE_INPUT,"{4E94D9}Авторизация в АП","\
{FFFFFF}Вы имеете полномочия администратора на нашем сервере\n\
Для продолжения игры на сервере, Вам необходимо указать спец. пароль администратора\n\
Пароль должен состоять только цифр, длина его - не ограничена\n\
Введите пароль в строчку ниже, проверив его правильность:\n\n\
{FB5F7C}При нажатии на клавишу 'ESC' или 'Отмена', Вы будете кикнуты с сервера","Далее","Отмена");
return true;
}
else
{
ShowPlayerDialogFix(playerid, dialog_LOADSPAWN, DIALOG_STYLE_LIST, "{4485B3}Выберите место появления", "{F2EF15}1. {FFFFFF}База организации\n{F2EF15}2. {FFFFFF}Ж/Д Вокзал\n{F2EF15}3. {FFFFFF}Дом / квартира\n{F2EF15}4. {FFFFFF}Место, где вышел с сервера", "Выбрать", "Закрыть");
}
 
 
        DeletePVar(playerid,"player_auth");
        PLAYER_DATA[playerid][data_LOGGED] = true;
        CancelSelectTextDraw(playerid);
        TogglePlayerControllable(playerid, true);
 
  SpawnPlayerAC(playerid);
 
 
}
else
{
    new wrongtext[145];
        if (GetPVarInt(playerid, "WrongPassword") == 3) return Kick(playerid);
        SetPVarInt(playerid, "WrongPassword", GetPVarInt ( playerid, "WrongPassword") + 1);
format(wrongtext,sizeof(wrongtext),"Вы ввели неправильный пароль! Осталось попыток %d/3",GetPVarInt(playerid,"WrongPassword"));
SendClientMessage(playerid, 0xFF333300, wrongtext);
Dialog_PLAYER_LOGIN(playerid);
}
 
return true;
}

 

Изменено пользователем АЛЕКСАНДР МАМАЕВ

Поделиться сообщением

Ссылка на сообщение
Поделиться на другие сайты

gegelo    22

gegelo
Опубликовано

@АЛЕКСАНДР МАМАЕВ, строк записи в некоторых запросах нет, мб из-за этого.

Попробуй:

public LoadPlayerData(playerid)
{
	new rows, fields, temp[20],login_ip[32];
    cache_get_data(rows, fields);
    if(rows)
	{
		cache_get_field_content(0, "id", temp), PLAYER_DATA[playerid][data_ID] = strval (temp);
		cache_get_field_content(0, "money", temp), PLAYER_DATA[playerid][data_MONEY] = strval (temp);
		cache_get_field_content(0, "donate", temp), PLAYER_DATA[playerid][data_DONATE] = strval (temp);
		cache_get_field_content(0, "sex", temp), PLAYER_DATA[playerid][data_SEX] = strval (temp);
		cache_get_field_content(0, "skin", temp), PLAYER_DATA[playerid][data_SKIN] = strval (temp);
		cache_get_field_content(0, "lvl", temp), PLAYER_DATA[playerid][data_LVL] = strval (temp);
		cache_get_field_content(0, "exp", temp), PLAYER_DATA[playerid][data_EXP] = strval (temp);
		cache_get_field_content(0, "member", temp), PLAYER_DATA[playerid][data_MEMBER] = strval (temp);
		cache_get_field_content(0, "podmember", temp), PLAYER_DATA[playerid][data_PODMEMBER] = strval (temp);
		cache_get_field_content(0, "rank", temp), PLAYER_DATA[playerid][data_RANK] = strval (temp);
		cache_get_field_content(0, "skinm", temp), PLAYER_DATA[playerid][data_SKINM] = strval (temp);
		cache_get_field_content(0, "leader", temp), PLAYER_DATA[playerid][data_LEADER] = strval (temp);
		cache_get_field_content(0, "admlvl", temp), PLAYER_DATA[playerid][data_ADMLVL] = strval (temp);
		cache_get_field_content(0, "register_ip", temp), PLAYER_DATA[playerid][data_REGISTER_IP], dbHandle, 32);
		cache_get_field_content(0, "login_ip", temp), login_ip, dbHandle, 32);
		cache_get_field_content(0, "regdate_day", temp), PLAYER_DATA[playerid][data_REGDATE_DAY] = strval (temp);
		cache_get_field_content(0, "regdate_month", temp), PLAYER_DATA[playerid][data_REGDATE_MONTH] = strval (temp);
		cache_get_field_content(0, "regdate_year", temp), PLAYER_DATA[playerid][data_REGDATE_YEAR] = strval (temp);
		cache_get_field_content(0, "mute", temp), PLAYER_DATA[playerid][data_MUTE] = strval (temp);
		cache_get_field_content(0, "mutetime", temp), PLAYER_DATA[playerid][data_MUTETIME] = strval (temp);
		cache_get_field_content(0, "warn", temp), PLAYER_DATA[playerid][data_WARN] = strval (temp);
		cache_get_field_content(0, "warntime", temp), PLAYER_DATA[playerid][data_WARNTIME] = strval (temp);
		cache_get_field_content(0, "salary", temp), PLAYER_DATA[playerid][data_SALARY] = strval (temp);
		cache_get_field_content(0, "bank", temp), PLAYER_DATA[playerid][data_BANK] = strval (temp);
		cache_get_field_content(0, "licb", temp), PLAYER_DATA[playerid][data_LICB] = strval (temp);
		cache_get_field_content(0, "licg", temp), PLAYER_DATA[playerid][data_LICG] = strval (temp);
		cache_get_field_content(0, "business", temp), PLAYER_DATA[playerid][data_BUSINESS] = strval (temp);
		cache_get_field_content(0, "house", temp), PLAYER_DATA[playerid][data_HOUSE] = strval (temp);
		cache_get_field_content(0, "kv", temp), PLAYER_DATA[playerid][data_KV] = strval (temp);
        cache_get_field_content(0, "padik", temp), PLAYER_DATA[playerid][data_PADIK] = strval (temp);
	    cache_get_field_content(0, "ab", temp), PLAYER_DATA[playerid][data_AB] = strval (temp);
   		cache_get_field_content(0, "car_1", temp), PLAYER_DATA[playerid][data_CAR][0] = strval (temp);
		cache_get_field_content(0, "carfuel_1", temp), PLAYER_DATA[playerid][data_CARFUEL][0] = strval (temp);
		cache_get_field_content(0, "car_color1_1", temp), PLAYER_DATA[playerid][data_CAR_COLOR1][0] = strval (temp);
		cache_get_field_content(0, "car_color2_1", temp), PLAYER_DATA[playerid][data_CAR_COLOR2][0] = strval (temp);
		cache_get_field_content(0, "car_2", temp), PLAYER_DATA[playerid][data_CAR][1] = strval (temp);
		cache_get_field_content(0, "carfuel_2", temp), PLAYER_DATA[playerid][data_CARFUEL][1] = strval (temp);
		cache_get_field_content(0, "car_color1_2", temp), PLAYER_DATA[playerid][data_CAR_COLOR1][1] = strval (temp);
		cache_get_field_content(0, "car_color2_2", temp), PLAYER_DATA[playerid][data_CAR_COLOR2][1] = strval (temp);
		cache_get_field_content(0, "car_3", temp), PLAYER_DATA[playerid][data_CAR][2] = strval (temp);
		cache_get_field_content(0, "carfuel_3", temp), PLAYER_DATA[playerid][data_CARFUEL][2] = strval (temp);
		cache_get_field_content(0, "car_color1_3", temp), PLAYER_DATA[playerid][data_CAR_COLOR1][2] = strval (temp);
		cache_get_field_content(0, "car_color2_3", temp), PLAYER_DATA[playerid][data_CAR_COLOR2][2] = strval (temp);
		cache_get_field_content(0, "car_4", temp), PLAYER_DATA[playerid][data_CAR][3] = strval (temp);
		cache_get_field_content(0, "carfuel_4", temp), PLAYER_DATA[playerid][data_CARFUEL][3] = strval (temp);
		cache_get_field_content(0, "car_color1_4", temp), PLAYER_DATA[playerid][data_CAR_COLOR1][3] = strval (temp);
		cache_get_field_content(0, "car_color2_4", temp), PLAYER_DATA[playerid][data_CAR_COLOR2][3] = strval (temp);
	    cache_get_field_content(0, "patr", temp), PLAYER_DATA[playerid][data_PATR] = strval (temp);
	    cache_get_field_content(0, "drugs", temp), PLAYER_DATA[playerid][data_NARKO] = strval (temp);
    	cache_get_field_content(0, "wanted", temp), PLAYER_DATA[playerid][data_WANTED] = strval (temp);
		cache_get_field_content(0, "number", temp), PLAYER_DATA[playerid][data_NUMBER] = strval (temp);
		cache_get_field_content(0, "number_m", temp), PLAYER_DATA[playerid][data_NUMBER_M] = strval (temp);
		cache_get_field_content(0, "jail", temp), PLAYER_DATA[playerid][data_JAIL] = strval (temp);
		cache_get_field_content(0, "jailtime", temp), PLAYER_DATA[playerid][data_JAILTIME] = strval (temp);
		cache_get_field_content(0, "phone", temp), PLAYER_DATA[playerid][data_PHONE] = strval (temp);
		cache_get_field_content(0, "hp", temp), PLAYER_DATA[playerid][data_HP] = strval (temp);
		cache_get_field_content(0, "arm", temp), PLAYER_DATA[playerid][data_ARM] = strval (temp);
		cache_get_field_content(0, "med", temp), PLAYER_DATA[playerid][data_MED] = strval (temp);
		cache_get_field_content(0, "spawn", temp), PLAYER_DATA[playerid][data_SPAWN] = strval (temp);
		cache_get_field_content(0, "hospital", temp), PLAYER_DATA[playerid][data_HOSPITAL] = strval (temp);
		cache_get_field_content(0, "job", temp), PLAYER_DATA[playerid][data_JOB] = strval (temp);
	    cache_get_field_content(0, "polit", temp), PLAYER_DATA[playerid][data_POLIT] = strval (temp);
        cache_get_field_content(0, "gun0", temp), PLAYER_DATA[playerid][data_GUN][0] = strval (temp);
		cache_get_field_content(0, "gun1", temp), PLAYER_DATA[playerid][data_GUN][1] = strval (temp);
		cache_get_field_content(0, "gun2", temp), PLAYER_DATA[playerid][data_GUN][2] = strval (temp);
		cache_get_field_content(0, "gun3", temp), PLAYER_DATA[playerid][data_GUN][3] = strval (temp);
		cache_get_field_content(0, "gun4", temp), PLAYER_DATA[playerid][data_GUN][4] = strval (temp);
		cache_get_field_content(0, "gun5", temp), PLAYER_DATA[playerid][data_GUN][5] = strval (temp);
		cache_get_field_content(0, "gun6", temp), PLAYER_DATA[playerid][data_GUN][6] = strval (temp);
		cache_get_field_content(0, "gun7", temp), PLAYER_DATA[playerid][data_GUN][7] = strval (temp);
		cache_get_field_content(0, "gun8", temp), PLAYER_DATA[playerid][data_GUN][8] = strval (temp);
		cache_get_field_content(0, "gun9", temp), PLAYER_DATA[playerid][data_GUN][9] = strval (temp);
		cache_get_field_content(0, "gun10", temp), PLAYER_DATA[playerid][data_GUN][10] = strval (temp);
		cache_get_field_content(0, "gun11", temp), PLAYER_DATA[playerid][data_GUN][11] = strval (temp);
		cache_get_field_content(0, "gun12", temp), PLAYER_DATA[playerid][data_GUN][12] = strval (temp);
		cache_get_field_content(0, "ammo0", temp), PLAYER_DATA[playerid][data_AMMO][0] = strval (temp);
		cache_get_field_content(0, "ammo1", temp), PLAYER_DATA[playerid][data_AMMO][1] = strval (temp);
		cache_get_field_content(0, "ammo2", temp), PLAYER_DATA[playerid][data_AMMO][2] = strval (temp);
		cache_get_field_content(0, "ammo3", temp), PLAYER_DATA[playerid][data_AMMO][3] = strval (temp);
		cache_get_field_content(0, "ammo4", temp), PLAYER_DATA[playerid][data_AMMO][4] = strval (temp);
		cache_get_field_content(0, "ammo5", temp), PLAYER_DATA[playerid][data_AMMO][5] = strval (temp);
		cache_get_field_content(0, "ammo6", temp), PLAYER_DATA[playerid][data_AMMO][6] = strval (temp);
		cache_get_field_content(0, "ammo7", temp), PLAYER_DATA[playerid][data_AMMO][7] = strval (temp);
		cache_get_field_content(0, "ammo8", temp), PLAYER_DATA[playerid][data_AMMO][8] = strval (temp);
		cache_get_field_content(0, "ammo9", temp), PLAYER_DATA[playerid][data_AMMO][9] = strval (temp);
		cache_get_field_content(0, "ammo10", temp), PLAYER_DATA[playerid][data_AMMO][10] = strval (temp);
		cache_get_field_content(0, "ammo11", temp), PLAYER_DATA[playerid][data_AMMO][11] = strval (temp);
		cache_get_field_content(0, "ammo12", temp), PLAYER_DATA[playerid][data_AMMO][12] = strval (temp);
 	    cache_get_field_content(0, "golos", temp), PLAYER_DATA[playerid][data_GOLOS] = strval (temp);
        cache_get_field_content(0, "pistol_skill", temp), PLAYER_DATA[playerid][data_PISTOL] = strval (temp);
		cache_get_field_content(0, "sdpistol_skill", temp), PLAYER_DATA[playerid][data_SDPISTOL] = strval (temp);
		cache_get_field_content(0, "deagle_skill", temp), PLAYER_DATA[playerid][data_DEAGLE] = strval (temp);
		cache_get_field_content(0, "shotgun_skill", temp), PLAYER_DATA[playerid][data_SHOTGUN] = strval (temp);
		cache_get_field_content(0, "mp5_skill", temp), PLAYER_DATA[playerid][data_MP5] = strval (temp);
		cache_get_field_content(0, "ak47_skill", temp), PLAYER_DATA[playerid][data_AK47] = strval (temp);
		cache_get_field_content(0, "rifle_skill", temp), PLAYER_DATA[playerid][data_SNIPERRIFLE] = strval (temp);
		cache_get_field_content(0, "zakon", temp), PLAYER_DATA[playerid][data_ZAKON] = strval (temp);
		cache_get_field_content(0, "promocode", temp), PLAYER_DATA[playerid][data_PROMOCODE] = strval (temp);
		cache_get_field_content(0, "vip", temp), PLAYER_DATA[playerid][data_VIP] = strval (temp);
		cache_get_field_content(0, "viptime", temp), PLAYER_DATA[playerid][data_VIPTIME] = strval (temp);
		cache_get_field_content(0, "time", temp), PLAYER_DATA[playerid][data_TIME] = strval (temp);
        cache_get_field_content(0, "admcode", temp), PLAYER_DATA[playerid][data_ECODE] = strval (temp);
		cache_get_field_content(0, "car_POSX_1", temp), PLAYER_DATA[playerid][data_CARX][0] = strval (temp);
		cache_get_field_content(0, "car_POSY_1", temp), PLAYER_DATA[playerid][data_CARY][0] = strval (temp);
		cache_get_field_content(0, "car_POSZ_1", temp), PLAYER_DATA[playerid][data_CARZ][0] = strval (temp);
		cache_get_field_content(0, "car_POSR_1", temp), PLAYER_DATA[playerid][data_CARANGLE][0] = strval (temp);
		cache_get_field_content(0, "car_POSX_2", temp), PLAYER_DATA[playerid][data_CARX][1] = strval (temp);
		cache_get_field_content(0, "car_POSY_2", temp), PLAYER_DATA[playerid][data_CARY][1] = strval (temp);
		cache_get_field_content(0, "car_POSZ_2", temp), PLAYER_DATA[playerid][data_CARZ][1] = strval (temp);
		cache_get_field_content(0, "car_POSR_2", temp), PLAYER_DATA[playerid][data_CARANGLE][1] = strval (temp);
		cache_get_field_content(0, "car_POSX_3", temp), PLAYER_DATA[playerid][data_CARX][2] = strval (temp);
		cache_get_field_content(0, "car_POSY_3", temp), PLAYER_DATA[playerid][data_CARY][2] = strval (temp);
		cache_get_field_content(0, "car_POSZ_3", temp), PLAYER_DATA[playerid][data_CARZ][2] = strval (temp);
		cache_get_field_content(0, "car_POSR_3", temp), PLAYER_DATA[playerid][data_CARANGLE][2] = strval (temp);
		cache_get_field_content(0, "car_POSX_4", temp), PLAYER_DATA[playerid][data_CARX][3] = strval (temp);
		cache_get_field_content(0, "car_POSY_4", temp), PLAYER_DATA[playerid][data_CARY][3] = strval (temp);
		cache_get_field_content(0, "car_POSZ_4", temp), PLAYER_DATA[playerid][data_CARZ][3] = strval (temp);
		cache_get_field_content(0, "car_POSR_4", temp), PLAYER_DATA[playerid][data_CARANGLE][3] = strval (temp);
		cache_get_field_content(0, "car_NUMBER_1", temp), car_NUMBER[playerid][0], dbHandle, 64);
		cache_get_field_content(0, "car_NUMBER_2", temp), car_NUMBER[playerid][1], dbHandle, 64);
		cache_get_field_content(0, "car_NUMBER_3", temp), car_NUMBER[playerid][2], dbHandle, 64);
		cache_get_field_content(0, "car_NUMBER_4", temp), car_NUMBER[playerid][3], dbHandle, 64);
		cache_get_field_content(0, "lastvisit", temp), PLAYER_DATA[playerid][data_LASTVISIT], dbHandle, 64);
		cache_get_field_content(0, "ckick", temp), PLAYER_DATA[playerid][data_CKICK] = strval (temp);
		cache_get_field_content(0, "cban", temp), PLAYER_DATA[playerid][data_CBAN] = strval (temp);
		cache_get_field_content(0, "cjail", temp), PLAYER_DATA[playerid][data_CJAIL] = strval (temp);
		cache_get_field_content(0, "creport", temp), PLAYER_DATA[playerid][data_CREPORT] = strval (temp);
		cache_get_field_content(0, "cmute", temp), PLAYER_DATA[playerid][data_CMUTE] = strval (temp);
		cache_get_field_content(0, "cslap", temp), PLAYER_DATA[playerid][data_CSLAP] = strval (temp);
		cache_get_field_content(0, "cveh", temp), PLAYER_DATA[playerid][data_CVEH] = strval (temp);
		cache_get_field_content(0, "m_online", temp), PLAYER_DATA[playerid][data_MONLINE] = strval (temp);
		cache_get_field_content(0, "n_online", temp), PLAYER_DATA[playerid][data_NONLINE] = strval (temp);
		cache_get_field_content(0, "cadmtext", temp), PLAYER_DATA[playerid][data_CADMTEXT] = strval (temp);
		cache_get_field_content(0, "a_online", temp), PLAYER_DATA[playerid][data_AONLINE] = strval (temp);
	    cache_get_field_content(0, "admin_ban_time", temp), admin_ban_time[playerid] = strval (temp);
		cache_get_field_content(0, "mileage_1", temp), PLAYER_DATA[playerid][data_MILEAGE][0] = strval (temp);
		cache_get_field_content(0, "mileage_2", temp), PLAYER_DATA[playerid][data_MILEAGE][1] = strval (temp);
		cache_get_field_content(0, "mileage_3", temp), PLAYER_DATA[playerid][data_MILEAGE][2] = strval (temp);
		cache_get_field_content(0, "mileage_4", temp), PLAYER_DATA[playerid][data_MILEAGE][3] = strval (temp);
		cache_get_field_content(0, "pass", temp), PLAYER_DATA[playerid][data_PASS] = strval (temp);
		cache_get_field_content(0, "pass_s", temp), PLAYER_DATA[playerid][data_PASS_S] = strval (temp);
		cache_get_field_content(0, "pass_n", temp), PLAYER_DATA[playerid][data_PASS_N] = strval (temp);
		cache_get_field_content(0, "age", temp), PLAYER_DATA[playerid][data_AGE] = strval (temp);
        cache_get_field_content(0, "pass_date", temp), PLAYER_DATA[playerid][data_PASS_DATE], dbHandle, 32);
        cache_get_field_content(0, "car_TUNING_1", temp), car_TUNING[playerid][0], dbHandle, 128);
        cache_get_field_content(0, "car_TUNING_2", temp), car_TUNING[playerid][1], dbHandle, 128);
        cache_get_field_content(0, "car_TUNING_3", temp), car_TUNING[playerid][2], dbHandle, 128);
        cache_get_field_content(0, "car_TUNING_4", temp), car_TUNING[playerid][3], dbHandle, 128);
        cache_get_field_content(0, "data_x", temp), PLAYER_DATA[playerid][data_X] = strval (temp);
		cache_get_field_content(0, "data_y", temp), PLAYER_DATA[playerid][data_Y] = strval (temp);
		cache_get_field_content(0, "data_z", temp), PLAYER_DATA[playerid][data_Z] = strval (temp);
		cache_get_field_content(0, "world_car1", temp), PLAYER_DATA[playerid][data_WORLD_CAR][0] = strval (temp);
		cache_get_field_content(0, "world_car2", temp), PLAYER_DATA[playerid][data_WORLD_CAR][1] = strval (temp);
		cache_get_field_content(0, "world_car3", temp), PLAYER_DATA[playerid][data_WORLD_CAR][2] = strval (temp);
		cache_get_field_content(0, "world_car4", temp), PLAYER_DATA[playerid][data_WORLD_CAR][3] = strval (temp);
		cache_get_field_content(0, "pSiga", temp), PLAYER_DATA[playerid][data_pSiga] = strval (temp);
		cache_get_field_content(0, "pSpal", temp), PLAYER_DATA[playerid][data_pSpal] = strval (temp);
		cache_get_field_content(0, "pSgf", temp), PLAYER_DATA[playerid][data_pSgf] = strval (temp);
		cache_get_field_content(0, "Hunger", temp), PLAYER_DATA[playerid][data_Hunger] = strval (temp);
		cache_get_field_content(0, "Thirst", temp), PLAYER_DATA[playerid][data_Thirst] = strval (temp);
		cache_get_field_content(0, "Piss", temp), PLAYER_DATA[playerid][data_Piss] = strval (temp);
		cache_get_field_content(0, "Sleep", temp), PLAYER_DATA[playerid][data_Sleep] = strval (temp);
		cache_get_field_content(0, "tros", temp), PLAYER_DATA[playerid][data_tros] = strval (temp);
		cache_get_field_content(0, "voenbilet", temp), PLAYER_DATA[playerid][data_voenbilet] = strval (temp);
		cache_get_field_content(0, "ud", temp), PLAYER_DATA[playerid][data_ud] = strval (temp);
		cache_get_field_content(0, "udhp", temp), PLAYER_DATA[playerid][data_udhp] = strval (temp);
		cache_get_field_content(0, "worms", temp), PLAYER_DATA[playerid][data_worms] = strval (temp);
		cache_get_field_content(0, "z", temp), PLAYER_DATA[playerid][data_ZCHAT] = strval (temp);
		cache_get_field_content(0, "gr", temp), PLAYER_DATA[playerid][data_GR] = strval (temp);
		cache_get_field_content(0, "qq", temp), PLAYER_DATA[playerid][data_QQ] = strval (temp);
		cache_get_field_content(0, "ktp", temp), PLAYER_DATA[playerid][data_KTP] = strval (temp);
		cache_get_field_content(0, "kstp", temp), PLAYER_DATA[playerid][data_KSTP] = strval (temp);
		cache_get_field_content(0, "sl", temp), PLAYER_DATA[playerid][data_SL] = strval (temp);
		cache_get_field_content(0, "zm", temp), PLAYER_DATA[playerid][data_ZM] = strval (temp);
		cache_get_field_content(0, "vjail", temp), PLAYER_DATA[playerid][data_VJAIL] = strval (temp);
		cache_get_field_content(0, "spaw", temp), PLAYER_DATA[playerid][data_SPAW] = strval (temp);
		cache_get_field_content(0, "ota", temp), PLAYER_DATA[playerid][data_OTA] = strval (temp);
     	cache_get_field_content(0, "res", temp), PLAYER_DATA[playerid][data_RES] = strval (temp);
		cache_get_field_content(0, "resc", temp), PLAYER_DATA[playerid][data_RESC] = strval (temp);
		cache_get_field_content(0, "rescar", temp), PLAYER_DATA[playerid][data_RESCAR] = strval (temp);
		cache_get_field_content(0, "tpcar", temp), PLAYER_DATA[playerid][data_TPCAR] = strval (temp);
		cache_get_field_content(0, "tpcark", temp), PLAYER_DATA[playerid][data_TPCARK] = strval (temp);
		cache_get_field_content(0, "dveh", temp), PLAYER_DATA[playerid][data_DVEH] = strval (temp);
		cache_get_field_content(0, "alldveh", temp), PLAYER_DATA[playerid][data_ALLDVEH] = strval (temp);
		cache_get_field_content(0, "ory", temp), PLAYER_DATA[playerid][data_ORY] = strval (temp);
		cache_get_field_content(0, "swarn", temp), PLAYER_DATA[playerid][data_SWARN] = strval (temp);
		cache_get_field_content(0, "rban", temp), PLAYER_DATA[playerid][data_RBAN] = strval (temp);
		cache_get_field_content(0, "cc", temp), PLAYER_DATA[playerid][data_CC] = strval (temp);
		cache_get_field_content(0, "nik", temp), PLAYER_DATA[playerid][data_NIK] = strval (temp);
	    cache_get_field_content(0, "zapr", temp), PLAYER_DATA[playerid][data_ZAPR] = strval (temp);
        cache_get_field_content(0, "selfipalk", temp), PLAYER_DATA[playerid][data_SELFPALK] = strval (temp);
	    cache_get_field_content(0, "vig", temp), PLAYER_DATA[playerid][data_VIG] = strval (temp);

        sscanf(car_TUNING[playerid][0], "p<,>iiiiiiiii", PLAYER_DATA[playerid][data_TUNING_ID_1][0], PLAYER_DATA[playerid][data_TUNING_ID_1][1], PLAYER_DATA[playerid][data_TUNING_ID_1][2], PLAYER_DATA[playerid][data_TUNING_ID_1][3], PLAYER_DATA[playerid][data_TUNING_ID_1][4], PLAYER_DATA[playerid][data_TUNING_ID_1][5], PLAYER_DATA[playerid][data_TUNING_ID_1][6], PLAYER_DATA[playerid][data_TUNING_ID_1][7], PLAYER_DATA[playerid][data_TUNING_ID_1][8]);
        sscanf(car_TUNING[playerid][1], "p<,>iiiiiiiii", PLAYER_DATA[playerid][data_TUNING_ID_2][0], PLAYER_DATA[playerid][data_TUNING_ID_2][1], PLAYER_DATA[playerid][data_TUNING_ID_2][2], PLAYER_DATA[playerid][data_TUNING_ID_2][3], PLAYER_DATA[playerid][data_TUNING_ID_2][4], PLAYER_DATA[playerid][data_TUNING_ID_2][5], PLAYER_DATA[playerid][data_TUNING_ID_2][6], PLAYER_DATA[playerid][data_TUNING_ID_2][7], PLAYER_DATA[playerid][data_TUNING_ID_2][8]);
        sscanf(car_TUNING[playerid][2], "p<,>iiiiiiiii", PLAYER_DATA[playerid][data_TUNING_ID_3][0], PLAYER_DATA[playerid][data_TUNING_ID_3][1], PLAYER_DATA[playerid][data_TUNING_ID_3][2], PLAYER_DATA[playerid][data_TUNING_ID_3][3], PLAYER_DATA[playerid][data_TUNING_ID_3][4], PLAYER_DATA[playerid][data_TUNING_ID_3][5], PLAYER_DATA[playerid][data_TUNING_ID_3][6], PLAYER_DATA[playerid][data_TUNING_ID_3][7], PLAYER_DATA[playerid][data_TUNING_ID_3][8]);
        sscanf(car_TUNING[playerid][3], "p<,>iiiiiiiii", PLAYER_DATA[playerid][data_TUNING_ID_4][0], PLAYER_DATA[playerid][data_TUNING_ID_4][1], PLAYER_DATA[playerid][data_TUNING_ID_4][2], PLAYER_DATA[playerid][data_TUNING_ID_4][3], PLAYER_DATA[playerid][data_TUNING_ID_4][4], PLAYER_DATA[playerid][data_TUNING_ID_4][5], PLAYER_DATA[playerid][data_TUNING_ID_4][6], PLAYER_DATA[playerid][data_TUNING_ID_4][7], PLAYER_DATA[playerid][data_TUNING_ID_4][8]);

		new visit_str[128];
		format(visit_str, sizeof visit_str, "Urban History Role Play: {FFFFFF}Последний вход в аккаунт был выполнен: {DCF58A}< %s >", PLAYER_DATA[playerid][data_LASTVISIT]);
		SendClientMessage(playerid, 0x5BA0D4AA, visit_str);

    	for(new i = 0; i < 13; i++)
		{
		    if(PLAYER_DATA[playerid][data_GUN][i] != 0 && PLAYER_DATA[playerid][data_AMMO][i] != 0) GivePlayerWeapon(playerid, PLAYER_DATA[playerid][data_GUN][i], PLAYER_DATA[playerid][data_AMMO][i]);
		}
		new c_[MAX_PLAYERS] = 0;
		for(new c; c < 4; c++)
		{
		    if(PLAYER_DATA[playerid][data_CAR] != 0) c_[playerid] ++;
		}
		if(c_[playerid])
			SendClientMessage(playerid, COLOR_ORANGE, "Вы являетесь владельцем автомобиля. Чтобы загрузить автомобиль в игру, используйте /fixcar");

		if(PLAYER_DATA[playerid][data_VIP] != 0)
		{
			if(gettime() >= PLAYER_DATA[playerid][data_VIPTIME])
	        {
				SendClientMessage(playerid, COLOR_ORANGE, "Срок действия Вашего VIP аккаунта закончился");
				PLAYER_DATA[playerid][data_VIP] = 0;
				PLAYER_DATA[playerid][data_VIPTIME] = 0;
			}
			else
			{
				new format_vip_text[128];

				format(format_vip_text, sizeof format_vip_text, "На Вашем аккаунте имеется VIP статус на %d дней. Истекает: %s", ((PLAYER_DATA[playerid][data_VIPTIME] - gettime()) / 86400) + 1, date("%dd.%mm.%yyyy / %hh:%ii:%ss", PLAYER_DATA[playerid][data_VIPTIME]));
				SendClientMessage(playerid, COLOR_ORANGE, format_vip_text);
			}
		}

Поделиться сообщением

Ссылка на сообщение
Поделиться на другие сайты

АЛЕКСАНДР МАМАЕВ    0

АЛЕКСАНДР МАМАЕВ
Опубликовано

@gegelo,  

 

непринял мод: (35352) : error 001: expected token: ";", but found ")"

(35352) : error 029: invalid expression, assumed zero
(35352) : warning 215: expression has no effect
(35353) : warning 215: expression has no effect
(35353) : warning 215: expression has no effect
(35353) : warning 215: expression has no effect
(35353) : error 001: expected token: ";", but found ")"
(35353) : error 029: invalid expression, assumed zero
(35353) : warning 215: expression has no effect
(35457) : warning 215: expression has no effect
(35457) : warning 215: expression has no effect
(35457) : warning 215: expression has no effect
(35457) : error 001: expected token: ";", but found ")"
(35457) : error 029: invalid expression, assumed zero и тд много вышло

Поделиться сообщением

Ссылка на сообщение
Поделиться на другие сайты

gegelo    22

gegelo
Опубликовано

@АЛЕКСАНДР МАМАЕВ, я уже тупанул, давно не юзал, забыл что строки записи не нужны там, не вставляй это. А когда почту удалял всё связанное с ней удалил, сравни с дампами. А то мы вокруг да около ходим.

 

И вот хороший совет.

 


Могу предложить вывести весь код сохранения в логи сервера...

Поделиться сообщением

Ссылка на сообщение
Поделиться на другие сайты

АЛЕКСАНДР МАМАЕВ    0

АЛЕКСАНДР МАМАЕВ
Опубликовано (изменено)

@gegelo, да всё удалил а как это делаеться Могу предложить вывести весь код сохранения в логи сервера...?

вот при регистрации после выбора скина сюда кидает всё как надо даётьсян ну лвл и з базы и тд ну из мода меняеться:

forward CreatePlayerAccount(playerid);
public CreatePlayerAccount(playerid)
{
	new rr_lvl, rre_money, rrr_money, rreg_prova, temp[10], r, f;
	cache_get_data(r, f);
	
	cache_get_field_content(0, "reglvl", temp), rr_lvl = strval (temp);
	cache_get_field_content(0, "regmoney", temp), rre_money = strval (temp);
	cache_get_field_content(0, "regrmoney", temp), rrr_money = strval (temp);
	cache_get_field_content(0, "rprova", temp), rreg_prova = strval (temp);

	for(new i; i < 14; i++) TextDrawHideForPlayer(playerid, select_skin[i]);
	CancelSelectTextDraw(playerid);

    if(GetPVarInt(playerid,"select_skin") == 0) return Kick(playerid);
    DeletePVar(playerid,"select_skin");
    PLAYER_DATA[playerid][data_SELECTSKIN] = false;
 	PLAYER_DATA[playerid][data_CLICKTD] = false;
    PLAYER_DATA[playerid][data_SKIN] = GetPlayerSkin(playerid);
    
    PLAYER_DATA[playerid][data_LVL] = rr_lvl;
	PLAYER_DATA[playerid][data_MONEY] = rre_money + random(rrr_money);
	PLAYER_DATA[playerid][data_ZAKON] = 10 + random(10);
	PLAYER_DATA[playerid][data_LICB] = rreg_prova;
	PLAYER_DATA[playerid][data_Hunger] = 30 + random(70);
	PLAYER_DATA[playerid][data_Thirst] = 20 + random(80);
	PLAYER_DATA[playerid][data_Piss] = 20 + random(50);
	PLAYER_DATA[playerid][data_Sleep] = 20 + random(50);
	PLAYER_DATA[playerid][data_HP] = 100.0;
	PLAYER_DATA[playerid][data_LOGGED] = true;
    TogglePlayerControllable(playerid, true);
    DeletePVar(playerid,"player_auth");
    for(new x; x <30; x++) SendClientMessage(playerid, -1, " ");
    SendClientMessage(playerid, 0x46A3F5FF, "Добро пожаловать на сервер");
	SendClientMessage(playerid, 0x46A3F5FF, "Если вы новичок, то обязательно прочитайте помощь на спавне (место где вы появляетесь в игре)");
	SendClientMessage(playerid, 0x46A3F5FF, "По любому вопросу, вы можете обратиться к Администрации сервера с помощью команды /mn > репорт");
	SendClientMessage(playerid, 0x46A3F5FF, "Для того, чтобы ввести команду нажмите клавишу F6 или английскую T (все команды начинаются с символа '/')");
	SendClientMessage(playerid, 0x46A3F5FF, "Нужные вам команды вы можете посмотреть с помощью команды /mn > список команд");
	CreateAccount(playerid);
	SetPlayerSpawn(playerid);
	return true;
}

но потом должно ити на сохранение тоесть сюда CreateAccount ну я так понел вроде так может тут что то потомучто что после скина даёться но несохраняеться может и за этого и при перезаходе непринимает пароль:

stock CreateAccount(playerid)
{
	new query[300];
    mysql_format(dbHandle, query, sizeof(query), "INSERT INTO `accounts` ( `name`, `password`, `register_ip`, `referal`, `sex`, `regdate_day`, `regdate_month`, `regdate_year`, `skin`) VALUES ( '%e', '%e', '%s', '%s', '%d', '%d', '%d', '%d', '%d')",
	PLAYER_DATA[playerid][data_NAME],PLAYER_DATA[playerid][data_PASSWORD],PLAYER_DATA[playerid][data_REGISTER_IP],PLAYER_DATA[playerid][data_REFERAL],PLAYER_DATA[playerid][data_SEX],PLAYER_DATA[playerid][data_REGDATE_DAY],PLAYER_DATA[playerid][data_REGDATE_MONTH],PLAYER_DATA[playerid][data_REGDATE_YEAR],PLAYER_DATA[playerid][data_SKIN]);
    mysql_function_query(dbHandle, query, false, "", "");
    SavePlayerData(playerid);
	return true;
}
Изменено пользователем АЛЕКСАНДР МАМАЕВ

Поделиться сообщением

Ссылка на сообщение
Поделиться на другие сайты

АЛЕКСАНДР МАМАЕВ    0

АЛЕКСАНДР МАМАЕВ
Опубликовано

я делал для проверки выдачю админки без админ проверки асё выдовал деньги и тд нечё не идёт в базу чтото со стоком сохранения аккаунта гдето с базой разногласие наверное

Поделиться сообщением

Ссылка на сообщение
Поделиться на другие сайты

gegelo    22

gegelo
Опубликовано

@АЛЕКСАНДР МАМАЕВ, денвер юзаешь или хост? Мускул какой версии?

Поделиться сообщением

Ссылка на сообщение
Поделиться на другие сайты

noname_idk    150

noname_idk
Опубликовано

@АЛЕКСАНДР МАМАЕВ, вы сами понимаете что пишете?

С нуля пойдем. Какая на данным момент у Вас осталась ошибка и когда запись об этой ошибке появляется в логах? (при старте сервера, при заходе игрока, при его регистрации, авторизации и т.д.)

Поделиться сообщением

Ссылка на сообщение
Поделиться на другие сайты

АЛЕКСАНДР МАМАЕВ    0

АЛЕКСАНДР МАМАЕВ
Опубликовано

,  

[17:45:07] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

[17:45:54] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''0,0,' at line 1

Поделиться сообщением

Ссылка на сообщение
Поделиться на другие сайты

noname_idk    150

noname_idk
Опубликовано
@АЛЕКСАНДР МАМАЕВ, удалите логи MySQL. Запустите сервер и проверьте, есть ли эта ошибка в логах. Если нет, авторизуйтесь, зарегайтесь, что-нибудь поделайте, чтобы определить когда она примерно появляется.

Поделиться сообщением

Ссылка на сообщение
Поделиться на другие сайты

АЛЕКСАНДР МАМАЕВ    0

АЛЕКСАНДР МАМАЕВ
Опубликовано

@gegelo,, после регистрации при спавне 

[11:59:44] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

@gegelo, хост MySQL 39.3 

Поделиться сообщением

Ссылка на сообщение
Поделиться на другие сайты

noname_idk    150

noname_idk
Опубликовано

@АЛЕКСАНДР МАМАЕВ, сам аккаунт в базе создается? 

Поделиться сообщением

Ссылка на сообщение
Поделиться на другие сайты

АЛЕКСАНДР МАМАЕВ    0

АЛЕКСАНДР МАМАЕВ
Опубликовано

, да но не все строки 

Поделиться сообщением

Ссылка на сообщение
Поделиться на другие сайты

АЛЕКСАНДР МАМАЕВ    0

АЛЕКСАНДР МАМАЕВ
Опубликовано

, был бы отчёт MySQL поподробнее

Поделиться сообщением

Ссылка на сообщение
Поделиться на другие сайты

АЛЕКСАНДР МАМАЕВ    0

АЛЕКСАНДР МАМАЕВ
Опубликовано

чёто вроде с сохранением тюнига ну верне с прописыванием его в базу данных:

[12:56:46] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''0,0,0,0,0,0,0,0,' at line 1

Поделиться сообщением

Ссылка на сообщение
Поделиться на другие сайты

gegelo    22

gegelo
Опубликовано

@АЛЕКСАНДР МАМАЕВ, ну покажи его значит

Поделиться сообщением

Ссылка на сообщение
Поделиться на другие сайты

АЛЕКСАНДР МАМАЕВ    0

АЛЕКСАНДР МАМАЕВ
Опубликовано (изменено)

@gegelo, в самой базе varcar 128 размер строки 0,0,0,0,0,0,0,0,0 это стоит в пункте сохранеия ну по умолчянию а щас из мода:

		if(clickedid == tuning_text[20])
		{
		    if(!player_cost_tuning[playerid]) return SendClientMessage(playerid, COLOR_WARNING, "Вы еще не сделали заказа в СТО");
			if(PLAYER_DATA[playerid][data_MONEY] < player_cost_tuning[playerid]) return SendClientMessage(playerid, COLOR_WARNING, "У Вас на руках недостаточно средств, для оплаты заказа");
			if(GetPlayerVehicleID(playerid) == PLAYER_DATA[playerid][data_VEH][0])
			{
				if(GetPVarInt(playerid, "TUNING_WHEEL") > 0)
				{
				    PLAYER_DATA[playerid][data_TUNING_ID_1][0] = GetPVarInt(playerid, "TUNING_WHEEL");
				}
				if(GetPVarInt(playerid, "TUNING_SP") > 0)
				{
				    PLAYER_DATA[playerid][data_TUNING_ID_1][1] = GetPVarInt(playerid, "TUNING_SP");
				}
				if(GetPVarInt(playerid, "TUNING_FB") > 0)
				{
				    PLAYER_DATA[playerid][data_TUNING_ID_1][2] = GetPVarInt(playerid, "TUNING_FB");
				}
				if(GetPVarInt(playerid, "TUNING_RB") > 0)
				{
				    PLAYER_DATA[playerid][data_TUNING_ID_1][3] = GetPVarInt(playerid, "TUNING_RB");
				}
				if(GetPVarInt(playerid, "TUNING_NITRO") > 0)
				{
				    PLAYER_DATA[playerid][data_TUNING_ID_1][4] = GetPVarInt(playerid, "TUNING_NITRO");
				}
				if(GetPVarInt(playerid, "TUNING_GYDRO") > 0)
				{
				    PLAYER_DATA[playerid][data_TUNING_ID_1][5] = GetPVarInt(playerid, "TUNING_GYDRO");
				}
				if(GetPVarInt(playerid, "TUNING_BALON") > 0)
				{
				    PLAYER_DATA[playerid][data_TUNING_ID_1][6] = GetPVarInt(playerid, "TUNING_BALON");
				}
				if(GetPVarInt(playerid, "TUNING_UB") > 0)
				{
				    PLAYER_DATA[playerid][data_TUNING_ID_1][7] = GetPVarInt(playerid, "TUNING_UB");
				}
				if(GetPVarInt(playerid, "TUNING_KR") > 0)
				{
				    PLAYER_DATA[playerid][data_TUNING_ID_1][8] = GetPVarInt(playerid, "TUNING_KR");
				}
				if(GetPVarInt(playerid, "TUNING_COLOR_1") != 0 || GetPVarInt(playerid, "TUNING_COLOR_2") != 0)
				{
				    new b = GetPVarInt(playerid,"business");
				    new prod = 1;
				    BUSINESS_DATA[b][data_PRODKRAS] -= prod;
				    PLAYER_DATA[playerid][data_CAR_COLOR1][0] = GetPVarInt(playerid, "TUNING_COLOR_1"), PLAYER_DATA[playerid][data_CAR_COLOR2][0] = GetPVarInt(playerid, "TUNING_COLOR_2");
				}
				format(car_TUNING[playerid][0], 128, "\
				%d,%d,%d,%d,%d,%d,%d,%d,%d",
				PLAYER_DATA[playerid][data_TUNING_ID_1][0],
				PLAYER_DATA[playerid][data_TUNING_ID_1][1],
				PLAYER_DATA[playerid][data_TUNING_ID_1][2],
				PLAYER_DATA[playerid][data_TUNING_ID_1][3],
				PLAYER_DATA[playerid][data_TUNING_ID_1][4],
				PLAYER_DATA[playerid][data_TUNING_ID_1][5],
				PLAYER_DATA[playerid][data_TUNING_ID_1][6],
				PLAYER_DATA[playerid][data_TUNING_ID_1][7],
				PLAYER_DATA[playerid][data_TUNING_ID_1][8]);
			}
			if(GetPlayerVehicleID(playerid) == PLAYER_DATA[playerid][data_VEH][1])
			{
				if(GetPVarInt(playerid, "TUNING_WHEEL") > 0)
				{
				    PLAYER_DATA[playerid][data_TUNING_ID_2][0] = GetPVarInt(playerid, "TUNING_WHEEL");
				}
				if(GetPVarInt(playerid, "TUNING_SP") > 0)
				{
				    PLAYER_DATA[playerid][data_TUNING_ID_2][1] = GetPVarInt(playerid, "TUNING_SP");
				}
				if(GetPVarInt(playerid, "TUNING_FB") > 0)
				{
				    PLAYER_DATA[playerid][data_TUNING_ID_2][2] = GetPVarInt(playerid, "TUNING_FB");
				}
				if(GetPVarInt(playerid, "TUNING_RB") > 0)
				{
				    PLAYER_DATA[playerid][data_TUNING_ID_2][3] = GetPVarInt(playerid, "TUNING_RB");
				}
				if(GetPVarInt(playerid, "TUNING_NITRO") > 0)
				{
				    PLAYER_DATA[playerid][data_TUNING_ID_2][4] = GetPVarInt(playerid, "TUNING_NITRO");
				}
				if(GetPVarInt(playerid, "TUNING_GYDRO") > 0)
				{
				    PLAYER_DATA[playerid][data_TUNING_ID_1][5] = GetPVarInt(playerid, "TUNING_GYDRO");
				}
				if(GetPVarInt(playerid, "TUNING_BALON") > 0)
				{
				    PLAYER_DATA[playerid][data_TUNING_ID_2][6] = GetPVarInt(playerid, "TUNING_BALON");
				}
				if(GetPVarInt(playerid, "TUNING_UB") > 0)
				{
				    PLAYER_DATA[playerid][data_TUNING_ID_2][7] = GetPVarInt(playerid, "TUNING_UB");
				}
				if(GetPVarInt(playerid, "TUNING_KR") > 0)
				{
				    PLAYER_DATA[playerid][data_TUNING_ID_2][8] = GetPVarInt(playerid, "TUNING_KR");
				}
				if(GetPVarInt(playerid, "TUNING_COLOR_1") != 0 || GetPVarInt(playerid, "TUNING_COLOR_2") != 0)
				{
				    PLAYER_DATA[playerid][data_CAR_COLOR1][1] = GetPVarInt(playerid, "TUNING_COLOR_1"), PLAYER_DATA[playerid][data_CAR_COLOR2][1] = GetPVarInt(playerid, "TUNING_COLOR_2");
				}
				format(car_TUNING[playerid][1], 128, "\
				%d,%d,%d,%d,%d,%d,%d,%d,%d",
				PLAYER_DATA[playerid][data_TUNING_ID_2][0],
				PLAYER_DATA[playerid][data_TUNING_ID_2][1],
				PLAYER_DATA[playerid][data_TUNING_ID_2][2],
				PLAYER_DATA[playerid][data_TUNING_ID_2][3],
				PLAYER_DATA[playerid][data_TUNING_ID_2][4],
				PLAYER_DATA[playerid][data_TUNING_ID_2][5],
				PLAYER_DATA[playerid][data_TUNING_ID_2][6],
				PLAYER_DATA[playerid][data_TUNING_ID_2][7],
				PLAYER_DATA[playerid][data_TUNING_ID_2][8]);
			}
			if(GetPlayerVehicleID(playerid) == PLAYER_DATA[playerid][data_VEH][2])
			{
				if(GetPVarInt(playerid, "TUNING_WHEEL") > 0)
				{
				    PLAYER_DATA[playerid][data_TUNING_ID_3][0] = GetPVarInt(playerid, "TUNING_WHEEL");
				}
				if(GetPVarInt(playerid, "TUNING_SP") > 0)
				{
				    PLAYER_DATA[playerid][data_TUNING_ID_3][1] = GetPVarInt(playerid, "TUNING_SP");
				}
				if(GetPVarInt(playerid, "TUNING_FB") > 0)
				{
				    PLAYER_DATA[playerid][data_TUNING_ID_3][2] = GetPVarInt(playerid, "TUNING_FB");
				}
				if(GetPVarInt(playerid, "TUNING_RB") > 0)
				{
				    PLAYER_DATA[playerid][data_TUNING_ID_3][3] = GetPVarInt(playerid, "TUNING_RB");
				}
				if(GetPVarInt(playerid, "TUNING_NITRO") > 0)
				{
				    PLAYER_DATA[playerid][data_TUNING_ID_3][4] = GetPVarInt(playerid, "TUNING_NITRO");
				}
				if(GetPVarInt(playerid, "TUNING_GYDRO") > 0)
				{
				    PLAYER_DATA[playerid][data_TUNING_ID_3][5] = GetPVarInt(playerid, "TUNING_GYDRO");
				}
				if(GetPVarInt(playerid, "TUNING_BALON") > 0)
				{
				    PLAYER_DATA[playerid][data_TUNING_ID_3][6] = GetPVarInt(playerid, "TUNING_BALON");
				}
				if(GetPVarInt(playerid, "TUNING_UB") > 0)
				{
				    PLAYER_DATA[playerid][data_TUNING_ID_3][7] = GetPVarInt(playerid, "TUNING_UB");
				}
				if(GetPVarInt(playerid, "TUNING_KR") > 0)
				{
				    PLAYER_DATA[playerid][data_TUNING_ID_3][8] = GetPVarInt(playerid, "TUNING_KR");
				}
				if(GetPVarInt(playerid, "TUNING_COLOR_1") != 0 || GetPVarInt(playerid, "TUNING_COLOR_2") != 0)
				{
				    PLAYER_DATA[playerid][data_CAR_COLOR1][2] = GetPVarInt(playerid, "TUNING_COLOR_1"), PLAYER_DATA[playerid][data_CAR_COLOR2][2] = GetPVarInt(playerid, "TUNING_COLOR_2");
				}
				format(car_TUNING[playerid][2], 128, "\
				%d,%d,%d,%d,%d,%d,%d,%d,%d",
				PLAYER_DATA[playerid][data_TUNING_ID_3][0],
				PLAYER_DATA[playerid][data_TUNING_ID_3][1],
				PLAYER_DATA[playerid][data_TUNING_ID_3][2],
				PLAYER_DATA[playerid][data_TUNING_ID_3][3],
				PLAYER_DATA[playerid][data_TUNING_ID_3][4],
				PLAYER_DATA[playerid][data_TUNING_ID_3][5],
				PLAYER_DATA[playerid][data_TUNING_ID_3][6],
				PLAYER_DATA[playerid][data_TUNING_ID_3][7],
				PLAYER_DATA[playerid][data_TUNING_ID_3][8]);
			}
			if(GetPlayerVehicleID(playerid) == PLAYER_DATA[playerid][data_VEH][3])
			{
				if(GetPVarInt(playerid, "TUNING_WHEEL") > 0)
				{
				    PLAYER_DATA[playerid][data_TUNING_ID_4][0] = GetPVarInt(playerid, "TUNING_WHEEL");
				}
				if(GetPVarInt(playerid, "TUNING_SP") > 0)
				{
				    PLAYER_DATA[playerid][data_TUNING_ID_4][1] = GetPVarInt(playerid, "TUNING_SP");
				}
				if(GetPVarInt(playerid, "TUNING_FB") > 0)
				{
				    PLAYER_DATA[playerid][data_TUNING_ID_4][2] = GetPVarInt(playerid, "TUNING_FB");
				}
				if(GetPVarInt(playerid, "TUNING_RB") > 0)
				{
				    PLAYER_DATA[playerid][data_TUNING_ID_4][3] = GetPVarInt(playerid, "TUNING_RB");
				}
				if(GetPVarInt(playerid, "TUNING_NITRO") > 0)
				{
				    PLAYER_DATA[playerid][data_TUNING_ID_3][4] = GetPVarInt(playerid, "TUNING_NITRO");
				}
				if(GetPVarInt(playerid, "TUNING_GYDRO") > 0)
				{
				    PLAYER_DATA[playerid][data_TUNING_ID_4][5] = GetPVarInt(playerid, "TUNING_GYDRO");
				}
				if(GetPVarInt(playerid, "TUNING_BALON") > 0)
				{
				    PLAYER_DATA[playerid][data_TUNING_ID_4][6] = GetPVarInt(playerid, "TUNING_BALON");
				}
				if(GetPVarInt(playerid, "TUNING_UB") > 0)
				{
				    PLAYER_DATA[playerid][data_TUNING_ID_3][7] = GetPVarInt(playerid, "TUNING_UB");
				}
				if(GetPVarInt(playerid, "TUNING_KR") > 0)
				{
				    PLAYER_DATA[playerid][data_TUNING_ID_4][8] = GetPVarInt(playerid, "TUNING_KR");
				}
				if(GetPVarInt(playerid, "TUNING_COLOR_1") != 0 || GetPVarInt(playerid, "TUNING_COLOR_2") != 0)
				{
				    PLAYER_DATA[playerid][data_CAR_COLOR1][2] = GetPVarInt(playerid, "TUNING_COLOR_1"), PLAYER_DATA[playerid][data_CAR_COLOR2][2] = GetPVarInt(playerid, "TUNING_COLOR_2");
				}
				format(car_TUNING[playerid][3], 128, "\
				%d,%d,%d,%d,%d,%d,%d,%d,%d",
				PLAYER_DATA[playerid][data_TUNING_ID_4][0],
				PLAYER_DATA[playerid][data_TUNING_ID_4][1],
				PLAYER_DATA[playerid][data_TUNING_ID_4][2],
				PLAYER_DATA[playerid][data_TUNING_ID_4][3],
				PLAYER_DATA[playerid][data_TUNING_ID_4][4],
				PLAYER_DATA[playerid][data_TUNING_ID_4][5],
				PLAYER_DATA[playerid][data_TUNING_ID_4][6],
				PLAYER_DATA[playerid][data_TUNING_ID_4][7],
				PLAYER_DATA[playerid][data_TUNING_ID_4][8]);
			}

			PLAYER_DATA[playerid][data_MONEY] -= player_cost_tuning[playerid];
			new b = GetPVarInt(playerid, "business"), cost_format[128];
			BUSINESS_DATA[b][data_BANK] += player_cost_tuning[playerid];
			UpdateBusinessData(b);
			SaveBusinessData(b);
			SavePlayerData(playerid);
			player_cost_tuning[playerid] = 0;
			format(cost_format, sizeof cost_format, "…€ME®E®…† ®A CYMMY:  ~y~~h~%d PY—", player_cost_tuning[playerid]);
			PlayerTextDrawSetString(playerid, tuning_player_text[playerid], cost_format);

			SendClientMessage(playerid, COLOR_LBLUE, "Заказ оплачен");

			DeletePVar(playerid, "TUNING_WHEEL"), DeletePVar(playerid, "TUNING_SP"), DeletePVar(playerid, "TUNING_FB"), DeletePVar(playerid, "TUNING_RB"),
		    DeletePVar(playerid, "TUNING_NITRO"), DeletePVar(playerid, "TUNING_GYDRO"), DeletePVar(playerid, "TUNING_BALON"), DeletePVar(playerid, "TUNING_UB"),
		    DeletePVar(playerid, "TUNING_KR"), DeletePVar(playerid, "TUNING_COLOR_1"), DeletePVar(playerid, "TUNING_COLOR_2");
		} 

вот запрос в базу при сейве аккаунта:

 acc_str_strcat(query, sizeof(query), "car_TUNING_1", car_TUNING[playerid][0]);
	acc_str_strcat(query, sizeof(query), "car_TUNING_2", car_TUNING[playerid][1]);
	acc_str_strcat(query, sizeof(query), "car_TUNING_3", car_TUNING[playerid][2]);
	acc_str_strcat(query, sizeof(query), "car_TUNING_4", car_TUNING[playerid][3]);
Изменено пользователем АЛЕКСАНДР МАМАЕВ

Поделиться сообщением

Ссылка на сообщение
Поделиться на другие сайты

АЛЕКСАНДР МАМАЕВ    0

АЛЕКСАНДР МАМАЕВ
Опубликовано (изменено)

@gegelo, а нет в тюне всё норм думал и за него и начел менять показатели думал  new car_TUNING[MAX_PLAYERS][4][128]; влияет на сохраность и ставил 256 но потом дошло что это длина строчки но ошибка всеровно есть одна вот она вот знать бы подробно где именно а то непонятно: а нет тюнил и вылезло при выезде [12:28:50] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''0,0,0,0,0,' at line 1 

[12:21:05] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
Изменено пользователем АЛЕКСАНДР МАМАЕВ

Поделиться сообщением

Ссылка на сообщение
Поделиться на другие сайты
Гость
Эта тема закрыта для публикации ответов.
Авторизация  
Подписчики 0
Перейти к списку тем Архив Вопросов/Проблем/Ошибок

  • Последние посетители   0 пользователей онлайн

    Ни одного зарегистрированного пользователя не просматривает данную страницу

×

Важная информация

Мы разместили cookie-файлы на ваше устройство, чтобы помочь сделать этот сайт лучше. Вы можете изменить свои настройки cookie-файлов, или продолжить без изменения настроек.

  Я принимаю