winter37rus

ошибка при добавлении итема SELECT `object_id`,`amount` FROM `items` WHERE `owner_id`='268478223' AND `item_id`='57' AND `loc`='INVENTORY' ошибка при редактировании SELECT `amount` AS `count`, `enchant` AS `enchant_level`,`item_type` AS `item_id` FROM `items` WHERE `object_id`='268478223'

сейчас вот так .только вот редактирование и добавление не работает. коды в 20 посте

/************************* * Add Item *************************/ $l2_content .= " <div align='left'> <form action='{$_url}=chars&action=character&lid={$lid}&sid={$sid}&id={$charID}' method='post'> Добавить персонажу предмет <b>Item ID</b>: <input type='text' name='AddItemId' style='width: 70px;'> <b>Количество:</b> <input type='text' name='AddItemCount' style='width: 70px;'> <b>Заточка:</b> <input type='text' name='AddItemEnchant' value='0' style='width: 70px;'> <b><i>одиночный</i></b> <input type='checkbox' value='1' name='AddItemSingle' title='Не складывается в кучу, а добавляется отдельно'> <input type='submit' value='Добавить' name='AddItem' class='button'></form> </div>"; if ( isset($_POST["AddItem"]) ) { $AddItemId = intval( $_POST["AddItemId"] ); $AddItemCount = intval( $_POST["AddItemCount"] ); $AddItemEnchant = !empty( $_POST["AddItemEnchant"] ) ? intval( $_POST["AddItemEnchant"] ):0; $AddItemSingle = intval( $controller->set("AddItemSingle") ); if ( empty($AddItemId) or $AddItemId == 0 ) $l2_content .= "<div class='error'>Введите ID предмета</div>"; elseif ( empty($AddItemCount) or $AddItemCount == 0 ) $l2_content .= "<div class='error'>Введите количество предметов</div>"; elseif ( $char_data["online"] == 1 ) $l2_content .= "<div class='error'>Персонаж находится в игре</div>"; else { if ( $AddItemSingle == "0" ) { $add_query = $gdb[$sid]->query( "SELECT `object_id`,`count` FROM `items` WHERE `owner_id`='{$charID}' AND `item_id`='{$AddItemId}' AND `loc`='INVENTORY'" ); if ( $gdb[$sid]->num_rows($add_query) > 0 ) { $add_data = $gdb[$sid]->fetch( $add_query ); $gdb[$sid]->query( "UPDATE `items` SET `count`=`count`+{$AddItemCount} WHERE `owner_id`='{$charID}' AND `object_id`='{$add_data["object_id"]}'" ); } else { list( $max_obj ) = $gdb[$sid]->fetch( $gdb[$sid]->query("SELECT MAX(`object_id`)+1 FROM `items`") ); $gdb[$sid]->query( "INSERT INTO `items` SET `owner_id`='{$charID}',`object_id`='{$max_obj}',`item_id`='{$AddItemId}',`count`={$AddItemCount},`enchant_level`='{$AddItemEnchant}',`loc`='INVENTORY'" ); } } else { for ( $i = 0; $i < $AddItemCount; $i++ ) { list( $max_obj ) = $gdb[$sid]->fetch( $gdb[$sid]->query("SELECT MAX(`object_id`)+1 FROM `items`") ); $gdb[$sid]->query( "INSERT INTO `items` SET `owner_id`='{$charID}',`object_id`='{$max_obj}',`item_id`='{$AddItemId}',`count`='1',`enchant_level`='{$AddItemEnchant}',`loc`='INVENTORY'" ); } } if ( $gdb[$sid]->affected() > 0 ) { $l2_content .= "<div class='no_error'>Персонажу был добавлен предмет <b>ID: {$AddItemId} ({$AddItemCount}шт.)[заточка: +{$AddItemEnchant}]</b></div>"; } else { $l2_content .= "<div class='error'>Ошибка базы данных</div>"; } } $l2_content .= "<center><a href='{$_url}=chars&action=character&lid={$lid}&sid={$sid}&id={$charID}'><b>Назад</b></a></center><br>"; } /************************* * Delete inventory *************************/ if ( isset($_REQUEST["delete_items"]) ) { $gdb[$sid]->SuperQuery( $qList[$vgs]["delItemByOwner"], array("charID" => $charID) ); $l2_content .= "<div class='error'> Удалено записей: ".$gdb[$sid]->affected()."</div><br>\n"; } /************************* * Delete item *************************/ if ( isset($_REQUEST["do"]) && $_REQUEST["do"] == "del_item" ) { $object_id = intval( $_REQUEST["object_id"] ); $gdb[$sid]->SuperQuery( $qList[$vgs]["delItemByObjectID"], array("objectID" => $object_id) ); $l2_content .= "<div class='error'> Удалено записей: ".$gdb[$sid]->affected()."</div><br>\n"; } /************************* * Edit item *************************/ if ( isset($_REQUEST["do"]) && $_REQUEST["do"] == "edit_item" ) { $edit_owner_id = intval( $_REQUEST["id"] ); $edit_object_id = intval( $_REQUEST["object_id"] ); $item_data = $gdb[$sid]->SuperFetchArray( $qList[$vgs]["getItemByObjectID"], array("objectID" => $edit_object_id) ); //$item_data = $gdb[$sid]->fetch($item_select); $l2_content .= " <form method='post' action='{$_url}=chars&action=character&lid={$lid}&sid={$sid}&do=update_item&id={$edit_owner_id}&object_id={$edit_object_id}'> <b>Edit Item</b> - ID {$item_data["item_id"]}<br> <b>Count</b>: <input type='text' value='{$item_data["count"]}' name='item_count' style='width: 50px;'> <b>Enchant</b>: <input type='text' value='{$item_data["enchant_level"]}' name='item_enchant' style='width: 50px;'> <input type='submit' value='Edit'><hr>"; } /************************* * Update item *************************/ if ( isset($_REQUEST["do"]) && $_REQUEST["do"] == "update_item" ) { $update_owner_id = intval( $_REQUEST["id"] ); $update_object_id = intval( $_REQUEST["object_id"] ); $update_count = intval( $_REQUEST["item_count"] ); $update_enchant = intval( $_REQUEST["item_enchant"] ); $update_count = ( $update_count > 0 ) ? $update_count:1; $gdb[$sid]->SuperQuery( $qList[$vgs]["setItem"], array("count" => $update_count, "enchant" => $update_enchant, "objectID" => $update_object_id) ); if ( $gdb[$sid]->affected() ) { $l2_content .= "<div class='no_error'>Предмет успешно обновлен</div>\n"; } else { $l2_content .= "<div class='error'>Ошибка при обновлении</div>\n"; } } вот коды удаления добавления редактирования

ну стало более менее но при попытке редактировать пишет ошибку SELECT `amount` AS `count`, `enchant` AS `enchant_level`,`item_type` AS `item_id` FROM `items` WHERE `object_id`='268478223'

в данный момент на работе. скайпы и аськи ок и вк и прочие вещи у нас в рабочее время запрещены. нехочу получить люлей от начальства.

paperdol это то что надето и должно быть вроде как в LOC inventory то что в инвентаре и должно быть вроде как в LOC заточка попала в LOC количество в заточку все перепутано вот код отображения в админке /************************* * Show char inventory *************************/ $sel = $gdb[$sid]->SuperQuery( $qList[$vgs]["getInventory"], array("charID" => $charID, "order" => "name") ); if ( $gdb[$sid]->num_rows($sel) == 0 ) { $l2_content .= "<div class='error'>У персонажа нет вещей</div>"; } else { $l2_content .= "<div> <table cellpadding='0' cellspacing='0' width='100%' class='shadow'> <tr> <td class='tdTitle'>ID</td> <td class='tdTitle'>Item</td> <td class='tdTitle'>Type</td> <td class='tdTitle'>Count</td> <td class='tdTitle'>Enchant</td> <td class='tdTitle'>Loc</td> <td class='tdTitle'>&nbsp</td> </tr>\n"; while ( list($object_id, $item_id, $item_count, $item_enchant, $item_loc, $item_name, $item_type) = $gdb[$sid]->fetch($sel) ) { $l2_content .= " <tr class='trRow' onmouseover=\"this.className='trRowOn'\" onmouseout=\"this.className='trRow'\"> <td>".$item_id."</td> <td>".$item_name."</td> <td>".$item_type."</td> <td>".$controller->CountFormat( $item_count )."</td> <td>".$item_enchant."</td> <td>".$item_loc."</td> <td><a href='{$_url}=chars&action=character&lid={$lid}&sid={$sid}&do=edit_item&id={$charID}&object_id={$object_id}'><img src='".TPLDIR."/edit.png' title='Edit'></a> <a href=\"javascript: v='{$item_id}'; url='{$_url}=chars&action=character&lid={$lid}&sid={$sid}&do=del_item&id={$charID}&object_id={$object_id}'; confirmDelete(v,url);\"><img src='".TPLDIR."/delete.png' title='Delete'></a></td> </tr>\n"; } $l2_content .= "</table></div><br>"; } } }

хзхзхз короче у меня в инвентаре адена в колличестве 998 штук .и хомка точеная на +10

я хз как узнать?.

ХАХ с чего такая уверенность?

ошибка удалил items.loc стало работать но все неправильно отображает где count пишет id адены а в заточке показывает колличество вот мои таблицы item_id owner_id item_type amount location slot enchant

никого не заставляю и не принуждаю! сказал заплачу значит заплачу!нехотите неверьте!

да

угу есть важные вещи. хотелось бы просто l2j_lucera3 переписать. изменить под мои таблицы! да и нет у меня таблицы с люцеры!все что дали с люцерой всю установил

вот ошибка при добавлении вещи Ошибка MySQL! ======================== MySQL вернул ошибку: Unknown column 'object_id' in 'field list' Номер ошибки: 1054 SELECT `object_id`,`count` FROM `items` WHERE `owner_id`='268478795' AND `item_id`='57' AND `loc`='INVENTORY' Шмот в админке не видно так же как и в ЛК просто пишет "У персонажа нет вещей"

а если ты мне не поможешь предоплата тютю???? Если я буду каждому предоплату давать останусь и без денег и без своей таблицы!

Парни помогайте заплачу от 1000 рублей и выше. Тот кто решит мою проблему в моих темах заплачу! http://forummaxi.ru/topic/69999-sw13-не-видит-шмот-в-админке/ http://forummaxi.ru/topic/70040-расположение-таблицstressweb/ Жду ответа!Кто сегодня решит мою проблему заплачу 3000 рублей!!!Срочно!!!! Если сегодня не поможете с завтрашнего дня заплачу не 3к а 1к.! СРОЧНО

Заплачу 1000 рублей тому кто решит мою проблему!

Заплачу 1000рублей тому кто решит мою проблему!

Всем ку! Обьясню сразу У меня не выводит список вещей на персе в админке и ЛК Помогите разобраться с таблицами и колонками куда чего пихать не пойму в mysql в таблице 'items' у меня 7 колонок item_id owner_id item_type amount location slot enchant Как все тут поменять чтобы все стало выводить как положено? сборка lucera в папке l2j в файле привязки сервера и сайта почему то строка связанная с инвентарем такая : "getInventory" => "SELECT 0 FROM `items` WHERE FALSE;", "getCharInventory" => "SELECT 0 FROM `items` WHERE FALSE;", Но если поменять этот код сверху на этот то все кое как работать начинает. "getInventory" => " SELECT items.owner_id,items.item_id,items.item_type,items.amount,items.location,items.enchant, 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' WHEN weapon.crystal_type != '' THEN 'weapon' WHEN etcitem.crystal_type != '' THEN 'etc' END AS `type` 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 items.owner_id='{charID}' ORDER BY {order}", "getCharInventory" => " SELECT items.owner_id,items.item_id,items.item_type,items.amount,items.location,items.enchant,armorName,weaponName,etcName,armorType,weaponType,etcType FROM `items` LEFT JOIN ( SELECT item_id, name AS armorName, crystal_type AS armorType FROM `armor` ) AS aa ON aa.item_id = items.item_id LEFT JOIN ( SELECT item_id, name AS weaponName, crystal_type AS weaponType FROM `weapon` ) AS ww ON ww.item_id = items.item_id LEFT JOIN ( SELECT item_id, name AS etcName, crystal_type AS etcType FROM `etcitem` ) AS ee ON ee.item_id = items.item_id WHERE items.owner_id='{charID}' AND items.location='{loc}' ORDER BY items.location", Начинает отображаться но без картинок все колонки перепутаны и хрен поймешь что в папке admin в файле chars.php такой код /************************* * Show char inventory *************************/ $sel = $gdb[$sid]->SuperQuery( $qList[$vgs]["getInventory"], array("charID" => $charID, "order" => "name") ); if ( $gdb[$sid]->num_rows($sel) == 0 ) { $l2_content .= "<div class='error'>У персонажа нет вещей</div>"; } else { $l2_content .= "<div> <table cellpadding='0' cellspacing='0' width='100%' class='shadow'> <tr> <td class='tdTitle'>ID</td> <td class='tdTitle'>Item</td> <td class='tdTitle'>Type</td> <td class='tdTitle'>Count</td> <td class='tdTitle'>Enchant</td> <td class='tdTitle'>Loc</td> <td class='tdTitle'>&nbsp</td> </tr>\n"; while ( list($object_id, $item_id, $item_count, $item_enchant, $item_loc, $item_name, $item_type) = $gdb[$sid]->fetch($sel) ) { $l2_content .= " <tr class='trRow' onmouseover=\"this.className='trRowOn'\" onmouseout=\"this.className='trRow'\"> <td>".$item_id."</td> <td>".$item_name."</td> <td>".$item_type."</td> <td>".$controller->CountFormat( $item_count )."</td> <td>".$item_enchant."</td> <td>".$item_loc."</td> <td><a href='{$_url}=chars&action=character&lid={$lid}&sid={$sid}&do=edit_item&id={$charID}&object_id={$object_id}'><img src='".TPLDIR."/edit.png' title='Edit'></a> <a href=\"javascript: v='{$item_id}'; url='{$_url}=chars&action=character&lid={$lid}&sid={$sid}&do=del_item&id={$charID}&object_id={$object_id}'; confirmDelete(v,url);\"><img src='".TPLDIR."/delete.png' title='Delete'></a></td> </tr>\n"; } $l2_content .= "</table></div><br>"; } } } /** в папке application/account/charinfo.php такой код /************************** * items paperdoll **************************/ $query_paperdoll = $gdb[$sid]->SuperQuery( $qList[$vgs]["getCharInventory"], array("charID" => $charID, "loc" => "PAPERDOLL") ); $paperdoll = ""; while ( $paperdoll_data = $gdb[$sid]->fetch($query_paperdoll) ) { $name = ( $paperdoll_data["armorName"] != "" ) ? $paperdoll_data["armorName"] ($paperdoll_data["weaponName"] != "") ? $paperdoll_data["weaponName"]:$paperdoll_data["etcName"] ); $name = str_replace( "'", "\\'", $name ); $grade = ( $paperdoll_data["armorType"] != "" ) ? ( (strtolower($paperdoll_data["armorType"]) == "none") ? "ng":$paperdoll_data["armorType"] ) ($paperdoll_data["weaponType"] != "") ? ((strtolower($paperdoll_data["weaponType"]) == "none") ? "ng":$paperdoll_data["weaponType"]):"" ); $grade = ( !empty($grade) ) ? '<img border=0 src='.TPLDIR.'/images/grade/grade_'.$grade.'.gif>':""; $enchant = $paperdoll_data["enchant_level"] > 0 ? " +".$paperdoll_data["enchant_level"]:""; $count = $controller->CountFormat( $paperdoll_data["count"] ); $img = ( $controller->IsImage($paperdoll_data["item_id"]) ) ? $paperdoll_data["item_id"]:"blank"; $type = $qList[$vgs]["itemType"][$paperdoll_data["loc_data"]]; $paperdoll .= "<div id='item' class='{$type}'><img border='0' src='".HTTP_HOME_URL."/items/{$img}.gif' onmouseover=\"Tip('{$name} {$count} {$enchant} {$grade}', FONTCOLOR, '#333333',BGCOLOR, '#FFFFFF', BORDERCOLOR, '#666666', FADEIN, 500, FADEOUT, 500, FONTWEIGHT, 'bold')\"></div>\n"; } /************************** * items inventory **************************/ $query_inventory = $gdb[$sid]->SuperQuery( $qList[$vgs]["getCharInventory"], array("charID" => $charID, "loc" => "INVENTORY") ); $inv = ""; while ( $inv_data = $gdb[$sid]->fetch($query_inventory) ) { $name = ( $inv_data["armorName"] != "" ) ? $inv_data["armorName"] ($inv_data["weaponName"] != "") ? $inv_data["weaponName"]:$inv_data["etcName"] ); $name = str_replace( "'", "\\'", $name ); $grade = ( $inv_data["armorType"] != "" ) ? ( (strtolower($inv_data["armorType"]) == "none") ? "ng":$inv_data["armorType"] ) ($inv_data["weaponType"] != "") ? ((strtolower($inv_data["weaponType"]) == "none") ? "ng":$inv_data["weaponType"]):"" ); $grade = ( !empty($grade) ) ? '<img border=0 src='.TPLDIR.'/images/grade/grade_'.$grade.'.gif>':""; $enchant = $inv_data["enchant_level"] > 0 ? " +".$inv_data["enchant_level"]:""; $count = ( $inv_data["count"] > 1 ) ? "(".$controller->CountFormat( $inv_data["count"] ).")":""; $img = ( $controller->IsImage($inv_data["item_id"]) ) ? $inv_data["item_id"]:"blank"; $inv .= "<img class='floated' border='0' src='".HTTP_HOME_URL."/items/{$img}.gif' onmouseover=\"Tip('{$name} {$count} {$enchant} {$grade}', FONTCOLOR, '#333333',BGCOLOR, '#FFFFFF', BORDERCOLOR, '#666666', FADEIN, 500, FADEOUT, 500, FONTWEIGHT, 'bold')\">\n"; } $tpl->LoadView( "character" ); $tpl->Set( "prof", "<img src='".TPLDIR."/images/prof/{$char_data["base_class"]}.gif'>" ); $tpl->Set( "charname", $char_data["char_name"] ); $tpl->Set( "sex", "<img src='".TPLDIR."/images/face/{$char_data["race"]}_{$char_data["sex"]}.gif'>" ); $tpl->Set( "race", $raceList[$char_data["race"]] ); $tpl->Set( "level", $char_data["level"] ); $tpl->Set( 'cp', $char_data["maxCp"] ); $tpl->Set( 'hp', $char_data["maxHp"] ); $tpl->Set( 'mp', $char_data["maxMp"] ); $tpl->Set( 'pvp', $char_data["pvpkills"] ); $tpl->Set( 'pk', $char_data["pkkills"] ); $tpl->Set( 'karma', $char_data["karma"] ); $tpl->Set( 'str', $char_data["STR"] ); $tpl->Set( 'dex', $char_data["DEX"] ); $tpl->Set( 'con', $char_data["CON"] ); $tpl->Set( 'int', $char_data["_INT"] ); $tpl->Set( 'wit', $char_data["WIT"] ); $tpl->Set( 'men', $char_data["MEN"] ); $tpl->Set( 'exp', $char_data["exp"] ); $tpl->Set( 'sp', $char_data["sp"] ); $tpl->Set( 'paperdoll', $paperdoll ); $tpl->Set( 'inventory', $inv ); $tpl->Build( "l2character" ); $profile = $tpl->GetResult( "l2character" ); if ( $l2cfg["cache"]["enable"] and $l2cfg["cache"]["char"] ) { $controller->SetCache( "l2char_{$charID}_s{$sid}", $profile, $l2cfg["cache"]["char"] ); } } else { $profile = "<div class='error'>{$lang["chars_12"]}</div>"; } } } } else exit; ?> Всю инфу выложил прошу помощи ребята выручайте!

В админ панели при добавлении какой либо вещи пишет "Ошибка базы данных" помогите..........

Вот нашел кусок php с выводом всех вещей в личном кабинете что не так ? /************************** * items inventory **************************/ $query_inventory = $gdb[$sid]->SuperQuery( $qList[$vgs]["getCharInventory"], array("charID" => $charID, "loc" => "INVENTORY") ); $inv = ""; while ( $inv_data = $gdb[$sid]->fetch($query_inventory) ) { $name = ( $inv_data["armorName"] != "" ) ? $inv_data["armorName"] ($inv_data["weaponName"] != "") ? $inv_data["weaponName"]:$inv_data["etcName"] ); $name = str_replace( "'", "\\'", $name ); $grade = ( $inv_data["armorType"] != "" ) ? ( (strtolower($inv_data["armorType"]) == "none") ? "ng":$inv_data["armorType"] ) ($inv_data["weaponType"] != "") ? ((strtolower($inv_data["weaponType"]) == "none") ? "ng":$inv_data["weaponType"]):"" ); $grade = ( !empty($grade) ) ? '<img border=0 src='.TPLDIR.'/images/grade/grade_'.$grade.'.gif>':""; $enchant = $inv_data["enchant_level"] > 0 ? " +".$inv_data["enchant_level"]:""; $count = ( $inv_data["count"] > 1 ) ? "(".$controller->CountFormat( $inv_data["count"] ).")":""; $img = ( $controller->IsImage($inv_data["item_id"]) ) ? $inv_data["item_id"]:"blank"; $inv .= "<img class='floated' border='0' src='".HTTP_HOME_URL."/items/{$img}.gif' onmouseover=\"Tip('{$name} {$count} {$enchant} {$grade}', FONTCOLOR, '#333333',BGCOLOR, '#FFFFFF', BORDERCOLOR, '#666666', FADEIN, 500, FADEOUT, 500, FONTWEIGHT, 'bold')\">\n"; }

К сожалению нет. еслиб была невидна просто картинка все бы давно поправил!

Для моей сборки в стрессвеб lucera есть! собственно именно этот код я и вставил в первом посте. Кто разбирается помогите поченму от с mysql не тащит базы weapon armor etcitem ???

Приветствую вас форумчане! Решил зарегистрироваться требуется ваша помощь! Запустил уже 4 месяца назад свой сервер Interlude. Сборка шара lucera interlude stressweb 13 шара от стрессвеба sql запросы выполнял все в БД Привилегии таблицам давал. Все работает кроме списка вещей. Так же если зайти в личный кабинет. списка вещей тоже нету И все никак не могу разобраться. Проблема следующая. В админ панели в управлении аккаунтами не видит список шмоток на чаре постоянно пишет "У персонажа нет вещей" Хотя если нажать "Удалить все вещи на чаре" он все прекрасно удаляет. Так же при нажатии на кнопку добавить персу вещ пишет Ошибка базы данных. Куда ковырять? В stress web lucera добавлял сам Прилагаю код под сборку lucera для stressweb sql для вывода шмоток на сайт залил в базу следующие таблицы может тут что не так прописано? weapon armor etcitem <?php if (!defined("STRESSWEB")) { die ("Access denied..."); } $qList["Lucera3"] = array ( // WTF ??? "fields" => array( "accessLevel"=> "access_level", "charID" => "obj_Id", ), "itemType" => array ( 0 => "dress", 1 => "helmet", 2 => "lefthair", 3 => "righthair", 4 => "necklace", 5 => "weapon", 6 => "top", 7 => "shield", 8 => "leftearring", 9 => "rightearring", 10 => "gloves", 11 => "lower", 12 => "bots", 14 => "leftring", 15 => "rightring", 16 => "ring", // 18 => "lefthair", // 20 => "righthair", // 22 => "braslet", ), "insAccount" => " INSERT INTO `accounts` ( `login`, `password`, `accessLevel`, `email` ) VALUES ( '{login}', '{pass}', '0', '{email}' ) ", "insItem" => " INSERT LOW_PRIORITY INTO `items` ( `owner_id`, `item_id`, `item_type`, `amount`, `enchant`, `location`, `slot` ) VALUES ( '{ownerID}', '{objectID}', '{itemID}', '{count}', '{enchant}', 'INVENTORY', '0' ) ", "setPassword" => " UPDATE `accounts` SET `password` = '{pass}' WHERE `login` = '{login}' ", "setAccessLevelAccount" => " UPDATE `accounts` SET `accessLevel` = '{level}' WHERE `login` = '{login}' ", "setAccessLevelCharacter" => " UPDATE `characters` SET `accesslevel` = '{level}' WHERE `obj_Id` = '{charID}' ", "setTeleport" => " UPDATE `characters` SET `x` = '{x}', `y` = '{y}', `z` = '{z}', `last_teleport` = '{lastteleport}' WHERE `obj_Id` = '{charID}' ", "setItem" => " UPDATE `items` SET `amount` = '{count}', `enchant` = '{enchant}' WHERE `item_id` = '{objectID}' ", "setItemCount" => " UPDATE `items` SET `amount` = '{count}' WHERE `owner_id` = '{ownerID}' AND `item_id` = '{objectID}' ", "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' ", "getCountKamael" => " SELECT 0 AS `count(0)` ", "getCountDawn" => " SELECT count(0) FROM `seven_signs` WHERE `cabal` = 'dawn' ", "getCountDusk" => " SELECT count(0) FROM `seven_signs` WHERE `cabal`='dusk' ", "getAccount" => " SELECT `login` AS `login`, `password` AS `password`, `lastactive` AS `lastactive`, `accessLevel` AS `accessLevel`, `lastIP` AS `lastIP` FROM `accounts` WHERE `login`='{login}' {where} LIMIT 1 ", "getAccounts" => " SELECT `login` AS `login`, `lastactive` AS `lastactive`, `accessLevel` AS `accessLevel`, `lastIP` 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_subpledges`.`name` AS `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_subpledges` ON `characters`.`clanid` = `clan_subpledges`.`clan_id` AND `clan_subpledges`.`type` = 0 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_subpledges`.`name` AS `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_subpledges` ON `characters`.`clanid` = `clan_subpledges`.`clan_id` AND `clan_subpledges`.`type` = 0 WHERE `characters`.`account_name` = '{account}' ORDER BY `characters`.`char_name` ", "getTopClan"=>" SELECT `clan_subpledges`.`name` AS `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 `clan_subpledges` ON `clan_data`.`clan_id` = `clan_subpledges`.`clan_id` AND `clan_subpledges`.`type` = 0 LEFT JOIN `characters` ON `characters`.`obj_Id` = `clan_subpledges`.`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_subpledges`.`name` AS `clan_name`, `clan_subpledges`.`clan_id` AS `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_subpledges` ON `characters`.`clanid` = `clan_subpledges`.`clan_id` AND `clan_subpledges`.`type` = 0 WHERE `characters`.`accesslevel` = '0' ORDER BY {order} DESC LIMIT {limit} ", "getRich" => " SELECT `characters`.`char_name`, `character_subclasses`.`level`, `characters`.`sex`, `characters`.`online`, `characters`.`onlinetime`, `char_templates`.`ClassName`, `clan_subpledges`.`name` AS `clan_name`, `clan_subpledges`.`clan_id` AS `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_subpledges` ON `characters`.`clanid` = `clan_subpledges`.`clan_id` AND `clan_subpledges`.`type` = 0 LEFT JOIN ( SELECT `owner_id`, SUM(`amount`) AS `count` FROM `items` WHERE `items`.`item_type` = {item_id} GROUP BY `owner_id` ) AS `count` ON `characters`.`obj_Id` = `count`.`owner_id` WHERE `characters`.`accesslevel` = '0' ORDER BY `count` DESC, `level` DESC, `onlinetime` 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_subpledges`.`name` AS `clan_name`, `clan_data`.`clan_id` FROM `characters` LEFT JOIN `clan_subpledges` ON `characters`.`clanid` = `clan_subpledges`.`clan_id` AND `clan_subpledges`.`type` = 0 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_subpledges`.`name` AS `clan_name`, `clan_subpledges`.`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_subpledges` ON `characters`.`clanid` = `clan_subpledges`.`clan_id` AND `clan_subpledges`.`type` = 0 WHERE `characters`.`accesslevel` = '0' AND `characters`.`online` = '1' ORDER BY `character_subclasses`.`level` DESC, `characters`.`onlinetime` DESC ", // TODO There is no such thing "getEpicStatus" => "SELECT 0 FROM `epic_boss_spawn` WHERE FALSE", // TODO There is no such thing "getRaidStatus" => "SELECT 0 FROM `epic_boss_spawn` WHERE FALSE", "getClan" => " SELECT `clan_subpledges`.`name` AS `clan_name` FROM `clan_subpledges` WHERE `clan_subpledges`.`clan_id` = '{clanid}' AND `clan_subpledges`.`type` = 0 ", "getCastles" => " SELECT `castle`.`name`, `castle`.`id`, `castle`.`tax_percent` AS `taxPercent`, `castle`.`siege_date` AS `siegeDate`, `clan_subpledges`.`name` AS `clan_name`, `clan_data`.`clan_id` FROM `castle` LEFT OUTER JOIN `clan_data` ON `clan_data`.`hasCastle` = `castle`.`id` LEFT JOIN `clan_subpledges` ON `clan_subpledges`.`clan_id` = `clan_data`.`clan_id` AND `clan_subpledges`.`type` = 0 ORDER BY `castle`.`id` ", "getSiege" => " SELECT siege_clans.unit_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 unit_id='{castle}'", "getOlympiad" => " SELECT olympiad_nobles.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", "getInventory" => "SELECT 0 FROM `items` WHERE FALSE;", "getCharInventory" => "SELECT 0 FROM `items` WHERE FALSE;", "getItemByObjectID" => " SELECT `amount` AS `count`, `enchant` AS `enchant_level`,`item_type` AS `item_id` FROM `items` WHERE `object_id`='{objectID}'", "getLastTeleport" => " SELECT `char_name`,`online`,`accesslevel`,`lastteleport` FROM `characters` WHERE `obj_Id`='{charID}'", "getItem" => " SELECT `object_id`, `amount` AS `count` FROM `items` WHERE `owner_id` = '{charID}' AND `item_type` = '{itemID}' AND `location` = 'INVENTORY' LIMIT 1", "getMax" => " SELECT MAX(`item_id`)+1 AS `max` FROM `items`", "delAccounts" => " DELETE FROM accounts WHERE login='{login}'", "delItemByID" => " DELETE FROM `items` WHERE `item_type`='{item}'", "delCharByID" => " DELETE FROM `characters` WHERE `obj_Id`='{charID}'", "delItemByOwner" => " DELETE FROM `items` WHERE `owner_id`='{charID}'", "delItemByObjectID" => " DELETE FROM `items` WHERE `object_id`='{objectID}'", "delItemByIDOwner" => " DELETE FROM `items` WHERE `item_type`='{item}' AND `owner_id`='{charID}'", "other" => array( "DELETE FROM character_friends WHERE char_id='{charID}' OR friend_id='{charID}'", "DELETE FROM character_hennas WHERE char_obj_id='{charID}'", "DELETE FROM character_macroses WHERE char_obj_id='{charID}'", "DELETE FROM character_quests WHERE char_id='{charID}'", "DELETE FROM character_recipebook WHERE char_id='{charID}'", "DELETE FROM character_shortcuts WHERE char_obj_id='{charID}'", "DELETE FROM character_skills WHERE char_obj_id='{charID}'", "DELETE FROM character_skills_save WHERE char_obj_id='{charID}'", "DELETE FROM character_subclasses WHERE char_obj_id='{charID}'", "DELETE FROM seven_signs WHERE char_obj_id='{charID}'", "DELETE FROM items WHERE owner_id='{charID}'", "DELETE FROM clan_data WHERE leader_id='{charID}'", ), "l2top" => array( "getChar" => " SELECT account_name, obj_Id AS charID, online FROM `characters` WHERE `char_name`='{name}'", "getItem" => " SELECT AS `item_type` AS `item_id`,`amount` AS `count` FROM `items` WHERE `owner_id`='{ownerID}' AND `item_type`='{itemID}' AND `location`='INVENTORY'", "getMax" => " SELECT MAX(`item_id`)+1 AS `max` FROM `items`", "insItem" => " INSERT INTO `items` (`owner_id`,`item_id`,`item_type`,`amount`,`enchant`,`location`,`slot`) VALUES ('{charID}', '{objectID}', '{itemID}', '{count}', '0', 'INVENTORY', '0')", "insl2top" => " INSERT INTO `l2top` (`nick`,`ip`,`time`) VALUES ('{nick}','{ip}','{time}')", "setItem" => " UPDATE `items` SET `amount`=`amount`+'{count}' WHERE `owner_id`='{ownerID}' AND `item_type`='{itemID}' AND `location`='INVENTORY'", ), "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", ); ?>