{"Name":"Swirlhost.SwirlChat.Logs","ConfigurationID":"12596434-9932-801b-23a5-8567e068a2c5","searchItems":[],"queryItems":[],"listItems":[],"messageItems":[{"Index":1,"Level":0,"Parameters":{"Name":"OnRender","RenderType":"0","skipDebug":"False","includeSearch":"False"},"ActionType":"Action-Region","ChildActions":[{"Index":2,"Level":0,"Parameters":{"Type":"Query-Query","GroupStatement":"","GroupIndex":"","Value":"SELECT\n\trm.msg_id,\n\trm.msg_ts,\n\tISNULL(rm.ip_addr,'unkown') as ip_addr,\n\tISNULL(rm.msg_from_chat_userid, -1) as msg_from_chat_userid,\n\tISNULL(rm.msg_to_chat_userid, -1) as msg_to_chat_userid,\n\tISNULL(ru.nick, 'SYSTEM') as nick,\n\trm.msg_color,\n\trm.msg_text,\n\trm.msg_type\nFROM\n\tSWIRLCHAT_RoomMessage rm\n\tLEFT OUTER JOIN SWIRLCHAT_RoomUser ru\n\t\tON ru.chatuser_id=rm.msg_from_chat_userid\n\tand ru.room_id=rm.room_id\nWHERE\n\trm.room_id=1\n\tand rm.msg_ts between getdate()-7 and getdate()\nORDER BY\n\trm.msg_ts ASC","Connection":"","Filter":"","CacheTime":"","CacheName":"","CacheShared":"false"},"ActionType":"Template","ChildActions":[{"Index":3,"Level":0,"Parameters":{"Type":"Group-Header","GroupStatement":"","GroupIndex":"0","Value":"<style type=\"text/css\">\n\t.tblChatLog, .tblChatLog tr td {\n\t\tpadding: 3px;\n\t}\n</style>\n<table>\n<tr>\n\t<td>Start Date: <input type=\"text\" name=\"startDate\" id=\"startDate\" size=\"10\" /></td>\n\t<td>End Date: <input type=\"text\" name=\"endDate\" id=\"endDate\" size=\"10\" value=\"\" /></td>\n\t<td>Room: <select name=\"room\" id=\"room\">{SUBQUERY, Name=\"qryRooms\", Query=\"SELECT room_id, room_name, portal_id FROM SWIRLCHAT_PortalRoom ORDER BY portal_id, room_name\" , Header=\"\", Footer=\"\", NoResultFormat=\"\", NoQueryFormat=\"\", Format=\"<option value=\\\"[room_id]\\\">[room_name]</option>\", SelectedFormat=\"\", Value=\"\", SelectedField=\"\", SelectedItems=\"\", UseCache=\"false\"}</select></td>\n\t<td><a {ACTION,cmdGetLog,cmdGetLog,,Message}>Get Logs</a></td>\n</tr>\n<tr>\n\t<td><input type=\"checkbox\" name=\"showSystem\" id=\"showSystem\" value=\"true\" /> Show System Messages</td>\n\t<td></td>\n\t<td></td>\n\t<td></td>\n</tr>\n</table>\n<table class=\"tblChatLog\">\n<tr>\n\t<td style=\"border-bottom: 1px solid #000;\">Msg ID</td>\n\t<td style=\"border-bottom: 1px solid #000;\">Timestamp</td>\n\t<td style=\"border-bottom: 1px solid #000;\">IP Address</td>\n\t<!-- <td style=\"border-bottom: 1px solid #000;\">From User</td> -->\n\t<td style=\"border-bottom: 1px solid #000;\">To User</td>\n\t<td style=\"border-bottom: 1px solid #000;\">From User</td>\n\t<td style=\"border-bottom: 1px solid #000;\">Message</td>\n\t<!-- <td style=\"border-bottom: 1px solid #000;\">Message Type</td> -->\n</tr>","Connection":"","Filter":"","CacheTime":"","CacheName":"","CacheShared":"false"},"ActionType":"Template","ChildActions":[{"Index":4,"Level":0,"Parameters":{"Type":"Detail-Detail","GroupStatement":"","GroupIndex":"","Value":"<tr>\n\t<td>[msg_id]</td>\n\t<td>[msg_ts]</td>\n\t<td>[ip_addr]</td>\n\t<!-- <td>{IIF,\"'[msg_from_chat_userid]'='-1'\",\"System\",\"[msg_from_chat_userid]\"}</td> -->\n\t<td>{IIF,\"'[msg_to_chat_userid]'='-1'\",\"Room\",\"[msg_to_chat_userid]\"}</td>\n\t<td>[nick]</td>\n\t<td style=\"color:[msg_color];\">[msg_text]</td>\n\t<!-- <td>[msg_type]</td> -->\n</tr>","Connection":"","Filter":"","CacheTime":"","CacheName":"","CacheShared":"false"},"ActionType":"Template","ChildActions":[]},{"Index":5,"Level":0,"Parameters":{"Type":"Detail-Alternate","GroupStatement":"","GroupIndex":"","Value":"<tr style=\"background-color: #EFEFEF;\">\n\t<td>[msg_id]</td>\n\t<td>[msg_ts]</td>\n\t<td>[ip_addr]</td>\n\t<!-- <td>{IIF,\"'[msg_from_chat_userid]'='-1'\",\"System\",\"[msg_from_chat_userid]\"}</td> -->\n\t<td>{IIF,\"'[msg_to_chat_userid]'='-1'\",\"Room\",\"[msg_to_chat_userid]\"}</td>\n\t<td>[nick]</td>\n\t<td style=\"color:[msg_color];\">[msg_text]</td>\n\t<!-- <td>[msg_type]</td> -->\n</tr>","Connection":"","Filter":"","CacheTime":"","CacheName":"","CacheShared":"false"},"ActionType":"Template","ChildActions":[]}]},{"Index":6,"Level":0,"Parameters":{"Type":"Group-Footer","GroupStatement":"","GroupIndex":"0","Value":"</table>","Connection":"","Filter":"","CacheTime":"","CacheName":"","CacheShared":"false"},"ActionType":"Template","ChildActions":[]}]},{"Index":7,"Level":0,"Parameters":{"Type":"cmdGetLog","Value":"cmdGetLog"},"ActionType":"Message","ChildActions":[{"Index":8,"Level":0,"Parameters":{"Type":"Query-Query","GroupStatement":"","GroupIndex":"","Value":"SELECT\n\trm.msg_id,\n\trm.msg_ts,\n\tISNULL(rm.ip_addr,'unkown') as ip_addr,\n\tISNULL(rm.msg_from_chat_userid, -1) as msg_from_chat_userid,\n\tISNULL(rm.msg_to_chat_userid, -1) as msg_to_chat_userid,\n\tISNULL(ru.nick, 'SYSTEM') as nick,\n\trm.msg_color,\n\trm.msg_text,\n\trm.msg_type\nFROM\n\tSWIRLCHAT_RoomMessage rm\n\tLEFT OUTER JOIN SWIRLCHAT_RoomUser ru\n\t\tON ru.chatuser_id=rm.msg_from_chat_userid\n\tand ru.room_id=rm.room_id\nWHERE\n\trm.room_id=[room,Form]\n\tand rm.msg_ts between '[startDate,Form] 12:00AM' and '[endDate,Form] 11:59PM'\n\t{IIF,\"'[showSystem,Form]'='true'\",\"\",\"and ru.nick IS NOT NULL\"}\nORDER BY\n\trm.msg_ts ASC","Connection":"","Filter":"","CacheTime":"","CacheName":"","CacheShared":"false"},"ActionType":"Template","ChildActions":[{"Index":9,"Level":0,"Parameters":{"Type":"Group-Header","GroupStatement":"","GroupIndex":"0","Value":"<style type=\"text/css\">\n\t.tblChatLog, .tblChatLog tr td {\n\t\tpadding: 3px;\n\t}\n</style>\n<table>\n<tr>\n\t<td>Start Date: <input type=\"text\" name=\"startDate\" id=\"startDate\" size=\"10\" value=\"[startDate,Form]\" /></td>\n\t<td>End Date: <input type=\"text\" name=\"endDate\" id=\"endDate\" size=\"10\" value=\"[endDate,Form]\" /></td>\n\t<td>Room: <select name=\"room\" id=\"room\">{SUBQUERY, Name=\"qryRooms\", Query=\"SELECT room_id, room_name, portal_id FROM SWIRLCHAT_PortalRoom ORDER BY portal_id, room_name\" , Header=\"\", Footer=\"\", NoResultFormat=\"\", NoQueryFormat=\"\", Format=\"<option value=\\\"[room_id]\\\" \\{IIF,\\\"'[room,Form]'='[room_id]'\\\",\\\"selected=\\\\\"selected\\\\\"\\\",\\\"\\\"\\}>[room_name]</option>\", SelectedFormat=\"\", Value=\"\", SelectedField=\"\", SelectedItems=\"\", UseCache=\"false\"}</select></td>\n\t<td><a {ACTION,cmdGetLog,cmdGetLog,,Message}>Get Logs</a></td>\n</tr>\n<tr>\n\t<td><input type=\"checkbox\" name=\"showSystem\" id=\"showSystem\" value=\"true\" {IIF,\"'[showSystem,Form]'='true'\",\"checked\",\"\"} /> Show System Messages</td>\n\t<td></td>\n\t<td></td>\n\t<td></td>\n</tr>\n</table>\n<table class=\"tblChatLog\">\n<tr>\n\t<td style=\"border-bottom: 1px solid #000;\">Msg ID</td>\n\t<td style=\"border-bottom: 1px solid #000;\">Timestamp</td>\n\t<td style=\"border-bottom: 1px solid #000;\">IP Address</td>\n\t<!-- <td style=\"border-bottom: 1px solid #000;\">From User</td> -->\n\t<td style=\"border-bottom: 1px solid #000;\">To User</td>\n\t<td style=\"border-bottom: 1px solid #000;\">From User</td>\n\t<td style=\"border-bottom: 1px solid #000;\">Message</td>\n\t<!-- <td style=\"border-bottom: 1px solid #000;\">Message Type</td> -->\n</tr>","Connection":"","Filter":"","CacheTime":"","CacheName":"","CacheShared":"false"},"ActionType":"Template","ChildActions":[{"Index":10,"Level":0,"Parameters":{"Type":"Detail-Detail","GroupStatement":"","GroupIndex":"","Value":"<tr>\n\t<td>[msg_id]</td>\n\t<td>[msg_ts]</td>\n\t<td>[ip_addr]</td>\n\t<!-- <td>{IIF,\"'[msg_from_chat_userid]'='-1'\",\"System\",\"[msg_from_chat_userid]\"}</td> -->\n\t<td>{IIF,\"'[msg_to_chat_userid]'='-1'\",\"Room\",\"[msg_to_chat_userid]\"}</td>\n\t<td>[nick]</td>\n\t<td style=\"color:[msg_color];\">[msg_text]</td>\n\t<!-- <td>[msg_type]</td> -->\n</tr>","Connection":"","Filter":"","CacheTime":"","CacheName":"","CacheShared":"false"},"ActionType":"Template","ChildActions":[]},{"Index":11,"Level":0,"Parameters":{"Type":"Detail-Alternate","GroupStatement":"","GroupIndex":"","Value":"<tr style=\"background-color: #EFEFEF;\">\n\t<td>[msg_id]</td>\n\t<td>[msg_ts]</td>\n\t<td>[ip_addr]</td>\n\t<!-- <td>{IIF,\"'[msg_from_chat_userid]'='-1'\",\"System\",\"[msg_from_chat_userid]\"}</td> -->\n\t<td>{IIF,\"'[msg_to_chat_userid]'='-1'\",\"Room\",\"[msg_to_chat_userid]\"}</td>\n\t<td>[nick]</td>\n\t<td style=\"color:[msg_color];\">[msg_text]</td>\n\t<!-- <td>[msg_type]</td> -->\n</tr>","Connection":"","Filter":"","CacheTime":"","CacheName":"","CacheShared":"false"},"ActionType":"Template","ChildActions":[]}]},{"Index":12,"Level":0,"Parameters":{"Type":"Group-Footer","GroupStatement":"","GroupIndex":"0","Value":"</table>","Connection":"","Filter":"","CacheTime":"","CacheName":"","CacheShared":"false"},"ActionType":"Template","ChildActions":[]}]}]},{"Index":13,"Level":0,"Parameters":{"Type":"Detail-NoResults","GroupStatement":"","GroupIndex":"","Value":"<table>\n<tr>\n\t<td>Start Date: <input type=\"text\" name=\"startDate\" id=\"startDate\" size=\"10\" value=\"[startDate,Form]\" /></td>\n\t<td>End Date: <input type=\"text\" name=\"endDate\" id=\"endDate\" size=\"10\" value=\"[endDate,Form]\" /></td>\n\t<td>Room: <select name=\"room\" id=\"room\">{SUBQUERY, Name=\"qryRooms\", Query=\"SELECT room_id, room_name, portal_id FROM SWIRLCHAT_PortalRoom ORDER BY portal_id, room_name\" , Header=\"\", Footer=\"\", NoResultFormat=\"\", NoQueryFormat=\"\", Format=\"<option value=\\\"[room_id]\\\" \\{IIF,\\\"'[room,Form]'='[room_id]'\\\",\\\"selected=\\\\\"selected\\\\\"\\\",\\\"\\\"\\}>[room_name]</option>\", SelectedFormat=\"\", Value=\"\", SelectedField=\"\", SelectedItems=\"\", UseCache=\"false\"}</select></td>\n\t<td><a {ACTION,cmdGetLog,cmdGetLog,,Message}>Get Logs</a></td>\n</tr>\n<tr>\n\t<td><input type=\"checkbox\" name=\"showSystem\" id=\"showSystem\" value=\"true\" {IIF,\"'[showSystem,Form]'='true'\",\"checked\",\"\"} /> Show System Messages</td>\n\t<td></td>\n\t<td></td>\n\t<td></td>\n</tr>\n</table>","Connection":"","Filter":"","CacheTime":"","CacheName":"","CacheShared":"false"},"ActionType":"Template","ChildActions":[]}]}],"recordsPerPage":"0","enableAlphaFilter":"false","enablePageSelection":"false","enableRecordsPerPage":"false","enableCustomPaging":"false","enableExcelExport":false,"enableHide_OnNoQuery":false,"enableHide_OnNoResults":false,"enableAdvancedParsing":true,"enableCompoundIIFConditions":"true","enableQueryDebug":"false","enableQueryDebug_Edit":"false","enableQueryDebug_Admin":"false","enableQueryDebug_Super":"false","enableQueryDebug_Log":false,"enableQueryDebug_ErrorLog":false,"autoRefreshInterval":"","skipRedirectActions":"false","skipSubqueryDebugging":"false","enableAdmin_Edit":true,"enableAdmin_Admin":false,"enableAdmin_Super":false,"BotRecordCount":0,"BotPageVariableName":null,"enableBotShowAllRecords":false,"enableBotDetection":false,"BotNonAjaxText":null,"disableOpenScript":false,"enableSilverlight":false,"enableAJAX":"false","enableAJAXPaging":"false","enableAJAXCustomPaging":"false","enableAJAXCustomStatus":"false","enableAJAXPageHistory":"false","customAJAXPageHistory":"","enableAJAXManual":"false","includeJavascriptUtilities":"false","includeJavascriptValidation":"false","javascriptInclude":[],"javascriptOnComplete":"","enableMultipleColumnSorting":"false","ModuleCommunicationMessageType":"","showAll":"true","useExplicitSystemVariables":"false","enabledForcedQuerySplit":"false","query":"","filter":"","customConnection":"","listItem":"","listAItem":"","defaultItem":"","noqueryItem":"","SearchQuery":"","SearchTitle":"","SearchLink":"","SearchAuthor":"","SearchDate":"","SearchKey":"","SearchContent":"","SearchDescription":"","Header":null,"Footer":null,"Title":null,"Version":"20"}