[?] - Field can ONLY be edited in SQL database

bhoward

Hello. =)

I'm trying to add a "Price" field to my tickets: ONLY the staff can edit this area, but everyone (including clients) can see the listed price.

I followed (this thread's instructions), and I'm having problems. If a staff member tries to edit the ticket (and add a price), NOTHING will appear. The text doesn't show up at all. I have to manually update the database in order for the Prices to appear. =\

What messed up? I currently have 30 rows in my table -- is that too many, so it's causing problems? Or did I enter the wrong values? Mind you, the other fields I created were drop-down menus, and this is a text area, so maybe I did make a mistake?:

In class.ticket.php (near the bottom):

',money='.db_input(Format:($var)).

In my database row:

Field: money

Type: VARCHAR

Length/Value: 20

Collation latin1_swedish_ci

Attributes:

Null: null

Default: 0

Extra:

Comments:

If anyone can help, I'd greatly appreciate it! Thanks in advance!!

bhoward

Sorry to double-post, but I thought of a better way to ask my question (which I also posted in (this thread)):

==========================

I noticed a major glitch with this code

You can't edit these fields if you click on a ticket (from the control panel) and hit "Edit Ticket". I can't make any changes at all, unless I go directly to the database (in my case, by using myPHPadmin).

So, if a customer makes a mistake and I have to change it, I have to go to the database. Likewise, if I'm posting the grand total for each customer's order, I have to go to the database. This is VERY time-consuming.

Is there a way to fix this? The default fields (such as "Name", "Telephone Number", etc.) can be edited...so what code(s) did the "official/original" programmer use?

EDIT: Believe it or not, I solved it!!! O_O

(That said, if a moderator could take (this file), and replace Frink09's original post with it, I'd greatly appreciate it!)

First though, here's a picture of what I was talking about:

blank

You can't edit these fields (or even see them) in the "Edit Ticket" area!! Frink09, the original author of (this thread), omitted this information (or maybe he didn't know about it)...so here's what you need to do.

1) Open include/staff/editticket.inc.php. Add this at the top of the page:

$info=array('email'=>$ticket->getEmail(),

'name' =>$ticket->getName(),

'phone'=>$ticket->getPhone(),

'phone_ext'=>$ticket->getPhoneExt(),

'newvar'=>$ticket->getNewvar(),

Now reopen include/class.ticket.php. You'll need to update a few more fields:

2) Go to the section that says //Replace base variables. Edit here (DON'T add spaces, and DO leave a comma at the end):

$search = array('/%id/','/%ticket/','/%email/','/%name/','/%subject/','/%topic/','/%phone/','/%status/','/%priority/','/%newvar/',

3) In that same area, go here:

$replace = array($this->getId(),

$this->getExtId(),

$this->getEmail(),

$this->getName(),

$this->getSubject(),

$this->getHelpTopic(),

$this->getPhoneNumber(),

$this->getStatus(),

$this->getPriority(),

$this->newvar(),

4) Now go to function update($var,&$errors) {. Edit here:

$fields=array();

$fields = array('type'=>'string', 'required'=>1, 'error'=>'newvar required');

5) And edit here:

if(!$errors){

$sql='UPDATE '.TICKET_TABLE.' SET updated=NOW() '.

',email='.db_input($var).

',name='.db_input(Format:($var)).

',subject='.db_input(Format:($var)).

',newvar='.db_input(Format:($var)).

tsz42

thank you!

Instructions were fairly clear as to what I needed to do and it worked like a charm.

Again, many thanks! :)

freddyvangeel

so i've been looking all over and even with this info, i still cannot edit the ticket info for the additional fields.

everything else works ok, i even do have the fields added to editticket, but get an error when i try to change this.

please help!

thanks a lot!!