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

Discussion in 'Inactive/Unsupported Plugins' started by Tiraldric, May 3, 2011.

  1. Offline

    Tiraldric

    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
    [​IMG]

    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:
    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
     
    efstajas likes this.
  2. Offline

    Plague

    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.
     
  3. Offline

    Tiraldric

    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.
     
  4. Offline

    Pontus Lantz

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

    Craftee

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

    alext97

    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:(
     
  7. Offline

    Tiraldric

    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');
     
  8. Offline

    tom

    Detailed instructions would be nice :D !
     
  9. Offline

    Craftee

     
  10. Offline

    Ubersaint

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

    Tiraldric

    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?
     
  12. Offline

    Ubersaint

    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.
     
  13. Offline

    Tiraldric

    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.
    [​IMG]

    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.
     
    Benjamin_Price likes this.
  14. Offline

    Ubersaint

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

    tom

    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
     
  16. Offline

    Tiraldric

    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.
     
  17. Offline

    tom

    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
     
  18. Offline

    Tiraldric

    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.
     
  19. Offline

    Benjamin_Price

    this is a good thing! :)
     
  20. Offline

    Tiraldric

    Thanks ^^.
     
  21. Offline

    alext97

    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:(
     
  22. Offline

    gamingvortex

    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)
     
  23. Offline

    Tiraldric

    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.
     
  24. Offline

    Acidspit

    Tiraldric from DAoC?
     
  25. Offline

    Tiraldric

    Yeah, one and the same.
     
  26. Offline

    Acidspit

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

    Birdie

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

    tha d0ctor

  29. Offline

    Klong-Nu

    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");
     
  30. Offline

    alext97

Share This Page