PHP GUS_get_date_comparison Examples

Example #1

File: daily.php Project: hostellerie/gus

         } else {
             $T->set_var('rowclass', 'row2');
         }
         $result = DB_query("SELECT COUNT( DISTINCT ip ) AS num_anon FROM {$temp_table['name']} WHERE uid = '1' AND DAYOFMONTH( date ) = {$day}");
         $row = DB_fetchArray($result, FALSE);
         $anon += $row['num_anon'];
         $T->set_var('anon', $row['num_anon']);
         $result = DB_query("SELECT COUNT( DISTINCT uid ) AS num_registered FROM {$temp_table['name']} WHERE uid > '1' AND DAYOFMONTH( date ) = {$day}");
         $row = DB_fetchArray($result, FALSE);
         $reg += $row['num_registered'];
         $T->set_var('reg', $row['num_registered']);
         $result = DB_query("SELECT COUNT(*) AS num_pages FROM {$temp_table['name']} WHERE DAYOFMONTH( date ) = {$day}");
         $row = DB_fetchArray($result, FALSE);
         $pages += $row['num_pages'];
         $T->set_var('pages', $row['num_pages']);
         $date_compare = GUS_get_date_comparison('date', $year, $month, $day);
         $result = DB_query("SELECT COUNT(*) AS num_stories FROM {$_TABLES['stories']} WHERE {$date_compare}");
         $row = DB_fetchArray($result, FALSE);
         $stories += $row['num_stories'];
         $T->set_var('stories', $row['num_stories']);
         $result = DB_query("SELECT COUNT(*) AS num_comments FROM {$_TABLES['comments']} WHERE {$date_compare}");
         $row = DB_fetchArray($result, FALSE);
         $comments += $row['num_comments'];
         $T->set_var('comments', $row['num_comments']);
         $result = DB_query("SELECT COUNT(*) AS num_links FROM {$temp_table['name']}\n\t\t\t\t\t\t\t\tWHERE page LIKE '%portal.php' AND query_string <> '' AND DAYOFMONTH( date ) = {$day}");
         $row = DB_fetchArray($result, FALSE);
         $linksf += $row['num_links'];
         $T->set_var('linksf', $row['num_links']);
         $T->Parse('ABlock', 'ROW', TRUE);
     }
 }

Example #2

File: index.php Project: hostellerie/gus

 }
 $rowNum++;
 $temp_table = GUS_create_temp_userstats_table($res['year'], $res['month']);
 $result = DB_query("SELECT COUNT( DISTINCT ip ) AS num_anon FROM {$temp_table['name']} WHERE uid='1'");
 $row = DB_fetchArray($result, FALSE);
 $anon += $row['num_anon'];
 $T->set_var('anon', $row['num_anon']);
 $result = DB_query("SELECT COUNT( DISTINCT uid ) AS num_registered FROM {$temp_table['name']} WHERE uid>'1'");
 $row = DB_fetchArray($result, FALSE);
 $reg += $row['num_registered'];
 $T->set_var('reg', $row['num_registered']);
 $result = DB_query("SELECT COUNT(*) AS num_pages FROM {$temp_table['name']}");
 $row = DB_fetchArray($result, FALSE);
 $pages += $row['num_pages'];
 $T->set_var('pages', $row['num_pages']);
 $date_compare = GUS_get_date_comparison('date', $res['year'], $res['month']);
 $result = DB_query("SELECT COUNT(*) AS num_stories FROM {$_TABLES['stories']} WHERE {$date_compare}");
 $row = DB_fetchArray($result, FALSE);
 $stories += $row['num_stories'];
 $T->set_var('stories', $row['num_stories']);
 $result = DB_query("SELECT COUNT(*) AS num_comments FROM {$_TABLES['comments']} WHERE {$date_compare}");
 $row = DB_fetchArray($result, FALSE);
 $comments += $row['num_comments'];
 $T->set_var('comments', $row['num_comments']);
 if ($_GUS_phplinks == 1) {
     $outer_frame = DB_getItem($_TABLES['plsettings'], 'OuterFrame', "ID = '1' LIMIT 1");
     if ($outer_frame === 'N') {
         $result = DB_query("SELECT COUNT(*) AS num_links FROM {$temp_table['name']} WHERE page='phplinks/out.php'");
         $row = DB_fetchArray($result, FALSE);
         $linksf += $row['num_links'];
     } else {