- Joined
- Dec 28, 2010
- Messages
- 111
- Reaction score
- 35
Hi i spend this Afternoon Figuring out how i would do this and i figured this is how it would work.
On Me page there is a Support Ticket Form people can Fill out.
Second it sends the Information to a table in your Database
Third Staff members or people who access to Manage can go to "Support Tickets" and see
"Username" "Problem" "Respond to Email"
its 12 pm here so i made it where Staff has to go to their Email or Hotel's Email and use Respond to email to send Support Answer.
I took the "Hotel Alert" page in Manage and turned it into "Support Tickets" Cause truthfully i dont know how to make a Whole new page for Manage. This Whole thing can Easily be Turned into a Staff Application form. When user Push's Submit page it Takes them to a Page thanking them for their Support Ticket and after a couple seconds it redirects back to me page.
Please Rate out of /10 "Like" if i Helped or your Think this is Cool :closedeyes: Hopy you all Enjoy :mellow:
Anywho im finished
MediaFire:
Megaupload:
"Import" This into your Database.
Screen Shots
Form On Site
What it looks like in SQL
What it looks like in Manage
If something isnt Working it means i might have missed a file but im Sure i didnt
On Me page there is a Support Ticket Form people can Fill out.
Second it sends the Information to a table in your Database
Third Staff members or people who access to Manage can go to "Support Tickets" and see
"Username" "Problem" "Respond to Email"
its 12 pm here so i made it where Staff has to go to their Email or Hotel's Email and use Respond to email to send Support Answer.
I took the "Hotel Alert" page in Manage and turned it into "Support Tickets" Cause truthfully i dont know how to make a Whole new page for Manage. This Whole thing can Easily be Turned into a Staff Application form. When user Push's Submit page it Takes them to a Page thanking them for their Support Ticket and after a couple seconds it redirects back to me page.
Please Rate out of /10 "Like" if i Helped or your Think this is Cool :closedeyes: Hopy you all Enjoy :mellow:
Anywho im finished
MediaFire:
To view the content, you need to sign in or register
Megaupload:
To view the content, you need to sign in or register
"Import" This into your Database.
Code:
/*
Navicat MySQL Data Transfer
Source Server : localhost
Source Server Version : 50141
Source Host : localhost:3306
Source Database : fortexdb
Target Server Type : MYSQL
Target Server Version : 50141
File Encoding : 65001
Date: 2011-01-04 19:09:59
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `support_ticket`
-- ----------------------------
DROP TABLE IF EXISTS `support_ticket`;
CREATE TABLE `support_ticket` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`username` text NOT NULL,
`email` text NOT NULL,
`problem` text NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
Screen Shots
Form On Site
What it looks like in SQL
What it looks like in Manage
If something isnt Working it means i might have missed a file but im Sure i didnt
Last edited:

