1. проблема с русской кодировкой в чате и боях (истории пустые, но во время боя иногда проскакивают раунды с номральной кодировкой)
Некорректно отображаются кланы и должности, когда открываешь список кланов в библиотеке (как я понял только те, что на русском)
2. проблема с эликами при употреблении (шампусик нормально пьется)
3. срок годности вещей
4. вещи на базаре покупаются с вечным ожиданием (из банка берутся тоже)
5. капча не пашет
6. при попытке выкинуть ресы выдает длинную ошибку, как с элями
Код:
Context info for the following error/warning:
Error: 1024, Write multi-query failed (1):
CREATE TEMPORARY TABLE thingstothrowaway TYPE=HEAP SELECT t.thingid FROM thing t /*INNER JOIN thingtype tt ON t.thingtypeid=tt.thingtypeid*/ WHERE t.thingid='693757698' AND t.userid='850038' AND (t.clan = '' OR t.clan='850038') /*AND NOT FIND_IN_SET('clan', tt.tflags)*/ AND t.place='inv' AND t.placeid=0 LIMIT 1; UPDATE thingstothrowaway INNER JOIN thing USING(thingid) SET userid=0, place='room', placetime=NOW(), placeid=16842752; REPLACE INTO thingvisibility (thingid, userid, roomid) SELECT thingid, 850038, 16842752 FROM thingstothrowaway; SELECT COUNT(*), GROUP_CONCAT(thingid) INTO @cnt, @thingids FROM thingstothrowaway;
With result:
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 'TYPE=HEAP SELECT t.thingid FROM thing t /*INNER JOIN thingtype tt ON t.thing' at line 1
in /var/www/haddan/core/library/db_fns.php, 329
Backtrace: {
file: /var/www/haddan/core/library/db_fns.php, 329
call: trigger_error("Write multi-query failed (1):
CREATE TEMPORARY TABLE thingstothrowaway TYPE=HEAP
SELECT t.thingid
FROM thing t
/*INNER J...")
file: /var/www/haddan/core/library/db_fns.php, 305
call: db_trigger_error("Write multi-query failed (1):
CREATE TEMPORARY TABLE thingstothrowaway TYPE=HEAP
SELECT t.thingid
FROM thing t
/*INNER J...", "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use...", 256)
file: /var/www/htdocs/inv/inv.php, 632
call: db_multiquery_write("CREATE TEMPORARY TABLE thingstothrowaway TYPE=HEAP
SELECT t.thingid
FROM thing t
/*INNER JOIN thingtype tt ON t.thingtypeid=...")
file: /var/www/htdocs/inv/inv.php, 391
call: throwAwayThing(Array(4))
file: /var/www/htdocs/inv/inv.php, 111
call: processInventoryPost(Array(4))
}
Locals:
Array
(
[querytext] => Write multi-query failed (1):
CREATE TEMPORARY TABLE thingstothrowaway TYPE=HEAP
SELECT t.thingid
FROM thing t
/*INNER JOIN thingtype tt ON t.thingtypeid=tt.thingtypeid*/
WHERE t.thingid='693757698' AND t.userid='850038' AND (t.clan = '' OR t.clan='850038') /*AND NOT FIND_IN_SET('clan', tt.tflags)*/ AND t.place='inv' AND t.placeid=0
LIMIT 1;
UPDATE thingstothrowaway
INNER JOIN thing USING(thingid)
SET userid=0, place='room', placetime=NOW(), placeid=16842752;
REPLACE INTO thingvisibility (thingid, userid, roomid)
SELECT thingid, 850038, 16842752
FROM thingstothrowaway;
SELECT COUNT(*), GROUP_CONCAT(thingid) INTO @cnt, @thingids FROM thingstothrowaway;
[error] => 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 'TYPE=HEAP
SELECT t.thingid
FROM thing t
/*INNER JOIN thingtype tt ON t.thing' at line 1
[type] => 256
)
Context info for the following error/warning:
Error: 256, Write multi-query failed (1):
CREATE TEMPORARY TABLE thingstothrowaway TYPE=HEAP SELECT t.thingid FROM thing t /*INNER JOIN thingtype tt ON t.thingtypeid=tt.thingtypeid*/ WHERE t.thingid='693757698' AND t.userid='850038' AND (t.clan = '' OR t.clan='850038') /*AND NOT FIND_IN_SET('clan', tt.tflags)*/ AND t.place='inv' AND t.placeid=0 LIMIT 1; UPDATE thingstothrowaway INNER JOIN thing USING(thingid) SET userid=0, place='room', placetime=NOW(), placeid=16842752; REPLACE INTO thingvisibility (thingid, userid, roomid) SELECT thingid, 850038, 16842752 FROM thingstothrowaway; SELECT COUNT(*), GROUP_CONCAT(thingid) INTO @cnt, @thingids FROM thingstothrowaway;
With result:
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 'TYPE=HEAP SELECT t.thingid FROM thing t /*INNER JOIN thingtype tt ON t.thing' at line 1
in /var/www/haddan/core/library/db_fns.php, 332
Backtrace: {
file: /var/www/haddan/core/library/db_fns.php, 332
call: trigger_error("Write multi-query failed (1):
CREATE TEMPORARY TABLE thingstothrowaway TYPE=HEAP
SELECT t.thingid
FROM thing t
/*INNER J...", 256)
file: /var/www/haddan/core/library/db_fns.php, 305
call: db_trigger_error("Write multi-query failed (1):
CREATE TEMPORARY TABLE thingstothrowaway TYPE=HEAP
SELECT t.thingid
FROM thing t
/*INNER J...", "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use...", 256)
file: /var/www/htdocs/inv/inv.php, 632
call: db_multiquery_write("CREATE TEMPORARY TABLE thingstothrowaway TYPE=HEAP
SELECT t.thingid
FROM thing t
/*INNER JOIN thingtype tt ON t.thingtypeid=...")
file: /var/www/htdocs/inv/inv.php, 391
call: throwAwayThing(Array(4))
file: /var/www/htdocs/inv/inv.php, 111
call: processInventoryPost(Array(4))
}
Locals:
Array
(
[querytext] => Write multi-query failed (1):
CREATE TEMPORARY TABLE thingstothrowaway TYPE=HEAP
SELECT t.thingid
FROM thing t
/*INNER JOIN thingtype tt ON t.thingtypeid=tt.thingtypeid*/
WHERE t.thingid='693757698' AND t.userid='850038' AND (t.clan = '' OR t.clan='850038') /*AND NOT FIND_IN_SET('clan', tt.tflags)*/ AND t.place='inv' AND t.placeid=0
LIMIT 1;
UPDATE thingstothrowaway
INNER JOIN thing USING(thingid)
SET userid=0, place='room', placetime=NOW(), placeid=16842752;
REPLACE INTO thingvisibility (thingid, userid, roomid)
SELECT thingid, 850038, 16842752
FROM thingstothrowaway;
SELECT COUNT(*), GROUP_CONCAT(thingid) INTO @cnt, @thingids FROM thingstothrowaway;
[error] => 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 'TYPE=HEAP
SELECT t.thingid
FROM thing t
/*INNER JOIN thingtype tt ON t.thing' at line 1
[type] => 256
)
7. Боты долго убиваются (остается 1 или 2 хп)
8. Проблемы с отображением информации о персонаже у персонажей (помойму связано с html инфой)
9. Товары у ботов не покупаются массово, только по 1 штуке (