Most visitors online was 10613 , on 26 Apr 2024
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!Need help here, DataServer is always "Not Responding" i waited for so long and it doesn't change.
Maybe i just overlooked something, any idea guys?
NVM/ ODBC issue
DarkLord's horse cannot be displayed. When using another database, it can be displayed. Is there any way to solve that problem in the other database?
I have fixed the Errtel creation, but it just seems like there is something missing globally. What I mean is that whenever you put something into the cells for creating Errtel or upgrading it, there are no items in lpObj->m_playerData->pPentagramMixSystem, all problems come from that. Maybe someone has a knowledge of where to look, because unfortunately I'm not that good at c++ and especially at developing MuOnline servers.
the bot help is completely bugged.
first : I cant save settings, they are deleted after reconnection.
third : I asked nothing and my caracter pick up all items xd
second : Logs arent not saved
I didn't have this error. How about other skills? Is there any error show in the Sameserver / Dataserver console?I have problems with the scroll evil spirit! I buy it in the market and when I add it it disappears from the inventory but it does not appear in the list of the skills! someone had the same problem?
I put it to work thanks!What I can not fix the one that does not run the database of the battlecore throws me this ODBC error that I do not know how to solve it and I tried several things but I could not !!
[00:05:29] SELECT ItemCount FROM GameServerInfo WHERE Number = 0[00:05:29] SQLSTATE: 42S02, Diagnosis: [Microsoft][ODBC SQL Server Driver][SQL Server]El nombre de objeto 'GameServerInfo' no es válido.
USE [MuOnline]
GO
/****** Object: Table [dbo].[GameServerInfo] ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[GameServerInfo](
[Number] [int] NOT NULL,
[ItemCount] [bigint] NULL,
[ZenCount] [int] NULL,
[GmItemCount] [int] NULL,
[AceItemCount] [int] NULL,
[GensRankingMonth] [int] NULL,
CONSTRAINT [PK_GameServerInfo] PRIMARY KEY NONCLUSTERED
(
[Number] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF,
ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[GameServerInfo] ADD CONSTRAINT [DF_GameServerInfo_Number]
DEFAULT ((0)) FOR [Number]
GO
ALTER TABLE [dbo].[GameServerInfo] ADD CONSTRAINT [DF_GameServerInfo_ZenCount]
DEFAULT ((0)) FOR [ZenCount]
GO
ALTER TABLE [dbo].[GameServerInfo] ADD DEFAULT ((1)) FOR [GensRankingMonth]
GO
USE [MuOnline]
GO
/****** Object: StoredProcedure [dbo].[WZ_GetItemSerial2] ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE Procedure [dbo].[WZ_GetItemSerial2]
@iAddSerialCount int
AS
BEGIN
DECLARE @ItemSerial bigint
SET NOCOUNT ON
BEGIN TRANSACTION
UPDATE GameServerInfo
SET @ItemSerial = ItemCount = ItemCount+@iAddSerialCount
IF ( @@error <> 0 )
BEGIN
ROLLBACK TRANSACTION
SELECT -1
END
ELSE
BEGIN
COMMIT TRANSACTION
SELECT @ItemSerial-@iAddSerialCount+1 AS ItemSerial
END
SET NOCOUNT OFF
END
GO
USE [MuOnline]
GO
INSERT [dbo].[GameServerInfo] ([Number] ,[ItemCount], [ZenCount], [GmItemCount], [AceItemCount], [GensRankingMonth]) VALUES (0, 0, 0, 0, 0, 0)
GO
USE [MuOnline] GO /****** Objeto: Tabla [dbo].
[GameServerInfo] ******/
SET
ANSI_NULLS ON
GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo]. [GameServerInfo] (
[Número] [int]
NO NULL, [ItemCount] [bigint] NULL,
[ZenCount] [int] NULL,
[GmItemCount] [int]
NULL, [AceItemCount] [int] NULL, [GensRankingMonth] [int] NULL,
CONSTRAINT [PK_GameServerInfo] PRIMARY KEY NONCLUSTERED
(
[Number] ASC
)WITH (PAD_INDEX ALLOW_PAGE_LOCKS
ALLOW_ROW_LOCKS IGNORE_DUP_KEY STATISTICS_NORECOMPUTE de " ON
[PRIMARY]
GO ALTER TABLE [dbo]. [GameServerInfo] ADD CONSTRAINT [DF_GameServerInfo_Number]
DEFAULT ((0))
FOR [Number] GO ALTER TABLE [dbo]. [GameServerInfo]
ADD CONSTRAINT [DF_GameServerInfo_ZenCount] DEFAULT ((0))
FOR
[ZenCount] GO ALTER TABLE [dbo]. [GameServerInfo]
ADD DEFAULT ((1)) FOR [GensRankingMonth] GO
USE
[MuOnline] GO /****** Objeto: StoredProcedure [dbo]. [WZ_GetItemSerial2]
******/ SET
ANSI_NULLS ON
GO SET QUOTED_IDENTIFIER ON GO CREATE Procedure [dbo]. [WZ_GetItemSerial2]
@iAddSerialCount int
AS BEGIN DECLARE @ItemSerial bigint SET NOCOUNT ON BEGIN TRANSACTION UPDATE GameServerInfo SET @ItemSerial ? ItemCount ? ItemCount + @iAddSerialCount IF ( @@error <> 0 ) BEGIN ROLLBACK TRANSACTION SELECT -1 END ELSE BEGIN COMMIT TRANSACTION SELECT @ItemSerial-@iAddSerialCount+1 ASItemSerial END SET NOCOUNT OFF GO
USE
[MuOnline] GO
INSERT [dbo]. [GameServerInfo] ([Number] ,[ItemCount], [ZenCount], [GmItemCount], [AceItemCount], [GensRankingMonth]) VALORES (0, 0, 0, 0,
0, 0)
GO