Paidmails, Easy-Inbox und Mailsortierung

[Tommyzero]

ich hatte mir hier das sotier addon runtergeladen und in banner,paidling und hihgforced bereich eingebaut doch in die easy in box bekomme ich nicht ganz hin meine idee steht in // aber mails werden nich tangezeit vielleicht habt ihr ne lösung.

$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()); 

[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")); 

[Tommyzero]

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")); 

wird leider immer noch keine mails angezeigt

[jpwfour]

MySQL Fehlermeldungen?
evtl mal

echo mysql_error(); 

nach jedem query ausgeben lassen.

[Tommyzero]

MySQL Fehlermeldungen?
evtl mal

echo mysql_error(); 

nach jedem query ausgeben lassen.

keine meldungen nur leere anzeige menü links sieht man menü rechts nicht nicht

[jpwfour]

Dann wohl eher ein Syntax Fehler, poste mal deine geänderten Zeilen hier.

[Tommyzero]

also hier die grund zeilen

$max = mysql_fetch_array(db_query ("SELECT ".$db_feld." 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()); 

hier meine idee

$max = mysql_fetch_assoc(db_query ("SELECT ".$db_feld.", var, vonu FROM ".$db_prefix."_userdaten WHERE uid = '".$_SESSION['uid']."' LIMIT 1")  echo 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]."") echo mysql_error()); 

und hier die codes von sotierung

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

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 = "forcedbanner" 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 '.$usr['max_forced'].'');