'; print ""; } function PrintSideAd(){ print ' '; } function ConnectToDB() { $dbh=mysql_connect ("localhost", "rockmusi_mtype", "7Y#3;d1^13Lj") or die ('I cannot connect to the database because: ' . mysql_error()); mysql_select_db ("rockmusi_mt"); } function PrintMerch($artista='',$artistb='',$artistc='') { if($artista != ''){ $sql = "SELECT * FROM `allposters` WHERE MATCH ( Title ) AGAINST ( '$artista' ) ORDER BY `rank` LIMIT 2"; $result = mysql_query($sql); if($result != '') { ?>
Related Merch:
"; } } // end artista if($artistb != 0){ $sql = "SELECT * FROM `allposters` WHERE MATCH ( Title ) AGAINST ( '$artistb' ) ORDER BY `rank` LIMIT 2"; $result = mysql_query($sql); if ($result) { print ""; } while($myrow = mysql_fetch_array($result)) { ?> "; } } // end artistb if($artistc != 0){ $sql = "SELECT * FROM `allposters` WHERE MATCH ( Title ) AGAINST ( '$artistc' ) ORDER BY `rank` LIMIT 2"; $result = mysql_query($sql); if ($result) { print ""; } while($myrow = mysql_fetch_array($result)) { ?> "; } } // end artistc if(($artista != '')) { ?>






"; } else if($imgurl == "0") { print ""; } else { if($url == "x"){ $url = $imgurl; } copy($url,$tempfile); $img = imagecreatefromjpeg( $tempfile ); // Get image size and scale ratio $width = imagesx($img); $height = imagesy($img); $scale = min($w/$width, $h/$height); // If the image is larger than the max shrink it if ($scale < 1) { $new_width = floor($scale*$width); $new_height = floor($scale*$height); // Create a new temporary image $tmp_img = imagecreatetruecolor($new_width, $new_height); // Copy and resize old image into new image imagecopyresampled($tmp_img, $img, 0, 0, 0, 0, $new_width, $new_height, $width, $height); imagedestroy($img); $img = $tmp_img; // store image to server if(!@imagejpeg($tmp_img,$filename,85)){ echo "error saving jpeg."; exit; } // update database $sql = "UPDATE `mt_" . $type . "` SET `" . $type . "_" . $w . "` = \"" . $fileurl . "\" WHERE `" . $type . "_id` = $id LIMIT 1"; $result = mysql_query($sql); print "\"\"/"; } // scale < 1 } } } function DateDropDown($size=90,$default="DropDate") { // $size = the number of days to display in the drop down // $default = Todays date in m:d:Y format (SEE DATE COMMAND ON WWW.PHP.NET) // $skip = if set then the program will skip Sundays and Saturdays $skip=1; echo "\n"; } function StoreAlbumInfo($id,$link,$label,$rdate,$asin=0){ ConnectToDB(); $sql = "SELECT * FROM `mt_album` WHERE `album_id` = $id LIMIT 1"; $result = mysql_query($sql); while($myrow = mysql_fetch_assoc($result)) { if($myrow['album_link'] == "1"){ mysql_query("UPDATE `mt_album` SET `album_link` = \"" . $link . "\" WHERE `album_id` = '$id' LIMIT 1"); } if($myrow['album_label'] == "1"){ mysql_query("UPDATE `mt_album` SET `album_label` = \"" . $label . "\" WHERE `album_id` = '$id' LIMIT 1"); } if($myrow['album_date'] == "1"){ mysql_query("UPDATE `mt_album` SET `album_date` = \"" . $rdate . "\" WHERE `album_id` = '$id' LIMIT 1"); } if($myrow['album_ASIN'] == "1"){ mysql_query("UPDATE `mt_album` SET `album_ASIN` = \"" . $asin . "\" WHERE `album_id` = '$id' LIMIT 1"); } } } function StoreAlbumASIN($id,$asin){ ConnectToDB(); $sql = "SELECT * FROM `mt_album` WHERE `album_id` = $id LIMIT 1"; $result = mysql_fetch_array(mysql_query($sql)); if($result['album_ASIN'] == "1"){ mysql_query("UPDATE `mt_album` SET `album_ASIN` = \"" . $asin . "\" WHERE `album_id` = '$id' LIMIT 1"); } } function PrintAlbumLink($id,$link){ ConnectToDB(); $sql = "SELECT * FROM `mt_album` WHERE `album_id` = $id LIMIT 1"; $result = mysql_query($sql); while($myrow = mysql_fetch_assoc($result)) { if($myrow['album_link'] == "1"){ mysql_query("UPDATE `mt_album` SET `album_link` = \"" . $link . "\" WHERE `album_id` = '$id' LIMIT 1"); print $link; } else { print $myrow['album_link']; } } } function PrintAlbumLabel($id,$label){ ConnectToDB(); $sql = "SELECT * FROM `mt_album` WHERE `album_id` = $id LIMIT 1"; $result = mysql_query($sql); while($myrow = mysql_fetch_assoc($result)) { if($myrow['album_label'] == "1"){ mysql_query("UPDATE `mt_album` SET `album_label` = \"" . $label . "\" WHERE `album_id` = '$id' LIMIT 1"); print $label; } else { print $myrow['album_label']; } } } function PrintAlbumDate($id,$rdate){ ConnectToDB(); $sql = "SELECT * FROM `mt_album` WHERE `album_id` = $id LIMIT 1"; $result = mysql_query($sql); while($myrow = mysql_fetch_assoc($result)) { if($myrow['album_date'] == "1"){ mysql_query("UPDATE `mt_album` SET `album_date` = \"" . $rdate . "\" WHERE `album_id` = '$id' LIMIT 1"); print $rdate; } else { print $myrow['album_date']; } } } function PrintAuthor($authorname,$authornick){ $imgurl = "/images/staff/" . $authorname . "_60.jpg"; $serverimg = "/home/rockmusi/public_html" . $imgurl; print ""; if(file_exists($serverimg)){ print ""; } print $authornick . ""; $result = mysql_query("SELECT stafftitle FROM `mt_author` WHERE author_name = '$authorname'"); $row = mysql_fetch_row($result); print "
" . $row[0] . ""; } function PrintAuthorNameLink($id){ $result = mysql_query("SELECT entry_author_id FROM `mt_entry` WHERE entry_id = '$id'"); $rowa = mysql_fetch_row($result); $result = mysql_query("SELECT author_id, author_name, author_nickname FROM `mt_author` WHERE author_id = '$rowa[0]'"); $row = mysql_fetch_row($result); print "" . $row[2] . ""; } function array_sort($array, $key) { for ($i = 0; $i < sizeof($array); $i++) { $sort_values[$i] = $array[$i][$key]; } asort ($sort_values); reset ($sort_values); while (list ($arr_key, $arr_val) = each ($sort_values)) { $sorted_arr[] = $array[$arr_key]; } return $sorted_arr; } function array_rsort($array, $key) { for ($i = 0; $i < sizeof($array); $i++) { $sort_values[$i] = $array[$i][$key]; } rsort ($sort_values); reset ($sort_values); while (list ($arr_key, $arr_val) = each ($sort_values)) { $sorted_arr[] = $array[$arr_key]; } return $sorted_arr; } function HeadStuff($section,$title,$desc){ ?> <? if($title){ print $title . " / "; } ?> <? if($section) { print $section . " / "; } ?>Rock Music Review =$today) && ($resulta['date'] <=$week)){ print "" . $theartist . " is currently on tour..."; return; } else if($resulta['date'] >=$today) { print "" . $theartist . " tour dates..."; return; } } } if (!function_exists('virtual')) { function virtual($file){ include("/home/rockmusi/public_html/$file"); } } if (!function_exists('mb_strtolower')) { function mb_strtolower($a){ return strtolower($a); } } ?> Rock Music Review
Get the latest album reviews, interviews, concert reviews, photos, and exclusive contests in your inbox!
We'll never email more than once a week and your info will never be shared.
email   name   city state  
" onMouseOver="javascript:document.getElementById('album').style.display = 'inline';" onMouseOut="javascript:document.getElementById('album').style.display = 'none';"> " onMouseOver="javascript:document.getElementById('album').style.display = 'inline';" onMouseOut="javascript:document.getElementById('album').style.display = 'none';"> " onMouseOver="javascript:document.getElementById('album').style.display = 'inline';" onMouseOut="javascript:document.getElementById('album').style.display = 'none';"> " onMouseOver="javascript:document.getElementById('album').style.display = 'inline';" onMouseOut="javascript:document.getElementById('album').style.display = 'none';"> " onMouseOver="javascript:document.getElementById('album').style.display = 'inline';" onMouseOut="javascript:document.getElementById('album').style.display = 'none';">
Sponsored Advertising
VIDEO ARCHIVES

- -
($skip+20)){ ?>
IN THE KNOW
Previous"; if (($thedate) < (date("Ymd"))) { $dateword .= " | Next"; } $dateword .= "Archived "; } else if ($_GET['view'] == "video") { $thedate = date("Ymd")-1; $dateword = "Yesterday's"; } else { $thedate = date("Ymd"); $dateword = ""; } // $sql = "SELECT * FROM `video` WHERE `date` = '" . $thedate . "' LIMIT 1"; // $result = mysql_query($sql); //$sql = "SELECT * FROM `video` WHERE `date` <= '" . $thedate . "' AND `code` != '' ORDER BY `date` DESC LIMIT 1"; $sql = "SELECT * FROM `video` WHERE `code` != '' ORDER BY RAND() LIMIT 1"; $result = mysql_query($sql); while($darow = mysql_fetch_array($result)) { ?>
Video of the Day: -
STEAL THESE SONGS!

RMR



1 2 3 4 5 6 7