FAQ-Thread

[sterni]

Nein leider nicht benutze 1.2.3

[Sebmaster]

Nein leider nicht benutze 1.2.3

Nein auf was?

Was gibt der Query aus?

[sterni]

Also wenn ich Deins benutze bekomm ich




SELECT t1.* FROM vms_gebuchte_werbung t1 LEFT JOIN vms_adscan_userblacklist t4 ON t4.tan = t1.tan AND t4.uid = 327046 LEFT JOIN vms_fb_blacklist AS t3 ON t3.kid = t1.kid AND t3.werbeart=t1.werbeart LEFT JOIN vms_reloads t2 ON (t1.tan = t2.tan AND (t2.uid = 327046 OR t2.ip = "84.130.111.143") AND t2.bis >= 1228242060) WHERE (t3.kid IS NULL OR LOCATE(t3.sponsor, t1.ziel) = 0) AND t4.tan IS NULL AND t2.tan IS NULL AND t1.werbeart = "forcedbanner" AND t1.menge > 0 AND t1.status = 1 AND t1.verdienst > 0 AND t1.sponsor != 327046 ORDER BY t1.verdienst DESC LIMIT 20
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/web361/html/klammunity/content/verdienen/klick4.php on line 17

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/web361/html/klammunity/content/verdienen/klick4.php on line 22

Alle Banner im Reload !

[Sebmaster]

OK, nun so:

<?
userstatus (); 
head ('Paidbanner');

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

$query = 'SELECT t1.* 
              FROM '.$db_prefix.'_gebuchte_werbung t1
            LEFT JOIN '.$db_prefix.'_adscan_userblacklist t4 ON t4.tan = t1.tan AND t4.uid = '.$_SESSION['uid'].'
            LEFT JOIN '.$db_prefix.'_fb_blacklist AS t3 ON t3.kid = t1.kid AND t3.werbeart=t1.werbeart
              LEFT JOIN '.$db_prefix.'_reloads t2
              ON (t1.tan = t2.tan AND (t2.uid = '.$_SESSION['uid'].' OR t2.ip = "'.$ip.'") AND t2.bis >= '.time().') 
              WHERE (t3.kid IS NULL OR LOCATE(t3.sponsor, t1.ziel) = 0) AND t4.tan IS NULL AND 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.verdienst DESC LIMIT '.$usr['max_forced'];
echo $query;
$fbanner = db_query ($query);
mysql_error();

while ($f_banner = mysql_fetch_assoc ($fbanner)){
    echo '<div align="center" id="banner_'.$f_banner['tan'].'"><a href="fc.php?tan='.$f_banner['tan'].'" target="_blank"><img src="'.$f_banner['banner'].'" border="0" height="60" width="468" alt="'.$f_banner['tan'].'" onClick="document.getElementById(\'banner_'.$f_banner['tan'].'\').style.display=\'none\';"></a>'
    . '<br>Reload:'. $f_banner['reload']/3600 .' Std. | Verdienst: '.number_format($f_banner['verdienst'],2,',','.').' | Aufenthalt: '.$f_banner['aufendhalt'].' Sekunden<br><br></div>';    
}  

if (mysql_num_rows ($fbanner) > 0) echo '<div align="center"><input type="button" name="mehr_banner" value="Weitere Banner !" onclick="javascript:location.reload();" /></div>';  
else echo '<div style="text-align: center; font-weight: bold; color: #ff0000;">Alle Banner im Reload !</div>';

foot ();
?>

Wieder die Rückgabe bitte

[sterni]

SELECT t1.* FROM vms_gebuchte_werbung t1 LEFT JOIN vms_adscan_userblacklist t4 ON t4.tan = t1.tan AND t4.uid = 327046 LEFT JOIN vms_fb_blacklist AS t3 ON t3.kid = t1.kid AND t3.werbeart=t1.werbeart LEFT JOIN vms_reloads t2 ON (t1.tan = t2.tan AND (t2.uid = 327046 OR t2.ip = "84.130.111.143") AND t2.bis >= 1228244731) WHERE (t3.kid IS NULL OR LOCATE(t3.sponsor, t1.ziel) = 0) AND t4.tan IS NULL AND t2.tan IS NULL AND t1.werbeart = "forcedbanner" AND t1.menge > 0 AND t1.status = 1 AND t1.verdienst > 0 AND t1.sponsor != 327046 ORDER BY t1.verdienst DESC LIMIT 20
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /var/www/web361/html/klammunity/content/verdienen/klick4.php on line 18

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/web361/html/klammunity/content/verdienen/klick4.php on line 23

Alle Banner im Reload !

[Sebmaster]

<?
userstatus (); 
head ('Paidbanner');

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

$query = 'SELECT t1.* 
              FROM '.$db_prefix.'_gebuchte_werbung t1
            LEFT JOIN '.$db_prefix.'_adscan_userblacklist t4 ON t4.tan = t1.tan AND t4.uid = '.$_SESSION['uid'].'
            LEFT JOIN '.$db_prefix.'_fb_blacklist AS t3 ON t3.kid = t1.kid AND t3.werbeart=t1.werbeart
              LEFT JOIN '.$db_prefix.'_reloads t2
              ON (t1.tan = t2.tan AND (t2.uid = '.$_SESSION['uid'].' OR t2.ip = "'.$ip.'") AND t2.bis >= '.time().') 
              WHERE (t3.kid IS NULL OR LOCATE(t3.sponsor, t1.ziel) = 0) AND t4.tan IS NULL AND 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.verdienst DESC LIMIT '.$usr['max_forced'];
echo $query;
$fbanner = db_query ($query) or die(mysql_error());

while ($f_banner = mysql_fetch_assoc ($fbanner)){
    echo '<div align="center" id="banner_'.$f_banner['tan'].'"><a href="fc.php?tan='.$f_banner['tan'].'" target="_blank"><img src="'.$f_banner['banner'].'" border="0" height="60" width="468" alt="'.$f_banner['tan'].'" onClick="document.getElementById(\'banner_'.$f_banner['tan'].'\').style.display=\'none\';"></a>'
    . '<br>Reload:'. $f_banner['reload']/3600 .' Std. | Verdienst: '.number_format($f_banner['verdienst'],2,',','.').' | Aufenthalt: '.$f_banner['aufendhalt'].' Sekunden<br><br></div>';    
}  

if (mysql_num_rows ($fbanner) > 0) echo '<div align="center"><input type="button" name="mehr_banner" value="Weitere Banner !" onclick="javascript:location.reload();" /></div>';  
else echo '<div style="text-align: center; font-weight: bold; color: #ff0000;">Alle Banner im Reload !</div>';

foot ();
?>

Ein letztes mal noch

[sterni]

SELECT t1.* FROM vms_gebuchte_werbung t1 LEFT JOIN vms_adscan_userblacklist t4 ON t4.tan = t1.tan AND t4.uid = 327046 LEFT JOIN vms_fb_blacklist AS t3 ON t3.kid = t1.kid AND t3.werbeart=t1.werbeart LEFT JOIN vms_reloads t2 ON (t1.tan = t2.tan AND (t2.uid = 327046 OR t2.ip = "84.130.111.143") AND t2.bis >= 1228245152) WHERE (t3.kid IS NULL OR LOCATE(t3.sponsor, t1.ziel) = 0) AND t4.tan IS NULL AND t2.tan IS NULL AND t1.werbeart = "forcedbanner" AND t1.menge > 0 AND t1.status = 1 AND t1.verdienst > 0 AND t1.sponsor != 327046 ORDER BY t1.verdienst DESC LIMIT 20Unerlaubte Mischung von Sortierreihenfolgen (latin1_german1_ci, IMPLICIT) und (latin1_swedish_ci, IMPLICIT) für Operation 'locate'

[Sebmaster]

Unerlaubte Mischung von Sortierreihenfolgen (latin1_german1_ci, IMPLICIT) und (latin1_swedish_ci, IMPLICIT) für Operation 'locate'

Daran liegts! Geh in phpMyAdmin und stell dort den Zeichensatz um, einfach in ALLE Adscan Tabellen gehen, und dort auf das jeweils andre (latin1:swedish bzw. latin1_german) umstellen.

Machst du folgendermaßen: In die Adscan Tabellen, in allen Spalten auf das Bleistiftsymbol und den richtigen Charset auswählen und speichern.

Dannach wieder das Adscan original der Dateien verwenden

Mfg
Sebmaster