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 Dec 24, 2011@ledhead900:
Actually, I do own the server so I do not need remote access to my server. I've installed many plugins with MySQL support and didn't have a single eror. But when i tried to install this with the mysql setting correctly inputted, it's giving me these erors that it can't access it.. I am currently using WAMP MySQL.. So could this be the cause of it? It just can't seem to connect to the MySQL database!
-
View User Profile
-
Send Message
Posted Dec 24, 2011@Exote
Nolagg :) - It has a watcher in the background for naughty plugins that errors on them as it deals with chunks and the sending of chunks and so on. if u look further down you can see burgerkiller and nolagg and the error related to it.
He uses Async on some of his events as he needs to capture chunks and things like this.
The plugin version of WebAuction was current 0.6.2 I am using the RB of bukkit.
-
View User Profile
-
Send Message
Posted Dec 24, 2011@ledhead900
Oh the threads are definitely doing something they shouldn't. You know what triggered those errors for you?
-
View User Profile
-
Send Message
Posted Dec 24, 2011@waterways4 Make sure the Mysql server has remote access enabled if you do not own the server you must contact your host. Remote is required if the Mysql server is not located on the same server as the MC server.
@Exote I think your plugin is being naughty with threads ;)
-
View User Profile
-
Send Message
Posted Dec 24, 2011@waterways4
Haha feel like I'm being told off, shouting my name like that :P
Try not using localhost but the actual IP.
-
View User Profile
-
Send Message
Posted Dec 24, 2011@Exote:
It just won't work.. I've checked exactly the setting for the other plugins but it still won't load..
-
View User Profile
-
Send Message
Posted Dec 24, 2011@waterways4
Just look in the website config file, and put in the mc server ip as the host.
As for whether the mysql details are right, just try them exactly as you used in another plugin, just to check if the connection is there. iConomy or something similar.
-
View User Profile
-
Send Message
Posted Dec 24, 2011@Exote. Oops, and I almost forgot. Since I uploaded the WebAuction onto my website via an ftp client. How would i configure the setting there? I can't use localhost, because it's up in the web. I've also port forwarded : Port "3306"!
-
View User Profile
-
Send Message
Posted Dec 24, 2011@Exote, Yes, the configuration setting to connect to mysql is correct.I've used this setting for alot of my plugins and didn't have any eror. Here's my config file. The username is : "minecraft" and password : "12345". I've also created a database in mysql called webauction.
MySQL: Host: localhost Username: minecraft Password: 12345 Port: 3306 Database: webauction
Is there anyway you can help with my configuration like using : Team Viewer?
-
View User Profile
-
Send Message
Posted Dec 24, 2011@AndrewsPanda
Updated transaction log a bit, but it is still giving me problems.
-
View User Profile
-
Send Message
Posted Dec 24, 2011@shadoom23
Sorry, misspelled damage once and everything died :P should be fixed now.
-
View User Profile
-
Send Message
Posted Dec 24, 2011@waterways4
You really sure this is the correct login information? is your username: minecraft? is it locally hosted on the same ip as your minecraft server?
-
View User Profile
-
Send Message
Posted Dec 24, 20112011-12-24 16:49:31 [INFO] [WebAuction] WebAuction is initializing 2011-12-24 16:49:31 [INFO] [WebAuction] MySQL Initializing 2011-12-24 16:49:31 [SEVERE] [WebAuction] Exception getting mySQL Connection 2011-12-24 16:49:31 [SEVERE] java.sql.SQLException: Access denied for user 'minecraft'@'localhost' (using password: YES) 2011-12-24 16:49:31 [SEVERE] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) 2011-12-24 16:49:31 [SEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593) 2011-12-24 16:49:31 [SEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525) 2011-12-24 16:49:31 [SEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:931) 2011-12-24 16:49:31 [SEVERE] at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:4031) 2011-12-24 16:49:31 [SEVERE] at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1296) 2011-12-24 16:49:31 [SEVERE] at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2338) 2011-12-24 16:49:32 [SEVERE] at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2371) 2011-12-24 16:49:32 [SEVERE] at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2163) 2011-12-24 16:49:32 [SEVERE] at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:794) 2011-12-24 16:49:32 [SEVERE] at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) 2011-12-24 16:49:32 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) 2011-12-24 16:49:32 [SEVERE] at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) 2011-12-24 16:49:32 [SEVERE] at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source) 2011-12-24 16:49:32 [SEVERE] at java.lang.reflect.Constructor.newInstance(Unknown Source) 2011-12-24 16:49:32 [SEVERE] at com.mysql.jdbc.Util.handleNewInstance(Util.java:407) 2011-12-24 16:49:32 [SEVERE] at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:378) 2011-12-24 16:49:32 [SEVERE] at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:305) 2011-12-24 16:49:32 [SEVERE] at java.sql.DriverManager.getConnection(Unknown Source) 2011-12-24 16:49:32 [SEVERE] at java.sql.DriverManager.getConnection(Unknown Source) 2011-12-24 16:49:32 [SEVERE] at me.exote.webauction.MySQLDataQueries.getConnection(MySQLDataQueries.java:46) 2011-12-24 16:49:32 [SEVERE] at me.exote.webauction.MySQLDataQueries.tableExists(MySQLDataQueries.java:77) 2011-12-24 16:49:32 [SEVERE] at me.exote.webauction.MySQLDataQueries.initTables(MySQLDataQueries.java:114) 2011-12-24 16:49:32 [SEVERE] at me.exote.webauction.WebAuction.onEnable(WebAuction.java:72) 2011-12-24 16:49:32 [SEVERE] at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:188) 2011-12-24 16:49:32 [SEVERE] at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:968) 2011-12-24 16:49:32 [SEVERE] at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:280) 2011-12-24 16:49:32 [SEVERE] at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:186) 2011-12-24 16:49:32 [SEVERE] at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:169) 2011-12-24 16:49:32 [SEVERE] at net.minecraft.server.MinecraftServer.t(MinecraftServer.java:348) 2011-12-24 16:49:32 [SEVERE] at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:335) 2011-12-24 16:49:32 [SEVERE] at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:165) 2011-12-24 16:49:32 [SEVERE] at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:399) 2011-12-24 16:49:32 [SEVERE] at net.minecraft.server.ThreadServerApplication.run(SourceFile:457) 2011-12-24 16:49:32 [SEVERE] Error occurred while enabling WebAuction v0.6.2 (Is it up to date?): null java.lang.NullPointerException at me.exote.webauction.MySQLDataQueries.tableExists(MySQLDataQueries.java:82) at me.exote.webauction.MySQLDataQueries.initTables(MySQLDataQueries.java:114) at me.exote.webauction.WebAuction.onEnable(WebAuction.java:72) at org.bukkit.plugin.java.JavaPlugin.setEnabled(JavaPlugin.java:188) at org.bukkit.plugin.java.JavaPluginLoader.enablePlugin(JavaPluginLoader.java:968) at org.bukkit.plugin.SimplePluginManager.enablePlugin(SimplePluginManager.java:280) at org.bukkit.craftbukkit.CraftServer.loadPlugin(CraftServer.java:186) at org.bukkit.craftbukkit.CraftServer.enablePlugins(CraftServer.java:169) at net.minecraft.server.MinecraftServer.t(MinecraftServer.java:348) at net.minecraft.server.MinecraftServer.a(MinecraftServer.java:335) at net.minecraft.server.MinecraftServer.init(MinecraftServer.java:165) at net.minecraft.server.MinecraftServer.run(MinecraftServer.java:399) at net.minecraft.server.ThreadServerApplication.run(SourceFile:457)
I can't seem to be able to connect to the server, even though I've typed in the correct information for the mysql database!
-
View User Profile
-
Send Message
Posted Dec 23, 2011anyone else having issues with metadata/damagevalues ?
magenta wool shows perfectly fine under "my items" when i auction it, it becomes white wool
ok what i've found out:
edit1: 0.6.2 = colored wools, slaps etc every item that uses metadata does not work 0.6.1 = all that metadata stuff works edit2: the latest source on github does not work at all
It's really a great plugin with a nice idea, I wish i could help in anyway but i guess im not awesome enough :\ If there is someone (saw some people in the tickets) who have experience should help this dev and make it more awesome than it already is <3
thank you nice plugin dev, me gusta you
-
View User Profile
-
Send Message
Posted Dec 23, 2011Ok I have updated to the latest WebAuction plugin and latest WebInterface. The one with player stats etc.
I completely removed the old WebInterface files and replaced it with the new ones. Except for config.php
I am now getting errors in the Transaction log.
Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in /home/kryptiox/public_html/WebInterface/scripts/itemInfo.php on line 130
-
View User Profile
-
Send Message
Posted Dec 23, 2011Making progress with the website side of things. New page to display player stats; things like number of items sold and bought and amount of money spent and gained etc.
The item info page now properly shows enchantment market prices. Need to sort out transaction log in a similar way. And the graphs.
Also improved some of the methods in item and auction handling. So should be easier for new pages and features. infinite stacks next up.
-
View User Profile
-
Send Message
Posted Dec 23, 2011When I try to access the web page I get the following error:
Unable to connect to databaseLost connection to MySQL server at 'reading initial communication packet', system error: 111
-
View User Profile
-
Send Message
Posted Dec 23, 2011@darkmage0252
Infinite stacks quite soon, but progress is slowing down over Christmas. Will never have a chat/command based way of buying and selling in game, as that defeats the point of having a nice web interface. However it wouldn't be hard for someone else to make a plugin that links to the WA database tables and has some way of buying and selling in game.
-
View User Profile
-
Send Message
Posted Dec 23, 2011@Sejsel
Well, it seems that you cannot solve it, right? Or you just have not saw it? Or even worse, you have Ignored it? Just asking...
-
View User Profile
-
Send Message
Posted Dec 22, 2011How much longer tell infinite stacks? and do you think there will ever be support for a chat based addon for this plugin so they dont have to use the website?