Newer
Older
Christoph Zysik
committed
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
<?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;
}