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

[Alladrios]

Re make your file then and run MSSQL as admin while trying to import or remove UAC.

[Giammy]

I've already made it but i'll try another one time, ty man

[Giammy]

Nothig i still get the same error

check please <.<

[Alladrios]

You are trying to insert into the item table.

use this code:

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

#Edit: my bad i didnt see you were trying to import another table than productlist.
I never tried importing a whole item table through this command and i wouldnt recommend it. Refer to Profnerwosol advise a few posts before.

[kalle801]

hmm, how do i make an .mdf file to .csv?

[Shaiyaadict]

can someone explain me why i get a "Disconnected" when i buy a Item in the Item Mall ?? ... I change it in the Sdata and Import it in de Productlist ... but still a disconnected when i buy it ( after clicking "ok" for purchase .. )

[zargon05]

Originally Posted by Shaiyaadict

can someone explain me why i get a "Disconnected" when i buy a Item in the Item Mall ?? ... I change it in the Sdata and Import it in de Productlist ... but still a disconnected when i buy it ( after clicking "ok" for purchase .. )

This is the wrong post, there is a another one about fixing the in-game item mall. Look there.

[Shaiyaadict]

Originally Posted by zargon05

This is the wrong post, there is a another one about fixing the in-game item mall. Look there.

Yes i know but they send me to this link , because there is some info about it ... i try it but witouth succes ...


I tried this methode ( this forum )

and this one :


but still disconnected :/ ... can change everything except this stupid Item Mall :/ ...

[zargon05]

[Shaiyaadict]

Originally Posted by zargon05

oo yeah , forget to put it too lol ;..


try it and still disconnected

[remnikalija]

where can i get the edited Skill.SData

[SrShaden]

I'm trying to get my skill.sdata to match the database to make the skill jump work cause I gave up on ps_game... but when I edit the skills I get this error when returning it to .sdata format.

skill_rows:3343
Traceback <most recent call last>:
File "src\SData.py", line 113, in <module>
main(sys.argv[1:])
File 'src\SData.py", line 102, in main
result = SDataItems[SDataName](outFmt)
File "C:\Python27\src\Skill.py", line 121, in MainSkill
return CombineSkill("Skill")
File "C:\Python27\src\Skill.py", line 154, in CombineSkill
pack_fields(fout, skill_type, i)
File "C:\Python27\src\Utils.py", line 67, in pack_fields
data = rec[ field[0]]
KeyError: `SkillName`
Press any key to continue . . .

Now I tried changing ==3 to ==9 that didn't work, I tried Zargon's quick fix... that doesn't work either, I use OpenOffice for csv so I tried using Hex editor and modify from there... but when I go in game skill still stops at 4 and i dont have the skill jump... and yes my database is edited and my skill.sdata is an ep5... any suggestions?

[SrShaden]

# Bump

I tried using another servers working skill.sdata that jumps... but then I get a dump file... I just dont get it... can someone give me a little help with this plz...

Am I missing something to match the database?... Do I only have to match the skill level ? like
Replacing:
1, 2, 3, 4, 5, 6, 7.
With:
1, 0, 2, 0, 0, 0, 3.

For all the skills... I must be missing something real simple... but i dont get the python error above... its happening a lot lately

EDIT: So I was using OpenOffice as usual, and finally figured out that it doesn't work with EP5 db i guess... I used notepad and I can edit the skill to match the database... but for some reason skill still doesn't jump, gamedef is the one from here, and I matched the skill.sdata. Any ideas?

[flared ego]

Edit.. file read error solved

Second the SAH file I am using is from US client and the rowID of each skill progressively gets off from the sql table, 400+ rows off by the bottom of the table. and causes a jumbled mess in the game skill graphics and making it impossible to learn the skills.
Now the issue is there is no simple way of fixing this from what i understand, In hopes that someone is feeling generous please any advice is much appreciated.

[_Diavolino_]

Hello
thx for this interesting release but same that i follow ur explications at letters, i get character load error!!! so i verify my encrypt decryp etc and stilll same pb...
I let decrypt and change the 2 numbers 74<-- 01... i let encrypt and same error and without i get sgraphic error ... an other pist to explore ? ideas? please thx thx

Maybe an other emplacement to change these 2 number ? ... 00 01