FragenThread [Offi V15][OLD]

Nep-Nep

Zitat von Crasy;124801

[FONT="Franklin Gothic Medium"][COLOR="DarkOrange"][SIZE="2"]Soo ich hab auch ein Problem woran ich bereits eine woche acker :o
Das Problem an sich ist ganz simple nur zu fixxen net
Ich habe schon 3 verschiede Neuz.exen versucht nix geholfen
Mein Problem:
Ich kann kein char Sehen
Anders Eklärt:
Ich kann mich einloggen komme auch bis zur char auswahl und kann auch ein char machen nun 2 punkte
1. Mein char is dannach net da und nach einem relogg auch net
2. Ich kann Auf dem gleichen slot wo ich den char erstellt habe einen weiteren machen und so weiter
Manche sagten mir es liegt an der DB dbo.CreateChar aber das kann es nicht sein den da ist kein fehler denn mein char ist in der Chara.tbl wie er sein soll und auf der HP im Ranking is er auch.
Hat einer ein fixx für das problem ? :<[/SIZE][/COLOR][/FONT]

Alles anzeigen

Es wird dir die BASE_VALUE_TBL fehlen ;).

Crasy

[FONT="Franklin Gothic Medium"][COLOR="DarkOrange"][SIZE="2"]Ne die is da

Da sind die Daten von meinen 2 chars drin also HP, MP, FP^^[/SIZE][/COLOR][/FONT]

tester1337

Zitat von Crasy;124859

[FONT="Franklin Gothic Medium"][COLOR="DarkOrange"][SIZE="2"]Ne die is da
Da sind die Daten von meinen 2 chars drin also HP, MP, FP^^[/SIZE][/COLOR][/FONT]

Da liegste falsch.
Das sind die Default-Werte für neue Male (0) und Female (1) Chars.

uKnow

Kann jemand die Datasubs von RoS hochladen?
Würde gern was testen.

Crasy

[FONT="Franklin Gothic Medium"][COLOR="DarkOrange"][SIZE="2"]Jo Twilight aber dann kommt spalte HitPoint usw...=D

Aber das hilft mir net weiter :<[/SIZE][/COLOR][/FONT]

mcrolanson

Ich habe diesen Fehler und Absturz WorldServer
Hilf mir, diesen Fehler zu vermeiden

WorldServerv15_noMapkeyedited.exe caused an EXCEPTION_INT_DIVIDE_BY_ZERO in module WorldServerv15_noMapkeyedited.exe at 0023:00455DDA, CLinkMap::Init()+0138 byte(s), E:\Neurospace_TestBuild\PROGRAM\WorldServer\LinkMap.cpp, line 0058+0005 byte(s)

- Registers

EAX=00000000 EBX=1C1B0044 ECX=00000000 EDX=00000000 ESI=3EB575C0
EDI=3EB575A0 EBP=0060A8CC ESP=0576BC6C EIP=00455DDA FLG=00010202
CS=0023 DS=002B SS=002B ES=002B FS=0053 GS=002B

0023:00455DDA (0x00000007 0x00000000 0x00000000 0x00000000) WorldServerv15_noMapkeyedited.exe, CLinkMap::Init()+0138 byte(s), E:\Neurospace_TestBuild\PROGRAM\WorldServer\LinkMap.cpp, line 0058+0005 byte(s)
0023:00455325 (0x3EB575A0 0x0000011F 0x1C1B0020 0x006E9F40) WorldServerv15_noMapkeyedited.exe, CLayeredLinkMap::CreateLinkMap()+0133 byte(s), E:\Neurospace_TestBuild\PROGRAM\WorldServer\layeredlinkmap.cpp, line 0122
0023:005760E0 (0x0000011F 0x006E9F40 0x00000000 0x454247D9) WorldServerv15_noMapkeyedited.exe, CWorld::CreateLayer()+0032 byte(s), E:\Neurospace_TestBuild\PROGRAM\_Common\worldfile.cpp, line 1194+0011 byte(s)
0023:005212B8 (0x0576BD50 0x0000011F 0x0576BD64 0x0576BD8C) WorldServerv15_noMapkeyedited.exe, CInstanceDungeonBase::CreateDungeonLayer()+0088 byte(s), E:\Neurospace_TestBuild\PROGRAM\_Common\InstanceDungeonBase.cpp, line 0120+0008 byte(s)
0023:0052157B (0x00000079 0x00000065 0x00000000 0x00000000) WorldServerv15_noMapkeyedited.exe, CInstanceDungeonBase::CreateDungeon()+0331 byte(s), E:\Neurospace_TestBuild\PROGRAM\_Common\InstanceDungeonBase.cpp, line 0184
0023:0052359A (0x00000001 0x00000079 0x00000065 0x00000000) WorldServerv15_noMapkeyedited.exe, CInstanceDungeonHelper::OnCreateDungeon()+0058 byte(s), E:\Neurospace_TestBuild\PROGRAM\_Common\InstanceDungeonBase.cpp, line 0824
0023:00415FB6 (0x00000001 0xFFFFFFFF 0xFFFFFFFF 0xFFFFFFFF) WorldServerv15_noMapkeyedited.exe, CDPCoreClient::OnInstanceDungeonCreate()+0246 byte(s), E:\Neurospace_TestBuild\PROGRAM\WorldServer\DPCoreClient.cpp, line 3317
0023:0040D8CD (0x454247D9 0x0000001C 0x00000190 0x04B17167) WorldServerv15_noMapkeyedited.exe, CDPCoreClient::UserMessageHandler()+0669 byte(s), E:\Neurospace_TestBuild\PROGRAM\WorldServer\DPCoreClient.cpp, line 0214
0023:00482DF4 (0x00000000 0x02AFB2B8 0x0576FF88 0x02AFB2B8) WorldServerv15_noMapkeyedited.exe, CDPMng::ReceiveMessage()+0196 byte(s), E:\Neurospace_TestBuild\PROGRAM\_Network\Net\Src\DPMng.cpp, line 0187

uKnow

Worldserver ohne Mapkey usen.

mcrolanson

Dieser Fehler wird nur geschehen, um keine Karte Schlüssel WorldServer?

Wenn ich nicht verwenden Sie die Taste WorldServer keine Karte dieser Fehler vermieden wird?

Sagen Sie mir bitte.

uKnow

Googletranslator sucks.
Use Worldserverfixed.exe, or Worldserver_nomapkey.exe.

mcrolanson

Ich benutzt habe und die Worldserver_no_mapkey
Der Fehler noch kommen.

Bitte helfen Sie.

Special

hey ich habe einen hamachi server (für bro und mich) nun möchte mein bro connecten aber es geht nicht :/ patcher patscht mit meiner hamachi ip net und er kann nicht connecten..

despiteous

Zitat von Special;125092

hey ich habe einen hamachi server (für bro und mich) nun möchte mein bro connecten aber es geht nicht :/ patcher patscht mit meiner hamachi ip net und er kann nicht connecten..

Error würde helfen oder etwa nicht ?
Wo bleibt er stecken?
Client 1 zu 1 gleich ?

Special

ist schon beim einloggen denke nicht dass es direct mit files zusammen hängt ( da der patcher auf meine hamachi ip connectet) aber bei ihm patchts nicht . das müsste heissen er kann net zu hamachi connecten .. er ist aber im NW

despiteous

Ehm auch IP in der Neuz bzw. in der Neuz.ini eingetragen ?

Special

jop :(

E: achja zur regipage kann er auch nicht connecten

Darki

nochmal ne frage ehm ja kann man eig denn charnamen ändern in z.b. Beispiel[Admin] oder so und noch beim musik ordner sind von jedem sound 2dateien einmal die ogg und die andere was is die adnere?

Dunat

So und ich wollte fragen
Wie bekomm ich den Server eigentlich deutsch?
Was muss ich alles austauschen und / oder ändern?

Kiya

propItem.txt [item namen auf deutsch]
lang in der neuz [ingame dann auf deutsch teils]
character.txt.txt[npc namen auf deutsch]
worlddialog.txt[dialog allgemein in flaris]
propQuest.inc[quests sind dann auf deutsch]

und nochn bisschen aber kein bock alles aufzuzählen xD

zcoolmax

help!!! error query [CHARACTER_STR]

Code

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
ALTER                proc [dbo].[CHARACTER_STR]
	@iGu        		  				CHAR(2) 			= 'S1', 
	@im_idPlayer   				CHAR(7) 			= '0000001',
	@iserverindex  				CHAR(2) 			= '01',
	/**********************************************
	 INSERT ?
	**********************************************/
	-- CHARACTER_TBL
	@iaccount 						VARCHAR(32)	= '',
	@im_szName 				VARCHAR(32)	= '',
	@iplayerslot 					INT						= 0,
	@idwWorldID 				INT 						= 0,
	@im_dwIndex 				INT 						= 0,
	@im_vPos_x 					REAL 					= 0,
	@im_vPos_y 					REAL 					= 0,
	@im_vPos_z 					REAL 					= 0,
	@im_szCharacterKey 	VARCHAR(32)	= '',
	@im_dwSkinSet 			INT						= 0,
	@im_dwHairMesh 		INT						= 0,
	@im_dwHairColor 		INT						= 0,
	@im_dwHeadMesh 		INT						= 0,
	@im_dwSex 					INT						= 0,
	/**********************************************
	 UPDATE ?
	**********************************************/
	-- CHARACTER_TBL
	@im_vScale_x				REAL					=	0,
	@im_dwMotion				INT						=	0,
	@im_fAngle					REAL					=	0,
	@im_nHitPoint				INT						=	0,
	@im_nManaPoint			INT						=	0,
	@im_nFatiguePoint		INT						=	0,
	@im_dwRideItemIdx		INT						=	0,
	@im_dwGold					INT						=	0,
	@im_nJob						INT						=	0,
	@im_pActMover				VARCHAR(50)	=	'',
	@im_nStr						INT						=	0,
	@im_nSta						INT						=	0,
	@im_nDex						INT						=	0,
	@im_nInt							INT						=	0,
	@im_nLevel					INT						=	0,
	@im_nExp1					BIGINT						=	0,
	@im_nExp2					BIGINT						=	0,
	@im_aJobSkill				VARCHAR(500)	='',
	@im_aLicenseSkill		VARCHAR(500)	='',
	@im_aJobLv					VARCHAR(500)	='',
	@im_dwExpertLv			INT						=	0,
	@im_idMarkingWorld	INT						=	0,
	@im_vMarkingPos_x	REAL					=	0,
	@im_vMarkingPos_y	REAL					=	0,
	@im_vMarkingPos_z	REAL					=	0,
	@im_nRemainGP			INT						=	0,
	@im_nRemainLP			INT						=	0,
	@im_nFlightLv				INT						=	0,
	@im_nFxp						INT						=	0,
	@im_nTxp						INT						=	0,
	@im_lpQuestCntArray	VARCHAR(3072)= '',
	@im_chAuthority			CHAR(1)				= '',
	@im_dwMode				INT						=	0,
	@im_idparty					INT						=	0,
	@im_idMuerderer			INT						=	0,
	@im_nFame					INT						=	0,
	@im_nDeathExp				BIGINT					=  0,
	@im_nDeathLevel				INT					=  0,
	@im_dwFlyTime					INT					=  0,
	@im_nMessengerState 	INT					=  0,
	@iTotalPlayTime			INT						= 	0
	-------------- (ADD : Version8-PK System)
	,@im_nPKValue    		int=0
	,@im_dwPKPropensity    	int=0
	,@im_dwPKExp     		int=0
	-- CARD_CUBE_TBL
	,@im_Card 						VARCHAR(1980)= '',
	@im_Index_Card 			VARCHAR(215) 	= '',
	@im_ObjIndex_Card 	VARCHAR(215) 	= '',
	@im_Cube 						VARCHAR(1980)= '',
	@im_Index_Cube 			VARCHAR(215) 	= '',
	@im_ObjIndex_Cube 	VARCHAR(215) 	= '',
	-- INVENTORY_TBL
	@im_Inventory 				VARCHAR(6940)= '',
	@im_apIndex 				VARCHAR(345) 	= '',
	@im_adwEquipment 	VARCHAR(135) 	= '',
	@im_dwObjIndex 			VARCHAR(345) 	= '',
	-- TASKBAR_TBL
	@im_aSlotApplet 			VARCHAR(3100)= '',
	-- TASKBAR_ITEM_TBL
	@im_aSlotItem 				VARCHAR(6885)= '',
	-- TASKBAR_TBL
	@im_aSlotQueue 			VARCHAR(225)= '',
	@im_SkillBar					SMALLINT			= 0,
	-- BANK_TBL
	@im_Bank						VARCHAR(4290)= '',
	@im_apIndex_Bank		VARCHAR(215)= '',
	@im_dwObjIndex_Bank VARCHAR(215)= '',
	@im_dwGoldBank			INT						= 0,
	@im_nFuel						INT						= -1,
	@im_tmAccFuel				INT 						= 0,
	@im_dwSMTime			VARCHAR(2560)='',
	@iSkillInfluence				varchar(2048) ='',
	@im_dwSkillPoint			INT 						= 0,
	@im_aCompleteQuest	varchar(1024) = '',
	@im_extInventory			varchar(2000) = '',
	@im_extBank					varchar(2000) = '',
	@im_InventoryPiercing varchar(8000) = '',
	@im_BankPiercing		varchar(8000) = '',
	@im_dwReturnWorldID INT		 				= 1,
	@im_vReturnPos_x 		REAL					= 0,
	@im_vReturnPos_y 		REAL					= 0,
	@im_vReturnPos_z 		REAL					= 0,
	-------------- ( Version 7 : Skill Update)
	@im_SkillPoint			int=0,
	@im_SkillLv				int=0,
	@im_SkillExp			bigint=0,
	-------------- (?? ?? : 2006 11 13 Attendant Class)
	@idwEventFlag                   bigint=0,
	@idwEventTime                   int=0,
	@idwEventElapsed                int=0
	-------------- (ADD : Version8-Angel System)
	,@im_nAngelExp		bigint=0
	,@im_nAngelLevel		int=0
	--------------- Version 9 ?? ?? Pet??
,@iszInventoryPet	varchar(4200)     = '$'


,@iszBankPet	varchar(4200)     = '$'
,@im_dwPetId int = -1


,@im_nExpLog int = 0
,@im_nAngelExpLog int = 0
, @im_nCoupon int = 0
---------- Ver.13
, @im_nHonor int = -1
, @im_nLayer int = 0
---------- Ver 15
--, @im_BankPW char(4) = '0000'
, @im_aCheckedQuest varchar(100) =''
, @im_nCampusPoint int = 0
, @im_idCampus int = 0


/*******************************************************
	Gu ??
    S : SELECT
    I  : INSERT
    U : UPDATE
    D : DELETE




2005.04.11 updated


ALTER TABLE  CHARACTER_TBL  ADD   m_aCompleteQuest  varchar(1024) NULL
ALTER TABLE CHARACTER_TBL  ALTER COLUMN   m_lpQuestCntArray	VARCHAR(3072) NULL


*******************************************************/
AS
set nocount on
declare @last_connect tinyint
set @last_connect = 1


DECLARE @om_chLoginAuthority CHAR(1),@oaccount VARCHAR(32),@oplayerslot INT




IF @iGu = 'S2' -- ??? ?? ??????? ??????  ????
	BEGIN
		IF @iaccount = '' OR @im_szName  = ''
 		BEGIN
 			SELECT m_chAuthority = '',fError = '1', fText = '????'
 			RETURN
 		END
			SELECT	A.dwWorldID, 
							A.m_szName,
					 		A.playerslot,
							A.End_Time, 
							A.BlockTime,
							A.m_dwIndex, 
							A.m_idPlayer, 
							A.m_idparty,
							A.m_dwSkinSet, 
							A.m_dwHairMesh, 
							A.m_dwHeadMesh, 
							A.m_dwHairColor, 
							A.m_dwSex, 
							A.m_nJob, 
							A.m_nLevel, 
							A.m_vPos_x, 
							A.m_vPos_y, 
							A.m_vPos_z, 
							A.m_nStr,
							A.m_nSta,
							A.m_nDex,
							A.m_nInt,
							A.m_aJobLv,
							A.m_chAuthority,
							A.m_idCompany,
							A.m_nMessengerState,
							B.m_Inventory, 
							B.m_apIndex,
							B.m_adwEquipment,
							B.m_dwObjIndex,
							m_idGuild = CASE WHEN C.m_idGuild  IS NULL THEN '0' ELSE C.m_idGuild END	,
							m_idWar = CASE WHEN C.m_idWar  IS NULL THEN '0' ELSE C.m_idWar END,
							D.m_extInventory,
							D.m_InventoryPiercing,
							------------- ver. 13
							A.m_nHonor,
							last_connect = @last_connect
			  FROM 	CHARACTER_TBL A, INVENTORY_TBL B,GUILD_MEMBER_TBL C, INVENTORY_EXT_TBL D
			WHERE 	A.m_idPlayer = B.m_idPlayer
				  AND 	A.serverindex= B.serverindex	
				  AND  B.m_idPlayer = D.m_idPlayer
				  AND  B.serverindex = D.serverindex
				  AND  D.m_idPlayer *= C.m_idPlayer
				  AND  D.serverindex *= C.serverindex
				  AND  A.isblock = 'F'
				  AND  A.account   	= @iaccount  
				  AND 	A.serverindex= @iserverindex
			 ORDER BY A.playerslot
insert into CHARACTER_TBL_penya_check (account, m_szName, m_dwGold, check_sec, serverindex)
select @iaccount, m_szName, m_dwGold, 9, @iserverindex
from CHARACTER_TBL (nolock)
where account = @iaccount and serverindex = @iserverindex and TotalPlayTime < 1 and m_dwGold >= 1		
				RETURN
 	END
/*
	
	 ??? ?? ??????? ??????  ????
	 ex ) 
	 CHARACTER_STR 'S2',@im_idPlayer (iMode),@iserverindex,@iaccount,@im_szName (iPassword)
	 CHARACTER_STR 'S2','0','02','seghope','1234'




*/


ELSE
IF @iGu = 'S3' -- ??? ????? ?? ???? idPlayer? ? ????
	BEGIN
		 SELECT m_szName, m_idPlayer,m_idCompany
			FROM CHARACTER_TBL 
		 WHERE serverindex = @iserverindex 
--			  AND  isblock = 'F'
		 ORDER BY m_idPlayer
		RETURN
	END
/*
	
	 ??? ????? ?? ???? idPlayer? ? ????
	 ex ) 
	 CHARACTER_STR 'S3','',@iserverindex
	 CHARACTER_STR 'S3','','01'






*/


ELSE
IF @iGu = 'S4' -- ??? ??? ??
	BEGIN
		declare @q1 nvarchar(4000)
		set @q1 = '
				SELECT Item_Name, Item_count, m_nAbilityOption, m_nNo, m_bItemResist, m_nResistAbilityOption,
						m_bCharged, nPiercedSize, adwItemId0, adwItemId1, adwItemId2, adwItemId3, m_dwKeepTime, nRandomOptItemId,
						isnull(adwItemId5, 0) as adwItemId5, isnull(adwItemId6, 0) as adwItemId6, isnull(adwItemId7, 0) as adwItemId7, isnull(adwItemId8, 0) as adwItemId8, isnull(adwItemId9, 0) as adwItemId9, isnull(nUMPiercedSize, 0) as nUMPiercedSize,
						isnull(adwUMItemId0, 0) as adwUMItemId0, isnull(adwUMItemId1, 0) as adwUMItemId1, isnull(adwUMItemId2, 0) as adwUMItemId2, isnull(adwUMItemId3, 0) as adwUMItemId3, isnull(adwUMItemId4, 0) as adwUMItemId4
				FROM ITEM_SEND_TBL
				WHERE m_idPlayer = @im_idPlayer AND serverindex = @iserverindex AND ItemFlag = 0'
		exec sp_executesql @q1, N'@im_idPlayer char(7), @iserverindex char(2)', @im_idPlayer, @iserverindex
/*
		SELECT 	Item_Name, 
						Item_count,
						m_nAbilityOption,
						m_nNo,
						m_bItemResist,


						m_nResistAbilityOption,
						m_bCharged,
						nPiercedSize,
						adwItemId0,
						adwItemId1,
						adwItemId2,
						adwItemId3,
						m_dwKeepTime
		  FROM ITEM_SEND_TBL 
 		 WHERE	m_idPlayer   				= @im_idPlayer 	
			  AND 	serverindex 				= @iserverindex
			  AND   ItemFlag = 0
*/
		RETURN
	END
/*
	


	 ??? ??
	 ex ) 
	 CHARACTER_STR 'S4',@im_idPlayer,@iserverindex
	 CHARACTER_STR 'S4','000001','01'


*/


ELSE
IF @iGu = 'S5' -- ??? ??? ????? ??? ??
	BEGIN
--		DELETE ITEM_SEND_TBL 
		UPDATE ITEM_SEND_TBL SET ProvideDt=getdate(), ItemFlag=1
 		 WHERE	m_nNo  = @iplayerslot
		IF @@ROWCOUNT = 0
		SELECT fError = '0'
		ELSE
		SELECT fError = '1'
		RETURN
	END
/*
	
	 ??? ??? ????? ??? ??
	 ex ) 
	 CHARACTER_STR 'S5',@im_idPlayer,@iserverindex,@iaccount


	 CHARACTER_STR 'S5','000001','01','???',1,1
*/


ELSE
IF @iGu = 'S6' -- ??? ??? ??
	BEGIN
		SELECT 	Item_Name, 
						Item_count,
						m_nAbilityOption,
						m_nNo,
						State,
						m_bItemResist,
						m_nResistAbilityOption
			FROM ITEM_REMOVE_TBL 
 		 WHERE	m_idPlayer   				= @im_idPlayer 	
			  AND 	serverindex 				= @iserverindex
			  AND  	ItemFlag = 0
	RETURN
	END
/*
	??? ??
	ex )
	 CHARACTER_STR 'S6',@im_idPlayer,@iserverindex
	 CHARACTER_STR 'S6','000001','01'
*/	


ELSE
IF @iGu = 'S7' -- ??? ??? ????? ??? ??
	BEGIN
--		DELETE  ITEM_REMOVE_TBL 
		UPDATE ITEM_REMOVE_TBL SET DeleteDt=getdate(), ItemFlag=1
 		 WHERE	m_nNo  = @iplayerslot


		IF @@ROWCOUNT = 0
		SELECT fError = '0'
		ELSE
		SELECT fError = '1'
		RETURN
	END
/*
	 ??? ??? ????? ??? ??
	 ex ) 
	 CHARACTER_STR 'S7',@im_idPlayer,@iserverindex,@iaccount
	 CHARACTER_STR 'S7','000001','01','???',1,1
*/


IF @iGu = 'S8' -- ??? ?? ????
	BEGIN


				-- ?? ?? ???? character ?


				SELECT @om_chLoginAuthority = m_chLoginAuthority
				  FROM  ACCOUNT.ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL 
				WHERE account   = @iaccount
				
				SELECT	m_chLoginAuthority = @om_chLoginAuthority,
								A.account,
								A.m_idPlayer,
								A.playerslot,
								A.serverindex,
								A.dwWorldID,
								A.m_szName,
								A.m_dwIndex,
								A.m_vScale_x,
								A.m_dwMotion,
								A.m_vPos_x,
								A.m_vPos_y,
								A.m_vPos_z,
								A.m_fAngle,
								A.m_szCharacterKey,
								A.m_idPlayer,
								A.m_nHitPoint,
								A.m_nManaPoint,
								A.m_nFatiguePoint,
								A.m_nFuel,
								A.m_dwSkinSet,
								A.m_dwHairMesh,
								A.m_dwHairColor,
								A.m_dwHeadMesh,
								A.m_dwSex,
								A.m_dwRideItemIdx,
								A.m_dwGold,
								A.m_nJob,
								A.m_pActMover,
								A.m_nStr,
								A.m_nSta,
								A.m_nDex,
								A.m_nInt,
								A.m_nLevel,
								A.m_nMaximumLevel,
								A.m_nExp1,
								A.m_nExp2,
								A.m_aJobSkill,
								A.m_aLicenseSkill,
								A.m_aJobLv,
								A.m_dwExpertLv,
								A.m_idMarkingWorld,
								A.m_vMarkingPos_x,
								A.m_vMarkingPos_y,
								A.m_vMarkingPos_z,
								A.m_nRemainGP,
								A.m_nRemainLP,
								A.m_nFlightLv,
								A.m_nFxp,
								A.m_nTxp,
								A.m_lpQuestCntArray,
								m_aCompleteQuest = ISNULL(A.m_aCompleteQuest,'$'),
								A.m_chAuthority,
								A.m_dwMode,
								A.m_idparty,
								A.m_idCompany,
								A.m_idMuerderer,
								A.m_nFame,
								A.m_nDeathExp,
								A.m_nDeathLevel,
								A.m_dwFlyTime,
								A.m_nMessengerState,
								A.End_Time,
								A.BlockTime,
								A.blockby,
								A.isblock,
								A.TotalPlayTime,
								A.CreateTime,
								A.m_dwSkillPoint,
								B.m_aSlotApplet,								
								B.m_aSlotQueue,
								B.m_SkillBar,
								C.m_aSlotItem,
								D.m_Inventory,
								D.m_apIndex,
								D.m_adwEquipment,
								D.m_dwObjIndex,
								m_idGuild = ISNULL(G.m_idGuild,'0'),
								m_idWar = ISNULL(G.m_idWar,'0'),
								A.m_tmAccFuel,
								A.m_tGuildMember,		
								m_dwSMTime = ISNULL(H.m_dwSMTime,'NULL')	,
								SkillInfluence = ISNULL(E.SkillInfluence,'$'),
								F.m_extInventory,																						 		
								F.m_InventoryPiercing,
								A.m_dwReturnWorldID,
								A.m_vReturnPos_x,
								A.m_vReturnPos_y,
								A.m_vReturnPos_z,
								last_connect = @last_connect,
								A.m_SkillPoint,
								A.m_SkillLv,
						        A.m_SkillExp,
						      -------------- (2006 11 13 ?? ?? : Attedant Event)
						        A.dwEventFlag,
						        A.dwEventTime,
						        A.dwEventElapsed
						      -------------- (Version8 : PK System)
								,A.PKValue 		as m_nPKValue
								,A.PKPropensity as m_dwPKPropensity
								,A.PKExp 		as m_dwPKExp
						      -------------- (Version8 : Angel System)
								,A.AngelExp 	as m_nAngelExp
								,A.AngelLevel 	as m_nAngelLevel
							------------------- Version9 Pet
								,F.szInventoryPet as szInventoryPet
								,A.m_dwPetId
								, A.m_nExpLog, A.m_nAngelExpLog
								, m_nCoupon
								---------------- ver.13
								, A.m_nLayer
								---------- Ver 15
								, A.m_aCheckedQuest	
								, A.m_nCampusPoint
								, A.idCampus
								, isnull(R.m_nRestPoint, 0) m_nRestPoint
								, isnull(R.m_LogOutTime, 0) m_LogOutTime
						FROM    CHARACTER_TBL A,
								TASKBAR_TBL B,
								TASKBAR_ITEM_TBL C,
								INVENTORY_TBL D,
								SKILLINFLUENCE_TBL E,
								INVENTORY_EXT_TBL F,								
								GUILD_MEMBER_TBL G,
								BILING_ITEM_TBL H
								, tblRestPoint R
				WHERE  A.m_idPlayer   = @im_idPlayer
				     AND 	A.serverindex  = @iserverindex
					  AND	A.m_idPlayer   = B.m_idPlayer
				     AND 	A.serverindex  = B.serverindex
				     AND 	B.m_idPlayer   = C.m_idPlayer
				     AND 	B.serverindex  = C.serverindex
				     AND 	C.m_idPlayer   = D.m_idPlayer
				     AND 	C.serverindex  = D.serverindex
				     AND 	D.m_idPlayer   = E.m_idPlayer
				     AND 	D.serverindex  = E.serverindex
				     AND 	E.m_idPlayer   = F.m_idPlayer
				     AND 	E.serverindex  = F.serverindex
					AND  F.serverindex *= G.serverindex
					AND  F.m_idPlayer *= G.m_idPlayer
					AND  F.serverindex *= R.serverindex
					AND  F.m_idPlayer *= R.m_idPlayer
					AND  F.serverindex *= H.serverindex
					AND  F.m_idPlayer *= H.m_idPlayer
					AND A.account = lower(@iaccount)


insert into CHARACTER_TBL_validity_check (m_idPlayer, serverindex, account, m_szName, TotalPlayTime, m_dwGold, m_nLevel, m_nJob, sum_ability, CreateTime)
select m_idPlayer, serverindex, account, m_szName, TotalPlayTime, m_dwGold, m_nLevel, m_nJob, (m_nStr + m_nSta + m_nDex + m_nInt), CreateTime
from CHARACTER_TBL (nolock)
where m_idPlayer = @im_idPlayer and TotalPlayTime <= 1
	and (m_dwGold >= 1 or m_nLevel >= 2 or m_nJob >= 1 or (m_nStr + m_nSta + m_nDex + m_nInt) > 60)




declare @m_dwGold_old bigint, @m_dwGold_now bigint
select @m_dwGold_old = m_dwGold from tblLogout_Penya (nolock) where m_idPlayer = @im_idPlayer
select @m_dwGold_now = m_dwGold from CHARACTER_TBL (nolock) where serverindex = @iserverindex and m_idPlayer = @im_idPlayer
if (@m_dwGold_old <> @m_dwGold_now)
begin
	insert into tblLogout_Penya_Diff_Log (serverindex, m_idPlayer, m_dwGold_old, regdate_old, m_dwGold_now)
	select serverindex, m_idPlayer, @m_dwGold_old, regdate, @m_dwGold_now
	from tblLogout_Penya (nolock)
	where m_idPlayer = @im_idPlayer and serverindex = @iserverindex
end


				-- ?? ?? ???? account ?
	
-- 				DECLARE @bank TABLE (m_idPlayer CHAR(6),serverindex CHAR(2),playerslot INT)
-- 
-- 				INSERT @bank
-- 				(m_idPlayer,serverindex,playerslot)
--               SELECT m_idPlayer,serverindex,playerslot 
--               FROM CHARACTER_TBL 
--               WHERE account = @iaccount 
--               AND isblock = 'F'
--               ORDER BY playerslot


				SELECT  a.m_idPlayer,
								c.playerslot,
 								a.m_Bank,
								a.m_apIndex_Bank,
								a.m_dwObjIndex_Bank,
								a.m_dwGoldBank,
								a.m_BankPw,				 		
								b.m_extBank,
						                            b.m_BankPiercing
								,b.szBankPet
				   FROM 	dbo.BANK_TBL a,
                            dbo.BANK_EXT_TBL b,	
                            dbo.CHARACTER_TBL  c
               WHERE 	a.m_idPlayer = b.m_idPlayer
                    AND a.serverindex = b.serverindex
                    AND b.m_idPlayer = c.m_idPlayer
                    AND b.serverindex = c.serverindex
 					  AND c.account = @iaccount 
                    AND c.isblock = 'F'
				ORDER BY c.playerslot


				-- ?? ?? ????
				
				SELECT	a.nPocket,
					a.szItem,
					a.szIndex,
					a.szObjIndex,
					a.bExpired,
					a.tExpirationDate,
					b.szExt,
					b.szPiercing,
					b.szPet
			FROM	tblPocket as a inner join tblPocketExt as b
				on a.serverindex = b.serverindex AND a.idPlayer = b.idPlayer AND a.nPocket = b.nPocket
			WHERE a.serverindex = @iserverindex AND a.idPlayer = @im_idPlayer
			ORDER BY a.nPocket
		RETURN
	END
/*
	
	 ??? ?? ???? New
	 ex ) 
	 CHARACTER_STR 'S8',@im_idPlayer,@iserverindex,@iaccount
	 CHARACTER_STR 'S8','425120','01','ata3k'
*/
ELSE
IF @iGu = 'U1' -- ??? ??
	BEGIN
		UPDATE CHARACTER_TBL
		      SET	dwWorldID 				= @idwWorldID,
						m_dwIndex 				= @im_dwIndex,			
						m_dwSex	 				= @im_dwSex,
						m_vScale_x 				= @im_vScale_x,						
						m_dwMotion 				= @im_dwMotion,
						m_vPos_x 					= @im_vPos_x,
						m_vPos_y 					= @im_vPos_y,
						m_vPos_z 					= @im_vPos_z,
						m_dwHairMesh    	= @im_dwHairMesh,
						m_dwHairColor	    	= @im_dwHairColor,
						m_dwHeadMesh	   	= @im_dwHeadMesh,  -- 2004/11/08   ??  
						m_fAngle 					= 0, --@im_fAngle,
						m_szCharacterKey 	= @im_szCharacterKey,
						m_nHitPoint 				= @im_nHitPoint,
						m_nManaPoint 			= @im_nManaPoint,
						m_nFatiguePoint 		= @im_nFatiguePoint,
						m_nFuel						= @im_nFuel,
						m_dwRideItemIdx 		= @im_dwRideItemIdx,
						m_dwGold 					= @im_dwGold,
						m_nJob 						= @im_nJob,
						m_pActMover 			= @im_pActMover,
						m_nStr 						= @im_nStr,
						m_nSta 						= @im_nSta,
						m_nDex 						= @im_nDex,
						m_nInt 						= @im_nInt,
						m_nLevel 					= @im_nLevel,
						m_nMaximumLevel	= CASE WHEN m_nMaximumLevel < @im_nLevel THEN @im_nLevel ELSE m_nMaximumLevel END,
						m_nExp1	 				= @im_nExp1,
						m_nExp2 					= @im_nExp2,
						m_aJobSkill 				= @im_aJobSkill,
						m_aLicenseSkill 		= @im_aLicenseSkill,
						m_aJobLv 					= @im_aJobLv,
						m_dwExpertLv 			= @im_dwExpertLv,
						m_idMarkingWorld 	= @im_idMarkingWorld,
						m_vMarkingPos_x 	= @im_vMarkingPos_x,
						m_vMarkingPos_y 	= @im_vMarkingPos_y,


						m_vMarkingPos_z 	= @im_vMarkingPos_z,
						m_nRemainGP 			= @im_nRemainGP,
						m_nRemainLP 			= @im_nRemainLP,
						m_nFlightLv 				= @im_nFlightLv,
						m_nFxp 						= @im_nFxp,
						m_nTxp 						= @im_nTxp,
						m_lpQuestCntArray 	= @im_lpQuestCntArray,
						m_aCompleteQuest = @im_aCompleteQuest,
						m_dwMode 				= @im_dwMode,
						m_idparty 					= @im_idparty,
						m_idMuerderer 		= @im_idMuerderer,
						m_nFame 					= @im_nFame,	
						m_nDeathExp			= @im_nDeathExp,
						m_nDeathLevel			= @im_nDeathLevel,						
						m_nMessengerState = @im_nMessengerState,
						--m_dwFlyTime				= m_dwFlyTime + @im_dwFlyTime,
						m_dwFlyTime = @im_dwFlyTime,
						TotalPlayTime 			= TotalPlayTime + @iTotalPlayTime,
						m_tmAccFuel 			= @im_tmAccFuel,
						m_dwSkillPoint			= @im_dwSkillPoint,
						m_dwReturnWorldID= @im_dwReturnWorldID,
						m_vReturnPos_x		= @im_vReturnPos_x,
						m_vReturnPos_y		= @im_vReturnPos_y,
						m_vReturnPos_z		= @im_vReturnPos_z,
						m_SkillPoint		=@im_SkillPoint,
						m_SkillLv			=@im_SkillLv,
				        m_SkillExp                      =@im_SkillExp
				      -------------- (?? ?? : 2006 11 13 Attendant Event)
				        , dwEventFlag                     =@idwEventFlag
				        , dwEventTime                     =@idwEventTime
				        , dwEventElapsed          =@idwEventElapsed
				      -------------- (ADD: Version8-PK System)
						, PKValue        	= @im_nPKValue
						, PKPropensity   	= @im_dwPKPropensity
						, PKExp         	= @im_dwPKExp
				      -------------- (ADD: Version8-Angel System)
						, AngelExp			= @im_nAngelExp
						, AngelLevel		= @im_nAngelLevel
					--------------------- Version9 Pet
						, m_dwPetId = @im_dwPetId


						, m_nExpLog = @im_nExpLog
						, m_nAngelExpLog = @im_nAngelExpLog
						, m_nCoupon = @im_nCoupon
						------------- ver. 13
						, m_nHonor = @im_nHonor
						, m_nLayer = @im_nLayer
						---------- Ver 15
						, m_aCheckedQuest = @im_aCheckedQuest
						, m_nCampusPoint = @im_nCampusPoint
						, idCampus = @im_idCampus
				WHERE   m_idPlayer                              = @im_idPlayer  
				AND 	serverindex 				= @iserverindex


-- 		if object_id('QUEST_TBL') is not null
-- 			EXEC QUEST_STR 'A1',@im_idPlayer,@iserverindex,@im_lpQuestCntArray


update tblLogout_Penya
set m_dwGold = @im_dwGold, regdate = getdate()
where m_idPlayer = @im_idPlayer and serverindex = @iserverindex


		IF @im_nLevel>=120 BEGIN
			UPDATE 	CHARACTER_TBL 
				SET FinalLevelDt=getdate() 
			WHERE 	serverindex=@iserverindex 
				AND m_idPlayer=@im_idPlayer 
				AND FinalLevelDt='2000-01-01'
		END


		--??? ???? ?? ??
		IF @im_dwSMTime > '' 
			BEGIN
				IF EXISTS(SELECT * FROM BILING_ITEM_TBL WHERE m_idPlayer= @im_idPlayer  AND serverindex 	= @iserverindex)
				UPDATE BILING_ITEM_TBL
						SET m_dwSMTime = @im_dwSMTime
				 WHERE	m_idPlayer   				= @im_idPlayer 	
					  AND 	serverindex 				= @iserverindex
				ELSE
				INSERT BILING_ITEM_TBL
					(m_idPlayer,serverindex,m_dwSMTime)
				VALUES
					(@im_idPlayer,@iserverindex,@im_dwSMTime)
			END
		ELSE
			 DELETE BILING_ITEM_TBL
			 WHERE	m_idPlayer   				= @im_idPlayer 	
			      AND 	serverindex 				= @iserverindex


			
-- 		UPDATE 	CARD_CUBE_TBL 
-- 				SET m_Card 						= @im_Card,
-- 						m_apIndex_Card 		= @im_Index_Card,
-- 						m_dwObjIndex_Card= @im_ObjIndex_Card,
-- 						m_Cube 						= @im_Cube,
-- 						m_apIndex_Cube 	= @im_Index_Cube,
-- 						m_dwObjIndex_Cube=@im_ObjIndex_Cube 
-- 		 WHERE	m_idPlayer   				= @im_idPlayer 	
-- 			  AND 	serverindex 				= @iserverindex
		
		UPDATE INVENTORY_TBL 
		      SET 	m_Inventory 				= @im_Inventory,
						m_apIndex 				= @im_apIndex,
						m_adwEquipment 	= @im_adwEquipment,
						m_dwObjIndex 			= @im_dwObjIndex
		 WHERE 	m_idPlayer   				= @im_idPlayer 	
			  AND 	serverindex 				= @iserverindex
		
		
		UPDATE TASKBAR_TBL 
			  SET 	m_aSlotApplet 			= @im_aSlotApplet,
						m_aSlotQueue 			= @im_aSlotQueue,
						m_SkillBar					= @im_SkillBar
		 WHERE 	m_idPlayer   				= @im_idPlayer 	
			  AND 	serverindex 				= @iserverindex




		UPDATE TASKBAR_ITEM_TBL 
			  SET 	m_aSlotItem 				= @im_aSlotItem						
		 WHERE 	m_idPlayer   				= @im_idPlayer 	
			  AND 	serverindex 				= @iserverindex


		UPDATE BANK_TBL 
			  SET 	m_Bank 						= @im_Bank,
						m_apIndex_Bank 		= @im_apIndex_Bank, 
						m_dwObjIndex_Bank = @im_dwObjIndex_Bank, 
						m_dwGoldBank 		= @im_dwGoldBank
		 WHERE 	m_idPlayer   				= @im_idPlayer 	
			  AND 	serverindex 				= @iserverindex


		UPDATE SKILLINFLUENCE_TBL
			 SET SkillInfluence = @iSkillInfluence
		 WHERE 	m_idPlayer   				= @im_idPlayer 	
			  AND 	serverindex 				= @iserverindex


		UPDATE INVENTORY_EXT_TBL 
		      SET 	m_extInventory 				= @im_extInventory,
						m_InventoryPiercing= @im_InventoryPiercing
			,szInventoryPet	= @iszInventoryPet
		 WHERE 	m_idPlayer   				= @im_idPlayer 	
			  AND 	serverindex 				= @iserverindex


		UPDATE BANK_EXT_TBL 
			  SET 	m_extBank 						= @im_extBank,
						m_BankPiercing			= @im_BankPiercing
			, szBankPet = @iszBankPet
		 WHERE 	m_idPlayer   				= @im_idPlayer 	
			  AND 	serverindex 				= @iserverindex


		SELECT fError = '1', fText = 'OK'
		RETURN
	END
/*
	
	??????
	 ex ) 
	 CHARACTER_STR 'U1', ALL ...
	 CHARACTER_STR 'U1','000001','01' ...
*/


ELSE
IF @iGu = 'U2' --? ???? ??
	BEGIN
		UPDATE CHARACTER_TBL
		      SET	TotalPlayTime 			= TotalPlayTime + @iplayerslot 
		 WHERE	m_szName  				= @im_szName 	
			  AND 	serverindex 				= @iserverindex
		RETURN
	END
/*


	? ???? ??
	 ex ) 
	 CHARACTER_STR 'U2','',@iserverindex,'',@im_szName,@iplayerslot (@iTotalPlayTime)
	 CHARACTER_STR 'U2','','01','','beat',10234
*/


ELSE
IF @iGu = 'U3' --? ???? ?? new
	BEGIN
		UPDATE CHARACTER_TBL
		      SET	TotalPlayTime 			= TotalPlayTime + @iplayerslot 
		 WHERE 	m_idPlayer   				= @im_idPlayer 	
			  AND 	serverindex 				= @iserverindex
		RETURN
	END
/*


	? ???? ?? (new)
	 ex ) 
	 CHARACTER_STR 'U3',@im_idPlayer,@iserverindex,'','',@iplayerslot (@iTotalPlayTime)
	 CHARACTER_STR 'U3','000001','01','','',10234
*/


ELSE
IF @iGu = 'U4' --??? ? ??
	BEGIN
		IF EXISTS(SELECT m_idPlayer FROM CHARACTER_TBL WHERE m_szName  = @im_szName  AND serverindex	= @iserverindex)
			BEGIN
				SELECT fError = '0'
			END
		ELSE
			BEGIN
				UPDATE CHARACTER_TBL
				      SET	m_szName			= @im_szName
				 WHERE 	m_idPlayer   				= @im_idPlayer 	
					  AND 	serverindex 				= @iserverindex
				SELECT fError = '1'
			END
		RETURN
	END


-- Ver 15
ELSE
IF @iGu = 'U5' --?? ??? ???? ??
	BEGIN
		IF EXISTS(SELECT m_idPlayer FROM CHARACTER_TBL WHERE m_idPlayer = @im_idPlayer AND serverindex	= @iserverindex)
			BEGIN
				UPDATE CHARACTER_TBL
				      SET	m_nCampusPoint			= m_nCampusPoint + @iplayerslot
				 WHERE 	m_idPlayer   				= @im_idPlayer 	
					  AND 	serverindex 				= @iserverindex


				declare @u5m_nCampusPoint int
				select @u5m_nCampusPoint = m_nCampusPoint from CHARACTER_TBL (nolock) WHERE  m_idPlayer = @im_idPlayer AND serverindex	= @iserverindex
				SELECT fError = '1', @u5m_nCampusPoint  m_nCampusPoint
			END
		ELSE
		RETURN
	END
ELSE
IF @iGu = 'U6' -- ?? ID ???? ??
	BEGIN
		IF EXISTS(SELECT m_idPlayer FROM CHARACTER_TBL WHERE  m_idPlayer = @im_idPlayer AND serverindex	= @iserverindex)
			BEGIN
				UPDATE CHARACTER_TBL
				      SET	idCampus			= @iplayerslot
				 WHERE 	m_idPlayer   				= @im_idPlayer 	
					  AND 	serverindex 				= @iserverindex
				SELECT fError = '1'
			END
		ELSE
			BEGIN
				SELECT fError = '0'
			END
		RETURN
	END




/*




	??? ? ??
	 ex ) 
	 CHARACTER_STR 'U4',@im_idPlayer,@iserverindex,@iaccount,@im_szName
	 CHARACTER_STR 'U4','000001','01','','????'
*/
ELSE
IF @iGu = 'D1' -- ??? ??
	BEGIN
		IF @im_szName = ''
		BEGIN
			SELECT fError = '1', fText = '??????'
			RETURN
		END
			if not exists (select * from CHARACTER_TBL where m_idPlayer = @im_idPlayer and account = @iaccount and serverindex = @iserverindex)
			begin
				select fError = '1'
				return
			end


			DECLARE @Exists int
	
			IF EXISTS(SELECT name  from syscolumns where name='m_idPlayer' AND collation= 'Japanese_BIN')
				BEGIN
					IF EXISTS(SELECT * FROM ACCOUNT.ACCOUNT_DBF.dbo.ACCOUNT_TBL  WHERE account = @iaccount AND (password =  @im_szName OR member = 'B' ))
		              SET @Exists = 1
					ELSE
						SET @Exists = 0				
				END
			ELSE
				BEGIN
					IF EXISTS(SELECT *  FROM ACCOUNT.ACCOUNT_DBF.dbo.ACCOUNT_TBL  WHERE account = @iaccount AND (id_no2 =  @im_szName OR member = 'B' ))
		              SET @Exists = 1
					ELSE
						SET @Exists = 0		
				END


			IF @Exists > 0
				BEGIN
					DECLARE @currDate char(12)				
					SET @currDate = CONVERT(CHAR(8),GETDATE(),112) 
											   + RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(hh,GETDATE())),2) 
											   + RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(mi,GETDATE())),2)






					IF EXISTS(SELECT m_idPlayer FROM GUILD_MEMBER_TBL WHERE 	m_idPlayer = @im_idPlayer AND serverindex = @iserverindex	AND m_idWar > 0)
						BEGIN
						SELECT fError = '3', fText = '????'
						RETURN
						END
					ELSE
						BEGIN
						UPDATE CHARACTER_TBL
							  SET isblock 						= 'D',
									  End_Time						= @currDate ,	
									  BlockTime					= LEFT(@currDate,8)
						WHERE 	m_idPlayer   				= @im_idPlayer 	
							  AND 	serverindex 				= @iserverindex	
	
						UPDATE MESSENGER_TBL
							   SET State = 'D'
						 WHERE 	m_idPlayer   				= @im_idPlayer 	
							  AND 	serverindex 				= @iserverindex	
	
						UPDATE MESSENGER_TBL
							   SET State = 'D'


						 WHERE 	f_idPlayer   				= @im_idPlayer 	
							  AND 	serverindex 				= @iserverindex	






                     /****************************************************************************************/
                     /**                     200506 event                                                                                                          **/
                     /****************************************************************************************/




-- 						if (not exists(select account from RANKING.RANKING_DBF.dbo.last_1_month_tbl where account = @iaccount)
--                           and convert(char(10),getdate(),120) between '2005-07-05' and '2005-07-12')
-- 
--                      begin  --: 1?? ?? ????? ?? ???? ?? 
-- 							declare @cash int,@get_cach int
-- 							select @cash = case when m_nLevel between 10 and 19 then 500
-- 	                                                       when m_nLevel between 20 and 39 then 1000 
-- 	                                                       when m_nLevel between 40 and 49 then 1500 
-- 	                                                       when m_nLevel between 50 and 59 then 2000
-- 	                                                       when m_nLevel between 60 and 69 then 2500
-- 	                                                       when m_nLevel >=	70 then 3000
-- 	                                                       else 0 end
-- 	                     from CHARACTER_TBL
-- 	                     where m_idPlayer = @im_idPlayer and serverindex = @iserverindex
-- 	
-- 	                     select @get_cach = isnull(sum(amount),0)
-- 	                     from  RANKING.RANKING_DBF.dbo.event_member_tbl  
-- 	                     where account = @iaccount
-- 	                     group by account
-- 	
-- 							if @cash + @get_cach > 5000
-- 	                     set @cash = 5000 - @get_cach
-- 	                    
-- 	                     if @cash > 0
-- 	
-- 	                     begin
-- 								declare @retcode int
-- 	
-- 			                 if not exists(select * from BILLING.QLORD_MASTER.dbo.BX_TG_USERINFO where USER_ID = @iaccount)
-- 			                 exec BILLING.QLORD_MASTER.dbo.BX_SP_PROCESS_USERINFO @iaccount,@iaccount,'FLYF',' ','1111111111118',' ',' ',''
-- 		
-- 			                 exec @retcode = BILLING.QLORD_MASTER.dbo.BX_SP_INSERT_BONUS_IN @iaccount,@iaccount,'FLYF','IN00000004',@cash,'??? ?? ???',0,''
-- 	
-- 								if @retcode <> 1
--                             set @cash = 0
-- 
-- 		 					   insert  RANKING.RANKING_DBF.dbo.event_member_tbl 
-- 								 (account,amount,m_idPlayer,serverindex,retcode,date)
-- 					          values
-- 		                      (@iaccount,@cash,@im_idPlayer,@iserverindex,@retcode,getdate())  
-- 	                        
-- 	                     end
--                      end
                     /****************************************************************************************/
                     /****************************************************************************************/
                     /****************************************************************************************/					




						IF EXISTS(SELECT m_idPlayer FROM GUILD_MEMBER_TBL   WHERE 	m_idPlayer = @im_idPlayer AND serverindex = @iserverindex) 
							BEGIN
								SELECT fError = '4', fText = m_idGuild FROM GUILD_MEMBER_TBL   WHERE 	m_idPlayer = @im_idPlayer AND serverindex = @iserverindex
								RETURN
							END
						ELSE
							BEGIN
								SELECT fError = '0', fText = 'DELETE OK'
								RETURN
							END
							
						END
				END
			ELSE
				BEGIN
					SELECT fError = '1', fText = '??????'
					RETURN
				END
	END
/*


	??? ??
	 ex ) 
	 CHARACTER_STR 'D1',@im_idPlayer,@iserverindex,@iaccount (isblock)
	 CHARACTER_STR 'D1','001068','01','ata3k','1019311'


*/


ELSE
IF @iGu = 'I1' -- ?? ?? ??
	BEGIN


	IF EXISTS(SELECT m_szName FROM CHARACTER_TBL
		  WHERE  m_szName = @im_szName AND serverindex = @iserverindex)
		BEGIN
			SELECT  fError = '0', fText = '??? ??!' 
			RETURN
		END
	ELSE
		BEGIN
			DECLARE
								@om_idPlayer 					CHAR		(7)		,
								@om_vScale_x					REAL					,
								@om_dwMotion					INT						,
								@om_fAngle						REAL					,
								@om_nHitPoint					INT						,
								@om_nManaPoint				INT						,
								@om_nFatiguePoint			INT						,
								@om_dwRideItemIdx		INT						,
								@om_dwGold					INT						,
								@om_nJob							INT						,
								@om_pActMover				VARCHAR(50)	,
								@om_nStr							INT						,
								@om_nSta							INT						,
								@om_nDex							INT						,
								@om_nInt							INT						,
								@om_nLevel						INT						,
								@om_nExp1						BIGINT						,
								@om_nExp2						BIGINT						,	
								@om_aJobSkill					VARCHAR	(500),
								@om_aLicenseSkill			VARCHAR	(500),
								@om_aJobLv						VARCHAR	(500),
								@om_dwExpertLv				INT						,
								@om_idMarkingWorld		INT						,
								@om_vMarkingPos_x		REAL					,
								@om_vMarkingPos_y		REAL					,
								@om_vMarkingPos_z		REAL					,
								@om_nRemainGP				INT						,
								@om_nRemainLP				INT						,
								@om_nFlightLv					INT						,
								@om_nFxp							INT						,
								@om_nTxp							INT						,
								@om_lpQuestCntArray		VARCHAR(1024),
								@om_chAuthority				CHAR(1)				,
								@om_dwMode					INT						,
								@oblockby							VARCHAR(32)	,
								@oTotalPlayTime				INT						,
								@oisblock							CHAR(1)				,
								@oEnd_Time						CHAR(12)	,
								@om_Inventory					VARCHAR(6940),
								@om_apIndex					VARCHAR(345)	,
								@om_adwEquipment		VARCHAR(135)	,
								@om_aSlotApplet				VARCHAR(3100),
								@om_aSlotItem					VARCHAR(6885),
								@om_aSlotQueue				VARCHAR(225),
								@om_SkillBar						SMALLINT,
								@om_dwObjIndex				VARCHAR(345)	,
								@om_Card							VARCHAR(1980),
								@om_Cube						VARCHAR(1980),
								@om_apIndex_Card			VARCHAR(215)	,
								@om_dwObjIndex_Card	VARCHAR(215)	,
								@om_apIndex_Cube		VARCHAR(215)	,
								@om_dwObjIndex_Cube	VARCHAR(215)	,
								@om_idparty						INT						,
								@om_idMuerderer			INT						,
								@om_nFame						INT						,
								@om_nDeathExp				BIGINT						,
								@om_nDeathLevel			INT						,
								@om_dwFlyTime				INT						,
								@om_nMessengerState	INT						,
								@om_Bank							VARCHAR(4290),
								@om_apIndex_Bank		 	VARCHAR(215)	,
								@om_dwObjIndex_Bank VARCHAR(215)	,
								@om_dwGoldBank			INT						
								---------- Ver 15
								, @om_aCheckedQuest varchar(100) 
								, @om_nCampusPoint int 
								, @om_idCampus int


				 IF EXISTS (SELECT * FROM CHARACTER_TBL WHERE  serverindex = @iserverindex)
				 SELECT @om_idPlayer = RIGHT('0000000' + CONVERT(VARCHAR(7),MAX(m_idPlayer)+1),7)
			       FROM CHARACTER_TBL
				  WHERE  serverindex = @iserverindex
				ELSE		
				SELECT @om_idPlayer = '0000001'	
			
				 SELECT @om_vScale_x 				= m_vScale_x,
								@om_dwMotion 				= m_dwMotion,
								@om_fAngle 						= m_fAngle,
								@om_nHitPoint 					= m_nHitPoint,
								@om_nManaPoint 			= m_nManaPoint,
								@om_nFatiguePoint 			= m_nFatiguePoint,
								@om_dwRideItemIdx 		= m_dwRideItemIdx,
								@om_dwGold 					= m_dwGold,
								@om_nJob 						= m_nJob,
								@om_pActMover 				= m_pActMover,
								@om_nStr 							= m_nStr,
								@om_nSta 							= m_nSta,
								@om_nDex 						= m_nDex,
								@om_nInt 							= m_nInt,
								@om_nLevel 						= m_nLevel,
								@om_nExp1 						= m_nExp1,
								@om_nExp2 						= m_nExp2,
								@om_aJobSkill 					= m_aJobSkill,
								@om_aLicenseSkill 			= m_aLicenseSkill,
								@om_aJobLv 					= m_aJobLv,
								@om_dwExpertLv 				= m_dwExpertLv,
								@om_idMarkingWorld 		= m_idMarkingWorld,
								@om_vMarkingPos_x 		= m_vMarkingPos_x,
								@om_vMarkingPos_y 		= m_vMarkingPos_y,
								@om_vMarkingPos_z 		= m_vMarkingPos_z,
								@om_nRemainGP 			= m_nRemainGP,
								@om_nRemainLP 			= m_nRemainLP,
								@om_nFlightLv 					= m_nFlightLv,
								@om_nFxp 						= m_nFxp,
								@om_nTxp 						= m_nTxp,
								@om_lpQuestCntArray		= m_lpQuestCntArray,
								@om_chAuthority 				= m_chAuthority,
								@om_dwMode 					= m_dwMode,
								@oblockby 						= blockby,
								@oTotalPlayTime 				= TotalPlayTime,
								@oisblock 							= isblock,
								@oEnd_Time 					= CONVERT(CHAR(8),DATEADD(yy,3,GETDATE()),112) + '0000',
								@om_Inventory 					= m_Inventory,
								@om_apIndex 					= m_apIndex,
								@om_adwEquipment 		= m_adwEquipment,
								@om_aSlotApplet 				= m_aSlotApplet,
								@om_aSlotItem 					= m_aSlotItem,
								@om_aSlotQueue 			= m_aSlotQueue,
								@om_SkillBar						= m_SkillBar,
								@om_dwObjIndex 			= m_dwObjIndex,
								@om_Card 						= m_Card,
								@om_Cube 						= m_Cube,
								@om_apIndex_Card 		= m_apIndex_Card,
								@om_dwObjIndex_Card	= m_dwObjIndex_Card,
								@om_apIndex_Cube 		= m_apIndex_Cube,
								@om_dwObjIndex_Cube = m_dwObjIndex_Cube,
								@om_idparty 						= m_idparty,			
								@om_idMuerderer 			= m_idMuerderer,
								@om_nFame 						= m_nFame,
								@om_nDeathExp				= m_nDeathExp,
								@om_nDeathLevel			= m_nDeathLevel,
								@om_dwFlyTime				= m_dwFlyTime,
								@om_nMessengerState 	= m_nMessengerState,
								@om_Bank							= m_Bank,
								@om_apIndex_Bank		 	= m_apIndex_Bank,
								@om_dwObjIndex_Bank 	= m_dwObjIndex_Bank,
								@om_dwGoldBank			= m_dwGoldBank			
	
			       FROM BASE_VALUE_TBL
				 WHERE g_nSex 								= @im_dwSex


			




				INSERT CHARACTER_TBL
							(
								m_idPlayer,
								serverindex,
								account,
								m_szName,
								playerslot,
								dwWorldID,
								m_dwIndex,
								m_vScale_x,
								m_dwMotion,
								m_vPos_x,
								m_vPos_y,
								m_vPos_z,
								m_fAngle,
								m_szCharacterKey,
								m_nHitPoint,
								m_nManaPoint,
								m_nFatiguePoint,
								m_nFuel,
								m_dwSkinSet,
								m_dwHairMesh,
								m_dwHairColor,
								m_dwHeadMesh,
								m_dwSex,
								m_dwRideItemIdx,
								m_dwGold,
								m_nJob,
								m_pActMover,
								m_nStr,
								m_nSta,
								m_nDex,
								m_nInt,
								m_nLevel,
								m_nMaximumLevel,
								m_nExp1,
								m_nExp2,
								m_aJobSkill,
								m_aLicenseSkill,
								m_aJobLv,
								m_dwExpertLv,
								m_idMarkingWorld,
								m_vMarkingPos_x,
								m_vMarkingPos_y,
								m_vMarkingPos_z,
								m_nRemainGP,
								m_nRemainLP,
								m_nFlightLv,
								m_nFxp,
								m_nTxp,
								m_lpQuestCntArray,
								m_aCompleteQuest,
								m_chAuthority,
								m_dwMode,
								m_idparty,
								m_idCompany,
								m_idMuerderer,
								m_nFame,
								m_nDeathExp,
								m_nDeathLevel,
								m_dwFlyTime,
								m_nMessengerState,
								blockby,
								TotalPlayTime,
								isblock,
								End_Time,
								BlockTime,
								CreateTime,
								m_tmAccFuel,
								m_tGuildMember,
								m_dwSkillPoint,
								m_dwReturnWorldID,
								m_vReturnPos_x,
								m_vReturnPos_y,
								m_vReturnPos_z,
								m_SkillPoint,
								m_SkillLv,
								m_SkillExp
								---------- Ver 15
								, m_aCheckedQuest
								, m_nCampusPoint
								, idCampus
							)


				VALUES
							(
								@om_idPlayer,
								@iserverindex,
								@iaccount,
								@im_szName,
								@iplayerslot,
								@idwWorldID,
								@im_dwIndex,
								@om_vScale_x,
								@om_dwMotion,
								@im_vPos_x,
								@im_vPos_y,
								@im_vPos_z,
								@om_fAngle,
								@im_szCharacterKey,
								@om_nHitPoint,
								@om_nManaPoint,


								@om_nFatiguePoint,
								-1, --m_nFuel
								@im_dwSkinSet,
								@im_dwHairMesh,
								@im_dwHairColor,
								@im_dwHeadMesh,
								@im_dwSex,
								@om_dwRideItemIdx,
								@om_dwGold,
								@om_nJob,
								@om_pActMover,
								@om_nStr,
								@om_nSta,
								@om_nDex,
								@om_nInt,
								@om_nLevel,
								1, --m_nMaximumLevel
								@om_nExp1,
								@om_nExp2,
								@om_aJobSkill,
								@om_aLicenseSkill,
								@om_aJobLv,
								@om_dwExpertLv,
								@om_idMarkingWorld,
								@om_vMarkingPos_x,
								@om_vMarkingPos_y,
								@om_vMarkingPos_z,
								@om_nRemainGP,
								@om_nRemainLP,
								@om_nFlightLv,
								@om_nFxp,
								@om_nTxp,
								@om_lpQuestCntArray,
								'$', -- m_aCompleteQuest
								@om_chAuthority,
								@om_dwMode,
								@om_idparty,
								'000000', -- m_idCompany
								@om_idMuerderer,
								@om_nFame,
								@om_nDeathExp,
								@om_nDeathLevel,
								@om_dwFlyTime	,
								@om_nMessengerState,
								@oblockby,
								@oTotalPlayTime,
								@oisblock,
								@oEnd_Time,
								CONVERT(CHAR(8),DATEADD(d,-1,GETDATE()),112),
								GETDATE(),
								0,
								CONVERT(CHAR(8),DATEADD(d,-1,GETDATE()),112) 
									+ RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(hh,DATEADD(d,-1,GETDATE()))),2) 
									+ RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(mi,DATEADD(d,-1,GETDATE()))),2) 
									+ RIGHT('00' + CONVERT(VARCHAR(2),DATEPART(ss,DATEADD(d,-1,GETDATE()))),2),
								0, --m_dwSkillPoint
                            1,
                            0, 
                            0,
                            0,
							@im_SkillPoint,
							@im_SkillLv,
							@im_SkillExp
							-- Ver 15
							, '$'
							, 0
							, 0
							)




				INSERT INVENTORY_TBL
							(
								m_idPlayer,
								serverindex,
								m_Inventory,
								m_apIndex,
								m_adwEquipment,
								m_dwObjIndex
							)
				VALUES 
							(
								@om_idPlayer,
								@iserverindex,
								@om_Inventory,
								@om_apIndex,
								@om_adwEquipment,
								@om_dwObjIndex
							)




-- 				INSERT CARD_CUBE_TBL
-- 							(
-- 								m_idPlayer,
-- 								serverindex,
-- 								m_Card,
-- 								m_Cube,
-- 								m_apIndex_Card,
-- 								m_dwObjIndex_Card,
-- 								m_apIndex_Cube,
-- 								m_dwObjIndex_Cube
-- 							)
-- 				VALUES 
-- 							(
-- 								@om_idPlayer,
-- 								@iserverindex,
-- 								@om_Card,
-- 								@om_Cube,
-- 								@om_apIndex_Card,
-- 								@om_dwObjIndex_Card,
-- 								@om_apIndex_Cube,
-- 								@om_dwObjIndex_Cube
-- 							)






				IF @@SERVERNAME = 'WEB' OR  @@SERVERNAME = 'SERVER4'
				SET @om_aSlotApplet = '0,2,400,0,0,0,0/1,2,398,0,1,0,0/2,2,2010,0,2,0,0/3,2,1005,0,3,0,0/4,3,25,0,4,0,0/$'


				INSERT TASKBAR_TBL
							(
								m_idPlayer,
								serverindex,
								m_aSlotApplet,
								m_aSlotQueue,
								m_SkillBar


							)
				VALUES 
							(
								@om_idPlayer,
								@iserverindex,
								@om_aSlotApplet,
								@om_aSlotQueue,


								@om_SkillBar
							)




				INSERT TASKBAR_ITEM_TBL
							(
								m_idPlayer,
								serverindex,
								m_aSlotItem
							)
				VALUES 
							(
								@om_idPlayer,
								@iserverindex,
								@om_aSlotItem
							)
			INSERT BANK_TBL
							(
								m_idPlayer,
								serverindex,
								m_Bank,
								m_BankPw,
								m_apIndex_Bank, 
								m_dwObjIndex_Bank ,
								m_dwGoldBank
							)
				VALUES 
							(
								@om_idPlayer,
								@iserverindex,
								@om_Bank,
								'0000', -- m_BankPw
--								@im_BankPW,
								@om_apIndex_Bank, 
								@om_dwObjIndex_Bank,
								@om_dwGoldBank 
							)


		INSERT SKILLINFLUENCE_TBL
							( 								
								m_idPlayer,
								serverindex,
								SkillInfluence
							)
				VALUES 
							(


								@om_idPlayer,
								@iserverindex,
								'$'
							)


		INSERT INVENTORY_EXT_TBL
							( 								
								m_idPlayer,
								serverindex,
								m_extInventory,
								m_InventoryPiercing
							)
				VALUES 
							(
								@om_idPlayer,
								@iserverindex,
								'$','$'
							)


		INSERT BANK_EXT_TBL
							( 								
								m_idPlayer,
								serverindex,
								m_extBank,
								m_BankPiercing
							)
				VALUES 
							(
								@om_idPlayer,
								@iserverindex,
								'$','$'
							)




		-- Skill Information
		INSERT INTO tblSkillPoint(serverindex, PlayerID, SkillID, SkillLv, SkillPosition)
        	VALUES (@iserverindex, @om_idPlayer, 1, 0, 0)
		INSERT INTO tblSkillPoint(serverindex, PlayerID, SkillID, SkillLv, SkillPosition)
        	VALUES (@iserverindex, @om_idPlayer, 2, 0, 1)
		INSERT INTO tblSkillPoint(serverindex, PlayerID, SkillID, SkillLv, SkillPosition)
        	VALUES (@iserverindex, @om_idPlayer, 3, 0, 2)






		-- Pocket
	INSERT  tblPocket ( serverindex, idPlayer, nPocket, szItem, szIndex, szObjIndex, bExpired, tExpirationDate )
	VALUES ( @iserverindex, @om_idPlayer, 0, '$', '$', '$', 0, 0 )
	
	INSERT  tblPocketExt ( serverindex, idPlayer, nPocket, szExt, szPiercing, szPet )
	VALUES ( @iserverindex, @om_idPlayer, 0, '$', '$', '$' )
	
	INSERT  tblPocket ( serverindex, idPlayer, nPocket, szItem, szIndex, szObjIndex, bExpired, tExpirationDate )
	VALUES ( @iserverindex, @om_idPlayer, 1, '$', '$', '$', 1, 0 )
	
	INSERT  tblPocketExt ( serverindex, idPlayer, nPocket, szExt, szPiercing, szPet )
	VALUES ( @iserverindex, @om_idPlayer, 1, '$', '$', '$' )
	
	INSERT  tblPocket ( serverindex, idPlayer, nPocket, szItem, szIndex, szObjIndex, bExpired, tExpirationDate )
	VALUES ( @iserverindex, @om_idPlayer, 2, '$', '$', '$', 1, 0 )
	
	INSERT  tblPocketExt ( serverindex, idPlayer, nPocket, szExt, szPiercing, szPet )
	VALUES ( @iserverindex, @om_idPlayer, 2, '$', '$', '$' )


	------------------- ver. 13
	insert into tblMaster_all (serverindex, m_idPlayer, sec)
	select @iserverindex, @om_idPlayer, 1
	insert into tblMaster_all (serverindex, m_idPlayer, sec)
	select @iserverindex, @om_idPlayer, 2
	insert into tblMaster_all (serverindex, m_idPlayer, sec)
	select @iserverindex, @om_idPlayer, 3


		/*
		?? ??? : ??? ????
		?? ??1 : ?? 1~20 ??? ?? ?? ???(????? ????? ?? ?? ??)
		?? ??2 : ??? ??? ???? ???
		
		??? ?? 
		??? 23~27???(28 0?? ??)
		
		?? ?? 
		??? 24~27???(28 0?? ??)
		*/


	------------------- ver. 15
	insert into tblRestPoint (serverindex, m_idPlayer)
	select @iserverindex, @om_idPlayer


------------ Penay check default setting
insert into tblLogout_Penya (serverindex, m_idPlayer)
select @iserverindex, @om_idPlayer




/*"???????~!"*/
if (getdate() >= '2009-05-29 00:00:00' and getdate() < '2009-06-29 00:00:00')
begin
	declare @i1_regdate datetime
	select @i1_regdate = regdate from ACCOUNT.ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL where account = @iaccount
	if (@i1_regdate >= '2009-05-29 00:00:00' and @i1_regdate < '2009-06-29 00:00:00')
	begin
		if not exists (select * from MANAGE_DBF.dbo.tblEvent_NewAcc_090529 where account = @iaccount)
		begin
			insert into ITEM_SEND_TBL (m_idPlayer, serverindex, Item_Name, Item_count, m_bCharged, idSender)
			select @om_idPlayer, @iserverindex, '30191', 1, 1, '0000000'


			insert into MANAGE_DBF.dbo.tblEvent_NewAcc_090529 (account, serverindex, m_idPlayer, m_szName)
			select @iaccount, @iserverindex, @om_idPlayer, @im_szName
		end
	end
end




--[Event.4] ???? ?? ???? 
if (getdate() >= '2009-12-29 10:00:00' and getdate() < '2010-03-02 10:00:00')
begin
	declare @aregdate datetime
	select @aregdate = regdate from ACCOUNT.ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL where account = @iaccount
	declare @id_no1 char(6), @id_no2 char(7), @itcount int


	if (@aregdate >= '2009-12-29 10:00:00' and @aregdate < '2010-03-02 10:00:00')
	begin
		select @id_no1 = id_no1, @id_no2 = id_no2 from ACCOUNT.ACCOUNT_DBF.dbo.ACCOUNT_TBL where account = @iaccount


		/* ??? ????? ?? ?? 2?? ??? ??? ? ?? ?? ?? ??*/
		select @itcount = count(*) from ACCOUNT.ACCOUNT_DBF.dbo.ACCOUNT_TBL AA
		inner join ACCOUNT.ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL BB on AA.account = BB.account
		where id_no1 = @id_no1 and id_no2 = @id_no2 and left ((right(AA.account, 4)), 2) <> '__'
		and regdate <= '2009-12-29 10:00:00'


		--Event.1 ?? ?? ?? : ??? ???? (????)    
		if (@itcount = 0)
		begin
/*
			DECLARE @nMaxMailID int
			SELECT @nMaxMailID = MAX(nMail) + 1 from MAIL_TBL where serverindex = @iserverindex
			SET @nMaxMailID = ISNULL( @nMaxMailID, 0 )
	
			EXEC dbo.MAIL_STR 'A1', @nMaxMailID, @iserverindex, @om_idPlayer, '0000000', 0, 0, 0, '?? ?? ???', '????? ??? ??????.', '26205', 3, 0, 0, 0, 0, 2
*/
			--ES ??? ????(20) (???: 26205)
			insert into ITEM_SEND_TBL (serverindex, m_idPlayer, Item_Name, Item_count, m_bCharged, idSender)
			select @iserverindex, @om_idPlayer, '26314', 3, 1, '0000000'


			insert into MANAGE_DBF.dbo.tbl_Event_NewAccount_0912 (account, serverindex, m_idPlayer, m_Jumin)
			select @iaccount, @iserverindex, @om_idPlayer, @id_no1+@id_no2
		end
	end


	-- Event.2 ????! ??? ????? ( ?? ??)
	if (getdate() >= '2010-02-22 10:00:00' and getdate() < '2010-02-23 10:00:00')
	begin
		--??? ????? ( ?? ??)
		-- @aregdate, @id_no1, @id_no2  ? ????? ???? ?? ??
		if (@aregdate >= '2010-02-02 10:00:00' and @aregdate < '2010-02-23 10:00:00')
		begin
			/* ??? ????? ?? ?? 2?? ??? ??? ? ?? ?? ?? ??*/
			select @itcount = count(*) from ACCOUNT.ACCOUNT_DBF.dbo.ACCOUNT_TBL AA
			inner join ACCOUNT.ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL BB on AA.account = BB.account
			where id_no1 = @id_no1 and id_no2 = @id_no2 and left ((right(AA.account, 4)), 2) <> '__'
			and regdate <= '2010-01-29 10:00:00'
	
			if (@itcount = 0 )
			begin
				-- ?? 3? ??
				insert into ITEM_SEND_TBL (serverindex, m_idPlayer, Item_Name, Item_count, m_bCharged, idSender)
				select @iserverindex, @om_idPlayer, '26919', 1, 1, '0000000'
			
				insert into ITEM_SEND_TBL (serverindex, m_idPlayer, Item_Name, Item_count, m_bCharged, idSender)
				select @iserverindex, @om_idPlayer, '26920', 1, 1, '0000000'
			
				insert into ITEM_SEND_TBL (serverindex, m_idPlayer, Item_Name, Item_count, m_bCharged, idSender)
				select @iserverindex, @om_idPlayer, '26921', 1, 1, '0000000'


				insert into MANAGE_DBF.dbo.tbl_Event_WSNB_1001 (account, serverindex, m_idPlayer, m_Type)
				select @iaccount, @iserverindex, @om_idPlayer, 'N'
				
				insert into MANAGE_DBF.dbo.tbl_Event_WSNB_1001_account (account)
				select @iaccount
			end
		end
		--??? ????? (?? ??)
		if not exists (select top 1 * from MANAGE_DBF.dbo.tbl_Event_WSNB_1001_account (nolock) where account = @iaccount)
		begin
			-- ?? 3? ??
			insert into ITEM_SEND_TBL (serverindex, m_idPlayer, Item_Name, Item_count, m_bCharged, idSender)
			select @iserverindex, @om_idPlayer, '26919', 1, 1, '0000000'
		
			insert into ITEM_SEND_TBL (serverindex, m_idPlayer, Item_Name, Item_count, m_bCharged, idSender)
			select @iserverindex, @om_idPlayer, '26920', 1, 1, '0000000'
		
			insert into ITEM_SEND_TBL (serverindex, m_idPlayer, Item_Name, Item_count, m_bCharged, idSender)
			select @iserverindex, @om_idPlayer, '26921', 1, 1, '0000000'


			insert into MANAGE_DBF.dbo.tbl_Event_WSNB_1001 (account, serverindex, m_idPlayer, m_Type)
			select @iaccount, @iserverindex, @om_idPlayer, 'H'
		end
	end
end


/*[Event.1-2]?? ???? ???? ??~!! ? ???~ ???~ Start 
if (getdate() >= '2009-07-28 10:00:00' and getdate() < '2009-09-01')
begin
    
	declare @aregdate datetime
	select @aregdate = regdate from ACCOUNT.ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL where account = @iaccount


	if (@aregdate >= '2009-07-28 10:00:00')
	begin
		declare @id_no1 char(6), @id_no2 char(7), @itcount int
		select @id_no1 = id_no1, @id_no2 = id_no2 from ACCOUNT.ACCOUNT_DBF.dbo.ACCOUNT_TBL where account = @iaccount
--		select @itcount = count(*) from ACCOUNT.ACCOUNT_DBF.dbo.ACCOUNT_TBL where id_no1 = @id_no1 and id_no2 = @id_no2 and left ((right(account, 4)), 2) <> '__'


--		 ??? ????? ?? ?? 2?? ??? ??? ? ?? ?? ?? ??
		select @itcount = count(*) from ACCOUNT.ACCOUNT_DBF.dbo.ACCOUNT_TBL AA
		inner join ACCOUNT.ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL BB on AA.account = BB.account
		where id_no1 = @id_no1 and id_no2 = @id_no2 and left ((right(AA.account, 4)), 2) <> '__'
		and regdate <= @aregdate




	--Event.1 ?? ?? ?? : ?? ??? ???? (????)    
		if not exists (select * from WEB.ONLINE_DBF.dbo.tbl_Event_NewAccount_0907 where account = @iaccount)
		begin
			if (@itcount = 1)
			begin
				--??? ?? ??(???: 30191)
				insert into ITEM_SEND_TBL (serverindex, m_idPlayer, Item_Name, Item_count, m_bCharged, idSender)
				select @iserverindex, @om_idPlayer, '30191', 1, 1, '0000000'


				--??? ?? ??(???: 26770)
				insert into ITEM_SEND_TBL (serverindex, m_idPlayer, Item_Name, Item_count, m_bCharged, idSender)
				select @iserverindex, @om_idPlayer, '26770', 1, 1, '0000000'


				insert into WEB.ONLINE_DBF.dbo.tbl_Event_NewAccount_0907 (account, serverindex, m_idPlayer)
				select @iaccount, @iserverindex, @om_idPlayer
			end
		end


		--Event.2 ?? ?? ? ???? ??? ?? : ??? ??? ???? (????)
		if exists (select * from WEB.ONLINE_DBF.dbo.USER_Recommand_TBL where mem_id = @iaccount and regdate >= '2009-07-28')
		begin


			--?? ???? ?? (???? ???? ?? : 2082)
			declare @remem_id as varchar (32), @re_serverindex char(2), @re_m_idPlayer char(7)
			select @remem_id = remem_id from WEB.ONLINE_DBF.dbo.USER_Recommand_TBL where mem_id = @iaccount
			exec MANAGE_DBF.dbo.usp_Highest_Char @remem_id, @re_serverindex output, @re_m_idPlayer output
--			select @remem_id, @re_serverindex, @re_m_idPlayer 


			if @re_serverindex is not NULL and  @re_m_idPlayer is not NULL
			begin
				if not exists (select * from WEB.ONLINE_DBF.dbo.USER_Recommand_Provide_TBL_0907 where account = @iaccount)
			        	begin
					if (@itcount = 1)
					begin
	
						insert into ITEM_SEND_TBL (serverindex, m_idPlayer, Item_Name, Item_count, m_bCharged, idSender)
						select @iserverindex, @om_idPlayer, '30191', 1, 1, '0000000'
	
						insert into WEB.ONLINE_DBF.dbo.USER_Recommand_Provide_TBL_0907 (account, serverindex, m_idPlayer, m_Item)
						select @iaccount, @iserverindex, @om_idPlayer, '30191'
	
						-- ???? ???? (??)
						declare @q001 nvarchar(4000)
						set @q001 = '
						insert into CHARACTER_[&server&]_DBF.dbo.ITEM_SEND_TBL (serverindex, m_idPlayer, Item_Name, Item_count, m_bCharged, idSender)
						select @re_serverindex, @re_m_idPlayer, ''2082'', 2, 1, ''0000000'''
						set @q001 = replace(@q001, '[&server&]', @re_serverindex)
						exec sp_executesql @q001, N'@re_serverindex char(2), @re_m_idPlayer char(7)', @re_serverindex, @re_m_idPlayer
	
--						insert into WEB.ONLINE_DBF.dbo.USER_Recommand_Provide_TBL_0907 (account, serverindex, m_idPlayer, m_Item)
--						select @remem_id, @re_serverindex, @re_m_idPlayer, '2082'
					end
				end
			end
		end
	end
end
--    [Event.1-2]??? ???? ???? ??~!! ? ???~ ???~ End */


/* [Event.2]???~ ??? ????! Start 
if (getdate() >= '2009-02-24 10:00:00' and getdate() <= '2009-03-24 10:00:00')
begin
    
    declare @aregdate datetime
    select @aregdate = regdate from ACCOUNT.ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL where account = @iaccount
    
    if (@aregdate >= '2009-02-24 10:00:00')
    begin
	declare @id_no1 char(6), @id_no2 char(7), @itcount int
	select @id_no1 = id_no1, @id_no2 = id_no2 from ACCOUNT.ACCOUNT_DBF.dbo.ACCOUNT_TBL where account = @iaccount
	select @itcount = count(*) from ACCOUNT.ACCOUNT_DBF.dbo.ACCOUNT_TBL where id_no1 + id_no2 = @id_no1 + @id_no2 and left ((right(account, 4)), 2) <> '__'


        --?? ?? ?? : ?? ??? ???? (????)    
        if not exists (select * from WEB.ONLINE_DBF.dbo.tbl_Event_NewAccount_0902 where account = @iaccount)
        begin
	if (@itcount = 1)
	begin
	            --FLY/FOR/FUN?? 30?
	            insert into ITEM_SEND_TBL (serverindex, m_idPlayer, Item_Name, Item_count, m_bCharged, idSender)
	            select @iserverindex, @om_idPlayer, '26666', 30, 1, '0000000'
	            --FLY/FOR/FUN?? 30?
	            insert into ITEM_SEND_TBL (serverindex, m_idPlayer, Item_Name, Item_count, m_bCharged, idSender)
	            select @iserverindex, @om_idPlayer, '26667', 30, 1, '0000000'
	            --FLY/FOR/FUN?? 30?                
	            insert into ITEM_SEND_TBL (serverindex, m_idPlayer, Item_Name, Item_count, m_bCharged, idSender)
	            select @iserverindex, @om_idPlayer, '26668', 30, 1, '0000000'
	            
	            insert into WEB.ONLINE_DBF.dbo.tbl_Event_NewAccount_0902 (account, serverindex, m_idPlayer)
	            select @iaccount, @iserverindex, @om_idPlayer
	end
        end


        --?? ?? ? ???? ??? ?? : ??? ??? ???? (????)
        if exists (select * from WEB.ONLINE_DBF.dbo.USER_Recommand_TBL where mem_id = @iaccount and regdate >= '2009-02-24')
        begin
        	if not exists (select * from WEB.ONLINE_DBF.dbo.USER_Recommand_Provide_TBL_0902 where account = @iaccount)
        	begin
		if (@itcount = 1)
		begin


			-- ??? ?? ????? ?? ???? ?? (2009-02-24 11:40)     by ???
		                insert into ITEM_SEND_TBL (serverindex, m_idPlayer, Item_Name, Item_count, m_bCharged, idSender)
		                select @iserverindex, @om_idPlayer, '30191', 1, 1, '0000000'
		
		                insert into WEB.ONLINE_DBF.dbo.USER_Recommand_Provide_TBL_0902 (account, serverindex, m_idPlayer)
		                select @iaccount, @iserverindex, @om_idPlayer
		end
        	end
        end


    end
    
end*/
/* [Event.2]???~ ??? ????! End */


/* [Event.5] ???? ???? ^^ Start 
if (getdate() >= '2009-03-03 09:00:00' and getdate() <= '2009-03-31 09:00:00')
begin
    
    declare @a2regdate datetime
    declare @sex char(1)
    select @a2regdate = regdate from ACCOUNT.ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL where account = @iaccount
    select @sex = [??] from WEB.ONLINE_DBF.dbo.USER_TBL where [??] = @iaccount
    
    if (@a2regdate >= '2009-03-03 09:00:00' and @sex = '2')
    begin


        --- ?? ??? ????  (????)    
        if not exists (select * from WEB.ONLINE_DBF.dbo.tbl_Event_NewAccount_Women_0903 where account = @iaccount)
        begin
            --??? ?? ??
            insert into ITEM_SEND_TBL (serverindex, m_idPlayer, Item_Name, Item_count, m_bCharged, idSender)
            select @iserverindex, @om_idPlayer, '26770', 1, 1, '0000000'
            
            insert into WEB.ONLINE_DBF.dbo.tbl_Event_NewAccount_Women_0903 (account, serverindex, m_idPlayer)
            select @iaccount, @iserverindex, @om_idPlayer
        end


    end
    
end*/
/* [Event.5] ???? ???? ^^ End */	


	/*
		?? ??? : ??? ????


		?? ??1 : ?? 1~20 ??? ?? ?? ???(????? ????? ?? ?? ??)
		?? ??2 : ??? ??? ???? ???
		
		??? ?? 
		??? 23~27???(28 0?? ??)
		
		?? ?? 
		??? 24~27???(28 0?? ??)
		*/


/*	if (getdate() <= '2008-02-12 09:00:00')
	begin
		declare @regdate datetime, @check int
		select @check = count(*) from ACCOUNT.ACCOUNT_DBF.dbo.tblEvent_Board_Provide where account = @iaccount
		select @regdate = regdate from ACCOUNT.ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL where account = @iaccount


		if ((@check = 0) and (@regdate >= '2008-01-08 11:00:00'))
		begin
			declare @channel_check char(4)
			set @channel_check = right(@iaccount, 4)


			if (@channel_check = '__an')
			begin
				insert into ITEM_SEND_TBL(m_idPlayer, serverindex, Item_Name, Item_count, m_nAbilityOption, idSender)
				select @om_idPlayer, @iserverindex, '26533', 1, 0, '0000000'


				insert into ACCOUNT.ACCOUNT_DBF.dbo.tblEvent_Board_Provide (account, serverindex, m_idPlayer, m_szName)
				select @iaccount, @iserverindex, @om_idPlayer, @im_szName
			end
			else if (@channel_check = '__bu')
			begin
				if (getdate() <= '2008-02-08 23:59:59')
				begin
					insert into ITEM_SEND_TBL(m_idPlayer, serverindex, Item_Name, Item_count, m_nAbilityOption, idSender)
					select @om_idPlayer, @iserverindex, '26534', 1, 0, '0000000'


					insert into ACCOUNT.ACCOUNT_DBF.dbo.tblEvent_Board_Provide (account, serverindex, m_idPlayer, m_szName)
					select @iaccount, @iserverindex, @om_idPlayer, @im_szName
				end
			end
			else
			begin
				insert into ITEM_SEND_TBL(m_idPlayer, serverindex, Item_Name, Item_count, m_nAbilityOption, idSender)
				select @om_idPlayer, @iserverindex, '26532', 1, 0, '0000000'


				insert into ACCOUNT.ACCOUNT_DBF.dbo.tblEvent_Board_Provide (account, serverindex, m_idPlayer, m_szName)
				select @iaccount, @iserverindex, @om_idPlayer, @im_szName
			end
		end
	end
*/
/*	if (getdate() >= '2008-07-30 00:00:00' and getdate() <= '2008-09-15 23:59:59')
	begin
		declare @aregdate datetime
		select @aregdate = regdate from ACCOUNT.ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL where account = @iaccount
		if (@aregdate >= '2008-07-30 00:00:00')
		begin
			declare @reaccount varchar(32)
			if exists (select * from WEB.ONLINE_DBF.dbo.USER_Recommand_TBL where mem_id = @iaccount)
			begin
				if not exists (select * from WEB.ONLINE_DBF.dbo.USER_Recommand_Provide_TBL where account = @iaccount)
				begin
					insert into ITEM_SEND_TBL (serverindex, m_idPlayer, Item_Name, Item_count, m_bCharged, idSender)
					select @iserverindex, @om_idPlayer, '30191', 1, 1, '0000000'


					insert into WEB.ONLINE_DBF.dbo.USER_Recommand_Provide_TBL (account, serverindex, m_idPlayer)
					select @iaccount, @iserverindex, @om_idPlayer
				end
			end
		end
	end
*/
/*	if (getdate() >= '2008-12-17 10:00:00' and getdate() <= '2009-01-27 10:00:00')
	begin
		declare @aregdate datetime
		select @aregdate = regdate from ACCOUNT.ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL where account = @iaccount
		if (@aregdate >= '2008-12-17 10:00:00')
		begin
			declare @reaccount varchar(32)
			if exists (select * from WEB.ONLINE_DBF.dbo.USER_Recommand_TBL where mem_id = @iaccount and regdate >= '2008-12-16')
			begin
				if not exists (select * from WEB.ONLINE_DBF.dbo.USER_Recommand_Provide_TBL_0812 where account = @iaccount)
				begin
					insert into ITEM_SEND_TBL (serverindex, m_idPlayer, Item_Name, Item_count, m_bCharged, idSender)
					select @iserverindex, @om_idPlayer, '30191', 1, 1, '0000000'


					insert into WEB.ONLINE_DBF.dbo.USER_Recommand_Provide_TBL_0812 (account, serverindex, m_idPlayer)
					select @iaccount, @iserverindex, @om_idPlayer
				end
			end
		end
	end




		IF (GETDATE() BETWEEN '2004-06-23 18:00:00.000' AND '2004-06-27 23:59:59.999')
		INSERT ITEM_SEND_TBL
				(m_idPlayer, serverindex, Item_Name, Item_count, m_nAbilityOption, End_Time, m_bItemResist, m_nResistAbilityOption, m_bCharged)
			VALUES
				('261007','01','?? ??? 12',2,0,NULL,0,0,1)
*/




		SELECT fError = '1', fText = 'OK',m_idPlayer=@om_idPlayer
		RETURN
		END
	END


/*
	
	?? ?? ??
	 ex ) 
	 CHARACTER_STR 'I1','',@iserverindex,@iaccount,@im_szName,@iplayerslot,@idwWorldID,
											@im_dwIndex,@im_vPos_x,@im_vPos_y,@im_vPos_z,@im_szCharacterKey,
											@im_dwSkinSet,@im_dwHairMesh,@im_dwHairColor,@im_dwHeadMesh,@im_dwSex
	 CHARACTER_STR 'I1','','01','beat','????3',0,0,


											0,0,0,0,'',
											0,0,0,0,0


*/
set nocount off
RETURN

Alles anzeigen

Dunat

Zitat von Kiya;125241

propItem.txt [item namen auf deutsch]
lang in der neuz [ingame dann auf deutsch teils]
character.txt.txt[npc namen auf deutsch]
worlddialog.txt[dialog allgemein in flaris]
propQuest.inc[quests sind dann auf deutsch]

und nochn bisschen aber kein bock alles aufzuzählen xD

Dank dir! Und vielleicht hast du ja doch noch Lust die eine oder andere Sache aufzuzählen ^^

FragenThread [Offi V15][OLD]

Jetzt mitmachen!

SCHNELLZUGRIFF

HILFE & COMMUNITY

RECHTLICHES