Exordium Flyff Source.

#define __SWITCH_FIX
#define		__VER 17
#define		__JOPS_GLOW
#define		__DEATH_MATCH
#define		__ARENA_SCORE
#define		__PMA_AUCTIONHOUSE




#define __DEBUG_SALT
#define		__WEAPON_LEVELING
#if __VER >= 16
#define __GUILD_COLOR
#define __NEW_PROP_PARAMETER 
#define __3RD_LEGEND16 
#define __CROSSBOW	
#define __NO_AFTER_SKIN 
#define __NO_SUB_LANG 
#define __IMPROVE_MAP_SYSTEM 
#define __NEW_SKILL_TREE 
#define __LOADING_SCREEN_UPDATE
#define __ITEM_LINK




#ifdef __NEW_PROP_PARAMETER
//#define __NEW_ITEM_VARUNA
#define __NEW_STACKABLE_AMPS
#define __UPGRADE_SUCCESS_SCROLL
//#define __TELEPORT_SCROLL
#endif // __NEW_PROP_PARAMETER




//	#define		__BS_EFFECT_LUA		
#endif // __VER >= 16




#if __VER >= 17
#define	__FASHION_COMBINE
#define __NEW_WEAPON_GLOW
//#define __TABBED_INVENTORY
//#define __BARUNA_PIERCING
#define __COLOSSEUM
//#define __BAHARA_AGGRO_SYSTEM
#endif // __VER >= 17




/******************** EXORDIUM NEW SYSTEMS ********************/
#define __PETFILTER
#define __QUICKJOBCHANGE
//#define __TRANSFER_AWAKE
//#define __Jandy
#define	__PMA_GW
#define     __BARUNA_16
#define __PMA_WING                                                        
#define __TELEPORT_SYSTEM     
#define __TORCHE_SYSTEM
#define __AWAKE_TRANSFER




#define __PERIN_CONVERTER
#define __COUNTRY_ICON








/******************** EXORDIUM NEW SYSTEMS ********************/




#define	__SECURITY_FIXES
#define __INVISIBLE_FIX

/****** Object:  Table [dbo].[tblAuction]    Script Date: 11/03/2012 14:31:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[tblAuction](
    [dwId] [char](7) NOT NULL,
    [idPlayer] [char](7) NOT NULL,
    [nItemNum] [int] NOT NULL,
    [szItem] [varchar](1024) NOT NULL,
    [nPriceCash] [int] NULL,
    [nPricePerin] [int] NULL,
    [nPricePenya] [int] NULL,
    [szTimeEnd] [char](15) NOT NULL,
    [bDirectBuy] [int] NULL,
    [idOffer] [char](7) NULL,
    [szDesc] [varchar](128) NULL,
    [bExtend] [int] NULL,
    [bMail] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO

USE [CHARACTER_01_DBF]
GO
/****** Object:  StoredProcedure [dbo].[uspSaveAuction]    Script Date: 11/03/2012 14:29:25 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO




ALTER proc [dbo].[uspSaveAuction]
@dwId        CHAR(7),
@szItem        VARCHAR(1024)   = '$',
@nItemNum      int,
@idPlayer        CHAR(7),
@nPriceCash      int,
@nPricePerin     int,
@nPricePenya      int,
@szTimeEnd        CHAR(15),
@bDirectBuy        int,
@bExtend        int,
@bMail        int,
@idOffer        CHAR(7),
@szDesc        VARCHAR(128)   = '$'
AS
set nocount on


    BEGIN
        IF EXISTS ( SELECT * FROM tblAuction WHERE idPlayer=@idPlayer AND dwId=@dwId )
         BEGIN
            
                UPDATE  tblAuction
                SET        
                        dwId  = @dwId,
                        szItem = @szItem,
                        nItemNum = @nItemNum,
                        idPlayer = @idPlayer,
                        nPriceCash         = @nPriceCash,
                        nPricePerin         = @nPricePerin,
                        nPricePenya      = @nPricePenya,
                        szTimeEnd         = @szTimeEnd,
                        bDirectBuy         = @bDirectBuy,
                        bExtend         = @bExtend,
                        bMail         = @bMail,
                        idOffer         = @idOffer,
                        szDesc            = @szDesc
                WHERE   idPlayer = @idPlayer AND dwId = @dwId
                RETURN
        END
        ELSE BEGIN
        
                IF EXISTS (SELECT * FROM tblAuction )
                        SELECT @dwId = RIGHT('0000000' + CONVERT(VARCHAR(7),MAX(dwId)+1),7)
                        FROM tblAuction
                 ELSE BEGIN
                        
                        SELECT @dwId = '0000001'
                 END


                INSERT INTO  tblAuction(dwId, szItem,nItemNum,idPlayer,nPriceCash,nPricePerin,nPricePenya,szTimeEnd,bDirectBuy,bExtend,bMail,idOffer,szDesc)
                 VALUES(@dwId,@szItem, @nItemNum, @idPlayer, @nPriceCash, @nPricePerin, @nPricePenya, @szTimeEnd, @bDirectBuy,@bExtend,@bMail, @idOffer, @szDesc )
                 
                 SELECT dwId FROM tblAuction WHERE dwId = @dwId
                 RETURN
                        
         END
    END