[Guide]Srevolution Full Guide Mssql + Mssql Server Manager + Server Files

Page 24 of 45 « First 142223 24 252634 Last »
11/22/2010 23:18 MesselyQc#346
Quote:
Originally Posted by zoovoo View Post
(thnx ) no work (((
edxSilkroadLoader5 : 127.0.0.1 Port 15779 ! :D


Quote:
Originally Posted by [B]ase[J]umP View Post
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
[Only registered and activated users can see links. Click Here To Register...]

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 [B]ase[J]umP#347
LOL.i didnt notice that xD.
what a fail from me :D
11/23/2010 18:55 gandras16#348
[Only registered and activated users can see links. Click Here To Register...]

Why new update doesn't work for me.... Help me
11/24/2010 06:12 Mudzas#349
Can someone uploand client to another site? I have very slow speed from multiupload.
Thanks
11/24/2010 06:17 Monaiz#350
Quote:
Originally Posted by taobine View Post
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 spidercom#351
I am connecting and gives me just requestion client pliz helllllllllllllllllllllllp
11/24/2010 22:45 MesselyQc#352
Quote:
Originally Posted by Monaiz View Post
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 magic128#353
could anyone help me ?
[Only registered and activated users can see links. Click Here To Register...]
i can't create an account
11/25/2010 01:20 Monaiz#354
Make gold 0 then press enter
11/25/2010 10:45 LastThief#355
Quote:
Originally Posted by magic128 View Post
could anyone help me ?
[Only registered and activated users can see links. Click Here To Register...]
i can't create an account
write (1) on it and its done :D
11/25/2010 11:05 ahmed4ever2u#356
Quote:
Originally Posted by LastThief View Post
write (1) on it and its done :D
+1
11/25/2010 13:13 magic128#357
@lastthief thanks

new error ...
[Only registered and activated users can see links. Click Here To Register...]
11/25/2010 17:07 thienphuongtc#358
@magic128: U restart computer
0r:
Quote:
Originally Posted by LastThief View Post
open your management studio--->login in windows mode---->expand Security--->Expand logins---->right click on sa---->master database-->silk--->Enjoy :D
11/26/2010 21:32 patrik96#359
i need team viewer help xD i fatally failed >.<

EDIT: i already did it :P works fine! ^^
11/26/2010 21:35 Haxor#360
I just made a tutorial video how to set the setting
Thank me if i helped! xD
Page 24 of 45 « First 142223 24 252634 Last »