Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 02:09

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

 

[RELEASE] FULL FILE SERVER 8.1 ~

Reply
 
Old   #76
 
elite*gold: 0
Join Date: Feb 2012
Posts: 11
Received Thanks: 2
Quote:
Originally Posted by Mslolita View Post
i did this not working... i am using sql 2012

Code:
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]
Error:
Code:
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'.
Use it:

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

INSERT INTO [Telecaster7.4].dbo.[character]
([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])

SELECT 

[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]

FROM [telecaster81] .dbo.[Character] AS Character
SET IDENTITY INSERT [telecaster8.1].dbo.[character] OFF



salamator is offline  
Old   #77
 
elite*gold: 0
Join Date: Dec 2012
Posts: 102
Received Thanks: 4
i am getting this error..

Code:
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 156, Level 15, State 1, Line 49
Incorrect syntax near the keyword 'IDENTITY'.
Msg 156, Level 15, State 1, Line 49
Incorrect syntax near the keyword 'OFF'.

Quote:
Originally Posted by salamator View Post
Use it:

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

INSERT INTO [Telecaster7.4].dbo.[character]
([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])

SELECT 

[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]

FROM [telecaster81] .dbo.[Character] AS Character
SET IDENTITY INSERT [telecaster8.1].dbo.[character] OFF


Mslolita is offline  
Old   #78
 
elite*gold: 0
Join Date: Feb 2012
Posts: 11
Received Thanks: 2
Quote:
Originally Posted by Mslolita View Post
i am getting this error..

Code:
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 156, Level 15, State 1, Line 49
Incorrect syntax near the keyword 'IDENTITY'.
Msg 156, Level 15, State 1, Line 49
Incorrect syntax near the keyword 'OFF'.

Ops...
Code:
SET IDENTITY_INSERT [dbo].[Character] ON
INSERT INTO [Telecaster7.4].dbo.[character]
([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])

SELECT 

[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]

FROM [telecaster81] .dbo.[Character] AS Character
SET IDENTITY_INSERT [dbo].[Character] OFF
salamator is offline  
Old   #79
 
elite*gold: 0
Join Date: Dec 2012
Posts: 102
Received Thanks: 4
stil not working...

Code:
Msg 207, Level 16, State 1, Line 4
Invalid column name 'main_title'.
Msg 207, Level 16, State 1, Line 5
Invalid column name 'sub_title_0'.
Msg 207, Level 16, State 1, Line 6
Invalid column name 'sub_title_1'.
Msg 207, Level 16, State 1, Line 7
Invalid column name 'sub_title_2'.
Msg 207, Level 16, State 1, Line 8
Invalid column name 'sub_title_3'.
Msg 207, Level 16, State 1, Line 9
Invalid column name 'sub_title_4'.
Msg 207, Level 16, State 1, Line 10
Invalid column name 'remain_title_time'.
Msg 207, Level 16, State 1, Line 11
Invalid column name 'arena_point'.
Msg 207, Level 16, State 1, Line 12
Invalid column name 'arena_block_time'.
Msg 207, Level 16, State 1, Line 13
Invalid column name 'arena_penalty_count'.
Msg 207, Level 16, State 1, Line 14
Invalid column name 'arena_penalty_dec_time'.
Msg 207, Level 16, State 1, Line 15
Invalid column name 'arena_mvp_count'.
Msg 207, Level 16, State 1, Line 16
Invalid column name 'arena_record_0_0'.
Msg 207, Level 16, State 1, Line 17
Invalid column name 'arena_record_0_1'.
Msg 207, Level 16, State 1, Line 18
Invalid column name 'arena_record_1_0'.
Msg 207, Level 16, State 1, Line 19
Invalid column name 'arena_record_1_1'.
Msg 207, Level 16, State 1, Line 20
Invalid column name 'arena_record_2_0'.
Msg 207, Level 16, State 1, Line 21
Invalid column name 'arena_record_2_1'.
Msg 207, Level 16, State 1, Line 22
Invalid column name 'alias'.
if i remove the
[ ( ] [pet],

[alias] [ ) ]

i am getting this error
Code:
Msg 102, Level 15, State 1, Line 3
Incorrect syntax near 'pet'.
Quote:
Originally Posted by salamator View Post
Ops...
Code:
SET IDENTITY_INSERT [dbo].[Character] ON
INSERT INTO [Telecaster7.4].dbo.[character]
([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])

SELECT 

[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]

FROM [telecaster81] .dbo.[Character] AS Character
SET IDENTITY_INSERT [dbo].[Character] OFF


Mslolita is offline  
Old   #80
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,003
Received Thanks: 957
It seems like going through this much trouble and not knowing as much as is needed to be known about SQL that more time could have been saved just inserting the new columns into 7.4 manually.

With "add column"

It would be done already.
ThunderNikk is offline  
Old   #81
 
elite*gold: 0
Join Date: Dec 2012
Posts: 102
Received Thanks: 4
adding the colums only wont make it work... i already tried it

Quote:
Originally Posted by thndr View Post
It seems like going through this much trouble and not knowing as much as is needed to be known about SQL that more time could have been saved just inserting the new columns into 7.4 manually.

With "add column"

It would be done already.
Mslolita is offline  
Old   #82
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,003
Received Thanks: 957
Well thats all that SQL is doing is adding the columns from 8.1 that are not in your 7.4 dbo.character table and putting them in there.

There is no data to select and add from the 8.1 database an insert into the 7.4 data base except for the columns.

Until there are characters made in the 8.4 database there is no data, that is why people told you to populate the new columns with 0's for now because there is no data to add until you apply a title or gain arena points on said characters in the 7.4 data base the data is 0

As soon as you apply a title or something else for the new content add then the table will update the 0's
ThunderNikk is offline  
Old   #83
 
elite*gold: 0
Join Date: Dec 2012
Posts: 102
Received Thanks: 4
let me try again

Quote:
Originally Posted by thndr View Post
Well thats all that SQL is doing is adding the columns from 8.1 that are not in your 7.4 dbo.character table and putting them in there.

There is no data to select and add from the 8.1 database an insert into the 7.4 data base except for the columns.

Until there are characters made in the 8.4 database there is no data, that is why people told you to populate the new columns with 0's for now because there is no data to add until you apply a title or gain arena points on said characters in the 7.4 data base the data is 0

As soon as you apply a title or something else for the new content add then the table will update the 0's
Mslolita is offline  
Old   #84
 
elite*gold: 0
Join Date: Oct 2010
Posts: 2,557
Received Thanks: 2,411
To be honest you guys are just playing with fire attempting to import old data (well at-least from 7.3) but even back in 7.3 to 7.4 several Dev's encounter dead-locking or random crashing usually related to a bad import or conversion import.
ismokedrow is offline  
Old   #85
 
elite*gold: 0
Join Date: Dec 2012
Posts: 102
Received Thanks: 4
so a epic 8.1 server have to start all over again ?
because it's not a good idea to import old database filles and merge the database to keep the account characters?

there is a way to import these databases into 1 without making them crash etc..

Quote:
Originally Posted by ismokedrow View Post
To be honest you guys are just playing with fire attempting to import old data (well at-least from 7.3) but even back in 7.3 to 7.4 several Dev's encounter dead-locking or random crashing usually related to a bad import or conversion import.
Mslolita is offline  
Old   #86
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,003
Received Thanks: 957
To import all of the data from your 7.4 Telecaster into your 8.1 Telecaster it is much more extensive then just importing the Character table into 8.1 there is a lot of character data that is not contained in just the character table.

It is far easier to update the 7.4 Telecaster to work with the 8.1 Arcadia by adding the new table content and data into the 7.4 Telecaster.

By adding the missing columns now when Arcadia runs a SMP to update the data in the character table it can.

Again like Drow said it may go a lot deeper than just table data being able to be updated. I know he ran into trouble working with their server. I am not sure on how all the program-ability works yet as there may be new SMPs in the new Telecaster that you would lose if you update the old one.

We know that somehow they do it on the retail servers as they maintain character data through all of the epics so far but they probably have better SQL written to update the SMPs as well.

I am going to work on it a little bit and I will let you know what I find out.
ThunderNikk is offline  
Old   #87
 
elite*gold: 0
Join Date: Dec 2012
Posts: 102
Received Thanks: 4
i tried to insert the smp to and updated missing colums but still the game server is now crashing without making a crash log.

i found out it's not just the character table that should be transfered there are more tables to like dbo.title,dbo.titlecondition. i did copy these tables but still it does crash for some reason.

i am using the arcadia 8.1 backup + 7.4 auth
telecaster 7.4 combined with the missing colums smp and tables from 8.1.

hope you will find out more, ill keep working on it.

Quote:
Originally Posted by thndr View Post
To import all of the data from your 7.4 Telecaster into your 8.1 Telecaster it is much more extensive then just importing the Character table into 8.1 there is a lot of character data that is not contained in just the character table.

It is far easier to update the 7.4 Telecaster to work with the 8.1 Arcadia by adding the new table content and data into the 7.4 Telecaster.

By adding the missing columns now when Arcadia runs a SMP to update the data in the character table it can.

Again like Drow said it may go a lot deeper than just table data being able to be updated. I know he ran into trouble working with their server. I am not sure on how all the program-ability works yet as there may be new SMPs in the new Telecaster that you would lose if you update the old one.

We know that somehow they do it on the retail servers as they maintain character data through all of the epics so far but they probably have better SQL written to update the SMPs as well.

I am going to work on it a little bit and I will let you know what I find out.
Mslolita is offline  
Old   #88
Moderator
 
elite*gold: 1
Join Date: Dec 2012
Posts: 3,003
Received Thanks: 957
dbo.titleresource and dbo.titleconditionresource are part of Arcadia.
ThunderNikk is offline  
Old   #89
 
elite*gold: 0
Join Date: Dec 2012
Posts: 102
Received Thanks: 4
anyone can help me out ?

@TheOnlyOneRaskim

Raskim maybe you know how to?
Mslolita is offline  
Old   #90
 
elite*gold: 0
Join Date: Apr 2011
Posts: 273
Received Thanks: 69
how you are mentoring a rappelz server without knowing the "basic" knowledge of mssql ??
try this one :


TheSuperKiller is offline  
Reply



« Previous Thread | Next Thread »

Similar Threads
AUF DER SUCHE NACH DEUTSCHLAND File Server 2011 FULL Franzi
AUF DER SUCHE NACH DEUTSCHLAND File Server 2011 FULL Franzi
0 Replies - Metin2 PServer - Discussions / Questions
[Release] Full O3D File Format
Hallo Leute, Ich hab mir mal die Zeit genommen das komplette O3D Datei Format aufzuschreiben. Vielleicht kann der eine oder andere was damit...
2 Replies - Flyff PServer Guides & Releases
I want File server 7.1 full ^_^
i want set up my server P server bUt i want File server i don't have ^_^ pls give me it i :mofo: UP UP where all please i want
1 Replies - Rappelz Private Server
[Release]Game2089 Full File
This topic deleted because I give just Lexico
17 Replies - Metin2 PServer Guides & Strategies
Help i want file Server Full Ep3
plaeseeeee.. thank you.:handsdown:
3 Replies - Cabal Hacks, Bots, Cheats, Exploits & Macros



All times are GMT +2. The time now is 02:09.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy
Copyright ©2017 elitepvpers All Rights Reserved.