How to display entries from MySQL into sidebar in vb 4?
 

This is the first time I ever had to use vbulletin for a client. The requirement is that I have to publish a feed from MySQL in the sidebar for CMS/blog and forum of vbulletin 4 implementation.

Could you please point me in the right direction?

I don't know what you mean by "publish a feed from MySQL". However, I'll tell you that you will probably do this for your CMS page by creating a PHP widget and on the Forum page by creating a PHP block. I don't know about the blog.

Thanks for the quick reply!

Publish from feed in the sense :

I have to display the following results :

That should display a feed like thing on the right sidebar with the following output (all links are hyperlinks)..

Check 1
Check 2
Check 3
......so on.

Did I make sense? What is the best way of doing it? Thank you so much!

I guess you want a PHP widget (for the CMS page) and block (for the forum.php page). there have been several released in the mods forum if you need to see examples.

Please look at this thread : https://vborg.vbsupport.ru/showthread.php?t=238270

Am struggling for so many hours now! How to display an array in a PHP block?

p.s : (Though I have a license, it still is blocking my own code from being displayed in the forums. I am baffled with the whole license process)..

I wrote a PHP widget for a fellow a few weeks ago.

It sounds like you are trying to do something similar. Have a look at this post.

You will want to change the SQL to suit your needs and also make links out of the data by adding the appropriate <a></a> tags.

So take what I wrote and tweak it a little bit. It shouldn't be too difficult.

-fab

Sir, you are fabulous! I got everything working in the last hour but was having issues trying to concatenate <br/> tags. Was using </br> and it didn't work, now it does!

I really really appreciate your help :) I wish there is more support staff like you here for a commercial product like this. Searching without keyword knowledge is a pain for newbie vb4 users like me. Thanks again :)