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.
PHP-Code:
$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());