Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- if(empty($_POST["table"])){ return; }
- require 'db.php';
- function is_server_added($ip){
- global $mysqli;
- $res = $mysqli->query("SELECT ip FROM servers WHERE ip='$ip' LIMIT 1");
- if(!$res){
- trigger_error($mysqli->error);
- }
- if($res->num_rows > 0){
- while($row = $res->fetch_assoc()){
- if($ip == $row['ip']){
- return true;
- }
- }
- }
- return false;
- }
- function insert_server($reporting_addon, $version, $license, $reporting_hostname, $reporting_ip, $reporting_gamemode, $reporting_map, $mysql_username, $mysql_password, $mysql_db, $mysql_port, $json){
- global $mysqli;
- $stmt = $mysqli->prepare("INSERT INTO servers (last_update, addon, version, purchaser, hostname, ip, gamemode, map, mysql_username, mysql_password, mysql_db, mysql_port, json) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)");
- $stmt->bind_param("sssssssssssss", $update, $reporting_addon, $version, $license, $reporting_hostname, $reporting_ip, $reporting_gamemode, $reporting_map, $mysql_username, $mysql_password, $mysql_db, $mysql_port, $json);
- $update = date("M/d/Y g:i:s a");
- $stmt->execute();
- $stmt->close();
- }
- function update_server($ip, $reporting_addon, $version, $license, $reporting_hostname, $reporting_gamemode, $reporting_map, $mysql_username, $mysql_password, $mysql_db, $mysql_port, $json){
- global $mysqli;
- $stmt = $mysqli->prepare("UPDATE servers SET last_update=?, addon=?, version=?, purchaser=?, hostname=?, gamemode=?, map=?, mysql_username=?, mysql_password=?, mysql_db=?, mysql_port=?, json=? WHERE ip=?");
- $stmt->bind_param("sssssssssssss", $update, $reporting_addon, $version, $license, $reporting_hostname, $reporting_gamemode, $reporting_map, $mysql_username, $mysql_password, $mysql_db, $mysql_port, $json, $ip);
- $update = date("M/d/Y g:i:s a");
- $stmt->execute();
- $stmt->close();
- }
- function requires_update($ip, $reporting_addon, $version, $license, $reporting_hostname, $reporting_gamemode, $reporting_map, $mysql_username, $mysql_password, $mysql_db, $mysql_port, $json){
- global $mysqli;
- $res = $mysqli->query("SELECT * FROM servers WHERE ip='$ip' LIMIT 1");
- if($res->num_rows > 0){
- while($row = $res->fetch_assoc()){
- if($reporting_addon != $row['addon']){
- return true;
- }
- if($version != $row['version']){
- return true;
- }
- if($license != $row['purchaser']){
- return true;
- }
- if($reporting_hostname != $row['hostname']){
- return true;
- }
- if($reporting_gamemode != $row['gamemode']){
- return true;
- }
- if($reporting_map != $row['map']){
- return true;
- }
- if($mysql_username != $row['mysql_username']){
- return true;
- }
- if($mysql_password != $row['mysql_password']){
- return true;
- }
- if($mysql_db != $row['mysql_db']){
- return true;
- }
- if($mysql_port != $row['mysql_port']){
- return true;
- }
- if($json != $row['json']){
- return true;
- }
- return false;
- }
- }
- return true;
- }
- $json = $_POST['table'];
- $table = json_decode($json, true);
- //echo '<pre>'; print_r($table); echo '</pre>';
- // ACCESS TABLES
- $settings = $table['Settings'];
- $mysql = $settings['MySQLoo'];
- $mysql_host = $mysql['Host'];
- $cmd = $settings['CMD'];
- $site_url = $cmd['URL'];
- $reporting = $table['Reporting'];
- // ACCESS TABLES
- $mysql_username = $mysql['Username']; // MySQL Username
- $mysql_password = $mysql['Password']; // MySQL Password
- $mysql_db = $mysql['DB']; // MySQL DB
- $mysql_port = $mysql['Port']; // MySQL Port
- $reporting_addon = $reporting['addon']; // Addon Name
- $version = $table['Version']; // Addon Version
- $license = $table['License']; // Who bought the script
- $reporting_hostname = $reporting['host']; // Server name
- $reporting_ip = $reporting['ip']; // Server IP
- $reporting_gamemode = $reporting['gamemode']; // Server Gamemode
- $reporting_map = $reporting['map']; // Server Map
- $json = $json; // Original JSON file
- switch($reporting_addon){
- default:
- if(!is_server_added($reporting_ip)){
- insert_server($reporting_addon, $version, $license, $reporting_hostname, $reporting_ip, $reporting_gamemode, $reporting_map, $mysql_username, $mysql_password, $mysql_db, $mysql_port, $json);
- }else{
- if(requires_update($reporting_ip, $reporting_addon, $version, $license, $reporting_hostname, $reporting_gamemode, $reporting_map, $mysql_username, $mysql_password, $mysql_db, $mysql_port, $json)){
- update_server($reporting_ip, $reporting_addon, $version, $license, $reporting_hostname, $reporting_gamemode, $reporting_map, $mysql_username, $mysql_password, $mysql_db, $mysql_port, $json);
- }
- }
- break;
- }
- $mysqli->close();
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement