CSP MySQL User Manager 2.3.3d with active code function

[Satshare]

editing by kalf

Technical Infos:
* Date: 13.7.2016
* CMUM Version: 2.3.3d (this verion is in english)
* Code Gen Version: 1.9 (Fix all errors)
* Plugin version: 2.8 (if you need the new pluging PM me) enigma2 box
* Added: Added Function Import and export user with code.
* Added: Display the result on the activation page.
* Added: added activecode.php for Active code plugin.
* Fix: Import Profiles Function.
* Fix: Change date format Y-m-d to d-m-Y.
* Added: 5 Days test line code
* Added: 1 month line Code
* Added: 3 month line Code
* Added: 6 month line Code
* Added: 9 month line Code
* Added: 12 month line Code
* Added: 24 month line Code
* Added: PRIVATE CODE ACTIVATION (SEE SCREENSHOT)

* Pluging v 2.8 (if you need the new pluging PM me)
* Added: Download new Channel list (from your server)
* Added: Download CCcam.prio (from your server)
* Added: CCcam2.21 in the plugin (no cam needit whit this plugin!)
* Fix Green button remove CCcam.cfg
* Added: message expire account every 2 hours for 3 days
* Added: No internet connection (if the box have no internet connection you get message)

* Plugin test on OpenPli

Requirements
-Running Version of CSP (Server side)
-CSP Proxy XML
-Download attached cmum-2.3.3d.zip
-General Linux SSH terminal knowledge (putty)


First install

Firstly we have to install phpMyAdmin and MySQL and apache2 and php5 onto your server,

sudo apt-get install apache2
sudo apt-get install php5
sudo /etc/init.d/apache2 restart
sudo apt-get install phpmyadmin
sudo apt-get install mysql-server

Make sure all passwords are the same when installing to make it easier to configure and a better database sync.

Once passwords are set you may be prompted to Retry, Cancel, Continue. Select the number which refers to continue if the same error message appears then refer to Skip.

Now into installing the CSP tables for the database into MySQL
Using your FTP Program go to /var/lib/mysql/mysql/ . Copy the contents of SQL in the attached file to this directory.

Now to install the tables run

mysql -u root -p PASSWORD -h localhost mysql < /var/lib/mysql/mysql/cmumdb.sql

Replace PASSWORD with the password you set when installing MySQL

That's SQL side installed, and DONE Now onto the Web Interface side

Go to /var/www/ and create a folder called CSP

cd /var/www

mkdir csp

Login to your prefer FTP program again and go into the server and locate the folder which has just been created /var/www/csp
Copy over the content in WWW in the attached .zip file.

Locate examples.config.php
Copy and paste the following

PHP

$dbhost = "127.0.0.1";
$dbname = "mysql";
$dbuser = "root";
$dbpass = "PASSWORD"; < this is the password you used to set myadmin and mysql
$charset = "utf-8";

Rename this file to config.php

Go to csp/genxml/ and open genxml.php
Edit the top of the file to the following

PHP

$dbhost = "127.0.0.1";
$dbname = "mysql";
$dbuser = "root";
$dbpass = "PASSWORD"; < this is the password you used to set myadmin and mysql
$charset = "utf-8";

ONLY EDIT THAT PART
Using PASSWORD as the one set when installing MySQL.

CHMOD the folder >> activecodefiles to 777 ant the files to in the folder

Go to your browser and put your server IP or DNS/csp
example

http://192.168.0.1/csp
Username: admin
Passwd: password

Go to your CSP config Installation directory which is usr/local/csp/config and Edit proxy.xml

Replace this the default user manager
With this

<user-manager allow-on-failure="false" log-failures="true">
<auth-config>
<update-interval>1</update-interval>
<user-source name="tnt">
<user-file-url>YOUR GENXML DIRECTORY(EXAMPLE:http://192.168.0.1/csp/genxml/genxml.php</user-file-url>
</user-source>
</auth-config>
</user-manager>

server info
the file in your

/var/www/csp/server.php

can you set your dns ant port for ping zo you can see if your server are online

info

/var/www/csp/info.php

you can set all info off your server if you want

activecode
set your Line in see screenshot

/var/www/csp/activecode.php AND /var/www/csp/codeactivation.php

you see 2 line N Line and a Cline you can adit it and set more lines! do not edit ohter things!!!

See Screenshots

edit the 2 file's and add your database (see screenshot)

/var/www/csp/activecode.php AND /var/www/csp/codeactivation.php

in each file you must set database 2 times


If you need the plugin PM me

Maked bij Kalf Dreamtv-Team

 

[hamza]

The password is not working