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

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

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

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

Сохранение MYSQL R39-2

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

lava172

Умник
Вот что в mysql логе
PHP: 
[14:48:11] [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
[14:48:11] [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 '85 `Money` = '0',' at line 1
[14:48:11] [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 '56 `Kills` = '0',' at line 1
[14:48:11] [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 '53 `Deaths` = '0',' at line 1
[14:48:11] [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 '53 `Skin` = '0',' at line 1
[14:48:11] [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 '53 `Admin` = '0',' at line 1
[14:48:11] [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 '53 `Warns` = '0',' at line 1
[14:48:11] [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 '53 `Mute` = '0',' at line 1
[14:48:11] [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 '53 `Mutes` = '0',' at line 1
[14:48:11] [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 '53 `Jail` = '0',' at line 1
[14:48:11] [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 '53 `Jails` = '0',' at line 1
[14:48:11] [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 '53 `DonateMoney` = '0',' at line 1
[14:48:11] [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 '53 `Gorod` = '0',' at line 1
[14:48:11] [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 '53 `Sex` = '0',' at line 1
[14:48:11] [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 '53 `Gun1` = '0',' at line 1
[14:48:11] [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 '53 `Gun2` = '0',' at line 1
[14:48:11] [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 '53 `Gun3` = '0',' at line 1
[14:48:11] [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 '53 `Gun4` = '0',' at line 1
[14:48:11] [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 '53 `Level` = '0',' at line 1
[14:48:11] [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 '53 `Bank` = '0',' at line 1
[14:48:11] [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 '53 `Freeze` = '0',' at line 1
[14:48:11] [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 '53 `Freezes` = '0',' at line 1
[14:48:11] [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 '53 `Kiss` = '0',' at line 1
[14:48:11] [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 '53 `Hour` = '0',' at line 1
[14:48:11] [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 '53 `Minute` = '0',' at line 1
[14:48:11] [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 '53 `Year` = '0',' at line 1
[14:48:11] [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 '53 `Month` = '0',' at line 1
[14:48:11] [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 '53 `Day` = '0',' at line 1
[14:48:11] [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 '53 `Gang` = '0',' at line 1
[14:48:11] [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 '53 `GangLvl` = '0',' at line 1
[14:48:11] [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 '53 `Reg` = '0',' at line 1
[14:48:11] [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 '53 `Reg` = '0', WHERE `Name` = 'jchao_ichln',' at line 1
Вот сток сохранения:

PHP: 
stock SaveAccount(playerid)
{
	new query_string[1024] = "UPDATE `Accounts` SET";
    f(query_string,"%s `Key` = '%s',", query_string,pStats[playerid][pPassword]), mysql_function_query(mysql_connect_ID, query_string, false, "", "");
    f(query_string,"%d `Money` = '%d',", query_string,pStats[playerid][pMoney]), mysql_function_query(mysql_connect_ID, query_string, false, "", "");
    f(query_string,"%d `Kills` = '%d',", query_string,pStats[playerid][pKills]), mysql_function_query(mysql_connect_ID, query_string, false, "", "");
    f(query_string,"%d `Deaths` = '%d',", query_string,pStats[playerid][pDeaths]), mysql_function_query(mysql_connect_ID, query_string, false, "", "");
    f(query_string,"%d `Skin` = '%d',", query_string,pStats[playerid][pSkin]), mysql_function_query(mysql_connect_ID, query_string, false, "", "");
    f(query_string,"%d `Admin` = '%d',", query_string,pStats[playerid][pAdmin]), mysql_function_query(mysql_connect_ID, query_string, false, "", "");
    f(query_string,"%d `Warns` = '%d',", query_string,pStats[playerid][pWarns]), mysql_function_query(mysql_connect_ID, query_string, false, "", "");
    f(query_string,"%d `Mute` = '%d',", query_string,pStats[playerid][pMute]), mysql_function_query(mysql_connect_ID, query_string, false, "", "");
    f(query_string,"%d `Mutes` = '%d',", query_string,pStats[playerid][pMutes]), mysql_function_query(mysql_connect_ID, query_string, false, "", "");
    f(query_string,"%d `Jail` = '%d',", query_string,pStats[playerid][pJail]), mysql_function_query(mysql_connect_ID, query_string, false, "", "");
    f(query_string,"%d `Jails` = '%d',", query_string,pStats[playerid][pJails]), mysql_function_query(mysql_connect_ID, query_string, false, "", "");
    f(query_string,"%d `DonateMoney` = '%d',", query_string,pStats[playerid][pDonateMoney]), mysql_function_query(mysql_connect_ID, query_string, false, "", "");
    f(query_string,"%d `Gorod` = '%d',", query_string,pStats[playerid][Gorod]), mysql_function_query(mysql_connect_ID, query_string, false, "", "");
    f(query_string,"%d `Sex` = '%d',", query_string,pStats[playerid][pSex]), mysql_function_query(mysql_connect_ID, query_string, false, "", "");
    f(query_string,"%d `Gun1` = '%d',", query_string,pStats[playerid][pGun1]), mysql_function_query(mysql_connect_ID, query_string, false, "", "");
    f(query_string,"%d `Gun2` = '%d',", query_string,pStats[playerid][pGun2]), mysql_function_query(mysql_connect_ID, query_string, false, "", "");
    f(query_string,"%d `Gun3` = '%d',", query_string,pStats[playerid][pGun3]), mysql_function_query(mysql_connect_ID, query_string, false, "", "");
    f(query_string,"%d `Gun4` = '%d',", query_string,pStats[playerid][pGun4]), mysql_function_query(mysql_connect_ID, query_string, false, "", "");
    f(query_string,"%d `Level` = '%d',", query_string,pStats[playerid][pLevel]), mysql_function_query(mysql_connect_ID, query_string, false, "", "");
    f(query_string,"%d `Bank` = '%d',", query_string,pStats[playerid][pBank]), mysql_function_query(mysql_connect_ID, query_string, false, "", "");
    f(query_string,"%d `Freeze` = '%d',", query_string,pStats[playerid][pFreeze]), mysql_function_query(mysql_connect_ID, query_string, false, "", "");
    f(query_string,"%d `Freezes` = '%d',", query_string,pStats[playerid][pFreezes]), mysql_function_query(mysql_connect_ID, query_string, false, "", "");
    f(query_string,"%d `Kiss` = '%d',", query_string,pStats[playerid][pKiss]), mysql_function_query(mysql_connect_ID, query_string, false, "", "");
    f(query_string,"%d `Hour` = '%d',", query_string,pStats[playerid][phour]), mysql_function_query(mysql_connect_ID, query_string, false, "", "");
    f(query_string,"%d `Minute` = '%d',", query_string,pStats[playerid][pminute]), mysql_function_query(mysql_connect_ID, query_string, false, "", "");
    f(query_string,"%d `Year` = '%d',", query_string,pStats[playerid][pyear]), mysql_function_query(mysql_connect_ID, query_string, false, "", "");
    f(query_string,"%d `Month` = '%d',", query_string,pStats[playerid][pmonth]), mysql_function_query(mysql_connect_ID, query_string, false, "", "");
    f(query_string,"%d `Day` = '%d',", query_string,pStats[playerid][pday]), mysql_function_query(mysql_connect_ID, query_string, false, "", "");
    f(query_string,"%d `Gang` = '%d',", query_string,PGang[playerid]), mysql_function_query(mysql_connect_ID, query_string, false, "", "");
    f(query_string,"%d `GangLvl` = '%d',", query_string,GangLvl[playerid]), mysql_function_query(mysql_connect_ID, query_string, false, "", "");
    f(query_string,"%d `Reg` = '%d',", query_string,pStats[playerid][pReg]), mysql_function_query(mysql_connect_ID, query_string, false, "", "");
    f(query_string,"%s WHERE `Name` = '%s',", query_string,pStats[playerid][pName]), mysql_function_query(mysql_connect_ID, query_string, false, "", "");
	return 1;
}
 
Статус
В этой теме нельзя размещать новые ответы.
Сверху Снизу