Register for your free account! | Forgot your password?

Go Back   elitepvpers > Popular Games > Silkroad Online > SRO Coding Corner
You last visited: Today at 05:14

  • Please register to post and access all features, it's quick, easy and FREE!

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.

Reply
 
Old 12/24/2010, 20:30   #451
 
hambal's Avatar
 
elite*gold: 20
Join Date: Apr 2008
Posts: 1,841
Received Thanks: 366
guys who can help me whit fixing my problem whit teamviewer pm me on elitepvpers
hambal is offline  
Old 12/24/2010, 22:49   #452
 
elite*gold: 0
Join Date: Jun 2008
Posts: 89
Received Thanks: 21
who become i silk.sql pls uploaden ....
pisser is offline  
Old 12/25/2010, 00:02   #453
 
killer2speed's Avatar
 
elite*gold: 0
Join Date: Sep 2007
Posts: 40
Received Thanks: 7
Quote:
Originally Posted by PressButton View Post
where silk.sql :/

copy it
Quote:
/****** Object: Table [dbo].[char_items] Script Date: 12/15/2010 22:19:07 ******/
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)),
[phy_re] [tinyint] NULL CONSTRAINT [DF_char_items_blue1] DEFAULT ((0)),
[mag_re] [tinyint] NULL CONSTRAINT [DF_char_items_blue_id_2] DEFAULT ((0)),
[phy_def] [tinyint] NULL CONSTRAINT [DF_char_items_phy_def] DEFAULT ((0)),
[mag_def] [tinyint] NULL CONSTRAINT [DF_char_items_mag_def] DEFAULT ((0)),
[block_ratio] [tinyint] NULL CONSTRAINT [DF_char_items_block_ratio] DEFAULT ((0)),
[attack_ratio] [tinyint] NULL CONSTRAINT [DF_char_items_attack_ratio] DEFAULT ((0)),
[parry_ratio] [tinyint] NULL CONSTRAINT [DF_char_items_parry_ratio] DEFAULT ((0)),
[phy_attack] [tinyint] NULL CONSTRAINT [DF_char_items_phy_attack] DEFAULT ((0)),
[mag_attack] [tinyint] NULL CONSTRAINT [DF_char_items_mag_attack] DEFAULT ((0)),
[str_value] [tinyint] NULL CONSTRAINT [DF_char_items_str_value] DEFAULT ((0)),
[int_value] [tinyint] NULL CONSTRAINT [DF_char_items_int_value] DEFAULT ((0)),
[block_blue] [tinyint] NULL CONSTRAINT [DF_char_items_block_blue] 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
/****** Object: Table [dbo].[character] Script Date: 12/15/2010 22:19:17 ******/
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 ((17)),
[runspeed] [int] NULL CONSTRAINT [DF_karakterler_runspeed] DEFAULT ((70)),
[berserkspeed] [int] NULL CONSTRAINT [DF_karakterler_berserkerspeed] DEFAULT ((100)),
[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)),
[Action] [int] NULL CONSTRAINT [DF_character_Action] DEFAULT ((0)),
[Online] [tinyint] NULL CONSTRAINT [DF_character_Online] DEFAULT ((1)),
[DailyPK] [tinyint] NULL CONSTRAINT [DF_character_DailyPK] DEFAULT ((0)),
[PkLevel] [tinyint] NULL CONSTRAINT [DF_character_PkLevel] DEFAULT ((0)),
[MurderLevel] [tinyint] NULL CONSTRAINT [DF_character_MurderLevel] DEFAULT ((0))
) ON [PRIMARY]

/****** 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]

GO
SET ANSI_PADDING OFF



killer2speed is offline  
Thanks
1 User
Old 12/25/2010, 00:07   #454
 
killer2speed's Avatar
 
elite*gold: 0
Join Date: Sep 2007
Posts: 40
Received Thanks: 7
Quote:
Originally Posted by eslamradwan View Post

why im stuck when game loading ?? the game Freez when loading after selct Char and pres start
plz help

thx
# up Your database Srevolution_1.2.5 thanks,,,,
killer2speed is offline  
Old 12/25/2010, 00:28   #455
 
hambal's Avatar
 
elite*gold: 20
Join Date: Apr 2008
Posts: 1,841
Received Thanks: 366
nvm got it working
hambal is offline  
Old 12/25/2010, 13:00   #456
 
viky909's Avatar
 
elite*gold: 0
Join Date: Sep 2009
Posts: 40
Received Thanks: 2
Hi bro , i need little help : where the silk.sql file ?!

thanks in advance !
viky909 is offline  
Old 12/25/2010, 14:42   #457
 
viky909's Avatar
 
elite*gold: 0
Join Date: Sep 2009
Posts: 40
Received Thanks: 2
Quote:
Originally Posted by SmileJoint View Post


Uploaded with
how to solve this problem?
Run as admin !
viky909 is offline  
Old 12/25/2010, 14:46   #458
 
viky909's Avatar
 
elite*gold: 0
Join Date: Sep 2009
Posts: 40
Received Thanks: 2
Quote:
Originally Posted by genral20110 View Post
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
Same error here !
viky909 is offline  
Old 12/25/2010, 17:57   #459
 
majdi1's Avatar
 
elite*gold: 0
Join Date: May 2009
Posts: 124
Received Thanks: 4
hi help i have error in login server they say the sql pw is expired
majdi1 is offline  
Old 12/25/2010, 18:23   #460
 
elite*gold: 0
Join Date: Mar 2009
Posts: 2,693
Received Thanks: 3,160
guys learn to use spoilers !
LastThief is offline  
Old 12/25/2010, 22:46   #461
 
elite*gold: 0
Join Date: Dec 2007
Posts: 57
Received Thanks: 16
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
Laci9009 is offline  
Old 12/25/2010, 23:13   #462
 
dimkacool's Avatar
 
elite*gold: 0
Join Date: Jun 2009
Posts: 3,448
Received Thanks: 2,330
Quote:
Originally Posted by Laci9009 View Post
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..
dimkacool is offline  
Old 12/25/2010, 23:24   #463
 
elite*gold: 0
Join Date: Dec 2007
Posts: 57
Received Thanks: 16
dimkacool

Thank You for reply!
BTW how can i use english language?
I use the korean client (ksro client) and i use edxloder 5 with english patch

Pls tell me how to use english language .. need media.pk2? tell me pls.
Thank You!
Laci9009 is offline  
Old 12/25/2010, 23:33   #464
 
dimkacool's Avatar
 
elite*gold: 0
Join Date: Jun 2009
Posts: 3,448
Received Thanks: 2,330
Quote:
Originally Posted by Laci9009 View Post
dimkacool

Thank You for reply!
BTW how can i use english language?
I use the korean client (ksro client) and i use edxloder 5 with english patch

Pls tell me how to use english language .. need media.pk2? tell me pls.
Thank You!
Gosh... You have to use english keyboard first.
And than you must set english language (writing)...
Ant than press Left Shift + ~ .
dimkacool is offline  
Old 12/25/2010, 23:51   #465
 
elite*gold: 0
Join Date: Dec 2007
Posts: 57
Received Thanks: 16
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?

Thank You again!
Laci9009 is offline  
Reply


Similar Threads 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 05:15.


Powered by vBulletin®
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2026 elitepvpers All Rights Reserved.