Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Just released Live Support for osC


Guest

Recommended Posts

I was lookingI was looking for a free solution to offer a customer of mine the ability for Live Support. However, there really wasn't one, I looked at the others here, while one used ICQ and the other wasn't exactly free.

 

So I created one that integrates into osCommerce.

 

you can view a demo here at.

admin: http://dev.bluetruck.net/original/admin/index.php

catalog: http://dev.bluetruck.net/original/catalog/default.php

 

Just so you are aware, i found a couple of bugs that I need to work out, minor ones really, but they will worked out in a day or two.

 

this uses a page refresh for the script, and I would like to create a socket based version, but that is still some ways off yet

 

Go ahead and download, the script take a look at it and tell me what you think. If there is something that you can contribute, that would be appreciated, and I hope you can use it.

 

also if you have any bugs or contributions please let me know.

 

 

Mike

Link to comment
Share on other sites

  • Replies 93
  • Created
  • Last Reply

Top Posters In This Topic

On my installation, after the windows is closed, the status don't change in the ls_techs table.

 

If I make a connection, after close, the status is still busy. If I dont' make any discution, when I close the window (as admin) the status remain "yes".

 

 

Thank you for your help,

Link to comment
Share on other sites

Hi Mike,

 

Great contro, Installed like a dream .. But I have noticed a couple of issues. I am sure they are small but here they are.

 

I do not know if there is an unvailable graphic but even if I do not open the admin side it still says available.

 

After testing the chat portion (which worked great) the opened window went to busy when I ended chat. But still allowed people to click on the help. So they just sat there with waiting and I was never notified.They get a chat window but I did not get any notice.

 

After I closed the window in the admin area and tried to reopen it tell me that there is 1 window open and I can not open any more.

 

Your thoughts on the about?

 

kmcar :D

Link to comment
Share on other sites

This is the beta version, and I needed some testing, ideas and suggestions.

 

I appreciate everything you have told me, I am going ot be working on fixing the problems suggested.

 

I am going to try and include the following.

 

- multiple support users. (may take a little more time)

- method for handling multiple requests.

- notify message to support user when user closes window.

- notify to user when support is on another chat.

 

plus others as they get reported, or suggested.

 

I think this could be a great contribution, and with your help and patience I can work out most of the bugs and problems.

Link to comment
Share on other sites

This is the beta version, and I needed some testing, ideas and suggestions.

 

I appreciate everything you have told me, I am going ot be working on fixing the problems suggested.

 

I am going to try and include the following.

 

- multiple support users. (may take a little more time)

- method for handling multiple requests.

- notify message to support user when user closes window.

- notify to user when support is on another chat.

 

plus others as they get reported, or suggested.

 

Kewl ...

 

I replaced the ls_start.php like suggested. You also mentioned that you forgot to put an extenseion on a file. I looked through the whole contro and did not find that.

 

Just so you know when I try and start the support mod from within admin I get the following error.

 

Live Support is currently open

Currently only 1 window can be open

 

But I checked and it is not open anywhere that I know of. Don;t know if I told you that one yet.

 

Great Job Mike .. I'm here with ya testing away. As long as you fix them I will test them.

 

kmcar :D

 

I think this could be a great contribution, and with your help and patience I can work out most of the bugs and problems.

Link to comment
Share on other sites

I think when I got my sql tables, my live support was open at the time.

 

which placed the tech as being in use.

 

open your ls_tech table and change status from 'yes' to 'no'

 

that should fix that problem.

 

sorry

Link to comment
Share on other sites

I think when I got my sql tables, my live support was open at the time.

 

which placed the tech as being in use.

 

open your ls_tech table and change status from 'yes' to 'no'

 

that should fix that problem.

 

sorry

 

Tried that but it did not work. There is no data in either tables

Link to comment
Share on other sites

try this:

 

DROP TABLE `ls_techs`;

 

CREATE TABLE ls_techs (

tech_id int(11) NOT NULL auto_increment,

support_tech varchar(20) NOT NULL default '',

password varchar(25) NOT NULL default '',

support_group varchar(255) NOT NULL default '',

status varchar(10) default NULL,

PRIMARY KEY (tech_id),

UNIQUE KEY yech_id (tech_id)

) TYPE=MyISAM;

 

#

# Dumping data for table `ls_techs`

#

 

INSERT INTO ls_techs VALUES (1, 'Sales', '', 'Sales', 'no');

Link to comment
Share on other sites

try this:

 

DROP TABLE `ls_techs`;

 

CREATE TABLE ls_techs (

 tech_id int(11) NOT NULL auto_increment,

 support_tech varchar(20) NOT NULL default '',

 password varchar(25) NOT NULL default '',

 support_group varchar(255) NOT NULL default '',

 status varchar(10) default NULL,

 PRIMARY KEY  (tech_id),

 UNIQUE KEY yech_id (tech_id)

) TYPE=MyISAM;

 

#

# Dumping data for table `ls_techs`

#

 

INSERT INTO ls_techs VALUES (1, 'Sales', '', 'Sales', 'no');

Ok that got it going again. But after I went into chat and disccounted chat it still states busy. Is there a limit to kill the connection with no activity.

 

Also if the admin side states busy which it isn't it still allows on the client side and just sits there with a chat window blinking

Link to comment
Share on other sites

try this:

 

DROP TABLE `ls_techs`;

 

CREATE TABLE ls_techs (

 tech_id int(11) NOT NULL auto_increment,

 support_tech varchar(20) NOT NULL default '',

 password varchar(25) NOT NULL default '',

 support_group varchar(255) NOT NULL default '',

 status varchar(10) default NULL,

 PRIMARY KEY  (tech_id),

 UNIQUE KEY yech_id (tech_id)

) TYPE=MyISAM;

 

#

# Dumping data for table `ls_techs`

#

 

INSERT INTO ls_techs VALUES (1, 'Sales', '', 'Sales', 'no');

 

I think the problem lies in the status. When I end a chat it goes to busy and if you close the admin part it goes to busy. After changing status to yes, I was able to startup the admin char portion, if it was no then unavailable is shown on the site which is perfect.

 

Tried finding you on MSIM but no listing

Link to comment
Share on other sites

This error is from your testing site, l3ackdraft:

 

1054 - Unknown column 'tech_reply' in 'field list'



insert into ls_conversations (id, guest, tech, session_id, message, tech_reply) values ('', 'Clement', 'Sales', '9ece6c6035680a75e8a4c6fb75034092', 'Welcome Clement, please wait a few seconds for a live operator to come to your assistance.', '2')



[TEP STOP]

Link to comment
Share on other sites

right now there are going ot be some errors on the demo site.

 

I am in the process of making some changes to the Live Support, and in doing so some changes were in the SQL, and the code itself.

 

Until I work out these changes, the demo site is BROKE.

 

I will post when new changes are active and the site it working.

 

thanks for all your input.

Mike

Link to comment
Share on other sites

I love what you have done so far with your live support. I have installed the base and the first fix. Don't know what the second fix was for you didn't explain that one, other than to say you goofed.

 

I wait with anticipation for you next release and fixes.

Here are some suggestions>

 

1) a reset tech button so I don't have to open myphpadmin to reset.

2) a kill session button so it the other person loses their connection I don't have to open myphpadmin and delete the users text to clear the chat.

3) that is a great alarm clock you have to notify trech that a call is coming in can you knock it down a few notches, I still have claw marks on the ceiling :lol:

4) an Admin page to do maint - add and delete techs. and to clear past chat sessions.

5) and of course the biggie multi session chats from the same tech, so one man operations can handle multiple calls.

 

Keep up the great work!

 

Thanks

Theo. :D

Share your knowlege and you learn even more !

Link to comment
Share on other sites

in Admin

If you change ls_commwindow.php at line 29

from

function popup(){

var win = window.open('ls_comm_exit?tech=1','conversation');

 

to

function popup(){

var win = window.open('ls_comm_exit.php?tech=1','conversation');

 

(the php ext is missing) 8)

it fixes the "busy" problem.

 

The next problem is if the "sales" closes before the user the conversation table is not cleared and the phone will keep ringing.

Link to comment
Share on other sites

Feature Requests...

 

1) Option to turn on sound so it will play a ring wave/midi.

2) Option for multi-windows if more then one person wants help.

3) Option to turn off display part if help is not available.

4) If live help is not available forwards to contact page where it has filled in subject and just asks for email/comment. Like Sorry but we're not available right now.. and shows normal hours of operation.

 

I'm currently testing it now and it seems to work...

Link to comment
Share on other sites

i've made some modifications to these nice code, i got it working pretty good , there are just some details that i got to fix.

 

btw, im not an expert so if the code it's "newbie" in someplaces, dont complain :)

 

maybe some "code-master" can get a better results.

 

- to fix the availability issue, i modified the file catalog/live_support.php , the customer only can login if the status of the Sales agent is yes.

 

original

$support_query = tep_db_query("select status from " . TABLE_LS_TECHS . " where status='yes' or status='busy' ");

modified

 

$support_query = tep_db_query("select status from " . TABLE_LS_TECHS . " where status='yes'");

 

- when a user leaves the chat , you have to clear the session, i think the better choice is to control the status of the session in the Sales side, so in catalog/ls_exit.php i added a line to the buffer so the Sales agent can notice when the customer leaves the chat

put it just below the for cycle

 

$guest ='';

$message='the customer has leave the room';

tep_db_query("insert into " . TABLE_LS_CONVERSATIONS . " (id, guest, tech, session_id, message, tech_reply) values ('', '" . $guest . "', 'Sales',  '" . $osCsid . "', '" . $message . "', '0')");

 

this is the code in the script portion of admin/ls_commwindow.php

<script language="javascript">

function popup(){

       window.open('ls_comm_exit.php?osCsid=<? echo $session_id; ?>');

}

</script>

</head>

 

at this moment there's only one line in the buffer and the status is still busy, so in admin/ls_comm_exit.php i got this code

 

<?

require('includes/application_top.php');

$delete_query = tep_db_query("select id from " . TABLE_LS_CONVERSATIONS . " where session_id = '" . $osCsid . "' ");

$delete_results = tep_db_num_rows($delete_query);

echo $delete_results;

for($i=0; $i < $delete_results; $i++) {

       tep_db_query("delete from  " . TABLE_LS_CONVERSATIONS . "  where session_id = '" . $osCsid . "' ");

}



tep_db_query("update " . TABLE_LS_TECHS . " set status = 'yes' where tech_id = '1'  ");



echo "<script>window.close()</script>";

?>

 

this will clear the buffer and with status "yes" (available)

 

i dont know if it's my browser but im having a hard time with the popup() function (onunload wndow) in ls_commwindow.php , sometime it works and sometime id doesnt works, so im thinking that maybe i will have to use a "Close" button

 

i still got to fix the situation when the Sales agent leaves the room first.

 

Mike, congrats. , nice job with this mod. :D

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...