|
You last visited: Today at 17:58
Advertisement
[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.
11/22/2010, 23:18
|
#346
|
elite*gold: 0 
Join Date: Jun 2008
Posts: 322
Received Thanks: 53
|
Quote:
Originally Posted by zoovoo
(thnx ) no work (((
|
edxSilkroadLoader5 : 127.0.0.1 Port 15779 ! 
Quote:
Originally Posted by [B]ase[J]umP
lol i cant get the tables x)
i copy-pasted it and it wont give me the tables.
|
1. after all installation and settings done , restart your pc.
2.Dont forget to put silk instead of master,copy all than click execute
PHP Code:
USE [silk]
GO
/****** Object: Table [dbo].[users] Script Date: 11/12/2010 00:58:12 ******/
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].[storage_items] Script Date: 11/12/2010 00:58:10 ******/
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].[server] Script Date: 11/12/2010 00:58:09 ******/
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].[saved_skills] Script Date: 11/12/2010 00:58:07 ******/
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,
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].[pets] Script Date: 11/12/2010 00:58:06 ******/
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] [varchar](50) NULL,
[pet_id] [int] NULL,
[pet_type] [tinyint] NULL,
[pet_name] [varchar](50) NULL,
[pet_state] [tinyint] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[news] Script Date: 11/12/2010 00:58:04 ******/
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,
[Year] [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].[mastery] Script Date: 11/12/2010 00:58:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[mastery](
[id] [int] NULL,
[owner] [int] NULL,
[mastery] [int] NULL,
[level] [tinyint] NULL CONSTRAINT [DF_mastery_level] DEFAULT ((0))
) ON [PRIMARY]
/****** Object: Table [dbo].[guild_storage] Script Date: 11/12/2010 00:58:00 ******/
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] Script Date: 11/12/2010 00:57:58 ******/
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,
[owner] [varchar](50) NULL,
[name] [varchar](50) NULL,
[level] [tinyint] NULL,
[storageid] [int] NULL,
[Grant_name] [varchar](50) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[character_jobs] Script Date: 11/12/2010 00:57:56 ******/
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,
[job_type] [tinyint] NULL,
[job_experience] [int] NULL,
[job_rank] [tinyint] NULL,
[job_state] [tinyint] NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
/****** Object: Table [dbo].[character_guides] Script Date: 11/12/2010 00:57:54 ******/
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] Script Date: 11/12/2010 00:57:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[character](
[id] [int] IDENTITY(1,1) NOT NULL,
[account] [nvarchar](50) NOT NULL,
[name] [nvarchar](50) NOT NULL,
[chartype] [int] NOT NULL,
[volume] [tinyint] NOT NULL,
[level] [tinyint] NOT NULL CONSTRAINT [DF_karakterler_level] DEFAULT ((1)),
[strength] [smallint] NOT NULL CONSTRAINT [DF_karakterler_strength] DEFAULT ((20)),
[intelligence] [smallint] NOT NULL CONSTRAINT [DF_karakterler_intelligence] DEFAULT ((20)),
[attribute] [smallint] NOT NULL CONSTRAINT [DF_karakterler_attribute] DEFAULT ((0)),
[hp] [int] NOT NULL CONSTRAINT [DF_karakterler_hp] DEFAULT ((200)),
[mp] [int] NOT NULL CONSTRAINT [DF_karakterler_mp] DEFAULT ((200)),
[gold] [bigint] NOT NULL CONSTRAINT [DF_karakterler_gold] DEFAULT ((0)),
[experience] [bigint] NOT NULL CONSTRAINT [DF_karakterler_expirience] DEFAULT ((0)),
[spbar] [int] NOT NULL CONSTRAINT [DF_karakterler_sbpar] DEFAULT ((0)),
[sp] [int] NOT NULL CONSTRAINT [DF_karakterler_sp] DEFAULT ((0)),
[gm] [tinyint] NOT NULL CONSTRAINT [DF_karakterler_gm] DEFAULT ((0)),
[xsect] [tinyint] NULL CONSTRAINT [DF_karakterler_xsect] DEFAULT ((168)),
[ysect] [tinyint] NULL CONSTRAINT [DF_karakterler_ysect] DEFAULT ((97)),
[unknown3] [nvarchar](50) NULL,
[xpos] [int] NULL CONSTRAINT [DF_karakterler_xpos] DEFAULT ((911)),
[ypos] [int] NULL CONSTRAINT [DF_karakterler_ypos] DEFAULT ((1083)),
[zpos] [int] NULL CONSTRAINT [DF_karakterler_zpos] DEFAULT ((-32)),
[s_hp] [int] NOT NULL CONSTRAINT [DF_karakterler_s_hp] DEFAULT ((200)),
[s_mp] [int] NOT NULL CONSTRAINT [DF_karakterler_s_mp] DEFAULT ((200)),
[min_phyatk] [int] NULL,
[max_phyatk] [int] NULL,
[min_magatk] [int] NULL,
[max_magatk] [int] NULL,
[phydef] [smallint] NULL,
[magdef] [smallint] NULL,
[hit] [smallint] NULL,
[parry] [smallint] NULL,
[unknown] [nvarchar](50) NULL,
[walkspeed] [int] NULL CONSTRAINT [DF_karakterler_walkspeed] DEFAULT ((15)),
[runspeed] [int] NULL CONSTRAINT [DF_karakterler_runspeed] DEFAULT ((50)),
[berserkspeed] [int] NULL CONSTRAINT [DF_karakterler_berserkerspeed] DEFAULT ((50)),
[berserkbar] [tinyint] NULL CONSTRAINT [DF_karakterler_berserkerbar] DEFAULT ((0)),
[unknown2] [nvarchar](50) NULL,
[mag_absord] [smallint] NULL CONSTRAINT [DF_karakterler_mag_absord] DEFAULT ((0)),
[phy_absord] [smallint] NULL CONSTRAINT [DF_karakterler_phy_absord] DEFAULT ((0)),
[savearea] [tinyint] NULL CONSTRAINT [DF_karakterler_savearea] DEFAULT ((3)),
[title] [tinyint] NULL CONSTRAINT [DF_karakterler_title] DEFAULT ((0)),
[deleted] [tinyint] NULL CONSTRAINT [DF_karakterler_deleted] DEFAULT ((0)),
[deletedtime] [datetime] NULL CONSTRAINT [DF_karakterler_deletedtime] DEFAULT ('10.10.2010'),
[Slots] [int] NULL CONSTRAINT [DF_karakterler_Slots] DEFAULT ((45)),
[Pvpstate] [tinyint] NULL CONSTRAINT [DF_character_Pkstate] DEFAULT ((0))
) ON [PRIMARY]
/****** Object: Table [dbo].[char_items] Script Date: 11/12/2010 00:57:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[char_items](
[id] [int] IDENTITY(1,1) NOT NULL,
[owner] [int] NULL,
[itemid] [int] NULL CONSTRAINT [DF_char_items_itemid] DEFAULT ((0)),
[itemnumber] [varchar](50) NULL,
[plusvalue] [tinyint] NULL CONSTRAINT [DF_char_items_plusvalue] DEFAULT ((0)),
[slot] [tinyint] NULL,
[type] [tinyint] NULL CONSTRAINT [DF_char_items_type] DEFAULT ((0)),
[quantity] [smallint] NULL CONSTRAINT [DF_char_items_quantity] DEFAULT ((1)),
[durability] [int] NULL CONSTRAINT [DF_char_items_durability] DEFAULT ((30)),
[inavatar] [bigint] NULL CONSTRAINT [DF_char_items_inavatar] DEFAULT ((0)),
CONSTRAINT [PK_char_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
|
|
|
|
11/23/2010, 18:34
|
#347
|
elite*gold: 0
Join Date: Jan 2010
Posts: 2,363
Received Thanks: 695
|
LOL.i didnt notice that xD.
what a fail from me
|
|
|
|
|
11/23/2010, 18:55
|
#348
|
elite*gold: 0
Join Date: Feb 2010
Posts: 38
Received Thanks: 1
|
Why new update doesn't work for me.... Help me
|
|
|
|
|
11/24/2010, 06:12
|
#349
|
elite*gold: 0
Join Date: Mar 2008
Posts: 72
Received Thanks: 16
|
Can someone uploand client to another site? I have very slow speed from multiupload.
Thanks
|
|
|
|
|
11/24/2010, 06:17
|
#350
|
elite*gold: 0
Join Date: Nov 2010
Posts: 76
Received Thanks: 7
|
Quote:
Originally Posted by taobine
after installed and config setting you should restart computer.
|
im tired of people thinking restarting the dam computer solves all of your problems. IT DOESN'T
Hes Settings.cfg is not correct.
|
|
|
|
|
11/24/2010, 13:08
|
#351
|
elite*gold: 0
Join Date: Jul 2009
Posts: 56
Received Thanks: 5
|
I am connecting and gives me just requestion client pliz helllllllllllllllllllllllp
|
|
|
|
|
11/24/2010, 22:45
|
#352
|
elite*gold: 0
Join Date: Jun 2008
Posts: 322
Received Thanks: 53
|
Quote:
Originally Posted by Monaiz
im tired of people thinking restarting the dam computer solves all of your problems. IT DOESN'T
Hes Settings.cfg is not correct.
|
In this case ,we need to restart computer 
|
|
|
|
|
11/25/2010, 00:38
|
#353
|
elite*gold: 15
Join Date: May 2009
Posts: 448
Received Thanks: 218
|
could anyone help me ?
i can't create an account
|
|
|
|
|
11/25/2010, 01:20
|
#354
|
elite*gold: 0
Join Date: Nov 2010
Posts: 76
Received Thanks: 7
|
Make gold 0 then press enter
|
|
|
|
|
11/25/2010, 10:45
|
#355
|
elite*gold: 0
Join Date: Mar 2009
Posts: 2,693
Received Thanks: 3,160
|
Quote:
Originally Posted by magic128
could anyone help me ?
i can't create an account |
write (1) on it and its done
|
|
|
|
|
11/25/2010, 11:05
|
#356
|
elite*gold: 0
Join Date: Nov 2009
Posts: 1,515
Received Thanks: 891
|
Quote:
Originally Posted by LastThief
write (1) on it and its done |
+1
|
|
|
|
|
11/25/2010, 13:13
|
#357
|
elite*gold: 15
Join Date: May 2009
Posts: 448
Received Thanks: 218
|
@lastthief thanks
new error ...
|
|
|
|
|
11/25/2010, 17:07
|
#358
|
elite*gold: 0
Join Date: Nov 2010
Posts: 17
Received Thanks: 0
|
@magic128: U restart computer
0r:
Quote:
Originally Posted by LastThief
open your management studio--->login in windows mode---->expand Security--->Expand logins---->right click on sa---->master database-->silk--->Enjoy |
|
|
|
|
|
11/26/2010, 21:32
|
#359
|
elite*gold: 0
Join Date: Oct 2008
Posts: 105
Received Thanks: 11
|
i need team viewer help xD i fatally failed >.<
EDIT: i already did it :P works fine! ^^
|
|
|
|
|
11/26/2010, 21:35
|
#360
|
elite*gold: 0
Join Date: Feb 2008
Posts: 3,777
Received Thanks: 1,455
|
I just made a tutorial video how to set the setting
Thank me if i helped! xD
|
|
|
|
 |
|
Similar Threads
|
[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 ?
|
All times are GMT +1. The time now is 18:00.
|
|
![[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}
![[B]ase[J]umP's Avatar](https://www.elitepvpers.com/forum/customavatars/avatar2047563_7.gif){kind=avatar}
