Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Mpt - sql.dll - odbc

Initiate Mage
Joined
Jun 17, 2009
Messages
33
Reaction score
1
Hello People..

I have a little Problem

If i using the SQL.dll(Gregoos DLL creator) without ODBC so i get Connection lost to Server

If i using ODBC with sa and pw (SQL Server Authentifizierung) it will come Unable to connect


and if i using ODBC with NT-Authentifizierung i can connect to Server with the Admin.exe

But without SQL.dll i dont know .. can run the clan system files from sandurr 2.0?

Well i configurated all

IIS
Server.exe - Changed to or Clan/
In the Hotuk.ini iused

*Clan_SERVER 55.55.55.55 80 55.55.55.55 80
*ENABLE_CLAN 55.55.55.55 80 55.55.55.55 80 //55.55.55.55 <- Extern IP

I dont know what the problem here :/ still says in clan error 58

i have installed SQL Server 2005 - Windows 2008 32bit
Microsoft Visual 2008

Another think... there is no anyway to change the IP on Pstale.exe ? i got started that think.. but it says unable to connect :(

If anyone from MPT like come back to make he own server online .. i will add u to the Project.. so we make them online if u guys from MPT like =)


thanks for help

greets Flaya:thumbup:
 
Last edited:
Junior Spellweaver
Joined
Mar 10, 2009
Messages
194
Reaction score
2
here's the possible solution: do you use an other database users then sa? if so there is your problem, I had this also till i found out.
 
Joined
Jul 24, 2006
Messages
881
Reaction score
579
ODBC - Needs to connect via NT Authorisation with accountDB set as master table
SQL.DLL - Connects via sql login info, BUT you can ONLY log in game with the default admin password you set in the hotuk.ini, normal password you set for the account will not work in the server (Don't ask me why, I have no idea)

So best bet just do not use sql.dll, just use odbc, but you can still use clan.dll and the clanprodecure.dll with teh normal sql login info.

As for the clan files on the site, yes sandurrs clan files will work (But as SheenBR has said, they are vulnerable to attack).
You have to enable asp.net on ur iis
Google how to do this.

To check if asp.net is working on ur iis, browse to your clan insert file ( ) if you do not get error=100 you have not correctly enabled asp.

Also setting up the clan in your hotuk for yourself is a bit weird.
If you are behind a router you have to use local lan IP, wan IP will not work.
You can only use your WAN ip if your modem is directly connected to your computer, so you are not apart of a home network.
 
Initiate Mage
Joined
Jun 17, 2009
Messages
33
Reaction score
1
Okay thanks :) i will check it.. i use a root server.. there no router ^^ but thanks ^^
 
Custom Title Activated
Member
Joined
May 26, 2007
Messages
5,545
Reaction score
1,314
You should not be able to do Clan without SQL.dll, because it is only that which knows about SoD and Bless scores and clans, IMS. I have no login problems with SQL.dll, or ODBC, but always have problems setting up Clans, Bless and SoD.

SQL.dll requires the 32-bit OS, or modifying for WoW6432 VM on an x64 machine.

IIS always has ASP enabled (not necessarily for all folders, but it's enabled) what it doesn't necessarily have set up is ASP.net. (or php etc.) So, vbscript, jscript and anything else that the Windows Script Host can process should work out of the box, but dotNet framework scripting may not AFAIK.

ODBC is (supposedly) depreciated, (both in Windows and the PT server) and should not be enabled at all. The "sa" account should also be disabled, but some "clanadmin" type account should be set up with admin rights over appropriate tables. However, get it to work first, then worry about security. ^_^
 
Initiate Mage
Joined
Jun 17, 2009
Messages
33
Reaction score
1
Hey Hey i got them Work. with Sandurs files ...

i changed the DB Clandb to ClanDB and finish :D
 
Custom Title Activated
Member
Joined
Jan 28, 2009
Messages
1,320
Reaction score
616
I thought that MS SQL does not distinguished upper and lower case. Even My SQL does not on windows os.
 
Custom Title Activated
Member
Joined
May 26, 2007
Messages
5,545
Reaction score
1,314
The "original" script file was ClanDb! :eek:

However, re-reading Sandurrs original readme from CSM2
Code:
'---------------------------------------------------------
'Register Page, Clan system, Clan Management & SOD Ranking
'Original written by Sandurr Version 2.0 
'© Sandurr November, 2006
'
'
'No more Error 9 & 11 & 54 :D
---------------------------------------------------------
**********************************************************
 INSTALLATION GUIDE
**********************************************************
- Copy all files and folders in "Clan & Website" folder to your "wwwroot"
- Copy SQL.dll and Clan.dll to your <server root> folder
- Edit correct Username, Password and SQL Host in the following files:
       SQL.dll Reg.reg
       Clan\clanInsert.aspx
       ServerMain\settings.asp
       ServerMain\SODsettings.asp
       functions\database.asp
- Merge SQL.dll Reg.reg
- Delete your old [COLOR="#FF0000"]ClanDB[/COLOR], GameLogDB, ItemLogDB, SoD2DB and create all new
database ( ClanDB, GameLogDB, ItemLogDB, SoD2DB, LogDB ) using files in SQL 
Script folder (LevelList is a table in AccountDB)
- Create the virtual maps for Clan, Clancontent & ServerMain in IIS
- Give public access connection Clan, Clancontent & ServerMain in IIS
---------------------------------------------------------
**********************************************************
 Notes:
**********************************************************
- Sometimes you might get error 65 when creating clan but it still works
fine :P
- To update SOD Clan Scores to the database you must run ClanSODManager while
running your server.exe
The script was:-
Code:
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ClanHome]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[ClanHome](
	[IDX] [int] NOT NULL,
	[MIDX] [int] NOT NULL,
	[SelServer] [int] NOT NULL,
	[Intro] [nvarchar](300) NULL,
	[Image] [nvarchar](50) NULL,
	[Skin] [int] NULL,
	[PrivHome] [int] NULL,
	[PrivMem] [int] NULL,
	[PrivBoard] [int] NULL
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ClanMainCharChangeLog]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[ClanMainCharChangeLog](
	[IDX] [int] NOT NULL,
	[UserID] [varchar](50) NULL,
	[BeforeCharName] [varchar](50) NULL,
	[AfterCharName] [varchar](50) NULL,
	[CServer] [int] NULL,
	[RegiDate] [datetime] NULL
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ClanMainDeleted]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[ClanMainDeleted](
	[IDX] [int] NOT NULL,
	[MIDX] [int] NOT NULL,
	[ClanName] [nvarchar](50) NOT NULL,
	[Userid] [nvarchar](50) NULL,
	[ClanZang] [nvarchar](50) NOT NULL,
	[Flag] [int] NOT NULL,
	[MemCnt] [int] NOT NULL,
	[MIConCnt] [int] NOT NULL,
	[RegiDate] [datetime] NOT NULL,
	[LimitDate] [datetime] NOT NULL,
	[DelDate] [datetime] NOT NULL,
	[DelActive] [char](1) NOT NULL,
	[PFlag] [int] NOT NULL,
	[KFlag] [int] NOT NULL,
	[DelState] [char](1) NOT NULL,
	[DelCase] [char](10) NOT NULL,
	[Server] [int] NOT NULL
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ClanMainView]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[ClanMainView](
	[IDX] [int] NOT NULL,
	[ClanName] [nvarchar](50) NOT NULL,
	[Note] [text] NOT NULL,
	[NoteCnt] [int] NOT NULL,
	[UserID] [nvarchar](50) NULL,
	[ClanZang] [nvarchar](50) NOT NULL,
	[Flag] [int] NOT NULL,
	[MemCnt] [int] NOT NULL,
	[MIconCnt] [int] NOT NULL,
	[RegiDate] [datetime] NOT NULL,
	[LimitDate] [datetime] NOT NULL,
	[DelActive] [char](1) NOT NULL,
	[PFlag] [int] NOT NULL,
	[KFlag] [int] NOT NULL,
	[Cpoint] [int] NULL,
	[CWin] [int] NULL,
	[CFail] [int] NULL,
	[ClanMoney] [bigint] NULL,
	[CNFlag] [int] NULL,
	[SiegeMoney] [bigint] NULL,
	[Server] [varchar](1) NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ClanMoneyLog]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[ClanMoneyLog](
	[IDX] [int] NOT NULL,
	[CIDX] [int] NULL,
	[UserID] [varchar](50) NULL,
	[chName] [varchar](50) NULL,
	[ServerName] [varchar](50) NULL,
	[Operator] [varchar](50) NULL,
	[OperCode] [char](10) NULL,
	[ClanMoney] [bigint] NULL,
	[RegistDay] [datetime] NULL,
	[Note] [varchar](50) NULL
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ClanSubCharChangeLog]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[ClanSubCharChangeLog](
	[IDX] [int] NOT NULL,
	[UserID] [varchar](50) NULL,
	[BeforeCharName] [varchar](50) NULL,
	[AfterCharName] [varchar](50) NULL,
	[CServer] [int] NULL,
	[RegiDate] [datetime] NULL
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ClanSubDeleted]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[ClanSubDeleted](
	[IDX] [int] NOT NULL,
	[MIDX] [int] NOT NULL,
	[userid] [nvarchar](50) NOT NULL,
	[ChName] [nvarchar](50) NOT NULL,
	[ChType] [int] NULL,
	[ChLv] [int] NULL,
	[ClanName] [nvarchar](50) NULL,
	[Permi] [char](2) NOT NULL,
	[JoinDate] [datetime] NOT NULL,
	[DelActive] [char](1) NOT NULL,
	[PFlag] [int] NOT NULL,
	[KFlag] [int] NOT NULL,
	[DelDate] [datetime] NOT NULL,
	[DelState] [char](1) NOT NULL,
	[DelCase] [char](10) NULL,
	[Server] [int] NOT NULL
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ClanSubView]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[ClanSubView](
	[IDX] [int] NOT NULL,
	[MIDX] [int] NOT NULL,
	[userid] [nvarchar](50) NOT NULL,
	[ChName] [nvarchar](50) NOT NULL,
	[ChType] [int] NULL,
	[ChLv] [int] NULL,
	[ClanName] [nvarchar](50) NULL,
	[Permi] [char](2) NOT NULL,
	[JoinDate] [datetime] NOT NULL,
	[DelActive] [char](1) NOT NULL,
	[PFlag] [int] NOT NULL,
	[KFlag] [int] NOT NULL,
	[Server] [varchar](1) NOT NULL
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ClanTicket]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[ClanTicket](
	[SNo] [int] NULL,
	[ServerName] [varchar](50) NULL,
	[MIDX] [int] NULL,
	[ClanName] [varchar](50) NULL,
	[ClanJang] [int] NULL,
	[ClanImage] [varchar](50) NULL,
	[UserID] [varchar](25) NULL,
	[ChName] [varchar](50) NULL,
	[GPCode] [varchar](20) NULL,
	[LogonTime] [datetime] NULL,
	[IP] [varchar](20) NULL,
	[RNo] [int] NULL,
	[Flag] [int] NULL
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GameNotice]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[GameNotice](
	[UserID] [varchar](50) NULL,
	[ChName] [varchar](50) NULL,
	[Server] [int] NULL,
	[PFlag] [int] NULL,
	[Txt] [varchar](1000) NULL,
	[Flag] [tinyint] NULL
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GameNoticeGroup]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[GameNoticeGroup](
	[IDX] [int] NOT NULL,
	[GroupCD] [int] NOT NULL,
	[MainCD] [int] NOT NULL,
	[DetailCD] [int] NOT NULL,
	[Title] [varchar](50) NOT NULL,
	[Content] [text] NOT NULL,
	[FromDay] [datetime] NOT NULL,
	[ToDay] [datetime] NOT NULL,
	[RegistDay] [datetime] NOT NULL,
	[DelActive] [int] NOT NULL,
	[Hit] [int] NOT NULL,
	[Flag] [tinyint] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[GameNoticePrivate]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[GameNoticePrivate](
	[IDX] [int] NOT NULL,
	[Userid] [varchar](50) NOT NULL,
	[Title] [varchar](50) NOT NULL,
	[Content] [text] NOT NULL,
	[FromDay] [datetime] NOT NULL,
	[ToDay] [datetime] NOT NULL,
	[RegistDay] [datetime] NOT NULL,
	[DelActive] [int] NOT NULL,
	[Hit] [int] NOT NULL,
	[Flag] [tinyint] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Notice]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[Notice](
	[IDX] [int] NOT NULL,
	[MIDX] [int] NOT NULL,
	[Userid] [varchar](25) NOT NULL,
	[WriteName] [varchar](100) NOT NULL,
	[Title] [varchar](600) NOT NULL,
	[Content] [text] NOT NULL,
	[SelServer] [int] NOT NULL,
	[RegiDate] [datetime] NOT NULL,
	[RegiIP] [char](15) NOT NULL,
	[Hit] [int] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[PRBBSMain]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[PRBBSMain](
	[IDX] [int] NOT NULL,
	[PMNo] [varchar](20) NOT NULL,
	[Userid] [varchar](25) NOT NULL,
	[Title] [varchar](600) NOT NULL,
	[Content] [text] NOT NULL,
	[UserName] [varchar](100) NOT NULL,
	[ClanIdx] [int] NOT NULL,
	[SelServer] [int] NOT NULL,
	[RegiDate] [datetime] NOT NULL,
	[RegiIP] [char](15) NOT NULL,
	[Hit] [int] NOT NULL,
	[CountCom] [int] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[PRBBSSub]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[PRBBSSub](
	[SIDX] [int] NOT NULL,
	[MINDEX] [int] NOT NULL,
	[PMNo] [varchar](20) NOT NULL,
	[userid] [varchar](25) NOT NULL,
	[writename] [varchar](100) NOT NULL,
	[Content] [text] NOT NULL,
	[RegiDate] [datetime] NOT NULL,
	[RegiIP] [char](15) NOT NULL,
	[UserName] [varchar](100) NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[PRBbsFile]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[PRBbsFile](
	[IDX] [int] NOT NULL,
	[MINDEX] [int] NOT NULL,
	[FileName] [varchar](255) NOT NULL,
	[FileSize] [varchar](100) NOT NULL,
	[RegiDate] [datetime] NOT NULL
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SiegeClanList]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[SiegeClanList](
	[IDX] [int] NOT NULL,
	[UserID] [varchar](50) NOT NULL,
	[CharName] [varchar](50) NOT NULL,
	[ClanName] [varchar](50) NOT NULL,
	[TaxRate] [int] NOT NULL,
	[ServerName] [varchar](50) NOT NULL,
	[Server] [tinyint] NOT NULL,
	[OperFrom] [datetime] NULL,
	[OperTo] [datetime] NULL,
	[RegistDay] [datetime] NOT NULL
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SiegeCurrentList]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[SiegeCurrentList](
	[IDX] [int] NOT NULL,
	[CIDX] [int] NULL,
	[UserID] [varchar](50) NULL,
	[chName] [varchar](50) NULL,
	[ServerName] [varchar](50) NULL,
	[Operator] [varchar](50) NULL,
	[OperCode] [char](10) NULL,
	[SiegeMoney] [bigint] NULL,
	[RegistDay] [datetime] NULL
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SiegeMoneyTax]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[SiegeMoneyTax](
	[DNo] [int] IDENTITY(1,1) NOT NULL,
	[IDX] [int] NULL,
	[Mixing] [bigint] NULL,
	[Aging] [bigint] NULL,
	[Shop] [bigint] NULL,
	[Poison1] [bigint] NULL,
	[Poison2] [bigint] NULL,
	[Poison3] [bigint] NULL,
	[Force] [bigint] NULL,
	[Warpgate] [bigint] NULL,
	[Skill] [bigint] NULL,
	[Total] [bigint] NULL,
	[Tax] [bigint] NULL,
	[ServerName] [varchar](50) NULL,
	[RegistDay] [datetime] NULL
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[SiegeMoneyLog]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[SiegeMoneyLog](
	[IDX] [int] IDENTITY(1,1) NOT NULL,
	[CIDX] [int] NULL,
	[UserID] [varchar](50) NULL,
	[chName] [varchar](50) NULL,
	[ServerName] [varchar](50) NULL,
	[Operator] [varchar](50) NULL,
	[OperCode] [char](10) NULL,
	[SiegeMoney] [bigint] NULL,
	[RegistDay] [datetime] NULL
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[UL]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[UL](
	[IDX] [int] NOT NULL,
	[MIDX] [int] IDENTITY(1,1) NOT NULL,
	[userid] [nvarchar](50) NOT NULL,
	[ChName] [nvarchar](50) NOT NULL,
	[ChType] [int] NULL,
	[ChLv] [int] NULL,
	[ClanName] [nvarchar](50) NULL,
	[Permi] [char](2) NOT NULL,
	[JoinDate] [datetime] NOT NULL,
	[DelActive] [char](1) NOT NULL,
	[PFlag] [int] NOT NULL,
	[KFlag] [int] NOT NULL,
	[MIconCnt] [int] NOT NULL
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CL]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[CL](
	[IDX] [int] IDENTITY(1,1) NOT NULL,
	[ClanName] [nvarchar](50) NOT NULL,
	[Note] [text] NOT NULL,
	[NoteCnt] [int] NOT NULL,
	[UserID] [nvarchar](50) NULL,
	[ClanZang] [nvarchar](50) NOT NULL,
	[Flag] [int] NOT NULL,
	[MemCnt] [int] NOT NULL,
	[MIconCnt] [int] NOT NULL,
	[RegiDate] [datetime] NOT NULL,
	[LimitDate] [datetime] NOT NULL,
	[DelActive] [char](1) NOT NULL,
	[PFlag] [int] NOT NULL,
	[KFlag] [int] NOT NULL,
	[Cpoint] [int] NULL,
	[CWin] [int] NULL,
	[CFail] [int] NULL,
	[ClanMoney] [bigint] NULL,
	[CNFlag] [int] NULL,
	[SiegeMoney] [bigint] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[CT]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[CT](
	[SNo] [int] NULL,
	[ServerName] [varchar](50) NULL,
	[MIDX] [int] NULL,
	[ClanName] [varchar](50) NULL,
	[ClanJang] [int] NULL,
	[ClanImage] [varchar](50) NULL,
	[UserID] [varchar](25) NULL,
	[ChName] [varchar](50) NULL,
	[GPCode] [varchar](20) NULL,
	[LogonTime] [datetime] NULL,
	[IP] [varchar](20) NULL,
	[RNo] [int] NULL,
	[Flag] [int] NULL
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[LI]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[LI](
	[IMG] [int] NOT NULL,
	[ID] [int] NOT NULL
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[BBSMain]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[BBSMain](
	[IDX] [int] NOT NULL,
	[MIDX] [int] NOT NULL,
	[Userid] [varchar](25) NOT NULL,
	[WriteName] [varchar](100) NOT NULL,
	[Title] [varchar](600) NOT NULL,
	[Content] [text] NOT NULL,
	[SelServer] [int] NOT NULL,
	[RegiDate] [datetime] NOT NULL,
	[RegiIP] [char](15) NOT NULL,
	[Hit] [int] NOT NULL,
	[CountCom] [int] NOT NULL,
	[NickName] [varchar](32) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[BBSSub]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[BBSSub](
	[SIDX] [int] NOT NULL,
	[MINDEX] [int] NOT NULL,
	[Userid] [varchar](25) NOT NULL,
	[WriteName] [varchar](100) NOT NULL,
	[Content] [text] NOT NULL,
	[RegiDate] [datetime] NOT NULL,
	[RegiIP] [char](15) NOT NULL,
	[NickName] [varchar](32) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[ChipLog]') AND type in (N'U'))
BEGIN
CREATE TABLE [dbo].[ChipLog](
	[LgIDX] [int] NOT NULL,
	[CIDX] [int] NOT NULL,
	[CServer] [int] NOT NULL,
	[Userid] [varchar](50) NOT NULL,
	[Chname] [varchar](50) NOT NULL,
	[Permi] [char](2) NOT NULL,
	[RegiDate] [datetime] NOT NULL
) ON [PRIMARY]
END
Just for historic reference, should anyone be looking for answers here. ^_^
 
Back
Top