Reply to thread

Message

<blockquote data-quote="Lehmden" data-source="post: 1129730" data-attributes="member: 109222">Hi.Looks great.<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite24" alt="(y)" title="Thumbs Up&nbsp; &nbsp; (y)" loading="lazy" data-shortname="(y)" />Especially the new &quot;watched&quot; logo is something I like to see. Don't know if it can be done in xaml but I would love to have a &quot;Traffic Light&quot; system for series and seasons. Red means no episodes watched and yellow means some, but not all episodes watched. Green could be for all episodes watched, but it can be left out completely, to be consistent, no problem...&nbsp; This information definitely is available in the DB and it is usable with a&nbsp; DB query. I did this in MP2-Edit so I'm sure it's working 100% reliable. But I don't know if this can be shown that easy in skin here... I really need this as this is one of the things I'm missing from MP1 the most...If someone want to have a look, here is the code I use to achieve this in MP2-Edit:[code]&nbsp; &nbsp; &nbsp; &nbsp; $query = 'SELECT PLAYCOUNT FROM M_MEDIAITEM INNER JOIN M_SERIESITEM ON M_MEDIAITEM.MEDIA_ITEM_ID = M_SERIESITEM.MEDIA_ITEM_ID Where M_SERIESITEM.SERIESNAME = &quot;' &amp; $series &amp; '&quot; ;' &nbsp; &nbsp; &nbsp; &nbsp; $iRval = _SQLite_GetTable(-1, $query, $aResult, $iRows, $iColumns)&nbsp; &nbsp; &nbsp; &nbsp; _SQLite_QueryFinalize($iRval)&nbsp; &nbsp; &nbsp; &nbsp; $play2 = StringFormat ( &quot;%03s&quot;&nbsp; ,$aResult[0] - 1)&nbsp; &nbsp; &nbsp; &nbsp; $coutall = Int($aResult[0] - 1)&nbsp; &nbsp; &nbsp; &nbsp; $query = 'SELECT PLAYCOUNT FROM M_MEDIAITEM INNER JOIN M_SERIESITEM ON M_MEDIAITEM.MEDIA_ITEM_ID = M_SERIESITEM.MEDIA_ITEM_ID WHERE M_MEDIAITEM.PLAYCOUNT IS NULL AND M_SERIESITEM.SERIESNAME = &quot;' &amp; $series &amp; '&quot; ;'&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $iRval = _SQLite_GetTable(-1, $query, $aResult, $iRows, $iColumns)&nbsp; &nbsp; &nbsp; &nbsp; _SQLite_QueryFinalize($iRval)&nbsp; &nbsp; &nbsp; &nbsp; $play = StringFormat ( &quot;%03s&quot;&nbsp; ,$aResult[0] - 1) &amp; &quot;/&quot; &amp; $play2&nbsp; &nbsp; &nbsp; &nbsp; $coutsee = Int($aResult[0] - 1)&nbsp; &nbsp; &nbsp; &nbsp; ;Set Watchd Status Logo&nbsp; &nbsp; &nbsp; &nbsp; If $coutsee = 0 then&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; GUICtrlSetImage($Picb3, @ScriptDir &amp; &quot;\Images\eye-green.gif&quot;)&nbsp; &nbsp; &nbsp; &nbsp; ElseIf $coutsee = $coutall Then&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; GUICtrlSetImage($Picb3, @ScriptDir &amp; &quot;\Images\eye-red.gif&quot;)&nbsp; &nbsp; &nbsp; &nbsp; Else&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; GUICtrlSetImage($Picb3, @ScriptDir &amp; &quot;\Images\eye-yellow.gif&quot;)&nbsp; &nbsp; &nbsp; &nbsp; EndIf[/code]</blockquote>

[QUOTE="Lehmden, post: 1129730, member: 109222"] Hi. Looks great.(y) Especially the new "watched" logo is something I like to see. Don't know if it can be done in xaml but I would love to have a "Traffic Light" system for series and seasons. Red means no episodes watched and yellow means some, but not all episodes watched. Green could be for all episodes watched, but it can be left out completely, to be consistent, no problem... This information definitely is available in the DB and it is usable with a DB query. I did this in MP2-Edit so I'm sure it's working 100% reliable. But I don't know if this can be shown that easy in skin here... I really need this as this is one of the things I'm missing from MP1 the most... If someone want to have a look, here is the code I use to achieve this in MP2-Edit: [code] $query = 'SELECT PLAYCOUNT FROM M_MEDIAITEM INNER JOIN M_SERIESITEM ON M_MEDIAITEM.MEDIA_ITEM_ID = M_SERIESITEM.MEDIA_ITEM_ID Where M_SERIESITEM.SERIESNAME = "' & $series & '" ;' $iRval = _SQLite_GetTable(-1, $query, $aResult, $iRows, $iColumns) _SQLite_QueryFinalize($iRval) $play2 = StringFormat ( "%03s" ,$aResult[0] - 1) $coutall = Int($aResult[0] - 1) $query = 'SELECT PLAYCOUNT FROM M_MEDIAITEM INNER JOIN M_SERIESITEM ON M_MEDIAITEM.MEDIA_ITEM_ID = M_SERIESITEM.MEDIA_ITEM_ID WHERE M_MEDIAITEM.PLAYCOUNT IS NULL AND M_SERIESITEM.SERIESNAME = "' & $series & '" ;' $iRval = _SQLite_GetTable(-1, $query, $aResult, $iRows, $iColumns) _SQLite_QueryFinalize($iRval) $play = StringFormat ( "%03s" ,$aResult[0] - 1) & "/" & $play2 $coutsee = Int($aResult[0] - 1) ;Set Watchd Status Logo If $coutsee = 0 then GUICtrlSetImage($Picb3, @ScriptDir & "\Images\eye-green.gif") ElseIf $coutsee = $coutall Then GUICtrlSetImage($Picb3, @ScriptDir & "\Images\eye-red.gif") Else GUICtrlSetImage($Picb3, @ScriptDir & "\Images\eye-yellow.gif") EndIf [/code] [/QUOTE]

Verification