[English]Discussion

Cavatina;37745 schrieb:

Dear GodLikerz,
I am writing to you because you are really great. I have got very stupid bug and I don`t know how to fix it. Probably i have somethin wrong in .ini files or... .
I know that you runned server without any bugs.

My bug look that:
- When I am creating new character it says that name is in use. To play i have to back to server screen and again go to character screen, then I can choose character and play.
I know that it isn`t very big bug but it is strange...

I will give you my settings and if you can please tell me what is wrong, tell me please what I don`t have but you have.
Then...

1. Softwere
- MMSQL Server 2005
- SQL Server Management Studio Express
- Fame files
- Fame DataBase
- ODBC 5.1

2. My ini files


3. My ODBC settings:
- character01 for CHARACTER_01_DBF
- log01 for LOG_01_DBF
- login for ACCOUNT_DBF


So... that is all I think. If I forgot about something say me I will add.


I belive that you will help me. I really don`t know what is may be.


Yours
~Cavatina

Edin;40784 schrieb:

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

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

Pandu;44141 schrieb:

hello @ all,

could anyone give me the query 2 create an account?

- Pandu