WebAuction
WebAuction - Website based item market [1597]
Requires: An economy plugin (iConomy 4,5,6, BOSEconomy 6 & 7, EssentialsEcon, 3Co, MultiCurrency, MineConomy, eWallet, EconXP)
Requires: Vault
Requires: Web server running PHP 5.2+
Download Latest .jar:
WebAuction.jar v0.6.4 - last change 20th Jan 2012
Download Latest Web Folder:
WebInterface.zip v0.6.4 - last change 22th Jan 2012
Download Latest Development .jar:
WebAuction.jar - last change 9th Feb 2012
Download Latest Development Web Folder:
WebInterface.zip - last change 9th Feb 2012
Development Server
If you want to see a demonstration of a working (mostly) development version of this plugin, I am currently running a small server with it (not 24/7). However the website is pretty sluggish because it is not hosted on the same server as minecraft, but it should still work.
- IP: twm.servegame.com
- Website: webauction.threewisemeh.com
Source (GitHub)
WebAuction (jar) - http://bit.ly/o8vpPq
WebInterface (web files) - http://bit.ly/nPubR1
Description
Ok, so I know there are loads of shop plugins that all do slightly different things. But because of the UI restrictions in game, I chose to make a shop plugin that links in with a website via a MySQL database to make trade easier, and even allow people to check on how their items are doing without being logged into the game. (mobile device?).
Basic idea is that admins (or players with right permissions etc) set up auction houses around the world. Players can then go there and deposit items, when they do this the items disappear from the world and get logged into the players online account. They they put money in the online account by clicking signs. Once this is done and they have set a password, they can log into the website and see all the auctions that are going on.
Using the money in the online account they can buy items, and they will be sent to the mailbox in game (a sign) and they can set up their own auctions for the items they have stored online.
One of the main features is that the website will look at all the sales and calculate a moving average for the market price of that item. Which should help players when setting a price, or buyers to see if they are getting a good deal.
Notes:
- Just added a how to edit section for info and new designs to help change the look of the website
- Works best with iConomy stored in the same MySQL database as the WebAuction tables (direct money link from game to website)
Features:
- Only members of your server can get an account
- Change password from in game
- Deposit items to be sold by right-clicking a mailbox deposit sign while holding it
- Change online balance with signs
- Get items from a sign mail box
- Moving average market price calculations
- Can link directly to the iConomy database
Overview Video:
NEW VIDEO :D
Screenshots:
will take more soon, when we have spent a while using it so that the market prices are properly calculated.

Setup:
Basics:
- Download the WebAuction.zip and extract it
- Put the WebAuction.jar in the plugins folder on your minecraft server
- Put the WebAuctionInterface folder (you can rename) on your website
- Restart server
- Look in plugins/WebAuction to find the config file add your MySQL database details
- In the interface folders on website, find the scripts/config.php file and add MySQL details again
- Be careful with mysql passwords, special characters such as {}[]() may cause the file to be incorrectly read by the yml parser.
- Make everyone create a password, make sure its different to ones they use elsewhere etc.
- Make a sign for the withdraw mail box (see screenshot) First list: "[WebAuction]" Second line: "MailBox"
- Make a sign for the deposit mail box (see screenshot) First list: "[WebAuction]" Second line: "MailBox" Third line: "Deposit"
- If you have iConomy data stored in the same database as the WebAuction data, use the web config file to point to the right table, and ignore the stuff about withdraw and deposit signs.
- Make some withdraw and deposit signs for money (again in screenshot) First line "[WebAuction]" Second: "Withdraw" or "Deposit" Third: the amount of money, or for the withdraw sign you can put "All" on the third line
- You can also make recent auction signs, to show a live feed of the new auctions: First line "[WebAuction]" Second: "Recent" Third: a number for the offset, so for the most recent auction put "1", second most recent "2" etc.
- Log into the website and start selling
Important Signs
Mailbox:
Used to deposit items and withdraw items that are in your mail
Line 1: [WebAuction] Line 2: MailBox Line 3: Withdraw (not actually needed but makes it neater with the other deposit sign :P)
Line 1: [WebAuction] Line 2: MailBox Line 3: Deposit
Deposit Money:
Used to send money to the website to be used on the WebAuction (not needed if using iconomy databases) Line 3 can be any number (100, 0.01, 55.7 etc.)
Line 1: [WebAuction] Line 2: Deposit Line 3: 100
Withdraw Money:
Used to get money from the website to be used on the WebAuction (not needed if using iconomy databases) Line 3 can be any number (100, 0.01, 55.7 etc.) Line 3 can also be "All".
Line 1: [WebAuction] Line 2: Withdraw Line 3: All
Recent Auction Feed
Used to see recent auctions people have made, you can set up as many signs as you want each looking for subsequent auctions. For example in your auction house you could have one sign to show each of the five most recent auctions. For line 3 enter the number for the offset from the most recent auction ("1" for the most recent, "2" for the second most recent... etc.)
These signs will update automatically when new auctions are made, and will display the item name, the quantity and the price.
Line 1: [WebAuction] Line 2: Recent Line 3: 1
There is now also another way of displaying recent auctions. If you have the SignLink plugin on your server you can display values about the auctions however you like on signs using various bits of data as variables. So far I have just got:
- Auction Name (%WAName1%)
- Auction Price (%WAPrice1%)
- Auction Quantity (%WAQuant1%)
Where you can change the number (1) for any other in the same way as in the previous auction signs, except I think 0 is actually the most recent auction.
I will soon be adding other information such as the sellers name and maybe the market price etc.
New Auction Shouting
A sign that is given a radius, when a new auction is created it will shout in it's radius about it to anyone nearby, line 3 is the radius in blocks.
Line 1: [WebAuction] Line 2: Shout Line 3: 10
Twitter feed
If you want to send information of new auctions and sales to a twitter account. Open up the config.php file (in the scripts folder).
Go to: https:dev.twitter.com/apps/new Input all your information. It doesnt really matter what you put for the name and things on the first page. (and you don't need to add anything for the callback)
When you have created your new app, open the settings tab, and set the application type access to "read and write". Save everything. Go back to main app info page. On that page should be the consumer key and consumer secret. Add these two values to the config file.
Near the bottom of the page is a button that says "create access token", makes sure you have set the permissions to read and write then click this button and copy the two values it gives you into the config folder.
Done (hopefully)
More Setup Information
To get more info on how to set up the plugin, along with common problems, take a look at the How to Install page
Changing the Design
To see how to change the design, or select one someone else has made: How to Edit
Commands:
- /wa password [pass] (sets your password)
Permissions:
- wa.use.withdraw.items (use mail box)
- wa.use.withdraw.money (use withdraw sign)
- wa.use.deposit.items (use deposit sign)
- wa.use.deposit.money (use deposit sign)
- wa.canbuy (can buy from auction)
- wa.cansell (can sell to the auction)
- wa.create.sign.deposit (create deposit sign)
- wa.create.sign.withdraw (create withdraw sign)
- wa.create.sign.mailbox.withdraw (create mailbox sign)
- wa.create.sign.mailbox.deposit (create mailbox sign)
- wa.create.sign.shout (create a new auction shout sign)
- wa.create.sign.recent (create a recent auction sign)
- wa.webadmin (user account is admin on the website)
- wa.remove (remove WA signs)
Donations:
Hope you guys like the plugin, keep telling me things you think would be cool to add and I will do my best. And a donation is always nice :P

-
View User Profile
-
Send Message
Posted Oct 30, 2011Hey. Im new to this plugin and i have no idea how to set up the website. I have tried several ways with several hosts. but none of them have worked. Can you create a tut on how to make the website? Thanks.
-
View User Profile
-
Send Message
Posted Oct 30, 2011Sorry if this is not the right section or you have already answered to this sort of question but i get this error in my server:
30.10 21:42:06 [Server] INFO [WebAuction] Player found, canBuy: 1 canSell: 1 isAdmin: 0
30.10 21:42:06 [Server] WARNING [WebAuction] Error at SQL UPDATE Query: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException Unknown column 'isAdmin' in 'field list'
30.10 21:42:06 [Server] WARNING [WebAuction] Error at SQL UPDATE Query: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException Unknown column 'canSell' in 'field list'
How can avoid it? Thank you.
I have the last version of wa
-
View User Profile
-
Send Message
Posted Oct 30, 2011@Exote
If i run the updateTables.php script i get this: <<code Warning: mysql_query() [function.mysql-query]: Access denied for user 'dembalan'@'localhost' (using password: NO) in /home/dembalan/public_html/auction/scripts/updateTables.php on line 11
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/dembalan/public_html/auction/scripts/updateTables.php on line 11
Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/dembalan/public_html/auction/scripts/updateTables.php on line 12
Warning: mysql_query() [function.mysql-query]: Access denied for user 'dembalan'@'localhost' (using password: NO) in /home/dembalan/public_html/auction/scripts/updateTables.php on line 19
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/dembalan/public_html/auction/scripts/updateTables.php on line 19
Warning: mysql_query() [function.mysql-query]: Access denied for user 'dembalan'@'localhost' (using password: NO) in /home/dembalan/public_html/auction/scripts/updateTables.php on line 11
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/dembalan/public_html/auction/scripts/updateTables.php on line 11
Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/dembalan/public_html/auction/scripts/updateTables.php on line 12
Warning: mysql_query() [function.mysql-query]: Access denied for user 'dembalan'@'localhost' (using password: NO) in /home/dembalan/public_html/auction/scripts/updateTables.php on line 19
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/dembalan/public_html/auction/scripts/updateTables.php on line 19
Warning: mysql_query() [function.mysql-query]: Access denied for user 'dembalan'@'localhost' (using password: NO) in /home/dembalan/public_html/auction/scripts/updateTables.php on line 25
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/dembalan/public_html/auction/scripts/updateTables.php on line 25
Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/dembalan/public_html/auction/scripts/updateTables.php on line 26
Warning: mysql_query() [function.mysql-query]: Access denied for user 'dembalan'@'localhost' (using password: NO) in /home/dembalan/public_html/auction/scripts/updateTables.php on line 33
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/dembalan/public_html/auction/scripts/updateTables.php on line 33
Warning: mysql_query() [function.mysql-query]: Access denied for user 'dembalan'@'localhost' (using password: NO) in /home/dembalan/public_html/auction/scripts/updateTables.php on line 25
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/dembalan/public_html/auction/scripts/updateTables.php on line 25
Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/dembalan/public_html/auction/scripts/updateTables.php on line 26
Warning: mysql_query() [function.mysql-query]: Access denied for user 'dembalan'@'localhost' (using password: NO) in /home/dembalan/public_html/auction/scripts/updateTables.php on line 33
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/dembalan/public_html/auction/scripts/updateTables.php on line 33
Warning: mysql_query() [function.mysql-query]: Access denied for user 'dembalan'@'localhost' (using password: NO) in /home/dembalan/public_html/auction/scripts/updateTables.php on line 25
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/dembalan/public_html/auction/scripts/updateTables.php on line 25
Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/dembalan/public_html/auction/scripts/updateTables.php on line 26
Warning: mysql_query() [function.mysql-query]: Access denied for user 'dembalan'@'localhost' (using password: NO) in /home/dembalan/public_html/auction/scripts/updateTables.php on line 33
Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/dembalan/public_html/auction/scripts/updateTables.php on line 33>>
<</code>>
-
View User Profile
-
Send Message
Posted Oct 30, 2011@TomShar
@jeremybombed
@jeremybombed
Try run the index page of the website or the updateTables.php script.
-
View User Profile
-
Send Message
Posted Oct 30, 2011And this:
2011-10-30 02:42:56 [SEVERE] Error occurred while enabling WebAuction v0.3 (Is it up to date?): null java.lang.NullPointerException at com.alta189.sqlLibrary.MySQL.DatabaseHandler.checkTable(DatabaseHandler.java:134) at com.alta189.sqlLibrary.MySQL.mysqlCore.checkTable(mysqlCore.java:72) at me.exote.webauction.WebAuction.onEnable(WebAuction.java:105) at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:126) at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:941) at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:280) at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:174) at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:157) at net.minecraft.server.MinecraftServer.e(MinecraftServer.java:297) at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:284) at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:152) at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:348) at net.minecraft.server.ThreadServerApplication.run(SourceFile:417)
-
View User Profile
-
Send Message
Posted Oct 30, 2011I get this:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/arubacra/public_html/auction/scripts/login-script.php on line 10
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/arubacra/public_html/auction/scripts/login-script.php on line 11
Warning: Cannot modify header information - headers already sent by (output started at /home/arubacra/public_html/auction/scripts/login-script.php:10) in /home/arubacra/public_html/auction/scripts/login-script.php on line 25
-
View User Profile
-
Send Message
Posted Oct 29, 2011I get these error:
Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/dembalan/public_html/auction/scripts/updateTables.php on line 12 Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/dembalan/public_html/auction/scripts/updateTables.php on line 12 Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/dembalan/public_html/auction/scripts/updateTables.php on line 26 Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/dembalan/public_html/auction/scripts/updateTables.php on line 26 Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/dembalan/public_html/auction/scripts/updateTables.php on line 26
-
View User Profile
-
Send Message
Posted Oct 29, 2011please add a password decode for md5
-
View User Profile
-
Send Message
Posted Oct 29, 2011I get this on the webauction page:
What have I done wrong?
-
View User Profile
-
Send Message
Posted Oct 28, 2011We finally decided to go with this for our server, and everyone is loving it so far. =) However, one player brought up an issue that can potentially be abused; there is no limit to items that you can send to the web, and people could use it to bypass the need for chests.
It would be wonderful for us survivor server owners/administrators if you could add support via permissions for number of auctions able to be had at once, as well as items that can be stored? Would make a world of difference, thank you. =)
-
View User Profile
-
Send Message
Posted Oct 28, 2011@Exote
First of, let me say great work so far!
Now, down the business. I would like to request that a features is added to the auction system that would handle multi-world support with the ability to link worlds into groups. I believe this would be a huge leap in making your plugin truly awesome!
For a reference, the multi-world inventory system I'm using is World Inventories. If you could load the groups already in the configuration of this plugin, that'd be ideal. If not, a configuration in the same style as world inventories would be ideal.
Also, a configurable limit on how many items that can be sent to the web would be great too. Prevent users from using this as a web-chest.
Thank you.
-
View User Profile
-
Send Message
Posted Oct 28, 2011I get this error: Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'dembalan_tom'@'188.227.161.50' (using password: YES) in /home/dembalan/public_html/auction/scripts/config.php on line 43 Unable to connect to databaseAccess denied for user 'dembalan_tom'@'188.227.161.50' (using password: YES)
What is wrong?
This is the error file btw:
[28-Oct-2011 14:32:16] PHP Warning: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user 'dembalan_tom'@'188.227.161.50' (using password: YES) in /home/dembalan/public_html/auction/scripts/config.php on line 43 [28-Oct-2011 14:32:16] PHP Warning: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user 'dembalan_tom'@'188.227.161.50' (using password: YES) in /home/dembalan/public_html/auction/scripts/config.php on line 43 [28-Oct-2011 14:38:29] PHP Warning: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user 'dembalan_tom'@'188.227.161.50' (using password: YES) in /home/dembalan/public_html/auction/scripts/config.php on line 43 [28-Oct-2011 14:38:29] PHP Warning: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user 'dembalan_tom'@'188.227.161.50' (using password: YES) in /home/dembalan/public_html/auction/scripts/config.php on line 43 [28-Oct-2011 14:41:43] PHP Warning: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user 'dembalan_tom'@'188.227.161.50' (using password: YES) in /home/dembalan/public_html/auction/scripts/config.php on line 43 [28-Oct-2011 14:41:54] PHP Warning: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user 'dembalan_tom'@'188.227.161.50' (using password: YES) in /home/dembalan/public_html/auction/scripts/config.php on line 43 [28-Oct-2011 14:41:58] PHP Warning: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user 'dembalan_tom'@'188.227.161.50' (using password: YES) in /home/dembalan/public_html/auction/scripts/config.php on line 43 [28-Oct-2011 15:08:04] PHP Warning: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user 'dembalan_tom'@'188.227.161.50' (using password: YES) in /home/dembalan/public_html/auction/scripts/config.php on line 43 [28-Oct-2011 15:08:04] PHP Warning: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user 'dembalan_tom'@'188.227.161.50' (using password: YES) in /home/dembalan/public_html/auction/scripts/config.php on line 43
-
View User Profile
-
Send Message
Posted Oct 28, 2011FEATURE REQUEST
Can we please have it so that if a player adds an auction of an item they already have up for sale, it stacks it..
Becuase i have people that, for example, put 50 dirt @ $10 each and then later on put another 50 Dirt @ $10... and it makes two entries... why not stack up..?
-
View User Profile
-
Send Message
Posted Oct 25, 2011my "recent" signs never update.
also, latest shows 3.3 but there's a date of OCT 21 and another 3.3 with OCT 13
Should the former be 3.4?
-
View User Profile
-
Send Message
Posted Oct 25, 2011Can u please update ur repo to the newest version. Thanks
-
View User Profile
-
Send Message
Posted Oct 24, 2011Ok so i am trying to set this up n my server and it makes no snse i have it in the plugins folder along withspout andit wont let me make the chest or anything. Its also not letting me accses the website thing. So can you explain in detail how to set this up or please post a vidieo on how to do it. It seems like a great ida and im excited to use it. Thanks
-
View User Profile
-
Send Message
Posted Oct 23, 2011Can you make a vid how to put it online
-
View User Profile
-
Send Message
Posted Oct 23, 2011@Exote
sorry totally skipped over the question asked last night, was early morning for me.
but yes its hosted on a dedicated server, i have iconomy and lwc connecting to it no problems, and like i said WebAuction created the mysql table with no problem
-
View User Profile
-
Send Message
Posted Oct 23, 2011@Exote
yeah, I don't want you to catalogue all items :P
the thing is, when I look into my MySQL database after i put these custom items in the deposit chest, the show up as "name:318 damage:1027 player:kolibri7".
so 318 IS the ID of flint, so there's no way I could rename this item or is there?
the damage number seems to be the real ID of that custom block...
Edit: I realized that there is indeed a way to rename these items with damage.
sry I didn't see this earlier :P
but editing a PHP file is a bit of a pain to add custom items, especially when it comes to updating the plugin, don't you think?
Edit2: The Recent signs ingame also show the wrong item name. What would you think of a new table in MySQL where we can put in our own custom items with name, id and image?
-
View User Profile
-
Send Message
Posted Oct 23, 2011[SEVERE] Could not pass event PLAYER_INTERACT to WebAuction java.lang.NumberFormatException: empty String at sun.misc.FloatingDecimal.readJavaFormatString(Unknown Source) at java.lang.Double.parseDouble(Unknown Source) at me.exote.webauction.WebAuctionPlayerListener.onPlayerInteract(WebAuctionPlayerListener.java:218) at org.bukkit.plugin.java.JavaPluginLoader$11.execute(JavaPluginLoader.java:330) at org.bukkit.plugin.RegisteredListener.callEvent(RegisteredListener.java:58) at org.bukkit.plugin.SimplePluginManager.callEvent(SimplePluginManager.java:339) at org.bukkit.craftbukkit.event.CraftEventFactory.callPlayerInteractEvent(CraftEventFactory.java:171) at net.minecraft.server.ItemInWorldManager.interact(ItemInWorldManager.java:265) at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:592) at net.minecraft.server.Packet15Place.a(SourceFile:57) at net.minecraft.server.NetworkManager.b(NetworkManager.java:226) at net.minecraft.server.NetServerHandler.a(NetServerHandler.java:92) at org.getspout.spout.SpoutNetServerHandler.a(SpoutNetServerHandler.java:500) at net.minecraft.server.NetworkListenThread.a(SourceFile:108) at net.minecraft.server.MinecraftServer.h(MinecraftServer.java:471) at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:374) at net.minecraft.server.ThreadServerApplication.run(SourceFile:417)