Community AlphaAlpha MUADMINS
RORomână
Autentificare
Pe MuADMINSConfig ScannerÎncarcă zip-ul fișierelor tale: rate-uri, drop-uri, spoturi, limiteDeschidePe MuADMINSÎntâlnește-ne pe DiscordCere ajutor, arată la ce lucrezi și vorbește despre MU cu alți proprietari de servere.Deschide
← Toate soluțiile
SiteX-TeamS2, S17

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

Scris de MuADMINS pe baza surseiNot 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.

Scris de MuADMINS
Te-a ajutat?

Tot nu merge? Caută în MuGPS Întreabă Asistentul MU

MuADMINS Community Alpha: gratuit, făcut de comunitate, în dezvoltare activă.