vb.org Archive
Page 6 of 14 « First 45 6 78 Last »
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)
-   -   vB3 Boardstatistic Version 2 (https://vborg.vbsupport.ru/showthread.php?t=66783)

Onkel_Tom 08-23-2004 01:26 AM
You can also easy test the function by this small php script.
Just copy ist to a file on your server like browsertest.php and run it from your Browser to see what is the output ;)

PHP Code:
<?php 

$agent0 = getenv("HTTP_USER_AGENT"); 
$agent1 = $_SERVER['HTTP_USER_AGENT']; 
$agent2 = $HTTP_USER_AGENT; 
$agent3 = get_browser(); 

echo "<b>getenv:</b> $agent0</br \></br \>"; 
echo "<b>_SERVER:</b> $agent1</br \></br \>"; 
echo "<b>HTTP_USER_AGENT:</b> $agent2</br \></br \>"; 
echo "<b>get_browser:</b> $agent3</br \></br \>"; 

?>

Onkel_Tom 08-23-2004 01:37 AM
Don't forget to change also the same line in file statistic_counter.php at line 26 !!!

It should read in your case as:
Code:
$browserstamp = $_SERVER['HTTP_USER_AGENT'];

Wential 08-23-2004 02:01 AM
Quote:
Originally Posted by Onkel_Tom
Don't forget to change also the same line in file statistic_counter.php at line 26 !!!

It should read in your case as:
Code:
$browserstamp = $_SERVER['HTTP_USER_AGENT'];
Got it, thanks again!

Zelda-King 08-23-2004 09:07 AM
On both version 1 and this version some of the most popular user countries don't show for me. I have remote countries like the Seychelles listed but not the UK/US.

... The English templates still need a lot of work, and it's not just the language. The notation isn't consistant. For example some statistic fields have a : after them and others do not.

Here's my updated STATISTIC template:
Code:
$statistic_header
<script language="JavaScript" type="text/javascript">
<!--
var win=null;
function NewWindow(mypage,myname,w,h,scroll,pos){
if(pos=="random"){LeftPosition=(screen.width)?Math.floor(Math.random()*(screen.width-w)):100;TopPosition=(screen.height)?Math.floor(Math.random()*((screen.height-h)-75)):100;}
if(pos=="center"){LeftPosition=(screen.width)?(screen.width-w)/2:100;TopPosition=(screen.height)?(screen.height-h)/2:100;}
else if((pos!="center" && pos!="random") || pos==null){LeftPosition=0;TopPosition=20}
settings='width='+w+',height='+h+',top='+TopPosition+',left='+LeftPosition+',scrollbars='+scroll+',location=no,directories=no,status=no,menubar=no,toolbar=no,resizable=no';
win=window.open(mypage,myname,settings);}
// -->
</script>

<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">

<tr>
    <td class="tcat" colspan="2"><div align="center"><strong>Statistic Overview</strong></div></td>
</tr>

<tr>
        <td class="panelsurround">
        <div class="panel">
        <fieldset class="fieldset">
        <legend><strong>Topics/Threads/Users</strong></legend>
        <table width="95%" border="0" align="center" cellpadding="0" cellspacing="$stylevar[formspacer]">

<tr>
    <td colspan="2">&nbsp;</td>
</tr>

<tr>
    <td class="alt2">Threads:</td>
        <td class="alt2">$Themen</td>
</tr>

<tr>
  <td>Posts:</td>
    <td>$Beitraege</td>
</tr>
<tr>
  <td class="alt2">Thread Views:</td>
  <td class="alt2">$Beitraege_gelesen (? $Beitraege_durchschnitt times)</td>
</tr>
<tr>
  <td>Registered Members:</td>
    <td>$Member</td>
</tr>
<tr>
  <td class="alt2">Visitors:</td>
  <td class="alt2">$Besucher*</td>
</tr>
<tr>
    <td>Side Calls:</td>
    <td>$Seitenaufrufe*</td>
</tr>
<tr>
    <td class="tcat" colspan="2"><div align="center">* - Since Statistics
                Started on $statistikaktiv</div></td>
</tr>

<tr>
  <td colspan="2">&nbsp;</td>
</tr>

        </table>
        </fieldset>
        </div>
        <div class="panel">
        <fieldset class="fieldset">
    <legend><strong>User Activity</strong></legend>
    <table width="95%" border="0" align="center">

<tr>
  <td colspan="3">&nbsp;</td>
</tr>

<tr>
  <td class="alt2" width="30%">Active users: </td>
  <td class="alt2" width="70%">$aktive_user_prozent % ($aktive_user) on this
        forum have posted*</td>
  <td class="alt2" width="70%"> <img src="images/statistik/bar5.gif" alt="Active user" width="$aktive_user_bar" height="10" border="0" /></td>
</tr>

<tr>
    <td>Not active Users: </td>
    <td>$unaktive_user_prozent % ($alle_unaktiven_user) on this forum have never
        posted*</td>
    <td> <img src="images/statistik/bar10.gif" alt="Not active User" width="$unaktive_user_bar" height="10" border="0" /></td>
</tr>

<tr>
    <td>&nbsp;</td>
    <td colspan="2" class="tcat"><div align="center">*Since $vboptions[bbtitle] is online</div></td>
</tr>

<tr>
    <td colspan="3">&nbsp;</td>
</tr>

<tr>
    <td class="tfoot" colspan="3"><div align="center">Visits of registered Members for the last 30, 14 and 7 days </div></td>
</tr>

<tr>
  <td class="alt2">The last 30 days:</td>
  <td class="alt2"colspan="2">
  <img src="images/statistik/bar1.gif" alt="Besuche von registrierten Membern f?r die letzten 30 days" width="$bar_aktiv_user1" height="10" border="0" />
    $aktiven_user1_prozent % ($aktiven_user1)</td>
</tr>

<tr>
  <td>The last 14 days:</td>
  <td colspan="2"> <img src="images/statistik/bar2.gif" alt="Besuche von registrierten Membern f?r die letzten 14 days" width="$bar_aktiv_user2" height="10" border="0" />
    $aktiven_user2_prozent %($aktiven_user2)</td>
</tr>

<tr>
  <td class="alt2">The last 7 days:</td>
  <td class="alt2"colspan="2">
  <img src="images/statistik/bar3.gif" alt="Besuche von registrierten Membern f?r die letzten 7 days " width="$bar_aktiv_user3" height="10" border="0" />
    $aktiven_user3_prozent %($aktiven_user3)</td>
</tr>

<tr>
    <td>Not visited $vboptions[bbtitle] for more then 30 days:</td>
    <td colspan="2">
    <img src="images/statistik/bar4.gif" alt="$vboptions[bbtitle] l?nger als 30 days nicht mehr besucht!" width="$bar_aktiv_user4" height="10" border="0" />
    $aktiven_user4_prozent % ($aktiven_user4) </td>
</tr>

<tr>
    <td colspan="3">&nbsp;</td>
</tr>

        </table>
        </fieldset>
        </div>

        <div class="panel">
        <fieldset class="fieldset">
    <legend><strong>Private Messages </strong></legend>
    <table width="95%" border="0" align="center">

<tr>
    <td colspan="2">&nbsp;</td>
</tr>

<tr>
    <td class="alt2">All written PMs:</td>
    <td class="alt2">$PMS</td>
</tr>

<tr>
    <td>All PMs in the database:</td>
    <td>$alle_pm ($pm_ungelesen unread)</td>
</tr>

<tr>
  <td class="alt2">Space Used by PMs:</td>
  <td class="alt2">$pm_speicher_in_kb kb ($pm_speicher_in_mb mb)</td>
</tr>

<tr>
    <td colspan="2">&nbsp;</td>
</tr>

        </table>
        </fieldset>
        </div>

        <div class="panel">
        <fieldset class="fieldset">
    <legend><strong>Database</strong></legend>
    <table width="95%" border="0" align="center">

<tr>
    <td colspan="3">&nbsp;</td>
</tr>

<tr>
    <td class="alt2"><img src="images/statistik/misc/database.gif" alt="Database Size" width="14" height="14" border="0" /></td>
    <td class="alt2">Database Size:</td>
    <td class="alt2">$datenbank_in_kb KiloBytes ($datenbank_in_mb Mb)</td>
</tr>

<tr>
    <td><img src="images/statistik/misc/serverinfo.gif" alt="Server Info" width="14" height="14" border="0" /></td>
    <td>Server Info:</td>
    <td>$serverinfo</td>
</tr>

<tr>
  <td class="alt2"><img src="images/statistik/misc/mysqlinfo.gif" alt="MYSQL Version" width="14" height="14" border="0" /></td>
  <td class="alt2">MYSQL Version:</td>
  <td class="alt2">$mysqlversion</td>
</tr>

<tr>
    <td><img src="images/statistik/misc/smilie.gif" alt="Smilies" width="14" height="14" border="0" /></td>
    <td>Smilies:</td>
    <td>$alle_smilies total</td>
</tr>

<tr>
  <td class="alt2"><img src="images/statistik/misc/anhaenge.gif" alt="Stored Attachments" width="14" height="14" border="0" /></td>
  <td class="alt2">Stored Attachments:</td>
  <td class="alt2">$alle_anhaenge</td>
</tr>

<tr>
    <td><img src="images/statistik/misc/anhaenge1.gif" alt="Space Used by Attachments" width="14" height="14" border="0" /></td>
    <td>Space Used by Attachments:</td>
    <td>$anhaenge_speicher_in_kb KiloBytes ($anhaenge_speicher_in_mb Mb)</td>
</tr>

<tr>
    <td class="alt2"><img src="images/statistik/misc/auge.gif" alt="Attachments Viewed / Downloaded" width="14" height="14" border="0" /></td>
    <td class="alt2">Attachments Viewed / Downloaded:</td>
    <td class="alt2">$alle_downloads times</td>
</tr>

<tr>
    <td colspan="3">&nbsp;</td>
</tr>

        </table>
        </fieldset>
        </div>
        </td>

        <td valign="top" class="panelsurround">
        <div class="panel">
        <fieldset class="fieldset">
        <legend><strong>The 5 Top Posters</strong></legend>
        <table width="95%" border="0" align="center" cellpadding="0" cellspacing="$stylevar[formspacer]">

<tr>
    <td colspan="3">&nbsp;</td>
</tr>

<tr>
    <td class="alt2"><img src="images/statistik/misc/goldmedal.gif" alt="Gold Medal Winner" width="14" height="14" border="0" /></td>
    <td class="alt2"><a title="Show $postername1's profile" href="member.php?u=$posterid1">
    $postername1</a></td>
    <td class="alt2"><img src="images/statistik/bar1.gif" alt="Gold Medal Winner" width="$maxposter1_bar" height="10" border="0" />
        with $poster_beitragszahl1 posts ($maxposter1_prozent %)</td>
</tr>

<tr>
    <td><img src="images/statistik/misc/silvermedal.gif" alt="Silver Medal Winner" width="14" height="14" border="0" /></td>
    <td><a title="Show $postername2's profile" href="member.php?u=$posterid2">
    $postername2</a></td>
    <td><img src="images/statistik/bar2.gif" alt="Silver Medal Winner" width="$maxposter2_bar" height="10" border="0" />
    with $poster_beitragszahl2 posts ($maxposter2_prozent %)</td>
</tr>

<tr>
    <td class="alt2"><img src="images/statistik/misc/bronzemedal.gif" alt="Bronce Medal Winner" width="14" height="14" border="0" /></td>
    <td class="alt2"><a title="Show $postername3's profile" href="member.php?u=$posterid3">
    $postername3</a></td>
    <td class="alt2"><img src="images/statistik/bar3.gif" alt="Bronze Medal Winner" width="$maxposter3_bar" height="10" border="0" />
        with $poster_beitragszahl3 posts ($maxposter3_prozent %)</td>
</tr>

<tr>
    <td><img src="images/statistik/misc/ananas.gif" alt="Golden pineapple" width="14" height="14" border="0" /></td>
    <td> <a title="Show $postername4's profile" href="member.php?u=$posterid4">
    $postername4</a></td>
    <td><img src="images/statistik/bar4.gif" alt="Golden pineapple" width="$maxposter4_bar" height="10" border="0" />
    with $poster_beitragszahl4 posts ($maxposter4_prozent %)</td>
</tr>

<tr>
    <td class="alt2"><img src="images/statistik/misc/lollipop.gif" alt="Lollipop" width="14" height="14" border="0" /></td>
    <td class="alt2"><a title="Show $postername5's profile" href="member.php?u=$posterid5">
    $postername5</a></td>
    <td class="alt2"><img src="images/statistik/bar5.gif" alt="Just a Lollipop" width="$maxposter5_bar" height="10" border="0" />
        with $poster_beitragszahl5 posts ($maxposter5_prozent %)</td>
</tr>

<tr>
  <td colspan="3"><br />These members have a combined total of $maxposter_summe posts!!<br />
        <a onclick="NewWindow(this.href,'statistik','640','480','yes','center');return false" onfocus="this.blur()" title="Show the $topposter_limit Top Poster in a PopUp Window" href="statistik.php?do=topposter_popup">
        Show $topposter_limit Top Posters</a>
        </td>
</tr>

<tr>
    <td colspan="3">&nbsp;</td>
</tr>

        </table>
        </fieldset>
        </div>

        <div class="panel">
        <fieldset class="fieldset">
        <legend><strong>Other Records</strong></legend>
        <table width="95%" border="0" align="center">

<tr>
    <td colspan="3">&nbsp;</td>
</tr>

<tr>
    <td class="alt2"><img src="images/statistik/misc/antworten.gif" alt="Largest Thread" width="14" height="14" border="0" /> </td>
    <td class="alt2">Largest Thread:</td>
    <td class="alt2"><a title="$maxthread_titel_long" href="showthread.php?threadid=$maxthread_id">$maxthread_titel</a> <br />
    with <strong>$maxthread_antworten</strong> replies<br/>
    <a onclick="NewWindow(this.href,'statistik','640','480','yes','center');return false" onfocus="this.blur()" title="Show the $maxthread_limit Threads in a PopUp Window" href="statistik.php?do=maxthread_popup">
        Show $maxthread_limit Threads (PopUp Window)</a></td>
</tr>

<tr>
    <td><img src="images/statistik/misc/ansehen.gif" alt="Most Popular Thread" width="14" height="14" border="0" /></td>
    <td>Most Popular Thread: </td>
    <td><a title="$mostpopular_titel_long" href="showthread.php?threadid=$mostpopular_id">$mostpopular_titel</a> <br />
    with <strong>$mostpopular_views</strong> views<br/>
    <a onclick="NewWindow(this.href,'statistik','640','480','yes','center');return false" onfocus="this.blur()"
    title="Show the $mostpopular_limit most Popular Threads in a PopUp Window" href="statistik.php?do=mostpopular_popup">
        Show the $mostpopular_limit Most Popular Threads</a></td>
</tr>

<tr>
    <td class="alt2"><img src="images/statistik/misc/poular_forum.gif" alt="Most Popular Forum:" width="14" height="14" border="0" /></td>
    <td class="alt2">Most Popular Forum:</td>
    <td class="alt2"><a title="$popularforum_titel" href="forumdisplay.php?forumid=$popularforum_id">$popularforum_titel</a> <br />
    with <strong>$popularforum_antworten</strong> posts<br/>
    <a onclick="NewWindow(this.href,'statistik','640','480','yes','center');return false" onfocus="this.blur()" title="Show the $popularforum_limit Most Popular Forums in a PopUp Window" href="statistik.php?do=popularforum_popup">
        Show the $popularforum_limit Most Popular Forums</a></td>
</tr>

<tr>
    <td colspan="3">&nbsp;</td>
</tr>

<tr>
    <td class="tcat" colspan="3"><div align="center">Absolute records</div></td>
</tr>

<tr>
        <td colspan="3">&nbsp;</td>
</tr>

<tr>
    <td class="alt2">
    <img src="images/statistik/misc/mostonline.gif" alt="Most users ever online" width="14" height="14" border="0" /></td>
    <td class="alt2" colspan="2">Most users ever online was <strong>$maxusers[maxonline]</strong>,<strong>$recorddate</strong> at <strong>$recordtime </strong></td>
</tr>

<tr>
    <td><img src="images/statistik/misc/newusers.gif" alt="Most new registrations" width="14" height="14" border="0" /></td>
    <td colspan="2">Most new registrations was <strong>$getmostregister_tag</strong>
        with <strong>$getmostregister_user New Members</strong> <br />
        <a onclick="NewWindow(this.href,'statistik','440','480','yes','center');return false" title="Show the $popularforum_limit days with the Most new registrations in a PopUp Window" href="statistik.php?do=mostregister_popup">
        Show $mostregister_limit days</a>
    </td>
</tr>

<tr>
  <td class="alt2"><img src="images/statistik/misc/onlines.gif" alt="Most registered Member visited" width="14" height="14" border="0" /></td>
  <td class="alt2" colspan="2">Most registered member visits was <strong>$getmost_member_tag</strong>
        with <strong>$getmost_member_user</strong> Members<br />
        <a onclick="NewWindow(this.href,'statistik','540','480','yes','center');return false" title="Show the $visit_limit days with the most registered Member visited in a PopUp Window" href="statistik.php?do=visit_popup">
        Show $visit_limit days</a>
  </td>
</tr>

<tr>
    <td><img src="images/statistik/misc/threads.gif" alt="written the most new threads" width="14" height="14" border="0" /></td>
    <td colspan="2">Most new threads was <strong>$getmost_threads_tag</strong>
        with <strong>$getmost_threads_sum</strong> New Threads <br />
    <a onclick="NewWindow(this.href,'statistik','540','480','yes','center');return false" onfocus="this.blur()" title="Show the $mostthread_limit days written the most new threads in a PopUp Window" href="statistik.php?do=mostthread_popup">
        Show $mostthread_limit days</a>
    </td>
</tr>

<tr>
    <td class="alt2"><img src="images/statistik/misc/posts.gif" alt="Written the most new posts" width="14" height="14" border="0" /></td>
    <td class="alt2"colspan="2">Most new posts was <strong>$getmost_posts_tag</strong>
        with <strong>$getmost_posts_sum</strong> New Posts<br />
    <a onclick="NewWindow(this.href,'statistik','540','480','yes','center');return false" onfocus="this.blur()" title="Show the $mostpost_limit days with the most new posts in a PopUp Window" href="statistik.php?do=mostpost_popup">
        Show $mostpost_limit days</a>

    </td>
</tr>

<tr>
    <td colspan="3">&nbsp;</td>
</tr>

        </table>
        </fieldset>
        </div>

        <div class="panel">
        <fieldset class="fieldset">
        <legend><strong>Avatars / Profile Pics</strong></legend>
        <table width="95%" border="0" align="center">

<tr>
    <td colspan="3">&nbsp;</td>
</tr>

<tr>
    <td class="alt2"><img src="images/statistik/misc/noavatar.gif" alt="Users Without Avatar" width="14" height="14" border="0" /></td>
    <td class="alt2">Users Without Avatar: </td>
    <td class="alt2"><img src="images/statistik/bar1.gif" alt="Users Without Avatar" width="$kein_avatarbar" height="10" border="0" /> $prozent_avatar % ($kein_avatar)</td>
</tr>

<tr>
    <td><img src="images/statistik/misc/mit_avatar.gif" alt="Users with Avatar" width="14" height="14" border="0" /></td>
    <td>Users with Avatar: </td>
    <td><img src="images/statistik/bar2.gif" alt="Users with Avatar" width="$mit_avatarbar" height="10" border="0" /> $prozent_mit_avatar % ($alle_avatars)</td>
</tr>

<tr>
    <td class="alt2"><img src="images/statistik/misc/noavantar.gif" alt="Users Without Profile Pic" width="14" height="14" border="0" /></td>
    <td class="alt2">Users Without Profile Pic: </td>
    <td class="alt2"><img src="images/statistik/bar3.gif" alt="Users Without Profile Pic" width="$kein_profilpicbar" height="10" border="0" /> $prozent_profilpic % ($kein_profilpic)</td>
</tr>

<tr>
    <td><img src="images/statistik/misc/mit_profil.gif" alt="Users with Profile Pic" width="14" height="14" border="0" /></td>
    <td>Users with Profile Pic: </td>
    <td><img src="images/statistik/bar4.gif" alt="Users with Profile Pic" width="$mit_profilpicbar" height="10" border="0" /> $prozent_mit_profilpic % ($alle_profilpics)</td>
</tr>

<tr>
    <td colspan="3">&nbsp;</td>
</tr>

        </table>
        </fieldset>
        </div>
        </td>
        </tr>

<tr>
    <td class="tcat" colspan="2">&nbsp;</td>
</tr>

        </table>

$statistic_footer

Onkel_Tom 08-23-2004 10:20 AM
Quote:
Originally Posted by Zelda-King
On both version 1 and this version some of the most popular user countries don't show for me. I have remote countries like the Seychelles listed but not the UK/US.

... The English templates still need a lot of work, and it's not just the language. The notation isn't consistant. For example some statistic fields have a : after them and others do not.
Hmm, UK and US are listed in the database table "statistik_laender" as unique entry, so the statistic should also identify all visitors from this countries.

Countries are identified by the following lines in function_statistik.php
Code:
$ip = $_SERVER['REMOTE_ADDR'];
  $fullhost = gethostbyaddr($ip);
and the Browserlanguage in the same file by:
Code:
$sprache = $_SERVER['HTTP_ACCEPT_LANGUAGE'];
If your server can't handle this request, $_server needs PHP < 4.1.0, you should upgrade php or use older syntax for php > 4.0.1

btw. you are using the old template STATISTICS which has more missed translations than my new one...
and sorry for that, we are germans which are not english professionals ;)
but we are understanding english as well :D

For the notation I will update missing ":" in the next update.

Zelda-King 08-23-2004 10:44 AM
Oh I don't expect you Germans to translate it to English at all. You've done admirably to even have a remote English version. I was just surprised with such a popular hack, that there hasn't been more member support to get it fully translated. Fortunately I still remember some German.

Zelda-King 08-23-2004 10:48 AM
Incidentally I'm using PHP 4.3.8 / MySQL 4.0.20-standard

Here's my URL: http://www.gamercrossfire.net/bb/sta...p?do=countries

Wential 08-23-2004 11:02 AM
Yeah after 10+ hours of stats collecting, I don't have any USA listings either. The UK one seems to be working though.

Zelda-King 08-23-2004 11:09 AM
Now I have England showing under browser language, but not visitor host. My host is English.

Onkel_Tom 08-23-2004 12:16 PM
Can you please check what is the output of this script on your browser wenn you upload a file with this content:

PHP Code:
<?php 

   $ip = $_SERVER['REMOTE_ADDR'];
   $fullhost = gethostbyaddr($ip);
   $at = preg_replace("/^[^.]+./", "*.", $fullhost);
   $hostdot  = ".";
   $hoster    = strrchr($at, $hostdot);
   $sprache = $_SERVER['HTTP_ACCEPT_LANGUAGE'];
   
 
   echo "<b>IP Adress:</b> $ip</br \>";
   echo "<b>full hostname:</b> $fullhost</br \>";
   echo "<b>only TLD of hostname:</b> $at</br \>";
   echo "<b>country of hoster(provider):</b> $hoster</br \>";
   echo "<b>your language:</b> $sprache</br \>";
   
   
?>
Mine looks like:
Code:
IP Adress: 80.131.xxx.xxx
full hostname: pxxxxxx.dip0.t-ipconnect.de
only end of hostname: *.dip0.t-ipconnect.de
country of hoster(provider): .de
your language: de
If visitors uses software tools like Norton Internet Security which can suppress Browser output of this information you will get "unknown" result in your statistics.

Zelda-King 08-23-2004 01:00 PM
I'm on it. In the meantime here's a new English STATISTIC template for you based on the english2.zip file (last update before this post).

Code:
$statistic_header
<script language="JavaScript" type="text/javascript">
<!--
var win=null;

function NewWindow(mypage,myname,w,h,scroll,pos){
if(pos=="random"){LeftPosition=(screen.width)?Math.floor(Math.random()*(screen.width-w)):100;TopPosition=(screen.height)?Math.floor(Math.random()*((screen.height-h)-75)):100;}
if(pos=="center"){LeftPosition=(screen.width)?(screen.width-w)/2:100;TopPosition=(screen.height)?(screen.height-h)/2:100;}
else if((pos!="center" && pos!="random") || pos==null){LeftPosition=0;TopPosition=20}
settings='width='+w+',height='+h+',top='+TopPosition+',left='+LeftPosition+',scr  ollbars='+scroll+',location=no,directories=no,status=no,menubar=no,toolbar=no,re  sizable=no';
win=window.open(mypage,myname,settings);}
// -->
</script>

<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">

<tr>
    <td class="tcat" colspan="2"><div align="center"><strong>Statistic Overview</strong></div></td>
</tr>

<tr>
        <td class="panelsurround">
        <div class="panel">
        <fieldset class="fieldset">
        <legend><strong>Topics/Threads/Users/Hits</strong></legend>
        <table width="95%" border="0" align="center" cellpadding="0" cellspacing="$stylevar[formspacer]">

<tr>
    <td colspan="2">&nbsp;</td>
</tr>

<tr>
    <td class="alt2">Threads:</td>
        <td class="alt2">$Themen</td>
</tr>

<tr>
  <td>Posts:</td>
    <td>$Beitraege</td>
</tr>
<tr>
  <td class="alt2">Thread Views:</td>
  <td class="alt2">$Beitraege_gelesen (? $Beitraege_durchschnitt times)</td>
</tr>
<tr>
  <td>Registered Members:</td>
    <td>$Member</td>
</tr>
<tr>
  <td class="alt2">Visitors:</td>
  <td class="alt2">$Besucher*</td>
</tr>
<tr>
    <td>Website Hits:</td>
    <td>$Seitenaufrufe*</td>
</tr>
<tr>
    <td class="tcat" colspan="2"><div align="center">* - Since Statistics
                started on $statistikaktiv</div></td>
</tr>

<tr>
  <td colspan="2">&nbsp;</td>
</tr>

        </table>
        </fieldset>
        </div>
        <div class="panel">
        <fieldset class="fieldset">
    <legend><strong>User Activity</strong></legend>
    <table width="95%" border="0" align="center">

<tr>
  <td colspan="3">&nbsp;</td>
</tr>

<tr>
  <td class="alt2" width="30%">Active users: </td>
  <td class="alt2" width="70%">$aktive_user_prozent % ($aktive_user) have posted*</td>
  <td class="alt2" width="70%"> <img src="images/statistik/bar5.gif" alt="Users which have posted on this board" width="$aktive_user_bar" height="10" border="0" /></td>
</tr>

<tr>
    <td>Inactive Users: </td>
    <td>$unaktive_user_prozent % ($alle_unaktiven_user) have never posted*</td>
    <td> <img src="images/statistik/bar10.gif" alt="Users which never posted on this board" width="$unaktive_user_bar" height="10" border="0" /></td>
</tr>

<tr>
    <td>&nbsp;</td>
    <td colspan="2" class="tcat"><div align="center">*Since $vboptions[bbtitle] came online</div></td>
</tr>

<tr>
    <td colspan="3">&nbsp;</td>
</tr>

<tr>
    <td class="tfoot" colspan="3"><div align="center">Visits of registered Members for the last 30, 14 and 7 days </div></td>
</tr>

<tr>
  <td class="alt2">The last 30 days:</td>
  <td class="alt2"colspan="2">
  <img src="images/statistik/bar1.gif" alt="Visits from registered Members in the last 30 days" width="$bar_aktiv_user1" height="10" border="0" />
    $aktiven_user1_prozent % ($aktiven_user1)</td>
</tr>

<tr>
  <td>The last 14 days:</td>
  <td colspan="2"> <img src="images/statistik/bar2.gif" alt="Visits from registered Members in the last 14 days" width="$bar_aktiv_user2" height="10" border="0" />
    $aktiven_user2_prozent %($aktiven_user2)</td>
</tr>

<tr>
  <td class="alt2">The last 7 days:</td>
  <td class="alt2"colspan="2">
  <img src="images/statistik/bar3.gif" alt="Visits from registered Members in the last 7 days" width="$bar_aktiv_user3" height="10" border="0" />
    $aktiven_user3_prozent %($aktiven_user3)</td>
</tr>

<tr>
    <td>No visit in the last 30 days:</td>
    <td colspan="2">
    <img src="images/statistik/bar4.gif" alt="Members which has not visited $vboptions[bbtitle] for more than 30 days!" width="$bar_aktiv_user4" height="10" border="0" />
    $aktiven_user4_prozent % ($aktiven_user4) </td>
</tr>

<tr>
    <td colspan="3">&nbsp;</td>
</tr>

        </table>
        </fieldset>
        </div>

        <div class="panel">
        <fieldset class="fieldset">
    <legend><strong>Private Messages </strong></legend>
    <table width="95%" border="0" align="center">

<tr>
    <td colspan="2">&nbsp;</td>
</tr>

<tr>
    <td class="alt2">Total PMs written:</td>
    <td class="alt2">$PMS</td>
</tr>

<tr>
    <td>Total PMs stored in database:</td>
    <td>$alle_pm ($pm_ungelesen unread)</td>
</tr>

<tr>
  <td class="alt2">Memory used by PMs:</td>
  <td class="alt2">$pm_speicher_in_kb kb ($pm_speicher_in_mb mb)</td>
</tr>

<tr>
    <td colspan="2">&nbsp;</td>
</tr>

        </table>
        </fieldset>
        </div>

        <div class="panel">
        <fieldset class="fieldset">
    <legend><strong>Database and Server</strong></legend>
    <table width="95%" border="0" align="center">

<tr>
    <td colspan="3">&nbsp;</td>
</tr>

<tr>
    <td class="alt2"><img src="images/statistik/misc/database.gif" alt="Database Size" width="14" height="14" border="0" /></td>
    <td class="alt2">Database Size:</td>
    <td class="alt2">$datenbank_in_kb kb ($datenbank_in_mb mb)</td>
</tr>

<tr>
    <td><img src="images/statistik/misc/serverinfo.gif" alt="Server Info" width="14" height="14" border="0" /></td>
    <td>Server Information:</td>
    <td>$serverinfo</td>
</tr>

<tr>
  <td class="alt2"><img src="images/statistik/misc/mysqlinfo.gif" alt="MYSQL Version" width="14" height="14" border="0" /></td>
  <td class="alt2">MySQL Version:</td>
  <td class="alt2">$mysqlversion</td>
</tr>

<tr>
    <td><img src="images/statistik/misc/smilie.gif" alt="Smilies" width="14" height="14" border="0" /></td>
    <td>Usable Smilies:</td>
    <td>$alle_smilies total</td>
</tr>

<tr>
  <td class="alt2"><img src="images/statistik/misc/anhaenge.gif" alt="Stored Attachments" width="14" height="14" border="0" /></td>
  <td class="alt2">Stored Attachments:</td>
  <td class="alt2">$alle_anhaenge</td>
</tr>

<tr>
    <td><img src="images/statistik/misc/anhaenge1.gif" alt="Space Used by Attachments" width="14" height="14" border="0" /></td>
    <td>Memory used by Attachments:</td>
    <td>$anhaenge_speicher_in_kb kb ($anhaenge_speicher_in_mb mb)</td>
</tr>

<tr>
    <td class="alt2"><img src="images/statistik/misc/auge.gif" alt="Attachments viewed or downloaded" width="14" height="14" border="0" /></td>
    <td class="alt2">Attachments Hits:</td>
    <td class="alt2">$alle_downloads times</td>
</tr>

<tr>
    <td colspan="3">&nbsp;</td>
</tr>

        </table>
        </fieldset>
        </div>
        </td>

        <td valign="top" class="panelsurround">
        <div class="panel">
        <fieldset class="fieldset">
        <legend><strong>The Top 5 Posters</strong></legend>
        <table width="95%" border="0" align="center" cellpadding="0" cellspacing="$stylevar[formspacer]">

<tr>
    <td colspan="3">&nbsp;</td>
</tr>

<tr>
    <td class="alt2"><img src="images/statistik/misc/goldmedal.gif" alt="Gold Medal Winner" width="14" height="14" border="0" /></td>
    <td class="alt2"><a title="Show $postername1's profile" href="member.php?u=$posterid1">
    $postername1</a></td>
    <td class="alt2"><img src="images/statistik/bar1.gif" alt="Gold Medal Winner" width="$maxposter1_bar" height="10" border="0" />
        with $poster_beitragszahl1 posts ($maxposter1_prozent %)</td>
</tr>

<tr>
    <td><img src="images/statistik/misc/silvermedal.gif" alt="Silver Medal Winner" width="14" height="14" border="0" /></td>
    <td><a title="Show $postername2's profile" href="member.php?u=$posterid2">
    $postername2</a></td>
    <td><img src="images/statistik/bar2.gif" alt="Silver Medal Winner" width="$maxposter2_bar" height="10" border="0" />
    with $poster_beitragszahl2 posts ($maxposter2_prozent %)</td>
</tr>

<tr>
    <td class="alt2"><img src="images/statistik/misc/bronzemedal.gif" alt="Bronze Medal Winner" width="14" height="14" border="0" /></td>
    <td class="alt2"><a title="Show $postername3's profile" href="member.php?u=$posterid3">
    $postername3</a></td>
    <td class="alt2"><img src="images/statistik/bar3.gif" alt="Bronze Medal Winner" width="$maxposter3_bar" height="10" border="0" />
        with $poster_beitragszahl3 posts ($maxposter3_prozent %)</td>
</tr>

<tr>
    <td><img src="images/statistik/misc/ananas.gif" alt="Golden pineapple" width="14" height="14" border="0" /></td>
    <td> <a title="Show $postername4's profile" href="member.php?u=$posterid4">
    $postername4</a></td>
    <td><img src="images/statistik/bar4.gif" alt="Golden pineapple" width="$maxposter4_bar" height="10" border="0" />
    with $poster_beitragszahl4 posts ($maxposter4_prozent %)</td>
</tr>

<tr>
    <td class="alt2"><img src="images/statistik/misc/lollipop.gif" alt="Just a Lollipop" width="14" height="14" border="0" /></td>
    <td class="alt2"><a title="Show $postername5's profile" href="member.php?u=$posterid5">
    $postername5</a></td>
    <td class="alt2"><img src="images/statistik/bar5.gif" alt="Lollipop" width="$maxposter5_bar" height="10" border="0" />
        with $poster_beitragszahl5 posts ($maxposter5_prozent %)</td>
</tr>

<tr>
  <td colspan="3"><br />These members have a combined total of $maxposter_summe posts!!<br />
        <a onclick="NewWindow(this.href,'statistik','640','480','yes','center');return false" onfocus="this.blur()" title="Show the $topposter_limit Top Posters in a PopUp Window" href="statistik.php?do=topposter_popup">
        Show Top $topposter_limit Posters (PopUp Window)</a>
        </td>
</tr>

<tr>
    <td colspan="3">&nbsp;</td>
</tr>

        </table>
        </fieldset>
        </div>

        <div class="panel">
        <fieldset class="fieldset">
        <legend><strong>Other Records</strong></legend>
        <table width="95%" border="0" align="center">

<tr>
    <td colspan="3">&nbsp;</td>
</tr>

<tr>
    <td class="alt2"><img src="images/statistik/misc/antworten.gif" alt="Largest Thread" width="14" height="14" border="0" /> </td>
    <td class="alt2">Largest Thread:</td>
    <td class="alt2"><a title="$maxthread_titel_long" href="showthread.php?threadid=$maxthread_id">$maxthread_titel</a> <br />
    with <strong>$maxthread_antworten</strong> replies<br/>
    <a onclick="NewWindow(this.href,'statistik','640','480','yes','center');return false" onfocus="this.blur()" title="Show the $maxthread_limit Threads in a PopUp Window" href="statistik.php?do=maxthread_popup">
        Show $maxthread_limit Threads (PopUp Window)</a></td>
</tr>

<tr>
    <td><img src="images/statistik/misc/ansehen.gif" alt="Most Popular Thread" width="14" height="14" border="0" /></td>
    <td>Most Popular Thread:</td>
    <td><a title="$mostpopular_titel_long" href="showthread.php?threadid=$mostpopular_id">$mostpopular_titel</a> <br />
    with <strong>$mostpopular_views</strong> views<br/>
    <a onclick="NewWindow(this.href,'statistik','640','480','yes','center');return false" onfocus="this.blur()"
    title="Show the $mostpopular_limit most Popular Threads in a PopUp Window" href="statistik.php?do=mostpopular_popup">
        Show the $mostpopular_limit Most Popular Threads (PopUp Window)</a></td>
</tr>

<tr>
    <td class="alt2"><img src="images/statistik/misc/poular_forum.gif" alt="Most Popular Forum" width="14" height="14" border="0" /></td>
    <td class="alt2">Most Popular Forum:</td>
    <td class="alt2"><a title="$popularforum_titel" href="forumdisplay.php?forumid=$popularforum_id">$popularforum_titel</a> <br />
    with <strong>$popularforum_antworten</strong> posts<br/>
    <a onclick="NewWindow(this.href,'statistik','640','480','yes','center');return false" onfocus="this.blur()" title="Show the $popularforum_limit Most Popular Forums in a PopUp Window" href="statistik.php?do=popularforum_popup">
        Show the $popularforum_limit Most Popular Forums (PopUp Window)</a></td>
</tr>

<tr>
    <td colspan="3">&nbsp;</td>
</tr>

<tr>
    <td class="tcat" colspan="3"><div align="center">Absolute Records</div></td>
</tr>

<tr>
        <td colspan="3">&nbsp;</td>
</tr>

<tr>
    <td class="alt2">
    <img src="images/statistik/misc/mostonline.gif" alt="Most users ever online" width="14" height="14" border="0" /></td>
    <td class="alt2" colspan="2">Most users ever online was <strong>$maxusers[maxonline]</strong>, on <strong>$recorddate</strong> at <strong>$recordtime </strong></td>
</tr>

<tr>
    <td><img src="images/statistik/misc/newusers.gif" alt="Most new registrations" width="14" height="14" border="0" /></td>
    <td colspan="2">Most new registrations was on  <strong>$getmostregister_tag</strong>
        with <strong>$getmostregister_user New Members</strong> <br />
        <a onclick="NewWindow(this.href,'statistik','440','480','yes','center');return false" title="Show the $popularforum_limit days with the Most new registrations in a PopUp Window" href="statistik.php?do=mostregister_popup">
        Show $mostregister_limit days (PopUp Window)</a>
    </td>
</tr>

<tr>
  <td class="alt2"><img src="images/statistik/misc/onlines.gif" alt="Most registered members visited" width="14" height="14" border="0" /></td>
  <td class="alt2" colspan="2">Most visits by registered members was on  <strong>$getmost_member_tag</strong>
        with <strong>$getmost_member_user</strong> Members<br />
        <a onclick="NewWindow(this.href,'statistik','540','480','yes','center');return false" title="Show the $visit_limit days when the most registered members visited in a PopUp Window" href="statistik.php?do=visit_popup">
        Show $visit_limit days (PopUp Window)</a>
  </td>
</tr>

<tr>
    <td><img src="images/statistik/misc/threads.gif" alt="written the most new threads" width="14" height="14" border="0" /></td>
    <td colspan="2">Most new threads posted was on  <strong>$getmost_threads_tag</strong>
        with <strong>$getmost_threads_sum</strong> New Threads <br />
    <a onclick="NewWindow(this.href,'statistik','540','480','yes','center');return false" onfocus="this.blur()" title="Show the $mostthread_limit days with the most new threads posted in a PopUp Window" href="statistik.php?do=mostthread_popup">
        Show $mostthread_limit days (PopUp Window)</a>
    </td>
</tr>

<tr>
    <td class="alt2"><img src="images/statistik/misc/posts.gif" alt="Written the most new posts" width="14" height="14" border="0" /></td>
    <td class="alt2"colspan="2">Most new posts written was on  <strong>$getmost_posts_tag</strong>
        with <strong>$getmost_posts_sum</strong> New Posts<br />
    <a onclick="NewWindow(this.href,'statistik','540','480','yes','center');return false" onfocus="this.blur()" title="Show the $mostpost_limit days with the most new posts in a PopUp Window" href="statistik.php?do=mostpost_popup">
        Show $mostpost_limit days (PopUp Window)</a>

    </td>
</tr>

<tr>
    <td colspan="3">&nbsp;</td>
</tr>

        </table>
        </fieldset>
        </div>

        <div class="panel">
        <fieldset class="fieldset">
        <legend><strong>Avatars / Profile Pics</strong></legend>
        <table width="95%" border="0" align="center">

<tr>
    <td colspan="3">&nbsp;</td>
</tr>

<tr>
    <td class="alt2"><img src="images/statistik/misc/noavatar.gif" alt="Users Without Avatar" width="14" height="14" border="0" /></td>
    <td class="alt2">Users Without Avatar: </td>
    <td class="alt2"><img src="images/statistik/bar1.gif" alt="Users Without Avatar" width="$kein_avatarbar" height="10" border="0" /> $prozent_avatar % ($kein_avatar)</td>
</tr>

<tr>
    <td><img src="images/statistik/misc/mit_avatar.gif" alt="Users with Avatar" width="14" height="14" border="0" /></td>
    <td>Users with Avatar: </td>
    <td><img src="images/statistik/bar2.gif" alt="Users with Avatar" width="$mit_avatarbar" height="10" border="0" /> $prozent_mit_avatar % ($alle_avatars)</td>
</tr>

<tr>
    <td class="alt2"><img src="images/statistik/misc/noavantar.gif" alt="Users Without Profile Pic" width="14" height="14" border="0" /></td>
    <td class="alt2">Users Without Profile Pic: </td>
    <td class="alt2"><img src="images/statistik/bar3.gif" alt="Users Without Profile Pic" width="$kein_profilpicbar" height="10" border="0" /> $prozent_profilpic % ($kein_profilpic)</td>
</tr>

<tr>
    <td><img src="images/statistik/misc/mit_profil.gif" alt="Users with Profile Pic" width="14" height="14" border="0" /></td>
    <td>Users with Profile Pic: </td>
    <td><img src="images/statistik/bar4.gif" alt="Users with Profile Pic" width="$mit_profilpicbar" height="10" border="0" /> $prozent_mit_profilpic % ($alle_profilpics)</td>
</tr>

<tr>
    <td colspan="3">&nbsp;</td>
</tr>

        </table>
        </fieldset>
        </div>
        </td>
        </tr>

<tr>
    <td class="tcat" colspan="2">&nbsp;</td>
</tr>

        </table>

$statistic_footer

Zelda-King 08-23-2004 01:04 PM
Quote:
Can you please check what is the output of this script on your browser...
Code:
IP Adress: xxx.xx.xx.xx
full hostname: hostxxx-xx-xx-xx.rangexxx-xx.btcentralplus.com
only TLD of hostname: *.rangexxx-xx.btcentralplus.com
country of hoster(provider): .com
your language: en-us,en;q=0.5
(That's with and without my ZoneAlarm Security Suite switched on.)

Onkel_Tom 08-23-2004 01:13 PM
what happens if your are changing the following line in file functions_statistik.php

search for:
Code:
elseif(ereg("us", $sprache))$browser_sprache="UnitedStates";
and replace by:
Code:
elseif(ereg("en-us", $sprache))$browser_sprache="UnitedStates";

Zelda-King 08-23-2004 01:17 PM
It still isn't showing America. I'll leave the file like that until directed otherwise and give you the link: http://www.gamercrossfire.net/bb/sta...p?do=countries
(Note: STATISTIC template updated in above post.)

Just a couple of things in some other templates I ironed out;

statistic_polls:

Code:
$statistic_header
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
  <tr>
    <td class="tcat" colspan="2"><div align="center"><strong>Polls / Stickys /
        Searchwords</strong></div></td>
  </tr>
  <tr>
    <td colspan="2"> <div class="panel">
        <fieldset class="fieldset">
        <legend><strong>The last $poll_limit Polls</strong></legend>
        <div align="center">
          <table width="95%" border="0">
            <tr>
              <td class="thead"><div align="center"><strong>Title</strong></div></td>
              <td class="thead"><div align="center"><strong>Starter</strong></div></td>
              <td class="thead"><div align="center"><strong>Poll</strong></div></td>
              <td class="thead"><div align="center"><strong>Date</strong></div></td>
              <td class="thead"><div align="center"><strong>Answer possibilities</strong></div></td>
              <td class="thead"><div align="center"><strong>Voted</strong></div></td>
              <td class="thead"><div align="center"><strong>Opened</strong></div></td>
              <td class="thead"><div align="center"><strong>Ends</strong></div></td>
              <td class="thead"><div align="center"><strong>Multiple choice</strong></div></td>
              <td class="thead"><div align="center"><strong>Public</strong></div></td>
              <td class="thead"><div align="center"><strong>Views</strong></div></td>
            </tr>
            $statistic_polls_bit
          </table>
          <table width="95%" border="0">
            <tr>
              <td>&nbsp;</td>
            </tr>
            <tr>
              <td class="thead"><div align="right"><img src="images/statistik/misc/daumenhoch.gif" alt="activ" width="15" height="15" />
                  active <img src="images/statistik/misc/daumenrunter.gif" alt="inactive" width="15" height="15" />
                                inactive</div></td>
            </tr>
          </table>
        </div>
        </fieldset>
      </div></td>
  </tr>
  <tr>
    <td valign="top"> <div class="panel">
        <fieldset class="fieldset">
        <legend><strong>The last $sticky_limit sticky threads</strong></legend>
        <table width="95%" border="0" align="center">
          <tr>
            <td colspan="4">&nbsp;</td>
          </tr>
          <tr>
            <td class="thead"><div align="center"><strong>Title</strong></div></td>
            <td class="thead"><div align="center"><strong>Author</strong></div></td>
            <td class="thead"><div align="center"><strong>Date</strong></div></td>
            <td class="thead"><div align="center"><strong>views</strong></div></td>
          </tr>
          $statistic_sticky_bit
        </table>
        </fieldset>
      </div>
      </td>
    <td valign="top"> <div class="panel">
        <fieldset class="fieldset">
        <legend><strong>The latest&nbsp; $search_limit Searchwords (Big Brother is watching you)</strong></legend>
        <table width="95%" border="0" align="center">
          <tr>
            <td colspan="3">&nbsp;</td>
          </tr>
          <tr>
            <td class="thead"><div align="center"><strong>Search word</strong></div></td>
            <td class="thead"><div align="center"><strong>searched on</strong></div></td>
            <td class="thead"><div align="center"><strong>needed time to find</strong></div></td>
          </tr>
          $statistic_search_bit
        </table>
      <table width="95%" border="0" align="center">
        <tr>
          <td><div align="right"><img src="images/statistik/misc/bag.gif" alt="This was a search for latest threads (Not a real search query)" width="20" height="21" border="0" />
              Search for latest threads (Not a real search query)</div></td>
        </tr>
      </table>
        </fieldset>
      </div>
</td>
  </tr>
  <tr>
    <td class="tcat" colspan="2">&nbsp;</td>
  </tr>
</table>

$statistic_footer
statistic_last_x_days
Code:
$statistic_header

<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
  <tr>
    <td class="tcat" colspan="2"><div align="center"><strong>Statistics for the
                last $xtage_limit days and the last $xthemen_limit threads</strong></div></td>
  </tr>
  <tr>
<td valign="top" class="panelsurround">
    <div class="panel">
        <fieldset class="fieldset">
        <legend><strong>The last $xtage_limit days</strong></legend>

        <table width="95%" border="0" cellpadding="0" cellspacing="$stylevar[formspacer]">
          <tr>
            <td class="thead"><div align="center"><strong>Date</strong></div></td>
            <td class="thead"><div align="center"><strong>New Registrations</strong></div></td>
            <td class="thead"><div align="center"><strong>New Threads</strong></div></td>
            <td class="thead"><div align="center"><strong>New Posts</strong></div></td>
            <td class="thead"><div align="center"><strong>Registered Members Visits</strong></div></td>
          </tr>
          $statistic_last_x_result_bit
        </table>
                </fieldset>
                </div>
</td>

<td valign="top" class="panelsurround">
    <div class="panel">
        <fieldset class="fieldset">
    <legend><strong>The last $xthemen_limit threads</strong></legend>
    <table width="95%" border="0" align="center" cellpadding="0" cellspacing="$stylevar[formspacer]">
    <tr>
            <td class="thead"><div align="center"><strong>Date</strong></div></td>
    </tr>
          $statistic_last_x_threads_bit
        </table>
      </fieldset>
        </div>
</td>
  </tr>
  <tr>
    <td class="tcat" colspan="2">&nbsp;</td>
  </tr>
</table>

$statistic_footer
I think that's most grammatical discrepancies dealt with now.

Onkel_Tom 08-23-2004 01:53 PM
Okay, I think I found the problem !
The countrynames in table "statistik_laender" are not identical with the Names given in file "functions_statistik.php"
So the query
Code:
$DB_site->query("
                UPDATE " . TABLE_PREFIX . "statistik_laender
                SET Zaehler_Browsersprache  = Zaehler_Browsersprache  +1
                WHERE (Name_Land  = '$browser_sprache')
                ");
can't work while trying to compare "Name_Land" with "$browser_sprache"....

Zelda-King, if you can do me favour, please replace the following line in file functions_statistik.php:
Code:
elseif(ereg("us", $sprache))$browser_sprache="UnitedStates";
with:
Code:
elseif(ereg("us", $sprache))$browser_sprache="United States";
and try if it works. The problem only occur on countries with 2 separated words like United States, United Kingdom etc.
Countries like Germany, Venezuela etc. are working

So I have to fix the complete 2 listings in functions_statistik.php for Browser language and countries by host :tired:

Wential 08-23-2004 02:05 PM
United States listings are working now. Thanks!

Zelda-King 08-23-2004 02:08 PM
I don't quite follow... well I understand the problem but there is no 'file' called statistik_laender so do you mean I should change the database table statistik_laender or alter the functions_statistik.php? I've changed the reference to the United States in functions_statistik.php. No show of America yet... I suppose I have to wait until some more Americans show up again.

Wential 08-23-2004 02:41 PM
I just changed the line to this elseif(ereg("us", $sprache))$browser_sprache="United States"; and it started working.

Zelda-King 08-23-2004 02:59 PM
The browser thing is working for me now. I applied the same change to the visitor countries section but I'm having no joy yet.

Onkel_Tom 08-23-2004 03:08 PM
Quote:
Originally Posted by Zelda-King
I don't quite follow... well I understand the problem but there is no 'file' called statistik_laender...
Sorry, only 3 hours sleep this night, it's the file "functions_statistik.php" not statistik_laender

Onkel_Tom 08-23-2004 03:55 PM
Okay, here we go ...
attached you will find the new file functions_statistik.php which must be copied to /include Directory and overwriting the old one.

In this file all entries are fixed to be identified from statistics Hack as correct Browser language and origin country of visitor.

Zelda-King 08-23-2004 04:13 PM
I realise you've been doing some real drudgery work on this but I'd better mention the new file has Bosnia andH erzegovina where it should have Bosnia and Herzegovina.

Well I still have a problem with certain countries showing on Visitor Countries... though the browser ones work fine, as I posted before. Weird. I know they use the same table.

Update: Ah.. United States has finally decided to show up. It doesn't seem to log everyone from there but it does initially work. Still nothing from the UK yet. :/

Zelda-King 08-23-2004 05:56 PM
Nice update. The templates STATISTIC, statistik_polls and statistic_last_x_days lack my latest updates. They're all on this page. I'm not bothered because I fixed mine myself but if you update the templates again at some point could you please use those fixes? :D

Edit: Hmm, someone's registering under two tables. United States AND Unknown. The hits and percentage was going up at the same rate until another American came online.

Here, I updated the English in the statistic_referer template:
Code:
  $statistic_header
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
  <tr>
    <td class="tcat" colspan="2"><div align="center"><strong>The latest $refrerer_limit Referers
                and the $domain_limit Top Level Domains</strong></div></td>
  </tr>
  <tr>
    <td valign="top" class="panelsurround"> <div class="panel">
        <fieldset class="fieldset">
        <legend><strong>The latest $refrerer_limit Referers</strong></legend>
        <table width="95%" border="0" align="center" cellpadding="0" cellspacing="$stylevar[formspacer]">
          <tr>
            <td>&nbsp;</td>
          </tr>
            $statistic_referer_bit

        </table>
        </fieldset>
      </div></td>
    <td valign="top" class="panelsurround"> <div class="panel">
        <fieldset class="fieldset">
        <legend><strong>The $domain_limit Top Level Domains</strong></legend>
        <table width="95%" border="0" align="center" cellpadding="0" cellspacing="$stylevar[formspacer]">
          <tr>
            <td>&nbsp;</td>
          </tr>

            $statistic_domain_bit
</table>
        </fieldset>
      </div></td>
  </tr>

  <tr>
    <td colspan="2" valign="top" class="panelsurround"><div class="panel">
        <fieldset class="fieldset">
            <legend><strong>Referers summary</strong></legend>
        <table width="auto" border="0">
          <tr>
            <td>&nbsp;</td>
          </tr>
          <tr>
            <td class="alt2"><span class="highlight">$direkte_zugriffe</span>
              visitors visited $vboptions[bbtitle] directly.</td>
          </tr>
          <tr>
            <td class="alt1"><span class="highlight">$alle_referer</span>
              visitors visited $vboptions[bbtitle] via a hyperlink (Referer).</td>
          </tr>
          <tr>
            <td class="alt2"><span class="highlight">$Anzahl_der_Referer</span>
              different hyperlinks (Referer)  referred visitors to $vboptions[bbtitle].
              </td>
          </tr>
          <tr>
            <td class="alt1"><span class="highlight">$Anzahl_der_Kurz_Referer</span>
              different referring domains referred visitors to $vboptions[bbtitle].
            </td>
          </tr>
        </table>
</fieldset>
</div>
&nbsp;</td>
  </tr>
  <tr>
    <td class="tcat" colspan="2">&nbsp;</td>
  </tr>
</table>
$statistic_footer

Zelda-King 08-23-2004 09:50 PM
I just noticed the Europe table in statistik_laender is 'Europ' (with no 'e' on the end), so the 'Europe' references in functions_statistik.php won't work surely. Oh.. and the Ascension flag is missing from the flaggen folder.

Onkel_Tom 08-24-2004 12:11 AM
Thanks Zelda-King for your translation work on the Templates !
I integrated the better english in my new zip File.

I checked the table inserts for "statistik_laender" and there is Europe with "e" in.
Also my test db has the Europe with "e" inside, so that must be a transfering or inserting error on your server.

We have both a wrong thinking about a translation in poll template. It's not "Ends" as category, it's Duration. This field doesn't show the days remaining, it shows only the configured duration of the poll ;)

What about the installation and Script executing problems ?
Does it work for all in the meanwhile ?

YamaMotoYama 08-24-2004 12:11 AM
This is an awsome hack. I installed it with only one problem: I have several users that use an apostrophe in there username. This causes sql errors. Do you know of away around this?

Thanks in advance,

Y.

Smitty 08-24-2004 12:17 AM
Quote:
Originally Posted by Onkel_Tom
We have both a wrong thinking about a translation in poll template. It's not "Ends" as category, it's Duration.
Fields:
Thread Title
Started by
Poll Question
Date
Poll Choices
Total Votes
Thread Open or Closed
Duration
Multiple Choice
'Open' Poll (Is poll open or closed)
Views

NOTE: Down at the bottom - Searches. People on my board asked why all the dots with bags. I put in this note: "General Search (Like 'Last 24 Hours' or 'Last Visit')" - http://Elsmar.com/Forums/statistik.php?do=polls

EDIT ADD: I did a few translations a bit back. I'm not going through the update until you folks finish because the stats are relative to me. That is, some of the language translations aren't important to me and the statistics it gives me are sufficient - Like 10 times what I had before and are presented well.

That said, I appreciate the fine tuning you folks are doing on this. I had a different program back in the vB 2.x days and really loved this when I saw it - this one is exceptional. I'm not a php programmer so it's all beyond me or I'l pitch in on that stuff.

Zelda-King 08-24-2004 12:40 AM
I'll just change it to 'Europe' in my database then. Not a problem.
Quote:
Originally Posted by Onkel_Tom
What about the installation and Script executing problems ?
Does it work for all in the meanwhile ?
I've had no trouble with that, and I think it's good the templates are done first. It means we who've installed the hack can make template updates easier, plus if we want to add into every style it's easy to just change the default style to any otehr mother style then just rerun the templates bit. (It doesn't inject into all styles. Just the default one, but I like that because I have a Mother - Child system anyway.)

Onkel_Tom 08-24-2004 12:44 AM
thanks Smitty for your positive feedback.
If you install the new files and Templates you get ride of the "(days)" in the duration row of the polls ;)
But you are right to wait until our fine tuning is done. It's only neccesary to download the new files for that people which have problem to get the scripts run.

@YamaMotoYama
I will check the apostrophe problem in username...

Zelda-King 08-24-2004 01:31 AM
Here's an Ascension flag (United Kingdom Academic Institutions) in case anyone else is missing one.

oldfan 08-24-2004 03:12 AM
We got a final version? If so, were can I download it :)
Thanks for all your HARD WORK Onkel_Tom!!

Zelda-King 08-24-2004 10:38 AM
A very slight grammar change was needed in the statistic_spider template:
Code:
$statistic_header
 <!-- Spider Anzeige Start -->
<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="$stylevar[cellspacing]" border="0" width="100%" align="center">
  <tr>
    <td class="tcat" colspan="2"><div align="center"><strong>Spiders and Searchrobots</strong></div></td>
  </tr>
  <tr>
    <td valign="top" class="panelsurround">
      <div class="panel">
        <fieldset class="fieldset">
        <legend><strong>Spiders</strong> ($wieviele_spider of known 93 different) <font color="#FF0000"> (Display dynamical)</font></legend>
        <table width="95%" border="0" align="center">
          <tr>
    <td>&nbsp;</td>
  </tr>
  $statistic_bots_bit
</table>

                </fieldset>

</div>
</td>

<td valign="top" class="panelsurround">
      <div class="panel">
        <fieldset class="fieldset">
            <legend><strong>Searchrobots Summary</strong></legend>
        <table width="95%" border="0" align="center">
  <tr>
            <td>$totalspider ($totalspider_in_prozent %) counted Spiders since statistics started.</td>
  </tr>
</table>
</fieldset>
</div>
</td>
  </tr>
  <tr>
    <td class="tcat" colspan="2">&nbsp;</td>
  </tr>
</table>
 <!-- Spider Anzeige Ende -->
$statistic_footer

Onkel_Tom 08-24-2004 10:41 AM
@ oldfan

You know, a final version will never be reached because of updates, additions and so on ;)
But I think we reached now a status that the hack must work on all installations without database errors and script errors, especially the apostrophe problem mentioned by YamaMotoYama. I have to check this but have no free time right now.

So I suggest for all people which have problems before with the hack to install it on your site and to help us with the bugfixing if still errors occur. Normally the installation and also the scripts must run fine now, but if nobody is testing it and waiting for a final version, we will get no final :D

@ Zelda-King
Thanks for the missing flag ;)

Onkel_Tom 08-24-2004 02:20 PM
- apostrophe problem fixed ! ;), just replace statistik.php
- also a problem in template statistic_last_x_threads_bit where fix to show the thread itself and the profile of last poster, there was missing a "?" in the syntax of 3 href lines.

- Template statistic_spider translated from Zelda-King included
- missing flag for United Kingdom Academic Institutions included, thanks Zelda-King

YamaMotoYama 08-24-2004 05:00 PM
Awsome, thank you so much.

Y.


Quote:
Originally Posted by Onkel_Tom
- apostrophe problem fixed ! ;), just replace statistik.php
- also a problem in template statistic_last_x_threads_bit where fix to show the thread itself and the profile of last poster, there was missing a "?" in the syntax of 3 href lines.

- Template statistic_spider translated from Zelda-King included
- missing flag for United Kingdom Academic Institutions included, thanks Zelda-King


new zip file with all updates right now !

LAST UPDATE of Zip File: August, 24th 05:05pm

Smitty 08-24-2004 05:14 PM
Quote:
Originally Posted by Onkel_Tom
So I suggest for all people which have problems before with the hack to install it on your site and to help us with the bugfixing if still errors occur. Normally the installation and also the scripts must run fine now, but if nobody is testing it and waiting for a final version, we will get no final :D
There have not been any changes to the database, correct? To 'upgrade' all we have to do is change the templates and the main php file, correct? Or should we just run the install script?

Wential 08-24-2004 06:02 PM
The install script still has problems in it but yes, you would just re-run the install script. Attached is my "fixed" install script, but it has been modified to put vb3_ before all the database commands as the prefix. If you use it, change vb3_ globally in the file to whatever you use as a database prefix first.

Zelda-King 08-24-2004 06:20 PM
I just noticed a lot of the flagge_link entries in statistik_laender point to noflag.gif.

Onkel_Tom 08-24-2004 08:08 PM
@ Wential
You are right !
If you include a variable from config.php like the table prefix you should also include this file in your installation script:

find in file install_statistik_english.php:
Code:
require_once('./global.php');
require_once('./includes/adminfunctions_template.php');
replace it with:
Code:
require_once('./global.php');
require_once('./includes/config.php');
require_once('./includes/adminfunctions_template.php');
and try to install again ;)

Sorry for that, my test installation has no table prefix so I'm not able to found out that we still have a problem there.

@Zelda-King
Ooooh, that's crazy because the german version of this hack has all flags in the database, but german countrynames :devious:
I will try a export from my german database table and try to replace the flags in the english version....

apokphp 08-24-2004 08:33 PM
Tom, your install script results in this error:
Quote:
Parse error: parse error, unexpected T_STRING in /home/apok/public_html/forums/admincp/install_statistik_english.php on line 340
I took out the prefix from Wentials, and it worked fine.

1 problem though. I installed this on another site before the latest English Translation install script was posted. How can I uninstall this hack on that server, so I can reinstall w/ the new English translation?


All times are GMT. The time now is 05:31 PM.
Page 6 of 14 « First 45 6 78 Last »
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01981 seconds
  • Memory Usage 2,151KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (19)bbcode_code_printable
  • (2)bbcode_php_printable
  • (9)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete