Main Page: Difference between revisions
mNo edit summary |
No edit summary |
||
| Line 25: | Line 25: | ||
== [[Server Linkshell Chat]] == | == [[Server Linkshell Chat]] == | ||
SELECT accounts_sessions.accid, accounts_sessions.charid, chars.charname, chars.pos_zone, zone_settings.name | |||
FROM accounts_sessions | |||
ORDER BY accounts_sessions.charid; | |||
== Who's Online == | |||
{{#get_db_data: | {{#get_db_data: | ||
db=MediaWiki | db=MediaWiki | ||
|from= | |from=accounts_sessions, chars, zone_settings | ||
|where= | |where=accounts_sessions.charid = chars.charid | ||
AND | AND chars.pos_zone = zone_settings.zoneid | ||
|order by=charname | |||
|order by= | |||
|data= | |data= | ||
Result1= | Result1=accid, Result2=charid, Result3=charname, Result4=zoneid, Result5=zonename | ||
}} | }} | ||
| Line 44: | Line 48: | ||
{{!}} {{{Result2}}} | {{!}} {{{Result2}}} | ||
{{!}} {{{Result3}}} | {{!}} {{{Result3}}} | ||
{{!}} {{{Result4}}} | |||
{{!}} {{{Result5}}} | |||
}} | }} | ||
|} | |} | ||
{{#clear_external_data:}} | {{#clear_external_data:}} | ||
Revision as of 21:50, 8 August 2023
Welcome to the FFXI-Caldera Wikipedia!
Caldera is a Final Fantasy XI (FFXI) 99+ private server which focuses on delivering endgame content with functionality for all jobs.
The primary goal of the server is to provide complex, enjoyable, teamwork based encounters to groups of players without the typical grind associated with retail FFXI.
| IP Address | ffxicaldera.myddns.me --hairpin |
| Discord | https://discord.gg/5X9ZFsn |
New players please read this guide:
SELECT accounts_sessions.accid, accounts_sessions.charid, chars.charname, chars.pos_zone, zone_settings.name FROM accounts_sessions ORDER BY accounts_sessions.charid;
Who's Online
The query SELECT accid,charid,charname,zoneid,zonename FROM `accounts_sessions`,`chars`,`zone_settings` WHERE accounts_sessions.charid = chars.charid AND chars.pos_zone = zone_settings.zoneid ORDER BY charname is invalid (Error 1052: Column 'accid' in field list is ambiguous Function: EDConnectorRdbms::fetch Query: SELECT accid,charid,charname,zoneid,zonename FROM `accounts_sessions`,`chars`,`zone_settings` WHERE accounts_sessions.charid = chars.charid AND chars.pos_zone = zone_settings.zoneid ORDER BY charname ).
| Date/Time | Player | Message |
|---|