Advertisement
Lonster_Monster

php help

Mar 23rd, 2018
253
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 2.04 KB | None | 0 0
  1. Main PHP
  2. <?php
  3.     require 'steamauth/steamauth.php';
  4.     require 'connection.php';
  5.     $Credits = 0;
  6.     if(isset($_SESSION['steamid'])){
  7.     include  ('steamauth/userInfo.php');
  8.     $steamid         = $steamprofile['steamid'];
  9.     $SteamName       = $steamprofile['personaname'];
  10.     $isAdmin = false;
  11.     $sql_table = "users";
  12.     $sql_Admin_table = "betterbot_administrators";
  13.     $sql = "SELECT * FROM $sql_table WHERE steamId = $steamid;";
  14.     $sql_insert_data = mysqli_query($conn,"INSERT INTO $sql_table (steamId, steam_Name)
  15.     VALUES ('$steamid', '$SteamName');");
  16.     $results = $conn->query($sql);
  17.         if ($results->num_rows > 0) {
  18.     // output data of each row
  19.             while($row = $results->fetch_assoc()) {
  20.             echo "id: " . $row["id"]. " - steam_Name: " . $row["steam_Name"]. "- steamId: " . $row["steamId"].  "- isAdmin: " . $row["isAdmin"]."<br>";
  21.                 if ($row["isAdmin"] == "true"){
  22.                 $isAdmin = true;
  23.                     if ($isAdmin === true){
  24.                     $admin =$row["isAdmin"];
  25.                     $sql = "SELECT * FROM $sql_Admin_table WHERE steamId = $steamid;";
  26.                     $result = $conn->query($sql);
  27.                         if ($result == false) {
  28.                             $sql = mysqli_query($conn,"INSERT INTO $sql_Admin_table (`steamId`, `steam_Name`, `isAdmin`) VALUES ('$steamid', '$SteamName', '$admin');");
  29.                             if ($conn->query($sql) == true){   
  30.                             }else{
  31.                                
  32.                             }
  33.                         }else{
  34.                                
  35.                         }
  36.                     }                  
  37.                 }else{
  38.                 $sql = mysqli_query($conn,"INSERT INTO $sql_Admin_table (SteamId, SteamName) VALUES ('$steamid', '$SteamName');");
  39.                     if ($conn->query($sql) == TRUE)
  40.                     {
  41.                         echo "New record created successfully";
  42.                     } else {
  43.                         echo "Error: " . $sql . "<br>" . $conn->error;
  44.                     }
  45.                 }
  46.             }
  47.         }
  48.         else
  49.         {
  50.            
  51.         }
  52.         mysqli_close($conn);
  53.     }
  54. ?>
  55. Connection Php
  56. <?php
  57. $servername = "localhost";
  58. $username = "root";
  59. $password = "";
  60. $dbname = "users";
  61.  
  62. // Create connection
  63. $conn = new mysqli($servername, $username, $password, $dbname);
  64. // Check connection
  65. if ($conn->connect_error) {
  66.     die("Connection failed: " . $conn->connect_error);
  67. }
  68. echo "Connected successfully";
  69. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement