import_mayday.php File Reference

Go to the source code of this file.

Functions
	handle_pear_error ($error_obj)
	insertCategory ($in_cat)
	insertLocation ($in_loc)
	insertProfile ($in_profile)
	insertMayday ($in_job)
	insertHistory ($in_entry)
	insertComment ($in_entry)
Variables
	$srcDSN = $argv[1]
	$destDSN = $argv[2]
	$o_srcDB = DB::connect($srcDSN)
	$o_destDB = DB::connect($destDSN)
	$s_sql = 'DELETE FROM mayday_locations'
	$a_loc = $o_srcDB->getAll($s_sql, null, DB_FETCHMODE_ASSOC)
	$a_locCache = array()
	$a_resolutions = $o_destDB->getAll($s_sql, null, DB_FETCHMODE_ASSOC)
	$a_resCache = array()
	$a_statuses = $o_destDB->getAll($s_sql, null, DB_FETCHMODE_ASSOC)
	$a_statusCache = array()
	$a_prios = $o_destDB->getAll($s_sql, null, DB_FETCHMODE_ASSOC)
	$a_priCache = array()
	$a_cats = $o_srcDB->getAll($s_sql, null, DB_FETCHMODE_ASSOC)
	$a_catCache = array()
	$a_users = $o_srcDB->getAll($s_sql, null, DB_FETCHMODE_ASSOC)
	$a_userCache = array()
	$a_addUsers = file('create_users')
	$a_addUser ['user_fname'] = $a_user[1]
	$a_maydays = $o_srcDB->getAll($s_sql, null, DB_FETCHMODE_ASSOC)
	$a_maydayCache = array()
else	$a_mayday ['job_category'] = $a_catCache['other']
	$a_logs = $o_srcDB->getAll($s_sql, null, DB_FETCHMODE_ASSOC)
	$a_logCache = array()
	$a_log ['mayday_id'] = $a_maydayCache[$a_log['mayday_id']]
	break
case	__pad0__
case	__pad1__
case	__pad2__
case	__pad3__
case	__pad4__
case	__pad5__
case	__pad6__
case	__pad7__
case	__pad8__
case	__pad9__
case	__pad10__
	case
case	__pad11__
default	__pad12__

---

Function Documentation

handle_pear_error (  $  error_obj  )

Definition at line 19 of file import_mayday.php.

insertCategory (  $  in_cat  )

Definition at line 311 of file import_mayday.php. References $o_destDB, and $s_sql.

insertComment (  $  in_entry  )

Definition at line 398 of file import_mayday.php. References $o_destDB, and $s_sql.

insertHistory (  $  in_entry  )

Definition at line 384 of file import_mayday.php. References $o_destDB, and $s_sql.

insertLocation (  $  in_loc  )

Definition at line 324 of file import_mayday.php. References $o_destDB, and $s_sql.

insertMayday (  $  in_job  )

Definition at line 360 of file import_mayday.php. References $o_destDB, and $s_sql.

insertProfile (  $  in_profile  )

Definition at line 337 of file import_mayday.php. References $o_destDB, and $s_sql.

---

Variable Documentation

$a_addUser['user_id'] = $a_user[1]

Definition at line 87 of file import_mayday.php.

$a_addUsers = file('create_users')

Definition at line 84 of file import_mayday.php.

$a_catCache = array()

Definition at line 67 of file import_mayday.php.

$a_cats = $o_srcDB->getAll($s_sql, null, DB_FETCHMODE_ASSOC)

Definition at line 66 of file import_mayday.php. Referenced by FF_Action_Form_Ticket::createFormElements().

$a_loc = $o_srcDB->getAll($s_sql, null, DB_FETCHMODE_ASSOC)

Definition at line 32 of file import_mayday.php.

$a_locCache = array()

Definition at line 33 of file import_mayday.php.

$a_log['new_value'] = $a_maydayCache[$a_log['mayday_id']]

Definition at line 185 of file import_mayday.php.

$a_logCache = array()

Definition at line 177 of file import_mayday.php.

$a_logs = $o_srcDB->getAll($s_sql, null, DB_FETCHMODE_ASSOC)

Definition at line 176 of file import_mayday.php.

$a_mayday['resolution'] = $a_catCache['other']

Definition at line 108 of file import_mayday.php.

$a_maydayCache = array()

Definition at line 102 of file import_mayday.php.

$a_maydays = $o_srcDB->getAll($s_sql, null, DB_FETCHMODE_ASSOC)

Definition at line 101 of file import_mayday.php.

$a_priCache = array()

Definition at line 57 of file import_mayday.php.

$a_prios = $o_destDB->getAll($s_sql, null, DB_FETCHMODE_ASSOC)

Definition at line 56 of file import_mayday.php.

$a_resCache = array()

Definition at line 42 of file import_mayday.php.

$a_resolutions = $o_destDB->getAll($s_sql, null, DB_FETCHMODE_ASSOC)

Definition at line 41 of file import_mayday.php.

$a_statusCache = array()

Definition at line 50 of file import_mayday.php.

$a_statuses = $o_destDB->getAll($s_sql, null, DB_FETCHMODE_ASSOC)

Definition at line 49 of file import_mayday.php.

$a_userCache[$a_addUser['user_id']] = array()

Definition at line 79 of file import_mayday.php.

$a_users = $o_srcDB->getAll($s_sql, null, DB_FETCHMODE_ASSOC)

Definition at line 78 of file import_mayday.php. Referenced by FF_Output_Mayday::getFormattedWatchlist(), FF_Model_Ticket::getHandlerOptions(), FF_DataAccess_Permissions_mysql::getUsersForObject(), and FF_Action_GetHandlers::run().

$destDSN = $argv[2]

Definition at line 17 of file import_mayday.php.

$o_destDB = DB::connect($destDSN)

Definition at line 26 of file import_mayday.php. Referenced by insertCategory(), insertComment(), insertHistory(), insertLocation(), insertMayday(), and insertProfile().

$o_srcDB = DB::connect($srcDSN)

Definition at line 25 of file import_mayday.php.

$s_sql = 'DELETE FROM mayday_locations'

Definition at line 28 of file import_mayday.php.

$srcDSN = $argv[1]

Definition at line 14 of file import_mayday.php.

case __pad0__

Definition at line 203 of file import_mayday.php.

case __pad10__

Definition at line 285 of file import_mayday.php.

case __pad11__

Definition at line 294 of file import_mayday.php.

default __pad12__

Definition at line 300 of file import_mayday.php.

case __pad1__

Definition at line 228 of file import_mayday.php.

case __pad2__

Definition at line 233 of file import_mayday.php.

case __pad3__

Definition at line 238 of file import_mayday.php.

case __pad4__

Definition at line 243 of file import_mayday.php.

case __pad5__

Definition at line 248 of file import_mayday.php.

case __pad6__

Definition at line 255 of file import_mayday.php.

case __pad7__

Definition at line 262 of file import_mayday.php.

case __pad8__

Definition at line 269 of file import_mayday.php.

case __pad9__

Definition at line 275 of file import_mayday.php.

break

Definition at line 201 of file import_mayday.php.

case

Definition at line 290 of file import_mayday.php.

---