Paidmails, Easy-Inbox und Mailsortierung

[jpwfour]

$max = mysql_fetch_array(db_query ("SELECT ".$db_feld." FROM ".$db_prefix."_userdaten WHERE uid = '".$_SESSION['uid']."' LIMIT 1"));
//$max = mysql_fetch_assoc(db_query ("SELECT max_forced, var, vonu FROM ".$db_prefix."_userdaten WHERE uid = '".$_SESSION['uid']."' LIMIT 1"));

$pmail = db_query("SELECT t1.* FROM ".$db_prefix."_gebuchte_werbung AS t1 LEFT JOIN ".$db_prefix."_reloads_mail AS t2 ON (t1.tan = t2.tan AND (t2.uid = '".$_SESSION['uid']."' OR t2.ip = '".$ip."') AND t2.bis >= '".time()."') WHERE t2.tan IS NULL AND t1.werbeart = 'paidmail' AND t1.menge > 0 AND t1.status = 1 AND t1.verdienst > 0 ORDER BY t1.verdienst DESC LIMIT ".$max[$db_feld]."") OR die(mysql_error());
//$pmail = db_query("SELECT t1.* FROM ".$db_prefix."_gebuchte_werbung AS t1 LEFT JOIN ".$db_prefix."_reloads_mail AS t2 ON (t1.tan = t2.tan AND (t2.uid = '".$_SESSION['uid']."' OR t2.ip = '".$ip."') AND t2.bis >= '".time()."') WHERE t2.tan IS NULL AND t1.werbeart = 'paidmail' AND t1.menge > 0 AND t1.status = 1 AND t1.verdienst > 0 AND t1.sponsor '= '.$_SESSION['uid'].' ORDER BY t1.'.$usr['var'].' '.$usr['vonu'].' LIMIT ".$max[$db_feld]."") OR die(mysql_error()); 

Ich denke mal, weil du max_forced ausliest aus der DB, aber bei den Mails das Limit afaik in einer anderen Variablen steht.

Also deine 2. Zeile sollte so stimmen, aber die 1. ändern in:

$max = mysql_fetch_assoc(db_query ("SELECT ".$db_feld.", var, vonu FROM ".$db_prefix."_userdaten WHERE uid = '".$_SESSION['uid']."' LIMIT 1"));