chriscloyd Posted July 9, 2006 Share Posted July 9, 2006 Please help me right now im creating a support script i have the ticket part all worked out i just need an idea on how to make the live support part work like what tables would i need in my database i dont need someone to make it for me i just need help like little bits and pieces i can do the coding. Quote Link to comment Share on other sites More sharing options...
hackerkts Posted July 9, 2006 Share Posted July 9, 2006 Are you asking for suggestion about the database structure ?Hmm.. I could only think of[list][*]ID (ticket id, most important)[*]Name of the sender[*]Name of the Email[*]Emergency type (make it as 1 is not important, then 2 as normal and 3 as very important. Just an idea)[*]Name of helper (The name who give support for this ticket)[*]Date that the helper starts giving his/her support (Date when he started to support)[*]Status (Have it been solve ?)[/list]:o I could only think of that at the moment..Hope this is what you looking for. Quote Link to comment Share on other sites More sharing options...
chriscloyd Posted July 9, 2006 Author Share Posted July 9, 2006 it does but im trying to make it how it shows whos going to accecpt the live support requestrefresh every 5 seconds and what not you know what i mean? Quote Link to comment Share on other sites More sharing options...
hackerkts Posted July 9, 2006 Share Posted July 9, 2006 You need to use cronjob, it's in the cPanel.Most hosting will have that. Quote Link to comment Share on other sites More sharing options...
Daniel0 Posted July 9, 2006 Share Posted July 9, 2006 Put this on the page [code]<script type='text/javascript'>settimeout('location.href=location.href',5000);</script>[/code]To refresh it every 5 seconds. Quote Link to comment Share on other sites More sharing options...
ShogunWarrior Posted July 9, 2006 Share Posted July 9, 2006 A non-javascript version is:[code]<head><meta http-equiv="refresh" content="300"></head>[/code] Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.