num_rows; if($rowcount > 0) { $passi_numer_dy = hash('whirlpool', $password); $passi_numer_dy = strtoupper($passi_numer_dy); $passi = $result2['Password']; $adminlevel = $result2['Admin']; $useridja = $result2['ID']; $emaili = $result2['Email']; $namech = $result2['Namechanges']; $phonech = $result2['Phonechanges']; $discordauth = $result2['Discord']; $forumauth = $result2['Forum']; $donaterank = $result2['DonateRank']; $quiz = $result2['Quiz']; mysqli_free_result($result); $user_check_query = "SELECT reason, date FROM bans WHERE name = '$username' LIMIT 1"; $result = mysqli_query($link, $user_check_query); $rowcount = $result->num_rows; if($rowcount == 0) { if($passi_numer_dy == $passi) { $chars = array( array("N/A", -1, 0), array("N/A", -1, 0), array("N/A", -1, 0), array("N/A", -1, 0), array("N/A", -1, 0), array("N/A", -1, 0) ); $user_check_query = "SELECT ID, char_name, Model FROM characters WHERE master = '$useridja' LIMIT 6"; $result = mysqli_query($link, $user_check_query); $count = 0; while($result2 = mysqli_fetch_array($result, MYSQLI_ASSOC)) { $emri = $result2['char_name']; $playid = $result2['ID']; $Model = $result2['Model']; $chars[$count][0] = returnName($emri); $chars[$count][1] = $playid; $chars[$count][2] = $Model; $count++; } //mysqli_free_result($result); //if($count > 0) //{ //$averagehours = averageHours($link, $username); //} $averagehours = 0.0; $client_ip = returnIpAddress(); $client_browser = getBrowser(); $client_os = getOS(); $user_check_query = "INSERT INTO ucp_logins(User, IP, Browser, OS) VALUES ('$username', '$client_ip', '$client_browser', '$client_os')"; $result = mysqli_query($link, $user_check_query); $_SESSION['username'] = $username; $_SESSION['quiz'] = $quiz; $_SESSION['donaterank'] = $donaterank; $_SESSION['adminlevel'] = $adminlevel; $_SESSION['playersqlid'] = $useridja; $_SESSION['playeremail'] = $emaili; $_SESSION['namechanges'] = $namech; $_SESSION['phonechanges'] = $phonech; $_SESSION['characters'] = $chars; $_SESSION['discord_auth'] = $discordauth; $_SESSION['forum_auth'] = $forumauth; $_SESSION['averagehours'] = $averagehours; exit("true"); mysqli_free_result($result); mysqli_close($link); } else { mysqli_close($link); $gabim = "Invalid credentials given"; } } else { $BanData = mysqli_fetch_array($result, MYSQLI_ASSOC); mysqli_free_result($result); ?>