[RELEASE] GM Broadcast item

[pimpjuc]

Today im releasing a script to make a portable GM Broadcast item, I have just made this pretty basic to just give a basic usable idea for anyone to modify to suit there needs

cq_action:

INSERT INTO cq_action VALUES ('6400030', '6400031', '0000', '0101', '0', 'Welcome~%user_name~to~the~Events~GM~Tool.');
INSERT INTO cq_action VALUES ('6400031', '6400032', '0000', '0102', '0', 'Announce~Hurdle~Race~Start. 6400130');
INSERT INTO cq_action VALUES ('6400032', '6400033', '0000', '0102', '0', 'Announce~Mount~Race~Start. 6400131');
INSERT INTO cq_action VALUES ('6400033', '6400034', '0000', '0102', '0', 'Announce~LegionWar~Start. 6400132');
INSERT INTO cq_action VALUES ('6400034', '6400035', '0000', '0102', '0', 'Announce~PK~Tourney~Start. 6400133');
INSERT INTO cq_action VALUES ('6400035', '6400036', '0000', '0102', '0', 'Announce~FamilyWar~Start. 6400134');
INSERT INTO cq_action VALUES ('6400036', '6400037', '0000', '0102', '0', 'Announce~DragonCave~Open. 6400135');
INSERT INTO cq_action VALUES ('6400037', '6400038', '0000', '0102', '0', 'Announce~Abyssal~Pallace~start. 6400136');
INSERT INTO cq_action VALUES ('6400038', '4000010', '0000', '0102', '0', 'Just~Checking. 0');

INSERT INTO cq_action VALUES ('6400130', '0000', '0000', '0125', '2011', 'Hurdle~Race~Starting~in~5~Minutes~head~to~Cronos~Teleporters!');
INSERT INTO cq_action VALUES ('6400131', '0000', '0000', '0125', '2011', 'Mount~Race~Starting~in~5~Minutes~head~to~Cronos~Teleporters!');
INSERT INTO cq_action VALUES ('6400132', '0000', '0000', '0125', '2011', 'Legion~War~Starting~in~5~Minutes~head~to~Cronos~Teleporters!');
INSERT INTO cq_action VALUES ('6400133', '0000', '0000', '0125', '2011', 'PK~War~Starting~in~5~Minutes~head~to~Cronos~Teleporters!');
INSERT INTO cq_action VALUES ('6400134', '0000', '0000', '0125', '2011', 'Family~War~Starting~in~5~Minutes~head~to~your~Teleporters!');
INSERT INTO cq_action VALUES ('6400135', '0000', '0000', '0125', '2011', 'Dragon~Cave~Starting~in~5~Minutes~head~to~the~Teleporters!');
INSERT INTO cq_action VALUES ('6400136', '0000', '0000', '0125', '2011', 'Abyssal~Pallace~Starting~in~5~Minutes~head~to~Cronos~Teleporters!');

cq_task:

INSERT INTO cq_task VALUES ('6400030', '6400030', '0000', '', '', '0', '0', '999', '-100000', '100000', '0999', '0000', '0', '-1', '0');

Explanation:
Firstly I haven't included the item itself in this release the Portable Side of the item is based on the same idea as cyberghoser1's portable NPC(so search that thread to learn how to build the item) i just used a pre-existing item with no use(saves time :P)and changed its name and 'action id' client and Db side.

The First section of action is simply a normal NPC so most of us can make that easy enough Now the second half is all the [GM] messages to be sent,
as explained by magewarrior in previous threads type=125 and data=2011 combined in cq_action produce a [GM] message from the param column
so you can broadcast messages to all in the game.
you can use an update script like this to change what you want

Hurdle race = UPDATE cq_action SET param='whatever~you~want~here' WHERE id=6400130;

Mount race = UPDATE cq_action SET param='whatever~you~want~here' WHERE id=6400130;

Legion War = UPDATE cq_action SET param='whatever~you~want~here' WHERE id=6400130;

PK War = UPDATE cq_action SET param='whatever~you~want~here' WHERE id=6400130;

Family War = UPDATE cq_action SET param='whatever~you~want~here' WHERE id=6400130;

Dragon Cave = UPDATE cq_action SET param='whatever~you~want~here' WHERE id=6400130;

Abyssal Palace = UPDATE cq_action SET param='whatever~you~want~here' WHERE id=6400130;

Im also working on another type the script to get it that far is attached if anyone has any ideas on making it work it would be appreciated
Hope yo'all like

[~Sword~Stalker~.]

nice one

[dungeonmaster]

Very nice dude thanks!

[magewarior2]

Nice release!

i did complete your work