[Z0MBERTH]

Buenas comunidad, el dнa de hoy trabajando en mi gamemode mysql me entero de un pequeсo problema, pasa que al registrar el jugador crea su debida columna en la base de datos, pero al desconectar no guarda los datos sacados, si el jugador reloguea y vuelve a iniciar secciуn & desconecta guarda los datos cуmo deberнa ser, їDesean echarle un vistazo al cуdigo o algъn consejo para arreglarlo? (Estuve leyendo todo el post de BlueG a ver si encontraba algo - MySQL R39-4), un saludo.

[N3cromancer]

Esta un poco confuso el problema hermano, detalla un poco mas la falla del script.

[Z0MBERTH]

Quote:

Originally Posted by N3cromancer Esta un poco confuso el problema hermano, detalla un poco mas la falla del script.

Lo acabo de aclarar perfectamente, no es culpa mнa que no hayas metido lуgica al asunto, de igual manera seguirй viendo las funciones del plugin, saludos (Espero ayuda de alguien.)

[DesingMyCry]

Quote:

Originally Posted by Zo0mer Lo acabo de aclarar perfectamente, no es culpa mнa que no hayas metido lуgica al asunto, de igual manera seguirй viendo las funciones del plugin, saludos (Espero ayuda de alguien.)

Bajo esa premisa, nadie deberнa contestarte ya que al ser un problema de tu script (y no de el gestor de base de datos) no haz "metido" lуgica a el --problema--.

Partamos por definiciones bбsicas... al registrar un usuario, crea una tabla? Ojala estйs confundiendo tablas con inserciones (columnas).

El problema principal, no se puede saber con certeza sin tener el cуdigo, pero por lуgica supongo que al intentar guardar los datos en la desconexiуn, hay una condiciуn para saber si dicho jugador ingresу a la cuenta (superу el login), y si es cierto, actualiza los datos. Bajo este punto, al registrar al usuario, la variable contenedora de esa informaciуn no se establece en el valor que deberнa.

[GaBO!]

Quote:

Originally Posted by Zo0mer Lo acabo de aclarar perfectamente, no es culpa mнa que no hayas metido lуgica al asunto, de igual manera seguirй viendo las funciones del plugin, saludos (Espero ayuda de alguien.)

si vas a pedir ayudar, trata que la descripcion de tu problema sea lo mas clara posible

[N3cromancer]

Quote:

Originally Posted by Zo0mer Lo acabo de aclarar perfectamente, no es culpa mнa que no hayas metido lуgica al asunto, de igual manera seguirй viendo las funciones del plugin, saludos (Espero ayuda de alguien.)

Anda a mamarte un guebo pedazo de malagradecido, por eso se te joden las mierdas nadie deberнa ayudarte por ser tan boca floja.

[Juance]

Podrнas postear el OnPlayerDisconnect de tu gamemode o al menos la funciуn donde haces el guardado y asн podremos ayudarte mejor.

Y recorda que para que otros acudan a ayudarte, debes ser agradecido en todo momento. Ya que los que estamos acб, estamos para ayudar al otro y a nadie se le estб pagando por estar acб, es por voluntad propia el ayudar, asн que se amable.

[bm0z]

Mira que hay veces que uno pide ayuda y espera que se lo resuelvan con una venda en los ojos, pero este no uno de esos caso, es uno de esos casos donde un mal educado se pone a responder temas sin siquiera leer el post inicial.

En fin, volviendo al tema, el plugin no genera un archivo de log? Lo otro que puedes hacer es poner un printf con el cуdigo sql y ejecutarlo desde phpMyAdmin para ver que error te da.

Sino sube el cуdigo aquн para ver que puede ser.

[Z0MBERTH]

Estuve chequeando lo que me 'DesingMyCry', pero en realidad tanto cуmo Loguear/Registrar da lo mismos valores , en menos de un minuto editarй el este mensaje para dejar el MYSQL_LOG.txt

EDITO: Acб esta el 'Mysql_log.txt'

Код:

[12:08:45] [DEBUG] mysql_connect - host: "localhost", user: "root", database: "roleplay", password: "****", port: 3306, autoreconnect: true, pool_size: 2
[12:08:45] [DEBUG] CMySQLHandle::Create - creating new connection..
[12:08:45] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called
[12:08:45] [DEBUG] CMySQLHandle::Create - connection created (id: 1)
[12:08:45] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[12:08:45] [DEBUG] CMySQLConnection::Connect - connection was successful
[12:08:45] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[12:08:45] [DEBUG] mysql_errno - connection: 1
[12:08:45] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[12:08:45] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[12:08:45] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[12:08:45] [DEBUG] CMySQLConnection::Connect - connection was successful
[12:08:45] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[12:08:45] [DEBUG] CMySQLConnection::Connect - connection was successful
[12:08:45] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[12:08:45] [DEBUG] CMySQLConnection::Connect - connection was successful
[12:08:45] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[12:09:34] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT `Password`, `ID` FROM `usuarios` WHERE `Nombre` = '%e' LIMIT 1"
[12:09:34] [DEBUG] mysql_tquery - connection: 1, query: "SELECT `Password`, `ID` FROM `usuarios` WHERE `Nombre` = 'Jorge_", callback: "ShowLoginOrRegister", format: "i"
[12:09:34] [DEBUG] CMySQLQuery::Execute[ShowLoginOrRegister] - starting query execution
[12:09:34] [DEBUG] CMySQLQuery::Execute[ShowLoginOrRegister] - query was successfully executed within 183.454 milliseconds
[12:09:34] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[12:09:34] [DEBUG] Calling callback "ShowLoginOrRegister"..
[12:09:34] [DEBUG] cache_get_data - connection: 1
[12:09:34] [DEBUG] cache_get_data - connection: 1
[12:09:34] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[12:09:52] [DEBUG] cache_insert_id - connection: 1
[12:09:52] [WARNING] cache_insert_id - no active cache
[12:09:52] [DEBUG] mysql_format - connection: 1, len: 2000, format: "INSERT INTO `usuarios` (`Nombre`, `IP`, `Password`, `PosX`, `PosY`, `PosZ`, `PosA`, `Vida`, `Chaleco`, `Admin`, `Dinero`, `Sexo`..."
[12:09:52] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO `usuarios` (`Nombre`, `IP`, `Password`, `PosX`, `Pos", callback: "(null)", format: "i"
[12:09:52] [DEBUG] mysql_format - connection: 1, len: 180, format: "SELECT * FROM `usuarios` WHERE `Nombre` = '%s'"
[12:09:52] [DEBUG] mysql_query - connection: 1, query: "SELECT * FROM `usuarios` WHERE `Nombre` = 'Jorge_Mayor'", use_cache: true
[12:09:52] [DEBUG] CMySQLQuery::Execute - starting query execution
[12:09:52] [DEBUG] CMySQLQuery::Execute - query was successfully executed within 1.609 milliseconds
[12:09:52] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[12:09:52] [DEBUG] CMySQLHandle::SaveActiveResult - cache saved (id: 1)
[12:09:52] [DEBUG] mysql_format - connection: 1, len: 1000, format: "UPDATE `usuarios` SET `PosX` = '%.4f', `PosY` = '%.4f', `PosZ` = '%.4f', `PosA` = '%.4f', `Vida` = '%.4f', `Chaleco` = '%.4f', `..."
[12:09:52] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `usuarios` SET `PosX` = '0.0000', `PosY` = '0.0000', `Pos", callback: "(null)", format: "(null)"
[12:09:52] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:09:52] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 49.534 milliseconds
[12:09:52] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[12:09:52] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:09:52] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 1.255 milliseconds
[12:09:52] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[12:11:00] [DEBUG] mysql_format - connection: 1, len: 180, format: "SELECT * FROM `usuarios` WHERE `Nombre` = '%s'"
[12:11:00] [DEBUG] mysql_query - connection: 1, query: "SELECT * FROM `usuarios` WHERE `Nombre` = 'Jorge_Mayor'", use_cache: true
[12:11:00] [DEBUG] CMySQLQuery::Execute - starting query execution
[12:11:00] [DEBUG] CMySQLQuery::Execute - query was successfully executed within 0.714 milliseconds
[12:11:00] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[12:11:00] [DEBUG] CMySQLHandle::SaveActiveResult - cache saved (id: 2)
[12:11:00] [DEBUG] mysql_format - connection: 1, len: 1000, format: "UPDATE `usuarios` SET `PosX` = '%.4f', `PosY` = '%.4f', `PosZ` = '%.4f', `PosA` = '%.4f', `Vida` = '%.4f', `Chaleco` = '%.4f', `..."
[12:11:00] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `usuarios` SET `PosX` = '1657.5860', `PosY` = '-2285.4200", callback: "(null)", format: "(null)"
[12:11:00] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[12:11:00] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.633 milliseconds
[12:11:00] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving

[Jking]

Quote:

Originally Posted by Zo0mer Код: [12:09:52] [DEBUG] mysql_query - connection: 1, query: "SELECT * FROM `usuarios` WHERE `Nombre` = 'Jorge_Mayor'", use_cache: true [12:09:52] [DEBUG] CMySQLQuery::Execute - starting query execution [12:09:52] [DEBUG] CMySQLQuery::Execute - query was successfully executed within 1.609 milliseconds [12:09:52] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [12:09:52] [DEBUG] CMySQLHandle::SaveActiveResult - cache saved (id: 1) [12:09:52] [DEBUG] mysql_format - connection: 1, len: 1000, format: "UPDATE `usuarios` SET `PosX` = '%.4f', `PosY` = '%.4f', `PosZ` = '%.4f', `PosA` = '%.4f', `Vida` = '%.4f', `Chaleco` = '%.4f', `..." [12:09:52] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `usuarios` SET `PosX` = '0.0000', `PosY` = '0.0000', `Pos", callback: "(null)", format: "(null)" [12:09:52] [DEBUG] CMySQLQuery::Execute[] - starting query execution [12:09:52] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 49.534 milliseconds [12:09:52] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving [12:09:52] [DEBUG] CMySQLQuery::Execute[] - starting query execution [12:09:52] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 1.255 milliseconds [12:09:52] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving [12:11:00] [DEBUG] mysql_format - connection: 1, len: 180, format: "SELECT * FROM `usuarios` WHERE `Nombre` = '%s'" [12:11:00] [DEBUG] mysql_query - connection: 1, query: "SELECT * FROM `usuarios` WHERE `Nombre` = 'Jorge_Mayor'", use_cache: true [12:11:00] [DEBUG] CMySQLQuery::Execute - starting query execution [12:11:00] [DEBUG] CMySQLQuery::Execute - query was successfully executed within 0.714 milliseconds [12:11:00] [DEBUG] CMySQLResult::CMySQLResult() - constructor called [12:11:00] [DEBUG] CMySQLHandle::SaveActiveResult - cache saved (id: 2) [12:11:00] [DEBUG] mysql_format - connection: 1, len: 1000, format: "UPDATE `usuarios` SET `PosX` = '%.4f', `PosY` = '%.4f', `PosZ` = '%.4f', `PosA` = '%.4f', `Vida` = '%.4f', `Chaleco` = '%.4f', `..." [12:11:00] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `usuarios` SET `PosX` = '1657.5860', `PosY` = '-2285.4200", callback: "(null)", format: "(null)" [12:11:00] [DEBUG] CMySQLQuery::Execute[] - starting query execution [12:11:00] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.633 milliseconds [12:11:00] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving

Hace tiempo que ese tipo de consultas no se hacen desde la aplicaciуn. Usa procedimientos almacenados, disparadores y vistas. Es mбs seguro y mбs rбpido.