FUNCIONS.PHP

 

function auth($login = '', $passwd = '')

    session_start();

    global $dbhost, $dbuser, $dbpw, $dbname;

    global $HTTP_SESSION_VARS, $tablepre;

   

    $authdata = $HTTP_SESSION_VARS['authdata'];

   

    if ( is_array( $authdata ) ) {

        $check = $authdata['login'];

        $pw = $authdata['password'];

        $register = false;

    } elseif (!empty($login)) {

        $check = $login;

        $pw = $passwd;

        $register = true;

    } else {

        return false;

    }

   

    mysql_connect($dbhost, $dbuser, $dbpw) or die(mysql_error());

    mysql_select_db($dbname) or die(mysql_error());

   

    $sql = "SELECT * FROM " . $tablepre . "users WHERE username = '" . $check . "'";

    $result = mysql_query($sql) or die(mysql_error());

    $row = mysql_fetch_assoc($result);

   

    if ( $row["password"] == $pw ) {

   

        if ($register) {

            $HTTP_SESSION_VARS["authdata"] = array("login"=>$row["username"], "password"=>$row["password"], "userlevel"=>$row["user_level"], "uid"=>$row["uid"]);

        }

       

        return $row["userlevel"];

    }

 

    unset( $HTTP_SESSION_VARS['authdata'] );

    return false;

 

function monthPullDown($month, $montharray)

    echo "n<select name="month">n";

 

    for($i=0;$i < 12; $i++) {

        if ($i != ($month - 1)) {

            echo "  <option value="" . ($i + 1) . "">$montharray[$i]</option>n";

        } else {

            echo "  <option value="" . ($i + 1) . "" selected>$montharray[$i]</option>n";

        }

    }

 

    echo "</select>nn";

 

function yearPullDown($year)

    echo "<select name="year">n";

 

    $z = 3;

    for($i=1;$i < 8; $i++) {

       

        if ($z == 0) {

            echo "  <option value="" . ($year - $z) . "" selected>" . ($year - $z) . "</option>n";

        } else {

            echo "  <option value="" . ($year - $z) . "">" . ($year - $z) . "</option>n";

        }

       

        $z--;

    }

 

    echo "</select>nn";

 

function dayPullDown($day)

    echo "<select name="day">n";

 

    for($i=1;$i <= 31; $i++) {

        if ($i == $day) {

            echo "  <option value="$i" selected>$i</option>n";

        } else {

            echo "  <option value="$i">$i</option>n";

        }

    }

 

    echo "</select>nn";

 

function hourPullDown($hour, $namepre)

    echo "n<select name="" . $namepre . "_hour">n";

 

    for($i=0;$i <= 12; $i++) {

        if ($i == $hour) {

            echo "  <option value="$i" selected>$i</option>n";

        } else {

            echo "  <option value="$i">$i</option>n";

        }

    }

 

    echo "</select>nn";

 

function minPullDown($min, $namepre)

    echo "n<select name="" . $namepre . "_min">n";

 

    for($i=0;$i <= 55; $i+=5) {

       

        if ($i < 10) { $disp = "0" . $i; } else { $disp = $i; }

       

        if ($i == $min) {

            echo "  <option value="$i" selected>$disp</option>n";

        } else {

            echo "  <option value="$i">$disp</option>n";

        }

    }

 

    echo "</select>nn";

 

function amPmPullDown($pm, $namepre)

    if ($pm) { $pm = " selected"; } else { $am = " selected"; }

 

    echo "n<select name="" . $namepre . "_am_pm">n";

    echo "  <option value="0"$am>am</option>n";

    echo "  <option value="1"$pm>pm</option>n";

    echo "</select>nn";

 

function javaScript()

    <script language="JavaScript">

    function submitMonthYear() {

        document.monthYear.method = "post";

        document.monthYear.action = "index.php?month=" + document.monthYear.month.value + "&year=" + document.monthYear.year.value;

        document.monthYear.submit();

    }

 

    function postMessage(day, month, year) {

        eval("page" + day + " = window.open('eventform.php?d=" + day + "&m=" + month + "&y=" + year + "', 'postScreen', 'toolbar=0,scrollbars=1,location=0,statusbar=0,menubar=0,resizable=1,width=340,height=400');");

    }

 

    function openPosting(pId) {

        eval("page" + pId + " = window.open('eventdisplay.php?id=" + pId + "', 'mssgDisplay', 'toolbar=0,scrollbars=1,location=0,statusbar=0,menubar=0,resizable=1,width=340,height=400');");

    }

   

    function loginPop(month, year) {

        eval("logpage = window.open('login.php?month=" + month + "&year=" + year + "', 'mssgDisplay', 'toolbar=0,scrollbars=1,location=0,statusbar=0,menubar=0,resizable=1,width=340,height=400');");

    }

    </script>

 

 

function footprint($auth, $m, $y) {

    global $lang;

   

    echo "<br><br><span class="footprint">n";

    echo "Calendário de eventos<br>n[ ";

   

    if ( $auth == 2 ) {

        echo "<a href="useradmin.php">" . $lang['adminlnk'] . "</a> | ";

        echo " <a href="login.php?action=logout&month=$m&year=$y">" . $lang['logout'] . "</a>";

    } elseif ( $auth == 1 ) {

        echo "<a href="useradmin.php?flag=changepw">" . $lang['changepw'] . "</a> | ";

        echo "<a href="login.php?action=logout&month=$m&year=$y">" . $lang['logout'] . " </a>";

    } else {

        echo "<a href="javascript:loginPop($m, $y)">" . $lang['login'] . "</a>";

    }

   

    echo " ]</span>";

 

 

function scrollArrows($m, $y)

    // setar variáveis para o mês corrente

    $nextyear = ($m != 12) ? $y : $y + 1;

    $prevyear = ($m != 1) ? $y : $y - 1;

    $prevmonth = ($m == 1) ? 12 : $m - 1;

    $nextmonth = ($m == 12) ? 1 : $m + 1;

 

    $s = "<a href="index.php?month=" . $prevmonth . "&year=" . $prevyear . "">n";

    $s .= "<img src="images/leftArrow.gif" border="0"></a> ";

    $s .= "<a href="index.php?month=" . $nextmonth . "&year=" . $nextyear . "">";

    $s .= "<img src="images/rightArrow.gif" border="0"></a>";

   

    return $s;

 

function writeCalendar($month, $year)

    global $lang, $tablepre, $titlelimit, $titlecharlimit;

    global $dbhost, $dbuser, $dbpw, $dbname;

   

    $str = "<table cellpadding="1" cellspacing="1" border="0">n<tr>n";

   

    foreach($lang['abrvdays'] as $day) {

        $str .= "t<td class="column_header">&nbsp;$day</td>n";

    }

 

    $str .= "</tr>nn";

 

    mysql_connect($dbhost, $dbuser, $dbpw) or die(mysql_error());

    mysql_select_db($dbname) or die(mysql_error());

 

    $sql = "SELECT id, d, title, TIME_FORMAT(start_time, '%l:%i%p') AS stime, TIME_FORMAT(end_time, '%l:%i%p') AS etime FROM " . $tablepre . "mssgs WHERE m = $month AND y = $year ORDER BY start_time";

    $result = mysql_query($sql) or die(mysql_error());

 

    // cria array com título, id e hora para os eventos

    while($row = mysql_fetch_assoc($result)) {

        $eventinfo[$row["d"]]["id"][] = $row["id"];

 

        // setar uma pequena string.  $titleDisplayCharLimit de config.php

        if (strlen($row["title"]) > $titlecharlimit) {

            $eventinfo[$row["d"]]["title"][] = substr(stripslashes($row["title"]), 0, $titlecharlimit) . "...";

        } else {

            $eventinfo[$row["d"]]["title"][] = stripslashes($row["title"]);

        }

       

        if ( $row["stime"] != $row["etime"]) {

            $timestr = "<div align="right" class="time_str">(" . $row["stime"] . " - " . $row["etime"] . ")&nbsp;</div>";

        } else {

            $timestr = "<br>";

        }

 

        $eventinfo[$row["d"]]["timestr"][] = $timestr;

    }

   

    // determina se o usuário está autorizado a editar o calendário

    $auth = auth();

   

    // pega  o número de dias no mês

    $days = 31-((($month-(($month<8)?1:0))%2)+(($month==2)?((!($year%((!($year%100))?400:4)))?1:2):0));

   

    // pega a posição da semana do primeiro dia do mês

    $weekpos = date("w",mktime(0,0,0,$month,1,$year));

    $day = ($weekpos == 0) ? 1 : 0;

 

    // variáveis do dia que muda a cor da tabela

    $d = date(j); $m = date(n); $y = date(Y);

   

    // loop que escreve nas células vazia até atingir posição do 1º dia do mês ($wPos)

    // e ele escreve os dias e, em seguida, preenche a última linha com células vazias após o último dia

    while($day <= $days) {

       

        $str .="<tr>n";

 

        for($i=0;$i < 7; $i++) {

 

            if($day > 0 && $day <= $days) {

               

                $str .= "   <td class="";

                    $str .= "today";

                    $str .= "day";

                $str .= "_cell" valign="top"><span class="day_number">";

               

                if ($auth) {

                    $str .= "<a href="javascript: postMessage($day, $month, $year)">$day</a>";

                } else {

                    $str .= "$day";

                }

               

                $str .= "</span><br>";

               

                // impõe limite no título

                $titles = count($eventinfo[$day]["title"]);

                if ($titlelimit < $titles) { $titles = $titlelimit; }

               

                // mostra o link do evento se existir algum para o dia marcado

                if($eventinfo[$day]["title"][0]) {

                    for($j=0;$j < $titles;$j++) {

                        $str .= "<span class="title_txt">-";

                        $str .= "<a href="javascript:openPosting(" . $eventinfo[$day]["id"][$j] . ")">";

                        $str .= $eventinfo[$day]["title"][$j] . "</a></span>" . $eventinfo[$day]["timestr"][$j];

                    }

                }

 

                $str .= "</td>n";

                $day++;

            } elseif($day == 0)  {

                $str .= "   <td class="empty_day_cell" valign="top">&nbsp;</td>n";

                $weekpos--;

                if ($weekpos == 0) {$day++;}

            } else {

                $str .= "   <td class="empty_day_cell" valign="top">&nbsp;</td>n";

            }

        }

        $str .= "</tr>nn";

    }

   

    $str .= "</table>nn";

    return $str;