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

Page 4 of 4 « First 23 4
02/16/2011 21:18 Alladrios#46
Re make your file then and run MSSQL as admin while trying to import or remove UAC.
02/16/2011 21:26 Giammy#47
I've already made it but i'll try another one time, ty man
02/16/2011 21:50 Giammy#48
Nothig i still get the same error

check please <.<



[Only registered and activated users can see links. Click Here To Register...]
02/16/2011 22:00 Alladrios#49
You are trying to insert into the item table.

use this code:
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.
03/12/2011 11:56 kalle801#50
hmm, how do i make an .mdf file to .csv?
03/19/2011 17:44 Shaiyaadict#51
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 .. )
03/19/2011 19:06 zargon05#52
Quote:
Originally Posted by Shaiyaadict View Post
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.
03/19/2011 23:46 Shaiyaadict#53
Quote:
Originally Posted by zargon05 View Post
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 : [Only registered and activated users can see links. Click Here To Register...]


but still disconnected :/ ... can change everything except this stupid Item Mall :/ ...
03/20/2011 04:18 zargon05#54
[Only registered and activated users can see links. Click Here To Register...]
03/20/2011 04:59 Shaiyaadict#55
Quote:
Originally Posted by zargon05 View Post
[Only registered and activated users can see links. Click Here To Register...]
oo yeah , forget to put it too lol ;..


try it and still disconnected
03/27/2011 23:17 remnikalija#56
where can i get the edited Skill.SData
04/03/2011 19:33 SrShaden#57
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?
04/07/2011 02:09 SrShaden#58
# 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?
11/06/2011 01:36 flared ego#59
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.
01/13/2012 02:34 _Diavolino_#60
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
Page 4 of 4 « First 23 4