Codezwiz >> Forums >> Codezwiz PHP Nuke Help >> Modules Menu

I ran int some problems with your modules menu due to a clash with another block.. anyway got that fixed but have made some mods to the block which can be seen here at
[ Register or login to view links on this board. ]

I'm using sql generated custom links for my RG_Sports module. They add a league automatically into the menu as soon as it's created. I've also done the same for individual coppermine galleries.

The code below is what makes the football site work and thought it might be of use to someone else. It is entered prior to the last } in the mcid loop. If anyone needs a hand or help i can send a copy of the complete modded block. The first section (mcid=1) is particular to the RG_Sports block but shows principle to anyone wishing to change this to another custom module.

Sorry about the copyright at the bottom but will be adding your site banner on to the right hand panel. Gorgeous site you've got here guys :-)

******************** Code ****************

/* Include external link if mcid matches */
if ($mcid == 1){
$content .= "   <img src=\"images/CZModules/arrow.gif\" align=\"middle\"> <a href=\"leagues.html\" title=\"Leagues\" onmouseover=\"self.status=' Leagues ';return true\" onmouseout=\"self.status='';return true\">Leagues</a> ";

$sql = "SELECT * FROM ".$prefix."_rgdivisions WHERE season_id='$season_id' AND div_id < 50 ORDER BY div_id";
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result)) {
$div_id = $row[div_id];
$div_name = $row[description];

$content .= "      <img src=\"images/CZModules/ball.gif\" align=\"middle\" alt=\"Information on Scotland $div_name\"> <a href=\"league-$div_id.html\" title=\"$div_name\" onmouseover=\"self.status=' $div_name ';return true\" onmouseout=\"self.status='';return true\">$div_name</a> ";
}

$content .= "   <img src=\"images/CZModules/arrow.gif\" align=\"middle\"> <a href=\"results.html\" title=\"Results\" onmouseover=\"self.status=' Results of games played ';return true\" onmouseout=\"self.status='';return true\">Results</a> ";
$content .= "   <img src=\"images/CZModules/arrow.gif\" align=\"middle\"> <a href=\"fixtures.html\" title=\"Fixtures\" onmouseover=\"self.status=' Fixtures to be played ';return true\" onmouseout=\"self.status='';return true\">Fixtures</a> ";
$content .= "   <img src=\"images/CZModules/arrow.gif\" align=\"middle\"> <a href=\"alphaplayers.html\" title=\"Players\" onmouseover=\"self.status=' Registered players ';return true\" onmouseout=\"self.status='';return true\">Players</a> ";
$content .= "   <img src=\"images/CZModules/arrow.gif\" align=\"middle\"> <a href=\"fixtures.html\" title=\"Teams\" onmouseover=\"self.status=' Registered Teams ';return true\" onmouseout=\"self.status='';return true\">Teams</a> ";
$content .= "   <img src=\"images/CZModules/arrow.gif\" align=\"middle\"> <a href=\"teamadmins.html\" title=\"Team Admins\" onmouseover=\"self.status=' Team Admin Information ';return true\" onmouseout=\"self.status='';return true\">Team Admins</a> ";
$content .= "      <img src=\"images/CZModules/ball.gif\" align=\"middle\"> <a href=\"modules.php?name=RG_Sports&do=enterteam\" title=\"Register Team\" onmouseover=\"self.status=' If your division is listed you can register your team now ';return true\" onmouseout=\"self.status='';return true\">Register Team</a> ";
$content .= "      <img src=\"images/CZModules/ball.gif\" align=\"middle\"> <a href=\"modules.php?name=RG_Sports&do=enterteam\" title=\"Register Player\" onmouseover=\"self.status=' If your team is listed you can open your player record now ';return true\" onmouseout=\"self.status='';return true\">Register Player</a> ";

$content .= "      <img src=\"images/CZModules/ball.gif\" align=\"middle\"> <a href=\"modules.php?name=RG_Sports&do=enterfixture1\" title=\"Enter Fixture\" onmouseover=\"self.status=' Team Admins can enter fixtures involving their team ';return true\" onmouseout=\"self.status='';return true\">Enter Fixture</a> ";

$content .= "      <img src=\"images/CZModules/ball.gif\" align=\"middle\"> <a href=\"modules.php?name=RG_Sports&do=enterresult\" title=\"Enter Result\" onmouseover=\"self.status=' Results can be entered for fixtures already on the system ';return true\" onmouseout=\"self.status='';return true\">Enter Result</a> ";
}

if ($mcid == 4){
$content .= "   <img src=\"images/CZModules/arrow.gif\" align=\"middle\"> <a href=\"links.html\" title=\"Web Links\" onmouseover=\"self.status=' Web Links ';return true\" onmouseout=\"self.status='';return true\">Web Links</a> ";

$sql = "SELECT * FROM ".$prefix."_links_categories ORDER BY cid";
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result)) {
$cid = $row[cid];
$title = $row[title];
$cdescription = $row[cdescription];

$content .= "      <img src=\"images/CZModules/ball.gif\" align=\"middle\"> <a href=\"link-$cid.html\" title=\"$title\" onmouseover=\"self.status=' Link Categories ';return true\" onmouseout=\"self.status='';return true\">$title</a> ";
}

$content .= "      <img src=\"images/CZModules/ball.gif\" align=\"middle\"> <a href=\"linkop-AddLink.html\" title=\"Add Link\" onmouseover=\"self.status=' Add a Link ';return true\" onmouseout=\"self.status='';return true\">Add Link</a> ";

}

if ($mcid == 5){
$content .= "   <img src=\"images/CZModules/arrow.gif\" align=\"middle\"> <a href=\"modules.php?name=coppermine\" title=\"Galleries\" onmouseover=\"self.status=' Galleries ';return true\" onmouseout=\"self.status='';return true\">All Galleries</a> ";

$content .= "   <img src=\"images/CZModules/ball.gif\" align=\"middle\"> <a href=\"modules.php?name=coppermine&file=upload\" title=\"Upload Picture\" onmouseover=\"self.status=' Add a picture to the gallery ';return true\" onmouseout=\"self.status='';return true\">Upload Picture</a> ";

$sql = "SELECT * FROM ".$prefix."_cpg_categories ORDER BY cid";
$result = $db->sql_query($sql);
while ($row = $db->sql_fetchrow($result)) {
$cid = $row[cid];
$catname = $row[catname];
$description = $row[description];

$content .= "      <img src=\"images/CZModules/ball.gif\" align=\"middle\"> <a href=\"modules.php?name=coppermine&cat=$cid\" title=\"$catname\" onmouseover=\"self.status=' Gallery ';return true\" onmouseout=\"self.status='';return true\">$catname</a> ";

}

Hey thanks alot. And if anyone uses it the ;; ;; ;; ;; ;; ;; are actually & n b s p ; Thats something im still working on the GT seems to parse them too