Форум администраторов игровых серверов

Цитата:

Сообщение от ANZO (Сообщение 157518)

Эти кабинеты и обвязки вообще-то под ПТС платформу, а не жабу.

В том то и суть топика)
подскажите что под жабу)

ну я не совсем ноль,
как бы исходя из логики понять можно,

а по поводу гхтвеба, он под жабу катит проблема в конекте к бд
акаунты читает, но некоторые строки в коде отвечают за поиск чаров на аккаунте. Проблема в том что половину этих значений нет в моей сборке, они лишние....такие как лвл,макс, хп, макс мп и т.д.
и из за этого система не видит персонажей в бд.

полный код

Цитата:

<?php if (!defined('BASEPATH')) exit('No direct script access allowed');

$q_list['l2Phoenix'] = array(

// SELECT
'check_login' => "
SELECT *
FROM `accounts`
WHERE `login` = ?
LIMIT 1
",

'check_login_and_password' => "
SELECT *
FROM `accounts`
WHERE `login` = ?
AND `password` = ?
LIMIT 1
",

'get_game_account_list' => "
SELECT `login`,`lastactive`,`lastIP`,`user_id`,`server_id `
FROM `accounts`
WHERE `user_id` = ?
AND `server_id` = ?
",

/* 'get_characters_where_account_name' => "
SELECT `account_name`,`charId` AS `char_id`,`char_name`,`level`,`maxHp`,`curHp`,`max Cp`,`maxMp`,`sex`,`x`,`y`,
`z`,`exp`,`sp`,`karma`,`pvpkills`,`pkkills`,`clani d`,`race`,`classid`,`base_class`,`title`,`online`,
`onlinetime`,`lastAccess`,`nobless`
FROM `characters`
WHERE `account_name` = ?
",*/

'get_all_characters_count' => "
SELECT COUNT(0) as `count`
FROM `characters`
",

'get_all_characters' => "
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 ?,?
",

'get_all_characters_where_login' => "
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}
WHERE characters.account_name = ?
ORDER BY characters.level DESC
",

'get_all_accounts' => "
SELECT `login`, `lastactive`, `access_level`, `lastIP`, `user_id`, `server_id`
FROM `accounts`
ORDER BY `login`
LIMIT ?,?
",

'get_all_accounts_count' => "
SELECT COUNT(0) as `count`
FROM `accounts`
",

'get_character' => "
SELECT *
FROM characters
WHERE characters.obj_Id = ?
LIMIT 1
",

'get_character_inventar' => "
SELECT items.object_id,items.item_id,items.count,items.en chant_level,items.loc,items.loc_data
FROM items
WHERE items.owner_id = ?
",

// UPDATE
'snap_game_account' => "
UPDATE `accounts`
SET `user_id` = ?, `server_id` = ?
WHERE `login` = ?
AND `password` = ?
LIMIT 1
",

'change_inventory_item' => "
UPDATE `items`
SET `count` = ?, `enchant_level` = ?
WHERE `object_id` = ?
",

// INSERT
'insert_accounts' => "
INSERT INTO `accounts` (`login`,`password`,`access_level`,`user_id`,`serv er_id`)
VALUE (?,?,0,?,?)
",

// DELETE
'delete_inventory_item' => "
DELETE FROM `items`
WHERE `object_id` = ?
LIMIT 1
",

// Статистика
'get_count_online_characters' => "
SELECT COUNT(0) as `count`
FROM `characters`
WHERE `online` = '1'
",

'get_count_game_accounts' => "
SELECT COUNT(0) as `count`
FROM `accounts`
",

'get_count_characters' => "
SELECT COUNT(0) as `count`
FROM `characters`
",

'get_count_clans' => "
SELECT COUNT(0) as `count`
FROM `clan_data`
",

'get_count_humans' => "
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'
",

'get_count_elf' => "
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'
",

'get_count_delf' => "
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'
",

'get_count_orcs' => "
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'
",

'get_count_dwarf' => "
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'
",

'get_count_kamael' => "
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='5' AND characters.accesslevel='0'
",

'get_top_pvp' => "
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 characters.pvpkills DESC
LIMIT ?
",

'get_top_online' => "
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 characters.onlinetime DESC
LIMIT ?
",

'get_top_top' => "
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 characters.exp DESC
LIMIT ?
",

'get_top_pk' => "
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 characters.pkkills DESC
LIMIT ?
",

'get_top_clans' => "
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 ?
",

'get_castles' => "
SELECT castle.siegeDate,castle.id,castle.`name`,castle.ta xPercent,clan_data.clan_id,clan_data.clan_name
FROM `castle`
LEFT JOIN clan_data ON clan_data.hasCastle = castle.id
ORDER BY `id`
",

'get_siege' => "
SELECT siege_clans.unit_id, siege_clans.clan_id, siege_clans.type, siege_clans.castle_owner, clan_data.clan_name
FROM siege_clans
LEFT JOIN clan_data ON clan_data.clan_id = siege_clans.clan_id
WHERE unit_id = ?
",

'get_clan' => "
SELECT clan_name
FROM `clan_data`
WHERE clan_id = ?
",

'get_clan_characters' => "
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 = ?
ORDER BY character_subclasses.level DESC
",
);

и сама неувязочка

Цитата:

/* 'get_characters_where_account_name' => "
SELECT `account_name`,`charId` AS `char_id`,`char_name`,`level`,`maxHp`,`curHp`,`max Cp`,`maxMp`,`sex`,`x`,`y`,
`z`,`exp`,`sp`,`karma`,`pvpkills`,`pkkills`,`clani d`,`race`,`classid`,`base_class`,`title`,`online`,
`onlinetime`,`lastAccess`,`nobless`
FROM `characters`
WHERE `account_name` = ?
",*/

их изменение нечего не решает,
как я понял где-то в движке есть файл который отвечает за исполние функций запросов в бд.
тут лишь шапочка...

offtop: