channel order

[BrickTop]

Hi all abit of help needed here,

im trying to put my channels in order that i want my end users to see and select , done this on panel and saved , but checked on my box and they are not in
the order ive put on the panel
has anyone got a guide on this please and thankyou

 

[incubo78]

which panel do you use ?
Channel Sorting Type choose bouquet.

 

[BrickTop]

panel i use is xtream-ui

 

[incubo78]

panel i use is xtream-ui

on setting, streamin part Channel Sorting Type what did you choose ? it should be bouquet and you arrange your channels in bouquet.

 

[brando1972]

New here can I get some likes please so I can view some how to articles? Thanks

 

[sc0tsman]

on setting, streamin part Channel Sorting Type what did you choose ? it should be bouquet and you arrange your channels in bouquet.

Nothing works tried every combination.

 

[sc0tsman]

panel i use is xtream-ui

Starkey did you get a solution for this?

 

[BrickTop]

Starkey did you get a solution for this?

yes thanks bud , i mass edited channels into catagories first then painstakingly renamed the channels (im OCD) to my own preferance then put them in order acorring to V****NM***A / S*Y
then, it was easier to add logo and EPG at the same time , made sure i backed database up , after each session
it was a monster of a task , but glad its done now

EDIT: i used bouquet order NOT Manual

 

[sc0tsman]

I think I tried that too mate but no joy, such a great panel with a simple feature missing

 

[BrickTop]

I think I tried that too mate but no joy, such a great panel with a simple feature missing

it is a ball ache no doubt!

 

[miltonr]

es un dolor de pelota sin duda!

The way to solve this is to edit the UNIX TimeStamp in the database, which looks something like "1648727183" and order the first channel to be the date closest to today.

Hi all abit of help needed here,

im trying to put my channels in order that i want my end users to see and select , done this on panel and saved , but checked on my box and they are not in
the order ive put on the panel
has anyone got a guide on this please and thankyou

 

[thugthug]

The way to solve this is to edit the UNIX TimeStamp in the database, which looks something like "1648727183" and order the first channel to be the date closest to today.

I have no idea how to do this, could you give us any tips on where to start?

 

[sc0tsman]

I have no idea how to do this, could you give us any tips on where to start?

I would like to know too.

 

[miltonr]

I have no idea how to do this, could you give us any tips on where to start?

You have to go to configurations - database, there it asks for the mysql password, you are going to show tables, and you go to the streams table, the column "added" you just have to learn a little about mysql database

Once you are working in the database you can modify the unix date in the "added" column, the oldest date will order the channel down, the date closest to today will order it higher in the list, I share with you an example of the command which should be used to modify the date:

UPDATE `streams`
SET `added`= 1638946206
WHERE id = 2811

the id has to match that of your channel to modify
and the number that we set in "added" is the unix date, you can search more about unix dates in google.

 

[thugthug]

You have to go to configurations - database, there it asks for the mysql password, you are going to show tables, and you go to the streams table, the column "added" you just have to learn a little about mysql database

Once you are working in the database you can modify the unix date in the "added" column, the oldest date will order the channel down, the date closest to today will order it higher in the list, I share with you an example of the command which should be used to modify the date:

UPDATE `streams`
SET `added`= 1638946206
WHERE id = 2811

the id has to match that of your channel to modify
and the number that we set in "added" is the unix date, you can search more about unix dates in google.

I was confused about unix dates, it's something new for me.

While you gave me the first clue, I opened HeidiSQL and went after the "added" column to see what was in it and understand it better.

But then I was afraid to make changes and they for some reason would become a problem in MySQL.

So I went to google about Unix TimeStamp and found that they are dates in number format for unix or something, I still don't know the definition.

I found a site that does the conversion and I realized that the number you provided was in this case an old date, 1638946206.

and I was almost getting to your logic:

Once you are working in the database you can modify the unix date in the "added" column, the oldest date will order the channel down, the date closest to today will order it higher in the list, I share with you an example of the command which should be used to modify the date:

But as you saw in my HeidiSQL print, the "added" is not self-completed, wouldn't it be ideal to add a value to fill as "current date" so that future streams already have the correct dates? @miltonr

 

[miltonr]

Estaba confundido acerca de las fechas de Unix, es algo nuevo para mí.

Mientras me diste la primera pista, abrí HeidiSQL y busqué la columna "agregado" para ver qué contenía y entenderlo mejor.

Pero luego tuve miedo de hacer cambios y, por alguna razón, se convertirían en un problema en MySQL.

Así que fui a Google sobre Unix TimeStamp y descubrí que son fechas en formato numérico para Unix o algo así, todavía no sé la definición.

Encontré un sitio que realiza la conversión y me di cuenta de que el número que proporcionó en este caso era una fecha anterior, 1638946206.

y casi estaba llegando a tu lógica:

first make a backup of the database is the safest, then check if you are in the "streams" table you have to find that the added column has values similar to this "1639394826"

Update:
check that you are in the row of a channel, order them by "category_id", it must have the date that you loaded the streams, you can enter a unix date, your DB will not have a problem