hi,
i have added 1 extra field to it and it just working fine,
1 thing i notice.. when user has login in to his account to view his ticket, the templates seems ruin / incomplete when he tries to create a new ticket from here.
Is this normal or should i disable the open new ticket from here ? It shouldnt be this way right ? or anything i missed out on the coding part ?
thanks
edit ticket custom field
Hi everyone.
Using the complete mod on page 14 made a custom field work fully for me.
Thanks Frink09 and jkisner.
I wonder if there is any way to get the "edit ticket" page to be able to edit the custom field also.
I tried adding the field to the file: /html/include/staff/editticket.inc.php
and the field shows up with current content show, but the changes aren't written to the database when I click "update ticket".
It feels as if more files than editticket.inc.php needs to be changed.
editticket.inc.php modifications:
line 11
'company' =>$ticket->getCompany(),
line 54
<tr>
<td align="left" ><b>Company Name:</b></td>
<td>
<input type="text" id="company" name="company" size="25" value="<?=$info?>">
<font class="error"><b>*</b> <?=$errors?></font>
</td>
</tr>
Has anyone gotten this to work ?
Cheers
//Hakan
edit ticket custom field
Just got "edit ticket" working by looking at page 1 of this thread.
Using the modifications from my post above + these below.
/include/class.ticket.php modifications:
line 1085
$fields = array('type'=>'string', 'required'=>1, 'error'=>'Company required');
line 1133
',company='.db_input(Format:($var)).
//Hakan
hi hjtech..
since you got it working fine... when user logs in to check the total tickets opened... can you click on new ticket from there ? do u have any error too ?
thanks
I have the same issue. I can create a new ticket as a user with no problem. But when I am logged into the site, the create ticket page will not load correctly. It stops after the first new field I have created.
The same in the admin, I can't view any of the tickets now.
It seems others are experience this exact same issue but can anyone tell us if you've fixed it and how?
Hi firezz & tonin.
I can create new tickets just fine logged in, in the staff view.
The very first modification I made to our system was to add a new field according to this thread.
But I didnt get it to work until i downloaded the finished files on page 14.
Besides those files the only thing I had to do was add the table in the database.
And my custom field happens to be the same as the example in this thread (company).
Worked at once, no problems at all, and I was very happy :)
After that I have done various changes in some php-files, like removing things that I dont need, and some such changes resulted in no tickets showing up etc etc in staff view, then I had to restore my last working file.
//Hakan
Would it help if I sent you my files? Then you could just edit them how you like.
hi hjtech ..
is the files by jkisner you mentioned ? coz previously i downloaded another set of files from one of the users here (*cant rmb which page) and just added the table in db ...
anyway .. i am downloading and will try on this files shortly... :)
thanks
Custom field text disappears on error with Captcha control
My custom fields that has been added disappears when the Captcha control is entered incorrectly but not with the other errors when Captcha is disabled
the one downloaded.. still same ...
after some changes, got it working errr... after some changes still...
will go back home and reedit some and posted the said files as well :)
thanks
Clients can not view ticket status after mod
I just realized my clients can not view ticket status after this mod. I have combed through the files and can't seem to figure out whats wrong. Please help!! They can log in but nothing shows up expect the the client information. None of the added notes show up or the information in the field that I added.
Thanks
Fatal Error: Contact system adminstrator.
There have been a lot of questions about how to add a new field to the ticket and rightly so, the more info a user can provide the better. For our purposes we wanted to add a Company field so we knew exactly who we were dealing with.We added the field successfully and this thread explains the process. As a favor, can someone help us with adding that new field to the "tickets.inc.php" page?!?! It would be greatly appreciated. We'd like to be able to see Company in that table as a column where you see the ticket id, date, department, priority etc.
To add a new field there are 6 places you have to go to accomplish your goal.
MySQL Database: manually add a field to ost_Ticket
support/include/class.ticket.php
support/include/client/open.inc.php
support/include/client/viewticket.inc.php
include/staff/viewticket.inc.php
include/staff/newticket.inc.php
2.) class.ticket.php
Add your variable here:
class Ticket{
var $id;
var $extid;
var $email;
var $status;
var $created;
var $updated;
var $priority;and here: like so ($this->newvar=$row;)
if(($res=db_query($sql)) && db_num_rows($res)):
$row=db_fetch_array($res);
$this->id =$row;
$this->extid =$row;
$this->email =$row;
$this->fullname =$row;and here:
//GET
function getId(){
return $this->id;
}
function getExtId(){
return $this->extid;
}
function getEmail(){
return $this->email;
}
function getNewvar(){
return $this->newvar;
}and here:
function create($var,&$errors,$origin,$autorespond=true,$alertstaff=true) {
global $cfg,$thisclient,$_FILES;
$id=0;
$fields=array();
$fields = array('type'=>'string', 'required'=>1, 'error'=>'newvar required');and finally:
$extId=Ticket:();
$sql= 'INSERT INTO '.TICKET_TABLE.' SET created=NOW() '.
',ticketID='.db_input($extId).
',dept_id='.db_input($deptId).
',priority_id='.db_input($priorityId).
',email='.db_input($var).
',name='.db_input(Format:($var)).
',newvar='.db_input(Format:($var)).3.) open.inc.php Copy info from other the other fields, just make sure the new field php scripts are different.
4.) viewticket.inc.php Repeat Step 3
5.) staff/viewticket.inc.php Repeat Step 4
4.) staff/newticket.inc.php Repeat Step 5
Hi I recently installed osticket onto a linux box and have managed a couple of mods to display in the user panel. But after making the mySQL chances suggested I now just get the message Fatal Error: Contact system adminstrator. why i try to access osticket.
Any suggestions would be great because I'm totally new to linux php mysql and osticket :(
Problem resolved, someone changed the root mysql password.
do you have a site i can look at? if you send me a private message i'll give you the link to my site and you can tell me if that is what you're looking for.
Hi contentpig and others
Can you help me with this?
I've added fields like company and address to osticket successfully
Now I want to get the fields filled in when a user is logged in (like name and email)
thanks
You can see here: www.knxcontrol.NL/support(www.knxcontrol.NL/support)
fileds
you want the fields to be autocomplete? once the user logs in, the name and email address on the ticket creation page that info is auto-filled in. Is that what you're looking for?
yes, but in this case for the additional fields that have been added.
email and name is allready working.
Got it all working... thank you.
My line numbers might be a little off as I have other mods but...class.ticket.php Step 1: approx line 27
class.ticket.php Step 2: approx line 62
class.ticket.php Step 3: approx line 111
class.ticket.php Step 4: approx line 820
class.ticket.php Step 5: approx line 913
Say you were adding a confirm email address field, just copy:
$fields = array('type'=>'email', 'required'=>1, 'error'=>'Valid email required');Paste, then change it to:
$fields = array('type'=>'confirm_email', 'required'=>1, 'error'=>'Email addresses must match');I changed the elements so they would have different names.
***NOTE:
the 'type' refers to the type of data on the form. confirm_email is not a default type. Here is a list of the types supported for validation by default.
'integer':
'int':
'double':
'text':
'string':
'array':
'radio':
'date':
'time':
'phone':
'fax':
'email':
'url':
'password':
'username':
'zipcode'
Hope this helps you apply the mod.
Also I have not followed these steps yet, I plan on adding fields later today or tomorrow. I will follow up with success or failure.
Got the whole mod working. Added new fiield, new drop down and also enable editticket to edit the field.
Can share with ya all if want.
Thank you all for the support.
sorry all, i've just solved my problem.
just read thru the thread and saw that i've missed the client.inc.php bit.
works great now!
Add New Field - Company
To add a new field "company" to osTicket v1.6.0
Remember to: Backup, Backup, Backup & Backup.
Database & Files/Folders...before you Install any mods and/or hacks!
Let's Begin...
------------------------------------------------
1. Download the "osticket_fields.zip" file and unzip.
2. Upload the "include" folder to your hosting server. (8 files total)
3. Login to your phpMyAdmin database and click the tab "SQL".
Copy & Paste the statement below in the "Run SQL query" big box.
-------------------------------------------------------------------------
ALTER TABLE ost_ticket ADD COLUMN company varchar(50) DEFAULT NULL;
-------------------------------------------------------------------------
Note: If you want to make the Company field required:
Change ( 'required'=>0 to 'required'=>1 )
Located In the: "client.ticket.php" file, on/or around lines (1175).
That's It!
Enjoy ;)
Best Regards,
Michael B
Small correction
After adding the files to new install of osTicket v1.6.0 I realized that there is a function missing for the Ticket update - company name is ignored by the update function. It is an easy fix, just modify the class.ticket.php from the zip file included by bobath as follow:
Find this code (starts at line 1129):
$sql='UPDATE '.TICKET_TABLE.' SET updated=NOW() '.
',email='.db_input($var).
',name='.db_input(Format:($var)).
',subject='.db_input(Format:($var)).
... and replace with:
$sql='UPDATE '.TICKET_TABLE.' SET updated=NOW() '.
',email='.db_input($var).
',name='.db_input(Format:($var)).
',company='.db_input(Format:($var)).
',subject='.db_input(Format:($var)).
Upload the changed file to your server. All done, the Ticket update function will work as expected.
Cheers,
Greg
