[INFO/WEB] iConomy WebWealth v0.1 - a simple table to show wealth [740]

iConomyWebWealth - A simple table view page to show off wealth:
Version: v0.1

iConomyWebWealth is a really, really, simple and easy to use .php script that
will connect to a mysql DB and show the current wealth of players.

Features:

• Shows the current wealth of the players on the server.

Preview: http://www.influxwow.com/iConomyWebtracker.php


Download V0.2: http://dl.dropbox.com/u/12692139/iConomyWebstat/iConomyWebtracker_v0.2.zip
Download V0.1: http://dl.dropbox.com/u/12692139/iConomyWebstat/iConomyWebtracker.zip
Just drop it in htdocs in xampp and away you go.

Dependencies:

• iConomy by Nijikokun

http://forums.bukkit.org/threads/econ-iconomy-5-0-eruanna-602-740.40/

Must dump data through MySQL not flatfile.

• Webserver of sometype, xampp or other with php.

Changelog:
V0.2

• Changed query to display by highest money earned rather then entry ID.

V0.1

• Released

 

don't use version ranges unless it's really needed, plus using 0-740 is a plain lie this would not work with forst few hundred builds.

 

My apologies - I assumed that since the release wasn't relevant to what version of bucket was being run that would be appropriate. The only dependency is MySQL/php.

 

Having this in the plugin list is kind of confusing. This is just a part of a configurable php code piece.

 

wait what? so what can i do with this plugin... im confused. please provide the functionality of the plugin please

 

Nice plugin!
But There is o ranking system
how I Can edit that?

example:
Rank
1 alext97 30
2 Test 20


sorry for my bad English

 

It lets you display which players have the most money through the iConomy system on a website if you use MySQL to store the data. It's a php table just to rank players total amount of cash.

Sorry, when I built the query I had it ordered by ID rather then the total balance. I've updated this, so redownload it if you don't feel like changing the php. If you'd rather just change the PHP change this line.

PHP:

$sql = mysql_query('SELECT id, username, balance FROM '.mysqltable.' ORDER BY id');

to

PHP:

$sql = mysql_query('SELECT id, username, balance FROM '.mysqltable.' ORDER BY balance DESC');

 

Detailed instructions would be nice !

 

I'd love to use this but on my end i get the list up but nothing is on it.

 

Most likely that means that your data is being dumped to a flatfile rather then MySQL. I'll be posting a guide on how to fully set everything up including MySQL sometime later, maybe tonight if I finish off some of my 3D modeling work.

What you see is the list page up, but no ones information on it, right?

 

Thats right it shows the list page and yet nothing is listed, I use MySQL for the Iconomy so i'm not sure why its having a hardtime finding the info.

 

Hmmm. Are you sure that all the configuration settings were applied properly?

PHP:

define(mysqluser, "root");
define(mysqlhost, "localhost");
define(mysqlpass, "securebyqvkqhext");
define(mysqldata, "minecraft");
define(mysqltable, "iconomy");

MySQL admin logon name.
MySQL host - whatever the IP/Hostname of your minecraft server is.
Password for said admin logon.
The name of the database that all the minecraft information is in.
The name of the table that iconomy is on.

Should look something like this, depending on what your using to navigate the SQL databases.


If your database (the one on the far left) is called something different then minecraft you need to change it.
If the table has a different name, you may need to change it too.

Otherwise, I'm not sure without taking a look myself.

 

Found the problem the normal table listed in the script was iconomy but on my server its iConomy

 

Could you give me an example of which directroy to put it in like /local/usr etc.. Like the local site. I keep getting URL not found when i do mywebsite.com/iconomywebtracker.php

 

Should be in your root web directory, this differs by OS/Host, ect. Take a screenshot of your upload panel or whatever you use and I'll see if I can help.

 

My FTP ? Im on OS Debian Linux 6.0 CPU and Kernel : Linux 2.6.32-5-amd64 on x86_64 Hosting with Hetzner.de

 

Hard to say. Not an expert with linux. I use xampp and all you need to do with it is drop the script in your root directory.

 

this is a good thing!

 

Thanks ^^.

 

If you want to limit your table to # visible players add this

Code:

LIMIT #

example(without ID!): http://minecraft.mcserver.se/iconomy.php

Code:

$sql = mysql_query('SELECT username, balance FROM '.mysqltable.' ORDER BY balance DESC LIMIT 10');

sorry for my bad english

 

I really dont believe this is coded properly (no offence) if i was to put my database into this file it looks like someones gonig to find out the details and hack my database... id rather it have a include(config.php); command in it with the database in there... (sorry to be a pest)

 

That's simple enough to do - I don't really think the second layer of inheiritance offers any real protection from hackers to be utterly honest with you. Weak security measures in the first place and improper database setup is far more likely. I cringe every time I see someone who allows root access from other machines besides the localhost. Use root only for local access and create accounts for outside access. All of the sudden the information your worried about them having becomes worthless to them.

 

Tiraldric from DAoC?

 

Yeah, one and the same.

 

Interesting. I take it you remember Ammatic? I'm not him, just a good friend.

 

Kind of a late message, but just put it in /var/www/html

 

something is wrong with the ordering of mine

http://mycraftsmp.net/iconomy/iconomy.php

even with
$sql = mysql_query('SELECT id, username, balance FROM '.mysqltable.' ORDER BY balance DESC')

 

You have a problem here

PHP:

//MySQL config
define(mysqluser, "root");
define(mysqlhost, "localhost");
define(mysqlpass, "securebyqvkqhext");
define(mysqldata, "minecraft");
define(mysqltable, "iconomy");


This causes an error in php but still functions as undefined constants are treated as strings even if they generate an error. Change it to this

PHP:

//MySQL config
define("mysqluser", "root");
define("mysqlhost", "localhost");
define("mysqlpass", "securebyqvkqhext");
define("mysqldata", "minecraft");
define("mysqltable", "iconomy");


And you dont need this

PHP:

error_reporting("E_ALL");


 

This is my "iConomyWebWealth"