Page 1 of 1

Allocated Person

Posted: Thu Apr 30, 2009 10:09 am
by nickday85
Script URL:
Version of script:
Hosting company:
URL of phpinfo.php:
URL of session_test.php:
What terms did you try when SEARCHING for a solution:

Write your message below:

I updated Hesk to 2.0 yesterday from 0.93x

All is working fine and it looks customisable to our liking. The only thing I am having troubles with is re-adding our option to allocate tickets to different users. I have re-edited the admin_ticket.php to add:


Code: Select all

<!-- Change Allocated Person Mod-->
	<form method="POST" action="admin_change_person.php">
	<table border="0">
	<tr>
	<td align="right" width="150"><?php echo "Allocated Person"; ?>:</td>
	<td align="left" width="200"><select name="user">
	<?php
	require_once('inc/database.inc.php');

hesk_dbConnect() or hesk_error("Can't connect to database! Please notify webmaster at $hesk_settings[webmaster_mail]!");
$sql = "SELECT * FROM `hesk_users`";
$result = hesk_dbQuery($sql) or hesk_error("Couldn't execute SQL: $sql<br>Please contact webmaster at $hesk_settings[webmaster_mail] and give him this error message");
while ($row=hesk_dbFetchAssoc($result))
{
	echo "
    <option value=\"$row[name]\">$row[name]</option>
    ";
}

?>
</select></td>

<td align="left" width="450">
<p align="left"><input type="hidden" name="track" value="<?php echo $ticket['trackid']; ?>">
<input type="hidden" name="s" value="<?php echo 0 ?>">
<input type="hidden" name="refresh" value="<?php echo $random; ?>">
<input type="submit" value="<?php echo "Update User"; ?>" class="button"></p>
</td>
</form>
</tr>
<!-- End Mod -->
This has added a lovely drop down box at the bottom of the page, but it is unpopulated. I'm struggling to find the string needed to populate. It used to be "person".

Any ideas?

Posted: Thu Apr 30, 2009 10:37 am
by Klemen
I don't provide support for custom or third party modifications, but try deleting

Code: Select all

require_once('inc/database.inc.php'); 

hesk_dbConnect() or hesk_error("Can't connect to database! Please notify webmaster at $hesk_settings[webmaster_mail]!"); 

Posted: Thu Apr 30, 2009 10:53 am
by nickday85
Klemen wrote:I don't provide support for custom or third party modifications, but try deleting

Code: Select all

require_once('inc/database.inc.php'); 

hesk_dbConnect() or hesk_error("Can't connect to database! Please notify webmaster at $hesk_settings[webmaster_mail]!"); 
I know you don't and i really appreciate it.

This has worked but I am now getting this error. I think it would be the last one.

Code: Select all

Warning: require_once(hesk_settings.inc.php) [function.require-once]: failed to open stream: No such file or directory in C:\wamp\www\helpdesk\admin\admin_change_person.php on line 35

Fatal error: require_once() [function.require]: Failed opening required 'hesk_settings.inc.php' (include_path='.;C:\php5\pear') in C:\wamp\www\helpdesk\admin\admin_change_person.php on line 35
[/code]

Posted: Thu Apr 30, 2009 1:13 pm
by Klemen
Try changing

Code: Select all

require_once('inc/database.inc.php');
to

Code: Select all

require(HESK_PATH . 'inc/database.inc.php'); 

Posted: Thu Apr 30, 2009 1:32 pm
by nickday85
Klemen wrote:Try changing

Code: Select all

require_once('inc/database.inc.php');
to

Code: Select all

require(HESK_PATH . 'inc/database.inc.php'); 
Have done this, and am no longer getting the error. Just a blank screen :(

Posted: Thu Apr 30, 2009 4:08 pm
by Klemen
Try

Code: Select all

require_once(HESK_PATH . 'inc/database.inc.php'); 
or just delete the require code (I didn't see your edited file but the database.inc.php should have been included already).

Same feature

Posted: Fri May 22, 2009 7:38 pm
by newtech
I need the same feature-allocation.

Did you get this feature to work for you based upon this topic?
If not, can you share what worked for you?

Posted: Sat May 23, 2009 2:23 am
by newtech
I don't see how this script can work since there is no admin_change_person.php file.

Did you create this file and did other things that are not listed on this forum topic. If so, it would be nice to have everything you did.

Posted: Mon Jul 13, 2009 11:09 am
by tomdawson
Hi there,

It would be great to have the information about the "allocated person" mod...

Any ideas if this will be fully supported by Hesk, maybe in the next version?
Also, any ideas when v2.1 will be out?

Cheers,
Tom :)

Posted: Mon Jul 13, 2009 12:17 pm
by Klemen
This is not something that will be included in 2.1, but definitely in the future sometime.

The exact date of 2.1 is not know yet. I will be on holidays in the beginning of August so it will be released either before than or (more likely) shortly after I come back (middle of August).