LaMO
21/04/2020, 08:53 PM
Query corrigida, a que tinha anteriormente no fórum estava com problemas!
Atenção: Sempre faça um BACKUP antes de rodar uma query que não conhece.
Use Muonline
Go
[Only registered and activated users can see links]
[Only registered and activated users can see links]
DECLARE LISTA CURSOR LOCAL FOR
SELECT distinct(IP) FROM memb_stat where connectstat=1
OPEN LISTA
[Only registered and activated users can see links]
[Only registered and activated users can see links]
begin
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
end
CLOSE LISTA
DEALLOCATE LISTA
[Only registered and activated users can see links]
Créditos: russo1
Atenção: Sempre faça um BACKUP antes de rodar uma query que não conhece.
Use Muonline
Go
[Only registered and activated users can see links]
[Only registered and activated users can see links]
DECLARE LISTA CURSOR LOCAL FOR
SELECT distinct(IP) FROM memb_stat where connectstat=1
OPEN LISTA
[Only registered and activated users can see links]
[Only registered and activated users can see links]
begin
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
[Only registered and activated users can see links]
end
CLOSE LISTA
DEALLOCATE LISTA
[Only registered and activated users can see links]
Créditos: russo1