Changeset 537

Timestamp:

Sep 26, 2004, 11:24:49 PM (20 years ago)

Author:

gweltas

Message:

-First draft of history display

Location:

trunk

Files:

• admin/images/monthly_visits.img.php (added)
• admin/images/phpBarGraph.php (added)
• admin/include/isadmin.inc.php (modified) (1 diff)
• admin/stats.php (modified) (2 diffs)
• include/functions.inc.php (modified) (1 diff)
• install/phpwebgallery_structure.sql (modified) (1 diff)
• template/default/admin/stats.tpl (added)
• template/default/admin/stats.vtp (deleted)

trunk/admin/include/isadmin.inc.php

@@ -32 +32 @@
 {
   echo '<div style="text-align:center;">'.$lang['access_forbiden'].'<br />';
-  echo '<a href="./identification.php">'.$lang['ident_title'].'</a></div>';
+  echo '<a href="'.PHPWG_ROOT_PATH.'identification.php">'.$lang['ident_title'].'</a></div>';
   exit();
 }

trunk/admin/stats.php

@@ -30 +30 @@
 }
 include_once( PHPWG_ROOT_PATH.'admin/include/isadmin.inc.php' );
-$max_pixels = 500;
-//------------------------------------------------------------ comment deletion
-if ( isset( $_GET['del'] ) and is_numeric( $_GET['del'] ) )
-{
-  $query = 'DELETE FROM '.COMMENTS_TABLE;
-  $query.= ' WHERE id = '.$_GET['del'];
-  $query.= ';';
-  mysql_query( $query );
-}
-//--------------------------------------------------------- history table empty
-if ( isset( $_GET['act'] ) and $_GET['act'] == 'empty' )
-{
-  $query = 'DELETE FROM '.HISTORY_TABLE.';';
-  mysql_query( $query );
-}
 
-// empty link
-$url_empty = PHPWG_ROOT_PATH.'admin.php?page=stats';
-if (isset($_GET['last_days']))
-        $url_empty .='&last_days='.$_GET['last_days'];
-$url_empty.= '&act=empty';
+$url_img_monthly_report = PHPWG_ROOT_PATH.'/admin/images/monthly_visits.img.php';
 //----------------------------------------------------- template initialization
 $template->set_filenames( array('stats'=>'admin/stats.tpl') );
 
-if ( isset( $_GET['last_days'] ) ) define( 'MAX_DAYS', $_GET['last_days'] );
-else                               define( 'MAX_DAYS', 0 );
-
-foreach ( $conf['last_days'] as $option ) {
-  $url = $_SERVER['PHP_SELF'].'?last_days='.($option - 1);
-  $url.= '&page=stats';
-  $template->assign_block_vars(
-    'last_day_option',
-    array(
-      'OPTION'=>$option,
-      'T_STYLE'=>(( $option == MAX_DAYS + 1 )?'text-decoration:underline;':''),
-      'U_OPTION'=>add_session_id( $url )
-      )
-    );
-}
-
 $template->assign_vars(array(
-  'L_STAT_LASTDAYS'=>$lang['stats_last_days'],
-  'L_STAT_DATE'=>$lang['date'],
-  'L_STAT_LOGIN'=>$lang['login'],
-  'L_STAT_IP'=>$lang['IP'],
-  'L_STAT_FILE'=>$lang['file'],
-  'L_STAT_CATEGORY'=>$lang['category'],
-  'L_STAT_PICTURE'=>$lang['picture'],
-  'L_STAT_EMPTY'=>$lang['stats_empty'],
-  'L_STAT_SEEN'=>$lang['stats_pages_seen'],
-  'L_STAT_VISITOR'=>$lang['stats_visitors'],
-  
-  'STAT_EMPTY_URL'=>$url_empty
+  'L_STAT_TITLE'=>$lang['stats_last_days'],
+  'L_STAT_MONTHLY_ALT'=>$lang['stats_pages_seen_graph_title'],
+  'IMG_MONTHLY_REPORT'=>add_session_id($url_img_monthly_report)
   ));
-
-$tpl = array( 'stats_pages_seen_graph_title', 'stats_visitors_graph_title');
 
 //---------------------------------------------------------------- log  history
@@ -94 +48 @@
 $starttime = mktime(  0, 0, 0,date('n'),date('j'),date('Y') );
 $endtime   = mktime( 23,59,59,date('n'),date('j'),date('Y') );
-for ( $i = 0; $i <= MAX_DAYS; $i++ )
+//for ( $i = 0; $i <= MAX_DAYS; $i++ )
 {
-  $day = array();
+  /*$day = array();
   $template->assign_block_vars('day',array(
     ));

trunk/include/functions.inc.php

@@ -346 +346 @@
   if ( $conf['log'] )
   {
-    $query = 'insert into '.PREFIX_TABLE.'history';
+    $query = 'insert into '.HISTORY_TABLE;
     $query.= ' (date,login,IP,file,category,picture) values';
-    $query.= " (".time().", '".$user['username']."'";
+    $query.= " (NOW(), '".$user['username']."'";
     $query.= ",'".$_SERVER['REMOTE_ADDR']."'";
     $query.= ",'".$file."','".$category."','".$picture."');";

trunk/install/phpwebgallery_structure.sql

@@ -95 +95 @@
 DROP TABLE IF EXISTS phpwebgallery_history;
 CREATE TABLE phpwebgallery_history (
-  date int(11) NOT NULL default '0',
+  date datetime NOT NULL default '0000-00-00 00:00:00',
   login varchar(15) default NULL,
   IP varchar(50) NOT NULL default '',
   category varchar(150) default NULL,
   file varchar(50) default NULL,
-  picture varchar(150) default NULL
+  picture varchar(150) default NULL,
+  PRIMARY KEY `date` (`date`)
 ) TYPE=MyISAM;