Bleem with Live Support!

[bluejeans]

In first, excuse for my english, but i'm a french guy, and my english is a little poor! :oops:

 

I've installed "Live Support" (a very nice contribution) on my site and I've this problem when i try to connect with "Guest"! and the live support is engaged in my admin panel

 

Fatal error: Call to undefined function: tep_db_prepare_input() in /xxxx/xxxx/html/live_support.php on line 23

 

Below the "live_support.php" in my catalog repertory:

 

 

<?

/*

 

Live Support v 1.2b

Author: Mike Lessar <[email protected]>

 

for use with:

osCommerce v2.2, Open Source E-Commerce Solutions

http://www.oscommerce.com

 

Released under the GNU General Public License

 

*/

 

require('includes/application_top.php');

 

if($login) {

// first lets check to see if live support is really available

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

$support_results = tep_db_num_rows($support_query);

if($support_results > 0) {

// enter the user into the que

$guest = tep_db_prepare_input($HTTP_POST_VARS['login']);

if(!$guest) { $guest = "Guest"; }

$start_msg = "Welcome $guest, please wait a few seconds for a live operator to come to your assistance.";

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

tep_db_query("insert into " . TABLE_LS_STATUS . " (id, session_id, status) values ('', '" . $osCsid . "', '1')");

tep_redirect(tep_href_link('ls_start.php', '', 'NONSSL'));

} else {

echo "<br><br><div align="center"><b>Sorry but support is currently not availabe!</b></div>n";

}

} else {

 

?>

 

 

Thanks for your help! :wink:

[Guest]

Have you installed the Live Support Fix? If not, download it and replace the /catalog/admin/live_support.php file with the new one.

 

Good Luck.

 

-R

[bluejeans]

Thanks ugottasalsa for your answer.

 

Yes I've installed the fix.

I don't understand why i've this problem, so for the moment i've uninstall it!

 

Thanks again, bye!