$v) {
if (!is_numeric($v)) {
unset($_post['artist_id'][$k]);
}
else {
$xtr .= "&artist_id[]={$v}";
}
}
$req .= "AND c.event_band_id IN (". implode(',',$_post['artist_id']) .") ";
}
if (is_numeric($_post['band_id'])) {
$req .= "AND c.event_band_id = {$_post['band_id']} ";
$xtr .= "&band_id={$_post['band_id']}";
}
elseif (is_array($_post['band_id'])) {
foreach ($_post['band_id'] as $k => $v) {
if (!is_numeric($v)) {
unset($_post['band_id'][$k]);
}
else {
$xtr .= "&band_id[]={$v}";
}
}
$req .= "AND c.event_band_id IN (". implode(',',$_post['band_id']) .") ";
}
if (strlen($_post['event_location']) > 0) {
$_post['event_location'] = urldecode($_post['event_location']);
$req .= "AND c.event_location = '". cleanInput($_post['event_location']) ."' ";
$xtr .= "&event_location=". urlencode($_post['event_location']);
}
$req .= "GROUP BY c.event_id
ORDER BY c.event_time ASC ";
$_ev = dbQuery($req,'NUMERIC');
if (is_array($_ev)) {
foreach ($_ev as $id => $_v) {
list($ty2,$ty4,$tmn,$tdy,$thr) = explode('|',chunk_split($_v['event_time'],2,'|'));
$_v['event_year'] = $ty2 . $ty4;
$_v['event_month'] = $tmn;
$_v['event_day'] = $tdy;
$_v['event_hour'] = $thr;
$_v['artist_url'] = getJamroomUrl($_v['event_band_id'],$_v['server_url']) . "/{$config['artist_dir']}/{$_v['event_band_id']}/";
$_dt[$tdy]["{$_v['event_id']}"] = $_v;
}
}
$_tmp = getMonthInfo($mon,$yer);
$_rt['month_long_name'] = $_tmp['long_name'];
$_rt['month_short_name'] = $_tmp['short_name'];
$_rt['month_number_days'] = $_tmp['days'];
$_rt['this_year'] = $yer;
$_rt['next_year'] = $yer + 1;
$_rt['prev_year'] = $yer - 1;
$_rt['this_month'] = $mon;
if ($mon == 12) {
$_rt['next_month'] = '01';
$_rt['prev_month'] = '11';
}
elseif ($mon == 1 || $mon == '01') {
$_rt['next_month'] = '02';
$_rt['prev_month'] = '12';
}
else {
$_rt['next_month'] = str_pad(($mon + 1),2,0,STR_PAD_LEFT);
$_rt['prev_month'] = str_pad(($mon - 1),2,0,STR_PAD_LEFT);
}
$row = 1;
$cnt = 0;
$tmp = date('w',mktime(0,0,0,$mon,1,$yer));
while ($cnt < $tmp) {
$_rt['_DAYS'][$row][$cnt++] = array();
}
for ($day = 1; $day <= $_tmp['days']; $day++) {
$day = str_pad($day,2,0,STR_PAD_LEFT);
$_rt['_DAYS'][$row][$cnt] = $_dt[$day];
$_rt['_DAYS'][$row][$cnt]['month_day'] = $day;
$_rt['_DAYS'][$row][$cnt]['number_events'] = count($_dt[$day]);
if (++$cnt > 6) {
$cnt = 0;
$row++;
}
}
if ($cnt > 0) {
while ($cnt < 7) {
$_rt['_DAYS'][$row][$cnt++] = array();
}
}
$template = 'calendar_big.tpl';
if (strlen($_post['template']) > 0) {
$template = $_post['template'];
}
$_rt['template_name'] = $template;
$_rt['prev_year_url'] = "calendar.php?mode=display&month={$mon}&year={$_rt['prev_year']}&template={$template}{$xtr}";
$_rt['next_year_url'] = "calendar.php?mode=display&month={$mon}&year={$_rt['next_year']}&template={$template}{$xtr}";
if ($_rt['prev_month'] == '12') {
$_rt['prev_month_url'] = "calendar.php?mode=display&month=12&year={$_rt['prev_year']}&template={$template}{$xtr}";
}
else {
$_rt['prev_month_url'] = "calendar.php?mode=display&month={$_rt['prev_month']}&year={$yer}&template={$template}{$xtr}";
}
if ($_rt['next_month'] == '1') {
$_rt['next_month_url'] = "calendar.php?mode=display&month=1&year={$_rt['next_year']}&template={$template}{$xtr}";
}
else {
$_rt['next_month_url'] = "calendar.php?mode=display&month={$_rt['next_month']}&year={$yer}&template={$template}{$xtr}";
}
ob_start();
htmlShowTemplate("{$jamroom['jm_dir']}/templates/calendar/{$template}",$_rt,"{$jamroom['jm_dir']}/templates/calendar",'yes');
addToCache($cache_key,ob_get_contents());
ob_end_flush();
exit;
}
elseif (isset($_post['mode']) && $_post['mode'] == 'show_event') {
$_drep = array(
'JAMROOM_DIR' => $jamroom['jm_dir'],
'JAMROOM_URL' => $jamroom['jm_htm']
);
$c_time = strftime('%Y%m%d%H');
$req = "SELECT c.event_id, c.event_band_id, c.event_added, c.event_time, c.event_title, c.event_location, c.event_description,
m.image_time, m.image_name, m.image_type, m.image_size, m.image_extension,
i.band_time, i.band_name, i.band_members, i.band_location, i.band_story,
i.band_quota, i.band_website, i.band_influence, i.band_soundlike,
v.server_id, v.server_ip, v.server_name, v.server_url
FROM {$jamroom_db['calendar']} c
LEFT JOIN {$jamroom_db['calendar_image']} m ON m.band_id = c.event_band_id
LEFT JOIN {$jamroom_db['band_info']} i ON i.band_id = c.event_band_id
LEFT JOIN {$jamroom_db['quota']} q ON q.quota_id = i.band_quota
LEFT JOIN {$jamroom_db['servers']} v ON v.server_id = i.band_server
WHERE q.quota_calendar = 'yes'
AND c.event_show != 'no' ";
if (strlen($_post['old_events']) == 0) {
$req .= " AND c.event_time >= {$c_time} ";
}
if (is_numeric($_post['range'])) {
$end = strftime('%Y%m%d%H',(time() + ($_post['range'] * 86400)));
$req .= "AND c.event_time <= {$end} ";
}
if (is_numeric($_post['year'])) {
$req .= "AND c.event_time LIKE '{$_post['year']}______' ";
}
elseif (is_array($_post['year'])) {
foreach ($_post['year'] as $k => $v) {
if (!is_numeric($v)) {
unset($_post['year'][$k]);
}
}
$req .= "AND (c.event_time LIKE '". implode("______' OR c.event_time LIKE '",$_post['year']) ."______') ";
}
if (is_numeric($_post['month'])) {
$req .= "AND c.event_time LIKE '____{$_post['month']}____' ";
}
elseif (is_array($_post['month'])) {
foreach ($_post['month'] as $k => $v) {
if (!is_numeric($v)) {
unset($_post['month'][$k]);
}
}
$req .= "AND (c.event_time LIKE '____". implode("____' OR c.event_time LIKE '____",$_post['month']) ."____') ";
}
if (is_numeric($_post['day'])) {
$req .= "AND c.event_time LIKE '______{$_post['day']}__' ";
}
elseif (is_array($_post['day'])) {
foreach ($_post['day'] as $k => $v) {
if (!is_numeric($v)) {
unset($_post['day'][$k]);
}
}
$req .= "AND (c.event_time LIKE '______". implode("__' OR c.event_time LIKE '______",$_post['day']) ."__') ";
}
if (is_numeric($_post['hour'])) {
$req .= "AND c.event_time LIKE '________{$_post['hour']}' ";
}
elseif (is_array($_post['hour'])) {
foreach ($_post['hour'] as $k => $v) {
if (!is_numeric($v)) {
unset($_post['hour'][$k]);
}
}
$req .= "AND (c.event_time LIKE '________". implode("' OR c.event_time LIKE '________",$_post['hour']) ."') ";
}
if (is_numeric($_post['artist_id'])) {
$req .= "AND c.event_band_id = {$_post['artist_id']} ";
}
elseif (is_array($_post['artist_id'])) {
foreach ($_post['artist_id'] as $k => $v) {
if (!is_numeric($v)) {
unset($_post['artist_id'][$k]);
}
}
$req .= "AND c.event_band_id IN (". implode(',',$_post['artist_id']) .") ";
}
if (is_numeric($_post['band_id'])) {
$req .= "AND c.event_band_id = {$_post['band_id']} ";
}
elseif (is_array($_post['band_id'])) {
foreach ($_post['band_id'] as $k => $v) {
if (!is_numeric($v)) {
unset($_post['band_id'][$k]);
}
}
$req .= "AND c.event_band_id IN (". implode(',',$_post['band_id']) .") ";
}
if (is_numeric($_post['event_id'])) {
$req .= "AND c.event_id = {$_post['event_id']} ";
}
elseif (is_array($_post['event_id'])) {
foreach ($_post['event_id'] as $k => $v) {
if (!is_numeric($v)) {
unset($_post['event_id'][$k]);
}
}
$req .= "AND c.event_id IN (". implode(',',$_post['event_id']) .") ";
}
if (strlen($_post['event_location']) > 0) {
$_post['event_location'] = urldecode($_post['event_location']);
$req .= "AND c.event_location = '". cleanInput($_post['event_location']) ."' ";
}
$req .= "GROUP BY c.event_id
ORDER BY c.event_time ASC ";
if (is_numeric($_post['limit'])) {
$req .= "LIMIT {$_post['limit']}";
}
$_rt = dbQuery($req,'NUMERIC');
ob_start();
if (is_array($_rt)) {
if (is_file("{$jamroom['jm_dir']}/templates/calendar/calendar_row.tpl")) {
$row_tpl = "{$jamroom['jm_dir']}/templates/calendar/calendar_row.tpl";
}
else {
$row_tpl = "{$jamroom['jm_dir']}/templates/calendar/default_entry.tpl";
}
if (isset($_post['entry_tpl'])) {
$row_tpl = "{$jamroom['jm_dir']}/templates/calendar/{$_post['entry_tpl']}";
}
elseif (isset($_post['row_template'])) {
$row_tpl = "{$jamroom['jm_dir']}/templates/calendar/{$_post['row_template']}";
}
foreach ($_rt as $_row) {
if ((is_numeric($_row['server_id']) && $_row['server_id'] != 0) && strpos($_row['server_url'],'ttp')) {
$aurl = $_row['server_url'];
}
else {
$aurl = $jamroom['jm_htm'];
}
$yer = substr($_row['event_time'],0,4);
$mon = substr($_row['event_time'],4,2);
$day = substr($_row['event_time'],6,2);
$hrs = substr($_row['event_time'],8,2);
$_rep = array(
'JAMROOM_DIR' => $jamroom['jm_dir'],
'JAMROOM_URL' => $jamroom['jm_htm'],
'SERVER_URL' => $aurl,
'EVENT_ID' => $_row['event_id'],
'EVENT_CREATED' => gmstrftime($config['date1'],convertTime($_row['event_added'],$config['server_offset'])),
'EVENT_TIME' => $_row['event_time'],
'EVENT_HOUR24' => $hrs,
'EVENT_DAY' => $day,
'EVENT_MONTH' => $mon,
'EVENT_YEAR' => $yer,
'EVENT_TITLE' => $_row['event_title'],
'EVENT_DESCRIPTION' => bbDecode($_row['event_description']),
'EVENT_LOCATION' => $_row['event_location'],
'EVENT_IMAGE' => "{$aurl}/image.php?band_id={$_row['event_band_id']}&event_id={$_row['event_id']}&mode=calendar_image",
'EVENT_IMAGE_NAME' => $_row['image_name'],
'EVENT_IMAGE_TYPE' => $_row['image_type'],
'EVENT_IMAGE_SIZE' => $_row['image_size'],
'EVENT_IMAGE_EXTENSION' => $_row['image_extension'],
'BAND_ID' => $_row['event_band_id'],
'BAND_NAME' => $_row['band_name'],
'BAND_INFO' => bbDecode($_row['band_story']),
'BAND_LOCATION' => $_row['band_location'],
'BAND_WEBSITE' => $_row['band_website'],
'BAND_INFLUENCE' => $_row['band_influence'],
'BAND_SOUNDLIKE' => $_row['band_soundlike'],
'BAND_IMAGE' => "{$aurl}/image.php?band_id={$_row['event_band_id']}&mode=band_image",
'BAND_IMAGE_URL' => "{$aurl}/image.php?band_id={$_row['event_band_id']}&mode=band_image",
'BAND_RATING_FORM' => "{$jamroom['jm_htm']}/rating.php?mode=rate_band&band_id={$_row['event_band_id']}",
'ARTIST_URL' => "{$aurl}/{$config['artist_dir']}/{$_row['event_band_id']}/",
'BAND_URL' => "{$aurl}/{$config['artist_dir']}/{$_row['event_band_id']}/"
);
if ($hrs == '00') {
$_rep['EVENT_AMPM'] = 'am';
$_rep['EVENT_HOUR12'] = 12;
}
elseif ($hrs < 12) {
$_rep['EVENT_AMPM'] = 'am';
$_rep['EVENT_HOUR12'] = ($hrs - 0);
}
elseif ($hrs == 12) {
$_rep['EVENT_AMPM'] = 'pm';
$_rep['EVENT_HOUR12'] = 12;
}
else {
$_rep['EVENT_AMPM'] = 'pm';
$_rep['EVENT_HOUR12'] = ($hrs - 12);
}
$_stm = strtotime("{$_rep['EVENT_MONTH']}/{$_rep['EVENT_DAY']}/{$_rep['EVENT_YEAR']} {$hrs}:00:00");
$_rep['EVENT_EPOCH_TIME'] = $_stm;
$_rep['EVENT_WDAY_SHORT'] = strftime('%a',$_stm);
$_rep['EVENT_WDAY_LONG'] = strftime('%A',$_stm);
htmlShowTemplate($row_tpl,$_rep,"{$jamroom['jm_dir']}/templates/calendar",'yes');
}
}
$rows = ob_get_contents();
ob_end_clean();
if (isset($_post['header_tpl'])) {
htmlShowTemplate("{$jamroom['jm_dir']}/templates/calendar/{$_post['header_tpl']}",$_drep,"{$jamroom['jm_dir']}/templates/calendar",'yes');
}
elseif (isset($_post['header_template'])) {
htmlShowTemplate("{$jamroom['jm_dir']}/templates/calendar/{$_post['header_template']}",$_drep,"{$jamroom['jm_dir']}/templates/calendar",'yes');
}
elseif (is_file("{$jamroom['jm_dir']}/templates/calendar/common_header.tpl")) {
htmlShowTemplate("{$jamroom['jm_dir']}/templates/calendar/common_header.tpl",$_drep,"{$jamroom['jm_dir']}/templates/calendar",'yes');
}
else {
htmlShowTemplate("{$jamroom['jm_dir']}/templates/calendar/default_header.tpl",$_drep);
}
echo $rows;
if (isset($_post['footer_tpl'])) {
htmlShowTemplate("{$jamroom['jm_dir']}/templates/calendar/{$_post['footer_tpl']}",$_drep,"{$jamroom['jm_dir']}/templates/calendar",'yes');
}
elseif (isset($_post['footer_template'])) {
htmlShowTemplate("{$jamroom['jm_dir']}/templates/calendar/{$_post['footer_template']}",$_drep,"{$jamroom['jm_dir']}/templates/calendar",'yes');
}
elseif (is_file("{$jamroom['jm_dir']}/templates/calendar/common_footer.tpl")) {
htmlShowTemplate("{$jamroom['jm_dir']}/templates/calendar/common_footer.tpl",$_drep,"{$jamroom['jm_dir']}/templates/calendar",'yes');
}
else {
htmlShowTemplate("{$jamroom['jm_dir']}/templates/calendar/default_footer.tpl",$_drep);
}
}
elseif (isset($_post['mode']) && ($_post['mode'] == 'add_event' || $_post['mode'] == 'modify_event')) {
$_user = verifySession('on');
$language = getLanguage($_user['user_language']);
if (isset($config['hour_format']) && $config['hour_format'] == 24) {
$_hrs = array(
'00' => '00:00', '01' => '01:00', '02' => '02:00', '03' => '03:00', '04' => '04:00', '05' => '05:00',
'06' => '06:00', '07' => '07:00', '08' => '08:00', '09' => '09:00', '10' => '10:00', '11' => '11:00',
'12' => '12:00', '13' => '13:00', '14' => '14:00', '15' => '15:00', '16' => '16:00', '17' => '17:00',
'18' => '18:00', '19' => '19:00', '20' => '20:00', '21' => '21:00', '22' => '22:00', '23' => '23:00'
);
}
else {
$_hrs = array(
'12' => '12:00 pm', '13' => '01:00 pm', '14' => '02:00 pm', '15' => '03:00 pm', '16' => '04:00 pm', '17' => '05:00 pm',
'18' => '06:00 pm', '19' => '07:00 pm', '20' => '08:00 pm', '21' => '09:00 pm', '22' => '10:00 pm', '23' => '11:00 pm',
'00' => '12:00 am', '01' => '01:00 am', '02' => '02:00 am', '03' => '03:00 am', '04' => '04:00 am', '05' => '05:00 am',
'06' => '06:00 am', '07' => '07:00 am', '08' => '08:00 am', '09' => '09:00 am', '10' => '10:00 am', '11' => '11:00 am'
);
}
ob_start();
if ($_post['mode'] == 'add_event') {
jmHtmlBegin($language['calendar'][13],'null','song_order','include/jamroom_calendar.inc.js');
jmBodyBegin();
jmSpanCell($language['calendar'][13],$language['calendar'][14],30,'html_create.png');
jmBeginForm("calendar.php?mode=create_event&band_id={$_user['user_band_id']}&e_mode=add_event");
}
else {
if (!is_numeric($_post['event_id'])) {
jmErrorPage("invalid event_id received - verify usage");
}
$req = "SELECT c.*,
i.band_id, i.image_time, i.image_name, i.image_type, i.image_size, i.image_extension
FROM {$jamroom_db['calendar']} c
LEFT JOIN {$jamroom_db['calendar_image']} i ON i.event_id = c.event_id
WHERE c.event_id = {$_post['event_id']}
AND c.event_band_id = {$_user['user_band_id']}
LIMIT 1";
$_cal = dbQuery($req,'SINGLE');
if (is_array($_cal) && is_numeric($_cal['event_id'])) {
$_cal['event_year'] = substr($_cal['event_time'],0,4);
$_cal['event_month'] = substr($_cal['event_time'],4,2);
$_cal['event_day'] = substr($_cal['event_time'],6,2);
$_cal['event_hour'] = substr($_cal['event_time'],8,2);
$_cal['event_title'] = showHtml(cleanHtml($_cal['event_title']));
$_cal['event_location'] = showHtml(cleanHtml($_cal['event_location']));
}
else {
jmErrorPage("{$language['calendar'][17]} ({$_post['event_id']}) - {$language['calendar'][18]}");
}
jmHtmlBegin($language['calendar'][15],'null','song_order','include/jamroom_calendar.inc.js');
jmBodyBegin();
jmSpanCell($language['calendar'][15],$language['calendar'][16],30,'html_modify.png');
jmBeginForm("calendar.php?mode=update_event&band_id={$_user['user_band_id']}&event_id={$_post['event_id']}&e_mode=modify_event");
jmLinkCell($language['calendar'][55],$_post['event_id'],'null','30');
}
if (isset($_post['jm_error'])) {
if ($_post['jm_error'] == 'date_error') {
jmShowError($language['calendar'][56]);
}
elseif ($_post['jm_error'] == 'time_error') {
jmShowError($language['calendar'][57]);
}
elseif ($_post['jm_error'] == 'title_error') {
jmShowError($language['calendar'][58]);
}
unset($_post['jm_error']);
}
jmInput($language['calendar'][19],'event_title','description',$_cal['event_title'],$language['calendar'][20]);
if (@is_file("{$jamroom['jm_dir']}/config/event_location.txt")) {
@jmSelect($language['calendar'][45],'event_location',"{$jamroom['jm_dir']}/config/event_location.txt",$_cal['event_location'],$language['calendar'][46]);
}
else {
jmInput($language['calendar'][45],'event_location','description',$_cal['event_location'],$language['calendar'][46]);
}
if (empty($_cal['event_hour'])) {
$_cal['event_hour'] = 12;
}
jmSelect($language['calendar'][21],'event_hour',$_hrs,$_cal['event_hour'],$language['calendar'][22]);
if (empty($_cal['event_time'])) {
$show_date = strftime('%m/%d/%Y');
}
else {
$yer = substr($_cal['event_time'],0,4);
$mon = substr($_cal['event_time'],4,2);
$day = substr($_cal['event_time'],6,2);
$show_date = "{$mon}/{$day}/{$yer}";
}
$ustyle = getUserStyle();
jmInput($language['calendar'][47],'event_time','description',$show_date," {$language['calendar'][49]}");
$mkup = showMarkupCfg();
jmTextArea("{$language['calendar'][29]}
{$mkup}",'event_description',stripslashes($_cal['event_description']));
$s_check = '';
if (isset($_cal['event_show']) && $_cal['event_show'] == 'no') {
$s_check = 'checked';
}
jmCheckBox($language['calendar'][59],'event_show',$language['calendar'][60],$s_check);
$_image['id_type'] = 'event_id';
$_image['match_id'] = $_post['event_id'];
$_image['mode'] = 'calendar_image';
$_image['cur_tag'] = $language['calendar'][50];
$_image['new_tag'] = $language['calendar'][51];
$_image['imp_tag'] = $language['calendar'][52];
$_image['del_tag'] = $language['calendar'][53];
$_image['del_help'] = $language['band'][47];
$_image['gal_num'] = $_post['event_id'];
if ($mode != 'create') {
$_image['file_name'] = "event_{$_post['event_id']}_image.{$_cal['image_extension']}";
$_image['db_name'] = $_cal['image_name'];
$_image['size'] = $_cal['image_size'];
}
htmlImageArea($_user['user_band_id'],$_image,$_dat['server_url']);
$_clean = array('event_description');
if ($_post['mode'] == 'add_event') {
jmSubmitClear($language['calendar'][30],$language['calendar'][32],'150px',$_clean,'','band.php');
}
else {
jmSubmitClear($language['calendar'][31],$language['calendar'][32],'150px',$_clean,'','calendar.php?mode=choose_event');
}
jmEndForm();
jmBodyEnd();
jmHtmlEnd();
ob_end_flush();
exit;
}
elseif (isset($_post['mode']) && ($_post['mode'] == 'update_event' || $_post['mode'] == 'create_event')) {
$_user = verifySession('on');
$language = getLanguage($_user['user_language']);
if (!is_numeric($_user['user_band_id'])) {
jmErrorPage("{$language['calendar'][33]} - {$language['calendar'][18]}");
}
if (empty($_post['event_title'])) {
header("Location: calendar.php?mode={$_post['e_mode']}&jm_error=title_error");
exit;
}
list($mon,$day,$yer) = explode('/',$_post['event_time']);
if (strtotime($_post['event_time']) == -1 || !@checkdate($mon,$day,$yer)) {
header("Location: calendar.php?mode={$_post['e_mode']}&jm_error=date_error");
exit;
}
if (!is_numeric($_post['event_hour']) || ($_post['event_hour'] < 0 || $_post['event_hour'] > 23)) {
header("Location: calendar.php?mode={$_post['e_mode']}&jm_error=time_error");
exit;
}
$event_time = "{$yer}{$mon}{$day}{$_post['event_hour']}";
$tim = time();
$_post['event_title'] = cleanInput(stripHtml($_post['event_title']));
$_post['event_location'] = cleanInput(stripHtml($_post['event_location']));
$_post['event_description'] = cleanInput(stripHtml($_post['event_description']));
$event_show = 'yes';
if (isset($_post['event_show']) && $_post['event_show'] == 'on') {
$event_show = 'no';
}
if (isset($_post['mode']) && $_post['mode'] == 'update_event') {
if (!is_numeric($_post['event_id'])) {
jmErrorPage("invalid event_id received - verify usage");
}
$req = "UPDATE {$jamroom_db['calendar']} SET
event_time = {$event_time},
event_title = '{$_post['event_title']}',
event_location = '{$_post['event_location']}',
event_description = '{$_post['event_description']}',
event_show = '{$event_show}'
WHERE event_band_id = {$_user['user_band_id']}
AND event_id = {$_post['event_id']}
LIMIT 1";
$cnt = dbQuery($req,'COUNT');
if ($cnt != 1) {
jmErrorPage($language['calendar'][35]);
}
}
else {
$req = "INSERT INTO {$jamroom_db['calendar']}
( event_band_id, event_added, event_time, event_title, event_location, event_description, event_show )
VALUES
( {$_user['user_band_id']}, {$tim}, {$event_time}, '{$_post['event_title']}',
'{$_post['event_location']}', '{$_post['event_description']}', '{$event_show}' )";
$_post['event_id'] = dbQuery($req,'INSERT_ID');
if (!is_numeric($_post['event_id'])) {
jmErrorPage($language['calendar'][35]);
}
}
if (isset($_post['image_delete']) && $_post['image_delete'] == 'on') {
$_ret = deleteMediaFile($_user['user_band_id'],'calendar_image',$_post['event_id']);
if (!empty($_ret['error'])) {
jmErrorPage($_ret['error']);
}
}
if (!empty($_post['image_import']) || $_post['calendar_image']['size'] > 0) {
$_ret = getMediaFile($_user['user_band_id'],'event_image',$_post['event_id'],$_post);
if (!empty($_ret['error'])) {
jmErrorPage($_ret['error']);
}
}
ob_start();
jmHtmlBegin($language['misc'][36]);
jmBodyBegin();
jmShowSuccess($language['calendar'][34]);
jmRefresh();
jmBodyEnd();
ob_end_flush();
if ($_user['user_band_id'] != 0) {
setLock($_user['user_band_id'],'on');
}
exit;
}
elseif (isset($_post['mode']) && $_post['mode'] == 'remove_event') {
$_user = verifySession('on');
$language = getLanguage($_user['user_language']);
if (!is_array($_post['event_id'])) {
jmErrorPage("{$language['calendar'][37]} - {$language['calendar'][38]}");
}
foreach ($_post['event_id'] as $eid) {
if (!is_numeric($eid)) {
continue;
}
$req = "DELETE FROM {$jamroom_db['calendar']}
WHERE event_id = {$eid}
AND event_band_id = {$_user['user_band_id']}
LIMIT 1";
$cnt = dbQuery($req,'COUNT');
if ($cnt != 1) {
jmErrorPage("{$language['calendar'][39]} ({$_post['event_id']}) - {$language['calendar'][18]}");
}
else {
deleteMediaFile($_user['user_band_id'],'calendar_image',$eid);
jmLogger($_user['user_band_id'],'INF',"(calendar.php) {$_post['mode']}: event_id {$eid} was successfully deleted");
}
}
setLock($_user['user_band_id'],'on');
ob_start();
jmHtmlBegin($language['misc'][36]);
JmBodyBegin();
jmShowSuccess($language['calendar'][40]);
jmRefresh();
jmBodyEnd();
ob_end_flush();
exit;
}
elseif (isset($_post['mode']) && ($_post['mode'] == 'delete_event' || $_post['mode'] == 'choose_event')) {
$_user = verifySession('on');
$language = getLanguage($_user['user_language']);
$req = "SELECT *
FROM {$jamroom_db['calendar']}
WHERE event_band_id = {$_user['user_band_id']}
GROUP BY event_id
ORDER BY event_time ASC";
$_rt = dbQuery($req,'NUMERIC');
if (!is_array($_rt)) {
jmErrorPage("{$language['calendar'][33]} ({$_user['user_band_id']}) - {$language['calendar'][18]}");
}
foreach ($_rt as $_row) {
$yer = substr($_row['event_time'],0,4);
$mon = substr($_row['event_time'],4,2);
$day = substr($_row['event_time'],6,2);
$hrs = substr($_row['event_time'],8,2);
$_mon = getMonthInfo($mon);
$_row['event_title'] = stripslashes($_row['event_title']);
$hidden = '';
if ($_row['event_show'] != 'yes') {
$hidden = "({$language['song'][94]})";
}
$_cal["{$_row['event_id']}"] = "{$_row['event_title']} ({$_mon['short_name']} {$day}, {$yer}) {$hidden}";
}
ob_start();
if ($_post['mode'] == 'delete_event') {
jmHtmlBegin($language['calendar'][41]);
jmBodyBegin();
jmSpanCell($language['calendar'][41],$language['calendar'][42],30,'html_delete.png');
jmBeginForm("calendar.php?mode=remove_event&band_id={$_user['user_band_id']}");
jmErrorBanner("{$language['message'][24]} {$language['misc'][108]}");
jmChoose("{$language['calendar'][43]}
{$language['song'][111]}",'event_id',$_cal,'','yes');
jmSubmit($language['calendar'][41],$language['calendar'][44],'150px','band.php');
}
else {
jmHtmlBegin($language['calendar'][15]);
jmBodyBegin();
jmSpanCell($language['calendar'][15],$language['calendar'][16],30,'html_select_modify.png');
jmBeginForm("calendar.php?mode=modify_event&band_id={$_user['user_band_id']}");
jmChoose($language['calendar'][43],'event_id',$_cal);
jmSubmit($language['calendar'][15],'','150px','band.php');
}
jmEndForm();
jmBodyEnd();
jmHtmlEnd();
ob_end_flush();
exit;
}
else {
ob_start();
jmHtmlBegin($language['band'][1]);
jmBodyBegin();
jmSpanCell($language['band'][61],$language['band'][4],'30','html_delete.png');
jmRefresh();
jmBodyEnd();
jmHtmlEnd();
ob_end_flush();
exit;
}
?>