| Query: | SELECT count(*) as player_online FROM players WHERE online = 1 |
| SQLSTATE: | 00000 |
| Driver code: | |
| Error message: |
| Query: | SELECT count(broadcasting) as broadcasting FROM players WHERE broadcasting = 1 |
| SQLSTATE: | 00000 |
| Driver code: | |
| Error message: |
| Query: | SELECT count(viewers) as viewers FROM players WHERE viewers >= 1 |
| SQLSTATE: | 00000 |
| Driver code: | |
| Error message: |
|
|
|
|
Currently This Server is the only with a unique system of broadcasting game in the current time. System is based on an official TibiaCast.
You can enter a live stream by login into the game without entering any account number and password. Just don't write anything in those 2 fields and just press enter. A list of all available casts will appear shortly and you choose the one you would like to watch. After login into the cast, you can talk with other audiences and a person that is broadcasting.
To make your own broadcast, you must login to your account and use a command /cast on.
Full command list can be found below.
Currently available commands for spectators:
/show - display the amount of currently active spectators
/name - change your name on chat with player and other spectators
/auth - authenticate to an exisiting cast (required with chat proctetion)
Available commands for streaming players:
/cast on - enables the stream
/cast off - disables the stream
/cast password {password} - sets a password on the stream
/cast password off - disables the password protection
/cast auth on - enables requirement of authentication on chat
/cast auth off - disables requirement of authentication on chat
/cast kick {name} - kick a spectator from your stream
/cast ban {name} - locks spectator IP from joining your stream
/cast unban {name} - removes banishment lock
/cast bans - shows banished spectators list
/cast mute {name} - mutes selected spectator from chat
/cast unmute {name} - removes mute
/cast mutes - shows muted spectators list
/cast show - displays the amount and nicknames of current spectators
/cast status - displays stream status
| Query: | SELECT name,level,vocation,promotion,viewers, looktype, lookbody, looklegs, lookhead, lookfeet, lookaddons FROM players WHERE world_id=0 AND broadcasting=1 ORDER BY name asc |
| SQLSTATE: | 00000 |
| Driver code: | |
| Error message: |
| Query: | SELECT `value` FROM `global_storage` WHERE `key` = 12384 |
| SQLSTATE: | 00000 |
| Driver code: | |
| Error message: |
| Query: | SELECT `value` FROM `global_storage` WHERE `key` = 12381 |
| SQLSTATE: | 00000 |
| Driver code: | |
| Error message: |
| Query: | SELECT `value` FROM `global_storage` WHERE `key` = 12382 |
| SQLSTATE: | 00000 |
| Driver code: | |
| Error message: |
| Query: | SELECT `value` FROM `global_storage` WHERE `key` = 12383 |
| SQLSTATE: | 00000 |
| Driver code: | |
| Error message: |
| Query: | SELECT * FROM players WHERE deleted = 0 AND group_id >= 1 AND group_id != 4 AND group_id != 5 AND group_id != 6 AND account_id != 1 AND id > 7 AND level < 1200 ORDER BY experience DESC LIMIT 5 |
| SQLSTATE: | 00000 |
| Driver code: | |
| Error message: |
| Query: | SELECT * FROM guild_ranks WHERE id = 0 |
| SQLSTATE: | 00000 |
| Driver code: | |
| Error message: |
| Query: | SELECT `id`, `world_id`, `name`, `ownerid`, `checkdata`, `creationdata`, `motd`, `description`, `create_ip`, `guild_logo` FROM `guilds` WHERE `id` = '' |
| SQLSTATE: | 00000 |
| Driver code: | |
| Error message: |
|
- Mixtrix
56, Sorcerer
|
| Query: | SELECT * FROM guild_ranks WHERE id = 0 |
| SQLSTATE: | 00000 |
| Driver code: | |
| Error message: |
| Query: | SELECT `id`, `world_id`, `name`, `ownerid`, `checkdata`, `creationdata`, `motd`, `description`, `create_ip`, `guild_logo` FROM `guilds` WHERE `id` = '' |
| SQLSTATE: | 00000 |
| Driver code: | |
| Error message: |
|
- Power ranger
8, Paladin
|
| Query: | SELECT * FROM guild_ranks WHERE id = 0 |
| SQLSTATE: | 00000 |
| Driver code: | |
| Error message: |
| Query: | SELECT `id`, `world_id`, `name`, `ownerid`, `checkdata`, `creationdata`, `motd`, `description`, `create_ip`, `guild_logo` FROM `guilds` WHERE `id` = '' |
| SQLSTATE: | 00000 |
| Driver code: | |
| Error message: |
|
- Power loco
8, Knight
|
| Query: | SELECT * FROM guild_ranks WHERE id = 0 |
| SQLSTATE: | 00000 |
| Driver code: | |
| Error message: |
| Query: | SELECT `id`, `world_id`, `name`, `ownerid`, `checkdata`, `creationdata`, `motd`, `description`, `create_ip`, `guild_logo` FROM `guilds` WHERE `id` = '' |
| SQLSTATE: | 00000 |
| Driver code: | |
| Error message: |
|
4 - Combo Um
8, Druid
|
| Query: | SELECT * FROM guild_ranks WHERE id = 0 |
| SQLSTATE: | 00000 |
| Driver code: | |
| Error message: |
| Query: | SELECT `id`, `world_id`, `name`, `ownerid`, `checkdata`, `creationdata`, `motd`, `description`, `create_ip`, `guild_logo` FROM `guilds` WHERE `id` = '' |
| SQLSTATE: | 00000 |
| Driver code: | |
| Error message: |
|
5 - Combo Dois
8, Druid
|
| Query: | SELECT `guild_id` FROM `castle48h_config` |
| SQLSTATE: | 42S02 |
| Driver code: | 1146 |
| Error message: | Table 'bancohells.castle48h_config' doesn't exist |
