Informações
Webshop
Enquete
Staff
select * from mw_config
2.41msselect count(1)
from mw_helpdesk_tickets
where status = 1
2.48msselect count(1)
from mw_helpdesk_tickets
where status = 2
1.19msselect count(1)
from mw_helpdesk_tickets
where status = 3
1.21msselect
ac.GameIDC as character,
ms.IP as ip,
ms.memb___id as account,
ms.ConnectStat as connect_stat,
c.MapNumber as map,
c.MapPosX as x,
c.MapPosY as y,
c.Class as character_class,
ms.ServerName as server_name,
(select top 1 AccountLevel from MEMB_INFO where memb___id = c.AccountID) as vipType,
ms.ConnectTM as connected_at,
ms.DisConnectTM as disconnected_at,
gm.G_Name as guild
from MEMB_STAT ms
join AccountCharacter ac ON ms.memb___id = ac.Id collate DATABASE_DEFAULT
join Character c ON ms.memb___id = c.AccountID collate DATABASE_DEFAULT
left join GuildMember gm ON c.Name = gm.Name collate DATABASE_DEFAULT
where ms.ConnectStat > 0
and ac.GameIDC = c.Name
order by ConnectTM desc
12.37msParams | |
---|---|
0 | null |
select
count(1) as total from MEMB_INFO
1.38msselect
count(1) as total
from Character
1.66msSELECT
COUNT(1) AS total FROM Guild
1.76msselect top 5 i.*
, s.coin
, c.slug as category_slug
, s.slug as shop_slug
from mw_shop_items i
join mw_shop_categories c on c.id = i.category_id
join mw_shops s on s.id = c.shop_id
where i.offer = 1
and i.shop_item_id is null
order by i.solds desc
6.52msselect *
from mw_polls
where active = 1
and convert(date, getdate()) >= start_date
and (end_date is null or convert(date, getdate()) <= end_date)
order by id desc
1.68msselect
c.Name as name,
c.Class as class,
c.CtlCode as code,
case when s.ConnectStat > 0 and ac.GameIDC = c.Name then 1 else 0 end as status
from MEMB_STAT s
join AccountCharacter ac on s.memb___id = ac.Id collate DATABASE_DEFAULT
join Character c on s.memb___id = c.AccountID collate DATABASE_DEFAULT
where c.CtlCode > 7
2.43msselect *
from mw_slides
where active = 1
and type = ?
order by sequence
1.71msParams | |
---|---|
0 | modal |