// no date submitted, so set $date and $enddate to today
$date = $_GET['date'];
$enddate = $_GET['enddate'];
}
$od = new OccupancyData($date, $enddate);
$formattedDate = date("m-d-y", strtotime($date));
$formattedEndDate = date("m-d-y", strtotime($enddate));
// String of this date, including the weekday and such
if ($od instanceof OccupancyData) {
include_once "dataView.inc";
} else {
echo "<h3>Occupancy Data for " . $formattedDate . " to " . $formattedEndDate . " not found</h3><br>";
}
export_data($od, $date, $enddate, $formattedDate, $formattedEndDate);
// options to export data or select a different date range
show_options();
?>
<!-- the footer goes here now -->
<?php
include_once "footer.inc";
?>
</div>
</div>
</body>
</html>
<?php
function export_data($od, $date, $enddate, $formattedDate, $formattedEndDate)
{
// download the data to the desktop
$filename = "dataexport.csv";
case 'compare':
if (count($dbs_config) < 2) {
$schema1 = @$_POST['schema1'];
$schema2 = @$_POST['schema2'];
if (get_magic_quotes_gpc()) {
// sigh...
$schema1 = stripslashes($schema1);
$schema2 = stripslashes($schema2);
}
} else {
$schema1 = $dbs_config[@$_POST['schema1']];
$schema2 = $dbs_config[@$_POST['schema2']];
$schema1 = serialize(DbDiff::export($schema1['config'], $schema1['name']));
$schema2 = serialize(DbDiff::export($schema2['config'], $schema2['name']));
}
do_compare($schema1, $schema2);
echo '<p><a href="?">« Back to main page</a></p>';
break;
default:
show_options($dbs_config);
}
?>
<div id="footer">
<p>More information on this tool is available from the corresponding <a href="http://joefreeman.co.uk/blog/2009/07/php-script-to-compare-mysql-database-schemas/">blog post</a>.</p>
</div>
</div>
</body>
</html>
} else {
$limArray = array('gen_user_id' => intval($_POST['inbox_count'][$id]), 'gen_ip' => intval($_POST['outbox_count'][$id]), 'gen_intdata' => intval($_POST['inbox_size'][$id]), 'gen_chardata' => intval($_POST['outbox_size'][$id]));
if ($sql->update('generic', array('data' => $limArray, 'WHERE' => 'gen_id = ' . $id))) {
e107::getLog()->logArrayAll('PM_ADM_06', $limArray);
$mes->addSuccess($id . ADLAN_PM_11);
} else {
e107::getLog()->log_event('PM_ADM_09', '');
$mes->addError($id . ADLAN_PM_7);
}
}
}
}
$ns->tablerender($caption, $mes->render() . $text);
switch ($action) {
case 'main':
$ns->tablerender(ADLAN_PM_12, show_options($pm_prefs));
break;
case 'limits':
$ns->tablerender(ADLAN_PM_14, show_limits($pm_prefs));
$ns->tablerender(ADLAN_PM_15, add_limit($pm_prefs));
break;
case 'maint':
$ns->tablerender(ADLAN_PM_60, show_maint($pm_prefs));
break;
}
require_once e_ADMIN . 'footer.php';
function show_options($pm_prefs)
{
$frm = e107::getForm();
$txt = "\n\t<fieldset id='plugin-pm-prefs'>\n\t<form method='post' action='" . e_SELF . "'>\n\t<table class='table adminform'>\n\t<colgroup span='2'>\n\t\t<col class='col-label' />\n\t\t<col class='col-control' />\n\t</colgroup>\n\t<tbody>\n\t<tr>\n\t\t<td>" . ADLAN_PM_16 . "</td>\n\t\t<td>" . $frm->text('pm_option-title', $pm_prefs['title'], '50') . "</td>\n\t</tr>\n\t<tr>\n\t\t<td>" . ADLAN_PM_17 . "</td>\n\t\t<td>" . $frm->radio_switch('pm_option-animate', $pm_prefs['animate'], LAN_YES, LAN_NO) . "</td>\n\t</tr>\n\t<tr>\n\t\t<td>" . ADLAN_PM_18 . "</td>\n\t\t<td>" . $frm->radio_switch('pm_option-dropdown', $pm_prefs['dropdown'], LAN_YES, LAN_NO) . "</td>\n\t</tr>\n\t<tr>\n\t\t<td>" . ADLAN_PM_19 . "</td>\n\t\t<td>" . $frm->text('pm_option-read_timeout', $pm_prefs['read_timeout'], '5', array('class' => 'tbox input-text')) . "</td>\n\t</tr>\n\t<tr>\n\t\t<td>" . ADLAN_PM_20 . "</td>\n\t\t<td>" . $frm->text('pm_option-unread_timeout', $pm_prefs['unread_timeout'], '5', array('class' => 'tbox input-text')) . "</td>\n\t</tr>\n\t<tr>\n\t\t<td>" . ADLAN_PM_21 . "</td>\n\t\t<td>" . $frm->radio_switch('pm_option-popup', $pm_prefs['popup'], LAN_YES, LAN_NO) . "</td>\n\t</tr>\n\t<tr>\n\t\t<td>" . ADLAN_PM_22 . "</td>\n\t\t<td>" . $frm->text('pm_option-popup_delay', $pm_prefs['popup_delay'], '5', array('class' => 'tbox input-text')) . " " . ADLAN_PM_44 . "</td>\n\t</tr>\n\t<tr>\n\t\t<td>" . ADLAN_PM_23 . "</td>\n\t\t<td>" . e107::getUserClass()->uc_dropdown('pm_option-pm_class', $pm_prefs['pm_class'], 'member,admin,classes') . "</td>\n\t</tr>\n\t<tr>\n\t\t<td>" . ADLAN_PM_24 . "</td>\n\t\t<td>" . $frm->text('pm_option-perpage', $pm_prefs['perpage'], '5', array('class' => 'tbox input-text')) . "</td>\n\t</tr>\n\t<tr>\n\t\t<td>" . ADLAN_PM_25 . "</td>\n\t\t<td>" . e107::getUserClass()->uc_dropdown('pm_option-notify_class', $pm_prefs['notify_class'], 'nobody,member,admin,classes') . "</td>\n\t</tr>\n\t<tr>\n\t\t<td>" . ADLAN_PM_26 . "</td>\n\t\t<td>" . e107::getUserClass()->uc_dropdown('pm_option-receipt_class', $pm_prefs['receipt_class'], 'nobody,member,admin,classes') . "</td>\n\t</tr>\n\t<tr>\n\t\t<td>" . ADLAN_PM_27 . "</td>\n\t\t<td>" . e107::getUserClass()->uc_dropdown('pm_option-attach_class', $pm_prefs['attach_class'], 'nobody,member,admin,classes') . "</td>\n\t</tr>\n\t<tr>\n\t\t<td>" . ADLAN_PM_28 . "</td>\n\t\t<td>" . $frm->text('pm_option-attach_size', $pm_prefs['attach_size'], '8', array('class' => 'tbox input-text')) . " kB</td>\n\t</tr>\n\t<tr>\n\t\t<td>" . ADLAN_PM_29 . "</td>\n\t\t<td>" . e107::getUserClass()->uc_dropdown('pm_option-sendall_class', $pm_prefs['sendall_class'], 'nobody,member,admin,classes') . "</td>\n\t</tr>\n\t<tr>\n\t\t<td>" . ADLAN_PM_30 . "</td>\n\t\t<td>" . e107::getUserClass()->uc_dropdown('pm_option-multi_class', $pm_prefs['multi_class'], 'nobody,member,admin,classes') . "</td>\n\t</tr>\n\t<tr>\n\t\t<td>" . ADLAN_PM_31 . "</td>\n\t\t<td>" . e107::getUserClass()->uc_dropdown('pm_option-opt_userclass', $pm_prefs['opt_userclass'], 'nobody,member,admin,classes') . "</td>\n\t</tr>\n\t<tr>\n\t\t<td>" . ADLAN_PM_81 . "</td>\n\t\t<td>" . $frm->text('pm_option-pm_max_send', $pm_prefs['pm_max_send'], '5', array('class' => 'tbox input-text')) . "<span class='field-help'>" . ADLAN_PM_82 . "</span></td>\n\t</tr>\n\t</tbody>\n\t</table>\n\t<div class='buttons-bar center'>\n\t\t" . $frm->admin_button('update_prefs', 'no-value', 'update', LAN_UPDATE) . "\n\t</div>\n\t</form>\n\t</fieldset>\n\t";
return $txt;
function init(array $options = array())
{
global $databases;
if (!isset($databases['drupal6'])) {
die(drush_set_error(dt('Unable to find Drupal 6 database.')));
}
$trace = debug_backtrace();
$caller = isset($trace[0]['file']) ? $trace[0]['file'] : __FILE__;
$task = drush_get_option('task');
//$default_commands = default_commands();
//$commands = array_merge($default_commands, $options['commands']);
$commands = $options['commands'];
// Add exit command to end of the commands options
$commands[] = array('label' => t('Exit'), 'callback' => array('drush_exit'));
prepare($caller);
if ($task) {
foreach ($commands as $key => $command) {
if ($commands[$key]['label'] == $task) {
$action = $key;
}
}
if ($action) {
run($action, $commands);
} else {
drush_log('Unable to load task', 'error');
}
} else {
show_options($commands);
}
}
