select * from memb_stat where ip = '000.000.000.000'

select * from memb_stat where ip like '000.000.000.%'

select * from character where energy>=1000 and strength>=1000 and dexterity>=1000

select ip, AccountID, name, clevel, servername, mapnumber, mapposx, mapposy, connecttm, disconnecttm
from character
join Memb_Stat on Character.Accountid = Memb_Stat.memb___id
join Accountcharacter on Character.name = accountcharacter.gameidc
where Memb_Stat.ConnectStat = 1
and Memb_Stat.ip like '000.000.000.%'
and accountcharacter.gameidc=name order by servername

declare @deldate datetime
set @deldate = '2013-04-30'

DECLARE tnames CURSOR
FOR select memb___id from memb_info where bloc_code = 1
and convert(datetime,bloc_date) < @deldate and avtounblock = 0 order by convert(datetime,bloc_date) desc
open tnames
DECLARE @tablename sysname
FETCH NEXT FROM tnames INTO @tablename
WHILE @@FETCH_STATUS = 0
BEGIN
 delete accountcharacter where id = @tablename
 delete character where accountid = @tablename
 delete memb_info where memb___id = @tablename
 delete vi_curr_info where memb___id = @tablename
 delete warehouse where accountid = @tablename
 print 'delete account: ' + @tablename
 FETCH NEXT FROM tnames INTO @tablename
END
close tnames
DEALLOCATE tnames

declare @login varchar(10)
declare @oldnick varchar(10)
declare @newnick varchar(10)
set @oldnick = 'Sid***'
set @newnick = 'Swat_MG'
set @login = (select AccountID from Character where Name = @oldnick)
if @login not in (select memb___id from memb_stat where connectstat='1')
begin
 if @newnick not in (select Name from character where name = @newnick)
 begin
  UPDATE Character SET Name=@newnick WHERE Name = @oldnick
  UPDATE AccountCharacter SET GameID1 = @newnick WHERE GameID1 = @oldnick
  UPDATE AccountCharacter SET GameID2 = @newnick WHERE GameID2 = @oldnick
  UPDATE AccountCharacter SET GameID3 = @newnick WHERE GameID3 = @oldnick
  UPDATE AccountCharacter SET GameID4 = @newnick WHERE GameID4 = @oldnick
  UPDATE AccountCharacter SET GameID5 = @newnick WHERE GameID5 = @oldnick
  UPDATE AccountCharacter SET GameIDC = @newnick WHERE GameIDC = @oldnick
  UPDATE OptionData SET Name = @newnick WHERE Name = @oldnick
  UPDATE GuildMember SET Name = @newnick WHERE Name = @oldnick
  UPDATE Guild SET G_Master = @newnick WHERE G_Master = @oldnick
  PRINT 'nick pomenjali! :)'
 end
 else PRINT 'nick zanjat'
end
else PRINT 'user "' + @login + '" online'

select * from pwd_log where accountid = 'Security'

select distinct memb__pwd a from memb_info
union
select distinct pwd_old a from pwd_log
order by a desc

select memb___id from memb_info