The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Edited by which field in database ?
'Edited by',
which field is in database with user name who post edited ? |
#2
|
||||
|
||||
It's in the table called "editlog", the username field.
|
#3
|
|||
|
|||
Code:
$getposts=$db->query_read(" SELECT post.*, editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline FROM ". TABLE_PREFIX ."thread AS thread, ". TABLE_PREFIX ."post AS post, ". TABLE_PREFIX ."editlog AS editlog JOIN editlog ON post.postid = editlog.userid WHERE thread.forumid = 5 AND post.postid = thread.firstpostid AND post.visible = 1 GROUP BY post.postid DESC LIMIT 10"); but when I add to this JOIN isn't correct I'd like display who edited post but is problem with query. |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|