Add to block-user_info

rebelt · Worker Joined: May 07, 2006 Posts: 138

I have 2 blocks which display a total and would like to add them to user_info.

Code:

if (eregi("block-Players_Block.php",$_SERVER['SCRIPT_NAME'])) {
Header("Location: index.php");
die();
}
$result = mysql_query("SELECT * FROM team_players") or die(mysql_error());

$num_rows = mysql_num_rows($result);
$content = "Players: $num_rows";

and

Code:

if( eregi( "block-teams_registered.php",$PHP_SELF ) ) {
Header( "Location: index.php" );
die();
}
$result = mysql_query("SELECT * FROM team_names2") or die(mysql_error());

$num_rows = mysql_num_rows($result);
$content = "Teams: $num_rows";

Tried adding the code between Membership and People online so I had

League:
Players: 999
Teams: 74

But nothing I did seemed to work.

Can anyone help out please?

Palbin · Posted: Sat Dec 13, 2008 5:55 pm

Other than making sure you are not overwriting a previously needed $result all you need to do is make sure your $content variables read like this $content .= "......";

P.S. I should have looked at your code better. You need to be using code as shown below.

Code:

$result = $db->sql_query("SELECT * FROM team_players");
$num_rows = $db->sql_numrows($result);

$content .= "Players: $num_rows";

Code:

$result = $db->sql_query("SELECT * FROM team_names2");
$num_rows = $db->sql_numrows($result);

$content .= "Teams: $num_rows";

rebelt · Worker Joined: May 07, 2006 Posts: 138

Thanks Palbin. That code was years old with the block created using nuke tools.
Trouble with ravennuke is it's so good, you go for months without adding a block or whatever, then forget how you did it last time. Smile

Anyone know how to add it to user_info please?

Palbin · Posted: Sun Dec 14, 2008 10:22 am

You should be able to just drop those lines in where you need them. Even if the queries don't work for some reason you should still see "Players:" and "Teams:"

If it doesn't work post the code you are trying to insert and also some of the surrounding code so I can see exactly where you are trying to insert it.

rebelt · Worker Joined: May 07, 2006 Posts: 138

Starting at line 280, here is where I inserted the code.

Code:

if (is_admin($admin) AND @file_exists('modules/Resend_Email/index.php')) $waitLink = '<a href="modules.php?name=Resend_Email" title="'._TTL_RESENDEMAIL.'">'._WAITLINK.'</a>';
else $waitLink = _WAITLINK;
$content .= '<img src="images/blocks/ur-member.gif" height="14" width="17" alt="" /> '.$waitLink.': <b>'.$waiting.'</b><br />'."\n";
$content .= '<img src="images/blocks/ur-guest.gif" height="14" width="17" alt="" /> '._BOVER.': <b>'.number_format($numrows1,0).'</b><br />'."\n<hr />\n";
$result = $db->sql_query("SELECT * FROM team_players");
$num_rows = $db->sql_numrows($result);

$content .= "Players: $num_rows";
$result = $db->sql_query("SELECT * FROM team_names2");
$num_rows = $db->sql_numrows($result);

$content .= "Teams: $num_rows";

But I get this

I'm trying to get it to look like

Membership:
Latest: RebelT
New Today: 0
New Yesterday: 0
Waiting: 0
Overall: 1
____________
League:
Players: 999
Teams: 74
____________
People Online:
Visitors: 0
Members: 0
Hidden: 0
Total: 1

Palbin · Posted: Sun Dec 14, 2008 7:11 pm

Well you need to add some formatting with html. You need to add a <br />at the end of each line. Add an <hr /> for the horizontal rule at the bottom of the league area. You don't even have anything stating "League:" in the code.

rebelt · Worker Joined: May 07, 2006 Posts: 138

Wasn't sure how to put it in Embarassed

rebelt · Worker Joined: May 07, 2006 Posts: 138

I tried this.

Code:

$content .= "<b>League: '</b><br />'"
$result = $db->sql_query("SELECT * FROM team_players");
$num_rows = $db->sql_numrows($result);

$content .= "Players: $num_rows '<br />'";
$result = $db->sql_query("SELECT * FROM team_names2");
$num_rows = $db->sql_numrows($result);

$content .= "Teams: $num_rows '<br /><hr />'";

but then I can't see the block or anything after it. Sorry if I'm being a bit thick

trunks · Posted: Mon Dec 15, 2008 7:06 pm

You have a mixture of " and ' in that code rebelt try:

Code:

$content .= "<hr/>";
$content .= "<b>League:</b><br />";
$result = $db->sql_query("SELECT * FROM team_players");
$num_rows = $db->sql_numrows($result);
$content .= "Players: $num_rows<br />";
$content .= "<hr/>";

Palbin · Posted: Mon Dec 15, 2008 7:56 pm

rebelt, your code was fine except that you need to replace '</b> with </b> and '<br /> with <br /> (both locations). See corrected code below. Cheers

Code:

$content .= "<b>League: </b><br />'"
$result = $db->sql_query("SELECT * FROM team_players");
$num_rows = $db->sql_numrows($result);

$content .= "Players: $num_rows <br />'";
$result = $db->sql_query("SELECT * FROM team_names2");
$num_rows = $db->sql_numrows($result);

$content .= "Teams: $num_rows <br /><hr />'";

trunks · Posted: Mon Dec 15, 2008 8:00 pm

Thats also what i did :S except added the horizontal line on a different line... i removed the ' also for him O.o

Palbin · Posted: Mon Dec 15, 2008 9:36 pm

trunks wrote:

Thats also what i did :S except added the horizontal line on a different line... i removed the ' also for him O.o

Except you missed a piece of code. THe part about the teams Smile

rebelt · Worker Joined: May 07, 2006 Posts: 138

Sorry guys but I must be missing something Question

I added the code to a block

Code:

<?php

if (eregi("block-Players_Block.php",$_SERVER['SCRIPT_NAME'])) {
Header("Location: index.php");
die();
}

$content .= "<b>League: </b><br />'"
$result = $db->sql_query("SELECT * FROM team_players");
$num_rows = $db->sql_numrows($result);

$content .= "Players: $num_rows <br />'";
$result = $db->sql_query("SELECT * FROM team_names2");
$num_rows = $db->sql_numrows($result);

$content .= "Teams: $num_rows <br /><hr />'";
die();

?>

to see it in action but it kills everything from that block onwards. Sad

From this

to this

I can't provide a link because it's on my computer but here's the view source code.

Code:

<!DOCTYPE html
PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="Content-Type" content="text/html;charset=ISO-8859-1" />
<title>RebelT Play site - Administration Menu</title>

<meta http-equiv="Content-Script-Type" content="text/javascript" />
<meta http-equiv="Content-Style-Type" content="text/css" />
<meta http-equiv="EXPIRES" content="0" />
<meta name="RESOURCE-TYPE" content="DOCUMENT" />
<meta name="DISTRIBUTION" content="GLOBAL" />
<meta name="AUTHOR" content="RebelT Play site" />
<meta name="COPYRIGHT" content="Copyright (c) by RebelT Play site" />
<meta name="KEYWORDS" content="CMS, cms, Best CMS, best cms, Raven, RavenNuke, Raven Nuke, raven, ravennuke, raven nuke, ravenuke, Ravenuke, scripts, PHP, php, MySQL, mysql, SQL, sql, News, news, Technology, technology, Headlines, headlines, Nuke, nuke, PHP-Nuke, phpnuke, php-nuke, Linux, linux, Windows, windows, Software, software, Download, download, Downloads, downloads, Free, FREE, free, Community, community, Forum, forum, Forums, forums, Bulletin, bulletin, Board, board, Boards, boards, Survey, survey, Comment, comment, Comments, comments, Portal, portal, ODP, odp, Open, open, Open Source, OpenSource, Opensource, opensource, open source, Free Software, FreeSoftware, Freesoftware, free software, GNU, gnu, GPL, gpl, License, license, Unix, UNIX, *nix, unix, Database, DataBase, Blogs, blogs, Blog, blog, database, Programming, programming, Web Site, web site, Weblog, WebLog, weblog" />
<meta name="DESCRIPTION" content="Local site" />
<meta name="ROBOTS" content="INDEX, FOLLOW" />
<meta name="REVISIT-AFTER" content="1 DAYS" />
<meta name="RATING" content="GENERAL" />
<meta name="GENERATOR" content="RavenNuke(tm) Copyright (c) 2008 by Gaylen Fraley. This is free software, and you may redistribute it under the GPL (http://www.gnu.org/licenses/gpl-2.0.txt). RavenNuke(tm) is supported by the RavenNuke(tm) Team at http://ravenphpscripts.com." /> <script type="text/javascript">
/*<![CDATA[*/
function hideshow(which) {
if (!document.getElementById) {
return;
}
if (which.style.display=="block") {
which.style.display="none";
}
else {
which.style.display="block";
}
}
/*]]>*/
</script><script type="text/javascript">
function gotoURL(dropDown) {
   URL=dropDown.options[dropDown.selectedIndex].value;
   if(URL.length>0) {
      top.location.href = URL;
   }
}
</script>
<style type="text/css">
.mymodulesselectbox{
width:140px;
background:#f7f8fc;
}
</style><link rel="StyleSheet" href="themes/ravennuke.css" type="text/css" />
<link rel="StyleSheet" href="themes/weston/style/style.css" type="text/css" />
<link rel="StyleSheet" href="includes/nukeSEO/nukePIE.css" type="text/css" />
<script type="text/javascript" language="JavaScript" src="includes/boxover/boxover.js"></script>
<link rel="StyleSheet" href="includes/nukeSEO/seoHelp.css" type="text/css" /><link rel="STYLESHEET" type="text/css" href="includes/nukeSEO/forms/dhtmlxCombo/css/dhtmlXCombo.css" />

</head>
<body bgcolor="#FFFFFF" text="#000000" style="margin: 10px"><br />
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="20%" style="background-image: url(themes/weston/images/cloth.jpg)"><div align="center"><img src="themes/weston/images/rack.jpg"></div></td>
<td width="60%" style="background-image: url(themes/weston/images/cloth.jpg)" height="110"><div align="center"><a href="http://ravenphpscripts.com" title="Weston Pool League"><img src="themes/weston/images/logo.gif" alt="PHP Web Host - Quality Web Hosting For All PHP Applications" border="0" /></a></div></td>
<td width="20%" style="background-image: url(themes/weston/images/cloth.jpg)" height="110">
<div align="center"><img src="themes/weston/images/rack.jpg"></div></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><table width="100%" border="0" cellpadding="4" cellspacing="0" style="background-image: url(themes/weston/images/cellpic1.gif)">
<tr>

<td width="20%" height="30" nowrap="nowrap"><font class="content">  Welcome RebelT!</font></td>

<td width="60%" nowrap="nowrap">
<div align="center"><a href="index.php"><img src="themes/weston/images/navbar_b1.gif" width="100" height="25" border="0"></a><a href="modules.php?name=NukeWrap&page=Hesk"><img src="themes/weston/images/navbar_b2.gif" width="79" height="22" border="0"></a><a href="faq.html"><img src="themes/weston/images/navbar_b4.gif" width="79" height="22" border="0"></a><a href="http://forum.westonpoolleague.org.uk" target="_blank"><img src="themes/weston/images/navbar_b3.gif" width="79" height="22" border="0"></a><a href="modules.php?name=Downloads"><img src="themes/weston/images/navbar_b6.gif" width="79" height="22" border="0"></a><a href="links.html"><img src="themes/weston/images/navbar_b5.gif" width="79" height="22" border="0"></a></div></td>

<td width="20%" nowrap="nowrap">
<div align="right"><font class="content"> <script type="text/javascript">



</script> </font></div></td>
</tr>
</table></td>
</tr>
</table>
<table width="100%" cellpadding="0" cellspacing="0" border="0" align="center">
<tr valign="top">
<td align="center"></td>
</tr></table>
<table width="100%" cellpadding="0" cellspacing="0" border="0" align="center">
<tr valign="top">
<td valign="top" width="1" style="background-image: url(themes/weston/images/7px.gif)">
<script type="text/javascript" language="JavaScript">
function sommaire_envoielistbox(page) {
var reg= new RegExp('(_sommaire_targetblank)$','g');
if (reg.test(page)) {
   page=page.replace(reg,"");
   window.open(page,'','menubar=yes,status=yes, location=yes, scrollbars=yes, resizable=yes');
}else if (page!="select") {
      top.location.href=page;
}
}
function sommaire_ouvre_popup(page,nom,option) {
window.open(page,nom,option);
}
</script>
<table width="170" border="0" cellspacing="0" cellpadding="7">
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="1">
<tr>
<td bgcolor="#486386"><table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#FFFFFF">
<tr>
<td height="27" style="background-image: url(themes/weston/images/cellpic3.gif)"><table width="100%" border="0" cellspacing="0" cellpadding="4">
<tr>
<td><font class="block-title"><strong>Navigation</strong></font></td>
</tr>
</table></td>
</tr>
<tr>
<td style="background-image: url(themes/weston/images/cloth.jpg)"><table width="100%" border="0" cellspacing="0" cellpadding="4">
<tr>
<td>

<table width="100%" border="0" cellspacing="0" cellpadding="0">
               <tr height="4" bgcolor=""><td></td></tr>
               <tr ><td bgcolor="" ><font class="storytitle"><strong>Rules</strong></font></td></tr>
<tr name="sommaire-1" id="sommaire-1"><td bgcolor=""><table width="100%" border="0" cellspacing="0" cellpadding="0"><tr><td width="0" align="right"><img src="images/sommaire/categories/petitrond.gif" border="0"></td><td> <a href="contentid-94.html"><font class="boxcontent"><strong>League</strong></font></a></td></tr>
<tr><td width="0" align="right"><img src="images/sommaire/categories/petitrond.gif" border="0"></td><td> <a href="content-cat-2.html"><font class="boxcontent"><strong>World</strong></font></a></td></tr>
<tr><td width="0" align="right"><img src="images/sommaire/categories/petitrond.gif" border="0"></td><td> <a href="modules.php?name=Referee"><font class="boxcontent"><strong>Referee</strong></font></a></td></tr>
</table></td></tr><tr height="4" bgcolor=""><td></td></tr>
               <tr height="4" bgcolor=""><td></td></tr>
               <tr ><td bgcolor="" ><font class="storytitle"><strong>Cup Games</strong></font></td></tr>
<tr name="sommaire-3" id="sommaire-3"><td bgcolor=""><table width="100%" border="0" cellspacing="0" cellpadding="0"><tr><td width="0" align="right"><strong><big>·</big></strong></td><td> <a href="contentid-80.html"><font class="boxcontent"><strong>Baxter (wint)</strong></font></a></td></tr>
<tr><td width="0" align="right"><strong><big>·</big></strong></td><td> <a href="contentid-82.html"><font class="boxcontent"><strong>Workingmens (wint)</strong></font></a></td></tr>
<tr><td width="0" align="right"><strong><big>·</big></strong></td><td> <a href="contentid-81.html"><font class="boxcontent"><strong>MacAverne (wint)</strong></font></a></td></tr>
<tr><td width="0" align="right"><strong><big>·</big></strong></td><td> <a href="contentid-89.html"><font class="boxcontent">Gifford (summ)</font></a></td></tr>
<tr><td width="0" align="right"><strong><big>·</big></strong></td><td> <a href="contentid-88.html"><font class="boxcontent">Forresters (summ)</font></a></td></tr>
<tr><td width="0" align="right"><strong><big>·</big></strong></td><td> <a href=""><font class="boxcontent">View Cup Results</font></a></td></tr>
</table></td></tr><tr height="4" bgcolor=""><td></td></tr>
               <tr height="4" bgcolor=""><td></td></tr>
               <tr ><td bgcolor="" ><font class="storytitle"><strong>League Games</strong></font></td></tr>
<tr name="sommaire-4" id="sommaire-4"><td bgcolor=""><table width="100%" border="0" cellspacing="0" cellpadding="0"><tr><td width="0" align="right"><img src="images/sommaire/categories/yellow.gif" border="0"></td><td> <a href="modules.php?name=NukeWrap&page=Current_Table"><font class="boxcontent"><strong>Tables</strong></font></a></td></tr>
<tr><td width="0" align="right"><img src="images/sommaire/categories/red.gif" border="0"></td><td> <a href="contentid-83.html"><font class="boxcontent"><strong>Doubles Cat 1</strong></font></a></td></tr>
<tr><td width="0" align="right"><img src="images/sommaire/categories/yellow.gif" border="0"></td><td> <a href="contentid-84.html"><font class="boxcontent"><strong>Doubles Cat 2</strong></font></a></td></tr>
<tr><td width="0" align="right"><img src="images/sommaire/categories/red.gif" border="0"></td><td> <a href="contentid-85.html"><font class="boxcontent"><strong>Singles Cat 1</strong></font></a></td></tr>
<tr><td width="0" align="right"><img src="images/sommaire/categories/yellow.gif" border="0"></td><td> <a href="contentid-86.html"><font class="boxcontent"><strong>Singles Cat 2</strong></font></a></td></tr>
<tr><td width="0" align="right"><img src="images/sommaire/categories/red.gif" border=0></td><td> <a href="leagueresult.php"><strong><font class="boxcontent">Live Results</font></strong></a></td></tr>
<tr><td width="0" align="right"><img src="images/sommaire/categories/yellow.gif" border=0></td><td> <a href="maintenance.php?op=ListTeams"><strong><font class="boxcontent">Team Details</font></strong></a></td></tr>
<tr><td width="0" align="right"><img src="images/sommaire/categories/red.gif" border=0></td><td> <a href="http://westonpoolleague.org.uk/8balls2/main.php?table_id=0&Action=Go" target="_blank"><strong><font class="boxcontent">8 Ball List</font></strong></a></td></tr>
<tr><td width="0" align="right"><img src="images/sommaire/categories/yellow.gif" border="0"></td><td> <a href="modules.php?name=NukeWrap&page=fixtures"><font class="boxcontent"><strong>Fixtures</strong></font></a></td></tr>
</table></td></tr><tr height="4" bgcolor=""><td></td></tr>
               <tr height="4" bgcolor=""><td></td></tr>
               <tr ><td bgcolor="" ><font class="storytitle">Forms</font></td></tr>
<tr name="sommaire-5" id="sommaire-5"><td bgcolor=""><table width="100%" border="0" cellspacing="0" cellpadding="0"><tr><td width="0" align="right"><img src="images/sommaire/categories/red.gif" border=0></td><td> <a href="leagueresult.php?op=resultform"><strong><font class="boxcontent">League Result</font></strong></a></td></tr>
<tr><td width="0" align="right"><img src="images/sommaire/categories/yellow.gif" border=0></td><td> <a href="league_cupres.php"><strong><font class="boxcontent">Cup Result</font></strong></a></td></tr>
<tr><td width="0" align="right"><img src="images/sommaire/categories/red.gif" border=0></td><td> <a href=""><font class="boxcontent">Doubles Result</font></a></td></tr>
<tr><td width="0" align="right"><img src="images/sommaire/categories/yellow.gif" border="0"></td><td> <a href="modules.php?name=NukeWrap&page=singles_results"><font class="boxcontent"><strong>Singles Result</strong></font></a></td></tr>
<tr><td width="0" align="right"><img src="images/sommaire/categories/red.gif" border=0></td><td> <a href=""><font class="boxcontent">Remove Player</font></a></td></tr>
<tr><td width="0" align="right"><img src="images/sommaire/categories/yellow.gif" border=0></td><td> <a href=""><font class="boxcontent">Postpone Request</font></a></td></tr>
<tr><td width="0" align="right"><img src="images/sommaire/categories/red.gif" border=0></td><td> <a href=""><font class="boxcontent">Postponed Result</font></a></td></tr>
<tr><td width="0" align="right"><img src="images/sommaire/categories/yellow.gif" border=0></td><td> <a href="maintenance.php"><strong><font class="boxcontent">Team Registration</font></strong></a></td></tr>
<tr><td width="0" align="right"><img src="images/sommaire/categories/red.gif" border=0></td><td> <a href="http://westonpoolleague.org.uk/singles_doubles" target="_blank"><strong><font class="boxcontent">Singles/Doubles Entry</font></strong></a></td></tr>
</table></td></tr><tr height="4" bgcolor=""><td></td></tr>
               <tr height="4" bgcolor=""><td></td></tr>
               <tr ><td bgcolor="" ><a href="contentid-87.html"><a href="contentid-87.html"><font class="storytitle">Committee</font></a></td></tr>

               <tr height="4" bgcolor=""><td></td></tr>
               <tr ><td bgcolor="" ><font class="storytitle">Miscellaneous</font></td></tr>
<tr name="sommaire-11" id="sommaire-11"><td bgcolor=""><table width="100%" border="0" cellspacing="0" cellpadding="0"><tr><td width="0" align="right"><img src="images/sommaire/categories/yellow.gif" border="0"></td><td> <a href="journal.html"><font class="boxcontent">Journal</font></a></td></tr>
<tr><td width="0" align="right"><img src="images/sommaire/categories/red.gif" border="0"></td><td> <a href="modules.php?name=Members_List"><font class="boxcontent">Members List</font></a></td></tr>
<tr><td width="0" align="right"><img src="images/sommaire/categories/yellow.gif" border="0"></td><td> <a href="recommend.html"><font class="boxcontent">Recommend Us</font></a></td></tr>
<tr><td width="0" align="right"><img src="images/sommaire/categories/red.gif" border="0"></td><td> <a href="reviews.html"><font class="boxcontent">Reviews</font></a></td></tr>
<tr><td width="0" align="right"><img src="images/sommaire/categories/yellow.gif" border="0"></td><td> <a href="stats.html"><font class="boxcontent">Statistics</font></a></td></tr>
<tr><td width="0" align="right"><img src="images/sommaire/categories/red.gif" border="0"></td><td> <a href="archive.html"><font class="boxcontent">Stories Archive</font></a></td></tr>
<tr><td width="0" align="right"><img src="images/sommaire/categories/yellow.gif" border="0"></td><td> <a href="submit.html"><font class="boxcontent">Submit News</font></a></td></tr>
<tr><td width="0" align="right"><img src="images/sommaire/categories/red.gif" border="0"></td><td> <a href="content-cat-6.html"><font class="boxcontent">Table Archive</font></a></td></tr>
<tr><td width="0" align="right"><img src="images/sommaire/categories/yellow.gif" border="0"></td><td> <a href="modules.php?name=Your_Account"><font class="boxcontent">Your Account</font></a></td></tr>
</table></td></tr><tr height="4" bgcolor=""><td></td></tr><tr><td><hr><div align="center"><strong>Modules visible</strong><br>but unselected (in <a href="admin.php?op=sommaire">SP admin panel</a>)</div><br><strong><big>·</big></strong> <a href="modules.php?name=Content">Content</a><br>
<strong><big>·</big></strong> <a href="modules.php?name=Doubles_view">Doubles_view</a><br>
<strong><big>·</big></strong> <a href="modules.php?name=Downloads">Downloads</a><br>
<strong><big>·</big></strong> <a href="faq.html">FAQ</a><br>
<strong><big>·</big></strong> <a href="contact.html">Feedback</a><br>
<strong><big>·</big></strong> <a href="forums.html">Forums</a><br>
<strong><big>·</big></strong> <a href="modules.php?name=Groups">Groups</a><br>
<strong><big>·</big></strong> <a href="modules.php?name=Hesk">Hesk</a><br>
<strong><big>·</big></strong> <a href="modules.php?name=NukeSentinel">NukeSentinel</a><br>
<strong><big>·</big></strong> <a href="modules.php?name=NukeWrap">NukeWrap</a><br>
<strong><big>·</big></strong> <a href="modules.php?name=Referee">Referee</a><br>
<strong><big>·</big></strong> <a href="modules.php?name=Single_submit">Single_submit</a><br>
<strong><big>·</big></strong> <a href="modules.php?name=Single_View">Single_View</a><br>
<strong><big>·</big></strong> <a href="links.html">Web Links</a><br>
</td></tr></table><br><center><b>Invisible Modules</b><br><font class="tiny">(Active but invisible link)</font></center><form action="modules.php" method="get" name="sommaireformlistboxinvisibles"><select name="somlistboxinvisibles" onchange="sommaire_envoielistbox(this.options[this.selectedIndex].value)"><option value="select">Select...<option value="modules.php?name=Advertising">Advertising<option value="modules.php?name=Feeds">Feeds<option value="modules.php?name=GCalendar">GCalendar<option value="modules.php?name=HTML_Newsletter">HTML Newsletter<option value="modules.php?name=Legal">Legal<option value="modules.php?name=Resend_Email">Resend Email</select></form>
<br><center><b>Inactive Modules</b><br><font class="tiny">(for Admin tests)</font></center><form action="modules.php" method="get" name="sommaireformlistboxinactifs"><select name="somlistboxinactifs" onchange="sommaire_envoielistbox(this.options[this.selectedIndex].value)"><option value="select">Select...<option value="modules.php?name=AvantGo">AvantGo<option value="modules.php?name=Comments">Comments<option value="modules.php?name=Encyclopedia">Encyclopedia<option value="modules.php?name=ErrorDocuments">ErrorDocuments<option value="modules.php?name=How_To_Install">How To Install<option value="modules.php?name=Private_Messages">Private Messages<option value="modules.php?name=rwsMetAuthors">Authors and Articles<option value="modules.php?name=RWS_WhoIsWhere">RWS WhoIsWhere<option value="modules.php?name=Search">Search<option value="modules.php?name=Surveys">Surveys<option value="top.html">Top 10<option value="topics.html">Topics<option value="modules.php?name=UserInfoAddons">UserInfoAddons</select></form>
</td>
</tr>
</table></td>
</tr>
<tr>
<td height="27" style="background-image: url(themes/weston/images/cellpic1.gif)"> </td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
<table width="170" border="0" cellspacing="0" cellpadding="7">
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="1">
<tr>
<td bgcolor="#486386"><table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#FFFFFF">
<tr>
<td height="27" style="background-image: url(themes/weston/images/cellpic3.gif)"><table width="100%" border="0" cellspacing="0" cellpadding="4">
<tr>
<td><font class="block-title"><strong>User Info</strong></font></td>
</tr>
</table></td>
</tr>
<tr>
<td style="background-image: url(themes/weston/images/cloth.jpg)"><table width="100%" border="0" cellspacing="0" cellpadding="4">
<tr>
<td><form action="modules.php?name=Your_Account" method="post"><center><b>Your IP: 127.0.0.1</b></center><center><img alt="" src="modules/Forums/images/avatars/blank.gif" /></center><br /><center>125 post(s)</center>
<br /><img src="images/blocks/group-4.gif" height="14" width="17" alt="" /> Welcome, <b>RebelT</b><br />

<a href="modules.php?name=Your_Account&op=logout"><img src="images/blocks/arrow-blk.gif" width="17" border="0" alt="" /> Logout</a>
<hr />
<img src="images/blocks/group-2.gif" height="14" width="17" alt="" /> <b><u>Membership:</u></b><br />
<img src="images/blocks/ur-moderator.gif" height="14" width="17" alt="" /> Latest: <a href="modules.php?name=Your_Account&op=userinfo&username=daddy"><img src="images/blocks/icon_mini_profile.gif" border="0" title="Check the profile of daddy" alt="Check the profile of daddy" /></a> <a href="forums.html&file=profile&mode=viewprofile&u=746"><b>daddy</b></a><br />
<img src="images/blocks/ur-author.gif" height="14" width="17" alt="" /> New Today: <b>0</b><br />
<img src="images/blocks/ur-admin.gif" height="14" width="17" alt="" /> New Yesterday: <b>0</b><br />
<img src="images/blocks/ur-member.gif" height="14" width="17" alt="" /> <a href="modules.php?name=Resend_Email" title="Resend Email phpNuke Module at RavenPHPScripts">Waiting</a>: <b>0</b><br />
<img src="images/blocks/ur-guest.gif" height="14" width="17" alt="" /> Overall: <b>525</b><br />
<hr />
<img src="images/blocks/group-3.gif" height="14" width="17" alt="" /> <b><u>People Online:</u></b>
<br />
<img src="images/blocks/ur-anony.gif" height="14" width="17" alt="" /> Visitors: <b>0</b><br />
<img src="images/blocks/ur-member.gif" height="14" width="17" alt="" /> Members: <b>0</b><br />
<img src="images/blocks/ur-hiddenmember.gif" height="14" width="17" alt="" /> Hidden: <b>1</b><br />
<img src="images/blocks/ur-registered.gif" height="14" width="17" alt="" /> Total: <b>1</b><br />
<hr noshade="noshade" />
<img src="images/blocks/group-1.gif" height="14" width="17" align="middle" alt="" /> <b><u>Online Now:</u></b><br /><a href="http://www.dnsstuff.com/tools/whois.ch?ip=127.0.0.1" title="127.0.0.1" target="_blank">01</a>: <a href="modules.php?name=Your_Account&op=userinfo&username=RebelT"><img src="images/blocks/icon_mini_profile.gif" border="0" alt="Check the profile of RebelT" title="Check the profile of RebelT" /></a> <a href="modules.php?name=Private_Messages&mode=post&u=2"><img src="images/blocks/nopm.gif" border="0" alt="Send a quick private message to RebelT" title="Send a quick private message to RebelT" /></a> <a title="Check the profile of RebelT" href="forums.html&file=profile&mode=viewprofile&u=2">RebelT</a>(H)<br />
<hr /><center><small>We have received</small><br />
<b>682,875</b><br />
<small>page views since<br />2005</small></center><hr noshade="noshade" /><center>Hits New Today: <b>0</b><br />Hits New Yesterday: <b>0</b><br /></center><hr noshade="noshade" /><center>Server Date/Time<br />16 December 2008
14:58:56 GMT (GMT +0)</center></form></td>
</tr>
</table></td>
</tr>
<tr>
<td height="27" style="background-image: url(themes/weston/images/cellpic1.gif)"> </td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>

Just in case there's something else. Very Happy

Guardian2003 · Posted: Tue Dec 16, 2008 9:17 am

Try removing the die() from the second to last line.

Palbin · Posted: Tue Dec 16, 2008 9:22 am

Remove die(); at the end that is killing everything. I also changed the security check at the top to bring it up to date.

Code:

<?php

if ( !defined('BLOCK_FILE') ) {
Header("Location: ../index.php");
}

$content .= "<b>League: </b><br />'"
$result = $db->sql_query("SELECT * FROM team_players");
$num_rows = $db->sql_numrows($result);

$content .= "Players: $num_rows <br />'";
$result = $db->sql_query("SELECT * FROM team_names2");
$num_rows = $db->sql_numrows($result);

$content .= "Teams: $num_rows <br /><hr />'";

?>

Palbin · Posted: Tue Dec 16, 2008 9:22 am

Guardian2003, got me while I was typing Smile

Guardian2003 · Posted: Tue Dec 16, 2008 9:23 am

rebelt · Worker Joined: May 07, 2006 Posts: 138

No change.

Just added a phpinfo. would the following make a difference?

PHP Version 5.2.6
Mysql 5.0.51b

rebelt · Worker Joined: May 07, 2006 Posts: 138

Palbin wrote:

Code:

<?php

if ( !defined('BLOCK_FILE') ) {
Header("Location: ../index.php");
}

$content .= "<b>League: </b><br />'"
$result = $db->sql_query("SELECT * FROM team_players");
$num_rows = $db->sql_numrows($result);

$content .= "Players: $num_rows <br />'";
$result = $db->sql_query("SELECT * FROM team_names2");
$num_rows = $db->sql_numrows($result);

$content .= "Teams: $num_rows <br /><hr />'";

?>

Created a new block pasted the above code in it. Killed everything afterwards.
Crying or Very sad

Guardian2003 · Posted: Sun Dec 21, 2008 10:49 am

Try this;

Code:

if ( !defined('BLOCK_FILE') ) {
Header("Location: ../index.php");
}
global $db;
$content = '';
$content .= "<b>League: </b><br />";
$result = $db->sql_query("SELECT * FROM team_players");
$num_rows = $db->sql_numrows($result);

$content .= "Players: $num_rows <br />";
$result = $db->sql_query("SELECT * FROM team_names2");
$num_rows = $db->sql_numrows($result);

$content .= "Teams: $num_rows <br /><hr />";

rebelt · Worker Joined: May 07, 2006 Posts: 138

Worked a treat. Thank you.