[Offi Files]Fragen u. Disskussionsthread

TEST
AddTail( -1, 1, "Rocknetwork", "127.0.0.1", 0, 1, 0 );
AddTail( 1, 1, "Enclose", "127.0.0.1", 0, 1, 500 );

DSN_NAME_LOGIN "login"
DB_ADMIN_ID_LOGIN "sa"

DSN_NAME_LOG "log01"
DB_ADMIN_ID_LOG "sa"

MSG_VER "20070712"

DB_PWD_LOGIN "1234"
DB_PWD_LOG "1234"

Core "127.0.0.1"
Port 15000

Account "127.0.0.1"
DSN_NAME_LOGIN "login"
DB_PWD_LOGIN "1234"

Sys "1"
Database "127.0.0.1"
PartyExpRate "2"

// 167 0 0 2 2 00 00

101
{
1 0 0 30 30 00 00
2 0 0 5 5 00 00
3 0 0 3 3 00 00
200 0 0 5 5 00 00
201 0 0 5 5 00 00
210 0 0 1 1 00 00
220 0 0 1 1 00 00
230 0 0 1 1 00 00
202 0 0 5 5 00 00
204 0 0 5 5 00 00
205 0 0 2 2 00 00
203 0 0 3 3 00 00
206 0 0 2 2 00 00
207 0 0 2 2 00 00
208 0 0 2 2 00 00
241 0 0 1 1 00 00
242 0 0 1 1 00 00
243 0 0 1 1 00 00
244 0 0 1 1 00 00
21 0 0 1 1 00 00
22 0 0 1 1 00 00
23 0 0 1 1 00 00
24 0 0 1 1 00 00
25 0 0 1 1 00 00
121 0 0 5 5 00 00
122 0 0 5 5 00 00
209 0 0 1 1 00 00
151 0 0 2 2 00 00
152 0 0 2 2 00 00
153 0 0 2 2 00 00
154 0 0 2 2 00 00
155 0 0 2 2 00 00
156 0 0 2 2 00 00
157 0 0 2 2 00 00
158 0 0 2 2 00 00
159 0 0 2 2 00 00
160 0 0 2 2 00 00
161 0 0 2 2 00 00
162 0 0 2 2 00 00
163 0 0 2 2 00 00
164 0 0 2 2 00 00
165 0 0 2 2 00 00
166 0 0 2 2 00 00
}

ResourceFolder "C:\Dokumente und Einstellungen\Johann Görzen\Desktop\Flyff v14 Pserver\v14 Server packet\Resource\"

Sys 1

Account "127.0.0.1"

DSN_NAME_CHARACTER "character01"
DB_ADMIN_ID_CHARACTER "sa"

DSN_NAME_LOG "log01"
DB_ADMIN_ID_LOG "sa"

LANG 1

DB_PWD_LOG "1234"
DB_PWD_CHARACTER "1234"
DB_PWD_BACKEND "1234"
DB_PWD_ITEMUPDATE "1234"

DB "127.0.0.1"
Core "127.0.0.1"


AddCache( "127.0.0.1" );


MSG_VER "20070712"

ResourceFolder "C:\Dokumente und Einstellungen\Johann Görzen\Desktop\Flyff v14 Pserver\v14 Server packet\Resource\"
Key 0101
DB "127.0.0.1"
Core "127.0.0.1"
LANG 1
18
Heartbeat 10101
GUILDWAR 1
GUILDBANK 1
WORMON 0
//DROPITEM_REMOVE 0
GUILDCOMBAT 1
ARENA 1
SCHOOL 1
//PK 1
STEAL 1
PKCOST 0
RECOMMEND 1
RAINBOWRACE 1
SECRETROOM 1
GUILDCOMBAT1TO1 1

query:LOGIN_STR 'test3', '89d1ed22aac58f5bbea53b2fde81a946', '5.123.123.92'
SQLSTATE:42000 error:[Microsoft][SQL Server Native Client 10.0][SQL Server]Procedure or function LOGIN_STR has too many arguments specified.

USE [ACCOUNT_DBF]
GO
/****** Object: StoredProcedure [dbo].[LOGIN_STR] Script Date: 04/03/2010 12:41:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE 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
GO