Info xui one mysql commands

[gzowner]

Here is some mysql commands that can help you filter out your VOD

Want to seperate by year? Make a CAT for the Year. remember the CAT ID #

UPDATE `xui`.`streams` SET `category_id` = '[CATIDHERE]' WHERE (`year` = '2022');

Want Actor Folders?
Lets see if it pulls
SELECT * FROM xui.streams WHERE movie_properties REGEXP '[^\\d\\w]Dwayne Johnson[^\\d\\w]' <---REplace DJ with actor of your choice.

UPDATE `xui`.`streams` SET `category_id` = '[CATIDHERE]' WHERE movie_properties REGEXP '[^\\d\\w]Dwayne Johnson[^\\d\\w]'; <---replace DJ with a actor of your choice

 

[alt132]

hi
after changing the domain in lb, it restarts the streams. is there a way to change the domain without restarting the streams?
thanks

 

[gzowner]

hi
after changing the domain in lb, it restarts the streams. is there a way to change the domain without restarting the streams?
thanks

No. you want it to restart so it grabs the changes. Making DNS changes always requires a restart. A few secs isnt a killer unless you got some high class demanding asshole customers

 

[Moviplus]

Hey, now that you're talking about xuiOne database. Does it have any relationships between tables? Because I'm testing it in local and I see no relationships in ER Diagram. Is this correct or did I fucked up my database? Thanks =)

 

[gzowner]

Hey, now that you're talking about xuiOne database. Does it have any relationships between tables? Because I'm testing it in local and I see no relationships in ER Diagram. Is this correct or did I fucked up my database? Thanks =)

i havent test it to that point to give u a honest answer. Just check logs to see if it has errors in it.