Menu
▾
▴
MyDynaWeb CVS: htdocs sukria
|
From: mdw c. <myd...@li...> - 2002-01-15 11:17:16
|
MyDynaWeb CVS committal
Author : sukria
Project : mydynaweb
Module : htdocs
Dir : mydynaweb/htdocs
Modified Files:
comment.php count.php show_stats.php
Log Message:
Again I try to make mydynaweb 0.5 really nice to see....
The show_stats.php can now show the stats with the new format.
The detail of a piece of news is better. (author and date added)
The count.php script wotrks fine now.
TO DO : the referer mode for show_stats.php
===================================================================
RCS file: /cvsroot/mydynaweb/mydynaweb/htdocs/comment.php,v
retrieving revision 1.12
retrieving revision 1.13
diff -u -3 -r1.12 -r1.13
--- comment.php 2001/11/08 03:11:12 1.12
+++ comment.php 2002/01/15 11:16:46 1.13
@@ -25,7 +25,7 @@
$rqt->query($DBH, $sql);
$row = $rqt->getrow();
$news_titre = $row[1];
-
+$info = "<center>" . translate('POSTED_BY', $DBH). " " . $row['user_name'].", ".$row['date'] . "</center>";
$sql = "select count(*) from comments
where _num_news = $row[0]";
$rqt2 = new query($DBH);
@@ -38,10 +38,11 @@
$rqt2 = new query($DBH);
$rqt2->query($DBH, $sql) or send_sql_error($PHP_SELF, $sql, $rqt->error());
+
+$PAGE .= "";
-$PAGE = get_piece_of_news($row[1], '<i>' . $row['texte'] . '</i><br><br>' .
+$PAGE .= get_piece_of_news($row[1], '<P>' . $row['texte'] . '<br><br>' .
$row['long_text'], $row[4], translate($row[5],$DBH), "news.php?q=$row[6]", $row[nbhit], $row[0], $row2[0], strlen($row['long_text']) * 8, $DBH);
-$PAGE .= "<P><a href='add_comment.php?num_news=$news'>".translate("COMMENT_NEWS",$DBH)."</a></P>";
// we get the comments
@@ -66,7 +67,8 @@
}
-$CONTENT = get_page(translate("COMMENT_RELATED",$DBH)." <EM>$news_titre</EM>", translate("THERE_ARE",$DBH)." $num_cmt ".translate("COMMENTS_REC",$DBH), $PAGE, $DBH);
+$PAGE .= "<P><center><b><a href='add_comment.php?num_news=$news'>".translate("COMMENT_NEWS",$DBH)."</a></b></P></center>";
+$CONTENT = get_page("<h2>$news_titre</h2>", $info, $PAGE, $DBH);
print_template(THEMES_PATH."/main.html", $CONTENT, $row[1], $DBH,"COMMENT.$news", $REMOTE_ADDR, $HTTP_REFERER, $MSG, 10, 50);
}
===================================================================
RCS file: /cvsroot/mydynaweb/mydynaweb/htdocs/count.php,v
retrieving revision 1.6
retrieving revision 1.7
diff -u -3 -r1.6 -r1.7
--- count.php 2001/12/06 16:28:40 1.6
+++ count.php 2002/01/15 11:16:46 1.7
@@ -23,10 +23,10 @@
if (!isset($DYNA_UNIQUE)) {
- header ("Location: images/poweredbymydynaweb.gif");
+ header ("Location: images/dynalogo.gif");
}
else {
- header ("Location: images/coffee.gif");
+ header ("Location: images/pixel.gif");
}
$DBH->close();
@@ -77,6 +77,8 @@
$PAGES = $old['PAGEVIEWS'] + 1;
$VISITS = $old['VISITS'] + 1;
$PEOPLE = $old['PEOPLE'];
+ // This is your first visit
+ setcookie('DYNA_VISIT', '1', (time() + 30 * 60));
}
}
else { // no, never seen before...
@@ -100,6 +102,7 @@
$PEOPLE = $old['PEOPLE'] + 1;
}
+ //if (!$PEOPLE) $PEPOLE=1;
// now, we have to store in the DB the new vals of the stats :
$sql = "UPDATE STATS
===================================================================
RCS file: /cvsroot/mydynaweb/mydynaweb/htdocs/show_stats.php,v
retrieving revision 1.8
retrieving revision 1.9
diff -u -3 -r1.8 -r1.9
--- show_stats.php 2001/09/26 22:25:00 1.8
+++ show_stats.php 2002/01/15 11:16:46 1.9
@@ -3,44 +3,40 @@
include('./include/mydynaweb.init.php');
include(DYNA_ROOT . '/include/mydynaweb.libs.php');
+if (!strlen($mode)) {
+ $mode = 'MONTH';
+ $month='2001-12';
+}
$DBH=new db();
$DBH->open($dbName, $dbServer, $dbUser, $dbPass);
-if (SHOW_STATS) {
-
- if (strlen($fullday) && $mode == "DAY") {
- $date_frag = explode("-",$fullday);
- $mon = $date_frag[1] . "_" . $date_frag[0];
- $day = $date_frag[2];
- }
-
// We generate graphs from the user query and store it in $PAGE
switch($mode)
{
case 'MONTH':
- $PAGE = "<i>" . str_replace('_', ' ', $mon) . "</i><br><br>";
-
+ $PAGE .= "<table width='90%' align='center'>
+ <tr><td><b>Day</b></td>
+ <td><b>Pages Viewed</b></td>
+ <td><b>Visits</b></td>
+ <td><b>Visitors</b></td></tr>\n";
+
// what is he max hit number ?
- $sql = "select sum(nb_hit) from hit_$mon group by day;";
+ $sql = "select day, PAGEVIEWS, VISITS, PEOPLE
+ from STATS
+ where DAY like '$month-%'
+ order by DAY ";
$rqt = new query($DBH);
$rqt->query($DBH, $sql);
$max = 0;
while($row = $rqt->getrow()) {
- if ($row[0] > $max) {
- $max = $row[0];
- }
+ $PAGE .= "<tr><td>$row[0]</td><td>$row[1]</td><td>$row[2]</td><td>$row[3]</td></tr>\n";
}
- // we look for each day in the month $mon
- $sql = "select distinct day from hit_$mon order by day asc";
- $rqt = new query($DBH);
- $rqt->query($DBH, $sql);
- while ($row = $rqt->getrow()) {
- $PAGE .= get_stats_day($mon, $row[0], $max, $DBH);
- }
+ $PAGE.= "</table>\n";
+
break;
case 'DAY':
@@ -63,44 +59,6 @@
}
- $PAGE .= "<hr align='center' width='50%'>
- <form name='foo' action='$PHP_SELF'>
- <table width=480 cellpadding=0 cellspacing=0 border=0>
- <tr>
- <td valign='middle' align='center'>
- <b>Choose your stats period</b>
- </td>
- <td valign='middle' align='center'>
- <select name='mode'>
- <option value='DAY'>Day</option>
- <option value='MONTH'>Month</option>
- </select>
- </td>
- </tr>
- <tr>
- <td valign='middle' align='center'>
- <b>Enter the day you want</b>
- </td>
- <td valign='middle' align='center'>
- <input type='text' name='fullday' value='YYYY-MM-DD' size='10'>
- </td>
- </tr>
- <tr><td clospan='2' valign='top' align='middle'><i>OR</i></td></tr>
- <tr>
- <td valign='middle' align='center'>
- <b>Enter the month you want</b>
- </td>
- <td valign='middle' align='center'>
- <input type='text' name='mon' value='MM_YYYY' size='7'>
- </td>
- </tr>
-
- <tr><td clospan='2' valign='top' align='middle'><input type='submit' value='show stats'></td></tr>
-
- </table>
- </form>
-
- <div align='center'><a href='show_stats.php?mode=REFERER'>".translate('SHOW_REFERERS', $DBH)."</a></center>";
// 2 - We send the HTML output in the appropriate format (language, theme)
@@ -109,83 +67,5 @@
print_template(THEMES_PATH."/main.html", $CONTENT, translate('STATS_TITLE', $DBH), $DBH, 'stats', $REMOTE_ADDR, $HTTP_REFERER);
-
-}
-else {
-
- $CONTENT = get_page(translate('STATS_SORRY_TITLE', $DBH), '', translate('STATS_SORRY_CONTENT', $DBH), $DBH);
- print_template(THEMES_PATH."/main.html", $CONTENT, translate('STATS_SORRY_TITLE', $DBH), $DBH, 'stats', $REMOTE_ADDR, $HTTP_REFERER);
-
-}
-
-die();
-
-
-function get_stats_day ($mon, $day, $max, $DBH)
-{
-
- // we make the stats for the day $mon $day (yyyy-mm-dd)
-
-
- $sql = "select count(*) from hit_$mon where day=$day";
- $rqt = new query($DBH);
- $rqt->query($DBH, $sql);
- $row = $rqt->getrow();
- $surfers = $row[0];
-
-
- $sql = "select nb_visit from hit_$mon where day=$day";
- $rqt = new query($DBH);
- $rqt->query($DBH, $sql);
- $visits = 0;
- while ($row = $rqt->getrow()) {
- $visits += $row[0];
- }
-
-
- $sql = "select nb_hit from hit_$mon where day=$day";
- $rqt = new query($DBH);
- $rqt->query($DBH, $sql);
- $hits = 0;
- while ($row = $rqt->getrow()) {
- $hits += $row[0];
- }
-
-
- if (!$hits) {
- $CONTENT = get_page('Stats Unavailable !',
- "The following problem occured :",
- 'Sorry stats are no longer supported in this release.', $DBH);
- print_template(THEMES_PATH."/main.html", $CONTENT, 'No Stats', $DBH,"URL=$url", $REMOTE_ADDR, $HTTP_REFERER);
- die();
- }
-
-if (! strlen($max)) {
- $max = $hits;
-}
-
- $hit_percentile = ($hits * 100 / $max);
- $vis_percentile = ($visits * 100 / $max);
- $sur_percentile = ($surfers * 100 / $max);
-
- if ($day < 10) {
- $day = "0" . $day;
- }
-
- $PAGE = " <table>
- <tr> <td rowspan='3' valign='middle' align='center'><b>$day</b></td>
- <td>".translate("PAGE_VIEW", $DBH). " : </td>
- <td>$hit_percentile</td><td align='right'>$hits</td></tr>
- <tr><td>".translate("VISIT",$DBH)." : </td> <td>$vis_percentile</td>
- <td align='right'>$visits</td></tr>
- <tr><td>".translate("USER", $DBH)." : </td> <td>$sur_percentile</td>
- <td align='right'>$surfers</td></tr>
- </table>";
-
- $date = date("d - m - Y");
-
- return $PAGE;
-
-}
?>
|
