function irc_max_id() { return db_max(CHAT_TABLE, "id"); }
function GetNextOrder($id, $pid) { $table = content_support_table_name($this->content_id, $this->GetCatDatasetID($id), $id); return db_max($table, 'order', "`pid`={$pid}") + 1; }
function GetNextProblemLetter($contest_id) { $max = db_max('tester_tasks', 'letter', "`contest_id`={$contest_id}"); return $max + 1; }
function Categories_Add($contest_id = -1) { global $name; if (!$this->GetAllowed('CONTEST.MANAGE')) { return; } if ($contest_id < 0) { $contest_id = $_SESSION['WT_contest_id']; } $name = stripslashes($name); if (trim($name) == '') { add_info('Имя категории не может быть пустым.'); return false; } if (db_count('tester_categories', '`name`=' . db_string($name))) { add_info('Категория с таким именем уже существует.'); return false; } $order = db_max('tester_categories', 'order', '`contest_id`=' . $_SESSION['WT_contest_id']) + 1; db_insert('tester_categories', array('name' => db_string(htmlspecialchars($name)), 'contest_id' => $contest_id, 'order' => $order)); return true; }
function Editor_SavePublication($formname = '') { global $id, $uid, $redirect; if ($id == '') { $id = $this->dbids[$this->uids[$uid]]; } if (!isnumber($id)) { return; } if (!$this->GetAllowed('EDITINFO')) { return; } $r = db_row_value($this->settings['content'], '`id`=' . $id); $this->dataset->ReceiveData($formname); $cid = db_max($this->settings['content'], 'id', '`uid`=' . $uid); if ($this->CheckExistment($cid)) { if ($redirect != '') { redirect(); } return; } $arr = $this->dataset->GetFieldValues(true); $arr['uid'] = $r['uid']; $arr['order'] = $r['order']; $arr['timestamp'] = time(); $arr['user_id'] = '"' . user_id() . '"'; $arr['ip'] = '"' . get_real_ip() . '"'; db_insert($this->settings['content'], $arr); $this->dataset->FreeValues(); $this->ReceiveContent(); if ($redirect != '') { redirect(); } }
echo "<center><font color=\"red\"><b>All fields need to be entered before you can send out this newsletter</b></font></center>"; } else { if ($continue == "1") { if ($_GET[email_type] == "html") { send_newsletter($_GET[email_type], $_POST[html_subject], $_POST[html_message]); $insert = @mysql_query("INSERT INTO {$news_table} VALUES ('" . (db_max($news_table) + 1) . "', 'html', '" . $_POST[html_subject] . "', '" . $_POST[html_message] . "', '" . time() . "')"); } else { if ($_GET[email_type] == "text") { send_newsletter($_GET[email_type], $_POST[text_subject], $_POST[text_message]); $insert = @mysql_query("INSERT INTO {$news_table} VALUES ('" . (db_max($news_table) + 1) . "', 'text', '" . $_POST[text_subject] . "', '" . $_POST[text_message] . "', '" . time() . "')"); } else { if ($_GET[email_type] == "both") { send_newsletter("html", $_POST[html_subject], $_POST[html_message]); send_newsletter("text", $_POST[text_subject], $_POST[text_message]); $insert = @mysql_query("INSERT INTO {$news_table} VALUES ('" . (db_max($news_table) + 1) . "', 'html', '" . $_POST[html_subject] . "', '" . $_POST[html_message] . "', '" . time() . "')"); $insert2 = @mysql_query("INSERT INTO {$news_table} VALUES ('" . (db_max($news_table) + 1) . "', 'text', '" . $_POST[text_subject] . "', '" . $_POST[text_message] . "', '" . time() . "')"); } } } echo "<center>You successfully sent the newsletter to the following people</center>\n\t\t\t\t\t<center><table border=\"1\" width=\"50%\" cellpadding=\"3\">\n\t\t\t\t\t <tr>\n\t\t\t\t\t <td width=\"50%\"><b>HTML subscribers</b><br>"; if ($_GET[email_type] == "html" or $_GET[email_type] == "both") { $result = @mysql_query("SELECT * FROM {$users_table} WHERE email_type = 'html'"); while ($row = mysql_fetch_array($result)) { echo "" . $row[email] . "<br>\n"; } } else { if ($_GET[email_type] == "text") { echo "--No subscribers--"; } } echo "</td><td width=\"50%\"><b>Text subscribers</b><br>";
function Create() { global $manage_datafiled_denied_fieldnames; $dataset = $this->dataset; $type = $this->datatype; $title = $this->title; $field = $this->field; if (trim($title) == '' || trim($field) == '' || trim($type) == '') { return false; } if (db_count('dataset_assoc', '`dataset`="' . $this->id . '" and `title`="' . $title . '"') > 0) { add_info('Поле с таким именем уже существует в этом наборе данных.'); return false; } if (db_count('dataset_assoc', '`dataset`="' . $dataset . '" and `field`="' . $field . '"') > 0) { add_info('Поле с таким именем поля в базе данных уже ' . 'существует в этом наборе данных.'); return false; } if (!isalphanum($field)) { add_info('Название поля может содержать лишь ' . 'символы латинского алфавита и цифры.'); return false; } // Check da valide of the fieldname $valid = true; for ($i = 0; $i < count($manage_datafiled_denied_fieldnames); $i++) { if ($manage_datafiled_denied_fieldnames[$i] == $field) { $valid = false; break; } } if (!$valid) { add_info('Извините, но данное название поля является ' . 'системным и Вы не можете его использрвать.'); return false; } $title = htmlspecialchars($title); $mord = db_max('dataset_assoc', 'order', '`dataset`=' . $dataset); $ord = $mord + 1; $s = array('important' => false, 'invisible' => false); $s = addslashes(serialize($s)); db_insert('dataset_assoc', array('dataset' => '"' . $dataset . '"', 'datatype' => "\"{$type}\"", 'title' => "\"{$title}\"", 'field' => "\"{$field}\"", 'settings' => "\"{$s}\"", 'order' => $ord)); manage_datatype_refcount_inc($type); return true; }
public function testQueryBuilderAggregates() { $qb = db_max('post', 'postViews'); $this->assertEqual($qb->getSQL(), 'SELECT MAX(`postViews`) max FROM `post` `post`'); $qb = db_max('post', 'postViews', 'maxPostViews'); $this->assertEqual($qb->getSQL(), 'SELECT MAX(`postViews`) maxPostViews FROM `post` `post`'); $qb = db_min('post', 'postViews'); $this->assertEqual($qb->getSQL(), 'SELECT MIN(`postViews`) min FROM `post` `post`'); $qb = db_sum('post', 'postViews'); $this->assertEqual($qb->getSQL(), 'SELECT SUM(`postViews`) sum FROM `post` `post`'); $qb = db_avg('post', 'postViews'); $this->assertEqual($qb->getSQL(), 'SELECT AVG(`postViews`) avg FROM `post` `post`'); $qb = db_max('post', 'postViews'); $qb->min('postViews', 'min'); $this->assertEqual($qb->getSQL(), 'SELECT MAX(`postViews`) max, MIN(`postViews`) min FROM `post` `post`'); $qb = db_select('post', 'p')->max('postViews', 'max')->min('postViews', 'min'); $this->assertEqual($qb->getSQL(), 'SELECT MAX(`postViews`) max, MIN(`postViews`) min FROM `post` `p`'); }
// unsubscribe user $remove = @mysql_query("DELETE FROM {$users_table} WHERE email='" . $email . "'"); $send_msg = parse_msg($success_msg[2], $email); $headers = 'From: ' . $sender_email . '' . "\r\n" . 'Reply-To: ' . $sender_email . "\r\n"; $sender = '-f' . $sender_email . ''; mail($email, $subject[2], $send_msg, $headers, $sender); echo "<center><b>You have successfully been removed from this list</b></center>"; } } else { if ($_GET[action] == "sub") { // check existing email if (db_num($users_table, "email='{$email}'") > 0) { echo "<center><font color=\"red\"><b>This email address is already subscribed to this newsletter</b></center>"; } else { // subscribe user if (empty($_GET[email_type]) || !checkEmail($email)) { echo "<center><font color=\"red\"><b>Be sure you enter an email type (HTML/Text) and make sure your email address entered is a valid email</b></font></center>"; } else { $insert = @mysql_query("INSERT INTO {$users_table} VALUES ('" . (db_max($users_table) + 1) . "', '" . $email . "', '" . $_GET[email_type] . "', '" . time() . "')"); $send_msg = parse_msg($success_msg[1], $email); $headers = 'From: ' . $sender_email . '' . "\r\n" . 'Reply-To: ' . $sender_email . "\r\n"; $sender = '-f' . $sender_email . ''; mail($email, $subject[1], $send_msg, $headers, $sender); echo "<center>You successfully subscribed <b>" . $email . "</b> to our newsletter. Thank you for signing up.</center>"; } } } } } } }
function db_next_field($table, $field, $clause = '') { return db_max($table, $field, trim($clause) != '' ? $clause : '') + 1; }