17-Nov-2013, 09:38 PM
I moved some comments between different pages (admin/menage/comments/edit/page)..and they are all gone, I can't see no one..and all web page returns error 
---------
Undefined variable: cmtx_mysql_table_prefix in /member/.../comments/most_comments.php on line 8 (and 12)
-------------------
Undefined variable: cmtx_mysql_table_prefix in /member/.../comments/most_comments.php on line 8 (and 12)
PHP Code:
<?php
8)$comments = mysql_query("SELECT `page_id`, COUNT(`page_id`) AS `total` FROM `" . $cmtx_mysql_table_prefix . "comments` WHERE `is_approved` = '1' GROUP BY `page_id` ORDER BY `total` DESC LIMIT 1");
12)$page_query = mysql_query("SELECT * FROM `" . $cmtx_mysql_table_prefix . "pages` WHERE `id` = '" . $comment["page_id"] . "'");
$page = mysql_fetch_assoc($page_query);
Undefined variable: cmtx_mysql_table_prefix in /member/.../comments/recent_comments.php
PHP Code:
<?php
8)$comments = mysql_query("SELECT * FROM `" . $cmtx_mysql_table_prefix . "comments` WHERE `is_approved` = '1' ORDER BY `dated` DESC LIMIT 5");
12) $page_query = mysql_query("SELECT * FROM `" . $cmtx_mysql_table_prefix . "pages` WHERE `id` = '" . $comment["page_id"] . "'");
$page = mysql_fetch_assoc($page_query);
basically a pages replica ..(name and ID)..deleting double.. all ok.. but that scared ..!