Pesquisar na Comunidade

Olá, Venho agora mesmo lhes pedir para verificar o porque de não aparecer os cast no PHP. Query para verificação: e PHP cast completo: Verifiquem se a algum erro nesta parte por favor, se for o caso de mudar o SQL me ajudem. Obrigado a todos que me ajudarem.

Preciso de uma, no caso creio que uma globalevents, que delete o item id 2187, em 30 em 30 minutos, para o pessoal ai que conhece e mole. aguardar aqui, valeu, a sim quero que delete do Player, da house, e do depot. Isso tudo com o servidor online.

Boa noite pessoal, aqui estou com dificuldade para achar uma Query que adicione a todos Depot de todos players do servidor 1 Item. entao se alguem que entenda melhor de sql aqui, uma query para add a todos do servidor na tabela Player_depotitems.

alguém sabe resolver? [23/1/2016 9:34:50] mysql_real_query(): INSERT INTO `house_lists` (`house_id`, `world_id`, `listid`, `list`) VALUES (374, 0, 256, 'Gzuis') - MYSQL ERROR: Cannot add or update a child row: a foreign key constraint fails (`god`.`house_lists`, CONSTRAINT `house_lists_ibfk_1` FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses` (`id`, `world_id`) ON DELETE CASCADE) (1452) [23/1/2016 9:34:50] mysql_real_query(): INSERT INTO `house_lists` (`house_id`, `world_id`, `listid`, `list`) VALUES (407, 0, 257, 'lolas') - MYSQL ERROR: Cannot add or update a child row: a foreign key constraint fails (`god`.`house_lists`, CONSTRAINT `house_lists_ibfk_1` FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses` (`id`, `world_id`) ON DELETE CASCADE) (1452) [23/1/2016 9:34:50] mysql_real_query(): INSERT INTO `house_data` (`house_id`, `world_id`, `data`) VALUES (369, 0, '°\0&\0\0\0\0%€\0\0descriptionG\0\0\0It belongs to house \'Unnamed House #369\'. Dyos Dbronks owns this house.\0doorid\0\0\0\0±\0%\0\0\0\0Ú€\0\0description\0\0\0Nobody is sleeping there.\0±\0&\0\0\0\0Û€\0\0description\0\0\0Nobody is sleeping there.\0µ\0%\0\0\0\0Ú€\0\0description\0\0\0Nobody is sleeping there.\0µ\0&\0\0\0\0Û€\0\0description\0\0\0Nobody is sleeping there.\0¶\0&\0\0\0\0%€\0\0descriptionG\0\0\0It belongs to house \'Unnamed House #369\'. Dyos Dbronks owns this house.\0doorid\0\0\0\0°\0(\0\0\0\0À\0\0descriptionG\0\0\0It belongs to house \'Unnamed House #369\'. Dyos Dbronks owns this house.\0doorid\0\0\0\0°\0)\0\0\0\0%€\0\0descriptionG\0\0\0It belongs to house \'Unnamed House #369\'. Dyos Dbronks owns this house.\0doorid\0\0\0\0²\0*\0\0\0\0$€\0\0descriptionG\0\0\0It belongs to house \'Unnamed House #369\'. Dyos Dbronks owns this house.\0doorid\0\0\0\0µ\0*\0\0\0\0$€\0\0descriptionG\0\0\0It belongs to house \'Unnamed House #369\'. Dyos Dbronks owns this house.\0doorid\0\0\0\0¶\0)\0\0\0\0%€\0\0descriptionG\0\0\0It belongs to house \'Unnamed House #369\'. Dyos Dbronks owns this house.\0doorid\0\0\0\0'),(370, 0, '±\0\0\0\0\0Ú€\0\0description\0\0\0Nobody is sleeping there.\0µ\0\0\0\0\0Ú€\0\0description\0\0\0Nobody is sleeping there.\0°\0 \0\0\0\0%€\0\0descriptionA\0\0\0It belongs to house \'Unnamed House #370\'. Blayde owns this house.\0doorid\0\0\0\0°\0\"\0\0\0\0Ä€\0\0descriptionA\0\0\0It belongs to house \'Unnamed House #370\'. Blayde owns this house.\0doorid\0\0\0\0°\0#\0\0\0\0%€\0\0descriptionA\0\0\0It belongs to house \'Unnamed House #370\'. Blayde owns this house.\0doorid\0\0\0\0±\0 \0\0\0\0Û€\0\0description\0\0\0Nobody is sleeping there.\0²\0\"\0\0\0\0W\n\0³\0 \0\0\0\0™ \0³\0!\0\0\0\0Ÿ \0³\0\"\0\0\0\0W\n\0µ\0 \0\0\0\0Û€\0\0description\0\0\0Nobody is sleeping there.\0¶\0 \0\0\0\0%€\0\0descriptionA\0\0\0It belongs to house \'Unnamed House #370\'. Blayde owns this house.\0doorid\0\0\0\0¶\0#\0\0\0\0%€\0\0descriptionA\0\0\0It belongs to house \'Unnamed House #370\'. Blayde owns this house.\0doorid\0\0\0\0'),(371, 0, '°\0\Z\0\0\0\0%€\0\0descriptionD\0\0\0It belongs to house \'Unnamed House #371\'. Fodastiko owns this house.\0doorid\0\0\0\0±\0\0\0\0\0Ú€\0\0description\0\0\0Nobody is sleeping there.\0±\0\Z\0\0\0\0Û€\0\0description\0\0\0Nobody is sleeping there.\0±\0\0\0\0\0½ \0pd\0²\0\0\0\0\0$€\0\0descriptionD\0\0\0It belongs to house \'Unnamed House #371\'. Fodastiko owns this house.\0doorid\0\0\0\0²\0\0\0\0\0Ç\"\0pd\0m\0²\0\Z\0\0\0\0½ \0pd\0m\0²\0\0\0\0\0¾ \0pd\0m\0³\0\0\0\0\0· \0¸ \0z\0p2\0m\0³\0\Z\0\0\0\0½ \0pd\0V \0m\0³\0\0\0\0\0¾ \0pI\0m\0´\0\0\0\0\0Ç\"\0¥\0pd\0m\0´\0\Z\0\0\0\0½ \0pd\0m\0´\0\0\0\0\0¾ \0pd\0µ\0\0\0\0\0$€\0\0descriptionD\0\0\0It belongs to house \'Unnamed House #371\'. Fodastiko owns this house.\0doorid\0\0\0\0µ\0\0\0\0\0Ú€\0\0description\0\0\0Nobody is sleeping there.\0µ\0\Z\0\0\0\0Û€\0\0description\0\0\0Nobody is sleeping there.\0µ\0\0\0\0\0½ \0pd\0¶\0\Z\0\0\0\0%€\0\0descriptionD\0\0\0It belongs to house \'Unnamed House #371\'. Fodastiko owns this house.\0doorid\0\0\0\0°\0\0\0\0\0À\0\0descriptionD\0\0\0It belongs to house \'Unnamed House #371\'. Fodastiko owns this house.\0doorid\0\0\0\0°\0\0\0\0\0%€\0\0descriptionD\0\0\0It belongs to house \'Unnamed House #371\'. Fodastiko owns this house.\0doorid\0\0\0\0±\0\0\0\0\0¨ \0pd\0²\0\0\0\0\0¿ \0pd\0²\0\0\0\0\0U\n\0pd\0³\0\0\0\0\0¥ \0pd\0³\0\0\0\0\0%\'\0pd\0´\0\0\0\0\0Ö\0p<\0´\0\0\0\0\0U\n\0pd\0µ\0\0\0\0\0¨ \0pd\0µ\0\0\0\0\0Ö\0p2\0¶\0\0\0\0\0%€\0\0descriptionD\0\0\0It belongs to house \'Unnamed House #371\'. Fodastiko owns this house.\0doorid\0\0\0\0'),(372, 0, '°\0&\0\0\0\0Ä€\0\0description>\0\0\0It belongs to house \'Unnamed House #372\'. Poi owns this house.\0doorid\0\0\0\0°\0\'\0\0\0\0%€\0\0description>\0\0\0It belongs to house \'Unnamed House #372\'. Poi owns this house.\0doorid\0\0\0\0¶\0&\0\0\0\0%€\0\0description>\0\0\0It belongs to house \'Unnamed House #372\'. Poi owns this house.\0doorid\0\0\0\0°\0)\0\0\0\0%€\0\0description>\0\0\0It belongs to house \'Unnamed House #372\'. Poi owns this house.\0doorid\0\0\0\0±\0(\0\0\0\0Ú€\0\0description\0\0\0Nobody is sleeping there.\0±\0)\0\0\0\0Û€\0\0description\0\0\0Nobody is sleeping there.\0²\0*\0\0\0\0$€\0\0description>\0\0\0It belongs to house \'Unnamed House #372\'. Poi owns this house.\0doorid\0\0\0\0µ\0(\0\0\0\0Ú€\0\0description\0\0\0Nobody is sleeping there.\0µ\0)\0\0\0\0Û€\0\0description\0\0\0Nobody is sleeping there.\0µ\0*\0\0\0\0$€\0\0description>\0\0\0It belongs to house \'Unnamed House #372\'. Poi owns this house.\0doorid\0\0\0\0¶\0)\0\0\0\0%€\0\0description>\0\0\0It belongs to house \'Unnamed House #372\'. Poi owns this house.\0doorid\0\0\0\0'),(373, 0, '±\0\0\0\0\0Ú€\0\0description\0\0\0Nobody is sleeping there.\0²\0\0\0\0\0º\"\0m\0p2\0m\0³\0\0\0\0\0p2\0ä\0m\0´\0\0\0\0\0p2\0m\0µ\0\0\0\0\0â€\0\0description!\0\0\0Chapelero Loko is sleeping there.\n\0sleepstartí_”Vä\0\0\0°\0\"\0\0\0\0Ä€\0\0descriptionE\0\0\0It belongs to house \'Unnamed House #373\'. Mage Frits owns this house.\0doorid\0\0\0\0±\0 \0\0\0\0Û€\0\0description\0\0\0Nobody is sleeping there.\0±\0\"\0\0\0\0Ø \0&\'\00\"\0±\0#\0\0\0\0¥ \0%\0d\0²\0 \0\0\0\0É\"\0â\"\09 \0d\0²\0!\0\0\0\0½ \0\0²\0\"\0\0\0\0²\"\0¥ \0™\"\0²\0#\0\0\0\0p2\0m\0Ç\"\0³\0 \0\0\0\0½ \0_\0³\0!\0\0\0\0¨ \0Å\"\0³\0\"\0\0\0\0¦ \0ƒ\0³\0#\0\0\0\0p2\0ô\0m\0´\0 \0\0\0\0`\n\0ù\0”\"\0d\0´\0!\0\0\0\0Ò \0È\0´\0\"\0\0\0\0€ \0\0d\0´\0#\0\0\0\0p2\0m\0µ\0 \0\0\0\0ã€\0\0description!\0\0\0Chapelero Loko is sleeping there.\n\0sleepstartí_”Vä\0\0\0µ\0!\0\0\0\0¿ \0B\0¥\0µ\0\"\0\0\0\0¨ \0Í&\0µ\0#\0\0\0\0Ÿ\0¶\0 \0\0\0\0%€\0\0descriptionE\0\0\0It belongs to house \'Unnamed House #373\'. Mage Frits owns this house.\0doorid\0\0\0\0¶\0#\0\0\0\0%€\0\0descriptionE\0\0\0It belongs to house \'Unnamed House #373\'. Mage Frits owns this house.\0doorid\0\0\0\0'),(374, 0, '°\0\Z\0\0\0\0%€\0\0description@\0\0\0It belongs to house \'Unnamed House #374\'. Tpain owns this house.\0doorid\0\0\0\0±\0\0\0\0\0Ú€\0\0description\0\0\0Nobody is sleeping there.\0±\0\Z\0\0\0\0Û€\0\0description\0\0\0Nobody is sleeping there.\0²\0\0\0\0\0$€\0\0description@\0\0\0It belongs to house \'Unnamed House #374\'. Tpain owns this house.\0doorid\0\0\0\0²\0\0\0\0\0™\"\0Å\0Ä\0²\0\Z\0\0\0\0%\0²\0\0\0\0\0i1€\0\0aid*\0\0\0description8\0\0\0This item was purchased at the shop by the player Tpain.\0³\0\0\0\0\0= \0\0\0\0\0³\0\0\0\0\0ð\0´\0\0\0\0\09 \0´\0\Z\0\0\0\0Ÿ\0´\0\0\0\0\0²\"\0µ\0\0\0\0\0$€\0\0description@\0\0\0It belongs to house \'Unnamed House #374\'. Tpain owns this house.\0doorid\0\0\0\0µ\0\0\0\0\0Ú€\0\0description\0\0\0Nobody is sleeping there.\0µ\0\Z\0\0\0\0Û€\0\0description\0\0\0Nobody is sleeping there.\0µ\0\0\0\0\0ó&\0¶\0\Z\0\0\0\0%€\0\0description@\0\0\0It belongs to house \'Unnamed House #374\'. Tpain owns this house.\0doorid\0\0\0\0°\0\0\0\0\0%€\0\0description@\0\0\0It belongs to house \'Unnamed House #374\'. Tpain owns this house.\0doorid\0\0\0\0°\0\0\0\0\0Ä€\0\0description@\0\0\0It belongs to house \'Unnamed House #374\'. Tpain owns this house.\0doorid\0\0\0\0²\0\0\0\0\0V \0³\0\0\0\0\0ù\0´\0\0\0\0\0Ö\0´\0\0\0\0\0Í&\0µ\0\0\0\0\0\0¶\0\0\0\0\0%€\0\0description@\0\0\0It belongs to house \'Unnamed House #374\'. Tpain owns this house.\0doorid\0\0\0\0'),(375, 0, 'Á\0\'\0\0\0\0%€\0\0description?\0\0\0It belongs to house \'Unnamed House #375\'. Uaix owns this house.\0doorid\0\0\0\0Â\0%\0\0\0\0Ú€\0\0description\0\0\0Nobody is sleeping there.\0Â\0&\0\0\0\0Û€\0\0description\0\0\0Nobody is sleeping there.\0Ç\0\'\0\0\0\0%€\0\0description?\0\0\0It belongs to house \'Unnamed House #375\'. Uaix owns this house.\0doorid \0\0\0\0Á\0)\0\0\0\0%€\0\0description?\0\0\0It belongs to house \'Unnamed House #375\'. Uaix owns this house.\0doorid\0\0\0\0Â\0+\0\0\0\0$€\0\0description?\0\0\0It belongs to house \'Unnamed House #375\'. Uaix owns this house.\0doorid\0\0\0\0Ä\0+\0\0\0\0$€\0\0description?\0\0\0It belongs to house \'Unnamed House #375\'. Uaix owns this house.\0doorid\0\0\0\0Æ\0+\0\0\0\0$€\0\0description?\0\0\0It belongs to house \'Unnamed House #375\'. Uaix owns this house.\0doorid\0\0\0\0Ç\0)\0\0\0\0À\0\0description?\0\0\0It belongs to house \'Unnamed House #375\'. Uaix owns this house.\0doorid\0\0\0\0Ç\0*\0\0\0\0%€\0\0description?\0\0\0It belongs to house \'Unnamed House #375\'. Uaix owns this house.\0doorid\0\0\0\0') - MYSQL ERROR: Cannot add or update a child row: a foreign key constraint fails (`god`.`house_data`, CONSTRAINT `house_data_ibfk_1` FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses` (`id`, `world_id`) ON DELETE CASCADE) (1452) [23/1/2016 9:34:50] mysql_real_query(): INSERT INTO `house_data` (`house_id`, `world_id`, `data`) VALUES (369, 0, '°\0&\0\0\0\0%€\0\0descriptionG\0\0\0It belongs to house \'Unnamed House #369\'. Dyos Dbronks owns this house.\0doorid\0\0\0\0±\0%\0\0\0\0Ú€\0\0description\0\0\0Nobody is sleeping there.\0±\0&\0\0\0\0Û€\0\0description\0\0\0Nobody is sleeping there.\0µ\0%\0\0\0\0Ú€\0\0description\0\0\0Nobody is sleeping there.\0µ\0&\0\0\0\0Û€\0\0description\0\0\0Nobody is sleeping there.\0¶\0&\0\0\0\0%€\0\0descriptionG\0\0\0It belongs to house \'Unnamed House #369\'. Dyos Dbronks owns this house.\0doorid\0\0\0\0°\0(\0\0\0\0À\0\0descriptionG\0\0\0It belongs to house \'Unnamed House #369\'. Dyos Dbronks owns this house.\0doorid\0\0\0\0°\0)\0\0\0\0%€\0\0descriptionG\0\0\0It belongs to house \'Unnamed House #369\'. Dyos Dbronks owns this house.\0doorid\0\0\0\0²\0*\0\0\0\0$€\0\0descriptionG\0\0\0It belongs to house \'Unnamed House #369\'. Dyos Dbronks owns this house.\0doorid\0\0\0\0µ\0*\0\0\0\0$€\0\0descriptionG\0\0\0It belongs to house \'Unnamed House #369\'. Dyos Dbronks owns this house.\0doorid\0\0\0\0¶\0)\0\0\0\0%€\0\0descriptionG\0\0\0It belongs to house \'Unnamed House #369\'. Dyos Dbronks owns this house.\0doorid\0\0\0\0'),(370, 0, '±\0\0\0\0\0Ú€\0\0description\0\0\0Nobody is sleeping there.\0µ\0\0\0\0\0Ú€\0\0description\0\0\0Nobody is sleeping there.\0°\0 \0\0\0\0%€\0\0descriptionA\0\0\0It belongs to house \'Unnamed House #370\'. Blayde owns this house.\0doorid\0\0\0\0°\0\"\0\0\0\0Ä€\0\0descriptionA\0\0\0It belongs to house \'Unnamed House #370\'. Blayde owns this house.\0doorid\0\0\0\0°\0#\0\0\0\0%€\0\0descriptionA\0\0\0It belongs to house \'Unnamed House #370\'. Blayde owns this house.\0doorid\0\0\0\0±\0 \0\0\0\0Û€\0\0description\0\0\0Nobody is sleeping there.\0²\0\"\0\0\0\0W\n\0³\0 \0\0\0\0™ \0³\0!\0\0\0\0Ÿ \0³\0\"\0\0\0\0W\n\0µ\0 \0\0\0\0Û€\0\0description\0\0\0Nobody is sleeping there.\0¶\0 \0\0\0\0%€\0\0descriptionA\0\0\0It belongs to house \'Unnamed House #370\'. Blayde owns this house.\0doorid\0\0\0\0¶\0#\0\0\0\0%€\0\0descriptionA\0\0\0It belongs to house \'Unnamed House #370\'. Blayde owns this house.\0doorid\0\0\0\0'),(371, 0, '°\0\Z\0\0\0\0%€\0\0descriptionD\0\0\0It belongs to house \'Unnamed House #371\'. Fodastiko owns this house.\0doorid\0\0\0\0±\0\0\0\0\0Ú€\0\0description\0\0\0Nobody is sleeping there.\0±\0\Z\0\0\0\0Û€\0\0description\0\0\0Nobody is sleeping there.\0±\0\0\0\0\0½ \0pd\0²\0\0\0\0\0$€\0\0descriptionD\0\0\0It belongs to house \'Unnamed House #371\'. Fodastiko owns this house.\0doorid\0\0\0\0²\0\0\0\0\0Ç\"\0pd\0m\0²\0\Z\0\0\0\0½ \0pd\0m\0²\0\0\0\0\0¾ \0pd\0m\0³\0\0\0\0\0· \0¸ \0z\0p2\0m\0³\0\Z\0\0\0\0½ \0pd\0V \0m\0³\0\0\0\0\0¾ \0pI\0m\0´\0\0\0\0\0Ç\"\0¥\0pd\0m\0´\0\Z\0\0\0\0½ \0pd\0m\0´\0\0\0\0\0¾ \0pd\0µ\0\0\0\0\0$€\0\0descriptionD\0\0\0It belongs to house \'Unnamed House #371\'. Fodastiko owns this house.\0doorid\0\0\0\0µ\0\0\0\0\0Ú€\0\0description\0\0\0Nobody is sleeping there.\0µ\0\Z\0\0\0\0Û€\0\0description\0\0\0Nobody is sleeping there.\0µ\0\0\0\0\0½ \0pd\0¶\0\Z\0\0\0\0%€\0\0descriptionD\0\0\0It belongs to house \'Unnamed House #371\'. Fodastiko owns this house.\0doorid\0\0\0\0°\0\0\0\0\0À\0\0descriptionD\0\0\0It belongs to house \'Unnamed House #371\'. Fodastiko owns this house.\0doorid\0\0\0\0°\0\0\0\0\0%€\0\0descriptionD\0\0\0It belongs to house \'Unnamed House #371\'. Fodastiko owns this house.\0doorid\0\0\0\0±\0\0\0\0\0¨ \0pd\0²\0\0\0\0\0¿ \0pd\0²\0\0\0\0\0U\n\0pd\0³\0\0\0\0\0¥ \0pd\0³\0\0\0\0\0%\'\0pd\0´\0\0\0\0\0Ö\0p<\0´\0\0\0\0\0U\n\0pd\0µ\0\0\0\0\0¨ \0pd\0µ\0\0\0\0\0Ö\0p2\0¶\0\0\0\0\0%€\0\0descriptionD\0\0\0It belongs to house \'Unnamed House #371\'. Fodastiko owns this house.\0doorid\0\0\0\0'),(372, 0, '°\0&\0\0\0\0Ä€\0\0description>\0\0\0It belongs to house \'Unnamed House #372\'. Poi owns this house.\0doorid\0\0\0\0°\0\'\0\0\0\0%€\0\0description>\0\0\0It belongs to house \'Unnamed House #372\'. Poi owns this house.\0doorid\0\0\0\0¶\0&\0\0\0\0%€\0\0description>\0\0\0It belongs to house \'Unnamed House #372\'. Poi owns this house.\0doorid\0\0\0\0°\0)\0\0\0\0%€\0\0description>\0\0\0It belongs to house \'Unnamed House #372\'. Poi owns this house.\0doorid\0\0\0\0±\0(\0\0\0\0Ú€\0\0description\0\0\0Nobody is sleeping there.\0±\0)\0\0\0\0Û€\0\0description\0\0\0Nobody is sleeping there.\0²\0*\0\0\0\0$€\0\0description>\0\0\0It belongs to house \'Unnamed House #372\'. Poi owns this house.\0doorid\0\0\0\0µ\0(\0\0\0\0Ú€\0\0description\0\0\0Nobody is sleeping there.\0µ\0)\0\0\0\0Û€\0\0description\0\0\0Nobody is sleeping there.\0µ\0*\0\0\0\0$€\0\0description>\0\0\0It belongs to house \'Unnamed House #372\'. Poi owns this house.\0doorid\0\0\0\0¶\0)\0\0\0\0%€\0\0description>\0\0\0It belongs to house \'Unnamed House #372\'. Poi owns this house.\0doorid\0\0\0\0'),(373, 0, '±\0\0\0\0\0Ú€\0\0description\0\0\0Nobody is sleeping there.\0²\0\0\0\0\0º\"\0m\0p2\0m\0³\0\0\0\0\0p2\0ä\0m\0´\0\0\0\0\0p2\0m\0µ\0\0\0\0\0â€\0\0description!\0\0\0Chapelero Loko is sleeping there.\n\0sleepstartí_”Vä\0\0\0°\0\"\0\0\0\0Ä€\0\0descriptionE\0\0\0It belongs to house \'Unnamed House #373\'. Mage Frits owns this house.\0doorid\0\0\0\0±\0 \0\0\0\0Û€\0\0description\0\0\0Nobody is sleeping there.\0±\0\"\0\0\0\0Ø \0&\'\00\"\0±\0#\0\0\0\0¥ \0%\0d\0²\0 \0\0\0\0É\"\0â\"\09 \0d\0²\0!\0\0\0\0½ \0\0²\0\"\0\0\0\0²\"\0¥ \0™\"\0²\0#\0\0\0\0p2\0m\0Ç\"\0³\0 \0\0\0\0½ \0_\0³\0!\0\0\0\0¨ \0Å\"\0³\0\"\0\0\0\0¦ \0ƒ\0³\0#\0\0\0\0p2\0ô\0m\0´\0 \0\0\0\0`\n\0ù\0”\"\0d\0´\0!\0\0\0\0Ò \0È\0´\0\"\0\0\0\0€ \0\0d\0´\0#\0\0\0\0p2\0m\0µ\0 \0\0\0\0ã€\0\0description!\0\0\0Chapelero Loko is sleeping there.\n\0sleepstartí_”Vä\0\0\0µ\0!\0\0\0\0¿ \0B\0¥\0µ\0\"\0\0\0\0¨ \0Í&\0µ\0#\0\0\0\0Ÿ\0¶\0 \0\0\0\0%€\0\0descriptionE\0\0\0It belongs to house \'Unnamed House #373\'. Mage Frits owns this house.\0doorid\0\0\0\0¶\0#\0\0\0\0%€\0\0descriptionE\0\0\0It belongs to house \'Unnamed House #373\'. Mage Frits owns this house.\0doorid\0\0\0\0'),(374, 0, '°\0\Z\0\0\0\0%€\0\0description@\0\0\0It belongs to house \'Unnamed House #374\'. Tpain owns this house.\0doorid\0\0\0\0±\0\0\0\0\0Ú€\0\0description\0\0\0Nobody is sleeping there.\0±\0\Z\0\0\0\0Û€\0\0description\0\0\0Nobody is sleeping there.\0²\0\0\0\0\0$€\0\0description@\0\0\0It belongs to house \'Unnamed House #374\'. Tpain owns this house.\0doorid\0\0\0\0²\0\0\0\0\0™\"\0Å\0Ä\0²\0\Z\0\0\0\0%\0²\0\0\0\0\0i1€\0\0aid*\0\0\0description8\0\0\0This item was purchased at the shop by the player Tpain.\0³\0\0\0\0\0= \0\0\0\0\0³\0\0\0\0\0ð\0´\0\0\0\0\09 \0´\0\Z\0\0\0\0Ÿ\0´\0\0\0\0\0²\"\0µ\0\0\0\0\0$€\0\0description@\0\0\0It belongs to house \'Unnamed House #374\'. Tpain owns this house.\0doorid\0\0\0\0µ\0\0\0\0\0Ú€\0\0description\0\0\0Nobody is sleeping there.\0µ\0\Z\0\0\0\0Û€\0\0description\0\0\0Nobody is sleeping there.\0µ\0\0\0\0\0ó&\0¶\0\Z\0\0\0\0%€\0\0description@\0\0\0It belongs to house \'Unnamed House #374\'. Tpain owns this house.\0doorid\0\0\0\0°\0\0\0\0\0%€\0\0description@\0\0\0It belongs to house \'Unnamed House #374\'. Tpain owns this house.\0doorid\0\0\0\0°\0\0\0\0\0Ä€\0\0description@\0\0\0It belongs to house \'Unnamed House #374\'. Tpain owns this house.\0doorid\0\0\0\0²\0\0\0\0\0V \0³\0\0\0\0\0ù\0´\0\0\0\0\0Ö\0´\0\0\0\0\0Í&\0µ\0\0\0\0\0\0¶\0\0\0\0\0%€\0\0description@\0\0\0It belongs to house \'Unnamed House #374\'. Tpain owns this house.\0doorid\0\0\0\0'),(375, 0, 'Á\0\'\0\0\0\0%€\0\0description?\0\0\0It belongs to house \'Unnamed House #375\'. Uaix owns this house.\0doorid\0\0\0\0Â\0%\0\0\0\0Ú€\0\0description\0\0\0Nobody is sleeping there.\0Â\0&\0\0\0\0Û€\0\0description\0\0\0Nobody is sleeping there.\0Ç\0\'\0\0\0\0%€\0\0description?\0\0\0It belongs to house \'Unnamed House #375\'. Uaix owns this house.\0doorid \0\0\0\0Á\0)\0\0\0\0%€\0\0description?\0\0\0It belongs to house \'Unnamed House #375\'. Uaix owns this house.\0doorid\0\0\0\0Â\0+\0\0\0\0$€\0\0description?\0\0\0It belongs to house \'Unnamed House #375\'. Uaix owns this house.\0doorid\0\0\0\0Ä\0+\0\0\0\0$€\0\0description?\0\0\0It belongs to house \'Unnamed House #375\'. Uaix owns this house.\0doorid\0\0\0\0Æ\0+\0\0\0\0$€\0\0description?\0\0\0It belongs to house \'Unnamed House #375\'. Uaix owns this house.\0doorid\0\0\0\0Ç\0)\0\0\0\0À\0\0description?\0\0\0It belongs to house \'Unnamed House #375\'. Uaix owns this house.\0doorid\0\0\0\0Ç\0*\0\0\0\0%€\0\0description?\0\0\0It belongs to house \'Unnamed House #375\'. Uaix owns this house.\0doorid\0\0\0\0') - MYSQL ERROR: Cannot add or update a child row: a foreign key constraint fails (`god`.`house_data`, CONSTRAINT `house_data_ibfk_1` FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses` (`id`, `world_id`) ON DELETE CASCADE) (1452) [23/1/2016 9:34:50] mysql_real_query(): INSERT INTO `house_data` (`house_id`, `world_id`, `data`) VALUES (369, 0, '°\0&\0\0\0\0%€\0\0descriptionG\0\0\0It belongs to house \'Unnamed House #369\'. Dyos Dbronks owns this house.\0doorid\0\0\0\0±\0%\0\0\0\0Ú€\0\0description\0\0\0Nobody is sleeping there.\0±\0&\0\0\0\0Û€\0\0description\0\0\0Nobody is sleeping there.\0µ\0%\0\0\0\0Ú€\0\0description\0\0\0Nobody is sleeping there.\0µ\0&\0\0\0\0Û€\0\0description\0\0\0Nobody is sleeping there.\0¶\0&\0\0\0\0%€\0\0descriptionG\0\0\0It belongs to house \'Unnamed House #369\'. Dyos Dbronks owns this house.\0doorid\0\0\0\0°\0(\0\0\0\0À\0\0descriptionG\0\0\0It belongs to house \'Unnamed House #369\'. Dyos Dbronks owns this house.\0doorid\0\0\0\0°\0)\0\0\0\0%€\0\0descriptionG\0\0\0It belongs to house \'Unnamed House #369\'. Dyos Dbronks owns this house.\0doorid\0\0\0\0²\0*\0\0\0\0$€\0\0descriptionG\0\0\0It belongs to house \'Unnamed House #369\'. Dyos Dbronks owns this house.\0doorid\0\0\0\0µ\0*\0\0\0\0$€\0\0descriptionG\0\0\0It belongs to house \'Unnamed House #369\'. Dyos Dbronks owns this house.\0doorid\0\0\0\0¶\0)\0\0\0\0%€\0\0descriptionG\0\0\0It belongs to house \'Unnamed House #369\'. Dyos Dbronks owns this house.\0doorid\0\0\0\0'),(370, 0, '±\0\0\0\0\0Ú€\0\0description\0\0\0Nobody is sleeping there.\0µ\0\0\0\0\0Ú€\0\0description\0\0\0Nobody is sleeping there.\0°\0 \0\0\0\0%€\0\0descriptionA\0\0\0It belongs to house \'Unnamed House #370\'. Blayde owns this house.\0doorid\0\0\0\0°\0\"\0\0\0\0Ä€\0\0descriptionA\0\0\0It belongs to house \'Unnamed House #370\'. Blayde owns this house.\0doorid\0\0\0\0°\0#\0\0\0\0%€\0\0descriptionA\0\0\0It belongs to house \'Unnamed House #370\'. Blayde owns this house.\0doorid\0\0\0\0±\0 \0\0\0\0Û€\0\0description\0\0\0Nobody is sleeping there.\0²\0\"\0\0\0\0W\n\0³\0 \0\0\0\0™ \0³\0!\0\0\0\0Ÿ \0³\0\"\0\0\0\0W\n\0µ\0 \0\0\0\0Û€\0\0description\0\0\0Nobody is sleeping there.\0¶\0 \0\0\0\0%€\0\0descriptionA\0\0\0It belongs to house \'Unnamed House #370\'. Blayde owns this house.\0doorid\0\0\0\0¶\0#\0\0\0\0%€\0\0descriptionA\0\0\0It belongs to house \'Unnamed House #370\'. Blayde owns this house.\0doorid\0\0\0\0'),(371, 0, '°\0\Z\0\0\0\0%€\0\0descriptionD\0\0\0It belongs to house \'Unnamed House #371\'. Fodastiko owns this house.\0doorid\0\0\0\0±\0\0\0\0\0Ú€\0\0description\0\0\0Nobody is sleeping there.\0±\0\Z\0\0\0\0Û€\0\0description\0\0\0Nobody is sleeping there.\0±\0\0\0\0\0½ \0pd\0²\0\0\0\0\0$€\0\0descriptionD\0\0\0It belongs to house \'Unnamed House #371\'. Fodastiko owns this house.\0doorid\0\0\0\0²\0\0\0\0\0Ç\"\0pd\0m\0²\0\Z\0\0\0\0½ \0pd\0m\0²\0\0\0\0\0¾ \0pd\0m\0³\0\0\0\0\0· \0¸ \0z\0p2\0m\0³\0\Z\0\0\0\0½ \0pd\0V \0m\0³\0\0\0\0\0¾ \0pI\0m\0´\0\0\0\0\0Ç\"\0¥\0pd\0m\0´\0\Z\0\0\0\0½ \0pd\0m\0´\0\0\0\0\0¾ \0pd\0µ\0\0\0\0\0$€\0\0descriptionD\0\0\0It belongs to house \'Unnamed House #371\'. Fodastiko owns this house.\0doorid\0\0\0\0µ\0\0\0\0\0Ú€\0\0description\0\0\0Nobody is sleeping there.\0µ\0\Z\0\0\0\0Û€\0\0description\0\0\0Nobody is sleeping there.\0µ\0\0\0\0\0½ \0pd\0¶\0\Z\0\0\0\0%€\0\0descriptionD\0\0\0It belongs to house \'Unnamed House #371\'. Fodastiko owns this house.\0doorid\0\0\0\0°\0\0\0\0\0À\0\0descriptionD\0\0\0It belongs to house \'Unnamed House #371\'. Fodastiko owns this house.\0doorid\0\0\0\0°\0\0\0\0\0%€\0\0descriptionD\0\0\0It belongs to house \'Unnamed House #371\'. Fodastiko owns this house.\0doorid\0\0\0\0±\0\0\0\0\0¨ \0pd\0²\0\0\0\0\0¿ \0pd\0²\0\0\0\0\0U\n\0pd\0³\0\0\0\0\0¥ \0pd\0³\0\0\0\0\0%\'\0pd\0´\0\0\0\0\0Ö\0p<\0´\0\0\0\0\0U\n\0pd\0µ\0\0\0\0\0¨ \0pd\0µ\0\0\0\0\0Ö\0p2\0¶\0\0\0\0\0%€\0\0descriptionD\0\0\0It belongs to house \'Unnamed House #371\'. Fodastiko owns this house.\0doorid\0\0\0\0'),(372, 0, '°\0&\0\0\0\0Ä€\0\0description>\0\0\0It belongs to house \'Unnamed House #372\'. Poi owns this house.\0doorid\0\0\0\0°\0\'\0\0\0\0%€\0\0description>\0\0\0It belongs to house \'Unnamed House #372\'. Poi owns this house.\0doorid\0\0\0\0¶\0&\0\0\0\0%€\0\0description>\0\0\0It belongs to house \'Unnamed House #372\'. Poi owns this house.\0doorid\0\0\0\0°\0)\0\0\0\0%€\0\0description>\0\0\0It belongs to house \'Unnamed House #372\'. Poi owns this house.\0doorid\0\0\0\0±\0(\0\0\0\0Ú€\0\0description\0\0\0Nobody is sleeping there.\0±\0)\0\0\0\0Û€\0\0description\0\0\0Nobody is sleeping there.\0²\0*\0\0\0\0$€\0\0description>\0\0\0It belongs to house \'Unnamed House #372\'. Poi owns this house.\0doorid\0\0\0\0µ\0(\0\0\0\0Ú€\0\0description\0\0\0Nobody is sleeping there.\0µ\0)\0\0\0\0Û€\0\0description\0\0\0Nobody is sleeping there.\0µ\0*\0\0\0\0$€\0\0description>\0\0\0It belongs to house \'Unnamed House #372\'. Poi owns this house.\0doorid\0\0\0\0¶\0)\0\0\0\0%€\0\0description>\0\0\0It belongs to house \'Unnamed House #372\'. Poi owns this house.\0doorid\0\0\0\0'),(373, 0, '±\0\0\0\0\0Ú€\0\0description\0\0\0Nobody is sleeping there.\0²\0\0\0\0\0º\"\0m\0p2\0m\0³\0\0\0\0\0p2\0ä\0m\0´\0\0\0\0\0p2\0m\0µ\0\0\0\0\0â€\0\0description!\0\0\0Chapelero Loko is sleeping there.\n\0sleepstartí_”Vä\0\0\0°\0\"\0\0\0\0Ä€\0\0descriptionE\0\0\0It belongs to house \'Unnamed House #373\'. Mage Frits owns this house.\0doorid\0\0\0\0±\0 \0\0\0\0Û€\0\0description\0\0\0Nobody is sleeping there.\0±\0\"\0\0\0\0Ø \0&\'\00\"\0±\0#\0\0\0\0¥ \0%\0d\0²\0 \0\0\0\0É\"\0â\"\09 \0d\0²\0!\0\0\0\0½ \0\0²\0\"\0\0\0\0²\"\0¥ \0™\"\0²\0#\0\0\0\0p2\0m\0Ç\"\0³\0 \0\0\0\0½ \0_\0³\0!\0\0\0\0¨ \0Å\"\0³\0\"\0\0\0\0¦ \0ƒ\0³\0#\0\0\0\0p2\0ô\0m\0´\0 \0\0\0\0`\n\0ù\0”\"\0d\0´\0!\0\0\0\0Ò \0È\0´\0\"\0\0\0\0€ \0\0d\0´\0#\0\0\0\0p2\0m\0µ\0 \0\0\0\0ã€\0\0description!\0\0\0Chapelero Loko is sleeping there.\n\0sleepstartí_”Vä\0\0\0µ\0!\0\0\0\0¿ \0B\0¥\0µ\0\"\0\0\0\0¨ \0Í&\0µ\0#\0\0\0\0Ÿ\0¶\0 \0\0\0\0%€\0\0descriptionE\0\0\0It belongs to house \'Unnamed House #373\'. Mage Frits owns this house.\0doorid\0\0\0\0¶\0#\0\0\0\0%€\0\0descriptionE\0\0\0It belongs to house \'Unnamed House #373\'. Mage Frits owns this house.\0doorid\0\0\0\0'),(374, 0, '°\0\Z\0\0\0\0%€\0\0description@\0\0\0It belongs to house \'Unnamed House #374\'. Tpain owns this house.\0doorid\0\0\0\0±\0\0\0\0\0Ú€\0\0description\0\0\0Nobody is sleeping there.\0±\0\Z\0\0\0\0Û€\0\0description\0\0\0Nobody is sleeping there.\0²\0\0\0\0\0$€\0\0description@\0\0\0It belongs to house \'Unnamed House #374\'. Tpain owns this house.\0doorid\0\0\0\0²\0\0\0\0\0™\"\0Å\0Ä\0²\0\Z\0\0\0\0%\0²\0\0\0\0\0i1€\0\0aid*\0\0\0description8\0\0\0This item was purchased at the shop by the player Tpain.\0³\0\0\0\0\0= \0\0\0\0\0³\0\0\0\0\0ð\0´\0\0\0\0\09 \0´\0\Z\0\0\0\0Ÿ\0´\0\0\0\0\0²\"\0µ\0\0\0\0\0$€\0\0description@\0\0\0It belongs to house \'Unnamed House #374\'. Tpain owns this house.\0doorid\0\0\0\0µ\0\0\0\0\0Ú€\0\0description\0\0\0Nobody is sleeping there.\0µ\0\Z\0\0\0\0Û€\0\0description\0\0\0Nobody is sleeping there.\0µ\0\0\0\0\0ó&\0¶\0\Z\0\0\0\0%€\0\0description@\0\0\0It belongs to house \'Unnamed House #374\'. Tpain owns this house.\0doorid\0\0\0\0°\0\0\0\0\0%€\0\0description@\0\0\0It belongs to house \'Unnamed House #374\'. Tpain owns this house.\0doorid\0\0\0\0°\0\0\0\0\0Ä€\0\0description@\0\0\0It belongs to house \'Unnamed House #374\'. Tpain owns this house.\0doorid\0\0\0\0²\0\0\0\0\0V \0³\0\0\0\0\0ù\0´\0\0\0\0\0Ö\0´\0\0\0\0\0Í&\0µ\0\0\0\0\0\0¶\0\0\0\0\0%€\0\0description@\0\0\0It belongs to house \'Unnamed House #374\'. Tpain owns this house.\0doorid\0\0\0\0'),(375, 0, 'Á\0\'\0\0\0\0%€\0\0description?\0\0\0It belongs to house \'Unnamed House #375\'. Uaix owns this house.\0doorid\0\0\0\0Â\0%\0\0\0\0Ú€\0\0description\0\0\0Nobody is sleeping there.\0Â\0&\0\0\0\0Û€\0\0description\0\0\0Nobody is sleeping there.\0Ç\0\'\0\0\0\0%€\0\0description?\0\0\0It belongs to house \'Unnamed House #375\'. Uaix owns this house.\0doorid \0\0\0\0Á\0)\0\0\0\0%€\0\0description?\0\0\0It belongs to house \'Unnamed House #375\'. Uaix owns this house.\0doorid\0\0\0\0Â\0+\0\0\0\0$€\0\0description?\0\0\0It belongs to house \'Unnamed House #375\'. Uaix owns this house.\0doorid\0\0\0\0Ä\0+\0\0\0\0$€\0\0description?\0\0\0It belongs to house \'Unnamed House #375\'. Uaix owns this house.\0doorid\0\0\0\0Æ\0+\0\0\0\0$€\0\0description?\0\0\0It belongs to house \'Unnamed House #375\'. Uaix owns this house.\0doorid\0\0\0\0Ç\0)\0\0\0\0À\0\0description?\0\0\0It belongs to house \'Unnamed House #375\'. Uaix owns this house.\0doorid\0\0\0\0Ç\0*\0\0\0\0%€\0\0description?\0\0\0It belongs to house \'Unnamed House #375\'. Uaix owns this house.\0doorid\0\0\0\0') - MYSQL ERROR: Cannot add or update a child row: a foreign key constraint fails (`god`.`house_data`, CONSTRAINT `house_data_ibfk_1` FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses` (`id`, `world_id`) ON DELETE CASCADE) (1452) [

boa noite galera do xtibia tenho um script aq de reset e queria que quando resetar daria 1 reset a mais na opçao resets em players tfs 1.0

Ola gelerinha quem poder me ajudar eu nao me lembro onde eu peguei esse script de ban que eu gostei muito so que meu servidor e mysql quando eu do ban a pessoa pode logar novamente pq ta faltando as query se alguem poder me ajudar vo postar meu script. nada ainda Tuts tuts tuts..

Basta seguir os seguintes passos: Primeiramente e preciso fazer o login no phpMyAdmin! Acesse: localhost/phpmyadmin/ Agora selecione a database de seu servidor: Agora, selecione a coluna SQL : E por ultimo, escreva a query e aperte GO : Creditos: Alexclusive Simples assim! Talvez ajude alguem um dia!