home
products
contribute
download
documentation
forum
Home
Forums
New posts
Search forums
What's new
New posts
All posts
Latest activity
Members
Registered members
Current visitors
Donate
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
MediaPortal 2
Plugin Development
Need a little help with plugin development
Contact us
RSS
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="Lehmden" data-source="post: 1187197" data-attributes="member: 109222"><p>Hi.</p><p>I can answer a few of your questions..</p><p></p><p>I've done it in my AutoIt tool this way (it's working):</p><p>"SELECT * FROM M_MEDIAITEM INNER JOIN M_SERIESITEM ON M_MEDIAITEM.MEDIA_ITEM_ID = M_SERIESITEM.MEDIA_ITEM_ID INNER JOIN NM_EPISODE ON NM_EPISODE.MEDIA_ITEM_ID = M_SERIESITEM.MEDIA_ITEM_ID INNER JOIN V_EPISODE ON NM_EPISODE.ID = V_EPISODE.ID ;"</p><p></p><p></p><p>Good question, next question... <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite2" alt=";)" title="Wink ;)" loading="lazy" data-shortname=";)" /> I never understand why the episodes numbers are in an extra table and encrypted to a GUID... Makes queries much more complicated and I can't see any advantage in this approach. But I can imagine this will change with the MIA rework within the next weeks (also I'm not sure about this)...</p><p></p><p></p><p>In table M_PROVIDERRESOURCE...</p><p></p><p>And now forget all that I've written above<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite7" alt=":p" title="Stick Out Tongue :p" loading="lazy" data-shortname=":p" /> </p><p>because of:</p><p></p><p>The right and only way is to ask MP2 server. Never access the database directly... This may lead to crashes and/or corrupted databases... We don't want to copy bad coding styles from other applications...<img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite2" alt=";)" title="Wink ;)" loading="lazy" data-shortname=";)" /></p><p>If you need guidance for this you may ask some devs...</p></blockquote><p></p>
[QUOTE="Lehmden, post: 1187197, member: 109222"] Hi. I can answer a few of your questions.. I've done it in my AutoIt tool this way (it's working): "SELECT * FROM M_MEDIAITEM INNER JOIN M_SERIESITEM ON M_MEDIAITEM.MEDIA_ITEM_ID = M_SERIESITEM.MEDIA_ITEM_ID INNER JOIN NM_EPISODE ON NM_EPISODE.MEDIA_ITEM_ID = M_SERIESITEM.MEDIA_ITEM_ID INNER JOIN V_EPISODE ON NM_EPISODE.ID = V_EPISODE.ID ;" Good question, next question... ;) I never understand why the episodes numbers are in an extra table and encrypted to a GUID... Makes queries much more complicated and I can't see any advantage in this approach. But I can imagine this will change with the MIA rework within the next weeks (also I'm not sure about this)... In table M_PROVIDERRESOURCE... And now forget all that I've written above:p because of: The right and only way is to ask MP2 server. Never access the database directly... This may lead to crashes and/or corrupted databases... We don't want to copy bad coding styles from other applications...;) If you need guidance for this you may ask some devs... [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 2
Plugin Development
Need a little help with plugin development
Contact us
RSS
Top
Bottom