How can i get the first post only?

[vietdjclub]

somebody know the way to get only first post ,

ex: i have the topic with 20 reply on it.

xxx (owner posted)
x1
x2
x3
...
x20

now i want to write a query to get only xxx (owner posted)
how can i do it
Thank for reading my question

[Opserty]

SELECT *
FROM thread
LEFT JOIN post ON ( post.postid = thread.firstpostid )
WHERE thread.threadid = AAA

(Where AAA is the thread id)

[vietdjclub]

thank Opserty

[Dismounted]

You may want to just grab the post's info, instead of including thread data, to save on memory.
SELECT p.*
FROM thread AS t
LEFT JOIN post AS p ON (p.postid = t.firstpostid)
WHERE t.threadid = X

[Paul M]

I hate it when people use single letters in sql. :)

[Dismounted]

SELECT post.*
FROM thread AS thread
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
WHERE thread.threadid = X
Happy now, Paul? :p

[Opserty]

You don't need the "AS thread" or "AS post" if they are the same as the table names no? :p

[Blindspot]

even easier

$postinfo = fetch_postinfo($thread['firstpostid']);

and if you dont have $thread


$threadinfo= fetch_postinfo($threadid);
$postinfo = fetch_postinfo($threadinfo['firstpostid']);

[vietdjclub]

wow it's great for coder. big thank all

--------------- Added 1215142664 at 1215142664 ---------------

thank for first question. now i got trouble with query

my query:

$x = $vbulletin->db->query_read("
SELECT * FROM " . TABLE_PREFIX . "thread as t
INNER JOIN " . TABLE_PREFIX . "post as p ON (t.threadid = p.threadid)
WHERE forumid IN(xx) ORDER BY p.post_thanks_amount DESC LIMIT 0 , 5");

while ($xxx = $vbulletin->db->fetch_array($x))
{
$mymessage = $xxx['threadid'];
$threaddm->do_set('pagetext', $mymessage);
}


more code....

the thread auto create perfectly with all infomation but 'pagetext' can not get anything from my query, it's empty.

i want to ask who can help me: how can i get 5 threadid and put it on 'pagetext'

it's mean 1 new thread with 5 threadid (i got from above query) on its

best regard,

[vietdjclub]

please help me with code

my query:

$x = $vbulletin->db->query_read("
SELECT * FROM " . TABLE_PREFIX . "thread as t
INNER JOIN " . TABLE_PREFIX . "post as p ON (t.threadid = p.threadid)
WHERE forumid IN(xx) ORDER BY p.post_thanks_amount DESC LIMIT 0 , 5");

while ($xxx = $vbulletin->db->fetch_array($x))
{
$mymessage = $xxx['threadid'];
$threaddm->do_set('pagetext', $mymessage);
}

$threaddm->do_set('forumid', $to_forum_1);
$threaddm->do_set('postuserid', $postuserid);
$threaddm->do_set('userid', $postuserid);
$threaddm->do_set('username', $postusername);
$threaddm->do_set('title', $title);
$threaddm->do_set('allowsmilie', $allowsmilie);
$threaddm->do_set('visible', $visible);
$tid = $threaddm->save();

the thread auto create perfectly with all infomation but 'pagetext' can not get anything from my query, it's empty.

i want to ask who can help me: how can i get 5 threadid and put it on 'pagetext'

it's mean 1 new thread with 5 threadid (i got from above query) on its

best regard,

[Dismounted]

What are you trying to do there? Why are you assigning the thread id to pagetext? Please explain what you want to do.

[vietdjclub]

What are you trying to do there? Why are you assigning the thread id to pagetext? Please explain what you want to do.

thank for your reply.

my plan for the mod:

step 1: run query to get 10 threadid from thread table
step 2: auto create 1 new thread on the special forum, with 10 threadid that i got from step 1

ex:

step 1: after query i got threadid = 1,2,3,4,5,6,7,8,9,10
step 2: one new thread auto open on the special forum = 3
step 3: then put 1,2,3,4,5,6,7,8,9,10 on the new thread on step 2


please help me. thank again

[Blindspot]

even easier

$postinfo = fetch_postinfo($thread['firstpostid']);

and if you dont have $thread


$threadinfo= fetch_postinfo($threadid);
$postinfo = fetch_postinfo($threadinfo['firstpostid']);

[vietdjclub]

finally i found how to do it. thank for support

[Opserty]

even easier

$postinfo = fetch_postinfo($thread['firstpostid']);and if you dont have $thread


$threadinfo= fetch_postinfo($threadid);
$postinfo = fetch_postinfo($threadinfo['firstpostid']);

Using that method you'd be using two queries, when you can cover it in a single query with a JOIN.

[vietdjclub]

exactly as Opserty said. I use JOIN

[vietdjclub]

Thank friends for helping me . i just finished my mod on yesterday
mod: Auto Top 10 Threads - Auto run very month

some pics for the mod (setting & Result)