SQL Autoannouncer for Arcemu

[xX EPIC Xx]

Hello all i just figgured out how to make a auto announcer with SQL and i want to share it with all on MMOWNED.

THIS SQL ANNOUNCER ONLY WORKS ON ARCEMU

STEP 1) Download this
_____________________________
By click on "i agree" you agree to not
copy my release and not flame me if
it's some error in it. The password is
colamancool
_____________________________
I AGREE I DON'T AGREE
_____________________________

when you've downloaded it unzip it.

STEP 2) Run the sql into your world database

STEP 3) go to your Arcemu
and open Configs/arcemu-optional.conf

search for:
<CommonSchedule AutoBroadCast = "0"

and edit all to this

<CommonSchedule AutoBroadCast = "1" //1 to enable and 0 to disable
BroadCastInterval = "1440" //interval by second
BroadCastTriggerPercentCap = "2"
BroadCastOrderMode = "0">

STEP 4) open your SQL and then search for worldbroadcast

open the table and write your announce. For Exemple

Entry_____Text______Percent
1 This anouncer Pwns! 20

restart server and you're done!
now it will announce every 100 secound

to change the interval go to arcemu-optional.conf and
change the red

BroadCastInterval = "1440"

to any thing between 10-1440

[fresh]

doesnt sound to bad but there everywere on here

[EmiloZ]

Nice release, +Rep

[xX EPIC Xx]

what is everywere here?

EDIT: Ty!

[Flake0207]

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*/
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ANSI';*/
/*!40014 SET @OLD' at line 1
[Err] #################################
#                               #
#                               #
#  This was made by colamancool #
#         on MMOWNED.com        #
#                               #
#################################

/*!40100 SET CHARACTER SET latin1;*/
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ANSI';*/
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;*/


#
# Table structure for table 'worldbroadcast'
#

CREATE TABLE /*!32312 IF NOT EXISTS*/ "worldbroadcast" (
  "entry" int(11) unsigned NOT NULL auto_increment,
  "text" varchar(255) NOT NULL,
  "percent" int(3) NOT NULL default '100',
  PRIMARY KEY  ("entry")
) AUTO_INCREMENT=31 /*!40100 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci*/;
[Msg] Finished - Unsuccessfully
--------------------------------------------------

??

[xanderpk]

Ur sql sucks - 100

[Link_S]

The last post here were posted two years ago.. Necro posting! :O