Register Members List Search Today's Posts Mark Forums Read

Reply
 
Thread Tools
  #1  
Old 13 Mar 2010, 22:10
rayofvictory rayofvictory is offline
 
Join Date: Mar 2010
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?
Reply With Quote
  #2  
Old 13 Mar 2010, 22:58
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
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.
__________________
Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #3  
Old 14 Mar 2010, 16:45
rayofvictory rayofvictory is offline
 
Join Date: Mar 2010
Thanks for the quick reply!

Publish from feed in the sense :

I have to display the following results :


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

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!
Reply With Quote
  #4  
Old 15 Mar 2010, 00:27
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Real name: Lynne
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.
__________________
Try a search before posting for help. Many users won't, and don't, help if the question has been answered several times before.
W3Schools -
Online vBulletin Manual
If I post some CSS and don't say where it goes, put it in the additional.css template.
I will NOT help via PM (you will be directed to post in the forums for help.)
Reply With Quote
  #5  
Old 15 Mar 2010, 00:36
rayofvictory rayofvictory is offline
 
Join Date: Mar 2010
Please look at this thread : http://www.vbulletin.org/forum/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)..
Reply With Quote
  #6  
Old 16 Mar 2010, 04:19
fdifranco fdifranco is offline
 
Join Date: Feb 2010
Try this out

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
Reply With Quote
  #7  
Old 16 Mar 2010, 04:32
rayofvictory rayofvictory is offline
 
Join Date: Mar 2010
Originally Posted by fdifranco View Post
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
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
Forum Jump


New To Site? Need Help?

All times are GMT. The time now is 03:01.

Layout Options | Width: Wide Color: