".$locale['cm10'].""); $miesiace = array(' ', 'Styczeń', 'Luty', 'Marzec', 'Kwiecień', 'Maj', 'Czerwiec', 'Lipiec', 'Sierpień', 'Wrzesień', 'PaĄdziernik', 'Listopad', 'Grudzień'); if (isset($step) == "") $step = "list"; if ($step == "list") { if (!isset($sortby)) $sortby = "all"; $search = 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","0","1","2","3","4","5","6","7","8","9" ); if (!isset($type)) $type = "artist"; echo "

---

\n\n"; echo ""; for ($i=0;$i < 36;$i++) { echo ""; echo ($i==17 ? "\n\n\n" : "\n"); } echo "\n

".$locale['cm11']."	".$search[$i]."	".$locale['cm11']."

\n"; if ($type == "artist") { $orderby = ($sortby == "all" ? "" : "WHERE a.artist_name LIKE '".stripinput($sortby)."%'"); $result = dbquery("SELECT * FROM ".$db_prefix."artist a ".$orderby." ORDER BY artist_name"); $rows = dbrows($result); if ($rows != 0) { $i = 0; echo "\n"; while ($data = dbarray($result)) { $klasa = ($i % 2 == 0 ? "tbl1" : "tbl2"); echo ""; $i++; } echo "

".$locale['cm22']."

".$data['artist_name']."

"; } else { echo "
\n".$locale['cm12']."$sortby

\n\n"; } } else if ($type == "review") { $orderby = ($sortby == "all" ? "" : " WHERE review_name LIKE '".stripinput($sortby)."%'"); $result = dbquery("SELECT * FROM ".$db_prefix."review ".$orderby." ORDER BY review_datestamp DESC"); $rows = dbrows($result); if ($rows != 0) { $i = 0; echo ""; while ($data = dbarray($result)) { $result2 = dbquery("SELECT * FROM ".$db_prefix."artist WHERE artist_id ='".$data['review_artist_id']."'"); $data2 = dbarray($result2); if (date('d', $data['review_datestamp']) != $dzien) { $dzien = date('d', $data['review_datestamp']); $miesiac = intval(date('m', $data['review_datestamp'])); $rok = date('Y', $data['review_datestamp']); echo ""; } $klasa = ($i % 2 == 0 ? "tbl1" : "tbl2"); echo ""; $i++; } echo "

[ Recenzje ]
	Recenzja:
".$dzien." ".$miesiace[$miesiac]." ".$rok."
".($data['review_image'] ? "" : "")."	".$data2['artist_name']." ".substr($data['review_album'], 0 , 30)."

"; } else echo "
Nie ma żadnych recenzji, których nazwa zaczyna się na $sortby

\n\n"; } } else { echo "

"; $result2 = dbquery("SELECT * FROM ".$db_prefix."artist WHERE artist_id='$artist_id'"); if (dbrows($result2)) $data2= dbarray($result2); echo " ".strtoupper($data2['artist_name'])."

"; $result = dbquery("SELECT * FROM ".$db_prefix."review a, ".$db_prefix."artist b WHERE a.".$step."_artist_id = b.artist_id AND a.review_artist_id='$artist_id' AND a.review_id='$id'"); if ($id) { $data = dbarray($result); $numer = $id; echo ""; } else { $result = dbquery("SELECT * FROM ".$db_prefix."review a, ".$db_prefix."artist b WHERE a.review_artist_id = b.artist_id AND a.review_artist_id='$artist_id'"); if (dbrows($result)) { while ($data = dbarray($result)) { echo ""; } } else { $komunikat = $locale['cm20']; } } echo " ".($data['review_image'] ? "" : "")." ".$locale['cm24']." ".$data['review_album']." ".$locale['cm24']." ".$data['review_name']" ".$locale['cm25']." $result = dbquery( SELECT tn.*, review_name FROM ".$db_prefix."review tn LEFT JOIN ".$db_prefix."users tu ON tn.review_name=tu.user_id); ".$locale['cm25']." ".$data['review_year']." ".$locale['cm26']." ".$data['review_url_title']." ".$locale['cm27']." ".str_repeat('', $data['review_note'])." ".$locale['cm28']." ".$data['review_body']." ".($data['review_image'] ? "" : "")." ".$data['review_album']."

\n"; } closetable(); include INCLUDES."comments_include.php"; showcomments('r','review',"review_id",$id,FUSION_SELF."?step=review&type=comments&artist_id=".$artist_id."&id=".$id); require_once "side_right.php"; require_once "footer.php"; ?>