cora cp users

[N e s s 3]

how to fix this error? 

A Database Error Occurred

Error Number: 1054

Unknown column 'item_db.type' in 'where clause'

SELECT * FROM ((SELECT * FROM (`tcp_shop`) JOIN `item_db2` ON `item_db2`.`id`=`tcp_shop`.`item_id` WHERE `item_db.type`=5) UNION (SELECT * FROM (`tcp_shop`) JOIN `item_db` ON `item_db`.`id`=`tcp_shop`.`item_id` WHERE `item_db.type`=5)) a ORDER BY `name_japanese` asc LIMIT 0, 10

Filename: /home/brynhild/application/models/mshop.php

Line Number: 60

 

i got this error when i click consumable, weapon, costumes, pet, cards, and misc category in cash shop help me for those who are using cora cp

[Takari 27]

Hi. The problem here is that in the shop controller, the `type` fields are prefixed with the `item_db` table name while in the model it's also prefixed with whatever db you choose. So if you are using item_db, it would add an item_db string string in the field name which will result into `item_db`.`item_db.type` thus creating an error in the sql statement.
 
You can fix this by editing line 24-51 of the application/controllers/shop.php file. In those lines you'll find this piece of code:
 

if(isset($_GET['cat'])) {            switch($_GET['cat']) {                case 'consume':                    $cond = array('index'=>'item_db.type','val'=>array(0,2,11,18)); break;                case 'head':                    $cond = array('index'=>'equip_locations','val'=>array(1,256,257,512,513,768,769)); break;                case 'weapon':                    $cond = array('index'=>'item_db.type','val'=>array(5)); break;                case 'shield':                    $cond = array('index'=>'equip_locations','val'=>array(32)); break;                case 'armor':                    $cond = array('index'=>'equip_locations','val'=>array(16)); break;                case 'robe':                    $cond = array('index'=>'equip_locations','val'=>array(4)); break;                case 'shoes':                    $cond = array('index'=>'equip_locations','val'=>array(64)); break;                case 'accessories':                    $cond = array('index'=>'equip_locations','val'=>array(8,128,136)); break;                case 'pets':                    $cond = array('index'=>'item_db.type','val'=>array(7,8)); break;                case 'cards':                    $cond = array('index'=>'item_db.type','val'=>array(6)); break;                case 'costumes':                    $cond = array('index'=>'equip_locations','val'=>array(1024,2048,3072,4096,5120,6144,7168,8192));                case 'misc':                    $cond = array('index'=>'item_db.type','val'=>array(3,10)); break;            }        }

For each case where the 'index' is `item_db.type`, remove the item_db so you'll only be left with `type`. Unfortunately there's no official patch for this, so a fix for now will have to be done like this.

On the good note, we have already restarted development for the second phase of CORA's beta.