DB:Auth:autobroadcast 548

Back to auth database list of tables.

The `autobroadcast` table

This table contains the autobroadcast entries for your realms. Values like it's activity, position and Timer (*.On, *.Center, *.Timer) are defined within the worldserver.conf. They are chosen randomly, based on their weight.

Structure

Field	Type	Attributes	Key	Null	Default	Extra	Comment
realmid	int			NO	-1
id	tinyint	unsigned		NO		AUTO_INCREMENT
weight	tinyint	unsigned			1
text	longtext	unsigned		NO

DB Structure

CREATE TABLE `sf_auth`.`Untitled`  (
  `realmid` int NOT NULL DEFAULT -1,
  `id` tinyint UNSIGNED NOT NULL AUTO_INCREMENT,
  `weight` tinyint UNSIGNED NULL DEFAULT 1,
  `text` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`, `realmid`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

Description of the fields

realmid

The realmlist.id. Defines which realm this entry belongs to. Use -1 for all realms to load this entry.

id

Unique identifier key per realm. Entries with same id will override each other without warnings - this can be used to replace -1 realmid entry on a specific realm.

weight

A non-negative integer. Entries with higher weight have more chance to get picked.

text

The text to broadcast. Color and item/spell/quest link formating codes can be used.