Mensajes: 369
Temas: 64
Registro en: Feb 2017
Reputación:
2
Buenas alguien me podría decir como hacer para mejorar la velocidad en que el un código lee y carga los datos de un servidor mysql con sqlx, mi servidor estando en localhost carga lento quisiera saber si se puede hacer mas rápido, estoy usando el za 4.6
Descargar AMXX / zombie_apocalypse46.sma (Tamaño: 517.83 KB / Descargas: 5)
Mensajes: 7,178
Temas: 93
Registro en: Aug 2014
Reputación:
63
mysqlt y modela bien tu db
Mensajes: 369
Temas: 64
Registro en: Feb 2017
Reputación:
2
No logro cambiarme a mysqlt no entiendo, como modelar bien la db??
Mensajes: 7,178
Temas: 93
Registro en: Aug 2014
Reputación:
63
10/01/2019, 07:03 PM
(Última modificación: 10/01/2019, 07:04 PM por Hinami. Edited 2 times in total.)
https://www.youtube.com/watch?v=g-nwiRY5wMw
obvio estoy respondiendo a tu pregunta, como pediste.
y si no te anda el mysqlt deberias de postear los errores en tus post, ya que pones code más no errores y nadie es adivino xdxd
Mensajes: 369
Temas: 64
Registro en: Feb 2017
Reputación:
2
Aca un pedazo del code + el error
Código PHP: public Sql_Init() { g_SqlTuple = mysql_makehost(mysql_host, mysql_user, mysql_pass, mysql_database)
if (!g_SqlTuple) { // Log error log_to_file("SQL_ERROR.txt", "No se pudo conectar con la base de datos.") // Pause plugin return pause("a"); } new ErrorCode, Handle:SqlConnection = mysql_connect(g_SqlTuple, ErrorCode, g_Error, charsmax(g_Error)) // Load account count if (SqlConnection != Empty_Handle) { new Handle:query = mysql_query(SqlConnection, "SELECT * FROM `%s`", TABLE9) //SQL_Execute(query) if (mysql_num_results()) <--------- en estos comandos es que me lanza los warnings { g_createdaccounts = SQL_ReadResult(query, 0) g_createdcharacters = SQL_ReadResult(query, 1) } else { g_createdaccounts = g_createdcharacters = 0 formatex(g_query,charsmax(g_query), "INSERT INTO `%s` (`Created accounts`, `Created characters`) VALUES ('0', '0')", TABLE9) mysql_query(g_SqlTuple, "IgnoreHandle", g_query) } mysql_free(query) } return PLUGIN_CONTINUE; } // en todos estos y muchos mas mysql_read_result(query, 0, szName, charsmax(szName)) iLevel = mysql_read_result(query, 1) iExp = mysql_read_result(query, 2) iAp = mysql_read_result(query, 3) iFame = mysql_read_result(query, 4) iHP = mysql_read_result(query, 5) iZP = mysql_read_result(query, 6)
Código PHP: Welcome to the AMX Mod X 1.8.1-300 Compiler. Copyright (c) 1997-2006 ITB CompuPhase, AMX Mod X Team
C:\Program Files\Counter-Strike-Zombie\cstrike\addons\amxmodx\scripting\include\mysqlt.inc(239) : warning 203: symbol is never used: "query" Warning: Tag mismatch on line 2047 Warning: Tag mismatch on line 4539 Warning: Tag mismatch on line 4552 Warning: Tag mismatch on line 4553 Warning: Tag mismatch on line 4554 Warning: Tag mismatch on line 4555 Warning: Tag mismatch on line 4556 Warning: Tag mismatch on line 4557 Warning: Tag mismatch on line 4558 Warning: Tag mismatch on line 4603 Warning: Tag mismatch on line 4647 Warning: Tag mismatch on line 4719 Warning: Tag mismatch on line 4720 Warning: Tag mismatch on line 4721 Warning: Tag mismatch on line 4722 Warning: Tag mismatch on line 4723 Warning: Tag mismatch on line 4724 Warning: Tag mismatch on line 4725 Warning: Tag mismatch on line 4735 Warning: Tag mismatch on line 4736 Warning: Tag mismatch on line 4737 Warning: Tag mismatch on line 4738 Warning: Tag mismatch on line 4739 Warning: Tag mismatch on line 4740 Warning: Tag mismatch on line 4741 Warning: Tag mismatch on line 4742 Warning: Tag mismatch on line 4743 Warning: Tag mismatch on line 4744 Warning: Tag mismatch on line 4755 Warning: Tag mismatch on line 4756 Warning: Tag mismatch on line 4757 Warning: Tag mismatch on line 4758 Warning: Tag mismatch on line 4768 Warning: Tag mismatch on line 4769 Warning: Tag mismatch on line 4770 Warning: Tag mismatch on line 4771 Warning: Tag mismatch on line 4772 Warning: Tag mismatch on line 4773 Warning: Tag mismatch on line 4774 Warning: Tag mismatch on line 4775 Warning: Tag mismatch on line 4776 Warning: Tag mismatch on line 4777 Warning: Tag mismatch on line 4778 Warning: Tag mismatch on line 4779 Warning: Tag mismatch on line 4780 Warning: Tag mismatch on line 4781 Warning: Tag mismatch on line 4782 Warning: Tag mismatch on line 4783 Warning: Tag mismatch on line 4784 Warning: Tag mismatch on line 4785 Warning: Tag mismatch on line 4786 Warning: Tag mismatch on line 4787 Warning: Tag mismatch on line 4788 Warning: Tag mismatch on line 4789 Warning: Tag mismatch on line 4790 Warning: Tag mismatch on line 4791 Warning: Tag mismatch on line 4792 Warning: Tag mismatch on line 4793 Warning: Tag mismatch on line 4803 Warning: Tag mismatch on line 4804 Warning: Tag mismatch on line 4805 Warning: Tag mismatch on line 4806 Warning: Tag mismatch on line 4807 Warning: Tag mismatch on line 4808 Warning: Tag mismatch on line 4809 Warning: Tag mismatch on line 4810 Warning: Tag mismatch on line 4811 Warning: Tag mismatch on line 4812 Warning: Tag mismatch on line 4822 Warning: Tag mismatch on line 4823 Warning: Tag mismatch on line 4824 Warning: Tag mismatch on line 4825 Warning: Tag mismatch on line 4826 Warning: Tag mismatch on line 4827 Warning: Tag mismatch on line 4828 Warning: Tag mismatch on line 4829 Warning: Tag mismatch on line 4830 Warning: Tag mismatch on line 4840 Warning: Tag mismatch on line 4841 Warning: Tag mismatch on line 4842 Warning: Tag mismatch on line 4843 Warning: Tag mismatch on line 4854 Warning: Tag mismatch on line 4855 Warning: Tag mismatch on line 4856 Warning: Tag mismatch on line 4857 Warning: Tag mismatch on line 4862 Warning: Tag mismatch on line 4867 Header size: 12652 bytes Code size: 576468 bytes Data size: 398232 bytes Stack/heap size: 16384 bytes; max. usage is unknown, due to recursion Total requirements: 1003736 bytes
88 Warnings. Done.
Mensajes: 7,178
Temas: 93
Registro en: Aug 2014
Reputación:
63
Código PHP: /* [Comprueba si hay mas resultados] return: Devuelve true si hay mas resultados,de lo contrario false */ native mysql_more_results();
/* [Obtiene los datos de una columna(ID)] -column: El id de la columna Ejemplo: -Para numeros: new num = mysql_read_result(0) -Para Float: new Float:num2 mysql_read_result(1, num2) -Para String: new str[32] mysql_read_result(2, str, 31) */ native mysql_read_result(column, {Float,_}:...);
leete el include mysqlt
+
https://amxmodx-es.com/Thread-Modulo-MySQL-Threads-1-2
Mensajes: 369
Temas: 64
Registro en: Feb 2017
Reputación:
2
lo que pasa es que no entiendo eso de sql no se mucho de tablas ni de como obtener cierta info o escribirla en amx, pero me es necesario aprenderlo.
Mensajes: 369
Temas: 64
Registro en: Feb 2017
Reputación:
2
10/01/2019, 11:06 PM
(Última modificación: 10/01/2019, 11:38 PM por luxor xD.)
Me puede ayudar con esto
Código PHP: // Load account count if (SqlConnection != Empty_Handle) { new Handle:query = mysql_query(SqlConnection, "SELECT * FROM `%s`", TABLE9) //SQL_Execute(query) if (mysql_more_results()) <--------- en estos comandos es que me lanza los warnings { g_createdaccounts = SQL_ReadResult(query, 0) g_createdcharacters = SQL_ReadResult(query, 1) }
lo cambie pero sigue lanzando warnings donde mismo
Aquí te dejo el código SQLX y el código que estoy intentando poner con Mysqlt para ver si me pueden ayudar.
este es el codigo original del za 4.6, este no tira ninguna error
Código PHP: /*======================================================== [SQLX] ========================================================*/ public Sql_Init() { #if defined USE_SQLITE new get_type[12] SQL_SetAffinity("sqlite") SQL_GetAffinity(get_type, sizeof get_type)
if (!equali(get_type, "sqlite")) { // Log error log_to_file( "SQLITE_ERROR.txt", "Error en la conexión.") // Pause plugin return pause( "a" ); } g_SqlTuple = SQL_MakeDbTuple( "", "", "", mysql_database) #else g_SqlTuple = SQL_MakeDbTuple(mysql_host, mysql_user, mysql_pass, mysql_database)
if (!g_SqlTuple) { // Log error log_to_file("SQL_ERROR.txt", "No se pudo conectar con la base de datos.") // Pause plugin return pause("a"); } #endif new ErrorCode, Handle:SqlConnection = SQL_Connect(g_SqlTuple, ErrorCode, g_Error, charsmax(g_Error)) // Create tables new len = 0 len += formatex(g_motd[len], charsmax(g_motd) - len, "CREATE TABLE IF NOT EXISTS `%s`(", TABLE9) len += formatex(g_motd[len], charsmax(g_motd) - len, "`Created accounts` int(15) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Created characters` int(15) NOT NULL DEFAULT '0')") SQL_ThreadQuery(g_SqlTuple, "QueryCreateTable", g_motd) len = 0 len += formatex(g_motd[len], charsmax(g_motd) - len, "CREATE TABLE IF NOT EXISTS `%s`(", TABLE1) len += formatex(g_motd[len], charsmax(g_motd) - len, "`User ID` varchar(32) NOT NULL, ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Password` varchar(35) NOT NULL, ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Register Date` date NOT NULL, ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Last Loggin` date NOT NULL DEFAULT '0000-00-00', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Character 1` varchar(32) NOT NULL DEFAULT 'None', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Character 2` varchar(32) NOT NULL DEFAULT 'None', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Character 3` varchar(32) NOT NULL DEFAULT 'None', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Character 4` varchar(32) NOT NULL DEFAULT 'None', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Character 5` varchar(32) NOT NULL DEFAULT 'None')") SQL_ThreadQuery(g_SqlTuple, "QueryCreateTable", g_motd) len = 0 len += formatex(g_motd[len], charsmax(g_motd) - len, "CREATE TABLE IF NOT EXISTS `%s`(", TABLE2) len += formatex(g_motd[len], charsmax(g_motd) - len, "`User ID` varchar(32) NOT NULL, ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Character` varchar(32) NOT NULL, ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Level` int(5) NOT NULL DEFAULT '1', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Experience` int(16) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Ammopacks` int(10) NOT NULL DEFAULT '%d', ", get_pcvar_num(cvar_startammopacks)) len += formatex(g_motd[len], charsmax(g_motd) - len, "`Used Ammopacks` int(10) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Range` int(3) NOT NULL DEFAULT '1', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Fame` int(3) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Human Points` int(10) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Zombie Points` int(10) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Used Human Points` int(10) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Used Zombie Points` int(10) NOT NULL DEFAULT '0')") SQL_ThreadQuery(g_SqlTuple, "QueryCreateTable", g_motd) len = 0 len += formatex(g_motd[len], charsmax(g_motd) - len, "CREATE TABLE IF NOT EXISTS `%s`(", TABLE3) len += formatex(g_motd[len], charsmax(g_motd) - len, "`User ID` varchar(32) NOT NULL, ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Character` varchar(32) NOT NULL, ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Human Class` int(3) NOT NULL DEFAULT '%d', ", HCLASS_NONE) len += formatex(g_motd[len], charsmax(g_motd) - len, "`Next Human Class` int(3) NOT NULL DEFAULT '%d', ", HCLASS_NONE) len += formatex(g_motd[len], charsmax(g_motd) - len, "`Zombie Class` int(3) NOT NULL DEFAULT '%d', ", ZCLASS_NONE) len += formatex(g_motd[len], charsmax(g_motd) - len, "`Next Zombie Class` int(3) NOT NULL DEFAULT '%d')", ZCLASS_NONE) SQL_ThreadQuery(g_SqlTuple, "QueryCreateTable", g_motd) len = 0 len += formatex(g_motd[len], charsmax(g_motd) - len, "CREATE TABLE IF NOT EXISTS `%s`(", TABLE4) len += formatex(g_motd[len], charsmax(g_motd) - len, "`User ID` varchar(32) NOT NULL, ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Character` varchar(32) NOT NULL, ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Infected Human` int(10) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Received Infect` int(10) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Human Killed` int(10) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Zombie Killed` int(10) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Survivor Killed` int(10) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Wesker Killed` int(10) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Nemesis Killed` int(10) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Alien Killed` int(10) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Human Dead` int(10) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Zombie Dead` int(10) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Survivor Dead` int(10) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Wesker Dead` int(10) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Nemesis Dead` int(10) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Alien Dead` int(10) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Human Damage` int(20) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Zombie Damage` int(20) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Survivor Damage` int(20) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Wesker Damage` int(20) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Nemesis Damage` int(20) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Alien Damage` int(20) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Human RDamage` int(20) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Zombie RDamage` int(20) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Survivor RDamage` int(20) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Wesker RDamage` int(20) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Nemesis RDamage` int(20) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Alien RDamage` int(20) NOT NULL DEFAULT '0')") SQL_ThreadQuery(g_SqlTuple, "QueryCreateTable", g_motd) len = 0 len += formatex(g_motd[len], charsmax(g_motd) - len, "CREATE TABLE IF NOT EXISTS `%s`(", TABLE5) len += formatex(g_motd[len], charsmax(g_motd) - len, "`User ID` varchar(32) NOT NULL, ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Character` varchar(32) NOT NULL, ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`HAttack Skill` int(3) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`HHealth Skill` int(3) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`HSpeed Skill` int(3) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`HGravity Skill` int(3) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`HArmor Skill` int(3) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`ZAttack Skill` int(3) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`ZHealth Skill` int(3) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`ZSpeed Skill` int(3) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`ZGravity Skill` int(3) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`ZDefense Skill` int(3) NOT NULL DEFAULT '0')") SQL_ThreadQuery(g_SqlTuple, "QueryCreateTable", g_motd) len = 0 len += formatex(g_motd[len], charsmax(g_motd) - len, "CREATE TABLE IF NOT EXISTS `%s`(", TABLE6) len += formatex(g_motd[len], charsmax(g_motd) - len, "`User ID` varchar(32) NOT NULL, ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Character` varchar(32) NOT NULL, ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Selected Quest` int(4) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Completed Quest` int(5) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Quest Rounds` int(5) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Quest Killed Human` int(5) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Quest Killed Zombie` int(5) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Quest Killed Survivor` int(5) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Quest Killed Wesker` int(5) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Quest Killed Nemesis` int(5) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Quest Killed Alien` int(5) NOT NULL DEFAULT '0')") SQL_ThreadQuery(g_SqlTuple, "QueryCreateTable", g_motd) len = 0 len += formatex(g_motd[len], charsmax(g_motd) - len, "CREATE TABLE IF NOT EXISTS `%s`(", TABLE7) len += formatex(g_motd[len], charsmax(g_motd) - len, "`User ID` varchar(32) NOT NULL, ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Character` varchar(32) NOT NULL, ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Rounds Played` int(10) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Hours Played` int(10) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Minutes Played` int(3) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Seconds Played` int(3) NOT NULL DEFAULT '0')") SQL_ThreadQuery(g_SqlTuple, "QueryCreateTable", g_motd) len = 0 len += formatex(g_motd[len], charsmax(g_motd) - len, "CREATE TABLE IF NOT EXISTS `%s`(", TABLE8) len += formatex(g_motd[len], charsmax(g_motd) - len, "`User ID` varchar(32) NOT NULL, ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Character` varchar(32) NOT NULL, ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Hud Stat T` int(1) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Hud Stat X` float NOT NULL DEFAULT '0.03', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Hud Stat Y` float NOT NULL DEFAULT '0.02', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Hud RGB` varchar(12) NOT NULL DEFAULT '79 168 51', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`NVG RGB` varchar(12) NOT NULL DEFAULT '0 255 0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Flashlight RGB` varchar(12) NOT NULL DEFAULT '255 255 255')") SQL_ThreadQuery(g_SqlTuple, "QueryCreateTable", g_motd) // Load account count if (SqlConnection != Empty_Handle) { new Handle:query = SQL_PrepareQuery(SqlConnection, "SELECT * FROM `%s`", TABLE9) SQL_Execute(query) if (SQL_NumResults(query)) { g_createdaccounts = SQL_ReadResult(query, 0) g_createdcharacters = SQL_ReadResult(query, 1) } else { g_createdaccounts = g_createdcharacters = 0 formatex(g_query,charsmax(g_query), "INSERT INTO `%s` (`Created accounts`, `Created characters`) VALUES ('0', '0')", TABLE9) SQL_ThreadQuery(g_SqlTuple, "IgnoreHandle", g_query) } SQL_FreeHandle(query) } return PLUGIN_CONTINUE; }
Este es lo que e cambiado para hacerlo con Mysqlt el cual me lanza errores leves de compilación pero no me carga datos ni guarda.
Código PHP: /*======================================================== [MYSQLT] ========================================================*/ public Sql_Init() { g_SqlTuple = mysql_makehost(mysql_host, mysql_user, mysql_pass, mysql_database)
if (!g_SqlTuple) { // Log error log_to_file("SQL_ERROR.txt", "No se pudo conectar con la base de datos.") // Pause plugin return pause("a"); } new ErrorCode, Handle:SqlConnection = mysql_connect(g_SqlTuple, ErrorCode, g_Error, charsmax(g_Error)) // Create tables new len = 0 len += formatex(g_motd[len], charsmax(g_motd) - len, "CREATE TABLE IF NOT EXISTS `%s`(", TABLE9) len += formatex(g_motd[len], charsmax(g_motd) - len, "`Created accounts` int(15) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Created characters` int(15) NOT NULL DEFAULT '0')") mysql_query(g_SqlTuple, "QueryCreateTable", g_motd) len = 0 len += formatex(g_motd[len], charsmax(g_motd) - len, "CREATE TABLE IF NOT EXISTS `%s`(", TABLE1) len += formatex(g_motd[len], charsmax(g_motd) - len, "`User ID` varchar(32) NOT NULL, ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Password` varchar(35) NOT NULL, ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Register Date` date NOT NULL, ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Last Loggin` date NOT NULL DEFAULT '0000-00-00', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Character 1` varchar(32) NOT NULL DEFAULT 'None', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Character 2` varchar(32) NOT NULL DEFAULT 'None', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Character 3` varchar(32) NOT NULL DEFAULT 'None', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Character 4` varchar(32) NOT NULL DEFAULT 'None', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Character 5` varchar(32) NOT NULL DEFAULT 'None')") mysql_query(g_SqlTuple, "QueryCreateTable", g_motd) len = 0 len += formatex(g_motd[len], charsmax(g_motd) - len, "CREATE TABLE IF NOT EXISTS `%s`(", TABLE2) len += formatex(g_motd[len], charsmax(g_motd) - len, "`User ID` varchar(32) NOT NULL, ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Character` varchar(32) NOT NULL, ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Level` int(5) NOT NULL DEFAULT '1', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Experience` int(16) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Ammopacks` int(10) NOT NULL DEFAULT '%d', ", get_pcvar_num(cvar_startammopacks)) len += formatex(g_motd[len], charsmax(g_motd) - len, "`Used Ammopacks` int(10) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Range` int(3) NOT NULL DEFAULT '1', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Fame` int(3) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Human Points` int(10) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Zombie Points` int(10) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Used Human Points` int(10) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Used Zombie Points` int(10) NOT NULL DEFAULT '0')") mysql_query(g_SqlTuple, "QueryCreateTable", g_motd) len = 0 len += formatex(g_motd[len], charsmax(g_motd) - len, "CREATE TABLE IF NOT EXISTS `%s`(", TABLE3) len += formatex(g_motd[len], charsmax(g_motd) - len, "`User ID` varchar(32) NOT NULL, ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Character` varchar(32) NOT NULL, ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Human Class` int(3) NOT NULL DEFAULT '%d', ", HCLASS_NONE) len += formatex(g_motd[len], charsmax(g_motd) - len, "`Next Human Class` int(3) NOT NULL DEFAULT '%d', ", HCLASS_NONE) len += formatex(g_motd[len], charsmax(g_motd) - len, "`Zombie Class` int(3) NOT NULL DEFAULT '%d', ", ZCLASS_NONE) len += formatex(g_motd[len], charsmax(g_motd) - len, "`Next Zombie Class` int(3) NOT NULL DEFAULT '%d')", ZCLASS_NONE) mysql_query(g_SqlTuple, "QueryCreateTable", g_motd) len = 0 len += formatex(g_motd[len], charsmax(g_motd) - len, "CREATE TABLE IF NOT EXISTS `%s`(", TABLE4) len += formatex(g_motd[len], charsmax(g_motd) - len, "`User ID` varchar(32) NOT NULL, ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Character` varchar(32) NOT NULL, ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Infected Human` int(10) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Received Infect` int(10) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Human Killed` int(10) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Zombie Killed` int(10) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Survivor Killed` int(10) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Wesker Killed` int(10) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Nemesis Killed` int(10) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Alien Killed` int(10) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Human Dead` int(10) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Zombie Dead` int(10) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Survivor Dead` int(10) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Wesker Dead` int(10) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Nemesis Dead` int(10) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Alien Dead` int(10) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Human Damage` int(20) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Zombie Damage` int(20) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Survivor Damage` int(20) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Wesker Damage` int(20) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Nemesis Damage` int(20) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Alien Damage` int(20) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Human RDamage` int(20) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Zombie RDamage` int(20) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Survivor RDamage` int(20) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Wesker RDamage` int(20) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Nemesis RDamage` int(20) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Alien RDamage` int(20) NOT NULL DEFAULT '0')") mysql_query(g_SqlTuple, "QueryCreateTable", g_motd) len = 0 len += formatex(g_motd[len], charsmax(g_motd) - len, "CREATE TABLE IF NOT EXISTS `%s`(", TABLE5) len += formatex(g_motd[len], charsmax(g_motd) - len, "`User ID` varchar(32) NOT NULL, ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Character` varchar(32) NOT NULL, ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`HAttack Skill` int(3) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`HHealth Skill` int(3) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`HSpeed Skill` int(3) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`HGravity Skill` int(3) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`HArmor Skill` int(3) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`ZAttack Skill` int(3) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`ZHealth Skill` int(3) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`ZSpeed Skill` int(3) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`ZGravity Skill` int(3) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`ZDefense Skill` int(3) NOT NULL DEFAULT '0')") mysql_query(g_SqlTuple, "QueryCreateTable", g_motd) len = 0 len += formatex(g_motd[len], charsmax(g_motd) - len, "CREATE TABLE IF NOT EXISTS `%s`(", TABLE6) len += formatex(g_motd[len], charsmax(g_motd) - len, "`User ID` varchar(32) NOT NULL, ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Character` varchar(32) NOT NULL, ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Selected Quest` int(4) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Completed Quest` int(5) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Quest Rounds` int(5) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Quest Killed Human` int(5) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Quest Killed Zombie` int(5) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Quest Killed Survivor` int(5) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Quest Killed Wesker` int(5) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Quest Killed Nemesis` int(5) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Quest Killed Alien` int(5) NOT NULL DEFAULT '0')") mysql_query(g_SqlTuple, "QueryCreateTable", g_motd) len = 0 len += formatex(g_motd[len], charsmax(g_motd) - len, "CREATE TABLE IF NOT EXISTS `%s`(", TABLE7) len += formatex(g_motd[len], charsmax(g_motd) - len, "`User ID` varchar(32) NOT NULL, ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Character` varchar(32) NOT NULL, ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Rounds Played` int(10) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Hours Played` int(10) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Minutes Played` int(3) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Seconds Played` int(3) NOT NULL DEFAULT '0')") mysql_query(g_SqlTuple, "QueryCreateTable", g_motd) len = 0 len += formatex(g_motd[len], charsmax(g_motd) - len, "CREATE TABLE IF NOT EXISTS `%s`(", TABLE8) len += formatex(g_motd[len], charsmax(g_motd) - len, "`User ID` varchar(32) NOT NULL, ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Character` varchar(32) NOT NULL, ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Hud Stat T` int(1) NOT NULL DEFAULT '0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Hud Stat X` float NOT NULL DEFAULT '0.03', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Hud Stat Y` float NOT NULL DEFAULT '0.02', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Hud RGB` varchar(12) NOT NULL DEFAULT '79 168 51', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`NVG RGB` varchar(12) NOT NULL DEFAULT '0 255 0', ") len += formatex(g_motd[len], charsmax(g_motd) - len, "`Flashlight RGB` varchar(12) NOT NULL DEFAULT '255 255 255')") mysql_query(g_SqlTuple, "QueryCreateTable", g_motd) // Load account count if (SqlConnection != Empty_Handle) { new Handle:query = mysql_query(SqlConnection, "SELECT * FROM `%s`", TABLE9) //SQL_Execute(query) if (mysql_more_results()) // en estos if me lanza el error { g_createdaccounts = SQL_ReadResult(query, 0) g_createdcharacters = SQL_ReadResult(query, 1) } else { g_createdaccounts = g_createdcharacters = 0 formatex(g_query,charsmax(g_query), "INSERT INTO `%s` (`Created accounts`, `Created characters`) VALUES ('0', '0')", TABLE9) mysql_query(g_SqlTuple, "IgnoreHandle", g_query) } mysql_free(query) } return PLUGIN_CONTINUE; }
Logs
Código PHP: Welcome to the AMX Mod X 1.8.1-300 Compiler. Copyright (c) 1997-2006 ITB CompuPhase, AMX Mod X Team
C:\Program Files\Counter-Strike-Zombie\cstrike\addons\amxmodx\scripting\include\mysqlt.inc(239) : warning 203: symbol is never used: "query" Warning: Tag mismatch on line 2187 Warning: Tag mismatch on line 4679 Warning: Tag mismatch on line 4692 Warning: Tag mismatch on line 4693 Warning: Tag mismatch on line 4694 Warning: Tag mismatch on line 4695 Warning: Tag mismatch on line 4696 Warning: Tag mismatch on line 4697 Warning: Tag mismatch on line 4698 Warning: Tag mismatch on line 4743 Warning: Tag mismatch on line 4787 Warning: Tag mismatch on line 4859 Warning: Tag mismatch on line 4860 Warning: Tag mismatch on line 4861 Warning: Tag mismatch on line 4862 Warning: Tag mismatch on line 4863 Warning: Tag mismatch on line 4864 Warning: Tag mismatch on line 4865 Warning: Tag mismatch on line 4875 Warning: Tag mismatch on line 4876 Warning: Tag mismatch on line 4877 Warning: Tag mismatch on line 4878 Warning: Tag mismatch on line 4879 Warning: Tag mismatch on line 4880 Warning: Tag mismatch on line 4881 Warning: Tag mismatch on line 4882 Warning: Tag mismatch on line 4883 Warning: Tag mismatch on line 4884 Warning: Tag mismatch on line 4895 Warning: Tag mismatch on line 4896 Warning: Tag mismatch on line 4897 Warning: Tag mismatch on line 4898 Warning: Tag mismatch on line 4908 Warning: Tag mismatch on line 4909 Warning: Tag mismatch on line 4910 Warning: Tag mismatch on line 4911 Warning: Tag mismatch on line 4912 Warning: Tag mismatch on line 4913 Warning: Tag mismatch on line 4914 Warning: Tag mismatch on line 4915 Warning: Tag mismatch on line 4916 Warning: Tag mismatch on line 4917 Warning: Tag mismatch on line 4918 Warning: Tag mismatch on line 4919 Warning: Tag mismatch on line 4920 Warning: Tag mismatch on line 4921 Warning: Tag mismatch on line 4922 Warning: Tag mismatch on line 4923 Warning: Tag mismatch on line 4924 Warning: Tag mismatch on line 4925 Warning: Tag mismatch on line 4926 Warning: Tag mismatch on line 4927 Warning: Tag mismatch on line 4928 Warning: Tag mismatch on line 4929 Warning: Tag mismatch on line 4930 Warning: Tag mismatch on line 4931 Warning: Tag mismatch on line 4932 Warning: Tag mismatch on line 4933 Warning: Tag mismatch on line 4943 Warning: Tag mismatch on line 4944 Warning: Tag mismatch on line 4945 Warning: Tag mismatch on line 4946 Warning: Tag mismatch on line 4947 Warning: Tag mismatch on line 4948 Warning: Tag mismatch on line 4949 Warning: Tag mismatch on line 4950 Warning: Tag mismatch on line 4951 Warning: Tag mismatch on line 4952 Warning: Tag mismatch on line 4962 Warning: Tag mismatch on line 4963 Warning: Tag mismatch on line 4964 Warning: Tag mismatch on line 4965 Warning: Tag mismatch on line 4966 Warning: Tag mismatch on line 4967 Warning: Tag mismatch on line 4968 Warning: Tag mismatch on line 4969 Warning: Tag mismatch on line 4970 Warning: Tag mismatch on line 4980 Warning: Tag mismatch on line 4981 Warning: Tag mismatch on line 4982 Warning: Tag mismatch on line 4983 Warning: Tag mismatch on line 4994 Warning: Tag mismatch on line 4995 Warning: Tag mismatch on line 4996 Warning: Tag mismatch on line 4997 Warning: Tag mismatch on line 5002 Warning: Tag mismatch on line 5007 Header size: 12624 bytes Code size: 589804 bytes Data size: 417268 bytes Stack/heap size: 16384 bytes; max. usage is unknown, due to recursion Total requirements: 1036080 bytes
88 Warnings. Done.
tan solo con que me ayudes a solucionar el error de ese public yo solucionare los demás ya que son puros errores con el IF ese.
|