Okay
Find:
PHP Code:
$sidebar = "<b><u>".$loggedinname."'s Links:</u></b><br><br>
And put this ABOVE that
PHP Code:
$query222 = "SELECT * FROM ".$prefix."users WHERE username = '$loggedinname'";
$result222 = @mysql_query($query222);
$num222 = @mysql_numrows($result222);
//Loop out code
$i=0;
while ($i < 1) {
$coins=@mysql_result($result222,$i,"coins");
$i++;
}
Then at last you add the line that really shows it.
Somewhere you want it in the text of your sidebar put this:
PHP Code:
You currenty have $coins Coins.<br>
[hr]
lol, ill make it again for you
PHP Code:
mysql_query("INSERT INTO ".$prefix."users VALUES ('', '$username', '$pass1','$email','3','1', '$date', '0','','','','','','1500')");