Форумы мира Хаддан
Страница 11 из 20 « Первая < 78910 11 12131415 > Последняя »
Показывать 40 сообщений этой темы на одной странице

Форумы мира Хаддан (http://forum.haddan.ru/index.php)
-   Общий форум (http://forum.haddan.ru/forumdisplay.php?f=9)
-   -   Тест Хаддана (http://forum.haddan.ru/showthread.php?t=111999)

Maelstorm 11.11.2014 19:01
Цитата:
Сообщение от Mr. Bugy men
Код:
CREATE TEMPORARY TABLE thingstothrowaway TYPE=HEAP
Это вместо транзакций вы используете?:crazy:
Учти матчасть в разделах MyISAM и InnoDB : вопросы быстродействия.

Исправлены ошибки с русским языком. Остается вопрос с наименованием вещей в послебоевом сообщении, не могу сказать исправились они или нет. Проверьте

Логайн 11.11.2014 19:11
Инфа кнопаха
 
Код:
Context info for the following error/warning:
Error: 256, Read query failed:
SELECT r.name AS racename, UNIX_TIMESTAMP(u.registered) AS registered, UNIX_TIMESTAMP(u.lastlogin) AS lastlogin, ur.realname, ur.realsex, ur.country, ur.city, ur.icq, ur.homepage, u.slogan, u.about, u.image, cr.rank_name AS clantitle, up.val AS verdict, FIND_IN_SET('redirectinfo', u.flags) AS redirectinfo, FIND_IN_SET('blocked', u.flags) AS blocked, (FIND_IN_SET('htmlinabout', u.flags) OR FIND_IN_SET('htmlinabout', clan.flags)) AS htmlinabout, (FIND_IN_SET('htmlinslogan', u.flags) OR FIND_IN_SET('htmlinslogan', clan.flags)) AS htmlinslogan, (FIND_IN_SET('htmlinrealname', u.flags) OR FIND_IN_SET('htmlinrealname', clan.flags)) AS htmlinrealname, (FIND_IN_SET('htmlincountry', u.flags) OR FIND_IN_SET('htmlincountry', clan.flags)) AS htmlincountry, (FIND_IN_SET('htmlincity', u.flags) OR FIND_IN_SET('htmlincity', clan.flags)) AS htmlincity, IFNULL(session.roomid, b.roomid) AS online, IFNULL(u.lastroomid, b.roomid) AS roomid, IFNULL(u.wins, npc.wins) AS wins, IFNULL(u.loses, npc.loses) AS loses, IFNULL(u.draws, npc.draws) AS draws, IFNULL(u.deaths, npc.deaths) AS deaths, bm.state AS battlestate, UNIX_TIMESTAMP(b.timestart) AS battlestart, b.round AS battleround, b.weapon AS battleweapon, bm.userid, bm.memberid, bm.battleid, bm.color, bm.state, 0 as bstamp, bm.killedpc, bm.killednpc, bm.hitpc, bm.hitnpc, bm.num, bm.expa, bm.hp AS bmhp, bm.hpc AS bmhpc, bm.mpc AS bmmpc, bm.bfc AS bmbfc, CONCAT(IFNULL(u.username, npc.name), IF(num > 0, num + 1, '')) AS username, IFNULL(u.race, npc.race) AS race, IFNULL(u.sex, npc.sex) AS sex, u.clan, u.teacher, npc.bonus AS x_bonus, npc.req AS x_req, npc.brcache AS x_brcache, IF(bm.level<>0,bm.level,IFNULL(u.`level`, npc.`level`)) AS level, IFNULL(u.lastroomid,0) as roomid, IFNULL(u.image, npc.image) AS image, IF(session.userid IS NOT NULL OR bm.userid < 0, 1, 0) AS online, IFNULL(u.`aligEG`, npc.`aligEG`) AS `aligEG`, IFNULL(u.`aligCL`, npc.`aligCL`) AS `aligCL`, IFNULL(u.`str`, npc.`str`) AS `str`, IFNULL(u.`dex`, npc.`dex`) AS `dex`, IFNULL(u.`rag`, npc.`rag`) AS `rag`, IFNULL(u.`int`, npc.`int`) AS `int`, IFNULL(u.`wis`, npc.`wis`) AS `wis`, IFNULL(u.`inu`, npc.`inu`) AS `inu`, IFNULL(u.`con`, npc.`con`) AS `con`, IFNULL(u.`eng`, npc.`eng`) AS `eng`, IFNULL(u.`exp`, npc.`exp`) AS `exp`, IFNULL(u.hpc, bm.hpc) AS hpc, IFNULL(u.mpc, bm.mpc) AS mpc, u.hpt AS hpt, u.mpt AS mpt, u.bft AS bft, IFNULL(u.bf, 100) as bf, IFNULL(u.bfc, 100) as bfc, u.add, u.cash, u.icon, u.`maginq`, u.`mstadd`, u.`profession`, u.`prof_exp`, u.`pair`, u.`usercontext`, u.battleid AS battleid_bound, IFNULL(u.`mstp`, npc.`mstp`) AS `mstp`, IFNULL(u.`msts`, npc.`msts`) AS `msts`, IFNULL(u.`mstc`, npc.`mstc`) AS `mstc`, IFNULL(u.`mstb`, npc.`mstb`) AS `mstb`, IFNULL(u.`mst2`, npc.`mst2`) AS `mst2`, IFNULL(u.`mst1`, npc.`mst1`) AS `mst1`, IFNULL(u.`mst11`, npc.`mst11`) AS `mst11`, IFNULL(u.`mstd`, npc.`mstd`) AS `mstd`, IFNULL(u.`msth`, npc.`msth`) AS `msth`, IFNULL(u.`magfire`, npc.`magfire`) AS `magfire`, IFNULL(u.`magair`, npc.`magair`) AS `magair`, IFNULL(u.`magwater`, npc.`magwater`) AS `magwater`, IFNULL(u.`magearth`, npc.`magearth`) AS `magearth`, IFNULL(u.`magblack`, npc.`magblack`) AS `magblack`, IFNULL(u.`magwhite`, npc.`magwhite`) AS `magwhite`, IFNULL(u.`maggray`, npc.`maggray`) AS `maggray`, IFNULL(u.`magshaman`, npc.`magshaman`) AS `magshaman`, IFNULL(u.effects, bm.effects) AS effects, bm.wearro, u.slots, u.petid, u.partyid, u.partystamp,u.karma,u.class, /*IFNULL(u.wear, npc.wear) AS wear,*/ IFNULL(u.w_ring1, npc.w_ring1) AS w_ring1, IFNULL(u.w_ring2, npc.w_ring2) AS w_ring2, IFNULL(u.w_ring3, npc.w_ring3) AS w_ring3, IFNULL(u.w_earing, npc.w_earing) AS w_earing, IFNULL(u.w_amulet, npc.w_amulet) AS w_amulet, IFNULL(u.w_necklace, npc.w_necklace) AS w_necklace, IFNULL(u.w_weapon1, npc.w_weapon1) AS w_weapon1, IFNULL(u.w_weapon2, npc.w_weapon2) AS w_weapon2, IFNULL(u.w_armor, npc.w_armor) AS w_armor, IFNULL(u.w_helmet, npc.w_helmet) AS w_helmet, IFNULL(u.w_bracers, npc.w_bracers) AS w_bracers, IFNULL(u.w_gloves, npc.w_gloves) AS w_gloves, IFNULL(u.w_belt, npc.w_belt) AS w_belt, IFNULL(u.w_pants, npc.w_pants) AS w_pants, IFNULL(u.w_boots, npc.w_boots) AS w_boots, IFNULL(u.w_underhelmet, npc.w_underhelmet) AS w_underhelmet, IFNULL(u.w_underarmor, npc.w_underarmor) AS w_underarmor, IFNULL(u.w_underpants, npc.w_underpants) AS w_underpants, IFNULL(u.w_underboots, npc.w_underboots) AS w_underboots, IFNULL(u.w_overhelmet, npc.w_overhelmet) AS w_overhelmet, IFNULL(u.w_overarmor, npc.w_overarmor) AS w_overarmor, IFNULL(u.w_overpants, npc.w_overpants) AS w_overpants, IFNULL(u.w_overboots, npc.w_overboots) AS w_overboots FROM `haddanarc`.battlemember AS bm LEFT JOIN session ON (bm.userid > 0 AND bm.userid=session.userid) LEFT JOIN user AS u ON (bm.userid > 0 AND bm.userid=u.userid) LEFT JOIN npc ON (bm.userid < 0 AND bm.userid=npc.npcid) LEFT JOIN race r ON r.raceid=u.race OR r.raceid=npc.race LEFT JOIN user_prop_str up ON up.userid=u.userid AND up.name='verdict' LEFT JOIN clan_ranks cr ON u.clantitle=cr.uid LEFT JOIN clan ON u.clan=clan.clanid LEFT JOIN `haddanarc`.battle b ON b.battleid=bm.battleid LEFT JOIN userreal ur ON u.ruid = ur.ruid WHERE bm.memberid='484467585'
With result:
Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation 'ifnull'
in /var/www/haddan/core/library/db_fns.php, 332

Backtrace: {
file: /var/www/haddan/core/library/db_fns.php, 332
call: trigger_error("Read query failed:

SELECT r.name AS racename,
UNIX_TIMESTAMP(u.registered) AS registered,
UNIX_TIMESTAMP(u.lastlogin) AS l...", 256)

file: /var/www/haddan/core/library/db_fns.php, 201
call: db_trigger_error("Read query failed:

SELECT r.name AS racename,
UNIX_TIMESTAMP(u.registered) AS registered,
UNIX_TIMESTAMP(u.lastlogin) AS l...", "Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation 'ifnull'", 256)

file: /var/www/htdocs/user.php, 136
call: db_query_read("SELECT r.name AS racename,
UNIX_TIMESTAMP(u.registered) AS registered,
UNIX_TIMESTAMP(u.lastlogin) AS lastlogin,
ur.realname,...")
}
Locals:
Array
(
    [querytext] => Read query failed:

SELECT r.name AS racename,
UNIX_TIMESTAMP(u.registered) AS registered,
UNIX_TIMESTAMP(u.lastlogin) AS lastlogin,
ur.realname, ur.realsex, ur.country, ur.city, ur.icq, ur.homepage,
u.slogan, u.about, u.image,
cr.rank_name AS clantitle,
up.val AS verdict,
FIND_IN_SET('redirectinfo', u.flags) AS redirectinfo,
FIND_IN_SET('blocked', u.flags) AS blocked,
(FIND_IN_SET('htmlinabout', u.flags) OR FIND_IN_SET('htmlinabout', clan.flags)) AS htmlinabout,
(FIND_IN_SET('htmlinslogan', u.flags) OR FIND_IN_SET('htmlinslogan', clan.flags)) AS htmlinslogan,
(FIND_IN_SET('htmlinrealname', u.flags) OR FIND_IN_SET('htmlinrealname', clan.flags)) AS htmlinrealname,
(FIND_IN_SET('htmlincountry', u.flags) OR FIND_IN_SET('htmlincountry', clan.flags)) AS htmlincountry,
(FIND_IN_SET('htmlincity', u.flags) OR FIND_IN_SET('htmlincity', clan.flags)) AS htmlincity,
IFNULL(session.roomid, b.roomid) AS online,
IFNULL(u.lastroomid, b.roomid) AS roomid,
IFNULL(u.wins, npc.wins) AS wins,
IFNULL(u.loses, npc.loses) AS loses,
IFNULL(u.draws, npc.draws) AS draws,
IFNULL(u.deaths, npc.deaths) AS deaths,
bm.state AS battlestate,
UNIX_TIMESTAMP(b.timestart) AS battlestart,
b.round AS battleround,
b.weapon AS battleweapon,
 bm.userid, bm.memberid, bm.battleid, bm.color, bm.state, 0 as bstamp,
  bm.killedpc, bm.killednpc, bm.hitpc, bm.hitnpc, bm.num, bm.expa,
  bm.hp AS bmhp, bm.hpc AS bmhpc, bm.mpc AS bmmpc, bm.bfc AS bmbfc,
  CONCAT(IFNULL(u.username, npc.name), IF(num > 0, num + 1, '')) AS username,
  IFNULL(u.race, npc.race) AS race,
  IFNULL(u.sex, npc.sex) AS sex,
 
  u.clan, u.teacher,
  npc.bonus AS x_bonus, npc.req AS x_req, npc.brcache AS x_brcache,
 
  IF(bm.level<>0,bm.level,IFNULL(u.`level`, npc.`level`)) AS level,
   
  IFNULL(u.lastroomid,0) as roomid, 
 
  IFNULL(u.image, npc.image) AS image,
  IF(session.userid IS NOT NULL OR bm.userid < 0, 1, 0) AS online,
  IFNULL(u.`aligEG`, npc.`aligEG`) AS `aligEG`,
  IFNULL(u.`aligCL`, npc.`aligCL`) AS `aligCL`,
  IFNULL(u.`str`, npc.`str`) AS `str`,
  IFNULL(u.`dex`, npc.`dex`) AS `dex`,
  IFNULL(u.`rag`, npc.`rag`) AS `rag`,
  IFNULL(u.`int`, npc.`int`) AS `int`,
  IFNULL(u.`wis`, npc.`wis`) AS `wis`,
  IFNULL(u.`inu`, npc.`inu`) AS `inu`,
  IFNULL(u.`con`, npc.`con`) AS `con`,
  IFNULL(u.`eng`, npc.`eng`) AS `eng`,
  IFNULL(u.`exp`, npc.`exp`) AS `exp`,
  IFNULL(u.hpc, bm.hpc) AS hpc,
  IFNULL(u.mpc, bm.mpc) AS mpc,
  u.hpt AS hpt,
  u.mpt AS mpt,
  u.bft AS bft,
  IFNULL(u.bf, 100) as bf,
  IFNULL(u.bfc, 100) as bfc,
  u.add, u.cash, u.icon,
  u.`maginq`, u.`mstadd`,
  u.`profession`, u.`prof_exp`,
  u.`pair`, u.`usercontext`,
  u.battleid AS battleid_bound,
  IFNULL(u.`mstp`, npc.`mstp`) AS `mstp`,
  IFNULL(u.`msts`, npc.`msts`) AS `msts`,
  IFNULL(u.`mstc`, npc.`mstc`) AS `mstc`,
  IFNULL(u.`mstb`, npc.`mstb`) AS `mstb`,
  IFNULL(u.`mst2`, npc.`mst2`) AS `mst2`,
  IFNULL(u.`mst1`, npc.`mst1`) AS `mst1`,
  IFNULL(u.`mst11`, npc.`mst11`) AS `mst11`,
  IFNULL(u.`mstd`, npc.`mstd`) AS `mstd`,
  IFNULL(u.`msth`, npc.`msth`) AS `msth`,
  IFNULL(u.`magfire`, npc.`magfire`) AS `magfire`,
  IFNULL(u.`magair`, npc.`magair`) AS `magair`,
  IFNULL(u.`magwater`, npc.`magwater`) AS `magwater`,
  IFNULL(u.`magearth`, npc.`magearth`) AS `magearth`,
  IFNULL(u.`magblack`, npc.`magblack`) AS `magblack`,
  IFNULL(u.`magwhite`, npc.`magwhite`) AS `magwhite`,
  IFNULL(u.`maggray`, npc.`maggray`) AS `maggray`,
  IFNULL(u.`magshaman`, npc.`magshaman`) AS `magshaman`,
  IFNULL(u.effects, bm.effects) AS effects,
  bm.wearro,
  u.slots, u.petid,
  u.partyid, u.partystamp,u.karma,u.class,
  /*IFNULL(u.wear, npc.wear) AS wear,*/
  IFNULL(u.w_ring1, npc.w_ring1) AS w_ring1,
  IFNULL(u.w_ring2, npc.w_ring2) AS w_ring2,
  IFNULL(u.w_ring3, npc.w_ring3) AS w_ring3,
  IFNULL(u.w_earing, npc.w_earing) AS w_earing,
  IFNULL(u.w_amulet, npc.w_amulet) AS w_amulet,
  IFNULL(u.w_necklace, npc.w_necklace) AS w_necklace,
  IFNULL(u.w_weapon1, npc.w_weapon1) AS w_weapon1,
  IFNULL(u.w_weapon2, npc.w_weapon2) AS w_weapon2,
  IFNULL(u.w_armor, npc.w_armor) AS w_armor,
  IFNULL(u.w_helmet, npc.w_helmet) AS w_helmet,
  IFNULL(u.w_bracers, npc.w_bracers) AS w_bracers,
  IFNULL(u.w_gloves, npc.w_gloves) AS w_gloves,
  IFNULL(u.w_belt, npc.w_belt) AS w_belt,
  IFNULL(u.w_pants, npc.w_pants) AS w_pants,
  IFNULL(u.w_boots, npc.w_boots) AS w_boots,
  IFNULL(u.w_underhelmet, npc.w_underhelmet) AS w_underhelmet,
  IFNULL(u.w_underarmor, npc.w_underarmor) AS w_underarmor,
  IFNULL(u.w_underpants, npc.w_underpants) AS w_underpants,
  IFNULL(u.w_underboots, npc.w_underboots) AS w_underboots,
  IFNULL(u.w_overhelmet, npc.w_overhelmet) AS w_overhelmet,
  IFNULL(u.w_overarmor, npc.w_overarmor) AS w_overarmor,
  IFNULL(u.w_overpants, npc.w_overpants) AS w_overpants,
  IFNULL(u.w_overboots, npc.w_overboots) AS w_overboots
FROM `haddanarc`.battlemember AS bm
  LEFT JOIN session ON (bm.userid > 0 AND bm.userid=session.userid)
  LEFT JOIN user AS u ON (bm.userid > 0 AND bm.userid=u.userid)
  LEFT JOIN npc ON (bm.userid < 0 AND bm.userid=npc.npcid)
LEFT JOIN race r ON r.raceid=u.race OR r.raceid=npc.race
LEFT JOIN user_prop_str up ON up.userid=u.userid AND up.name='verdict'
LEFT JOIN clan_ranks cr ON u.clantitle=cr.uid
LEFT JOIN clan ON u.clan=clan.clanid
LEFT JOIN `haddanarc`.battle b ON b.battleid=bm.battleid
LEFT JOIN userreal ur ON u.ruid = ur.ruid
WHERE bm.memberid='484467585'
    [error] => Illegal mix of collations (cp1251_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation 'ifnull'
    [type] => 256
)

DespoD 11.11.2014 19:17
в бою когда много атак .... не обновляется само ... жмешь обновить идет дальше бой

жан клод ЛЕНИН 11.11.2014 19:36
Раунд 2 паппапап
Цитата:
18:03:45 +72 Ледяной элементаль (??? ???? ?????)npc[1622/1622], -15 +100 жан клод ЛЕНИН[1651/1684]
18:03:45 Ледяной элементаль (??? ???? ?????)npc: удар по Вааздилnpc (в пах). Результат: Удары: -144 Вааздилnpc[0/325] Смерть
18:03:45 Ледяной элементаль (??? ???? ?????)npc: удар по Вааздилnpc (в корпус). Результат: Заблокировано, но блок пробит! Удары: -90 Вааздилnpc[105/325]
18:03:45 жан клод ЛЕНИН: читает из книги заклинание Благословление леса. Результат: {Благословление леса} жан клод ЛЕНИН[1551/1684], {Благословление леса} Ледяной элементаль (??? ???? ?????)npc[1550/1622].
18:02:49 Проклятый скрипень (??? ???? ?????)npc: удар по Вааздилnpc (в живот). Результат: Заблокировано, но блок пробит! Удары: -22 Вааздилnpc[195/325]
18:03:45 Ледяной элементаль (??? ???? ?????)npc: удар по Вааздилnpc (в голову). Результат: Заблокировано, но блок пробит! Удары: -108 Вааздилnpc[217/325]
18:02:49 жан клод ЛЕНИН находится под защитой. Ледяной элементаль (??? ???? ?????) принимает атаку на себя. Вааздилnpc: удар по Ледяной элементаль (??? ???? ?????)npc (в корпус). Результат: Уворот! Ледяной элементаль (??? ???? ?????)npc[1550/1550] проводит контратаку.

Жалость 11.11.2014 19:41
Я получил ежедневную награду 3 раза((

∇ 19:31 Вездесущий: БОНУС №4.Вы получаете 240мн! Приходите завтра и получите больше! Каждый 5-ый день - 2 змн! Бонус растет на уровнях 6, 11, 16 и 21!
∇ 19:31 Вездесущий: БОНУС №4.Вы получаете 240мн! Приходите завтра и получите больше! Каждый 5-ый день - 2 змн! Бонус растет на уровнях 6, 11, 16 и 21!
∇ 19:31 Вездесущий: БОНУС №4.Вы получаете 240мн! Приходите завтра и получите больше! Каждый 5-ый день - 2 змн! Бонус растет на уровнях 6, 11, 16 и 21!

жан клод ЛЕНИН 11.11.2014 19:42
Цитата:
Сообщение от Жалость
Я получил ежедневную награду 3 раза((

∇ 19:31 Вездесущий: БОНУС №4.Вы получаете 240мн! Приходите завтра и получите больше! Каждый 5-ый день - 2 змн! Бонус растет на уровнях 6, 11, 16 и 21!
∇ 19:31 Вездесущий: БОНУС №4.Вы получаете 240мн! Приходите завтра и получите больше! Каждый 5-ый день - 2 змн! Бонус растет на уровнях 6, 11, 16 и 21!
∇ 19:31 Вездесущий: БОНУС №4.Вы получаете 240мн! Приходите завтра и получите больше! Каждый 5-ый день - 2 змн! Бонус растет на уровнях 6, 11, 16 и 21!

это у тебя инет подвис. на самом деле ты его получил 1 раз.

Жалость 11.11.2014 19:43
Неа. 3 раза. К тому же я смог потратить все 720 монет...

Жалость 11.11.2014 19:43
Новые сапоги от Али http://haddan.ru/thing.php?id=602129401, почему-то сразу с зачарованием... не заказывал

GRENZGAENGER 11.11.2014 20:09
между с оружиемУменьшение износа; аура взаимной ненависти сторон в этом бою снижает износ всех вещей в 3 раза. кланами ??????? ???????? ??????? ???????? и ????????? ?? ???? ????????? ?? ????

В боях ЭКВ

DespoD 11.11.2014 20:15
Код:
Context info for the following error/warning:
Error: 1024, Write multi-query failed (1):
CREATE TEMPORARY TABLE `cnv` ( `id` int(10) unsigned NOT NULL, `fld` set('unique','rare','artefact','quest','goldcoins','clan','npc','nolib','nodamage','retired','diamondcoins','active','sell4gold','binded','nodurable') NOT NULL default '' ) TYPE=HEAP SELECT 1 AS `id`, 'goldcoins' AS `fld`; SET @set_num := (SELECT `fld`+0 FROM `cnv` WHERE `id`=1); DROP TEMPORARY TABLE `cnv`
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 1 AS `id`, 'goldcoins' AS `fld`; SET @set_num := (SELECT `f' at line 4
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 `cnv` (
`id` int(10) unsigned NOT NULL,
`fld` set('unique','rare','ar...")

file: /var/www/haddan/core/library/db_fns.php, 305
call: db_trigger_error("Write multi-query failed (1):

CREATE TEMPORARY TABLE `cnv` (
`id` int(10) unsigned NOT NULL,
`fld` set('unique','rare','ar...", "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/haddan/core/library/BonReq.php, 619
call: db_multiquery_write("CREATE TEMPORARY TABLE `cnv` (
`id` int(10) unsigned NOT NULL,
`fld` set('unique','rare','artefact','quest','goldcoins','clan'...")

file: /var/www/haddan/core/library/BonReq.php(48) : eval()'d code, 1
call: BRBase::make_sql_set("goldcoins", "thingtype", "tflags")

file: /var/www/haddan/core/library/BonReq.php, 48
call: eval()

file: /var/www/haddan/core/library/BonReq.php, 940
call: BRBase::_getVal("
file: /var/www/haddan/core/library/BonReq.php, 1467
call: Bon->_initFromString("filter.flags:
file: /var/www/haddan/core/library/BonReq.php, 1448
call: Bon::_initBonuses("x.fixedprices: 1;
filter.flags:
file: /var/www/haddan/core/library/BonReq.php, 1601
call: Bon::_initBonusesEx("x.fixedprices: 1;
filter.flags:
file: /var/www/haddan/core/library/BonReq.php, 1575
call: BonReqs->initFromArray(Array(13), Null)

file: /var/www/haddan/core/roomfunc/shop_helper.php, 92
call: BonReqs::createFromArray(Array(13), "UPDATE `shop_dpt` SET `brcache`='%CACHE%' WHERE `dptid`='31'")

file: /var/www/haddan/core/roomfunc/shop_helper.php, 202
call: shopDptSelect(-2, 31, Array(7), False)

file: /var/www/htdocs/room/func/shop.php, 39
call: shopMain(Array(7))
}
Locals:
Array
(
    [querytext] => Write multi-query failed (1):

CREATE TEMPORARY TABLE `cnv` (
`id` int(10) unsigned NOT NULL,
`fld` set('unique','rare','artefact','quest','goldcoins','clan','npc','nolib','nodamage','retired','diamondcoins','active','sell4gold','binded','nodurable') NOT NULL default ''
) TYPE=HEAP
SELECT 1 AS `id`, 'goldcoins' AS `fld`;

SET @set_num := (SELECT `fld`+0 FROM `cnv` WHERE `id`=1);

DROP TEMPORARY TABLE `cnv`
    [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 1 AS `id`, 'goldcoins' AS `fld`;

SET @set_num := (SELECT `f' at line 4
    [type] => 256
)

Context info for the following error/warning:
Error: 256, Write multi-query failed (1):
CREATE TEMPORARY TABLE `cnv` ( `id` int(10) unsigned NOT NULL, `fld` set('unique','rare','artefact','quest','goldcoins','clan','npc','nolib','nodamage','retired','diamondcoins','active','sell4gold','binded','nodurable') NOT NULL default '' ) TYPE=HEAP SELECT 1 AS `id`, 'goldcoins' AS `fld`; SET @set_num := (SELECT `fld`+0 FROM `cnv` WHERE `id`=1); DROP TEMPORARY TABLE `cnv`
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 1 AS `id`, 'goldcoins' AS `fld`; SET @set_num := (SELECT `f' at line 4
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 `cnv` (
`id` int(10) unsigned NOT NULL,
`fld` set('unique','rare','ar...", 256)

file: /var/www/haddan/core/library/db_fns.php, 305
call: db_trigger_error("Write multi-query failed (1):

CREATE TEMPORARY TABLE `cnv` (
`id` int(10) unsigned NOT NULL,
`fld` set('unique','rare','ar...", "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/haddan/core/library/BonReq.php, 619
call: db_multiquery_write("CREATE TEMPORARY TABLE `cnv` (
`id` int(10) unsigned NOT NULL,
`fld` set('unique','rare','artefact','quest','goldcoins','clan'...")

file: /var/www/haddan/core/library/BonReq.php(48) : eval()'d code, 1
call: BRBase::make_sql_set("goldcoins", "thingtype", "tflags")

file: /var/www/haddan/core/library/BonReq.php, 48
call: eval()

file: /var/www/haddan/core/library/BonReq.php, 940
call: BRBase::_getVal("
file: /var/www/haddan/core/library/BonReq.php, 1467
call: Bon->_initFromString("filter.flags:
file: /var/www/haddan/core/library/BonReq.php, 1448
call: Bon::_initBonuses("x.fixedprices: 1;
filter.flags:
file: /var/www/haddan/core/library/BonReq.php, 1601
call: Bon::_initBonusesEx("x.fixedprices: 1;
filter.flags:
file: /var/www/haddan/core/library/BonReq.php, 1575
call: BonReqs->initFromArray(Array(13), Null)

file: /var/www/haddan/core/roomfunc/shop_helper.php, 92
call: BonReqs::createFromArray(Array(13), "UPDATE `shop_dpt` SET `brcache`='%CACHE%' WHERE `dptid`='31'")

file: /var/www/haddan/core/roomfunc/shop_helper.php, 202
call: shopDptSelect(-2, 31, Array(7), False)

file: /var/www/htdocs/room/func/shop.php, 39
call: shopMain(Array(7))
}
Locals:
Array
(
    [querytext] => Write multi-query failed (1):

CREATE TEMPORARY TABLE `cnv` (
`id` int(10) unsigned NOT NULL,
`fld` set('unique','rare','artefact','quest','goldcoins','clan','npc','nolib','nodamage','retired','diamondcoins','active','sell4gold','binded','nodurable') NOT NULL default ''
) TYPE=HEAP
SELECT 1 AS `id`, 'goldcoins' AS `fld`;

SET @set_num := (SELECT `fld`+0 FROM `cnv` WHERE `id`=1);

DROP TEMPORARY TABLE `cnv`
    [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 1 AS `id`, 'goldcoins' AS `fld`;

SET @set_num := (SELECT `f' at line 4
    [type] => 256
)
выходит в баре во вкладке "Эксклюзив"


Часовой пояс GMT +4, время: 21:35.
Страница 11 из 20 « Первая < 78910 11 12131415 > Последняя »
Показывать 40 сообщений этой темы на одной странице

Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd. Адаптация Архивариус & dukei