function scheduleNewEmail_temp($email_to, $email_content, $subject, $caldate_day, $hour, $USERNAME)
{
$manageUsers = new manageUsers();
$thisuserEmailId = $manageUsers->get_userSingleDetail($USERNAME, 'user_primaryEmail');
$delivery_ts = $caldate_day . ' ' . $hour . ':10:00';
// 'YYYY-MM-DD HH:MM:SS'
$details = array('emailby_user' => $USERNAME, 'email_to' => $email_to, 'email_content' => $email_content, 'emailby_from' => $thisuserEmailId, 'email_subject' => $subject, 'email_scheduledon' => $delivery_ts);
$success = execute_sqlInsert("scheduledmails", $details);
}
public function scheduleNewEmail($email_to, $email_content, $subject, $caldate_day, $hour)
{
$USERNAME = $_SESSION['uname'];
$manageUsers = new manageUsers();
$thisuserEmailId = $manageUsers->get_userSingleDetail($USERNAME, 'user_primaryEmail');
$delivery_ts = $caldate_day . ' ' . $hour . ':01:00';
// 'YYYY-MM-DD HH:MM:SS'
$details = array(emailby_user => $USERNAME, email_to => $email_to, email_content => $email_content, emailby_from => $thisuserEmailId, email_subject => $subject, email_scheduledon => $delivery_ts);
$success = execute_sqlInsert("scheduledmails", $details);
}
<?php
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
// date in the past
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
// always modified
header("Cache-Control: no-store, no-cache, must-revalidate");
// HTTP/1.1
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache");
// HTTP/1.0
$tmpManageUsers = new manageUsers();
$browser = $_SERVER["HTTP_USER_AGENT"];
if (strpos(strtolower($browser), 'msie') !== false) {
echo "<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01//EN\" \"http://www.w3.org/TR/html4/strict.dtd\">";
}
?>
<HTML>
<HEAD>
<TITLE><?php
echo APPNAME;
echo " - " . getVariableFromMasterSubdomainRow('clientName');
?>
</TITLE>
<script type="text/javascript" src="<?php
echo JSASSETS_URL;
?>
jquery.js"></script>
<script type="text/javascript" src="<?php
echo JSASSETS_URL;
?>
</td> </tr> </table> </div> <div style='clear:both; margin-left:auto; margin-right:auto; margin-top:25px;'> <table cellpadding=0 cellspacing=2 border=0 width='90%' align=center> <tr> <Td align=center> <b><nobr>iCal Reminders URL</nobr></b> </td> </tr> <tr> <td> <?php $tmp_manageUsers = new manageUsers(); $this_key = $tmp_manageUsers->get_userSingleDetail($username, 'remindersicalkey'); echo 'http://' . $_SESSION["subdomain"] . '.discreteevents.com/ical_reminders.php?key=' . $this_key; ?> </td> </tr> <tr> <td align='center'> <span class="bluebutton" onclick="newIcalURL()"> Generate new iCal URL </span> </td> </tr> </table> </div> <?php
if(a){
window.location.href='projects.php';
}else{
My_JsLibrary.showErrMsg() ;
}
}
});
}
};
</SCRIPT>
<?php
$manageUsers = new manageUsers();
$allusers = $manageUsers->listOfAllUsers();
$manageProjects = new manageProjects();
$allProjects = $manageProjects->listOfAllProjectsIncludeClosed();
?>
<div class="ProjectsListing">
<div style="margin-bottom: 10px;">
<span onclick="manageProjectsJsfunctions.createNewProject_form();" class='bluebutton'>Add Project</span>
</div>
<?php
foreach ($allProjects as $project) {
if ($project == DEFAULTPERSONALPROJECT) {
continue;
}
$usersInThisProject = $manageProjects->getUsersListInProject($project);
$isProjectActive = $manageProjects->isProjectActive($project);
<?php
include "../includes/config.php";
include "../includes/classes.php";
include getLanguage(null, !empty($_GET['lang']) ? $_GET['lang'] : $_COOKIE['lang'], 2);
session_start();
$db = new mysqli($CONF['host'], $CONF['user'], $CONF['pass'], $CONF['name']);
if ($db->connect_errno) {
echo "Failed to connect to MySQL: (" . $db->connect_errno . ") " . $db->connect_error;
}
$db->set_charset("utf8");
$resultSettings = $db->query(getSettings());
$settings = $resultSettings->fetch_assoc();
if (isset($_SESSION['usernameAdmin']) && isset($_SESSION['passwordAdmin'])) {
$loggedInAdmin = new loggedInAdmin();
$loggedInAdmin->db = $db;
$loggedInAdmin->url = $CONF['url'];
$loggedInAdmin->username = $_SESSION['usernameAdmin'];
$loggedInAdmin->password = $_SESSION['passwordAdmin'];
$loggedIn = $loggedInAdmin->verify();
if ($loggedIn['username']) {
if (isset($_POST['start'])) {
$manageUsers = new manageUsers();
$manageUsers->db = $db;
$manageUsers->url = $CONF['url'];
$manageUsers->per_page = $settings['uperpage'];
echo $manageUsers->getUsers($_POST['start']);
}
}
}
<li><a href="#maintasks_inprogresstasks">In Progress</a></li> <li><a href="#maintasks_completed">Completed</a></li> </ul> <ul id="scheduledtasks" title="Scheduled"> <li><a href='#scheduled_tasks'>Scheduled On Date</a></li> </ul> <?php $ureport = new taskReports(); $ureport->showOnlyMyTasks = false; //$ureport->PersonalTasks = false; $ureport->doNotIncludePersonalCondition = true; $ureport->listWorks_iPhone($DE_GLOBALS_WORK_NEW, 'maintasks_newtasks', 'New'); $ureport->listWorks_iPhone($DE_GLOBALS_WORK_PROGRESS, 'maintasks_inprogresstasks', 'InProgress'); $ureport->listWorks_iPhone($DE_GLOBALS_WORK_COMPLETED, 'maintasks_completed', 'Completed'); // $ureport_personal = new taskReports(); // $ureport_personal->showOnlyMyTasks = false; // $ureport_personal->PersonalTasks = true; // $ureport_personal->listWorks_iPhone($DE_GLOBALS_WORK_NEW, 'personal_newtasks', 'New' ); // $ureport_personal->listWorks_iPhone($DE_GLOBALS_WORK_PROGRESS, 'personal_inprogresstasks', 'InProgress'); // $ureport_personal->listWorks_iPhone($DE_GLOBALS_WORK_COMPLETED, 'personal_completed', 'Completed'); $ureport_scheduled = new taskReports(); $ureport_scheduled->showOnlyMyTasks = false; $ureport_scheduled->listWorks_iPhone($DE_GLOBALS_WORK_SCHEDULED, 'scheduled_tasks', 'Schld OnDate'); // * TODO * global $DE_GLOBALS_WORK_TASKONTASK; $manageUsers = new manageUsers(); $manageUsers->getUnreadCommentsiPhone($_SESSION["uname"]); ?> </body> </html>
<?php
include_once "include_db.php";
include_once "include_functions.php";
$uekey = @$_GET["key"];
$USERNAME = executesql_returnArray("select username from users where remindersicalkey='{$uekey}' ;");
if (!$USERNAME) {
exit;
}
$tmp_manageUsers = new manageUsers();
$actual_key = $tmp_manageUsers->get_userSingleDetail($USERNAME, 'remindersicalkey');
if (!$uekey || $uekey != $actual_key) {
exit;
}
$result = mysql_query("select * from scheduledmails where emailby_user='******' order by email_scheduledon");
$scE_Count = @mysql_num_rows($result);
?>
BEGIN:VCALENDAR
PRODID:-//CenterLimit LLC//DiscreteEvents Reminders Calendar 0.01//EN
VERSION:2.0
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:DiscreteEvents Reminders
X-WR-TIMEZONE:Asia/Calcutta
X-WR-CALDESC:DiscreteEvents Reminders for <?php
echo $USERNAME;
if ($scE_Count == 0) {
echo "\nEND:VCALENDAR";
exit;
}
while ($row = mysql_fetch_assoc($result)) {
<?php
include_once "include_db.php";
include_once "include_functions.php";
checkUserSessionandCookie();
$USERNAME = $_SESSION["uname"];
$TASKID = get_GET_var('taskid');
$manageWorks = new manageWorks();
$manageUsers = new manageUsers();
$manageProjects = new manageProjects();
$allPeers = $manageUsers->listOfAllPeerUsers($USERNAME);
$taskDetails = $manageWorks->get_workDetails($TASKID);
$taskDetails['work_briefDesc'] = $taskDetails['work_briefDesc'] ? $taskDetails['work_briefDesc'] : 'No Description';
$usersActiveProjects = $manageUsers->get_usersActiveProjects($USERNAME);
// $allProjects
// `workID`,
// `work_userAssigned`,
// `work_addedBy` ,
// `work_dateAdded` timestamp ,
// `work_deadLine` date ,
// `work_startDate` timestamp,
// `work_completeDate` timestamp,
// `work_briefDesc` text,
// `work_Notes` text,
// `work_status` '1',
// `work_priority` 'N',
// `work_projectName`,
// `work_isPrivate` 'N',
$workStatus = $taskDetails["work_status"];
switch ($workStatus) {
case $DE_GLOBALS_WORK_NEW:
<script>
var show_scheduleEmailForm = function(subj , body ){
//My_JsLibrary.showdeadcenterdiv( 'ScheduleEmail_Form' );
if(!subj){ var subj = '';}
if(!body){ var body = '';}
EDIT_SCHEDULEDEMAILID = 0 ;
<?php
$manageUsers = new manageUsers();
$username = $_SESSION["uname"];
echo "var myemail='" . $manageUsers->get_userSingleDetail($username, 'user_primaryEmail') . "';";
echo "var TomorrowCaldate='" . getTomorrowCaldate(1) . "';";
?>
$("#ScheduleEmail_Form_Title").html('Schedule a Reminder');
_$('nu_scEmail_to').value = myemail ;
_$('nu_scEmail_when').value = TomorrowCaldate ;
_$('nu_scEmail_subject').value = subj ;
_$('nu_scEmail_body').value = body ;
$('#ScheduleEmail_Form').showWithBg();
_$('nu_scEmail_subject').focus();
};
var schedule_newTask = function(){
var emailTo = My_JsLibrary.getFieldValue('nu_scEmail_to');
var emailSubject = My_JsLibrary.getFieldValue('nu_scEmail_subject');
var emailBody = My_JsLibrary.getFieldValue('nu_scEmail_body');
var emailWhen = My_JsLibrary.getFieldValue('nu_scEmail_when');
var emailHour = My_JsLibrary.getFieldValue('nu_scEmail_hr');
if( ! My_JsLibrary.checkRequiredFields( ['nu_scEmail_to', 'nu_scEmail_subject', 'nu_scEmail_when'] ) ){
function PageMain()
{
global $TMPL, $LNG, $CONF, $db, $settings;
if (isset($_POST['login'])) {
$logInAdmin = new logInAdmin();
$logInAdmin->db = $db;
$logInAdmin->url = $CONF['url'];
$logInAdmin->username = $_POST['username'];
$logInAdmin->password = $_POST['password'];
$TMPL['message'] = $logInAdmin->in();
}
if (isset($_SESSION['usernameAdmin']) && isset($_SESSION['passwordAdmin'])) {
$loggedInAdmin = new loggedInAdmin();
$loggedInAdmin->db = $db;
$loggedInAdmin->url = $CONF['url'];
$loggedInAdmin->username = $_SESSION['usernameAdmin'];
$loggedInAdmin->password = $_SESSION['passwordAdmin'];
$loggedIn = $loggedInAdmin->verify();
if ($loggedIn['username']) {
// Set the content to true, change the $skin to content
$content = true;
$TMPL_old = $TMPL;
$TMPL = array();
$TMPL['url'] = $CONF['url'];
if ($_GET['b'] == 'security') {
// Security Admin Tab
$skin = new skin('admin/security');
$page = '';
if (!empty($_POST)) {
$updateSettings = new updateSettings();
$updateSettings->db = $db;
$updated = $updateSettings->query_array('admin', $_POST);
if ($updated == 1) {
header("Location: " . $CONF['url'] . "/index.php?a=admin&b=security&m=s");
} else {
header("Location: " . $CONF['url'] . "/index.php?a=admin&b=security&m=i");
}
}
if ($_GET['m'] == 's') {
$TMPL['message'] = notificationBox('success', $LNG['password_changed']);
} elseif ($_GET['m'] == 'i') {
$TMPL['message'] = notificationBox('info', $LNG['password_not_changed']);
}
} elseif ($_GET['b'] == 'social') {
// Security Admin Tab
$skin = new skin('admin/social');
$page = '';
if (!extension_loaded('openssl')) {
$TMPL['message'] .= notificationBox('error', $LNG['openssl_error']);
}
if (!function_exists('curl_exec')) {
$TMPL['message'] .= notificationBox('info', $LNG['curl_error']);
}
$TMPL['fbappid'] = $settings['fbappid'];
$TMPL['fbappsecret'] = $settings['fbappsecret'];
if (empty($settings['fbapp'])) {
$TMPL['fbappoff'] = ' selected="selected"';
} else {
$TMPL['fbappon'] = ' selected="selected"';
}
if (!empty($_POST)) {
$updateSettings = new updateSettings();
$updateSettings->db = $db;
$updated = $updateSettings->query_array('settings', $_POST);
if ($updated == 1) {
header("Location: " . $CONF['url'] . "/index.php?a=admin&b=social&m=s");
} else {
header("Location: " . $CONF['url'] . "/index.php?a=admin&b=social&m=i");
}
}
if ($_GET['m'] == 's') {
$TMPL['message'] .= notificationBox('success', $LNG['settings_saved']);
} elseif ($_GET['m'] == 'i') {
$TMPL['message'] .= notificationBox('info', $LNG['nothing_changed']);
}
} elseif ($_GET['b'] == 'payments') {
$managePayments = new managePayments();
$managePayments->db = $db;
$managePayments->url = $CONF['url'];
$managePayments->per_page = $settings['rperpage'];
if (isset($_GET['id'])) {
$skin = new skin('admin/payment');
$page = '';
if (isset($_GET['type'])) {
$managePayments->updatePayment($_GET['id'], $_GET['type']);
}
$TMPL['content'] = $managePayments->getPayment($_GET['id']);
// If the payment doens't exist
if (empty($TMPL['content'])) {
header("Location: " . $CONF['url'] . "/index.php?a=admin&b=payments&m=i");
}
} else {
$skin = new skin('admin/manage_payments');
$page = '';
$TMPL['payments'] = $managePayments->getPayments(0);
}
if ($_GET['m'] == 'i') {
$TMPL['message'] = notificationBox('error', $LNG['payment_not_exist']);
}
} elseif ($_GET['b'] == 'pro') {
// Security Admin Tab
$skin = new skin('admin/pro');
$page = '';
if (!extension_loaded('openssl')) {
$TMPL['message'] .= notificationBox('error', $LNG['openssl_error']);
}
if (!function_exists('curl_exec')) {
$TMPL['message'] .= notificationBox('info', $LNG['curl_error']);
}
$TMPL['ppuser'] = $settings['paypaluser'];
$TMPL['pppass'] = $settings['paypalpass'];
$TMPL['ppsign'] = $settings['paypalsign'];
$TMPL['currentProMonth'] = $settings['promonth'];
$TMPL['currentProYear'] = $settings['proyear'];
if (empty($settings['paypalapp'])) {
$TMPL['ppappoff'] = ' selected="selected"';
} else {
$TMPL['ppappon'] = ' selected="selected"';
}
if (empty($settings['paypalsand'])) {
$TMPL['ppsandoff'] = ' selected="selected"';
} else {
$TMPL['ppsandon'] = ' selected="selected"';
}
if ($settings['protracksize'] == '5242880') {
$TMPL['aprotrack'] = 'selected="selected"';
} elseif ($settings['protracksize'] == '10485760') {
$TMPL['bprotrack'] = 'selected="selected"';
} elseif ($settings['protracksize'] == '26214400') {
$TMPL['cprotrack'] = 'selected="selected"';
} elseif ($settings['protracksize'] == '52428800') {
$TMPL['dprotrack'] = 'selected="selected"';
} elseif ($settings['protracksize'] == '104857600') {
$TMPL['eprotrack'] = 'selected="selected"';
} elseif ($settings['protracksize'] == '262144000') {
$TMPL['fprotrack'] = 'selected="selected"';
} elseif ($settings['protracksize'] == '524288000') {
$TMPL['gprotrack'] = 'selected="selected"';
} elseif ($settings['protracksize'] == '1073741824') {
$TMPL['hprotrack'] = 'selected="selected"';
} else {
$TMPL['iprotrack'] = 'selected="selected"';
}
if ($settings['protracktotal'] == '104857600') {
$TMPL['aprototal'] = 'selected="selected"';
} elseif ($settings['protracktotal'] == '209715200') {
$TMPL['bprototal'] = 'selected="selected"';
} elseif ($settings['protracktotal'] == '314572800') {
$TMPL['cprototal'] = 'selected="selected"';
} elseif ($settings['protracktotal'] == '524288000') {
$TMPL['dprototal'] = 'selected="selected"';
} elseif ($settings['protracktotal'] == '1073741824') {
$TMPL['eprototal'] = 'selected="selected"';
} elseif ($settings['protracktotal'] == '5368709120') {
$TMPL['fprototal'] = 'selected="selected"';
} elseif ($settings['protracktotal'] == '10737418240') {
$TMPL['gprototal'] = 'selected="selected"';
} elseif ($settings['protracktotal'] == '26843545600') {
$TMPL['hprototal'] = 'selected="selected"';
} else {
$TMPL['iprototal'] = 'selected="selected"';
}
if ($settings['tracksize'] == '5242880') {
$TMPL['atrack'] = 'selected="selected"';
} elseif ($settings['tracksize'] == '10485760') {
$TMPL['btrack'] = 'selected="selected"';
} elseif ($settings['tracksize'] == '26214400') {
$TMPL['ctrack'] = 'selected="selected"';
} elseif ($settings['tracksize'] == '52428800') {
$TMPL['dtrack'] = 'selected="selected"';
} else {
$TMPL['etrack'] = 'selected="selected"';
}
if ($settings['currency'] == 'USD') {
$TMPL['usd_currency'] = 'selected="selected"';
} elseif ($settings['currency'] == 'EUR') {
$TMPL['eur_currency'] = 'selected="selected"';
} else {
$TMPL['gbp_currency'] = 'selected="selected"';
}
if ($settings['tracksizetotal'] == '104857600') {
$TMPL['atotal'] = 'selected="selected"';
} elseif ($settings['tracksizetotal'] == '209715200') {
$TMPL['btotal'] = 'selected="selected"';
} elseif ($settings['tracksizetotal'] == '314572800') {
$TMPL['ctotal'] = 'selected="selected"';
} elseif ($settings['tracksizetotal'] == '524288000') {
$TMPL['dtotal'] = 'selected="selected"';
} else {
$TMPL['etotal'] = 'selected="selected"';
}
if (!empty($_POST)) {
$updateSettings = new updateSettings();
$updateSettings->db = $db;
$updated = $updateSettings->query_array('settings', $_POST);
if ($updated == 1) {
header("Location: " . $CONF['url'] . "/index.php?a=admin&b=pro&m=s");
} else {
header("Location: " . $CONF['url'] . "/index.php?a=admin&b=pro&m=i");
}
}
if ($_GET['m'] == 's') {
$TMPL['message'] .= notificationBox('success', $LNG['settings_saved']);
} elseif ($_GET['m'] == 'i') {
$TMPL['message'] .= notificationBox('info', $LNG['nothing_changed']);
}
} elseif ($_GET['b'] == 'stats') {
// Security Admin Tab
$skin = new skin('admin/stats');
$page = '';
list($TMPL['tracks_total'], $TMPL['tracks_public'], $TMPL['tracks_private'], $TMPL['comments_total'], $TMPL['users_today'], $TMPL['users_this_month'], $TMPL['users_last_30'], $TMPL['users_total'], $TMPL['total_reports'], $TMPL['pending_reports'], $TMPL['safe_reports'], $TMPL['deleted_reports'], $TMPL['total_tracks_reports'], $TMPL['pending_track_reports'], $TMPL['safe_track_reports'], $TMPL['deleted_track_reports'], $TMPL['total_comment_reports'], $TMPL['pending_comment_reports'], $TMPL['safe_comment_reports'], $TMPL['deleted_comment_reports'], $TMPL['total_likes'], $TMPL['likes_today'], $TMPL['likes_this_month'], $TMPL['likes_last_30'], $TMPL['total_plays'], $TMPL['plays_today'], $TMPL['plays_this_month'], $TMPL['plays_last_30'], $TMPL['total_downloads'], $TMPL['downloads_today'], $TMPL['downloads_this_month'], $TMPL['downloads_last_30'], $TMPL['total_playlists'], $TMPL['playlists_today'], $TMPL['playlists_this_month'], $TMPL['playlists_last_30'], $TMPL['total_payments'], $TMPL['payments_today'], $TMPL['payments_this_month'], $TMPL['payments_last_30'], $TMPL['total_earnings'], $TMPL['earnings_today'], $TMPL['earnings_this_month'], $TMPL['earnings_last_30']) = statistics($db, $settings['currency']);
$TMPL['currency'] = $settings['currency'];
} elseif ($_GET['b'] == 'themes') {
$skin = new skin('admin/themes');
$page = '';
$updateSettings = new updateSettings();
$updateSettings->db = $db;
$themes = $updateSettings->getThemes();
$TMPL['themes_list'] = $themes[0];
if (isset($_GET['theme'])) {
// If theme is in array
if (in_array($_GET['theme'], $themes[1])) {
$updated = $updateSettings->query_array('settings', array('theme' => $_GET['theme']));
if ($updated == 1) {
header("Location: " . $CONF['url'] . "/index.php?a=admin&b=themes&m=s");
} else {
header("Location: " . $CONF['url'] . "/index.php?a=admin&b=themes&m=i");
}
}
}
if ($_GET['m'] == 's') {
$TMPL['message'] = notificationBox('success', $LNG['theme_changed']);
} elseif ($_GET['m'] == 'i') {
$TMPL['message'] = notificationBox('error', $LNG['nothing_changed']);
}
} elseif ($_GET['b'] == 'reports') {
$manageReports = new manageReports();
$manageReports->db = $db;
$manageReports->url = $CONF['url'];
$manageReports->title = $settings['title'];
$manageReports->per_page = $settings['rperpage'];
if (ctype_digit($_GET['id'])) {
if (isset($_GET['type'])) {
// Do the manage report action
$manageReport = $manageReports->manageReport($_GET['id'], $_GET['type']);
}
$skin = new skin('admin/report');
$page = '';
$TMPL['content'] = $manageReports->getReport($_GET['id']);
// If the report doesn't exist
if (empty($TMPL['content'])) {
header("Location: " . $CONF['url'] . "/index.php?a=admin&b=reports&m=i");
}
} else {
$skin = new skin('admin/manage_reports');
$page = '';
$TMPL['reports'] = $manageReports->getReports(0);
}
if ($_GET['m'] == 'i') {
$TMPL['message'] = notificationBox('error', $LNG['report_not_exist']);
}
} elseif ($_GET['b'] == 'users_settings') {
$skin = new skin('admin/users_settings');
$page = '';
if ($settings['notificationl'] == '0') {
$TMPL['loff'] = 'selected="selected"';
} else {
$TMPL['lon'] = 'selected="selected"';
}
if ($settings['notificationc'] == '0') {
$TMPL['coff'] = 'selected="selected"';
} else {
$TMPL['con'] = 'selected="selected"';
}
if ($settings['email_comment'] == '0') {
$TMPL['ecoff'] = 'selected="selected"';
} else {
$TMPL['econ'] = 'selected="selected"';
}
if ($settings['email_like'] == '0') {
$TMPL['eloff'] = 'selected="selected"';
} else {
$TMPL['elon'] = 'selected="selected"';
}
if ($settings['email_new_friend'] == '0') {
$TMPL['enfoff'] = 'selected="selected"';
} else {
$TMPL['enfon'] = 'selected="selected"';
}
if ($settings['notificationd'] == '0') {
$TMPL['doff'] = 'selected="selected"';
} else {
$TMPL['don'] = 'selected="selected"';
}
if ($settings['notificationf'] == '0') {
$TMPL['foff'] = 'selected="selected"';
} else {
$TMPL['fon'] = 'selected="selected"';
}
if ($settings['ronline'] == '3') {
$TMPL['uone'] = 'selected="selected"';
} elseif ($settings['ronline'] == '7') {
$TMPL['utwo'] = 'selected="selected"';
} else {
$TMPL['uthree'] = 'selected="selected"';
}
if ($settings['nperwidget'] == '5') {
$TMPL['none'] = 'selected="selected"';
} elseif ($settings['nperwidget'] == '10') {
$TMPL['ntwo'] = 'selected="selected"';
} elseif ($settings['nperwidget'] == '20') {
$TMPL['nthree'] = 'selected="selected"';
} else {
$TMPL['nfour'] = 'selected="selected"';
}
if ($settings['lperpost'] == '5') {
$TMPL['likeson'] = 'selected="selected"';
} else {
$TMPL['likesoff'] = 'selected="selected"';
}
if (!empty($_POST)) {
$updateSettings = new updateSettings();
$updateSettings->db = $db;
$updated = $updateSettings->query_array('settings', $_POST);
if ($updated == 1) {
header("Location: " . $CONF['url'] . "/index.php?a=admin&b=users_settings&m=s");
} else {
header("Location: " . $CONF['url'] . "/index.php?a=admin&b=users_settings&m=i");
}
}
if ($_GET['m'] == 's') {
$TMPL['message'] = notificationBox('success', $LNG['settings_saved']);
} elseif ($_GET['m'] == 'i') {
$TMPL['message'] = notificationBox('info', $LNG['nothing_changed']);
}
} elseif ($_GET['b'] == 'users') {
$manageUsers = new manageUsers();
$manageUsers->db = $db;
$manageUsers->url = $CONF['url'];
$manageUsers->title = $settings['title'];
$manageUsers->per_page = $settings['rperpage'];
if (!isset($_GET['id']) && !isset($_GET['idu'])) {
$skin = new skin('admin/manage_users');
$page = '';
// Save the array returned into a list
$TMPL['users'] = $manageUsers->getUsers(0);
} else {
$skin = new skin('admin/user');
$page = '';
$getUser = $manageUsers->getUser($_GET['id'], $_GET['idu']);
if (!$getUser) {
header("Location: " . $CONF['url'] . "/index.php?a=admin&b=users&m=un");
}
// Create the class instance
$updateUserSettings = new updateUserSettings();
$updateUserSettings->db = $db;
$updateUserSettings->id = $getUser['idu'];
if (!empty($_POST)) {
$TMPL['message'] = $updateUserSettings->query_array('users', array_map("strip_tags_array", $_POST));
}
$userSettings = $updateUserSettings->getSettings();
$TMPL['countries'] = countries(1, $userSettings['country']);
$TMPL['username'] = $userSettings['username'];
$TMPL['idu'] = $userSettings['idu'];
$TMPL['currentFirstName'] = $userSettings['first_name'];
$TMPL['currentLastName'] = $userSettings['last_name'];
$TMPL['currentEmail'] = $userSettings['email'];
$TMPL['currentCity'] = $userSettings['city'];
$TMPL['currentWebsite'] = $userSettings['website'];
$TMPL['currentDescription'] = $userSettings['description'];
$TMPL['currentFacebook'] = $userSettings['facebook'];
$TMPL['currentTwitter'] = $userSettings['twitter'];
$TMPL['currentGplus'] = $userSettings['gplus'];
$TMPL['currentYouTube'] = $userSettings['youtube'];
$TMPL['currentSoundCloud'] = $userSettings['soundcloud'];
$TMPL['currentLastfm'] = $userSettings['lastfm'];
$TMPL['currentMySpace'] = $userSettings['myspace'];
$TMPL['currentVimeo'] = $userSettings['vimeo'];
$TMPL['currentTumblr'] = $userSettings['tumblr'];
$feed = new feed();
$feed->db = $db;
$feed->id = $updateUserSettings->id;
$manageReports = new manageReports();
$manageReports->db = $db;
$manageReports->url = $CONF['url'];
$manageReports->per_page = $settings['rperpage'];
if (isset($_GET['suspend'])) {
$manageUsers->suspendUser($feed->id, $_GET['suspend']);
}
$user = $manageUsers->getUser($getUser['idu']);
$TMPL['username'] = '******' . $CONF['url'] . '/index.php?a=profile&u=' . $user['username'] . '" target="_blank"><img src="' . $CONF['url'] . '/thumb.php?src=' . $user['image'] . '&t=a&w=112&h=112"></a></div>
<div class="manage-users-content"><a href="' . $CONF['url'] . '/index.php?a=profile&u=' . $user['username'] . '" target="_blank">' . $user['username'] . '</a><br>' . $user['email'] . '</div>';
$TMPL['reports'] = $manageReports->getReports(0, $feed->getTrackList($feed->id) ? $feed->getTrackList($feed->id) : 1);
if (empty($TMPL['reports'])) {
$TMPL['hide_r'] = ' style="display: none;"';
}
// If the user has payments history
$managePayments = new managePayments();
$managePayments->db = $db;
$managePayments->url = $CONF['url'];
$managePayments->per_page = $settings['rperpage'];
$TMPL['history'] = $managePayments->getPayments(0, $updateUserSettings->id);
if (empty($TMPL['history'])) {
$TMPL['hide_p'] = ' style="display: none;"';
}
// Suspend variable for the suspend url
$TMPL['suspend'] = $user['suspended'] ? '0' : '1';
$TMPL['status_desc'] = $user['suspended'] ? $LNG['restore_account'] : $LNG['suspend_account'];
$TMPL['status'] = $user['suspended'] ? notificationBox('error', $LNG['account_suspended']) : '';
if ($user['suspended']) {
$TMPL['suspended'] = $LNG['restore'];
} else {
$TMPL['suspended'] = $LNG['suspend'];
}
}
// If GET delete is set, delete the user
if ($_GET['delete']) {
$manageUsers->deleteUser($_GET['delete']);
header("Location: " . $CONF['url'] . "/index.php?a=admin&b=users&m=" . $_GET['delete']);
}
if ($_GET['m'] == 'un') {
$TMPL['message'] = notificationBox('error', $LNG['user_not_exist']);
} elseif (!empty($_GET['m'])) {
$TMPL['message'] = notificationBox('success', sprintf($LNG['user_has_been_deleted'], $_GET['m']));
}
} elseif ($_GET['b'] == 'categories') {
$manageCategories = new manageCategories();
$manageCategories->db = $db;
$manageCategories->url = $CONF['url'];
$skin = new skin('admin/manage_categories');
$page = '';
$TMPL['categories'] = $manageCategories->getCategories();
} elseif ($_GET['b'] == 'ads') {
$skin = new skin('admin/manage_ads');
$page = '';
$TMPL['ad1'] = $settings['ad1'];
$TMPL['ad2'] = $settings['ad2'];
$TMPL['ad3'] = $settings['ad3'];
$TMPL['ad4'] = $settings['ad4'];
$TMPL['ad5'] = $settings['ad5'];
$TMPL['ad6'] = $settings['ad6'];
$TMPL['ad7'] = $settings['ad7'];
if (!empty($_POST)) {
// Unset the submit array element
$updateSettings = new updateSettings();
$updateSettings->db = $db;
$updated = $updateSettings->query_array('settings', $_POST);
if ($updated == 1) {
header("Location: " . $CONF['url'] . "/index.php?a=admin&b=ads&m=s");
} else {
header("Location: " . $CONF['url'] . "/index.php?a=admin&b=ads&m=i");
}
}
if ($_GET['m'] == 's') {
$TMPL['message'] = notificationBox('success', $LNG['settings_saved']);
} elseif ($_GET['m'] == 'i') {
$TMPL['message'] = notificationBox('info', $LNG['nothing_changed']);
}
} else {
$skin = new skin('admin/general');
$page = '';
$TMPL['currentTitle'] = $settings['title'];
$TMPL['currentFormat'] = $settings['format'];
$TMPL['currentArtFormat'] = $settings['artformat'];
$TMPL['currentTrackFormat'] = $settings['trackformat'];
if ($settings['captcha'] == '1') {
$TMPL['on'] = 'selected="selected"';
} else {
$TMPL['off'] = 'selected="selected"';
}
if ($settings['time'] == '0') {
$TMPL['one'] = 'selected="selected"';
} elseif ($settings['time'] == '1') {
$TMPL['two'] = 'selected="selected"';
} elseif ($settings['time'] == '2') {
$TMPL['three'] = 'selected="selected"';
} else {
$TMPL['four'] = 'selected="selected"';
}
if ($settings['volume'] == '0.20') {
$TMPL['vtwenty'] = 'selected="selected"';
} elseif ($settings['volume'] == '0.40') {
$TMPL['vfourty'] = 'selected="selected"';
} elseif ($settings['volume'] == '0.60') {
$TMPL['vsixty'] = 'selected="selected"';
} elseif ($settings['volume'] == '0.80') {
$TMPL['veighty'] = 'selected="selected"';
} elseif ($settings['volume'] == '1') {
$TMPL['vhundred'] = 'selected="selected"';
}
if ($settings['conline'] == '60') {
$TMPL['conone'] = 'selected="selected"';
} elseif ($settings['conline'] == '300') {
$TMPL['contwo'] = 'selected="selected"';
} else {
$TMPL['conthree'] = 'selected="selected"';
}
if ($settings['perpage'] == '10') {
$TMPL['ten'] = 'selected="selected"';
} elseif ($settings['perpage'] == '20') {
$TMPL['twenty'] = 'selected="selected"';
} elseif ($settings['perpage'] == '35') {
$TMPL['thirtyfive'] = 'selected="selected"';
} else {
$TMPL['fifty'] = 'selected="selected"';
}
if ($settings['nperpage'] == '10') {
$TMPL['nten'] = 'selected="selected"';
} elseif ($settings['nperpage'] == '25') {
$TMPL['ntwentyfive'] = 'selected="selected"';
} elseif ($settings['nperpage'] == '50') {
$TMPL['nfifty'] = 'selected="selected"';
} else {
$TMPL['nonehundred'] = 'selected="selected"';
}
if ($settings['mperpage'] == '5') {
$TMPL['mone'] = 'selected="selected"';
} elseif ($settings['mperpage'] == '10') {
$TMPL['mtwo'] = 'selected="selected"';
} elseif ($settings['mperpage'] == '25') {
$TMPL['mthree'] = 'selected="selected"';
} else {
$TMPL['mfour'] = 'selected="selected"';
}
if ($settings['mlimit'] == '500') {
$TMPL['cone'] = 'selected="selected"';
} elseif ($settings['mlimit'] == '1000') {
$TMPL['ctwo'] = 'selected="selected"';
} elseif ($settings['mlimit'] == '2500') {
$TMPL['cthree'] = 'selected="selected"';
} else {
$TMPL['cfour'] = 'selected="selected"';
}
if ($settings['chatr'] == '1') {
$TMPL['crone'] = 'selected="selected"';
} elseif ($settings['chatr'] == '2') {
$TMPL['crtwo'] = 'selected="selected"';
} elseif ($settings['chatr'] == '3') {
$TMPL['crthree'] = 'selected="selected"';
} elseif ($settings['chatr'] == '5') {
$TMPL['crfive'] = 'selected="selected"';
} elseif ($settings['chatr'] == '10') {
$TMPL['crten'] = 'selected="selected"';
} elseif ($settings['chatr'] == '30') {
$TMPL['crthirty'] = 'selected="selected"';
} else {
$TMPL['croff'] = 'selected="selected"';
}
if ($settings['qperpage'] == '10') {
$TMPL['qten'] = 'selected="selected"';
} elseif ($settings['qperpage'] == '20') {
$TMPL['qtwenty'] = 'selected="selected"';
} elseif ($settings['qperpage'] == '35') {
$TMPL['qthirtyfive'] = 'selected="selected"';
} else {
$TMPL['qfifty'] = 'selected="selected"';
}
if ($settings['cperpage'] == '5') {
$TMPL['cfive'] = 'selected="selected"';
} elseif ($settings['cperpage'] == '10') {
$TMPL['cten'] = 'selected="selected"';
} elseif ($settings['cperpage'] == '25') {
$TMPL['ctwentyfive'] = 'selected="selected"';
} else {
$TMPL['cfifty'] = 'selected="selected"';
}
if ($settings['size'] == '1048576') {
$TMPL['onemb'] = 'selected="selected"';
} elseif ($settings['size'] == '2097152') {
$TMPL['twomb'] = 'selected="selected"';
} elseif ($settings['size'] == '3145728') {
$TMPL['threemb'] = 'selected="selected"';
} else {
$TMPL['tenmb'] = 'selected="selected"';
}
if ($settings['mail'] == '1') {
$TMPL['mailon'] = 'selected="selected"';
} else {
$TMPL['mailoff'] = 'selected="selected"';
}
if ($settings['intervaln'] == '10000') {
$TMPL['intonen'] = 'selected="selected"';
} elseif ($settings['intervaln'] == '30000') {
$TMPL['inttwon'] = 'selected="selected"';
} elseif ($settings['intervaln'] == '60000') {
$TMPL['intthreen'] = 'selected="selected"';
} elseif ($settings['intervaln'] == '120000') {
$TMPL['intfourn'] = 'selected="selected"';
} elseif ($settings['intervaln'] == '300000') {
$TMPL['intfiven'] = 'selected="selected"';
} elseif ($settings['intervaln'] == '600000') {
$TMPL['intsixn'] = 'selected="selected"';
} else {
$TMPL['intsevenn'] = 'selected="selected"';
}
if ($settings['artsize'] == '1048576') {
$TMPL['aart'] = 'selected="selected"';
} elseif ($settings['artsize'] == '2097152') {
$TMPL['bart'] = 'selected="selected"';
} elseif ($settings['artsize'] == '3145728') {
$TMPL['cart'] = 'selected="selected"';
} else {
$TMPL['dart'] = 'selected="selected"';
}
if ($settings['rperpage'] == '10') {
$TMPL['rpone'] = 'selected="selected"';
} elseif ($settings['rperpage'] == '20') {
$TMPL['rptwo'] = 'selected="selected"';
} elseif ($settings['rperpage'] == '50') {
$TMPL['rpthree'] = 'selected="selected"';
} else {
$TMPL['rpfour'] = 'selected="selected"';
}
if ($settings['sperpage'] == '10') {
$TMPL['sone'] = 'selected="selected"';
} elseif ($settings['sperpage'] == '20') {
$TMPL['stwo'] = 'selected="selected"';
} elseif ($settings['sperpage'] == '35') {
$TMPL['sthree'] = 'selected="selected"';
} else {
$TMPL['sfour'] = 'selected="selected"';
}
if ($settings['aperip'] == '1') {
$TMPL['ipone'] = 'selected="selected"';
} elseif ($settings['aperip'] == '3') {
$TMPL['iptwo'] = 'selected="selected"';
} elseif ($settings['aperip'] == '5') {
$TMPL['ipthree'] = 'selected="selected"';
} elseif ($settings['aperip'] == '10') {
$TMPL['ipfour'] = 'selected="selected"';
} else {
$TMPL['ipoff'] = 'selected="selected"';
}
if (isset($_POST['submit'])) {
// Unset the submit array element
unset($_POST['submit']);
$updateSettings = new updateSettings();
$updateSettings->db = $db;
$updated = $updateSettings->query_array('settings', $_POST);
if ($updated == 1) {
header("Location: " . $CONF['url'] . "/index.php?a=admin&m=s");
} else {
header("Location: " . $CONF['url'] . "/index.php?a=admin&m=i");
}
}
if ($_GET['m'] == 's') {
$TMPL['message'] = notificationBox('success', $LNG['settings_saved']);
} elseif ($_GET['m'] == 'i') {
$TMPL['message'] = notificationBox('info', $LNG['nothing_changed']);
}
}
$page .= $skin->make();
$TMPL = $TMPL_old;
unset($TMPL_old);
$TMPL['settings'] = $page;
if (isset($_GET['logout']) == 1) {
$loggedInAdmin->logOut();
header("Location: " . $CONF['url'] . "/index.php?a=admin");
}
} else {
// Set the content to false, change the $skin to log-in.
$content = false;
}
}
// Bold the current link
if (isset($_GET['b'])) {
$LNG["admin_menu_{$_GET['b']}"] = $LNG["admin_menu_{$_GET['b']}"];
$TMPL['welcome'] = $LNG["admin_ttl_{$_GET['b']}"];
} else {
$LNG["admin_menu_general"] = $LNG["admin_menu_general"];
$TMPL['welcome'] = $LNG["admin_ttl_general"];
}
function adminMenuCounts($db, $type)
{
// Type 0: Return the reports number
if ($type == 0) {
$query = $db->query('SELECT COUNT(`id`) as `count` FROM `reports` WHERE `state` = 0');
}
$result = $query->fetch_assoc();
return $result['count'];
}
$adminMenu = array('' => array('admin_menu_general', ''), '&b=users_settings' => array('admin_menu_users_settings', ''), '&b=pro' => array('admin_menu_pro', ''), '&b=social' => array('admin_menu_social', ''), '&b=themes' => array('admin_menu_themes', ''), '&b=stats' => array('admin_menu_stats', ''), '&b=security' => array('admin_menu_security', ''), '&b=users' => array('admin_menu_manage_users', ''), '&b=payments' => array('admin_menu_manage_payments', ''), '&b=reports' => array('admin_menu_manage_reports', adminMenuCounts($db, 0)), '&b=categories' => array('admin_menu_manage_categories', ''), '&b=ads' => array('admin_menu_manage_ads', ''), '&logout=1' => array('admin_menu_logout', ''));
foreach ($adminMenu as $link => $title) {
if ($link == '&b=' . $_GET['b'] || $link == $_GET['b']) {
$TMPL['admin_menu'] .= '<strong>';
$ttl = $LNG[$title[0]];
}
$TMPL['admin_menu'] .= '<a href="' . $CONF['url'] . '/index.php?a=admin' . $link . '" ' . ($title[0] == 'admin_menu_logout' ? '' : 'rel="loadpage"') . '>' . $LNG[$title[0]] . ' ' . ($title[1] ? '<span class="admin-notifications-number">' . $title[1] . '</span>' : '') . '</a>';
if ($link == '&b=' . $_GET['b'] || $link == $_GET['b']) {
$TMPL['admin_menu'] .= '</strong>';
}
}
$TMPL['url'] = $CONF['url'];
$TMPL['title'] = $LNG['title_admin'] . ' - ' . ($loggedIn['username'] ? $ttl : $LNG['login']) . ' - ' . $settings['title'];
if ($content) {
$skin = new skin('admin/content');
} else {
$skin = new skin('admin/login');
}
return $skin->make();
}
function PageMain()
{
global $TMPL, $LNG, $CONF, $db, $settings;
if (isset($_POST['login'])) {
$logInAdmin = new logInAdmin();
$logInAdmin->db = $db;
$logInAdmin->url = $CONF['url'];
$logInAdmin->username = $_POST['username'];
$logInAdmin->password = $_POST['password'];
$TMPL['message'] = $logInAdmin->in();
}
if (isset($_SESSION['usernameAdmin']) && isset($_SESSION['passwordAdmin'])) {
$loggedInAdmin = new loggedInAdmin();
$loggedInAdmin->db = $db;
$loggedInAdmin->url = $CONF['url'];
$loggedInAdmin->username = $_SESSION['usernameAdmin'];
$loggedInAdmin->password = $_SESSION['passwordAdmin'];
$loggedIn = $loggedInAdmin->verify();
if ($loggedIn['username']) {
// Set the content to true, change the $skin to content
$content = true;
$TMPL_old = $TMPL;
$TMPL = array();
$TMPL['url'] = $CONF['url'];
if ($_GET['b'] == 'security') {
// Security Admin Tab
$skin = new skin('admin/security');
$page = '';
if (!empty($_POST)) {
$updateSettings = new updateSettings();
$updateSettings->db = $db;
$updated = $updateSettings->query_array('admin', $_POST);
if ($updated == 1) {
header("Location: " . $CONF['url'] . "/index.php?a=admin&b=security&m=s");
} else {
header("Location: " . $CONF['url'] . "/index.php?a=admin&b=security&m=i");
}
}
if ($_GET['m'] == 's') {
$TMPL['message'] = notificationBox('success', $LNG['password_changed'], $LNG['password_success_changed']);
} elseif ($_GET['m'] == 'i') {
$TMPL['message'] = notificationBox('info', $LNG['nothing_changed'], $LNG['password_not_changed']);
}
} elseif ($_GET['b'] == 'stats') {
// Security Admin Tab
$skin = new skin('admin/stats');
$page = '';
list($TMPL['messages_total'], $TMPL['messages_public'], $TMPL['messages_private'], $TMPL['comments_total'], $TMPL['users_today'], $TMPL['users_this_month'], $TMPL['users_last_30'], $TMPL['users_total'], $TMPL['total_reports'], $TMPL['pending_reports'], $TMPL['safe_reports'], $TMPL['deleted_reports'], $TMPL['total_message_reports'], $TMPL['pending_message_reports'], $TMPL['safe_message_reports'], $TMPL['deleted_message_reports'], $TMPL['total_comment_reports'], $TMPL['pending_comment_reports'], $TMPL['safe_comment_reports'], $TMPL['deleted_comment_reports'], $TMPL['total_likes'], $TMPL['likes_today'], $TMPL['likes_this_month'], $TMPL['likes_last_30']) = users_stats($db);
} elseif ($_GET['b'] == 'manage_reports') {
$skin = new skin('admin/manage_reports');
$page = '';
$manageReports = new manageReports();
$manageReports->db = $db;
$manageReports->url = $CONF['url'];
$manageReports->per_page = $settings['rperpage'];
// Save the array returned into a list
$TMPL['reports'] = $manageReports->getReports(0);
} elseif ($_GET['b'] == 'users_settings') {
$skin = new skin('admin/users_settings');
$page = '';
if ($settings['mprivacy'] == '1') {
$TMPL['pon'] = 'selected="selected"';
} else {
$TMPL['poff'] = 'selected="selected"';
}
if ($settings['notificationl'] == '0') {
$TMPL['loff'] = 'selected="selected"';
} else {
$TMPL['lon'] = 'selected="selected"';
}
if ($settings['notificationc'] == '0') {
$TMPL['coff'] = 'selected="selected"';
} else {
$TMPL['con'] = 'selected="selected"';
}
if ($settings['sound_new_notification'] == '0') {
$TMPL['snnoff'] = 'selected="selected"';
} else {
$TMPL['snnon'] = 'selected="selected"';
}
if ($settings['sound_new_chat'] == '0') {
$TMPL['sncoff'] = 'selected="selected"';
} else {
$TMPL['sncon'] = 'selected="selected"';
}
if ($settings['email_comment'] == '0') {
$TMPL['ecoff'] = 'selected="selected"';
} else {
$TMPL['econ'] = 'selected="selected"';
}
if ($settings['email_like'] == '0') {
$TMPL['eloff'] = 'selected="selected"';
} else {
$TMPL['elon'] = 'selected="selected"';
}
if ($settings['email_new_friend'] == '0') {
$TMPL['enfoff'] = 'selected="selected"';
} else {
$TMPL['enfon'] = 'selected="selected"';
}
if ($settings['notifications'] == '0') {
$TMPL['soff'] = 'selected="selected"';
} else {
$TMPL['son'] = 'selected="selected"';
}
if ($settings['notificationd'] == '0') {
$TMPL['doff'] = 'selected="selected"';
} else {
$TMPL['don'] = 'selected="selected"';
}
if ($settings['notificationf'] == '0') {
$TMPL['foff'] = 'selected="selected"';
} else {
$TMPL['fon'] = 'selected="selected"';
}
if ($settings['ilimit'] == '1') {
$TMPL['ione'] = 'selected="selected"';
} elseif ($settings['ilimit'] == '3') {
$TMPL['ithree'] = 'selected="selected"';
} elseif ($settings['ilimit'] == '6') {
$TMPL['isix'] = 'selected="selected"';
} else {
$TMPL['inine'] = 'selected="selected"';
}
if ($settings['ronline'] == '5') {
$TMPL['uone'] = 'selected="selected"';
} elseif ($settings['ronline'] == '10') {
$TMPL['utwo'] = 'selected="selected"';
} else {
$TMPL['uthree'] = 'selected="selected"';
}
if ($settings['nperwidget'] == '5') {
$TMPL['none'] = 'selected="selected"';
} elseif ($settings['nperwidget'] == '10') {
$TMPL['ntwo'] = 'selected="selected"';
} elseif ($settings['nperwidget'] == '20') {
$TMPL['nthree'] = 'selected="selected"';
} else {
$TMPL['nfour'] = 'selected="selected"';
}
if ($settings['lperpost'] == '3') {
$TMPL['likesone'] = 'selected="selected"';
} elseif ($settings['lperpost'] == '5') {
$TMPL['likestwo'] = 'selected="selected"';
} else {
$TMPL['likesnone'] = 'selected="selected"';
}
if ($settings['verified'] == 0) {
$TMPL['off_v'] = 'selected="selected"';
} else {
$TMPL['on_v'] = 'selected="selected"';
}
if (!empty($_POST)) {
$updateSettings = new updateSettings();
$updateSettings->db = $db;
$updated = $updateSettings->query_array('settings', $_POST);
if ($updated == 1) {
header("Location: " . $CONF['url'] . "/index.php?a=admin&b=users_settings&m=s");
} else {
header("Location: " . $CONF['url'] . "/index.php?a=admin&b=users_settings&m=i");
}
}
if ($_GET['m'] == 's') {
$TMPL['message'] = notificationBox('success', $LNG['settings_saved'], $LNG['general_settings_saved']);
} elseif ($_GET['m'] == 'i') {
$TMPL['message'] = notificationBox('info', $LNG['nothing_saved'], $LNG['general_settings_unaffected']);
}
} elseif ($_GET['b'] == 'users') {
$manageUsers = new manageUsers();
$manageUsers->db = $db;
$manageUsers->url = $CONF['url'];
$manageUsers->per_page = $settings['uperpage'];
if (!isset($_GET['e'])) {
$skin = new skin('admin/manage_users');
$page = '';
// Save the array returned into a list
$TMPL['users'] = $manageUsers->getUsers(0);
} else {
$skin = new skin('admin/edit_users');
$page = '';
$getUser = $manageUsers->getUser($_GET['e'], $_GET['ef']);
if (!$getUser) {
header("Location: " . $CONF['url'] . "/index.php?a=admin&b=users&m=un");
}
// Create the class instance
$updateUserSettings = new updateUserSettings();
$updateUserSettings->db = $db;
$updateUserSettings->id = $getUser['idu'];
if (!empty($_POST)) {
$TMPL['message'] = $updateUserSettings->query_array('users', array_map("strip_tags_array", $_POST));
}
$userSettings = $updateUserSettings->getSettings();
$date = explode('-', $userSettings['born']);
$TMPL['years'] = generateDateForm(0, $date[0]);
$TMPL['months'] = generateDateForm(1, $date[1]);
$TMPL['days'] = generateDateForm(2, $date[2]);
$TMPL['username'] = $userSettings['username'];
$TMPL['idu'] = $userSettings['idu'];
$TMPL['currentFirstName'] = $userSettings['first_name'];
$TMPL['currentLastName'] = $userSettings['last_name'];
$TMPL['currentEmail'] = $userSettings['email'];
$TMPL['currentLocation'] = $userSettings['location'];
$TMPL['currentWebsite'] = $userSettings['website'];
$TMPL['currentBio'] = $userSettings['bio'];
$TMPL['currentFacebook'] = $userSettings['facebook'];
$TMPL['currentTwitter'] = $userSettings['twitter'];
$TMPL['currentGplus'] = $userSettings['gplus'];
if ($userSettings['verified'] == 0) {
$TMPL['off_v'] = 'selected="selected"';
} else {
$TMPL['on_v'] = 'selected="selected"';
}
}
// If GET delete is set, delete the user
if ($_GET['delete']) {
$manageUsers->deleteUser($_GET['delete']);
header("Location: " . $CONF['url'] . "/index.php?a=admin&b=users&m=" . $_GET['delete']);
}
if ($_GET['m'] == 'un') {
$TMPL['message'] = notificationBox('error', $LNG['error'], $LNG['user_not_exist']);
} elseif (!empty($_GET['m'])) {
$TMPL['message'] = notificationBox('success', $LNG['user_deleted'], sprintf($LNG['user_has_been_deleted'], $_GET['m']));
}
} elseif ($_GET['b'] == 'manage_notices') {
$skin = new skin('admin/manage_notices');
$page = '';
$TMPL['ad1'] = stripslashes($settings['ad1']);
$TMPL['ad2'] = stripslashes($settings['ad2']);
$TMPL['ad3'] = stripslashes($settings['ad3']);
$TMPL['ad4'] = stripslashes($settings['ad4']);
$TMPL['ad5'] = stripslashes($settings['ad5']);
$TMPL['ad6'] = stripslashes($settings['ad6']);
$TMPL['ad7'] = stripslashes($settings['ad7']);
if (!empty($_POST)) {
// Unset the submit array element
$updateSettings = new updateSettings();
$updateSettings->db = $db;
$updated = $updateSettings->query_array('settings', $_POST);
if ($updated == 1) {
header("Location: " . $CONF['url'] . "/index.php?a=admin&b=manage_notices&m=s");
} else {
header("Location: " . $CONF['url'] . "/index.php?a=admin&b=manage_notices&m=i");
}
}
} else {
$skin = new skin('admin/general');
$page = '';
$TMPL['currentTitle'] = $settings['title'];
$TMPL['currentFormat'] = $settings['format'];
$TMPL['currentCensor'] = $settings['censor'];
$TMPL['currentFormatMsg'] = $settings['formatmsg'];
if ($settings['captcha'] == '1') {
$TMPL['on'] = 'selected="selected"';
} else {
$TMPL['off'] = 'selected="selected"';
}
if ($settings['smiles'] == '1') {
$TMPL['son'] = 'selected="selected"';
} else {
$TMPL['soff'] = 'selected="selected"';
}
if ($settings['time'] == '0') {
$TMPL['one'] = 'selected="selected"';
} elseif ($settings['time'] == '1') {
$TMPL['two'] = 'selected="selected"';
} elseif ($settings['time'] == '2') {
$TMPL['three'] = 'selected="selected"';
} else {
$TMPL['four'] = 'selected="selected"';
}
if ($settings['conline'] == '60') {
$TMPL['conone'] = 'selected="selected"';
} elseif ($settings['conline'] == '300') {
$TMPL['contwo'] = 'selected="selected"';
} else {
$TMPL['conthree'] = 'selected="selected"';
}
if ($settings['perpage'] == '10') {
$TMPL['ten'] = 'selected="selected"';
} elseif ($settings['perpage'] == '20') {
$TMPL['twenty'] = 'selected="selected"';
} elseif ($settings['perpage'] == '25') {
$TMPL['twentyfive'] = 'selected="selected"';
} else {
$TMPL['fifty'] = 'selected="selected"';
}
if ($settings['nperpage'] == '10') {
$TMPL['nten'] = 'selected="selected"';
} elseif ($settings['nperpage'] == '25') {
$TMPL['ntwentyfive'] = 'selected="selected"';
} elseif ($settings['nperpage'] == '50') {
$TMPL['nfifty'] = 'selected="selected"';
} else {
$TMPL['nonehundred'] = 'selected="selected"';
}
if ($settings['mperpage'] == '5') {
$TMPL['mone'] = 'selected="selected"';
} elseif ($settings['mperpage'] == '10') {
$TMPL['mtwo'] = 'selected="selected"';
} elseif ($settings['mperpage'] == '25') {
$TMPL['mthree'] = 'selected="selected"';
} else {
$TMPL['mfour'] = 'selected="selected"';
}
if ($settings['climit'] == '500') {
$TMPL['cone'] = 'selected="selected"';
} elseif ($settings['climit'] == '1000') {
$TMPL['ctwo'] = 'selected="selected"';
} elseif ($settings['climit'] == '2500') {
$TMPL['cthree'] = 'selected="selected"';
} else {
$TMPL['cfour'] = 'selected="selected"';
}
if ($settings['chatr'] == '1') {
$TMPL['crone'] = 'selected="selected"';
} elseif ($settings['chatr'] == '2') {
$TMPL['crtwo'] = 'selected="selected"';
} elseif ($settings['chatr'] == '3') {
$TMPL['crthree'] = 'selected="selected"';
} elseif ($settings['chatr'] == '5') {
$TMPL['crfive'] = 'selected="selected"';
} elseif ($settings['chatr'] == '10') {
$TMPL['crten'] = 'selected="selected"';
} elseif ($settings['chatr'] == '30') {
$TMPL['crthirty'] = 'selected="selected"';
} else {
$TMPL['croff'] = 'selected="selected"';
}
if ($settings['qperpage'] == '10') {
$TMPL['qten'] = 'selected="selected"';
} elseif ($settings['qperpage'] == '25') {
$TMPL['qtwentyfive'] = 'selected="selected"';
} elseif ($settings['qperpage'] == '50') {
$TMPL['qfifty'] = 'selected="selected"';
} else {
$TMPL['qonehundred'] = 'selected="selected"';
}
if ($settings['cperpage'] == '3') {
$TMPL['ctrei'] = 'selected="selected"';
} elseif ($settings['cperpage'] == '5') {
$TMPL['ccinci'] = 'selected="selected"';
} elseif ($settings['cperpage'] == '10') {
$TMPL['czece'] = 'selected="selected"';
} else {
$TMPL['ccinspe'] = 'selected="selected"';
}
if ($settings['message'] == '500') {
$TMPL['unu'] = 'selected="selected"';
} elseif ($settings['message'] == '1000') {
$TMPL['doi'] = 'selected="selected"';
} elseif ($settings['message'] == '2500') {
$TMPL['trei'] = 'selected="selected"';
} else {
$TMPL['patru'] = 'selected="selected"';
}
if ($settings['size'] == '1048576') {
$TMPL['onemb'] = 'selected="selected"';
} elseif ($settings['size'] == '2097152') {
$TMPL['twomb'] = 'selected="selected"';
} elseif ($settings['size'] == '3145728') {
$TMPL['threemb'] = 'selected="selected"';
} else {
$TMPL['tenmb'] = 'selected="selected"';
}
if ($settings['mail'] == '1') {
$TMPL['mailon'] = 'selected="selected"';
} else {
$TMPL['mailoff'] = 'selected="selected"';
}
if ($settings['intervalm'] == '10000') {
$TMPL['intone'] = 'selected="selected"';
} elseif ($settings['intervalm'] == '30000') {
$TMPL['inttwo'] = 'selected="selected"';
} elseif ($settings['intervalm'] == '60000') {
$TMPL['intthree'] = 'selected="selected"';
} elseif ($settings['intervalm'] == '120000') {
$TMPL['intfour'] = 'selected="selected"';
} elseif ($settings['intervalm'] == '300000') {
$TMPL['intfive'] = 'selected="selected"';
} elseif ($settings['intervalm'] == '600000') {
$TMPL['intsix'] = 'selected="selected"';
} else {
$TMPL['intseven'] = 'selected="selected"';
}
if ($settings['intervaln'] == '10000') {
$TMPL['intonen'] = 'selected="selected"';
} elseif ($settings['intervaln'] == '30000') {
$TMPL['inttwon'] = 'selected="selected"';
} elseif ($settings['intervaln'] == '60000') {
$TMPL['intthreen'] = 'selected="selected"';
} elseif ($settings['intervaln'] == '120000') {
$TMPL['intfourn'] = 'selected="selected"';
} elseif ($settings['intervaln'] == '300000') {
$TMPL['intfiven'] = 'selected="selected"';
} elseif ($settings['intervaln'] == '600000') {
$TMPL['intsixn'] = 'selected="selected"';
} else {
$TMPL['intsevenn'] = 'selected="selected"';
}
if ($settings['sizemsg'] == '1048576') {
$TMPL['onembMsg'] = 'selected="selected"';
} elseif ($settings['sizemsg'] == '2097152') {
$TMPL['twombMsg'] = 'selected="selected"';
} elseif ($settings['sizemsg'] == '3145728') {
$TMPL['threembMsg'] = 'selected="selected"';
} else {
$TMPL['tenmbMsg'] = 'selected="selected"';
}
if ($settings['uperpage'] == '10') {
$TMPL['upone'] = 'selected="selected"';
} elseif ($settings['uperpage'] == '20') {
$TMPL['uptwo'] = 'selected="selected"';
} elseif ($settings['uperpage'] == '50') {
$TMPL['upthree'] = 'selected="selected"';
} else {
$TMPL['upfour'] = 'selected="selected"';
}
if ($settings['rperpage'] == '10') {
$TMPL['rpone'] = 'selected="selected"';
} elseif ($settings['rperpage'] == '20') {
$TMPL['rptwo'] = 'selected="selected"';
} elseif ($settings['rperpage'] == '50') {
$TMPL['rpthree'] = 'selected="selected"';
} else {
$TMPL['rpfour'] = 'selected="selected"';
}
if ($settings['sperpage'] == '10') {
$TMPL['sone'] = 'selected="selected"';
} elseif ($settings['sperpage'] == '20') {
$TMPL['stwo'] = 'selected="selected"';
} elseif ($settings['sperpage'] == '25') {
$TMPL['sthree'] = 'selected="selected"';
} else {
$TMPL['sfour'] = 'selected="selected"';
}
if (isset($_POST['submit'])) {
// Unset the submit array element
unset($_POST['submit']);
$updateSettings = new updateSettings();
$updateSettings->db = $db;
$updated = $updateSettings->query_array('settings', $_POST);
if ($updated == 1) {
header("Location: " . $CONF['url'] . "/index.php?a=admin&m=s");
} else {
header("Location: " . $CONF['url'] . "/index.php?a=admin&m=i");
}
}
if ($_GET['m'] == 's') {
$TMPL['message'] = notificationBox('success', $LNG['settings_saved'], $LNG['general_settings_saved']);
} elseif ($_GET['m'] == 'i') {
$TMPL['message'] = notificationBox('info', $LNG['nothing_saved'], $LNG['general_settings_unaffected']);
}
}
$page .= $skin->make();
$TMPL = $TMPL_old;
unset($TMPL_old);
$TMPL['settings'] = $page;
if (isset($_GET['logout']) == 1) {
$loggedInAdmin->logOut();
header("Location: " . $CONF['url'] . "/index.php?a=admin");
}
} else {
// Set the content to false, change the $skin to log-in.
$content = false;
}
}
// Bold the current link
if (isset($_GET['b'])) {
$LNG["admin_menu_{$_GET['b']}"] = '<strong>' . $LNG["admin_menu_{$_GET['b']}"] . '</strong>';
$TMPL['welcome'] = '<strong>' . $LNG["admin_ttl_{$_GET['b']}"] . '</strong>';
} else {
$LNG["admin_menu_general"] = '<strong>' . $LNG["admin_menu_general"] . '</strong>';
$TMPL['welcome'] = '<strong>' . $LNG["admin_ttl_general"] . '</strong>';
}
$TMPL['admin_menu'] = '
<a href="' . $CONF['url'] . '/index.php?a=admin">' . $LNG['admin_menu_general'] . '</a>
<a href="' . $CONF['url'] . '/index.php?a=admin&b=users_settings">' . $LNG['admin_menu_users_settings'] . '</a>
<a href="' . $CONF['url'] . '/index.php?a=admin&b=stats">' . $LNG['admin_menu_stats'] . '</a>
<a href="' . $CONF['url'] . '/index.php?a=admin&b=security">' . $LNG['admin_menu_security'] . '</a>
<a href="' . $CONF['url'] . '/index.php?a=admin&b=users">' . $LNG['admin_menu_users'] . '</a>
<a href="' . $CONF['url'] . '/index.php?a=admin&b=manage_reports">' . $LNG['admin_menu_manage_reports'] . '</a>
<a href="' . $CONF['url'] . '/index.php?a=admin&b=manage_notices">' . $LNG['admin_menu_manage_notices'] . '</a>
<a href="' . $CONF['url'] . '/index.php?a=admin&logout=1">' . $LNG['admin_menu_logout'] . '</a>';
$TMPL['url'] = $CONF['url'];
$TMPL['localurl'] = $CONF['url'];
$TMPL['titleh'] = $settings['title'];
$TMPL['title'] = $LNG['title_admin'] . ' - ' . $settings['title'];
if ($content) {
$skin = new skin('admin/content');
} else {
$skin = new skin('admin/login');
}
return $skin->make();
}
$ST_emailText = array();
$mainResult = mysql_query("select dbname as thisdb, timezone as thisTimeZone from " . MASTERDB . ".subdomains where status='Y' ORDER BY pid ");
while ($mainrow = @mysql_fetch_array($mainResult)) {
extract($mainrow);
// $thisdb , $thisTimeZone
putenv("TZ=" . $thisTimeZone);
// Scheduled Tasks
$thisdb_result = mysql_query("select workID, work_userAssigned, work_addedBy, work_dateAdded, work_deadLine, work_startDate, work_completeDate, work_briefDesc, work_Notes, work_status, work_priority, work_projectName, work_isPrivate, daysb4deadline , work_RTID from " . $thisdb . ".WORKS where work_status='" . $DE_GLOBALS_WORK_SCHEDULED . "'");
while ($row = @mysql_fetch_array($thisdb_result)) {
extract($row);
// workID, work_userAssigned, work_addedBy, work_dateAdded, work_deadLine, work_startDate, work_completeDate,
// work_briefDesc, work_Notes, work_status, work_priority, work_projectName, work_isPrivate, daysb4deadline
if (isTodayXdaysBeforeDeadline($daysb4deadline, $work_deadLine)) {
$somequery = mysql_query("update " . $thisdb . ".WORKS set work_status = '" . $DE_GLOBALS_WORK_NEW . "' where workID='{$workID}' ");
$ST_emailText[] = "Task {$workID} of {$thisdb} is added to tasks from scheduled list - <BR> Work Description : {$work_briefDesc} <BR> Deadline: {$work_deadLine} <BR> Days Before : {$daysb4deadline} ";
$tmp_manageUsers = new manageUsers();
$email_userAssigned = $tmp_manageUsers->get_userSingleDetail($work_userAssigned, 'user_primaryEmail');
$email_taskOwner = $tmp_manageUsers->get_userSingleDetail($work_addedBy, 'user_primaryEmail');
$scheduledtask_invoked_email = new sendaMail();
if ($email_userAssigned) {
$scheduledtask_invoked_email->messageTo($email_userAssigned);
}
if ($email_taskOwner && $email_userAssigned != $email_taskOwner) {
$scheduledtask_invoked_email->messageTo($email_taskOwner);
}
if ($work_RTID > 0) {
$scheduledtask_invoked_email->subject("Added Recurring Task {$workID} - {$work_briefDesc} ");
} else {
$scheduledtask_invoked_email->subject("Moved Scheduled Task {$workID} - {$work_briefDesc} ");
}
$scheduledtask_invoked_email->body("Task Description: {$work_briefDesc} <BR> Task Deadline: {$work_deadLine} ");
}; // End of localajaxinit
</SCRIPT>
<?php
function showHowManyCommentsSelect()
{
?>
<center>
<div style='margin:10px;'>
Show
<select id="select_comments_howmany" onchange="var hm = this.value; My_JsLibrary.updatePageWithGetVar('howmany', hm);">
<option value='25'>25 Comments</option>
<option value='50'>50 Comments</option>
<option value='100'>100 Comments</option>
<option value='250'>250 Comments</option>
</select>
</div>
</center>
<?php
}
showHowManyCommentsSelect();
$howmany = get_GET_var('howmany');
if (!$howmany) {
$howmany = 25;
}
$manageUsers = new manageUsers();
$manageUsers->getUnreadComments($username, $howmany);
showHowManyCommentsSelect();
include "include_footer.php";
<?php
include "../includes/config.php";
include "../includes/classes.php";
include getLanguage(null, !empty($_GET['lang']) ? $_GET['lang'] : $_COOKIE['lang'], 2);
session_start();
$db = new mysqli($CONF['host'], $CONF['user'], $CONF['pass'], $CONF['name']);
if ($db->connect_errno) {
echo "Failed to connect to MySQL: (" . $db->connect_errno . ") " . $db->connect_error;
}
$db->set_charset("utf8");
$resultSettings = $db->query(getSettings());
$settings = $resultSettings->fetch_assoc();
if (isset($_SESSION['usernameAdmin']) && isset($_SESSION['passwordAdmin'])) {
$loggedInAdmin = new loggedInAdmin();
$loggedInAdmin->db = $db;
$loggedInAdmin->url = $CONF['url'];
$loggedInAdmin->username = $_SESSION['usernameAdmin'];
$loggedInAdmin->password = $_SESSION['passwordAdmin'];
$loggedIn = $loggedInAdmin->verify();
if ($loggedIn['username']) {
if (isset($_POST['id'])) {
$manageUsers = new manageUsers();
$manageUsers->db = $db;
$manageUsers->url = $CONF['url'];
echo $manageUsers->deleteUser($_POST['id']);
}
}
}
$responseEmail .= "\n" . "Notes : " . $taskDetails["work_Notes"];
$responseEmail .= "\n" . "Added By : " . $taskDetails["work_addedBy"];
$responseEmail .= "\n" . "Assigned to : " . $taskDetails["work_userAssigned"];
$responseEmail .= "\n" . "Task Created On : " . $taskDetails["work_dateAdded"];
$responseEmail .= "\n" . "Task Deadline : " . $taskDetails["work_deadLine"];
$responseEmail .= "\n\n" . "Comments : ";
while ($row = mysql_fetch_assoc($comments_result)) {
$responseEmail .= "\n" . "----------------------------------------------------";
$responseEmail .= "\n" . $row['comment_by'] . " on " . $row['comment_date'];
$responseEmail .= "\n" . $row['comment'];
}
$responseEmail .= "\n\n";
} else {
$responseEmail = $taskDetails["work_briefDesc"];
}
$tmp_manageUsers = new manageUsers();
$user_fromEMailId = $tmp_manageUsers->get_userSingleDetail($USERNAME, 'user_primaryEmail');
$email = new sendaMail();
$email->asFrom($user_fromEMailId);
$email->messageTo($toemailId);
$email->subject("Details of task - " . $workid);
$email->body($responseEmail);
if ($includeAttachments == 'yes') {
$COMMENTLOGMESSAGE .= "\n Included Attachments";
$attachments = mysql_query("select diskfilename, uploadname from attachments where workid='{$workid}' ");
while ($row = mysql_fetch_assoc($attachments)) {
$email->AddAttachment(APP_INSTALLPATH . 'attachments/' . $_SESSION["subdomain"] . '/' . $row['diskfilename'], $row['uploadname']);
}
}
$email->send();
$manageWorks->addComment($workid, APPNAME, $COMMENTLOGMESSAGE);
