Changeset 295 for trunk/services
- Timestamp:
- Dec 16, 2007 7:21:57 AM (16 years ago)
- Location:
- trunk/services
- Files:
-
- 8 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/services/admins.php
r266 r295 39 39 40 40 // Instantiate a sorting object with the default sort and order. Add SQL for each column. 41 $so = new SortOrder('admin_ tbl.admin_id', 'DESC');42 $so->setColumn('admin_ tbl.admin_id', 'admin_tbl.admin_id ASC', 'admin_tbl.admin_idDESC');43 $so->setColumn(' admin_tbl.username', 'admin_tbl.username ASC', 'admin_tbl.usernameDESC');44 $so->setColumn(' admin_tbl.userpass', 'admin_tbl.userpass ASC', 'admin_tbl.userpass DESC');45 $so->setColumn(' admin_tbl.first_name', 'admin_tbl.first_name ASC', 'admin_tbl.first_name DESC');46 $so->setColumn(' admin_tbl.last_name', 'admin_tbl.last_name ASC', 'admin_tbl.last_name DESC');47 $so->setColumn(' admin_tbl.email', 'admin_tbl.email ASC', 'admin_tbl.email DESC');48 $so->setColumn(' admin_tbl.user_type', 'admin_tbl.user_type ASC', 'admin_tbl.user_type DESC');49 $so->setColumn(' admin_tbl.seconds_online', 'admin_tbl.seconds_online ASC', 'admin_tbl.seconds_online DESC');50 $so->setColumn(' admin_tbl.last_login_datetime', 'admin_tbl.last_login_datetime ASC', 'admin_tbl.last_login_datetime DESC');51 $so->setColumn(' admin_tbl.last_access_datetime', 'admin_tbl.last_access_datetime ASC', 'admin_tbl.last_access_datetime DESC');52 $so->setColumn(' admin_tbl.last_login_ip', 'admin_tbl.last_login_ip ASC', 'admin_tbl.last_login_ip DESC');53 $so->setColumn('ad min_tbl.added_by_user_id', 'admin_tbl.added_by_user_id ASC', 'admin_tbl.added_by_user_id DESC');54 $so->setColumn(' admin_tbl.modified_by_user_id', 'admin_tbl.modified_by_user_id ASC', 'admin_tbl.modified_by_user_id DESC');55 $so->setColumn('ad min_tbl.added_datetime', 'admin_tbl.added_datetime ASC', 'admin_tbl.added_datetime DESC');56 $so->setColumn(' admin_tbl.modified_datetime', 'admin_tbl.modified_datetime ASC', 'admin_tbl.modified_datetime DESC');41 $so = new SortOrder('admin_id', 'DESC'); 42 $so->setColumn('admin_id', $auth->getParam('db_primary_key') . ' ASC', $auth->getParam('db_primary_key') . ' DESC'); 43 $so->setColumn('username', $auth->getParam('db_username_column') . ' ASC', $auth->getParam('db_username_column') . ' DESC'); 44 $so->setColumn('userpass', $auth->getParam('db_table') . '.userpass ASC', $auth->getParam('db_table') . '.userpass DESC'); 45 $so->setColumn('first_name', $auth->getParam('db_table') . '.first_name ASC', $auth->getParam('db_table') . '.first_name DESC'); 46 $so->setColumn('last_name', $auth->getParam('db_table') . '.last_name ASC', $auth->getParam('db_table') . '.last_name DESC'); 47 $so->setColumn('email', $auth->getParam('db_table') . '.email ASC', $auth->getParam('db_table') . '.email DESC'); 48 $so->setColumn('user_type', $auth->getParam('db_table') . '.user_type ASC', $auth->getParam('db_table') . '.user_type DESC'); 49 $so->setColumn('seconds_online', $auth->getParam('db_table') . '.seconds_online ASC', $auth->getParam('db_table') . '.seconds_online DESC'); 50 $so->setColumn('last_login_datetime', $auth->getParam('db_table') . '.last_login_datetime ASC', $auth->getParam('db_table') . '.last_login_datetime DESC'); 51 $so->setColumn('last_access_datetime', $auth->getParam('db_table') . '.last_access_datetime ASC', $auth->getParam('db_table') . '.last_access_datetime DESC'); 52 $so->setColumn('last_login_ip', $auth->getParam('db_table') . '.last_login_ip ASC', $auth->getParam('db_table') . '.last_login_ip DESC'); 53 $so->setColumn('added_by_user_id', $auth->getParam('db_table') . '.added_by_user_id ASC', $auth->getParam('db_table') . '.added_by_user_id DESC'); 54 $so->setColumn('modified_by_user_id', $auth->getParam('db_table') . '.modified_by_user_id ASC', $auth->getParam('db_table') . '.modified_by_user_id DESC'); 55 $so->setColumn('added_datetime', $auth->getParam('db_table') . '.added_datetime ASC', $auth->getParam('db_table') . '.added_datetime DESC'); 56 $so->setColumn('modified_datetime', $auth->getParam('db_table') . '.modified_datetime ASC', $auth->getParam('db_table') . '.modified_datetime DESC'); 57 57 58 58 // Instantiate page numbers. Total items are set and calculation is done in the getRecordList function. … … 143 143 if (getFormdata('cancel', false)) { 144 144 // Remove lock 145 $lock->select( 'admin_tbl', 'admin_id', getFormData('admin_id'));145 $lock->select($auth->getParam('db_table'), $auth->getParam('db_primary_key'), getFormData('admin_id')); 146 146 $lock->remove(); 147 147 if ($app->validBoomerangURL('admins')) { … … 162 162 if (getFormdata('repeat', false)) { 163 163 // Display edit function with next available ID. 164 $qid = $db->query("SELECT admin_id FROM admin_tbl WHERE admin_id > '" . $db->escapeString(getFormData('admin_id')) . "' ORDER BY admin_idASC LIMIT 1");164 $qid = $db->query("SELECT " . $auth->getParam('db_primary_key') . " FROM " . $auth->getParam('db_table') . " WHERE " . $auth->getParam('db_primary_key') . " > '" . $db->escapeString(getFormData('admin_id')) . "' ORDER BY " . $auth->getParam('db_primary_key') . " ASC LIMIT 1"); 165 165 if (list($next_id) = mysql_fetch_row($qid)) { 166 166 $app->dieURL($_SERVER['PHP_SELF'] . '?op=edit&admin_id=' . $next_id); … … 265 265 function &editRecordForm($id) 266 266 { 267 global $auth; 267 268 global $lock; 268 269 $app =& App::getInstance(); 269 270 $db =& DB::getInstance(); 270 271 271 $lock->select( 'admin_tbl', 'admin_id', $id);272 $lock->select($auth->getParam('db_table'), $auth->getParam('db_primary_key'), $id); 272 273 if ($lock->isLocked() && !$lock->isMine()) { 273 274 $lock->dieErrorPage(); … … 276 277 // Get the information for the form. 277 278 $qid = $db->query(" 278 SELECT * 279 FROM admin_tbl 280 WHERE admin_id = '" . $db->escapeString($id) . "' 279 SELECT *, 280 " . $auth->getParam('db_primary_key') . " AS admin_id 281 FROM " . $auth->getParam('db_table') . " 282 WHERE " . $auth->getParam('db_primary_key') . " = '" . $db->escapeString($id) . "' 281 283 "); 282 284 if (!$frm = mysql_fetch_assoc($qid)) { … … 287 289 288 290 // Lock this record. 289 $lock->set( 'admin_tbl', 'admin_id', $id, $frm['username']);291 $lock->set($auth->getParam('db_table'), $auth->getParam('db_primary_key'), $id, $frm['username']); 290 292 291 293 // Set misc values for the form. … … 328 330 $db =& DB::getInstance(); 329 331 330 $lock->select( 'admin_tbl', 'admin_id', $id);332 $lock->select($auth->getParam('db_table'), $auth->getParam('db_primary_key'), $id); 331 333 if ($lock->isLocked() && !$lock->isMine()) { 332 334 $lock->dieErrorPage(); … … 338 340 // Get the information for this object. 339 341 $qid = $db->query(" 340 SELECT username, user_type from admin_tbl341 WHERE admin_id= '" . $db->escapeString($id) . "'342 SELECT " . $auth->getParam('db_username_column') . ", user_type from " . $auth->getParam('db_table') . " 343 WHERE " . $auth->getParam('db_primary_key') . " = '" . $db->escapeString($id) . "' 342 344 "); 343 345 if (! list($name, $user_type) = mysql_fetch_row($qid)) { … … 348 350 349 351 // Get the information for this object. 350 $qid = $db->query("SELECT COUNT(*) from admin_tbl");352 $qid = $db->query("SELECT COUNT(*) from " . $auth->getParam('db_table') . ""); 351 353 list($num_admins) = mysql_fetch_row($qid); 352 354 if ('root' == $user_type && 'root' != $auth->get('user_type')) { … … 361 363 } else { 362 364 // Delete the record. 363 $db->query("DELETE FROM admin_tbl WHERE admin_id= '" . $db->escapeString($id) . "'");365 $db->query("DELETE FROM " . $auth->getParam('db_table') . " WHERE " . $auth->getParam('db_primary_key') . " = '" . $db->escapeString($id) . "'"); 364 366 $app->raiseMsg(sprintf(_("The admin <em>%s</em> has been deleted."), $name), MSG_SUCCESS, __FILE__, __LINE__); 365 367 } … … 381 383 // Insert record data. 382 384 $db->query(" 383 INSERT INTO admin_tbl(384 username,385 INSERT INTO " . $auth->getParam('db_table') . " ( 386 " . $auth->getParam('db_username_column') . ", 385 387 first_name, 386 388 last_name, … … 406 408 // Create version. 407 409 $version = Version::getInstance($auth); 408 $version->create( 'admin_tbl', 'admin_id', $last_insert_id, $frm['username']);410 $version->create($auth->getParam('db_table'), $auth->getParam('db_primary_key'), $last_insert_id, $frm['username']); 409 411 410 412 $app->raiseMsg(sprintf(_("The Administrator <em>%s</em> has been added."), $frm['username']), MSG_SUCCESS, __FILE__, __LINE__); … … 421 423 $db =& DB::getInstance(); 422 424 423 $lock->select( 'admin_tbl', 'admin_id', $frm['admin_id']);425 $lock->select($auth->getParam('db_table'), $auth->getParam('db_primary_key'), $frm['admin_id']); 424 426 if ($lock->isLocked() && !$lock->isMine()) { 425 427 $lock->dieErrorPage(); … … 437 439 // Update record data. 438 440 $db->query(" 439 UPDATE admin_tblSET440 username= '" . $db->escapeString($frm['username']) . "',441 UPDATE " . $auth->getParam('db_table') . " SET 442 " . $auth->getParam('db_username_column') . " = '" . $db->escapeString($frm['username']) . "', 441 443 first_name = '" . $db->escapeString($frm['first_name']) . "', 442 444 last_name = '" . $db->escapeString($frm['last_name']) . "', … … 445 447 modified_by_user_id = '" . $db->escapeString($auth->get('user_id')) . "', 446 448 modified_datetime = NOW() 447 WHERE admin_id= '" . $db->escapeString($frm['admin_id']) . "'449 WHERE " . $auth->getParam('db_primary_key') . " = '" . $db->escapeString($frm['admin_id']) . "' 448 450 "); 449 451 450 452 // Create version. 451 453 $version = Version::getInstance($auth); 452 $version->create( 'admin_tbl', 'admin_id', $frm['admin_id'], $frm['username']);454 $version->create($auth->getParam('db_table'), $auth->getParam('db_primary_key'), $frm['admin_id'], $frm['username']); 453 455 454 456 $app->raiseMsg(sprintf(_("The Administrator <em>%s</em> has been updated."), $frm['username']), MSG_SUCCESS, __FILE__, __LINE__); … … 464 466 global $tmp_prefs; 465 467 global $cache; 468 global $auth; 466 469 $db =& DB::getInstance(); 467 470 … … 474 477 $where_clause .= (empty($where_clause) ? 'WHERE' : 'AND') . " 475 478 ( 476 admin_tbl.usernameLIKE '%" . $db->escapeString($qry_words[$i]) . "%'477 OR admin_tbl.first_name LIKE '%" . $db->escapeString($qry_words[$i]) . "%'478 OR admin_tbl.last_name LIKE '%" . $db->escapeString($qry_words[$i]) . "%'479 OR admin_tbl.email LIKE '%" . $db->escapeString($qry_words[$i]) . "%'479 " . $auth->getParam('db_table') . "." . $auth->getParam('db_username_column') . " LIKE '%" . $db->escapeString($qry_words[$i]) . "%' 480 OR " . $auth->getParam('db_table') . ".first_name LIKE '%" . $db->escapeString($qry_words[$i]) . "%' 481 OR " . $auth->getParam('db_table') . ".last_name LIKE '%" . $db->escapeString($qry_words[$i]) . "%' 482 OR " . $auth->getParam('db_table') . ".email LIKE '%" . $db->escapeString($qry_words[$i]) . "%' 480 483 ) 481 484 "; … … 486 489 $qid = $db->query(" 487 490 SELECT COUNT(*) 488 FROM admin_tbl491 FROM " . $auth->getParam('db_table') . " 489 492 $where_clause 490 493 "); … … 498 501 $sql = " 499 502 SELECT 500 admin_tbl.*, 501 a1.username AS added_admin_username, 502 a2.username AS modified_admin_username 503 FROM admin_tbl 504 LEFT JOIN admin_tbl a1 ON (admin_tbl.added_by_user_id = a1.admin_id) 505 LEFT JOIN admin_tbl a2 ON (admin_tbl.modified_by_user_id = a2.admin_id) 503 " . $auth->getParam('db_table') . ".*, 504 " . $auth->getParam('db_table') . "." . $auth->getParam('db_primary_key') . " AS admin_id, 505 a1." . $auth->getParam('db_username_column') . " AS added_admin_username, 506 a2." . $auth->getParam('db_username_column') . " AS modified_admin_username 507 FROM " . $auth->getParam('db_table') . " 508 LEFT JOIN " . $auth->getParam('db_table') . " a1 ON (" . $auth->getParam('db_table') . ".added_by_user_id = a1." . $auth->getParam('db_primary_key') . ") 509 LEFT JOIN " . $auth->getParam('db_table') . " a2 ON (" . $auth->getParam('db_table') . ".modified_by_user_id = a2." . $auth->getParam('db_primary_key') . ") 506 510 $where_clause 507 511 " . $so->getSortOrderSQL() . " -
trunk/services/templates/admin_form.ihtml
r235 r295 1 1 <?php $fv->printErrorMessages(); ?> 2 2 3 <form method="post" action="<?php echo oTxt($_SERVER['PHP_SELF']); ?>" >3 <form method="post" action="<?php echo oTxt($_SERVER['PHP_SELF']); ?>" class="sc-form"> 4 4 <?php $app->printHiddenSession(); ?> 5 5 <input type="hidden" name="op" value="<?php echo $frm['new_op']; ?>" /> … … 46 46 <td> 47 47 <select name="user_type" class="sc-small"> 48 <?php printSetSelectForm('admin_tbl', 'user_type', $frm['user_type'], true); ?>48 <?php printSetSelectForm($auth->getParam('db_table'), 'user_type', $frm['user_type'], true); ?> 49 49 </select> 50 50 </td> -
trunk/services/templates/admin_list.ihtml
r270 r295 1 1 2 2 <?php $fv->printErrorMessages(); ?> 3 <form action="<?php echo oTxt($_SERVER['PHP_SELF']); ?>" method="get"> 4 <?php $app->printHiddenSession(false); ?> 3 5 4 <div id="commandbox"> 6 <span class="sc-nowrap commanditem"><a href="<?php echo $app->oHREF($_SERVER['PHP_SELF'] . '?op=add'); ?>"><?php echo _("Add administrator"); ?></a></span>7 8 <div class="form">5 <span class="sc-nowrap commanditem"><a href="<?php echo $app->oHREF($_SERVER['PHP_SELF'] . '?op=add'); ?>"><?php echo _("Add Administrator"); ?></a></span> 6 <form action="<?php echo oTxt($_SERVER['PHP_SELF']); ?>" method="get" class="sc-form"> 7 <?php $app->printHiddenSession(false); ?> 9 8 <input type="text" class="sc-small" size="20" name="search_query" value="<?php echo getFormData('search_query'); ?>" title="<?php echo oTxt(_("Fields searched: Admin id, Username, Userpass, First name, Last name, Email.")); ?>" /> 10 9 <input type="submit" value="<?php echo _("Search"); ?>" /> 11 </ div>10 </form> 12 11 </div> 13 12 14 13 <?php include 'list_info.ihtml'; ?> 15 14 15 <form action="<?php echo oTxt($_SERVER['PHP_SELF']); ?>" method="get" class="sc-form"> 16 16 <table class="list"> 17 17 <tr> … … 33 33 <tr> 34 34 <td class="sc-padleft sc-nowrap"><a title="<?php printf(_("Edit %s"), oTxt($list[$i]['username'])) ?>" href="<?php echo $app->oHREF($_SERVER['PHP_SELF'] . '?op=edit&admin_id=' . $list[$i]['admin_id']); ?>"><img src="/admin/_widgets/edit.gif" alt="Edit" width="14" height="18" border="0" /></a> </td> 35 <td class="sc-padleft sc-nowrap"><a title="<?php printf(_("Versions of %s"), oTxt($list[$i]['username'])) ?>" href="<?php echo $app->oHREF( '/admin/versions.php?record_table=admin_tbl&record_key=admin_id&boomerang=true&record_val=' . $list[$i]['admin_id']); ?>"><img src="/admin/_widgets/subcategory.gif" alt="" width="18" height="14" border="0" /></a> </td>35 <td class="sc-padleft sc-nowrap"><a title="<?php printf(_("Versions of %s"), oTxt($list[$i]['username'])) ?>" href="<?php echo $app->oHREF(sprintf('/admin/versions.php?record_table=%s&record_key=%s&record_val=%s&boomerang=true', $auth->getParam('db_table'), $auth->getParam('db_primary_key'), $list[$i]['admin_id'])); ?>"><img src="/admin/_widgets/subcategory.gif" alt="" width="18" height="14" border="0" /></a> </td> 36 36 <td class="sc-nowrap"><?php echo oTxt($list[$i]['admin_id'], true); ?> </td> 37 37 <td class="sc-nowrap"><?php echo oTxt($list[$i]['username'], true); ?> </td> -
trunk/services/templates/lock.ihtml
r185 r295 4 4 } 5 5 ?> 6 <form method="post" action="<?php echo oTxt($_SERVER['PHP_SELF']); ?>" >6 <form method="post" action="<?php echo oTxt($_SERVER['PHP_SELF']); ?>" class="sc-form"> 7 7 <?php $app->printHiddenSession() ?> 8 8 <input type="hidden" name="lock_id" value="<?php echo $lock->getID(); ?>" /> -
trunk/services/templates/log_list.ihtml
r270 r295 1 <form action="<?php echo oTxt($_SERVER['PHP_SELF']); ?>" method="get" >1 <form action="<?php echo oTxt($_SERVER['PHP_SELF']); ?>" method="get" class="sc-form"> 2 2 <?php $app->printHiddenSession(false); ?> 3 3 <div id="commandbox"> -
trunk/services/templates/login_form.ihtml
r291 r295 1 <form method="post" action="<?php echo oTxt($_SERVER['PHP_SELF']); ?>" >1 <form method="post" action="<?php echo oTxt($_SERVER['PHP_SELF']); ?>" class="sc-form"> 2 2 <?php $app->printHiddenSession() ?> 3 3 <table> -
trunk/services/templates/password.ihtml
r235 r295 1 1 <?php $fv->printErrorMessages(); ?> 2 2 3 <form method="post" action="<?php echo oTxt($_SERVER['PHP_SELF']); ?>" >3 <form method="post" action="<?php echo oTxt($_SERVER['PHP_SELF']); ?>" class="sc-form"> 4 4 <?php $app->printHiddenSession() ?> 5 5 <input type="hidden" name="op" value="update_password" /> -
trunk/services/templates/versions_list.ihtml
r270 r295 1 <form method="post" action="<?php echo oTxt($_SERVER['PHP_SELF']); ?>" >1 <form method="post" action="<?php echo oTxt($_SERVER['PHP_SELF']); ?>" class="sc-form"> 2 2 <?php $app->printHiddenSession() ?> 3 3 <input type="submit" name="op" value="<?php echo _("Cancel"); ?>" />
Note: See TracChangeset
for help on using the changeset viewer.