My gs from this theared dont crash, but dont ask me source, bcz i added my own Leader System for my Project and more more more customs =).Gs crash((((
My gs from this theared dont crash
if you not hard release this fix or if fix released repost here, its help other coders like RacRac to fix. Because he dont fix it in this release.
use [MuOnline]
GO
/****** Object: Table [dbo].[T_LuckyCoinRegCount] Script Date: 02/06/2012 07:02:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING OFF
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[T_LuckyCoinRegCount]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[T_LuckyCoinRegCount](
[AccountID] [varchar](10) NOT NULL,
[Name] [varchar](10) NOT NULL,
[ServerCode] [smallint] NOT NULL,
[CoinCount] [int] NOT NULL,
[LastRegDate] [smalldatetime] NOT NULL
) ON [PRIMARY]
END
GO
SET ANSI_PADDING OFF
GO
--//************************************************************************
--// 내 용 : 7주년 이벤트 행운의 동전 등록
--// 부 서 : MU_STUDIO
--// 만들일 : 2008..11
--// 만들이 : 전일곤
--// 수정 : 김대원 2009.07.16 SUMMER EVENT
--//
--// 리턴값 설명
--//
--//************************************************************************
CREATE PROCEDURE [dbo].[SP_REQ_REGEIST_COIN]
[USER=412249]Server[/USER]Code smallint,
[USER=162874]account[/USER]ID varchar( 10 ),
[USER=1333344765]name[/USER] varchar( 10 ),
[USER=1333340598]reg[/USER]Coin int
AS
BEGIN
IF [USER=412249]Server[/USER]Code = 12) -- 12 면 테스트서버(등록 이벤트 제외)
BEGIN
SELECT -1 AS Result
RETURN
END
SET NOCOUNT ON
SET XACT_ABORT ON -- 에러발생시 모든 트랜잭션 취소
DECLARE @nCoinCount int
SET LOCK_TIMEOUT 1000 -- 트랜잭션 장기 잠금처리를 막기 위해서
BEGIN TRANSACTION
IF EXISTS ( SELECT AccountID FROM T_LuckyCoinRegCount WHERE AccountID = [USER=162874]account[/USER]ID AND Name = [USER=1333344765]name[/USER] AND ServerCode = [USER=412249]Server[/USER]Code)
BEGIN
SELECT @nCoinCount = CoinCount FROM T_LuckyCoinRegCount WHERE AccountID = [USER=162874]account[/USER]ID AND Name = [USER=1333344765]name[/USER] AND ServerCode = [USER=412249]Server[/USER]Code
SET @nCoinCount = @nCoinCount + [USER=1333340598]reg[/USER]Coin
UPDATE T_LuckyCoinRegCount SET CoinCount = @nCoinCount, LastRegDate = GetDate() WHERE AccountID = [USER=162874]account[/USER]ID AND Name = [USER=1333344765]name[/USER] AND ServerCode = [USER=412249]Server[/USER]Code
--SELECT @nCoinCount AS Result
SELECT SUM(CoinCount) As Result FROM T_LuckyCoinRegCount WHERE AccountID = [USER=162874]account[/USER]ID group by AccountID
-- 위 내용 추가 by natinda
END
ELSE
BEGIN
INSERT T_LuckyCoinRegCount VALUES ( [USER=162874]account[/USER]ID, [USER=1333344765]name[/USER], [USER=412249]Server[/USER]Code, [USER=1333340598]reg[/USER]Coin, GetDate() )
--SELECT [USER=1333340598]reg[/USER]Coin AS Result
SELECT SUM(CoinCount) As Result FROM T_LuckyCoinRegCount WHERE AccountID = [USER=162874]account[/USER]ID group by AccountID
END
IF( @@Error <>0 )
ROLLBACK TRANSACTION
ELSE
COMMIT TRANSACTION
SET NOCOUNT OFF
END
GO
--//************************************************************************
--// 내 용 : 7주년 이벤트 행운의 동전
--// 부 서 : MU_STUDIO
--// 만들일 : 2008.11.11
--// 만들이 : 전일곤
--// 수정 : 김대원 SUMMER EVENT 2009.07.16
--// 리턴값 설명
--//
--//************************************************************************
CREATE PROCEDURE [dbo].[SP_REQ_GET_COIN_COUNT]
[USER=412249]Server[/USER]Code smallint,
[USER=162874]account[/USER]ID varchar( 10 ),
[USER=1333344765]name[/USER] varchar( 10 )
AS
BEGIN
--BEGIN TRANSACTION
SET NOCOUNT ON
-- SET XACT_ABORT ON -- 에러발생시 모든 트랜잭션 취소
DECLARE @nCoinCount int
-- SET LOCK_TIMEOUT 1000 -- 트랜잭션 장기 잠금처리를 막기 위해서
-- IF EXISTS ( SELECT AccountID FROM T_LuckyCoinRegCount WHERE AccountID = [USER=162874]account[/USER]ID AND Name = [USER=1333344765]name[/USER] AND ServerCode = [USER=412249]Server[/USER]Code)
IF EXISTS ( SELECT AccountID FROM T_LuckyCoinRegCount WHERE AccountID = [USER=162874]account[/USER]ID)
BEGIN
--SELECT CoinCount AS Result FROM T_LuckyCoinRegCount WHERE AccountID = [USER=162874]account[/USER]ID AND Name = [USER=1333344765]name[/USER] AND ServerCode = [USER=412249]Server[/USER]Code
SELECT sum(CoinCount) AS Result FROM T_LuckyCoinRegCount WHERE AccountID = [USER=162874]account[/USER]ID group by AccountID
-- 위 내용 추가
END
ELSE
BEGIN
-- 동전 등록시 INSERT
--INSERT T_LuckyCoinRegCount VALUES ( [USER=162874]account[/USER]ID, [USER=1333344765]name[/USER], [USER=412249]Server[/USER]Code, 0, GetDate() )
SELECT 0 AS Result
END
-- IF( @@Error <>0 )
-- ROLLBACK TRANSACTION
-- ELSE
-- COMMIT TRANSACTION
SET NOCOUNT OFF
ENDTy bro, also needed fix RF and SUM cart if not hard release it too.
give me your skype.
Ty bro, amazing =) can you share fixed dataserver, because my dataserver from this theared bugged (Dublicate character(only visual) / Kill Monster, but he stay(visual))
![RacRac - [Development] Community Edition Season6 Episode3 z-Team - RaGEZONE Forums](http://sia1.subirimagenes.net/img/2014/08/03/140803085604676352.png "RacRac - [Development] Community Edition Season6 Episode3 z-Team - RaGEZONE Forums")
Because this happens
Since I solve this problem.
i use windows 7 ultimate and vs 2010 pack 1
Help please
Thanks
i'm have all files in data\custom\
wtf??? how to fix this bug? meybe its "CheatGuard" folder buged?
VMBEGIN
VMEND#define VMPROTECT
#include "VMProtectSDK.h"#include "VMProtectSDK.h"
![guild-alliance - [Development] Community Edition Season6 Episode3 z-Team - RaGEZONE Forums](https://forum.ragezone.com/data/attachments/89/89746-c6b05acac77e1760cc637bfe40eac0ee.jpg "guild-alliance - [Development] Community Edition Season6 Episode3 z-Team - RaGEZONE Forums")
