more info abou change item faction

[lolodh]

I use script fc in my test private server.
I can change class too.
But need info how possible chanege all items in account to new side?
Any script is possible make it right?
Any1 can give script auto change inventary and wh?
Or show mr imformation please and ty!!

[SnickQ]

[lolodh]

I have this errors.

Msg 911, Level 16, State 1, Line 1
Database 'GM_Stuff' does not exist. Make sure that the name is entered correctly.
Msg 207, Level 16, State 1, Procedure usp_FC, Line 81
Invalid column name 'Class'.

[sominus]

It says already, you missing a database in your server, and a column (a field) named 'Class', in your Chars table.

Try to read and learn what exactly the script is actually doing, because (even if it runs without errors), you could end up causing unwanted bugs with some items (not every server use the same Type/TypeID)

[Big_]

Database 'GM_Stuff' does not exist and Invalid column name 'Class' the error is saying you dont have the database GM_Stuff and you also done have the column Class

[lolodh]

ty! I think just understand!!
I need create script for me Data Base! and create column Class too.!
and write manual avery ID and typeID that I need change faction..right?

[SnickQ]

When you create new item u should add 1 TypeID for both faction
Example
16 35 -Light adamas helm
31 35 Dark adamas helm

Then just what you need is change Type

And for weap also
2 110 -Light 2 h weap
4 110 -Dark 2 H weap

Only for 3 type you need change TypeID for Type
5, 6 , 12
(Dual weap, spear and stuff have both faction)
So

6 1 -Light Sspear
6 2 -Dark Spear
Then

Set TypeID='1'
where Type='6' and TypeID='2'