How to Limit People From Opening Multiple Tickets

[SupportCenter]

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:


Hi, Just wanted to know if there was a way that I could limit the number of tickets people can open at one given time. I got people that open up 2 or 3 tickets at a time and its cramming up our support ticket system.

I wanted to know how to do this also in the event some person starts to spam our support site with opening up multiple tickets purposely.

Thank you.

[Klemen]

Haven't tested it but in the submit_ticket.php you can add something like this:

Code: Select all

$sql = "SELECT * FROM `".hesk_dbEscape($hesk_settings['db_pfix'])."tickets` WHERE `status` != '3' AND (`email` LIKE '".hesk_dbEscape($email)."' OR `ip` LIKE '".hesk_dbEscape($_SERVER['REMOTE_ADDR'])."')";
$res = hesk_dbQuery($sql);
if (hesk_dbNumRows($res) >= 3)
{
	hesk_error("You can have maximum 3 open tickets at a time!");
}

Paste it just below:

Code: Select all

hesk_dbConnect();

[SupportCenter]

Im not going to buy you a beer. Im buying you the Krystal!

Works like a charm!

PHP MASTER!

[SupportCenter]

Today a few people where able to post multiple tickets at once. I dont know how they did it but it was done.

I couldnt find this topic so I opened up another Topic conversation sorry.

[Klemen]

The fix mentioned here allows up to 3 open tickets with the same e-mail, but if they use another e-mail it won't help.

[SupportCenter]

I changed it so that they could only open up one ticket. I just changed it to make sure its > 1.

[Klemen]

You should use hesk_dbNumRows($res) > 0 to allow only one ticket, not > 1 (this would allow up to 2 tickets).

[SupportCenter]

having it set to 0 prevents anyone from opening or creating a ticket.

This seems to work :

/* Add to database */
hesk_dbConnect();
$sql = "SELECT * FROM `".hesk_dbEscape($hesk_settings['db_pfix'])."tickets` WHERE `status` != '1' AND (`email` LIKE '".hesk_dbEscape($email)."' OR `ip` LIKE '".hesk_dbEscape($_SERVER['REMOTE_ADDR'])."')";
$res = hesk_dbQuery($sql);
if (hesk_dbNumRows($res) > 1)
{
hesk_error("You can have maximum 1 open tickets at a time!");
}

[Klemen]

Your code allows up to 2 tickets. If one already in the database and the second one is still submitted because hesk_dbNumRows($res) will return 1 so it's not more ">" than 1 and no error is given.

[franku]

Hi Kleman - will this work with the latest version of Hesk? Or is there new code that will be needed to be used ?

[Klemen]

Instead of $email you will need to use $tmpvar['email'] in the code and paste the code just above

Code: Select all

/* Custom fields */

(because the hesk_dbConnect(); portion has been moved toward the top of the file).