Beiträge von Haris31

Hi,

I would know if there is a happened to save the accounts/characters/inventory when we go to a v11 db to a v14 db

Google traduction :

Hallo,

Ich wollte kennen, ob es eine Lösung gibt, um keine Kontos(Zählen) / characteres / Inventare zu beseitigen, wenn wir eines db v11 in db 14 gehen

You speak of these npc's ?

Check my character.inc
MEGAUPLOAD - The leading online storage and file delivery service

Zitat von Edin;40784

Hello GodLikerz ;)
So, i have got everything working now, but theres one problem (ore maybe more?) left:
Everytime, i try to get past the Serverscreen (where the Channels are listed), i get this error:
and in my error.txt + CQuery-LogFile is the following content:

How do i fix this?

Greetings,
Edin

Execute it in your CHARACTER_01_DBF :

Zitat

USE [CHARACTER_01_DBF]
GO
/****** Objet*: StoredProcedure [dbo].[MAIL_STR_REALTIME] Date de génération du script*: 10/23/2009 23:30:17 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/****** Object: Stored Procedure dbo.MAIL_STR_REALTIME Script Date: 7/29/2008 3:34:04 AM ******/
ALTER proc [dbo].[MAIL_STR_REALTIME]

@iGu CHAR(2),
@serverindex CHAR(2),
@nMail_Before INT = 0,
@nMail_After INT = 0,
@idPlayer CHAR(7) = '0000000',
@nLevel INT = 0,
@iaccount VARCHAR(32) = '',
@tmCreate INT = 0,
@dwSerialNumber INT = 0,
@nHitPoint INT = 0
as
set nocount on

declare @sdate VARCHAR
declare @edate VARCHAR
declare @iserverindex char(2)

set @sdate = '2007-07-18 00:00:00'--'2007-07-10 00:00:00' -- '2007-07-18 00:00:00'
set @edate = '2007-08-31 23:59:00'--'2007-07-10 23:00:00' -- '2007-08-31 23:59:00'
set @iserverindex = cast((cast(@serverindex as int) + 50) as char(2))

IF @iGu = 'S1'
BEGIN
SELECT * FROM MAIL_TBL
WHERE serverindex = @iserverindex AND byRead<90
ORDER BY nMail
RETURN
END
ELSE
IF @iGu = 'U1'
BEGIN
UPDATE MAIL_TBL SET nMail = @nMail_After, serverindex = @serverindex, dwSerialNumber = @dwSerialNumber, nHitPoint = @nHitPoint
WHERE serverindex = @iserverindex and nMail = @nMail_Before
RETURN
END
ELSE
IF @iGu = 'I1'
BEGIN
-- 추천 이벤트 기간인지 확인
IF(getdate() < @sdate or getdate() > @edate) BEGIN
RETURN
END
-- 추천인 인지 확인 -- select top 10 * from ACCOUNT_DBF.dbo.tblEventRecommend
-- IF( NOT EXISTS(SELECT * FROM ACCOUNT_DBF.dbo.tblEventRecommend where byaccount = @iaccount ) ) BEGIN
-- RETURN
-- END

-- 받을수 있는 아이템이 있는지 확인
DECLARE @ItemID int
DECLARE @ItemNum int
DECLARE @bBinds int
SET @ItemID = 0
SET @ItemNum = 1
SET @bBinds = 2

IF( @nLevel = 20 ) BEGIN
SET @ItemID = 26112
END
ELSE IF( @nLevel = 40 ) BEGIN
SET @ItemID = 26211
END
ELSE IF( @nLevel = 60 ) BEGIN
SET @ItemID = 26103
END
ELSE IF( @nLevel = 80 ) BEGIN
SET @ItemID = 30135
END
ELSE IF( @nLevel = 100 ) BEGIN
SET @ItemID = 5800
SET @bBinds = 0
END
ELSE IF( @nLevel = 120 ) BEGIN
SET @ItemID = 4703
SET @bBinds = 0
END

IF( @ItemID = 0 ) BEGIN
RETURN
END

-- 메일 아이디 할당 하기
DECLARE @nMaxMailID int
SELECT @nMaxMailID = MAX(nMail)+1 from MAIL_TBL where serverindex = @iserverindex
SET @nMaxMailID = ISNULL( @nMaxMailID, 0 )

-- 아이템 주기
DECLARE @szTitle VARCHAR(128)
DECLARE @szText VARCHAR(1024)
SET @szTitle = '레벨 업을 축하 드립니다!'
SET @szText = '캐릭터 레벨 업 기념 상품을 보내드립니다 ^ㅁ^* 프리프와 함께 즐거운 하루 보내시기 바랍니다. 감사합니다.'

EXEC dbo.MAIL_STR 'A1', @nMaxMailID, @iserverindex, @idPlayer, '0000000', 0, @tmCreate, 0, @szTitle, @szText,@ItemID, @ItemNum, 0, 0, 0, 0, @bBinds
RETURN
END

Alles anzeigen