Community AlphaAlpha MUADMINS
FILFilipino
Mag-sign in
Sa MuADMINSConfig ScannerI-upload ang zip ng mga file mo: rate, drop, spot, limitBuksanSa MuADMINSMakipagkita sa amin sa DiscordHumingi ng tulong, ibahagi ang ginagawa mo at makipag-usap tungkol sa MU sa ibang may-ari ng server.Buksan
← Lahat ng solusyon
WebsiteX-TeamS2, S17

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

Isinulat ng MuADMINS mula sa sourceNot 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.

Isinulat ng MuADMINS
Nakatulong ba ito?

Naipit pa rin? Maghanap sa MuGPS Magtanong sa MU Assistant

MuADMINS Community Alpha: libre, gawa ng komunidad, at patuloy na dine-develop.