How to edit Channel List with sqlitestudio

There are 2 replies in this Thread which was already clicked 1,037 times. The last Post () by TH3-J0K3R.

  • Download sqlitestudio
    get your pm.db from the box
    open sqlitestudio
    drag and drop pm.db into the left pane
    double click pm_fav_t0
    click Data
    5487f51a42.jpg


    each number ex: 215-202-216-203-861-150-28-29-852- represents a channel



    double click pm_prog_t0 click Data
    the row progRowID hols the channel number
    1ae1a4.jpg


    make your list in notepad ex: 215-202-216-203-861-150-28-29-852-
    and past it into your categeory in pm_fav_t0
    click green check mark to commit the changes


    put the pm.db back onto the box
    reboot

  • Thanks for guide lambo, never seen the sqlitestudio before so cheers for that.


    Here is some extra help to speed up finding all the id's of a particular set of channels.


    Say you want to find all the id's of Sky Sports, 1st open SQL Editor by pressing button shown in image below


    d8395e7e12fd1c1380.jpg


    Then enter this SQL query


    SELECT progRowID FROM pm_prog_t0 WHERE acServiceName LIKE '%Sky Sports%';


    Change the Text between the % % to find what you are looking for, if you only want to find the id's for Sky Sports 1 you would do %Sky Sports 1%


    12579f59b2.jpg


    once you run query you can copy all the id's and follow guide above.


    Cheers

    If it ain't broke break it and try make it better

  • nice info guys :)


    so many devices i need to update so hopefully this will help me on my way :)

    PM for support 0nly with a Link to Y0ur
    P05t w1Th Wat5 up 0r 155u3 thaT5
    B33N ....... P05T3D


    0D3R PATCH3D 3H ;)
    much <3 th0ugh in d0 a5 Ab0v3
    1n Wh3n 533N r3plY n PM n 58PP0rt G1v3n ;)



    "I'm against Piracey so please DONT ATTACK SHIPS"
    :p

    Edited once, last by TH3-J0K3R ().

  • master G

    Added the Label Article

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!