Untitled

//start joinmsg.php

<?php
include("../common_mysql.php");
if (isset($_GET["steamid"])){
    $q = mysql_query("SELECT * FROM player_joinsounds WHERE steamid='" . mysql_real_escape_string($_GET["steamid"]) ."' LIMIT 1");
    if ($r = mysql_fetch_assoc($q)){
        print($r["msg"]);
    }
}
?>

//end joinmsg.php
//start joinsound.php

<?php
include("../common_mysql.php");
if (isset($_GET["steamid"])){
    $q = mysql_query("SELECT * FROM player_joinsounds WHERE steamid='" . mysql_real_escape_string($_GET["steamid"]) ."' LIMIT 1");
    if ($r = mysql_fetch_assoc($q)){
        $sound = "sounds/".$r["sound"];
    }
}
?>
<html>
    <head>
        <script type="text/javascript" src="audio-player.js"></script>
        <script type="text/javascript">
            AudioPlayer.setup("player.swf", {
            width: 290,
            animation: "no",
            autostart: "yes",
            remaining: "yes",
            initialvolume: 100
            });
        </script>
    </head>
    <body>
        <p id="audioplayer_1">Songs</p>
        <script type="text/javascript">
            AudioPlayer.embed("audioplayer_1", {soundFile: "<?php echo $sound;?>"});
        </script>
    </body>
</html>