3334
iqtpi_site_tab_stats
iqtpi_site_tab_stats
|/routinetype-subutility|
7
<var set = att.set>
<var set_format = att.set_format>
<var idstr = att.idstr>
<!--- the past seven days... --->
<var dt = now()-7>
<var _total_users = 0>
<var _trust_where = "user.sites LIKE ('%|#set.id#|%')">
<if trim(set.gutitle) NEQ ""> <var _trust_where = _trust_where & "OR user.sites LIKE ('%|#set.gutitle#|%')"></if>
<set orb="user" select="count(user.id) AS idcount" where="#_trust_where#">
<setcrawl><var _total_users = set.idcount></setcrawl>
</set>
<!--- how many friends trust this site? --->
<var _total_trust_friends = 0>
<real_person><set orb="user" select="count(user.id) AS idcount" where="user.id IN (#GLOBAL.Def.Friends.intList#) AND (#_trust_where#)">
<setcrawl><var _total_trust_friends = set.idcount></setcrawl>
</set></real_person>
<!--- following? --->
<var _total_trust_following = 0>
<real_person><set orb="user" select="count(user.id) AS idcount" where="user.id IN (#GLOBAL.Def.Following.intList#) AND (#_trust_where#)">
<setcrawl><var _total_trust_following = set.idcount></setcrawl>
</set></real_person>
<!--- followers? --->
<var _total_trust_followers = 0>
<real_person><set orb="user" select="count(user.id) AS idcount" where="user.id IN (#GLOBAL.Def.Followers.intList#) AND (#_trust_where#)">
<setcrawl><var _total_trust_followers = set.idcount></setcrawl>
</set></real_person>
<var _total_logins = 0>
<set is_proxy="1" orb="sitelogin" select="count(sitelogin.id) AS idcount" where="sitelogin.so_dateinserted > #dt# AND sitelogin.name = '|/site-#set.id#|'">
<setcrawl><var _total_logins = set.idcount></setcrawl>
</set>
<var _total_logins_unique = 0>
<set is_proxy="1" orb="sitelogin" select="count(sitelogin.user_id) AS idcount" where="sitelogin.so_dateinserted > #dt# AND sitelogin.name = '|/site-#set.id#|'">
<setcrawl><var _total_logins_unique = set.idcount></setcrawl>
</set>
<style type="text/css">
.users ul { margin-top:0px; margin-bottom:0px; margin-left:-1.36em; }
.users ul li { margin-bottom:0.36em; }
</style>
<div class="noverflow">
<IF set.gutitle NEQ "iqtpi">
<div style="float:right; width:30%; font-size:0.8em; border-left:1px solid #GLOBAL.Def.Style.color.g5#; padding-left:1.6%; padding-bottom:1em;">
<if _total_users EQ 0>
<var _total_users_minus_html = 'No one trusts this site'>
<var _total_users_curr_html = 'No one trusts this site'>
<var _total_users_plus_html = '<a href="http://#this_domain#/People/All?&people_site=#set_format.idstr#">One person</a> trusts this site'>
<elseif _total_users EQ 1>
<var _total_users_minus_html = 'No one has'>
<var _total_users_curr_html = '<a href="http://#this_domain#/People/All?&people_site=#set_format.idstr#">One person</a> trusts this site'>
<var _total_users_plus_html = '<a href="http://#this_domain#/People/All?&people_site=#set_format.idstr#">#_total_users+1# people</a> trust this site'>
<else>
<if _total_users EQ 2>
<var _total_users_minus_html = '<a href="http://#this_domain#/People/All?&people_site=#set_format.idstr#">One person</a> trusts this site'>
<else>
<var _total_users_minus_html = '<a href="http://#this_domain#/People/All?&people_site=#set_format.idstr#">#_total_users-1# people</a> trust this site'>
</if>
<var _total_users_curr_html = '<a href="http://#this_domain#/People/All?&people_site=#set_format.idstr#">#_total_users# people</a> trust this site'>
<var _total_users_plus_html = '<a href="http://#this_domain#/People/All?&people_site=#set_format.idstr#">#_total_users+1# people</a> trust this site'>
</if>
<!--- do you trust this site --->
<div id="trusted_container_container" style="min-height:2.4em;"><div id="trusted_container">
<div id="trusted" style="padding-bottom:16px;">
<real_person>
<var _trusted = 0>
<if findNoCase("|#set.id#|",GLOBAL.Def.CLIENT.sites) GT 0 OR (trim(set.gutitle) NEQ "" AND findNoCase("|#set.gutitle#|",GLOBAL.Def.CLIENT.sites) GT 0)>
<var _trusted = 1>
</if>
<var _trusted_html_1 = '<div style="padding-bottom:0.2em;"><img src="http://fentriss.net/get_7o_file.cfm?&path=icons/Fugue/icons/tick.png" border="0" style="max-height:0.88em;"> #set_format.title# is on your list of trusted sites.</div>
<div align="right"><small>
<a id="j_remove_trusted_site" onclick="try{j_remove_trusted_site(this);}catch(err){}; return false;"
href="http://#this_domain#/j_service?&j=/site-#set_format.idstr#&j_function=remove_trusted_site">Remove Site</a>
|
<a href="http://#this_domain#/#so_slash_string#?&sts=Login"><b>Log In</b></a>
</small></div>'>
<var _trusted_html_0 = '<div style="padding-bottom:0.2em;"><img src="http://fentriss.net/get_7o_file.cfm?&path=icons/Fugue/icons/cross.png" border="0" style="max-height:0.88em;"> #set_format.title# is not on your list of trusted sites.</div>
<div align="right"><small>
<a id="j_add_trusted_site" onclick="try{j_add_trusted_site(this);}catch(err){}; return false;"
href="http://#this_domain#/j_service?&j=/site-#set_format.idstr#&j_function=add_trusted_site"><b>Add Site ></b></a>
</small></div>'>
<if _trusted EQ 1>
#_trusted_html_1#
<else>
#_trusted_html_0#
</if>
</real_person>
<fake_person>
<b>Log into iqtpi to add this to your list of trusted sites.</b>
</fake_person>
</div>
</div></div>
<div style="border-top:1px solid #GLOBAL.Def.Style.color.g5#; height:3px;"> </div>
<div class="users">
<div style="margin-bottom:0.36em;">
<span id="total_users_fragment">
#_total_users_curr_html#
</span>
</div>
<if _trusted EQ 1>
<!--- adjust the _total_users html --->
<var _total_users_plus_html = _total_users_curr_html>
<var _total_users_curr_html = _total_users_minus_html>
</if>
<if _total_users EQ 0>
<else>
<ul>
<if _total_trust_friends GT 0>
<li>
<if _total_trust_friends EQ 1>
<a href="http://#this_domain#/People/Friends?&people_site=#set_format.idstr#">one friend</a>
<else>
<a href="http://#this_domain#/People/Friends?&people_site=#set_format.idstr#">#_total_trust_friends# friends</a>
</if>
</li>
</if>
<if _total_trust_following GT 0>
<li>
<if _total_trust_following EQ 1>
<a href="http://#this_domain#/People/Following?&people_site=#set_format.idstr#">one person you follow</a>
<else>
<a href="http://#this_domain#/People/Following?&people_site=#set_format.idstr#">#_total_trust_following# people you follow</a>
</if>
</li>
</if>
<if _total_trust_followers GT 0>
<li>
<if _total_trust_followers EQ 1>
<a href="http://#this_domain#/People/Followers?&people_site=#set_format.idstr#">one follower</a>
<else>
<a href="http://#this_domain#/People/Friends?&people_site=#set_format.idstr#">#_total_trust_followers#</a> followers</a>
</if>
this site
</li>
</if>
</ul>
</if>
</div>
</div>
</IF>
<div style="margin-right:35%;">
<!--- logins - past seven days --->
<ul style="margin-top:0px; margin-left:-1em;">
<li style="margin-bottom:0.36em;">
<if _total_logins EQ 0>
no users logged into this site within the past seven days
<elseif _total_logins EQ 1>
one user logged into this site over the past seven days
<else>
this site was logged into #_total_logins# times by
<if _total_logins_unique LTE 1>
one unique iqtpi user
<else>
#_total_logins_unique# unique iqtpi users
</if>
over the past seven days
</if>
</li>
<var _can_i_delete = 0>
<var _can_steve_delete = 0>
<set is_proxy="0" orb="site" select="site.id" where="site.id = #set.id#" keylev="DELETE">
<setcrawl><var _can_i_delete = 1></setcrawl>
</set>
<if _can_i_delete EQ 1>
<!--- the logged in user can view detailed stats --->
<else>
<!--- steve will show the logged in user some less-detailed stats --->
<set is_proxy="1" orb="site" select="site.id" where="site.id = #set.id#" keylev="DELETE">
<setcrawl><var _can_steve_delete = 1></setcrawl>
</set>
</if>
<if _can_i_delete EQ 1 OR _can_steve_delete EQ 1>
<!--- how many anon visits? --->
<var _anon_visits = 0>
<set orb="siterequest" select="count(siterequest.id) AS idcount"
where="siterequest.site_id = #set.id# AND siterequest.utype = 'browser' AND siterequest.userid_unsignedint < 2 AND siterequest.so_dateinserted > #dt#"
is_proxy="#_can_steve_delete#">
<setcrawl><var _anon_visits = set.idcount></setcrawl>
</set>
<li>
this site had
<if _anon_visits EQ 0>
no anonymous visits
<elseif _anon_visits EQ 1>
one anonymous visit
<else>
#numberFormat(_anon_visits,"999,999,999,999")# anonymous visits
</if>
in the past seven days
<if _anon_visits GT 210>
(about #numberFormat(_anon_visits/7,"999,999")# per day)
</if>
<if _anon_visits GT 100>
<small><ul style="margin-top:0.2em; margin-bottom:0.2em; margin-left:-1.36em; color:##999;">
<!--- how many unique ips? --->
<var _unique_ips = 0>
<set orb="siterequest" select="count(siterequest.remote_addr) AS idcount"
where="siterequest.site_id = #set.id# AND siterequest.utype = 'browser' AND siterequest.userid_unsignedint < 2 AND siterequest.so_dateinserted > #dt#"
is_proxy="#_can_steve_delete#">
<setcrawl><var _unique_ips = set.idcount></setcrawl>
</set>
<li>
anonymous visits came from
<if _unique_ips LTE 1>
one ip address
<else>
#numberFormat(_unique_ips,"999,999")# unique ip addresses
</if>
<if _unique_ips GT 7>
(about #numberFormat(_unique_ips/7,"999,999")# per day)
</if>
</li>
</ul></small>
</if>
</li>
</if>
</ul>
</div>
</div>
<IF set.gutitle NEQ "iqtpi">
<real_person>
<tag.jquery>
<script type="text/javascript">
function j_add_trusted_site(that) {
$.get(that.href,function() {
$('##trusted_container').slideUp(180);
setTimeout('j_add_trusted_site_2()',181);
});
}
function j_add_trusted_site_2() {
$('##trusted').html('#replace(escapeSingleQuotes(_trusted_html_1),CHR(10),"\#CHR(10)#","all")#');
$('##trusted_container').slideDown(360);
$('##total_users_fragment').html('#replace(escapeSingleQuotes(_total_users_plus_html),CHR(10),"\#CHR(10)#","all")#');
}
function j_remove_trusted_site(that) {
$.get(that.href,function() {
$('##trusted_container').slideUp(180);
setTimeout('j_remove_trusted_site_2()',181);
});
}
function j_remove_trusted_site_2() {
$('##trusted').html('#replace(escapeSingleQuotes(_trusted_html_0),CHR(10),"\#CHR(10)#","all")#');
$('##trusted_container').slideDown(360);
$('##total_users_fragment').html('#replace(escapeSingleQuotes(_total_users_curr_html),CHR(10),"\#CHR(10)#","all")#');
}
</script>
</real_person>
</IF>
<var set_format = att.set_format>
<var idstr = att.idstr>
<!--- the past seven days... --->
<var dt = now()-7>
<var _total_users = 0>
<var _trust_where = "user.sites LIKE ('%|#set.id#|%')">
<if trim(set.gutitle) NEQ ""> <var _trust_where = _trust_where & "OR user.sites LIKE ('%|#set.gutitle#|%')"></if>
<set orb="user" select="count(user.id) AS idcount" where="#_trust_where#">
<setcrawl><var _total_users = set.idcount></setcrawl>
</set>
<!--- how many friends trust this site? --->
<var _total_trust_friends = 0>
<real_person><set orb="user" select="count(user.id) AS idcount" where="user.id IN (#GLOBAL.Def.Friends.intList#) AND (#_trust_where#)">
<setcrawl><var _total_trust_friends = set.idcount></setcrawl>
</set></real_person>
<!--- following? --->
<var _total_trust_following = 0>
<real_person><set orb="user" select="count(user.id) AS idcount" where="user.id IN (#GLOBAL.Def.Following.intList#) AND (#_trust_where#)">
<setcrawl><var _total_trust_following = set.idcount></setcrawl>
</set></real_person>
<!--- followers? --->
<var _total_trust_followers = 0>
<real_person><set orb="user" select="count(user.id) AS idcount" where="user.id IN (#GLOBAL.Def.Followers.intList#) AND (#_trust_where#)">
<setcrawl><var _total_trust_followers = set.idcount></setcrawl>
</set></real_person>
<var _total_logins = 0>
<set is_proxy="1" orb="sitelogin" select="count(sitelogin.id) AS idcount" where="sitelogin.so_dateinserted > #dt# AND sitelogin.name = '|/site-#set.id#|'">
<setcrawl><var _total_logins = set.idcount></setcrawl>
</set>
<var _total_logins_unique = 0>
<set is_proxy="1" orb="sitelogin" select="count(sitelogin.user_id) AS idcount" where="sitelogin.so_dateinserted > #dt# AND sitelogin.name = '|/site-#set.id#|'">
<setcrawl><var _total_logins_unique = set.idcount></setcrawl>
</set>
<style type="text/css">
.users ul { margin-top:0px; margin-bottom:0px; margin-left:-1.36em; }
.users ul li { margin-bottom:0.36em; }
</style>
<div class="noverflow">
<IF set.gutitle NEQ "iqtpi">
<div style="float:right; width:30%; font-size:0.8em; border-left:1px solid #GLOBAL.Def.Style.color.g5#; padding-left:1.6%; padding-bottom:1em;">
<if _total_users EQ 0>
<var _total_users_minus_html = 'No one trusts this site'>
<var _total_users_curr_html = 'No one trusts this site'>
<var _total_users_plus_html = '<a href="http://#this_domain#/People/All?&people_site=#set_format.idstr#">One person</a> trusts this site'>
<elseif _total_users EQ 1>
<var _total_users_minus_html = 'No one has'>
<var _total_users_curr_html = '<a href="http://#this_domain#/People/All?&people_site=#set_format.idstr#">One person</a> trusts this site'>
<var _total_users_plus_html = '<a href="http://#this_domain#/People/All?&people_site=#set_format.idstr#">#_total_users+1# people</a> trust this site'>
<else>
<if _total_users EQ 2>
<var _total_users_minus_html = '<a href="http://#this_domain#/People/All?&people_site=#set_format.idstr#">One person</a> trusts this site'>
<else>
<var _total_users_minus_html = '<a href="http://#this_domain#/People/All?&people_site=#set_format.idstr#">#_total_users-1# people</a> trust this site'>
</if>
<var _total_users_curr_html = '<a href="http://#this_domain#/People/All?&people_site=#set_format.idstr#">#_total_users# people</a> trust this site'>
<var _total_users_plus_html = '<a href="http://#this_domain#/People/All?&people_site=#set_format.idstr#">#_total_users+1# people</a> trust this site'>
</if>
<!--- do you trust this site --->
<div id="trusted_container_container" style="min-height:2.4em;"><div id="trusted_container">
<div id="trusted" style="padding-bottom:16px;">
<real_person>
<var _trusted = 0>
<if findNoCase("|#set.id#|",GLOBAL.Def.CLIENT.sites) GT 0 OR (trim(set.gutitle) NEQ "" AND findNoCase("|#set.gutitle#|",GLOBAL.Def.CLIENT.sites) GT 0)>
<var _trusted = 1>
</if>
<var _trusted_html_1 = '<div style="padding-bottom:0.2em;"><img src="http://fentriss.net/get_7o_file.cfm?&path=icons/Fugue/icons/tick.png" border="0" style="max-height:0.88em;"> #set_format.title# is on your list of trusted sites.</div>
<div align="right"><small>
<a id="j_remove_trusted_site" onclick="try{j_remove_trusted_site(this);}catch(err){}; return false;"
href="http://#this_domain#/j_service?&j=/site-#set_format.idstr#&j_function=remove_trusted_site">Remove Site</a>
|
<a href="http://#this_domain#/#so_slash_string#?&sts=Login"><b>Log In</b></a>
</small></div>'>
<var _trusted_html_0 = '<div style="padding-bottom:0.2em;"><img src="http://fentriss.net/get_7o_file.cfm?&path=icons/Fugue/icons/cross.png" border="0" style="max-height:0.88em;"> #set_format.title# is not on your list of trusted sites.</div>
<div align="right"><small>
<a id="j_add_trusted_site" onclick="try{j_add_trusted_site(this);}catch(err){}; return false;"
href="http://#this_domain#/j_service?&j=/site-#set_format.idstr#&j_function=add_trusted_site"><b>Add Site ></b></a>
</small></div>'>
<if _trusted EQ 1>
#_trusted_html_1#
<else>
#_trusted_html_0#
</if>
</real_person>
<fake_person>
<b>Log into iqtpi to add this to your list of trusted sites.</b>
</fake_person>
</div>
</div></div>
<div style="border-top:1px solid #GLOBAL.Def.Style.color.g5#; height:3px;"> </div>
<div class="users">
<div style="margin-bottom:0.36em;">
<span id="total_users_fragment">
#_total_users_curr_html#
</span>
</div>
<if _trusted EQ 1>
<!--- adjust the _total_users html --->
<var _total_users_plus_html = _total_users_curr_html>
<var _total_users_curr_html = _total_users_minus_html>
</if>
<if _total_users EQ 0>
<else>
<ul>
<if _total_trust_friends GT 0>
<li>
<if _total_trust_friends EQ 1>
<a href="http://#this_domain#/People/Friends?&people_site=#set_format.idstr#">one friend</a>
<else>
<a href="http://#this_domain#/People/Friends?&people_site=#set_format.idstr#">#_total_trust_friends# friends</a>
</if>
</li>
</if>
<if _total_trust_following GT 0>
<li>
<if _total_trust_following EQ 1>
<a href="http://#this_domain#/People/Following?&people_site=#set_format.idstr#">one person you follow</a>
<else>
<a href="http://#this_domain#/People/Following?&people_site=#set_format.idstr#">#_total_trust_following# people you follow</a>
</if>
</li>
</if>
<if _total_trust_followers GT 0>
<li>
<if _total_trust_followers EQ 1>
<a href="http://#this_domain#/People/Followers?&people_site=#set_format.idstr#">one follower</a>
<else>
<a href="http://#this_domain#/People/Friends?&people_site=#set_format.idstr#">#_total_trust_followers#</a> followers</a>
</if>
this site
</li>
</if>
</ul>
</if>
</div>
</div>
</IF>
<div style="margin-right:35%;">
<!--- logins - past seven days --->
<ul style="margin-top:0px; margin-left:-1em;">
<li style="margin-bottom:0.36em;">
<if _total_logins EQ 0>
no users logged into this site within the past seven days
<elseif _total_logins EQ 1>
one user logged into this site over the past seven days
<else>
this site was logged into #_total_logins# times by
<if _total_logins_unique LTE 1>
one unique iqtpi user
<else>
#_total_logins_unique# unique iqtpi users
</if>
over the past seven days
</if>
</li>
<var _can_i_delete = 0>
<var _can_steve_delete = 0>
<set is_proxy="0" orb="site" select="site.id" where="site.id = #set.id#" keylev="DELETE">
<setcrawl><var _can_i_delete = 1></setcrawl>
</set>
<if _can_i_delete EQ 1>
<!--- the logged in user can view detailed stats --->
<else>
<!--- steve will show the logged in user some less-detailed stats --->
<set is_proxy="1" orb="site" select="site.id" where="site.id = #set.id#" keylev="DELETE">
<setcrawl><var _can_steve_delete = 1></setcrawl>
</set>
</if>
<if _can_i_delete EQ 1 OR _can_steve_delete EQ 1>
<!--- how many anon visits? --->
<var _anon_visits = 0>
<set orb="siterequest" select="count(siterequest.id) AS idcount"
where="siterequest.site_id = #set.id# AND siterequest.utype = 'browser' AND siterequest.userid_unsignedint < 2 AND siterequest.so_dateinserted > #dt#"
is_proxy="#_can_steve_delete#">
<setcrawl><var _anon_visits = set.idcount></setcrawl>
</set>
<li>
this site had
<if _anon_visits EQ 0>
no anonymous visits
<elseif _anon_visits EQ 1>
one anonymous visit
<else>
#numberFormat(_anon_visits,"999,999,999,999")# anonymous visits
</if>
in the past seven days
<if _anon_visits GT 210>
(about #numberFormat(_anon_visits/7,"999,999")# per day)
</if>
<if _anon_visits GT 100>
<small><ul style="margin-top:0.2em; margin-bottom:0.2em; margin-left:-1.36em; color:##999;">
<!--- how many unique ips? --->
<var _unique_ips = 0>
<set orb="siterequest" select="count(siterequest.remote_addr) AS idcount"
where="siterequest.site_id = #set.id# AND siterequest.utype = 'browser' AND siterequest.userid_unsignedint < 2 AND siterequest.so_dateinserted > #dt#"
is_proxy="#_can_steve_delete#">
<setcrawl><var _unique_ips = set.idcount></setcrawl>
</set>
<li>
anonymous visits came from
<if _unique_ips LTE 1>
one ip address
<else>
#numberFormat(_unique_ips,"999,999")# unique ip addresses
</if>
<if _unique_ips GT 7>
(about #numberFormat(_unique_ips/7,"999,999")# per day)
</if>
</li>
</ul></small>
</if>
</li>
</if>
</ul>
</div>
</div>
<IF set.gutitle NEQ "iqtpi">
<real_person>
<tag.jquery>
<script type="text/javascript">
function j_add_trusted_site(that) {
$.get(that.href,function() {
$('##trusted_container').slideUp(180);
setTimeout('j_add_trusted_site_2()',181);
});
}
function j_add_trusted_site_2() {
$('##trusted').html('#replace(escapeSingleQuotes(_trusted_html_1),CHR(10),"\#CHR(10)#","all")#');
$('##trusted_container').slideDown(360);
$('##total_users_fragment').html('#replace(escapeSingleQuotes(_total_users_plus_html),CHR(10),"\#CHR(10)#","all")#');
}
function j_remove_trusted_site(that) {
$.get(that.href,function() {
$('##trusted_container').slideUp(180);
setTimeout('j_remove_trusted_site_2()',181);
});
}
function j_remove_trusted_site_2() {
$('##trusted').html('#replace(escapeSingleQuotes(_trusted_html_0),CHR(10),"\#CHR(10)#","all")#');
$('##trusted_container').slideDown(360);
$('##total_users_fragment').html('#replace(escapeSingleQuotes(_total_users_curr_html),CHR(10),"\#CHR(10)#","all")#');
}
</script>
</real_person>
</IF>
0.00
0
0
0