<?php $adArten = array('forcedbanner' => 'forcedbanner', ); /* * TODO * nothing checks wether user landed on blacklist... * blacklist check is broken currently anyway * please fix me */ function invalidateAlreadyRunningAd() { global $adArten,$ip,$db_prefix; $result = false; if( isset($_SESSION['current_ad']) ) { $tan = ( isset($_SESSION['current_ad']['tan']) ) ? $_SESSION['current_ad']['tan'] : false; $art = ( isset($_SESSION['current_ad']['art']) ) ? $_SESSION['current_ad']['art'] : ''; if( false !== $tan && in_array($art, $adArten) ) { $dbArt = $adArten[$art]; $kamp = db_query ("SELECT `t1`.* FROM `" . $db_prefix . "_gebuchte_werbung` AS `t1` LEFT JOIN `" . $db_prefix . "_reloads` AS `t2` ON (`t1`.`tan`=`t2`.`tan` AND (`t2`.`uid`=" . $_SESSION['uid'] . " OR `t2`.`ip`='" . $ip . "') AND `t2`.`bis` > " . time() . ") WHERE `t1`.`tan` = '" . $tan . "' AND `t2`.`tan` IS NULL AND `t1`.`werbeart` = '".$dbArt."' LIMIT 1"); if ( mysqli_num_rows( $kamp ) ) { $result = true; $forced = mysqli_fetch_assoc( $kamp ); $new_reload = time() + $forced['reload']; db_query("INSERT INTO `" . $db_prefix . "_reloads` (`ip`,`uid`,`tan`,`bis`) VALUES ('" . $ip . "'," . $_SESSION['uid'] . ",'" . $tan . "'," . $new_reload . ")"); } } unset( $_SESSION['current_ad'] ); } return $result; } function setCurrentRunningAd( $art, $tan ) { $_SESSION['current_ad']['tan'] = $tan; $_SESSION['current_ad']['art'] = $art; $_SESSION['current_ad']['time'] = time(); $_SESSION['current_ad']['paid'] = false; } function handleAdPayout( $forced ) { global $dbArten, $ip, $db_prefix; db_query("UPDATE ".$db_prefix."_kontodaten SET klicks = klicks + 1, kv = kv + ".$forced['verdienst'].", fc_klicks = fc_klicks + 1 WHERE uid = '".$_SESSION['uid']."'"); // Hier Zusatz für Fakeschutz kontobuchung ('+', $forced['verdienst'], create_code(14), $_SESSION['uid'], 1, 'Forcedbannerverdienst'); refumsatz ($forced['verdienst'], $_SESSION['uid']); rallysystem ($_SESSION['uid'], '1', $forced['verdienst']); bilanz($forced['preis'], $forced['verdienst'],'Werbebereich','Forcedbannerklick'); $new_reload = time() + $forced['reload']; db_query("INSERT INTO " . $db_prefix . "_reloads (ip,uid,tan,bis) VALUES ('" . $ip . "'," . $_SESSION['uid'] . ",'" . $forced['tan'] . "'," . $new_reload . ")"); db_query("UPDATE " . $db_prefix . "_gebuchte_werbung SET menge = menge - 1 WHERE tan='" . $forced['tan'] . "'"); } function checkAdOk( $art, $tan ) { global $dbArten, $ip, $db_prefix, $sql_open; $result = array('checkResult' => false); $sql = "SELECT `t1`.* FROM `" . $db_prefix . "_gebuchte_werbung` AS `t1` LEFT JOIN `" . $db_prefix . "_reloads` AS `t2` ON (`t1`.`tan`=`t2`.`tan` AND (`t2`.`uid`=" . $_SESSION['uid'] . " OR `t2`.`ip`='" . $ip . "') AND `t2`.`bis` > " . time() . ") WHERE `t1`.`tan` = ? AND `t2`.`tan` IS NULL AND `t1`.`werbeart` = ? LIMIT 1"; $statement = mysqli_stmt_init( $sql_open ); mysqli_stmt_prepare( $statement, $sql ); mysqli_stmt_bind_param( $statement, "ss", $tan, $art ); if( mysqli_stmt_execute( $statement ) ) { mysqli_stmt_store_result( $statement ); if ( mysqli_stmt_num_rows( $statement ) > 0 ) { $timepassed = ( time() - $_SESSION['current_ad']['time'] ) +1; $rows = db_fetch( $statement ); $forced = $row[0]; $result['data'] = $forced; if( $timepassed >= $forced['aufendhalt'] ) { handleAdPayout( $forced ); $_SESSION['current_ad']['paid'] = true; $result['checkResult'] = true; } } } mysqli_stmt_close( $statement ); return $result; } function getNewAdData( $dbArt ) { global $ip,$db_prefix; $result = array('count' => 0, 'data' => array() ); $banner_sql = 'SELECT t1.* FROM ' . $db_prefix . '_gebuchte_werbung t1 LEFT JOIN ' . $db_prefix . '_userblacklist t4 ON 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 t2.tan IS NULL AND t1.werbeart = "'.$dbArt.'" AND t1.menge > 0 AND t1.status = 1 AND t1.verdienst > 0 AND t1.sponsor != ' . $_SESSION['uid'] . ' ORDER BY t1.verdienst DESC LIMIT 3'; $banner_res = db_query( $banner_sql ); $banner_c = mysqli_num_rows( $banner_res ); $result['count'] = $banner_c; if( 0 < $banner_c ) { while( $banner = mysqli_fetch_assoc( $banner_res ) ) $result['data'][] = $banner; } return $result; }