![[FAQ] v15 Files](https://www.elitepvpers.com/forum/iconimages/flyff-private-server/faq-v15-files_ltr.gif){kind=small}
F: Ich komme nicht in die Map hinein, wie fixxe ich das ?
Ändert den port von dem CacheServer von 15400 auf 5400.
Danach sollte es gehen.
Danach sollte es gehen.
F: Wenn ich auf LogIn klicke, kommt da "Server Verifizierungs fehler", wie fix ich das ?
Mach in MSSQL eine neue Anfrage und führ das hier aus.
Code:
USE [ACCOUNT_DBF]
GO
/****** Object: StoredProcedure [dbo].[LOGIN_STR] Script Date: 05/01/2010 10:14:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROC [dbo].[LOGIN_STR]
@iaccount VARCHAR(32),
@ipassword char(32)
-- Ver. 14 PCZoneIP
,@i_IPAddress varchar(15) = '0.0.0.0'
/***********************************************************************************
***********************************************************************************
***********************************************************************************
***********************************************************************************
ACCOUNT_STR 스토어드
작성자 : 최석준
작성일 : 2004.01.18
ex) ACCOUNT_STR 'beat','1234'
SELECT * FROM ACCOUNT_TBL_DETAIL WHERE account='aeonsoft'
***********************************************************************************
***********************************************************************************
***********************************************************************************
***********************************************************************************/
AS
set nocount on
-- Ver 14. PCZoneIP_Check
declare @o_Grade tinyint
exec dbo.USP_PCZoneIP_Check @i_IPAddress, @o_Grade output
IF EXISTS(SELECT a.account FROM ACCOUNT_TBL a,ACCOUNT_TBL_DETAIL b
WHERE a.account = b.account AND a.account = @iaccount ) -- AND gamecode = 'A000')
BEGIN
DECLARE @curDate char(8)
IF EXISTS(SELECT account FROM ACCOUNT_TBL
WHERE account = @iaccount AND password = @ipassword) BEGIN
SELECT @curDate=CONVERT(CHAR(8), getdate(), 112)
SELECT fError=CASE
-- WHEN session<>@isession OR sessionExpireDt<getdate() THEN '91'
WHEN BlockTime>=@curDate THEN '9'
ELSE '0' END,
fText= CASE
-- WHEN session<>@isession OR sessionExpireDt<getdate() THEN 'Session Expired'
WHEN BlockTime>=@curDate THEN 'Block' ELSE 'OK' END,
fCheck=tester,
f18='1'
-- Ver14. PCZoneIP
,fPCZone = @o_Grade
FROM ACCOUNT_TBL a INNER JOIN ACCOUNT_TBL_DETAIL b ON (a.account=b.account)
WHERE a.account=@iaccount
END
ELSE BEGIN
SELECT fError = '1', fText = 'Wrong Password !!',fCheck ='',f18='1', fPCZone = '0' -- PCZoneIP (, fPCZone = '0' 추가)
END
END
ELSE BEGIN
SELECT fError = '2', fText = 'Account Not Exists !!',fCheck ='',f18='1', fPCZone = '0' -- PCZoneIP (, fPCZone = '0' 추가)
END
RETURN
-- 계정 검사 Rule
-- 1. (fError=2 리턴) 계정있는지 확인. 계정확인시 "gamecode = A000" 만 프리프 회원.
-- 2. (fError=1 리턴) 암호확인.
-- 3. (fError=0 리턴) 사원 및 기자 확인( id_no1가 a0000 )으로 확인.계정.암호만 확인
-- 4. (fError=3 리턴) 블럭타임과, 과금타임 확인.
-- 5. (fError=4 리턴) 실명확인.
-- 6. (fError=5 리턴) 12세 이상인지 확인. 이하이면 "프리프는 12세 이상 이용가 이므로 ]
-- 게임접속을 할수 없습니다." 라고 알림.
-- 7. (fError=6 리턴) 부모동의서가 없는 애덜 확인 tester = 0 이면 "14세 미만 가입자 분들은
-- 부모등의서를 보내주셔야 게임 접속이 가능합니다"라고 알림.
-- 8. (fError=0 리턴) 위의 예말고는 정상 사용자로 인정.
set nocount off
F: Im Login fenster hab ich nur ein Weissen Hintergrund, wie bekomme ich es weg ?
Geh in den Theme Ordner und nenn den "German" Ordner zu "English" um.
F: Wie erstelle ich einen Account ?
Ladet euch diesen v15 Register Script.
oder
D = Teleport rechte
O = Operator
P = GM
Z = Admin
oder
F = Normale rechteQuote:
USE [ACCOUNT_DBF]
GO
INSERT INTO [dbo].[ACCOUNT_TBL] ([account], [password], [isuse], [member], [id_no1], [id_no2], [realname], [reload], [OldPassword], [TempPassword], [cash])
VALUES
(N'Account ID', N'PW in MD5', N'F', N'A', N'', N'', 'F', NULL, NULL, NULL, '0')
GO
INSERT INTO [dbo].[ACCOUNT_TBL_DETAIL] ([account], [gamecode], [tester], [m_chLoginAuthority], [regdate], [BlockTime], [EndTime], [WebTime], [isuse], [secession], [email])
VALUES
(N'Account ID', N'A000', N'2', N'F', GETDATE(), N'', N'', N'20050101', N'O', NULL, N'')
GO
D = Teleport rechte
O = Operator
P = GM
Z = Admin
F: Wenn ich Ingame bin bekomme ich wieder DC, warum ?
Die antwort liegt darin, dass die World ordner vom Clienten und Server nicht 1:1 stimmen.
F: Wie kann ich mit meinen Freunden über Hamachi spielen ?
AccountServer.ini:
LoginServer.iniQuote:
TEST
AddTail( -1, 1, "RockNetwork", "Hamachi IP", 0, 1, 0 );
AddTail( 1, 1, "Channel 1-1", "Hamachi IP", 0, 1, 1200 );
DSN_NAME_LOGIN "login"
DB_ADMIN_ID_LOGIN "login"
DSN_NAME_LOG "log01"
DB_ADMIN_ID_LOG "log01"
MSG_VER "20070712"
SKIP_TRACKING
//NOT_RELOADPRO
//NOLOG
// 6
DB_PWD_LOGIN "password"
DB_PWD_LOG "password"
WorldServer.iniQuote:
DB "127.0.0.1"
Core "127.0.0.1"
// CACHE
AddCache( "Hamachi IP" );
MSG_VER "20070712"
//NPROTECT
Thanks to Nilsator2Quote:
ResourceFolder "C:\Users\Sedrika\Desktop\Sedrika\v15 Files Repack by Sedrika\Resource"
Key 0101
Core "127.0.0.1"
DB "127.0.0.1"
Account "Hamachi IP"
LANG 6
Heartbeat 10101
Proc 2
GUILDWAR
//18
//PK
//PKCOST
//STEAL
DROPITEM_REMOVE
WORMON
GUILDBANK
GUILDCOMBAT
GUILDCOMBAT1TO1
ARENA
SECRETROOM
RAINBOWRACE
RECOMMEND
F: Wie kann ich die neues einbauen/verändern ?
Hier in diesem Thread von karasko sind gute tipps und wie ihr was macht auch.
LG Sedrika
