HELP my skills are bugged

[xell_llex1985]

well my server is up and running how ever the skills of some character jobs are bugged how ever the first created characters are not bugged. i mean its like this all first slot characters are not bugged but 2nd up to the last slots have all magic skills bugged.

[MentaL]

[Yamachi]

Looks like you've screwed with your character templates.

[xell_llex1985]

the what character templates???? in my sql or in my centos server?

[chumpywumpy]

The char templates are in your database. These contain the default stats, skills, equips etc that new chars are given and whichever template you are using is broken. See the guide in my sig and check your templates. Use the query below to change the template used (change @template for the number to change to):

update cabal_newflagdata_table
set chardataidx=@template,etcdataidx=@template

If you have default templates they should have these values:

1 = normal
2 = lev99 - Shineguard, face kets, rename card, x-gen card, a.master
3 = lev125 - Mithril, face kets, rename card, x-gen card, g.master
4 = 99 - Shineguard, nothing else, novice
5 = 125 - Mithril, nothing else, novice
6 = 99 - shineguard, nothing else, a.master
7 = 125 - Mithril, nothing else, a.master
8 = 150 - Mithril, nothing else, completer

[xell_llex1985]

uhhhh now about the default template sorry for so being noobish but i think i messed that up also, i tried to follow your TUT on how to auto add premium.. in one of your post and i accidentally change one of the tables on cabal_newflagdata_table, i was browsing the tables and for got to close that... umm can i still revert all my database to before wiping all that is in there and returning it from the start??

edit:
I follow your query updating now all newly created characters even on slot 1 are bugged T_T huhuhuhuhuhuhuh

p.s
wahehehe solve it already yehey thanx to chumpys tut hehehe rather than using update cabal_newflagdata_table
set chardataidx=1,etcdataidx=1 i chose template 10 it seems i messed up the tables on template 1 hahahhahahaha