function updateLastLogIn($user_id)
{
global $db;
$date = make_date();
$sql = "UPDATE users SET last_login='******' WHERE id ='{$user_id}' LIMIT 1";
$result = $db->query($sql);
return $result && $db->affected_rows() === 1 ? true : false;
}
<?php
require_once 'includes/load.php';
if (isset($_POST['custnr'])) {
$req_fields = array('s_id', 'quantity', 'price', 'total');
if (empty($errors)) {
$max = count($_POST['s_id']);
for ($i = 0; $i < $max; $i++) {
$s_total = floatval($_POST['quantity'][$i] * $_POST['price'][$i]);
$p_id = $db->escape((int) $_POST['s_id'][$i]);
$s_qty = $db->escape((int) $_POST['quantity'][$i]);
$date = $db->escape($_POST['date']);
$custnr = $db->escape($_POST['custnr']);
$comment = $db->escape($_POST['comment']);
$s_date = make_date();
$s_userID = $_SESSION['user_id'];
$s_mac = $db->escape($_POST['mac'][$i]);
$productCategory = find_by_id('products', $p_id);
$sql = "INSERT INTO entre_sales (";
$sql .= " product_id, qty, price, date, custnr, comment, FK_userID, mac";
$sql .= ") VALUES (";
$sql .= "'{$p_id}', '{$s_qty}', '{$s_total}', '{$s_date}', '{$custnr}', '{$comment}','{$s_userID}', '{$s_mac}'";
$sql .= ")";
if ($s_qty > 0) {
if ($db->query($sql)) {
update_entre_qty($s_qty, $p_id);
// $session->msg('s', "Sale added. ");
} else {
// $session->msg('d', ' Sorry failed to add!');
}
}
private function set_order_data()
{
$this->request_data['order'] = array();
$date_array = array();
$date_array = $this->request_param('booking_date');
//Order Details
$this->request_data['booking']['pickup_type'] = $this->request_param('pickup_type') ? $this->request_param('pickup_type') : 1;
if ($date_array) {
foreach ($date_array as $key => $date) {
$order = array('pickup_address' => $this->request_param('pickup_address', "Please give the pickup address."), 'requested_pickup_time' => $this->request_param('booking_time'), 'pickup_lat' => $this->request_param('pickup_lat', "Please give the pickup latitude."), 'pickup_long' => $this->request_param('pickup_long', "Please give the pickup longitude."), 'drop_address' => $this->request_param('drop_address', "Please give drop adddress."), 'pin' => $this->request_param('pin'), 'drop_lat' => $this->request_param('drop_lat', "Please give the drop latitude."), 'drop_long' => $this->request_param('drop_long', "Please give the drop longitude."), 'pickup_date' => make_date($date), 'is_flexible' => $this->request_data['booking']['pickup_type'] == 2 ? 1 : 0, 'flexible_time_id' => $this->request_param('flexible_timeslot'));
if ($order['is_flexible'] == 2) {
$order['flexible_time_id'] = $this->request_param('flexible_timeslot');
}
if ($this->update) {
$order['order_id'] = $key;
$order['flexible_time_id'] = $this->request_data['booking']['flexible_timeslot'] = $this->request_data['booking']['pickup_type'] == 1 ? 0 : $this->request_param('flexible_timeslot');
}
$this->request_data['order'][] = $order;
}
$order_count = count($this->request_data['order']);
$this->request_data['booking']['no_of_order'] = $order_count;
$this->request_data['booking']['booking_type'] = $order_count > 1 ? 2 : 1;
}
}
$sarr = explode(" ", $event->StartTime);
$earr = explode(" ", $event->EndTime);
}
// echo $event->StartTime;
?>
<input MaxLength="10" class="required date" id="stpartdate" name="stpartdate" style="padding-left:2px;width:90px;" type="text" value="<?php
echo isset($event) ? make_date($sarr[0]) : "";
?>
" />
<input MaxLength="5" class="required time" id="stparttime" name="stparttime" style="width:40px;" type="text" value="<?php
echo isset($event) ? make_time($sarr[1]) : "";
?>
" /> Jusqu'au
<input MaxLength="10" class="required date" id="etpartdate" name="etpartdate" style="padding-left:2px;width:90px;" type="text" value="<?php
echo isset($event) ? make_date($earr[0]) : "";
?>
" />
<input MaxLength="50" class="required time" id="etparttime" name="etparttime" style="width:40px;" type="text" value="<?php
echo isset($event) ? make_time($earr[1]) : "";
?>
" />
<label class="checkp">
<input id="IsAllDayEvent" name="IsAllDayEvent" type="checkbox" value="1" <?php
if (isset($event) && $event->IsAllDayEvent != 0) {
echo "checked";
}
?>
/> Toute la journée
</label>
</div>
function module_articles_frontpage()
{
echo "<!-- start articles frontpage -->";
global $article_author;
global $no_articles_text;
global $jokes, $layout, $chars_showing_articles, $chars_showing_first_article;
$query = "select * from articles WHERE is_deleted IS NULL AND comment_to IS NULL AND is_draft IS NULL ORDER BY date_posted DESC, time_posted DESC LIMIT 8";
$result = DB_get_table($query);
?>
<!-- start articles frontpage -->
<?php
if ($layout == "newspaper") {
echo '<table class="frontpage_table_2columns">';
} else {
echo '<table class="frontpage_table">';
}
if (!$result || DB_rows_affected($result) < 1) {
// hvis noe er feil, vis en vits.
echo '<tr>';
echo '<td colspan="2" class=\\"articles_frontpage\\">';
echo $no_articles_text . ' Vi presenterer i stedet en vits.<br/><br/>';
echo $jokes[array_rand($jokes, 1)];
echo '</td>';
echo '</tr>';
} else {
$num_results = DB_rows_affected();
// øverste artikkel, spenner over begge kolonnene.
echo "<tr>";
echo '<td colspan="2" class="articles_frontpage">';
$row = DB_next_row($result);
echo '<div class="header2 articletitlefront"><a href="index.php?m_c=m_va&articleid=' . $row['articleid'] . '">' . stripslashes($row['title']) . '</a></div>';
echo '<div class="metatext">' . $article_author;
echo '<span class="author">: ';
if (isset($row['author_username'])) {
echo '<a href="index.php?m_c=mvp&username='******'author_username'] . '">' . stripslashes($row['author']) . '</a>';
} else {
echo stripslashes($row['author']);
}
echo '</span>';
echo ', postet <span class="date">' . make_date($row['date_posted']) . ' </span><span class="time">' . make_time($row['time_posted']) . '</span></div>';
echo '<div class="textbody">';
if (strlen($row['body']) < $chars_showing_first_article * 2) {
echo stripslashes(nl2br($row['body']));
} else {
echo closeUnclosedTags(stripslashes(substr(nl2br($row['body']), 0, $chars_showing_first_article)));
echo " ...";
$chars_left = strlen($row['body']) - $chars_showing_first_article;
}
echo '</div>';
$number_of_comments = number_of_comments($row['articleid']);
echo '<div class="showarticlelink">';
if (strlen($row['body']) < $chars_showing_first_article * 2) {
echo '<a href="index.php?m_c=m_va&articleid=' . $row['articleid'] . '">Vis artikkelside</a> ';
} else {
echo '<a href="index.php?c=' . $chars_showing_first_article . '&m_c=m_va&articleid=' . $row['articleid'] . '#continue">Les hele artikkelen <span class="notice">(' . $chars_left . ' flere tegn)</span></a> ';
}
// Give link to comments if any, else link to the commenting form
if ($number_of_comments > 0) {
echo '<a href="index.php?m_c=m_va&articleid=' . $row['articleid'] . '#comments">Les kommentarer (' . $number_of_comments . ')</a> ';
} else {
global $anyone_comments;
if ($anyone_comments || isset($_SESSION['valid_user'])) {
echo '<a href="index.php?m_c=m_va&articleid=' . $row['articleid'] . '#commentform">Skriv kommentar</a> ';
} else {
echo "<span id='loginlink'><a href=\"javascript:showDiv('loginform', 'errorandlogout')\">Logg inn og kommenter</a></span>";
}
}
echo '</div>';
echo '</td>';
echo '</tr>';
// resten av artiklene
if ($layout == "newspaper") {
$chars_showing_first_article = $chars_showing_first_article / 4;
}
for ($i = 1; $i < $num_results; $i++) {
// sjekker layout og hvilken 'side' man er på, siden man kan velge mellom 1 eller 2 kolonner.
if (!($i % 2 == 0) || $layout == "weblog") {
echo "<tr>";
if ($layout == "weblog") {
echo '<td colspan="2" class="articles_frontpage">';
} else {
echo '<td class="articles_frontpage_2column">';
}
} else {
if ($layout == "weblog") {
echo '<td colspan="2" class="articles_frontpage">';
} else {
echo '<td class="articles_frontpage_2column">';
}
}
$row = DB_next_row($result);
echo '<div class="header2 articletitlefront"><a href="index.php?m_c=m_va&articleid=' . $row['articleid'] . '">' . stripslashes($row['title']) . '</a></div>';
echo '<div class="metatext">' . $article_author;
echo '<span class="author">: ';
if (isset($row['author_username'])) {
echo '<a href="index.php?m_c=mvp&username='******'author_username'] . '">' . stripslashes($row['author']) . '</a>';
} else {
echo stripslashes($row['author']);
}
echo '</span>';
echo ', postet <span class="date">' . make_date($row['date_posted']) . ' </span><span class="time">' . make_time($row['time_posted']) . '</span></div>';
echo '<div class="textbody">';
if (strlen($row['body']) < $chars_showing_first_article * 2) {
echo stripslashes(nl2br($row['body']));
} else {
echo stripslashes(substr(nl2br($row['body']), 0, $chars_showing_first_article));
echo " ...";
$chars_left = strlen($row['body']) - $chars_showing_first_article;
}
echo '</div>';
$number_of_comments = number_of_comments($row['articleid']);
echo "<div class=\"showarticlelink\">";
if (strlen($row['body']) < $chars_showing_first_article * 2) {
echo '<a href="index.php?m_c=m_va&articleid=' . $row['articleid'] . '">Vis artikkelside</a> ';
} else {
echo '<a href="index.php?c=' . $chars_showing_first_article . '&m_c=m_va&articleid=' . $row['articleid'] . '#continue">Les hele artikkelen <span class="notice">(' . $chars_left . ' flere tegn)</span></a> ';
}
if ($number_of_comments > 0) {
echo '<a href="index.php?m_c=m_va&articleid=' . $row['articleid'] . '#comments">Les kommentarer (' . $number_of_comments . ')</a> ';
} else {
echo '<a href="index.php?m_c=m_va&articleid=' . $row['articleid'] . '#commentform">Skriv kommentar</a> ';
}
echo '</div>';
echo '</td>';
if (!($i % 2 != 0) || $layout == "weblog") {
echo "</tr>";
}
}
// slutt for-løkke
// helt til slutt, hvis antall artikler på forsiden er et partall,
// og dette ikke er weblog (en artikkel pr rad)
// vil vi bare ha en artikkel på slutten, og må huske å avslutte raden.
if ($num_results % 2 == 0 && $layout != "weblog") {
echo "</tr>";
}
}
echo "</table>";
}
$week_number = end($week_text) + 0;
print $prev_month_button;
print $next_month_button;
print_r($month_buttons);
// Initialisation
require 'scraperwiki/simple_html_dom.php';
$html_content = scraperwiki::scrape("http://etrinex.evok.ch/degresjours/Default.aspx");
$html = str_get_html($html_content);
$dates = array();
$temperatures = array();
foreach ($html->find("table#Table1 tr") as $i => $row) {
if ($i == 1) {
// row of dates (2nd row)
foreach ($row->find("td") as $j => $cell) {
if ($j > 0 && $j < 8) {
$dates[] = make_date(date_parse_from_format("d-m-Y", $cell->innertext));
//$dates[] = $cell->innertext;
}
}
}
if ($i == 7) {
// row for Fribourg data (8th row)
foreach ($row->find("td") as $j => $cell) {
if ($j > 0 && $j < 14 && $j % 2 == 1) {
if ($cell->innertext == "-") {
$temperatures[] = "";
} else {
$temperatures[] = str_replace(",", ".", $cell->innertext) + 0;
}
}
}
if ($bday_year > 0) {
$a_birthdays[intval(substr($user['userbday'], 8, 2)) - 1][] = "<a href=\"" . build_link("v_profile.php?userid={$user['userid']}") . "\">{$user['username']}</a> ({$bday_year})";
}
}
// Fetching all events...
$a_events = array();
$r_events = thwb_query("SELECT * FROM " . $pref . "calendar\n WHERE eventtime>='{$year}-{$month}-01' AND eventtime<='{$year}-{$month}-{$lastday}'\n AND eventactive='1'\n ORDER BY eventtime, eventtext");
while ($event = mysql_fetch_array($r_events)) {
$a_events[intval(substr($event['eventtime'], 8, 2)) - 1][] = $event;
}
// Creating Eventbox
$eventbox = '';
$r_calendar = mysql_query("SELECT eventid, eventtime, eventsubject FROM " . $pref . "calendar WHERE eventtime >= '{$a_current['year']}-{$a_current['month']}-{$a_current['day']}' ORDER BY eventtime LIMIT 1");
if (mysql_num_rows($r_calendar) > 0) {
$calendar = mysql_fetch_array($r_calendar);
$calendar['eventtime'] = make_date($calendar['eventtime']);
$calendar['eventsubject'] = parse_code($calendar['eventsubject']);
eval($Tcaleventbox->GetTemplate('eventbox'));
}
$boxcount = $lastday + $firstday - 1;
if ($boxcount % 7 > 0) {
$boxcount += 7 - $boxcount % 7;
}
$calendar = '<tr>';
for ($i = 1; $i <= $boxcount; $i++) {
$userbday = '';
$events = '';
if ($i < $firstday || $i >= $lastday + $firstday) {
eval($Tcalrow_empty->GetTemplate('calendar'));
} else {
$thisday = $i + 1 - $firstday;
function previewArticle($article)
{
if (!$article) {
h3("Fant ikke artikkelen.");
} else {
table_open();
tr_open();
td_open(1);
h1_link($article['title'], url_to_article($article['articleid']));
articleMetaInfo($article['author'], $article['author_username'], make_date($article['date_posted']), make_time($article['time_posted']), $article['language']);
div_open("textbody", "");
$paragraph = makeReadyForPrint(nl2br($article['body']));
echo $paragraph;
div_close();
td_close();
tr_close();
table_close();
}
}
<?php
require_once '../lib/flip.php';
session_start();
check_valid_user();
if (!is_admin()) {
display_warning('Musisz mieæ uprawnienia administratora!');
exit;
}
$readable_start = make_date($_POST['start']);
$readable_end = make_date($_POST['end']);
if (!my_check_date($_POST['start']) || !my_check_date($_POST['end'])) {
display_warning('Z³a data!');
exit;
}
$stats = get_project_stats($_POST['projects'], $readable_start, $readable_end);
display_html_header();
display_document_header();
display_menu();
echo '<table width="90%">' . "\n";
echo '<tr><td align="center" class="naglowek">Statystyki projektów od ' . $readable_start . ' do ' . $readable_end . '<hr></td></tr>';
echo '<tr><td align="center"><table cellpadding="5" cellspacing="0" border="1" bgcolor="#fefffe"><tr>';
foreach (array('Projekt', 'Telefonów', 'Spotkañ', 'Ogó³em') as $label) {
echo '<th>' . $label . '</th>';
}
echo '</tr>';
$suma_telefonow = 0;
$suma_spotkan = 0;
foreach ($stats as $project_id => $details) {
$telefon = (int) $details['telefon'];
$spotkanie = (int) $details['spotkanie'];
function list_articles($result, $num_results)
{
global $article_author;
for ($i = 0; $i < $num_results; $i++) {
echo "<tr><td colspan=2>";
$row = DB_next_row($result);
echo "<div class=\"default_header\">" . stripslashes($row['title']) . "</div><div class=\"metatext\">";
echo "<span class=\"author\">" . $article_author . ": ";
echo stripslashes($row['author']) . ' (' . $row['author_username'] . ')';
echo ',</span> <span class="time">postet ';
echo make_date($row['date_posted']) . " ";
echo make_time($row['time_posted']);
echo '</span><div> ';
echo substr(nl2br(stripslashes($row['body'])), 0, 240);
if (strlen($row['body']) > 240) {
echo "...";
}
echo '</div><div class="editarticle">';
if (isset($_SESSION['valid_user']) || isset($_SESSION['valid_admin'])) {
if ($row['author_username'] == $_SESSION['valid_user']) {
echo '<a href="index.php?articleid=' . $row['articleid'] . '&m_c=module_delete_article">Slett</a>';
echo ' <a href="index.php?articleid=' . $row['articleid'] . '&m_c=module_enter_article&edit=1">Rediger</a>';
}
}
if ($row['comment_to'] > 0) {
echo ' <a href="index.php?articleid=' . $row['comment_to'] . '&m_c=m_va">Vis artikkelen denne kommentaren tilhører</a></div>';
} else {
echo ' <a href="index.php?articleid=' . $row['articleid'] . '&m_c=m_va">Vis</a></div>';
}
echo '</td></tr>';
}
}
$sql = "UPDATE " . TMPINTER . " SET date = '" . $date . "' , am = '" . $am . "' , pm = '" . $pm . "' , intervenantid = '" . $lstagent . "',evtidam = '" . $evtam . "',evtidpm = '" . $evtpm . "' WHERE idtmpintervention='" . $id . "'";
if (!$db->query($sql)) {
message(ERROR, 'Impossible de mettre à jour la base de données', __FILE__, __LINE__, $sql);
}
$meta = '<meta http-equiv="Refresh" content="2;url=' . $_SERVER["PHP_SELF"] . '">';
$message = 'Evénement planning modifié avec succès';
$message .= '<br /><br />' . sprintf($lang['update']['retour'], '<a href="' . $_SERVER["PHP_SELF"] . '">', '</a>');
message(INFO, $message);
}
include $header;
//mode affichage du formulaire
$template->set_filenames(array('body' => 'insert_pla_body.tpl'));
// Sélection de l'enregistrement
$sql = "SELECT * FROM " . TMPINTER . "," . EVENT . "," . AGENT . " WHERE " . AGENT . ".idintervenant = " . TMPINTER . ".intervenantid AND " . EVENT . ".idevenement = " . TMPINTER . ".evenementid AND idtmpintervention = '" . $id . "' ";
if (!($result = $db->query($sql))) {
message(ERROR, 'Impossible de selectionner les dates d\'interventions', __FILE__, __LINE__, $sql);
}
if ($db->num_rows($result)) {
$row = $db->fetch_array($result);
//selection des categories
$check = $row['am'] == '1' && $row['pm'] == '0' ? 'checked' : '';
$nockeck = $row['pm'] == '1' && $row['am'] == '0' ? 'checked' : '';
$nockeck2 = $row['pm'] == '1' && $row['am'] == '1' ? 'checked' : '';
$template->assign_vars(array('L_ENTETE' => 'Modifier un événement planning', 'L_EXPLAIN' => 'Tous les champs suivis d\'une étoile sont obligatoires', 'L_AJOUT' => $lang['Button']['update'], 'L_RESET' => $lang['Button']['reset2'], 'L_DATE' => $lang['insert']['date2'], 'L_AMPM' => $lang['insert']['ampm'], 'L_AGENT' => $lang['insert']['agent'], 'L_EVENT' => $lang['insert']['event'], 'LSTAGENT' => create_list("lstagent", AGENT, 'idintervenant', 'nom', 'prenom', $row['intervenantid'], 'code'), 'LSTEVENT' => create_list("lstevent", EVENT, 'idevenement', 'libevent', '', $row['evenementid'], 'libevent'), 'DATE' => make_date($row['date'], 'date'), 'TRAITCHECK' => $check, 'TRAITNOCHECK' => $nockeck, 'TRAITNOCHECK2' => $nockeck2, 'F_ACTION' => $_SERVER["PHP_SELF"] . '?mode=update&id=' . $id, 'F_ENCTYPE' => 'enctype="multipart/form-data"'));
}
break;
}
$template->pparse('body');
include $footer;
$db->free_result();
$db->close_connexion();
$html = str_get_html($html_content);
// initialize empty array to store the data array from each row
$tabledata = array();
// loop over rows
foreach ($html->find("table#Table1 tr") as $row) {
// initialize array to store the cell data from each row
$rowdata = array();
foreach ($row->find('td') as $cell) {
// change separator and type of temperature value
// and format date
$value = str_replace(",", ".", $cell->innertext);
if (strpos($value, ".")) {
$value += 0;
} else {
if (preg_match("/\\d-\\d/", $value)) {
$value = make_date(date_parse_from_format("d-m-Y", $value));
}
}
// push the cell's text to the array
$rowdata[] = $value;
// duplicate cell if colspan present
if (isset($cell->colspan)) {
$rowdata[] = $value;
}
}
// push the row's data array to the 'big' array
$tabledata[] = $rowdata;
}
$html->__destruct();
// delete unused row 0 and 2
unset($tabledata[0]);
private function set_order_data()
{
$this->request_data['order'] = array();
$date_array = array();
//Order Details
if ($this->request_data['booking']['booking_type'] == 2) {
$this->request_data['booking']['booking_date'] = date('Y-m-d H:i:s');
$date_json = $this->request('booking_date');
$date_array = json_decode(stripcslashes($date_json));
} else {
$date_array[] = $this->request('booking_date');
}
if ($date_array) {
foreach ($date_array as $date) {
$order = array('pickup_address' => $this->request('pickup_address', true), 'requested_pickup_time' => $this->request('booking_time'), 'pickup_lat' => $this->request('pickup_lat', true), 'pickup_long' => $this->request('pickup_long', true), 'drop_address' => $this->request('drop_address', true), 'pin' => $this->request('pin', true), 'drop_lat' => $this->request('drop_lat', true), 'drop_long' => $this->request('drop_long', true), 'pickup_date' => make_date($date), 'is_flexible' => $this->request_data['booking']['pickup_type'] == 2 ? 1 : 0, 'flexible_time_id' => $this->request('flexible_timeshot'));
if ($order['is_flexible'] == 2) {
$order['flexible_time_id'] = $this->request('flexible_timeshot');
}
$this->request_data['order'][] = $order;
}
$this->request_data['booking']['no_of_order'] = count($this->request_data['order']);
}
}
