Custom cms for read-write in xc2 sql

[sympan]

Hello to all
i have start to write an interface to read some data from xc sql and make some basic functions like extend one user, create other or just see where one line expire
this is has 2 parts, one for users and one for streamings
you can tell me some basic actions that you believe as sos to create ?
create this because if xc open again you have not lost any data in your db
thanks

 

[romeo007]

vod
series
sellers
sub resellers

 

[sympan]

for vod and series add functions ?

 

[acetk]

Hello to all
i have start to write an interface to read some data from xc sql and make some basic functions like extend one user, create other or just see where one line expire
this is has 2 parts, one for users and one for streamings
you can tell me some basic actions that you believe as sos to create ?
create this because if xc open again you have not lost any data in your db
thanks

some good stuff here

HowTo - Xtream Codes v2 API Examples

Hi People, here some "maybe" usefull information about the XC v2 API - didnt try it by myself You schould be able to use it against you XC v2 CMS server Please like - no likes needed to see the contents :) Creating New Line To create a New line, we will call the following URL...

www.worldofiptv.com

 

[maundy]

<?php
// DISPLAY USER LIST BY ID-USER-PASS-EXPIRY

$servername = "localhost:7999";
$username = "root";
$password = "password";
$dbname = "xtream_iptvpro";


$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}

$sql = "SELECT member_id, username, password, exp_date FROM users";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
while($row = $result->fetch_assoc()) {
echo "<br> USER ID: ". $row["member_id"]. " - USERNAME: ". $row["username"]. " - PASSWORD: ". $row["password"]. " - ESPIRES: ". $row["exp_date"] . "<br>";
}
} else {
echo "0 results";
}

$conn->close();
?>

edit expiry date with

$sql = "UPDATE streams SET exp_date='<NEW DATE HERE>' WHERE member_id=<MEMBERS ID HERE>";

dates are unix timestamp

Unix Time Stamp - Epoch Converter

Epoch and unix timestamp converter for developers. Date and time function syntax reference for various programming languages.

www.unixtimestamp.com

these are all your available sql queries
member_id
exp_date
is_restreamer
admin_enabled
enabled
is_trial
created_at
created_by
pair_id
is_mag
username
password
is_e2

hope this helps pal

 

[krotos]

when you finish do you will share it?

 

[sympan]

anyone has resolve convertion of mag (mac adresses) to enconding with python ? in db not see real mac but encoding

 

[chofrengo]

dude i had a office script , ill share with you maybe you can add some modules , like vods and remake

 

[phantomfx]

They used base64_encode(), you can use base64_decode() to revert it to real mac

 

[baybay26]

thanks...

 

[sympan]

thanks