Changeset 189

Timestamp:

06/07/2003 11:19:42 PM (23 years ago)

Author:

mikelittle

Message:

Converted to ezsql

File:

• trunk/b2archives.php (modified) (5 diffs)

trunk/b2archives.php

@@ -5 +5 @@
 require_once('b2config.php');
 require_once($abspath.$b2inc.'/b2functions.php');
-
-dbconnect();
 
 // this is what will separate your archive links
@@ -53 +51 @@
 
 if ($archive_mode == 'monthly') {
-    $arc_sql="SELECT DISTINCT YEAR(post_date), MONTH(post_date) FROM $tableposts WHERE post_date < '$now' AND post_category > 0 ORDER BY post_date DESC";
+    $arc_sql="SELECT DISTINCT YEAR(post_date) AS yr, MONTH(post_date) AS mn  FROM $tableposts WHERE post_date < '$now' AND post_category > 0 ORDER BY post_date DESC";
     $querycount++;
-    $arc_result=mysql_query($arc_sql) or die($arc_sql.'<br />'.mysql_error());
-    while($arc_row = mysql_fetch_array($arc_result)) {
-        $arc_year  = $arc_row['YEAR(post_date)'];
-        $arc_month = $arc_row['MONTH(post_date)'];
+    $arc_results = $wpdb->get_results($arc_sql);
+    foreach ($arc_results as $arc_row) {
+        $arc_year  = $arc_row->yr;
+        $arc_month = $arc_row->mn;
         echo "<li><a href=\"$archive_link_m$arc_year".zeroise($arc_month,2).'">';
         echo $month[zeroise($arc_month,2)].' '.$arc_year;
@@ -64 +62 @@
     }
 } elseif ($archive_mode == 'daily') {
-    $arc_sql="SELECT DISTINCT YEAR(post_date), MONTH(post_date), DAYOFMONTH(post_date) FROM $tableposts WHERE post_date < '$now' AND post_category > 0 ORDER BY post_date DESC";
+    $arc_sql="SELECT DISTINCT YEAR(post_date) AS yr, MONTH(post_date) AS mn, DAYOFMONTH(post_date) as dom FROM $tableposts WHERE post_date < '$now' AND post_category > 0 ORDER BY post_date DESC";
     $querycount++;
-    $arc_result=mysql_query($arc_sql) or die($arc_sql.'<br />'.mysql_error());
-    while($arc_row = mysql_fetch_array($arc_result)) {
-        $arc_year  = $arc_row['YEAR(post_date)'];
-        $arc_month = $arc_row['MONTH(post_date)'];
-        $arc_dayofmonth = $arc_row['DAYOFMONTH(post_date)'];
+    $arc_results = $wpdb->get_results($arc_sql);
+    foreach ($arc_results as $arc_row) {
+        $arc_year  = $arc_row->yr;
+        $arc_month = $arc_row->mn;
+        $arc_dayofmonth = $arc_row->dom;
         echo "<li><a href=\"$archive_link_m$arc_year".zeroise($arc_month,2).zeroise($arc_dayofmonth,2).'">';
         echo mysql2date($archive_day_date_format, $arc_year.'-'.zeroise($arc_month,2).'-'.zeroise($arc_dayofmonth,2).' 00:00:00');
@@ -79 +77 @@
         $start_of_week = 1;
     }
-    $arc_sql="SELECT DISTINCT YEAR(post_date), MONTH(post_date), DAYOFMONTH(post_date), WEEK(post_date) FROM $tableposts WHERE post_date < '$now' AND post_category > 0 ORDER BY post_date DESC";
+    $arc_sql="SELECT DISTINCT YEAR(post_date) AS yr, MONTH(post_date) AS mn, DAYOFMONTH(post_date) AS dom, WEEK(post_date) AS wk FROM $tableposts WHERE post_date < '$now' AND post_category > 0 ORDER BY post_date DESC";
     $querycount++;
-    $arc_result=mysql_query($arc_sql) or die($arc_sql.'<br />'.mysql_error());
+    $arc_results = $wpdb->get_results($arc_sql);
     $arc_w_last = '';
-    while($arc_row = mysql_fetch_array($arc_result)) {
-        $arc_year = $arc_row['YEAR(post_date)'];
-        $arc_w = $arc_row['WEEK(post_date)'];
+    foreach ($arc_results as $arc_row) {
+        $arc_year = $arc_row->yr;
+        $arc_w = $arc_row->wk;
         if ($arc_w != $arc_w_last) {
             $arc_w_last = $arc_w;
-            $arc_ymd = $arc_year.'-'.zeroise($arc_row['MONTH(post_date)'],2).'-' .zeroise($arc_row['DAYOFMONTH(post_date)'],2);
+            $arc_ymd = $arc_year.'-'.zeroise($arc_row->mn,2).'-' .zeroise($arc_row->dom,2);
             $arc_week = get_weekstartend($arc_ymd, $start_of_week);
             $arc_week_start = date_i18n($archive_week_start_date_format, $arc_week['start']);
@@ -98 +96 @@
     }
 } elseif ($archive_mode == 'postbypost') {
-    $requestarc = " SELECT ID,post_date,post_title FROM $tableposts WHERE post_date < '$now' AND post_category > 0 ORDER BY post_date DESC";
+    $requestarc = " SELECT ID, post_date, post_title FROM $tableposts WHERE post_date < '$now' AND post_category > 0 AND post_status = 'publish' ORDER BY post_date DESC";
     $querycount++;
-    $resultarc = mysql_query($requestarc);
-    while($row=mysql_fetch_object($resultarc)) {
+    $resultarc = $wpdb->get_results($requestarc);
+    foreach ($resultarc as $row) {
         if ($row->post_date != '0000-00-00 00:00:00') {
             echo "<li><a href=\"$archive_link_p".$row->ID.'">';