SQL copying

[solvent]

How can i copy 1 item in my SQL and Paste it ? like on the DB for a 1.9 ?

 

[solvent]

nm sorted that part any idea on how 2 make HalfMoon work on another class?

 

[andykid131]

As far as I'm aware, just change the field that chooses which class you need to be to have the spell, in TBL_MAGIC

 

[samhag]

Make a new row in TBL_MAGIC
FLD_ID ... must remain in sequence
FLD_MIMICID ...is the same as the original spell so if the warrior halfmoon is 25 the new spell must also have a value of 25
FLD_NAME ... whatever ya wanna call it

other values copy from original spell,

(FLD_JOB is the class, 0=warr 1=wizz 2=tao)

 

[solvent]

Make a new row in TBL_MAGIC
FLD_ID ... must remain in sequence
FLD_MIMICID ...is the same as the original spell so if the warrior halfmoon is 25 the new spell must also have a value of 25
FLD_NAME ... whatever ya wanna call it

other values copy from original spell,

(FLD_JOB is the class, 0=warr 1=wizz 2=tao)


iv done that, and my tao able to learn the spell, when i select wat key to use the spell i.e F1 it not allow the spell to work, dont even say "halfmoon enabled"

any idea's why this is ? >.<

 

[solvent]

any 1 ?

 

[akacary2]

Sorry 2 post cos i know its an old thread, just incase sum 1 else wants help

In my TBL_MAGIC i have:

56 25 TaoHalfMoon 0 23 0 0 0 3 0 0 2 45 5000 47 8000 50 14000 0 NULL

I also added the spell book in TBL_STDITEMS and wallah it works fine 4 me

TaoHalfMoon 4 2 1 0 0 0 1074 45 0 0 0 0 0 0 0 0 0 0 0 0 65000 5 NULL NULL NULL NULL NULL NULL NULL False 0 NULL True True True True True True True True NULL

The 1074 = book image in my db so ul need to change but all the other values should work fine
Hope this helps sum 1