[Release] Season XI (Server+Full Client)

[show40]

connection problem IGC.dll ss13 can you help me thanks

You have S13 Server???

 

[onlinezajzaj]

You have S13 Server???

No server ss13, only Client ss13 and Database ss13

 

[show40]

No server ss13, only Client ss13 and Database ss13

How do you login game?
I do not understand what you mean. . .

 

[onlinezajzaj]

How do you login game?
I do not understand what you mean. . .

i want you or can someone share me ss13 server, is this difficult or not? I am currently in Taiwan so can not Register QQ @@

 

[show40]

i want you or can someone share me ss13 server, is this difficult or not? I am currently in Taiwan so can not Register QQ @@

I can help you Register

 

[show40]

Is Cool....`~~~`

 

[hugab1]

Is Cool....`~~~`

View attachment 162570View attachment 162571

Please share with me too

ipipin2@gmail.com

 

[jhnjohnny]

DS Event BC Error (How fix?)
SQLSTATE: 42000, Diagnosis: [Microsoft][ODBC SQL Server Driver][SQL Server] IGC_GremoryCase_AddItem, Specified too many parameters.

Hi,

Run in SQL:

USE [MuOnline]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[IGC_GremoryCase_AddItem]
	@szAccountID varchar(10),
	@szName	varchar(10),
	@StorageType int,
	@RewardSource int,
	@ItemID int,
	@ItemLevel int,
	@ItemDurability int,
	@ItemOp1 int,
	@ItemOp2 int,
	@ItemOp3 int,
	@ItemExcOption int,
	@ItemSetOption int,
	@ItemSocket1 int,
	@ItemSocket2 int,
	@ItemSocket3 int,
	@ItemSocket4 int,
	@ItemSocket5 int,
	@ItemMainAttribute int,
	@ItemMuunEvoItemType int,
	@ItemMuunEvoItemIndex int,
 [USER=482628]rec[/USER]eiveDate bigint,
 [USER=874653]Expire[/USER]Date bigint
AS
BEGIN
	SET NOCOUNT ON;

	DECLARE @ItemsInStorage int
	SET @ItemsInStorage = (SELECT COUNT(*) FROM IGC_GremoryCase WHERE AccountID = @szAccountID AND ((Name = @szName AND StorageType = 2) OR StorageType = 1))

	IF (@ItemsInStorage >= 50)
	BEGIN
		WHILE (@ItemsInStorage >= 50)
		BEGIN
			DELETE FROM IGC_GremoryCase WHERE AccountID = @szAccountID AND ((Name = @szName AND StorageType = 2) OR StorageType = 1) AND ReceiveDate = 
			(SELECT MIN(ReceiveDate) FROM IGC_GremoryCase WHERE AccountID = @szAccountID AND ((Name = @szName AND StorageType = 2) OR StorageType = 1))
			SET @ItemsInStorage = @ItemsInStorage - 1
		END
	END

	DECLARE [USER=789557]Free[/USER]ItemGUID int
	SET [USER=789557]Free[/USER]ItemGUID = 0

	WHILE (1 = 1)
	BEGIN
		IF NOT EXISTS (SELECT * FROM IGC_GremoryCase WHERE AccountID = @szAccountID AND ((Name = @szName AND StorageType = 2) OR StorageType = 1) AND ItemGUID = [USER=789557]Free[/USER]ItemGUID)
		BEGIN
			BREAK
		END
		SET [USER=789557]Free[/USER]ItemGUID = [USER=789557]Free[/USER]ItemGUID + 1
	END

	DECLARE [USER=789557]Free[/USER]AuthCode int
	SET [USER=789557]Free[/USER]AuthCode = 0

	WHILE (1 = 1)
	BEGIN
		SET [USER=789557]Free[/USER]AuthCode = ROUND(((2000000000 - 1 -1) * RAND() + 1), 0)
		IF NOT EXISTS (SELECT * FROM IGC_GremoryCase WHERE AuthCode = [USER=789557]Free[/USER]AuthCode)
		BEGIN
			BREAK
		END
	END

	INSERT INTO IGC_GremoryCase (AccountID, Name, StorageType, RewardSource, ItemGUID, AuthCode, ItemID, ItemLevel, ItemDurability, ItemOp1, ItemOp2, ItemOp3, ItemExcOption, ItemSetOption, ItemSocket1, ItemSocket2, ItemSocket3, ItemSocket4, ItemSocket5, ItemMainAttribute, ItemMuunEvoItemType, ItemMuunEvoItemIndex, ReceiveDate, ExpireDate) VALUES
	(@szAccountID, @szName, @StorageType, @RewardSource, [USER=789557]Free[/USER]ItemGUID, [USER=789557]Free[/USER]AuthCode, @ItemID, @ItemLevel, @ItemDurability, @ItemOp1, @ItemOp2, @ItemOp3, @ItemExcOption, @ItemSetOption, @ItemSocket1, @ItemSocket2, @ItemSocket3, @ItemSocket4, @ItemSocket5, @ItemMainAttribute, @ItemMuunEvoItemType, @ItemMuunEvoItemIndex, [USER=482628]rec[/USER]eiveDate, [USER=874653]Expire[/USER]Date)


	SELECT [USER=789557]Free[/USER]ItemGUID AS ItemGUID, [USER=789557]Free[/USER]AuthCode AS AuthCode
END

Good Luck!!!

 

[ianvalls90]

Hi,

Run in SQL:


USE [MuOnline]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

create PROCEDURE [dbo].[IGC_GremoryCase_AddItem]
@szAccountID varchar(10),
@szNamevarchar(10),
@StorageType int,
@RewardSource int,
@ItemID int,
@ItemLevel int,
@ItemDurability int,
@ItemOp1 int,
@ItemOp2 int,
@ItemOp3 int,
@ItemExcOption int,
@ItemSetOption int,
@ItemSocket1 int,
@ItemSocket2 int,
@ItemSocket3 int,
@ItemSocket4 int,
@ItemSocket5 int,
@ItemMainAttribute int,
@ItemMuunEvoItemType int,
@ItemMuunEvoItemIndex int,
receiveDate bigint,
ExpireDate bigint
AS
BEGIN
SET NOCOUNT ON;

DECLARE @ItemsInStorage int
SET @ItemsInStorage = (SELECT COUNT(*) FROM IGC_GremoryCase WHERE AccountID = @szAccountID AND ((Name = @szName AND StorageType = 2) OR StorageType = 1))

IF (@ItemsInStorage >= 50)
BEGIN
WHILE (@ItemsInStorage >= 50)
BEGIN
DELETE FROM IGC_GremoryCase WHERE AccountID = @szAccountID AND ((Name = @szName AND StorageType = 2) OR StorageType = 1) AND ReceiveDate =
(SELECT MIN(ReceiveDate) FROM IGC_GremoryCase WHERE AccountID = @szAccountID AND ((Name = @szName AND StorageType = 2) OR StorageType = 1))
SET @ItemsInStorage = @ItemsInStorage - 1
END
END

DECLARE FreeItemGUID int
SET FreeItemGUID = 0

WHILE (1 = 1)
BEGIN
IF NOT EXISTS (SELECT * FROM IGC_GremoryCase WHERE AccountID = @szAccountID AND ((Name = @szName AND StorageType = 2) OR StorageType = 1) AND ItemGUID = FreeItemGUID)
BEGIN
BREAK
END
SET FreeItemGUID = FreeItemGUID + 1
END

DECLARE FreeAuthCode int
SET FreeAuthCode = 0

WHILE (1 = 1)
BEGIN
SET FreeAuthCode = ROUND(((2000000000 - 1 -1) * RAND() + 1), 0)
IF NOT EXISTS (SELECT * FROM IGC_GremoryCase WHERE AuthCode = FreeAuthCode)
BEGIN
BREAK
END
END

INSERT INTO IGC_GremoryCase (AccountID, Name, StorageType, RewardSource, ItemGUID, AuthCode, ItemID, ItemLevel, ItemDurability, ItemOp1, ItemOp2, ItemOp3, ItemExcOption, ItemSetOption, ItemSocket1, ItemSocket2, ItemSocket3, ItemSocket4, ItemSocket5, ItemMainAttribute, ItemMuunEvoItemType, ItemMuunEvoItemIndex, ReceiveDate, ExpireDate) VALUES
(@szAccountID, @szName, @StorageType, @RewardSource, FreeItemGUID, FreeAuthCode, @ItemID, @ItemLevel, @ItemDurability, @ItemOp1, @ItemOp2, @ItemOp3, @ItemExcOption, @ItemSetOption, @ItemSocket1, @ItemSocket2, @ItemSocket3, @ItemSocket4, @ItemSocket5, @ItemMainAttribute, @ItemMuunEvoItemType, @ItemMuunEvoItemIndex, receiveDate, ExpireDate)


SELECT FreeItemGUID AS ItemGUID, FreeAuthCode AS AuthCode
END

Appreciate this, i didnt have the time to make this and share it for them....non the less, try to use [ code ] [ /code ] tags.

 

[show40]

Hi,

Run in SQL:

USE [MuOnline]
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[IGC_GremoryCase_AddItem]
	@szAccountID varchar(10),
	@szName	varchar(10),
	@StorageType int,
	@RewardSource int,
	@ItemID int,
	@ItemLevel int,
	@ItemDurability int,
	@ItemOp1 int,
	@ItemOp2 int,
	@ItemOp3 int,
	@ItemExcOption int,
	@ItemSetOption int,
	@ItemSocket1 int,
	@ItemSocket2 int,
	@ItemSocket3 int,
	@ItemSocket4 int,
	@ItemSocket5 int,
	@ItemMainAttribute int,
	@ItemMuunEvoItemType int,
	@ItemMuunEvoItemIndex int,
 [USER=482628]rec[/USER]eiveDate bigint,
 [USER=874653]Expire[/USER]Date bigint
AS
BEGIN
	SET NOCOUNT ON;

	DECLARE @ItemsInStorage int
	SET @ItemsInStorage = (SELECT COUNT(*) FROM IGC_GremoryCase WHERE AccountID = @szAccountID AND ((Name = @szName AND StorageType = 2) OR StorageType = 1))

	IF (@ItemsInStorage >= 50)
	BEGIN
		WHILE (@ItemsInStorage >= 50)
		BEGIN
			DELETE FROM IGC_GremoryCase WHERE AccountID = @szAccountID AND ((Name = @szName AND StorageType = 2) OR StorageType = 1) AND ReceiveDate = 
			(SELECT MIN(ReceiveDate) FROM IGC_GremoryCase WHERE AccountID = @szAccountID AND ((Name = @szName AND StorageType = 2) OR StorageType = 1))
			SET @ItemsInStorage = @ItemsInStorage - 1
		END
	END

	DECLARE [USER=789557]Free[/USER]ItemGUID int
	SET [USER=789557]Free[/USER]ItemGUID = 0

	WHILE (1 = 1)
	BEGIN
		IF NOT EXISTS (SELECT * FROM IGC_GremoryCase WHERE AccountID = @szAccountID AND ((Name = @szName AND StorageType = 2) OR StorageType = 1) AND ItemGUID = [USER=789557]Free[/USER]ItemGUID)
		BEGIN
			BREAK
		END
		SET [USER=789557]Free[/USER]ItemGUID = [USER=789557]Free[/USER]ItemGUID + 1
	END

	DECLARE [USER=789557]Free[/USER]AuthCode int
	SET [USER=789557]Free[/USER]AuthCode = 0

	WHILE (1 = 1)
	BEGIN
		SET [USER=789557]Free[/USER]AuthCode = ROUND(((2000000000 - 1 -1) * RAND() + 1), 0)
		IF NOT EXISTS (SELECT * FROM IGC_GremoryCase WHERE AuthCode = [USER=789557]Free[/USER]AuthCode)
		BEGIN
			BREAK
		END
	END

	INSERT INTO IGC_GremoryCase (AccountID, Name, StorageType, RewardSource, ItemGUID, AuthCode, ItemID, ItemLevel, ItemDurability, ItemOp1, ItemOp2, ItemOp3, ItemExcOption, ItemSetOption, ItemSocket1, ItemSocket2, ItemSocket3, ItemSocket4, ItemSocket5, ItemMainAttribute, ItemMuunEvoItemType, ItemMuunEvoItemIndex, ReceiveDate, ExpireDate) VALUES
	(@szAccountID, @szName, @StorageType, @RewardSource, [USER=789557]Free[/USER]ItemGUID, [USER=789557]Free[/USER]AuthCode, @ItemID, @ItemLevel, @ItemDurability, @ItemOp1, @ItemOp2, @ItemOp3, @ItemExcOption, @ItemSetOption, @ItemSocket1, @ItemSocket2, @ItemSocket3, @ItemSocket4, @ItemSocket5, @ItemMainAttribute, @ItemMuunEvoItemType, @ItemMuunEvoItemIndex, [USER=482628]rec[/USER]eiveDate, [USER=874653]Expire[/USER]Date)


	SELECT [USER=789557]Free[/USER]ItemGUID AS ItemGUID, [USER=789557]Free[/USER]AuthCode AS AuthCode
END

Good Luck!!!

Or not

 

[jhnjohnny]

Or not

It's working perfect for me.

:top:

 

[show40]

It's working perfect for me.

:top:

OK....Thanks....:w00t:



GameServer log error:
[TMonsterSkillElement] ForceSkillElement(): m_iElementType unknown value: 24

Why.....?

 

[jhnjohnny]

OK....Thanks....:w00t:



GameServer log error:
[TMonsterSkillElement] ForceSkillElement(): m_iElementType unknown value: 24

Why.....?

Monster_Skill_Element: 23 and 24 does not exist (in GameServer/Source)

So in IGC_Monster_Skill_Element.xml change:

<Element Number="111" Type="23"
<Element Number="113" Type="24"

TO:

<Element Number="111" Type="20"
<Element Number="113" Type="20"


Good Look!!

 

[diegah]

Are you fixing something else that events like s10, s11 and s12 mixes? regards.

 

[show40]

Monster_Skill_Element: 23 and 24 does not exist (in GameServer/Source)

So in IGC_Monster_Skill_Element.xml change:

<Element Number="111" Type="23"
<Element Number="113" Type="24"

TO:

<Element Number="111" Type="20"
<Element Number="113" Type="20"


Good Look!!

<Element Number="111" Type="23" SuccessRate="100" ContinuanceTime="0" IncAndDecType="-1" IncAndDecValue="-1" NullifiedMagic="-1" CharacterClass="0" CharacterLevel="0" Name="Core Magriffy Clone" />
<Element Number="113" Type="24" SuccessRate="100" ContinuanceTime="10" IncAndDecType="-1" IncAndDecValue="-1" NullifiedMagic="2" CharacterClass="0" CharacterLevel="0" Name="Lord of Ferea Attack in Target Area" />


Specific how to modify? Thanks````

 

[diegah]

Change both "Type" numbers 23 and 24 to 20.. which else is working or being fixed show??

 

[show40]

Change both "Type" numbers 23 and 24 to 20.. which else is working or being fixed show??

Are you sure can fix??



I use MU.ToolKit [Silver Edition] tool add pet Muun item
Buy Success Petwarehouse no item....
how fix X shop buy pet muun sucess no item

 

[diegah]

try it, the error says that you are using a skill that does not exist.

How are that files did you fixed something else?? new mixes working? hunting log?

 

[jhnjohnny]

<Element Number="111" Type="23" SuccessRate="100" ContinuanceTime="0" IncAndDecType="-1" IncAndDecValue="-1" NullifiedMagic="-1" CharacterClass="0" CharacterLevel="0" Name="Core Magriffy Clone" />
<Element Number="113" Type="24" SuccessRate="100" ContinuanceTime="10" IncAndDecType="-1" IncAndDecValue="-1" NullifiedMagic="2" CharacterClass="0" CharacterLevel="0" Name="Lord of Ferea Attack in Target Area" />


Specific how to modify? Thanks````

Yes!!

In IGCData\Monsters\Skills\IGC_Monster_Skill_Element.xml

Change:

<Element Number="111" Type="23" SuccessRate="100" ContinuanceTime="0" IncAndDecType="-1" IncAndDecValue="-1" NullifiedMagic="-1" CharacterClass="0" CharacterLevel="0" Name="Core Magriffy Clone" />
<Element Number="113" Type="24" SuccessRate="100" ContinuanceTime="10" IncAndDecType="-1" IncAndDecValue="-1" NullifiedMagic="2" CharacterClass="0" CharacterLevel="0" Name="Lord of Ferea Attack in Target Area" />

TO:

<Element Number="111" Type="20" SuccessRate="100" ContinuanceTime="0" IncAndDecType="-1" IncAndDecValue="-1" NullifiedMagic="-1" CharacterClass="0" CharacterLevel="0" Name="Core Magriffy Clone" />
<Element Number="113" Type="20" SuccessRate="100" ContinuanceTime="10" IncAndDecType="-1" IncAndDecValue="-1" NullifiedMagic="2" CharacterClass="0" CharacterLevel="0" Name="Lord of Ferea Attack in Target Area" />

OK? Thankss!

 

[hugab1]

On s12-1s13 How to connect clientsWhat is?