API tools faq
paste
Advertisement
AhmedCloud

The page

AhmedCloud
Mar 7th, 2017
114
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 24.06 KB | None | 0 0
raw download clone embed print report
  1. <head>
  2. <title> Account Details</title>
  3. <style>
  4. input{
  5.     width:250px;
  6.     height:30px;
  7. }
  8. #container{
  9.     background-color:#de9f25;
  10.     padding:30px 10px 50px 10px;
  11.     width:600px;
  12.     box-shadow:1px 1px 5px #000;
  13.     border: 1px solid #c0c0c0;
  14. }
  15. table, th, td {
  16.     border: 3px solid black;
  17.     border-collapse: collapse;
  18.     border-color: #4f4f4f;
  19. }
  20. th, td {
  21.     padding: 5px;
  22.     text-align: left;    
  23. }
  24. </style>
  25. </head>
  26.  
  27. <?php
  28.     session_start();
  29.     $servername = "localhost";
  30.     $username = "root";
  31.     $password = "";
  32.     $dbname = "ds";
  33.     $conn = mysqli_connect($servername, $username, $password);
  34.     $bname = $_SESSION["dename"];
  35.     $accpw = $_SESSION["password"];
  36.     $bacc;
  37.     $owner;
  38.     $pacc;
  39.     $dspp;
  40.     $igaccid;
  41.     $igname;
  42.     $rank;
  43.     $team;
  44.     $emailad;
  45.     $count = 0;
  46.     if(isValidAccName($bname, $conn, $dbname) == -1)
  47.     {
  48.         echo "Incorrect player name or password.";
  49.         echo '<br><br><a href="/ds/index.php">Click here</a> to get redirected to the login page.';
  50.         return;
  51.     }
  52.     mysqli_select_db ($conn, $dbname);
  53.     $result = mysqli_query ($conn, "select * from accounts where name = '$bname'");
  54.     while ($row = mysqli_fetch_array ($result)) {
  55.         $count++;
  56.         if($count != 0)
  57.         if($accpw != $row['password'])
  58.         {
  59.             echo "Incorrect player name or password.";
  60.             echo '<br><br><a href="/ds/index.php">Click here</a> to get redirected to the login page.';
  61.             return;
  62.         }
  63.         $bacc = $row['id'];
  64.         $igaccid = $row['accid'];
  65.         $owner = $row['owner'];
  66.         $igname = $row['name'];
  67.         $emailad = $row['email'];
  68.         $dspp = $row['dspp'];
  69.         $rank = $row['rank'];
  70.         $team = $row['team'];
  71.     }
  72.     if($count == 0){
  73.         echo "Incorrect player name or password.";
  74.         echo '<br><br><a href="/ds/index.php">Click here</a> to get redirected to the login page.';
  75.         return;
  76.     }
  77.     $emailad = getAccEmail($bacc, $conn, $dbname);
  78.     $rank = getRankName($rank);
  79.     $team = getTeamName($team);
  80.     $dename = getAccountName($bacc, $conn, $dbname);
  81.     echo '<center><img src="http://i.imgur.com/uK4k2X7.png" /></center>';
  82.     echo "<center><h1>$dename</h1>";
  83.     echo "<div id='container' align='left'>";
  84.     echo "<font size=5 color=white><b>In-game name:</b> $igname";
  85.     echo "<br><b>Rank:</b> $rank";
  86.     echo "<br><b>Team:</b> $team";
  87.     echo "<br><b>Email Address:</b> $emailad";
  88.     echo "<br><b>DSPP:</b> $dspp";
  89.    
  90.     echo "</div></font>";
  91.     echo "<div id='container'>
  92.         <form action='' method='post'>
  93.         <font size=4><font color='#333333'>Change Password:</font><br>
  94.         <input type='password' name='currpw' placeholder='Current Password' />
  95.         <br><input type='password' name='newpw1' placeholder='New Password' />
  96.         <br><input type='password' name='newpw2' placeholder='Confirm Password' />
  97.         <br><br><input type='submit' name='updatepw' value='Change Password' />
  98.         </form></div><br><br>";
  99.        
  100.     if(isset($_POST['updatepw']))
  101.     {
  102.         if(!empty($_POST['currpw']) && !empty($_POST['newpw1']) && !empty($_POST['newpw2']))
  103.         {
  104.             if($_POST['currpw'] == $accpw)
  105.             {
  106.                 if($_POST['newpw1'] == $_POST['newpw2'])
  107.                 {
  108.                     $bacc = $_SESSION["id"];
  109.                     $lastpwch = getLastPwChange($bacc, $conn, $dbname);
  110.                     if(time()-$lastpwch > 3600 || $lastpwch == 0)
  111.                     {
  112.                         $currpw = $_POST['currpw'];
  113.                         $newpw1 = $_POST['newpw1'];
  114.                         $newpw2 = $_POST['newpw2'];
  115.                         setAccPassword($bacc, $newpw1, $conn, $dbname);
  116.                         $_SESSION["password"] = $newpw1;
  117.                         echo "You've succesfully changed your password to $newpw1";
  118.                     }
  119.                     else echo "<b>[ERROR]</b> You must wait at least one hour before changing your password again.";
  120.                 }
  121.                 else echo "<b>[ERROR]</b> Passwords don't match!";
  122.             }
  123.             else echo "<b>[ERROR]</b> Invalid current password!";
  124.         }
  125.         else echo "<b>[ERROR]</b> You must fill all forms!";
  126.     }
  127.     if($count == 0) echo "<h3>There are no DSPP transactions.";
  128.     if($owner == 1)
  129.     {
  130.         $bbcode = "";
  131.         $bbcode2 = "";
  132.         echo
  133.         "<center><hr>
  134.         <h2>Administration<br></h2>";
  135.         $count = 0;
  136.         mysqli_select_db ($conn, $dbname);
  137.         $result = mysqli_query ($conn, "select * from trans");
  138.         echo "<font color='#333333'><h1>DSPP Transactions:</h1>";
  139.         while ($row = mysqli_fetch_array ($result)) {
  140.             $count++;
  141.         }
  142.         if($count != 0)
  143.         {
  144.             echo "<table style='width:20%'>";
  145.             echo '<tr>';
  146.             echo '<th><b><font color=333333>Name</b></th>';
  147.             echo '<th><b><font color=333333>Amount</b></th>';
  148.             echo '<th><b><font color=333333>Reason</b></th>';
  149.             echo '<th><b><font color=333333>Before</b></th>';
  150.             echo '</tr>';
  151.         }
  152.         $count = 0;
  153.         mysqli_select_db ($conn, $dbname);
  154.         $result = mysqli_query ($conn, "select * from trans ORDER BY date DESC");
  155.         while ($row = mysqli_fetch_array ($result)) {
  156.             $count++;
  157.             if($count != 0)
  158.             $peid = $row['id'];
  159.             $pename = getAccountName($peid, $conn, $dbname);
  160.             $damount = number_format($row['amount']);
  161.             $before = time()-$row['date'];
  162.             $before = intval($before/86400);
  163.             $dreason = $row['reason'];
  164.             echo '<tr>';
  165.             echo "<td>$pename</td>";
  166.             echo "<td>+$damount</td>";
  167.             echo "<td>$dreason</td>";
  168.             echo "<td>$before days</td>";
  169.             echo '</tr>';
  170.             $bbcode = $bbcode."-[color=white][b]$pename";
  171.             $bbcode = $bbcode."[/b][/color] has been given [color=green]$damount";
  172.             $bbcode = $bbcode."[/color] DSPP ($dreason)\n";
  173.         }
  174.         echo '</table>';
  175.         if($count == 0) echo "<font size=5>There are no transactions!</font>";
  176.         else echo "<center><textarea style='width:40%;' rows='5'>$bbcode</textarea>";
  177.         echo "<br><br>";
  178.         echo "<table style='width:30%'>";
  179.         echo '<tr>';
  180.         echo '<td><b>Name</b></td>';
  181.         echo '<td><b>Rank</b></td>';
  182.         echo '<td><b>Team</b></td>';
  183.         echo '<td><b>DSPP</b></td>';
  184.         echo "<th colspan='2'>Last DSPP Given</th>";
  185.         echo '</tr>';
  186.         mysqli_select_db ($conn, $dbname);
  187.         $result = mysqli_query($conn, "select * from accounts ORDER BY rank DESC");
  188.         while($row = mysqli_fetch_array ($result))
  189.         {
  190.             $bacc = $row['id'];
  191.             $team = $row['team'];
  192.             $name = $row['name'];
  193.             $dspp = $row['dspp'];
  194.             $rank = $row['rank'];
  195.             $lastdspp = $row['lastdspp'];
  196.             $lastreason = $row['lastreason'];
  197.             if($lastdspp == 0) $lastdspp = "-";
  198.             else $lastdspp = "+$lastdspp";
  199.             if($rank >= 7)
  200.             {
  201.                 $dspp = "-";
  202.                 $lastdspp = "-";
  203.                 $lastreason = "-";
  204.             }
  205.             if(calcRank($dspp) > $rank)
  206.             {
  207.                 $rank = getRankName($rank);
  208.                 $rank = "<font color='#238C00'>$rank</font>";
  209.             }
  210.             else $rank = getRankName($rank);
  211.             $team = getTeamName($team);
  212.            
  213.             echo '<tr>';
  214.             echo "<td>$name</td>";
  215.             echo "<td>$rank</td>";
  216.             echo "<td>$team</td>";
  217.             echo "<td>$dspp</td>";
  218.             echo "<td>$lastdspp</td>";
  219.             echo "<td>$lastreason</td>";
  220.             echo '</tr>';
  221.         }
  222.         echo '</table>';
  223.         $count = 0;
  224.         echo "<br><b><font size=5>Last week promotions:</b></font>";
  225.         mysqli_select_db ($conn, $dbname);
  226.         $result = mysqli_query($conn, "select * from promotions");
  227.         while($row = mysqli_fetch_array ($result))
  228.         {
  229.             $count++;
  230.             if($count != 0)
  231.             $time = $row['time'];
  232.             if($time < time()-604800) continue;
  233.             $accid = $row['id'];
  234.             $oldrank = getRankName($row['oldrank']);
  235.             $newrank = getRankName($row['newrank']);
  236.             $name = getAccountName($accid, $conn, $dbname);
  237.             echo "<br>$name from $oldrank to $newrank!";
  238.             $bbcode2 = $bbcode2."-[color=white][b]$pename";
  239.             $bbcode2 = $bbcode2."[/b][/color] has been [color=green][b]PROMOTED.";
  240.             $bbcode2 = $bbcode2."[/b][/color]\n";
  241.         }
  242.         if($count != 0)echo "<center><textarea style='width:40%;' rows='5'>$bbcode2</textarea>";
  243.         else echo "<br><font size=5>There are no promotions!</font>";
  244.         $totaldspp = number_format(getAllDSPP($conn, $dbname));
  245.         echo "<br><b><font size=5><br>Total DSPP:</b>$totaldspp</font>";
  246.        
  247.         echo "<hr><div id='container'>
  248.         <form action='' method='post'>
  249.         <font size=4>Create new account:</font>
  250.         <br><input type='text' name='pname' placeholder='In-game Name' />
  251.         <br><input type='email' name='pemail' placeholder='Email Address' />
  252.         <br><input type='text' name='ppw' placeholder='Password' />
  253.         <br><br><input type='submit' name='create_button' value='Create account' />
  254.         </form></div><br><br>";
  255.        
  256.         echo "<div id='container'>
  257.         <form action='' method='post'>
  258.         <font size=4>Give DSPP:</font><br>
  259.         <input type='text' name='pename' placeholder='Name' />
  260.         <br><input type='number' name='dwamount' placeholder='Amount'/>
  261.         <br><input type='text' name='dwreason' placeholder='Reason'/>
  262.         <br><br><input type='submit' name='dspp_act' value='Add' />
  263.         </form></div><br><br>";
  264.        
  265.         echo "<div id='container'>
  266.         <form action='' method='post'>
  267.         <font size=4>Show Account Info:</font><br>
  268.         <input type='text' name='peename' placeholder='Name' />
  269.         <br><br><input type='submit' name='showinf' value='Show' />
  270.         </form></div><br><br>";
  271.        
  272.         echo "<div id='container'>
  273.         <form action='' method='post'>
  274.         <font size=4>Promote Member:</font><br>
  275.         <input type='text' name='peeeename' placeholder='Name' />
  276.         <br><br><input type='submit' name='ppromote' value='Promote' />
  277.         </form></div><br><br>";
  278.        
  279.         echo "<div id='container'>
  280.         <form action='' method='post'>
  281.         <font size=4>Set Team:</font><br><br>
  282.         Teams ID's:<br>
  283.         Supporter Team: 0
  284.         <br>Turfing Team: 1
  285.         <br>Events Team: 2
  286.         <br>Management: 3
  287.         <br><input type='text' name='peeeeename' placeholder='Name' />
  288.         <br><input type='text' name='pteam' placeholder='Team ID' />
  289.         <br><br><input type='submit' name='steam' value='Set Team' />
  290.         </form></div><br><br>";
  291.        
  292.         echo "<div id='container'>
  293.         <form action='' method='post'>
  294.         <font size=4>Set Rank:</font><br><br>
  295.         Ranks ID's:<br>
  296.         Trainee: 0
  297.         <br>Rookie: 1
  298.         <br>Competant: 2
  299.         <br>Skilled: 3
  300.         <br>Advanced: 4
  301.         <br>Expert: 5
  302.         <br>Master: 6
  303.         <br>Veteran: 7
  304.         <br>Supervisor: 8
  305.         <br>Head: 9
  306.         <br><input type='text' name='peeeeeename' placeholder='Name' />
  307.         <br><input type='text' name='prank' placeholder='Rank ID' />
  308.         <br><br><input type='submit' name='srank' value='Set Rank' />
  309.         </form></div><br><br>";
  310.        
  311.         echo "<div id='container'>
  312.         <form action='' method='post'>
  313.         <font size=4>Change Account Password:</font><br>
  314.         <input type='text' name='peeename' placeholder='Name' />
  315.         <br><input type='text' name='bopw' placeholder='New Password'/>
  316.         <br><br><input type='submit' name='bochangepw' value='Change Password' />
  317.         </form></div><br><br>";
  318.     }
  319.     if(isset($_POST['bochangepw']))
  320.     {
  321.         if(empty($_POST["peeename"]))
  322.         {
  323.             echo "Name can't be empty.<br><br><br>";
  324.             return;
  325.         }
  326.         if(empty($_POST["bopw"]))
  327.         {
  328.             echo "New password can't be empty.<br><br><br>";
  329.             return;
  330.         }
  331.         if(isValidAccName($_POST["peeename"], $conn, $dbname) == -1)
  332.         {
  333.             echo "<b>[ERROR]</b> Invalid name.";
  334.             return;
  335.         }
  336.         $dename = $_POST["peeename"];
  337.         $baccid = isValidAccName($_POST["peeename"], $conn, $dbname);
  338.         $baccpw = $_POST["bopw"];
  339.         setAccPassword($baccid, $baccpw, $conn, $dbname);
  340.         $_SESSION["sstarted"] = true;
  341.         echo "You've successfully changed the password of $dename to $baccpw";
  342.         return;
  343.     }
  344.     if(isset($_POST['create_button']))
  345.     {
  346.         if(empty($_POST["pname"]))
  347.         {
  348.             echo "In-game name can't be empty.<br><br><br>";
  349.             return;
  350.         }
  351.         if(empty($_POST["ppw"]))
  352.         {
  353.             echo "Password can't be empty.<br><br><br>";
  354.             return;
  355.         }
  356.         if(empty($_POST["pemail"]))
  357.         {
  358.             echo "Email Address can't be emtpy.<br><br><br>";
  359.             return 1;
  360.         }
  361.         $pname = $_POST["pname"];
  362.         if(isValidSFCNRAcc($pname) == 0)
  363.         {
  364.             echo "<b>[ERROR]</b> Invalid player account name.<br><br><br>";
  365.             return;
  366.         }
  367.        
  368.         if(isValidAccName($pname, $conn, $dbname) != -1) {
  369.             echo "<b>[ERROR]</b> This account is already registered.<br><br><br>";
  370.             return;
  371.         }
  372.         $quickname = $_POST["pname"];
  373.         $quickpw = $_POST["ppw"];
  374.         $email = $_POST["pemail"];
  375.         $joinedat = time();
  376.         mysqli_query($conn, "INSERT INTO accounts (name, password, email, joinedat) VALUES ('$quickname', '$quickpw', '$email', '$joinedat')");
  377.         $bacc = mysqli_insert_id($conn);
  378.         echo "Account ID: $bacc";
  379.         echo "<br>Player name: $quickname";
  380.         echo "<br>Password: $quickpw";
  381.         echo "<br>Email: $email";
  382.         echo "<br>Account was successfully registered!";
  383.     }
  384.     if(isset($_POST['dspp_act']))
  385.     {
  386.         if(empty($_POST["pename"]))
  387.         {
  388.             echo "<b>[ERROR]</b> You must enter a name.";
  389.             return;
  390.         }
  391.         if(empty($_POST["dwamount"]))
  392.         {
  393.             echo "<b>[ERROR]</b> You must enter an amount.";
  394.             return;
  395.         }
  396.         if(empty($_POST["dwreason"]))
  397.         {
  398.             echo "<b>[ERROR]</b> You must enter a reason.";
  399.             return;
  400.         }
  401.         if($_POST["dwamount"] == 0)
  402.         {
  403.             echo "<b>[ERROR]</b> Amount can't be 0.";
  404.             return;
  405.         }
  406.         $pname = $_POST["pename"];
  407.         if(IsValidAccName($pname, $conn, $dbname) == -1)
  408.         {
  409.                 echo "<b>[ERROR]</b> Invalid account name.";
  410.                 return;
  411.         }
  412.         if($_POST['dwamount'] < 0)
  413.         {
  414.             echo "<b>[ERROR]</b> Invalid amount.";
  415.             return;
  416.         }
  417.         $pname = IsValidAccName($_POST["pename"], $conn, $dbname);
  418.         $dspp = $_POST['dwamount'];
  419.         $reason = $_POST['dwreason'];
  420.         $detime = time();
  421.         mysqli_query($conn, "INSERT INTO trans (id, amount, reason, date) VALUES ('$pname', '$dspp', '$reason', '$detime')");
  422.         giveAccDSPP($pname, $dspp, $reason, $conn, $dbname);
  423.         echo "NAME: $pname || AMOUNT: $dspp || REASON: $reason<br>";
  424.         echo "DSPP were added.";
  425.     }
  426.     if(isset($_POST['showinf']))
  427.     {
  428.         if(empty($_POST["peename"]))
  429.         {
  430.             echo "Name can't be empty!<br><br><br>";
  431.             return;
  432.         }
  433.         if(isValidAccName($_POST["peename"], $conn, $dbname) == -1)
  434.         {
  435.             echo "<b>[ERROR]</b> Invalid name";
  436.             return;
  437.         }
  438.         $sbankid = isValidAccName($_POST["peename"], $conn, $dbname);
  439.         showAccountInfo($sbankid, $conn, $dbname);
  440.     }
  441.     if(isset($_POST['ppromote']))
  442.     {
  443.         if(empty($_POST["peeeename"]))
  444.         {
  445.             echo "Name can't be empty!<br><br><br>";
  446.             return;
  447.         }
  448.         if(isValidAccName($_POST["peeeename"], $conn, $dbname) == -1)
  449.         {
  450.             echo "<b>[ERROR]</b> Invalid name";
  451.             return;
  452.         }
  453.         $peid = isValidAccName($_POST["peeeename"], $conn, $dbname);
  454.         $dspp = getAccDSPP($peid, $conn, $dbname);
  455.         $rank = getAccRank($peid, $conn, $dbname);
  456.         if(calcRank($dspp) < $rank+1)
  457.         {
  458.             echo "<b>[ERROR]</b> No enough DSPP.";
  459.             return;
  460.         }
  461.         $hisname = $_POST["peeeename"];
  462.         $newrank = $rank+1;
  463.         PromoteAcc($peid, $rank, $newrank, $conn, $dbname);
  464.         $newrank = getRankName($newrank);
  465.         $rank = getRankName($rank);
  466.         echo "You've successfully promoted $hisname from $rank to $newrank!";
  467.     }
  468.     if(isset($_POST['steam']))
  469.     {
  470.         if(empty($_POST["peeeeename"]))
  471.         {
  472.             echo "Name can't be empty!<br><br><br>";
  473.             return;
  474.         }
  475.         if(empty($_POST["pteam"]) && $_POST["pteam"] != 0)
  476.         {
  477.             echo "Team ID can't be empty!<br><br><br>";
  478.             return;
  479.         }
  480.         if(isValidAccName($_POST["peeeeename"], $conn, $dbname) == -1)
  481.         {
  482.             echo "<b>[ERROR]</b> Invalid name";
  483.             return;
  484.         }
  485.         $teamid = $_POST["pteam"];
  486.         if($teamid < 0 || $teamid > 3)
  487.         {
  488.             echo "Invalid team ID.<br><br><br>";
  489.             return;
  490.         }
  491.         $hisname = $_POST["peeeeename"];
  492.         $peid = isValidAccName($_POST["peeeeename"], $conn, $dbname);
  493.         $teamname = getTeamName($_POST["pteam"]);
  494.         setAccTeam($peid, $teamid, $conn, $dbname);
  495.         echo "You've set $hisname's team to $teamname!";
  496.     }
  497.     if(isset($_POST['srank']))
  498.     {
  499.         if(empty($_POST["peeeeeename"]))
  500.         {
  501.             echo "Name can't be empty!<br><br><br>";
  502.             return;
  503.         }
  504.         if(empty($_POST["prank"]) && $_POST["prank"] != 0)
  505.         {
  506.             echo "Rank ID can't be empty!<br><br><br>";
  507.             return;
  508.         }
  509.         if(isValidAccName($_POST["peeeeeename"], $conn, $dbname) == -1)
  510.         {
  511.             echo "<b>[ERROR]</b> Invalid name";
  512.             return;
  513.         }
  514.         $rankid = $_POST["prank"];
  515.         if($rankid < 0 || $rankid > 9)
  516.         {
  517.             echo "Invalid rank ID.<br><br><br>";
  518.             return;
  519.         }
  520.         $hisname = $_POST["peeeeeename"];
  521.         $peid = isValidAccName($_POST["peeeeeename"], $conn, $dbname);
  522.         $rankname = getRankName($_POST["prank"]);
  523.         setAccRank($peid, $rankid, $conn, $dbname);
  524.         echo "You've set $hisname's rank to $rankname!";
  525.     }
  526.     function setAccPassword($baccf, $passwordf, $connf, $dbnamef)
  527.     {
  528.         $thetime = time();
  529.         $sql = "UPDATE accounts SET password='$passwordf', lastpasswordchange='$thetime' WHERE id=$baccf";
  530.         if(mysqli_query($connf, $sql)){
  531.             echo "<br>Settings were updated successfully.<br>";
  532.         }
  533.         else
  534.         {
  535.             echo "<br>ERROR: Could not able to execute $sql. <br>" . mysqli_error($connf)."<br>";
  536.         }
  537.     }
  538.     function getLastPwChange($baccf, $connf, $dbnamef)
  539.     {
  540.         if(isValidAccount($baccf, $connf, $dbnamef) == 0) return -1;
  541.         $result = mysqli_query ($connf, "select lastpasswordchange from accounts where id = $baccf");
  542.         while ($row = mysqli_fetch_array ($result)) {
  543.             $lastpasswordchange = $row['lastpasswordchange'];
  544.         }
  545.         return $lastpasswordchange;
  546.     }
  547.     function getAllDSPP($connf, $dbnamef)
  548.     {
  549.         $totaldspp = 0;
  550.         mysqli_select_db ($connf, $dbnamef);
  551.         $result = mysqli_query ($connf, "select * from accounts WHERE dspp > 0");
  552.         while ($row = mysqli_fetch_array ($result)) {
  553.             $dspp = $row['dspp'];
  554.             $totaldspp = $totaldspp+$dspp;
  555.         }
  556.         return $totaldspp;
  557.     }
  558.     function isValidOwnerID($baccf, $connf, $dbnamef)
  559.     {
  560.         $countf = 0;
  561.         mysqli_select_db ($connf, $dbnamef);
  562.         $result = mysqli_query ($connf, "select * from accounts where accid = $baccf");
  563.         while ($row = mysqli_fetch_array ($result)) {
  564.             $countf++;
  565.         }
  566.         if($countf == 0) return 0;
  567.         return 1;
  568.     }
  569.     function isValidAccName($baccf, $connf, $dbnamef)
  570.     {
  571.         $countf = 0;
  572.         mysqli_select_db ($connf, $dbnamef);
  573.         $result = mysqli_query ($connf, "select * from accounts where name='$baccf'");
  574.         while ($row = mysqli_fetch_array ($result)) {
  575.             $countf++;
  576.             $accid = $row['id'];
  577.         }
  578.         if($countf == 0) return -1;
  579.         return $accid;
  580.     }
  581.     function getAccountName($baccf, $connf, $dbnamef)
  582.     {
  583.         if(IsValidAccount($baccf, $connf, $dbnamef) == 0) return -1;
  584.         $result = mysqli_query ($connf, "select * from accounts where id = $baccf");
  585.         while ($row = mysqli_fetch_array ($result)) {
  586.             $namef = $row['name'];
  587.         }
  588.         return $namef;
  589.     }
  590.     function isValidSFCNRAcc($accidf)
  591.     {
  592.         $url = "http://sfcnr.com/sig/$accidf";
  593.         $handle = curl_init($url);
  594.         curl_setopt($handle,  CURLOPT_RETURNTRANSFER, TRUE);
  595.  
  596.         /* Get the HTML or whatever is linked in $url. */
  597.         $response = curl_exec($handle);
  598.  
  599.         /* Check for 404 (file not found). */
  600.         $httpCode = curl_getinfo($handle, CURLINFO_HTTP_CODE);
  601.         if($httpCode == 404) $returnvalue = 0;
  602.         else $returnvalue = 1;
  603.         curl_close($handle);
  604.         return $returnvalue;
  605.     }
  606.     function isValidAccount($baccf, $connf, $dbnamef)
  607.     {
  608.         $countf = 0;
  609.         mysqli_select_db ($connf, $dbnamef);
  610.         $result = mysqli_query ($connf, "select * from accounts where id = $baccf");
  611.         while ($row = mysqli_fetch_array ($result)) {
  612.             $countf++;
  613.         }
  614.         if($countf == 0) return 0;
  615.         return 1;
  616.     }
  617.     function getAccDSPP($baccf, $connf, $dbnamef)
  618.     {
  619.         if(IsValidAccount($baccf, $connf, $dbnamef) == 0) return -1;
  620.         $result = mysqli_query ($connf, "select dspp from accounts where id = $baccf");
  621.         while ($row = mysqli_fetch_array ($result)) {
  622.             $dspp = $row['dspp'];
  623.         }
  624.         return $dspp;
  625.     }
  626.     function getAccRank($baccf, $connf, $dbnamef)
  627.     {
  628.         if(IsValidAccount($baccf, $connf, $dbnamef) == 0) return -1;
  629.         $result = mysqli_query ($connf, "select rank from accounts where id = $baccf");
  630.         while ($row = mysqli_fetch_array ($result)) {
  631.             $rankf = $row['rank'];
  632.         }
  633.         return $rankf;
  634.     }
  635.     function giveAccDSPP($baccf, $dsppf, $thereasonf, $connf, $dbnamef)
  636.     {
  637.         if(IsValidAccount($baccf, $connf, $dbnamef) == 0) return -1;
  638.         $dspp = getAccDSPP($baccf, $connf, $dbnamef);
  639.         $dspp = $dspp+$dsppf;
  640.         setAccDSPP($baccf, $dspp, $thereasonf, $connf, $dbnamef);
  641.     }
  642.     function getAccTeam($baccf, $connf, $dbnamef)
  643.     {
  644.         if(IsValidAccount($baccf, $connf, $dbnamef) == 0) return -1;
  645.         $result = mysqli_query ($connf, "select team from accounts where id = $baccf");
  646.         while ($row = mysqli_fetch_array ($result)) {
  647.             $teamf = $row['team'];
  648.         }
  649.         return $teamf;
  650.     }
  651.     function setAccDSPP($baccf, $dsppf, $thereasonf, $connf, $dbnamef)
  652.     {
  653.         if(isValidAccount($baccf, $connf, $dbnamef) == 0) return -1;
  654.         $diff = $dsppf-getAccDSPP($baccf, $connf, $dbname);
  655.         mysqli_query($connf, "UPDATE accounts SET dspp=$dsppf, lastdspp=$diff, lastreason='$thereasonf' WHERE id=$baccf");
  656.     }
  657.     function setAccTeam($baccf, $teamf, $connf, $dbnamef)
  658.     {
  659.         if(isValidAccount($baccf, $connf, $dbnamef) == 0) return -1;
  660.         mysqli_query($connf, "UPDATE accounts SET team=$teamf WHERE id=$baccf");
  661.     }
  662.     function setAccRank($baccf, $rankf, $connf, $dbnamef)
  663.     {
  664.         if(isValidAccount($baccf, $connf, $dbnamef) == 0) return -1;
  665.         mysqli_query($connf, "UPDATE accounts SET rank=$rankf WHERE id=$baccf");
  666.     }
  667.     function PromoteAcc($baccf, $oldrank, $newrank, $connf, $dbnamef)
  668.     {
  669.         if(isValidAccount($baccf, $connf, $dbnamef) == 0) return -1;
  670.         $detime = time();
  671.         mysqli_query($connf, "INSERT INTO promotions (id, oldrank, newrank, time) VALUES ('$baccf', '$oldrank', '$newrank', '$detime')");
  672.         mysqli_query($connf, "UPDATE accounts SET rank=$newrank WHERE id=$baccf");
  673.     }
  674.     function getAccIngameAccID($baccf, $connf, $dbnamef)
  675.     {
  676.         if(isValidAccount($baccf, $connf, $dbnamef) == 0) return -1;
  677.         $result = mysqli_query ($connf, "select accid from accounts where id = $baccf");
  678.         while ($row = mysqli_fetch_array ($result)) {
  679.             $accidf = $row['accid'];
  680.         }
  681.         return $accidf;
  682.     }
  683.     function getAccIngameName($baccf, $connf, $dbnamef)
  684.     {
  685.         if(isValidAccount($baccf, $connf, $dbnamef) == 0) return -1;
  686.         $result = mysqli_query ($connf, "select name from accounts where id = $baccf");
  687.         while ($row = mysqli_fetch_array ($result)) {
  688.             $namef = $row['name'];
  689.         }
  690.         return $namef;
  691.     }
  692.     function getAccEmail($baccf, $connf, $dbnamef)
  693.     {
  694.         if(isValidAccount($baccf, $connf, $dbnamef) == 0) return -1;
  695.         $result = mysqli_query ($connf, "select * from accounts where id = $baccf");
  696.         while ($row = mysqli_fetch_array ($result)) {
  697.             $emailfs = $row['email'];
  698.         }
  699.         return $emailfs;
  700.     }
  701.     function calcRank($dspp)
  702.     {
  703.         $rank;
  704.         switch(true)
  705.         {
  706.             case ($dspp >= 0 && $dspp < 100):
  707.                 $rank = 0;
  708.                 return;
  709.             case ($dspp >= 100 && $dspp < 250):
  710.                 $rank = 1;
  711.                 break;
  712.             case ($dspp >= 250 && $dspp < 500):
  713.                 $rank = 2;
  714.                 break;
  715.             case ($dspp >= 500 && $dspp < 650):
  716.                 $rank = 3;
  717.                 break;
  718.             case ($dspp >= 650 && $dspp < 800);
  719.                 $rank = 4;
  720.                 break;
  721.             case ($dspp >= 800 && $dspp < 1000):
  722.                 $rank = 5;
  723.                 break;
  724.             case ($dspp >= 1000 && $dspp < 2000):
  725.                 $rank = 6;
  726.                 break;
  727.             case ($dspp >= 2000 && $dspp < 3000):
  728.                 $rank = 7;
  729.                 break;
  730.             case ($dspp >= 3000 && $dspp < 4000):
  731.                 $rank = 8;
  732.                 break;
  733.             case ($dspp >= 4000):
  734.                 $rank = 9;
  735.                 break;
  736.             default:
  737.                 $rank = -1;
  738.                 break;
  739.         }
  740.         return $rank;
  741.     }
  742.     function getRankName($rank)
  743.     {
  744.         $rankf;
  745.         switch($rank)
  746.         {
  747.             case 0:
  748.                 $rankf = "Trainee";
  749.                 break;
  750.             case 1:
  751.                 $rankf = "Rookie";
  752.                 break;
  753.             case 2:
  754.                 $rankf = "Competant";
  755.                 break;
  756.             case 3:
  757.                 $rankf = "Skilled";
  758.                 break;
  759.             case 4:
  760.                 $rankf = "Advanced";
  761.                 break;
  762.             case 5:
  763.                 $rankf = "Expert";
  764.                 break;
  765.             case 6:
  766.                 $rankf = "Master";
  767.                 break;
  768.             case 7:
  769.                 $rankf = "Veteran";
  770.                 break;
  771.             case 8:
  772.                 $rankf = "Supervisor";
  773.                 break;
  774.             case 9:
  775.                 $rankf = "Head";
  776.                 break;
  777.             default:
  778.                 $rankf = "Unkown Rank!";
  779.                 break;
  780.         }
  781.         return $rankf;
  782.     }
  783.     function getTeamName($rank)
  784.     {
  785.         $teamf;
  786.         switch($rank)
  787.         {
  788.             case 0:
  789.                 $teamf = "Support Team";
  790.                 break;
  791.             case 1:
  792.                 $teamf = "Turfing Team";
  793.                 break;
  794.             case 2:
  795.                 $teamf = "Events Team";
  796.                 break;
  797.             case 3:
  798.                 $teamf = "Management";
  799.                 break;
  800.             default:
  801.                 $teamf = "-";
  802.                 break;
  803.         }
  804.         return $teamf;
  805.     }
  806.     function showAccountInfo($baccf, $connf, $dbnamef)
  807.     {
  808.         if(isValidAccount($baccf, $connf, $dbnamef) == 0) return -1;
  809.        
  810.         $igname = getAccIngameName($baccf, $connf, $dbnamef);
  811.         $igaccid = getAccIngameAccID($baccf, $connf, $dbnamef);
  812.         $emailad = getAccEmail($baccf, $connf, $dbnamef);
  813.         $dspp = getAccDSPP($baccf, $connf, $dbnamef);
  814.         $rank = getAccRank($baccf, $connf, $dbnamef);
  815.         $rank = getRankName($rank);
  816.         $team = getAccTeam($baccf, $connf, $dbnamef);
  817.         $team = getTeamName($team);
  818.         echo "<center><h1>Account $baccf:</h1>";
  819.         echo "<div id='container' align='left'>";
  820.         echo "<font size=5 color=white><b>In-game name:</b> $igname";
  821.         echo "<br><b>Rank:</b> $rank";
  822.         echo "<br><b>Team:</b> $team";
  823.         echo "<br><b>Email Address:</b> $emailad";
  824.         echo "<br><b>DSPP:</b> $dspp";
  825.         echo "</div></font>";
  826.     }
  827.     echo time();
  828.     mysqli_close ($conn);
  829.     ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!