[henry_vnc]

Iam wondering if any of you in here know what kind of technology or scripts / intergration they are using to pull out specific posts/threads from vbulletin onto the main page?

sample sites:

Slickdeals.net
Tinh Tế - Chia sẻ thông tin, kinh nghiệm cho ngÆ°á»Â�i dùng Ä‘iện thoại, pda, máy tÃÂ*nh, máy ảnh vÃÂ* các thiết bị công nghệ


thnsk for helping

[Caddyman]

Probably just a rss feed......right?

[Oldiesmann]

Why not just contact those sites and ask them? I'm sure they won't mind explaining how to do that.

[AirborneKim]

Seems I'm not able to access either website right now, however, I'd think it would be a simply MySQL Query connecting the the threads table and pulling them through based on their forum id's.

For example:

PHP Code:


$getthreads = $db->query("SELECT * FROM threads WHERE fid = 'FID' OR fid = 'FID' ORDER BY threadid LIMIT 10");

while ($threadlist = $db->fetch_array($getthreads)) {

eval();

} 


This isn't tested, so I'm not sure if it works, but it's more of an example to provide you with a general idea of where to start.

I'm not 100% sure if vBulletin still uses $db->query as I do not have a working copy on-hand to look over and review for their query statements and classes.

Basically, what the above query is doing is looking through the threads table of your database, if the forum id (fid) is equal to the one in the query, or any of theme in the query, it will 'spit' it out to the eval(); statement.

The 'while' bit is a loop to loop the query through until it is told to stop. In this case, we have a LIMIT 10 at the end of the query so it will only get the first 10 threads that match the query call.

The eval(); is actually what is used to call templates in vBulletin so you would need to create a new template for your style and name it as you wish (can be anything you want). If you look in index.php, you can find the eval() call to call a template within vBulletin.

Once you have a new template, you need to insert the values accordingly.

For example, $threadlist is the variable you'll use to call the table information.

$threadlist[threadid] - Outputs thread id (i.e. 1, 2, 3 ect)
$threadlist[threadtitle] - Outputs the thread title
$threadlist[postauthor] - Outputs the author of the post
....

And the list could go on according the the 'thread' table structure.