Sw 13 Vs Асики

[marazm0 40]

Подскажите - в конфиге СВ13 нет сборки Акисов - какую команду выбирать чтобы все нормально отображало включая регистрацию

Изменено 5 ноября, 2013 пользователем marazm0

[marazm0 40]

Так же при регистрации пишет что ошибка БД хотя отображдает количество людей и кто в сети

[SoFace 315]

Во первых не Асик а aCis либо Акис (По Русски).

Во вторых пишите скрипт сами. Там все очень просто. Нужно только указать правильно таблицы БД и их колоны для автоматического заполнения.

[marazm0 40]

Во первых не Асик а aCis либо Акис (По Русски).

Во вторых пишите скрипт сами. Там все очень просто. Нужно только указать правильно таблицы БД и их колоны для автоматического заполнения.

 

Исправил в посте, в теме не могу. О печатался можно сказать, но пока нет возможности поправить постучал вскайп

[masone 298]

L2j ?

[zend 320]

Ищи файл в stressweb l2j\l2j_firstteam далее открывай его и копируй код что дал я. в админки stressweb выбиррай firstteam очишай кеш так же в админки, пробуй. Результат отпишешь сюда.

 

<?php
if (!defined("STRESSWEB")) die ("Access denied...");
$qList["FirstTeam"] = array (
"fields" => array(
 "accessLevel"=>"access_level",
 "charID"=>"obj_Id",
 ),
"insAccount" => "
 INSERT INTO `accounts` (`login`,`password`,`access_level`,`l2email`)
 VALUES ('{login}','{pass}','0','{l2email}')",
"setPassword" => "
 UPDATE `accounts`
 SET `password`='{pass}'
 WHERE `login`='{login}'",
"setAccessLevelAccount" => "
 UPDATE `accounts`
 SET `access_level`='{level}'
 WHERE `login`='{login}'",
"setAccessLevelCharacter" => "
 UPDATE `characters`
 SET `accesslevel`='{level}'
 WHERE `obj_Id`='{charID}'",

"setTeleport" => "
 UPDATE `characters`
 SET `x`='{x}',`y`='{y}',`z`='{z}',`lastteleport`='{lastteleport}'
 WHERE `obj_Id`='{charID}'",
"getCountAccounts" => "
 SELECT count(0)
 FROM accounts {where}",
"getCountCharacters" => "
 SELECT count(0)
 FROM characters {where}",
"getCountClans" => "
 SELECT count(0)
 FROM clan_data",
"getCountHuman" => "
 SELECT count(0)
 FROM characters
 LEFT JOIN character_subclasses ON character_subclasses.char_obj_id = characters.obj_Id AND character_subclasses.isBase='1'
 LEFT JOIN char_templates ON character_subclasses.class_id = char_templates.ClassId
 WHERE char_templates.RaceId='0' AND characters.accesslevel='0'",
"getCountElf" => "
 SELECT count(0)
 FROM characters
 LEFT JOIN character_subclasses ON character_subclasses.char_obj_id = characters.obj_Id AND character_subclasses.isBase='1'
 LEFT JOIN char_templates ON character_subclasses.class_id = char_templates.ClassId
 WHERE char_templates.RaceId='1' AND characters.accesslevel='0'",
"getCountDElf" => "
 SELECT count(0)
 FROM characters
 LEFT JOIN character_subclasses ON character_subclasses.char_obj_id = characters.obj_Id AND character_subclasses.isBase='1'
 LEFT JOIN char_templates ON character_subclasses.class_id = char_templates.ClassId
 WHERE char_templates.RaceId='2' AND characters.accesslevel='0'",
"getCountOrc" => "
 SELECT count(0)
 FROM characters
 LEFT JOIN character_subclasses ON character_subclasses.char_obj_id = characters.obj_Id AND character_subclasses.isBase='1'
 LEFT JOIN char_templates ON character_subclasses.class_id = char_templates.ClassId
 WHERE char_templates.RaceId='3' AND characters.accesslevel='0'",
"getCountDwarf" => "
 SELECT count(0)
 FROM characters
 LEFT JOIN character_subclasses ON character_subclasses.char_obj_id = characters.obj_Id AND character_subclasses.isBase='1'
 LEFT JOIN char_templates ON character_subclasses.class_id = char_templates.ClassId
 WHERE char_templates.RaceId='4' AND characters.accesslevel='0'",
"getCountDawn" => "
 SELECT count(0)
 FROM seven_signs
 WHERE cabal='dawn'",
"getCountDusk" => "
 SELECT count(0)
 FROM seven_signs
 WHERE cabal='dusk'",
"getAccount" => "
 SELECT login,password,last_access as lastactive,access_level AS accessLevel,last_ip as lastIP
 FROM `accounts`
 WHERE `login`='{login}' {where}
 LIMIT 1",
"getAccounts" => "
 SELECT login,last_access as lastactive,access_level,last_ip as lastIP
 FROM `accounts` {where}
 ORDER BY {order}
 LIMIT {limit}",
"getCharactersList" => "
 SELECT characters.account_name, characters.obj_Id, characters.char_name, character_subclasses.level, characters.accesslevel, characters.lastAccess, char_templates.ClassName
 FROM `characters`
 LEFT JOIN `character_subclasses` ON characters.obj_Id = character_subclasses.char_obj_id
 LEFT JOIN `char_templates` ON character_subclasses.class_id = char_templates.ClassId {where}
 ORDER BY characters.char_name
 LIMIT {limit}",
"getCharacter" => "
 SELECT characters.account_name, characters.char_name, character_subclasses.level, characters.sex, character_subclasses.class_id, characters.online, character_subclasses.exp, character_subclasses.sp, characters.karma, characters.pvpkills, characters.pkkills, characters.accesslevel, characters.onlinetime, characters.lastAccess, char_templates.ClassName, clan_data.clan_name
 FROM `characters`
 LEFT JOIN `character_subclasses` ON characters.obj_Id = character_subclasses.char_obj_id AND character_subclasses.isBase='1'
 LEFT JOIN `char_templates` ON character_subclasses.class_id = char_templates.ClassId
 LEFT JOIN `clan_data` ON characters.clanid = clan_data.clan_id
 WHERE characters.obj_Id='{charID}'",
"getCharacterInfo" => "
 SELECT characters.account_name, characters.char_name, character_subclasses.level, character_subclasses.maxHp, character_subclasses.maxCp, character_subclasses.maxMp, characters.sex, character_subclasses.exp, character_subclasses.sp, characters.pvpkills, characters.pkkills, characters.karma, char_templates.RaceId AS race, character_subclasses.class_id AS base_class, characters.accesslevel, characters.lastAccess, char_templates.ClassName, char_templates.STR, char_templates.CON, char_templates.DEX, char_templates._INT, char_templates.WIT, char_templates.MEN
 FROM `characters`
 LEFT JOIN `character_subclasses` ON characters.obj_Id = character_subclasses.char_obj_id
 LEFT JOIN `char_templates` ON character_subclasses.class_id = char_templates.ClassId
 WHERE characters.obj_Id='{charID}'",
"getAccountCharacters" => "
 SELECT characters.account_name, characters.obj_Id AS charID, characters.char_name, character_subclasses.level, characters.accesslevel, characters.lastAccess, characters.online, characters.onlinetime, char_templates.ClassName, clan_data.clan_name
 FROM `characters`
 LEFT JOIN `character_subclasses` ON characters.obj_Id = character_subclasses.char_obj_id AND character_subclasses.isBase='1'
 LEFT JOIN `char_templates` ON character_subclasses.class_id = char_templates.ClassId
 LEFT JOIN `clan_data` ON characters.clanid = clan_data.clan_id
 WHERE characters.account_name='{account}'
 ORDER BY characters.char_name",
"getTopClan"=>"
 SELECT clan_data.clan_name, clan_data.clan_id, ally_data.ally_name, clan_data.clan_level, clan_data.reputation_score, clan_data.hasCastle, characters.char_name, ccount
 FROM `clan_data`
 LEFT JOIN `characters` ON characters.obj_Id = clan_data.leader_id
 LEFT JOIN (
  SELECT clanid, count(0) AS ccount
  FROM characters
  WHERE clanid GROUP BY clanid
  ) AS levels ON clan_data.clan_id = levels.clanid
 LEFT JOIN `ally_data` ON clan_data.ally_id = ally_data.ally_id
 ORDER BY clan_data.clan_level DESC, clan_data.reputation_score DESC
 LIMIT {limit}",
"getTop" => "
 SELECT characters.char_name, character_subclasses.level, characters.sex, characters.pvpkills, characters.pkkills, characters.online, characters.onlinetime, char_templates.ClassName, clan_data.clan_name, clan_data.clan_id
 FROM `characters`
 LEFT JOIN `character_subclasses` ON characters.obj_Id = character_subclasses.char_obj_id AND character_subclasses.isBase='1'
 LEFT JOIN `char_templates` ON character_subclasses.class_id = char_templates.ClassId
 LEFT JOIN `clan_data` ON characters.clanid = clan_data.clan_id
 WHERE characters.accesslevel='0'
 ORDER BY {order} DESC
 LIMIT {limit}",
"getClanCharacters" => "
 SELECT characters.char_name, character_subclasses.level, characters.sex, characters.pvpkills, characters.pkkills, characters.online, characters.onlinetime, char_templates.ClassName, clan_data.clan_name, clan_data.clan_id
 FROM `characters`
 LEFT JOIN `character_subclasses` ON characters.obj_Id = character_subclasses.char_obj_id AND character_subclasses.isBase='1'
 LEFT JOIN `char_templates` ON character_subclasses.class_id = char_templates.ClassId
 LEFT JOIN `clan_data` ON characters.clanid = clan_data.clan_id
 WHERE characters.clanid='{clanid}'
 ORDER BY character_subclasses.level DESC",
"getOnline" => "
 SELECT characters.char_name, character_subclasses.level, characters.sex, characters.pvpkills, characters.pkkills, characters.online, characters.onlinetime, char_templates.ClassName, clan_data.clan_name, clan_data.clan_id
 FROM `characters`
 LEFT JOIN `character_subclasses` ON characters.obj_Id = character_subclasses.char_obj_id AND character_subclasses.isBase='1'
 LEFT JOIN `char_templates` ON character_subclasses.class_id = char_templates.ClassId
 LEFT JOIN `clan_data` ON characters.clanid = clan_data.clan_id
 WHERE characters.accesslevel='0' AND characters.online='1'
 ORDER BY character_subclasses.level DESC, characters.onlinetime DESC",
"getEpicStatus" => "
 SELECT epic_boss_spawn.respawnDate AS respawn_time, npc.name, npc.level
 FROM epic_boss_spawn
 LEFT JOIN npc ON epic_boss_spawn.bossId = npc.id
 ORDER BY npc.level DESC",
"getRaidStatus" => "
 SELECT raidboss_status.respawn_delay AS respawn_time, npc.level, npc.name
 FROM raidboss_status
 LEFT JOIN npc ON raidboss_status.id = npc.id
 ORDER BY npc.level DESC, npc.name ASC",
"getClan" => "
 SELECT clan_name
 FROM clan_data
 WHERE clan_id='{clanid}'",
"getCastles" => "
 SELECT castle.name, castle.id, castle.tax_percent as taxPercent, castle.siege_date as siegeDate, clan_data.clan_name, clan_data.clan_id
 FROM castle
 LEFT JOIN clan_data ON clan_data.hasCastle = castle.id",
"getSiege" => "
 SELECT siege_clans.residence_id as castle_id, siege_clans.clan_id, siege_clans.type, clan_data.clan_name
 FROM siege_clans
 LEFT JOIN clan_data ON clan_data.clan_id = siege_clans.clan_id
 WHERE residence_id='{castle}'",
"getOlympiad" => "
 SELECT characters.char_name, olympiad_nobles.olympiad_points, olympiad_nobles.competitions_done, char_templates.ClassName, characters.sex
 FROM olympiad_nobles
 LEFT JOIN char_templates ON olympiad_nobles.class_id = char_templates.ClassId
 LEFT JOIN characters ON olympiad_nobles.char_id = characters.obj_Id
 ORDER BY olympiad_nobles.class_id, olympiad_nobles.olympiad_points DESC",
"getLastTeleport" => "
 SELECT `char_name`,`online`,`accesslevel`,`lastteleport`
 FROM `characters`
 WHERE `obj_Id`='{charID}'",
"l2top" => array(
 "getChar" => "
  SELECT account_name, obj_Id AS charID, online
  FROM `characters`
  WHERE `char_name`='{name}'",
 ),
"getByLevel" => "
 SELECT characters.char_name
 FROM characters
 LEFT JOIN character_subclasses ON character_subclasses.char_obj_id = characters.obj_Id AND character_subclasses.isBase='1' 
 WHERE characters.account_name='{account}' AND character_subclasses.level>={level}
 LIMIT 1",

);
?>

[zend 320]

Так же хочу очень увидеть ошибку MySQL включи вывод ошибок в админки stressweb.

Так же не забыл ли ты про запросы св для логин сервера?

Изменено 5 ноября, 2013 пользователем zend

[marazm0 40]

При регистрации нового пользователя ( личный кабинет) в игру пускает, а когда на сайте хочу зайти - пишет пользователь не найден