[RELEASE] Website XML Stats Examples for Rose Online

[brand0n2]

This is a way you can do XML for things like: image stats, live stats on your site, etc...


Users List:

<?
header('Content-Type: text/xml');
print "<rose>

";

$username="root";
$password="******";
$dbname = "roseon";

$conn = mysql_connect(localhost,$username,$password);
mysql_select_db($dbname);

// read data from database
$result = mysql_query("select * from characters")
or die ("Could not read data because ".mysql_error());

// print the data in a table or xml
if (mysql_num_rows($result)) {
while ($qry = mysql_fetch_array($result)) {
print '  <player>
';
print '    <name>'.$qry[char_name].'</name>
';
print '    <level>'.$qry[level].'</level>
';
print '    <curhp>'.$qry[curHp].'</curhp>
';
print '    <curmp>'.$qry[curMp].'</curmp>
';
print '    <str>'.$qry[str].'</str>
';
print '    <dec>'.$qry[dex].'</dec>
';
print '    <cha>'.$qry[cha].'</cha>
';
print ' ';
print '    <exp>'.$qry[exp].'</exp>
';
print '    <zuly>'.$qry[zuly].'</zuly>
';
print '  </player>


';
}
}
print "

</rose>";
?>

KEEP IN MIND: Thats just an example, you can do what it which you like, for example, i made MSN Bot that did live stats for the server & connects to IRC & Live Signatures using PHP & GD. :technolog

[MentaL]

[GeNyaa]

It's nice...
But there are some changes...
I not going to post that from me but it's nice to start whit!

[brand0n2]

Yes, using this method, you can create alot of neat things. Me, I made Signature stats, bots, and everything.

[Rifke]

You retrieve everything from your database?

select * from characters

And you don't even need half of it? Don't you think you're spoiling precious site resources? And the point in using XML at this point is quite ussless? Because it doesn't give any advantage in your script? Loading it in a table it faster and has a layout already. This one you have to link to a CSS file in order to have some sort of layout.

The only real way this would be valuable it by using it with JavaScript (and/or AJAX). Neverless, good basic coding.

[brand0n2]

... Do you even listen to yourself?

Select * from Characters = It gets the info you want it to echo, so like it will echo the name, and level of a user.... Also, it gets the information i want from the "CHARACTER" STRUCTURE/TABLE

...idiot....Select ALL Tables from Characters ... but as you see in the damn script, i only want it to send out certain information keeping the others secret. understand?

...if your not stupid, you can use this script to edit it to make it into HTML tables. Prick.

[fate963]

Lmao, someone is pissed. :s

[brand0n2]

I had a very very very bad day.... When someone tries to correct something when i put "EXAMPLE" in the title just adds to it.

[GeNyaa]

It's need some changes if I were Moderator he get a Infraction xD