Here is the code below... I only put 4 users in, but you can copy and paste the code for any additional users you want. Just follow the same outline to get certain members from database.
scroll.php or place it in your main document head/page:
Code: Select all
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Mafia Wars Kingdom</title>
<link rel="icon" href="favicon.ico" type="image/x-icon">
<link rel="stylesheet" href="style/style.css">
<style type="text/css" media="screen">
#showlist {
background-color:black;
width:150px;
height:auto;
border:#000000 solid 2px;
text-align:center;
vertical-align: top;
}
#showlist p {
display:none;
color:red;
}
</style>
<style type="text/css" media="print">
#showlist {
display:none;
}
</style>
<script type="text/javascript" src="http://code.jquery.com/jquery-latest.min.js"></script>
<script type="text/javascript">
$(document).ready(function(){
$("#top15").load("toplist.php",function(){
playerlist = $("p.top15");
var topplayers = Math.floor( Math.random() * playerlist.length );
playerlist.eq(topplayers).addClass("list");
fadeIt();
})
});
function fadeIt(){
$(".list").fadeIn(600).delay(5000).fadeOut(600, function(){
$(this).removeClass("list");
$(this).next("p.top15").addClass("list");
if($(".list").length==0) $("p.top15:first").addClass("list");
fadeIt();
});
}
</script>
</head>
<body>
<div id="showlist"><center><font color="white">Top Players</font></center>
<div id="top15">
</div>
</div>
</body>
</html>
Code: Select all
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Mafia Wars Kingdom</title>
<link rel="icon" href="favicon.ico" type="image/x-icon">
<link rel="stylesheet" href="style/style.css">
<?php /*?> DATABASE CONNECTION <?php */?>
<?php
$db_conx = mysqli_connect("localhost", "root", "password", "database name");
// Evaluate the connection
if (mysqli_connect_errno()) {
echo mysqli_connect_error();
exit();
}// else {
//echo "Successful database connection!!!";
//}
?>
<?php /*?> PLAYER ONE DATABASE CODE <?php */?>
<?php
$selectplayer ="SELECT username, id FROM users ORDER BY strength DESC limit 1";
$user_query = mysqli_query($db_conx, $selectplayer);
while ($row = mysqli_fetch_array($user_query, MYSQLI_ASSOC)) {
$get_player = "SELECT `username` FROM `users` WHERE `id`='".$row['id']."'";
$user_query1 = mysqli_query($db_conx, $get_player);
$numrows = mysqli_num_rows($user_query1);
$rank_name = mysqli_fetch_assoc($user_query1);
$firstname = $row["username"];
$player1 = $row['username'] +1;
?>
<p class="top15">
<?php $player1 .= " $firstname";
echo $player1; ?>
</p>
<?php /*?> PLAYER TWO DATABASE CODE <?php */?>
<?php
$selectplayer ="SELECT username, id FROM users ORDER BY strength DESC limit 2,1";
$user_query = mysqli_query($db_conx, $selectplayer);
while ($row = mysqli_fetch_array($user_query, MYSQLI_ASSOC)) {
$get_player = "SELECT `username` FROM `users` WHERE `id`='".$row['id']."'";
$user_query1 = mysqli_query($db_conx, $get_player);
$numrows = mysqli_num_rows($user_query1);
$rank_name = mysqli_fetch_assoc($user_query1);
$firstname = $row["username"];
$player2 = $row['username'] +2;
?>
<p class="top15">
<?php $player2 .= " $firstname";
echo $player2; ?>
</p>
<?php /*?> PLAYER THREE DATABASE CODE <?php */?>
<?php
$selectplayer ="SELECT username, id FROM users ORDER BY strength DESC limit 3,1";
$user_query = mysqli_query($db_conx, $selectplayer);
while ($row = mysqli_fetch_array($user_query, MYSQLI_ASSOC)) {
$get_player = "SELECT `username` FROM `users` WHERE `id`='".$row['id']."'";
$user_query1 = mysqli_query($db_conx, $get_player);
$numrows = mysqli_num_rows($user_query1);
$rank_name = mysqli_fetch_assoc($user_query1);
$firstname = $row["username"];
$player3 = $row['username'] +3;
?>
<p class="top15">
<?php $player3 .= " $firstname";
echo $player3; ?>
</p>
<?php /*?> PLAYER FOUR DATABASE CODE <?php */?>
<?php
$selectplayer ="SELECT username, id FROM users ORDER BY strength DESC limit 4,1";
$user_query = mysqli_query($db_conx, $selectplayer);
while ($row = mysqli_fetch_array($user_query, MYSQLI_ASSOC)) {
$get_player = "SELECT `username` FROM `users` WHERE `id`='".$row['id']."'";
$user_query1 = mysqli_query($db_conx, $get_player);
$numrows = mysqli_num_rows($user_query1);
$rank_name = mysqli_fetch_assoc($user_query1);
$firstname = $row["username"];
$player4 = $row['username'] +4;
?>
<p class="top15">
<?php $player4 .= " $firstname";
echo $player4; ?>
</p>
<?php /*?> ALL THE ENDING BRACKET THINGIES TO CLOSE IT ALL OUT <?php */?>
<?php
}}}}
?>
I hope someone finds it useful