Add new Column to Creature and Gameobject Spawn DB

[tagala]

*i am using hearthstone core(no idea if this makes a difference)
I am running an all GM private server and to help prevent or undo spammers, i was hoping to add a column to the Database to see who spawned these things and delete them with one simple query (delete from `gameobject_spawns` where spawner = "Tagala") or something like that

i added the columns and everything boots up correctly but now im having trouble changing the c++ code, i have no idea what im doin with c++ to save my life. i had some experience with it in high school but not much.

anyway, i was able to find where it put the query into the database for the gameobjects but have no idea what to change, someone pls help!

[Link_S]

I got into this when I wrote a Phasing system some months ago also. Google is your best friend!
Anyway, here's the answer

ALTER TABLE table_name ADD COLUMN column_name column_type

Example, this code adds the column 'screw' wich holds an UNSIGNED INT(10) into the characters table.

ALTER TABLE characters ADD COLUMN screw UNSIGNED INT(10);

Don't forget to add the column to all load/save events that occur using that table.

[tagala]

as i already mentioned, i only need to change the c++ code, i already added the columns but thanks anyway

[Sorayazlawl]

PM/MSN/AIM me. I'll be able to help ya out

EDIT: Posting link for searchers: http://www.mmowned.com/forums/reques...ml#post1655281

[tagala]

thanks for the help! +Rep