name;
mysql_free_result($result);
$meta_title = $artName;
$meta_description = "What you think of ".$artName." music - without even hearing it!";
$meta_keywords = $artName.", Music, CDs, prediction, filtering, community, social, network";
} else {
$meta_title = "Home";
$meta_description = "Your reviews, opinions and information on all music";
$meta_keywords = "Review, Pop, Rock, Indie, Metal, Nu-Metal, Dance, Vote, Song, Album, Live, Festival, Single";
}
// if ($meta_title!="Home") {
// if (mysql_num_rows(mysql_query("SELECT id FROM pages WHERE name = '".addslashes($meta_title)."' LIMIT 1"))==0) {
// $matches = 1;
// while ($matches!=0) {
// $pickId = substr(md5(round(rand(1000000, 9999999))),0,10);
// $sql = "SELECT * FROM pages WHERE id = '".$pickId."' LIMIT 1";
// $matches = mysql_num_rows(mysql_query($sql));
// }
// mysql_query("INSERT INTO pages (id, name, page_type, page_id) VALUES ('".$pickId."', '".addslashes($meta_title)."', 'a', '".$artID."')");
// }
// }
echo "\n";
echo "\n";
echo "\n";
echo "\n";
echo "$meta_title - Noisehub.com\n";
echo "\n";
echo "\n";
}
function page_contents($logged_in, $user_name, $user_id)
{
$var_array = explode("/",$_SERVER['PHP_SELF']);
$artID = $var_array[3];
$myPage = $var_array[4];
if ($artID!="") {
include 'azDiscs.php'; // RUN IN HEADER, ADD 1 WEEK GIVEN 1 WEEK IN DB FILTER
$sql = "SELECT * FROM records WHERE artID = '".$artID."' AND status <> '0' AND imageLarge != '' ORDER BY members DESC LIMIT 1";
$result = mysql_query($sql);
echo "";
While ($i = mysql_fetch_object($result)) {
if ($i->imageLarge!="")
echo "![](\"http://ec1.images-amazon.com/images/I/{$i-) imageLarge}.jpg\" alt=\"{$i->name}\" style=\"width:200px;\"/>\n";
}
mysql_free_result($result);
$sql = "SELECT * FROM artists WHERE id = '".$artID."' LIMIT 1";
$result = mysql_query($sql);
While ($i = mysql_fetch_object($result))
$artName = $i->name;
echo " | {$artName} | \n";
mysql_free_result($result);
echo "
| [Help] | \n";
if ($logged_in=="true") {
echo "
| |
\n";
} else {
echo "\n";
echo "| The innovative Noisehub project determines a unique profile of your music preferences. It can then tell you how much you will like any music; even music that you have never heard of. | \n";
echo " | To get started, signup for free. (existing members login)\n";
echo " | |
\n";
}
echo "\n";
echo "\n";
// echo " [Help]
\n";
echo "\n";
echo " All music \n";
echo " Music I have \n";
echo " Music I will like \n";
echo " | \n";
} else {
echo " |
\n";
echo "
| |
\n";
echo "| Browse by letter: | \n";
echo "";
$myLetters=array("A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z");
for ($i=0;$i<26;$i++)
echo "[{$myLetters[$i]}] \n";
echo "[#] \n";
echo " |
| |
\n";
if (strlen($_GET['get'])==1) {
// ADD MODERATION CHECK FOR LISTING ARTISTS
if ($_GET['get']=="1") {
$sql = "SELECT * FROM artists WHERE sortName NOT LIKE 'A%' ";
for ($i=0;$i<26;$i++)
$sql .= "AND sortName NOT LIKE '".$myLetters[$i]."%' ";
$sql .= "AND status <> '0' ORDER BY sortName";
} else {
$sql = "SELECT * FROM artists WHERE sortName LIKE '".$_GET['get']."%' AND status <> '0' ORDER BY sortName";
}
$myLimit = 0;
echo "| Browse {$_GET['get']}: | ";
for ($i=0;$i";
$sql2 = $sql." LIMIT ".($i*100).", 1";
$result = mysql_query($sql2);
While ($j=mysql_fetch_object($result))
echo substr($j->sortName,0,3);
mysql_free_result($result);
echo " - ";
$sql2 = $sql." LIMIT ".(($i+1)*100).", 1";
$result = mysql_query($sql2);
While ($j=mysql_fetch_object($result))
echo substr($j->sortName,0,3);
mysql_free_result($result);
echo "] ";
}
echo "| | \n";
if (($_GET['start']!="") AND ((round($_GET['start']/100,0)==($_GET['start']/100))))
$myLimit = $_GET['start'];
$sql1 = $sql." LIMIT ".$myLimit.", 100";
$result = mysql_query($sql1);
While ($i = mysql_fetch_object($result)) {
echo "| id."\">".$i->name."";
}
mysql_free_result($result);
}
}
}
include 'sheet.php';
?>
| |