/**
* insert a copy of the default preferences for use by real account_id
*
* @param $account_id numerical id of account for which to create the prefs
*/
public function create_defaults($account_id)
{
return;
// not longer needed, as the defaults are merged in on runtime
$this->db->query("select * from phpgw_preferences where preference_owner='-2'", __LINE__, __FILE__);
$this->db->next_record();
if ($this->db->f('preference_value')) {
$this->db->query("insert into phpgw_preferences values ('{$account_id}','" . $this->db->f('preference_value') . "')", __LINE__, __FILE__);
}
if ($GLOBALS['phpgw_info']['server']['cache_phpgw_info'] && $account_id == $GLOBALS['phpgw_info']['user']['account_id']) {
$GLOBALS['phpgw']->session->read_repositories(False);
}
}
function get_fullname($uid)
{
global $name, $prefix, $hlpdsk_prefix;
$tts = new db();
$query = "select first_name,middle_name,last_name from users where id='{$uid}'";
if ($tts->query($query)) {
$tts->next_record();
$fullname = $tts->f('last_name') . ' ';
if ($tts->f('middle_name') != '') {
$fullname .= $tts->f('middle_name') . ' ';
}
$fullname .= $tts->f('first_name');
return $fullname;
}
return '';
}
$GO_SECURITY->authenticate();
$GO_MODULES->authenticate('messages');
#require($GO_LANGUAGE->get_language_file('messages'));
$post_action = isset($_REQUEST['post_action']) ? $_REQUEST['post_action'] : '';
$task = isset($_REQUEST['task']) ? $_REQUEST['task'] : '';
$mode = isset($_REQUEST['mode']) ? $_REQUEST['mode'] : 'messages';
$receipient_id = isset($_REQUEST['receipient']) ? $_REQUEST['receipient'] : '';
$link_back = isset($_REQUEST['link_back']) && $_REQUEST['link_back'] != '' ? $_REQUEST['link_back'] : $_SERVER['REQUEST_URI'];
$db = new db();
switch ($task) {
case 'send':
if ($_REQUEST['message'] == '') {
$feedback .= 'Message is empty';
} else {
if ($receipient_id > 0) {
if ($db->query("SELECT * FROM messages_users WHERE user_id='{$receipient_id}'") && $db->next_record()) {
$has_permission = $GO_SECURITY->has_permission($GO_SECURITY->user_id, $db->f('acl_write'));
} else {
$has_permission = true;
}
if ($has_permission) {
$msg_id = $db->nextid("messages_messages");
$db->query("INSERT INTO messages_messages (id,user_id,sender_id,ctime, text) VALUES ('{$msg_id}','{$receipient_id}','{$GO_SECURITY->user_id}','" . get_gmt_time() . "','" . smart_addslashes($_REQUEST['message']) . "')");
$db->query("INSERT INTO messages_new (id) VALUES ('{$msg_id}')");
} else {
$feedback .= "You are not allowed to send message to the receipient";
}
} else {
$feedback .= 'You did not specify receipient';
}
}
$GO_MODULES->authenticate('projects');
if (!$GO_MODULES->write_permissions) {
header('Location: ' . $GO_CONFIG->host . 'error_docs/403.php');
exit;
}
require $GO_LANGUAGE->get_language_file('projects');
require $GO_THEME->theme_path . "header.inc";
$template_id = $_REQUEST['template_id'];
$task_id = $_REQUEST['task_id'];
if (isset($template_id) && isset($task_id)) {
$db = new db();
$db->query('SELECT * FROM task_template_' . $template_id . ' ORDER BY task_order');
if ($db->num_rows() > 0) {
$tasks = array();
$tasks[0] = array(0, $pm_status_begin, '');
while ($db->next_record()) {
$tasks[$db->f('task_id')] = array($db->f('task_order'), $db->f('task_name'), $db->f('task_predecessors'));
}
if ($task_id <= 0) {
$predecessors = $_REQUEST['predecessors'];
if (!isset($predecessors) || $predecessors == '') {
$task_pre_list = '';
$predecessors = array();
} else {
$task_pre_list = "'" . $predecessors . "'";
$predecessors = explode(",", $predecessors);
}
display_tasklist($tasks, '', $predecessors);
} else {
$plist = array();
$task_pre_list = $tasks[$task_id][2];
$db_child->query("SELECT * FROM ab_categories WHERE parent_id = '{$id}' ORDER BY category");
$count_child = $db_child->num_rows();
//------------------------
echo '<tr class="HiLi">';
echo '<td align="center"><b>' . $value . '</b></td>';
echo "<td colspan=\"97\" nowrap><a href='javascript:set_edit({$id}, \"{$name}\", {$parent}, {$count_child})'><b>{$name}</b></a></td>";
if ($count == 1) {
echo '<td width="36" align="center"> </a></td>';
}
$delitem = sprintf($count_child > 0 ? $ab_ConfirmDeleteStatus2 : $ab_ConfirmDeleteStatus, $name);
echo "<td><a href='javascript:delete_status(\"" . div_confirm_id($delitem) . "\"," . $id . ")'>{$trash}</a></td>";
echo '</tr>';
// echo $spliter;
if ($count_child > 0) {
$val_child = 0;
while ($db_child->next_record()) {
$val_child++;
$name = $db_child->f('category');
$id = $db_child->f('category_id');
$parent = $db_child->f('parent_id');
$delitem = sprintf($ab_ConfirmDeleteStatus, $name);
$delitem_hint = "{$strDeleteItem} '{$name}'";
echo '<tr>';
echo '<td align="center"></td>';
echo "<td colspan=\"97\" nowrap><a href='javascript:set_edit({$id}, \"{$name}\", {$value}, 0)'>" . $val_child . " {$name}</a></td>";
if ($count == 1) {
echo '<td width="36" align="center"> </a></td>';
}
echo "<td><a href='javascript:delete_status(\"" . div_confirm_id($delitem) . "\",{$id})'>{$trash}</a></td>";
echo '</tr>';
// echo $spliter;
function print_config_content($order, $ab, $page)
{
global $strSexes, $GO_USERS;
$db = new db();
for ($i = 0; $i < count($order); $i++) {
switch ($order[$i]) {
case 'email':
if ($page == 0) {
echo "<td nowrap>" . mail_to(empty_to_stripe($ab->f("email")), empty_to_stripe($ab->f("email")), 'normal', true, $ab->f("id")) . " </td>\n";
}
if ($page == 1) {
echo '<td>' . mail_to($ab->f('email'), $ab->f('email')) . '</td>';
}
if ($page == 2) {
echo "<td>" . mail_to(empty_to_stripe($GO_USERS->f("email"))) . " </td>\n";
}
break;
case 'sex':
echo '<td nowrap> ' . $strSexes[$ab->f('sex')] . ' </td>';
break;
case 'birthday':
case 'relation_date':
$day = $ab->f($order[$i]) > 0 ? db_date_to_date($ab->f($order[$i])) : '';
echo '<td nowrap> ' . empty_to_stripe($day) . ' </td>';
break;
case 'company_id':
case 'parent':
$db->query("SELECT name FROM ab_companies WHERE id = '" . (int) $ab->f($order[$i]) . "'");
echo '<td nowrap> ' . htmlspecialchars(empty_to_stripe($db->next_record() ? $db->f('name') : '')) . ' </td>';
break;
case '':
break;
default:
echo "<td nowrap> " . htmlspecialchars(empty_to_stripe($ab->f($order[$i]))) . " </td>\n";
}
}
}
Free Software Foundation; either version 2 of the License, or (at your
option) any later version.
*/
require "../../Group-Office.php";
require $GO_MODULES->path . "classes/calendar.class.inc";
$cal = new calendar();
require $GO_LANGUAGE->get_language_file('calendar');
require $GO_THEME->theme_path . 'header.inc';
echo '<table border="0" cellpadding="10" cellspacing="0"><tr><td><h1>' . $sc_decline_title . '</h1>';
if ($_REQUEST['task'] == 'submit') {
if ($_REQUEST['event_id'] > 0 && $_REQUEST['email'] != '') {
if ($cal->set_event_status($_REQUEST['event_id'], '2', $_REQUEST['email'])) {
$db = new db();
$email = $_REQUEST['email'];
$db->query("SELECT first_name, middle_name, last_name FROM users WHERE email='" . $email . "'");
if ($db->next_record()) {
$name = $db->f('last_name') . ' ' . $db->f('middle_name') . ' ' . $db->f('first_name');
}
// $db->query("SELECT u.email, c.name FROM cal_events c INNER JOIN users u ON c.user_id = u.id WHERE c.id = '".$_REQUEST['event_id']."'");
$db->query("SELECT u.email, u.date_format, u.time_format, u.DST, c.* FROM cal_events c INNER JOIN users u ON c.user_id = u.id WHERE c.id = '" . $_REQUEST['event_id'] . "'");
if ($db->next_record()) {
$mail_to = $db->f('email');
$title = $db->f('name');
require 'decline_mail.php';
require_once $GO_CONFIG->root_path . 'lib/tkdlib.php';
echo send_mail($mail_to, $mail_body, $sc_declined_mail_title, $name, $email);
echo $sc_decline_confirm;
}
}
} else {
echo $sc_bad_event;
function notify_relevant_members($project_id, $task_id, $person_id, $assigned = true)
{
global $GO_CONFIG, $php_mailer_lang;
$db = new db();
$sql = "SELECT users.* FROM" . " users LEFT JOIN users_groups ON (users.id = users_groups.user_id)" . " WHERE users_groups.group_id='" . $GO_CONFIG->group_root . "'";
if ($db->query($sql) && $db->num_rows() && $db->next_record()) {
require_once $GO_CONFIG->class_path . "phpmailer/class.phpmailer.php";
require_once $GO_CONFIG->class_path . "phpmailer/class.smtp.php";
$mail = new PHPMailer();
$mail->PluginDir = $GO_CONFIG->class_path . 'phpmailer/';
$mail->SetLanguage($php_mailer_lang, $GO_CONFIG->class_path . 'phpmailer/language/');
switch ($GO_CONFIG->mailer) {
case 'smtp':
$mail->Host = $GO_CONFIG->smtp_server;
$mail->Port = $GO_CONFIG->smtp_port;
$mail->IsSMTP();
break;
case 'qmail':
$mail->IsQmail();
break;
case 'sendmail':
$mail->IsSendmail();
break;
case 'mail':
$mail->IsMail();
break;
}
$mail->Sender = $db->f('email');
$mail->From = $db->f('email');
$mail->FromName = $GO_CONFIG->title;
$mail->AddReplyTo($db->f('email'), $GO_CONFIG->title);
$mail->WordWrap = 50;
$mail->IsHTML(true);
$db->query("SELECT * FROM task WHERE task_id=" . $task_id . " AND task_project_id=" . $project_id);
$db->next_record();
$task_name = $db->f('task_name');
$task_person_id = $db->f('task_person_id');
$task_duration = $db->f('task_time');
$db->query('SELECT * ' . 'FROM pmProjects ' . 'WHERE id="' . $project_id . '" ');
$db->next_record();
$task_url = $GO_CONFIG->full_url . 'modules/projects/project.php?task=show_task_status&project_id=' . $project_id . '&task_id=' . $task_id . '&task_status=' . (isset($status) ? $status : '');
$project_url = $GO_CONFIG->full_url . 'modules/projects/project.php?project_id=' . $project_id;
global $pm_task_status_values;
$new_status = $pm_task_status_values[$status];
$project_name = $db->f('name');
$project_description = $db->f('description');
global $subjectTaskAssigneeChanged, $mailTaskAssigneeLeft, $mailTaskAssigneeJoined;
$mail->Subject = sprintf($subjectTaskAssigneeChanged, $task_name, $project_name);
if ($assigned) {
$mail_body = sprintf($mailTaskAssigneeJoined, $project_name, $project_description, $task_name, $task_duration, $task_url);
} else {
$mail_body = sprintf($mailTaskAssigneeLeft, $project_name, $project_description, $task_name);
}
$mail->Body = $mail_body;
$mail->ClearAllRecipients();
if (isset($status) && $status == TASK_DONE) {
$db->query('SELECT users.* ' . 'FROM users,pmProjects ' . 'WHERE users.id=pmProjects.user_id ' . 'AND pmProjects.id="' . $project_id . '"');
} else {
$db->query('SELECT * ' . 'FROM users ' . 'WHERE id="' . $task_person_id . '"');
}
$db->next_record();
$mail->AddAddress($db->f('email'));
// HACK: For some reasons, admin@hptvietnam.com.vn is not accepted by mail.hptvietnam.com.vn :(
$mail->From = $db->f('email');
$mail->Sender = $db->f('email');
//if (!$mail->Send()) echo "Failed: ".$mail->ErrorInfo;
$mail->Send();
//$mail->Send();
}
}
$Ticket_Number = isset($_GET['Ticket_Number']) ? Security::htmlsecure($_GET['Ticket_Number']) : 0;
$Ticket_Number = isset($_POST['Ticket_Number']) ? Security::htmlsecure($_POST['Ticket_Number']) : $Ticket_Number;
echo '<form method="post" action="' . $_SERVER['PHP_SELF'] . '" name="ticket_form">';
echo '<input type="hidden" name="Ticket_Number" value="' . $Ticket_Number . '" />';
global $name;
$textmenu = menu("Show_Tickets", '');
eval($textmenu);
//
// take ownership
if (isset($_GET['take_ownership'])) {
$query = "select * from acl_items where id='" . Security::sqlsecure($_GET['acl_write']) . "' and description='ticket write'";
$mydb = new db($query);
if ($mydb->next_record()) {
$query = "select * from acl where acl_id='" . Security::sqlsecure($_GET['acl_write']) . "' and user_id='" . whoami() . "'";
$mydb = new db($query);
if (!$mydb->next_record()) {
$query = "insert into acl (acl_id,user_id) values ('" . Security::sqlsecure($_GET['acl_write']) . "','" . whoami() . "')";
$mydb = new db($query);
}
}
}
//
$return_to = isset($_REQUEST['return_to']) ? $_REQUEST['return_to'] : $_SERVER['HTTP_REFERER'];
$link_back = isset($_REQUEST['link_back']) ? $_REQUEST['link_back'] : $_SERVER['REQUEST_URI'];
$ticket['acl_read'] = get_cross_value("{$prefix}{$hlpdsk_prefix}_tickets", "acl_read", " where Ticket_Number='" . Security::sqlsecure($Ticket_Number) . "'");
$ticket['acl_write'] = get_cross_value("{$prefix}{$hlpdsk_prefix}_tickets", "acl_write", " where Ticket_Number='" . Security::sqlsecure($Ticket_Number) . "'");
$acl_read = $ticket['acl_read'];
$acl_write = $ticket['acl_write'];
$tabtable = new tabtable('ticket_tabtable', $tts_lang_tickets_details, '100%', '400', '120', '', true);
if ($acl_read > 0 and $acl_write > 0) {
$tabtable->add_tab('properties', $strProperties);
function update_enable($pkgs)
{
$db = new db();
$db->query("SELECT id FROM modules");
$disabled_modules = array();
while ($db->next_record()) {
if (!in_array($db->f('id'), $pkgs)) {
$disabled_modules[] = $db->f('id');
}
}
if (!empty($pkgs)) {
$db->query("UPDATE modules SET enable=1 WHERE id in ('" . implode("','", $pkgs) . "')");
}
if (!empty($disabled_modules)) {
$db->query("UPDATE modules SET enable=0 WHERE id in ('" . implode("','", $disabled_modules) . "')");
}
}
function fill_config_content($order, $ab, $page, &$row, &$irow, &$firstrun)
{
global $strSexes, $GO_USERS;
$db = new db();
for ($i = 0; $i < count($order); $i++) {
switch ($order[$i]) {
case 'email':
if ($page == 0) {
if ($firstrun) {
$row[$irow++] = array('html' => mail_to(empty_to_stripe($ab->f("email")), empty_to_stripe($ab->f("email")), 'normal', true, $ab->f("id")));
} else {
$row[$irow++]['html'] = mail_to(empty_to_stripe($ab->f("email")), empty_to_stripe($ab->f("email")), 'normal', true, $ab->f("id"));
}
}
if ($page == 1) {
if ($firstrun) {
$row[$irow++] = array('html' => mail_to($ab->f('email'), $ab->f('email')));
} else {
$row[$irow++]['html'] = mail_to($ab->f('email'), $ab->f('email'));
}
}
if ($page == 2) {
if ($firstrun) {
$row[$irow++] = array('html' => mail_to(empty_to_stripe($GO_USERS->f("email"))));
} else {
$row[$irow++]['html'] = mail_to(empty_to_stripe($GO_USERS->f("email")));
}
}
break;
case 'sex':
$row[$irow++] = $strSexes[$ab->f('sex')];
break;
case 'birthday':
case 'relation_date':
$day = $ab->f($order[$i]) > 0 ? db_date_to_date($ab->f($order[$i])) : '';
$row[$irow++] = empty_to_stripe($day);
break;
case 'company_id':
case 'parent':
$db->query("SELECT name FROM ab_companies WHERE id = '" . (int) $ab->f($order[$i]) . "'");
$row[$irow++] = empty_to_stripe($db->next_record() ? $db->f('name') : '');
break;
case '':
break;
default:
$row[$irow++] = empty_to_stripe($ab->f($order[$i]));
}
}
}
define("NOR_PP_MODE_REGISTER", 4);
define("NOR_PP_MODE_DELETE", 5);
define("NOR_PP_MODE_ACCEPT", 6);
if (!defined("MAIL_DOMAIN")) {
define("MAIL_DOMAIN", "nordita.org");
}
define("PP_UNDEFINED", "to be allocated");
define("PP_LOGTABLE", "log");
define("PP_RESERVE", "register new preprint");
core_setConfig("redirectMailsInPlaygoundMode", True);
core_setConfig("plygroundEmail", "*****@*****.**");
core_setConfig("remindingPeriod", 7 * 24 * 3600);
// a week
$NOR_modes = array(NOR_PP_MODE_UNRESERVE => array("i" => "b_drop.png", "d" => "cancel preprint reservation"), NOR_PP_MODE_EDIT => array("i" => "b_edit.png", "d" => "edit preprint data"), NOR_PP_MODE_REGISTER => array("i" => "b_tip.png", "d" => "register preprint"), NOR_PP_MODE_DELETE => array("i" => "b_drop.png", "d" => "delete preprint"), NOR_PP_MODE_ACCEPT => array("i" => "b_ok.gif", "d" => "accept preprint"));
$NOR_fields = array("all" => "All", "AP" => "Astrophysics", "CM" => "Condensed Matter", "HE" => "High Energy", "NP" => "Nuclear Physics");
if (!$dbClass) {
$dbClass = new db($dbName, $dbServer, $dbUser, $dbP);
}
$dbClass->debug = 0;
$authClass->db = $dbClass;
$PPsecretary_email = "*****@*****.**";
$time = time();
$date = getdate();
$year = $date["year"];
$nor_pp_year0 = 1995;
$nor_pp_year = $year;
$q = $dbClass->query("SELECT MIN(Year) AS year0 FROM publications");
while ($r = $dbClass->next_record($q)) {
$nor_pp_year0 = $r["year0"];
}
list($AUTH_gecos, $AUTH_login, $AUTH_uid) = $authClass->whoami();
