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

<?php     

error_reporting(0);
// error_reporting(E_ALL);
//ini_set("display_errors", 0);

$db_name = "kptv";
$db_host = "localhost";
$db_password = "bBRWRXMBU3HmqCzP";
$db_usrName = "kptv";

// echo $db_name."/".$db_host."/".$db_password."/".$db_usrName;

//$ip=$_SERVER['REMOTE_ADDR']; 
$datenow = date("Y-m-d");
include('/var/www/sites/kptv.ro/public_html/radio/admin/dbconn2.php');
require_once "/var/www/sites/kptv.ro/public_html/radio/common/database.php";
require_once "/var/www/sites/kptv.ro/public_html/radio/ro/func/vote.php";

//require_once "../common/database.php";
//include('./radio/admin/dbconn2.php');
//require_once "../ro/func/vote.php";

//****************** Exportalja a top20 listat
$database = new Database($db_host, $db_name, $db_usrName, $db_password);
$sql7 = $database->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";
// $ourFileName = "/var/www/sites/kptv.ro/public_html/radio/voting/export_".$datenow.".txt";
// $ourFileHandle = fopen($ourFileName, 'wb') 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);        

/********/

$vote = new Vote();

$prevMonth = $vote->orderPrevMonth('prev_month');
$vote->handlePrevMonth($prevMonth);

$top20List = $vote->getTop20("up");
// usort($top20List, "sortByOrder");

$top20ListPlus = $vote->getTop20Plus("up");
// usort($top20ListPlus, "sortByOrder");

// echo "<pre>";
// print_r($top20List);
// die();

$vote->handleTop20Top20PlusLoc($top20List, $top20ListPlus);
$vote->sumTop20();

$vote->handleUp($vote->getTop20("up","ASC"), "top20");
$vote->handleUp($vote->getTop20Plus("up","ASC"), "top20plus");

$vote->increaseMonthsInTop();    
//$vote->reset();


function sortByOrder($a, $b) {
    return $b['up'] - $a['up'];
}

?>