var OC_newsession = 0; //忽略js错误 function killErrors(){ return true; } window.onerror = killErrors; var OC_delPageURL=""; //获取网站速度,spTime为耗时,GetPageSize为页面大小 var GetEndTime; var GetStartTime; var GetPageSize; function speedTest(){ var now=new Date(); GetEndTime=now.getTime(); if(typeof(beginTime) == 'undefined') { GetStartTime = -1; }else { GetStartTime = beginTime; } if(typeof(document.body.outerHTML)!='undefined') GetPageSize = document.body.outerHTML.length; else if(typeof(document.body.innerHTML)!='undefined') GetPageSize = document.body.innerHTML.length; } speedTest(); var spTime; if(GetStartTime == -1) spTime = -1; else spTime =GetEndTime-GetStartTime; //基础变量设置 var _LANG_NO_HISTORY = "没有历史记录"; var _LANG_SAVE_FAILURE = "保存失败"; var _LANG_SAVE_SUCCESS = "文件保存成功"; var _LANG_WELCOME = "欢迎您"; var _LANG_STATUS_1 = "在线"; var _LANG_STATUS_2 = "下线"; var _LANG_STATUS_3 = "忙碌"; var _LANG_STATUS_4 = "离开"; var _LANG_STATUS_5 = "下线"; var _LANG_STATUS_6 = "会议"; var _LANG_CLICK_WITH = "点击与"; var _LANG_CHAT_WITH = "交谈"; var _LANG_LIVEWORD_WITH = "留言"; var _LANG_WEB_SERVICE = "网站人员"; var _LANG_ASK_CHAT = "请求通讯"; var _LANG_CAN_YOU_AGREE = "你是否接受本公司在线人员"; var _LANG_SOME_HELP = "的通讯帮助"; var _LANG_AGREE_INFO = "如果是请点击“接受”,如果拒绝请点击“关闭”!"; var _LANG_CLICK_USERNAME = "请点击客服名称"; var _LANG_CHAT_OR_LIVEWORD = "即时交谈或留言"; var _LANG_LOADING_WAITING = "加载中,请稍等..."; var _LANG_USER_ASK_CHAT = "网站人员请求通讯"; var _LANG_CAN_YOU_ACCEPT = "是否接受本客服人员的帮助"; var _LANG_ACCEPT = "接受"; var _LANG_CLOSE = "关闭"; var _LANG_OFFLINE_LIVEWORD = "该客服人员不在线,你所发送的消息将会作为留言信息"; var _LANG_CONNECT_OK = "服务器连接成功"; var _LANG_MSG_NULL = "不能发送空消息!"; var _LANG_CONNECTING = "正在连接服务器中,请稍候发送!"; var _LANG_I_SAY = "我说"; var _LANG_FLEX_ERR_PARM = "系统出错,请稍候再试!"; var _LANG_FLEX_ERR_CLOSE = "服务器的连接已关闭,请重新再试!"; var _LANG_FLEX_ERR_FAILURE = "连接客服人员失败!"; var OC_counter=1; var OC_BASEURL = "http://www.ocint.net/"; var OC_myUserAcct= "G2466065"; var OC_myCompany = "21169"; var OC_mySkin = "black"; var OC_myAlign="righttop"; var OC_myX="0"; var OC_myY="0"; var OC_myUserName="美国190169"; var OC_myLang="cn"; var OC_server="125.89.79.67"; var OC_port=4409; var OC_output = ""; var OC_sysMyName = []; OC_sysMyName[0] = ""; OC_sysMyName[1] = ""; var OC_sysDomain = ""; var OC_stopBase = 0;//是否停止缓存验证 var OC_DEBUG = 1; var OC_OutClass = ""; var m_myAcct = OC_myUserAcct; var m_chatName = "";//聊天对象名称 var m_chatAcct = "";//聊天对象的帐号 var IpInfo = "";//IP信息 var m_imgshow = OC_BASEURL+"/WebOC/imgShow.php"; //FLASH调用的提示信息 function falert(errtype) { if(OC_DEBUG==0)return; switch(errtype) { case 0: alert(_LANG_FLEX_ERR_PARM); break; case 1: alert(_LANG_FLEX_ERR_CLOSE); break; case 2: alert(_LANG_FLEX_ERR_FAILURE); break; } } //保存用户信息 var OC_userInfoList = []; var OC_groupInfoList = []; var OC_userCount=0; var OC_servgroupNum=0; var OC_companyAcct; var OC_webAdd = 1;//列表由WEB添加 var OC_myWidth = 114; //OC的宽度 var bLogin = false;//聊天登录 var oc_offline=false;//下线 var oc_flashReady = false; //flash加载完成 //DIV移动相关信息 var OC_Obj=''; var OC_px=0; var OC_py=0; //获取当前网址 function GetUrl(){ return window.location.href; } //分析网址 function getval(s,val) { var arr = s.split("?"); if (!arr[1]) return ""; s = arr[1]; arr = s.split(val+"="); if (!arr[1]) return ""; s = arr[1]; arr = s.split("&"); return arr[0]; } //判断用户的按键 function keyDown(e){ if(ns4){ var iekey=e.which; } if(ie4){ var iekey=event.keyCode; } if ( (event.keyCode==116)|| //屏蔽 F5 刷新键 (event.ctrlKey && event.keyCode==82)){ //Ctrl + R event.keyCode=0; event.cancelBubble = true; return false; } if ((event.ctrlKey)&&(event.keyCode==78)) //屏蔽 Ctrl+n return false; if ((event.shiftKey)&&(event.keyCode==121)) //屏蔽 shift+F10 return false; if(event.ctrlKey&&iekey=="13"){ sendMsg(eWebEditor.document.body.innerHTML); eWebEditor.document.body.innerHTML=''; } } //返回对象 function mObj(name){ return document.createElement(name); } //保存文件 function savefile( obj_name ) { var d, s = ""; d = new Date(); s += (d.getYear()) + '.'; s += (d.getMonth() + 1) + "."; s += d.getDate(); var obj = getObj(obj_name); var txt = obj.innerHTML; if(txt.length<=0){ alert(_LANG_NO_HISTORY);//没有历史记录 return false; } var w = window.frames.w; if( !w ) { w = mObj( 'iframe' ); w.id = 'w'; w.style.display = 'none'; document.body.insertBefore( w ); w = window.frames.w; if( !w ) { w = window.open( '', '_temp', 'width=100,height=100' ); if( !w ) { window.alert(_LANG_SAVE_FAILURE); return false;//保存失败 } } } var d = w.document, ext = ".html"; path = "c:\\"; name = s+"@"+OC_sysMyName+ext; // alert(name); d.open( 'text/plain', 'replace' ); d.charset = 'UTF-8'; /* if( ext==='.txt' ) { d.write( obj.innerText ); d.close(); } else { */ d.close(); d.body.innerHTML = '\r\n' + obj.innerHTML + '\r\n'; // } if( d.execCommand( 'SaveAs', null, path+name ) ){ window.alert( _LANG_SAVE_SUCCESS+ name );//文件保存成功 } w.close(); return true; } //========================================修改函数===================================================== var OC_jsReady=false; var OC_swfReady=false; var OC_isIEBrowser=false; //检查浏览器 function CheckBrowser() { var app=navigator.appName; if (app.indexOf('Microsoft') != -1) { OC_isIEBrowser = true; } else { OC_isIEBrowser = false; } } function getSWF(movieName) { if (OC_isIEBrowser) { return window[movieName+"_ob"]; } else { return document[movieName+"_em"]; } } function isReady(){ return OC_jsReady; } function setSwfIsReady(){ if(oc_flashReady) //本函数已经加载 return; if(ocGetOffleint()) //全部下线 { return; } OC_swfReady=true; getSWF("FlashSocket").JConnectSocket(); ocgetServsys(); oc_flashReady = true; } //页面初始化 function pageInit(){ CheckBrowser(); //设置列表所在的位置 if(1) { getObj("OCWeb").style.top = OC_myY+'px'; if(OC_myAlign=="lefttop") getObj("OCWeb").style.left = OC_myX+'px'; else if(OC_myAlign=="righttop") getObj("OCWeb").style.left = document.body.clientWidth-OC_myX-OC_myWidth+'px'; else getObj("OCWeb").style.left = OC_myX+'px'; //默认左上角 } OC_jsReady=true; } //通过ID获得对象 function getObj(name){ return document.getElementById(name); } //加载列表所需的Socket的flash对象 function WriteSocket(){ OC_sysDomain = getval(document.location.href, "domain"); document.write(""); document.write(" "); document.write(" "); document.write(" "); document.write(" "); document.write(" "); } //聊天通讯窗口 function WriteChatSocket(){ document.write(""); document.write(""); document.write(""); document.write(" "); document.write(""); document.write(""); } //获取公司账号 function getCompanyAcct(){ return OC_companyAcct; } //默认缺省字体 function SetDefaultSize(strText) { var nStart = strText.indexOf("",nStart); var strStart = strText.substring(0,nEnd-1); var strEnd = strText.substring(nEnd); strText = strStart + " size=3" + strEnd; return strText; } //获取设置的样式 function GetStyle() { var strStyle = "font-size:12px; font-family:'宋体'; color:#000000;" return strStyle; } //发送信息 function sendMessage(str){ var now = new Date(); var strYear = now.getYear(); var strMonth = now.getMonth()+1; var strDay = now.getDate(); var strTime=now.toLocaleTimeString(); //获取当前时间 var dateTime = strYear+'-'+strMonth+'-'+strDay+' '+strTime; if(bLogin == true) { //改成APPEND的方法防止刷新 var s=document.createElement("span"); s.innerHTML="
"+_LANG_I_SAY+":("+dateTime + ")
" +str + "

"; getObj("message_box_mini").appendChild(s); getObj("OC__main_box").scrollTop=getObj("OC__main_box").scrollHeight; //滚动条回滚 getSWF("mySocket").JSendMessage(str); } else alert(_LANG_CONNECTING); } function SendMsgTOServer(msgid) { if(bLogin) //已经登陆成功 { var strText = msgid.value; //获得发送的信息 if(strText != "") { sendMessage(strText); } else alert(_LANG_MSG_NULL); msgid.value= ''; } else alert(_LANG_CONNECTING); } function showMessage(str,dateTime) { //改成APPEND的方法防止刷新 show_pop(); document.getElementById("servid").innerHTML = GetUserName(m_chatAcct); var s=document.createElement("span"); str = str.replace("src=\"","src=\""+OC_BASEURL+"/WebOC/"); s.innerHTML="
"+GetUserName(m_chatAcct)+"说:("+dateTime + ")
" +str + "

"; getObj("message_box_mini").appendChild(s); getObj("OC__main_box").scrollTop=getObj("OC__main_box").scrollHeight; //滚动条回滚 this.window.focus(); //窗口获得焦点弹出 getObj('eWebEditor').contentWindow.focus(); //getObj()不行,获不得焦点 } function ShowSize(dSize) { if(dSize<1024) { return dSize+"字节"; }else if(dSize>=1024&&dSize<1048576) { return parseInt(dSize/1024)+"K"; }else if(dSize>=1048576) { return parseInt(dSize/1048576)+"M"; } } //屏蔽按钮 function DisabledBtn(type, dFileNo,filename) { switch(type) { case 1: //接受 getSWF("mySocket").JSendFileMessage(MESSAGEACTIONACCPT,dFileNo,filename); break; case 0: //取消 getSWF("mySocket").JSendFileMessage(MESSAGEACTIONREFUSE,dFileNo,filename); break; case 2: //取消发送文件 getSWF("mySocket").JSendFileMessage(MESSAGEACTIONCANCLE,dFileNo,filename); break; } if(document.getElementById("allow"+dFileNo)) document.getElementById("allow"+dFileNo).innerHTML = "接受"; if(document.getElementById("deny"+dFileNo)) document.getElementById("deny"+dFileNo).innerHTML = "拒绝"; if(document.getElementById("askfile"+dFileNo)) document.getElementById("askfile"+dFileNo).innerHTML = "取消"; } //显示文件发送请求 var timer; var MESSAGEACTIONACCPT =1; //接受文件 var MESSAGEACTIONREFUSE =2; //拒绝文件 var MESSAGEACTIONCANCLE =3; //取消文件 var MESSAGEACTIONSENDERROR =4; //文件接收错误 function showAskMessage(nMessageAction,dFileNo,filename,dSize) { //改成APPEND的方法防止刷新 m_chatName = GetUserName(m_chatAcct); show_pop(); if(nMessageAction=="") { //请求数据 var s=document.createElement("span"); s.innerHTML="
"+m_chatName+" 准备给您发送文件:"+filename+"(大小"+ShowSize(dSize)+"),接受还是拒绝

"; getObj("message_box_mini").appendChild(s); getObj("OC__main_box").scrollTop=getObj("OC__main_box").scrollHeight; //滚动条回滚 this.window.focus(); //窗口获得焦点弹出 }else if(nMessageAction==MESSAGEACTIONCANCLE) { document.getElementById("ask"+dFileNo).innerHTML = " 发送方已经取消!"; } else if(nMessageAction==MESSAGEACTIONREFUSE) { document.getElementById("selaction"+dFileNo).innerHTML = " 接收方拒绝接收!"; } else if(nMessageAction==MESSAGEACTIONACCPT) { document.getElementById("selaction"+dFileNo).innerHTML = " 接收方同意接收!"; //显式进度条 document.getElementById('progcon'+dFileNo).style.display = ""; document.getElementById('proframe'+dFileNo).style.display = ""; document.getElementById('speed'+dFileNo).style.display = ""; /*var pf = document.frames['proframe'+dFileNo]; var pro = "Loop.php?toacct="+escape(m_chatAcct)+"&dFileNo="+dFileNo+"&myacct="+escape(m_myAcct)+"&r="+Math.round(Math.random()*9999); pf.location.href = pro; */ window.setTimeout("ShowFrame('"+dFileNo+"')",1000); var sf = eval("sendframe"+dFileNo); var send_url="http://www.ocint.net/cgi-bin/Upload?toacct="+escape(m_chatAcct)+"&dFileNo="+dFileNo+"&myacct="+escape(m_myAcct)+"&type=0"; sf.filesend.action=send_url; sf.filesend.submit(); //pf.Start(); //document.frames['proframe'+dFileNo].location.href='http://www.google.com' //document.getElementById('progcon'+dFileNo).style.display = ""; //timer=window.setInterval("ShowProgress('"+dFileNo+"')",2000); } } //设置个人账号 function SetMyUserAcct(_userAcct){ OC_myUserAcct=_userAcct; if(OC_myUserName == "") OC_myUserName = OC_myUserAcct; if(1==1) getObj('OC__maintop').title=OC_myUserName +_LANG_WELCOME; //getObj('OC__title_list').innerHTML =OC_myUserName +_LANG_WELCOME+"
"; } //获取个人账号 function GetMyUserAcct(){ return OC_myUserAcct; } //获取个人姓名 function GetMyName() { return OC_myUserName; } //清空在线用户列表 function ClearList() { OC_userInfoList.length = 0; } //分组收缩或是显示 function ShowOrHide(id, imgid, hideimg, showimg) { if(document.getElementById(id).style.display=="") { //隐藏内容 document.getElementById(id).style.display = "none"; document.getElementById(imgid).src=hideimg; } else { document.getElementById(id).style.display = ""; document.getElementById(imgid).src=showimg; } } //判断是否全为下线 function ocAllOffline(){ var offtotal = 0; for(i=0;i= 1) //存在客服分组 { for(i=0;i"+OC_groupInfoList[i][0]+"
"; strDivHtml+="
"; for(j=0;j  "+OC_userInfoList[j][5]+"
"; } } for(j=0;j  "+OC_userInfoList[j][5]+"
"; } } strDivHtml+=""; } } else { for(i=0;i"+OC_userInfoList[i][5]+"
"; } } for(i=0;i"+OC_userInfoList[i][5]+"
"; } } } return strDivHtml; } //关闭客服列表 function HideMianList(){ getObj("OCWeb").style.display = 'none'; } //鼠标放下 function DivMouseDown(object,event){ event = event || window.event; OC_Obj=object.id; if(OC_isIEBrowser) { getObj(OC_Obj).setCapture(); //将方法添加至文档 OC_px=event.x-getObj(OC_Obj).style.pixelLeft; // 计算鼠标偏移 OC_py=event.y-getObj(OC_Obj).style.pixelTop; } else { getObj(OC_Obj).addEventListener("mousemove",DivMouseMove,true); OC_px=event.pageX-parseInt(getObj(OC_Obj).style.left,10); // 计算鼠标偏移 //pageX OC_py=event.pageY-parseInt(getObj(OC_Obj).style.top,10); // 计算鼠标偏移 //pageX } //window.status=OC_py; } var oc_event_x; var oc_event_y; //鼠标移动 function DivMouseMove(event){ event = event || window.event; if(OC_Obj!=''){ var event_x ; var event_y; if(OC_isIEBrowser) { event_x = event.x; event_y = event.y; } else { event_x = event.pageX; event_y = event.pageY; } if(oc_event_x == event_x && oc_event_y == event_y) return; oc_event_x = event_x; oc_event_y = event_y; if(event_x-OC_px >= document.documentElement.scrollWidth-getObj(OC_Obj).clientWidth) //在最右边 getObj(OC_Obj).style.left = document.documentElement.scrollWidth-getObj(OC_Obj).clientWidth+'px'; else getObj(OC_Obj).style.left =event_x-OC_px+'px'; if(event_x-OC_px < 0) //在最左边 getObj(OC_Obj).style.left=0+'px'; if(event_y-OC_py >=document.documentElement.scrollHeight-getObj(OC_Obj).clientHeight)//在最下面 getObj(OC_Obj).style.top = document.documentElement.scrollHeight-getObj(OC_Obj).clientHeight+'px'; else getObj(OC_Obj).style.top=event_y-OC_py+'px'; if(event_y -OC_py <= 0) //在最上面 getObj(OC_Obj).style.top = 0+'px'; } } //鼠标松开 function DivMouseUp(){ if(OC_Obj!='') { if(OC_isIEBrowser) document.all(OC_Obj).releaseCapture(); //将方法从文档删除 else document.removeEventListener("mousemove",DivMouseMove,true); OC_Obj=''; } } //鼠标离开 function DivMouseOut(){ if(OC_Obj!='') { if(OC_isIEBrowser) document.all(OC_Obj).releaseCapture(); //将方法从文档删除 else document.removeEventListener("mousemove",DivMouseMove,true); OC_Obj=''; } } //传递参数给新打开的窗体 function OpenWin(_user_acct){ var openObject=window.open(""+OC_BASEURL+"/WebOC/ChatNew.php?company_acct="+getCompanyAcct()+"&my_user_acct="+GetMyUserAcct()+"&my_user_name="+OC_myUserName+"&oc_user_acct="+_user_acct+"&oc_user_status="+GetUserStatus(_user_acct)+"&oc_user_name="+GetUserName(_user_acct)+"&oc_lang="+OC_myLang+"&oc_skin="+OC_mySkin,"","height=568,width=750,top=150,left=150,toolbar=no,menubar=no,scrollbars=no,location=no,status=no,resizable=yes"); } //"height=490,width=650,top=150,left=150,toolbar=no,menubar=no,scrollbars=no,location=no,status=no", //height=100 窗口高度; //width=400 窗口宽度; //top=0 窗口距离屏幕上方的象素值; //left=0 窗口距离屏幕左侧的象素值; //toolbar=no 是否显示工具栏,yes为显示; //menubar,scrollbars 表示菜单栏和滚动栏。 //resizable=no 是否允许改变窗口大小,yes为允许; //location=no 是否显示地址栏,yes为允许; //status=no 是否显示状态栏内的信息(通常是文件已经打开),yes为允许 //接收到客服人员的聊天请求 function RequestFormOC(_user_acct){ ocgetServper(_user_acct); } //接收到客服人员的强制聊天信息 WriteChatSocket(); function ForceFormOC(_user_acct){ ModifyWebUserAction(4); //强制通讯中 getSWF("mySocket").JConnectSocket(getCompanyAcct(),GetMyUserAcct(),_user_acct); m_chatAcct = _user_acct ; chatUserName = _user_acct; /* var openObject=window.open(""+OC_BASEURL+"/WebOC/ChatNew.php?company_acct="+getCompanyAcct()+"&my_user_acct="+GetMyUserAcct()+"&my_user_name="+OC_myUserName+"&oc_user_acct="+_user_acct+"&oc_user_status="+GetUserStatus(_user_acct)+"&oc_user_name="+GetUserName(_user_acct)+"&oc_lang="+OC_myLang+"&oc_skin="+OC_mySkin,"","height=468,width=550,top=150,left=150,toolbar=no,menubar=no,scrollbars=no,location=no,status=no"); if(openObject == null) { ChatTipLocate(); chatUserName = _user_acct; getObj("OC__title_chat_tip").innerHTML = _LANG_WEB_SERVICE+GetUserName(_user_acct)+_LANG_ASK_CHAT; getObj("OC__request_text").innerHTML=_LANG_CAN_YOU_AGREE+"("+GetUserName(_user_acct)+")"+_LANG_SOME_HELP+"?\n"+_LANG_AGREE_INFO; getObj("OC__chat_tip").style.visibility="visible"; focus(); }*/ } //登陆成功,发送字体格式 function OnChat() { bLogin = true; getSWF("mySocket").JSendFont(nBold,nItalic,nUnderline,nSize,strColor,strType); //发送字体格式 getObj("status").innerHTML = _LANG_CONNECT_OK; } //关闭聊天窗体清除session中的内容 function CloseChat(_user_acct){ var usrurl="/delChat.php?_useracct="+_user_acct+""; //var sta=getResponseText(usrurl); } //用户关闭聊天窗体 function DelOpenObject(_user_acct) { for(i=0;i10000) { //alert('关闭'); } else { //alert('刷新'); for(i=0;i
"+_LANG_CLICK_USERNAME+"
"+_LANG_CHAT_OR_LIVEWORD+"
"+_LANG_LOADING_WAITING+"
"; document.write(str); //document.write("
"+_LANG_USER_ASK_CHAT+"
"+_LANG_CAN_YOU_ACCEPT+"
"); document.write("
   
 
欢迎您,来自广东中山的客人
    在线人员 【技术支持 】请求与您进行对话,是否接受请求? 如果是接受请点击立即对话,如果暂时不允许,请点击稍后再说!
立即对话   稍后再说
"); document.write("
来自客服001的消息 [进入完整版]
回复:
"); document.write(""); var myversionInfo = detectDoctype(); if(myversionInfo) { if(myversionInfo.xhtml.toLowerCase()=="html"&&myversionInfo.version.toLowerCase()!="4.01") //104 document.write(""); }else{//104 document.write(""); document.write(""); } } function addEventHandler(target, type, func) { if (target.addEventListener) target.addEventListener(type, func, false); else if (target.attachEvent) target.attachEvent("on" + type, func); else target["on" + type] = func; } var advIniTop = 0; function move() { var layer1 = document.getElementById("OCWeb"); if (layer1) layer1.style.top = advIniTop + document.body.scrollTop || document.documentElement.scrollTop + "px"; } if(GetBase()=="") addEventHandler(window, "scroll", move); //随机选择客服 function RandSelService(){ count = 0; all = 0; useracct = ""; for(i=0;i0){ //在线用户大于0 randindex = Math.round(Math.random()*(count-1)); count = 0; for(i=0;i"); WriteSocket(); //document.write(""); document.onload = pageInit(); document.onunload = reLoadWeb(); window.onscroll=document.onscroll=ChatTipLocate; window.onresize=ChatTipLocate; } function ChatTipLocate() { getObj("OC__chat_tip_new").style.top=(document.documentElement.scrollTop+(document.documentElement.clientHeight-getObj("OC__chat_tip_new").offsetHeight)/2)+"px"; getObj("OC__chat_tip_new").style.left=(document.documentElement.scrollLeft+(document.documentElement.clientWidth-getObj("OC__chat_tip_new").offsetWidth)/2)+"px"; } function OpenChat() { ModifyWebUserAction(5); //正常通讯中 OpenWin(chatUserName); getObj("OC__chat_tip_new").style.visibility="hidden"; } function CloseChatTip() { ModifyWebUserAction(3); //拒绝通讯 getObj("OC__chat_tip_new").style.visibility="hidden"; } if(GetBase()=="" && getObj("OCWeb")==null) //验证是否已加载 LoadHtml(OC_mySkin); OC_servgroupNum = 1;if(GetBase()=="") AddGroupListWeb('客服组',0); _DataBase_Name error: Invalid SQL: select a.user_acct,a.user_nickname,a.user_sex,b.online_status,b.online_port,c.servgroup_main_id,d.servper_sms_flag from mag_user_2.1169 a left join mag_online b on a.user_acct=b.online_user_acct and b.online_port in (4400,4401,4402,4403,4404,4405,4406,4407,4408,4409,443) left join mag_servgroupdep c on c.user_acct=a.user_acct left join mag_servper d on d.user_acct=a.user_acct where a.company_acct='21169' and a.user_permession & 0x80 = 0x80 AND (IFNULL( b.online_port, -1 ) = -1 OR b.online_port in (4400,4401,4402,4403,4404,4405,4406,4407,4408,4409,443)) group by a.user_acct order by a.user_nickname asc, b.online_status desc
mysql error: 1142 (SELECT command denied to user 'im'@'WEB190' for table '1169')
Session halted.