DB:Auth:autobroadcast 548

From Project Skyfire
Jump to navigation Jump to search

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.