Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- ini_set('display_errors', 1);
- ini_set('display_startup_errors', 1);
- ini_set('memory_limit', '1024M');
- error_reporting(E_ALL);
- $servername = "localhost";
- $username = "_North";
- $password = "APTR150s";
- $dbname = "4cc";
- $DB = new mysqli($servername, $username, $password, $dbname);
- if(!isset($_GET['cup'])){
- $cup = 39;
- } else {
- $cup = $_GET['cup'];
- }
- if(isset($_POST['name'])){
- if(substr($_POST['players'],strlen($_POST['players'])-1) == ',')
- $_POST['players'] = substr($_POST['players'],0,strlen($_POST['players'])-1);
- $sql = $DB->prepare("INSERT INTO FantasyDB (iCupID,sName) VALUES(" . $_POST['cup'] . ", ?)");
- $sql->bind_param("s",$_POST['name']);
- $sql->execute();
- $query = "SELECT iID FROM FantasyDB ORDER BY iID DESC LIMIT 1";
- $sql = $DB->query($query);
- while ($row = $sql->fetch_assoc()){
- $id = $row['iID'];
- }
- $row2s = explode(",",$_POST['players']);
- $start = 1;
- foreach($row2s as $row2){
- if($row2 == 'b'){
- $start = 0;
- } else {
- switch(substr($row2,0,1)){
- case "c":
- $cap = 2;
- $row2 = substr($row2,1);
- break;
- case "v":
- $cap = 1;
- $row2 = substr($row2,1);
- break;
- default:
- $cap = 0;
- }
- $query = "INSERT INTO FantasyPDB (bStart,iFFID,iPlayerID,iCap) VALUES($start, $id,$row2,$cap)";
- $DB->query($query);
- }
- }
- } elseif(isset($_GET['wiki'])){
- $sql = $DB->query("SELECT * FROM FantasyDB WHERE iCupID=$cup ORDER BY iID");
- echo "<plaintext>";
- while($ff = $sql->fetch_assoc()){
- $start = array();
- $startOrder = array();
- $bench = array();
- $benchOrder = array();
- $cap = 0;
- $vice = 0;
- $id = $ff['iID'];
- $name = $ff['sName'];
- $sql2 = $DB->query("SELECT * FROM FantasyPDB INNER JOIN PlayerDB ON FantasyPDB.iPlayerID = PlayerDB.iID INNER JOIN RosterOrderLookUp ON PlayerDB.sRegPos = RosterOrderLookUp.sPos WHERE iFFID = $id ORDER BY bStart DESC, iOrder, sName");
- echo "
- <div class='toccolours mw-collapsible mw-collapsed' style='width:720px'>
- '''$name'''
- <div class='mw-collapsible-content'>
- {{sq ff start}}";
- while($ffP = $sql2->fetch_assoc()){
- switch($ffP['sRegPos']){
- case "GK":
- $pos = "GK";
- break;
- case "LB":
- case "CB":
- case "SW":
- case "SB":
- case "RB":
- $pos = "DEF";
- break;
- case "DMF":
- case "CMF":
- case "SMF":
- case "LMF":
- case "RMF":
- case "AMF":
- $pos = "MID";
- break;
- case "LWF":
- case "RWF":
- case "SS":
- case "CF":
- $pos = "FWD";
- break;
- }
- switch($ffP['sMedal']){
- case "Gold":
- $med = 3;
- break;
- case "Silver":
- $med = 2;
- break;
- case "Bronze":
- $med = 1;
- break;
- default:
- $med = 0;
- break;
- }
- if($ffP['bStart'] == 1){
- $start[$ffP['iPlayerID']] = array(0,-99,$pos,0,$med,$ffP['sRegPos'],$ffP['sTeam'],$ffP['sName']);
- $startOrder[] = $ffP['iPlayerID'];
- } else {
- $bench[$ffP['iPlayerID']] = array(0,-99,$pos,-99,$med,$ffP['sRegPos'],$ffP['sTeam'],$ffP['sName']);
- $benchOrder[] = $ffP['iPlayerID'];
- }
- if ($ffP['iCap']==1)
- $vice = $ffP['iPlayerID'];
- if ($ffP['iCap']==2)
- $cap = $ffP['iPlayerID'];
- }
- $sql2 = $DB->query("SELECT * FROM MatchDB WHERE iCupID=$cup ORDER BY dUTCTime");
- while($match = $sql2->fetch_assoc()){
- $sql3 = $DB->query("SELECT * FROM PerformanceDB WHERE iMatchID=" . $match['iID']);
- $capP = false;
- foreach($start as $player=>$arr){
- $start[$player][1] = -99;
- }
- foreach($bench as $player=>$arr){
- $bench[$player][1] = -99;
- $bench[$player][3] = -99;
- }
- while($perf = $sql3->fetch_assoc()){
- if(isset($start[$perf['iPlayerID']]))
- $start[$perf['iPlayerID']][1] = $perf['iFF'];
- }
- foreach($start as $player=>$arr){
- if($player == $cap && $start[$player][1] > -99){
- $start[$player][1] *= 2;
- $capP = true;
- }
- }
- foreach($bench as $player=>$arr){
- if($player == $cap && $bench[$player][1] > -99){
- $bench[$player][1] *= 2;
- $capP = true;
- }
- }
- if(!$capP){
- foreach($start as $player=>$arr){
- if($player == $vice && $start[$player][1] > -99)
- $start[$player][1] *= 2;
- }
- foreach($bench as $player=>$arr){
- if($player == $vice && $bench[$player][1] > -99)
- $bench[$player][1] *= 2;
- }
- }
- foreach($start as $player=>$arr){
- if($arr[1] == -99){
- foreach($bench as $player2=>$arr2){
- if($arr[3] == -99 && $arr[2] == $arr2[2] && $arr2[4] <= $arr[4]){
- $bench[$player2][3] = $bench[$player2[1]];
- break;
- }
- }
- } else {
- $start[$player][0] += $arr[1];
- }
- }
- foreach($bench as $player=>$arr){
- $bench[$player][1] = $arr[3];
- if($arr[1] > -99)
- $bench[$player][0] += $arr[1];
- }
- }
- foreach($startOrder as $i){
- echo "
- {{sq ff ";
- if($start[$i][4] == 3)
- echo "gold ";
- if($start[$i][4] == 2)
- echo "silver ";
- if($start[$i][4] == 1)
- echo "bronze ";
- if($start[$i][4] == 0)
- echo "start ";
- echo "player |team=" . $start[$i][6] . " |pos=" . $start[$i][5] . " |name=" . $start[$i][7];
- if ($i == $vice)
- echo " {{vice-captain}}";
- if ($i = $cap)
- echo " {{captain}}";
- echo " |lastscore=0 |totalscore=" . $start[$i][0] . " }}";
- print_r($start[$i]);
- }
- echo "
- {{sq ff mid}}";
- foreach($benchOrder as $i){
- echo "
- {{sq ff ";
- if($bench[$i][4] == 3)
- echo "gold ";
- if($bench[$i][4] == 2)
- echo "silver ";
- if($bench[$i][4] == 1)
- echo "bronze ";
- echo "player |team=" . $bench[$i][6] . " |pos=" . $bench[$i][5] . " |name=" . $bench[$i][7];
- if ($i == $vice)
- echo " {{vice-captain}}";
- if ($i == $cap)
- echo " {{captain}}";
- echo " |lastscore=0 |totalscore=" . $bench[$i][0] . " }}";
- }
- echo "
- {{sq ff end}}</div>
- </div>";
- }
- } elseif(isset($_GET['string'])){
- $query = "SELECT * FROM FantasyDB WHERE iCupID = $cup ORDER BY iID";
- $sql = $DB->query($query);
- while ($row = $sql->fetch_assoc()){
- $id = $row['iID'];
- echo $row['sName'] . "<br>";
- $query = "SELECT * FROM FantasyPDB INNER JOIN PlayerDB ON FantasyPDB.iPlayerID = PlayerDB.iID INNER JOIN RosterOrderLookUp ON PlayerDB.sRegPos = RosterOrderLookUp.sPos WHERE iFFID = $id ORDER BY bStart DESC, iOrder, sName";
- $b = 0;
- $sql2 = $DB->query($query);
- while($row2 = $sql2->fetch_assoc()){
- if($row2['iCap']==1)
- echo "v";
- if($row2['iCap']==2)
- echo "c";
- if($row2['bStart']==0 && $b == 0){
- echo "b,";
- $b = 1;
- }
- echo $row2['iPlayerID'] . ",";
- }
- echo "<br>";
- }
- }
- ?>
- <form action='wiki.php' method='post'>
- Name <input name='name'><br>
- Players <input name='players'><br>
- Cup <input name='cup' value=39><br>
- <input type='submit'>
- </form>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement