private static void categoryHasItemsEvent(ArrayList items, string keyword) { ArrayList newItems = updateDatabaseTable(items, keyword); DAL.Select q = new DAL.Select("channel_name"); q.addJoin("channelwatchers", DAL.Select.JoinTypes.Inner, new DAL.WhereConds(false, "watcher_id", "=", false, "cw_watcher")); q.addJoin("channel", DAL.Select.JoinTypes.Inner, new DAL.WhereConds(false, "channel_id", "=", false, "cw_channel")); q.setFrom("watcher"); q.addWhere(new DAL.WhereConds("watcher_keyword", keyword)); q.addLimit(10, 0); ArrayList channels = DAL.singleton().executeSelect(q); foreach (object[] item in channels) { string channel = (string)item[0]; string message = compileMessage(items, keyword, channel, false); if (Configuration.singleton()["silence", channel] == "false") { Helpmebot6.irc.ircPrivmsg(channel, message); } } if (newItems.Count > 0) { var message = compileMessage(newItems, keyword, ">TWITTER<", false); new Twitter().updateStatus(message); } }
/// <summary> /// Determines whether [is watcher in channel] [the specified channel]. /// </summary> /// <param name="channel">The channel.</param> /// <param name="keyword">The keyword.</param> /// <returns> /// <c>true</c> if [is watcher in channel] [the specified channel]; otherwise, <c>false</c>. /// </returns> public bool isWatcherInChannel(string channel, string keyword) { DAL.Select q = new DAL.Select("COUNT(*)"); q.setFrom("channelwatchers"); q.addWhere(new DAL.WhereConds("channel_name", channel)); q.addWhere(new DAL.WhereConds("watcher_keyword", keyword)); q.addJoin("channel", DAL.Select.JoinTypes.Inner, new DAL.WhereConds(false, "cw_channel", "=", false, "channel_id")); q.addJoin("watcher", DAL.Select.JoinTypes.Inner, new DAL.WhereConds(false, "cw_watcher", "=", false, "watcher_id")); string count = DAL.singleton().executeScalarSelect(q); if (count == "0") { return(false); } return(true); }
private static void categoryHasItemsEvent(ArrayList items, string keyword) { ArrayList newItems = updateDatabaseTable(items, keyword); DAL.Select q = new DAL.Select("channel_name"); q.addJoin("channelwatchers", DAL.Select.JoinTypes.Inner, new DAL.WhereConds(false, "watcher_id", "=", false, "cw_watcher")); q.addJoin("channel", DAL.Select.JoinTypes.Inner, new DAL.WhereConds(false, "channel_id", "=", false, "cw_channel")); q.setFrom("watcher"); q.addWhere(new DAL.WhereConds("watcher_keyword", keyword)); q.addLimit(10, 0); ArrayList channels = DAL.singleton().executeSelect(q); foreach (object[] item in channels) { string channel = (string) item[0]; string message = compileMessage(items, keyword, channel, false); if (Configuration.singleton()["silence",channel] == "false") Helpmebot6.irc.ircPrivmsg(channel, message); } if (newItems.Count > 0) new Twitter( ).updateStatus(compileMessage(newItems, keyword, ">TWITTER<", false)); }
/// <summary> /// Determines whether [is watcher in channel] [the specified channel]. /// </summary> /// <param name="channel">The channel.</param> /// <param name="keyword">The keyword.</param> /// <returns> /// <c>true</c> if [is watcher in channel] [the specified channel]; otherwise, <c>false</c>. /// </returns> public bool isWatcherInChannel(string channel, string keyword) { DAL.Select q = new DAL.Select("COUNT(*)"); q.setFrom("channelwatchers"); q.addWhere(new DAL.WhereConds("channel_name", channel)); q.addWhere(new DAL.WhereConds("watcher_keyword", keyword)); q.addJoin("channel", DAL.Select.JoinTypes.Inner, new DAL.WhereConds(false, "cw_channel", "=", false, "channel_id")); q.addJoin("watcher", DAL.Select.JoinTypes.Inner, new DAL.WhereConds(false, "cw_watcher", "=", false, "watcher_id")); string count = DAL.singleton().executeScalarSelect(q); if (count == "0") return false; return true; }