All Skills Free?

[GuXz]

Hi for my soon server I want put all free skill (gold, book, sp)

 

I dont have find guide for this in ep2/ep3

 

Do you know how to make ?

 

Sry for bad english thanks

[DrGenius]

run this querry on newproject_data

 

UPDATE t_skillLevel SET a_needItemIndex1 = "-1";
UPDATE t_skillLevel SET a_needItemCount1 = "0";
UPDATE t_skillLevel SET a_needItemIndex2 = "-1";
UPDATE t_skillLevel SET a_needItemCount2 = "0";
UPDATE t_skillLevel SET a_learnSP = "0";
UPDATE t_skillLevel SET a_learnItemIndex1 = "-1";
UPDATE t_skillLevel SET a_learnItemCount1 = "0";
UPDATE t_skillLevel SET a_learnItemIndex2 = "-1";
UPDATE t_skillLevel SET a_learnItemCount2 = "0";
UPDATE t_skillLevel SET a_learnItemIndex3 = "-1";
UPDATE t_skillLevel SET a_learnItemCount3 = "0";
 

 

[GuXz]

Thanks, what is removed with this querry ? SP only or gold/book too

 

And if its not, post in ep2 post-it query, its search by many pepole

[Nymphetamine]

The query he gave u removes also items (skill book,gold etc.)

[GuXz]

Ok lol

 

My poor english :/ I need to learn yet years in game lol

 

Thanks. (y)

[LikeToMove]

Moved to solved section

[Johnny5]

Topic Closed by a moderator. The reason why: Answered