Support Ticket?

New Member Joined: Apr 09, 2006 Posts: 18 Location: USA

Not sure of where this should go, so I put it hear since this is the distro I am using. Anyone familiar with a good PHP-Nuke (module) support ticket system (trouble ticket) that is compatible with Raven Nuke and will not compromise security. I have tried googling it many times with various search words or phrases, but usually just comes up with a hosting companies support ticket system and them mentioning they support php nuke on their hosting packages. A free ticket system would be preferred since I am non profit but I would also pay (as long as it doesn't break the bank Smile

).

Thanks your help and input guys, you are the best and very helpful and once again I apologize if I posted this in the wrong area!

Sells PC To Pay For Divorce Joined: Posts: 5661

see if this is something....

http://sourceforge.net/projects/sqlservice2

Posted: Sun Oct 29, 2006 11:55 am

I have tried that. Keeps giving me an error trying to import the .SQL into the new database for it though. This is a tough one. I would think with as many PHP-Nuke website that are out there, there would be more support ticket modules available then there are!

Hangin' Around Joined: May 30, 2004 Posts: 46

I've been using this Support System for about 3 years. They have a Pro version which is not free. But with a little tweeking the free one is good.

Only registered users can see links on this board! Get registered or login!

Posted: Sun Oct 29, 2006 6:14 pm

Thanks for the reply. I had actually found that one and was looking at it. I noticed though that it said something like nuke 5 or 6 didn't know if it was compatible with the newer nukes, and especially the more secure raven nuke. Now I know someone else has tried it, I will give it a shot and see what I get. I am not looking for something major, since like I said I am non profit.

I also don;t mind paying $20-$30 for a script either if it works good for what I want either!

Hint Hint Raven!!! Very Happy

Thanks Guys!!

Posted: Sun Oct 29, 2006 6:28 pm

Ok, I downloaded the support toicket system that was suggested and looked at it. It is showing there that I need to create a database (which I know how to do) and then add tables to it. I know how to import .sql files and can run php scipts that automatically do the tables for you, but I am a noob when it comes to what they are describing. If anyone can help me out here, I would greatly appreciate it. I do not want to just try it and risk screwing up something. Thanks...

Code:

// STEP 2: Create a table with the following settings. 





CREATE TABLE supportsys (


   ticket int(11) NOT NULL auto_increment,


   email text NOT NULL,


   fname text NOT NULL,


   lname text NOT NULL,


   catergory text NOT NULL,


   pdes text NOT NULL,


   sdes text NOT NULL,


   status tinyint(4) NOT NULL,


   know tinyint(4) NOT NULL,


   PRIMARY KEY (ticket)


);

Posted: Sun Oct 29, 2006 6:59 pm

Using phpMyAdmin. Select SQL and copy, paste the below code. Click on GO and your done.

Code:




CREATE TABLE supportsys ( 


   ticket int(11) NOT NULL auto_increment, 


   email text NOT NULL, 


   fname text NOT NULL, 


   lname text NOT NULL, 


   catergory text NOT NULL, 


   pdes text NOT NULL, 


   sdes text NOT NULL, 


   status tinyint(4) NOT NULL, 


   know tinyint(4) NOT NULL, 


   PRIMARY KEY (ticket) 


);

To make sure the blocks and modules have the correct security. Read the readme.txt in ravens PatchLevel3.1_Docs directory and the Addons-Modules.txt and Blocks.txt in the ravens phpNuke7.6_Docs directory.