| changeset 360 | fad9bb5c094b |
| parent 351 | 8978cb3541ca |
| child 361 | 35ed07abc99e |
| 359:e0787bb6285b | 360:fad9bb5c094b |
|---|---|
1003 $db->free_result(); |
1003 $db->free_result(); |
1004 $e = $db->sql_query('SELECT * FROM ' . table_prefix.'comments WHERE page_id=\'' . $page_id . '\' AND namespace=\'' . $namespace . '\' AND approved=1;'); |
1004 $e = $db->sql_query('SELECT * FROM ' . table_prefix.'comments WHERE page_id=\'' . $page_id . '\' AND namespace=\'' . $namespace . '\' AND approved=1;'); |
1005 if(!$e) $db->_die('The comment text data could not be selected.'); |
1005 if(!$e) $db->_die('The comment text data could not be selected.'); |
1006 $num_app = $db->numrows(); |
1006 $num_app = $db->numrows(); |
1007 $db->free_result(); |
1007 $db->free_result(); |
1008 $lq = $db->sql_query('SELECT c.comment_id,c.subject,c.name,c.comment_data,c.approved,c.time,c.user_id,u.user_level,u.signature,u.user_has_avatar,u.avatar_type |
1008 $lq = $db->sql_query('SELECT c.comment_id,c.subject,c.name,c.comment_data,c.approved,c.time,c.user_id,c.ip_address,u.user_level,u.signature,u.user_has_avatar,u.avatar_type |
1009 FROM ' . table_prefix.'comments AS c |
1009 FROM ' . table_prefix.'comments AS c |
1010 LEFT JOIN ' . table_prefix.'users AS u |
1010 LEFT JOIN ' . table_prefix.'users AS u |
1011 ON c.user_id=u.user_id |
1011 ON c.user_id=u.user_id |
1012 WHERE page_id=\'' . $page_id . '\' |
1012 WHERE page_id=\'' . $page_id . '\' |
1013 AND namespace=\'' . $namespace . '\' ORDER BY c.time ASC;'); |
1013 AND namespace=\'' . $namespace . '\' ORDER BY c.time ASC;'); |
1116 if($row['approved']) $applink .= $lang->get('comment_btn_mod_unapprove'); |
1116 if($row['approved']) $applink .= $lang->get('comment_btn_mod_unapprove'); |
1117 else $applink .= $lang->get('comment_btn_mod_approve'); |
1117 else $applink .= $lang->get('comment_btn_mod_approve'); |
1118 $applink .= '</a>'; |
1118 $applink .= '</a>'; |
1119 $strings['MOD_APPROVE_LINK'] = $applink; unset($applink); |
1119 $strings['MOD_APPROVE_LINK'] = $applink; unset($applink); |
1120 $strings['MOD_DELETE_LINK'] = '<a href="'.makeUrlNS($namespace, $page_id, 'do=comments&sub=admin&action=delete&id=' . $row['comment_id']) . '">' . $lang->get('comment_btn_mod_delete') . '</a>'; |
1120 $strings['MOD_DELETE_LINK'] = '<a href="'.makeUrlNS($namespace, $page_id, 'do=comments&sub=admin&action=delete&id=' . $row['comment_id']) . '">' . $lang->get('comment_btn_mod_delete') . '</a>'; |
1121 $strings['MOD_IP_LINK'] = '<span style="opacity: 0.5; filter: alpha(opacity=50);">' . ( ( empty($row['ip_address']) ) ? $lang->get('comment_btn_mod_ip_missing') : $lang->get('comment_btn_mod_ip_notimplemented') ) . '</span>'; |
|
1121 |
1122 |
1122 // Signature |
1123 // Signature |
1123 $strings['SIGNATURE'] = ''; |
1124 $strings['SIGNATURE'] = ''; |
1124 if($row['signature'] != '') $strings['SIGNATURE'] = RenderMan::render($row['signature']); |
1125 if($row['signature'] != '') $strings['SIGNATURE'] = RenderMan::render($row['signature']); |
1125 |
1126 |