Announcement

Collapse
No announcement yet.

Hstouch

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Hstouch

    Hello CFGUY,

    Hoping you might be able to give me a hand with getting one thing going, and i can use that as an example to get other screens etc going. Anyway i would like to format my HSTOUCH screen with a TV Guide so that it shows up, when i use the style=2 thing, the buttons still remain at the top of the page, so that is not the best way to get this going, but i was wondering if there is anyway i can use a script as a textbox value, so that i can set the channel, the time (now) in the script or textbox, and it shows the upcoming shows, ideally even something like a listbox would be perfect.

    I do have what is coming up next in a device string, but because it is html it does not format well at all in hstouch, ideally what id like to do is to just be able to have the time, and the title of the show coming up next on each channel, keeping as much space as possible free (since the size is 800 x 480).

    Thanks
    HS3 PRO, Win10, WeatherXML, HSTouch, Pushover, UltraGCIR, Heaps of Jon00 Plugins, Just sold and about to move so very slim system.

    Facebook | Twitter | Flickr | Google+ | Website | YouTube

  • #2
    When you say the buttons are still at the top, are you talking about the navigation buttons?
    If so, you can remove them by user. Go to the User Options page and select No for the Navigation Buttons on Top.

    Will that work for you?
    --
    Jeff Farmer
    HS 3, HSPhone
    My HS3 Plugins: CFHSExtras, Random, Restart, Tracker, WeatherXML, PanaBluRay
    Other Plugins In Use: APCUPSD, BLOnkyo, Device History, EasyTrigger, HSTouch Server, PHLocation2, Pushover, RFXCom, UltraGCIR3, UltraMon3, UltraPioneerAVR3, X10, Z-Wave

    Hardware: GoControl Irrigation Controler, Schlage Lever Lock, Schlage Deadbolt, Way2Call Hi-Phone, RFXCom RFXrec433 Receiver, WGL 800, TI-103, Z-Net, Pioneer 1120, Pioneer 1021, Pioneer LX302, Panasonic BDT-110, Panasonic BDT-210 x2

    Comment


    • #3
      That should work well for me, how do i go about removing the buttons so all that is showing is the grid?

      On a side note, i seem to be having some issues in regards to the favorites / record controls being triggered. I have set up the control item (in this case to do a speak, to everything) and picked a show to do a quick remind, i add the item under the speak control, and when i get to the event window it has the close button, and the event window is sort of collapsed.

      It does not appear to actually error up, just the favorite event is never actually triggered (but does appear in the favorites view)
      HS3 PRO, Win10, WeatherXML, HSTouch, Pushover, UltraGCIR, Heaps of Jon00 Plugins, Just sold and about to move so very slim system.

      Facebook | Twitter | Flickr | Google+ | Website | YouTube

      Comment


      • #4
        Hopefully this helps

        <table align="center" border="0" cellpadding="2" cellspacing="1" width="95%"><tbody><tr><td class="tableheader">Log date & time</td> <td class="tableheader">Log type</td> <td class="tableheader">Log data</td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 10:00:07 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Finished setting hstv devices </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 10:00:03 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Array Rows: 18, Cols: 1 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 10:00:03 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> SELECT channelID, channelDevCode FROM tvChannels WHERE Len(channelDevCode) > 0 ORDER BY channelDevCode </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 10:00:02 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Array Rows: 24, Cols: 1 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 10:00:01 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> SELECT OptionValue, OptionName FROM UserOptions WHERE UserID = 'Travis' AND OptionName IN ('intShowNameNum','intUseNickName','intDispShowLength','intS howYear','intShowRepeat','strShowAudio','strShowSubtles','st rShowRating','strShowEPNum','strShowCat','intShowVideo','int ShowActor','intShowGuest','intShowHost','intShowDirector','i ntShowProducer','intChanSortOrder', 'intHoursWide','intJumpWhen','intRepeatHours','intShowCatLeg end','intShowWeekDay','intShowGrid','tuneItem','gridChanSort Order') </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 10:00:01 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Array Rows: 29, Cols: 27 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 10:00:01 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> SELECT c.channelID, c.channelName, c.channelNickName, c.channelNumber, l.starttime, l.endtime, l.title, l.episode, l.episodenum, l.category, l.programyear, l.videoaspect, l.videocolor, l.starrating, l.ratingsystem, l.rating, l.ratingadvisory, l.subtitles, l.description, l.audio, l.actors, l.director, l.hosts, l.guests, l.producers, l.scheduledEvent, l.repeatshowing , c.channelDevCode FROM tvListings l, tvChannels c WHERE l.channelID = c.channelID AND c.viewHide = 0 AND ( (l.starttime < DateAdd('n',5,Now()) AND l.endtime > DateAdd('n',5,Now()) ) OR (l.starttime < DateAdd('n',35,Now()) AND l.endtime > DateAdd('n',35,Now()) ) ) AND Len(c.channelDevCode) > 0 ORDER BY c.channelDevCode, c.channelNickname, l.starttime </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 10:00:01 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Array Rows: -1, Cols: 1 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 10:00:00 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> SELECT c.channelDevCode, count(*) FROM tvchannels c WHERE c.channelDevCode IS NOT NULL GROUP BY c.channelDevCode HAVING count(*) > 1 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 10:00:00 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> Event </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Running script statement immediately: &hs.Plugin("hstv").setDeviceStrings() </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 10:00:00 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> Event </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Event Trigger "hstv Set Device Strings" </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:21 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Array Rows: -1, Cols: 0 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:21 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> SELECT isActive FROM scheduledFavs WHERE channelID = 'extra.free.au' AND starttime = #8/24/2012 9:40:00 AM# </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:21 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Array Rows: 0, Cols: 1 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:21 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> SELECT DeviceType, DeviceName FROM devices WHERE deviceID = 1 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:21 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> favid = 4 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:21 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Array Rows: -1, Cols: 9 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:21 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> SELECT top 1 c.channelID, c.channelNickName, c.channelName, c.channelNumber, s.starttime, l.endtime, l.title, l.episode, l.category, l.description FROM scheduledFavs s, tvListings l, tvChannels c WHERE s.starttime > Now() And s.channelID = l.channelID And s.starttime = l.starttime And l.channelID = c.channelID And s.isActive = 1 ORDER BY s.starttime </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:21 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Array Rows: -1, Cols: 0 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:21 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> SELECT isActive FROM scheduledFavs WHERE channelID = 'extra.free.au' AND starttime = #8/24/2012 9:40:00 AM# </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:21 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Array Rows: 0, Cols: 1 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:21 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> SELECT DeviceType, DeviceName FROM devices WHERE deviceID = (SELECT deviceID FROM userFavs WHERE favID = 4) </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:21 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> runSelectQueryAccess: SELECT favID FROM scheduledFavs WHERE starttime > GETDATE() AND favID = 4 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:21 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> SELECT favID FROM scheduledFavs WHERE starttime > GETDATE() AND favID = 4 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:21 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> UPDATE tvListings SET scheduledEvent = 3 WHERE channelID = 'extra.free.au' AND starttime = #8/24/2012 9:40:00 AM# </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:21 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> runAccessActionQuery: INSERT INTO scheduledFavs (channelID, starttime, favID, isActive, ranTime, inactiveReason, endTime) VALUES ('extra.free.au',#8/24/2012 9:40:00 AM#,4,1,NULL,NULL, #8/24/2012 10:20:00 AM#) </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:21 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> INSERT INTO scheduledFavs (channelID, starttime, favID, isActive, ranTime, inactiveReason, endTime) VALUES ('extra.free.au',#8/24/2012 9:40:00 AM#,4,1,NULL,NULL, #8/24/2012 10:20:00 AM#) </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:21 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Array Rows: 0, Cols: 0 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:21 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> SELECT endTime FROM tvListings WHERE channelID = 'extra.free.au' AND starttime = #8/24/2012 9:40:00 AM# </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:21 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Array Rows: 0, Cols: 0 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:21 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> SELECT maxTimes FROM devices WHERE deviceID = (SELECT deviceID FROM userFavs WHERE favID = 4) </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:21 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Array Rows: 0, Cols: 1 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:21 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> SELECT Count(s.scheduledID), Max(d.maxTimes) FROM scheduledFavs s, userFavs f, devices d WHERE s.favID=f.FavID AND f.deviceID=d.deviceID AND s.isActive=1 AND s.starttime = #8/24/2012 9:40:00 AM# AND f.deviceID = (SELECT deviceID FROM userFavs WHERE favID = 4) </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:21 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Array Rows: 0, Cols: 2 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:21 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> SELECT d.deviceType, d.deviceID, d.deviceName FROM userFavs f, devices d WHERE f.deviceID = d.deviceID AND f.favID = 4 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:21 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Array Rows: -1, Cols: 1 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:21 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> SELECT channelID, favID FROM scheduledFavs WHERE channelID = 'extra.free.au' AND starttime = #8/24/2012 9:40:00 AM# AND favID = 4 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:21 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Array Rows: 0, Cols: 1 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:21 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> SELECT top 1 c.channelID, l.starttime FROM tvListings l, tvChannels c, userChannels u WHERE l.channelID = c.channelID AND l.channelID = u.channelID AND u.isAllowed = 1 AND u.isSelected = 1 AND c.viewhide = 0 AND u.userID = 'Travis' AND l.starttime > Now() AND l.starttime < #8/31/2012 12:00:00 AM# AND DatePart('w',l.starttime) IN (6) AND c.channelID = 'extra.free.au' AND starttime = #8/24/2012 9:40:00 AM# AND l.title = 'Nicer Dicer Australia' ORDER BY l.starttime </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:21 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Array Rows: 0, Cols: 31 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:21 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> SELECT deviceID, title, channelID, starttime, repeattype, intSun, intMon, intTue, intWed, intThu, intFri, intSat, matchtype, priorityLevel, keywords, keymatch, notkeyword, notmatch, notmatchtitle, nottitle, creditstype, creditname, yeardir, yearmade, creditsmatch, episodetext, episodeMatch, episodeNotText, episodeNotMatch, isActive, userID, onlyNew FROM userFavs WHERE favID = 4 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:21 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Array Rows: 0, Cols: 1 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:21 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> SELECT max(favID), min(favID) FROM userFavs WHERE deviceID = 1 AND title = 'Nicer Dicer Australia' AND starttime = #8/24/2012 9:40:00 AM# AND repeattype = 0 AND matchtype = 3 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:21 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> INSERT INTO userFavs (deviceID, title, channelID, starttime, repeattype, intSun, intMon, intTue, intWed, intThu, intFri, intSat, matchtype, priorityLevel, keywords, keymatch, notkeyword, notmatch, notmatchtitle, nottitle, creditstype, creditname, yeardir, yearmade, creditsmatch, episodetext, episodeMatch, episodeNotText, episodeNotMatch, isActive, userID, onlyNew) VALUES (1, 'Nicer Dicer Australia', 'extra.free.au', #8/24/2012 9:40:00 AM#, 0, 0, 0, 0,0, 0, 1, 0, 3, 4, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, 1,'Travis',0) </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:21 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Favorite Inserted </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:21 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Priority: 4 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:21 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Array Rows: 0, Cols: 1 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:21 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> SELECT count(favID), count(priorityLevel) FROM userFavs WHERE deviceID = 1 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:21 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Array Rows: 0, Cols: 1 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:21 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> SELECT channelID, title FROM tvListings WHERE channelID = 'extra.free.au' AND starttime = #8/24/2012 9:40:00 AM# </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:21 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Insert Favorite </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:21 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> PagePut: name: remind.x = value:1 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:21 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> PagePut: name: evPageSpecific = value:8/24/2012 9:32:29 AM </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:21 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> PagePut: name: evPageFrom = value:listings </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:21 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> PagePut: name: evChannelID = value:extra.free.au </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:21 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> PagePut: name: evStartTime = value:8/24/2012 9:40:00 AM </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:21 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> PagePut: name: ref_page = value:hstv </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:21 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> PagePut: name: evRepeats = value:0 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:21 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> PagePut: name: quickevent = value:Create </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:21 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> PagePut: name: deviceid = value:1 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:09 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Array Rows: 0, Cols: 2 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:09 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> SELECT deviceID, deviceName, isDefault FROM devices WHERE isActive = 1 AND deviceType = 3 ORDER BY deviceName </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:09 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> PagePut: name: remind.y = value:6 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:09 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> PagePut: name: remind.x = value:4 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:09 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> PagePut: name: evPageSpecific = value:8/24/2012 9:32:29 AM </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:09 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> PagePut: name: evPageFrom = value:listings </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:09 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> PagePut: name: evChannelID = value:extra.free.au </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:09 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> PagePut: name: evStartTime = value:8/24/2012 9:40:00 AM </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:09 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> PagePut: name: pg = valuegeventadd </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:33:09 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> PagePut: name: ref_page = value:hstv </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:32:35 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Array Rows: 0, Cols: 0 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:32:35 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> SELECT UserID FROM userOptions WHERE OptionName = 'pgprivtvadmin' AND OptionValue = '1' </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:32:35 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> GenPage: name: pg = value: hstvtuner </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:32:29 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Array Rows: 156, Cols: 1 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:32:29 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> SELECT Distinct category, catID FROM tvcategory WHERE hideCategory = 0 ORDER BY category </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:32:29 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Array Rows: 71, Cols: 3 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:32:29 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> SELECT t.ratingID, t.rating, t.hideRating, u.IsAllowed FROM tvratings t, userratings u WHERE t.ratingID = u.ratingID AND u.UserID = 'Travis' </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:32:29 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Array Rows: 101, Cols: 30 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:32:29 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> SELECT t.starttime, t.endtime, c.channelNumber, u.SortOrder, c.channelName, u.userid, t.title, t.episode, t.description, t.category, t.episodenum, t.audio, t.subtitles, t.ratingsystem, t.rating, c.channelNickName, c.channelID, c.channelIcon, c.channelNumber, t.videoaspect, t.videocolor, t.starrating, t.actors, t.guests, t.director, t.producers, t.hosts, t.repeatshowing, t.programyear, t.scheduledEvent, t.ratingadvisory FROM userChannels u, tvlistings t, tvchannels c WHERE u.channelID = t.channelID AND t.channelID = c.channelID AND u.userid = 'Travis' AND u.IsSelected = 1 AND u.IsAllowed = 1 AND c.viewHide = 0 AND ( (t.starttime >= #2012/08/24 9:30:00# AND t.starttime <= #2012/08/24 12:29:00#) OR (t.endtime >= #2012/08/24 9:31:00# And t.endtime <= #2012/08/24 12:29:00#) OR (t.starttime < #2012/08/24 9:30:00# AND t.endtime > #2012/08/24 12:29:00#) ) ORDER BY u.SortOrder, t.channelID, t.starttime </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:32:29 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Array Rows: 17, Cols: 2 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:32:29 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> SELECT c.channelID, c.channelname, c.channelnickname FROM tvChannels c, userChannels u WHERE u.channelID = c.channelID AND u.userID = 'Travis' AND u.IsSelected = 1 AND u.IsAllowed = 1 AND c.channelID IN (SELECT DISTINCT channelID FROM tvlistings) ORDER BY u.sortorder, c.channelname </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:32:29 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Array Rows: 24, Cols: 1 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:32:29 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> SELECT OptionValue, OptionName FROM UserOptions WHERE UserID = 'Travis' AND OptionName IN ('intShowNameNum','intUseNickName','intDispShowLength','intS howYear','intShowRepeat','strShowAudio','strShowSubtles','st rShowRating','strShowEPNum','strShowCat','intShowVideo','int ShowActor','intShowGuest','intShowHost','intShowDirector','i ntShowProducer','intChanSortOrder', 'intHoursWide','intJumpWhen','intRepeatHours','intShowCatLeg end','intShowWeekDay','intShowGrid','tuneItem','gridChanSort Order') </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:32:29 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Array Rows: 0, Cols: 0 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:32:29 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> SELECT UserID FROM userOptions WHERE OptionName = 'pgprivtvadmin' AND OptionValue = '1' </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:32:29 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Array Rows: 0, Cols: 1 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:32:29 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> SELECT optionValue, optionName FROM userOptions WHERE optionName = 'userStartPage' AND userID = 'Travis' </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:30:04 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Finished setting hstv devices </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:30:03 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Array Rows: 18, Cols: 1 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:30:03 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> SELECT channelID, channelDevCode FROM tvChannels WHERE Len(channelDevCode) > 0 ORDER BY channelDevCode </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:30:01 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Array Rows: 24, Cols: 1 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:30:01 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> SELECT OptionValue, OptionName FROM UserOptions WHERE UserID = 'Travis' AND OptionName IN ('intShowNameNum','intUseNickName','intDispShowLength','intS howYear','intShowRepeat','strShowAudio','strShowSubtles','st rShowRating','strShowEPNum','strShowCat','intShowVideo','int ShowActor','intShowGuest','intShowHost','intShowDirector','i ntShowProducer','intChanSortOrder', 'intHoursWide','intJumpWhen','intRepeatHours','intShowCatLeg end','intShowWeekDay','intShowGrid','tuneItem','gridChanSort Order') </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:30:01 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Array Rows: 31, Cols: 27 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:30:00 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> SELECT c.channelID, c.channelName, c.channelNickName, c.channelNumber, l.starttime, l.endtime, l.title, l.episode, l.episodenum, l.category, l.programyear, l.videoaspect, l.videocolor, l.starrating, l.ratingsystem, l.rating, l.ratingadvisory, l.subtitles, l.description, l.audio, l.actors, l.director, l.hosts, l.guests, l.producers, l.scheduledEvent, l.repeatshowing , c.channelDevCode FROM tvListings l, tvChannels c WHERE l.channelID = c.channelID AND c.viewHide = 0 AND ( (l.starttime < DateAdd('n',5,Now()) AND l.endtime > DateAdd('n',5,Now()) ) OR (l.starttime < DateAdd('n',35,Now()) AND l.endtime > DateAdd('n',35,Now()) ) ) AND Len(c.channelDevCode) > 0 ORDER BY c.channelDevCode, c.channelNickname, l.starttime </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:30:00 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Array Rows: -1, Cols: 1 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:30:00 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> SELECT c.channelDevCode, count(*) FROM tvchannels c WHERE c.channelDevCode IS NOT NULL GROUP BY c.channelDevCode HAVING count(*) > 1 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:30:00 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> Event </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Running script statement immediately: &hs.Plugin("hstv").setDeviceStrings() </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:30:00 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> Event </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Event Trigger "hstv Set Device Strings" </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:51 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Array Rows: -1, Cols: 0 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:51 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> SELECT isActive FROM scheduledFavs WHERE channelID = 'channel31.free.au' AND starttime = #8/24/2012 9:30:00 AM# </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:51 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Array Rows: 0, Cols: 1 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:51 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> SELECT DeviceType, DeviceName FROM devices WHERE deviceID = 1 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:51 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> favid = 3 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:51 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Array Rows: -1, Cols: 9 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:51 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> SELECT top 1 c.channelID, c.channelNickName, c.channelName, c.channelNumber, s.starttime, l.endtime, l.title, l.episode, l.category, l.description FROM scheduledFavs s, tvListings l, tvChannels c WHERE s.starttime > Now() And s.channelID = l.channelID And s.starttime = l.starttime And l.channelID = c.channelID And s.isActive = 1 ORDER BY s.starttime </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:51 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Array Rows: -1, Cols: 0 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:51 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> SELECT isActive FROM scheduledFavs WHERE channelID = 'channel31.free.au' AND starttime = #8/24/2012 9:30:00 AM# </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:51 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Array Rows: 0, Cols: 1 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:51 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> SELECT DeviceType, DeviceName FROM devices WHERE deviceID = (SELECT deviceID FROM userFavs WHERE favID = 3) </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:51 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> runSelectQueryAccess: SELECT favID FROM scheduledFavs WHERE starttime > GETDATE() AND favID = 3 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:51 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> SELECT favID FROM scheduledFavs WHERE starttime > GETDATE() AND favID = 3 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:51 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> UPDATE tvListings SET scheduledEvent = 3 WHERE channelID = 'channel31.free.au' AND starttime = #8/24/2012 9:30:00 AM# </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:51 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> runAccessActionQuery: INSERT INTO scheduledFavs (channelID, starttime, favID, isActive, ranTime, inactiveReason, endTime) VALUES ('channel31.free.au',#8/24/2012 9:30:00 AM#,3,1,NULL,NULL, #8/24/2012 10:00:00 AM#) </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:51 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> INSERT INTO scheduledFavs (channelID, starttime, favID, isActive, ranTime, inactiveReason, endTime) VALUES ('channel31.free.au',#8/24/2012 9:30:00 AM#,3,1,NULL,NULL, #8/24/2012 10:00:00 AM#) </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:51 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Array Rows: 0, Cols: 0 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:51 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> SELECT endTime FROM tvListings WHERE channelID = 'channel31.free.au' AND starttime = #8/24/2012 9:30:00 AM# </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:51 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Array Rows: 0, Cols: 0 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:51 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> SELECT maxTimes FROM devices WHERE deviceID = (SELECT deviceID FROM userFavs WHERE favID = 3) </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:51 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Array Rows: 0, Cols: 1 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:51 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> SELECT Count(s.scheduledID), Max(d.maxTimes) FROM scheduledFavs s, userFavs f, devices d WHERE s.favID=f.FavID AND f.deviceID=d.deviceID AND s.isActive=1 AND s.starttime = #8/24/2012 9:30:00 AM# AND f.deviceID = (SELECT deviceID FROM userFavs WHERE favID = 3) </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:51 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Array Rows: 0, Cols: 2 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:51 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> SELECT d.deviceType, d.deviceID, d.deviceName FROM userFavs f, devices d WHERE f.deviceID = d.deviceID AND f.favID = 3 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:51 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Array Rows: -1, Cols: 1 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:51 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> SELECT channelID, favID FROM scheduledFavs WHERE channelID = 'channel31.free.au' AND starttime = #8/24/2012 9:30:00 AM# AND favID = 3 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:51 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Array Rows: 0, Cols: 1 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:51 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> SELECT top 1 c.channelID, l.starttime FROM tvListings l, tvChannels c, userChannels u WHERE l.channelID = c.channelID AND l.channelID = u.channelID AND u.isAllowed = 1 AND u.isSelected = 1 AND c.viewhide = 0 AND u.userID = 'Travis' AND l.starttime > Now() AND l.starttime < #8/31/2012 12:00:00 AM# AND DatePart('w',l.starttime) IN (6) AND c.channelID = 'channel31.free.au' AND starttime = #8/24/2012 9:30:00 AM# AND l.title = 'In Good Shape' ORDER BY l.starttime </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:51 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Array Rows: 0, Cols: 31 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:51 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> SELECT deviceID, title, channelID, starttime, repeattype, intSun, intMon, intTue, intWed, intThu, intFri, intSat, matchtype, priorityLevel, keywords, keymatch, notkeyword, notmatch, notmatchtitle, nottitle, creditstype, creditname, yeardir, yearmade, creditsmatch, episodetext, episodeMatch, episodeNotText, episodeNotMatch, isActive, userID, onlyNew FROM userFavs WHERE favID = 3 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:51 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Array Rows: 0, Cols: 1 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:51 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> SELECT max(favID), min(favID) FROM userFavs WHERE deviceID = 1 AND title = 'In Good Shape' AND starttime = #8/24/2012 9:30:00 AM# AND repeattype = 0 AND matchtype = 3 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:51 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> INSERT INTO userFavs (deviceID, title, channelID, starttime, repeattype, intSun, intMon, intTue, intWed, intThu, intFri, intSat, matchtype, priorityLevel, keywords, keymatch, notkeyword, notmatch, notmatchtitle, nottitle, creditstype, creditname, yeardir, yearmade, creditsmatch, episodetext, episodeMatch, episodeNotText, episodeNotMatch, isActive, userID, onlyNew) VALUES (1, 'In Good Shape', 'channel31.free.au', #8/24/2012 9:30:00 AM#, 0, 0, 0, 0,0, 0, 1, 0, 3, 3, NULL, 0, NULL, 0, NULL, NULL, 0, NULL, 0, NULL, 0, NULL, 0, NULL, 0, 1,'Travis',0) </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:51 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Favorite Inserted </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:51 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Priority: 3 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:51 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Array Rows: 0, Cols: 1 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:51 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> SELECT count(favID), count(priorityLevel) FROM userFavs WHERE deviceID = 1 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:51 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Array Rows: 0, Cols: 1 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:51 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> SELECT channelID, title FROM tvListings WHERE channelID = 'channel31.free.au' AND starttime = #8/24/2012 9:30:00 AM# </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:51 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Insert Favorite </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:51 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> PagePut: name: remind.x = value:1 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:51 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> PagePut: name: evPageSpecific = value:8/24/2012 9:22:31 AM </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:51 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> PagePut: name: evPageFrom = value:listings </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:51 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> PagePut: name: evChannelID = value:channel31.free.au </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:51 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> PagePut: name: evStartTime = value:8/24/2012 9:30:00 AM </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:51 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> PagePut: name: ref_page = value:hstv </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:51 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> PagePut: name: evRepeats = value:0 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:51 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> PagePut: name: quickevent = value:Create </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:51 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> PagePut: name: deviceid = value:1 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:45 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Array Rows: 0, Cols: 2 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:45 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> SELECT deviceID, deviceName, isDefault FROM devices WHERE isActive = 1 AND deviceType = 3 ORDER BY deviceName </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:45 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> PagePut: name: remind.y = value:5 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:45 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> PagePut: name: remind.x = value:3 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:45 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> PagePut: name: evPageSpecific = value:8/24/2012 9:22:31 AM </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:45 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> PagePut: name: evPageFrom = value:listings </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:45 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> PagePut: name: evChannelID = value:channel31.free.au </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:45 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> PagePut: name: evStartTime = value:8/24/2012 9:30:00 AM </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:45 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> PagePut: name: pg = valuegeventadd </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:45 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> PagePut: name: ref_page = value:hstv </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:36 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> Array Rows: 0, Cols: 0 </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:36 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> SELECT UserID FROM userOptions WHERE OptionName = 'pgprivtvadmin' AND OptionValue = '1' </td> </tr><tr> <td style="text-align: center; white-space: nowrap;" class="tableroweven"> 8/24/2012 9:22:36 AM </td> <td style="text-align: center; white-space: nowrap;" class="tablerowodd"> hstv </td> <td style="text-align: left; width: 100%;" class="tableroweven"> GenPage: name: pg = value: hstvtuner </td></tr></tbody></table>
        HS3 PRO, Win10, WeatherXML, HSTouch, Pushover, UltraGCIR, Heaps of Jon00 Plugins, Just sold and about to move so very slim system.

        Facebook | Twitter | Flickr | Google+ | Website | YouTube

        Comment


        • #5
          Sorry should have clarified with the headers as well, the Style and the remove headers from top and bottom made a huge difference, but also is there any way to be able to call a link that doesn't show any of the homeseer headers etc in the page as well, basically the link would just be the TV Listing for example, so i could embed that in a table and just see the TV listings on a touchscreen


          Thanks for all your help!
          HS3 PRO, Win10, WeatherXML, HSTouch, Pushover, UltraGCIR, Heaps of Jon00 Plugins, Just sold and about to move so very slim system.

          Facebook | Twitter | Flickr | Google+ | Website | YouTube

          Comment


          • #6
            I am interested in trying this out. Is there a download link?

            Comment


            • #7
              Originally posted by jayman13 View Post
              I am interested in trying this out. Is there a download link?

              I edited this post to have the link:
              http://forums.homeseer.com/showthread.php?t=123533
              --
              Jeff Farmer
              HS 3, HSPhone
              My HS3 Plugins: CFHSExtras, Random, Restart, Tracker, WeatherXML, PanaBluRay
              Other Plugins In Use: APCUPSD, BLOnkyo, Device History, EasyTrigger, HSTouch Server, PHLocation2, Pushover, RFXCom, UltraGCIR3, UltraMon3, UltraPioneerAVR3, X10, Z-Wave

              Hardware: GoControl Irrigation Controler, Schlage Lever Lock, Schlage Deadbolt, Way2Call Hi-Phone, RFXCom RFXrec433 Receiver, WGL 800, TI-103, Z-Net, Pioneer 1120, Pioneer 1021, Pioneer LX302, Panasonic BDT-110, Panasonic BDT-210 x2

              Comment


              • #8
                Originally posted by CFGuy View Post
                I edited this post to have the link:
                http://forums.homeseer.com/showthread.php?t=123533
                Thanks! Will give it a whirl.

                Comment


                • #9
                  I thought I had set up everything correctly but when I click on the TV listings tab I get this

                  "This user has not been given permission to any show ratings. The listings can not be displayed until an admin assigns allowed ratings for default "

                  I've picked one of the ratings as default. Do you know what I'm doing wrong?

                  Comment


                  • #10
                    The default one is just for the import, in case a show is missing the rating tag. I need to change the warning message.

                    To assign which ratings a user is allowed to see, start by clicking on TV Admin, then Users. Click the radio button in front of one of the users, then click the Edit button. You will get a new row of navigation buttons. Click the one labeled Ratings. Select the ratings that you want the user to be able to see. Any that you set to Block will cause the program to be blacked out in the listings.
                    --
                    Jeff Farmer
                    HS 3, HSPhone
                    My HS3 Plugins: CFHSExtras, Random, Restart, Tracker, WeatherXML, PanaBluRay
                    Other Plugins In Use: APCUPSD, BLOnkyo, Device History, EasyTrigger, HSTouch Server, PHLocation2, Pushover, RFXCom, UltraGCIR3, UltraMon3, UltraPioneerAVR3, X10, Z-Wave

                    Hardware: GoControl Irrigation Controler, Schlage Lever Lock, Schlage Deadbolt, Way2Call Hi-Phone, RFXCom RFXrec433 Receiver, WGL 800, TI-103, Z-Net, Pioneer 1120, Pioneer 1021, Pioneer LX302, Panasonic BDT-110, Panasonic BDT-210 x2

                    Comment


                    • #11
                      thanks. I'm now getting a drop down under TV listings. But below it says that there are no listings available at this time. I know I downloaded them all as it did take awhile when I used the setup wizard.

                      Comment


                      • #12
                        HSTV was designed to be for multi users. I had 3 small kids when I originally wrote it. To get channels go to the page where you setup ratings. Click the button next to marked channels. You should get a list of all the channels. Select the channels you want the user to be allowed to see. If you want all of them, then click the button Select All. Scroll down and click Save.
                        This is the admin area where any HS admin user can control which channels the individual users can see.

                        After the admin has selected the channels the user then needs to click on the button Ch Selector which is next to the HSTV Admin button. Under the Column labeled Select: Web you click the checkbox for the channels to use.
                        This is the user area and the only channels they can choose from are the ones you as the admin assigned them in the admin area.

                        Each user that you have setup in HS will be able to select the channels they want.
                        --
                        Jeff Farmer
                        HS 3, HSPhone
                        My HS3 Plugins: CFHSExtras, Random, Restart, Tracker, WeatherXML, PanaBluRay
                        Other Plugins In Use: APCUPSD, BLOnkyo, Device History, EasyTrigger, HSTouch Server, PHLocation2, Pushover, RFXCom, UltraGCIR3, UltraMon3, UltraPioneerAVR3, X10, Z-Wave

                        Hardware: GoControl Irrigation Controler, Schlage Lever Lock, Schlage Deadbolt, Way2Call Hi-Phone, RFXCom RFXrec433 Receiver, WGL 800, TI-103, Z-Net, Pioneer 1120, Pioneer 1021, Pioneer LX302, Panasonic BDT-110, Panasonic BDT-210 x2

                        Comment


                        • #13
                          I am slowly moving forward in getting this set up for my hstouch system, thereby hopefully increasing the WAF, and allowing me to get even more automation stuff

                          I have turned off the hstv menu bar, and the category legend stuff so that part is working fine, however I am unsure of how to turn off the homeseer web server menu bar, so that only the tv listing grid is showing, but none of the homeseer server status, events, control etc headers.

                          Id appreciate any thoughts you might have as to how best to achieve this, so i can just have the listings table embedded in a hstouch textbox (html).

                          Thanks

                          (Marked the section i don't want to show in the attached picture in red)
                          Attached Files
                          HS3 PRO, Win10, WeatherXML, HSTouch, Pushover, UltraGCIR, Heaps of Jon00 Plugins, Just sold and about to move so very slim system.

                          Facebook | Twitter | Flickr | Google+ | Website | YouTube

                          Comment


                          • #14
                            I still can't get mine working. No grid and the tv listings page isn't working. Here is what I get in the log:

                            8/31/2012 6:09:06 AM HSTV Error Page Access: Object variable or With block variable not set.
                            8/31/2012 6:09:06 AM HSTV HSTV has finished setting up user access.
                            8/31/2012 6:09:06 AM HSTV runSelectQueryAccess: SELECT UserID FROM userOptions WHERE OptionName = 'pgprivtvadmin' AND OptionValue = '1'
                            8/31/2012 6:09:06 AM Debug Unrecognized database format 'C:\Program Files (x86)\HomeSeer HS2\data\hstv\hstv.mdb'.
                            8/31/2012 6:09:06 AM HSTV runSelectQueryAccess: SELECT UserID FROM userOptions WHERE OptionName = 'pgprivtvadmin' AND UserID = 'default'
                            8/31/2012 6:09:06 AM Debug Unrecognized database format 'C:\Program Files (x86)\HomeSeer HS2\data\hstv\hstv.mdb'.
                            8/31/2012 6:09:06 AM HSTV runAccessActionQuery: INSERT INTO userOptions (userID, optionName, optionValue) VALUES ('default','pgprivtvadmin','1')
                            8/31/2012 6:09:06 AM Debug Unrecognized database format 'C:\Program Files (x86)\HomeSeer HS2\data\hstv\hstv.mdb'.
                            8/31/2012 6:09:06 AM HSTV runAccessActionQuery: INSERT INTO userOptions (userID, optionName, optionValue) VALUES ('default','pgprivuseroptions','1')
                            8/31/2012 6:09:06 AM Debug Unrecognized database format 'C:\Program Files (x86)\HomeSeer HS2\data\hstv\hstv.mdb'.
                            8/31/2012 6:09:06 AM HSTV runSelectQueryAccess: SELECT optionName, optionValue FROM userOptions WHERE userID = 'default' AND optionName IN ('pgprivtvadmin','pgprivcategorylist','pgprivchselector','pg privevents','pgprivscheduled','pgprivsearch','pgprivtvdispla y','pgprivtvlistings','pgprivuseroptions','pgprivwapppc','in tAllowRecord','intAllowRemind','intAllowWatch')
                            8/31/2012 6:09:06 AM Debug Unrecognized database format 'C:\Program Files (x86)\HomeSeer HS2\data\hstv\hstv.mdb'.
                            8/31/2012 6:09:06 AM HSTV runSelectQueryAccess: SELECT COUNT(favID) FROM userFavs
                            8/31/2012 6:09:06 AM Debug Unrecognized database format 'C:\Program Files (x86)\HomeSeer HS2\data\hstv\hstv.mdb'.
                            8/31/2012 6:09:06 AM HSTV Error Page Access: Object variable or With block variable not set.
                            8/31/2012 6:09:06 AM HSTV HSTV has finished setting up user access.
                            8/31/2012 6:09:07 AM HSTV runSelectQueryAccess: SELECT UserID FROM userOptions WHERE OptionName = 'pgprivtvadmin' AND OptionValue = '1'
                            8/31/2012 6:09:07 AM Debug Unrecognized database format 'C:\Program Files (x86)\HomeSeer HS2\data\hstv\hstv.mdb'.
                            8/31/2012 6:09:07 AM HSTV runSelectQueryAccess: SELECT UserID FROM userOptions WHERE OptionName = 'pgprivtvadmin' AND UserID = 'default'
                            8/31/2012 6:09:07 AM Debug Unrecognized database format 'C:\Program Files (x86)\HomeSeer HS2\data\hstv\hstv.mdb'.
                            8/31/2012 6:09:07 AM HSTV runAccessActionQuery: INSERT INTO userOptions (userID, optionName, optionValue) VALUES ('default','pgprivtvadmin','1')
                            8/31/2012 6:09:07 AM Debug Unrecognized database format 'C:\Program Files (x86)\HomeSeer HS2\data\hstv\hstv.mdb'.
                            8/31/2012 6:09:07 AM HSTV runAccessActionQuery: INSERT INTO userOptions (userID, optionName, optionValue) VALUES ('default','pgprivuseroptions','1')
                            8/31/2012 6:09:07 AM Debug Unrecognized database format 'C:\Program Files (x86)\HomeSeer HS2\data\hstv\hstv.mdb'.
                            8/31/2012 6:09:07 AM HSTV runSelectQueryAccess: SELECT optionName, optionValue FROM userOptions WHERE userID = 'default' AND optionName IN ('pgprivtvadmin','pgprivcategorylist','pgprivchselector','pg privevents','pgprivscheduled','pgprivsearch','pgprivtvdispla y','pgprivtvlistings','pgprivuseroptions','pgprivwapppc','in tAllowRecord','intAllowRemind','intAllowWatch')
                            8/31/2012 6:09:07 AM Debug Unrecognized database format 'C:\Program Files (x86)\HomeSeer HS2\data\hstv\hstv.mdb'.
                            8/31/2012 6:09:07 AM HSTV runSelectQueryAccess: SELECT COUNT(favID) FROM userFavs
                            8/31/2012 6:09:07 AM Debug Unrecognized database format 'C:\Program Files (x86)\HomeSeer HS2\data\hstv\hstv.mdb'.
                            8/31/2012 6:09:07 AM HSTV Error Page Access: Object variable or With block variable not set.
                            8/31/2012 6:09:07 AM HSTV HSTV has finished setting up user access.

                            Comment


                            • #15
                              Check on the General Options and make sure you have Access selected as the Database Type. Also post or email your Connection String which is right below the Database type.

                              I have to run some errands this morning but when I get back I have the rest of the day to help.
                              --
                              Jeff Farmer
                              HS 3, HSPhone
                              My HS3 Plugins: CFHSExtras, Random, Restart, Tracker, WeatherXML, PanaBluRay
                              Other Plugins In Use: APCUPSD, BLOnkyo, Device History, EasyTrigger, HSTouch Server, PHLocation2, Pushover, RFXCom, UltraGCIR3, UltraMon3, UltraPioneerAVR3, X10, Z-Wave

                              Hardware: GoControl Irrigation Controler, Schlage Lever Lock, Schlage Deadbolt, Way2Call Hi-Phone, RFXCom RFXrec433 Receiver, WGL 800, TI-103, Z-Net, Pioneer 1120, Pioneer 1021, Pioneer LX302, Panasonic BDT-110, Panasonic BDT-210 x2

                              Comment

                              Working...
                              X