[Release] EP5 Skills Work around, How to enable Higher level skill.

~~Alladrios~~ · 01/26/2011, 17:11

Quote:

Originally Posted by *AngelFromHeaven*

Pl0x say me

How can i inject my moded ProductList ( for itemmall )

*EDIT Into db= GameDefs, dbo.ProductList

Get the produclist.import.csv then open it with text editor and remove the first line, then save your file. save this file to C:\

Next step is deleting productlist in the database, so use the following code:

Code:

TRUNCATE TABLE [PS_GameDefs].[dbo].[ProductList]

then import the new productlist into the database using:

Code:

BULK
INSERT dbo.ProductList
FROM 'c:\ProductList.import.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)
GO

SaphiraGaming · 01/26/2011, 17:19

Ty it works !

SaphiraGaming · 01/26/2011, 22:10

Msg 208, Level 16, State 82, Line 1
Invalid object name 'dbo.ProductList'.

i updated my itemmall then i become this error when i try

ProfNerwosol · 01/26/2011, 22:26

It eludes me why anyone is using BULK INSERT when Linked Server is easier. Read the following MSDN article. Once you know how to use Linked Servers I bet you won't return to error prone BULK INSERT.

~~Alladrios~~ · 01/27/2011, 17:37

#Updated, check the first post. Thank EC and Zargon for pointing out more infos on the skill.sdata recompiling.

zargon05 · 01/27/2011, 17:47

Quote:

Originally Posted by Alladrios

Basically after recompiling your skill.sdata (After editing to match server side) you need to open this file into a hex editor and change the first numbers to 74 01 if you dont wanna get sgraphic error. If you follow this advise you should have no problems loading the game.
Cheers.

If you are lazy like me and dont want to edit SData everytime you can directly edit Skill.py
From:

Code:

record_total = struct.pack('I', (len(recs)/3))

To:

Code:

record_total = struct.pack('I', 372)

It should be around Line 149

SaphiraGaming · 01/27/2011, 17:56

Quote:

Originally Posted by ProfNerwosol

It eludes me why anyone is using BULK INSERT when Linked Server is easier. Read the following MSDN article. Once you know how to use Linked Servers I bet you won't return to error prone BULK INSERT.

i dont understand that >.<

zargon05 · 01/27/2011, 18:04

Quote:
Originally Posted by Alladrios
Hello folks,

Im releasing publicly today my work from last days to help making private servers better.

This is Shinru's EP 5.2 GameDefs table edited to allow skill level jumping.

For example you'll get Leadership lvl 1 => Level 3 => Level 5

Remember this is only a work around (This is not a real skil 3+) and you will need to edit skill.sdata properly and to update your clients. Use brain.exe and some time you'll manage to do it. However skills 3+ you will get are FULLY working according you have the correct skill.sdata.

Here's the file:

Note: Make sure to back up your drops / items table before you import this. You should extract these tables to .csv and then re import them in thsi new gamedefs.

Here's an example of query you can use:
Code:
BULK
INSERT dbo.ProductList
FROM 'c:\ProductList.import.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)
GO
Update regarding Skill.sdata compilation:

Thanks EC and Zargon for pointing this out.

Basically after recompiling your skill.sdata (After editing to match server side) you need to open this file into a hex editor and change the first numbers to 74 01 if you dont wanna get sgraphic error. If you follow this advise you should have no problems loading the game.

I will remake mine completely fixing a few bugs (rez runes and some other items) and post it as soon as i get it done so you all have a ready to use work around for EP5 skills.

Cheers.

Quote:

Originally Posted by *AngelFromHeaven*

i dont understand that >.<

Try this:

Code:

BULK
INSERT PS_GameDefs.dbo.ProductList
FROM 'c:\ProductList.import.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)
GO

SaphiraGaming · 01/27/2011, 18:08

now this error

Spoiler

Nah sry it works forgot to delete first line in ProductList.import.csv

zargon05 · 01/27/2011, 18:11

Something is wrong with your csv file, can you post your csv file.

~~Alladrios~~ · 01/27/2011, 18:18

That's because he didnt delete the column names on the first row of produclist.import.csv

I deleted it on mine and then completed the query sucessfully.

and yes as zargon stated use the following query:

Code:

BULK
INSERT [PS_GameDefs].[dbo].[ProductList]
FROM 'c:\ProductList.import.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)
GO

Giammy · 02/16/2011, 18:22

keep getting this error, any trips?

Code:

i keeMsg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1, column 1 (RowID).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 2, column 1 (RowID).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 3, column 1 (RowID).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 4, column 1 (RowID).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 5, column 1 (RowID).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 6, column 1 (RowID).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 7, column 1 (RowID).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 8, column 1 (RowID).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 9, column 1 (RowID).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 10, column 1 (RowID).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 11, column 1 (RowID).
Msg 4865, Level 16, State 1, Line 1
Cannot bulk load because the maximum number of errors (10) was exceeded.
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error.
Msg 7330, Level 16, State 2, Line 1
Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".

~~Alladrios~~ · 02/16/2011, 18:48

Open your productlist.csv with any text editor and remove the first line. Thnen save and import.

[GM]Father · 02/16/2011, 20:43

What is this?

Quote:

Originally Posted by Giammy

Code:

[COLOR="Red"]i kee[/COLOR]Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1, column 1 (RowID).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 2, column 1 (RowID).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 3, column 1 (RowID).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 4, column 1 (RowID).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 5, column 1 (RowID).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 6, column 1 (RowID).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 7, column 1 (RowID).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 8, column 1 (RowID).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 9, column 1 (RowID).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 10, column 1 (RowID).
Msg 4864, Level 16, State 1, Line 1
Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 11, column 1 (RowID).
Msg 4865, Level 16, State 1, Line 1
Cannot bulk load because the maximum number of errors (10) was exceeded.
Msg 7399, Level 16, State 1, Line 1
The OLE DB provider "BULK" for linked server "(null)" reported an error. The provider did not give any information about the error.
Msg 7330, Level 16, State 2, Line 1
Cannot fetch a row from OLE DB provider "BULK" for linked server "(null)".

Giammy · 02/16/2011, 21:09

just an error,

i've already deleted the first line as u said in last pages man, for this reason i'm asking again what should i do cause that solution did not work