Autobroadcast.

[Verosk]

how do i make an autobroadcast? Basically im new to the DB and need help creating an autobroadcast anyone have an easy way to do it? couldnt find any forum on this, if there is please direct me!

Thanks.

[Jinfreakz]

First.... FAQ
Q: What is a World Broadcast?
A: An announcement that is announced to everyone in-game.

Q: Wouldn't just be better to do .ann?
A: No, because how will you spread the news if your not online?

Q: What are the benefits?
A: Tell the players of your server what's going on and alert them warnings.


Second...... How to enable this feature

Go to your arcemu-optional.conf and change the following things:

1. <CommonSchedule AutoBroadCast = "1"
change it from 0 to 1

#    AutoBroadCast (MultiLanguages supported)
#      Enable/Disable new broadcast system.(cebernic: blizzlike )
#      Default: 0(Disable) 1(Enable)
#
#    BroadCastInterval
#      Contents sending on interval by second
#      Default:(Min:10 Max:1440)
#
#    BroadCastTriggerPercentCap
#      Setup the cap of chance in condition with contents sending in each BroadCastInterval's value
#      Notice: OP can setup any of message's priority, this could be adjustment in field `percent` of table `worldbroadcast`
#      Default:99 (min:1 max:99, 99 only displaying message on priority 100 set.)
#      i.e : If set 50 ,it means all of messages 100% selected(but may not displayed) by higher than '50' priority with each broadcastinterval.
#      The total selected messages(>51 priority) chosen at random with send to all players.
#
#    BroadCastOrderMode [0-1]
#      0:RandomMode - By Triggering & Conditions 
#      1:SerialMode - [ignored both ->field `percent` from table `worldbroadcast` & TriggerPercentCap parameters.]
#      Default:0
#
#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#-#

<CommonSchedule AutoBroadCast = "1"
	BroadCastInterval = "10"
	BroadCastTriggerPercentCap = "2"
	BroadCastOrderMode = "0">

Here are the steps to making a world broadcast

1. First open up your database and click on world.

2. Next, inside the world database, go to your world_broadcasts table.

3. Now click on the data tab.

4. The first table will say "entry" this means the id of the announcement. I'd put a 1 there.

5. Next is the easy part. Under the "text" table, you put the announcement you want.

6. Last is the "percent' table. This determines how often the messege is announced. If I were you, I'd put 20 or 30


And there you go, you repeat these steps if you want more than one broadcast! Only, make the entry id's go up by 1.
Hope this helped you n00bs who do not know how to do this

*Credits to Double from ******* (another forum).

*I didn't write this, I just searched this up on google, found the answer, and gave it to you

[Verosk]

thanks but im very new to the db and really have no idea on how to do this.. i understood all the enter id etc.. just dont get the script D;

[gillisrofl]

thanks but im very new to the db and really have no idea on how to do this.. i understood all the enter id etc.. just dont get the script D;

Script ?

Well anyhow... if you meant the code, you will find that inside your configs folder where you have your config files. That code is a copy of the text inside the arcemu-optional.conf file. As the quote says you have to change a bit of the text inside that from
<CommonSchedule AutoBroadCast = "0"

to

<CommonSchedule AutoBroadCast = "1"

If you meant the Database, I can try explaining a bit easier here.
I believe that you have a program such as SQLyog or HediSQL to view your database right? In that case, simply go in there and look to the left. You will have a couple of databases there... probably around 4,5 or 6 (There should probably be three databases named "mysql", "test" and "information_schema". Just so you know where we are).
Find the database named "world" or something in that name. Otherwise, there is a way to recognize the world database. Simply double-click the Database in order to open it. It will display some folders under it:

"Tables"
"Views"
"Stored procs"
"Functions"
"Triggers"
"Events"

Once again, double click on the folder named "Tables" in order to get a big list of tables. Here you can confirm if this is your world database by either counting the number of tables which should be more than 30-40 tables. Or you could start looking for a table named "world_broadcasts" (Sometimes I experienced missing this table. If that's the same case with you, look at the bottom of my reply). Thankfully, all the tables are lined up in alfabetic order so you should find it somewhere at the end.
Now click that table (world_broadcasts) once. You should get a kind of an chart with.. not so many entries as for this table ^^ (If you don't get a chart, find a button called "3 Table data", and click it. It should now display... at least in SQLyog).
Anyhow, the first row in that chart should say "Entry" over it. Click just below to make a new one, and fill in the entry number. Take a number that is not on that chart under "Entry". For example there could be an existing one with entry number 1. In that case write 2 on your new one.
Next, look for the next part of the chart that says "text". Under that you will write your announcement!
And as for the last part, look for yet another part named "percent". Here you will write how many times it will appear in percent... write 20 or 30.


*** If you can tell me what program you use to view your database, I could post pictures!
Also if you don't have the world_broadcasts table, you could try enter one. For example here:
http://www.mmowned.com/forums/world-...er-arcemu.html

Reply if you still don't get something!

[Verosk]

Ok, i get the last part about entry number and text, what i dont get is where my config files are, im not the server owner/host if this helps? im just basically trying to learn my around it, could you guide me to where i can find this config folder? Sorry for kinda wasting your time just want to learn.

Also if it helps im using Navicat.

[gillisrofl]

Ok, i get the last part about entry number and text, what i dont get is where my config files are, im not the server owner/host if this helps? im just basically trying to learn my around it, could you guide me to where i can find this config folder? Sorry for kinda wasting your time just want to learn.

Also if it helps im using Navicat.

I assume that you are using a repack. If that's the case, go to where you extracted your private server (the place you start it up) and in the main folder look for a map called "configs". Go into that folder, and in there you should have all your .conf files. You must open the one called arcemu-optional.conf and edit it as we told you ^^.
You can also try to search for arcemu-optional by clicking ctrl + F in the map!

And no your not wasting our time at all mate. It's up to people if they want to help or not and thus they choose to waist their time or not :>... as for me... I got nothing special to do and just want to support around here a little :P

[Verosk]

confuuuse:S sorry but i didnt extract nothing as i said im not the host/owner all i have to do with the server is the database and realmlist XD.

[gillisrofl]

confuuuse:S sorry but i didnt extract nothing as i said im not the host/owner all i have to do with the server is the database and realmlist XD.

Ooooh your not the host? lols . Well then you won't be able to find the config files of course. Ask the host/owner to edit them for you, and the rest you will be able to fix yourself!

[Verosk]

thanks and sorry i thought i said i wasnt the host or owner befor ehehe ^^ +rep