select * from tab1 where ip='644300560'
insert into tab1 set ip=644300560
select * from hit_host where script='host'
update hit_host set h11=h11+1, hour=11, d7=d7+1, m8=m8+1, j2008=j2008+1 where script='host'
select hit_host.name, hit_host.d7 from hit_host where script='host'
delete from hit_host where mont<7
select * from language where script='en'
update language set d7=d7+1, m8=m8+1, j2008=j2008+1 where script='en'
select language.name, language.d7 from language where script='en'
delete from language where mont<7
select * from referer_host where script='---'
update referer_host set h11=h11+1, hour=11, d7=d7+1, m8=m8+1, j2008=j2008+1 where script='---'
select referer_host.name, referer_host.d7 from referer_host where script='---'
select count(*) from referer_host
delete from referer_host where mont<7
select * from referer where script='---'
update referer set h11=h11+1, hour=11, d7=d7+1, m8=m8+1, j2008=j2008+1 where script='---'
select referer.name, referer.d7 from referer where script='---'
select count(*) from referer
delete from referer where mont<7
select * from razrech where script='---'
update razrech set d7=d7+1, m8=m8+1, j2008=j2008+1 where script='---'
select razrech.name, razrech.d7 from razrech where script='---'
delete from razrech where mont<7
select * from razcolor where script='---'
update razcolor set d7=d7+1, m8=m8+1, j2008=j2008+1 where script='---'
select razcolor.name, razcolor.d7 from razcolor where script='---'
delete from razcolor where mont<7
select * from razcolor where script='---'
update razcolor set d7=d7+1, m8=m8+1, j2008=j2008+1 where script='---'
select razcolor.name, razcolor.d7 from razcolor where script='---'
delete from razcolor where mont<7
select * from statik where script='hits'
update statik set d7=d7+1, m8=m8+1, j2008=j2008+1 where script='hits'
select statik.name, statik.d7 from statik where script='hits'
delete from statik where mont<7
here -3
select * from tab1 where tab1.ip=644300560
select * from add_page where host='/' and vars=''
select * from page where script='/'
update page set h11=h11+1, hour=11, d7=d7+1, m8=m8+1, j2008=j2008+1 where script='/'
select page.name, page.d7 from page where script='/'
delete from page where mont<7
select * from tab2 where ip='62178' and time_visit>=1218131742 limit 0,20
select * from page_h where script='/'
update page_h set h11=h11+1, hour=11, d7=d7+1, m8=m8+1, j2008=j2008+1 where script='/'
select page_h.name, page_h.d7 from page_h where script='/'
delete from page_h where mont<7
select * from server_page where script='(2-5)'
update server_page set d7=d7+1, m8=m8+1, j2008=j2008+1 where script='(2-5)'
select server_page.name, server_page.d7 from server_page where script='(2-5)'
delete from server_page where mont<7
select * from brauser where script='unknown '
update brauser set day=7, mont=8 , d7=0, m8=0 , d29=0, d30=0, d31=0, d1=0, d2=0, d3=0, d4=0, d5=0, d6=0, d7=0 where script='unknown '
update brauser set d7=d7+1, m8=m8+1, j2008=j2008+1 where script='unknown '
select brauser.name, brauser.d7 from brauser where script='unknown '
delete from brauser where mont<7
select * from systems where script='unknown'
update systems set day=7, mont=8 , d7=0 , d6=0, d7=0 where script='unknown'
update systems set d7=d7+1, m8=m8+1, j2008=j2008+1 where script='unknown'
select systems.name, systems.d7 from systems where script='unknown'
delete from systems where mont<7
select * from navigator where script='CCBot/1.0 (+http://www.commoncrawl.org/bot.html)'
insert into navigator (script, day, mont) values ('CCBot/1.0 (+http://www.commoncrawl.org/bot.html)','7','8')
update navigator set d7=d7+1, m8=m8+1, j2008=j2008+1 where script='CCBot/1.0 (+http://www.commoncrawl.org/bot.html)'
select navigator.name, navigator.d7 from navigator where script='CCBot/1.0 (+http://www.commoncrawl.org/bot.html)'
delete from navigator where mont<7
select * from proxy where script='Numeric'
update proxy set d7=d7+1, m8=m8+1, j2008=j2008+1 where script='Numeric'
select proxy.name, proxy.d7 from proxy where script='Numeric'
delete from proxy where mont<7
select * from provider where script='---'
update provider set d7=d7+1, m8=m8+1, j2008=j2008+1 where script='---'
select provider.name, provider.d7 from provider where script='---'
delete from provider where mont<7
select * from countries where script='us'
update countries set d7=d7+1, m8=m8+1, j2008=j2008+1 where script='us'
select countries.name, countries.d7 from countries where script='us'
delete from countries where mont<7
select * from tab1 where tab1.ip=644300560
Warning: Cannot modify header information - headers already sent by (output started at /misc/18/247/171/414/2/user/web/silverspoonmurals.com/stats/modules/class_init.php:1922) in /misc/18/247/171/414/2/user/web/silverspoonmurals.com/stats/modules/class_init.php on line 1078
update tab1 set language='en', dateU='1218132342', referer='3', razrech='4', page='5', navigator='12163', countries='5', numv='1' where ip='644300560'
select * from tab1 where ip='644300560'
select * from tab2 where ip='62178' and time_visit>=1218131742 limit 0,20
insert into tab2 (dateU,page,referer,ip,time_visit,exit_page,indexp) values (1218132342,5,3,62178,1218132342,5,0)
select * from hit_host where script='hit'
update hit_host set h11=h11+1, hour=11, d7=d7+1, m8=m8+1, j2008=j2008+1 where script='hit'
select hit_host.name, hit_host.d7 from hit_host where script='hit'
delete from hit_host where mont<7
select * from exit_page where script='5'
update exit_page set h11=h11+1, hour=11, d7=d7+1, m8=m8+1, j2008=j2008+1 where script='5'
select exit_page.name, exit_page.d7 from exit_page where script='5'
delete from exit_page where mont<7
Warning: Cannot modify header information - headers already sent by (output started at /misc/18/247/171/414/2/user/web/silverspoonmurals.com/stats/modules/class_init.php:1922) in /misc/18/247/171/414/2/user/web/silverspoonmurals.com/stats/modules/class_init.php on line 1170
select max(dateU) from tab2 where ip=62178
select tab2.time_visit, tab2.dateU, tab2.referer, tab2.page, tab2.exit_page from tab2 where dateU=1218132342 and ip='62178'
select * from exit_page where script='5'
update exit_page set h11=h11-1, hour=11, d7=d7-1, m8=m8-1, j2008=j2008-1 where script='5'
select exit_page.name, exit_page.d7 from exit_page where script='5'
delete from exit_page where mont<7
select * from exit_page where script='5'
update exit_page set h11=h11+1, hour=11, d7=d7+1, m8=m8+1, j2008=j2008+1 where script='5'
select exit_page.name, exit_page.d7 from exit_page where script='5'
delete from exit_page where mont<7
update tab2 set time_visit=1218132342, exit_page=5 where dateU=1218132342 and ip=62178
select tab2.time_visit, tab2.dateU, tab2.indexp from tab2 where dateU=1218132342 and ip='62178'
select dateU from tab3 where dateU>=1218132342 and dateU<=1218132342 and ip='62178'
update tab1 set time_n='0' where ip='644300560'
update tab1 set page_n='1' where ip='644300560'
select * from depth_view where script='1'
update depth_view set d7=d7+1, m8=m8+1, j2008=j2008+1 where script='1'
select depth_view.name, depth_view.d7 from depth_view where script='1'
delete from depth_view where mont<7
select * from time_view where script='1'
update time_view set d7=d7+1, m8=m8+1, j2008=j2008+1 where script='1'
select time_view.name, time_view.d7 from time_view where script='1'
delete from time_view where mont<7
update tab2 set indexp='1' where dateU=1218132342 and ip=62178
insert into tab3 (dateU,page,referer,ip) values (1218132342,5,3,62178)
select * from tab4 where ip=62178
insert into tab4 (dateU,ip) values (1218132342,62178)
delete from tab4 where dateU<='1218132162'
select count(*) from tab1
select tab1.dateU from tab1 order by dateU desc limit 10000,1
delete from tab1 where dateU<='1208004864'
delete from tab2 where dateU<='1208004864'
delete from tab3 where dateU<='1208004864'