Mu Server Titan Tech 11.11.92 Séason 6 Episodio 3 Repack TNT Skynet con MySQL

Ver el tema anterior Ver el tema siguiente Ir abajo

Mu Server Titan Tech 11.11.92 Séason 6 Episodio 3 Repack TNT Skynet con MySQL

Mensaje por Admin el Lun Mar 09, 2015 6:37 pm

Hola amigos aqui una vez mas haciendo cosas locas en esta oportunidad quise intentar crear un season 6 episode 3 con mysql.

[Tienes que estar registrado y conectado para ver esa imagen]

- Error de Castle Siege, mysql trae cambiado el formato de fecha por lo que al configurar tira error.
- No se puede crear personajes, cualquiera nombre que pongas tira error

[Tienes que estar registrado y conectado para ver esa imagen]

Aqui les dejo el log

LOG Errores del Mu:
Initialized log instance
Initializing Servers...
[AllowList] Loaded Successfull!
[DataServer1] Initializing database connection
[DataServer1] [DB] Connection Successfull!
[DataServer1] Connected to MuOnline@MuOnline database
[DataServer1] Initialized database connection
[DataServer1] Initializing IOCP system connection
[DataServer1] Server Listen OK. Port: 55960
[DataServer1] Initialized IOCP system connection
[DataServer2] Initializing database connection
[DataServer2] [DB] Connection Successfull!
[DataServer2] Connected to MuOnline@MuOnline database
[DataServer2] Initialized database connection
[DataServer2] Initializing IOCP system connection
[DataServer2] Server Listen OK. Port: 55962
[DataServer2] Initialized IOCP system connection
[JoinServer] Initializing database connection
[JoinServer] [DB] Connection Successfull!
[JoinServer] Connected to Me_MuOnline@MuOnlineJoinDB database
[JoinServer] Initialized database connection
[JoinServer] Initializing IOCP system connection
[JoinServer] Server Listen OK. Port: 55970
[JoinServer] Initialized IOCP system connection
14:52:22 UPDATE MEMB_STAT SET ConnectStat = 0, DisConnectTM =     now() WHERE ConnectStat = 1
[WzExDB] Initializing database connection
[WzExDB] [DB] Connection Successfull!
[WzExDB] Connected to MuOnline@MuOnline database
[WzExDB] Initialized database connection
[WzExDB] Initializing IOCP system connection
[WzExDB] Server Listen OK. Port: 55906
[WzExDB] Initialized IOCP system connection
14:52:22 SELECT * FROM Guild WHERE Number = G_Union
14:52:22 SELECT * FROM Guild WHERE Number <> G_Union
[WzExDB] [MuOnlineDB] GuildData Loaded in 0 msec
[PostServer] Initializing IOCP system connection
[PostServer] Server Listen OK. Port: 55998
[PostServer] Initialized IOCP system connection
Servers initialization in 516 msec
[WzExDB] connect : [0][127.0.0.1]
[WzExDB] [ExDB][ChatServer] Chat Server Connected
[JoinServer] connect : [0][127.0.0.1]
[DataServer1] connect : [0][127.0.0.1]
[JoinServer] GameServer connected Main PORT : 55901 CODE : 0
[PostServer] connect : [0][127.0.0.1]
[PostServer] [PostServer][0] Connection Success: Server Code 0
[DataServer2] connect : [0][127.0.0.1]
14:52:57 SELECT ItemCount FROM GameServerInfo WHERE Number=0
14:52:57 SELECT ItemCount FROM GameServerInfo WHERE Number=0
[WzExDB] connect : [1][127.0.0.1]
14:52:57 [WzExDB] [ExDB][ExDB] GameServer with ServerCode[0] connected.
[JoinServer] connect : [1][127.0.0.1]
[JoinServer] GameServer connected GSCS PORT : 55919 CODE : 19
[DataServer1] connect : [1][127.0.0.1]
[DataServer2] connect : [1][127.0.0.1]
14:53:12 SELECT ItemCount FROM GameServerInfo WHERE Number=0
14:53:12 SELECT ItemCount FROM GameServerInfo WHERE Number=0
[WzExDB] connect : [2][127.0.0.1]
14:53:12 [WzExDB] [ExDB][ExDB] GameServer with ServerCode[19] connected.
[PostServer] connect : [1][127.0.0.1]
[PostServer] [PostServer][1] Connection Success: Server Code 19
14:53:17 call WZ_CS_GetCastleTotalInfo 0,7
SQLSTATE:42000, Diagnosis:[MySQL][ODBC 5.1 Driver][mysqld-5.0.24a-community-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0,7' at line 1
14:53:47 SELECT * FROM MEMB_INFO WHERE memb___id='virgen'
[Object] User virgen has join
14:53:47 call         connect('virgen','Main','186.110.235.168')memb__pwd
SQLSTATE:42000, Diagnosis:[MySQL][ODBC 5.1 Driver][mysqld-5.0.24a-community-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'memb__pwd' at line 1
14:53:47 SELECT Id FROM AccountCharacter WHERE Id='virgen'
14:53:47 SELECT * FROM AccountCharacter WHERE Id='virgen'
14:53:47 SELECT SCFIsVip, SCFVipMoney, SCFVipDays, SCFWareVipCount, DateDiff(dd , out__days,    now()) as dateDifference, SCFLuckyCoins, SCFExtWarehouse FROM MuOnline.dbo.MEMB_INFO WHERE memb___id = 'virgen'
SQLSTATE:42000, Diagnosis:[MySQL][ODBC 5.1 Driver][mysqld-5.0.24a-community-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '    now()) as dateDifference, SCFLuckyCoins, SCFExtWarehouse FROM MuOnline.dbo.M' at line 1
14:53:47 SELECT AccountID,BotLife,BotMaxLife FROM MuOnline.dbo.BotPet WHERE AccountID='virgen' AND BotLife < BotMaxLife
SQLSTATE:42000, Diagnosis:[MySQL][ODBC 5.1 Driver][mysqld-5.0.24a-community-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.BotPet WHERE AccountID='virgen' AND BotLife < BotMaxLife' at line 1
14:53:47 SELECT MuItemShopList FROM MuOnline.dbo.MEMB_INFO where memb___id = 'virgen'
SQLSTATE:42000, Diagnosis:[MySQL][ODBC 5.1 Driver][mysqld-5.0.24a-community-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.MEMB_INFO where memb___id = 'virgen'' at line 1
14:53:47 SELECT MuItemShopGiftList FROM MuOnline.dbo.MEMB_INFO where memb___id = 'virgen'
SQLSTATE:42000, Diagnosis:[MySQL][ODBC 5.1 Driver][mysqld-5.0.24a-community-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.MEMB_INFO where memb___id = 'virgen'' at line 1
14:53:47 SELECT MuItemShopGiftMsg FROM MuOnline.dbo.MEMB_INFO where memb___id = 'virgen'
SQLSTATE:42000, Diagnosis:[MySQL][ODBC 5.1 Driver][mysqld-5.0.24a-community-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.MEMB_INFO where memb___id = 'virgen'' at line 1
14:53:47 SELECT WCoin,WCoinP,GoblinCoin FROM MuOnline.dbo.MEMB_INFO where memb___id= 'virgen'
SQLSTATE:42000, Diagnosis:[MySQL][ODBC 5.1 Driver][mysqld-5.0.24a-community-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.MEMB_INFO where memb___id= 'virgen'' at line 1
14:53:53 SELECT * FROM AccountCharacter WHERE Id='virgen'
14:53:53 WZ_CreateCharacter 'virgen', 'acero', '16'
SQLSTATE:42000, Diagnosis:[MySQL][ODBC 5.1 Driver][mysqld-5.0.24a-community-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WZ_CreateCharacter 'virgen', 'acero', '16'' at line 1
14:54:07 call         disconnect('virgen')
[Player] virgen has been deleted
14:54:12 call WZ_CW_InfoLoad 0
SQLSTATE:42000, Diagnosis:[MySQL][ODBC 5.1 Driver][mysqld-5.0.24a-community-nt]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0' at line 1
[JoinServer] Connection Closed, dwIoSize == 0 (Index:0)
[DataServer1] Connection Closed, dwIoSize == 0 (Index:0)
[PostServer] Connection Closed, dwIoSize == 0 (Index:0)
[WzExDB] Connection Closed, dwIoSize == 0 (Index:1)
[DataServer2] Connection Closed, dwIoSize == 0 (Index:0)
[JoinServer] Connection Closed, dwIoSize == 0 (Index:1)
[DataServer1] Connection Closed, dwIoSize == 0 (Index:1)
[DataServer2] Connection Closed, dwIoSize == 0 (Index:1)
[PostServer] Connection Closed, dwIoSize == 0 (Index:1)
[WzExDB] Connection Closed, dwIoSize == 0 (Index:2)
[WzExDB] Connection Closed, dwIoSize == 0 (Index:0)

Configurar El server

Cambiar las ip publica o No-Ip en los siguientes archivos

D:\MuServer\data\MapServerInfo.dat

D:\MuServer\TitanCS\Data\CSF_ServerList.cfg


Cambiar el usuario y contraseña, si usan su propio user y pass, viene configurado como "root"

Revisar bien porque hay varias partes donde cambiar.

D:\MuServer\CashShorpeditor\XTRMu.ini

D:\MuServer\TitanCS\Data\SCF_Config.ini

D:\MuServer\TitanLinkServer\Config.ini


Modificar la ODBC

Abrir ODBC.reg con el blok de notas, modificar el usuario, password y puerto, con la informacion de su mysql. Cambiamos todas las partes donde aparesca lo mismo. (ejemplo cambiamos lo que esta con color rojo)

"Driver"="C:\\Archivos de programa\\MySQL\\Connector ODBC 5.1\\myodbc5.dll"
"SERVER"="127.0.0.1"
"UID"="root"
"PWD"="root"
"DATABASE"="muonline"
"PORT"="3307"

Files Completos MuMelon

[Tienes que estar registrado y conectado para ver este vínculo]


Creditos
WebZen
Oracle
Titan Tech
Skynet
Virgen  Razz (Uploader)
avatar
Admin
Admin

Mensajes : 317
Fecha de inscripción : 28/08/2013
Edad : 32
Localización : Argentina

Ver perfil de usuario http://mumelon.activo.in

Volver arriba Ir abajo

Ver el tema anterior Ver el tema siguiente Volver arriba

- Temas similares

 
Permisos de este foro:
No puedes responder a temas en este foro.