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
|
<?php
$ip=$_SERVER['REMOTE_ADDR'];
$datenow = date("Y-m-d");
include('config.php');
//****************** Exportalja a top20 listat
$sql7=mysql_query("SELECT ID, artist, song, up, active, prev_month, months_in_top, added_date, mp3 FROM top20 WHERE active=1 ORDER BY up DESC");
$ourFileName = "/var/www/sites/kptv.ro/public_html/radio/voting/export_".$datenow.".txt";
$ourFileHandle = fopen($ourFileName, 'w') or die("can't open file");
$putinto = "ID;artist;song;up;active;prev_month;months_in_top;added_date;mp3\n";
while ($row7=mysql_fetch_assoc($sql7)) {
$putinto .= implode(";",$row7);
$putinto .= "\n";
}
fwrite($ourFileHandle, $putinto);
fclose($ourFileHandle);
//****************** Elkesziti a top20 listat
$sql=mysql_query("SELECT ID FROM top20 WHERE active=1 ORDER BY up DESC, ID LIMIT 20 ");
$i = 0;
$arr = array();
while($row=mysql_fetch_array($sql)) {
$i=$i+1;
//$arr[$row['ID']] = $i;
mysql_query("UPDATE top20 SET prev_month = '".$i."' WHERE ID = ".$row['ID']);
}
//****************** Elkesziti a top20plus listat
$sql2=mysql_query("SELECT ID, up FROM top20plus WHERE active=1 ORDER BY up DESC LIMIT 3");
$first3 = array();
$k = 0;
while($row2=mysql_fetch_array($sql2)) {
$k++;
$first3[$row2['ID']] = $row2['up'];
}
//***************** modositja a months_in_top erteket
mysql_query("UPDATE top20 SET months_in_top=months_in_top+1");
//****************** Kiveszi az utolso darabot a 20-bol
$latest = array();
foreach($first3 as $key=>$vel) {
$sql1=mysql_query("SELECT ID, up FROM top20 WHERE active=1 ORDER BY up LIMIT 1");
$j = 0;
while($row1=mysql_fetch_array($sql1)) {
$j++;
$latest[$row1['ID']] = $row1['up'];
//****************** Ha van nagyobb a propuneri-ba akkor updateli
if ($row1['up'] < $vel) {
//************ atmasolja a top20 tablaba
mysql_query("INSERT INTO top20 SELECT * FROM top20plus WHERE ID = ".$key);
//************ inaktivnak teszi a top20plus tablaba
//mysql_query("UPDATE top20plus SET active = 0 WHERE ID = ".$key);
}
}
}
//***************** lezerozza a szavazatokat
mysql_query("UPDATE top20 SET up=0");
mysql_query("UPDATE top20plus SET up=0");
mysql_query("TRUNCATE vote");
mysql_query("TRUNCATE voteplus");
?>
|