[help] Modul Dle

Warning: require_once(/home/zinteco/data/www/liniage.la2wings.net/engine/lineage/admin/include/dbase/L2Emu.php): failed to open stream: No such file or directory in /home/zinteco/data/www/liniage.la2wings.net/engine/lineage/admin/include/jdb.php on line 35 Fatal error: require_once(): Failed opening required '/home/zinteco/data/www/liniage.la2wings.net/engine/lineage/admin/include/dbase/L2Emu.php' (include_path='.:/usr/local/share/pear') in /home/zinteco/data/www/liniage.la2wings.net/engine/lineage/admin/include/jdb.php on line 35

ALTER TABLE `donate` ADD `account` VARCHAR ( 45 ) NOT NULL AFTER `id`;
ALTER TABLE `donate` ADD `obj_Id` INT( 10 ) NOT NULL AFTER `account`;
ALTER TABLE `donate` ADD `server` INT( 10 ) NOT NULL AFTER `character`;
ALTER TABLE `donate` ADD INDEX ( `obj_Id` );

ALTER TABLE `accounts`
    ADD `email` VARCHAR( 100 ) NOT NULL ,
    ADD `answer` TEXT NOT NULL ,
    ADD `question` TEXT NOT NULL,
    ADD `hash` VARCHAR( 100 ) NULL;

ALTER TABLE `accounts` ADD INDEX ( `email` );

ALTER TABLE `accounts` ADD `email` VARCHAR( 50 ) NULL;

ALTER TABLE `characters` ADD `lastteleport` DECIMAL( 20, 0 ) NULL DEFAULT NULL;

CREATE TABLE IF NOT EXISTS `donate` (
  `id` int(11) NOT NULL auto_increment,
  `random` varchar(8) NOT NULL,
  `account` varchar(45) NOT NULL,
  `charId` int(10) NOT NULL,
  `character` varchar(35) NOT NULL,
  `server` tinyint(10) NOT NULL,
  `time` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `key` varchar(32) NOT NULL,
  `type` enum('sms','wm') NOT NULL default 'wm',
  `currency` enum('wmz','wmr','wme') NOT NULL default 'wmz',
  `items` varchar(256) NOT NULL,
  `price` decimal(9,2) NOT NULL default '0.00',
  `payer_wm` varchar(12) NOT NULL,
  `payer_purse` varchar(13) NOT NULL,
  `invs_no` varchar(11) NOT NULL,
  `trans_no` varchar(11) NOT NULL,
  `trans_date` varchar(17) NOT NULL,
  `state` enum('0','I','E','P','S') NOT NULL default '0',
  `success` enum('0','1') NOT NULL default '0',
  `comment` varchar(100) NOT NULL,
  PRIMARY KEY  (`id`),
  KEY `character` (`character`),
  KEY `charId` (`charId`),
  KEY `type` (`type`)
) ENGINE=MyISAM;

<?php

/********************************************************************/
/*                                                                  */
/* Lineage2 DLE Module, Copyright © 2007-2008, hellEVIL TEAM        */
/* http://www.hellevil.net                                          */
/*                                                                  */
/***************************F*****************************************/

if(!defined('DATALIFEENGINE')) {
    die("Hacking attempt!");
}

/********************************************************************/
/*                                                                  */
/*l2jfree                                                         */
/*                                                                  */
/********************************************************************/

// Список полей
$fList_RT = array(
    "accounts" => "accounts.login, accounts.password, accounts.lastactive AS lastActive, accounts.access_level AS accessLevel, accounts.lastIP, accounts.email, accounts.answer, accounts.question, accounts.hash",

    "char_templates" => "char_templates.ClassName AS classname, char_templates.STR AS str, char_templates.CON AS con, char_templates.DEX AS dex, char_templates._INT AS _int, char_templates.MEN AS men, char_templates.WIT AS wit",

    "characters" => "characters.obj_Id AS charId, characters.clanid, characters.account_name, characters.lastAccess, characters.char_name, characters.online, characters.level, characters.sex, characters.pvpkills, characters.pkkills, characters.onlinetime, characters.base_class, characters.exp, characters.sp, characters.karma, characters.maxHp, characters.maxMp, characters.x, characters.y, characters.z, characters.in_jail, characters.jail_timer, characters.nobless, characters.title ",

    "character_friends" => "character_friends.friend_id, character_friends.friend_name",        

    "character_subclasses" => "character_subclasses.*",

    "castle" => "castle.name AS castleName, castle.id AS castleID, castle.taxPercent, castle.siegeDate",

    "clanhall" => "clanhall.name AS clanhallName, clanhall.location AS clanhallLocation",

    "clan_data" => "clan_data.clan_name, clan_data.clan_id, clan_data.ally_id, clan_data.ally_name, clan_data.clan_level, clan_data.reputation_score, clan_data.hasCastle, clan_data.leader_id",

    "items" => "items.item_id, items.object_id, items.loc_data, items.count, items.loc, items.enchant_level",

    "items_info" => "
                CASE
                    WHEN armor.name != '' THEN armor.name
                    WHEN weapon.name != '' THEN weapon.name
                    WHEN etcitem.name != '' THEN etcitem.name
                END AS name,
                CASE
                    WHEN armor.crystal_type != '' THEN armor.crystal_type
                    WHEN weapon.crystal_type != '' THEN weapon.crystal_type
                END AS crystal_type,
                CASE
                    WHEN armor.crystal_type != '' THEN 'armor'
                    WHEN weapon.crystal_type != '' THEN 'weapon'                    
                END AS `type`",
);

// Запросы для таблиц
$qList_RT = array(
    // Таблица account
    "accounts" => array (
        "GetAccount" => "
            SELECT ".$fList_RT["accounts"]."
            FROM `accounts`
            WHERE login='{param0}'
            LIMIT 1",
            
        "GetCount" => "
            SELECT count(*)
            FROM `accounts`",

        "GetCountPlayers" => "
            SELECT count(*)
            FROM accounts
            WHERE access_level=0",
                    
        "GetList" => "
            SELECT ".$fList_RT["accounts"]."
            FROM `accounts`
            ORDER BY `access_level` DESC {param0}
            LIMIT {param1}",
        
        "SetPassword" => "
            UPDATE `accounts`
            SET `password` = '{param1}'
            WHERE `login`='{param0}'",
            
            "SetAnswerQuestion" => "
            UPDATE `accounts`
            SET
                `question` = '{param1}',
                `answer` = '{param2}'
            WHERE `login`='{param0}'
        ",
          
          "SetEmail" => "
            UPDATE `accounts`
            SET
                `email` = '{param1}',
            WHERE `login`='{param0}'
        ",
        
        "InsertAccount" => "
            INSERT INTO `accounts`
            (`login`, `password`, `access_level`, `email`, `answer`, `question`)
            VALUES ('{param0}', '{param1}', 0, '{param2}','{param3}','{param4}')",

        "DeleteAccount" => "
            DELETE FROM accounts
            WHERE login='{param0}'        
        ",

        "UpdateAccount" => "
            UPDATE `accounts`
            SET `access_level`={param1}, `email`='{param2}', `answer`='{param3}', `question`='{param4}'
            WHERE login='{param0}'            
        ",

        "GetAccountByEmail" => "
            SELECT *
            FROM `accounts`
            WHERE login='{param0}'
            AND email='{param1}'",
            
        "SetHash" => "
            UPDATE `accounts`
            SET `hash` = '{param1}'
            WHERE `login`='{param0}'",
    ),

    // Таблица characters
    "characters" => array (
        "byID" => "
            SELECT ".$fList_RT["characters"].",".$fList_RT["clan_data"].",".$fList_RT["char_templates"]."
            FROM `characters`
            LEFT JOIN `char_templates` ON characters.classid = char_templates.ClassId
            LEFT JOIN `clan_data` ON characters.clanid = clan_data.clan_id
            WHERE characters.obj_Id = '{param0}'
            LIMIT 1",
        
        "byLogin" => "
            SELECT ".$fList_RT["characters"].",".$fList_RT["clan_data"].",".$fList_RT["char_templates"]."
            FROM `characters`
            LEFT JOIN `char_templates` ON characters.classid = char_templates.ClassId
            LEFT JOIN `clan_data` ON characters.clanid = clan_data.clan_id
            WHERE characters.account_name = '{param0}'",
//+            
        "GetCountPlayers" => "
            SELECT count(*)
            FROM characters
            LEFT JOIN `accounts` ON characters.account_name = accounts.login
            WHERE accounts.access_level = 0",
//+        
        "GetCountOnline" => "
            SELECT count(*)
            FROM `characters`
            LEFT JOIN `accounts` ON characters.account_name = accounts.login
            WHERE accounts.access_level = 0 AND characters.online = 1",
//+
        "GetCount" => "
            SELECT count(*)
            FROM characters
            LEFT JOIN accounts ON characters.account_name = accounts.login
            [0:IFSETNN=]
                WHERE
                [1:IFSETNN=0]
                    characters.account_name like '%{param0}%'
                    [2:IFSETNN=1,2,3,4,5] AND [2:/IFSET]
                [1:/IFSET]
                [1:IFSETNN=1]
                    characters.char_name like '%{param1}%'
                    [2:IFSETNN=2,3,4,5] AND [2:/IFSET]
                [1:/IFSET]
                [1:IFSETNN=2]
                    characters.classid = '{param2}'
                    [2:IFSETNN=3,4,5] AND [2:/IFSET]
                [1:/IFSET]
                [1:IFSETNN=3,4,5] ( [1:/IFSET]
                [1:IFSETNN=3]
                    accounts.access_level > '0'
                    [2:IFSETNN=4,5] OR [2:/IFSET]
                [1:/IFSET]
                [1:IFSETNN=4]
                    accounts.access_level = '0'
                    [2:IFSETNN=5] OR [2:/IFSET]
                [1:/IFSET]
                [1:IFSETNN=5]
                    accounts.access_level < '0'                
                [1:/IFSET]
                [1:IFSETNN=3,4,5] ) [1:/IFSET]                        
            [0:/IFSET]
        ",
//+        
        "GetList" => "
            SELECT ".$fList_RT["characters"].",".$fList_RT["clan_data"].",".$fList_RT["char_templates"].",accounts.access_level AS accessLevel
            FROM `characters`
            LEFT JOIN `char_templates` ON characters.classid = char_templates.ClassId
            LEFT JOIN `clan_data` ON characters.clanid = clan_data.clan_id
            LEFT JOIN accounts ON characters.account_name = accounts.login
            [0:IFSETNN=3,4,5,6,7,8]
                WHERE
                [1:IFSETNN=3]
                    characters.account_name like '%{param3}%'
                    [2:IFSETNN=4,5,6,7,8] AND [2:/IFSET]
                [1:/IFSET]
                [1:IFSETNN=4]
                    characters.char_name like '%{param4}%'
                    [2:IFSETNN=5,6,7,8] AND [2:/IFSET]
                [1:/IFSET]
                [1:IFSETNN=5]
                    characters.classid = '{param5}'
                    [2:IFSETNN=6,7,8] AND [2:/IFSET]
                [1:/IFSET]
                [1:IFSETNN=6,7,8] ( [1:/IFSET]
                [1:IFSETNN=6]
                    accounts.access_level > '0'
                    [2:IFSETNN=7,8] OR [2:/IFSET]
                [1:/IFSET]
                [1:IFSETNN=7]
                    accounts.access_level = '0'
                    [2:IFSETNN=8] OR [2:/IFSET]
                [1:/IFSET]
                [1:IFSETNN=8]
                    accounts.access_level < '0'                
                [1:/IFSET]
                [1:IFSETNN=6,7,8] ) [1:/IFSET]                    
            [0:/IFSET]
            ORDER BY characters.online DESC, accounts.access_level DESC [0:IFSET=0], {param0}[0:/IFSET]
            [0:IFSET=0]LIMIT {param1}
                [0:IFSETNN=2] ,{param2} [0:/IFSET]
            [0:/IFSET]",
//+    
        "GetOnline" => "
            SELECT ".$fList_RT["characters"].",".$fList_RT["clan_data"].",".$fList_RT["char_templates"]."
            FROM `characters`
            LEFT JOIN char_templates ON char_templates.ClassId = characters.classid
            LEFT JOIN clan_data ON clan_data.clan_id = characters.clanid
            LEFT JOIN accounts ON characters.account_name = accounts.login
            WHERE accounts.access_level=0 AND characters.online=1
            ORDER BY characters.online DESC, accounts.access_level DESC, characters.exp DESC
            LIMIT {param0}",
//+
        "GetClanMembersList" => "
            SELECT ".$fList_RT["characters"].", ".$fList_RT["clan_data"].",".$fList_RT["char_templates"]."
            FROM `characters`
            LEFT JOIN char_templates ON char_templates.ClassId = characters.classid
            LEFT JOIN clan_data ON clan_data.clan_id = characters.clanid
            WHERE clan_data.clan_name = '{param0}'
            ORDER BY exp DESC",

        "GetClanMembersListByID" => "
            SELECT ".$fList_RT["characters"].", ".$fList_RT["clan_data"].",".$fList_RT["char_templates"]."
            FROM `characters`
            LEFT JOIN char_templates ON char_templates.ClassId = characters.classid
            LEFT JOIN clan_data ON clan_data.clan_id = characters.clanid
            WHERE clan_data.clan_id = '{param0}'
            ORDER BY exp DESC",
//+
        "GetCountRaceHumans" => "
            SELECT count(*)
            FROM characters
            LEFT JOIN accounts ON characters.account_name = accounts.login            
            WHERE characters.race=0 AND accounts.access_level=0",
//+
        "GetCountRaceElfs" => "
            SELECT count(*)
            FROM characters
            LEFT JOIN accounts ON characters.account_name = accounts.login
            WHERE characters.race=1 AND accounts.access_level=0",
//+        
        "GetCountRaceDElfs" => "
            SELECT count(*)
            FROM characters
            LEFT JOIN accounts ON characters.account_name = accounts.login
            WHERE characters.race=2 AND accounts.access_level=0",
//+
        "GetCountRaceOrcs" => "
            SELECT count(*)
            FROM characters
            LEFT JOIN accounts ON characters.account_name = accounts.login
            WHERE characters.race=3 AND accounts.access_level=0",
//+    
        "GetCountRaceDwarfs" => "
            SELECT count(*)
            FROM characters
            LEFT JOIN accounts ON characters.account_name = accounts.login
            WHERE characters.race=4 AND accounts.access_level=0",
//+
        "GetCountRaceKamaels" => "
            SELECT count(*)
            FROM characters
            LEFT JOIN accounts ON characters.account_name = accounts.login
            WHERE characters.race=5 AND accounts.access_level=0",
//+    
        "GetTop" => "
            SELECT ".$fList_RT["characters"].",".$fList_RT["clan_data"].",".$fList_RT["char_templates"]."
            FROM `characters`
            LEFT JOIN char_templates ON char_templates.ClassId = characters.classid
            LEFT JOIN clan_data ON clan_data.clan_id = characters.clanid
            LEFT JOIN accounts ON characters.account_name = accounts.login
            WHERE accounts.access_level=0
            ORDER BY characters.exp DESC
            LIMIT {param0}",
//+
        "GetTopPVP" => "
            SELECT ".$fList_RT["characters"].",".$fList_RT["clan_data"].",".$fList_RT["char_templates"]."
            FROM `characters`
            LEFT JOIN char_templates ON char_templates.ClassId = characters.classid
            LEFT JOIN clan_data ON clan_data.clan_id = characters.clanid
            LEFT JOIN accounts ON characters.account_name = accounts.login
            WHERE accounts.access_level=0 AND characters.pvpkills>0
            ORDER BY characters.pvpkills DESC, characters.exp DESC
            LIMIT {param0}",
//+
        "GetTopPK" => "
            SELECT ".$fList_RT["characters"].",".$fList_RT["clan_data"].",".$fList_RT["char_templates"]."
            FROM `characters`
            LEFT JOIN char_templates ON char_templates.ClassId = characters.classid
            LEFT JOIN clan_data ON clan_data.clan_id = characters.clanid
            LEFT JOIN accounts ON characters.account_name = accounts.login
            WHERE accounts.access_level=0 AND characters.pkkills>0
            ORDER BY characters.pkkills DESC, characters.exp DESC
            LIMIT {param0}",
//+            
        "GetTopOnline" => "
            SELECT ".$fList_RT["characters"].",".$fList_RT["clan_data"].",".$fList_RT["char_templates"]."
            FROM `characters`
            LEFT JOIN char_templates ON char_templates.ClassId = characters.classid
            LEFT JOIN clan_data ON clan_data.clan_id = characters.clanid
            LEFT JOIN accounts ON characters.account_name = accounts.login
            WHERE accounts.access_level=0
            ORDER BY characters.onlinetime DESC, characters.exp DESC
            LIMIT {param0}",

        "DeleteCharacter" => "
            DELETE FROM characters
            WHERE obj_Id='{param0}'",
    
        "SetLocation" => "
            UPDATE `characters`
            SET
                x='{param0}',
                y='{param1}',
                z='{param2}'
                {param3}
            WHERE obj_Id='{param4}'",
//    
        "UpdateCharacter" => "
            UPDATE `characters`
            SET
                `char_name` = '{param1}',
                `race` = '{param2}',
                `sex` = '{param3}',
                `base_class` = '{param4}',
                `title` = '{param5}',
                `level` = '{param7}',
                `exp` = '{param8}',
                `sp` = '{param9}',
                `pvpkills` = {param10},
                `pkkills` = {param11},
                `karma` = {param12},
                `nobless` = {param13},
                `in_jail` = {param14},
                `jail_timer` = {param15},
            WHERE obj_Id = {param0}
        ",
    ),
    
    // character_subclasses
    "character_subclasses" => array (
        "GetSubclass" => "
            SELECT ".$fList_RT["character_subclasses"].", ".$fList_RT["char_templates"]."
            FROM `character_subclasses`
            LEFT JOIN `char_templates` ON character_subclasses.class_id = char_templates.ClassId
            WHERE char_obj_Id = '{param0}'
            ORDER BY level DESC",

        "DeleteSubclasses" => "
            DELETE FROM character_subclasses WHERE char_obj_Id='{param0}'",    
    ),        
    
    // character_friends
    "character_friends" => array (
        "GetFriends" => "
            SELECT ".$fList_RT["character_friends"]."
            FROM `character_friends`
            WHERE char_id = '{param0}'
            ORDER BY friend_name ASC",
    
        "DeleteFriends" => "
            DELETE FROM character_friends
            WHERE char_id='{param0}' OR friend_id='{param0}'",    
    ),
    
    // character_hennas
    "character_hennas" => array (
        "DeleteHennas" => "
            DELETE FROM character_hennas
            WHERE char_obj_Id='{param0}'",
    ),
    
    // character_macroses
    "character_macroses" => array (
        "DeleteMacroses" => "
            DELETE FROM character_macroses
            WHERE char_obj_Id='{param0}'",
    ),
    
    // character_quests
    "character_quests" => array (
        "DeleteQuests" => "
            DELETE FROM character_quests
            WHERE char_id='{param0}'",
    ),
    
    // ***character_raidpoints
    "character_raidpoints" => array (
        "DeleteRaidPoints" => "
            DELETE FROM character_raidpoints
            WHERE owner_id='{param0}'",
    ),
    
    // character_recipebook
    "character_recipebook" => array (
        "DeleteRecipebook" => "
            DELETE FROM character_recipebook
            WHERE char_id='{param0}'",
    ),
    
    // character_recommends
    "character_recommends" => array (
        "DeleteRecommends" => "
            DELETE FROM character_recommends
            WHERE char_id='{param0}'",
    ),
    
    // character_shortcuts
    "character_shortcuts" => array (
        "DeleteShortcuts" => "
            DELETE FROM character_shortcuts
            WHERE char_obj_Id='{param0}'",
    ),
    
    // character_skills
    "character_skills" => array (
        "DeleteSkills" => "
            DELETE FROM character_skills
            WHERE char_obj_Id='{param0}'"
    ),
    
    // character_skills_save
    "character_skills_save" => array (
        "Delete" => "
            DELETE FROM character_skills_save
            WHERE char_obj_Id='{param0}'",
    ),
    
    // clan_data
    "clan_data" => array (
        "GetAlly" => "
            SELECT ".$fList_RT["clan_data"].",".$fList_RT["characters"].",".$fList_RT["castle"].",".$fList_RT["clanhall"]."
            FROM `clan_data`
            LEFT JOIN `characters` ON characters.obj_Id = clan_data.leader_id
            LEFT JOIN `castle` ON castle.id = clan_data.hasCastle
            LEFT JOIN `clanhall` ON clanhall.ownerId = clan_data.clan_id
            WHERE ally_id = '{param0}'
            ORDER BY {param1}
            LIMIT {param2}",

        "GetAllyList" => "
            SELECT ".$fList_RT["clan_data"].",".$fList_RT["characters"].",".$fList_RT["castle"].",".$fList_RT["clanhall"]."
            FROM `clan_data`
            LEFT JOIN `characters` ON characters.obj_Id = clan_data.leader_id
            LEFT JOIN `castle` ON castle.id = clan_data.hasCastle
            LEFT JOIN `clanhall` ON clanhall.ownerId = clan_data.clan_id
            WHERE ally_id
            ORDER BY {param0}
            LIMIT {param1}",
        
        "GetAllyCount" => "
            SELECT count(*)
            FROM `clan_data`
            WHERE ally_id = '{param0}'",

        "GetAllyListCount" => "
            SELECT count(*)
            FROM `clan_data`
            WHERE ally_id = '{param0}'",
                
        "GetClan" => "
            SELECT ".$fList_RT["clan_data"].",".$fList_RT["characters"].",".$fList_RT["castle"].",".$fList_RT["clanhall"]."
            FROM `clan_data`
            LEFT JOIN `characters` ON characters.obj_Id = clan_data.leader_id
            LEFT JOIN `clanhall` ON clanhall.ownerId = clan_data.clan_id            
            LEFT JOIN `castle` ON castle.id = clan_data.hasCastle
            WHERE clan_id = '{param0}'",
                
        "GetClanList" => "
            SELECT ".$fList_RT["clan_data"].",".$fList_RT["characters"].",".$fList_RT["castle"].",".$fList_RT["clanhall"]."
            FROM `clan_data`
            LEFT JOIN `characters` ON characters.obj_Id = clan_data.leader_id
            LEFT JOIN `clanhall` ON clanhall.ownerId = clan_data.clan_id
            LEFT JOIN `castle` ON castle.id = clan_data.hasCastle
            [0:IFSETNN=0]ORDER BY {param0}[0:/IFSET]
            [0:IFSETNN=1]LIMIT {param1}[0:/IFSET]",
//+                
        "GetClanCount" => "
            SELECT count(*)
            FROM `clan_data`",    
//+    
        "GetTopClanList" => "
            SELECT ".$fList_RT["clan_data"].",".$fList_RT["characters"].",csum,ccount,cavg
            FROM clan_data
            LEFT JOIN characters ON clan_data.leader_id=characters.obj_Id
            LEFT JOIN (
                SELECT clanid, SUM(level) AS csum, count(level) AS ccount,
                AVG(level) AS cavg
                FROM characters
                WHERE clanid GROUP BY clanid
            ) AS levels ON clan_data.clan_id = levels.clanid
            ORDER BY csum DESC
            LIMIT {param0}",
    
        "DeleteClanByLeader" => "
            DELETE FROM    clan_data
            WHERE leader_id='{param0}'",
    ),
    
    // clan_wars
    "clan_wars" => array(
        "GetWarList" => "
            SELECT ".$fList_RT["clan_data"]."
            FROM `clan_wars`
            LEFT JOIN `clan_data` ON clan_wars.clan2 = clan_data.clan_id
            WHERE clan_wars.clan1 = '{param0}'",            
    ),
    
    // castle
    "castle" => array(
        "GetCastles" => "
            SELECT ".$fList_RT["castle"].", ".$fList_RT["clan_data"]."
            FROM castle
            LEFT JOIN clan_data ON clan_data.hasCastle = castle.id",
    ),        
    
    // siege_clans
    "siege_clans" => array(
        "GetSiegeInfo" => "                
            SELECT siege_clans.clan_id,type,castle_owner,clan_data.clan_name
            FROM siege_clans
            LEFT JOIN clan_data ON clan_data.clan_id = siege_clans.clan_id
            WHERE castle_id = '{param0}'",
    ),
        
    // seven_signs
    "seven_signs" => array(
        "GetCountDusk" => "
            SELECT count(*)
            FROM seven_signs
            WHERE cabal='dusk'",
                
        "GetCountDawn" => "
            SELECT count(*)
            FROM seven_signs
            WHERE cabal='dawn'",
                
        "GetSevenSignsStatus" => "
            SELECT *
            FROM seven_signs_status
            LIMIT 1",
    
        "DeleteCharacter" => "
            DELETE FROM seven_signs
            WHERE char_obj_Id = '{param0}'",
    ),
    
    
    "raidboss_spawnlist" => array(
        "GetStatus" => "
            SELECT raidboss_spawnlist.boss_id, raidboss_spawnlist.respawn_time, npc.level, npc.name
            FROM raidboss_spawnlist
            LEFT JOIN npc ON raidboss_spawnlist.boss_id = npc.id
            ORDER BY raidboss_spawnlist.respawn_time ASC, npc.level DESC",
    ),
    
    // items
    "items" => array(
        "GetItem" => "
            SELECT ".$fList_RT["items"]."
            FROM `items`
            WHERE object_id = '{param0}'
            LIMIT 1",
        
        "GetList" => "
            SELECT ".$fList_RT["items"].", ".$fList_RT["items_info"]."
            FROM items
            LEFT JOIN armor ON armor.item_id = items.item_id
            LEFT JOIN weapon ON weapon.item_id = items.item_id
            LEFT JOIN etcitem ON etcitem.item_id = items.item_id
            WHERE owner_id = '{param0}'",

        "GetPaperdoll" => "
            SELECT ".$fList_RT["items"]."
            FROM `items`
            WHERE owner_id = '{param0}' and loc = 'PAPERDOLL'
            ORDER BY loc_data",

        "GetInventory" => "
            SELECT ".$fList_RT["items"]."
            FROM `items`
            WHERE owner_id = '{param0}' and loc = 'INVENTORY'
            ORDER BY loc_data",
            
        "GetMaxItem" => "
            SELECT MAX(`object_id`)+1 FROM `items`",
    
        "GetItemsWarehouse" => "
            SELECT item_id, loc_data, count, loc, enchant_level FROM `items`
            WHERE owner_id = '{param0}' and loc = 'WAREHOUSE'
            ORDER BY loc_data",

        "SearchItem" => "
            SELECT object_id, count
            FROM `items`
            WHERE owner_id = '{param0}' AND item_id = '{param1}' AND loc = 'INVENTORY'
            LIMIT 1",

        "InsertItem" => "
            INSERT INTO items (`owner_id`, `object_id`, `item_id`, `count`, `enchant_level`, `loc`)
            VALUES ('{param0}', '{param1}', '{param2}', '{param3}', 0, 'INVENTORY')
        ",
    
        "UpdateItem" => "
            UPDATE items
            SET
                count = '{param1}',
                enchant_level = '{param2}'
            WHERE object_id = '{param0}'        
        ",
    
        "UpdateItemCount" => "
            UPDATE items
            SET
                count = '{param1}'
            WHERE object_id = '{param0}'        
        ",
    
        "DeleteByOwner" => "
            DELETE FROM items
            WHERE owner_id = '{param0}'",
        
        "DeleteByOwnerItemID" => "
            DELETE FROM items
            WHERE owner_id = '{param0}' AND item_id = '{param1}'
            [0:IFSETNN=2]LIMIT {param2}[0:/IFSET]",
        
        "DeleteByOwnerObjectID" => "
            DELETE FROM items
            WHERE owner_id = '{param0}' AND object_id = '{param1}'
            [0:IFSETNN=2]LIMIT {param2}[0:/IFSET]",
    ),
);

unset($fList_RT);

?>