[EasyTarget]

awesome hack.

Just installed from scratch.. 1st hack on the forum and, besides the missing "]" in the navbar template edit that ndahiya pointed out, it seems to be working fine.

created, assigned, closed, edited and deleted tickets just fine.

some ideas:
have some sort of deletion verification so that if you mark a bunch of tickets and then accidentally choose delete that you don't lose them all.

for listing tickets maybe have the option to list them by category.

option to auto assign tickets according to the category they're placed in.

ability to assign tickets to usergroups.

ability to view who the ticket is assigned to/category while you're viewing the ticket/thread (maybe add categories in the navbit?).

*edit*
got this error when submitting a blank ticket:

Database error in vBulletin 3.5.4:

Invalid SQL:

		SELECT post.postid, IF(post.userid = 0, post.username, user.username) AS username,
			post.pagetext, post.allowsmilie, post.userid, post.dateline
		FROM vbs_ticket_post AS post
		LEFT JOIN user AS user ON(user.userid = post.userid)
		WHERE post.visible = 1
			
			AND post.threadid = 
		ORDER BY dateline DESC, postid DESC
		LIMIT 11;

MySQL Error  : 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 'ORDER BY dateline DESC, postid DESC
		LIMIT 11' at line 8
Error Number : 1064
Date         : Wednesday, May 17th 2006 @ 09:33:17 PM
Script       : XXX/vbsupport.php
Referrer     : XXX/vbsupport.php?do=newthread
IP Address   : XXX.XXX.XXX.XXX
Username     : XXXX
Classname    : vb_database