Не сохроняються созданные дома.

[$continue$]

Вот это я просто зашел когда на сервере в базе данных уже есть 355 домов.

  Открыть/закрыть

[16:11:10]

[16:11:10] ---------------------------

[16:11:10] MySQL Debugging activated (05/31/15)

[16:11:10] ---------------------------

[16:11:10]

[16:11:30] >> mysql_query( Connection handle: 1 )

[16:11:30] CMySQLHandler::Query(SELECT unbandate FROM bans WHERE name = 'kala4iks') - Successfully executed.

[16:11:30] >> mysql_store_result( Connection handle: 1 )

[16:11:30] CMySQLHandler::StoreResult() - Result was stored.

[16:11:30] >> mysql_num_rows( Connection handle: 1 )

[16:11:30] CMySQLHandler::NumRows() - Returned 0 row(s)

[16:11:30] >> mysql_free_result( Connection handle: 1 )

[16:11:30] CMySQLHandler::FreeResult() - Result was successfully free'd.

[16:11:30] >> mysql_query( Connection handle: 1 )

[16:11:30] CMySQLHandler::Query(SELECT unbandate FROM bans WHERE ip = '192.168.0.36') - Successfully executed.

[16:11:30] >> mysql_store_result( Connection handle: 1 )

[16:11:30] CMySQLHandler::StoreResult() - Result was stored.

[16:11:30] >> mysql_num_rows( Connection handle: 1 )

[16:11:30] CMySQLHandler::NumRows() - Returned 0 row(s)

[16:11:30] >> mysql_free_result( Connection handle: 1 )

[16:11:30] CMySQLHandler::FreeResult() - Result was successfully free'd.

[16:11:34] >> mysql_real_escape_string( Connection handle: 1 )

[16:11:34] CMySQLHandler::EscapeString(kala4iks); - Escaped 8 characters to kala4iks.

[16:11:34] >> mysql_query( Connection handle: 1 )

[16:11:34] CMySQLHandler::Query(SELECT `ID` FROM `accounts` WHERE `Nickname` = 'kala4iks') - Successfully executed.

[16:11:34] >> mysql_store_result( Connection handle: 1 )

[16:11:34] CMySQLHandler::StoreResult() - Result was stored.

[16:11:34] >> mysql_num_rows( Connection handle: 1 )

[16:11:34] CMySQLHandler::NumRows() - Returned 1 row(s)

[16:11:34] >> mysql_fetch_int( Connection handle: 1 )

[16:11:34] CMySQLHandler::FetchRow() - Return: 1

[16:11:34] >> mysql_free_result( Connection handle: 1 )

[16:11:34] CMySQLHandler::FreeResult() - Result was successfully free'd.

[16:11:37] >> mysql_real_escape_string( Connection handle: 1 )

[16:11:37] CMySQLHandler::EscapeString(0951249107); - Escaped 10 characters to 0951249107.

[16:11:37] >> mysql_query( Connection handle: 1 )

[16:11:37] CMySQLHandler::Query(SELECT * FROM `accounts` WHERE `Password` = '0951249107' AND `ID` = '1') - Successfully executed.

[16:11:37] >> mysql_store_result( Connection handle: 1 )

[16:11:37] CMySQLHandler::StoreResult() - Result was stored.

[16:11:37] >> mysql_num_rows( Connection handle: 1 )

[16:11:37] CMySQLHandler::NumRows() - Returned 1 row(s)

[16:11:37] >> mysql_fetch_row_format( Connection handle: 1 )

[16:11:37] CMySQLHandler::FetchRow() - Return: 1|kala4iks|0951249107|0|10|1|1|0|0|0|10000|0|0|0|0|0|0|0|0|0|0|0|0|0|0|3|3|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|9|0|0|0|0|0|0|0|0|0|0|0|0|0|0|180|0|0|0|0|0|0|0|0|0|0|0|0|0|0|No-One|0|0|0|0|0|0|0|0|0|0|0|0|1|1|1|1|1

[16:11:37] >> mysql_ping( Connection handle: 1 )

[16:11:37] CMySQLHandler::Ping() - Connection is still alive.

[16:11:37] >> mysql_real_escape_string( Connection handle: 1 )

[16:11:37] CMySQLHandler::EscapeString(kala4iks); - Escaped 8 characters to kala4iks.

[16:11:37] >> mysql_query( Connection handle: 1 )

[16:11:37] CMySQLHandler::Query(UPDATE `accounts` SET `Nickname`= 'kala4iks',`Level`= '0', `Admin`= '10', `Reg`= '1', `Sex`= '1', `Spawn`= '0', `Exp`= '0', `BankPass`= '0', `Money` = '10000', `Bank` = '0', `MuteTime` = '0', `Job`= '0', `PayCheck` = '0',`Jailed` = '0',`JailTime`= '0',`MedicTime` = '0',`Mats` = '0',`Drugs`= '0',`JobTime`= '0',`Member` = '0',`Leader` = '0',`Zam` = '0',`Rank` = '0',`Model` = '3',`Char` = '3',`Phousekey` = '0',`Carkey1` = '0', `Pbiskey` = '0',`TWarns` = '0',`CarLic` = '0',`MotoLic` = '0',`TruckLic` = '0',`TruckELic` = '0',`FlyLic` = '0',`BoatLic` = '0',`SD` = '0', `GunLic` = '0',`TaxiLic`= '0',`GruzSkill` = '0',`DrugSkill` = '0',`GunSkill` = '0',`CarSkill` = '0',`JackSkill` = '0',`RobSkill` = '0',`RobHouseSkill` = '0',`TimePizdanul` = '0',`RobHouseTime` = '0',`MechSkill` = '0',`TruckSkill` = '0',`DetSkill` = '0',`HeadValue` = '0',`HunterValue` = '0',`TruckETime` = '0' , `PayDay` = '9',`Warns`= '0',`Boxing` = '0',`Kunfu` = '0',`Kneehead` = '0',`Grabkick` = '0',`FStyle` = '0',`Rope` = '0',`CheatPassword` = '0',`GPS` = '0',`Sigs` = '0',`Pivo` = '0',`Wanted` = '0',`RobTime` = '0',`JackTime` = '0',`AdminOnline` = '180',`Vip` = '0', `Donate` = '0', `Kvest_1` = '0',`Kvest_2` = '0',`Kvest_3` = '0',`Kvest_4` = '0',`Kvest_5` = '0',`Kvest_6` = '0',`Kvest_7` = '0',`Kvest_8` = '0',`Kvest_9` = '0',`Kvest_10` = '0',`Kvest_11` = '0',`Kvest_12` = '0',`Mail` = 'No-One',`Repost` = '0', `Cor_X` = '0.000000',`Cor_Y` = '0.000000',`Cor_Z` = '0.000000',`Dworld` = '0',`Dint` = '0',`Dexit` = '0',`AdmLeader` = '0',`AdmBan` = '0',`AdmSkript` = '0' ,`JailBlock` = '0' ,`Fmute` = '0' ,`SettingName` = '1' ,`SettingLvl` = '1' ,`SettingSite` = '1' ,`SettingDate` = '1' ,`SettingTime` = '1' WHERE `ID` = '1') - Successfully executed.

[16:11:37] >> mysql_ping( Connection handle: 1 )

[16:11:37] CMySQLHandler::Ping() - Connection is still alive.

[16:11:37] >> mysql_real_escape_string( Connection handle: 1 )

[16:11:37] CMySQLHandler::EscapeString(kala4iks); - Escaped 8 characters to kala4iks.

[16:11:37] >> mysql_query( Connection handle: 1 )

[16:11:37] CMySQLHandler::Query(UPDATE `accounts` SET `Nickname`= 'kala4iks',`Level`= '0', `Admin`= '10', `Reg`= '1', `Sex`= '1', `Spawn`= '0', `Exp`= '0', `BankPass`= '0', `Money` = '10000', `Bank` = '0', `MuteTime` = '0', `Job`= '0', `PayCheck` = '0',`Jailed` = '0',`JailTime`= '0',`MedicTime` = '0',`Mats` = '0',`Drugs`= '0',`JobTime`= '0',`Member` = '0',`Leader` = '0',`Zam` = '0',`Rank` = '0',`Model` = '3',`Char` = '3',`Phousekey` = '0',`Carkey1` = '0', `Pbiskey` = '0',`TWarns` = '0',`CarLic` = '0',`MotoLic` = '0',`TruckLic` = '0',`TruckELic` = '0',`FlyLic` = '0',`BoatLic` = '0',`SD` = '0', `GunLic` = '0',`TaxiLic`= '0',`GruzSkill` = '0',`DrugSkill` = '0',`GunSkill` = '0',`CarSkill` = '0',`JackSkill` = '0',`RobSkill` = '0',`RobHouseSkill` = '0',`TimePizdanul` = '0',`RobHouseTime` = '0',`MechSkill` = '0',`TruckSkill` = '0',`DetSkill` = '0',`HeadValue` = '0',`HunterValue` = '0',`TruckETime` = '0' , `PayDay` = '9',`Warns`= '0',`Boxing` = '0',`Kunfu` = '0',`Kneehead` = '0',`Grabkick` = '0',`FStyle` = '0',`Rope` = '0',`CheatPassword` = '0',`GPS` = '0',`Sigs` = '0',`Pivo` = '0',`Wanted` = '0',`RobTime` = '0',`JackTime` = '0',`AdminOnline` = '180',`Vip` = '0', `Donate` = '0', `Kvest_1` = '0',`Kvest_2` = '0',`Kvest_3` = '0',`Kvest_4` = '0',`Kvest_5` = '0',`Kvest_6` = '0',`Kvest_7` = '0',`Kvest_8` = '0',`Kvest_9` = '0',`Kvest_10` = '0',`Kvest_11` = '0',`Kvest_12` = '0',`Mail` = 'No-One',`Repost` = '0', `Cor_X` = '0.000000',`Cor_Y` = '0.000000',`Cor_Z` = '0.000000',`Dworld` = '0',`Dint` = '0',`Dexit` = '0',`AdmLeader` = '0',`AdmBan` = '0',`AdmSkript` = '0' ,`JailBlock` = '0' ,`Fmute` = '0' ,`SettingName` = '1' ,`SettingLvl` = '1' ,`SettingSite` = '1' ,`SettingDate` = '1' ,`SettingTime` = '1' WHERE `ID` = '1') - Successfully executed.

А вот это после рестарта сервера, когда на сервере 355 домов.
Пришлось через файлообменник так как много строчек.
http://rghost.ru/private/6RQdjXxMb/8...05b08d95de547e (Не реклама).


Вот это я зашел на сервер когда я очистил полностью дома с базы данных.зашел и создал 1 дом.

  Открыть/закрыть

[16:20:16]

[16:20:16] ---------------------------

[16:20:16] MySQL Debugging activated (05/31/15)

[16:20:16] ---------------------------

[16:20:16]

[16:20:42] >> mysql_query( Connection handle: 1 )

[16:20:42] CMySQLHandler::Query(SELECT unbandate FROM bans WHERE name = 'kala4iks') - Successfully executed.

[16:20:42] >> mysql_store_result( Connection handle: 1 )

[16:20:42] CMySQLHandler::StoreResult() - Result was stored.

[16:20:42] >> mysql_num_rows( Connection handle: 1 )

[16:20:42] CMySQLHandler::NumRows() - Returned 0 row(s)

[16:20:42] >> mysql_free_result( Connection handle: 1 )

[16:20:42] CMySQLHandler::FreeResult() - Result was successfully free'd.

[16:20:42] >> mysql_query( Connection handle: 1 )

[16:20:42] CMySQLHandler::Query(SELECT unbandate FROM bans WHERE ip = '192.168.0.36') - Successfully executed.

[16:20:42] >> mysql_store_result( Connection handle: 1 )

[16:20:42] CMySQLHandler::StoreResult() - Result was stored.

[16:20:42] >> mysql_num_rows( Connection handle: 1 )

[16:20:42] CMySQLHandler::NumRows() - Returned 0 row(s)

[16:20:42] >> mysql_free_result( Connection handle: 1 )

[16:20:42] CMySQLHandler::FreeResult() - Result was successfully free'd.

[16:20:46] >> mysql_real_escape_string( Connection handle: 1 )

[16:20:46] CMySQLHandler::EscapeString(kala4iks); - Escaped 8 characters to kala4iks.

[16:20:46] >> mysql_query( Connection handle: 1 )

[16:20:46] CMySQLHandler::Query(SELECT `ID` FROM `accounts` WHERE `Nickname` = 'kala4iks') - Successfully executed.

[16:20:46] >> mysql_store_result( Connection handle: 1 )

[16:20:46] CMySQLHandler::StoreResult() - Result was stored.

[16:20:46] >> mysql_num_rows( Connection handle: 1 )

[16:20:46] CMySQLHandler::NumRows() - Returned 1 row(s)

[16:20:46] >> mysql_fetch_int( Connection handle: 1 )

[16:20:46] CMySQLHandler::FetchRow() - Return: 1

[16:20:46] >> mysql_free_result( Connection handle: 1 )

[16:20:46] CMySQLHandler::FreeResult() - Result was successfully free'd.

[16:20:48] >> mysql_real_escape_string( Connection handle: 1 )

[16:20:48] CMySQLHandler::EscapeString(0951249107); - Escaped 10 characters to 0951249107.

[16:20:48] >> mysql_query( Connection handle: 1 )

[16:20:48] CMySQLHandler::Query(SELECT * FROM `accounts` WHERE `Password` = '0951249107' AND `ID` = '1') - Successfully executed.

[16:20:48] >> mysql_store_result( Connection handle: 1 )

[16:20:48] CMySQLHandler::StoreResult() - Result was stored.

[16:20:48] >> mysql_num_rows( Connection handle: 1 )

[16:20:48] CMySQLHandler::NumRows() - Returned 1 row(s)

[16:20:48] >> mysql_fetch_row_format( Connection handle: 1 )

[16:20:48] CMySQLHandler::FetchRow() - Return: 1|kala4iks|0951249107|0|10|1|1|0|0|0|10000|0|0|0|0|0|0|0|0|0|0|0|0|0|0|3|3|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|9|0|0|0|0|0|0|0|0|0|0|0|0|0|0|180|0|0|0|0|0|0|0|0|0|0|0|0|0|0|No-One|0|0|0|0|0|0|0|0|0|0|0|0|1|1|1|1|1

[16:20:48] >> mysql_ping( Connection handle: 1 )

[16:20:48] CMySQLHandler::Ping() - Connection is still alive.

[16:20:48] >> mysql_real_escape_string( Connection handle: 1 )

[16:20:48] CMySQLHandler::EscapeString(kala4iks); - Escaped 8 characters to kala4iks.

[16:20:48] >> mysql_query( Connection handle: 1 )

[16:20:48] CMySQLHandler::Query(UPDATE `accounts` SET `Nickname`= 'kala4iks',`Level`= '0', `Admin`= '10', `Reg`= '1', `Sex`= '1', `Spawn`= '0', `Exp`= '0', `BankPass`= '0', `Money` = '10000', `Bank` = '0', `MuteTime` = '0', `Job`= '0', `PayCheck` = '0',`Jailed` = '0',`JailTime`= '0',`MedicTime` = '0',`Mats` = '0',`Drugs`= '0',`JobTime`= '0',`Member` = '0',`Leader` = '0',`Zam` = '0',`Rank` = '0',`Model` = '3',`Char` = '3',`Phousekey` = '0',`Carkey1` = '0', `Pbiskey` = '0',`TWarns` = '0',`CarLic` = '0',`MotoLic` = '0',`TruckLic` = '0',`TruckELic` = '0',`FlyLic` = '0',`BoatLic` = '0',`SD` = '0', `GunLic` = '0',`TaxiLic`= '0',`GruzSkill` = '0',`DrugSkill` = '0',`GunSkill` = '0',`CarSkill` = '0',`JackSkill` = '0',`RobSkill` = '0',`RobHouseSkill` = '0',`TimePizdanul` = '0',`RobHouseTime` = '0',`MechSkill` = '0',`TruckSkill` = '0',`DetSkill` = '0',`HeadValue` = '0',`HunterValue` = '0',`TruckETime` = '0' , `PayDay` = '9',`Warns`= '0',`Boxing` = '0',`Kunfu` = '0',`Kneehead` = '0',`Grabkick` = '0',`FStyle` = '0',`Rope` = '0',`CheatPassword` = '0',`GPS` = '0',`Sigs` = '0',`Pivo` = '0',`Wanted` = '0',`RobTime` = '0',`JackTime` = '0',`AdminOnline` = '180',`Vip` = '0', `Donate` = '0', `Kvest_1` = '0',`Kvest_2` = '0',`Kvest_3` = '0',`Kvest_4` = '0',`Kvest_5` = '0',`Kvest_6` = '0',`Kvest_7` = '0',`Kvest_8` = '0',`Kvest_9` = '0',`Kvest_10` = '0',`Kvest_11` = '0',`Kvest_12` = '0',`Mail` = 'No-One',`Repost` = '0', `Cor_X` = '0.000000',`Cor_Y` = '0.000000',`Cor_Z` = '0.000000',`Dworld` = '0',`Dint` = '0',`Dexit` = '0',`AdmLeader` = '0',`AdmBan` = '0',`AdmSkript` = '0' ,`JailBlock` = '0' ,`Fmute` = '0' ,`SettingName` = '1' ,`SettingLvl` = '1' ,`SettingSite` = '1' ,`SettingDate` = '1' ,`SettingTime` = '1' WHERE `ID` = '1') - Successfully executed.

[16:20:48] >> mysql_ping( Connection handle: 1 )

[16:20:48] CMySQLHandler::Ping() - Connection is still alive.

[16:20:48] >> mysql_real_escape_string( Connection handle: 1 )

[16:20:48] CMySQLHandler::EscapeString(kala4iks); - Escaped 8 characters to kala4iks.

[16:20:48] >> mysql_query( Connection handle: 1 )

[16:20:48] CMySQLHandler::Query(UPDATE `accounts` SET `Nickname`= 'kala4iks',`Level`= '0', `Admin`= '10', `Reg`= '1', `Sex`= '1', `Spawn`= '0', `Exp`= '0', `BankPass`= '0', `Money` = '10000', `Bank` = '0', `MuteTime` = '0', `Job`= '0', `PayCheck` = '0',`Jailed` = '0',`JailTime`= '0',`MedicTime` = '0',`Mats` = '0',`Drugs`= '0',`JobTime`= '0',`Member` = '0',`Leader` = '0',`Zam` = '0',`Rank` = '0',`Model` = '3',`Char` = '3',`Phousekey` = '0',`Carkey1` = '0', `Pbiskey` = '0',`TWarns` = '0',`CarLic` = '0',`MotoLic` = '0',`TruckLic` = '0',`TruckELic` = '0',`FlyLic` = '0',`BoatLic` = '0',`SD` = '0', `GunLic` = '0',`TaxiLic`= '0',`GruzSkill` = '0',`DrugSkill` = '0',`GunSkill` = '0',`CarSkill` = '0',`JackSkill` = '0',`RobSkill` = '0',`RobHouseSkill` = '0',`TimePizdanul` = '0',`RobHouseTime` = '0',`MechSkill` = '0',`TruckSkill` = '0',`DetSkill` = '0',`HeadValue` = '0',`HunterValue` = '0',`TruckETime` = '0' , `PayDay` = '9',`Warns`= '0',`Boxing` = '0',`Kunfu` = '0',`Kneehead` = '0',`Grabkick` = '0',`FStyle` = '0',`Rope` = '0',`CheatPassword` = '0',`GPS` = '0',`Sigs` = '0',`Pivo` = '0',`Wanted` = '0',`RobTime` = '0',`JackTime` = '0',`AdminOnline` = '180',`Vip` = '0', `Donate` = '0', `Kvest_1` = '0',`Kvest_2` = '0',`Kvest_3` = '0',`Kvest_4` = '0',`Kvest_5` = '0',`Kvest_6` = '0',`Kvest_7` = '0',`Kvest_8` = '0',`Kvest_9` = '0',`Kvest_10` = '0',`Kvest_11` = '0',`Kvest_12` = '0',`Mail` = 'No-One',`Repost` = '0', `Cor_X` = '0.000000',`Cor_Y` = '0.000000',`Cor_Z` = '0.000000',`Dworld` = '0',`Dint` = '0',`Dexit` = '0',`AdmLeader` = '0',`AdmBan` = '0',`AdmSkript` = '0' ,`JailBlock` = '0' ,`Fmute` = '0' ,`SettingName` = '1' ,`SettingLvl` = '1' ,`SettingSite` = '1' ,`SettingDate` = '1' ,`SettingTime` = '1' WHERE `ID` = '1') - Successfully executed.

[16:21:01] >> mysql_query( Connection handle: 1 )

[16:21:01] CMySQLHandler::Query(INSERT INTO `house` (`EnterX`, `EnterY`, `EnterZ`, `ExitX`, `ExitY`, `ExitZ`, `Int`, `Owned`, `Owner`, `Price`, `Lock`, `Lvl`, `Mats`, `Drugs`, `Heal`, `Arm`, `Class`)VALUE ('956.016113', '-1624.130249', '13.548741', '2237.523681', '-1081.612548', '1049.023437', '2', '0', 'The State', '1000000', '0', '10', '0', '0', '0', '0', '5')) - Successfully executed.

[16:21:01] >> mysql_query( Connection handle: 1 )

[16:21:01] CMySQLHandler::Query(UPDATE `stuff` SET value = '353' WHERE `ID` = '1') - Successfully executed.

[16:21:01] >> mysql_query( Connection handle: 1 )

[16:21:01] CMySQLHandler::Query(UPDATE `stuff` SET value = '73' WHERE `ID` = '2') - Successfully executed.

[16:21:01] >> mysql_query( Connection handle: 1 )

[16:21:01] CMySQLHandler::Query(UPDATE `stuff` SET value = '67' WHERE `ID` = '3') - Successfully executed.

[16:21:02] >> mysql_query( Connection handle: 1 )

[16:21:02] CMySQLHandler::Query(UPDATE `stuff` SET value = '12' WHERE `ID` = '4') - Successfully executed.

А вот я рестартнул сервер при созданном доме.
Пришлось снова залить на файлообменник так как файл слишком большой.
http://rghost.ru/private/6nQbYhCWt/d...235ceadfcca0a4 (Не реклама).

Ну вот и все дома не сохронились надеюсь поможете.

Если бы работали с много поточным плагином - наверняка бы помог (MySQL R7+)

[kala4iks]

Если бы работали с много поточным плагином - наверняка бы помог (MySQL R7+)

Жаль очень жаль.

[kala4iks]

Выручайте кто знает.

[A N D R E Y]

f(string, "SELECT * FROM `house` WHERE `ID` = '%d'", i);  

Тут все правильно? внимательно только смотрите. Это с загрузки я взял.

[kala4iks]

f(string, "SELECT * FROM `house` WHERE `ID` = '%d'", i);  

Тут все правильно? внимательно только смотрите. Это с загрузки я взял.

Если честно я не очень сильно разбераюсь в мускуле, вот почему и попросил помочь.

[kala4iks]

Для этого нужно изменить значение auto_increment в таблице с домами (раздел - операции).

Скинь логи mysql.

Так ты поможешь или нет?

[Daniel_Cortez]

Выручайте кто знает.

Я так понимаю, мой пост на предыдущей странице остался незамеченным?
Если нет, то вы хоть отвечайте.

[kala4iks]

Я так понимаю, мой пост на предыдущей странице остался незамеченным?
Если нет, то вы хоть отвечайте.

Это просто не такое как у меня. Не в этом дело у меня почему-то удаленные дома появляются что-то с auto_increment связано а я не знаю. + В той теме написано про файловое сохронение, а у меня на мускуле.

[Daniel_Cortez]

Это просто не такое как у меня. Не в этом дело у меня почему-то удаленные дома появляются что-то с auto_increment связано а я не знаю. + В той теме написано про файловое сохронение, а у меня на мускуле.

А с чего вы взяли, что там дело именно в файлах?

[A N D R E Y]

А ошибки при компилировании в конце появляются?