-
Notifications
You must be signed in to change notification settings - Fork 0
/
redirect.php
executable file
·113 lines (102 loc) · 3.42 KB
/
redirect.php
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
<?php
include('./requiert/php-global.php');
$off_id = $_GET['off_id'];
$maxOffersPerAnnonceurPerDay = 10;
// On selectionne les informations de la campagne
$sql = "SELECT id, idoffre, nom, url, remuneration, actif, regie, annonceur, quota,
( SELECT COUNT(*)
FROM histo_offers ho
WHERE ho.idt = o.nom
AND ho.etat != 'Refusé'
AND ho.date LIKE '".date('d/m/Y')."%'
) totalForQuota,
( SELECT olo.nom
FROM offers olo
JOIN histo_offers holo ON holo.idt = olo.nom
WHERE holo.idUser = '$mbreHashId'
AND holo.etat != 'Refusé'
AND olo.annonceur = o.annonceur
ORDER BY holo.date DESC
LIMIT 1
) latestOffer,
( SELECT ou.nom
FROM offers ou
WHERE ou.annonceur = o.annonceur
ORDER BY ou.nom
DESC LIMIT 1
) ultimateOffer
FROM offers o
WHERE pays LIKE '%%".$country_code."%%'
AND premium <= '".$mbrePremium."'
AND actif = 1
AND NOT EXISTS
( SELECT *
FROM histo_offers hoidUser
WHERE hoidUser.idt = o.nom
AND hoidUser.etat != 'Refusé'
AND hoidUser.date LIKE '".date('d/m/Y')."%'
AND hoidUser.idUser = '$mbreHashId'
) /* offer not done today */
AND NOT EXISTS
( SELECT *
FROM offers oip
JOIN histo_offers hoip ON hoip.idt = oip.nom
WHERE hoip.ip = '".ip."'
AND hoip.etat != 'Refusé'
AND hoip.date LIKE '".date('d/m/Y')."%'
AND hoip.idUser = '$mbreHashId'
AND oip.annonceur = o.annonceur
) /* no offer from same annonceur unless with different IP */
AND NOT EXISTS
( SELECT COUNT(*)
FROM offers oa
JOIN histo_offers hoa ON hoa.idt = oa.nom
WHERE hoa.etat != 'Refusé'
AND hoa.date LIKE '".date('d/m/Y')."%'
AND hoa.idUser = '$mbreHashId'
AND oa.annonceur = o.annonceur
HAVING COUNT(*) >= $maxOffersPerAnnonceurPerDay
) /* no more than max offers per day per annonceur per member */
AND idoffre = '$off_id'
HAVING (totalForQuota < o.quota OR o.quota = 0)
AND (o.nom > (CASE WHEN latestOffer = ultimateOffer THEN '' ELSE COALESCE(latestOffer, '') END))
ORDER BY o.nom ASC
";
$art = $pdo->query($sql);
$dones_art = $art->fetch(PDO::FETCH_ASSOC);
if (empty($dones_art))
{
header('Location: '.url_site.'');
exit;
}
$id = $dones_art['id'];
$idoffre = $dones_art['idoffre'];
$nom = addslashes($dones_art['nom']);
$url = $dones_art['url'];
$remuneration = $dones_art['remuneration'];
$actif = $dones_art['actif'];
$annonceur = $dones_art['annonceur'];
$regie = $dones_art['regie'];
if (isset($_SESSION['id'])) {
$rand = rand(100000000000000,999999999999999);
function data($longueur) {
$data = '';
$chaine = "azertyuiopqsdfghjklmwxcvbn1234567890AZERTYUIOPQSDFGHJKLMWXCVBN";
for ($i = 0; $i < $longueur; $i++) {
$data .= substr($chaine, (rand() % (strlen($chaine))), 1);
}
return $data;
}
$data = data(20);
$url = str_replace('#IDM', $data, $url);
$date = date('d/m/Y à H:i:s');
$pdo->exec("INSERT INTO `histo_offers` (`id`, `idUser`, `offerwall`, `idt`, `regie`, `remuneration`, `date`, `dateUsTime`, `data`, `etat`, `ip`) VALUES ('', '".$mbreHashId."', 'Mission', '".$nom."', '".$regie."', '".$remuneration."', '".$date."', '".date('Y-m-d H:i:s')."', '".$data."', 'En cours', '".ip."')");
}
else {
$url = str_replace('#IDM', '', $url);
}
echo 'Redirection en cours...';
header('Location: '.$url.'');
//echo '<br/>'.$url;
exit;
?>