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 6, 2011Hi I get this error everytime someone logs in:
14:46:25 [WARNING] [WebAuction] Error at SQL DELETE Query: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'minecraft.WA_Admins' doesn't exist
14:46:25 [INFO] [WebAuction] Player no longer WebAdmin
14:46:25 [INFO] [WebAuction] Player found
14:46:25 [WARNING] [WebAuction] Error at SQL DELETE Query: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table minecraft.WA_Admins' doesn't exist 14:46:25 [INFO] [WebAuction] Player no longer WebAdmin 14:46:25 [INFO] [WebAuction] Player found
The table minecraft.WA_Admins does not exist because it is called minecraft.WA_WebAdmins
in the login script it is specified correctly though... is there an error in the .jar somewhere maybe?
tom
-
View User Profile
-
Send Message
Posted Oct 6, 2011@ledhead900
Ok, I haven't had time to check all the images myself. I don't actually store the images on the website, if you look in the iteminfo page in the scripts folder, you will see a big list of item number with the names next to them, then further down with the image urls (linking to minecraft wiki). Let me know if you manage to find out which are wrong and I will change them for other people.
-
View User Profile
-
Send Message
Posted Oct 5, 2011@Exote
Thanks for keeping alive and going I love it, I have to inform some things tho I have not seen any errors yet but where may I found to location for the images it uses for items ?. some of the items are had indented images while the rest do not I noticed with the new food item in 1.8 I was going to remake the items myself, and also if I had a need I would replace them with images from a texture pack.
I was even thinking about replacing the header on the login page with our servers logo I will see what I can do with the styles later on but I just wanted to say thanks and point our the image issue.
-
View User Profile
-
Send Message
Posted Oct 3, 2011-
View User Profile
-
Send Message
Posted Oct 3, 2011will you implement functions for localization? I've translated the web interface in german, but it's not comfortable and killed a part of the stylings.
-
View User Profile
-
Send Message
Posted Oct 2, 2011Some suggestions; Well first, some things like the Golden Apple. The image is messed up, it indent's the page, it's not like the rest.
My other suggestion is; When Admin's sell something they have the option to set the amount to unlimited and when people click on buy stack, or scroll threw it, it goes either 64 stack, or 1 ~ 64 in the scroll menu when you click on how many.
Another suggestion is; You should be able to sell Packages. Like say, I have Diamond Armour set none of it is damaged and I just put it into my inventory on the Web Shop, I should have the option to package it as a, "Diamond Armour Package" and that's what it'll be named as when I sell it and the image would be like a box with each side that shows being a different part of the Diamond Armour and what ever sides that only show like bits and part of the Armour that is on that side make it only show that much and when you buy it and mail it it goes into your inventory in-game as all four pieces at once.
(Sorry about that run on)
-
View User Profile
-
Send Message
Posted Oct 2, 2011@nightsdawn Is your mysql set up on a remote host or is it on local host? If your remote host connection is slow to your server connection it will cause lag while using the signs excessively, this is why there is a config option to change the cooldown :)
-
View User Profile
-
Send Message
Posted Oct 1, 2011@Exote
Thanks ! But now sometime it said http://pastebin.com/4M1vne0s
Should i ignore too ?
-
View User Profile
-
Send Message
Posted Oct 1, 2011I would love to have this on my server but when I put this on and configure it everything works but it causes Major lag. I get a rolling error message saying my server is out of sync and makes the game unplayable. I have quite a few other plugins so im not sure whats causing it. Are there any known issues with other plugins?
-
View User Profile
-
Send Message
Posted Oct 1, 2011Good plugin, I really like it.
One change I made to the web interface was changing the Buy X from a select to text input. I subsidize a few items on my server and sell large quantitys for cheap. Takes way too long to load a select box up to 300,000. But great job so far
-
View User Profile
-
Send Message
Posted Oct 1, 2011Ok for signs and so that would help a little. But every update even to translate the website its a boring job ;-).
-
View User Profile
-
Send Message
Posted Oct 1, 2011@olimoli123
Will sort out my github properly at some point, but I'm not stopping you from decompiling in the mean time
@bank290541
Ignore that error, will go away when you create an auction, sorting that spam in next build
@corsab
I can quite easily add one of these for the plugin (signs and messages etc), but make be more difficult for the website files. The iteminfo one in particular has huge lists of item names which would have to be converted.
-
View User Profile
-
Send Message
Posted Oct 1, 2011Hi,
can u pls made a language.yml or something? Cause its horrible to translate all the english in that bunch of files in my servers native language.
:-)
-
View User Profile
-
Send Message
Posted Oct 1, 2011Will this ever be open source? :]
-
View User Profile
-
Send Message
Posted Oct 1, 2011@qazzi
You need to open the config.php and set iconomy=true and change the table to your iconomy's table name (case sensitive)
-
View User Profile
-
Send Message
Posted Oct 1, 2011@Exote Thanks, oh and I see there a php option to change them all with out manual edits of them all did not know that might want to add that to the info page.
-
View User Profile
-
Send Message
Posted Oct 1, 2011Request:
It would be nice if you could use Spout and SpoutCraft to make a Mailbox with a nice GUI. So if you hit the sign you will get a window with all you mail and so on. Dont now if its possible but it would be awsome!
-
View User Profile
-
Send Message
Posted Sep 30, 2011It says if you use iConomy you dont need to put the signs.. but I couldn't get it to work without them.
also, do you have an irc channel? :)
-
View User Profile
-
Send Message
Posted Sep 30, 2011What should i do ? http://pastebin.com/2QfU0J2x
-
View User Profile
-
Send Message
Posted Sep 30, 2011@Demonlover11
I had the same error until I setup for external SQL server.... but now im having issues getting it to work at all heh.