CORE Revision 1.1.45

The links you see here are partly for instructional examples, but mostly for object debugging.

List of all tickets

Warning:
    mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: NO)
/home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php, line 120 (Array)

Error:
    Connect: Access denied for user 'root'@'localhost' (using password: NO)

Error:
    Existing database connection not found

Error:
    Existing database connection not found

Tickets

A New Ticket

New Ticket

Use the form below to describe an issue you're having. This information will be passed along to a technician, and any resulting activity may be monitored from the Ticketing section.

Description Note Severity Min Med Max Critical Status Open In Work Pending Resovled

Source code

/home/bartniedner_com/core.bartniedner.com/htdocs/examples/tickets.php

<? /** * Core Example File * * @author Mark Young * @version $Id$ * @copyright MarkYoung, 19 February, 2007 * @package examples **/ include_once ($_SERVER['DOCUMENT_ROOT'] . "/core.inc.php"); include_once("ticket_functions.php"); Connect(DATA_EM7); SelectDatabase('master_data'); $ROA_ID=181; // this is the EM7 equivalent of the customer ID. if ($_POST['_action']=="note") { if ($tid = SubmitTicketNote($_POST, $return)) header("location:tickets.php?tid=$tid&note=".urlencode($return)); else header("location:tickets.php?error=".urlencode($return)); } if ($_REQUEST['_action']=="save") { if ($tid = SubmitTicket($_REQUEST, $return)) header("location:tickets.php?tid=$tid&note=".urlencode($return)); else header("location:tickets.php?error=".urlencode($return)); } include("head.php"); ?> <h3>List of all tickets</h3> <? $d = new dataTable(DATA_EM7); $d->Database="master_data"; $d->Tables[] = "ticketing"; $d->Where[]="roa_id=$ROA_ID"; $d->Fields=array( "concat('p',severity) as _ROWCLASS", "tid", "descr", "mid(' Min Med HighCrit', severity*4, 4) as severity", "mid(' OpenWorkReslPend', status*4,4) as status", ); $d->OrderBy[]="date_create desc"; $d->LoadData(); $o = new outputTable($d); $o->Title="Tickets"; $o->Types['tid']="header"; $o->hyperlinks['tid']='tickets.php?tid=$tid'; $o->Sorting=true; $o->perpage=10; $o->Display(); if ($_GET['tid']>0) { $tid = $_GET['tid']; ?> <h3>Ticket Details for #<?=$tid?></h3> <? $query = "select * from ticketing where tid=$tid limit 1"; $d = new data($query); $o = new outputSingle($d); $o->Title="Ticket #$tid"; $o->Display(); ?> <h4>Event Log for ticket #<?=$tid?></h4> <? $query = "select * from ticket_notes where tid=$tid order by user_edit desc"; $d = new data($query); $o = new outputTable($d); $o->Title='ticket log'; $o->Display(); ?> <h4>Add event to ticket #<?=$tid?></h4> <? $fields = array( "Note", "tid"=>$tid, 'customer_id'=>$ROA_ID ); $d = new data($fields); $o = new outputForm($d); $o->Title="New Note"; $o->Description="Use the form below to add additional notes, or reply to a previous note from the technicians"; $o->Method="POST"; $o->Types['tid']="hidden"; $o->Types['customer_id']="hidden"; $o->Types['Note']="textarea"; $o->SubmitLabel="Add Note"; $o->ResetLabel="Clear"; $o->Action='note'; $o->Display(); } ?> <h3>A New Ticket</h3> <? $fields = array( "Description", "Note", "Severity"=>array("",1=>"Min",2=>"Med",3=>"Max",4=>"Critical"), "Status"=>array("", 1=>"Open", 2=>"In Work", 3=>"Pending", 4=>"Resovled"), "customer_id"=>$ROA_ID ); $d = new data($fields); $o = new outputForm($d); $o->Title="New Ticket"; $o->Description="Use the form below to describe an issue you're having. This information will be passed along to a technician, and any resulting activity may be monitored from the Ticketing section."; $o->Method="POST"; $o->Types['Note']="textarea"; $o->Types['customer_id']='hidden'; $o->Display(); ?> <? include("foot.php"); ?>

1. [0.0000]db.inc.php File included   include_once, line 21 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
2. [0.0029]Connect mysql://root:@localhost/master_data   Connect, line 113 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
3. [0.0005]PrintWarning WARNING: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: NO)
   /home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php, line 120 (Array)   PrintWarning, line 380 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
4. [0.0000]PrintError ERROR: Connect: Access denied for user 'root'@'localhost' (using password: NO)   PrintError, line 344 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
5. [0.0000]SelectDatabase master_data   SelectDatabase, line 161 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
6. [0.0000]PrintError ERROR: Existing database connection not found   PrintError, line 344 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
7. [0.0000]Query $SQL_CURRENT_CONNECTION is not the expected object.    Query, line 210 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
8. [0.0612]include End head.php   include, line 52 home/bartniedner_com/core.bartniedner.com/htdocs/examples/head.php
9. [0.0024]Connect mysql://root:@localhost/master_data   Connect, line 113 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
10. [0.0005]PrintWarning WARNING: mysql_connect() [function.mysql-connect]: Access denied for user 'root'@'localhost' (using password: NO)
    /home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php, line 120 (Array)   PrintWarning, line 380 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
11. [0.0002]PrintError ERROR: Connect: Access denied for user 'root'@'localhost' (using password: NO)   PrintError, line 344 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
12. [0.0002]SelectDatabase master_data   SelectDatabase, line 161 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
13. [0.0000]PrintError ERROR: Existing database connection not found   PrintError, line 344 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
14. [0.0000]Query $SQL_CURRENT_CONNECTION is not the expected object.    Query, line 210 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
15. [0.0000]PrintError ERROR: Existing database connection not found   PrintError, line 344 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
16. [0.0000]Query $SQL_CURRENT_CONNECTION is not the expected object.    Query, line 210 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
17. [0.0001]ErrorHandler mysql_num_rows(): supplied argument is not a valid MySQL result resource
    /home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php, line 354 (Array)   ErrorHandler, line 140 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
18. [0.0001]JumpToRow jumping to row 0   JumpToRow, line 380 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
19. [0.0047]LoadData LoadData() called when data was already loaded! You dummy!!   LoadData, line 302 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/data.php
20. [0.0002]LoadJavascript Loaded http://core.bartniedner.com/include/javascript/ajax.js   LoadJavascript, line 854 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
21. [0.0000]DrawTopPart outputTable - Tickets
       DrawTopPart, line 205 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
    1. [0.0000]DrawTopPart AJAX enabled   DrawTopPart, line 206 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
    2. [0.0001]LoadJavascript Loaded http://core.bartniedner.com/include/javascript/jquery.js   LoadJavascript, line 854 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
    3. [0.0000]LoadJavascript Loaded http://core.bartniedner.com/include/javascript/core.js   LoadJavascript, line 854 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
    4. [0.0000]LoadJavascript Loaded http://core.bartniedner.com/include/javascript/firebug/firebug.js   LoadJavascript, line 854 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
    5. [0.0004]JumpToRow jumping to row 0   JumpToRow, line 380 home/bartniedner_com/core.bartniedner.com/htdocs/include/db.inc.php
    6. [0.0004]DrawBottomPart cached: /tmp/ticketskL9Zrm   DrawBottomPart, line 378 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
    7. [0.0000]DrawBottomPart End
    outputTable - Tickets   DrawBottomPart, line 381 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
22. [0.0001]__construct Incoming array is single-dimensional. Not that there's anything wrong with that.   __construct, line 144 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/data.php
23. [0.0019]__destruct    __destruct, line 181 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/data.php
24. [0.0000]LoadData LoadData() called when data was already loaded! You dummy!!   LoadData, line 302 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/data.php
25. [0.0001]ErrorHandler preg_match() expects parameter 2 to be string, array given
    /home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/outputForm.php, line 276 (Array)   ErrorHandler, line 140 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
26. [0.0000]DrawTopPart outputForm - New Ticket
       DrawTopPart, line 205 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
    1. [0.0006]ErrorHandler in_array() [function.in-array]: Wrong datatype for second argument
       /home/bartniedner_com/core.bartniedner.com/htdocs/include/html_functions.php, line 80 (Array)   ErrorHandler, line 140 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
    2. [0.0001]ErrorHandler in_array() [function.in-array]: Wrong datatype for second argument
       /home/bartniedner_com/core.bartniedner.com/htdocs/include/html_functions.php, line 80 (Array)   ErrorHandler, line 140 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
    3. [0.0001]ErrorHandler in_array() [function.in-array]: Wrong datatype for second argument
       /home/bartniedner_com/core.bartniedner.com/htdocs/include/html_functions.php, line 80 (Array)   ErrorHandler, line 140 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
    4. [0.0001]ErrorHandler in_array() [function.in-array]: Wrong datatype for second argument
       /home/bartniedner_com/core.bartniedner.com/htdocs/include/html_functions.php, line 80 (Array)   ErrorHandler, line 140 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
    5. [0.0002]ErrorHandler in_array() [function.in-array]: Wrong datatype for second argument
       /home/bartniedner_com/core.bartniedner.com/htdocs/include/html_functions.php, line 80 (Array)   ErrorHandler, line 140 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
    6. [0.0001]ErrorHandler in_array() [function.in-array]: Wrong datatype for second argument
       /home/bartniedner_com/core.bartniedner.com/htdocs/include/html_functions.php, line 80 (Array)   ErrorHandler, line 140 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
    7. [0.0001]ErrorHandler in_array() [function.in-array]: Wrong datatype for second argument
       /home/bartniedner_com/core.bartniedner.com/htdocs/include/html_functions.php, line 80 (Array)   ErrorHandler, line 140 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
    8. [0.0001]ErrorHandler in_array() [function.in-array]: Wrong datatype for second argument
       /home/bartniedner_com/core.bartniedner.com/htdocs/include/html_functions.php, line 80 (Array)   ErrorHandler, line 140 home/bartniedner_com/core.bartniedner.com/htdocs/include/core_functions.php
    9. [0.0001]Display Hidden Field: customer_id => '181'   Display, line 305 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/outputForm.php
    10. [0.0001]DrawBottomPart End
    outputForm - New Ticket   DrawBottomPart, line 381 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
27. [0.0003]include Begin foot.php   include, line 10 home/bartniedner_com/core.bartniedner.com/htdocs/examples/foot.php
28. [0.0007]DrawTopPart outputFreeText - Source code
       DrawTopPart, line 205 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
    1. [0.0005]DrawBottomPart cached: /tmp/sourcecodeDXs1n0   DrawBottomPart, line 378 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php
    2. [0.0000]DrawBottomPart End
    outputFreeText - Source code   DrawBottomPart, line 381 home/bartniedner_com/core.bartniedner.com/htdocs/include/classes/output.php