vb.org Archive - RDF-Feed from your Forums

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

- vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)

- - RDF-Feed from your Forums (https://vborg.vbsupport.ru/showthread.php?t=48187)

@ Dontom
Ich finde es klasse, dass Du Dir auch die M?he gemacht hast,
etwas derartiges zu coden. Darum sehe mein Posting bitte
nicht als Konkurenz-Angebot, sondern vielmehr als
eine weitere m?gliche L?sung, die Dir frei zur Verf?gung steht. :)

Liebe Gr??e,

It probably adds another query, but how can I also add the forum title to it? Do I also need an extra LEFT JOIN on forum USING(forumid)? Can someone point me in the right direction?

Thanks!
- djr

Quote:

Originally posted by djr
It probably adds another query, but how can I also add the forum title to it? Do I also need an extra LEFT JOIN on forum USING(forumid)? Can someone point me in the right direction?

Thanks!
- djr

It is already in there!

PHP Code:


		
			
...votetotal, forum.title AS forumname FROM thread...

You can use it as $rows[forumname].

Sorry, wasn't clear :( I use your version, because it's easier to work with. But you use a LEFT JOIN on forumpermission instead of forum.

- djr

Then you should have asked in the other thread. ;)

PHP Code:


		
			
$threads=$DB_site->query("SELECT threadid,thread.title AS title,thread.lastpost,thread.replycount,postusername,thread.forumid,forum.title AS forumtitle

                          FROM thread

                          LEFT JOIN forumpermission USING(forumid)

                          LEFT JOIN forum ON forum.forumid = thread.forumid

                          WHERE forumpermission.forumid IS NULL

                          ORDER BY lastpost DESC LIMIT ".$showthreadnumber);

You should also release yours as hack. Nothing against Dontom's one, but I feel a 'lil insecure when I have to include my db-details in a seperate php-file. I'd rather use a version which uses global.php.

Again, sorry for posting in the wrong thread and muchos thanks for the update query. Works like a charm!

- djr

Quote:

Originally posted by Areku
Excuse me, but what's a RDF file?

:rolleyes:

http://www.google.com/search?hl=en&i...%22RDF+file%22

Three questions.

1. How does RDF differ from RSS? I'm foggy on these XML filetypes. Or are they pretty much the same thing.

2. Is there a way to get it to just take news from one forum rather then all of them?

3. Why does this hack seem so much simpler then the vbsyndicate hack available?

Here's what I'm looking to do. I have my forums located at one URL and my main site at another. I want to get news from one forum onto the main page of my site. I figured RSS/RDF might be the best (only) way. It would also be a bonus if others could get that news on their site.

If I understand this hack correctly that is what this does right?

Quote:

Originally posted by roxics
Three questions.

1. How does RDF differ from RSS? I'm foggy on these XML filetypes. Or are they pretty much the same thing.
### ahem - no idea ;) very foggy here, too

2. Is there a way to get it to just take news from one forum rather then all of them?
### sure, just change the select -statement to below and change 999 to the forum you want to use

SELECT thread.title AS threadtitle, threadid, dateline, postusername, postuserid, thread.replycount, thread.lastposter, views, thread.forumid AS threadforumid, thread.lastpost AS lastpost, votenum, votetotal, forum.title AS forumname FROM thread LEFT JOIN forum ON forum.forumid = thread.forumid WHERE thread.visible = 1 AND thread.open AND forum.forumid = 999 ORDER BY LASTPOST DESC LIMIT 15

3. Why does this hack seem so much simpler then the vbsyndicate hack available?

### vbsyndicate generates afaik a javascript output, which is written periodically to you server

Here's what I'm looking to do. I have my forums located at one URL and my main site at another. I want to get news from one forum onto the main page of my site. I figured RSS/RDF might be the best (only) way. It would also be a bonus if others could get that news on their site.

### this hack should do this perfectly

If I understand this hack correctly that is what this does right?

Ok the feed works. My only problem is that if you look at the feed on another site it shows up. But when you click on the headline it takes you to a 404 error on my site.

Here is the feed on another site (ve news up top)

Here is my board

The forum it's drawing from is called Announcements & Classifieds

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_php_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01062 seconds Memory Usage 1,745KB 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 (2)bbcode_php_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (10)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 pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: