|
You last visited: Today at 21:42
Advertisement
Release v15 Source/Files with Custom Map
Discussion on Release v15 Source/Files with Custom Map within the Flyff PServer Guides & Releases forum part of the Flyff Private Server category.
01/18/2019, 15:30
|
#1
|
elite*gold: 0
Join Date: Aug 2014
Posts: 653
Received Thanks: 217
|
Release v15 Source/Files with Custom Map
Hi Epvpers i want to release my old version of flyff including the source and serverfiles
Neuz Versioncommon
PHP Code:
///////////////////HACKSHIELD ANTIHACK////////////////////// #define __HACK_SHIELD ////////////////////END OF HACKSHIELD/////////////////////// #pragma warning ( disable : 4715 ) #pragma warning ( disable : 4700 ) #pragma warning ( disable : 4309 ) //////////////////////STARTING FEATURES///////////////////// #define NEUZ_TITLE "FLYFF" #define NEUZ_IPSET "127.0.0.1" #define NEUZ_CPORT "5400" #define NEUZ_MSGVR "20100412" #define NEUZ_PHASH "kikugalanet" #define NEUZ_BHASH "" #define __PETS_RATE 5 #define __COUPLE_RATE 5 #define __PERFECT_EATPET 13579// Perfect Pet ////////////////////CUSTOM FEATURES////////////////////////// //#define __CLIENT_SERVER_ENCRYPTION #define __CROSS_2H_SHIELD #define __TELEPORTER_SYSTEM #define __NEW_WEAPON_GLOW #define __DISPLAY_WORLDINFO #define __INVENTORY_SORT_BUTTON #define __NO_TICKET_RESELL #define __FONTNAME_BOLD #define __NAME_COLOR #define __NAME_FONT #define __OLDPVPNAME #define __GAMEMASTER #define __PANG_SYSTEM #define __TRADE_FASHION_PET #define __USERTASKMENU #define __ULTI_SHIELDS #define __NEW_BUFF_FORMAT #define __CSHOUTSCR #define __SHOWEXPINC #define __NOT_STOLEN_INVENTORY #define __ITEM_COUNT_TOOLTIP #define __CHIP_PLAYERSHOP #define __EXTENDED_CURRENCY #define __NEW_EXCHANGE_V19 #define __EXCHANGE_NPC_FIX #define __EPVP_LORD_TRASH #define __EVENT_TELEPORT_ALL #define __2ND_PASSWORD_SYSTEM #define __CHANGE_2ND_PASSWORD #define __AUTO_PENYA_PICKUP #define __LOADING_SCREEN_UPDATE #define __FIX_PROPM_SPEEDHAX #define __CLIENT_FIXES_RH #define __FIX_NEUZ_WIN_FREEZE #define __FIX_GET_HP_MP_FP_POINT #define __SAVE_PLAYER_OUT #define __INCREASED_SPAWN #define __INCREASE_PETSPEED #define __LINK_FOR_ALL #define __BLOOM_QUALITY #define __PET_PORTBUG_RH #define __WINDOW_STYLE #define __SPEED_FIX #define __TAXES #define __VIP #define __CONEXP #define __SWDCROSS #define __GUILDBUFF #define __PETFILTER #define __WINDOWS_8 #define __INFOCOMMAND #define __NO_TEXTURECHANGE #define __SCROLL_OF_UNBIND #define __PMA_PARTYFINDER #define __PARTY_SKILLS_REFRESH #define __PERIN_CONVERTER #define __V17_CHARSELECT #define __ADDSHOPITEM #define __ARENA_SCORE #define __REMOVE_MAX_RECOVER_RATE #define __LIMIT_MAX_SPEED #ifdef __LIMIT_MAX_SPEED #define MAX_SPEED 300 #endif //__LIMIT_MAX_SPEED #define __CHEAT_BLOCK_SYSTEM #define __CHEAT_ENGINE_BLOCK #define __CHECK_CHEAT_TOOLS #define __SYSSECURITY_IP #define __NEED_GUILDNAME #define __LOADER_SPLASH #define __SPEED_CHECKER #define __HACK_FIXXES #define __RESTAT_BUG #define __NPART_FIXXED //#define __CEFIX //#define __HOOK_CHANGE #define __LEVEL_BOT_FIX #define __SECURITY_FIXES #define __INVISIBLE_FIX #define __CHAT_FIX #define __SWITCH_FIX #define __EEL_BUG_FIX #define __LACCO_FIX #define __FIX_ASAL #define __PET_COLLISION #define __CHANNEL_UCOUNTER #define __SPEEDHACK #define __FIX_KNIGHT_DRAWING #define __FIX_GET_ATTACK_RANGE #define __FIX_GUILD_STAT_HACK #define __FIX_CHAT_EMOCRASH #define __EXCHANGE_NEGATIVE #define __FIX_COMBO_BOX #define __FIX_HOUSING_CRASH #define __FIX_HONOR_TITLE #define __FIX_RANGE_01 #define __FIX_RANGE_02 #define __FIX_CHEAT #define __HOP_CRASH_FIX #define __QY_SECURITY #define __RANGE_FIXES #define __GAMEGUARD #define __GAMEGUARD_LOGS #define __ANTIHACK_EXTENDED #define __INFILTRATION #define __SYSSECURITY #define __CHEAT_ENGINE #ifdef __ANTIHACK #define __NO_TRADE #endif #define __BANN_USER #ifdef __BANN_USER #endif //__BANN_USER //////////////////////CUSTOM GS REWARD////////////////////////// #define __RC_GW_KILL // Red Chips for Kill #ifdef __RC_GW_KILL #define RC_KILL 10 // Amount of Red Chips for each kill #endif ////////////////////END OF FEATURES//////////////////////////
WorldServer Versioncommon
PHP Code:
//////////////////////STARTING FEATURES///////////////////// #define __PERFECT_EATPET 13579 #define __PETS_RATE 5 #define __COUPLE_RATE 5 //////////////////////////////////////////////////////////// #define __CROSS_2H_SHIELD #define __NEW_WEAPON_GLOW #define __NO_PARTY_GW_JOIN #define __TELEPORTER_SYSTEM #define __NAME_COLOR #define __NAME_FONT #define __OLDPVPNAME #define __TRADE_FASHION_PET #define __AIO_FIX_AWAKE_SCROLL #define __ULTI_SHIELDS #define __NEW_BUFF_FORMAT #define __NO_TICKET_RESELL #define __CSHOUTSCR #define __ALLOW_VENDING_AREA #define __EVENT_TELEPORT_ALL #define __NOT_STOLEN_INVENTORY #define __NEW_EXCHANGE_V19 #define __EXCHANGE_NPC_FIX #define __AUTO_PENYA_PICKUP #define __CHIP_PLAYERSHOP #define __EXTENDED_CURRENCY //#define __WELCOME_NEW_PLAYER #define __PMA_PARTYFINDER #define __FIX_PROPM_SPEEDHAX #define __ADMIN_PARTYINVITE #define __PET_COLLISION #define __SAVE_PLAYER_OUT #define __INCREASED_SPAWN #define __INCREASE_PETSPEED #define __PET_CRASH_FIXXED #define __INFOCOMMAND #define __LINK_FOR_ALL #define __SPEEDHACK #define __ALL_COUPLE #define __SPEED_FIX #define __TAXES #define __VIP #define __CONEXP #define __SWDCROSS #define __PETFILTER #define __GUILDBUFF #define __ADDSHOPITEM #define __PERIN_CONVERTER #define __PARTY_SKILLS_REFRESH #define __ARENA_SCORE #define __SCROLL_OF_UNBINDING #define __REMOVE_MAX_RECOVER_RATE #define __LIMIT_MAX_SPEED #ifdef __LIMIT_MAX_SPEED #define MAX_SPEED 300 #endif //__LIMIT_MAX_SPEED #define __GUILD_RENAME_FAKE #define __CHAR_RENAME_INVALID #define __BUFFEROVERDLOW_NAMECHECK #define __STAT_HACKFIX_RH #define __PET_PORTBUG_RH #define __NPART_FIXXED #define __HACK_FIXXES #define __TRADE_SAFE #define __RESTAT_BUG #define __EEL_BUG_FIX #define __SECURITY_FIXES #define __SWITCH_FIX #define __RANGE_FIXES #define __HOP_CRASH_FIX #define __GUILDBANK_DUPEFIX2 #define __LACCO_FIX #define __FIX_ANGEL_DUPE #define __FIX_GET_HP_MP_FP_POINT #define __FIX_GET_ATTACK_RANGE #define __FIX_CRASH_PACKET_01 #define __FIX_CRASH_PACKET_02 #define __FIX_KNIGHT_DRAWING #define __FIX_BUYITEM_DUPE #define __FIX_MOOTIE_HACKS #define __FIX_STAT_HACKS #define __FIX_DUPE_CRASH #define __FIX_HONOR_TITLE #define __FIX_HOUSING_CRASH #define __FIX_BLESS_HACK #define __FIX_LOOTPET_AI #define __FIX_PET_BEAD_HACK #define __FIX_PARTY_SUMMON #define __FIX_RANGE_01 #define __FIX_RANGE_02 #define __FIX_DUPE #define __FIX_ASAL #define __FIX_GUILD_STAT_HACK #define __FIX_EXCHANGE_NPC #define __FIX_CHAT_EMOCRASH #define __FIX_INVALID_TRANSFORM #define __EXCHANGE_NEGATIVE #define __QY_SECURITY #define __SYSSECURITY #define __NEED_GUILDNAME #define __SYS_010614 #define __INFILTRATION #define __ANTIHACK_EXTENDED #define __GAMEGUARD #define __ANTIHACK // (Test Antihack) #ifdef __ANTIHACK #define __C_T "[QOFlyFF]: Hack Logs" #define __GVER " v1.0" // (Antihack Version v2.0) #define __NO_TRADE #endif #define __BANN_USER #ifdef __BANN_USER #endif //__BANN_USER ////////////////////CUSTOM GS REWARD////////////////////////// #define __RC_GW_KILL // Red Chips for Kill #ifdef __RC_GW_KILL #define RC_KILL 10 // Amount of Red Chips for each kill #endif ////////////////////END OF FEATURES//////////////////////////
DatabaseServer Versioncommon
PHP Code:
#define __NEW_WEAPON_GLOW #define __NAME_COLOR #define __NAME_FONT #define __ULTI_SHIELDS #define __PETS_RATE 5 #define __COUPLE_RATE 5 #define __PERFECT_EATPET 13579 #define __NEW_BUFF_FORMAT #define __NOT_STOLEN_INVENTORY #define __2ND_PASSWORD_SYSTEM #define __CHANGE_2ND_PASSWORD #define __NEW_EXCHANGE_V19 #define __EVENT_TELEPORT_ALL #define __SQLINJECTION_FIX #define __INCREASED_SPAWN #define __INCREASE_PETSPEED #define __PET_COLLISION #define __ADDSHOPITEM #define __PETFILTER #define __PET_PORTBUG_RH #define __FLYFF_FIX_24 #define __FIX_GUILD_STAT_HACK #define __PMA_PARTYFINDER #define __ARENA_SCORE #define __SECURITY_FIXES #define __FIX_PLAYER_SLOT #define __FIX_RANKING_DB #define __GAMEGUARD #define __INFILTRATION #define __BANN_USER #ifdef __BANN_USER #endif //__BANN_USER ////////////////////CUSTOM GS REWARD////////////////////////// #define __RC_GW_KILL // Red Chips for Kill #ifdef __RC_GW_KILL #define RC_KILL 10 // Amount of Red Chips for each kill #endif
Source:
PHP Code:
http://www.mediafire.com/file/k46xc7a47ibdxjy/Release+Official+Source.rar
Virustotal:
Serverfiles:
PHP Code:
http://www.mediafire.com/file/csk83qzk8fbyqj9/Release+Serverfiles.rar
Virustotal:
Official video was made before
Official Ingame
Note: Client inside in Resource folder
i will delete this files in my storage after i upload.
source and serverfiles was updated and added features/items after the server down.
Update password: POT@ñgIña
|
|
|
01/19/2019, 02:06
|
#2
|
elite*gold: 0
Join Date: Oct 2018
Posts: 29
Received Thanks: 3
|
cant start MiniA because of the Antihack.
|
|
|
01/19/2019, 03:06
|
#3
|
elite*gold: 0
Join Date: Aug 2014
Posts: 653
Received Thanks: 217
|
Quote:
Originally Posted by xLurique
cant start MiniA because of the Antihack.
|
Run administrator the MiniA.exe ..its not the antihack problem
Modified your database add the .168slot inventory, fontname style and font name color..
|
|
|
01/19/2019, 22:15
|
#4
|
elite*gold: 51
Join Date: May 2009
Posts: 338
Received Thanks: 76
|
VS Version? and why is the server down now?
|
|
|
01/20/2019, 02:13
|
#5
|
elite*gold: 0
Join Date: Aug 2014
Posts: 653
Received Thanks: 217
|
Quote:
Originally Posted by Steffen Tequila
VS Version? and why is the server down now?
|
vs2003
|
|
|
01/20/2019, 03:02
|
#6
|
elite*gold: 0
Join Date: Oct 2018
Posts: 29
Received Thanks: 3
|
Just need the databasse
|
|
|
01/20/2019, 03:10
|
#7
|
elite*gold: 0
Join Date: Aug 2014
Posts: 653
Received Thanks: 217
|
here is the database you need to config
OPEN CHARACTER_01_DBF
Look this files
PHP Code:
dbo.CHARACTER_TBL
right click and click the design
add this
and
look for modified your character_str compare with this character_str
PHP Code:
USE [CHARACTER_01_DBF] GO /****** Object: StoredProcedure [dbo].[CHARACTER_STR] Script Date: 01/19/2019 20:05:39 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER proc [dbo].[CHARACTER_STR] @iGu CHAR(2) = 'S1', @im_idPlayer CHAR(7) = '0000001', [MENTION=3453071]iServe[/MENTION]rindex CHAR(2) = '01', /********************************************** INSERT ? **********************************************/ -- CHARACTER_TBL @iaccount VARCHAR(32) = '', @im_szName VARCHAR(32) = '', [MENTION=2476276]iPlayer[/MENTION]slot 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, [MENTION=3173290]itot[/MENTION]alPlayTime 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(MAX)= '', @im_apIndex VARCHAR(MAX) = '', @im_adwEquipment VARCHAR(MAX) = '', @im_dwObjIndex VARCHAR(MAX) = '', -- 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 [MENTION=714211]Im_BanK[/MENTION] 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)='', [MENTION=706561]iskill[/MENTION]Influence varchar(2048) ='', @im_dwSkillPoint INT = 0, @im_aCompleteQuest varchar(1024) = '', @im_extInventory varchar(MAX) = '', @im_extBank varchar(2000) = '', @im_InventoryPiercing varchar(MAX) = '', [MENTION=714211]Im_BanK[/MENTION]Piercing 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 --, [MENTION=714211]Im_BanK[/MENTION]PW char(4) = '0000' , @im_aCheckedQuest varchar(100) ='' , @im_nCampusPoint int = 0 , @im_idCampus int = 0 , @im_dwNameColor bigint = 0 , @im_nNameFont 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 [MENTION=5497993]last_[/MENTION]connect tinyint set [MENTION=5497993]last_[/MENTION]connect = 1 DECLARE @om_chLoginAuthority CHAR(1) [MENTION=4808045]oaccount[/MENTION] VARCHAR(32) [MENTION=6168206]OPlayer[/MENTION]slot 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 = [MENTION=5497993]last_[/MENTION]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= [MENTION=3453071]iServe[/MENTION]rindex 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, [MENTION=3453071]iServe[/MENTION]rindex from CHARACTER_TBL (nolock) where account = @iaccount and serverindex = [MENTION=3453071]iServe[/MENTION]rindex and TotalPlayTime < 1 and m_dwGold >= 1 RETURN END /* ??? ?? ??????? ?????? ???? ex ) CHARACTER_STR 'S2',@im_idPlayer (iMode) [MENTION=3453071]iServe[/MENTION]rindex,@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 = [MENTION=3453071]iServe[/MENTION]rindex -- AND isblock = 'F' ORDER BY m_idPlayer RETURN END /* ??? ????? ?? ???? idPlayer? ? ???? ex ) CHARACTER_STR 'S3','' [MENTION=3453071]iServe[/MENTION]rindex 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 = [MENTION=3453071]iServe[/MENTION]rindex AND ItemFlag = 0' exec sp_executesql @q1, N'@im_idPlayer char(7), [MENTION=3453071]iServe[/MENTION]rindex char(2)', @im_idPlayer, [MENTION=3453071]iServe[/MENTION]rindex /* 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 = [MENTION=3453071]iServe[/MENTION]rindex AND ItemFlag = 0 */ RETURN END /* ??? ?? ex ) CHARACTER_STR 'S4',@im_idPlayer [MENTION=3453071]iServe[/MENTION]rindex 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 = [MENTION=2476276]iPlayer[/MENTION]slot IF @@ROWCOUNT = 0 SELECT fError = '0' ELSE SELECT fError = '1' RETURN END /* ??? ??? ????? ??? ?? ex ) CHARACTER_STR 'S5',@im_idPlayer [MENTION=3453071]iServe[/MENTION]rindex,@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 = [MENTION=3453071]iServe[/MENTION]rindex AND ItemFlag = 0 RETURN END /* ??? ?? ex ) CHARACTER_STR 'S6',@im_idPlayer [MENTION=3453071]iServe[/MENTION]rindex 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 = [MENTION=2476276]iPlayer[/MENTION]slot IF @@ROWCOUNT = 0 SELECT fError = '0' ELSE SELECT fError = '1' RETURN END /* ??? ??? ????? ??? ?? ex ) CHARACTER_STR 'S7',@im_idPlayer [MENTION=3453071]iServe[/MENTION]rindex,@iaccount CHARACTER_STR 'S7','000001','01','???',1,1 */ IF @iGu = 'S8' -- ??? ?? ???? BEGIN -- ?? ?? ???? character ? SELECT @om_chLoginAuthority = m_chLoginAuthority FROM 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 = [MENTION=5497993]last_[/MENTION]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 , A.m_dwNameColor , A.m_nNameFont , 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 = [MENTION=3453071]iServe[/MENTION]rindex 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 [MENTION=1899648]M_D[/MENTION]wGold_old bigint, [MENTION=1899648]M_D[/MENTION]wGold_now bigint select [MENTION=1899648]M_D[/MENTION]wGold_old = m_dwGold from tblLogout_Penya (nolock) where m_idPlayer = @im_idPlayer select [MENTION=1899648]M_D[/MENTION]wGold_now = m_dwGold from CHARACTER_TBL (nolock) where serverindex = [MENTION=3453071]iServe[/MENTION]rindex and m_idPlayer = @im_idPlayer if [MENTION=1899648]M_D[/MENTION]wGold_old <> [MENTION=1899648]M_D[/MENTION]wGold_now) begin insert into tblLogout_Penya_Diff_Log (serverindex, m_idPlayer, m_dwGold_old, regdate_old, m_dwGold_now) select serverindex, m_idPlayer, [MENTION=1899648]M_D[/MENTION]wGold_old, regdate, [MENTION=1899648]M_D[/MENTION]wGold_now from tblLogout_Penya (nolock) where m_idPlayer = @im_idPlayer and serverindex = [MENTION=3453071]iServe[/MENTION]rindex end -- ?? ?? ???? account ? -- DECLARE [MENTION=468948]bank[/MENTION] TABLE (m_idPlayer CHAR(6),serverindex CHAR(2),playerslot INT) -- -- INSERT [MENTION=468948]bank[/MENTION] -- (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 = [MENTION=3453071]iServe[/MENTION]rindex AND a.idPlayer = @im_idPlayer ORDER BY a.nPocket RETURN END /* ??? ?? ???? New ex ) CHARACTER_STR 'S8',@im_idPlayer [MENTION=3453071]iServe[/MENTION]rindex,@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 + [MENTION=3173290]itot[/MENTION]alPlayTime, 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 , m_dwNameColor = @im_dwNameColor , m_nNameFont = @im_nNameFont WHERE m_idPlayer = @im_idPlayer AND serverindex = [MENTION=3453071]iServe[/MENTION]rindex -- if object_id('QUEST_TBL') is not null -- EXEC QUEST_STR 'A1',@im_idPlayer [MENTION=3453071]iServe[/MENTION]rindex,@im_lpQuestCntArray update tblLogout_Penya set m_dwGold = @im_dwGold, regdate = getdate() where m_idPlayer = @im_idPlayer and serverindex = [MENTION=3453071]iServe[/MENTION]rindex IF @im_nLevel>=120 BEGIN UPDATE CHARACTER_TBL SET FinalLevelDt=getdate() WHERE serverindex [MENTION=3453071]iServe[/MENTION]rindex 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 = [MENTION=3453071]iServe[/MENTION]rindex) UPDATE BILING_ITEM_TBL SET m_dwSMTime = @im_dwSMTime WHERE m_idPlayer = @im_idPlayer AND serverindex = [MENTION=3453071]iServe[/MENTION]rindex ELSE INSERT BILING_ITEM_TBL (m_idPlayer,serverindex,m_dwSMTime) VALUES (@im_idPlayer [MENTION=3453071]iServe[/MENTION]rindex,@im_dwSMTime) END ELSE DELETE BILING_ITEM_TBL WHERE m_idPlayer = @im_idPlayer AND serverindex = [MENTION=3453071]iServe[/MENTION]rindex -- 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 = [MENTION=3453071]iServe[/MENTION]rindex 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 = [MENTION=3453071]iServe[/MENTION]rindex UPDATE TASKBAR_TBL SET m_aSlotApplet = @im_aSlotApplet, m_aSlotQueue = @im_aSlotQueue, m_SkillBar = @im_SkillBar WHERE m_idPlayer = @im_idPlayer AND serverindex = [MENTION=3453071]iServe[/MENTION]rindex UPDATE TASKBAR_ITEM_TBL SET m_aSlotItem = @im_aSlotItem WHERE m_idPlayer = @im_idPlayer AND serverindex = [MENTION=3453071]iServe[/MENTION]rindex UPDATE BANK_TBL SET m_Bank = [MENTION=714211]Im_BanK[/MENTION], m_apIndex_Bank = @im_apIndex_Bank, m_dwObjIndex_Bank = @im_dwObjIndex_Bank, m_dwGoldBank = @im_dwGoldBank WHERE m_idPlayer = @im_idPlayer AND serverindex = [MENTION=3453071]iServe[/MENTION]rindex UPDATE SKILLINFLUENCE_TBL SET SkillInfluence = [MENTION=706561]iskill[/MENTION]Influence WHERE m_idPlayer = @im_idPlayer AND serverindex = [MENTION=3453071]iServe[/MENTION]rindex UPDATE INVENTORY_EXT_TBL SET m_extInventory = @im_extInventory, m_InventoryPiercing= @im_InventoryPiercing ,szInventoryPet = @iszInventoryPet WHERE m_idPlayer = @im_idPlayer AND serverindex = [MENTION=3453071]iServe[/MENTION]rindex UPDATE BANK_EXT_TBL SET m_extBank = @im_extBank, m_BankPiercing = [MENTION=714211]Im_BanK[/MENTION]Piercing , szBankPet = @iszBankPet WHERE m_idPlayer = @im_idPlayer AND serverindex = [MENTION=3453071]iServe[/MENTION]rindex 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 + [MENTION=2476276]iPlayer[/MENTION]slot WHERE m_szName = @im_szName AND serverindex = [MENTION=3453071]iServe[/MENTION]rindex RETURN END /* ? ???? ?? ex ) CHARACTER_STR 'U2','' [MENTION=3453071]iServe[/MENTION]rindex,'',@im_szName [MENTION=2476276]iPlayer[/MENTION]slot [MENTION=3173290]itot[/MENTION]alPlayTime) CHARACTER_STR 'U2','','01','','beat',10234 */ ELSE IF @iGu = 'U3' --? ???? ?? new BEGIN UPDATE CHARACTER_TBL SET TotalPlayTime = TotalPlayTime + [MENTION=2476276]iPlayer[/MENTION]slot WHERE m_idPlayer = @im_idPlayer AND serverindex = [MENTION=3453071]iServe[/MENTION]rindex RETURN END /* ? ???? ?? (new) ex ) CHARACTER_STR 'U3',@im_idPlayer [MENTION=3453071]iServe[/MENTION]rindex,'','' [MENTION=2476276]iPlayer[/MENTION]slot [MENTION=3173290]itot[/MENTION]alPlayTime) 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 = [MENTION=3453071]iServe[/MENTION]rindex) BEGIN SELECT fError = '0' END ELSE BEGIN UPDATE CHARACTER_TBL SET m_szName = @im_szName WHERE m_idPlayer = @im_idPlayer AND serverindex = [MENTION=3453071]iServe[/MENTION]rindex 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 = [MENTION=3453071]iServe[/MENTION]rindex) BEGIN UPDATE CHARACTER_TBL SET m_nCampusPoint = m_nCampusPoint + [MENTION=2476276]iPlayer[/MENTION]slot WHERE m_idPlayer = @im_idPlayer AND serverindex = [MENTION=3453071]iServe[/MENTION]rindex declare @u5m_nCampusPoint int select @u5m_nCampusPoint = m_nCampusPoint from CHARACTER_TBL (nolock) WHERE m_idPlayer = @im_idPlayer AND serverindex = [MENTION=3453071]iServe[/MENTION]rindex 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 = [MENTION=3453071]iServe[/MENTION]rindex) BEGIN UPDATE CHARACTER_TBL SET idCampus = [MENTION=2476276]iPlayer[/MENTION]slot WHERE m_idPlayer = @im_idPlayer AND serverindex = [MENTION=3453071]iServe[/MENTION]rindex SELECT fError = '1' END ELSE BEGIN SELECT fError = '0' END RETURN END /* ??? ? ?? ex ) CHARACTER_STR 'U4',@im_idPlayer [MENTION=3453071]iServe[/MENTION]rindex,@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 = [MENTION=3453071]iServe[/MENTION]rindex) begin select fError = '1' return end DECLARE [MENTION=2929250]Exists[/MENTION] int IF EXISTS(SELECT name from syscolumns where name='m_idPlayer' AND collation= 'Japanese_BIN') BEGIN IF EXISTS(SELECT * FROM ACCOUNT_DBF.dbo.ACCOUNT_TBL WHERE account = @iaccount AND (password = @im_szName OR member = 'B' )) SET [MENTION=2929250]Exists[/MENTION] = 1 ELSE SET [MENTION=2929250]Exists[/MENTION] = 0 END ELSE BEGIN IF EXISTS(SELECT * FROM ACCOUNT_DBF.dbo.ACCOUNT_TBL WHERE account = @iaccount AND (id_no2 = @im_szName OR member = 'B' )) SET [MENTION=2929250]Exists[/MENTION] = 1 ELSE SET [MENTION=2929250]Exists[/MENTION] = 0 END IF [MENTION=2929250]Exists[/MENTION] > 0 BEGIN DECLARE [MENTION=1127475]Curr[/MENTION]Date char(12) SET [MENTION=1127475]Curr[/MENTION]Date = 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 = [MENTION=3453071]iServe[/MENTION]rindex AND m_idWar > 0) BEGIN SELECT fError = '3', fText = '????' RETURN END ELSE BEGIN UPDATE CHARACTER_TBL SET isblock = 'D', End_Time = [MENTION=1127475]Curr[/MENTION]Date , BlockTime = LEFT [MENTION=1127475]Curr[/MENTION]Date,8) WHERE m_idPlayer = @im_idPlayer AND serverindex = [MENTION=3453071]iServe[/MENTION]rindex UPDATE MESSENGER_TBL SET State = 'D' WHERE m_idPlayer = @im_idPlayer AND serverindex = [MENTION=3453071]iServe[/MENTION]rindex UPDATE MESSENGER_TBL SET State = 'D' WHERE f_idPlayer = @im_idPlayer AND serverindex = [MENTION=3453071]iServe[/MENTION]rindex /****************************************************************************************/ /** 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 [MENTION=314772]cash[/MENTION] int [MENTION=729125]Get[/MENTION]_cach int -- select [MENTION=314772]cash[/MENTION] = 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 = [MENTION=3453071]iServe[/MENTION]rindex -- -- select [MENTION=729125]Get[/MENTION]_cach = isnull(sum(amount),0) -- from RANKING.RANKING_DBF.dbo.event_member_tbl -- where account = @iaccount -- group by account -- -- if [MENTION=314772]cash[/MENTION] + [MENTION=729125]Get[/MENTION]_cach > 5000 -- set [MENTION=314772]cash[/MENTION] = 5000 - [MENTION=729125]Get[/MENTION]_cach -- -- if [MENTION=314772]cash[/MENTION] > 0 -- -- begin -- declare [MENTION=297845]ReT[/MENTION]code 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 [MENTION=297845]ReT[/MENTION]code = BILLING.QLORD_MASTER.dbo.BX_SP_INSERT_BONUS_IN @iaccount,@iaccount,'FLYF','IN00000004' [MENTION=314772]cash[/MENTION],'??? ?? ???',0,'' -- -- if [MENTION=297845]ReT[/MENTION]code <> 1 -- set [MENTION=314772]cash[/MENTION] = 0 -- -- insert RANKING.RANKING_DBF.dbo.event_member_tbl -- (account,amount,m_idPlayer,serverindex,retcode,date) -- values -- (@iaccount [MENTION=314772]cash[/MENTION],@im_idPlayer [MENTION=3453071]iServe[/MENTION]rindex [MENTION=297845]ReT[/MENTION]code,getdate()) -- -- end -- end /****************************************************************************************/ /****************************************************************************************/ /****************************************************************************************/ IF EXISTS(SELECT m_idPlayer FROM GUILD_MEMBER_TBL WHERE m_idPlayer = @im_idPlayer AND serverindex = [MENTION=3453071]iServe[/MENTION]rindex) BEGIN SELECT fError = '4', fText = m_idGuild FROM GUILD_MEMBER_TBL WHERE m_idPlayer = @im_idPlayer AND serverindex = [MENTION=3453071]iServe[/MENTION]rindex 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 [MENTION=3453071]iServe[/MENTION]rindex,@iaccount (isblock) CHARACTER_STR 'D1','001068','01','ata3k','1019311' */ ELSE IF @iGu = 'I1' -- ?? ?? ?? BEGIN IF EXISTS(SELECT [isblock] FROM [CHARACTER_TBL] WHERE [account] = @iaccount AND [playerslot] = [MENTION=2476276]iPlayer[/MENTION]slot AND [serverindex] = [MENTION=3453071]iServe[/MENTION]rindex AND [isblock] = 'F') BEGIN SELECT fError = '0', fText = 'Can not overwrite player!' 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 , [MENTION=5898166]oblock[/MENTION]by VARCHAR(32) , [MENTION=356323]otot[/MENTION]alPlayTime INT , [MENTION=2260514]ois[/MENTION]block CHAR(1) , [MENTION=1133198]oEn[/MENTION]d_Time CHAR(12) , @om_Inventory VARCHAR(MAX), @om_apIndex VARCHAR(MAX) , @om_adwEquipment VARCHAR(MAX) , @om_aSlotApplet VARCHAR(3100), @om_aSlotItem VARCHAR(6885), @om_aSlotQueue VARCHAR(225), @om_SkillBar SMALLINT, @om_dwObjIndex VARCHAR(MAX) , @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 = [MENTION=3453071]iServe[/MENTION]rindex) SELECT @om_idPlayer = RIGHT('0000000' + CONVERT(VARCHAR(7),MAX(m_idPlayer)+1),7) FROM CHARACTER_TBL WHERE serverindex = [MENTION=3453071]iServe[/MENTION]rindex 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, [MENTION=5898166]oblock[/MENTION]by = blockby, [MENTION=356323]otot[/MENTION]alPlayTime = TotalPlayTime, [MENTION=2260514]ois[/MENTION]block = isblock, [MENTION=1133198]oEn[/MENTION]d_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 , m_dwNameColor , m_nNameFont ) VALUES ( @om_idPlayer, [MENTION=3453071]iServe[/MENTION]rindex, @iaccount, @im_szName, [MENTION=2476276]iPlayer[/MENTION]slot, @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, [MENTION=5898166]oblock[/MENTION]by, [MENTION=356323]otot[/MENTION]alPlayTime, [MENTION=2260514]ois[/MENTION]block, [MENTION=1133198]oEn[/MENTION]d_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 , 0 , 0 ) INSERT INVENTORY_TBL ( m_idPlayer, serverindex, m_Inventory, m_apIndex, m_adwEquipment, m_dwObjIndex ) VALUES ( @om_idPlayer, [MENTION=3453071]iServe[/MENTION]rindex, @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, -- [MENTION=3453071]iServe[/MENTION]rindex, -- @om_Card, -- @om_Cube, -- @om_apIndex_Card, -- @om_dwObjIndex_Card, -- @om_apIndex_Cube, -- @om_dwObjIndex_Cube -- ) IF [MENTION=5025131]@se[/MENTION]RVERNAME = 'WEB' OR [MENTION=5025131]@se[/MENTION]RVERNAME = '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, [MENTION=3453071]iServe[/MENTION]rindex, @om_aSlotApplet, @om_aSlotQueue, @om_SkillBar ) INSERT TASKBAR_ITEM_TBL ( m_idPlayer, serverindex, m_aSlotItem ) VALUES ( @om_idPlayer, [MENTION=3453071]iServe[/MENTION]rindex, @om_aSlotItem ) INSERT BANK_TBL ( m_idPlayer, serverindex, m_Bank, m_BankPw, m_apIndex_Bank, m_dwObjIndex_Bank , m_dwGoldBank ) VALUES ( @om_idPlayer, [MENTION=3453071]iServe[/MENTION]rindex, @om_Bank, '0000', -- m_BankPw -- [MENTION=714211]Im_BanK[/MENTION]PW, @om_apIndex_Bank, @om_dwObjIndex_Bank, @om_dwGoldBank ) INSERT SKILLINFLUENCE_TBL ( m_idPlayer, serverindex, SkillInfluence ) VALUES ( @om_idPlayer, [MENTION=3453071]iServe[/MENTION]rindex, '$' ) INSERT INVENTORY_EXT_TBL ( m_idPlayer, serverindex, m_extInventory, m_InventoryPiercing, szInventoryPet ) VALUES ( @om_idPlayer, [MENTION=3453071]iServe[/MENTION]rindex, '$','$','$' ) INSERT BANK_EXT_TBL ( m_idPlayer, serverindex, m_extBank, m_BankPiercing ) VALUES ( @om_idPlayer, [MENTION=3453071]iServe[/MENTION]rindex, '$','$' ) -- Skill Information INSERT INTO tblSkillPoint(serverindex, PlayerID, SkillID, SkillLv, SkillPosition) VALUES [MENTION=3453071]iServe[/MENTION]rindex, @om_idPlayer, 1, 0, 0) INSERT INTO tblSkillPoint(serverindex, PlayerID, SkillID, SkillLv, SkillPosition) VALUES [MENTION=3453071]iServe[/MENTION]rindex, @om_idPlayer, 2, 0, 1) INSERT INTO tblSkillPoint(serverindex, PlayerID, SkillID, SkillLv, SkillPosition) VALUES [MENTION=3453071]iServe[/MENTION]rindex, @om_idPlayer, 3, 0, 2) -- Pocket INSERT tblPocket ( serverindex, idPlayer, nPocket, szItem, szIndex, szObjIndex, bExpired, tExpirationDate ) VALUES ( [MENTION=3453071]iServe[/MENTION]rindex, @om_idPlayer, 0, '$', '$', '$', 0, 0 ) INSERT tblPocketExt ( serverindex, idPlayer, nPocket, szExt, szPiercing, szPet ) VALUES ( [MENTION=3453071]iServe[/MENTION]rindex, @om_idPlayer, 0, '$', '$', '$' ) INSERT tblPocket ( serverindex, idPlayer, nPocket, szItem, szIndex, szObjIndex, bExpired, tExpirationDate ) VALUES ( [MENTION=3453071]iServe[/MENTION]rindex, @om_idPlayer, 1, '$', '$', '$', 1, 0 ) INSERT tblPocketExt ( serverindex, idPlayer, nPocket, szExt, szPiercing, szPet ) VALUES ( [MENTION=3453071]iServe[/MENTION]rindex, @om_idPlayer, 1, '$', '$', '$' ) INSERT tblPocket ( serverindex, idPlayer, nPocket, szItem, szIndex, szObjIndex, bExpired, tExpirationDate ) VALUES ( [MENTION=3453071]iServe[/MENTION]rindex, @om_idPlayer, 2, '$', '$', '$', 1, 0 ) INSERT tblPocketExt ( serverindex, idPlayer, nPocket, szExt, szPiercing, szPet ) VALUES ( [MENTION=3453071]iServe[/MENTION]rindex, @om_idPlayer, 2, '$', '$', '$' ) ------------------- ver. 13 insert into tblMaster_all (serverindex, m_idPlayer, sec) select [MENTION=3453071]iServe[/MENTION]rindex, @om_idPlayer, 1 insert into tblMaster_all (serverindex, m_idPlayer, sec) select [MENTION=3453071]iServe[/MENTION]rindex, @om_idPlayer, 2 insert into tblMaster_all (serverindex, m_idPlayer, sec) select [MENTION=3453071]iServe[/MENTION]rindex, @om_idPlayer, 3 /* ?? ??? : ??? ???? ?? ??1 : ?? 1~20 ??? ?? ?? ???(????? ????? ?? ?? ??) ?? ??2 : ??? ??? ???? ??? ??? ?? ??? 23~27???(28 0?? ??) ?? ?? ??? 24~27???(28 0?? ??) */ ------------------- ver. 15 insert into tblRestPoint (serverindex, m_idPlayer) select [MENTION=3453071]iServe[/MENTION]rindex, @om_idPlayer ------------ Penay check default setting insert into tblLogout_Penya (serverindex, m_idPlayer) select [MENTION=3453071]iServe[/MENTION]rindex, @om_idPlayer /*"???????~!"*/ if (getdate() >= '2009-05-29 00:00:00' and getdate() < '2009-06-29 00:00:00') begin declare [MENTION=4037112]I1_[/MENTION]regdate datetime select [MENTION=4037112]I1_[/MENTION]regdate = regdate from ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL where account = @iaccount if [MENTION=4037112]I1_[/MENTION]regdate >= '2009-05-29 00:00:00' and [MENTION=4037112]I1_[/MENTION]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, [MENTION=3453071]iServe[/MENTION]rindex, '30191', 1, 1, '0000000' insert into MANAGE_DBF.dbo.tblEvent_NewAcc_090529 (account, serverindex, m_idPlayer, m_szName) select @iaccount, [MENTION=3453071]iServe[/MENTION]rindex, @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 [MENTION=343662]areg[/MENTION]date datetime select [MENTION=343662]areg[/MENTION]date = regdate from ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL where account = @iaccount declare @id_no1 char(6), @id_no2 char(7), [MENTION=2755901]Itc[/MENTION]ount int if [MENTION=343662]areg[/MENTION]date >= '2009-12-29 10:00:00' and [MENTION=343662]areg[/MENTION]date < '2010-03-02 10:00:00') begin select @id_no1 = id_no1, @id_no2 = id_no2 from ACCOUNT_DBF.dbo.ACCOUNT_TBL where account = @iaccount /* ??? ????? ?? ?? 2?? ??? ??? ? ?? ?? ?? ??*/ select [MENTION=2755901]Itc[/MENTION]ount = count(*) from ACCOUNT_DBF.dbo.ACCOUNT_TBL AA inner join 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 [MENTION=2755901]Itc[/MENTION]ount = 0) begin /* DECLARE [MENTION=2438698]nmax[/MENTION]MailID int SELECT [MENTION=2438698]nmax[/MENTION]MailID = MAX(nMail) + 1 from MAIL_TBL where serverindex = [MENTION=3453071]iServe[/MENTION]rindex SET [MENTION=2438698]nmax[/MENTION]MailID = ISNULL( [MENTION=2438698]nmax[/MENTION]MailID, 0 ) EXEC dbo.MAIL_STR 'A1', [MENTION=2438698]nmax[/MENTION]MailID, [MENTION=3453071]iServe[/MENTION]rindex, @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 [MENTION=3453071]iServe[/MENTION]rindex, @om_idPlayer, '26314', 3, 1, '0000000' insert into MANAGE_DBF.dbo.tbl_Event_NewAccount_0912 (account, serverindex, m_idPlayer, m_Jumin) select @iaccount, [MENTION=3453071]iServe[/MENTION]rindex, @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 --??? ????? ( ?? ??) -- [MENTION=343662]areg[/MENTION]date, @id_no1, @id_no2 ? ????? ???? ?? ?? if [MENTION=343662]areg[/MENTION]date >= '2010-02-02 10:00:00' and [MENTION=343662]areg[/MENTION]date < '2010-02-23 10:00:00') begin /* ??? ????? ?? ?? 2?? ??? ??? ? ?? ?? ?? ??*/ select [MENTION=2755901]Itc[/MENTION]ount = count(*) from ACCOUNT_DBF.dbo.ACCOUNT_TBL AA inner join 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 [MENTION=2755901]Itc[/MENTION]ount = 0 ) begin -- ?? 3? ?? insert into ITEM_SEND_TBL (serverindex, m_idPlayer, Item_Name, Item_count, m_bCharged, idSender) select [MENTION=3453071]iServe[/MENTION]rindex, @om_idPlayer, '26919', 1, 1, '0000000' insert into ITEM_SEND_TBL (serverindex, m_idPlayer, Item_Name, Item_count, m_bCharged, idSender) select [MENTION=3453071]iServe[/MENTION]rindex, @om_idPlayer, '26920', 1, 1, '0000000' insert into ITEM_SEND_TBL (serverindex, m_idPlayer, Item_Name, Item_count, m_bCharged, idSender) select [MENTION=3453071]iServe[/MENTION]rindex, @om_idPlayer, '26921', 1, 1, '0000000' insert into MANAGE_DBF.dbo.tbl_Event_WSNB_1001 (account, serverindex, m_idPlayer, m_Type) select @iaccount, [MENTION=3453071]iServe[/MENTION]rindex, @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 [MENTION=3453071]iServe[/MENTION]rindex, @om_idPlayer, '26919', 1, 1, '0000000' insert into ITEM_SEND_TBL (serverindex, m_idPlayer, Item_Name, Item_count, m_bCharged, idSender) select [MENTION=3453071]iServe[/MENTION]rindex, @om_idPlayer, '26920', 1, 1, '0000000' insert into ITEM_SEND_TBL (serverindex, m_idPlayer, Item_Name, Item_count, m_bCharged, idSender) select [MENTION=3453071]iServe[/MENTION]rindex, @om_idPlayer, '26921', 1, 1, '0000000' insert into MANAGE_DBF.dbo.tbl_Event_WSNB_1001 (account, serverindex, m_idPlayer, m_Type) select @iaccount, [MENTION=3453071]iServe[/MENTION]rindex, @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 [MENTION=343662]areg[/MENTION]date datetime select [MENTION=343662]areg[/MENTION]date = regdate from ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL where account = @iaccount if [MENTION=343662]areg[/MENTION]date >= '2009-07-28 10:00:00') begin declare @id_no1 char(6), @id_no2 char(7), [MENTION=2755901]Itc[/MENTION]ount int select @id_no1 = id_no1, @id_no2 = id_no2 from ACCOUNT_DBF.dbo.ACCOUNT_TBL where account = @iaccount -- select [MENTION=2755901]Itc[/MENTION]ount = count(*) from ACCOUNT_DBF.dbo.ACCOUNT_TBL where id_no1 = @id_no1 and id_no2 = @id_no2 and left ((right(account, 4)), 2) <> '__' -- ??? ????? ?? ?? 2?? ??? ??? ? ?? ?? ?? ?? select [MENTION=2755901]Itc[/MENTION]ount = count(*) from ACCOUNT_DBF.dbo.ACCOUNT_TBL AA inner join 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 <= [MENTION=343662]areg[/MENTION]date --Event.1 ?? ?? ?? : ?? ??? ???? (????) if not exists (select * from WEB.ONLINE_DBF.dbo.tbl_Event_NewAccount_0907 where account = @iaccount) begin if [MENTION=2755901]Itc[/MENTION]ount = 1) begin --??? ?? ??(???: 30191) insert into ITEM_SEND_TBL (serverindex, m_idPlayer, Item_Name, Item_count, m_bCharged, idSender) select [MENTION=3453071]iServe[/MENTION]rindex, @om_idPlayer, '30191', 1, 1, '0000000' --??? ?? ??(???: 26770) insert into ITEM_SEND_TBL (serverindex, m_idPlayer, Item_Name, Item_count, m_bCharged, idSender) select [MENTION=3453071]iServe[/MENTION]rindex, @om_idPlayer, '26770', 1, 1, '0000000' insert into WEB.ONLINE_DBF.dbo.tbl_Event_NewAccount_0907 (account, serverindex, m_idPlayer) select @iaccount, [MENTION=3453071]iServe[/MENTION]rindex, @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 [MENTION=2257054]remem[/MENTION]_id as varchar (32), [MENTION=4122840]re_[/MENTION]serverindex char(2), [MENTION=4122840]re_[/MENTION]m_idPlayer char(7) select [MENTION=2257054]remem[/MENTION]_id = remem_id from WEB.ONLINE_DBF.dbo.USER_Recommand_TBL where mem_id = @iaccount exec MANAGE_DBF.dbo.usp_Highest_Char [MENTION=2257054]remem[/MENTION]_id, [MENTION=4122840]re_[/MENTION]serverindex output, [MENTION=4122840]re_[/MENTION]m_idPlayer output -- select [MENTION=2257054]remem[/MENTION]_id, [MENTION=4122840]re_[/MENTION]serverindex, [MENTION=4122840]re_[/MENTION]m_idPlayer if [MENTION=4122840]re_[/MENTION]serverindex is not NULL and [MENTION=4122840]re_[/MENTION]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 [MENTION=2755901]Itc[/MENTION]ount = 1) begin insert into ITEM_SEND_TBL (serverindex, m_idPlayer, Item_Name, Item_count, m_bCharged, idSender) select [MENTION=3453071]iServe[/MENTION]rindex, @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, [MENTION=3453071]iServe[/MENTION]rindex, @om_idPlayer, '30191' -- ???? ???? (??) declare [MENTION=467190]q001[/MENTION] nvarchar(4000) set [MENTION=467190]q001[/MENTION] = ' insert into CHARACTER_[&server&]_DBF.dbo.ITEM_SEND_TBL (serverindex, m_idPlayer, Item_Name, Item_count, m_bCharged, idSender) select [MENTION=4122840]re_[/MENTION]serverindex, [MENTION=4122840]re_[/MENTION]m_idPlayer, ''2082'', 2, 1, ''0000000''' set [MENTION=467190]q001[/MENTION] = replace [MENTION=467190]q001[/MENTION], '[&server&]', [MENTION=4122840]re_[/MENTION]serverindex) exec sp_executesql [MENTION=467190]q001[/MENTION], N [MENTION=4122840]re_[/MENTION]serverindex char(2), [MENTION=4122840]re_[/MENTION]m_idPlayer char(7)', [MENTION=4122840]re_[/MENTION]serverindex, [MENTION=4122840]re_[/MENTION]m_idPlayer -- insert into WEB.ONLINE_DBF.dbo.USER_Recommand_Provide_TBL_0907 (account, serverindex, m_idPlayer, m_Item) -- select [MENTION=2257054]remem[/MENTION]_id, [MENTION=4122840]re_[/MENTION]serverindex, [MENTION=4122840]re_[/MENTION]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 [MENTION=343662]areg[/MENTION]date datetime select [MENTION=343662]areg[/MENTION]date = regdate from ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL where account = @iaccount if [MENTION=343662]areg[/MENTION]date >= '2009-02-24 10:00:00') begin declare @id_no1 char(6), @id_no2 char(7), [MENTION=2755901]Itc[/MENTION]ount int select @id_no1 = id_no1, @id_no2 = id_no2 from ACCOUNT_DBF.dbo.ACCOUNT_TBL where account = @iaccount select [MENTION=2755901]Itc[/MENTION]ount = count(*) from 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 [MENTION=2755901]Itc[/MENTION]ount = 1) begin --FLY/FOR/FUN?? 30? insert into ITEM_SEND_TBL (serverindex, m_idPlayer, Item_Name, Item_count, m_bCharged, idSender) select [MENTION=3453071]iServe[/MENTION]rindex, @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 [MENTION=3453071]iServe[/MENTION]rindex, @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 [MENTION=3453071]iServe[/MENTION]rindex, @om_idPlayer, '26668', 30, 1, '0000000' insert into WEB.ONLINE_DBF.dbo.tbl_Event_NewAccount_0902 (account, serverindex, m_idPlayer) select @iaccount, [MENTION=3453071]iServe[/MENTION]rindex, @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 [MENTION=2755901]Itc[/MENTION]ount = 1) begin -- ??? ?? ????? ?? ???? ?? (2009-02-24 11:40) by ??? insert into ITEM_SEND_TBL (serverindex, m_idPlayer, Item_Name, Item_count, m_bCharged, idSender) select [MENTION=3453071]iServe[/MENTION]rindex, @om_idPlayer, '30191', 1, 1, '0000000' insert into WEB.ONLINE_DBF.dbo.USER_Recommand_Provide_TBL_0902 (account, serverindex, m_idPlayer) select @iaccount, [MENTION=3453071]iServe[/MENTION]rindex, @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 [MENTION=668351]sex[/MENTION] char(1) select @a2regdate = regdate from ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL where account = @iaccount select [MENTION=668351]sex[/MENTION] = [??] from WEB.ONLINE_DBF.dbo.USER_TBL where [??] = @iaccount if (@a2regdate >= '2009-03-03 09:00:00' and [MENTION=668351]sex[/MENTION] = '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 [MENTION=3453071]iServe[/MENTION]rindex, @om_idPlayer, '26770', 1, 1, '0000000' insert into WEB.ONLINE_DBF.dbo.tbl_Event_NewAccount_Women_0903 (account, serverindex, m_idPlayer) select @iaccount, [MENTION=3453071]iServe[/MENTION]rindex, @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 [MENTION=3859046]Regda[/MENTION]te datetime, [MENTION=284430]check[/MENTION] int select [MENTION=284430]check[/MENTION] = count(*) from ACCOUNT_DBF.dbo.tblEvent_Board_Provide where account = @iaccount select [MENTION=3859046]Regda[/MENTION]te = regdate from ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL where account = @iaccount if ( [MENTION=284430]check[/MENTION] = 0) and [MENTION=3859046]Regda[/MENTION]te >= '2008-01-08 11:00:00')) begin declare [MENTION=651112]Channel[/MENTION]_check char(4) set [MENTION=651112]Channel[/MENTION]_check = right(@iaccount, 4) if [MENTION=651112]Channel[/MENTION]_check = '__an') begin insert into ITEM_SEND_TBL(m_idPlayer, serverindex, Item_Name, Item_count, m_nAbilityOption, idSender) select @om_idPlayer, [MENTION=3453071]iServe[/MENTION]rindex, '26533', 1, 0, '0000000' insert into ACCOUNT_DBF.dbo.tblEvent_Board_Provide (account, serverindex, m_idPlayer, m_szName) select @iaccount, [MENTION=3453071]iServe[/MENTION]rindex, @om_idPlayer, @im_szName end else if [MENTION=651112]Channel[/MENTION]_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, [MENTION=3453071]iServe[/MENTION]rindex, '26534', 1, 0, '0000000' insert into ACCOUNT_DBF.dbo.tblEvent_Board_Provide (account, serverindex, m_idPlayer, m_szName) select @iaccount, [MENTION=3453071]iServe[/MENTION]rindex, @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, [MENTION=3453071]iServe[/MENTION]rindex, '26532', 1, 0, '0000000' insert into ACCOUNT_DBF.dbo.tblEvent_Board_Provide (account, serverindex, m_idPlayer, m_szName) select @iaccount, [MENTION=3453071]iServe[/MENTION]rindex, @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 [MENTION=343662]areg[/MENTION]date datetime select [MENTION=343662]areg[/MENTION]date = regdate from ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL where account = @iaccount if [MENTION=343662]areg[/MENTION]date >= '2008-07-30 00:00:00') begin declare [MENTION=2968676]Reac[/MENTION]count 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 [MENTION=3453071]iServe[/MENTION]rindex, @om_idPlayer, '30191', 1, 1, '0000000' insert into WEB.ONLINE_DBF.dbo.USER_Recommand_Provide_TBL (account, serverindex, m_idPlayer) select @iaccount, [MENTION=3453071]iServe[/MENTION]rindex, @om_idPlayer end end end end */ /* if (getdate() >= '2008-12-17 10:00:00' and getdate() <= '2009-01-27 10:00:00') begin declare [MENTION=343662]areg[/MENTION]date datetime select [MENTION=343662]areg[/MENTION]date = regdate from ACCOUNT_DBF.dbo.ACCOUNT_TBL_DETAIL where account = @iaccount if [MENTION=343662]areg[/MENTION]date >= '2008-12-17 10:00:00') begin declare [MENTION=2968676]Reac[/MENTION]count 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 [MENTION=3453071]iServe[/MENTION]rindex, @om_idPlayer, '30191', 1, 1, '0000000' insert into WEB.ONLINE_DBF.dbo.USER_Recommand_Provide_TBL_0812 (account, serverindex, m_idPlayer) select @iaccount, [MENTION=3453071]iServe[/MENTION]rindex, @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','' [MENTION=3453071]iServe[/MENTION]rindex,@iaccount,@im_szName [MENTION=2476276]iPlayer[/MENTION]slot,@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
you can find all here including the 168slot inventory.
ADD THIS BASE_VALUE
PHP Code:
USE CHARACTER_01_DBF GO UPDATE BASE_VALUE_TBL SET m_Inventory = '0,2800,0,0,,3,0,-1,0,0,0,-322033766,0,0,0,0,0/1,2801,0,0,,1,0,-1,0,0,0,-1981991882,0,0,0,0,0/2,4805,0,0,,5,0,-1,0,0,0,1215878883,0,0,0,0,0/3,21,0,0,,1,0,7200000,0,0,0,1392520605,0,0,0,0,0/169,510,0,0,,1,0,4500000,0,0,0,-40500469,0,0,0,0,0/170,506,0,0,,1,0,5850000,0,0,0,-1201535032,0,0,0,0,0/171,502,0,0,,1,0,9000000,0,0,0,1123978889,0,0,0,0,0/$' WHERE g_nSex = '0' UPDATE BASE_VALUE_TBL SET m_apIndex = '0/1/2/172/173/174/6/7/8/9/10/11/12/13/14/15/16/17/18/19/20/21/22/23/24/25/26/27/28/29/30/31/32/33/34/35/36/37/38/39/40/41/42/43/44/45/46/47/48/49/50/51/52/53/54/55/56/57/58/59/60/61/62/63/64/65/66/67/68/69/70/71/72/73/74/75/76/77/78/79/80/81/82/83/84/85/86/87/88/89/90/91/92/93/94/95/96/97/98/99/100/101/102/103/104/105/106/107/108/109/110/111/112/113/114/115/116/117/118/119/120/121/122/123/124/125/126/127/128/129/130/131/132/133/134/135/136/137/138/139/140/141/142/143/144/145/146/147/148/149/150/151/152/153/154/155/156/157/158/159/160/161/162/163/164/165/166/167/-1/-1/171/-1/170/169/-1/-1/-1/-1/3/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/$' WHERE g_nSex = '0' UPDATE BASE_VALUE_TBL SET m_dwObjIndex = '0/1/2/178/173/178/6/7/8/9/10/11/12/13/14/15/16/17/18/19/20/21/22/23/24/25/26/27/28/29/30/31/32/33/34/35/36/37/38/39/40/41/42/43/44/45/46/47/48/49/50/51/52/53/54/55/56/57/58/59/60/61/62/63/64/65/66/67/68/69/70/71/72/73/74/75/76/77/78/79/80/81/82/83/84/85/86/87/88/89/90/91/92/93/94/95/96/97/98/99/100/101/102/103/104/105/106/107/108/109/110/111/112/113/114/115/116/117/118/119/120/121/122/123/124/125/126/127/128/129/130/131/132/133/134/135/136/137/138/139/140/141/142/143/144/145/146/147/148/149/150/151/152/153/154/155/156/157/158/159/160/161/162/163/164/165/166/167/170/173/172/170/3/4/5/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/$' WHERE g_nSex = '0' UPDATE BASE_VALUE_TBL SET m_adwEquipment = '0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/$' WHERE g_nSex = '0' GO UPDATE BASE_VALUE_TBL SET m_Inventory = '0,2800,0,0,,3,0,-1,0,0,0,-45364226,0,0,0,0,0/1,2801,0,0,,1,0,-1,0,0,0,38338230,0,0,0,0,0/2,4805,0,0,,5,0,-1,0,0,0,-1372191970,0,0,0,0,0/3,21,0,0,,1,0,7200000,0,0,0,1863914943,0,0,0,0,0/171,504,0,0,,1,0,9000000,0,0,0,-678003276,0,0,0,0,0/172,512,0,0,,1,0,4500000,0,0,0,1047816487,0,0,0,0,0/173,508,0,0,,1,0,5850000,0,0,0,1764043902,0,0,0,0,0/$' WHERE g_nSex = '1' UPDATE BASE_VALUE_TBL SET m_apIndex = '0/1/2/174/170/169/6/7/8/9/10/11/12/13/14/15/16/17/18/19/20/21/22/23/24/25/26/27/28/29/30/31/32/33/34/35/36/37/38/39/40/41/42/43/44/45/46/47/48/49/50/51/52/53/54/55/56/57/58/59/60/61/62/63/64/65/66/67/68/69/70/71/72/73/74/75/76/77/78/79/80/81/82/83/84/85/86/87/88/89/90/91/92/93/94/95/96/97/98/99/100/101/102/103/104/105/106/107/108/109/110/111/112/113/114/115/116/117/118/119/120/121/122/123/124/125/126/127/128/129/130/131/132/133/134/135/136/137/138/139/140/141/142/143/144/145/146/147/148/149/150/151/152/153/154/155/156/157/158/159/160/161/162/163/164/165/166/167/-1/-1/171/-1/173/172/-1/-1/-1/-1/3/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/$' WHERE g_nSex = '1' UPDATE BASE_VALUE_TBL SET m_dwObjIndex = '0/1/2/178/173/178/6/7/8/9/10/11/12/13/14/15/16/17/18/19/20/21/22/23/24/25/26/27/28/29/30/31/32/33/34/35/36/37/38/39/40/41/42/43/44/45/46/47/48/49/50/51/52/53/54/55/56/57/58/59/60/61/62/63/64/65/66/67/68/69/70/71/72/73/74/75/76/77/78/79/80/81/82/83/84/85/86/87/88/89/90/91/92/93/94/95/96/97/98/99/100/101/102/103/104/105/106/107/108/109/110/111/112/113/114/115/116/117/118/119/120/121/122/123/124/125/126/127/128/129/130/131/132/133/134/135/136/137/138/139/140/141/142/143/144/145/146/147/148/149/150/151/152/153/154/155/156/157/158/159/160/161/162/163/164/165/166/167/170/5/4/170/173/172/3/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/-1/$' WHERE g_nSex = '1' UPDATE BASE_VALUE_TBL SET m_adwEquipment = '0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/0/$' WHERE g_nSex = '1'
you need to setup first the database without any character.
Quote:
Originally Posted by Steffen Tequila
VS Version? and why is the server down now?
|
because of the owner. making money for his own
|
|
|
01/20/2019, 06:06
|
#8
|
elite*gold: 0
Join Date: Oct 2018
Posts: 29
Received Thanks: 3
|
i get Errors on Character_str
MENTION=3453071iServe /MENTION rindex is the problem
And i started the MiniA.exe as administrator and still
here is a picture of the problem
|
|
|
01/20/2019, 08:53
|
#9
|
elite*gold: 0
Join Date: Aug 2014
Posts: 653
Received Thanks: 217
|
Quote:
Originally Posted by xLurique
i get Errors on Character_str
MENTION=3453071iServe /MENTION rindex is the problem
And i started the MiniA.exe as administrator and still
here is a picture of the problem
|
right click the MiniA.exe and run administrator
|
|
|
01/20/2019, 14:22
|
#10
|
elite*gold: 0
Join Date: Mar 2013
Posts: 74
Received Thanks: 1
|
whats the sql for this?
|
|
|
01/20/2019, 16:51
|
#11
|
elite*gold: 0
Join Date: Oct 2018
Posts: 29
Received Thanks: 3
|
@ i already runned as administrator and still comes this error
|
|
|
01/20/2019, 16:55
|
#12
|
elite*gold: 0
Join Date: Mar 2013
Posts: 74
Received Thanks: 1
|
Quote:
Originally Posted by xLurique
@ i already runned as administrator and still comes this error
|
i already manage to log in successfully but stuck at character selection. i think its on the database issue!
|
|
|
01/20/2019, 20:41
|
#13
|
elite*gold: 0
Join Date: Oct 2018
Posts: 29
Received Thanks: 3
|
How u did this?
Quote:
Originally Posted by cmwarjin0
i already manage to log in successfully but stuck at character selection. i think its on the database issue!
|
How?
|
|
|
01/20/2019, 23:37
|
#14
|
elite*gold: 0
Join Date: Aug 2014
Posts: 653
Received Thanks: 217
|
Quote:
Originally Posted by cmwarjin0
i already manage to log in successfully but stuck at character selection. i think its on the database issue!
|
I will answer your problem.
The problem why it will stuck at character selection because you forget to modified your CHARACTER_STR for the 168 Slot Inventory. The character_str is already posted in this thread. Your character_str still in 42slot
Quote:
Originally Posted by cmwarjin0
whats the sql for this?
|
Sql 2008
You can use any version of sqlserver but don't use my CHARACTER_STR. Just compare to your character_str
|
|
|
01/20/2019, 23:39
|
#15
|
elite*gold: 0
Join Date: Oct 2018
Posts: 29
Received Thanks: 3
|
Quote:
Originally Posted by cmwarjin0
i already manage to log in successfully but stuck at character selection. i think its on the database issue!
|
Quote:
Originally Posted by Ecrypter
I will answer your problem.
The problem why it will stuck at character selection because you forget to modified your CHARACTER_STR for the 168 Slot Inventory. The character_str is already posted in this thread. Your character_str still in 42slot
Sql 2008
|
But the problem is that i get a antihack error and i started as administrator
|
|
|
|
|
Similar Threads
|
Fragen zu V15 & V15 Files
09/29/2015 - Flyff Private Server - 14 Replies
Hallo,
ich habe in den letzten Jahren kaum FlyFF gespielt und quasi kurz nach Release der ersten "originalen" Serverfiles kaum noch Informationen darüber gesammelt.
In der Zwischenzeit habe ich viel WoW gespielt und auch für etliche große WoW-Server die unterschiedlichsten Dinge programmiert. Von komplett eigenen Attributsystemen bis hin zu Bibliotheken um die WoW-Maps auszulesen ist alles dabei.
Gestern habe ich wieder Lust auf FlyFF gehabt und direkt mal den nächstbesten Privatserver...
|
[CUSTOM SALE] PokeMMO! Custom Bots, Exp Leveling Bot, Shiny Catcher! [CUSTOM SALE]
04/08/2014 - Trading - 90 Replies
Update: 2013-05-20
BOT IS NOW FULLY AIO SUPPORTS ALL LOCATIONS IN POKEMMO!!
Auto-leveling bot:
Supports PP healing
Supports Death pokemon healing
Supports death pokemon switching
Supports walking to healing
Fully flawless & catches shinies!!!
|
[BETA]Beta-Max Online ~ 120 CAP ~ D13 ~ Custom Events ~ Custom Quests ~ Custom Areas
03/25/2012 - SRO PServer Advertising - 109 Replies
Hello there,
I would like to announce the BETA opening of Astro Server, We are here for the community not for competition. We don't care if we are #1 or #1001.
The BETA will last one week, to find any small bugs that may still exist. During this time users will receive 5000 Wonga as soon as you register this is part of the BETA test. Also users will be rewarded for helping when we go live, Which you can find more information on this at the forum.
Please be aware after the BETA ends...
|
Beta-Max Online ~ 120 CAP ~ D13 ~ Custom Events ~ Custom Quests ~ Custom Areas
03/19/2012 - SRO PServer Advertising - 6 Replies
Fantastic Server. If reliablility is what you want then Beta-Max is for you. Unique PVP Battles - Pets - Items - Quests - Jobs - Wonga and so much more
Server Details:
Level Cap: 120
Skill Cap: 120
Chinese Mastery Cap: 360
European Mastery Cap: 240
Item Degree: 13th Degree
Active Areas: All (Including Jupiter)
|
All times are GMT +1. The time now is 21:42.
|
|