Announcement

kit...@yahoo.ie

Guest

MySQL on Client side

I was wondering if it's possible to add MySQL compatibility/functionality to the Windows client. Was hoping that when users go on to my site, it could check the MySQL database to see if any live support agents are online.
Would need to check this through the Desktop client I believe. Any help is appreciated!

https://groups.google.com/forum/#!topic … bQZLPYsLM0

Frank Frank

Member

Registered: 2013-03-15

Posts: 9

Re: MySQL on Client side

Why you need MySQL on Users Windows Client for checking livesupport status ?

On Wednesday, August 14, 2013 9:23:09 AM UTC+8, kit...***.ie wrote:I was wondering if it's possible to add MySQL compatibility/functionality to the Windows client. Was hoping that when users go on to my site, it could check the MySQL database to see if any live support agents are online.
Would need to check this through the Desktop client I believe. Any help is appreciated!

kit...@yahoo.ie

Guest

Re: MySQL on Client side

Because on my site, it checks if any online staff are signed in before displaying a message saying "Live Support Representatives Online". I'd need the client to set the user to online once they open the Client.

Remigijus Kiminas

Administrator

From: Lithuania

Registered: 2012-09-23

Posts: 3,661

Website

Re: MySQL on Client side

Hi,

Sorry but still i'm confused what you actually want to do. During embed code generation you can choose display widget if there are any online users or not.

2013/8/27  <kit...***.ie>

kit...@yahoo.ie

Guest

Re: MySQL on Client side

I'll try explain:

On my website: I've created code that forces a pop up to show up if any live support agents are online, asking the user does he need assistance from the live support staff.

I need my website to be able to detect if any admins are currently logged in to the Desktop client. If none have it open on their desktop, the pop up won't appear to the user.

I believe MySQL would be the best way to check this, or is there currently another method that makes it possible?

On Wednesday, August 14, 2013 2:23:09 AM UTC+1, kit...***.ie wrote:I was wondering if it's possible to add MySQL compatibility/functionality to the Windows client. Was hoping that when users go on to my site, it could check the MySQL database to see if any live support agents are online.
Would need to check this through the Desktop client I believe. Any help is appreciated!

Remigijus Kiminas

Administrator

From: Lithuania

Registered: 2012-09-23

Posts: 3,661

Website

Re: MySQL on Client side

Hi,

I'm still not sure what you want to do that, but in any case:
Just see this method
$isOnlineHelp = erLhcoreClassChat::isOnline($department);

https://github.com/remdex/livehelperchat/blob/master/lhc_web/lib/core/lhchat/lhchat.php#L506

Hope it helps with your modification

2013/8/28  <kit...***.ie>

kit...@yahoo.ie

Guest

Re: MySQL on Client side

That's what I'm looking for. Could you please help me with the code though?

How can I make my homepage check if there is any support agents online when a user goes onto my site?
Something like this:

if(SupportAgentsOnlineCount !=0)
{
     ///Run code for agents online
}
else
{
     ////Run code for no agents online
}

Obviously that code won't work but that is what I'd want to do. Could you type in code that I could put into my homepage to check this?

On Wednesday, August 14, 2013 2:23:09 AM UTC+1, kit...***.ie wrote:I was wondering if it's possible to add MySQL compatibility/functionality to the Windows client. Was hoping that when users go on to my site, it could check the MySQL database to see if any live support agents are online.
Would need to check this through the Desktop client I believe. Any help is appreciated!

kit...@yahoo.ie

Guest

Re: MySQL on Client side

Any help?

On Wednesday, August 14, 2013 2:23:09 AM UTC+1, kit...***.ie wrote:I was wondering if it's possible to add MySQL compatibility/functionality to the Windows client. Was hoping that when users go on to my site, it could check the MySQL database to see if any live support agents are online.
Would need to check this through the Desktop client I believe. Any help is appreciated!

kit...@yahoo.ie

Guest

Re: MySQL on Client side

Please give me any assistance you can. Please don't ignore me. Thank you.

On Wednesday, August 14, 2013 2:23:09 AM UTC+1, kit...***.ie wrote:I was wondering if it's possible to add MySQL compatibility/functionality to the Windows client. Was hoping that when users go on to my site, it could check the MySQL database to see if any live support agents are online.
Would need to check this through the Desktop client I believe. Any help is appreciated!

Remigijus Kiminas

Administrator

From: Lithuania

Registered: 2012-09-23

Posts: 3,661

Website

Re: MySQL on Client side

Hi,

Read documentation and make your own extension.

2013/9/12  <kit...***.ie>