Captcha Problem and Customization...HELP lol

pdrummer15

http://tsdtechno.com/test/help(http://tsdtechno.com/test/help)

i cant figure out whats wrong. this form is customized and not working.

captcha is not working correctly but i remove custom fields from open.inc and it works. Please Help on on a deadline.

scottro

Can you post your modified file(s)? Hard to say just by looking at frontend.

pdrummer15

Can you post your modified file(s)? Hard to say just by looking at frontend.

open.inc

<?php

if(!defined('OSTCLIENTINC')) die('Kwaheri rafiki!'); //Say bye to our friend..

$info=($_POST && $errors)?Format:($_POST)(); //on error...use the post data

?>

<div>

<?if($errors) {?>

<p align="center" id="errormessage"><?=$errors?></p>

<?}elseif($msg) {?>

<p align="center" id="infomessage"><?=$msg?></p>

<?}elseif($warn) {?>

<p id="warnmessage"><?=$warn?></p>

<?}?>

</div>

<div>Please fill in the form below to open a new ticket.</div><br />

<form action="open.php" method="post" enctype="multipart/form-data">

<table align="left" cellpadding="2" cellspacing="1" width="90%">

<tr>

<th width="20%">Customer Contact:</th>

<td>

<?if ($thisclient && ($name=$thisclient->getName())) {

?>

<input type="hidden" name="name" value="<?=$name?>" /><?=$name?>

<?}else {?>

<input type="text" name="name" size="25" value="<?=$info?>" />

<?}?>

 <font class="error">* <?=$errors?></font>

</td>

</tr>

<tr>

<th nowrap="nowrap" >Email Address:</th>

<td>

<?if ($thisclient && ($email=$thisclient->getEmail())) {

?>

<input type="hidden" name="email" size="25" value="<?=$email?>" /><?=$email?>

<?}else {?>

<input type="text" name="email" size="25" value="<?=$info?>" />

<?}?>

 <font class="error">* <?=$errors?></font>

</td>

</tr>

<tr>

<th>Telephone:</th>

<td><input type="text" name="phone" size="25" value="<?=$info?>" />

 Ext <input type="text" name="phone_ext" size="6" value="<?=$info?>" />

 <font class="error"> <?=$errors?></font></td>

</tr>

<tr>

<th>Address:</th>

<td>

<input type="text" name="address" size="35" value="<?=$info?>" />

 <font class="error">* <?=$errors?></font>

</td>

</tr>

<tr>

<th>City:</th>

<td>

<input type="text" name="city" size="35" value="<?=$info?>" />

 <font class="error">* <?=$errors?></font>

</td>

</tr>

<tr>

<th>State:</th>

<td>

<input type="text" name="state" size="35" value="<?=$info?>" />

 <font class="error">* <?=$errors?></font>

</td>

</tr>

<tr height="2px"><td align="left" colspan="2" > </td></tr>

<tr>

<th>Help Topic:</th>

<td>

<select name="topicId">

<option value="" selected="selected" >Select One</option>

<?

$services= db_query('SELECT topic_id,topic FROM '.TOPIC_TABLE.' WHERE isactive=1 ORDER BY topic');

if($services && db_num_rows($services)) {

while (list($topicId,$topic) = db_fetch_row($services)){

$selected = ($info==$topicId)?'selected':''; ?>

<option value="<?=$topicId?>"<?=$selected?>><?=$topic?></option>

<?

}

}else{?>

<option value="0" >General Inquiry</option>

<?}?>

</select>

 <font class="error">* <?=$errors?></font>

</td>

</tr>

<tr>

<th>Model #:</th>

<td>

<input type="text" name="model" size="35" value="<?=$info?>" />

 <font class="error">* <?=$errors?></font>

</td>

</tr>

<tr>

<th valign="top">Message:</th>

<td>

<? if($errors) {?> <font class="error"><b> <?=$errors?></b></font><br/><?}?>

<textarea name="message" cols="35" rows="8" wrap="soft" style="width%"><?=$info?></textarea></td>

</tr>

<tr>

<th valign="top">Additional Comments:</th>

<td>

<? if($errors) {?> <font class="error"><b> <?=$errors?></b></font><br/><?}?>

<textarea name="comments" cols="35" rows="8" wrap="soft" style="width%"><?=$info?></textarea></td>

</tr>

<?

if($cfg->allowPriorityChange() ) {

$sql='SELECT priority_id,priority_desc FROM '.TICKET_PRIORITY_TABLE.' WHERE ispublic=1 ORDER BY priority_urgency DESC';

if(($priorities=db_query($sql)) && db_num_rows($priorities)){ ?>

<tr>

<td>Priority:</td>

<td>

<select name="pri">

<?

$info=$info?$info:$cfg->getDefaultPriorityId(); //use system's default priority.

while($row=db_fetch_array($priorities)){ ?>

<option value="<?=$row?>" <?=$info==$row?'selected':''?> ><?=$row?></option>

<?}?>

</select>

</td>

</tr>

<? }

}?>

<?if(($cfg->allowOnlineAttachments() && !$cfg->allowAttachmentsOnlogin())

|| ($cfg->allowAttachmentsOnlogin() && ($thisclient && $thisclient->isValid()))){

?>

<tr>

<td>Attachment:</td>

<td>

<input type="file" name="attachment" /><font class="error"> <?=$errors?></font>

</td>

</tr>

<?}?>

<?if($cfg && $cfg->enableCaptcha() && (!$thisclient || !$thisclient->isValid())) {

if($_POST && $errors && !$errors)

$errors='Please re-enter the text again';

?>

<tr>

<th valign="top">Captcha Text:</th>

<td><img src="captcha.php" border="0" align="left" />

<span>  <input type="text" name="captcha" size="7" value="" /> <i>Enter the text shown on the image.</i></span><br/>

<font class="error"> <?=$errors?></font>

</td>

</tr>

<?}?>

<tr height="2px"><td align="left" colspan="2" > </td></tr>

<tr>

<td></td>

<td>

<input class="button" type="submit" name="submit_x" value="Submit Ticket" />

<input class="button" type="reset" value="Reset" />

<input class="button" type="button" name="cancel" value="Cancel" onclick='window.location.href="index.php"' />

</td>

</tr>

</table>

</form>

pdrummer15

class.ticket.php

class Ticket{

var $id;

var $extid;

var $email;

var $status;

var $created;

var $updated;

var $lastrespdate;

var $lastmsgdate;

var $duedate;

var $priority;

var $priority_id;

var $fullname;

var $staff_id;

var $dept_id;

var $topic_id;

var $dept_name;

var $company;

var $address;

var $city;

var $state;

var $model;

var $comments;

var $helptopic;

var $overdue;

var $lastMsgId;

var $dept; //Dept class

var $staff; //Staff class

var $topic; //Topic class

var $tlock; //TicketLock class

function Ticket($id,$exid=false){

$this->load($id);

}

function load($id) {

$sql =' SELECT ticket.*,topic.topic_id as topicId,lock_id,dept_name,priority_desc FROM '.TICKET_TABLE.' ticket '.

' LEFT JOIN '.DEPT_TABLE.' dept ON ticket.dept_id=dept.dept_id '.

' LEFT JOIN '.TICKET_PRIORITY_TABLE.' pri ON ticket.priority_id=pri.priority_id '.

' LEFT JOIN '.TOPIC_TABLE.' topic ON ticket.topic_id=topic.topic_id '.

' LEFT JOIN '.TICKET_LOCK_TABLE.' tlock ON ticket.ticket_id=tlock.ticket_id AND tlock.expire>NOW() '.

' WHERE ticket.ticket_id='.db_input($id);

//echo $sql;

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;

$this->status =$row;

$this->created =$row;

$this->updated =$row;

$this->duedate =$row;

$this->closed =$row;

$this->lastmsgdate =$row;

$this->lastrespdate =$row;

$this->lock_id =$row;

$this->priority_id=$row;

$this->priority=$row;

$this->staff_id =$row;

$this->dept_id =$row;

$this->topic_id =$row; //Note that we're actually joining the topic table to make the topic is not deleted (long story!).

$this->dept_name =$row;

$this->company =$row;

$this->address =$row;

$this->city =$row;

$this->state =$row;

$this->model =$row;

$this->comments =$row;

$this->helptopic =$row;

$this->overdue =$row;

$this->row=$row;

//Reset the sub classes (initiated ondemand)...good for reloads.

$this->staff=array();

$this->dept=array();

return true;

endif;

return false;

}

function reload() {

return $this->load($this->id);

}

function isOpen(){

return (strcasecmp($this->getStatus(),'Open')==0)?true;

}

function isClosed() {

return (strcasecmp($this->getStatus(),'Closed')==0)?true;

}

function isAssigned() {

return $this->getStaffId()?true;

}

function isOverdue() {

return $this->overdue?true;

}

function isLocked() {

return $this->lock_id?true;

}

//GET

function getId(){

return $this->id;

}

function getExtId(){

return $this->extid;

}

function getEmail(){

return $this->email;

}

function getName(){

return $this->fullname;

}

function getCompany() {

return $this->company;

}

		function getAddress() {
        return $this->address;
    }
		function getCity() {
        return $this->city;
    }
		function getState() {
        return $this->state;
    }
		function getModel() {
        return $this->model;
    }
		function getComments() {
        return $this->comments;
    }
    function getHelpTopic() {
        if($this->topic_id && ($topic=$this->getTopic()))
            return $topic->getName();
            
        return $this->helptopic;
    }
   
    function getCreateDate(){
        return $this->created;
    }

pdrummer15

class.ticket.php

function create($var,&$errors,$origin,$autorespond=true,$alertstaff=true) {

global $cfg,$thisclient,$_FILES;

/* Coders never code so fully and joyfully as when they do it for free - Peter Rotich */

$id=0;

$fields=array();

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

$fields = array('type'=>'email', 'required'=>1, 'error'=>'Valid email required');

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

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

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

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

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

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

$fields = array('type'=>'text', 'required'=>1, 'error'=>'Message required');

if(strcasecmp($origin,'web')==0) { //Help topic only applicable on web tickets.

$fields = array('type'=>'int', 'required'=>1, 'error'=>'Select help topic');

}elseif(strcasecmp($origin,'staff')==0){ //tickets created by staff...e.g on callins.

$fields = array('type'=>'int', 'required'=>1, 'error'=>'Dept. required');

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

$fields = array('type'=>'date', 'required'=>0, 'error'=>'Invalid date - must be MM/DD/YY');

}else { //Incoming emails

$fields = array('type'=>'int', 'required'=>1, 'error'=>'Email unknown');

}

$fields = array('type'=>'int', 'required'=>0, 'error'=>'Invalid Priority');

$fields = array('type'=>'phone', 'required'=>0, 'error'=>'Valid phone # required');

$validate = new Validator($fields);

if(!$validate->validate($var)){

$errors=array_merge($errors,$validate->errors());

}

pdrummer15

class.ticket.php

//We are ready son...hold on to the rails.

$extId=Ticket:();

$sql= 'INSERT INTO '.TICKET_TABLE.' SET created=NOW() '.

',ticketID='.db_input($extId).

',dept_id='.db_input($deptId).

',topic_id='.db_input($topicId).

',priority_id='.db_input($priorityId).

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

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

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

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

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

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

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

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

',helptopic='.db_input(Format:($topicDesc)).

',phone="'.db_input($var,false).'"'.

',phone_ext='.db_input($var?$var:'').

',ip_address='.db_input($ipaddress).

',source='.db_input($source);

scottro

hehe, I more meant attach but that works too

I'll take a look and see if anything pops out at me.

scottro

So if you take out JUST THE CODE FROM open.inc and the rest of your custom code stays in the other files, it still doesn't work?

pdrummer15

let me try real fast

pdrummer15

yes if i use the original file with the other files changed it does not work it gives me.

"Please re-enter the text again"

under the captcha. thanks for your help bud.

scottro

Can you paste in a new response just the stuff you added to open.inc? That way I can focus on that separately.

pdrummer15

Can you paste in a new response just the stuff you added to open.inc? That way I can focus on that separately.

<table align="left" cellpadding="2" cellspacing="1" width="90%">

<tr>

<th width="20%">Customer Contact:</th>

<td>

<?if ($thisclient && ($name=$thisclient->getName())) {

?>

<input type="hidden" name="name" value="<?=$name?>" /><?=$name?>

<?}else {?>

<input type="text" name="name" size="25" value="<?=$info?>" />

<?}?>

 <font class="error">* <?=$errors?></font>

</td>

</tr>

<tr>

<th nowrap="nowrap" >Email Address:</th>

<td>

<?if ($thisclient && ($email=$thisclient->getEmail())) {

?>

<input type="hidden" name="email" size="25" value="<?=$email?>" /><?=$email?>

<?}else {?>

<input type="text" name="email" size="25" value="<?=$info?>" />

<?}?>

 <font class="error">* <?=$errors?></font>

</td>

</tr>

<tr>

<th>Telephone:</th>

<td><input type="text" name="phone" size="25" value="<?=$info?>" />

 Ext <input type="text" name="phone_ext" size="6" value="<?=$info?>" />

 <font class="error"> <?=$errors?></font></td>

</tr>

<tr>

<th>Address:</th>

<td>

<input type="text" name="address" size="35" value="<?=$info?>" />

 <font class="error">* <?=$errors?></font>

</td>

</tr>

<tr>

<th>City:</th>

<td>

<input type="text" name="city" size="35" value="<?=$info?>" />

 <font class="error">* <?=$errors?></font>

</td>

</tr>

<tr>

<th>State:</th>

<td>

<input type="text" name="state" size="35" value="<?=$info?>" />

 <font class="error">* <?=$errors?></font>

</td>

</tr>

<tr height="2px"><td align="left" colspan="2" > </td></tr>

<tr>

<th>Help Topic:</th>

<td>

<select name="topicId">

<option value="" selected="selected" >Select One</option>

<?

$services= db_query('SELECT topic_id,topic FROM '.TOPIC_TABLE.' WHERE isactive=1 ORDER BY topic');

if($services && db_num_rows($services)) {

while (list($topicId,$topic) = db_fetch_row($services)){

$selected = ($info==$topicId)?'selected':''; ?>

<option value="<?=$topicId?>"<?=$selected?>><?=$topic?></option>

<?

}

}else{?>

<option value="0" >General Inquiry</option>

<?}?>

</select>

 <font class="error">* <?=$errors?></font>

</td>

</tr>

<tr>

<th>Model #:</th>

<td>

<input type="text" name="model" size="35" value="<?=$info?>" />

 <font class="error">* <?=$errors?></font>

</td>

</tr>

<tr>

<th valign="top">Message:</th>

<td>

<? if($errors) {?> <font class="error"><b> <?=$errors?></b></font><br/><?}?>

<textarea name="message" cols="35" rows="8" wrap="soft" style="width%"><?=$info?></textarea></td>

</tr>

<tr>

<th valign="top">Additional Comments:</th>

<td>

<? if($errors) {?> <font class="error"><b> <?=$errors?></b></font><br/><?}?>

<textarea name="comments" cols="35" rows="8" wrap="soft" style="width%"><?=$info?></textarea></td>

</tr>

scottro

Alot of that is stuff that is already there by default, what is JUST the stuff that you added?

pdrummer15

Alot of that is stuff that is already there by default, what is JUST the stuff that you added?

<tr>

<th>Address:</th>

<td>

<input type="text" name="address" size="35" value="<?=$info?>" />

 <font class="error">* <?=$errors?></font>

</td>

</tr>

<tr>

<th>City:</th>

<td>

<input type="text" name="city" size="35" value="<?=$info?>" />

 <font class="error">* <?=$errors?></font>

</td>

</tr>

<tr>

<th>State:</th>

<td>

<input type="text" name="state" size="35" value="<?=$info?>" />

 <font class="error">* <?=$errors?></font>

</td>

</tr>

<tr>

<th>Model #:</th>

<td>

<input type="text" name="model" size="35" value="<?=$info?>" />

 <font class="error">* <?=$errors?></font>

</td>

</tr>

<tr>

<th valign="top">Additional Comments:</th>

<td>

<? if($errors) {?> <font class="error"><b> <?=$errors?></b></font><br/><?}?>

<textarea name="comments" cols="35" rows="8" wrap="soft" style="width%"><?=$info?></textarea></td>

</tr>

scottro

Hmm, still nothing jumping out at me. Can you email me all the files you modified to do this and I'll implement on a new system on my test server and troubleshoot.

scott (at) sudobash (dot) net

pdrummer15

sure thing thanks

scottro

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

I turned off captcha and still had the issue... so I looked elsewhere until I found it.

pdrummer15

I turned off captcha and still had the issue... so I looked elsewhere until I found it.

thanks bud

pdrummer15

i tried it and its still no working =[

http://tsdtechno.com/test/help(http://tsdtechno.com/test/help)

im sorry im so stuck.

scottro

i tried it and its still no working =[
http://tsdtechno.com/test/help(http://tsdtechno.com/test/help)
im sorry im so stuck.

Hmph, looking again...