diff options
Diffstat (limited to 'old/admin/addiadj.php')
| -rw-r--r-- | old/admin/addiadj.php | 424 |
1 files changed, 0 insertions, 424 deletions
diff --git a/old/admin/addiadj.php b/old/admin/addiadj.php deleted file mode 100644 index b768200..0000000 --- a/old/admin/addiadj.php +++ /dev/null @@ -1,424 +0,0 @@ -<?php
-/******************************
- * EQdkp
- * Copyright 2002-2003
- * Licensed under the GNU GPL. See COPYING for full terms.
- * ------------------
- * addiadj.php
- * Began: Sun January 5 2003
- *
- * $Id: addiadj.php 46 2007-06-19 07:29:11Z tsigo $
- *
- ******************************/
-
-define('EQDKP_INC', true);
-define('IN_ADMIN', true);
-$eqdkp_root_path = './../';
-include_once($eqdkp_root_path . 'common.php');
-
-class Add_IndivAdj extends EQdkp_Admin
-{
- var $adjustment = array(); // Holds adjustment data if URI_ADJUSTMENT is set @var adjustment
- var $old_adjustment = array(); // Holds adjustment data from before POST @var old_adjustment
-
- function add_indivadj()
- {
- global $db, $eqdkp, $user, $tpl, $pm;
- global $eqdkp_root_path, $SID;
-
- parent::eqdkp_admin();
-
- $this->adjustment = array(
- 'adjustment_value' => post_or_db('adjustment_value'),
- 'adjustment_reason' => post_or_db('adjustment_reason'),
- 'member_names' => post_or_db('member_names')
- );
-
- // Vars used to confirm deletion
- $this->set_vars(array(
- 'confirm_text' => $user->lang['confirm_delete_iadj'],
- 'uri_parameter' => URI_ADJUSTMENT)
- );
-
- $this->assoc_buttons(array(
- 'add' => array(
- 'name' => 'add',
- 'process' => 'process_add',
- 'check' => 'a_indivadj_add'),
- 'update' => array(
- 'name' => 'update',
- 'process' => 'process_update',
- 'check' => 'a_indivadj_upd'),
- 'delete' => array(
- 'name' => 'delete',
- 'process' => 'process_delete',
- 'check' => 'a_indivadj_del'),
- 'form' => array(
- 'name' => '',
- 'process' => 'display_form',
- 'check' => 'a_indivadj_'))
- );
-
- $cur_hash = hash_filename("addiadj.php");
- //print"HASH::$cur_hash::<br>";
-
-
- // Build the adjustment aray
- // -----------------------------------------------------
- if ( $this->url_id )
- {
- $sql = 'SELECT adjustment_value, adjustment_date, adjustment_reason, member_name, adjustment_group_key
- FROM ' . ADJUSTMENTS_TABLE . "
- WHERE adjustment_id='" . $this->url_id . "'";
- $result = $db->query($sql);
- if ( !$row = $db->fetch_record($result) )
- {
- message_die($user->lang['error_invalid_adjustment']);
- }
- $db->free_result($result);
-
- // If member name isn't set, it's a group adjustment - put them back on that script
- if ( !isset($row['member_name']) )
- {
- redirect('addadj.php' . $SID . '&' . URI_ADJUSTMENT . '='.$adjustment_id);
- }
-
- $this->time = $row['adjustment_date'];
- $this->adjustment = array(
- 'adjustment_value' => post_or_db('adjustment_value', $row),
- 'adjustment_reason' => post_or_db('adjustment_reason', $row)
- );
-
- $members = array();
- $sql = 'SELECT member_name
- FROM ' . ADJUSTMENTS_TABLE . "
- WHERE adjustment_group_key='".$row['adjustment_group_key']."'";
- $result = $db->query($sql);
- while ( $row = $db->fetch_record($result) )
- {
- $members[] = $row['member_name'];
- }
- $db->free_result($result);
-
- $this->adjustment['member_names'] = ( !empty($_POST['member_names']) ) ? $_POST['member_names'] : $members;
- unset($row, $members, $sql);
- }
- }
-
- function error_check()
- {
- global $user;
-
- if ( (!isset($_POST['member_names'])) || (!is_array($_POST['member_names'])) )
- {
- $this->fv->errors['member_names'] = $user->lang['fv_required_members'];
- }
-
- $this->fv->is_number('adjustment_value', $user->lang['fv_number_adjustment']);
- $this->fv->is_filled('adjustment_value', $user->lang['fv_required_adjustment']);
- $this->fv->is_within_range('mo', 1, 12, $user->lang['fv_range_month']);
- $this->fv->is_within_range('d', 1, 31, $user->lang['fv_range_day']);
- $this->fv->is_within_range('y', 1998, 2010, $user->lang['fv_range_year']);
-
- $this->time = mktime(0, 0, 0, $_POST['mo'], $_POST['d'], $_POST['y']);
-
- return $this->fv->is_error();
- }
-
- // ---------------------------------------------------------
- // Process Add
- // ---------------------------------------------------------
- function process_add()
- {
- global $db, $eqdkp, $user, $tpl, $pm;
- global $eqdkp_root_path, $SID;
-
- //
- // Generate our group key
- //
- $group_key = $this->gen_group_key($this->time, stripslashes($_POST['adjustment_reason']), $_POST['adjustment_value']);
-
- //
- // Add adjustment to selected members
- //
- foreach ( $_POST['member_names'] as $member_name )
- {
- $this->add_new_adjustment($member_name, $group_key);
- }
-
- //
- // Logging
- //
- $log_action = array(
- 'header' => '{L_ACTION_INDIVADJ_ADDED}',
- '{L_ADJUSTMENT}' => $_POST['adjustment_value'],
- '{L_REASON}' => stripslashes($_POST['adjustment_reason']),
- '{L_MEMBERS}' => implode(', ', $_POST['member_names']),
- '{L_ADDED_BY}' => $this->admin_user);
- $this->log_insert(array(
- 'log_type' => $log_action['header'],
- 'log_action' => $log_action)
- );
-
- //
- // Success message
- //
- $success_message = sprintf($user->lang['admin_add_iadj_success'], $eqdkp->config['dkp_name'], $_POST['adjustment_value'], implode(', ', $_POST['member_names']));
- $link_list = array(
- $user->lang['list_indivadj'] => 'listadj.php' . $SID . '&' . URI_PAGE . '=individual',
- $user->lang['list_members'] => $eqdkp_root_path . 'listmembers.php' . $SID);
- $this->admin_die($success_message, $link_list);
- }
-
- // ---------------------------------------------------------
- // Process Update
- // ---------------------------------------------------------
- function process_update()
- {
- global $db, $eqdkp, $user, $tpl, $pm;
- global $eqdkp_root_path, $SID;
-
- //
- // Remove the old adjustment from members that received it
- // and then remove the adjustment itself
- //
- $this->remove_old_adjustment();
-
- //
- // Generate a new group key
- //
- $group_key = $this->gen_group_key($this->time, stripslashes($_POST['adjustment_reason']), $_POST['adjustment_value']);
-
- //
- // Add the new adjustment to selected members
- //
- foreach ( $_POST['member_names'] as $member_name )
- {
- $this->add_new_adjustment($member_name, $group_key);
- }
-
- //
- // Logging
- //
- $log_action = array(
- 'header' => '{L_ACTION_INDIVADJ_UPDATED}',
- 'id' => $this->url_id,
- '{L_ADJUSTMENT_BEFORE}' => $this->old_adjustment['adjustment_value'],
- '{L_REASON_BEFORE}' => $this->old_adjustment['adjustment_reason'],
- '{L_MEMBERS_BEFORE}' => implode(', ', $this->old_adjustment['member_names']),
- '{L_ADJUSTMENT_AFTER}' => $this->find_difference($this->old_adjustment['adjustment_value'], $_POST['adjustment_value']),
- '{L_REASON_AFTER}' => $this->find_difference($this->old_adjustment['adjustment_reason'], $_POST['adjustment_reason']),
- '{L_MEMBERS_AFTER}' => implode(', ', $this->find_difference($this->old_adjustment['member_names'], $_POST['member_names'])),
- '{L_UPDATED_BY}' => $this->admin_user);
- $this->log_insert(array(
- 'log_type' => $log_action['header'],
- 'log_action' => $log_action)
- );
-
- //
- // Success message
- //
- $success_message = sprintf($user->lang['admin_update_iadj_success'], $eqdkp->config['dkp_name'], $_POST['adjustment_value'], implode(', ', $_POST['member_names']));
- $link_list = array(
- $user->lang['list_indivadj'] => 'listadj.php' . $SID . '&' . URI_PAGE . '=individual',
- $user->lang['list_members'] => $eqdkp_root_path . 'listmembers.php' . $SID);
- $this->admin_die($success_message, $link_list);
- }
-
- // ---------------------------------------------------------
- // Process Delete (confirmed)
- // ---------------------------------------------------------
- function process_confirm()
- {
- global $db, $eqdkp, $user, $tpl, $pm;
- global $eqdkp_root_path, $SID;
-
- //
- // Remove the old adjustment from members that received it
- // and then remove the adjustment itself
- //
- $this->remove_old_adjustment();
-
- //
- // Logging
- //
- $log_action = array(
- 'header' => '{L_ACTION_INDIVADJ_DELETED}',
- 'id' => $this->url_id,
- '{L_ADJUSTMENT}' => $this->old_adjustment['adjustment_value'],
- '{L_REASON}' => $this->old_adjustment['adjustment_reason'],
- '{L_MEMBERS}' => implode(', ', $this->old_adjustment['member_names']));
- $this->log_insert(array(
- 'log_type' => $log_action['header'],
- 'log_action' => $log_action)
- );
-
- //
- // Success messages
- //
- $success_message = sprintf($user->lang['admin_delete_iadj_success'], $eqdkp->config['dkp_name'], $this->old_adjustment['adjustment_value'], implode(', ', $this->old_adjustment['member_names']));
- $link_list = array(
- $user->lang['list_indivadj'] => 'listadj.php' . $SID . '&' . URI_PAGE . '=individual',
- $user->lang['list_members'] => $eqdkp_root_path . 'listmembers.php' . $SID);
- $this->admin_die($success_message, $link_list);
- }
-
- // ---------------------------------------------------------
- // Process helper methods
- // ---------------------------------------------------------
- function remove_old_adjustment()
- {
- global $db;
-
- $adjustment_ids = array();
- $old_members = array();
-
- $sql = 'SELECT a2.*
- FROM (' . ADJUSTMENTS_TABLE . ' a1
- LEFT JOIN ' . ADJUSTMENTS_TABLE . " a2
- ON a1.adjustment_group_key = a2.adjustment_group_key)
- WHERE a1.adjustment_id='" . $this->url_id . "'";
- $result = $db->query($sql);
- while ( $row = $db->fetch_record($result) )
- {
- $adjustment_ids[] = $row['adjustment_id'];
-
- $old_members[] = addslashes($row['member_name']);
- $this->old_adjustment = array(
- 'adjustment_value' => addslashes($row['adjustment_value']),
- 'adjustment_date' => addslashes($row['adjustment_date']),
- 'member_names' => $old_members,
- 'adjustment_reason' => addslashes($row['adjustment_reason'])
- );
- }
-
- //
- // Remove the adjustment value from adjustments table
- //
- $sql = 'DELETE FROM ' . ADJUSTMENTS_TABLE . '
- WHERE adjustment_id IN (' . implode(', ', $adjustment_ids) . ')';
- $db->query($sql);
-
- //
- // Remove the adjustment value from members
- //
- $sql = 'UPDATE ' . MEMBERS_TABLE . '
- SET member_adjustment = member_adjustment - ' . stripslashes($this->old_adjustment['adjustment_value']) . '
- WHERE member_name IN (\'' . implode("', '", $this->old_adjustment['member_names']) . '\')';
- $db->query($sql);
- }
-
- function add_new_adjustment($member_name, $group_key)
- {
- global $db;
-
- //
- // Add the adjustment to the member
- //
- $sql = 'UPDATE ' . MEMBERS_TABLE . '
- SET member_adjustment = member_adjustment + ' . $db->escape($_POST['adjustment_value']) . "
- WHERE member_name='" . $member_name . "'";
- $db->query($sql);
- unset($sql);
-
- //
- // Add the adjustment to the database
- //
- $query = $db->build_query('INSERT', array(
- 'adjustment_value' => $_POST['adjustment_value'],
- 'adjustment_date' => $this->time,
- 'member_name' => $member_name,
- 'adjustment_reason' => $_POST['adjustment_reason'],
- 'adjustment_group_key' => $group_key,
- 'adjustment_added_by' => $this->admin_user)
- );
- $db->query('INSERT INTO ' . ADJUSTMENTS_TABLE . $query);
- }
-
- // ---------------------------------------------------------
- // Display form
- // ---------------------------------------------------------
- function display_form()
- {
- global $db, $eqdkp, $user, $tpl, $pm;
- global $eqdkp_root_path, $SID;
-
- //
- // Build member drop-down
- //
- $sql = 'SELECT member_name
- FROM ' . MEMBERS_TABLE . '
- ORDER BY member_name';
- $result = $db->query($sql);
- while ( $row = $db->fetch_record($result) )
- {
- if ( $this->url_id )
- {
- $selected = ( @in_array($row['member_name'], $this->adjustment['member_names']) ) ? ' selected="selected"' : '';
- }
- else
- {
- $selected = ( @in_array($row['member_name'], $_POST['member_names']) ) ? ' selected="selected"' : '';
- }
-
- $tpl->assign_block_vars('members_row', array(
- 'VALUE' => $row['member_name'],
- 'SELECTED' => $selected,
- 'OPTION' => $row['member_name'])
- );
- }
- $db->free_result($result);
-
- $tpl->assign_vars(array(
- // Form vars
- 'F_ADD_ADJUSTMENT' => 'addiadj.php' . $SID,
- 'ADJUSTMENT_ID' => $this->url_id,
-
- // Form values
- 'ADJUSTMENT_VALUE' => $this->adjustment['adjustment_value'],
- 'ADJUSTMENT_REASON' => stripslashes(htmlspecialchars($this->adjustment['adjustment_reason'])),
- 'MO' => date('m', stripslashes($this->time)),
- 'D' => date('d', stripslashes($this->time)),
- 'Y' => date('Y', stripslashes($this->time)),
- 'H' => date('h', stripslashes($this->time)),
- 'MI' => date('i', stripslashes($this->time)),
- 'S' => date('s', stripslashes($this->time)),
-
- // Language
- 'L_ADD_IADJ_TITLE' => $user->lang['addiadj_title'],
- 'L_MEMBERS' => $user->lang['members'],
- 'L_HOLD_CTRL_NOTE' => '(' . $user->lang['hold_ctrl_note'] . ')<br />',
- 'L_REASON' => $user->lang['reason'],
- 'L_VALUE' => $user->lang['value'],
- 'L_ADJUSTMENT_VALUE_NOTE' => strtolower($user->lang['adjustment_value_note']),
- 'L_DATE' => $user->lang['date'],
- 'L_ADD_ADJUSTMENT' => $user->lang['add_adjustment'],
- 'L_RESET' => $user->lang['reset'],
- 'L_UPDATE_ADJUSTMENT' => $user->lang['update_adjustment'],
- 'L_DELETE_ADJUSTMENT' => $user->lang['delete_adjustment'],
-
- // Form validation
- 'FV_MEMBERS' => $this->fv->generate_error('member_names'),
- 'FV_ADJUSTMENT' => $this->fv->generate_error('adjustment_value'),
- 'FV_MO' => $this->fv->generate_error('mo'),
- 'FV_D' => $this->fv->generate_error('d'),
- 'FV_Y' => $this->fv->generate_error('y'),
-
- // Javascript messages
- 'MSG_VALUE_EMPTY' => $user->lang['fv_required_adjustment'],
-
- // Buttons
- 'S_ADD' => ( !$this->url_id ) ? true : false)
- );
-
- $eqdkp->set_vars(array(
- 'page_title' => sprintf($user->lang['admin_title_prefix'], $eqdkp->config['guildtag'], $eqdkp->config['dkp_name']).': '.$user->lang['addiadj_title'],
- 'template_file' => 'admin/addiadj.html',
- 'display' => true)
- );
- }
-}
-
-$add_indivadj = new Add_IndivAdj;
-$add_indivadj->process();
-?>
|