Dueño del Castillo
Error al conectar con la base de datos: SQLSTATE[HY000]: General error: 20018 Invalid object name 'MuOnline.dbo.MuCastle_DATA'. [20018] (severity 16) [
SELECT TOP (1) [OWNER_GUILD]
FROM [MuOnline].[dbo].[MuCastle_DATA]
]
Mayores asesinatos
Error al conectar con la base de datos: SQLSTATE[HY000]: General error: 20018 Invalid object name 'MuOnline.dbo.C_PlayerKiller_Info'. [20018] (severity 16) [
SELECT
k.Killer,
COUNT(k.Killer) AS Asesinatos
FROM
MuOnline.dbo.C_PlayerKiller_Info k
WHERE
k.ServerCode = 14
AND k.KillDate >= '1990-01-01 18:00:00'
AND k.KillDate < '2200-01-01 19:00:00'
AND DATEPART(WEEKDAY, k.KillDate) = 1 -- Lunes es 1, Domingo es 7 si configuración en el servidor está en inglés
AND CONVERT(TIME, k.KillDate) BETWEEN '18:00:00' AND '19:00:00' -- Asegura que esté entre las 18:00 y las 19:00
GROUP BY
k.Killer
ORDER BY
Asesinatos DESC;
]
Historial de batallas ganadas
Error al conectar con la base de datos: SQLSTATE[HY000]: General error: 20018 Invalid object name 'MuOnline.dbo.MuCastle_SIEGE_GUILDLIST_History'. [20018] (severity 16) [
SELECT TOP (1000) [GUILD_OWNER], [Date]
FROM [MuOnline].[dbo].[MuCastle_SIEGE_GUILDLIST_History]
ORDER BY [Date] DESC
]