ticket owners at home page

[Cheetah]

Hello,
I want to show the ticket list at the homepage with the owners. I don't need the last editors.

Yes I know: "customizations of such extent are out of the scope of my free support here"

But perhaps someone has already fixed this and can help me. It is not possible for me to order support with payment in USD.

I do not have enough php knowledge to change it by myself.
Thanks
Uwe (germany)

[webguy78]

I just figured out how to do this. Here is a way to add owers to the admin page

Go to inc/ticket_list.inc.php

Add this line of code around line 237
<th class="admin_white" style="text-align:center; white-space:nowrap;"><a href="<?php
echo $href . '?' . $query; ?>category"><?php echo $hesklang['staff']; ?></a></th>

Add this line of code around line 288

//added category
$sql = "SELECT * FROM `hesk_users` WHERE `id`=$ticket[owner] LIMIT 1";
$newresult = hesk_dbQuery($sql) or hesk_error("$hesklang[cant_sql]:
$sql</p><p>$hesklang[mysql_said]:<br>".mysql_error()."</p><p>
$hesklang[contact_webmsater] $hesk_settings[webmaster_mail]");
$newcategory = hesk_dbFetchAssoc($newresult);
// done

And then add this line of code towards the bottom:

<td class="$color">$newcategory[name]</td>

[Raven]

I tried your mod and all I get is this:

Error:

Can't execute SQL

Please notify webmaster at webmaster@crikey-thatsmint.com

Any idea?

Looking within SELECT * FROM `hesk_users` I cannot see any thing for $ticket[owner]...

[Cheetah]

The same here.
In german "SQL kann nicht ausgeführt werden." It means can't execute sql.

I have a column "staff" now but it has no content.

running here in Windows Server 2003 with xampp (Apache, MySQL) environment.

[Klemen]

Just a tip: enable "Debug mode" in admin panel > Settings > Help Desk Settings to show the exact SQL query that is causing the problem.

[Cheetah]

Thank you.
Now I get the error message:

Error:

Can't execute SQL: SELECT * FROM `hesk_users` WHERE `id`= LIMIT 1

MySQL said:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 1' at line 1

I'll try google search but I'd be glad if anyone here has a tip for me.

[Cheetah]

Okay, replaced "$sql" to "$mySQL".
Now I get no sql error and I have a column "owner". But there is still no content
Any hints?

[cospa]

Hi there,

After logging in at Admin panel i see this:

Error:

Can't execute SQL

Please notify webmaster at beheer@cospamedia.nl


Cospa

[Klemen]

Download hesk_settings.inc.php from the server, open it in Notepad, change

Code: Select all

$hesk_settings['debug_mode']=0;

to

Code: Select all

$hesk_settings['debug_mode']=1;

, save changes, upload to the server and see if you get any new error messages.

[cospa]

Thnx, but now i see this:

Error:

Can't execute SQL: SELECT * FROM `hesk_usersusers` WHERE `user` = 'Administrator' LIMIT 1

MySQL said:
Table 'sexymail_gpt.hesk_usersusers' doesn't exist



WARNING
Debug mode is enabled. Make sure you disable debug mode in settings once HESK is installed and working properly.

[abyx]

Hallo, ich habe folgendes Problem wenn ein Ticket von der Webseite versendet werden soll. Erstelle ich eins aus dem Adminbereich kommt diese Fehler nicht. https://www.fassfaender.de/helpdesk/index.php?a=add
Ich habe viele offene Tickets da diese mit meinen Buchungen verbunden sind.

Danke schon mal für die Hilfe.

Hi, I have the following problem when a ticket from the web page to be sent. I create one from the admin section does not come this error. https://www.fassfaender.de/helpdesk/index.php?a=add
I have many open tickets as these are associated with my bookings.

Thanks in advance for your help.

SQL kann nicht ausgeführt werden.: SELECT `t1`.`id`,`t1`.`user`,`t1`.`name`, `t1`.`email`, `t1`.`language`, `t1`.`isadmin`, `t1`.`categories`, `t1`.`notify_assigned`, `t1`.`heskprivileges`, (SELECT COUNT(*) FROM `hesk_tickets` FORCE KEY (`statuses`) WHERE `owner`=`t1`.`id` AND `status` IN ('0','1','2','4','5') ) as `open_tickets` FROM `hesk_users` AS `t1` WHERE `t1`.`autoassign`='1' ORDER BY `open_tickets` ASC, RAND()

MySQL antwortet:
Key 'statuses' doesn't exist in table 'hesk_tickets'

[Klemen]

You are using an unofficial HESK modification, please try asking the Mod author Mike here:
viewforum.php?f=19