[English]Discussion

[SIZE="4"]Cavatina[/SIZE] is you the psykeeper on eFlyff - Lawolf server?

if yes send me your msn by PM i am the Blade Blackfaster i can fix your server errors too!

hugs

Zitat von Cavatina;37745

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

Alles anzeigen

i've got the same issue.

Also i can't msg new players... cause it says name does not exist ... i'll have to restart the servers to make it work :whut:

some one know how to make new world id ?
i try to edit "defineWorld.h" - "World.inc" but i dont know i think i miss some think...

thanks for help =]

some one know how to make new world id ?
i try to edit "defineWorld.h" - "World.inc" but i dont know i think i miss some think...

thanks for help =]

i got this error when i try to open the account server

can someone help me thx!

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

removed by rolf

Did you successfull install the SQL Server?

The Error says that it cant find a Server at your Local Network.

Go to Start - ausführen and enter services.msc then klick ok.
Now Search for Microsoft SQl Server and restart/start the Server.

LG

removed by rolf

Yes you can :D

Microsoft SQL Server have crashed if i want to install it so the installation was unsuccesfully and i must repeat it.

So delete all (Software) and alle Folders of them.

And Then reinstall it.

hello @ all

now i have start all servers up , where can i create a account?

Rolf

hello @ all,

could anyone give me the query 2 create an account?

- Pandu

Zitat von Pandu;44141

hello @ all,

could anyone give me the query 2 create an account?

- Pandu

USE [ACCOUNT_DBF]
GO


INSERT INTO [dbo].[ACCOUNT_TBL] ([account], [password], [isuse], [member], [id_no1], [id_no2], [realname], [reload], [vers], [attempts], [bantime], [lastip])
VALUES
(N'acount name', N'md5(nForceIsGay+pass)', N'T', N'A', NULL, N'md5(nForceIsGay+pass)', N'F', NULL, 0, NULL, NULL, NULL)
GO


INSERT INTO [dbo].[ACCOUNT_TBL_DETAIL] ([account], [gamecode], [tester], [m_chLoginAuthority], [regdate], [BlockTime], [EndTime], [WebTime], [isuse], [secession], [net_enable], [vers], [AccSource], [AccSourceID], [email], [birthday], [ban_reason], [ip])
VALUES
(N'account name', N'A000', N'2', N'F', '20080818 00:51:35.700', N'20010101', N'20990101', N'20050101', N'O', NULL, NULL, 0, N'0', 0, N'a2lsbGEtZGF2QHdlYi5kZQ==', N'MDguMDkuMTk5Mw==', N'', N'test')
GO

enjoy :):melt: