Problems Fluxcp Hercules

[stiflerxx 2]

Good to item_db category does not work and shows no errors '-' 

demonstrates how the image below:

 

however mob_db table works normally

 

and consultation of mob_db showing the items that drops from monbs TBM works and not only that work got item_db

 

 

does anyone know what can be?

Edited July 15, 2014 by stiflerxx

[Jedzkie 58]

did you check the settings if renewal or pre-renewal in servers.php?

[stiflerxx 2]

'Renewal'         => true,

'Renewal'         => false

 

tried them both,

 

my server and the table is pre item_db

 

modules>item>index.php

 

 

if (!defined('FLUX_ROOT')) exit;

//$this->loginRequired();

$title = 'List Items';

require_once 'Flux/TemporaryTable.php';

try {
if($server->isRenewal) {
$fromTables = array("{$server->charMapDatabase}.item_db", "{$server->charMapDatabase}.item_db");
} else {
$fromTables = array("{$server->charMapDatabase}.item_db", "{$server->charMapDatabase}.item_db");
}
$tableName = "{$server->charMapDatabase}.items";
$tempTable = new Flux_TemporaryTable($server->connection, $tableName, $fromTables);
$shopTable = Flux::config('FluxTables.ItemShopTable');

// Statement parameters, joins and conditions.
$bind = array();
$sqlpartial = "LEFT OUTER JOIN {$server->charMapDatabase}.$shopTable ON $shopTable.nameid = items.id ";
$sqlpartial .= "WHERE 1=1 ";
$itemID = $params->get('item_id');

if ($itemID) {
$sqlpartial .= "AND items.id = ? ";
$bind[] = $itemID;
}
else {
$opMapping = array('eq' => '=', 'gt' => '>', 'lt' => '<');
$opValues = array_keys($opMapping);
$itemName = $params->get('name');
$itemType = $params->get('type');
$equipLocs = $params->get('equip_loc');
$npcBuy = $params->get('npc_buy');
$npcBuyOp = $params->get('npc_buy_op');
$npcSell = $params->get('npc_sell');
$npcSellOp = $params->get('npc_sell_op');
$weight = $params->get('weight');
$weightOp = $params->get('weight_op');
$atk = $params->get('atk');
$atkOp = $params->get('atk_op');
if ($server->isRenewal) {
$matk = $params->get('matk');
$matkOp = $params->get('matk_op');
}
$defense = $params->get('defense');
$defenseOp = $params->get('defense_op');
$range = $params->get('range');
$rangeOp = $params->get('range_op');
$slots = $params->get('slots');
$slotsOp = $params->get('slots_op');
$refineable = $params->get('refineable');
$forSale = $params->get('for_sale');
$custom = $params->get('custom');

if ($itemName) {
$sqlpartial .= "AND (name_japanese LIKE ? OR name_japanese = ?) ";
$bind[] = "%$itemName%";
$bind[] = $itemName;
}

if ($itemType && $itemType !== '-1') {
if (count($itemTypeSplit = explode('-', $itemType)) == 2) {
$itemType = $itemTypeSplit[0];
$itemType2 = $itemTypeSplit[1];
}
if (is_numeric($itemType) && (floatval($itemType) == intval($itemType))) {
$itemTypes = Flux::config('ItemTypes')->toArray();
if (array_key_exists($itemType, $itemTypes) && $itemTypes[$itemType]) {
$sqlpartial .= "AND type = ? ";
$bind[] = $itemType;
} else {
$sqlpartial .= 'AND type IS NULL ';
}

if (count($itemTypeSplit) == 2 && is_numeric($itemType2) && (floatval($itemType2) == intval($itemType2))) {
$itemTypes2 = Flux::config('ItemTypes2')->toArray();
if (array_key_exists($itemType, $itemTypes2) && array_key_exists($itemType2, $itemTypes2[$itemType]) && $itemTypes2[$itemType][$itemType2]) {
$sqlpartial .= "AND view = ? ";
$bind[] = $itemType2;
} else {
$sqlpartial .= 'AND view IS NULL ';
}
}
} else {
$typeName = preg_quote($itemType, '/');
$itemTypes = preg_grep("/.*?$typeName.*?/i", Flux::config('ItemTypes')->toArray());

if (count($itemTypes)) {
$itemTypes = array_keys($itemTypes);
$sqlpartial .= "AND (";
$partial = '';

foreach ($itemTypes as $id) {
$partial .= "type = ? OR ";
$bind[] = $id;
}

$partial = preg_replace('/s*ORs*$/', '', $partial);
$sqlpartial .= "$partial) ";
} else {
$sqlpartial .= 'AND type IS NULL ';
}
}
}

if ($equipLocs !== false && $equipLocs !== '-1') {
if(is_numeric($equipLocs) && (floatval($equipLocs) == intval($equipLocs))) {
$equipLocationCombinations = Flux::config('EquipLocationCombinations')->toArray();
if (array_key_exists($equipLocs, $equipLocationCombinations) && $equipLocationCombinations[$equipLocs]) {
if ($equipLocs === '0') {
$sqlpartial .= "AND (equip_locations = 0 OR equip_locations IS NULL) ";
} else {
$sqlpartial .= "AND equip_locations = ? ";
$bind[] = $equipLocs;
}
}
} else {
$combinationName = preg_quote($equipLocs, '/');
$equipLocationCombinations = preg_grep("/.*?$combinationName.*?/i", Flux::config('EquipLocationCombinations')->toArray());

if (count($equipLocationCombinations)) {
$equipLocationCombinations = array_keys($equipLocationCombinations);
$sqlpartial .= "AND (";
$partial = '';

foreach ($equipLocationCombinations as $id) {
if ($id === 0) {
$partial .= "(equip_locations = 0 OR equip_locations IS NULL) OR ";
} else {
$partial .= "equip_locations = ? OR ";
$bind[] = $id;
}
}

$partial = preg_replace('/s*ORs*$/', '', $partial);
$sqlpartial .= "$partial) ";
}
}
}

if (in_array($npcBuyOp, $opValues) && trim($npcBuy) != '') {
$op = $opMapping[$npcBuyOp];
if ($op == '=' && $npcBuy === '0') {
$sqlpartial .= "AND (price_buy IS NULL OR price_buy = 0) ";
}
else {
$sqlpartial .= "AND price_buy $op ? ";
$bind[] = $npcBuy;
}
}

if (in_array($npcSellOp, $opValues) && trim($npcSell) != '') {
$op = $opMapping[$npcSellOp];
if ($op == '=' && $npcSell === '0') {
$sqlpartial .= "AND IFNULL(price_sell, FLOOR(price_buy/2)) = 0 ";
}
else {
$sqlpartial .= "AND IFNULL(price_sell, FLOOR(price_buy/2)) $op ? ";
$bind[] = $npcSell;
}
}

if (in_array($weightOp, $opValues) && trim($weight) != '') {
$op = $opMapping[$weightOp];
if ($op == '=' && $weight === '0') {
$sqlpartial .= "AND (weight IS NULL OR weight = 0) ";
}
else {
$sqlpartial .= "AND CAST(weight/10 AS UNSIGNED INTEGER) $op ? ";
$bind[] = $weight;
}
}

if (in_array($atkOp, $opValues) && trim($atk) != '') {
$op = $opMapping[$atkOp];
if ($op == '=' && $atk === '0') {
$sqlpartial .= "AND (atk IS NULL OR atk = 0) ";
}
else {
$sqlpartial .= "AND atk $op ? ";
$bind[] = $atk;
}
}

if ($server->isRenewal && in_array($matkOp, $opValues) && trim($matk) != '') {
$op = $opMapping[$matkOp];
if ($op == '=' && $matk === '0') {
$sqlpartial .= "AND (matk IS NULL OR matk = 0) ";
}
else {
$sqlpartial .= "AND matk $op ? ";
$bind[] = $matk;
}
}

if (in_array($defenseOp, $opValues) && trim($defense) != '') {
$op = $opMapping[$defenseOp];
if ($op == '=' && $defense === '0') {
$sqlpartial .= "AND (defence IS NULL OR defence = 0) ";
}
else {
$sqlpartial .= "AND defence $op ? ";
$bind[] = $defense;
}
}

if (in_array($rangeOp, $opValues) && trim($range) != '') {
$op = $opMapping[$rangeOp];
if ($op == '=' && $range === '0') {
$sqlpartial .= "AND (`range` IS NULL OR `range` = 0) ";
}
else {
$sqlpartial .= "AND `range` $op ? ";
$bind[] = $range;
}
}

if (in_array($slotsOp, $opValues) && trim($slots) != '') {
$op = $opMapping[$slotsOp];
if ($op == '=' && $slots === '0') {
$sqlpartial .= "AND (slots IS NULL OR slots = 0) ";
}
else {
$sqlpartial .= "AND slots $op ? ";
$bind[] = $slots;
}
}

if ($refineable) {
if ($refineable == 'yes') {
$sqlpartial .= "AND refineable > 0 ";
}
elseif ($refineable == 'no') {
$sqlpartial .= "AND IFNULL(refineable, 0) < 1 ";
}
}

if ($forSale) {
if ($forSale == 'yes') {
$sqlpartial .= "AND $shopTable.cost > 0 ";
}
elseif ($forSale == 'no') {
$sqlpartial .= "AND IFNULL($shopTable.cost, 0) < 1 ";
}
}

if ($custom) {
if ($custom == 'yes') {
$sqlpartial .= "AND origin_table LIKE '%item_db' ";
}
elseif ($custom == 'no') {
$sqlpartial .= "AND origin_table LIKE '%item_db' ";
}
}
}

// Get total count and feed back to the paginator.
$sth = $server->connection->getStatement("SELECT COUNT(DISTINCT items.id) AS total FROM $tableName $sqlpartial");
$sth->execute($bind);

$paginator = $this->getPaginator($sth->fetch()->total);
$sortable = array(
'item_id' => 'asc', 'name', 'type', 'equip_locations', 'price_buy', 'price_sell', 'weight',
'atk', 'defense', 'range', 'slots', 'refineable', 'cost', 'origin_table'
);
if($server->isRenewal) {
$sortable[] = 'matk';
}
$paginator->setSortableColumns($sortable);

$col = "origin_table, items.id AS item_id, name_japanese AS name, type, ";
$col .= "IFNULL(equip_locations, 0) AS equip_locations, price_buy, weight/10 AS weight, ";
$col .= "defence AS defense, `range`, slots, refineable, cost, $shopTable.id AS shop_item_id, ";
$col .= "IFNULL(price_sell, FLOOR(price_buy/2)) AS price_sell, view, atk, matk";

$sql = $paginator->getSQL("SELECT $col FROM $tableName $sqlpartial GROUP BY items.id");
$sth = $server->connection->getStatement($sql);

$sth->execute($bind);
$items = $sth->fetchAll();

$authorized = $auth->actionAllowed('item', 'view');

if ($items && count($items) === 1 && $authorized && Flux::config('SingleMatchRedirectItem')) {
$this->redirect($this->url('item', 'view', array('id' => $items[0]->item_id)));
}
}
catch (Exception $e) {
if (isset($tempTable) && $tempTable) {
// Ensure table gets dropped.
$tempTable->drop();
}

// Raise the original exception.
$class = get_class($e);
throw new $class($e->getMessage());
}
?>

 

Edited July 16, 2014 by stiflerxx