Community AlphaAlpha MUADMINS
DEDeutsch
Anmelden
Auf MuADMINSConfig ScannerZip deiner Dateien hochladen: Rates, Drops, Spots, LimitsÖffnenAuf MuADMINSTriff uns auf DiscordFrag nach Hilfe, zeig, woran du arbeitest, und sprich mit anderen Serverbetreibern über MU.Öffnen
← Alle Lösungen
WebsiteX-TeamS2, S17

WebEngine with X-Team files: online ranking fails with Invalid column name 'OnlineHours'

Von MuADMINS anhand der Quelle geschriebenNot verified

WebEngine's map for X-Team files (includes\config\xteam.tables.php) defines _CLMN_MS_ONLINEHRS_ = OnlineHours, and the online ranking (only for xteam files) runs:

SELECT TOP n memb___id, OnlineHours FROM MEMB_STAT WHERE OnlineHours > 0 ORDER BY OnlineHours DESC

The X-Team Season 2 and Season 17 scripts create MEMB_STAT without OnlineHours (memb___id, ConnectStat, ServerName, IP, ConnectTM, DisConnectTM). MuDevs has it (OnlineHours int DEFAULT 0).

Fix, pick one:

  1. Turn the online ranking off in the WebEngine rankings settings (rankings_enable_online).
  2. Or add the column (additive, backup first):
IF COL_LENGTH('dbo.MEMB_STAT', 'OnlineHours') IS NULL
  ALTER TABLE dbo.MEMB_STAT ADD OnlineHours int NOT NULL DEFAULT 0;

The X-Team procedures do not fill it, so the ranking stays empty until something counts the hours.

Source: WebEngine 1.2.7 includes/config/xteam.tables.php and includes/classes/class.rankings.php (_onlineRanking, _getOnlineRankingDataMembStatHours); X-Team S2 and S17 DB/MuOnline.sql; MuDevs S18 MuOnline DB Create Script.sql.

Von MuADMINS geschrieben
Hat das geholfen?

Kommst du immer noch nicht weiter? MuGPS durchsuchen Frag den MU-Assistenten

MuADMINS Community Alpha: kostenlos, von der Community gemacht, in aktiver Entwicklung.