Changing of Skills EP4/EP3||Reco-Stats removing

[Zoas]

I would like to change some Ep4 skills by exchanging the skill data from the EP4 client with the skill data from the EP3 client. And I would like to know if this is possible.

And is there a possibility to remove the Orange EP4 Stats, that they don't exist completely.

[Zoas]

Ok, seems like no one could help me, after some hours I found out how to change the reco/orange-stats.

So but I still don't know if there is a possibility to change skills from ep4 with old ep3 skills.

[Mithrandir.]

USE PS_GameData
UPDATE CharItems

SET Craftname = REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Column_Name, '20', '00''), '20', '00'') , '20', '00''), '20', '00''), '20', '00''), '20', '00''), '20', '00''), '20', '00''), '20', '00'')

This will set the Reroll Stats to 0 where the stats are 20

You can do this also with 19

USE PS_GameData
UPDATE CharItems

SET Craftname = REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Column_Name, '19', '00''), '19', '00'') , '19', '00''), '19', '00''), '19', '00''), '19', '00''), '19', '00''), '19', '00''), '19', '00'')

[Zoas]

Sorry, but I don't really get it, what do I change by using
SET Craftname = REPLACE
Using it as Update in PS-GAME data it doesn't worked.
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '<'.
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '='.
Msg 105, Level 15, State 1, Line 2
Unclosed quotation mark after the character string '00')
'.

Sorry bit confused working since 15 hours on server

[Mithrandir.]

Originally Posted by Zoas

Sorry, but I don't really get it, what do I change by using
SET Craftname = REPLACE
Using it as Update in PS-GAME data it doesn't worked.
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '<'.
Msg 102, Level 15, State 1, Line 2
Incorrect syntax near '='.
Msg 105, Level 15, State 1, Line 2
Unclosed quotation mark after the character string '00')
'.

Sorry bit confused working since 15 hours on server

Why you are using things like "<, >, =" if you don't know how to use this functions...

whats the max reroll on your server and which mssql version do you have?

[Zoas]

I try to learn by doing, I also read but like in physics, learning by doing is better.
However my maximal reroll is on [20] and i'm using Micrsoft SQL Management 2008 R2 RTM (x86)

But wait, I know that the numbers stand for Str, Dex, Rec, Int, Wis, Luc, HP, MP, SP, Lapisia.

So but now I want my Console to make me able to enchant, but I want no Orange-Stats.
I don't use SQl that long that I really know every step and, that i know everytime what i do, but shouldn't my Update should look like this?

SET Craftname = REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(Column_Name, '00', '-1''), '00', '-1'') , '00', '-1''), '00', '-1''), '00', '-1''), '00', '-1''), '00', '-1''), '00', '-1''), '00', '00'')

That you get a better idea of what i mean:

[Zoas]

Can sb. please give me a database.bak cause my backup's don't work and i made some mistakes, so nothing work like i want, my Orange stats are out now but i also can't enchant, i'm annoyed.