MuOnline ex700Plus Server Files [b.5]

[kanka916]

Arena not work
error/Warping to that specific location unavaliabe at the moment

[MarceliinGT]

Small habit can u share protocol for ex 700?

[580497]

Hi! I have a problem!
1) I go to MuMaker and make a one acc = OK!
2) I go to the game I write login and password = OK!
3) Сreate a character = OK!
4) I try to go at it and I can not! and GS gives error as in the screenshot =(

Please help can sql that I added, for example "Changes in database:
AccountCharacter - [ExtendedWarehouseCount] [tinyint] NOT NULL DEFAULT (0) - Add New
Character - [Inventory] [varbinary] (3776) NULL - Update
Character - [ExtendedInvenCount] [tinyint] NOT NULL DEFAULT (0) - Add New
warehouse - [Items] [varbinary] (3840) NULL - Update " if that is the problem Explain how to fix, Thanks!

[580497]

help please

[Yag4mi2k]

@580497

using ist query in quert analyzer in db MuOnline

USE MuOnline BEGIN TRANSACTION SET QUOTED_IDENTIFIER ON SET TRANSACTION ISOLATION LEVEL SERIALIZABLE SET ARITHABORT ON SET NUMERIC_ROUNDABORT OFF SET CONCAT_NULL_YIELDS_NULL ON SET ANSI_NULLS ON SET ANSI_PADDING ON SET ANSI_WARNINGS ON COMMIT BEGIN TRANSACTION ALTER TABLE dbo.[Character] DROP CONSTRAINT DF_Character_cLevel GO ALTER TABLE dbo.[Character] DROP CONSTRAINT DF_Character_LevelUpPoint GO ALTER TABLE dbo.[Character] DROP CONSTRAINT DF_Character_Experience GO ALTER TABLE dbo.[Character] DROP CONSTRAINT DF_Character_Money GO ALTER TABLE dbo.[Character] DROP CONSTRAINT DF_Character_MapDir GO ALTER TABLE dbo.[Character] DROP CONSTRAINT DF_Character_PkCount GO ALTER TABLE dbo.[Character] DROP CONSTRAINT DF_Character_PkLevel GO ALTER TABLE dbo.[Character] DROP CONSTRAINT DF_Character_PkTime GO ALTER TABLE dbo.[Character] DROP CONSTRAINT DF_Character_CtlCode GO ALTER TABLE dbo.[Character] DROP CONSTRAINT DF__Character__DbVer__3A4CA8FD GO ALTER TABLE dbo.[Character] DROP CONSTRAINT DF__Character__Quest__40F9A68C GO ALTER TABLE dbo.[Character] DROP CONSTRAINT DF__Character__Leade__6FB49575 GO ALTER TABLE dbo.[Character] DROP CONSTRAINT DF__Character__ChatL__70A8B9AE GO ALTER TABLE dbo.[Character] DROP CONSTRAINT DF__Character__Fruit__44CA3770 GO ALTER TABLE dbo.[Character] DROP CONSTRAINT DF_Character_ExtendedInvenCount GO ALTER TABLE dbo.[Character] DROP CONSTRAINT DF__Character__Reset__3DF31CAF GO ALTER TABLE dbo.[Character] DROP CONSTRAINT DF__Character__reset__3EE740E8 GO ALTER TABLE dbo.[Character] DROP CONSTRAINT DF__Character__reset__3FDB6521 GO ALTER TABLE dbo.[Character] DROP CONSTRAINT DF__Character__reset__40CF895A GO ALTER TABLE dbo.[Character] DROP CONSTRAINT DF__Character__MRese__41C3AD93 GO ALTER TABLE dbo.[Character] DROP CONSTRAINT DF__Character__PkCou__42B7D1CC GO ALTER TABLE dbo.[Character] DROP CONSTRAINT DF__Character__HeroC__43ABF605 GO CREATE TABLE dbo.Tmp_Character ( AccountID varchar(10) COLLATE Chinese_PRC_CI_AS NOT NULL, Name varchar(10) COLLATE Chinese_PRC_CI_AS NOT NULL, cLevel int NULL, LevelUpPoint int NULL, Class tinyint NULL, Experience int NULL, Strength smallint NULL, Dexterity smallint NULL, Vitality smallint NULL, Energy smallint NULL, Inventory varbinary(3776) NULL, MagicList varbinary(180) NULL, Money int NULL, Life real NULL, MaxLife real NULL, Mana real NULL, MaxMana real NULL, MapNumber smallint NULL, MapPosX smallint NULL, MapPosY smallint NULL, MapDir tinyint NULL, PkCount int NULL, PkLevel int NULL, PkTime int NULL, MDate smalldatetime NULL, LDate smalldatetime NULL, CtlCode tinyint NOT NULL, DbVersion tinyint NULL, Quest varbinary(50) NULL, Leadership smallint NULL, ChatLimitTime smallint NULL, FruitPoint int NULL, JHDX varchar(10) COLLATE Chinese_PRC_CI_AS NULL, JHtype tinyint NULL, ExtendedInvenCount tinyint NOT NULL, CTM_Image varchar(50) NULL, Resets int NOT NULL, resetsDay int NOT NULL, resetsWeek int NOT NULL, resetsMonth int NOT NULL, MResets int NOT NULL, PkCountWeb int NOT NULL, HeroCountWeb int NOT NULL, ExGameServerCode char(10) NULL ) ON [PRIMARY] GO ALTER TABLE dbo.Tmp_Character ADD CONSTRAINT DF_Character_cLevel DEFAULT (1) FOR cLevel GO ALTER TABLE dbo.Tmp_Character ADD CONSTRAINT DF_Character_LevelUpPoint DEFAULT (0) FOR LevelUpPoint GO ALTER TABLE dbo.Tmp_Character ADD CONSTRAINT DF_Character_Experience DEFAULT (0) FOR Experience GO ALTER TABLE dbo.Tmp_Character ADD CONSTRAINT DF_Character_Money DEFAULT (0) FOR Money GO ALTER TABLE dbo.Tmp_Character ADD CONSTRAINT DF_Character_MapDir DEFAULT (0) FOR MapDir GO ALTER TABLE dbo.Tmp_Character ADD CONSTRAINT DF_Character_PkCount DEFAULT (0) FOR PkCount GO ALTER TABLE dbo.Tmp_Character ADD CONSTRAINT DF_Character_PkLevel DEFAULT (3) FOR PkLevel GO ALTER TABLE dbo.Tmp_Character ADD CONSTRAINT DF_Character_PkTime DEFAULT (0) FOR PkTime GO ALTER TABLE dbo.Tmp_Character ADD CONSTRAINT DF_Character_CtlCode DEFAULT (0) FOR CtlCode GO ALTER TABLE dbo.Tmp_Character ADD CONSTRAINT DF__Character__DbVer__3A4CA8FD DEFAULT (0) FOR DbVersion GO ALTER TABLE dbo.Tmp_Character ADD CONSTRAINT DF__Character__Quest__40F9A68C DEFAULT (0) FOR Quest GO ALTER TABLE dbo.Tmp_Character ADD CONSTRAINT DF__Character__Leade__6FB49575 DEFAULT (0) FOR Leadership GO ALTER TABLE dbo.Tmp_Character ADD CONSTRAINT DF__Character__ChatL__70A8B9AE DEFAULT (0) FOR ChatLimitTime GO ALTER TABLE dbo.Tmp_Character ADD CONSTRAINT DF__Character__Fruit__44CA3770 DEFAULT (0) FOR FruitPoint GO ALTER TABLE dbo.Tmp_Character ADD CONSTRAINT DF_Character_ExtendedInvenCount DEFAULT (0) FOR ExtendedInvenCount GO ALTER TABLE dbo.Tmp_Character ADD CONSTRAINT DF__Character__Reset__3DF31CAF DEFAULT (0) FOR Resets GO ALTER TABLE dbo.Tmp_Character ADD CONSTRAINT DF__Character__reset__3EE740E8 DEFAULT (0) FOR resetsDay GO ALTER TABLE dbo.Tmp_Character ADD CONSTRAINT DF__Character__reset__3FDB6521 DEFAULT (0) FOR resetsWeek GO ALTER TABLE dbo.Tmp_Character ADD CONSTRAINT DF__Character__reset__40CF895A DEFAULT (0) FOR resetsMonth GO ALTER TABLE dbo.Tmp_Character ADD CONSTRAINT DF__Character__MRese__41C3AD93 DEFAULT (0) FOR MResets GO ALTER TABLE dbo.Tmp_Character ADD CONSTRAINT DF__Character__PkCou__42B7D1CC DEFAULT (0) FOR PkCountWeb GO ALTER TABLE dbo.Tmp_Character ADD CONSTRAINT DF__Character__HeroC__43ABF605 DEFAULT (0) FOR HeroCountWeb GO IF EXISTS(SELECT * FROM dbo.[Character]) EXEC('INSERT INTO dbo.Tmp_Character (AccountID, Name, cLevel, LevelUpPoint, Class, Experience, Strength, Dexterity, Vitality, Energy, Inventory, MagicList, Money, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, MapDir, PkCount, PkLevel, PkTime, MDate, LDate, CtlCode, DbVersion, Quest, Leadership, ChatLimitTime, FruitPoint, JHDX, JHtype, ExtendedInvenCount, CTM_Image, Resets, resetsDay, resetsWeek, resetsMonth, MResets, PkCountWeb, HeroCountWeb) SELECT AccountID, Name, cLevel, LevelUpPoint, Class, Experience, Strength, Dexterity, Vitality, Energy, Inventory, MagicList, Money, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, MapDir, PkCount, PkLevel, PkTime, MDate, LDate, CtlCode, DbVersion, Quest, Leadership, ChatLimitTime, FruitPoint, JHDX, JHtype, ExtendedInvenCount, CTM_Image, Resets, resetsDay, resetsWeek, resetsMonth, MResets, PkCountWeb, HeroCountWeb FROM dbo.[Character] TABLOCKX') GO DROP TABLE dbo.[Character] GO EXECUTE sp_rename N'dbo.Tmp_Character', N'Character', 'OBJECT' GO ALTER TABLE dbo.[Character] ADD CONSTRAINT PK_Character PRIMARY KEY NONCLUSTERED ( Name ) ON [PRIMARY] GO CREATE TRIGGER [kris] ON dbo.[Character] AFTER INSERT AS update character set inventory = 0xFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFFF from inserted where character.name = inserted.name and character.class = 96 GO COMMIT

[SmallHabit]

To all those who is seeking this thread. Project is not dead. I haven't much time. But still continuing project. Here is the video of Damage Visual bug fixes, I thought that it would be great if you would see the correct damage ^_^. Also there will be also fix for HP,MP,SD,ST visuals. When all will be completed I will leave there links to GS and Main with fixes. Good luck to all.



P.S. Now maximum damage can be up to 4,294,967,295 instead of 65,535.

[mauka]

LOOOOOOOOOOOOOOOOOOOOOL.. Pro, its client side only r GS needs to be coded to?

[SmallHabit]

Sure thing that I modded GS, just added two bytes to Damage protocol and Monster Die(there is also damage when monster dies)... ^_^

[580497]

@580497

using ist query in quert analyzer in db MuOnline

I'm sorry but you can step by step, and this base Muonline I'm not very well versed.

Thanks!

SmallHabit one can please give me your MuOnline.bak 2008R2 and I do not understand the configurations. or will explain step by step how to do it right. Thank you!

[Faronnia]

Awesome to get some news, man. I think we, as users/testers, won't have any problems waiting for updates. I know you have a life, as do we all, so slow progress with a currently free software dev/beta testing phases is to be expected, by all reasonable means.

So.., ye, thanks for the heads up glad your still alive and that my bugs list didn't give you a heart attack or something XD

[MAXDANGER]

I'm very happy, Seeing finally the forum
coming back to the origins.

Where was worked by the collectivity
the community.

In a project wherein everybody helped
fix, test, and share:
learning, files and so on.

Creating an option for those
they who need a stable, secure, and free version.

because the real reason of one community exist
is for collectivity sharing discoveries and growth
all together.

thank you
guys

[MFSoft]

SmallHabit , Already has some correction to the spells / skills that will add to relog? thank you

[tornado25]

Sure thing that I modded GS, just added two bytes to Damage protocol and Monster Die(there is also damage when monster dies)... ^_^

when you do more update ?

[metallica]

well not offense but try the next time dont post a real picture please...

Anyway any can post How edit "that" function about damage? what is in the sources?

And what other chance we need? if e.g we use a main S6?

[xDarKyx]

I'm glad that the project continues, hopefully a little faster. :D
Waiting for further updates man. :)