- Joined
- Oct 6, 2010
- Messages
- 539
- Reaction score
- 241
connection problem IGC.dll ss13 can you help me thanks
You have S13 Server???
Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature currently requires accessing the site using the built-in Safari browser.
connection problem IGC.dll ss13 can you help me thanks
You have S13 Server???
No server ss13, only Client ss13 and Database ss13
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 @@
DS Event BC Error (How fix?)
SQLSTATE: 42000, Diagnosis: [Microsoft][ODBC SQL Server Driver][SQL Server] IGC_GremoryCase_AddItem, Specified too many parameters.
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
Appreciate this, i didnt have the time to make this and share it for them....non the less, try to use [ code ] [ /code ] tags.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
Hi,
Run in SQL:
Code: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!!!
It's working perfect for me.
:top:
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!!
Change both "Type" numbers 23 and 24 to 20.. which else is working or being fixed show??
<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````