Beiträge von dese

    UPDATE `ssa`.`furniture` SET `allow_marketplace_sell` = '1',
    `interaction_modes_count` = '2' WHERE `furniture`.`public_name` = 'rare_dragonvamp*4' AND `furniture`.`item_name` = 'rare_dragonvamp*4' AND `furniture`.`type` = 's' AND `furniture`.`width` =1 AND `furniture`.`length` =1 AND CONCAT( `furniture`.`stack_height` ) = '1' AND `furniture`.`can_stack` = '1' AND `furniture`.`can_sit` = '0' AND `furniture`.`is_walkable` = '0' AND `furniture`.`sprite_id` =3000007 AND `furniture`.`allow_recycle` = '0' AND `furniture`.`allow_trade` = '0' AND `furniture`.`allow_marketplace_sell` = '' AND `furniture`.`allow_gift` = '0' AND `furniture`.`allow_inventory_stack` = '1' AND `furniture`.`interaction_type` = 'default' AND `furniture`.`interaction_modes_count` =1 AND `furniture`.`vending_ids` = '0' AND `furniture`.`is_arrow` = '0' AND `furniture`.`foot_figure` = '' LIMIT 1 ;
    UPDATE `ssa`.`furniture` SET `allow_marketplace_sell` = '1',
    `interaction_modes_count` = '2' WHERE `furniture`.`public_name` = 'rare_dragonvamp*0' AND `furniture`.`item_name` = 'rare_dragonvamp*0' AND `furniture`.`type` = 's' AND `furniture`.`width` =1 AND `furniture`.`length` =1 AND CONCAT( `furniture`.`stack_height` ) = '1' AND `furniture`.`can_stack` = '1' AND `furniture`.`can_sit` = '0' AND `furniture`.`is_walkable` = '0' AND `furniture`.`sprite_id` =3000004 AND `furniture`.`allow_recycle` = '0' AND `furniture`.`allow_trade` = '0' AND `furniture`.`allow_marketplace_sell` = '' AND `furniture`.`allow_gift` = '0' AND `furniture`.`allow_inventory_stack` = '1' AND `furniture`.`interaction_type` = 'default' AND `furniture`.`interaction_modes_count` =1 AND `furniture`.`vending_ids` = '0' AND `furniture`.`is_arrow` = '0' AND `furniture`.`foot_figure` = '' LIMIT 1 ;
    UPDATE `ssa`.`furniture` SET `allow_marketplace_sell` = '1',
    `interaction_modes_count` = '2' WHERE `furniture`.`public_name` = 'rare_dragonvamp*1' AND `furniture`.`item_name` = 'rare_dragonvamp*1' AND `furniture`.`type` = 's' AND `furniture`.`width` =1 AND `furniture`.`length` =1 AND CONCAT( `furniture`.`stack_height` ) = '1' AND `furniture`.`can_stack` = '1' AND `furniture`.`can_sit` = '0' AND `furniture`.`is_walkable` = '0' AND `furniture`.`sprite_id` =3000005 AND `furniture`.`allow_recycle` = '0' AND `furniture`.`allow_trade` = '0' AND `furniture`.`allow_marketplace_sell` = '' AND `furniture`.`allow_gift` = '0' AND `furniture`.`allow_inventory_stack` = '1' AND `furniture`.`interaction_type` = 'default' AND `furniture`.`interaction_modes_count` =1 AND `furniture`.`vending_ids` = '0' AND `furniture`.`is_arrow` = '0' AND `furniture`.`foot_figure` = '' LIMIT 1 ;
    UPDATE `ssa`.`furniture` SET `allow_marketplace_sell` = '1',
    `interaction_modes_count` = '2' WHERE `furniture`.`public_name` = 'rare_dragonvamp*2' AND `furniture`.`item_name` = 'rare_dragonvamp*2' AND `furniture`.`type` = 's' AND `furniture`.`width` =1 AND `furniture`.`length` =1 AND CONCAT( `furniture`.`stack_height` ) = '1' AND `furniture`.`can_stack` = '1' AND `furniture`.`can_sit` = '0' AND `furniture`.`is_walkable` = '0' AND `furniture`.`sprite_id` =3000006 AND `furniture`.`allow_recycle` = '0' AND `furniture`.`allow_trade` = '0' AND `furniture`.`allow_marketplace_sell` = '' AND `furniture`.`allow_gift` = '0' AND `furniture`.`allow_inventory_stack` = '1' AND `furniture`.`interaction_type` = 'default' AND `furniture`.`interaction_modes_count` =1 AND `furniture`.`vending_ids` = '0' AND `furniture`.`is_arrow` = '0' AND `furniture`.`foot_figure` = '' LIMIT 1 ;
    UPDATE `ssa`.`furniture` SET `allow_marketplace_sell` = '1',
    `interaction_modes_count` = '2' WHERE `furniture`.`public_name` = 'rare_dragonvamp*5' AND `furniture`.`item_name` = 'rare_dragonvamp*5' AND `furniture`.`type` = 's' AND `furniture`.`width` =1 AND `furniture`.`length` =1 AND CONCAT( `furniture`.`stack_height` ) = '1' AND `furniture`.`can_stack` = '1' AND `furniture`.`can_sit` = '0' AND `furniture`.`is_walkable` = '0' AND `furniture`.`sprite_id` =3000008 AND `furniture`.`allow_recycle` = '0' AND `furniture`.`allow_trade` = '0' AND `furniture`.`allow_marketplace_sell` = '' AND `furniture`.`allow_gift` = '0' AND `furniture`.`allow_inventory_stack` = '1' AND `furniture`.`interaction_type` = 'default' AND `furniture`.`interaction_modes_count` =1 AND `furniture`.`vending_ids` = '0' AND `furniture`.`is_arrow` = '0' AND `furniture`.`foot_figure` = '' LIMIT 1 ;
    UPDATE `ssa`.`furniture` SET `allow_marketplace_sell` = '1',
    `interaction_modes_count` = '2' WHERE `furniture`.`public_name` = 'rare_dragonvamp*6' AND `furniture`.`item_name` = 'rare_dragonvamp*6' AND `furniture`.`type` = 's' AND `furniture`.`width` =1 AND `furniture`.`length` =1 AND CONCAT( `furniture`.`stack_height` ) = '1' AND `furniture`.`can_stack` = '1' AND `furniture`.`can_sit` = '0' AND `furniture`.`is_walkable` = '0' AND `furniture`.`sprite_id` =3000009 AND `furniture`.`allow_recycle` = '0' AND `furniture`.`allow_trade` = '0' AND `furniture`.`allow_marketplace_sell` = '' AND `furniture`.`allow_gift` = '0' AND `furniture`.`allow_inventory_stack` = '1' AND `furniture`.`interaction_type` = 'default' AND `furniture`.`interaction_modes_count` =1 AND `furniture`.`vending_ids` = '0' AND `furniture`.`is_arrow` = '0' AND `furniture`.`foot_figure` = '' LIMIT 1 ;
    UPDATE `ssa`.`furniture` SET `allow_marketplace_sell` = '1',
    `interaction_modes_count` = '2' WHERE `furniture`.`public_name` = 'rare_dragonvamp*7' AND `furniture`.`item_name` = 'rare_dragonvamp*7' AND `furniture`.`type` = 's' AND `furniture`.`width` =1 AND `furniture`.`length` =1 AND CONCAT( `furniture`.`stack_height` ) = '1' AND `furniture`.`can_stack` = '1' AND `furniture`.`can_sit` = '0' AND `furniture`.`is_walkable` = '0' AND `furniture`.`sprite_id` =3000010 AND `furniture`.`allow_recycle` = '0' AND `furniture`.`allow_trade` = '0' AND `furniture`.`allow_marketplace_sell` = '' AND `furniture`.`allow_gift` = '0' AND `furniture`.`allow_inventory_stack` = '1' AND `furniture`.`interaction_type` = 'default' AND `furniture`.`interaction_modes_count` =1 AND `furniture`.`vending_ids` = '0' AND `furniture`.`is_arrow` = '0' AND `furniture`.`foot_figure` = '' LIMIT 1 ;
    UPDATE `ssa`.`furniture` SET `allow_marketplace_sell` = '1',
    `interaction_modes_count` = '2' WHERE `furniture`.`public_name` = 'rare_dragonvamp*8' AND `furniture`.`item_name` = 'rare_dragonvamp*8' AND `furniture`.`type` = 's' AND `furniture`.`width` =1 AND `furniture`.`length` =1 AND CONCAT( `furniture`.`stack_height` ) = '1' AND `furniture`.`can_stack` = '1' AND `furniture`.`can_sit` = '0' AND `furniture`.`is_walkable` = '0' AND `furniture`.`sprite_id` =3000011 AND `furniture`.`allow_recycle` = '0' AND `furniture`.`allow_trade` = '0' AND `furniture`.`allow_marketplace_sell` = '' AND `furniture`.`allow_gift` = '0' AND `furniture`.`allow_inventory_stack` = '1' AND `furniture`.`interaction_type` = 'default' AND `furniture`.`interaction_modes_count` =1 AND `furniture`.`vending_ids` = '0' AND `furniture`.`is_arrow` = '0' AND `furniture`.`foot_figure` = '' LIMIT 1 ;
    UPDATE `ssa`.`furniture` SET `allow_marketplace_sell` = '1',
    `interaction_modes_count` = '2' WHERE `furniture`.`public_name` = 'rare_dragonvamp*9' AND `furniture`.`item_name` = 'rare_dragonvamp*9' AND `furniture`.`type` = 's' AND `furniture`.`width` =1 AND `furniture`.`length` =1 AND CONCAT( `furniture`.`stack_height` ) = '1' AND `furniture`.`can_stack` = '1' AND `furniture`.`can_sit` = '0' AND `furniture`.`is_walkable` = '0' AND `furniture`.`sprite_id` =3000012 AND `furniture`.`allow_recycle` = '0' AND `furniture`.`allow_trade` = '0' AND `furniture`.`allow_marketplace_sell` = '' AND `furniture`.`allow_gift` = '0' AND `furniture`.`allow_inventory_stack` = '1' AND `furniture`.`interaction_type` = 'default' AND `furniture`.`interaction_modes_count` =1 AND `furniture`.`vending_ids` = '0' AND `furniture`.`is_arrow` = '0' AND `furniture`.`foot_figure` = '' LIMIT 1 ;
    UPDATE `ssa`.`furniture` SET `allow_marketplace_sell` = '1',
    `interaction_modes_count` = '2' WHERE `furniture`.`public_name` = 'rare_dragonwa01*20' AND `furniture`.`item_name` = 'rare_dragonwa01*20' AND `furniture`.`type` = 's' AND `furniture`.`width` =1 AND `furniture`.`length` =1 AND CONCAT( `furniture`.`stack_height` ) = '1' AND `furniture`.`can_stack` = '1' AND `furniture`.`can_sit` = '0' AND `furniture`.`is_walkable` = '0' AND `furniture`.`sprite_id` =100023082 AND `furniture`.`allow_recycle` = '0' AND `furniture`.`allow_trade` = '0' AND `furniture`.`allow_marketplace_sell` = '' AND `furniture`.`allow_gift` = '0' AND `furniture`.`allow_inventory_stack` = '1' AND `furniture`.`interaction_type` = 'default' AND `furniture`.`interaction_modes_count` =1 AND `furniture`.`vending_ids` = '0' AND `furniture`.`is_arrow` = '0' AND `furniture`.`foot_figure` = '' LIMIT 1 ;
    UPDATE `ssa`.`furniture` SET `allow_marketplace_sell` = '1',
    `interaction_modes_count` = '2' WHERE `furniture`.`public_name` = 'rare_dragonwamp*20' AND `furniture`.`item_name` = 'rare_dragonwamp*20' AND `furniture`.`type` = 's' AND `furniture`.`width` =1 AND `furniture`.`length` =1 AND CONCAT( `furniture`.`stack_height` ) = '1' AND `furniture`.`can_stack` = '1' AND `furniture`.`can_sit` = '0' AND `furniture`.`is_walkable` = '0' AND `furniture`.`sprite_id` =100023054 AND `furniture`.`allow_recycle` = '0' AND `furniture`.`allow_trade` = '0' AND `furniture`.`allow_marketplace_sell` = '' AND `furniture`.`allow_gift` = '0' AND `furniture`.`allow_inventory_stack` = '1' AND `furniture`.`interaction_type` = 'default' AND `furniture`.`interaction_modes_count` =1 AND `furniture`.`vending_ids` = '0' AND `furniture`.`is_arrow` = '0' AND `furniture`.`foot_figure` = '' LIMIT 1 ;
    UPDATE `ssa`.`furniture` SET `allow_marketplace_sell` = '1',
    `interaction_modes_count` = '2' WHERE `furniture`.`public_name` = 'rare_dragofatal*20' AND `furniture`.`item_name` = 'rare_dragofatal*20' AND `furniture`.`type` = 's' AND `furniture`.`width` =1 AND `furniture`.`length` =1 AND CONCAT( `furniture`.`stack_height` ) = '1' AND `furniture`.`can_stack` = '1' AND `furniture`.`can_sit` = '0' AND `furniture`.`is_walkable` = '0' AND `furniture`.`sprite_id` =100023055 AND `furniture`.`allow_recycle` = '0' AND `furniture`.`allow_trade` = '0' AND `furniture`.`allow_marketplace_sell` = '' AND `furniture`.`allow_gift` = '0' AND `furniture`.`allow_inventory_stack` = '1' AND `furniture`.`interaction_type` = 'default' AND `furniture`.`interaction_modes_count` =1 AND `furniture`.`vending_ids` = '0' AND `furniture`.`is_arrow` = '0' AND `furniture`.`foot_figure` = '' LIMIT 1 ;
    UPDATE `ssa`.`furniture` SET `allow_marketplace_sell` = '1',
    `interaction_modes_count` = '2' WHERE `furniture`.`public_name` = 'rare_glassnlamp' AND `furniture`.`item_name` = 'rare_glassnlamp' AND `furniture`.`type` = 's' AND `furniture`.`width` =1 AND `furniture`.`length` =1 AND CONCAT( `furniture`.`stack_height` ) = '1' AND `furniture`.`can_stack` = '1' AND `furniture`.`can_sit` = '0' AND `furniture`.`is_walkable` = '0' AND `furniture`.`sprite_id` =1000009 AND `furniture`.`allow_recycle` = '0' AND `furniture`.`allow_trade` = '0' AND `furniture`.`allow_marketplace_sell` = '' AND `furniture`.`allow_gift` = '0' AND `furniture`.`allow_inventory_stack` = '1' AND `furniture`.`interaction_type` = 'default' AND `furniture`.`interaction_modes_count` =1 AND `furniture`.`vending_ids` = '0' AND `furniture`.`is_arrow` = '0' AND `furniture`.`foot_figure` = '' LIMIT 1 ;

    Hey
    da ich schon seit langem auf der Suche nach einem Fix für die Customs bin, bin ich über diese Seite gestolpert : Fix de drakos Custom [SQL]
    Übersetzt :

    MONTAGE:
    -Kopieren Sie den Text in eine Editor und ersetzen Sie "km2" (ohne Anführungszeichen) in den Namen Ihres db
    -Setzen Sie den Code und setzen Sie den Befehl site: update_items
    - Erfolg! Drakos Fixeados!

    hab es gemacht aber er gibt noch ein Error

    Code :

    SQL
    UPDATE  `ssa`.`furniture` SET  `allow_marketplace_sell` =  '1',`interaction_modes_count` =  '2' WHERE  `furniture`.`public_name` =  'rare_dragonvamp*4' AND  `furniture`.`item_name` =  'rare_dragonvamp*4' AND  `furniture`.`type` =  's' AND  `furniture`.`width` =1 AND  `furniture`.`length` =1 AND CONCAT(  `furniture`.`stack_height` ) =  '1' AND  `furniture`.`can_stack` =  '1' AND  `furniture`.`can_sit` =  '0' AND  `furniture`.`is_walkable` =  '0' AND `furniture`.`sprite_id` =3000007 AND  `furniture`.`allow_recycle` =  '0' AND  `furniture`.`allow_trade` =  '0' AND  `furniture`.`allow_marketplace_sell` =  '' AND  `furniture`.`allow_gift` =  '0' AND `furniture`.`allow_inventory_stack` =  '1' AND  `furniture`.`interaction_type` =  'default' AND  `furniture`.`interaction_modes_count` =1 AND  `furniture`.`vending_ids` =  '0' AND  `furniture`.`is_arrow` =  '0' AND  `furniture`.`foot_figure` =  '' LIMIT 1 ;UPDATE  `ssa`.`furniture` SET  `allow_marketplace_sell` =  '1',`interaction_modes_count` =  '2' WHERE  `furniture`.`public_name` =  'rare_dragonvamp*0' AND  `furniture`.`item_name` =  'rare_dragonvamp*0' AND  `furniture`.`type` =  's' AND  `furniture`.`width` =1 AND  `furniture`.`length` =1 AND CONCAT(  `furniture`.`stack_height` ) =  '1' AND  `furniture`.`can_stack` =  '1' AND  `furniture`.`can_sit` =  '0' AND  `furniture`.`is_walkable` =  '0' AND `furniture`.`sprite_id` =3000004 AND  `furniture`.`allow_recycle` =  '0' AND  `furniture`.`allow_trade` =  '0' AND  `furniture`.`allow_marketplace_sell` =  '' AND  `furniture`.`allow_gift` =  '0' AND `furniture`.`allow_inventory_stack` =  '1' AND  `furniture`.`interaction_type` =  'default' AND  `furniture`.`interaction_modes_count` =1 AND  `furniture`.`vending_ids` =  '0' AND  `furniture`.`is_arrow` =  '0' AND  `furniture`.`foot_figure` =  '' LIMIT 1 ;UPDATE  `ssa`.`furniture` SET  `allow_marketplace_sell` =  '1',`interaction_modes_count` =  '2' WHERE  `furniture`.`public_name` =  'rare_dragonvamp*1' AND  `furniture`.`item_name` =  'rare_dragonvamp*1' AND  `furniture`.`type` =  's' AND  `furniture`.`width` =1 AND  `furniture`.`length` =1 AND CONCAT(  `furniture`.`stack_height` ) =  '1' AND  `furniture`.`can_stack` =  '1' AND  `furniture`.`can_sit` =  '0' AND  `furniture`.`is_walkable` =  '0' AND `furniture`.`sprite_id` =3000005 AND  `furniture`.`allow_recycle` =  '0' AND  `furniture`.`allow_trade` =  '0' AND  `furniture`.`allow_marketplace_sell` =  '' AND  `furniture`.`allow_gift` =  '0' AND `furniture`.`allow_inventory_stack` =  '1' AND  `furniture`.`interaction_type` =  'default' AND  `furniture`.`interaction_modes_count` =1 AND  `furniture`.`vending_ids` =  '0' AND  `furniture`.`is_arrow` =  '0' AND  `furniture`.`foot_figure` =  '' LIMIT 1 ;UPDATE  `ssa`.`furniture` SET  `allow_marketplace_sell` =  '1',`interaction_modes_count` =  '2' WHERE  `furniture`.`public_name` =  'rare_dragonvamp*2' AND  `furniture`.`item_name` =  'rare_dragonvamp*2' AND  `furniture`.`type` =  's' AND  `furniture`.`width` =1 AND  `furniture`.`length` =1 AND CONCAT(  `furniture`.`stack_height` ) =  '1' AND  `furniture`.`can_stack` =  '1' AND  `furniture`.`can_sit` =  '0' AND  `furniture`.`is_walkable` =  '0' AND `furniture`.`sprite_id` =3000006 AND  `furniture`.`allow_recycle` =  '0' AND  `furniture`.`allow_trade` =  '0' AND  `furniture`.`allow_marketplace_sell` =  '' AND  `furniture`.`allow_gift` =  '0' AND `furniture`.`allow_inventory_stack` =  '1' AND  `furniture`.`interaction_type` =  'default' AND  `furniture`.`interaction_modes_count` =1 AND  `furniture`.`vending_ids` =  '0' AND  `furniture`.`is_arrow` =  '0' AND  `furniture`.`foot_figure` =  '' LIMIT 1 ;UPDATE  `ssa`.`furniture` SET  `allow_marketplace_sell` =  '1',`interaction_modes_count` =  '2' WHERE  `furniture`.`public_name` =  'rare_dragonvamp*5' AND  `furniture`.`item_name` =  'rare_dragonvamp*5' AND  `furniture`.`type` =  's' AND  `furniture`.`width` =1 AND  `furniture`.`length` =1 AND CONCAT(  `furniture`.`stack_height` ) =  '1' AND  `furniture`.`can_stack` =  '1' AND  `furniture`.`can_sit` =  '0' AND  `furniture`.`is_walkable` =  '0' AND `furniture`.`sprite_id` =3000008 AND  `furniture`.`allow_recycle` =  '0' AND  `furniture`.`allow_trade` =  '0' AND  `furniture`.`allow_marketplace_sell` =  '' AND  `furniture`.`allow_gift` =  '0' AND `furniture`.`allow_inventory_stack` =  '1' AND  `furniture`.`interaction_type` =  'default' AND  `furniture`.`interaction_modes_count` =1 AND  `furniture`.`vending_ids` =  '0' AND  `furniture`.`is_arrow` =  '0' AND  `furniture`.`foot_figure` =  '' LIMIT 1 ;UPDATE  `ssa`.`furniture` SET  `allow_marketplace_sell` =  '1',`interaction_modes_count` =  '2' WHERE  `furniture`.`public_name` =  'rare_dragonvamp*6' AND  `furniture`.`item_name` =  'rare_dragonvamp*6' AND  `furniture`.`type` =  's' AND  `furniture`.`width` =1 AND  `furniture`.`length` =1 AND CONCAT(  `furniture`.`stack_height` ) =  '1' AND  `furniture`.`can_stack` =  '1' AND  `furniture`.`can_sit` =  '0' AND  `furniture`.`is_walkable` =  '0' AND `furniture`.`sprite_id` =3000009 AND  `furniture`.`allow_recycle` =  '0' AND  `furniture`.`allow_trade` =  '0' AND  `furniture`.`allow_marketplace_sell` =  '' AND  `furniture`.`allow_gift` =  '0' AND `furniture`.`allow_inventory_stack` =  '1' AND  `furniture`.`interaction_type` =  'default' AND  `furniture`.`interaction_modes_count` =1 AND  `furniture`.`vending_ids` =  '0' AND  `furniture`.`is_arrow` =  '0' AND  `furniture`.`foot_figure` =  '' LIMIT 1 ;UPDATE  `ssa`.`furniture` SET  `allow_marketplace_sell` =  '1',`interaction_modes_count` =  '2' WHERE  `furniture`.`public_name` =  'rare_dragonvamp*7' AND  `furniture`.`item_name` =  'rare_dragonvamp*7' AND  `furniture`.`type` =  's' AND  `furniture`.`width` =1 AND  `furniture`.`length` =1 AND CONCAT(  `furniture`.`stack_height` ) =  '1' AND  `furniture`.`can_stack` =  '1' AND  `furniture`.`can_sit` =  '0' AND  `furniture`.`is_walkable` =  '0' AND `furniture`.`sprite_id` =3000010 AND  `furniture`.`allow_recycle` =  '0' AND  `furniture`.`allow_trade` =  '0' AND  `furniture`.`allow_marketplace_sell` =  '' AND  `furniture`.`allow_gift` =  '0' AND `furniture`.`allow_inventory_stack` =  '1' AND  `furniture`.`interaction_type` =  'default' AND  `furniture`.`interaction_modes_count` =1 AND  `furniture`.`vending_ids` =  '0' AND  `furniture`.`is_arrow` =  '0' AND  `furniture`.`foot_figure` =  '' LIMIT 1 ;UPDATE  `ssa`.`furniture` SET  `allow_marketplace_sell` =  '1',`interaction_modes_count` =  '2' WHERE  `furniture`.`public_name` =  'rare_dragonvamp*8' AND  `furniture`.`item_name` =  'rare_dragonvamp*8' AND  `furniture`.`type` =  's' AND  `furniture`.`width` =1 AND  `furniture`.`length` =1 AND CONCAT(  `furniture`.`stack_height` ) =  '1' AND  `furniture`.`can_stack` =  '1' AND  `furniture`.`can_sit` =  '0' AND  `furniture`.`is_walkable` =  '0' AND `furniture`.`sprite_id` =3000011 AND  `furniture`.`allow_recycle` =  '0' AND  `furniture`.`allow_trade` =  '0' AND  `furniture`.`allow_marketplace_sell` =  '' AND  `furniture`.`allow_gift` =  '0' AND `furniture`.`allow_inventory_stack` =  '1' AND  `furniture`.`interaction_type` =  'default' AND  `furniture`.`interaction_modes_count` =1 AND  `furniture`.`vending_ids` =  '0' AND  `furniture`.`is_arrow` =  '0' AND  `furniture`.`foot_figure` =  '' LIMIT 1 ;UPDATE  `ssa`.`furniture` SET  `allow_marketplace_sell` =  '1',`interaction_modes_count` =  '2' WHERE  `furniture`.`public_name` =  'rare_dragonvamp*9' AND  `furniture`.`item_name` =  'rare_dragonvamp*9' AND  `furniture`.`type` =  's' AND  `furniture`.`width` =1 AND  `furniture`.`length` =1 AND CONCAT(  `furniture`.`stack_height` ) =  '1' AND  `furniture`.`can_stack` =  '1' AND  `furniture`.`can_sit` =  '0' AND  `furniture`.`is_walkable` =  '0' AND `furniture`.`sprite_id` =3000012 AND  `furniture`.`allow_recycle` =  '0' AND  `furniture`.`allow_trade` =  '0' AND  `furniture`.`allow_marketplace_sell` =  '' AND  `furniture`.`allow_gift` =  '0' AND `furniture`.`allow_inventory_stack` =  '1' AND  `furniture`.`interaction_type` =  'default' AND  `furniture`.`interaction_modes_count` =1 AND  `furniture`.`vending_ids` =  '0' AND  `furniture`.`is_arrow` =  '0' AND  `furniture`.`foot_figure` =  '' LIMIT 1 ;UPDATE  `ssa`.`furniture` SET  `allow_marketplace_sell` =  '1',`interaction_modes_count` =  '2' WHERE  `furniture`.`public_name` =  'rare_dragonwa01*20' AND  `furniture`.`item_name` =  'rare_dragonwa01*20' AND  `furniture`.`type` =  's' AND  `furniture`.`width` =1 AND  `furniture`.`length` =1 AND CONCAT(  `furniture`.`stack_height` ) =  '1' AND  `furniture`.`can_stack` =  '1' AND  `furniture`.`can_sit` =  '0' AND  `furniture`.`is_walkable` =  '0' AND `furniture`.`sprite_id` =100023082 AND  `furniture`.`allow_recycle` =  '0' AND  `furniture`.`allow_trade` =  '0' AND  `furniture`.`allow_marketplace_sell` =  '' AND  `furniture`.`allow_gift` =  '0' AND `furniture`.`allow_inventory_stack` =  '1' AND  `furniture`.`interaction_type` =  'default' AND  `furniture`.`interaction_modes_count` =1 AND  `furniture`.`vending_ids` =  '0' AND  `furniture`.`is_arrow` =  '0' AND  `furniture`.`foot_figure` =  '' LIMIT 1 ;UPDATE  `ssa`.`furniture` SET  `allow_marketplace_sell` =  '1',`interaction_modes_count` =  '2' WHERE  `furniture`.`public_name` =  'rare_dragonwamp*20' AND  `furniture`.`item_name` =  'rare_dragonwamp*20' AND  `furniture`.`type` =  's' AND  `furniture`.`width` =1 AND  `furniture`.`length` =1 AND CONCAT(  `furniture`.`stack_height` ) =  '1' AND  `furniture`.`can_stack` =  '1' AND  `furniture`.`can_sit` =  '0' AND  `furniture`.`is_walkable` =  '0' AND `furniture`.`sprite_id` =100023054 AND  `furniture`.`allow_recycle` =  '0' AND  `furniture`.`allow_trade` =  '0' AND  `furniture`.`allow_marketplace_sell` =  '' AND  `furniture`.`allow_gift` =  '0' AND `furniture`.`allow_inventory_stack` =  '1' AND  `furniture`.`interaction_type` =  'default' AND  `furniture`.`interaction_modes_count` =1 AND  `furniture`.`vending_ids` =  '0' AND  `furniture`.`is_arrow` =  '0' AND  `furniture`.`foot_figure` =  '' LIMIT 1 ;UPDATE  `ssa`.`furniture` SET  `allow_marketplace_sell` =  '1',`interaction_modes_count` =  '2' WHERE  `furniture`.`public_name` =  'rare_dragofatal*20' AND  `furniture`.`item_name` =  'rare_dragofatal*20' AND  `furniture`.`type` =  's' AND  `furniture`.`width` =1 AND  `furniture`.`length` =1 AND CONCAT(  `furniture`.`stack_height` ) =  '1' AND  `furniture`.`can_stack` =  '1' AND  `furniture`.`can_sit` =  '0' AND  `furniture`.`is_walkable` =  '0' AND `furniture`.`sprite_id` =100023055 AND  `furniture`.`allow_recycle` =  '0' AND  `furniture`.`allow_trade` =  '0' AND  `furniture`.`allow_marketplace_sell` =  '' AND  `furniture`.`allow_gift` =  '0' AND `furniture`.`allow_inventory_stack` =  '1' AND  `furniture`.`interaction_type` =  'default' AND  `furniture`.`interaction_modes_count` =1 AND  `furniture`.`vending_ids` =  '0' AND  `furniture`.`is_arrow` =  '0' AND  `furniture`.`foot_figure` =  '' LIMIT 1 ;UPDATE  `ssa`.`furniture` SET  `allow_marketplace_sell` =  '1',`interaction_modes_count` =  '2' WHERE  `furniture`.`public_name` =  'rare_glassnlamp' AND  `furniture`.`item_name` =  'rare_glassnlamp' AND  `furniture`.`type` =  's' AND  `furniture`.`width` =1 AND  `furniture`.`length` =1 AND CONCAT(  `furniture`.`stack_height` ) =  '1' AND  `furniture`.`can_stack` =  '1' AND  `furniture`.`can_sit` =  '0' AND  `furniture`.`is_walkable` =  '0' AND `furniture`.`sprite_id` =1000009 AND  `furniture`.`allow_recycle` =  '0' AND  `furniture`.`allow_trade` =  '0' AND  `furniture`.`allow_marketplace_sell` =  '' AND  `furniture`.`allow_gift` =  '0' AND `furniture`.`allow_inventory_stack` =  '1' AND  `furniture`.`interaction_type` =  'default' AND  `furniture`.`interaction_modes_count` =1 AND  `furniture`.`vending_ids` =  '0' AND  `furniture`.`is_arrow` =  '0' AND  `furniture`.`foot_figure` =  '' LIMIT 1 ;


    Error Code :

    SQL
    SQL-Befehl:UPDATE `ssa`.`furniture` SET `allow_marketplace_sell` = '1',
    `interaction_modes_count` = '2' WHERE `furniture`.`public_name` = 'rare_dragonvamp*4' AND `furniture`.`item_name` = 'rare_dragonvamp*4' AND `furniture`.`type` = 's' AND`furniture`.`width` =1 AND `furniture`.`length` =1 AND CONCAT( `furniture`.`stack_height` ) = '1' AND `furniture`.`can_stack` = '1' AND `furniture`.`can_sit` = '0' AND`furniture`.`is_walkable` = '0' AND `furniture`.`sprite_id` =3000007 AND `furniture`.`allow_recycle` = '0' AND `furniture`.`allow_trade` = '0' AND `furniture`.`allow_marketplace_sell` = ''AND `furniture`.`allow_gift` = '0' AND `furniture`.`allow_inventory_stack` = '1' AND `furniture`.`interaction_type` = 'default' AND `furniture`.`interaction_modes_count` =1 AND`furniture`.`vending_ids` = '0' AND `furniture`.`is_arrow` = '0' AND `furniture`.`foot_figure` = '' LIMIT 1 ;
    
    
    MySQL meldet: #1054 - Unknown column 'furniture.foot_figure' in 'where clause'


    hoffe auf Hilfe :D

    Customs :
    Möbel Pack !
    Problem : Doppelklick und nichts passiert also Keine Flammen, Schirm geht nicht auf etc.

    Bitte keine unnötige Kommentare

    Hey

    ich suche schon seit längerem Custom Drachen
    ich hatte schon dieses Möbel Pack ! aber da gingen die Flamen nicht ( Pascal meinte es liegt an den SWF's)
    Hat jemand ein Pack mit verschiedenen Drachen und FUNKTIONIERENDEN SWF's + sql & so ^^

    Ps : kommt nicht mit : SuFu, Google etc. hab schon geschaut da gingen die Drachen auch nicht :(
    Also wer nichts hat einfach nichts posten :whistling: