vb.org Archive - Edited by which field in database ?

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - Edited by which field in database ? (https://vborg.vbsupport.ru/showthread.php?t=152755)

roxxx

07-19-2007 02:38 PM

Edited by which field in database ?

'Edited by',
which field is in database with user name who post edited ?

nico_swd

07-19-2007 03:23 PM

It's in the table called "editlog", the username field.

roxxx

07-20-2007 07:25 AM

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");

above query is correct,
but when I add to this JOIN isn't correct :(
I'd like display who edited post but is problem with query.

All times are GMT. The time now is 03:13 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00910 seconds Memory Usage 1,710KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (3)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: