4images Forum & Community
4images Modifications / Modifikationen => Mods & Plugins (Releases & Support) => Topic started by: effemmess on June 27, 2003, 03:59:07 PM
-
Hallo an alle Statistik-Fetischisten!
ich bin dabei eine neue stats.php zu programmieren, die erstens viele Auswertungsmöglichkeiten bietet und zweitens sehr flexibel einsetzbar ist.
Die Idee dazu war geboren nach der Implementation von Vraxor´s stats.php (http://www.4homepages.de/forum/viewtopic.php?t=3303). :D
Bisher (V1.0) habe ich verschiedene Funktionalitäten zur Auswertung der user und der votes eingebaut. Weitere werden folgen... :)
Als Beispiel schaut euch folgende Site an:http://www.auf-einem-blick.de/4images/index.php
Mindestvoraussetzungen:
- 4images 1.7 :wink:
erweiterte Voraussetzungen (nicht zwingend erforderlich aber sehr hilfreich!):
- v@no´s Votes saved in DB (http://www.4homepages.de/forum/viewtopic.php?t=6123)
- effemmess´s Extension for Votes saved in DB (http://www.4homepages.de/forum/viewtopic.php?t=6404)
- effemmess´s Old votes 2 DB
(http://www.4homepages.de/forum/viewtopic.php?t=6405)
1. neue .../includes/stats.php anlegen
(vorher natürlich evtl. existierende sichern!)
einfügen:
<?PHP
//-----------------------------------------------------
//--- stats.php V1.1 by effemmess ---------------------
//--- based on Vraxor´s stats.php ---------------------
//--- for 4images V1.7 by Jan -------------------------
//-----------------------------------------------------
//-----------------------------------------------------
//--- Variableninitialisierung-------------------------
//-----------------------------------------------------
$time=time();
$m1 =60;
$h1 =$m1*60;
$T1 =$h1*24;
$T7 =$T1*7;
$T30=$T1*30;
(date("w",$time)==0) ? $date_w = 7 : $date_w = date("w",$time);
$ts_today_at_0 =mktime(0,0,0,date("m",$time),date("d",$time),date("Y",$time));
$ts_yesterday_at_0 =$ts_today_at_0-$T1;
$ts_1st_of_month =mktime(0,0,0,date("m",$time),1,date("Y",$time));
$ts_1st_of_month_before =mktime(0,0,0,date("m",$ts_1st_of_month-1),1,date("Y",$ts_1st_of_month-1));
$ts_this_monday =$ts_today_at_0-$T1*($date_w-1);
$ts_last_monday =$ts_this_monday-$T7;
$ts_24h_before =$time-$T1;
$ts_7days_before =$time-$T7;
$ts_30days_before =$time-$T30;
//-----------------------------------------------------
//--- Funktionen --------------------------------------
//-----------------------------------------------------
function sql_add($from=0,$to=0,$field){
$sql_add_from=$field." >= ".$from;
$sql_add_to =$field." <= ".$to;
$sql_add = "";
if ($from != 0 ||$to != 0){
if ($from != 0) $sql_add .=$sql_add_from;
if ($from != 0 && $to != 0) $sql_add .=" AND ";
if ($to != 0) $sql_add .=$sql_add_to;
}
return $sql_add;
}
function num_users($from=0,$to=0,$field="user_joindate"){
global $site_db, $select_mode;
if ($from != 0 ||$to != 0){
$sql_where=" AND ";
}
$sql = "SELECT COUNT(*) as users
FROM ".USERS_TABLE."
WHERE user_id <> ".GUEST.$sql_where.sql_add($from,$to,$field);
$row = $site_db->query_firstrow($sql);
$num_users = $row['users'];
return $num_users;
}
function num_votes_itable($from=0,$to=0,$field="image_date"){
global $site_db, $select_mode;
if ($from != 0 ||$to != 0){
$sql_where=" WHERE ";
}
$sql = "SELECT SUM(image_votes) AS votes
FROM ".IMAGES_TABLE.$sql_where.sql_add($from,$to,$field);
$row = $site_db->query_firstrow($sql);
$num_votes = (isset($row['votes'])) ? $row['votes'] : 0;
return $num_votes;
}
function num_votes_vtable($from=0,$to=0,$field="vote_date"){
global $site_db, $select_mode;
if ($from != 0 ||$to != 0){
$sql_where=" WHERE ";
}
$sql = "SELECT count(*) AS votes
FROM ".VOTED_TABLE.$sql_where.sql_add($from,$to,$field);
$row = $site_db->query_firstrow($sql);
$num_votes = (isset($row['votes'])) ? $row['votes'] : 0;
return $num_votes;
}
//-----------------------------------------------------
//--- Show number of Users ----------------------------
//-----------------------------------------------------
//total
$total_users = num_users();
$lang_total_users = $lang['users'];
$lang_since_begin_new_users = $lang['since_begin_new_users'];
$site_template->register_vars("total_users", $total_users);
$site_template->register_vars("lang_total_users", $lang_total_users);
$site_template->register_vars("lang_since_begin_new_users", $lang_since_begin_new_users);
unset($total_users);
unset($lang_total_users);
//today new
$today_new_users = num_users($ts_today_at_0,0);
$lang_today_new_users = $lang['today_new_users'];
$site_template->register_vars("today_new_users", $today_new_users);
$site_template->register_vars("lang_today_new_users", $lang_today_new_users);
unset($today_new_users);
unset($lang_today_new_users);
//yesterday new
$yesterday_new_users = num_users($ts_yesterday_at_0,$ts_today_at_0);
$lang_yesterday_new_users = $lang['yesterday_new_users'];
$site_template->register_vars("yesterday_new_users", $yesterday_new_users);
$site_template->register_vars("lang_yesterday_new_users", $lang_yesterday_new_users);
unset($yesterday_new_users);
unset($lang_yesterday_new_users);
//this week new
$this_week_new_users = num_users($ts_this_monday,0);
$lang_this_week_new_users = $lang['this_week_new_users'];
$site_template->register_vars("this_week_new_users", $this_week_new_users);
$site_template->register_vars("lang_this_week_new_users", $lang_this_week_new_users);
unset($this_week_new_users);
unset($lang_this_week_new_users);
//last week new
$last_week_new_users = num_users($ts_last_monday,$ts_this_monday);
$lang_last_week_new_users = $lang['last_week_new_users'];
$site_template->register_vars("last_week_new_users", $last_week_new_users);
$site_template->register_vars("lang_last_week_new_users", $lang_last_week_new_users);
unset($last_week_new_users);
unset($lang_last_week_new_users);
//this month new
$this_month_new_users = num_users($ts_1st_of_month,0);
$lang_this_month_new_users = $lang['this_month_new_users'];
$site_template->register_vars("this_month_new_users", $this_month_new_users);
$site_template->register_vars("lang_this_month_new_users", $lang_this_month_new_users);
unset($this_month_new_users);
unset($lang_this_month_new_users);
//last month new
$last_month_new_users = num_users($ts_1st_of_month_before,$ts_1st_of_month);
$lang_last_month_new_users = $lang['last_month_new_users'];
$site_template->register_vars("last_month_new_users", $last_month_new_users);
$site_template->register_vars("lang_last_month_new_users", $lang_last_month_new_users);
unset($last_month_new_users);
unset($lang_last_month_new_users);
//-----------------------------------------------------
//--- Votes -------------------------------------------
//-----------------------------------------------------
//total
$total_votes = num_votes_vtable();
$lang_total_votes = $lang['votes'];
$lang_since_begin_new_votes = $lang['since_begin_new_votes'];
$site_template->register_vars("total_votes", $total_votes);
$site_template->register_vars("lang_total_votes", $lang_total_votes);
$site_template->register_vars("lang_since_begin_new_votes", $lang_since_begin_new_votes);
unset($total_votes);
unset($lang_total_votes);
//today new
$today_new_votes = num_votes_vtable($ts_today_at_0,0);
$lang_today_new_votes = $lang['today_new_votes'];
$site_template->register_vars("today_new_votes", $today_new_votes);
$site_template->register_vars("lang_today_new_votes", $lang_today_new_votes);
unset($today_new_votes);
unset($lang_today_new_votes);
//yesterday new
$yesterday_new_votes = num_votes_vtable($ts_yesterday_at_0,$ts_today_at_0);
$lang_yesterday_new_votes = $lang['yesterday_new_votes'];
$site_template->register_vars("yesterday_new_votes", $yesterday_new_votes);
$site_template->register_vars("lang_yesterday_new_votes", $lang_yesterday_new_votes);
unset($yesterday_new_votes);
unset($lang_yesterday_new_votes);
//this week new
$this_week_new_votes = num_votes_vtable($ts_this_monday,0);
$lang_this_week_new_votes = $lang['this_week_new_votes'];
$site_template->register_vars("this_week_new_votes", $this_week_new_votes);
$site_template->register_vars("lang_this_week_new_votes", $lang_this_week_new_votes);
unset($this_week_new_votes);
unset($lang_this_week_new_votes);
//last week new
$last_week_new_votes = num_votes_vtable($ts_last_monday,$ts_this_monday);
$lang_last_week_new_votes = $lang['last_week_new_votes'];
$site_template->register_vars("last_week_new_votes", $last_week_new_votes);
$site_template->register_vars("lang_last_week_new_votes", $lang_last_week_new_votes);
unset($last_week_new_votes);
unset($lang_last_week_new_votes);
//this month new
$this_month_new_votes = num_votes_vtable($ts_1st_of_month,0);
$lang_this_month_new_votes = $lang['this_month_new_votes'];
$site_template->register_vars("this_month_new_votes", $this_month_new_votes);
$site_template->register_vars("lang_this_month_new_votes", $lang_this_month_new_votes);
unset($this_month_new_votes);
unset($lang_this_month_new_votes);
//last month new
$last_month_new_votes = num_votes_vtable($ts_1st_of_month_before,$ts_1st_of_month);
$lang_last_month_new_votes = $lang['last_month_new_votes'];
$site_template->register_vars("last_month_new_votes", $last_month_new_votes);
$site_template->register_vars("lang_last_month_new_votes", $lang_last_month_new_votes);
unset($last_month_new_votes);
unset($lang_last_month_new_votes);
//by 10<=user_id<=20 (example!)
$from =18;
$to =18;
$field="user_id";
$user_id_votes = num_votes_vtable($from,$to,$field);
$lang_user_id_votes = $lang['user_id_votes'];
$site_template->register_vars("user_id_votes", $user_id_votes);
$site_template->register_vars("lang_user_id_votes", $lang_user_id_votes);
unset($user_id_votes);
unset($lang_user_id_votes);
//by 1000<=image_id<=2000 (example!)
$from =1000;
$to =2000;
$field="image_id";
$image_id_votes = num_votes_itable($from,$to,$field);
$lang_image_id_votes = $lang['image_id_votes'];
$site_template->register_vars("image_id_votes", $image_id_votes);
$site_template->register_vars("lang_image_id_votes", $lang_image_id_votes);
unset($image_id_votes);
unset($lang_image_id_votes);
//-----------------------------------------------------
//--- Hits --------------------------------------------
//-----------------------------------------------------
$sql = "SELECT SUM(image_hits) AS sum
FROM ".IMAGES_TABLE;
$row = $site_db->query_firstrow($sql);
$sum = (isset($row['sum'])) ? $row['sum'] : 0;
$total_hits = $row['sum'];
$lang_total_hits = $lang['total_hits'];
$site_template->register_vars("total_hits", $total_hits);
$site_template->register_vars("lang_total_hits", $lang_total_hits);
unset($total_hits);
unset($lang_total_hits);
//-----------------------------------------------------
//--- Downloads ---------------------------------------
//-----------------------------------------------------
$sql = "SELECT SUM(image_downloads) AS sum
FROM ".IMAGES_TABLE;
$row = $site_db->query_firstrow($sql);
$sum = (isset($row['sum'])) ? $row['sum'] : 0;
$total_downloads = $row['sum'];
$lang_total_downloads = $lang['total_downloads'];
$site_template->register_vars("total_downloads", $total_downloads);
$site_template->register_vars("lang_total_downloads", $lang_total_downloads);
unset($total_downloads);
unset($lang_total_downloads);
//-----------------------------------------------------
//--- Comments ----------------------------------------
//-----------------------------------------------------
$sql = "SELECT SUM(image_comments) AS sum
FROM ".IMAGES_TABLE;
$row = $site_db->query_firstrow($sql);
$sum = (isset($row['sum'])) ? $row['sum'] : 0;
$total_comments = $row['sum'];
$lang_total_comments = $lang['total_comments'];
$site_template->register_vars("total_comments", $total_comments);
$site_template->register_vars("lang_total_comments", $lang_total_comments);
unset($total_comments);
unset($lang_total_comments);
$lang_total_images = $lang['total_images'];
$site_template->register_vars("lang_total_images", $lang_total_images);
unset($lang_total_comments);
$lang_total_categories = $lang['total_categories'];
$site_template->register_vars("lang_total_categories", $lang_total_categories);
unset($lang_total_categories);
//-----------------------------------------------------
//--- Templates ---------------------------------------
//-----------------------------------------------------
$stats = $site_template->parse_template("stats_box");
$site_template->register_vars("stats", $stats);
unset($stats);
?>
2. Sprachdatei ergänzen - .../lang/xxx/main.php:
//-----------------------------------------------------
//--- Statistics --------------------------------------
//-----------------------------------------------------
$lang['total_images'] = "Bilder:";
$lang['total_categories'] = "Kategorien:";
$lang['users'] = "Mitglieder:";
$lang['total_hits'] = "Hits:";
$lang['total_votes'] = "Votes:";
$lang['total_downloads'] = "Downloads:";
$lang['total_comments'] = "Kommentare:";
$lang['today_new_users'] = "heute:";
$lang['yesterday_new_users'] = "gestern:";
$lang['this_week_new_users'] = "diese Woche:";
$lang['last_week_new_users'] = "letzte Woche:";
$lang['this_month_new_users'] = "diesen Monat:";
$lang['last_month_new_users'] = "letzten Monat:";
$lang['since_begin_new_users'] = "seit Anfang:";
$lang['today_new_votes'] = $lang['today_new_users'];
$lang['yesterday_new_votes'] = $lang['yesterday_new_users'];
$lang['this_week_new_votes'] = $lang['this_week_new_users'];
$lang['last_week_new_votes'] = $lang['last_week_new_users'];
$lang['this_month_new_votes'] = $lang['this_month_new_users'];
$lang['last_month_new_votes'] = $lang['last_month_new_users'];
$lang['since_begin_new_votes'] = $lang['since_begin_new_users'];
für die beiden enthaltenen Beispiele sind hier noch keine Einträge vorhanden...
3. .../templates/xxx/style.css ergänzen:
.head3 {
background-color: #e1e1e1;
color: #ffffff;
font-family: Tahoma, Verdana, Arial, Helvetica, sans-serif;
font-size: 11px;
font-weight: bold;
}
4. Templates erstellen - hier: .../templates/xxx/stats_box.html
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="head2" height="20" align="center">S i t e - S t a t i s t i k</td>
</tr>
<tr>
<td class="head3" height="20" align="center">Gesamt-Statistik</td>
</tr>
<tr>
<td class="row2">
<table width="100%" border="0">
<tr class="row1">
<td align="left" width=60%>
{lang_total_images}<br>
{lang_total_categories}<br>
{lang_total_users}<br>
{lang_total_hits}<br>
{lang_total_downloads}
{lang_total_votes}<br>
{lang_total_comments}<br>
</td>
<td align="right" width="40%">
<B>{total_images}</B><br>
<B>{total_categories}</B><br>
<B>{total_users}</B><br>
<B>{total_hits}</B><br>
<B>{total_downloads}</B><br>
<B>{total_votes}</B><br>
<B>{total_comments}</B><br>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="head3" height="20" align="center">neue Mitglieder</td>
</tr>
<tr>
<td class="row2">
<table width="100%" border="0">
<tr class="row1">
<td align="left" width=60%>
{lang_today_new_users}<br>
{lang_yesterday_new_users}<br>
{lang_this_week_new_users}<br>
{lang_last_week_new_users}<br>
{lang_this_month_new_users}<br>
{lang_last_month_new_users}<br>
{lang_since_begin_new_users}<br>
</td>
<td align="right" width="40%">
<B>{today_new_users}</B><br>
<B>{yesterday_new_users}</B><br>
<B>{this_week_new_users}</B><br>
<B>{last_week_new_users}</B><br>
<B>{this_month_new_users}</B><br>
<B>{last_month_new_users}</B><br>
<B>{total_users}</B><br>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="head3" height="20" align="center">neue Stimmen</td>
</tr>
<tr>
<td class="row2">
<table width="100%" border="0">
<tr class="row1">
<td align="left" width=60%>
{lang_today_new_votes}<br>
{lang_yesterday_new_votes}<br>
{lang_this_week_new_votes}<br>
<!--
{lang_last_week_new_votes}<br>
{lang_this_month_new_votes}<br>
{lang_last_month_new_votes}<br>
-->
{lang_since_begin_new_votes}<br>
</td>
<td align="right" width="40%">
<B>{today_new_votes}</B><br>
<B>{yesterday_new_votes}</B><br>
<B>{this_week_new_votes}</B><br>
<!--
<B>{last_week_new_votes}</B><br>
<B>{this_month_new_votes}</B><br>
<B>{last_month_new_votes}</B><br>
-->
<B>{total_votes}</B><br>
</td>
</tr>
</table>
</td>
</tr>
<tr>
</table>
5.Eintrag {stats} an beliebiger Position in einem Haupt-Template platzieren - hier als Bsp. in .../template/xxx/home.html
...
<!--rechts-->
{if random_image}
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="head2" height="20" align="center"> <img src="{template_url}/images/spacer.gif" alt="" width="4" height="4" />{lang_random_image}</td>
</tr>
<tr>
<td class="tablebgcolor"><img src="{template_url}/images/spacer.gif" alt="" width="1" height="1" /></td>
</tr>
<tr>
<td align="center" class="row1">
<br />
{random_image}
<br />
<br />
</td>
</tr>
<tr>
<td class="tablebgcolor"><img src="{template_url}/images/spacer.gif" alt="" width="1" height="1" /></td>
</tr>
</table>
{endif random_image}
{potd_image}
{stats}
<!--rechts Ende-->
...
Wie schon oben gesagt, werde ich das ganze weiter ausbauen. Es wird weitere Auswertungen für Kommentare, Downloads, Postcards und evtl. auch Hits geben. Die in der stats.php enthaltenen Funktionen werden zukünftig evtl. in die functions.php oder eine functions-stats.php ausgelagert.
Viel Spaß! :)
effemmess
PS: wenn ihr die erweiterten Voraussetzungen nicht erfüllt, müsst ihr natürlich einige Funktionalitäten aus der stats.php entfernen!!! Man sollte aber leicht erkennen, was dort raus muß... :wink:
V1.0
- first release
V1.1
- bug fixed date(w)
-
Can somebody help me, i get always the fault:
DB Error: Bad SQL Query: SELECT count(*) AS votes FROM VOTED_TABLE
Table 'xxxx.VOTED_TABLE' doesn't exist
DB Error: Bad SQL Query: SELECT count(*) AS votes FROM VOTED_TABLE WHERE vote_date >= 1111273200
Table 'xxxxx.VOTED_TABLE' doesn't exist
DB Error: Bad SQL Query: SELECT count(*) AS votes FROM VOTED_TABLE WHERE vote_date >= 1111186800 AND vote_date <= 1111273200
Table 'xxxx.VOTED_TABLE' doesn't exist
DB Error: Bad SQL Query: SELECT count(*) AS votes FROM VOTED_TABLE WHERE vote_date >= 1110754800
Table 'xxxx.VOTED_TABLE' doesn't exist
DB Error: Bad SQL Query: SELECT count(*) AS votes FROM VOTED_TABLE WHERE vote_date >= 1110150000 AND vote_date <= 1110754800
Table 'xxxx.VOTED_TABLE' doesn't exist
DB Error: Bad SQL Query: SELECT count(*) AS votes FROM VOTED_TABLE WHERE vote_date >= 1109631600
Table 'xxxxx.VOTED_TABLE' doesn't exist
DB Error: Bad SQL Query: SELECT count(*) AS votes FROM VOTED_TABLE WHERE vote_date >= 1107212400 AND vote_date <= 1109631600
Table 'xxxxx.VOTED_TABLE' doesn't exist
DB Error: Bad SQL Query: SELECT count(*) AS votes FROM VOTED_TABLE WHERE user_id >= 18 AND user_id <= 18
Table 'xxx.VOTED_TABLE' doesn't exist
I think i have to make a mysql table ..but i don´t how i do this.
Thanx a lot.
P.s xxx i make for my pagename
-
Can someone post the whole thing in english :oops: I don't know german! :(
-
Hallo
Ich habe alles gemacht wie oben beschrieben. Habe auch alle Erweiterungen neu installiert. Dennoch erscheint mir keine Statistik :(
Unter http://foto.cini.ch kann man mein Album ansehen. Unter dem Zufallsbild, sollte die Statistik erscheinen, aber es erscheint nur ein dünner kaum erkennbarer Strich.
Ich bitte um Hilfe
Greets gwaggli
-
Here is the modification in /lang/main.php in spanish:
//-----------------------------------------------------
//--- Statistics --------------------------------------
//-----------------------------------------------------
$lang['total_images'] = "Total fotos::";
$lang['total_categories'] = "Categorías:";
$lang['users'] = "Usuarios registrados:";
$lang['total_hits'] = "Impactos:";
$lang['total_votes'] = "Votos:";
$lang['total_downloads'] = "Descargas:";
$lang['total_comments'] = "Comentarios:";
$lang['today_new_users'] = "Hoy";
$lang['yesterday_new_users'] = "Ayer";
$lang['this_week_new_users'] = "Esta semana:";
$lang['last_week_new_users'] = "La semana pasada:";
$lang['this_month_new_users'] = "Este mes:";
$lang['last_month_new_users'] = "Mes pasado";
$lang['since_begin_new_users'] = "Nuevos Usuarios";
$lang['today_new_votes'] = $lang['today_new_users'];
$lang['yesterday_new_votes'] = $lang['yesterday_new_users'];
$lang['this_week_new_votes'] = $lang['this_week_new_users'];
$lang['last_week_new_votes'] = $lang['last_week_new_users'];
$lang['this_month_new_votes'] = $lang['this_month_new_users'];
$lang['last_month_new_votes'] = $lang['last_month_new_users'];
$lang['since_begin_new_votes'] = $lang['since_begin_new_users'];
-
Hi i have installed this Mod and it does work but this part does not
<B>{today_new_votes}</B><br>
<B>{yesterday_new_votes}</B><br>
<B>{this_week_new_votes}</B><br>
<!--
<B>{last_week_new_votes}</B><br>
<B>{this_month_new_votes}</B><br>
<B>{last_month_new_votes}</B><br>
-
And did you install also these mods:
Mindestvoraussetzungen:
- 4images 1.7 :wink:
erweiterte Voraussetzungen (nicht zwingend erforderlich aber sehr hilfreich!):
- v@no´s Votes saved in DB (http://www.4homepages.de/forum/viewtopic.php?t=6123)
- effemmess´s Extension for Votes saved in DB (http://www.4homepages.de/forum/viewtopic.php?t=6404)
- effemmess´s Old votes 2 DB
(http://www.4homepages.de/forum/viewtopic.php?t=6405)
:?:
as long as you won't save the votes in you DB (first mod), you won't be able to get statistics about votes...
and
as long as you won't save the vote-date (second mod), you won't be able to get statistics about the time of voting...
-
thanks for replay I installed them I think i don't understand german i did what i could i just upload them to the plugign folder an execute them is that what i have to do?
-
OK, if you did install the mods, then everything should work fine...
but only if there are already data for the needed statistics ;)
that means - if there's no data for the stats, you can't have any stats 8O
If you don't have any votes where the vote_date is saved, you won't get any statistic-output.
Is that right?
-
ok thanks!!! I was confused but in these statistic are the any that shows that hits per dya per week and per month?
-
im use phpBB
can you halp me?
DB Error: Bad SQL Query: SELECT COUNT(*) as users FROM phpbb_users WHERE user_id <> -1 AND user_joindate >= 1113602400
Unknown column 'user_joindate' in 'where clause'
DB Error: Bad SQL Query: SELECT COUNT(*) as users FROM phpbb_users WHERE user_id <> -1 AND user_joindate >= 1113516000 AND user_joindate <= 1113602400
Unknown column 'user_joindate' in 'where clause'
DB Error: Bad SQL Query: SELECT COUNT(*) as users FROM phpbb_users WHERE user_id <> -1 AND user_joindate >= 1113170400
Unknown column 'user_joindate' in 'where clause'
DB Error: Bad SQL Query: SELECT COUNT(*) as users FROM phpbb_users WHERE user_id <> -1 AND user_joindate >= 1112565600 AND user_joindate <= 1113170400
Unknown column 'user_joindate' in 'where clause'
DB Error: Bad SQL Query: SELECT COUNT(*) as users FROM phpbb_users WHERE user_id <> -1 AND user_joindate >= 1112306400
Unknown column 'user_joindate' in 'where clause'
DB Error: Bad SQL Query: SELECT COUNT(*) as users FROM phpbb_users WHERE user_id <> -1 AND user_joindate >= 1109631600 AND user_joindate <= 1112306400
Unknown column 'user_joindate' in 'where clause'
-
on this MORE THAN MORE STATS, these 2 commands will not show up while in the template stats_box.html
{total_images}
{total_categories}
but I can put them in the, say home.html, it works.. why is that. something need to be changed in the function.php or something
I do have version 1.7.1 but I think did the same thing in 1.7 but not for sure..
Thanks for the help.
-
My german is poor..gee..my german is none...so, I belive that's happening if u include stats.php inside functions.php file, but it should work if u include it from page_header.php instead (should be at the end of page_header.php) or if u included after page_header.php included...(how many times I repeaded word "include"? sounds like a broken record :?)
-
My german is poor..gee..my german is none...so, I belive that's happening if u include stats.php inside functions.php file, but it should work if u include it from page_header.php instead (should be at the end of page_header.php) or if u included after page_header.php included...(how many times I repeaded word "include"? sounds like a broken record :?)
Ok.. um.. WHAT? :lol:
that i see nothing goes in to funtions.php.. so not for sure what you mean there. but.. why would the directions i have for this code that goes in the stats.php is totaly different now. i have tried both of them but nothing.. finally got my votes to work right.. guess after 1.7.1 upgrade or something it quit as it was working before.. but that is neither here nor there, I dont know.. i am totally confusing myself now.. :cry: :roll:
-
I cant get this to work either. :(
-
I finally got it to work... however, I have messed something up and I can not find where the correct code is...
The code I removed and cant find were I messed it up from is the code for total images & total categories. I realize this is really dumb... but please forgive me.. I'm learning ;)
-
when i try to run old_votes2db.php - change_voted_a_install.php got this error
Warning: main(./../admin/admin_global.php): failed to open stream: No such file or directory in /usr/home/maghna/www/old_votes2db.php on line 8
Fatal error: main(): Failed opening required './../admin/admin_global.php' (include_path='.:') in /usr/home/maghna/www/old_votes2db.php on line 8
any idea ?
-
thnx aloot gr8 job
its work wiz me 100%
-
The code I removed and cant find were I messed it up from is the code for total images & total categories. I realize this is really dumb... but please forgive me.. I'm learning ;)
Please help. Thanks.
-
Do u use more then one language on your gallery? if no, then add the missing words directly into the template.
-
Can somebody help me, i get always the fault:
DB Error: Bad SQL Query: SELECT count(*) AS votes FROM VOTED_TABLE
Table 'xxxx.VOTED_TABLE' doesn't exist
DB Error: Bad SQL Query: SELECT count(*) AS votes FROM VOTED_TABLE WHERE vote_date >= 1111273200
Table 'xxxxx.VOTED_TABLE' doesn't exist
DB Error: Bad SQL Query: SELECT count(*) AS votes FROM VOTED_TABLE WHERE vote_date >= 1111186800 AND vote_date <= 1111273200
Table 'xxxx.VOTED_TABLE' doesn't exist
DB Error: Bad SQL Query: SELECT count(*) AS votes FROM VOTED_TABLE WHERE vote_date >= 1110754800
Table 'xxxx.VOTED_TABLE' doesn't exist
DB Error: Bad SQL Query: SELECT count(*) AS votes FROM VOTED_TABLE WHERE vote_date >= 1110150000 AND vote_date <= 1110754800
Table 'xxxx.VOTED_TABLE' doesn't exist
DB Error: Bad SQL Query: SELECT count(*) AS votes FROM VOTED_TABLE WHERE vote_date >= 1109631600
Table 'xxxxx.VOTED_TABLE' doesn't exist
DB Error: Bad SQL Query: SELECT count(*) AS votes FROM VOTED_TABLE WHERE vote_date >= 1107212400 AND vote_date <= 1109631600
Table 'xxxxx.VOTED_TABLE' doesn't exist
DB Error: Bad SQL Query: SELECT count(*) AS votes FROM VOTED_TABLE WHERE user_id >= 18 AND user_id <= 18
Table 'xxx.VOTED_TABLE' doesn't exist
I think i have to make a mysql table ..but i don´t how i do this.
Thanx a lot.
P.s xxx i make for my pagename
hy
search this:
function num_users($from=0,$to=0,$field="user_joindate"){
an replace with:
function num_users($from=0,$to=0,$field="user_regdate"){
@effemmess: danke für den mod, funktioniert wunderbar (bis auf die eine änderung - das is aber nur wegen phpbb so) hoffe da kommt noch viel mehr :)
-
Do u use more then one language on your gallery? if no, then add the missing words directly into the template.
I got it to work. The stats.php was being called before the page_header.php there were no numbers for the variables. I moved the page_header.php up in the process.
Thanks.
-
Hallo, ein großartiger Mod der "fast" auf Anhieb sofort funktioniert :)
Ein Problem habe ich nun aber, die "Neuen Stimmen" bleiben bei mir auf 0 stehen, vermisse ich da einen Eintrag in der DB ??
Gruß, Michael
-
habe nun das [Plugin] Old votes 2 DB installiert und die Einträge sind da, ist es normal das man mir unter Neue Stimmen "heute" 6102 Einträge anzeigt ???
Außerdem werden die neuen Bewertungen nicht mitgezählt :roll:
-
on this MORE THAN MORE STATS, these 2 commands will not show up while in the template stats_box.html
{total_images}
{total_categories}
but I can put them in the, say home.html, it works.. why is that. something need to be changed in the function.php or something
I do have version 1.7.1 but I think did the same thing in 1.7 but not for sure..
Thanks for the help.
I have the same error...
{total_images}
{total_categories}
These variables don't show on the stats of my gallery...
Please, help me!
-
help please :(
-
Ich habe alles wie beschrieben ohne eine Fehlermeldung installiert aber ich habe überhaupt keine Statistik Anzeige !?
Warum?
4images 1.7.1
broken english
i've installed everything without any error but nothing happend!?
Why?
thanx
-
Ich habs gefunden
http://www.4homepages.de/forum/index.php?topic=7901.0
unter "Including the statistics in Index.php:"
aber nun habe ich das gleiche Problem wie "Busologo"
i try it in english
look at the topic to solve the problem
but now {total_images} and {total_categories} fail
-
Mod funktioniert mit kleinen Einschränkungen :(
Installation hat wunderbar funktioniert daher erst mal großes Lob. :D
Hab aber das gleiche Problem wie meine Vorredener.
Keine Anzeige der Bilder und der Kategorien. :(
Danke für Eure Hilfe
-
...
Mindestvoraussetzungen:
- 4images 1.7 :wink:
...
Hello
I can`t understand: IS this mod working with version 1.7.1 or isn`t.
Help me, please.
Thanks.
-
Hallo,
habe auch wie oben das Problem, dass Bilder und Kategorien nicht angezeit werden ?
Komischer WEISE wenn ich auf Kontrollcenter Klicke, dann sehe ich Sie .
Wo liegt der Fehler ?
Grüße Darkness :mrgreen:
The problem in english:
I have the MOD install, it works (fast) fine.
My problem is, the {total_images} and the {total_categories} see I not in the home.html and many other sites (The code include (ROOT_PATH.'includes/stats.php'); is in all sites!). The secound statistik can I see now under memberedit_profil.html.
Whats wrong ?
Greez Darkness :twisted:
-
I tried everything that i could think of (with my limited knowledge)
But I cant seem to show
{total_images}
{total_categories}
Using this mod.
The default one from Home.html show up nicely.
Can some one translate this in english ?
Wie schon oben gesagt, werde ich das ganze weiter ausbauen. Es wird weitere Auswertungen für Kommentare, Downloads, Postcards und evtl. auch Hits geben. Die in der stats.php enthaltenen Funktionen werden zukünftig evtl. in die functions.php oder eine functions-stats.php ausgelagert.
Viel Spaß!
effemmess
PS: wenn ihr die erweiterten Voraussetzungen nicht erfüllt, müsst ihr natürlich einige Funktionalitäten aus der stats.php entfernen!!! Man sollte aber leicht erkennen, was dort raus muß...
Help please
-
Hello,
I had had also this error.
You must place line:
require(ROOT_PATH.'includes/stats.php');
under this line:
include(ROOT_PATH.'includes/page_header.php');
set, then it folds marvelously.
Greet Darkness :mrgreen:
I have also for a long time tried out to I the rausgefunden had. On some sides the line sits "page_header.php" somewhat more deeply, must search.
-
english please?
-
Hi,
ich habe den Statistik Mod auch eingebaut und folgenden Fehler erhalten (s.Bild)
(http://www.camperboard.de/4imagesfehler.jpg)
Dabei muß ich sagen, dass 4images in das WBB eingebunden ist und ich schon joindate in regdate geändert habe.
Was mich wundert ist, dass er -1 als userid angibt, diese userid gibt es nicht.
Der Fehler muß also im Bereich:
$sql = "SELECT COUNT(*) as users
FROM ".USERS_TABLE."
WHERE user_id <> ".GUEST.$sql_where.sql_add($from,$to,$field);
$row = $site_db->query_firstrow($sql);
$num_users = $row['users'];
return $num_users;
liegen.
Es wäre super, wenn jemand helfen könnte
Gruß Arro
-
Nutz meinen Statistik Mod, der ist voll 4images kompatibel vom Code her,
und läuft auch mit einer nicht standardgemässen 4images Version was die Usertabellen angeht.
-
Hi Icecream,
ich hatte mir natürlich deinen Mod auch angesehen, fand aber die Idee, dass die Statistik nur das Wesentliche anzeigt und das auf der Hauptseite so klasse an dem Mod.
Deine Statistik zeigt zwar alles an, aber sorry das ist mir schon zu viel, da werden die User zugeschüttet und können je nachdem mit den ganzen Werten nichts anfangen.
Ausserdem setzt dein Mod einige Mods vorraus, die ich gar nicht einbauen wollte.
Gruß Arro
-
Na gut, will dich zu nichts überreden.
Nur noch kurz eine Sache zu meinem Mod falls das falsch rübergekommen ist.
Man kann alle Optionen in der Config auch ausschalten,
dann werden die gar nicht abgefragt (spart Querys) und auch nicht angezeigt.
Die zusätzlichen Mods sind keine Vorraussetzung nur eine Option.
Meiner Meinung nach, sind Anzeigen auf der Startseite (die ja sehr häufig aufgerufen wird),
immer so eine Sache, da sie wenn sie nicht ordentlich gecodet sind, ne Menge Querys (Abfragen) erzeugen,
dann wundert es mich manchmal nicht, dass Leute über Performance meckern,
wenn auf der Startseite schon 40-50 Querys erzeugt werden (zum Vergleich ein gutes Board erzeugt MAX. 10-20 Querys, wobei gute Boards teilweise unter 10 Querys schon bleiben).
Wenn du diesen Mod kompatibel machen willst,
musst du leider so einige Querys hier ändern, da (leider) bei den meisten Mods einfach von einer Standard 4images Struktur ausgegangen wird.
Was du z.b. machen kannst, ist:
WHERE user_id
ersetzen durch
WHERE ".get_user_table_field("","user_id")."
allerdings sind da bestimmt noch einige andere nicht standardkonforme Werte,
die da abgefragt werden.
-
Meiner Meinung nach, sind Anzeigen auf der Startseite (die ja sehr häufig aufgerufen wird),
immer so eine Sache, da sie wenn sie nicht ordentlich gecodet sind, ne Menge Querys (Abfragen) erzeugen,
dann wundert es mich manchmal nicht, dass Leute über Performance meckern,
wenn auf der Startseite schon 40-50 Querys erzeugt werden (zum Vergleich ein gutes Board erzeugt MAX. 10-20 Querys, wobei gute Boards teilweise unter 10 Querys schon bleiben).
Wenn du diesen Mod kompatibel machen willst,
musst du leider so einige Querys hier ändern, da (leider) bei den meisten Mods einfach von einer Standard 4images Struktur ausgegangen wird.
Was du z.b. machen kannst, ist:
WHERE user_id
ersetzen durch
WHERE ".get_user_table_field("","user_id")."
allerdings sind da bestimmt noch einige andere nicht standardkonforme Werte,
die da abgefragt werden.
Hallo IceCream,
du hast völlig Recht mit deiner Aussage und die hat was, ich wollte hier auch keinenfalls deinen Mod schlechtreden ich wäre froh wenn ich zu so etwas überhaupt in der Lage wäre.
Ich fand es halt nur informativ, das ganze auf der Startseite (als kleine Info) zu haben.
Ich werde jetzt mal deinen Lösungsansatz ausprobieren und vielen Dank dafür
Gruß Arro
-
Noch ein kleiner Nachtrag:
Das war es Icecream, damit wird es angezeigt, ich bin dir sehr dankbar.
Gruß Arro
-
Its been a long time I have added this mod. Few days back, I found out that the total number of votes shown by this mod are different than the no. of votes I currently have.
If you see Top Wallpapers (top.php) you will clearly see that the number of votes are more than 28 shown by this mod.
BestofWallpapers.Com (http://www.bestofwallpapers.com)
Its not a big problem but I will like to know what is the problem?
At least tell me where to start digging ?
-
Its been a long time I have added this mod. Few days back, I found out that the total number of votes shown by this mod are different than the no. of votes I currently have.
If you see Top Wallpapers (top.php) you will clearly see that the number of votes are more than 28 shown by this mod.
BestofWallpapers.Com (http://www.bestofwallpapers.com)
Its not a big problem but I will like to know what is the problem?
At least tell me where to start digging ?
Anyone ?? Should I just ignore it ??
-
hi evrey one
how I can make it work on V1.7.3
??
i have this err
An unexpected error occured. Please try again later.
pleeez help
-
Die Version A habe ich installiert und es funktioniert alles, außer die DB Votes. Da steht jetzt allerdings "An unexpected error occured. Please try again later." Vorher stand aber, dass es Probleme mit der Datenbank gibt.
Hier ist die Adresse:
http://www.delikanlim.net/galery/
Könnten Sie mir bitte helfen?
Ich danke im Vorraus.
-
I have just tried on a new installation and looks like this mod is working just fine with v 1.7.4.
So i thought to let you guys know. :)
Thanks for the mode.
-
Hi, hab grad alles nach Anleitung gemacht, leider kommt bei mir keine Statistik. Die Mods habe ich nicht installiert, da dort steht nicht zwingend notwendig. Was genau könnte der Fehler sein?
-
... hab grad alles nach Anleitung gemacht ...
... offensichtlich nicht, denn sonst würde es funktionieren ...
... und ohne URL um sich dein Problem mal anzusehen (bei der mageren Problembeschreibung) geht es halt nicht ... ;)
-
i also have installed both mods bevor,but when i insert the statistic i just can see the random image on a second place, nothing more.
im using 4images 1.7.4
-
Hello,
I had had also this error.
You must place line:
require(ROOT_PATH.'includes/stats.php');
under this line:
include(ROOT_PATH.'includes/page_header.php');
set, then it folds marvelously.
Greet Darkness :mrgreen:
I have also for a long time tried out to I the rausgefunden had. On some sides the line sits "page_header.php" somewhat more deeply, must search.
I know I should know this... but which file must we put this code in? I have been away from 4images for more than a year and have forgotten...
Thanks--
Robert
-
@Robert aka AntiNSA2
... you must put this code in every page (php-file) you want to show the statistics ...
-
Hi,
I'm new to this, but i had the same problem with Users and Categories. I had to add
include(ROOT_PATH.'includes/page_header.php');
in
includes/stats.php
Now it works great!
Michl
-
sadly..,
I can't get it to work in 1.7.6 version...
doesnt' show anything at all.
:cry:
-
sadly..,
... yes ... no link, no url, no error messages, no infos at all ...
... so there is no way for help ...
-
Will anyone plz translate it to english as i have use google translator but some codes text is in other language so if you plz help..
-
Will anyone plz share english version of this mod ?
-
@ ashfaq
... for mod translation use this : Google-Translation (http://translate.google.com/translate?u=http%3A%2F%2Fwww.4homepages.de%2Fforum%2Findex.php%3Ftopic%3D6484.0&sl=de&tl=en&hl=de&ie=UTF-8) ...
... and for code-translation in step 2 use this : ...
//------------------------------------------------ -----
//--- Statistics --------------------------------------
//------------------------------------------------ -----
$lang ['total_images'] = "Images:";
$lang ['total_categories'] = "Category:";
$lang ['users'] = "Members:";
$lang ['total_hits'] = "Hits:";
$lang ['total_votes'] = "Votes:";
$lang ['total_downloads'] = "Downloads:";
$lang ['total_comments'] = "Comments:";
$lang ['today_new_users'] ="Today:";
$lang ['yesterday_new_users'] = "Yesterday:";
$lang ['this_week_new_users'] = "This Week";
$lang ['last_week_new_users'] = "Last Week:";
$lang ['this_month_new_users'] = "This Month:";
$lang ['last_month_new_users'] = "Last Month:";
$lang ['since_begin_new_users'] = "Since Beginning:";
PS. ... google translation is a very fine tool ... ;)
-
Na this mod is not working for me but only show ... then random image and again ... but nothing else, i dont know when i did everything right then why its not showing statistics ? i did the following steps...
1: First i make a new page by given code and name it : stats.php
2: For second step i add given code in lang/english/main.php at page end before ?>
3: At third step i add css code in my template style.css at page end
4: For Forth step i make a new file named stats_box.html and put this file in my templates folder
5: Put this given code at my template home.html
So you see everything is ok then why its not showing stats ?
Plz notice that i didnt installed these codes that author mentioned.
- V @ no's Votes saved in DB
- effemmess´s Extension for Votes saved in DB - Extension for effemmess's Votes saved in DB
- effemmess´s Old votes 2 DB - Old effemmess's votes 2 DB
-
I can only find one of the two mods here on the forum... is this mod still alive? where can I find the mods that need to be installed ? I tried the search already.....
-
Mindestvoraussetzungen:
- 4images 1.7 Wink
erweiterte Voraussetzungen (nicht zwingend erforderlich aber sehr hilfreich!):
- v@no´s Votes saved in DB
This is here:
http://www.4homepages.de/forum/index.php?topic=6123.0
- effemmess´s Extension for Votes saved in DB
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
Where is this mod????
!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
- effemmess´s Old votes 2 DB
this is here:
http://www.4homepages.de/forum/index.php?topic=6405.new#new
Thanks-
-
Changelog:
- Added better Code for Statistik-View (Step 5)
- Bessere Anzeige der Statistiken hinzugefügt (Step 5)
:flag-de:
Hallo,
diese Mod basiert auf einen fertigen Code aus einem Arabischen Thread. Ich habe diesen nur etwas erweitert und an die Version 1.7.7 angepasst.
:flag-en:(Google Translate)
Hello,
This mod is based on a warrant from a code Arabian thread. I did this just to the expanded and adapted version 1.7.7.
Step 1
Open / Öffne: index.php
Search / Suche:
else {
$template = "";
}
include(ROOT_PATH.'includes/page_header.php');
Add after / füge darunter:
include(ROOT_PATH.'includes/stats.php');
Step 2
Open / Öffne: lang/YOUR-LANGUAGE/main.php
Add the End of File -above- / Füge am Ende der Datei -vor-
?>
This / Das ein
:flag-de:
//-----------------------------------------------------
//--- Statistics --------------------------------------
//-----------------------------------------------------
$lang['total_images'] = "Bilder:";
$lang['total_categories'] = "Kategorien:";
$lang['users'] = "Mitglieder:";
$lang['total_hits'] = "Hits:";
$lang['total_downloads'] = "Downloads:";
$lang['total_comments'] = "Kommentare:";
$lang['today_new_users'] = "heute:";
$lang['yesterday_new_users'] = "gestern:";
$lang['this_week_new_users'] = "diese Woche:";
$lang['last_week_new_users'] = "letzte Woche:";
$lang['this_month_new_users'] = "diesen Monat:";
$lang['last_month_new_users'] = "letzten Monat:";
$lang['since_begin_new_users'] = "seit Anfang:";
$lang['today_new_votes'] = $lang['today_new_users'];
$lang['yesterday_new_votes'] = $lang['yesterday_new_users'];
$lang['this_week_new_votes'] = $lang['this_week_new_users'];
$lang['last_week_new_votes'] = $lang['last_week_new_users'];
$lang['this_month_new_votes'] = $lang['this_month_new_users'];
$lang['last_month_new_votes'] = $lang['last_month_new_users'];
$lang['since_begin_new_votes'] = $lang['since_begin_new_users'];
:flag-en:
//-----------------------------------------------------
//--- Statistics --------------------------------------
//-----------------------------------------------------
$lang['total_images'] = "Pictures:";
$lang['total_categories'] = "Categories:";
$lang['users'] = "Members:";
$lang['total_hits'] = "Hits:";
$lang['total_downloads'] = "Downloads:";
$lang['total_comments'] = "Comments:";
$lang['today_new_users'] = "Today:";
$lang['yesterday_new_users'] = "Yesterday:";
$lang['this_week_new_users'] = "This Week:";
$lang['last_week_new_users'] = "Last Week:";
$lang['this_month_new_users'] = "This Month:";
$lang['last_month_new_users'] = "Last Month:";
$lang['since_begin_new_users'] = "Since Begin:";
$lang['today_new_votes'] = $lang['today_new_users'];
$lang['yesterday_new_votes'] = $lang['yesterday_new_users'];
$lang['this_week_new_votes'] = $lang['this_week_new_users'];
$lang['last_week_new_votes'] = $lang['last_week_new_users'];
$lang['this_month_new_votes'] = $lang['this_month_new_users'];
$lang['last_month_new_votes'] = $lang['last_month_new_users'];
$lang['since_begin_new_votes'] = $lang['since_begin_new_users'];
Step 3
Open / Öffne: templates/YOUR-TEMPLATE/home.html
Search / Suche
{endif random_image}
Add after / Füge danach ein
{stats}
Step 4
Download now the files from the ZIP file in your directory 4images / Lade nun die Dateien aus der ZIP-Datei in deinem 4images Verzeichnis
- include/stats.php
- templates/YOUR-TEMPLATE/stats_box.html
Step 5
Open / Öffne: templates/your-dein-template/stats_box.html
Ersetze mit / Replace with
<table width="150" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="20" colspan="2" class="head2"> <img src="{template_url}/images/spacer.gif" alt="" width="4" height="4" />Statistik</td>
</tr>
<tr>
<td colspan="2" class="tablebgcolor"><img src="{template_url}/images/spacer.gif" alt="" width="1" height="1" /></td>
</tr>
<tr>
<td align="left" class="row1">{lang_total_images}</td>
<td align="right" class="row1"><B>{total_images}</B></td>
</tr>
<tr>
<td align="left" class="row2">{lang_total_categories}</td>
<td align="right" class="row2"><B>{total_categories}</B></td>
</tr>
<tr>
<td align="left" class="row1">{lang_total_users}</td>
<td align="right" class="row1"><B>{total_users}</B></td>
</tr>
<tr>
<td align="left" class="row2">{lang_total_hits}</td>
<td align="right" class="row2"><B>{total_hits}</B></td>
</tr>
<tr>
<td align="left" class="row1">{lang_total_downloads}</td>
<td align="right" class="row1"><B>{total_downloads}</B></td>
</tr>
<tr>
<td align="left" class="row2">{lang_total_comments}</td>
<td align="right" class="row2"><B>{total_comments}</B></td>
</tr>
<tr>
<td colspan="2" class="tablebgcolor"><img src="{template_url}/images/spacer.gif" alt="" width="1" height="1" /></td>
</tr>
<tr>
<td height="20" colspan="2" class="head2"><img src="{template_url}/images/spacer.gif" alt="" width="4" height="4" />Neue User</td>
</tr>
<tr>
<td align="left" class="row1">{lang_today_new_users}</td>
<td align="right" class="row1"><B>{today_new_users}</B></td>
</tr>
<tr>
<td align="left" class="row2">{lang_yesterday_new_users}</td>
<td align="right" class="row2"><B>{yesterday_new_users}</B></td>
</tr>
<tr>
<td align="left" class="row1">{lang_this_week_new_users}</td>
<td align="right" class="row1"><B>{this_week_new_users}</B></td>
</tr>
<tr>
<td align="left" class="row2">{lang_last_week_new_users}</td>
<td align="right" class="row2"><B>{last_week_new_users}</B></td>
</tr>
<tr>
<td align="left" class="row1">{lang_this_month_new_users}</td>
<td align="right" class="row1"><B>{this_month_new_users}</B></td>
</tr>
<tr>
<td align="left" class="row2">{lang_last_month_new_users}</td>
<td align="right" class="row2"><B>{last_month_new_users}</B></td>
</tr>
<tr>
<td align="left" class="row1">{lang_since_begin_new_users}</td>
<td align="right" class="row1"><B>{total_users}</B></td>
</tr>
</table>
Demo: http://4images-aio.benny-boehnke.info/index.php
-
Hi!
...
Aber die Downloads werden nicht angezeigt. !?
But the downloads don´t show !?...
die werden bei dir schon angezeigt, nur ist deine tabelle in der höhe verschoben.
mfg Andi
-
Wo du Recht hast ^^
-
Hi, ich hab bei mir die Statistik auf allen Seiten eingefügt, habe aber den Effekt das sie in der detail.html nicht angezeigt wird. Auf allen anderen Seiten geht es und ich habe da nichts anders gemacht... hat da einer eine Idee?
Link (http://tino23.lsfs.de/lmj/)
Quelltext meiner detail.html (Zeile 252)
{header}
<table width="980" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td>
<table cellpadding="0" cellspacing="0" width="100%" border="0" bgcolor="#000000">
<tr>
<td width="100%">
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#000000" width="100%" height="136" background="{template_url}/images/bbcell.gif">
<tr>
<td align="center"><img src="{template_url}/images/4imgs.gif" width="985" height="136" align="center" alt="" /></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td class="bordercolor">
<table width="100%" border="0" cellspacing="1" cellpadding="0">
<tr>
<td class="tablebgcolor">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="navbar" height="23">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="left" width="50%">
<img src="{template_url}/images/spacer.gif" width="4" height="4" alt="" />{clickstream}</td>
<td align="right" width="50%">
<a href="{url_top_images}"><b>{lang_top_images}</b></a> |
<a href="{url_new_images}"><b>{lang_new_images}</b></a>
</td>
</tr>
</table>
</td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="150" class="row2" valign="top">
<table width="150" border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="head2" height="20"><img src="{template_url}/images/spacer.gif" alt="" width="4" height="4" />{lang_registered_user}</td>
</tr>
<tr>
<td class="tablebgcolor"><img src="{template_url}/images/spacer.gif" alt="" width="1" height="1" /></td>
</tr>
<tr>
<td align="center" class="row1">{user_box} </td>
</tr>
<tr>
<td class="tablebgcolor"><img src="{template_url}/images/spacer.gif" alt="" width="1" height="1" /></td>
</tr>
</table>
{if random_cat_image}
<table width="150" border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="head2" height="20"> <img src="{template_url}/images/spacer.gif" alt="" width="4" height="4" />{lang_random_image}</td>
</tr>
<tr>
<td class="tablebgcolor"><img src="{template_url}/images/spacer.gif" alt="" width="1" height="1" /></td>
</tr>
<tr>
<td align="center" class="row1">
<br />
{random_cat_image}
<br />
<br />
</td>
</tr>
<tr>
<td class="tablebgcolor"><img src="{template_url}/images/spacer.gif" alt="" width="1" height="1" /></td>
</tr>
</table>
{endif random_cat_image}
<br />
</td>
<td width="1" class="bordercolor" valign="top"><img src="{template_url}/images/spacer.gif" width="1" height="1" alt="" /></td>
<td width="18" valign="top"><img src="{template_url}/images/spacer.gif" width="18" height="18" alt="" /></td>
<td width="100%" valign="top"><br />
<table width="100%" border="0" cellspacing="0" cellpadding="1">
<tr>
<td class="bordercolor">
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr valign="top">
<td class="row2">
{if prev_image_name}{lang_prev_image}<br />
<b><a href="{prev_image_url}">{prev_image_name}</a></b>
<!-- <br /><br /><a href="{prev_image_url}"><img src="{prev_thumb_file}" border="1"></a> -->
{endif prev_image_name} </td>
<td align="right" class="row2">
{if next_image_name}{lang_next_image}<br />
<b><a href="{next_image_url}">{next_image_name}</a></b>
<!-- <br /><br /><a href="{next_image_url}"><img src="{next_thumb_file}" border="1"></a> -->
{endif next_image_name}</td>
</tr>
</table>
</td>
</tr>
</table>
<br>
<b class="title">{image_name}</b>{if image_is_new} <sup class="new">{lang_new}</sup>{endif image_is_new}
<hr size="1" />
{if msg}<b>{msg}<br /><br /></b>{endif msg}
<div align="center">
{image}
{if admin_links}<br />{admin_links}<br />{endif admin_links} <br />
<table width="100%" border="0" cellspacing="0" cellpadding="1">
<tr>
<td class="bordercolor">
<table width="100%" border="0" cellspacing="0" cellpadding="3">
<tr valign="top" class="row2">
<td align="left" width="33%">{if prev_image_name} {lang_prev_image}{endif prev_image_name}</td>
<td align="center" width="33%" class="head3"><b>{rate}</b></td>
<td align="right" width="33%">{if next_image_name}{lang_next_image} {endif next_image_name}</td>
</tr>
<tr valign="bottom">
<td align="left" width="33%">{if prev_image_name} <a href="{prev_image_url}"><img src="{prev_thumb_file}" border="0" height="50"></a>{endif prev_image_name}</td>
<td align="center" valign="middle" width="33%">{if rate_form}{rate_form}{endif rate_form}</td>
<td align="right" width="33%">{if next_image_name}<a href="{next_image_url}"><img src="{next_thumb_file}" border="0" height="50"></a>{endif next_image_name}</td>
</tr>
</table>
</td>
</tr>
</table>
<br />{lightbox_button} {postcard_button} {download_button} <!-- {download_zip_button} -->
</div><br />
<table width="100%" border="0" cellspacing="0" cellpadding="1">
<tr>
<td class="bordercolor">
<table width="100%" border="0" cellpadding="3" cellspacing="0">
<tr>
<td class="head1" valign="top" colspan="2">{image_name}</td>
</tr>
<tr>
<td valign="top" class="row1"><b>{lang_description}</b></td>
<td valign="top" class="row1">{image_description}</td>
</tr>
<tr>
<td valign="top" class="row2"><b>{lang_keywords}</b></td>
<td valign="top" class="row2">{image_keywords}</td>
</tr>
<tr>
<td valign="top" class="row1"><b>{lang_date}</b></td>
<td valign="top" class="row1">{image_date}</td>
</tr>
<tr>
<td valign="top" class="row2"><b>{lang_hits}</b></td>
<td valign="top" class="row2">{image_hits}</td>
</tr>
<tr>
<td valign="top" class="row1"><b>{lang_downloads}</b></td>
<td valign="top" class="row1">{image_downloads}</td>
</tr>
<tr>
<td valign="top" class="row2"><b>{lang_rating}</b></td>
<td valign="top" class="row2">{image_rating} ({image_votes}
{lang_votes})</td>
</tr>
<tr>
<td valign="top" class="row1"><b>{lang_file_size}</b></td>
<td valign="top" class="row1">{image_file_size}</td>
</tr>
<tr>
<td valign="top" class="row2"><b>{lang_added_by}</b></td>
<td valign="top" class="row2">{user_name_link}</td>
</tr>
</table>
</td>
</tr>
</table>
{if iptc_info}<br />
<table width="100%" border="0" cellspacing="0" cellpadding="1">
<tr>
<td class="bordercolor">
<table width="100%" border="0" cellpadding="3" cellspacing="0">
<tr>
<td class="head1" valign="top" colspan="2">IPTC Info</td>
</tr>
{iptc_info}
</table>
</td>
</tr>
</table>
{endif iptc_info}
{if exif_info}
<br />
<table width="100%" border="0" cellspacing="0" cellpadding="1">
<tr>
<td class="bordercolor">
<table width="100%" border="0" cellpadding="3" cellspacing="0">
<tr>
<td class="head1" valign="top" colspan="2">EXIF Info</td>
</tr>
{exif_info}
</table>
</td>
</tr>
</table>
{endif exif_info}
{if allow_comments}
<a name="comments"></a>
<br />
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td class="head1" valign="top">
<table width="100%" border="0" cellpadding="3" cellspacing="1">
<tr>
<td valign="top" class="head1">
{lang_author}
</td>
<td valign="top" class="head1">
{lang_comment}
</td>
</tr>
{comments}
</table>
</td>
</tr>
</table>
<br />
{comment_form}
{endif allow_comments}
<br /><br />
<p> </p>
</td>
<td width="19" valign="top"><img src="{template_url}/images/spacer.gif" alt="" width="19" height="19" /></td>
<td width="1" class="bordercolor" valign="top"><img src="{template_url}/images/spacer.gif" alt="" width="1" height="1" /></td>
<td width="150" class="row2" valign="top">
<table width="150" border="0" cellspacing="0" cellpadding="0">
<tr class="bordercolor">
<td class="head2" height="20"><img src="{template_url}/images/spacer.gif" alt="" width="4" height="4" />Fahrzeug - Info</td>
</tr>
<tr>
<td align="center" class="row1"> <p align="center">
<!-- <?php
echo date("d.m.Y, H:i");
?> -->
</p>
<?php include("{template_url}/4darkm.php"); ?>
{stats}
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
</td>
</tr>
</table>
{footer}
-
Hi, ich hab bei mir die Statistik auf allen Seiten eingefügt, habe aber den Effekt das sie in der detail.html nicht angezeigt wird. ...
wenn du die stats rechts auf der detail seite meinst , die werden angezeigt, wenn nicht lese mal die nächsten 3 posts von hier weg:
http://www.4homepages.de/forum/index.php?topic=6484.msg95378#msg95378
mfg Andi
-
Danke erst einmal für die Antwort, aber die Gesamtstatistik wird nach wie vor nicht Angezeigt, wenn ich mit die Details eines Bildes anzeigen lasse. Schau mal auf der Startseite, da ist unter der Besucherstatistik noch eine Gesamtstatistik, die Fehlt aber plötzlich auf der Datailseite.
Der Teil in der Index.php sollte auch richtig eingefügt sein, geht ja auch soweit...
else {
$template = "";
}
include(ROOT_PATH.'includes/page_header.php');
//--- Statistik MOD Anfang ---------------------------------
include(ROOT_PATH.'includes/stats.php');
//--- Statistik MOD Ende - ---------------------------------
-
wenn du die statistik überall angezeigt haben möchtest mußt du die stats.php in der page_header.php includen.
-
Kannst du mir mal den Code dafür geben, wo und wie ich das in der page_header.php mache?
-
versuche es mal
include(ROOT_PATH.'includes/stats.php');
//-----------------------------------------------------
//--- Register Global Vars ----------------------------
//-----------------------------------------------------
und aus der index nimmst du es raus