[Guide]Srevolution Full Guide Mssql + Mssql Server Manager + Server Files
Discussion on [Guide]Srevolution Full Guide Mssql + Mssql Server Manager + Server Files within the SRO Coding Corner forum part of the Silkroad Online category.
/****** Object: Table [dbo].[character_guides] Script Date: 12/15/2010 22:19:20 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[character_guides](
[id] [int] IDENTITY(1,1) NOT NULL,
[Guide_Name] [varchar](50) NULL,
[Guide_Owner] [varchar](50) NULL,
[Guide_Status] [tinyint] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[character_jobs] Script Date: 12/15/2010 22:19:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[character_jobs](
[id] [int] IDENTITY(1,1) NOT NULL,
[character_name] [varchar](50) NULL,
[job_alias] [varchar](50) NULL CONSTRAINT [DF_character_jobs_job_alias] DEFAULT ((0)),
[job_type] [tinyint] NULL,
[job_experience] [int] NULL CONSTRAINT [DF_character_jobs_job_experience] DEFAULT ((0)),
[job_rank] [tinyint] NULL CONSTRAINT [DF_character_jobs_job_rank] DEFAULT ((0)),
[job_state] [int] NULL CONSTRAINT [DF_character_jobs_job_state] DEFAULT ((0))
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[character_quests] Script Date: 12/15/2010 22:19:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[character_quests](
[id] [int] IDENTITY(1,1) NOT NULL,
[character] [varchar](50) NULL,
[quest_id] [int] NULL,
[quest_status] [tinyint] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[character_rev] Script Date: 12/15/2010 22:19:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[character_rev](
[id] [int] IDENTITY(1,1) NOT NULL,
[charname] [varchar](50) NULL,
[revxsec] [tinyint] NULL,
[revysec] [tinyint] NULL,
[revx] [int] NULL,
[revy] [int] NULL,
[revz] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[friends] Script Date: 12/15/2010 22:19:29 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[friends](
[id] [int] IDENTITY(1,1) NOT NULL,
[owner] [varchar](50) NULL,
[friend_name] [varchar](50) NULL,
[model_info] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[guild] Script Date: 12/15/2010 22:19:31 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[guild](
[id] [int] IDENTITY(1,1) NOT NULL,
[guild_name] [varchar](50) NULL,
[guild_level] [tinyint] NULL,
[guild_points] [int] NULL,
[guild_news_t] [varchar](50) NULL,
[guild_news_m] [varchar](50) NULL,
[guild_members_t] [tinyint] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[guild_members] Script Date: 12/15/2010 22:19:33 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[guild_members](
[id] [int] IDENTITY(1,1) NOT NULL,
[guild_name] [varchar](50) NULL,
[guild_member_id] [int] NULL,
[guild_rank] [tinyint] NULL,
[guild_points] [int] NULL,
[guild_auth] [tinyint] NULL,
[guild_grant] [varchar](50) NULL,
[guild_p] [tinyint] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[guild_storage] Script Date: 12/15/2010 22:19:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[guild_storage](
[id] [int] IDENTITY(1,1) NOT NULL,
[guild_id] [int] NULL,
[storage_id] [int] NULL,
[item_id] [int] NULL,
[item_plus] [tinyint] NULL,
[item_durability] [int] NULL,
[item_slot] [tinyint] NULL,
[item_type] [tinyint] NULL,
[item_quantity] [smallint] NULL
) ON [PRIMARY]
/****** Object: Table [dbo].[guild_war] Script Date: 12/15/2010 22:19:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[guild_war](
[id] [int] NULL,
[guild_id] [int] NULL,
[guild_id_2] [int] NULL,
[status] [tinyint] NULL,
[war_gold] [bigint] NULL
) ON [PRIMARY]
/****** Object: Table [dbo].[mastery] Script Date: 12/15/2010 22:19:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[mastery](
[owner] [int] NULL,
[mastery] [int] NULL,
[level] [tinyint] NULL CONSTRAINT [DF_mastery_level] DEFAULT ((0))
) ON [PRIMARY]
/****** Object: Table [dbo].[message] Script Date: 12/15/2010 22:19:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[message](
[id] [int] IDENTITY(1,1) NOT NULL,
[sender] [varchar](50) NULL,
[receiver] [varchar](50) NULL,
[message] [text] NULL,
[status] [tinyint] NULL,
[time] [datetime] NULL,
[idinfo] [tinyint] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[news] Script Date: 12/15/2010 22:19:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[news](
[id] [int] IDENTITY(1,1) NOT NULL,
[head] [text] NULL,
[text] [text] NULL,
[day] [smallint] NULL,
[month] [smallint] NULL,
CONSTRAINT [PK_news] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
/****** Object: Table [dbo].[pets] Script Date: 12/15/2010 22:19:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[pets](
[id] [int] IDENTITY(1,1) NOT NULL,
[playerid] [int] NULL,
[pet_type] [tinyint] NULL,
[pet_name] [varchar](50) NULL,
[pet_state] [tinyint] NULL,
[pet_hp] [int] NULL,
[pet_hgp] [int] NULL,
[pet_itemid] [int] NULL,
[pet_slots] [tinyint] NULL CONSTRAINT [DF_pets_pet_slots] DEFAULT ((28)),
[pet_time] [datetime] NULL,
[pet_active] [tinyint] NULL CONSTRAINT [DF_pets_pet_active] DEFAULT ((0)),
[pet_unique] [int] NULL,
[pet_check] [varchar](50) NULL CONSTRAINT [DF_pets_pet_check] DEFAULT ((0))
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[pets_storage] Script Date: 12/15/2010 22:19:48 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[pets_storage](
[id] [int] IDENTITY(1,1) NOT NULL,
[owner] [int] NULL,
[itemid] [int] NULL,
[itemnumber] [varchar](50) NULL,
[plusvalue] [tinyint] NULL,
[slot] [tinyint] NULL,
[type] [tinyint] NULL,
[quantity] [smallint] NULL CONSTRAINT [DF_pets_storage_quantity] DEFAULT ((0)),
[durability] [int] NULL CONSTRAINT [DF_pets_storage_durability] DEFAULT ((0)),
[blue_values_1] [tinyint] NULL,
[pet_id] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[rank_honor] Script Date: 12/15/2010 22:19:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[rank_honor](
[id] [int] IDENTITY(1,1) NOT NULL,
[rank_icon] [tinyint] NULL,
[rank_name] [varchar](50) NULL,
[rank_level] [tinyint] NULL,
[rank_level_c] [tinyint] NULL,
[rank_graduates] [int] NULL,
[rank_position] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[rank_job_activity] Script Date: 12/15/2010 22:19:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[rank_job_activity](
[id] [int] IDENTITY(1,1) NOT NULL,
[job_type] [tinyint] NULL,
[job_rank] [tinyint] NULL,
[job_name] [varchar](50) NULL,
[job_level] [tinyint] NULL,
[job_exp] [int] NULL,
[job_title] [tinyint] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[rank_job_donate] Script Date: 12/15/2010 22:19:55 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[rank_job_donate](
[id] [int] IDENTITY(1,1) NOT NULL,
[job_type] [tinyint] NULL,
[job_rank] [tinyint] NULL,
[job_name] [varchar](50) NULL,
[job_level] [tinyint] NULL,
[job_donate] [int] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[saved_skills] Script Date: 12/15/2010 22:19:58 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[saved_skills](
[id] [int] IDENTITY(1,1) NOT NULL,
[owner] [varchar](50) NULL,
[skillid] [int] NULL,
[level] [int] NULL CONSTRAINT [DF_saved_skills_level] DEFAULT ((1)),
CONSTRAINT [PK_saved_skills] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[server] Script Date: 12/15/2010 22:20:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[server](
[id] [int] NOT NULL,
[serverid] [smallint] NULL,
[name] [varchar](50) NULL,
[users_current] [smallint] NULL,
[users_max] [smallint] NULL,
[state] [tinyint] NULL,
[ip] [varchar](20) NULL,
[port] [smallint] NULL,
[type] [tinyint] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[storage_items] Script Date: 12/15/2010 22:20:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[storage_items](
[id] [int] IDENTITY(1,1) NOT NULL,
[owner] [int] NULL,
[itemid] [int] NULL,
[itemnumber] [varchar](50) NULL,
[plusvalue] [tinyint] NULL CONSTRAINT [DF_storage_items_plusvalue] DEFAULT ((0)),
[slot] [tinyint] NULL,
[type] [tinyint] NULL CONSTRAINT [DF_storage_items_type] DEFAULT ((0)),
[quantity] [smallint] NULL CONSTRAINT [DF_storage_items_quantity] DEFAULT ((1)),
[durability] [int] NULL CONSTRAINT [DF_storage_items_durability] DEFAULT ((30)),
CONSTRAINT [PK_storage_items] PRIMARY KEY CLUSTERED
(
[id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[users] Script Date: 12/15/2010 22:20:04 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[users](
[userid] [int] IDENTITY(1,1) NOT NULL,
[id] [varchar](50) NOT NULL,
[password] [varchar](50) NOT NULL,
[online] [tinyint] NOT NULL,
[unknown] [tinyint] NULL,
[unknown2] [int] NULL,
[silk] [int] NULL,
[gold] [bigint] NULL,
CONSTRAINT [PK_users] PRIMARY KEY CLUSTERED
(
[userid] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[users_ban] Script Date: 12/15/2010 22:20:07 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[users_ban](
[id] [int] IDENTITY(1,1) NOT NULL,
[username] [varchar](50) NULL,
[ipadress] [varchar](50) NULL,
[reason] [text] NULL,
[endtime] [datetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
no one know what is this problem what is this i posted picture look down here and see
you wont find any mistake in my sql or any thing else
[IMG] Uploaded with [/IMG]
[IMG] Uploaded with [/IMG]
[IMG] Uploaded with [/IMG]
[IMG] Uploaded with [/IMG]
[IMG] Uploaded with [/IMG]
[IMG] Uploaded with [/IMG]
[IMG] Uploaded with [/IMG]
[IMG] Uploaded with [/IMG]
[IMG] Uploaded with [/IMG]
i know that i posted many talks about this problem but i tried so much but nothing happend i want one of makers of server to help me in this problem
and there other people have the same problem
Hi,
I cant open the GM console itry to use ****+' and try to use ****+~
and try to use shift+'+alt but dont working.. GM console isnt opened.
Please help me. BTW im gm in game [GM]Redron
i changed the char to "gm1" so im GM but cant open GM console.
Help pls. Thank You!
Hi,
I cant open the GM console itry to use ****+' and try to use ****+~
and try to use shift+'+alt but dont working.. GM console isnt opened.
Please help me. BTW im gm in game [GM]Redron
i changed the char to "gm1" so im GM but cant open GM console.
Help pls. Thank You!
Rev 1.2.5
Try to use english language in silkroad, because in others you won't be able to open.. In my opinion..
i know that.. i need to switch to english type keyboard with alt+shift <- that was the change to english.. but ingame i cant change :S do You know anything to resolve it?
[Guide] Setup MSSQL for Personal PServers 05/17/2012 - Shaiya PServer Guides & Releases - 14 Replies So I know there have been quite a few people having issues setting up mssql correctly to host their own private servers. I decided to post a video tut on how to set it up correctly for local use. This was done on Windows XP 32-bit and works on other OS as well.
*Note* This configuration is based on personal home use, not for public servers. I do not condone the use of illegal public servers, you will have to figure out those settings yourself.
...
Hilfee!!!! Prob mit Server files Und Db MSSQL 10/23/2010 - Flyff Private Server - 1 Replies Also ich weis nicht wie Ich die offi Files richtig einstellen Und ein fügen solll Und bei der DB Kann ich nix Machen muss mich einloggen und weiss nicht wie
Ich bitte um schnelle Antwort Kann Auch Skype oda TW?? Pls Pls Antwort
Gruß Fashiion
[GUIDE]ASP.NET error for MSSQL 20005 10/02/2010 - Cabal Guides & Templates - 0 Replies After a couple hours i have figured out how to correct the ASP.NET.
I don't know if anyone else is having a problem with it....
This is what you do,
Click the start Icon.
in the search box type in "intermgr"
a screen like this should open
http://i814.photobucket.com/albums/zz64/xvvhitecl oudx/inetmgr.jpg
How i find mssql server 08/28/2010 - Kal Online - 3 Replies Mssql server funzt bei mir nicht das 2000 gar nicht mehr zum installieren das 2005-2008 kann man nirgends in der scheisse bei google downloaden ... hilfe bitte
Sql Server 200 /MSSQL 200 ? 08/26/2009 - Dekaron Private Server - 2 Replies Hi where i can get Sql Server 2000 or MSSQL 2000 ?
have any one a download link for me ?
![[Guide]Srevolution Full Guide Mssql + Mssql Server Manager + Server Files](https://www.elitepvpers.com/forum/iconimages/sro-coding-corner/guide-srevolution-full-guide-mssql-mssql-server-manager-server-files_ltr.gif){kind=small}
