Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

[Contribution] OSC-SupportTicketSystem Vs 1.0


henri

Recommended Posts

Hello Henri,

Thank you very much. Easy to install. Works Perfectly.

 

One comment about the support system that incorporates email interaction: It needed to use the aliases, and people like myself who are using virtual hosts, were not very much in luck installing it properly..

 

 

One question: Which affiliate contribution did you happen to install?

 

Mehmet.

 

me dumb, your own of course, just found it :oops: :oops:

GALATASARAY RULES!

ultrAslan - ultrAslan - ultrAslan

Link to comment
Share on other sites

  • Replies 111
  • Created
  • Last Reply

Top Posters In This Topic

Sorry, this did not work either. I wish I knew a little more php so I could figure it out. But thanks a lot for you help.

 

Looked again ;)

 

<?php



   if (tep_session_is_registered('customer_id')) {



     echo tep_draw_hidden_field('name',$customer['customers_firstname'] . ' ' . $customer['customers_lastname']) . $customer['customers_firstname'] . ' ' . $customer['customers_lastname']; 



   } else {



     echo tep_draw_input_field('name', ($error ? $name : $first_name)); if ($error_name) echo ENTRY_ERROR_NO_NAME;



   }



?>

must be changed to

<?php

 

if (tep_session_is_registered('customer_id') || tep_session_is_registered('affiliate_id')) {

 

echo tep_draw_hidden_field('name',$customer['customers_firstname'] . ' ' . $customer['customers_lastname']) . $customer['customers_firstname'] . ' ' . $customer['customers_lastname'];

 

} else {

 

echo tep_draw_input_field('name', ($error ? $name : $first_name)); if ($error_name) echo ENTRY_ERROR_NO_NAME;

 

}

 

?>

 

The lines below the same

Link to comment
Share on other sites

Something strange is happening. when I go to view tickets and am logged in as a customer, it does not show any existing tickets. I was getting an error that reads:

 

Warning: Missing argument 3 for splitpageresults() in /hsphere/local/home/admi0/hrcc.com/catalog/includes/classes/split_page_results.php on line 24

 

Warning: Missing argument 4 for splitpageresults() in /hsphere/local/home/admi0/hrcc.com/catalog/includes/classes/split_page_results.php on line 24

 

Only get this error in ticket_view.php when logged in as a customer. Code looks like this:

 

<?php

   if (tep_session_is_registered('customer_id')) {

     $customers_tickets_raw = "select * from " . TABLE_TICKET_TICKET . " where ticket_customers_id = '" . tep_db_prepare_input($customer_id) . "' order by ticket_date_last_modified desc";

     $customers_tickets_split = new splitPageResults($customers_tickets_raw, $customers_tickets_numrows);

     if ($customers_tickets_split->number_of_rows > 0 ) {

?>

 

I changed the code to say this:

 

<?php

   if (tep_session_is_registered('customer_id')) {

     $customers_tickets_raw = "select * from " . TABLE_TICKET_TICKET . " where ticket_customers_id = '" . tep_db_prepare_input($customer_id) . "' order by ticket_date_last_modified desc";

     $customers_tickets_split = new splitPageResults($HTTP_GET_VARS['page'], MAX_DISPLAY_SEARCH_RESULTS, $customers_tickets_raw, $customers_tickets_numrows);

     if ($customers_tickets_split->number_of_rows > 0 ) {

?>

 

and the error went away, but it does not show a listing of existing tickets for the logged in customer.

 

Any ideas what I could be doing wrong? I am not so good with php so any help will be greatly appreciated!

 

Otherwise, this is a great contrib, and I appreciate your hard work.

 

Also, there are folders called CVS in all your directories. Am I supposed to upload these? I am using OSC 2.2 MS1

Greyson Schwing

Link to comment
Share on other sites

<?php



   if (tep_session_is_registered('customer_id')) {



     echo tep_draw_hidden_field('name',$customer['customers_firstname'] . ' ' . $customer['customers_lastname']) . $customer['customers_firstname'] . ' ' . $customer['customers_lastname']; 



   } else {



     echo tep_draw_input_field('name', ($error ? $name : $first_name)); if ($error_name) echo ENTRY_ERROR_NO_NAME;



   }



?>

must be changed to

<?php



   if (tep_session_is_registered('customer_id') || tep_session_is_registered('affiliate_id')) {



     echo tep_draw_hidden_field('name',$customer['customers_firstname'] . ' ' . $customer['customers_lastname']) . $customer['customers_firstname'] . ' ' . $customer['customers_lastname']; 



   } else {



     echo tep_draw_input_field('name', ($error ? $name : $first_name)); if ($error_name) echo ENTRY_ERROR_NO_NAME;



   }



?>

 

The lines below the same

Nope! that did not work either. Actually now if I'm logged in as a customer it tries to fill in the name and email but they are blank. :roll:

Samuel Mateo, Jr.

osC 2.2 MS2

Installed Mods:

WYSIWYG HTMLArea 1.7 | Basic Template System 1.0 | osC-Affiliate | OSC-SupportTicket

Featured Products 1.3 | LoginBox 5.2 | LatestNews 1.1.3 | Extras for IE

Link to comment
Share on other sites

Great news. All my problems went away when I installed the right version!!!!!

 

Imagine that! :oops:

 

ANyway. I am wondering now if there is a way to make the ticket ID a sequential set of numbers that includes the date. Example:

 

200308260001

200308260002

200308260003

 

and so on. I am thinking that the code that generates the Ticket ID is:

 

      $ticket_link_id = '';

     for ($x=3;$x<10;$x++) {

       $ticket_link_id .= substr($time,$x,1) . tep_create_random_value(1, $type = 'chars');

     }

 

Instead of create random value, can it be made to pull in tht date and then generate the next number in the sequence? I am sure there is a function that can be written to do this, but of course I am not a programmer.

 

Thanks again for everything, this helps a lot!

Greyson Schwing

Link to comment
Share on other sites

hi there guys:

 

I've installed this contribution, but it doesn't work for me!! (murphy law). Links doesn't show at the admin page, and when I try to manually get into it by the URL bar, I get this:

 

1146 - Table 'store.TABLE_TICKET_ADMIN' doesn't exist



select ticket_admin_id, ticket_admin_name from TABLE_TICKET_ADMIN where ticket_language_id = '3'



[TEP STOP]

 

I've read the readme file 100 times, but I still don't get It. I've uploaded all files again, created the database tables again, but nothing. I'm using the spanish language.

 

What am I doing wrong?

 

Thanks in advance!

Link to comment
Share on other sites

hi there guys:

 

I've installed this contribution, but it doesn't work for me!! (murphy law). Links doesn't show at the admin page, and when I try to manually get into it by the URL bar, I get this:

 

1146 - Table 'store.TABLE_TICKET_ADMIN' doesn't exist



select ticket_admin_id, ticket_admin_name from TABLE_TICKET_ADMIN where ticket_language_id = '3'



[TEP STOP]

 

I've read the readme file 100 times, but I still don't get It. I've uploaded all files again, created the database tables again, but nothing. I'm using the spanish language.

 

What am I doing wrong?

 

Thanks in advance!

It does seem to be a DB problem are you sure the tables were created succesfully? What are you using to create the tables phpMyAdmin is probably the best tool out there.

 

BTW I translated the osC-Affiliate completely to Spanish. The one that is included is only partially translated. Right now I'm working on translating the Admin side, should be done by the weekend. Hopefully :roll:

Samuel Mateo, Jr.

osC 2.2 MS2

Installed Mods:

WYSIWYG HTMLArea 1.7 | Basic Template System 1.0 | osC-Affiliate | OSC-SupportTicket

Featured Products 1.3 | LoginBox 5.2 | LatestNews 1.1.3 | Extras for IE

Link to comment
Share on other sites

Samuel:

 

I've loaded the SQL dump into PHPMYADMIN, but I can't see that table. I've tried not twice but trice (sorry if it's mispelled), and no luck.

PHPMYADMIN says this:

 

DROP TABLE IF EXISTS ticket_admins;# MySQL ha devuelto un valor vac?o (i.e. cero columnas).

CREATE TABLE ticket_admins(

ticket_admin_id int( 11 ) NOT NULL default '0',

ticket_language_id int( 11 ) NOT NULL default '0',

ticket_admin_name varchar( 255 ) NOT NULL default '',

PRIMARY KEY ( ticket_admin_id, ticket_language_id ) 

);# MySQL ha devuelto un valor vac?o (i.e. cero columnas).

DROP TABLE IF EXISTS ticket_department;# MySQL ha devuelto un valor vac?o (i.e. cero columnas).

CREATE TABLE ticket_department(

ticket_department_id int( 5 ) NOT NULL default '0',

ticket_language_id int( 11 ) NOT NULL default '0',

ticket_department_name varchar( 60 ) NOT NULL default '',

PRIMARY KEY ( ticket_department_id, ticket_language_id ) 

);# MySQL ha devuelto un valor vac?o (i.e. cero columnas).

DROP TABLE IF EXISTS ticket_priority;# MySQL ha devuelto un valor vac?o (i.e. cero columnas).

CREATE TABLE ticket_priority(

ticket_priority_id int( 11 ) NOT NULL default '0',

ticket_language_id int( 11 ) NOT NULL default '0',

ticket_priority_name varchar( 60 ) NOT NULL default '',

PRIMARY KEY ( ticket_priority_id, ticket_language_id ) 

);# MySQL ha devuelto un valor vac?o (i.e. cero columnas).

DROP TABLE IF EXISTS ticket_reply;# MySQL ha devuelto un valor vac?o (i.e. cero columnas).

CREATE TABLE ticket_reply(

ticket_reply_id int( 11 ) NOT NULL default '0',

ticket_language_id int( 11 ) NOT NULL default '0',

ticket_reply_name varchar( 255 ) NOT NULL default '',

ticket_reply_text text NOT NULL default '',

PRIMARY KEY ( ticket_reply_id, ticket_language_id ) 

);# MySQL ha devuelto un valor vac?o (i.e. cero columnas).

DROP TABLE IF EXISTS ticket_status;# MySQL ha devuelto un valor vac?o (i.e. cero columnas).

CREATE TABLE ticket_status(

ticket_status_id int( 5 ) NOT NULL default '0',

ticket_language_id int( 11 ) NOT NULL default '0',

ticket_status_name varchar( 60 ) NOT NULL default '',

PRIMARY KEY ( ticket_status_id, ticket_language_id ) 

);# MySQL ha devuelto un valor vac?o (i.e. cero columnas).

 

to name a few. (for non spanish speakers, "MySQL ha devuelto un valor vac?o (i.e. cero columnas)" means "MySQL hsa given an empty value (zero columns)).

 

Pleaseeeee!! heeelpppp!!

Link to comment
Share on other sites

Are you droping the tables manually or are you selecting the file from your computer and uploading it? I'm not sure if this makes any difference but that's what I did and it worked just fine.

 

 

BTW, I made a mistake above. :roll: I meant to say I have a spanish version of Support Ticket and it's completely translated; admin and catalog. :D I also do have osC-Affiliate if you want it. :wink:

Samuel Mateo, Jr.

osC 2.2 MS2

Installed Mods:

WYSIWYG HTMLArea 1.7 | Basic Template System 1.0 | osC-Affiliate | OSC-SupportTicket

Featured Products 1.3 | LoginBox 5.2 | LatestNews 1.1.3 | Extras for IE

Link to comment
Share on other sites

Hi Henri,

I'm uploading the language files to your contribution in the Contributions section. Got one question. Are the language files compatible with both MS1 and MS2? I wanted to specify this in the description, but since I don't run MS1 I don't know.

 

Thanks

Samuel Mateo, Jr.

osC 2.2 MS2

Installed Mods:

WYSIWYG HTMLArea 1.7 | Basic Template System 1.0 | osC-Affiliate | OSC-SupportTicket

Featured Products 1.3 | LoginBox 5.2 | LatestNews 1.1.3 | Extras for IE

Link to comment
Share on other sites

Hello,

 

I installed the OSC TicketSystem but must have done something wrong. I have looked and looked but just can't spot the problem.

 

On the main page where the new box is for the Tickets, all I get for the Title is: BOX_HEADING_TICKET

 

Inside the box:

BOX_TICKET_GENERATE

BOX_TICKET_VIEW

 

The admin section is working.

 

TIA

Link to comment
Share on other sites

Did you upload the ticket language file?

 

That is where these are defined

define ('BOX_HEADING_TICKET','Support Ticket');

define ('BOX_TICKET_GENERATE','Open Support Ticket');

define ('BOX_TICKET_VIEW','View Ticket');

Samuel Mateo, Jr.

osC 2.2 MS2

Installed Mods:

WYSIWYG HTMLArea 1.7 | Basic Template System 1.0 | osC-Affiliate | OSC-SupportTicket

Featured Products 1.3 | LoginBox 5.2 | LatestNews 1.1.3 | Extras for IE

Link to comment
Share on other sites

Hi Henri,

I'm uploading the language files to your contribution in the Contributions section. Got one question. Are the language files compatible with both MS1 and MS2? I wanted to specify this in the description, but since I don't run MS1 I don't know.

I think so. I only fixed small bugs, don't recall changing anything (but adding) to the language files.

Cu Henri

Link to comment
Share on other sites

  • 4 weeks later...

The ticket systems seems to work fine except for one problem.

 

1. When a users leaves a new ticket, I get an email about a new ticket.

2. I go to admin and reply to the ticket.

 

<problem>

3 User replies to my answer and i never know it because I never get an email

saying they entered a new reply. With 20 tickets a day its takes a while to search all the tickets that are adding up to see if anyone replied and needs more information.

 

Did I miss a step in the install ?

 

CVS2M2

 

Dave

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...