Guild Bugg.

05/12/2012 22:46 STIV123#1

Put things in GWH. Get dc. and things are in GWH + They are in ur invertory

Doubled.. any1 know the reason ? o.O Ty

05/12/2012 23:34 treica#2

Code:

USE PS_GameLog;
GO
drop procedure [dbo].[usp_Insert_Action_Log_E]
GO

SET QUOTED_IDENTIFIER ON 
GO
SET ANSI_NULLS ON 
GO


/****** Object: Stored Procedure dbo.usp_Insert_Action_Log_E FIXED ********.com Twilight ******/

CREATE Proc usp_Insert_Action_Log_E



@UserID varchar(18),
@UserUID int,
@CharID int,
@CharName varchar(50),
@CharLevel tinyint,
@CharExp int,
@MapID smallint,
@PosX real,
@PosY real,
@PosZ real,
@ActionTimeZ varchar(50),
@ActionType tinyint,
@Value1 bigint = null,
@Value2 int = null,
@Value3 int = null,
@Value4 bigint = null,
@Value5 int = null,
@Value6 int = null,
@Value7 int = null,
@Value8 int = null,
@Value9 int = null,
@Value10 int = null,
@Text1 varchar(100) = '',
@Text2 varchar(100) = '',
@Text3 varchar(100) = '',
@Text4 varchar(100) = '',
@Sql nvarchar(4000) = '',
@yyyy varchar(4) = '',
@mm varchar(2) = '',
@dd varchar(2) = '',
@Bucket smallint = -1

AS
DECLARE @ActionTime as datetime
SELECT @ActionTime = CONVERT(datetime, @ActionTimeZ, 120)
SET @yyyy = datepart(yyyy, @ActionTime)
SET @mm = datepart(mm, @ActionTime)
SET @dd = datepart(dd, @ActionTime)


IF(LEN(@mm) = 1)
BEGIN
SET @mm = '0' + @mm
END

IF(LEN(@dd) = 1)
BEGIN
SET @dd = '0' + @dd
END

SET @Sql = N'
INSERT INTO PS_GameLog.dbo.ActionLog
(UserID, UserUID, CharID, CharName, CharLevel, CharExp, MapID, PosX, PosY, PosZ, ActionTime, ActionType, 
Value1, Value2, Value3, Value4, Value5, Value6, Value7, Value8, Value9, Value10, Text1, Text2, Text3, Text4)
VALUES(@UserID, @UserUID, @CharID, @CharName, @CharLevel, @CharExp, @MapID, @PosX, @PosY, @PosZ, @ActionTime, @ActionType, 
@Value1, @Value2, @Value3, @Value4, @Value5, @Value6, @Value7, @Value8, @Value9, @Value10, @Text1, @Text2, @Text3, @Text4)'

EXEC sp_executesql @Sql, 
N'@UserID varchar(18), @UserUID int, @CharID int, @CharName varchar(50), 
@CharLevel tinyint, @CharExp int, @MapID smallint, @PosX real, @PosY real, @PosZ real, @ActionTime datetime, @ActionType tinyint, 
@Value1 bigint, @Value2 int, @Value3 int, @Value4 bigint, @Value5 int, @Value6 int, @Value7 int, @Value8 int, 
@Value9 int, @Value10 int, @Text1 varchar(100), @Text2 varchar(100), @Text3 varchar(100), @Text4 varchar(100)',
@UserID, @UserUID, @CharID, @CharName, @CharLevel, @CharExp, @MapID, @PosX, @PosY, @PosZ, @ActionTime, @ActionType, 
@Value1, @Value2, @Value3, @Value4, @Value5, @Value6, @Value7, @Value8, @Value9, @Value10, @Text1, @Text2, @Text3, @Text4

GO
SET QUOTED_IDENTIFIER OFF 
GO
SET ANSI_NULLS ON 
GO

try this if will not work, then use The Search function should be there somewhere.

05/12/2012 23:47 STIV123#3

Ok Thanks. Quuery was successfully completed.

I have 1 more question tho. It's. How can i put that every new made char has a SKILL resset stone in the bagg? Ty.

05/12/2012 23:54 treica#4

If you really wanna thanks then see is a THANKS button under my post, push it :)

About it has been take a discussion here where you need to go to set it up
[Only registered and activated users can see links. Click Here To Register...]
I never tryed it so up on the right corner is such a white box Search engine try it out is very usefull.

05/13/2012 02:49 STIV123#5

And.. Every Server Restart 1 Fury Guild poof gone.. Idk for what reason :S Can anyone help meh?

Ty

05/13/2012 11:50 treica#6

type the following code for your guild db's you have created something before and it is crashing cuz is using again the row.

Code:

truncate table PS_GameData.dbo.Guilds
Truncate table PS_GameData.dbo._GuildDetailsBack
truncate table PS_GameData.dbo._GuildRankPoint
truncate table PS_GameData.dbo._GuildsBack
truncate table PS_GameData.dbo.GuildChars
truncate table PS_GameData.dbo.GuildDetails
truncate table PS_GameData.dbo.GuildNpcLv
truncate table PS_GameData.dbo.GuildRankLog
truncate table PS_GameData.dbo.GuildRankLog2
truncate table PS_GameData.dbo.GuildStoredItems

Then delete the table named dbo.Guilds and run this query

Code:

USE [PS_GameData]
GO
/****** Creation Guild Fixed by sandolkakos: Shaiya-UGO Server - www.universalgamesonline.com.br  ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[Guilds](
	[RowID] [int] IDENTITY(1,1) NOT NULL,
	[GuildID] [int] NOT NULL,
	[GuildName] [varchar](30) COLLATE Chinese_PRC_Stroke_CI_AS NOT NULL,
	[MasterUserID] [varchar](18) COLLATE Chinese_PRC_Stroke_CI_AS NOT NULL,
	[MasterCharID] [int] NOT NULL,
	[MasterName] [varchar](30) COLLATE Chinese_PRC_Stroke_CI_AS NOT NULL,
	[Country] [tinyint] NOT NULL,
	[TotalCount] [smallint] NOT NULL,
	[GuildPoint] [int] NOT NULL,
	[Del] [tinyint] NOT NULL CONSTRAINT [DF_Guilds_Del]  DEFAULT ((0)),
	[CreateDate] [datetime] NOT NULL,
	[DeleteDate] [datetime] NULL,
 CONSTRAINT [PK_Guilds] PRIMARY KEY CLUSTERED 
(
	[GuildID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF

For me it fixed the problem should do for you too :P