06.06.2015, 20:00
Код:
Err] 1305 - FUNCTION wcrp_backup.GetWeaponInfo does not exist [Err] /*!50001 DROP VIEW IF EXISTS `listCharInfo`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = utf8 */; /*!50001 SET character_set_results = utf8 */; /*!50001 SET collation_connection = utf8_general_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`CHC`@`24.235.%` SQL SECURITY DEFINER */ /*!50001 VIEW `listCharInfo` AS select `characters`.`username` AS `username`,`characters`.`money` AS `money`,`characters`.`bank` AS `bank`,`GetWeaponInfo`(`characters`.`gun0`) AS `Gun Slot 0`,`GetWeaponInfo`(`characters`.`gun1`) AS `Gun Slot 1`,`GetWeaponInfo`(`characters`.`gun2`) AS `Gun Slot 2`,`GetWeaponInfo`(`characters`.`gun3`) AS `Gun Slot 3`,`GetWeaponInfo`(`characters`.`gun4`) AS `Gun Slot 4`,`GetWeaponInfo`(`characters`.`gun5`) AS `Gun Slot 5`,`GetWeaponInfo`(`characters`.`gun6`) AS `Gun Slot 6`,`GetWeaponInfo`(`characters`.`gun7`) AS `Gun Slot 7`,`GetWeaponInfo`(`characters`.`gun8`) AS `Gun Slot 8`,`GetWeaponInfo`(`characters`.`gun9`) AS `Gun Slot 9`,`GetWeaponInfo`(`characters`.`gun10`) AS `Gun Slot 10`,`GetWeaponInfo`(`characters`.`gun11`) AS `Gun Slot 11`,`GetWeaponInfo`(`characters`.`gun12`) AS `Gun Slot 12`,`characters`.`id` AS `CharID`,`characters`.`accountid` AS `Account ID` from `characters` */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; /*!50001 DROP TABLE IF EXISTS `listHelpers`*/; /*!50001 DROP VIEW IF EXISTS `listHelpers`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = utf8 */; /*!50001 SET character_set_results = utf8 */; /*!50001 SET collation_connection = utf8_general_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`CHC`@`24.235.%` SQL SECURITY DEFINER */ /*!50001 VIEW `listHelpers` AS select `a`.`id` AS `Account ID`,`a`.`username` AS `Account Username`,if((`a`.`newbrank` = 1),'Helper','Teacher') AS `Newb Rank`,(to_days(now()) - to_days(`a`.`lastlogin`)) AS `Days Inactive`,`a`.`lastlogin` AS `Last Login` from `accounts` `a` where ((`a`.`adminlevel` = 0) and (`a`.`newbrank` <> 0) and (`a`.`ahide` <> 2)) order by `a`.`newbrank` desc,(to_days(now()) - to_days(`a`.`lastlogin`)) */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; /*!50001 DROP TABLE IF EXISTS `listHouses`*/; /*!50001 DROP VIEW IF EXISTS `listHouses`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = utf8 */; /*!50001 SET character_set_results = utf8 */; /*!50001 SET collation_connection = utf8_general_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`CHC`@`24.235.%` SQL SECURITY DEFINER */ /*!50001 VIEW `listHouses` AS select `h`.`id` AS `id`,`h`.`name` AS `name`,`c`.`username` AS `username`,`h`.`X` AS `X`,`h`.`Y` AS `Y`,`h`.`Z` AS `Z`,`h`.`price` AS `Value` from (`houses` `h` left join `characters` `c` on((`c`.`id` = `h`.`owner`))) */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; /*!50001 DROP TABLE IF EXISTS `listIBizes`*/; /*!50001 DROP VIEW IF EXISTS `listIBizes`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_con [Err] 1305 - FUNCTION wcrp_backup.GetVehicleName does not exist [Err] /*!50001 SET character_set_client = utf8 */; /*!50001 SET character_set_results = utf8 */; /*!50001 SET collation_connection = utf8_general_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`CHC`@`24.235.%` SQL SECURITY DEFINER */ /*!50001 VIEW `listVehicles` AS select `p`.`id` AS `CarID`,`a`.`id` AS `AccountID`,`a`.`username` AS `Account Name`,`c`.`id` AS `CharID`,`c`.`username` AS `Char Username`,`p`.`model` AS `ModelID`,`GetVehicleName`(`p`.`model`) AS `Model Name`,`p`.`colour1` AS `Colour 1`,`p`.`colour2` AS `Colour 2`,`GetTrunkItemName`(`p`.`trunk0type`,`p`.`trunk0num`) AS `Trunk 1`,`GetTrunkItemName`(`p`.`trunk1type`,`p`.`trunk1num`) AS `Trunk 2`,`GetTrunkItemName`(`p`.`trunk2type`,`p`.`trunk2num`) AS `Trunk 3`,`GetTrunkItemName`(`p`.`trunk3type`,`p`.`trunk3num`) AS `Trunk 4`,`GetTrunkItemName`(`p`.`trunk4type`,`p`.`trunk4num`) AS `Trunk 5`,`GetTrunkItemName`(`p`.`trunk5type`,`p`.`trunk5num`) AS `Trunk 6` from ((`playercars` `p` join `characters` `c` on((`c`.`id` = `p`.`owner`))) join `accounts` `a` on((`a`.`id` = `c`.`accountid`))) */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; /*!50001 DROP TABLE IF EXISTS `viewNotes`*/; /*!50001 DROP VIEW IF EXISTS `viewNotes`*/; /*!50001 SET @saved_cs_client = @@character_set_client */; /*!50001 SET @saved_cs_results = @@character_set_results */; /*!50001 SET @saved_col_connection = @@collation_connection */; /*!50001 SET character_set_client = utf8 */; /*!50001 SET character_set_results = utf8 */; /*!50001 SET collation_connection = utf8_general_ci */; /*!50001 CREATE ALGORITHM=UNDEFINED */ /*!50013 DEFINER=`CHC`@`24.235.%` SQL SECURITY DEFINER */ /*!50001 VIEW `viewNotes` AS select `b`.`noteid` AS `Note ID`,`ac1`.`username` AS `Account Name`,if((`ac2`.`username` is not null),`ac2`.`username`,'SYSTEM') AS `Set By`,`b`.`note` AS `Note`,`b`.`seton` AS `Set On` from ((`accountnotes` `b` join `accounts` `ac1` on((`b`.`accountid` = `ac1`.`id`))) left join `accounts` `ac2` on((`b`.`setby` = `ac2`.`id`))) order by `b`.`noteid` */; /*!50001 SET character_set_client = @saved_cs_client */; /*!50001 SET character_set_results = @saved_cs_results */; /*!50001 SET collation_connection = @saved_col_connection */; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; [Msg] Finished - Unsuccessfully --------------------------------------------------
.. :/