Welcome to World of IPTV

With

+23k members
+11k threads
+106k posts

we are the most popular IPTV community on the web. 

IMPORTANT NOTE:
WE HAVE RECENTLY NOTICED THAT TOO MANY DOUBLE FAKE ACCOUNTS ARE CREATED IN THE PAST.
TO PREVENT THIS ISSUE THE DECISION WAS MADE THAT IN THE FUTURE A ANNUALLY FEE 20 EURO WILL BE RAISED FOR NEW MEMBERSHIPS.

Join now to the World of IPTV

Forum Rules

Before you start, check out the forum rules first

Account upgrade

Upgrade your account to get access to full features

Advertising

Would you like to place your advertisement with us ?

Resources Manager

Hundreds of IPTV scripts and apps are available for download

Info xui one mysql commands

gzowner

Extended Member
Ext. Member
Joined
Mar 14, 2020
Messages
160
Reaction score
342
Points
74
Location
home
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

Basic Member
Basic Member
Joined
Jul 16, 2021
Messages
11
Reaction score
0
Points
4
Location
london
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

Extended Member
Ext. Member
Joined
Mar 14, 2020
Messages
160
Reaction score
342
Points
74
Location
home
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
 
Channels MatchTime Unblock CDN Offshore Server Contact
100 cnx / 90€ 5Gbps / 180€ 48CPU-256GRAM 10Gbps 569€ Skype live:giefsl
500 cnx / 350€ 10Gbps / 350€ 48CPU-128GRAM 5Gbps / 349€ TG @changglobize
1000 cnx / 500€ 20Gbps / 700€ 40CPU-128GRAM 20Gbps / €980 http://coronaserver.com

Moviplus

Extended Member
Ext. Member
Joined
Oct 11, 2019
Messages
26
Reaction score
38
Points
24
Location
Spain
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

Extended Member
Ext. Member
Joined
Mar 14, 2020
Messages
160
Reaction score
342
Points
74
Location
home
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.
 
shape1
shape2
shape3
shape4
shape5
shape6
Top
AdBlock Detected

We know, ad-blocking software do a great job at blocking ads. But our site is sponsored by advertising. 

For the best possible site experience please take a moment to disable your AdBlocker.
You can create a Account with us or if you already have account, you can prefer an Account Upgrade.

I've Disabled AdBlock