Augustomendes4426: Augustomendes4426 moved page DB:Auth:autobroadcast 548 to Autobroadcast 548: Removing prefix to match with world and to come characters wiki

2025-06-14T15:51:56Z

Augustomendes4426 moved page DB:Auth:autobroadcast 548 to Autobroadcast 548: Removing prefix to match with world and to come characters wiki

← Older revision	Revision as of 10:51, 14 June 2025
(No difference)

Admin: Final

2023-08-03T02:14:53Z

Final

← Older revision		Revision as of 21:14, 2 August 2023
Line 1:		Line 1:
	~~placeholder~~		{\| 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.

Admin: Created page with "placeholder"

2023-08-02T23:42:17Z

Created page with "placeholder"

New page

placeholder

Autobroadcast 548 - Revision history

Augustomendes4426: Augustomendes4426 moved page DB:Auth:autobroadcast 548 to Autobroadcast 548: Removing prefix to match with world and to come characters wiki

Admin: Final

Admin: Created page with "placeholder"