phpScheduleIt
June 19, 2013, 09:53:31 AM *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: phpScheduleIt 2.4.2 has been released!
 
   Home   Help Login Register  
Pages: [1]
  Print  
Author Topic: manage reservations, how to display another database field  (Read 805 times)
kaotik78
Newbie
*

Karma: 0
Posts: 4


« on: March 19, 2010, 07:01:03 PM »

Hi,

I've been trying again to figure something else out with this program and I'm having a difficult time with it.

When logged in as administrator, and then click on manage reservations, I would like to show another field that's in the login table in the phpscheduleit database.

So ultimately it would look like


Start Date   End Date   User      -->Location<--   Start Time   End Time   View   Modify   Delete


Location would be the street address pulled from the login table. I can't seem to get it to show up. I've tried $users->streetaddress;  streetaddress, no dice. Probably just a different way of coding that's probably very easy, but I'm overthinking it!
Logged
kaotik78
Newbie
*

Karma: 0
Posts: 4


« Reply #1 on: March 20, 2010, 03:14:52 PM »

Amazing what a day's rest can accomplish Smiley

All figured out!

What I did was add the field I needed in AdminDB.class.php on line 76, then went to admin.template.php and on line 785 I added this code to allow it to appear.

<td width=\"10%\">" . $link->getLink($_SERVER['PHP_SELF'] . $util->getSortingUrl($_SERVER['QUERY_STRING'], 'location'), translate('Location')) . "</td>

Then beneath that between line 807 and 809 I added this . '<td style="text-align: left">' . $cur['streetaddress'] . "</td>"

I had to sit down with pen/paper to map how everything is called together, in order to keep track of everything, it helped Smiley
Logged
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.18 | SMF © 2006-2007, Simple Machines Valid XHTML 1.0! Valid CSS!