vbulletin-php/weekly.php at master · dgranda/vbulletin-php · GitHub

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
<!DOCTYPE html>
<html lang="es">
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"/>
        <title>Weekly panel</title>
    </head>
    <body>
<?php
    require_once "vbfunctions.php";
    require_once "utils.php";
    try {
        echo "Loading default data... ";
        require_once "./forum_data.php"; # require will throw an error and stop executing if file is not found
        echo "OK<br/>\n";
        echo "Retrieving data from spreadsheet... ";
        # http://www.ravelrumba.com/blog/json-google-spreadsheets/
        $spreadsheet_data = getData(FEED);
        $today = new DateTime("now", new DateTimeZone('Europe/Madrid'));
        $current_cal_week = $today->format("W");
        if ($spreadsheet_data) {
            echo "OK<br/>\n";
            $post_title = "Carreritas semana #" . $current_cal_week;
            $post_msg = "";
            echo "Entries for current calendar week (" . $today->format("Y-m-d") . ", CW " . $current_cal_week ."):<br/>\n";
            // Order data by date and then by time
            //quickSort($spreadsheet_data, "Fecha");
            $sort = array();
            foreach($spreadsheet_data as $key => $value) {
                $sort['Fecha'][$key] = $value['Fecha'];
                if(empty($value['Hora inicio'])) {
                    $value['Hora inicio'] = "00:00";
                }
                // Taking hours and minutes. Force leading zeros
                $tmp = explode(":", $value['Hora inicio']);
                $value['Hora inicio'] = sprintf('%02d:%02d', $tmp[0], $tmp[1]);
                $sort['Hora inicio'][$key] = $value['Hora inicio'];
            }
            # sort by "Fecha" desc and then "Hora inicio" asc (first earlier)
            array_multisort($sort['Fecha'], SORT_ASC, $sort['Hora inicio'], SORT_ASC, $spreadsheet_data);

            foreach ($spreadsheet_data as $row) {
                if(!empty($row["Fecha"]) && !empty($row["Foreros"])) { // We need valid date and people running!
                    $norm_fecha = str_replace("/", "-", $row["Fecha"]);
                    $loop_cal_week = getCalendarWeek($norm_fecha);
                    if ($loop_cal_week == $current_cal_week) {
                        // 23/03/2013 16:30 Medio Maratón Azkoitia-Azpeitia 21097m Azpeitia (Gipuzkoa) Vredaman, Sukarr
                        if(empty($row["Hora inicio"])) {
                            $row["Hora inicio"] = "¿?";
                        }
                        $entry = $row["Fecha"] . " " . $row["Hora inicio"];
                        if(!empty($row["Web"])) {
                            checkAbsoluteURL($row["Web"]);
                            // Check that is a valid url! http://de3.php.net/manual/en/filter.filters.validate.php
                            if (filter_var($row["Web"], FILTER_VALIDATE_URL) === FALSE) {
                                echo $row["Web"] . " seems not a valid url!";
                                $entry .= " " . $row["Prueba"] . " ";
                            } else {
                                $entry .= " [url=" . $row["Web"] . "]" . $row["Prueba"] . "[/url] ";
                            }
                        } else {
                            $entry .= " " . $row["Prueba"] . " ";
                        }
                        $entry .= " " . $row["Distancia"] . " " . $row["Localidad"] . " [b]" . $row["Foreros"] . "[/b]";
                        if($row["Observaciones"]) {
                            $entry .=  " (" . $row["Observaciones"] . ")";
                        }
                        // Removing extra whitespaces, tabs or new lines
                        $post_msg .= preg_replace("/\s+/", " ", $entry) . "\n";
                    }
                }
            }
            if(!empty($post_msg)) {
?>
                <blockquote style="border:1px solid #D4D4D4;background-color:#E5EECC;padding:15px 5px;">
                    <?php echo $post_msg; ?>
                </blockquote>
                <blockquote style="border:1px solid #d6cfb7;background-color:#eee6cc;padding:15px 5px;">
                    <?php echo bbc2html($post_msg); ?>
                </blockquote>
<?php
                // Only one post per day -> lock file!
                //$today = new DateTime("now", new DateTimeZone('Europe/Madrid'));
                $date_string = $today->format("Ymd");
                if(!file_exists($date_string)) {
                    $vbff = new vBForumFunctions(FORUM_BASE_URL);
                    // Check cookie
                    if ($vbff->loggedin) {
                        echo "Cookie exists. Trying to get security token... ";
                        if ($vbff->getSecurityToken()){
                            echo "OK: " . $vbff->securitytoken . "<br/>\n";
                        } else {
                            throw new Exception("ERROR: No security token");
                        }
                    } else {
                        echo "Cookie not found, trying to log in... ";
                        if($vbff->login(FORUM_USERNAME, FORUM_PASSWORD)) {
                            echo "OK<br/>\n";
                        } else {
                            throw new Exception("Error: unable to log in!");
                        }
                    }
                    echo "Trying to post... ";
                    if(!$vbff->posts->postReply(FORUM_THREAD, $post_msg, $post_title)) {
                    //if(!false){
                        echo "Error: something went wrong when trying to post!";
                    } else {
                        // Check directory permissions!!
                        if(!touch($date_string)) {
                            echo "Couldn't create file " . $date_string . " under " . realpath(dirname(__FILE__));
                        } else {
                            echo "OK<br/>\n";
                        }
                    }
                } else {
                    echo "Error: only one post per day";
                }
            } else {
                echo "Error: no valid message for CW #" . $current_cal_week . ", nothing to post";
            }
        } else {
            echo "No data available for CW #" . $current_cal_week . ", nothing to post";
        }
    } catch (Exception $e) {
        echo $e->getMessage();
    }
?>
    </body>
</html>