Open "Query Analyzer" and insert this script in MuOnline:
alter table memb_info add SCFWareVipCount int Not NULL default 0
After this add this script in MuOnline:
__________________________________________________________________________________________
CREATE TABLE [dbo].[ExtendedWarehouse] (
[AccountID] [varchar] (10) NOT NULL ,
[Items] [varbinary] (1920) NULL ,
[Money] [int] NULL ,
[EndUseDate] [smalldatetime] NULL ,
[DbVersion] [tinyint] NULL ,
[pw] [smallint] NULL ,
[SCFExtWare] [int] NULL ,
) ON [PRIMARY]
GO
After this add this other script in MuOnline:
__________________________________________________________________________________________
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[BotPet]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[BotPet]
GO
CREATE TABLE [dbo].[BotPet] (
[AccountID] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[Name] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[cLevel] [int] NOT NULL ,
[Class] [tinyint] NULL ,
[Experience] [bigint] NULL ,
[Power] [smallint] NULL ,
[Defense] [smallint] NULL ,
[Inventory] [varbinary] (1728) NULL ,
[MagicList] [varbinary] (180) NULL ,
[Life] [real] NOT NULL ,
[MaxLife] [real] NOT NULL ,
[Mana] [real] NOT NULL ,
[MaxMana] [real] NOT NULL ,
[MapNumber] [smallint] NULL ,
[MapPosX] [smallint] NULL ,
[MapPosY] [smallint] NULL ,
[CDate] [smalldatetime] NULL ,
[BotLife] [int] NOT NULL ,
[BotMaxLife] [int] NOT NULL ,
[BotLvlUpDefense] [int] NOT NULL ,
[BotLvlUpPower] [int] NOT NULL ,
[BotLvlUpLife] [int] NOT NULL ,
[BotLvlUpMana] [int] NOT NULL ,
[BotLvlUpExp] [int] NOT NULL ,
[BotLvlUpMaxLevel] [int] NOT NULL
) ON [PRIMARY]
GO
New Commands:
/ware 1 (1 - new Warehouse, 0 - Default )
BotPet Commands:
__________________________________________________________________________________________
/botpet create index Name
/botpet followme
/botpet freeze
/botpet stats
/botpet skill NUM
/botpet life
/botpet mana
/botpet cry
/botpet hi
/botpet cheer
/botpet sir
/botpet bye
/botpet respect
/botpet comeon
/botpet win
/botpet hehe
/botpet dance
/vipset Nuber
__________________________________________________________________________________________
IP Changes:
ConnectServer/Data/BoR_ServerList.dat
Data/MapServerInfo.dat
Data/IpList.dat
Data/lang/kor/commonloc.cfg
SQL Password Changes:
EventServer\DATA\svconfig.ini
ExDB\ExDB.ini
RankingServer\svconfig.ini
SCFExDB\Config.ini
SCFInstaller\SCFQueryInstaller.ini
How to start server:
Your databases has latest updates so you don't need the sql scripts to insert!
You will start the server from folder "Start Server"
Enjoy !