Jump to content
Sign in to follow this  
olsonsp4c

Live Support phpOnline

Recommended Posts

Great contribution. Thanks a lot for doing this.

 

When I log into my admin panel in the News window I get a message saying:

ERROR:

I can connect to MYSQL but can not check the tables.

 

My database is local and I created the user will all rights except grant.

 

Any suggestions how to fix this, do I need to worry about it?

 

Thanks angain.

 

D.

 

Unfortunately, I'm not really adept at mysql... Have you verified that your info in the config file is identical to that in your includes/configure.php file?

 

Scott

Share this post


Link to post
Share on other sites

I am having a problem with the customer support window popping up. When I turn off the STS template it works but when it is on the support window does not pop up. Everything on the admin side seems to be working fine.

 

Any ideas?

Share this post


Link to post
Share on other sites

did STS have you install a javascript function for popups with the same function name?

 

Scott

Share this post


Link to post
Share on other sites

Hi Scott,

 

I don't believe that STS has the same function name on a pop up window. I did try changing it just to be sure and the window still does not pop up.

 

Chris

Share this post


Link to post
Share on other sites

Scott thanks for getting back to me.

I resolved my problem by moving the javascript function to an external file. Now everything is working.

 

Best

Chris

Share this post


Link to post
Share on other sites

I have it all set up and in its most it appears to be working. I am having one major problem though I can not get the window to pop up (user). I am currently using STS and I am assuming this is where the problems are lying and something to do with the javascript commands. I noticed this has been mentioned already, only inliquid never went into detail on how he fixed it...

 

Is there any work around for this, (I am not the best at scripting and can not find a solution on my own)

 

many thanks in advance.

 

Gary

Share this post


Link to post
Share on other sites
I have it all set up and in its most it appears to be working. I am having one major problem though I can not get the window to pop up (user). I am currently using STS and I am assuming this is where the problems are lying and something to do with the javascript commands. I noticed this has been mentioned already, only inliquid never went into detail on how he fixed it...

 

Is there any work around for this, (I am not the best at scripting and can not find a solution on my own)

 

many thanks in advance.

 

Gary

 

Gary, I don't know personally how to fix it; however, I would suggest that you message Chris above and ask him what he did. I'm sure he'd be willing to post his solution or message it to you.

 

Scott

Share this post


Link to post
Share on other sites

Hi Scott,

 

I think I got into troubles..

 

I forgot my admin. user name & password !!

 

Is there a way to correct it?

 

Waiting please for any advise from you..

 

Thanks again dear Scott,

 

Regards,

Nath


Best Regards,

Nathali

Share this post


Link to post
Share on other sites
Hi Scott,

 

I think I got into troubles..

 

I forgot my admin. user name & password !!

 

Is there a way to correct it?

 

Waiting please for any advise from you..

 

Thanks again dear Scott,

 

Regards,

Nath

 

you can look it up in the store database in the "bvars" table...

 

Scott

Share this post


Link to post
Share on other sites
you can look it up in the store database in the "bvars" table...

 

Scott

 

Hi Scott !

 

How are you?

 

I looked in the database in the "bvars" table, and I see there only this:

bname bvalue

conf_GEmailSubject Message from online support

conf_Msg1 Please Wait...

conf_Msg2 Locating an Available and Online

Customer Service ...

 

 

 

I think it's not there..

 

Is there another place I could look for?

 

Thanks Scott,

 

Happy New Year,

Nath


Best Regards,

Nathali

Share this post


Link to post
Share on other sites
Hi Scott !

 

How are you?

 

I looked in the database in the "bvars" table, and I see there only this:

bname bvalue

conf_GEmailSubject Message from online support

conf_Msg1 Please Wait...

conf_Msg2 Locating an Available and Online

Customer Service ...

 

 

 

I think it's not there..

 

Is there another place I could look for?

 

Thanks Scott,

 

Happy New Year,

Nath

 

happy ny to you as well!

 

here's what i found on the phponline forum:

 

If you forgotten your admin login and/ or password, You need to reset everything to factory default. To do that drop all MySQL tables and let them to be created again. Then you may login with admin as username and adm123 as password.

 

Thanks!

 

Scott

Share this post


Link to post
Share on other sites
happy ny to you as well!

 

here's what i found on the phponline forum:

 

If you forgotten your admin login and/ or password, You need to reset everything to factory default. To do that drop all MySQL tables and let them to be created again. Then you may login with admin as username and adm123 as password.

 

Thanks!

 

Scott

 

Thanks a lot Scott !

 

So which MySQL tables I should delete? "bvars" & "msgdb" & "cs" ?

 

Thanks,

Nath


Best Regards,

Nathali

Share this post


Link to post
Share on other sites
Thanks a lot Scott !

 

So which MySQL tables I should delete? "bvars" & "msgdb" & "cs" ?

 

Thanks,

Nath

 

yes :D

Share this post


Link to post
Share on other sites

Just to report that I installed this contrib with no problems, except the image did not appear in the Live Support box. Whe I changed the

$phponline_status_indicator_type indicator in \includes\boxes\live_support.php to 1, it worked as it should.


The Coopco Underwear Shop

 

If you live to be 100 years of age, that means you have lived for 36,525 days. Don't waste another, there aren't many left.

Share this post


Link to post
Share on other sites

I have installed this, installed the database, made the changes in the config file, but all I get in admin side is a blank.

 

On user side I get the dayana window, but nothing happens.

 

I followed the installation to a "T".

 

I have even uninstalled it, uninstalled the database 6 times and I always get the same results.

 

Please help

Share this post


Link to post
Share on other sites
I have installed this, installed the database, made the changes in the config file, but all I get in admin side is a blank.

 

On user side I get the dayana window, but nothing happens.

 

I followed the installation to a "T".

 

I have even uninstalled it, uninstalled the database 6 times and I always get the same results.

 

Please help

 

it would be impossible for me to suggest something without looking at it, having ftp access to your website, and to your osC admin.

 

Scott

Share this post


Link to post
Share on other sites

Ok, I also followed the directions and have been over every part of them and I have the problem of the blank screen. I cannot even get to the admin it is just completely blank.

 

Now I am curious though I did not see and .sql files there was nothing to upload to the database?

 

Am I missing something here. I have been looking on the daymb forums for answers as well, not much luck so far.


The Site can be viewed at www.performanceautopartsonline.com

 

The site is live (despite these minor glitches) please respect that and do not sign up etc...

 

maybe a contribution one day when I get this site the way I want it.

 

I don't make spelling mistakes! I have dyslecsic fingers.

Share this post


Link to post
Share on other sites
Ok, I also followed the directions and have been over every part of them and I have the problem of the blank screen. I cannot even get to the admin it is just completely blank.

 

Now I am curious though I did not see and .sql files there was nothing to upload to the database?

 

Am I missing something here. I have been looking on the daymb forums for answers as well, not much luck so far.

 

I don't understand what you mean by blank screen. please post screenshots.

 

The sql is automatically added. there is no sql to upload.

 

Scott

Share this post


Link to post
Share on other sites

1. When I meant blank screen I meant nothing but white, plain, nada, nothing.

 

2. I figured out the problem, it was no thanks to Godaddy, they are going to be switching the database server and gave me the info for the new one but it is not transfered yet, so 1 call and I got the current info and BAM! it works.

 

Sorry to waste your time. But when I made changes then I would get the errors but with localhost (which it is not) it gave the blank screen.

 

Hopw that help someone else, check with your host company to get the correct info as 'localhost' is not correct in all instances.


The Site can be viewed at www.performanceautopartsonline.com

 

The site is live (despite these minor glitches) please respect that and do not sign up etc...

 

maybe a contribution one day when I get this site the way I want it.

 

I don't make spelling mistakes! I have dyslecsic fingers.

Share this post


Link to post
Share on other sites

I must say I love this contribution! Excellent work.

 

Now having said that, I have a couple of questions/requests that I think can make it even better.

 

1. If on the ring tones selector in the admin if there was a way to press play to preveiw each one before selecting it (other wise I have to test it from the user side each time, or from my computer (good for the staff as well).

 

2. Is there a way to set the window size of the popup on the users end so that it is just slightly larger than the border (like the admin is) currently mine comes up short of a full page with lots of wasted white space.

 

3. Is there a way to make the admin window turn orange in the bottom (start menu) when the window is minimized when there is someone waiting (many other programs do this for various reasons i.e. yahoo IM)

 

I would start looking into it but I am not a programmer and I have so many other things on my plate, but I thought I would throw it out there.

 

Thanks again,


The Site can be viewed at www.performanceautopartsonline.com

 

The site is live (despite these minor glitches) please respect that and do not sign up etc...

 

maybe a contribution one day when I get this site the way I want it.

 

I don't make spelling mistakes! I have dyslecsic fingers.

Share this post


Link to post
Share on other sites
I must say I love this contribution! Excellent work.

 

Now having said that, I have a couple of questions/requests that I think can make it even better.

 

1. If on the ring tones selector in the admin if there was a way to press play to preveiw each one before selecting it (other wise I have to test it from the user side each time, or from my computer (good for the staff as well).

 

2. Is there a way to set the window size of the popup on the users end so that it is just slightly larger than the border (like the admin is) currently mine comes up short of a full page with lots of wasted white space.

 

3. Is there a way to make the admin window turn orange in the bottom (start menu) when the window is minimized when there is someone waiting (many other programs do this for various reasons i.e. yahoo IM)

 

I would start looking into it but I am not a programmer and I have so many other things on my plate, but I thought I would throw it out there.

 

Thanks again,

 

Thanks... 2 of those suggestion could just go directly to dynahost that wrote the actual software at http://www.dayanahost.com/forum2/index.php...SF&f=8& (I just ported it to osCommerce and customized it a bit)

 

The popup in the catalog and admin can be changed in size. Just look at the javascript in the infobox file and in the admin/includes/header.php and look for the height width settings which are large numbers like 500, 450 or something like that...

 

Scott

Share this post


Link to post
Share on other sites

Ok this is strange. On the admin side the screen sizes fine. But on the client side like I said the screen comes up almost as a full page and yet I looked up the settings and they are set at 5xx and 400 already, but for some reason it is not following that? wonder if there is an error in the script?

 

THis is the script in includes/boxes/live_support.php (I enlarged the sizes a bit as a test)

 

<script language="javascript"><!--

function phpOnlinePopupWindow() {

var url = "<?php echo $phpOnline_base_url.'/client.php';?>";

window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,res

izable=no,copyhistory=no,width=650,height=450,screenX=150,screenY=150,top=150,lef

t=150')

}

//--></script>


The Site can be viewed at www.performanceautopartsonline.com

 

The site is live (despite these minor glitches) please respect that and do not sign up etc...

 

maybe a contribution one day when I get this site the way I want it.

 

I don't make spelling mistakes! I have dyslecsic fingers.

Share this post


Link to post
Share on other sites
Ok this is strange. On the admin side the screen sizes fine. But on the client side like I said the screen comes up almost as a full page and yet I looked up the settings and they are set at 5xx and 400 already, but for some reason it is not following that? wonder if there is an error in the script?

 

THis is the script in includes/boxes/live_support.php (I enlarged the sizes a bit as a test)

 

<script language="javascript"></script>

 

In should read like this with no line break after "res" or after "lef":

 

<script language="javascript"><!--
 function phpOnlinePopupWindow() {
 var url = "<?php echo $phpOnline_base_url.'/client.php';?>";
window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,res
 izable=no,copyhistory=no,width=650,height=450,screenX=150,screenY=150,top=1
50,le
f
 t=150')
 }
 //--></script>

 

in this example you gave, the width is 650 and height 450

 

you might check your index.php to see if there is another popup script with the same name "popupWindow" - if so, rename that part.

 

Scott

Edited by olsonsp4c

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×