Changeset 139

Timestamp:

06/01/2003 12:10:47 PM (23 years ago)

Author:

saxmatt

Message:

ezSQL updates.

File:

• trunk/wp-admin/b2edit.showposts.php (modified) (5 diffs)

trunk/wp-admin/b2edit.showposts.php

@@ -129 +129 @@
                 <option value="all">All Categories</option>
                 <?php
-        $query="SELECT * FROM $tablecategories";
-        $result=mysql_query($query);
+        $categories = $wpdb->get_results("SELECT * FROM $tablecategories");
         $querycount++;
         $width = ($mode=="sidebar") ? "100%" : "170px";
-        while($row = mysql_fetch_object($result)) {
-                echo "<option value=\"".$row->cat_ID."\"";
-                if ($row->cat_ID == $postdata["Category"])
+        foreach ($categories as $category) {
+                echo "<option value=\"".$category->cat_ID."\"";
+                if ($category->cat_ID == $postdata["Category"])
                         echo " selected='selected'";
                 echo ">".$row->cat_name."</option>";
@@ -231 +230 @@
         include($abspath.'blog.header.php');
 
-        while($row = mysql_fetch_object($result)) {
+        foreach ($posts as $post) {
                 $posts_per_page = 10;
         start_b2(); ?>
                         <p>
-                                <strong><?php the_time('Y/m/d @ H:i:s'); ?></strong> [ <a href="b2edit.php?p=<?php echo $id ?>&c=1"><?php comments_number('no comment', '1 comment', "% comments") ?><?php trackback_number('', ', 1 trackback', ', % trackbacks') ?><?php pingback_number('', ', 1 pingback', ', % pingbacks') ?></a>
+                                <strong><?php the_time('Y/m/d @ H:i:s'); ?></strong> [ <a href="b2edit.php?p=<?php echo $id ?>&c=1"><?php comments_number('no comment', '1 comment', "% comments") ?></a>
                                 <?php
                                 if (($user_level > $authordata[13]) or ($user_login == $authordata[1])) {
-                                echo " - <a href=\"b2edit.php?action=edit&amp;post=".$postdata["ID"];
+                                echo " - <a href='b2edit.php?action=edit&amp;post=$id";
                                 if ($m)
                                 echo "&m=$m";
-                                echo "\">Edit</a>";
-                                echo " - <a href=\"b2edit.php?action=delete&amp;post=".$postdata["ID"]."\" onclick=\"return confirm('You are about to delete this post \'".$row->post_title."\'\\n  \'Cancel\' to stop, \'OK\' to delete.')\">Delete</a> ";
+                                echo "'>Edit</a>";
+                                echo " - <a href='b2edit.php?action=delete&amp;post=$id' onclick=\"return confirm('You are about to delete this post \'".$row->post_title."\'\\n  \'Cancel\' to stop, \'OK\' to delete.')\">Delete</a> ";
                                 }
                                 ?>
@@ -250 +249 @@
                                 <?php permalink_anchor(); ?>
                                 <?php
-                                if ($safe_mode)
-                                        echo "<xmp>";
                                 the_content();
-                                if ($safe_mode)
-                                        echo "</xmp>";
                                 ?>
                         </p>
@@ -262 +257 @@
                                 if (($withcomments) or ($c)) {
 
-                                        $queryc = "SELECT * FROM $tablecomments WHERE comment_post_ID = $id ORDER BY comment_date";
-                                        $resultc = mysql_query($queryc);
-                                        if ($resultc) {
+                                        $comments = $wpdb->get_results("SELECT * FROM $tablecomments WHERE comment_post_ID = $id ORDER BY comment_date");
+                                        if ($comments) {
                                         ?>
 
-                                        <h3 id="comments">comments</h3>
-
+                                        <h3>Comments</h3>
+                                <ol id="comments">
                                         <?php
-                                        while($rowc = mysql_fetch_object($resultc)) {
-                                                $commentdata = get_commentdata($rowc->comment_ID);
+                                        foreach ($comments as $comment) {
+                                                $commentdata = $comment;
                                         ?>
                                 
                                         <!-- comment -->
-                                        <p>
+                                        <li>
                                         <b><?php comment_author() ?> ( <?php comment_author_email_link() ?> / <?php comment_author_url_link() ?> )</b> (IP: <?php comment_author_IP() ?>)
-                                        <br />
                                         <?php comment_text() ?>
-                                        <br />
                                         <?php comment_date('Y/m/d') ?> @ <?php comment_time() ?> 
                                         <?php 
                                         if (($user_level > $authordata[13]) or ($user_login == $authordata[1])) {
-                                                echo "[ <a href=\"b2edit.php?action=editcomment&comment=".$commentdata["comment_ID"]."\">Edit</a>";
-                                                echo " - <a href=\"b2edit.php?action=deletecomment&p=".$postdata["ID"]."&comment=".$commentdata["comment_ID"]."\">Delete</a> ]";
+                                                echo "[ <a href=\"b2edit.php?action=editcomment&amp;comment=".$commentdata->comment_ID."\">Edit</a>";
+                                                echo " - <a href=\"b2edit.php?action=deletecomment&amp;p=".$post->ID."&amp;comment=".$commentdata->comment_ID."\">Delete</a> ]";
                                         }
                                         ?>
-                                        </p>
+                                        </li>
                                         <!-- /comment -->
 
@@ -293 +285 @@
                                         <?php //end of the loop, don't delete
                                         }
-
+                                        echo '</ol>';
                                         if ($comment_error)
-                                                echo "<p><font color=\"red\">Error: please fill the required fields (name & comment)</font></p>";
+                                                echo "<p>Error: please fill the required fields (name & comment)</p>";
                                         ?>