DB:Auth:autobroadcast 548: Difference between revisions
(Created page with "placeholder") |
(Final) |
||
Line 1: | Line 1: | ||
{| align="right" | |||
|- | |||
| __TOC__ | |||
|} | |||
{{Back-to:Auth_18414}} | |||
<big>'''The `autobroadcast` table'''</big> | |||
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. | |||
<big>'''Structure'''</big> | |||
{| border="1" | |||
|'''Field''' | |||
|'''Type''' | |||
|'''Attributes''' | |||
|'''Key''' | |||
|'''Null''' | |||
|'''Default''' | |||
|'''Extra''' | |||
|'''Comment''' | |||
|- | |||
|[[#realmid|realmid]] | |||
|int | |||
| | |||
| | |||
|NO | |||
|<nowiki>-1</nowiki> | |||
| | |||
| | |||
|- | |||
|[[#id|id]] | |||
|tinyint | |||
|unsigned | |||
| | |||
|NO | |||
| | |||
|AUTO_INCREMENT | |||
| | |||
|- | |||
|[[#weight|weight]] | |||
|tinyint | |||
|unsigned | |||
| | |||
| | |||
| 1 | |||
| | |||
| | |||
|- | |||
|[[#text|text]] | |||
|longtext | |||
|unsigned | |||
| | |||
|NO | |||
| | |||
| | |||
| | |||
|} | |||
<br> <big>'''DB Structure'''</big> | |||
<br> | |||
{| border="1"<br> | |||
<pre style="color: red"> | |||
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; | |||
</pre> | |||
<big>'''Description of the fields'''</big> | |||
==== 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. |
Latest revision as of 21:14, 2 August 2023
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.