Добавлена к запросу .php

[Main]

Добрый день всем.

И так, в .php и самих сайтах я ни в зуб ногой.

Нужна помощь в добавлении модуля оффлайн торга. (Вывод количества оффлайн торговцев в отдельный параметр или к общему online количеству).

Сам .php файлы -> http://rghost.ru/52329373

Посмотреть без скачивания:

Свернуть ↑

<?php

class Lineage_rebellion_hf extends CI_Driver
{
public $version = 'h';
private $char_id = 'obj_Id'; // characters



public function insert_account($login, $password)
{
$data = array(
'login' => $login,
'password' => $password,
);

return $this->db->insert('accounts', $data);
}

public function get_account_by_login($login)
{
return $this->get_accounts(1, NULL, array('login' => $login));
}

public function get_accounts_by_login($login, $limit = NULL, $offset = NULL)
{
$where = NULL;
$where_in_field = 'login';
$where_in = NULL;

if(is_array($login))
{
$where_in = $login;
}
else
{
$where = array('login' => $login);
}

return $this->get_accounts($limit, $offset, $where, NULL, NULL, NULL, NULL, $where_in_field, $where_in);
}

public function get_accounts($limit = NULL, $offset = NULL, array $where = NULL, $order_by = NULL, $order_type = 'asc', array $like = NULL, array $group_by = NULL, $where_in_field = NULL, array $where_in = NULL)
{
if(is_numeric($limit))
{
$this->db->limit($limit);
}

if(is_numeric($offset))
{
$this->db->offset($offset);
}

if($where != NULL)
{
$this->db->where($where);
}

if($order_by != NULL)
{
$this->db->order_by($order_by, $order_type);
}

if($like != NULL)
{
$this->db->like($like);
}

if($group_by != NULL)
{
$this->db->group_by($group_by);
}

if($where_in_field != NULL && $where_in != NULL)
{
$this->db->where_in($where_in_field, $where_in);
}

$this->db->select('login,password,last_access AS last_active');

if($limit == 1)
{
return $this->db->get('accounts')->row_array();
}

return $this->db->get('accounts')->result_array();
}

public function get_characters($limit = NULL, $offset = NULL, array $where = NULL, $order_by = NULL, $order_type = 'asc', array $like = NULL, array $group_by = NULL, $where_in_field = NULL, array $where_in = NULL)
{
if(is_numeric($limit))
{
$this->db->limit($limit);
}

if(is_numeric($offset))
{
$this->db->offset($offset);
}

if($where != NULL)
{
$this->db->where($where);
}

if($order_by != NULL)
{
$this->db->order_by($order_by, $order_type);
}

if($like != NULL)
{
$this->db->like($like);
}

if($group_by != NULL)
{
$this->db->group_by($group_by);
}

if($where_in_field != NULL && $where_in != NULL)
{
$this->db->where_in($where_in_field, $where_in);
}

$this->db->select('characters.account_name,characters.obj_ Id AS char_id,characters.char_name,character_subclasses. `level`,character_subclasses.curHp,character_subcl asses.curMp,character_subclasses.curCp,character_s ubclasses.maxHp,character_subclasses.maxMp,
character_subclasses.maxCp,characters.sex,characte rs.x,characters.y,characters.z,character_subclasse s.exp,character_subclasses.sp,characters.karma,cha racters.pvpkills,characters.pkkills,characters.cla nid AS clan_id,character_subclasses.class_id AS base_class,
characters.title,characters.`online`,characters.on linetime,clan_subpledges.`name` AS clan_name,clan_data.clan_level,clan_data.hasCastle ,clan_data.hasFortress AS hasFort,clan_data.ally_id,ally_data.ally_name,clan _subpledges.leader_id,
clan_data.crest AS crest_id,clan_data.largecrest AS crest_large_id,ally_data.crest AS ally_crest_id,clan_data.reputation_score');

$this->db->join('character_subclasses', 'characters.' . $this->char_id . ' = character_subclasses.char_obj_id AND character_subclasses.isBase = 1', 'left');
$this->db->join('clan_data', 'characters.clanid = clan_data.clan_id', 'left');
$this->db->join('clan_subpledges', 'clan_data.clan_id = clan_subpledges.clan_id AND clan_subpledges.type = 0', 'left');
$this->db->join('ally_data', 'clan_data.ally_id = ally_data.ally_id', 'left');

$result = array();

if($limit == 1)
{
$row = $this->db->get('characters')->row_array();

if($row)
{
// Вставляю race
$row['race'] = get_race_by_class_id($row['base_class']);
}

$result = $row;
}
else
{
$res = $this->db->get('characters')->result_array();

// Вставляю race
foreach($res as $key => $row)
{
$race = get_race_by_class_id($row['base_class']);
$row['race'] = $race;
$result[$key] = $row;
}
}

return $result;
}

public function get_characters_by_login($login, $limit = NULL, $offset = NULL)
{
$where = NULL;
$where_in_field = 'account_name';
$where_in = NULL;

if(is_array($login))
{
$where_in = $login;
}
else
{
$where = array('account_name' => $login);
}

return $this->get_characters($limit, $offset, $where, NULL, NULL, NULL, NULL, $where_in_field, $where_in);
}

public function change_password_on_account($password, $login)
{
return $this->db->update('accounts', array('password' => $password), array('login' => $login), 1);
}

public function get_character_by_char_id($char_id)
{
return $this->get_characters(1, NULL, array($this->char_id => $char_id));
}

public function change_coordinates($data, $char_id)
{
return $this->db->update('characters', $data, array($this->char_id => $char_id), 1);
}

public function insert_item($item_id, $count, $char_id, $enchant = 0, $loc = 'INVENTORY')
{
$this->db->select_max('object_id', 'max_id');
$max_id = $this->db->get('items', 1)->row_array();

$data_db = array(
'owner_id' => $char_id,
'object_id' => $max_id['max_id'] + 1,
'item_id' => $item_id,
'count' => $count,
'enchant_level' => (int) $enchant,
'loc' => $loc,
'loc_data' => '0',
);

return $this->db->insert('items', $data_db);
}

public function edit_item($object_id, $count, $char_id, $enchant = 0, $loc = 'INVENTORY')
{
$data_db_where = array(
'owner_id' => $char_id,
'object_id' => $object_id,
);

$data_db = array(
'count' => $count,
'enchant_level' => (int) $enchant,
'loc' => $loc,
'loc_data' => '0',
);

//return $this->db->update('items', $data_db, $data_db_where, 1);
return $this->db->update('items', $data_db, $data_db_where, 1);
}

public function del_item($item_id, $limit)
{
if(is_array($item_id))
{
$this->db->where($item_id);
}
else
{
$this->db->where('object_id', $item_id);
}

$this->db->limit($limit);
return $this->db->delete('items');
}

public function del_items_by_owner_id($owner_id)
{
return $this->db->delete('items', array('owner_id' => $owner_id));
}

public function get_character_item_by_item_id($char_id, $item_id)
{
$data_db_where = array(
'owner_id' => $char_id,
'item_id' => $item_id
);

return $this->get_character_items(1, 0, $data_db_where);
}

public function get_online_status($char_id)
{
$res = $this->get_characters(1, NULL, array($this->char_id => $char_id));

return $res['online'];
}

public function get_count_online()
{
return $this->get_count_row(array('online' => '1'), NULL, 'characters');
}

public function get_count_accounts(array $where = NULL, array $like = NULL)
{
return $this->get_count_row($where, $like, 'accounts');
}

public function get_count_characters(array $where = NULL, array $like = NULL)
{
return $this->get_count_row($where, $like, 'characters');
}

public function get_count_clans(array $where = NULL, array $like = NULL)
{
return $this->get_count_row($where, $like, 'clan_data');
}

public function get_count_male()
{
return $this->get_count_row(array('sex' => '0'), NULL, 'characters');
}

public function get_count_female()
{
return $this->get_count_row(array('sex' => '1'), NULL, 'characters');
}

public function get_count_race_by_id($race_id)
{
$characters = $this->get_characters();

$count = 0;

foreach($characters as $character)
{
$race = get_race_by_class_id($character['base_class']);

if($race == $race_id)
{
$count++;
}
}

return $count;
}

public function get_count_races_group_race()
{
$characters = $this->get_characters();

$result = array();

foreach($characters as $character)
{
$race = get_race_by_class_id($character['base_class']);

if(isset($result[$race]['count']))
{
$result[$race]['count']++;
$result[$race]['online'] += ($character['online'] == 1 ? 1 : 0);
}
else
{
$result[$race] = array(
'count' => 1,
'online' => ($character['online'] == 1 ? 1 : 0),
'race' => $race,
);
}
}

return $result;
}

public function get_top_pvp($limit = NULL)
{
return $this->get_characters($limit, NULL, array('pvpkills >' => '0'), 'pvpkills', 'desc');
}

public function get_top_pk($limit = NULL)
{
return $this->get_characters($limit, NULL, array('pkkills >' => '0'), 'pkkills', 'desc');
}

public function get_top_clans($limit = NULL)
{
$res = $this->db->select('clan_data.clan_id,clan_subpledges.`name ` AS clan_name,clan_data.clan_level,clan_data.hasCastle ,clan_data.hasFortress AS hasFort,clan_data.ally_id,ally_data.ally_name,clan _subpledges.leader_id,
clan_data.crest AS crest_id,clan_data.largecrest AS crest_large_id,ally_data.crest AS ally_crest_id,clan_data.reputation_score,character s.account_name,characters.char_name,
character_subclasses.`level`,character_subclasses. maxHp,character_subclasses.curHp,character_subclas ses.maxMp,character_subclasses.curMp,character_sub classes.maxCp,character_subclasses.curCp,
characters.sex,characters.x,characters.y,character s.z,character_subclasses.exp,character_subclasses. sp,characters.karma,characters.pvpkills,characters .pkkills,character_subclasses.class_id as base_class,
characters.title,characters.`online`,characters.on linetime,(SELECT COUNT(0) FROM `characters` WHERE clanid = `clan_data`.`clan_id`) AS ccount')

->join('clan_subpledges', 'clan_data.clan_id = clan_subpledges.clan_id AND clan_subpledges.type = 0', 'left')
->join('ally_data', 'clan_data.ally_id = ally_data.ally_id', 'left')
->join('characters', 'clan_subpledges.leader_id = characters.' . $this->char_id, 'left')
->join('character_subclasses', 'characters.obj_Id = character_subclasses.char_obj_id AND character_subclasses.isBase = 1', 'left')

->group_by('characters.' . $this->char_id)
->order_by('clan_data.clan_level', 'DESC')
->order_by('clan_data.reputation_score', 'DESC')
->limit($limit)
->get('clan_data')
->result_array();

foreach($res as $key => $row)
{
$res[$key]['race'] = get_race_by_class_id($row['base_class']);
}

return $res;
}

public function get_top_online($limit = 10)
{
return $this->get_characters($limit, NULL, array('online' => '1'), 'level', 'desc');
}

public function get_top($limit = 10)
{
return $this->get_characters($limit, NULL, NULL, 'exp', 'desc');
}

public function get_top_rich($limit = 10)
{
$this->db->select('characters.account_name,characters.obj_ Id AS char_id,characters.char_name,character_subclasses. `level`,character_subclasses.curHp,character_subcl asses.curMp,character_subclasses.curCp,character_s ubclasses.maxHp,character_subclasses.maxMp,
character_subclasses.maxCp,characters.sex,characte rs.x,characters.y,characters.z,character_subclasse s.exp,character_subclasses.sp,characters.karma,cha racters.pvpkills,characters.pkkills,characters.cla nid AS clan_id,
character_subclasses.class_id AS base_class,characters.title,characters.`online`,ch aracters.onlinetime,clan_subpledges.`name` AS clan_name,clan_data.clan_level,clan_data.hasCastle ,clan_data.hasFortress AS hasFort,clan_data.ally_id,
ally_data.ally_name,clan_subpledges.leader_id,clan _data.crest AS crest_id,clan_data.largecrest AS crest_large_id,ally_data.crest AS ally_crest_id,clan_data.reputation_score,SUM(items .count) AS adena');

$this->db->order_by('adena', 'desc');
$this->db->group_by('characters.' . $this->char_id);
$this->db->where('items.item_id', '57');

$this->db->join('character_subclasses', 'characters.obj_Id = character_subclasses.char_obj_id AND character_subclasses.isBase = 1', 'left');
$this->db->join('clan_data', 'characters.clanid = clan_data.clan_id', 'left');
$this->db->join('clan_subpledges', 'clan_data.clan_id = clan_subpledges.clan_id AND clan_subpledges.type = 0', 'left');
$this->db->join('ally_data', 'clan_data.ally_id = ally_data.ally_id', 'left');
$this->db->join('items', 'characters.obj_Id = items.owner_id', 'left');

$res = $this->db->get('characters', $limit)
->result_array();

$result = array();

foreach($res as $row)
{
$row['race'] = get_race_by_class_id($row['base_class']);
$result[] = $row;
}

return $result;
}

public function get_castles()
{
$this->db->select('castle.id,castle.`name`,castle.tax_percen t AS taxPercent,castle.siege_date AS siegeDate,ally_data.crest AS ally_crest_id,clan_data.crest AS crest_id,clan_data.largecrest AS crest_large_id,clan_data.clan_level,clan_data.hasC astle,
clan_data.hasFortress AS hasFort,clan_data.ally_id,clan_data.reputation_sco re,ally_data.ally_name,clan_data.clan_id,clan_subp ledges.`name` AS clan_name,clan_subpledges.leader_id');

$this->db->join('clan_data', 'castle.id = clan_data.hasCastle', 'left');
$this->db->join('ally_data', 'clan_data.ally_id = ally_data.ally_id', 'left');
$this->db->join('clan_subpledges', 'clan_data.clan_id = clan_subpledges.clan_id', 'left');

$this->db->order_by('castle.id');

return $this->db->get('castle')
->result_array();
}

public function get_siege()
{
$this->db->select('siege_clans.residence_id AS castle_id,siege_clans.clan_id,siege_clans.type,IF( siege_clans.type = "attackers",1,2) AS type,clan_subpledges.`name` AS clan_name,clan_data.clan_level,clan_subpledges.lea der_id,
clan_data.hasCastle,clan_data.hasFortress AS hasFort,clan_data.ally_id,clan_data.crest AS crest_id,clan_data.largecrest AS crest_large_id,ally_data.ally_name,ally_data.crest AS ally_crest_id,clan_data.reputation_score', false);

$this->db->join('clan_data', 'siege_clans.clan_id = clan_data.clan_id', 'left');
$this->db->join('clan_subpledges', 'clan_data.clan_id = clan_subpledges.clan_id', 'left');
$this->db->join('ally_data', 'clan_data.ally_id = ally_data.ally_id', 'left');

$this->db->where_in('residence_id', range(1, 9));

return $this->db->get('siege_clans')
->result_array();
}

public function get_clan_by_id($clan_id)
{
$this->db->select('clan_data.clan_id,clan_data.clan_level,cl an_data.hasCastle,clan_data.hasFortress AS hasFort,clan_subpledges.`name` AS clan_name,clan_subpledges.leader_id,clan_data.cres t AS crest_id,clan_data.largecrest AS crest_large_id,clan_data.reputation_score');

$this->db->join('clan_subpledges', 'clan_data.clan_id = clan_subpledges.clan_id', 'left');

$this->db->where('clan_data.clan_id', $clan_id);

return $this->db->get('clan_data')
->row_array();
}

public function get_characters_by_clan_id($clan_id, $limit = 10)
{
return $this->get_characters($limit, NULL, array('clanid' => $clan_id), 'level', 'desc');
}

public function get_count_character_items($char_id)
{
return $this->get_count_row(array('owner_id' => $char_id), NULL, 'items');
}

public function get_character_items_by_char_id($char_id)
{
return $this->get_character_items(NULL, NULL, array('owner_id' => $char_id), 'count', 'desc');
}

public function get_character_items($limit = NULL, $offset = NULL, array $where = NULL, $order_by = NULL, $order_type = 'asc', array $like = NULL, array $group_by = NULL, $where_in_field = NULL, array $where_in = NULL)
{
if(is_numeric($limit))
{
$this->db->limit($limit);
}

if(is_numeric($offset))
{
$this->db->offset($offset);
}

if($where != NULL)
{
$this->db->where($where);
}

if($order_by != NULL)
{
$this->db->order_by($order_by, $order_type);
}

if($like != NULL)
{
$this->db->like($like);
}

if($group_by != NULL)
{
$this->db->group_by($group_by);
}

if($where_in_field != NULL && $where_in != NULL)
{
$this->db->where_in($where_in_field, $where_in);
}

$this->db->select('owner_id,object_id,item_id,count,enchant_ level,loc,loc_data');

if($limit == 1)
{
return $this->db->get('items')->row_array();
}

return $this->db->get('items')->result_array();
}

private function get_count_row(array $where = NULL, array $like = NULL, $table)
{
if($where != NULL)
{
$this->db->where($where);
}

if($like != NULL)
{
$this->db->like($like);
}

$this->db->from($table);
return $this->db->count_all_results();
}

public function change_char_name($char_id, $char_name)
{
return $this->db->update('characters', array('char_name' => $char_name), array($this->char_id => $char_id), 1);
}

public function change_sex($char_id, $sex)
{
return $this->db->update('characters', array('sex' => $sex), array($this->char_id => $char_id), 1);
}

public function get_character_by_char_name($char_name)
{
$data_db_where = array(
'char_name' => $char_name,
);

return $this->get_characters(1, NULL, $data_db_where);
}

public function change_account_password($login, $new_password)
{
$data_db = array(
'login' => $login,
);

$data_db_where = array(
'password' => $new_password,
);

return $this->db->update('accounts', $data_db_where, $data_db, 1);
}
}

Свернуть ↑Развернуть ↓

Таблица character_variables, колонка name поле offline.


За помощь могу сказать спасибо, ну или оплатить

Добавлено через 1 час 23 минуты
Всё, разобрался.
Если кому понадобится:

 public function get_count_online()
{
$online = $this->get_count_row(array('online' => '1'), NULL, 'characters');
$offline = $this->get_count_row(array('name' => 'offline'), NULL, 'character_variables');
$online = $online+$offline;
return $online;
}

Можно закрывать.

[Gaikotsu]

зачем эти извращения, если большинство сборок поддерживают выдачу онлайна (общего и оффтрейдеров) в виде пакета, отдаваемого геймсервом в ответ на получение спецаилаьного пакета?