Second DB on single Page

[req2d]

I am in the process of learning & writing a mod that will essentially show thumbnails for spotlight threads. To keep things simple, I'm not linking it into vb per say, so my staff will have an external admin page where they will be able to upload and save spotlight thread entries ( seperate DB). This will then show the latest x spotlight thumbnails on forumhome.

Is it ok to have 2 db connections and if so, do I just save display/query part of this mod in a plugin within vb?

Many thanks for any help you can provide

Cheers

[sabret00the]

sounds to me like you're over complicating things to be honest. it really doesn't matter if it's the same DB or even if it's done through deep vBulletin integration. you could do the above via the vBulletin engine by creating a usergroup permission check on the newly designed admin page and do it like that. it'll probably be more efficient too.

[req2d]

Thank you Sabe,

Would this also work even if my staff do not have admin access (they're just mods)?

[sabret00the]

Yep, if you look into the article section. there's a thread on usergroup permissions. check that out.

Basically in the same way you enable your mods the ability the move posts, you'd have something "Can access news portal" and voila. It seems hard at first glance, but bare with it. it'll make things so much easier.

[req2d]

Thank you for your advice, will definitely look into it.

--------------- Added [DATE]1192389686[/DATE] at [TIME]1192389686[/TIME] ---------------

Given that I have a table created within the vb db, would this show the latest 6 images in a row? Sorry if the question is rather novice, all new to me. Many thanks

PHP Code:

$highlightthreads = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "highlightthread ORDER BY id DESC LIMIT 0, 6); 

while ($row = mysql_fetch_array($highlightthreads)) {
    echo "<img src=".$row["image"]." />";
    } 


[sabret00the]

it looks right.