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;
}
