- Timestamp:
- Jun 24, 2009, 9:00:40 PM (15 years ago)
- Location:
- trunk
- Files:
-
- 4 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/admin/comments.php
r3450 r3452 135 135 136 136 $query = ' 137 SELECT c.id, c.image_id, c.date, c.author, u.username, c.content, i.path, i.tn_ext 137 SELECT c.id, c.image_id, c.date, c.author, '. 138 $conf['user_fields']['username'].' AS username, c.content, i.path, i.tn_ext 138 139 FROM '.COMMENTS_TABLE.' AS c 139 140 INNER JOIN '.IMAGES_TABLE.' AS i 140 141 ON i.id = c.image_id 141 142 LEFT JOIN '.USERS_TABLE.' AS u 142 ON u. id= c.author_id143 ON u.'.$conf['user_fields']['id'].' = c.author_id 143 144 WHERE validated = \'false\' 144 145 ORDER BY c.date DESC -
trunk/comments.php
r3450 r3452 102 102 { 103 103 $page['where_clauses'][] = 104 'u. username= \''.addslashes($_GET['author']).'\'104 'u.'.$conf['user_fields']['username'].' = \''.addslashes($_GET['author']).'\' 105 105 OR author = \''.addslashes($_GET['author']).'\''; 106 106 } … … 269 269 ON ic.image_id = com.image_id 270 270 LEFT JOIN '.USERS_TABLE.' As u 271 ON u. id= com.author_id271 ON u.'.$conf['user_fields']['id'].' = com.author_id 272 272 WHERE '.implode(' 273 273 AND ', $page['where_clauses']).' … … 301 301 , com.author 302 302 , com.author_id 303 , username303 , '.$conf['user_fields']['username'].' AS username 304 304 , com.date 305 305 , com.content … … 309 309 ON ic.image_id = com.image_id 310 310 LEFT JOIN '.USERS_TABLE.' AS u 311 ON u. id= com.author_id311 ON u.'.$conf['user_fields']['id'].' = com.author_id 312 312 WHERE '.implode(' 313 313 AND ', $page['where_clauses']).' -
trunk/include/picture_comment.inc.php
r3450 r3452 129 129 130 130 $query = ' 131 SELECT com.id,author,author_id,username,date,image_id,content,validated 131 SELECT com.id,author,author_id,'.$conf['user_fields']['username'].' AS username, 132 date,image_id,content,validated 132 133 FROM '.COMMENTS_TABLE.' AS com 133 134 LEFT JOIN '.USERS_TABLE.' AS u 134 ON u. id= author_id135 ON u.'.$conf['user_fields']['id'].' = author_id 135 136 WHERE image_id = '.$page['image_id']. 136 137 $validated_clause.' -
trunk/template/yoga/comment_list.tpl
r3446 r3452 43 43 <fieldset> 44 44 <legend>{'Edit a comment'|@translate}</legend> 45 <label>{'comment'|@translate}<textarea name="content" id="contenteditid" rows="5" cols="80">{$comment.CONTENT }</textarea></label>45 <label>{'comment'|@translate}<textarea name="content" id="contenteditid" rows="5" cols="80">{$comment.CONTENT|escape}</textarea></label> 46 46 <input type="hidden" name="key" value="{$comment.KEY}"> 47 47 <input type="hidden" name="image_id" value="{$comment.IMAGE_ID|default:$current.id}">
Note: See TracChangeset
for help on using the changeset viewer.