Changeset 835 in ExiteCMS for trunk/includes/comments_include.php

Timestamp:

09/23/07 23:34:47 (5 years ago)

Author:

hverton

Message:

Replaced all button images by new {buttonlink} Smarty function

File:

• trunk/includes/comments_include.php (modified) (5 diffs)

trunk/includes/comments_include.php

@@ -21 +21 @@
 function showcomments($comment_type,$cdb,$ccol,$comment_id,$clink) {
 
-    global $settings,$locale,$userdata,$aidlink,
+    global $db_prefix, $settings,$locale,$userdata,$aidlink,
         $template_panels, $template_variables;
 
@@ -28 +28 @@
     if ((iMEMBER || $settings['guestposts'] == "1") && isset($_POST['post_comment'])) {
         $flood = false;
-        if (dbrows(dbquery("SELECT $ccol FROM ".DB_PREFIX."$cdb WHERE $ccol='$comment_id'"))==0) {
+        if (dbrows(dbquery("SELECT $ccol FROM ".$db_prefix."$cdb WHERE $ccol='$comment_id'"))==0) {
             fallback(BASEDIR."index.php");
         }
@@ -41 +41 @@
         $comment_smileys = isset($_POST['disable_smileys']) ? "0" : "1";
         if ($comment_name != "" && $comment_message != "") {
-            $result = dbquery("SELECT MAX(comment_datestamp) AS last_comment FROM ".DB_PREFIX."comments WHERE comment_ip='".USER_IP."'");
+            $result = dbquery("SELECT MAX(comment_datestamp) AS last_comment FROM ".$db_prefix."comments WHERE comment_ip='".USER_IP."'");
             if (!iSUPERADMIN || dbrows($result) > 0) {
                 $data = dbarray($result);
@@ -52 +52 @@
                 }
             }
-            if (!$flood) $result = dbquery("INSERT INTO ".DB_PREFIX."comments (comment_item_id, comment_type, comment_name, comment_message, comment_smileys, comment_datestamp, comment_ip) VALUES ('$comment_id', '$comment_type', '$comment_name', '$comment_message', '$comment_smileys', '".time()."', '".USER_IP."')");
+            if (!$flood) $result = dbquery("INSERT INTO ".$db_prefix."comments (comment_item_id, comment_type, comment_name, comment_message, comment_smileys, comment_datestamp, comment_ip) VALUES ('$comment_id', '$comment_type', '$comment_name', '$comment_message', '$comment_smileys', '".time()."', '".USER_IP."')");
         }
         redirect($clink);
@@ -58 +58 @@
 
     $result = dbquery(
-        "SELECT tcm.*,user_name FROM ".DB_PREFIX."comments tcm
-        LEFT JOIN ".DB_PREFIX."users tcu ON tcm.comment_name=tcu.user_id
+        "SELECT tcm.*,user_name FROM ".$db_prefix."comments tcm
+        LEFT JOIN ".$db_prefix."users tcu ON tcm.comment_name=tcu.user_id
         WHERE comment_item_id='$comment_id' AND comment_type='$comment_type'
         ORDER BY comment_datestamp ASC"