[RELEASE] FULL FILE SERVER 8.1 ~

Quote:

Originally Posted by mongreldogg 1. Есть эмулятор и базы 8.1 (отсюда взяты не спорю) 2. Уже всё добавили, поставили, пофиксили вылеты, биллинг, сд, дроп, разбор вещей, сладкий хлеб и сладкую воду, скилл скорость мага (впрочем наврядли ты знаешь все баги с этими вещами), всё рабочее 3. Перенесли своих петов на базу 8.1, всех персов и все шмотки с 7.4 без потерь данных и предыдущих наработок, все скрипты и так далее 4. Разработали систему ярости 5. Разработали скрипт для xONLINE сервера (уже давно) 6. Добавили свои магазины с овер 8к шмоток, из которых около 2к декорных и абсолютно все пушки которые есть в игре (5230 шт), расписали по полочкам в торговца пушками в СД. 7. Да всё это сделано не с воздуха и средства взяты с элит, не спорю, те же самые базы, эмули и даже ресурс эдиторы, но есть и вещи которые сделаны своими руками. У тебя есть что-то не слизанное?)))

Quote:

Originally Posted by [Xsanadu]Dream Да ты крут)))))

Quote:

Originally Posted by rakanomar ammmmm :$ it's easy .. - (FOR ACCOUNTS) in AUTH you Can use the Same database .. that's you use it with 7.4 file .. - (FOR characters ) in telecaster data base for upgrade from 7.4 to 8.1 < use this method :D Step/s : ammmm this is the new table that use in 8.1 data base PHP Code: [pet]       ,[main_title]       ,[sub_title_0]       ,[sub_title_1]       ,[sub_title_2]       ,[sub_title_3]       ,[sub_title_4]       ,[remain_title_time]       ,[arena_point]       ,[arena_block_time]       ,[arena_penalty_count]       ,[arena_penalty_dec_time]       ,[arena_mvp_count]       ,[arena_record_0_0]       ,[arena_record_0_1]       ,[arena_record_1_0]       ,[arena_record_1_1]       ,[arena_record_2_0]       ,[arena_record_2_1]       ,[alias]  so : Just go to old database(7.4)[dbo.characters] export data to database(8.1)[dbo.characters] and in the Rows insert VALUES ( 0 ) < zero .. ony in this tow Row insert ( time ) >> remain_title_time AND arena_penalty_dec_time ...... NOTICE : for export data USE Generate Script .. then > choose dbo.characters > next -> click at Advanced -> (TYPE OF DATA TO DCRIPT) make it _ Schema and data _ NOTICE : ammm i hope you to use MSSQL 2012 to bypass the isuse ..

Quote:

Originally Posted by Mslolita i can't get it working, can you make a quick tutorial or printscreens to show me how to do this.

SET IDENTITY INSERT [telecaster8.1].dbo.[character] ON

INSERT INTO [Telecaster7.4].dbo.[character]
(
	[pet] [int] NOT NULL,
	[main_title] [int] NOT NULL,
	[sub_title_0] [int] NOT NULL,
	[sub_title_1] [int] NOT NULL,
	[sub_title_2] [int] NOT NULL,
	[sub_title_3] [int] NOT NULL,
	[sub_title_4] [int] NOT NULL,
	[remain_title_time] [int] NOT NULL,
	[arena_point] [int] NOT NULL,
	[arena_block_time] [datetime] NOT NULL,
	[arena_penalty_count] [int] NOT NULL,
	[arena_penalty_dec_time] [datetime] NOT NULL,
	[arena_mvp_count] [int] NOT NULL,
	[arena_record_0_0] [int] NOT NULL,
	[arena_record_0_1] [int] NOT NULL,
	[arena_record_1_0] [int] NOT NULL,
	[arena_record_1_1] [int] NOT NULL,
	[arena_record_2_0] [int] NOT NULL,
	[arena_record_2_1] [int] NOT NULL,
	[alias] [nvarchar](61) NOT NULL,	(

SELECT 

(
	[pet] [int] NOT NULL,
	[main_title] [int] NOT NULL,
	[sub_title_0] [int] NOT NULL,
	[sub_title_1] [int] NOT NULL,
	[sub_title_2] [int] NOT NULL,
	[sub_title_3] [int] NOT NULL,
	[sub_title_4] [int] NOT NULL,
	[remain_title_time] [int] NOT NULL,
	[arena_point] [int] NOT NULL,
	[arena_block_time] [datetime] NOT NULL,
	[arena_penalty_count] [int] NOT NULL,
	[arena_penalty_dec_time] [datetime] NOT NULL,
	[arena_mvp_count] [int] NOT NULL,
	[arena_record_0_0] [int] NOT NULL,
	[arena_record_0_1] [int] NOT NULL,
	[arena_record_1_0] [int] NOT NULL,
	[arena_record_1_1] [int] NOT NULL,
	[arena_record_2_0] [int] NOT NULL,
	[arena_record_2_1] [int] NOT NULL,
	[alias] [nvarchar](61) NOT NULL,	(

FROM [telecaster81] .dbo.[Character]

Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'IDENTITY'.
Msg 156, Level 15, State 1, Line 1
Incorrect syntax near the keyword 'ON'.
Msg 102, Level 15, State 1, Line 5
Incorrect syntax near 'int'.
Msg 102, Level 15, State 1, Line 29
Incorrect syntax near 'int'.

Quote:

Originally Posted by mongreldogg  Spoiler SET IDENTITY INSERT [Database 8.1].dbo.[Table] ON INSERT INTO [Database 8.1].dbo.[Table] (here list of columns, with primary keys) SELECT (same list but for not existing columns insert 0) FROM [Database 7.4].dbo.[Table] If table dont have primary keys, dont wirte  Spoiler SET IDENTITY INSERT [Database 8.1].dbo.[Table] ON