xml backend question

daemon · Worker Joined: Jan 07, 2005 Posts: 163

the recent forums block doesnt have a backend xml with it, is there one available somewhere?

Raven · Posted: Sat Apr 01, 2006 11:20 am

Do you not see the orange XML button at the top? That's the backend xml.

daemon · Worker Joined: Jan 07, 2005 Posts: 163

it is looking for backendforums.php....... there wasnt one in the distro

Raven · Posted: Sat Apr 01, 2006 8:31 pm

That's because I was leaving that up to each admin. Not everyone wants the same info passed. You just need to take backend.php and modify it for your use. For a head-start, here is mine

Code:

<?php
/************************************************************************/
/* PHP-NUKE: Advanced Content Management System */
/* ============================================ */
/* */
/* Copyright (c) 2002 by Francisco Burzi */
/* http://phpnuke.org */
/* */
/* This program is free software. You can redistribute it and/or modify */
/* it under the terms of the GNU General Public License as published by */
/* the Free Software Foundation; either version 2 of the License. */
/* */
/************************************************************************/
/* Additional coding modifications by Raven 2004 */
/* http://ravenphpscripts.com -- http://ravenwebhosting.com */
/************************************************************************/
/* 100% RSS/XML and W3C Compliance by Gaylen Fraley (aka Raven) */
/* http://ravenphpscripts.com -- http://ravenwebhosting.com */
/************************************************************************/
header("Content-Type: text/xml");
include_once("mainfile.php");
echo makeBackendForumRSS($fid=0,$rssFeedLimit=15);
function makeBackendForumRSS($fid=0,$rssFeedLimit=15) {
global $db, $nukeurl, $user_prefix, $backend_language;
$fid = isset($_GET['fid'])?$_GET['fid']:0;
$fid = intval($fid);
$whereClause = '';
$counter = 0;
$xmlHeader = '';
$xmlBody = '';
$xmlFooter = '';
$addForumName = FALSE;
if ($fid) {
   $whereClause = "WHERE forum_id='$fid'";
   $addForumName = TRUE;
}
$xmlHeader .= "<?xml version=\"1.0\" encoding=\"ISO-8859-1\"?>\n\n";
$xmlHeader .= "<!DOCTYPE rss PUBLIC \"-//Netscape Communications//DTD RSS 0.91//EN\"\n";
$xmlHeader .= " \"http://my.netscape.com/publish/formats/rss-0.91.dtd\">\n\n";
$xmlHeader .= "<rss version=\"0.91\">\n\n";
$xmlHeader .= "<channel>\n";
$xmlHeader .= "<title>".htmlspecialchars($sitename)." - Forums%%_NAME_%%</title>\n";
$xmlHeader .= "<link>$nukeurl</link>\n";
$xmlHeader .= "<description>".htmlspecialchars($backend_title)."</description>\n";
$xmlHeader .= "<language>$backend_language</language>\n\n";
$result = $db->sql_query("SELECT topic_id, forum_id, topic_last_post_id, topic_title, topic_moved_id FROM ".$user_prefix."_bbtopics $whereClause ORDER BY topic_last_post_id DESC");
while(list($topic_id, $forum_id, $topic_last_post_id, $topic_title, $topic_moved_id) = $db->sql_fetchrow($result)) {
   $result1 = $db->sql_query( "SELECT auth_view, auth_read, forum_name, cat_id FROM ".$user_prefix."_bbforums where forum_id = '$forum_id'");
   list( $auth_view, $auth_read, $forum_name, $cat_id ) = $db->sql_fetchrow($result1);
   if( ( $auth_view != 0 ) or ( $auth_read != 0 ) ) continue;
   if( $topic_moved_id != 0 ) continue;
   ++$counter;
   $result3 = $db->sql_query("SELECT topic_id, FROM_UNIXTIME(post_time,'%b %d, %Y at %T') as post_time, username, user_id FROM ".$user_prefix."_bbposts," .$user_prefix."_users where post_id='$topic_last_post_id' AND user_id=poster_id Limit 1");
   list($topic_id, $post_time, $username, $user_id)=$db->sql_fetchrow($result3);
   $rtitle = superhtmlentities($topic_title);
   $rtitle = str_replace('_',' ',$rtitle); //added 9/1/2004
   $xmlBody .= "<item>\n";
   $xmlBody .= "<title>".htmlspecialchars($rtitle)."</title>\n";
   $xmlBody .= "<link>$nukeurl/postp$topic_last_post_id#$topic_last_post_id</link>\n";
   $xmlBody .= "</item>\n\n";
   if ($counter==$rssFeedLimit) break;
}
$xmlFooter .= "</channel>\n";
$xmlFooter .= "</rss>";
if ($addForumName) $xmlHeader = str_replace('%%_NAME_%%',": $forum_name",$xmlHeader);
else $xmlHeader = str_replace('%%_NAME_%%','',$xmlHeader);
return $xmlHeader.$xmlBody.$xmlFooter;
}

function superhtmlentities($text) {
// Thanks to mirrorball_girl for this
$entities = array(128 => 'euro', 130 => 'sbquo', 131 => 'fnof', 132 => 'bdquo', 133 => 'hellip', 134 => 'dagger', 135 => 'Dagger', 136 => 'circ', 137 => 'permil', 138 => 'Scaron', 139 => 'lsaquo', 140 => 'OElig', 145 => 'lsquo', 146 => 'rsquo', 147 => 'ldquo', 148 => 'rdquo', 149 => 'bull', 150 => '#45', 151 => 'mdash', 152 => 'tilde', 153 => 'trade', 154 => 'scaron', 155 => 'rsaquo', 156 => 'oelig', 159 => 'Yuml');
$new_text = '';
for($i = 0; $i < strlen($text); $i++) {
   $num = ord($text{$i});
   if (array_key_exists($num, $entities)) {
      switch ($num) {
         case 150:
            $new_text .= '-';
            break;
         case 153:
            $new_text .= '(tm)';
            break;
         default:
            $new_text .= "&".$entities[$num].';';
      }
   }
   elseif ($num < 127 || $num > 159) {
      $new_text .= htmlentities($text{$i});
   }
}
$new_text = ereg_replace(" +", " ", $new_text);
## remove double spaces.
return $new_text;
}
?>

daemon · Worker Joined: Jan 07, 2005 Posts: 163

sweet..... that made it easy....... thanks

dirtbag · Regular Joined: Nov 09, 2003 Posts: 73

thanks as i was looking for this and found it! you should add it with feature distros... is there a quick tweak where say i wanted just to list only Posts from a Certain Forum(s) instead all my Forums Subjects?

thanks again
rick

dirtbag · Regular Joined: Nov 09, 2003 Posts: 73

ahhh i spoke to soon! Crying or Very sad

anyideas as my links are getting messed up? something with the googletap?

Only registered users can see links on this board!
Get registered or login to the forums!

or maybe something changed since 2.002 as i am using that version of RavenPhpNuke

Code:

−
<rss version="0.91">
−
<channel>
<title> - Forums</title>
<link>http://www.subfighter.com</link>
<description/>
<language>en-us</language>
−
<item>
<title>Bottom Half Guard Submissions</title>
<link>http://www.subfighter.com/postp510780#510780</link>
</item>
−
<item>
<title>Video-&gt; Gono Akihiro vs Ivan Salaverry</title>
<link>http://www.subfighter.com/postp510779#510779</link>
</item>
−
<item>
−
<title>
Lee Murray Finally Caught &amp; Arrested In Morocco?
</title>
<link>http://www.subfighter.com/postp510777#510777</link>
</item>
−
<item>
<title>Any predictions on Renzo v/s Miletich?</title>
<link>http://www.subfighter.com/postp510776#510776</link>
</item>

pdoobepd · Worker Joined: May 07, 2005 Posts: 129

Raven...Using your block for a start my links are all messed up as well but they look nothing like dirtbags... Here is an example of what comes up when I click on the xml link in the collapsing forums block:

Only registered users can see links on this board!
Get registered or login to the forums!

en-us

Only registered users can see links on this board!
Get registered or login to the forums!

They are all scrunched together...??? and the page looks nothing like an rss/xml page should. Help ? lol Embarassed

Also most of those links and numbers are bad...no such posting number...where do I edit to fix the number or what is shown in the xml, once it actually looks like a real xml file? worship

Raven · Posted: Mon Jun 26, 2006 9:04 pm

Are you using an RSS reader? When I click on your xml button I get what I expect

Quote:

−
<rss version="0.91">
−
<channel>
<title> - Forums</title>
<link>http://www.ParanormalDreams.com/PD</link>
<description/>
<language>en-us</language>
−
<item>
<title>Saying Hello</title>
<link>http://www.ParanormalDreams.com/PD/postp630#630</link>
</item>
−
<item>
<title>Hello From Soth Yorkshire</title>
<link>http://www.ParanormalDreams.com/PD/postp629#629</link>
</item>
−
<item>
<title>Dream Experiement</title>
<link>http://www.ParanormalDreams.com/PD/postp627#627</link>
</item>
−
<item>
<title>Exploding Heads</title>
<link>http://www.ParanormalDreams.com/PD/postp626#626</link>
</item>
−
<item>
<title>Re: Paranormal Dreams News Letter</title>
<link>http://www.ParanormalDreams.com/PD/postp625#625</link>
</item>
−
<item>
<title>Internet connections have slowed down</title>
<link>http://www.ParanormalDreams.com/PD/postp623#623</link>
</item>
−
<item>
<title>Microsoft WGA - Windows Genuine Advantage</title>
<link>http://www.ParanormalDreams.com/PD/postp622#622</link>
</item>
−
<item>
<title>Do You Believe</title>
<link>http://www.ParanormalDreams.com/PD/postp621#621</link>
</item>
−
<item>
<title>Pluto's Newly Found Moons Named Nix, Hydra</title>
<link>http://www.ParanormalDreams.com/PD/postp619#619</link>
</item>
−
<item>
<title>Bank Data Sifted in Secret by U.S.</title>
<link>http://www.ParanormalDreams.com/PD/postp618#618</link>
</item>
−
<item>
<title>Global Warming</title>
<link>http://www.ParanormalDreams.com/PD/postp617#617</link>
</item>
−
<item>
<title>News Letter</title>
<link>http://www.ParanormalDreams.com/PD/postp616#616</link>
</item>
−
<item>
<title>Quick Management Lessons</title>
<link>http://www.ParanormalDreams.com/PD/postp612#612</link>
</item>
−
<item>
<title>hello everyone...</title>
<link>http://www.ParanormalDreams.com/PD/postp609#609</link>
</item>
−
<item>
<title>Politics</title>
<link>http://www.ParanormalDreams.com/PD/postp605#605</link>
</item>
</channel>
</rss>

pdoobepd · Worker Joined: May 07, 2005 Posts: 129

XML text is showing up properly now...server time delay probably...however those links are bad...no such postings exist such as

Only registered users can see links on this board!
Get registered or login to the forums!

What'd I do wrong ? lol

The correct link for the topic number above is actually:

Only registered users can see links on this board!
Get registered or login to the forums!

Raven · Posted: Mon Jun 26, 2006 9:55 pm

Looks like a GT issue to me.

pdoobepd · Worker Joined: May 07, 2005 Posts: 129

GT Issue??? as in google tap ? I have no idea what that is and don't think I have it. I do have a google websearch block and the google ads block...but that's it.

??Fixes??

montego · Posted: Tue Jun 27, 2006 6:27 am

Are you certain that you have the absolute latest version of that block? Look inside the block script and see if "Version 2.3.0" is at the top... Also, are you sure yourself or someone else hasn't modified the code? You might want to try replacing it with a freshly downloaded 2.3.0 version from this site here.

pdoobepd · Worker Joined: May 07, 2005 Posts: 129

Yes I have the latest version of the block I downloaded it from Ravens site here. No I have not edited the block except to take out the image and link for the xml temporarily until fixed. I still have original file saved.

From the top of the block php file

Code:

# Support: http://ravenphpscripts.com #
# Hosting: http://ravenwebhosting.com #
# Version: 2.3.1

# Version 2.3.1 #
# 02/13/2006 : Modified default empty $skipTopPostersUserNames="''" #
# : due to certain releases of MySQL behavior. #
# : Added setting ($showTickerMessage) to control ticker

montego · Posted: Tue Jun 27, 2006 8:23 pm

Well, I have downloaded the script and everything there looks fine. So, your site definitely has some form of GoogleTap installed. Had you installed this site yourself or did someone else do this for you?

I went to go check out the site, but I am being blocked here at work... sorry!

pdoobepd · Worker Joined: May 07, 2005 Posts: 129

I installed the site myself but do not "Host" it.

I Never installed any Google Tap what so ever as I have heard nothing but problems relating to it.

The only way I could have any google tap installed is if it came with a module or block I have installed on the site.

How do I check to see if a google tap is installed with another block or module?

I will run a database search later to see if it comes up with anything regarding a Google Tap.

Guardian2003 · Site Admin Joined: Aug 28, 2003 Posts: 4658

I couldnt find anything relating to googletap but the site is so slow I gave up.
What version is your forum? It looks quite old if the footer is correct.

pdoobepd · Worker Joined: May 07, 2005 Posts: 129

Site doesn't load slow for me...Anyway my version is

Powered by phpBB © 2001-2003 phpBB Group
phpBB port v2.0.7 based on Tom Nitzschner's phpbb port 2.0.6 upgraded to phpBB 2.0.7 standalone.
Ported and tested by:
Nuke Cops

BBtoNuke 2.0.7 by Nuke Cops ©

Only registered users can see links on this board!
Get registered or login to the forums!

I am not sure howevery why it states both phpbb stand alone and BBtoNuke...are they the same thing ? Names always bug me LOL

P.S. The Host is working on the server right now...that is why you had a slow site load problem.

Guardian2003 · Site Admin Joined: Aug 28, 2003 Posts: 4658

No offence but you really need to get your forum up to date and patched.
There has been at least one change in the way that sessions are handled since your version came out and updating your forum may actually fix the issue you have without any further problems.

pdoobepd · Worker Joined: May 07, 2005 Posts: 129

According to what I am seeing I am up to date... (?)

Can you give me a link to where to get an Upgrade and patches ?

I will check NukeCops in the mean time.

Thanks!

P.S.
I am considering changing my site over to Raven's Nuke...I currently have my "PHPNuke" installed in a separate folder not in "root" of site...Can I safely install Raven's Nuke into the Root of my site without affecting how my site currently appears until I get all installed and moved over ?

May sound like a dumb Q but need to know. LOL

Guardian2003 · Site Admin Joined: Aug 28, 2003 Posts: 4658

Yes you can safely install Raven Nuke so long as it is an different directory or the site root provided your host will allow you more than one mySQL database.
Depending on which version of nuke you are surrently using, you should be able to move the data without too much hassle.
BBtoNuke is the forums you should looking at NOT the phpBB stand alone forum. For clarification, BBtoNuke is phpBB Forum modified to work with nuke.

If you could clarify the nuke version you have, that might give us some indication of which BBtoNuke forum version may be installed (in case the footer message is inaccurate) - that is of course if you have not done any updates since it was originally installed.

pdoobepd · Worker Joined: May 07, 2005 Posts: 129

PHP Nuke Version 7.6 with Ravens/chatservs PHPNuke7.6 3.1 patch is what I am currently running that is all the clairification I know to give... (?)

Guardian2003 · Site Admin Joined: Aug 28, 2003 Posts: 4658

Well you shouldnt have much problem moving data to Raven Nuke if you wanted to go that route.
I will have to download the block and try it as I'm out of idea's at this stage unless the block is 'tapped'.

montego · Posted: Thu Jun 29, 2006 7:02 am

Guardian2003 wrote:

Well you shouldnt have much problem moving data to Raven Nuke if you wanted to go that route.
I will have to download the block and try it as I'm out of idea's at this stage unless the block is 'tapped'.

I downloaded it yesterday and took a look because I was concerned it was hard-coded on the links... I couldn't see it, but maybe I missed one somewhere when I was looking at it.

Sorry, pdoobepd, I tried to check your site too to see if it was running GT'd, but after several minutes, it still had not come up to the main home page. Maybe it was just at that point in time.