openquote('');
$result = dbquery("SELECT * FROM ".$db_prefix."cytat LEFT JOIN ".$db_prefix."cytat_cat ON (cytat_cat=cytat_cat_id) ORDER BY RAND()");
if (dbrows($result) > 0) {
$data = dbarray($result);
echo "
\n\n";
echo " | \n";
echo "
\n\n";
echo "\n";
echo "\n\n";
echo " | \n";
echo "".$data['cytat_description']." | \n";
echo " | \n";
echo " \n \n";
echo " | \n";
echo "
\n\n";
echo " | \n";
echo "
\n
\n";
echo "".$data['cytat_cat_name']."
";
if (iMEMBER) {
$rows = dbcount("(*)", $db_prefix."cytat_vote WHERE cytat_id='".$data['cytat_id']."' AND user_id='".$userdata['user_id']."'");
if(!$rows > 0 ) {
if (isset($_POST['add'])) {
$result_add = dbquery("UPDATE ".$db_prefix."cytat SET cytat_plus=cytat_plus+1 WHERE cytat_id='".$_POST['id']."' ");
$result_add2 = dbquery("INSERT INTO ".$db_prefix."cytat_vote SET cytat_id=".$_POST['id'].", user_id=".$_POST['userid']." ");
}
if (isset($_POST['substract'])) {
$result_add = dbquery("UPDATE ".$db_prefix."cytat SET cytat_minus=cytat_minus+1 WHERE cytat_id='".$_POST['id']."' ");
$result_add2 = dbquery("INSERT INTO ".$db_prefix."cytat_vote SET cytat_id=".$_POST['id'].", user_id=".$_POST['userid']." ");
}
echo "";
echo "";
} else {
echo "Już głosowałeś | ";
}
}
//echo "
";
//echo "
";
echo "Więcej cytatów...";
}
closequote();