☆ A M B ☆
<?php
require_once('Connections/****.php');
require_once('Connections/****.php');
if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
{
$theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
$theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
switch ($theType) {
case "text":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "long":
case "int":
$theValue = ($theValue != "") ? intval($theValue) : "NULL";
break;
case "double":
$theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
break;
case "date":
$theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
break;
case "defined":
$theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
break;
}
return $theValue;
}
}
mysql_select_db($database_wxyz, $wxyz);
$query_Recordset1 = "SELECT pageurl, COUNT(pageurl) as numvotes FROM hitus GROUP BY pageurl ORDER BY numvotes DESC LIMIT 10";
$Recordset1 = mysql_query($query_Recordset1, $wxyz) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
mysql_select_db($database_wxyz, $wxyz);
$query_Recordset3 = "SELECT * FROM hitus ORDER BY hitus.ts DESC LIMIT 10";
$Recordset3 = mysql_query($query_Recordset3, $wxyz) or die(mysql_error());
$row_Recordset3 = mysql_fetch_assoc($Recordset3);
$totalRows_Recordset3 = mysql_num_rows($Recordset3);
echo "<div align='center'><br>";
echo " <span style='font-weight: bold'><a href='[~965~]' title='Top Flixx'>Top Flixx</a> </span></div>";
do {
echo " <table width='100%' border='0'>";
echo " <tr>";
echo " <td>";
$o = $row_Recordset1['pageurl'] ;
mysql_select_db($database_abcd, $abcd);
$query_Recordset2 = "SELECT * FROM modx_site_content WHERE modx_site_content.id = '$o'";
$Recordset2 = mysql_query($query_Recordset2, $abcd) or die(mysql_error());
$row_Recordset2 = mysql_fetch_assoc($Recordset2);
$totalRows_Recordset2 = mysql_num_rows($Recordset2);
$first = $row_Recordset2['id'];
$first2 = $row_Recordset2['pagetitle'];
echo" <a href=\"index.php?id=$first\"> $first2 </a></td>";
echo"
</tr>
</table>";
<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1));
echo" <br>
<div align='center'><br>
<span style='font-weight: bold'>Recently Viewed </span></div>";
do {
echo " <table width='100%' border='0'>";
echo " <tr>";
echo " <td>";
$o = $row_Recordset3['pageurl'] ;
mysql_select_db($database_abcd, $abcd);
$query_Recordset4 = "SELECT * FROM modx_site_content WHERE modx_site_content.id = '$o'";
$Recordset4 = mysql_query($query_Recordset4, $abcd) or die(mysql_error());
$row_Recordset4 = mysql_fetch_assoc($Recordset4);
$totalRows_Recordset24 = mysql_num_rows($Recordset4);
$sec = $row_Recordset4['id'];
$sec2 = $row_Recordset4['pagetitle'];
echo" <a href=\"index.php?id=$sec\"> $sec2 </a></td>";
echo"
</tr>
</table>";
} while ($row_Recordset3 = mysql_fetch_assoc($Recordset3));
mysql_select_db($database_wxyz, $wxyz);
$query_Recordset5 = "SELECT * FROM favorites ORDER BY favorites.idx DESC LIMIT 5";
$Recordset5 = mysql_query($query_Recordset5, $wxyz) or die(mysql_error());
$row_Recordset5 = mysql_fetch_assoc($Recordset5);
$totalRows_Recordset5 = mysql_num_rows($Recordset5);
//////////////////
echo" <br>
<div align='center'><br>
<span style='font-weight: bold'>ModelFlixx Favorites </span></div>";
do {
echo " <table width='100%' border='0'>";
echo " <tr>";
echo " <td>";
$x = $row_Recordset5['id'] ;
mysql_select_db($database_wxyz, $wxyz);
$query_Recordset6 = "SELECT * FROM modx_site_content WHERE modx_site_content.id = '$x'";
$Recordset6 = mysql_query($query_Recordset6, $wxyz) or die(mysql_error());
$row_Recordset6 = mysql_fetch_assoc($Recordset6);
$totalRows_Recordset24 = mysql_num_rows($Recordset6);
$secc = $row_Recordset6['id'];
$secc2 = $row_Recordset6['pagetitle'];
echo" <a href=\"index.php?id=$secc\"> $secc2 </a></td>";
echo"
</tr>
</table>";
} while ($row_Recordset5 = mysql_fetch_assoc($Recordset5));
?>
?>
<?php
require_once('Connections/****.php'); ?>
<?php
$ips = $_GET["id"];
mysql_select_db($database_abcd, $abcd);
$query_Recordset1 = "SELECT * FROM hitus WHERE hitus.pageurl = '$ips'";
$Recordset1 = mysql_query($query_Recordset1, $abcd) or die(mysql_error());
$row_Recordset1 = mysql_fetch_assoc($Recordset1);
$totalRows_Recordset1 = mysql_num_rows($Recordset1);
echo $totalRows_Recordset1;
echo ' Views';
?>
?>
« MODx Parse Error » MODx encountered the following error while attempting to parse the requested resource: « PHP Parse Error » PHP error debug Error: mysql_select_db(): supplied argument is not a valid MySQL-Link resource Error type/ Nr.: Warning - 2 File: /home/content/j/a/z/jazzmatazz2005/html/manager/includes/document.parser.class.inc.php(770) : eval()'d code Line: 4 Parser timing MySQL: 0.0483 s (118 Requests) PHP: 0.6698 s Total: 0.7181 s
MODX Staff
This discussion is closed to further replies. Keep calm and carry on.