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
Customs :
Möbel Pack !
Problem : Doppelklick und nichts passiert also Keine Flammen, Schirm geht nicht auf etc.
Bitte keine unnötige Kommentare