Gunz SQL Processing (ADV Coder).

Status
Not open for further replies.
Hideasu

Hideasu

Newbie Spellweaver
10 Happy Years
Joined
Aug 10, 2011
Messages
77
Reaction score
133
Gunz SQL Interaction:
Code: 
// SQL ////////////////////////////////////////////////////////////////////////
///////////////////////////////////////////////////////////////////////////////

//@UserID		varchar(20)
TCHAR g_szDB_GET_LOGININFO[] = _T("{CALL spGetLoginInfo ('%s')}");

//@AID  int 
TCHAR g_szDB_GET_ACCOUNTINFO[] = _T("{CALL spGetAccountInfo (%d)}");

//@AID  int,    
//@CharNum smallint,    
//@CharName varchar(24)   
TCHAR g_szDB_DELETE_CHAR[] = _T("{CALL spDeleteChar (%d, %d, '%s')}");

//@AID		int
TCHAR g_szDB_GET_CHARLIST[] = _T("{CALL spGetCharList (%d)}");

//@CID		int,
//@Name		varchar(24),
//@Level	smallint,
//@XP		int,
//@BP		int
TCHAR g_szDB_SIMPLE_UPDATE_CHARINFO[] = _T("{CALL spSimpleUpdateChar (%d, '%s', %d, %d, %d)}");

//@AID int,
//@IPPart1 tinyint,  
//@IPPart2 tinyint,  
//@IPPart3 tinyint,  
//@IPPart4 tinyint,  
//@CountryCode3 char(3)  
TCHAR g_szDB_INSERT_CONN_LOG[] = _T("{CALL spInsertConnLog (%d, %d, %d, %d, %d, '%s')}");

//@MasterCID      INT,
//@MapName      VARCHAR(32),
//@GameType     VARCHAR(24)
TCHAR g_szDB_INSERT_GAME_LOG[] = _T("{CALL spInsertGameLog (%d, '%s', '%s')}");

//@GameLogID    INT,
//@CID          INT,
//@PlayTime     INT,
//@Kills        INT,
//@Deaths       INT,
//@XP           INT,
//@BP           INT
TCHAR g_szDB_INSERT_GAME_PLAYER_LOG[] = _T("{CALL InsertGamePlayerLog(%d, %d, %d, %d, %d, %d, %d)}");

//@AttackerCID	int,
//@VictimCID	int
TCHAR g_szDB_INSERT_KILL_LOG[] = _T("{CALL spInsertKillLog (%d, %d)}");

//@ItemID		int,
//@CID		    int,
//@Bounty		int,
//@CharBounty	int,
//@Type		    varchar(20)
TCHAR g_szDB_INSERT_ITEM_PURCHASE_BY_BOUNTY_LOG[] = _T("{CALL spInsertItemPurchaseLogByBounty (%d, %d, %d, %d, '%s')}");

//@AID		int,
//@CharName	varchar(32),
//@Type		varchar(20)
TCHAR g_szDB_INSERT_CHAR_MAKING_LOG[] = _T("{CALL spInsertCharMakingLog (%d, '%s', '%s')}");

//@ServerID smallint,
//@PlayerCount smallint,
//@GameCount smallint,
//@BlockCount int,
//@NonBlockCount int
TCHAR g_szDB_INSERT_SERVER_LOG[] = _T("{CALL spInsertServerLog (%d, %d, %d, %u, %u)}");

//@CurrPlayer   smallint,
//@ServerID     int
TCHAR g_szDB_UPDATE_SERVER_STATUS[] = _T("{CALL spUpdateServerStatus (%d, %d)}");

//@CID			INT
//@PlayTime		INT,
//@Kills		INT,
//@Deaths		INT,
//@XP			INT,
//@TotalXP		INT,
TCHAR g_szDB_INSERT_PLAYER_LOG[] = _T("{CALL spInsertPlayerLog (%d, %d, %d, %d, %d, %d)}");

//@CID			int,
//@Level		smallint,
//@BP			int,
//@KillCount	int,
//@DeathCount	int,
//@PlayTime		int
TCHAR g_szDB_INSERT_LEVELUP_LOG[] = _T("{CALL spInsertLevelUpLog (%d, %d, %d, %d, %d, %d)}");

//@AID INT
//@CID INT,
//@XP INT,
//@Level INT,
//@TotalPlayTime INT,
//@PlayTime INT,
//@KillCount INT,
//@DeathCount INT,
//@BP INT,
//@IsLevelUp BIT
TCHAR g_szDB_UPDATE_CHAR_PLAYINFO_LOG[] = _T("{CALL spCharUpdatePlayInfo (%d, %d, %d, %d, %d, %d, %d, %d, %d, %d)}");

//@Level        smallint,
//@CID          int
TCHAR g_szDB_UPDATE_CHAR_LEVEL[] = _T("{CALL spUpdateCharLevel (%d, %d)}");

//@BPInc        int,
//@CID          int
TCHAR g_szDB_UPDATE_CHAR_BP[] = _T("{CALL spUpdateCharBP (%d, %d)}");


//@PlayTimeInc    int,
//@CID            int
TCHAR g_szDB_UPDATE_CHAR_PLAYTIME[] = _T("{CALL	spUpdateCharPlayTime (%d, %d)}");

//@IP		varchar(20),
//@UserID	varchar(20)
TCHAR g_szDB_UPDATE_LAST_CONNDATE[] = _T("{CALL	spUpdateLastConnDate ('%s', '%s')}");

//@CID		 int,
//@FriendCID int,
//@Favorite	 tinyint
TCHAR g_szDB_ADD_FRIEND[] = _T("{CALL spAddFriend (%d, %d, %d)}");

//@CID		    int,
//@FriendCID	int
TCHAR g_szDB_REMOVE_FRIEND[] = _T("{CALL spRemoveFriend (%d, %d)}");

//@CID		int
TCHAR g_szDB_GET_FRIEND_LIST[] = _T("{CALL spGetFriendList (%d)}");

//@CID		int
TCHAR g_szDB_GET_CHAR_CLAN[] = _T("{CALL spGetCharClan (%d)}");

//@ClanName		varchar(24)
TCHAR g_szDB_GET_CLID_FROM_CLANNAME[] = _T("{CALL spGetCLIDFromClanName ('%s')}");

//@ClanName		varchar(24),
//@MasterCID		int,
//@Member1CID		int,
//@Member2CID		int,
//@Member3CID		int,
//@Member4CID		int
TCHAR g_szDB_CREATE_CLAN[] = _T("{CALL spCreateClan ('%s', %d, %d, %d, %d, %d)}");

//@CLID		      int,
//@ClanName	      varchar(24),
//@MasterCID	  int,
//@DeleteDate     datetime
TCHAR g_szDB_RESERVE_CLOSE_CLAN[] = _T("{CALL spReserveCloseClan (%d, '%s', %d, '%s')}");

//@CLID		int,
//@CID		int,
//@Grade	tinyint
TCHAR g_szDB_ADD_CLAN_MEMBER[] = _T("{CALL spAddClanMember (%d, %d, %d)}");

//@CLID		int,
//@CID		int
TCHAR g_szDB_REMOVE_CLAN_MEMBER[] = _T("{CALL spRemoveClanMember (%d, %d)}");

//@CLID		int,
//@CID		int,
//@NewGrade	tinyint
TCHAR g_szDB_UPDATE_CLAN_GRADE[] = _T("{CALL spUpdateClanGrade (%d, %d, %d)}");

//@CLID				    int,
//@AdminGrade			int,
//@MemberCharName		varchar(36)
TCHAR g_szDB_EXPEL_CLAN_MEMBER[] = _T("{CALL spRemoveClanMemberFromCharName (%d, %d, '%s')}");

//@CLID			int
TCHAR g_szDB_GET_CLAN_INFO[] = _T("{CALL spGetClanInfo (%d)}");

//@MEMBERCID0		int,
//@MEMBERCID1		int,
//@MEMBERCID2		int,
//@MEMBERCID3		int
TCHAR g_szDB_GET_LADDER_TEAM4_ID[] = _T("{CALL spGetTeamID4 (%d, %d, %d, %d)}");

//@WinnerTID		int, 
//@LoserTID		    int, 
//@DrawGame		    int, 
//@WinnerPoint		int, 
//@LoserPoint		int, 
//@DrawPoint		int
TCHAR g_szDB_TEAM4_WIN_THE_GAME[] = _T("{CALL spTeam4WinTheGame (%d, %d, %d, %d, %d, %d)}");

//@CID		int
TCHAR g_szDB_GET_LADDER_TEAM_MEMBERLIST[] = _T("{CALL spGetLadderTeamMemberByCID (%d)}");

//@WinnerCLID  int,  
//@LoserCLID  int,  
//@IsDrawGame  tinyint,  
//@WinnerPoint  int,  
//@LoserPoint  int,  
//@WinnerClanName  varchar(24),  
//@LoserClanName  varchar(24),  
//@RoundWins  tinyint,  
//@RoundLosses  tinyint,  
//@MapID   tinyint,  
//@GameType  tinyint,  
//@WinnerMembers  varchar(110),  
//@LoserMembers  varchar(110)  
TCHAR g_szDB_WIN_THE_CLAN_GAME[] = _T("{CALL spWinTheClanGame (%d, %d, %d, %d, %d, '%s', '%s', %d, %d, %d, %d, '%s', '%s')}");

//@CID		int,
//@CLID		int,
//@AddedContPoint	int
TCHAR g_szDB_UPDATE_CHAR_CLAN_CONTPOINT[] = _T("{CALL spUpdateCharClanContPoint (%d, %d, %d)}");

//@UGradeID int,
//@AID int
TCHAR g_szDB_EVENT_JJANG_UPDATE[] = _T("UPDATE Account SET UGradeID=%d WHERE AID=%d");

//@CID	int
TCHAR g_szDB_SELECT_QUEST_ITEM_INFO_BY_CID[] = _T( "{CALL spSelectCharQuestItemInfoByCID (%d)}" );

//@GameName varchar(64)
//@Master int 
//@Player1 int 
//@Player2 int
//@Player3 int
//@TotalQItemCount smallint 
//@ScenarioID smallint 
//@GamePlayTime tinyint 
TCHAR g_szDB_INSERT_QUEST_GAME_LOG[] = _T( "{CALL spInsertQuestGameLog ('%s', %d, %d, %d, %d, %d, %d, %d)}" );

//@QGLID int
//@CID int
//@QIID int
TCHAR g_szDB_INSERT_QUINQUEITEMLOG[] = _T( "{CALL spInsertQUniqueItemLog (%d, %d, %d)}" );

//@IP		int
TCHAR g_szDB_CHECK_PREMIUM_IP[] = _T( "{CALL spCheckPremiumIP ('%s')}" );

//@AID int,
//@CID int,
//@EventName varchar(24)
TCHAR g_szInsertEvent [] = _T( "{CALL spInsertEvent (%u, %u, '%s')}" );

//@AID		             int,
//@CID			         int,
//@HackingType   	     tinyint,
//@IPPart1		         tinyint,
//@IPPart2	             tinyint,
//@IPPart3	             tinyint,
//@IPPart4 		         tinyint,
//@EndHackingBlockDate	 smalldatetime,
//@ServerID		         tinyint,
//@ChannelName	         varchar(64),
//@Comment		         varchar(128),
//@HackingLevel		     tinyint
TCHAR g_szSetHackingBlock[] = _T( "{CALL spSetHackingBlock (%u, %u, %u, %u, %u, %u, %u, '%s', %u, '%s', '%s', %u)}" );

//@AID int,
//@BlockType tinyint
TCHAR g_szResetAccountHackingBlock[] = _T( "{CALL spResetAccountHackingBlock (%u, %u)}" );

// @AID int
// @CID int
// @BlockType tinyint
// @Comment varchar(256)
// @IP varchar(15)
// TCHAR g_szInsertBlockLog[] = _T( "{CALL spInsertBlockLog (%u, %u, %u,'%s', '%s')}" );

//@CID int,
//@CLID int,
//@DeleteDate smalldatetime
TCHAR g_szSetClanDeleteDate[] = _T( "{CALL spSetClanDeleteDate (%u, %u, '%s')}" );

//@CLID int
//@MasterCID int
//@DeleteName varchar(24)
//@WaitHour int = 168
TCHAR g_szDeleteExpiredClan[] = _T( "{CALL spDeleteExpiredClan (%u, %u, '%s', %u)}" );

//Nothing sended.
TCHAR g_szAdminResetAllHackingBlock[] = _T( "{CALL spResetHackingBlock}" );

//@AID int
TCHAR g_szUpdateAccountLastLogoutTime[] = _T( "{CALL spUpdateAccountLastLogoutTime (%u)}" );

//@Name varchar(24)
TCHAR g_szCheckDuplicateCharName[] = _T( "{CALL spCheckDuplicateCharName ('%s')}" );

//@Name varchar(24)
TCHAR g_szGetCIDbyCharName[] = _T( "{CALL spGetCIDbyCharName ('%s')}" );

//@CID int
TCHAR g_szGetCharNameByCID[] = _T( "{CALL spGetCharNameByCID ('%u')}" );

//Nothing sended.
TCHAR g_szGetDBConnection[] = _T( "{CALL spGetDBConnection}" );

//Nothing sended.
TCHAR g_spGetGambleItemList[] = _T( "{CALL spGetGambleItemList}" );

//Nothing sended.
TCHAR g_spGetGambleRewardItem[] = _T( "{CALL spGetGambleRewardItem}" );

//@AID int
//@IsHacker tinyint
TCHAR g_spUpdateAccountPowerLevelingInfo[] = _T( "{CALL spUpdateAccountPowerLevelingInfo(%u, %u)}" );

//@strGameName		VARCHAR(64),
//@nSID				TINYINT,
//@nTotalRound		SMALLINT,
//@nMasterPlayerCID	INT,
//@nGainRP1			INT,
//@nPlayer2CID		INT,
//@nGainRP2			INT,
//@nPlayer3CID		INT,
//@nGainRP3			INT,
//@nPlayer4CID		INT,
//@nGainRP4			INT,
//@nGamePlayTime	TINYINT
TCHAR g_spInsertSurvivalModeGameLog[] = _T( "{CALL spInsertSurvivalGameLog('%s', %u, %u, %u, %u, %u, %u, %u, %u, %u, %u, %u)}" );

//Nothing sended.
TCHAR g_spGetSurvivalGroupRanking[] = _T( "{CALL spGetSurvivalGroupRanking}" );

//@nCID int
TCHAR g_spGetSurvivalPrivateRanking[] = _T( "{CALL spGetSurvivalPrivateRanking(%u)}" );

//Nothing sended.
TCHAR g_spGetDTTimeStamp[] = _T( "{CALL spDTGetDTTimeStamp}" );

//@CID	INT
TCHAR g_spGetDTSideRankingInfo[] = _T( "{CALL spDTGetDTSideRanking(%u)}" );

//Nothing sended.
TCHAR g_spGetDTGroupRankingInfo[] = _T( "{CALL spDTGetDTGroupRanking}" );

//@CID INT 
TCHAR g_spInsertDTCharacterInfo[] = _T( "{CALL spDTInsertDTCharacterInfo(%u)}" );

//@CID INT
TCHAR g_spGetDTCharacterInfo[] = _T( "{CALL spDTGetDTCharacterInfo(%u)}" );

//@CID INT
TCHAR g_spGetDTCharacterInfoPrevious[] = _T( "{CALL spDTGetDTCharacterInfoPrevious(%u)}" );

//@CID			INT,
//@TimeStamp		CHAR(8),
//@TP			INT,
//@Wins			INT,
//@Loses			INT,
//@FGames			INT,
//@FWins			INT,
//@SFGames		INT,
//@SFWins			INT,
//@QFGames		INT,
//@QFWins			INT,
//@LeaveCount		INT
TCHAR g_spUpdateDTCharacterInfo[] = _T( "{CALL spDTUpdateDTCharacterInfo(%d, '%s', %d, %d, %d, %d, %d, %d, %d, %d, %d, %d)}" );

//@TournamentType TINYINT, 
//@MatchFactor TINYINT,
//@Player1 INT,	
//@Player2 INT,
//@Player3 INT,	
//@Player4 INT,	
//@Player5 INT,	
//@Player6 INT,	
//@Player7 INT,	
//@Player8 INT
TCHAR g_spInsertDTGameLog[] = _T( "{CALL spDTInsertDTGameLog(%u, %d, %d, %d, %d, %d, %d, %d, %d, %d)}" );

//@TimeStamp	CHAR(8),
//@LogID		INT,	
//@ChampCID	INT	
TCHAR g_spUpdateDTGameLog[] = _T( "{CALL spDTUpdateDTGameLog('%s', %d, %d)}" );

//@LogID		INT,
//@TimeStamp	CHAR(8),
//@MatchType	TINYINT,
//@PlayTime	INT,
//@WinnerCID	INT,
//@GainTP		INT,
//@LoserCID	INT,
//@LoseTP		INT
TCHAR g_spInsertDTGameLogDetail[] = _T( "{CALL spDTInsertDTGameLogDetail(%d, '%s', %d, %d, %d, %d, %d, %d)}" );

//@AID			INT
TCHAR g_spGetAccountPenaltyInfo[] = _T( "{CALL spGetAccountPenaltyInfo(%d)}" );

//@AID			INT,	
//@PCode		TINYINT,
//@PHour		INT,
//@GM_ID		VARCHAR(24)
TCHAR g_spInsertAccountPenaltyInfo[] = _T( "{CALL spInsertAccountPenaltyInfo(%d, %d, %d, '%s')}" );

//Nothing sended.
TCHAR g_szDB_GET_ALLITEM[] = _T("{CALL spGetAllItem}");

//@ServerID		INT,
//@ServerName		VARCHAR(24),
//@MaxPlayer		INT	
TCHAR g_szDB_UPDATE_SERVER_INFO[] = _T("{CALL spUpdateServerInfo (%d, '%s', %d)}");

//@AID		INT, 
//@CharNum	SMALLINT
TCHAR g_szDB_GET_ACCOUNT_CHARINFO[] = _T("{CALL spGetAccountCharInfo (%d, %d)}");

//@AID		INT,
//@CharNum	SMALLINT,
//@Name		VARCHAR(24),
//@Sex		TINYINT,
//@Hair		INT,
//@Face		INT,
//@Costume	INT
TCHAR g_szDB_CREATE_CHAR[] = _T("{CALL spInsertChar (%d, %d, '%s', %d, %d, %d, %d)}");

//@AID		INT,
//@CharNum	SMALLINT
TCHAR g_szDB_GET_CHARINFO_BY_AID[] = _T("{CALL spGetCharInfoByCharNum (%d, %d)}");

//@AID		INT, 
//@CharNum	SMALLINT
TCHAR g_szDB_GET_CHAR_EQUIPMENT_INFO_BY_AID[] = _T("{CALL spGetCharEquipmentInfoByAID (%d, %d)}");

//@CID			INT,
//@XPInc		INT,
//@BPInc		INT,
//@KillInc		INT,  
//@DeathInc		INT,
//@PlayTimeInc	INT
TCHAR g_szDB_UPDATE_CHAR_INFO_DATA[] = _T("{CALL spUpdateCharInfoData (%d, %d, %d, %d, %d, %d)}");

//@CID		    INT,
//@SlotID		INT,
//@CIID		    INT,
//@ItemID		INT
TCHAR g_szDB_UPDATE_EQUIPITEM[] = _T("{CALL spUpdateEquipItem (%d, %d, %d, %d)}");

//@CID  INT
TCHAR g_szDB_CLEARALL_EQUIPEDITEM[] = _T("{CALL spClearAllEquipedItem (%d)}");

//@CID  INT  
TCHAR g_szDB_SELECT_CHAR_ITEM[] = _T("{CALL spSelectCharItem (%d)}");						

//@CID	INT,
//@CIID	INT
TCHAR g_szDB_DELETE_EXPIRED_CHARACTER_ITEM[]	= _T("{CALL spDeleteExpiredCharacterItem (%d, %d)}");		

//@CIID		INT,
//@SpendCount	INT
TCHAR g_szDB_UPDATE_CHAR_SPEND_ITEM_COUNT[]	= _T("{CALL spUpdateCharItemSpendCount (%d, %d)}");

//@CID				INT,
//@CIID				INT,
//@GIID				INT,
//@GRIID			INT,
//@RewardItemID			INT,
//@RentHourPeriod		INT
TCHAR g_spChangeGambleItemToRewardNormalItem[] = _T( "{CALL spChangeGambleItemToRewardNormalItem (%u, %u, %u, %u, %u, %u)}" );

//@CID				INT
//@CIID				INT,
//@GIID				INT,
//@GRIID			INT,
//@RewardItemID		INT,
//@GambleItemCount	INT,
TCHAR g_spChangeGambleItemToRewardSpendableItem[] = _T( "{CALL spChangeGambleItemToRewardSpendableItem (%u, %u, %u, %u, %u, %u)}" );

//@CIID			INT,
//@GIID			INT,
//@GambleCount	INT
TCHAR g_szDB_UPDATE_CHAR_GAMBLE_ITEM_DECREASE[]	= _T("{CALL spUpdateCharGambleItemCount(%d, %d, %d)}");

//@CID			INT,  
//@ItemID		INT,
//@RentHourPeriod SMALLINT
TCHAR g_szDB_INSERT_DISTRIBUTE_ITEM[] = _T("{CALL spInsertDistributeItem(%d, %d, %d)}");			

//@CID				            INT,  
//@ItemID				        INT,
//@ItemCount		         	INT,
//@Price				        INT,
//@IsSpendableItem	            INT,
//@RentHourPeriod		        INT = NULL
TCHAR g_szDB_BUY_BOUNTY_ITEM[] = _T("{CALL spBuyBountyItem (%d, %d, %d, %d, %d, %d)}"); 

//@CID		INT,  
//@CIID		INT,
//@ItemID	INT,
//@Price	INT,  
//@CharBP	INT  
TCHAR g_szDB_SELL_ITEM_TO_BOUNTY[]	= _T("{CALL spSellItemToBounty (%d, %d, %d, %d, %d)}");

//@CID		    INT,  
//@CIID		    INT,
//@ItemID		INT,
//@ItemCnt	    INT,	
//@Price		INT,
//@CharBP		INT
TCHAR g_szDB_SELL_SPENDABLEITEM_TO_BOUNTY[]	= _T("{CALL spSellSpendableItemToBounty (%d, %d, %d, %d, %d, %d)}");

TCHAR g_szDB_SELL_CASH_ITEM_TO_BOUNTY[]	= _T("{CALL spSellCashItemToBounty (%d, %d, %d, %d, %d, %d)}");		
// Desc : »óÁ¡¿¡¼­ ij½¬ ¾ÆÀÌÅÛ ÆǸÅ
// Param :	@CID		INT
//			@CIID		INT
//			@ItemID		INT
//			@ItemCnt	INT
//			@Price		INT
//			@CharBP		INT

//Nothing sended.
TCHAR g_szDB_GET_BATTLE_TIME_REWARD_LIST[] = _T("{CALL spGetBattleTimeRewardDescription}");

//Nothing sended.
TCHAR g_szDB_GET_BATTLE_TIME_REWARD_ITEM_LIST[] = _T("{CALL spGetBattleTimeRewardItemList}");

//@CID        INT
TCHAR g_szDB_GET_CHAR_BR_INFO_ALL[] = _T("{CALL spGetCharBRInfoAll (%d)}");

//@CID      INT,
//@BRID     INT
TCHAR g_szDB_GET_CHAR_BR_INFO[] = _T("{CALL spGetCharBRInfo (%d, %d)}");

//@CID      INT,
//@BRID     INT,
//@BRTID    INT
TCHAR g_szDB_INSERT_CHAR_BR_INFO[] = _T("{CALL spInsertCharBRInfo (%d, %d, %d)}");

//@CID          INT,
//@BRID         INT,
//@BRTID        INT,
//@RewardCount  INT,
//@BattleTime   INT,
//@KillCount    INT
TCHAR g_szDB_UPDATE_CHAR_BR_INFO[] = _T("{CALL spUpdateCharBRInfo (%d, %d, %d, %d, %d, %d)}");

//@CID                  INT
//@BRID                 INT,
//@BRTID                INT,
//@BattleTime           INT,
//@KillCount            INT,
//@ItemID               INT,
//@ItemCnt              INT,
//@RentHourPeriod       INT,
//@IsSpendableItem      INT,
TCHAR g_szDB_GET_REWARD_CHAR_BR[] = _T("{CALL spRewardCharBattleTimeReward (%d, %d, %d, %d, %d, %d, %d, %d, %d)}");

Current missing procedure (Emisand DB):
Code: 
/****** Object:  StoredProcedure [dbo].[spDeleteExpiredClan]    Script Date: 11/26/2011 20:04:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- ÆÀ¸â¹ö ¾ò¾î¿À±â
CREATE PROC [dbo].[spDeleteExpiredClan]
	@CLID int,
	@MasterCID int,
	@DeleteName varchar(24),
	@WaitHour int = 168
AS
{CALL spDeleteExpiredClan (%u, %u, '%s', %u)}
RETURN
GO


/****** Object:  StoredProcedure [dbo].[spSetClanDeleteDate]    Script Date: 11/26/2011 20:04:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- ÆÀ¸â¹ö ¾ò¾î¿À±â
CREATE PROC [dbo].[spSetClanDeleteDate]
	@CID int,
	@CLID int,
	@DeleteDate smalldatetime
AS
/*{CALL spSetClanDeleteDate (%u, %u, '%s')}*/
RETURN
GO


/****** Object:  StoredProcedure [dbo].[spResetHackingBlock]    Script Date: 11/26/2011 20:04:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- ÆÀ¸â¹ö ¾ò¾î¿À±â
CREATE PROC [dbo].[spResetHackingBlock]
AS
/*{CALL spResetHackingBlock}*/
RETURN
GO


/****** Object:  StoredProcedure [dbo].[spSetHackingBlock]    Script Date: 11/26/2011 20:04:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- ÆÀ¸â¹ö ¾ò¾î¿À±â
CREATE PROC [dbo].[spSetHackingBlock]
	@AID			int,
	@CID			int,
	@HackingType   	        tinyint,
	@IPPart1		tinyint,
	@IPPart2		tinyint,
	@IPPart3	        tinyint,
	@IPPart4 		tinyint,
	@EndHackingBlockDate	smalldatetime,
	@ServerID		tinyint,
	@ChannelName		varchar(64),
	@Comment		varchar(128),
	@HackingLevel		tinyint
AS
/*{CALL spSetHackingBlock (%u, %u, %u, %u, %u, %u, %u, '%s', %u, '%s', '%s', %u)}*/
RETURN
GO


/****** Object:  StoredProcedure [dbo].[spTeam4WinTheGame]    Script Date: 11/26/2011 20:04:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- ÆÀ¸â¹ö ¾ò¾î¿À±â
CREATE PROC [dbo].[spTeam4WinTheGame]
	@WinnerTID		int, 
	@LoserTID		int, 
	@DrawGame		int, 
	@WinnerPoint		int, 
	@LoserPoint		int, 
	@DrawPoint		int
AS
/*{CALL spTeam4WinTheGame (%d, %d, %d, %d, %d, %d)}*/
RETURN
GO


/****** Object:  StoredProcedure [dbo].[spGetTeamID4]    Script Date: 11/26/2011 20:04:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- ÆÀ¸â¹ö ¾ò¾î¿À±â
CREATE PROC [dbo].[spGetTeamID4]
	@MEMBERCID0		int,
	@MEMBERCID1		int,
	@MEMBERCID2		int,
	@MEMBERCID3		int
AS
/*{CALL spGetTeamID4 (%d, %d, %d, %d)}*/
RETURN
GO


/****** Object:  StoredProcedure [dbo].[spGetLadderTeamMemberByCID]    Script Date: 11/26/2011 20:04:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- ÆÀ¸â¹ö ¾ò¾î¿À±â
CREATE PROC [dbo].[spGetLadderTeamMemberByCID]
	@CID		int
AS
/*{CALL spGetLadderTeamMemberByCID (%d)}*/
RETURN
GO


/****** Object:  StoredProcedure [dbo].[spCheckPremiumIP]    Script Date: 11/26/2011 20:04:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- ÆÀ¸â¹ö ¾ò¾î¿À±â
CREATE PROC [dbo].[spCheckPremiumIP]
	@IP		int
AS
/*{CALL spCheckPremiumIP ('%s')}*/
RETURN
GO

/****** Object:  StoredProcedure [dbo].[spReserveCloseClan]    Script Date: 11/26/2011 20:04:23 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- Ŭ·£ Æó¼â ¿¹¾àÇϱâ
CREATE PROC [dbo].[spReserveCloseClan]
	@CLID		int,
	@ClanName	varchar(24),
	@MasterCID	int,
        @DeleteDate     datetime
AS
	SET NOCOUNT ON
	UPDATE Clan SET DeleteFlag=2 WHERE CLID=@CLID AND Name=@ClanName AND MasterCID=@MasterCID
GO

Have fun editing your system procedure to your need.
NOTE: I've posted that for all those who are making thread about their GunZDB problem's.
 
Chrisss said:
Hey hideasu, thanks.

Can you also release your fix for the right click sniper glitch, nobody has foxed but if they have they wont release.
Thanks
Click to expand...

unsigned long g_dwLastSniperUpdate = 0;

void ZMyCharacter::OnGadget_Snifer()
{
unsigned long dwTime = timeGetTime();

if (g_dwLastSniperUpdate == 0 || g_dwLastSniperUpdate <= (dwTime - 200))
{
ZMyCharaterStatusBitPacking & zStatus = m_statusFlags.Ref();

zStatus.m_bSniferMode = !zStatus.m_bSniferMode;

ZCombatInterface* ci=ZGetCombatInterface();

if (ci)
{
if (zStatus.m_bSniferMode)
{
ci->OnGadget(MWT_SNIFER);
}
else
{
ci->OnGadgetOff();
}
}

g_dwLastSniperUpdate = dwTime;
}
}
Click to expand...
.........
 
Status
Not open for further replies.

RaGEZONE Sponsor

    HyperFilter

About RaGEZONE

RaGEZONE® is a leading MMO and MMORPG development community offering source codes, server files, tutorials, tools, and private servers for developers and gamers.

Forum Statistics

Members online
1,861
Guests online
31,726
Total visitors
33,587
Totals may include hidden visitors.

RaGEZONE Partners

    non GamStop casinos
Back