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

Page 3 of 4 12 3 4
01/26/2011 17:11 Alladrios#31
Quote:
Originally Posted by *AngelFromHeaven* View Post
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
:)
01/26/2011 17:19 SaphiraGaming#32
Ty it works !
01/26/2011 22:10 SaphiraGaming#33
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
01/26/2011 22:26 ProfNerwosol#34
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.

[Only registered and activated users can see links. Click Here To Register...]
01/27/2011 17:37 Alladrios#35
#Updated, check the first post. Thank EC and Zargon for pointing out more infos on the skill.sdata recompiling.
01/27/2011 17:47 zargon05#36
Quote:
Originally Posted by Alladrios View Post
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
01/27/2011 17:56 SaphiraGaming#37
Quote:
Originally Posted by ProfNerwosol View Post
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.

[Only registered and activated users can see links. Click Here To Register...]

i dont understand that >.<
01/27/2011 18:04 zargon05#38
Quote:
Originally Posted by Alladrios View Post
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:
[Only registered and activated users can see links. Click Here To Register...]

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* View Post
i dont understand that >.<
Try this:
Code:
BULK
INSERT PS_GameDefs.dbo.ProductList
FROM 'c:\ProductList.import.csv'
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n'
)
GO
01/27/2011 18:08 SaphiraGaming#39
now this error


Nah sry it works forgot to delete first line in ProductList.import.csv
01/27/2011 18:11 zargon05#40
Something is wrong with your csv file, can you post your csv file.
01/27/2011 18:18 Alladrios#41
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
02/16/2011 18:22 Giammy#42
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)".
02/16/2011 18:48 Alladrios#43
Open your productlist.csv with any text editor and remove the first line. Thnen save and import.
02/16/2011 20:43 [GM]Father#44
What is this?

Quote:
Originally Posted by Giammy View Post
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)".
02/16/2011 21:09 Giammy#45
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 :)
Page 3 of 4 12 3 4