Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[Release] zTeam eX802 Repack with fixes

Skilled Illusionist
Joined
Jul 16, 2013
Messages
317
Reaction score
9
Hi! Tell me, please, what is this item editor?
Thx.
IzsMuEditor



DomiTori - [Release] zTeam eX802 Repack with fixes - RaGEZONE Forums

DomiTori - [Release] zTeam eX802 Repack with fixes - RaGEZONE Forums

DomiTori - [Release] zTeam eX802 Repack with fixes - RaGEZONE Forums


Look I didn't use my editor for how many days.. but my character returns to all kris again -_-
I think this is a big bug for this files that we need to figure out and fix :(
 
Newbie Spellweaver
Joined
Sep 27, 2015
Messages
24
Reaction score
0
Anyone having a problem with level? Sometimes it stuck on 370/ 381 / 399
 
Newbie Spellweaver
Joined
Aug 4, 2015
Messages
39
Reaction score
0
Someone help me removed the ancient drop from Medusa Event, because it's not in event item bag but it still drop ancient
 
Newbie Spellweaver
Joined
Oct 1, 2015
Messages
34
Reaction score
1
Hello everybody! Please tell me this is normal when you can be registered through the client?
I opt for a server, insert new account and a new password, and I go to the game. There is an automatic registration.

How to disable this?

Thx.
 
Junior Spellweaver
Joined
Sep 16, 2015
Messages
198
Reaction score
16
[00:04:02] [DataServer] SELECT Count FROM web_Monster_Achiev WHERE Name = 'admin' AND MonsterID = 71
[00:04:02] [DataServer] SQLSTATE:42S02, SQLSTRING:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'web_Monster_Achiev'.
[00:04:02] [DataServer] UPDATE web_Monster_Achiev SET Count = Count + 1 WHERE Name = 'admin' AND MonsterID = 71
[00:04:02] [DataServer] SQLSTATE:42S02, SQLSTRING:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'web_Monster_Achiev'.
[00:04:02] [DataServer] SELECT Count FROM web_Monster_Ranking WHERE Name = 'admin' AND MonsterID = 71
[00:04:02] [DataServer] SQLSTATE:42S02, SQLSTRING:[Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'web_Monster_Ranking'.
[00:04:02] [DataServer] UPDATE web_Monster_Ranking SET Count = Count + 1 WHERE Name = 'admin AND MonsterID = 71


What columns or tables i need to add to fix this ?
 
Custom Title Activated
Loyal Member
Joined
Apr 6, 2007
Messages
1,806
Reaction score
483
[00:04:02][SQL Server]Invalid object name 'web_Monster_Achiev'.
[00:04:02][SQL Server]Invalid object name 'web_Monster_Ranking'.


What columns or tables i need to add to fix this ?

look at the error part i pointed out.....
Anyways; thats cuz you're lacking those two tables; but i dont know the exact columns they need.....i know Count column is needed on achiev table...should be a int type; and with default 0. (No nulls allowed.)....but i dont lnow about the rest of columns as i dont have those tables....i think those are part of MVCore web....check it out maybe it helps.
 
Joined
Nov 4, 2012
Messages
928
Reaction score
545
This tables is a custom of zTeam for an mu-server that i can't remember.

Here is a temp fix for this, need tests.
Why is a temp fix? R. I did not know if i will need to create more tables than this :D

Code:
USE MuOnline
GO

/****** Object:  Table [dbo].[web_Mix_Achiev]    Script Date: 19/09/2015 20:52:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[web_Mix_Achiev]
(
	[Name] [varchar](11) NOT NULL DEFAULT '',
	[Successe] INT NOT NULL DEFAULT 0,
	[Fail] INT NOT NULL DEFAULT 0
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[web_Mix_Ranking]    Script Date: 19/09/2015 20:52:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[web_Mix_Ranking]
(
	[Name] [varchar](11) NOT NULL DEFAULT '',
	[Successe] INT NOT NULL DEFAULT 0,
	[Fail] INT NOT NULL DEFAULT 0
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[web_Monster_Achiev]    Script Date: 13/10/2015 10:11:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[web_Monster_Achiev]
(
	[Name] [varchar](11) NOT NULL DEFAULT '',
	[MonsterID] INT NOT NULL DEFAULT 0,
	[Count] INT NOT NULL DEFAULT 0
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[web_Monster_Ranking]    Script Date: 13/10/2015 10:11:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[web_Monster_Ranking]
(
	[Name] [varchar](11) NOT NULL DEFAULT '',
	[MonsterID] INT NOT NULL DEFAULT 0,
	[Count] INT NOT NULL DEFAULT 0
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[web_Event_Achiev]    Script Date: 13/10/2015 10:11:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[web_Event_Achiev]
(
	[Name] [varchar](11) NOT NULL DEFAULT '',
	[BC_Exp] INT NOT NULL DEFAULT 0,
	[BC_ExtExp] INT NOT NULL DEFAULT 0,
	[BC_Score] INT NOT NULL DEFAULT 0,
	[DS_Exp] INT NOT NULL DEFAULT 0,
	[DS_Point] INT NOT NULL DEFAULT 0,
	[CC_UKill] INT NOT NULL DEFAULT 0,
	[CC_MKill] INT NOT NULL DEFAULT 0,
	[CC_TExp] INT NOT NULL DEFAULT 0,
	[CC_RExp] INT NOT NULL DEFAULT 0
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
/****** Object:  Table [dbo].[web_Event_Ranking]    Script Date: 13/10/2015 10:11:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[web_Event_Ranking]
(
	[Name] [varchar](11) NOT NULL DEFAULT '',
	[BC_Exp] INT NOT NULL DEFAULT 0,
	[BC_ExtExp] INT NOT NULL DEFAULT 0,
	[BC_Score] INT NOT NULL DEFAULT 0,
	[DS_Exp] INT NOT NULL DEFAULT 0,
	[DS_Point] INT NOT NULL DEFAULT 0,
	[CC_UKill] INT NOT NULL DEFAULT 0,
	[CC_MKill] INT NOT NULL DEFAULT 0,
	[CC_TExp] INT NOT NULL DEFAULT 0,
	[CC_RExp] INT NOT NULL DEFAULT 0
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO

Updated, the fix :junglejane:
 
Last edited:
Newbie Spellweaver
Joined
Nov 20, 2012
Messages
10
Reaction score
0
I have this problem, servers are not visible on the client, this is the log of the connect server, please someone has a solution.
[05:34:30] [.\Settings.ini] Server settings loaded
[05:34:30] [.\ServerList.txt] Server list loaded [1]
[05:34:30] [.\WhiteList.txt] White list loaded [1]
[05:34:30] [.\BlackList.txt] Black list loaded [0]
[05:34:30] [Update] [55557] [Recv] Port created
[05:34:30] [Server] [44405] Port created
[05:34:31] [JoinServer] Update completed
[05:36:59] [Connect] [192.168.10.119] [0]
[05:37:07] [Error] Invalid PacketHeader [225] [34] [192.168.10.119]
[05:37:07] [Error] WSARecv() 10054
[05:37:07] [Disconnect] [192.168.10.119] [0]]
 
Last edited:
Back
Top