vb.org Archive - Need help querying the database & pulling info

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

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

- - Need help querying the database & pulling info (https://vborg.vbsupport.ru/showthread.php?t=239083)

TerryMason

03-25-2010 01:25 PM

Need help querying the database & pulling info

I have a normal (non-VB) php page for my front / landing page. I'd like to be able to show the last 10 updated threads from forums 3,7,8,16,31. I want to pull the last post time, as well as other info, so using an RSS feed won't work - I need to pull from the database.

I'm a rookie with mysql, so I'm not exactly sure what the best way to go about this is. Does anyone have a code example to get me started? Also, should I have the database info inside of this file, or should I try to include one of my existing vb files (i.e. config.php)

Thanks for the help guys.

Lynne

03-25-2010 01:36 PM

There are a few modifications that show the Last 10 Update Threads... have you tried downloading one of them and looking at the code?

TerryMason

03-25-2010 02:28 PM

I have, but they don't seem to be a complete program, meaning they seem to call other functions that are built into vbulletin.

I need to find a way to access the database, and pull the data.

I had been working with this:

Code:





$mysql = mysql_connect(localhost);

mysql_select_db(DATABASE_NAME);

$user = $_GET['USER'];

$pass = $_GET['PASS'];





        ## GET LATEST THREADS ##

        SELECT thread.*,thread.iconid AS threadiconid $previewfield

        FROM ".TABLE_PREFIX."thread AS thread

        LEFT JOIN ".TABLE_PREFIX."deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND type = 'thread')

        $previewjoin

        WHERE open <> 10

        AND forumid NOT IN (0$limitfids)

        AND thread.visible = '1'

        AND deletionlog.primaryid IS NULL

        ORDER BY lastpost

        DESC LIMIT 5");

and I think I'm able to get the data, but I don't know how to echo it to the screen.

Anseur

03-25-2010 06:58 PM

I would suggest you look at the 'how to create your own vbulliten page' article, and see if your can add the appropiate emelents of that to your landing/front page. then you can use a mod like that to take the data and put it into a variable, then make a template that is called by the page and then call the variable in that page.

failing that, you will need to learn some php to get from the database and ehco stuff onto your custom page. Either way, your going to need some coding experiance to do it.

Lynne

03-26-2010 02:24 AM

If you require global.php in your code, then you don't need to write the stuff about connecting to mysql.

Have you taken a look at the showthread.php page? It's going to have some very similar code to what you want.

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00949 seconds Memory Usage 1,717KB 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 (5)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: