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 27, 2011This looks amazing! Is there any way you can add this to enjin.com's Advanced plan? If so, please do tell! Thank you ;)
-
View User Profile
-
Send Message
Posted Dec 27, 2011@Exote
Have a chat with bergerkiller hes freaking awesome with multi threading and MC, He probably can help you fix your thread issue while keeping it multi threaded.
-
View User Profile
-
Send Message
Posted Dec 27, 2011@ledhead900
Yeah it isn't happy when I try to edit signs in a separate thread. I will have to either run recent signs synchronously or compile a list of what to update asynchronously then update them in the main thread.
@andreblue
Make sure you have a version of php 5.2 or higher, If you do post your php error log.
-
View User Profile
-
Send Message
Posted Dec 26, 2011DataTables warning: JSON data from server could ont be parsed. This is casused by a JSON formatting error.
Page has no auctions on it also Error i get after log in, using chrome
-
View User Profile
-
Send Message
Posted Dec 26, 2011@Exote
^ seems to be related to that other error you need to fix run this along side Nolagg v1.53.X or the Debug version.
-
View User Profile
-
Send Message
Posted Dec 25, 2011@Exote
on the latest webinterface, the "max shown entries" are not correct when you click on "Transaction log" the colors also dont appear until you change the max shown entries
on the other tabs like "my auctions" etc it works fine -edit: removing aoColumns part beginning at line 57 in transactionsLog.php fixes colors and max shown entries
-
View User Profile
-
Send Message
Posted Dec 25, 2011I'm receiving this eror on my web page!
Click to preview...
-
View User Profile
-
Send Message
Posted Dec 25, 2011@waterways4
Need to set up your remote MySQL hosts to allow your web server to connect.
-
View User Profile
-
Send Message
Posted Dec 25, 2011@shadoom23:
I've placed the WebAuction website files into my website and set the configuration correctly, I just exchanged the host to my ip.. But when I tried launching it, it doesn't work. Can't connect to the mysql database.. I've already port forwarded port : 3306
It gives me this eror :
-
View User Profile
-
Send Message
Posted Dec 25, 2011@waterways4
3306 = default mysql port
-
View User Profile
-
Send Message
Posted Dec 24, 2011@Exote: Hey umm exote, is the default port for web auction (3306)? Because the plugin works fine now and loaded, but the website doesn't seem to be working.. It can't connect to mysql
-
View User Profile
-
Send Message
Posted Dec 24, 2011@ledhead900
Hey mate you still there? I think I can stay up for awhile, can you help me through Team Viewer? I've installed MySQL Server and MySQL Workbench
-
View User Profile
-
Send Message
Posted Dec 24, 2011@waterways4
3:14am It's Xmas day so I wont even be home till late in the arvo ;)
The morning half I am spending with my son and parents home, then off to my wifes family for rest of day. Boxing day we are off to the pool :).
As I said I could do it in about 5mins max if you pre download the files and you are running windows.
I also edited my post with the connectors and guides for all versions of MySql
Edit Ok going to bed now almost 1/4 to 4am PM me if u need any help with your Timezone and I will try and be on.
-
View User Profile
-
Send Message
Posted Dec 24, 2011@ledhead900
Thank you very much for you request on Team Viewer.. Unfortunately it is currently 12:04 AM (GMT + 8), and i am extremely tired.. What time is it over there? Because maybe tomorrow around 8:00 AM i will be available for your assistance.
You could pass me a link for the tutorial right now, so I can have a look at it first thing in the the morning tomorrow!
-
View User Profile
-
Send Message
Posted Dec 24, 2011@waterways4
I will upload a complete folder with all of mine you should not need any more for just about anything with that. Just make sure to put the "lib" folder in the ROOT of your Minecraft Server along side the server log and server properties files.
Link Removed: http://www.mediafire.com/?d5i4y7ionn9jl60
@waterways4
Yup I can point you to a Tutorial its really quite easy but I can help you with Team viewer as well if needed. Let me know which you preffer I have time to setup MySql if you download it from Here grabbing the correct version for your system and you might want the Workbench that allows you to setup tables and edit databases from Here
As for guides here are a couple for web machines but its suited for general install just pick the correct machine type you are installing on in the one of the guides it says developer machine but I tend to pick the one that is for multi function and not dedicated Mysql as that one sets up the ram usage for general install tho on the web server machine I have it dedicated as web server install.
Windows Guide Linux Guide Mac OS X
-
View User Profile
-
Send Message
Posted Dec 24, 2011@ledhead900
Oh yeah.. BTW I've tried using the official MySQL, I don't seem to know how to use it.. Last time I downloaded the MySQL Server or something, and I had no idea what to do.. Do you have a tutorial for me? I think that using the official MySQL would be the best solution to my problem! Thank you!
-
View User Profile
-
Send Message
Posted Dec 24, 2011<<reply @ledhead900>>
Omg.. So that's what I've been missing.. The third party mysql connectors.. How would I be able to down them? Please support we with a link!
-
View User Profile
-
Send Message
Posted Dec 24, 2011@waterways4
If you mean
It means that its not really an error related to WebAuction's or your config file is not properly formatted for YMAL, aka NO TABS used, proper spacing, etc you can check it by pasting your config Here at this Page I cannot see any others I probably missed the one you are referring to but you make it hard by not posting errors using the Code Paste tool on the post toolbar when you post in code its handy to input the correct format when it asks what Lanq to use, like my code post above I set the lanq to java. You can see how much easier it is to find key words in the code now ;)
I also see that it is not talking to the Mysql Connector that could be your issue but you say MySql is working for other plugins so it probably is working fine, Make sure your Connectors for thridparty databases are in "lib" folder in the root of your Mc Server.
Should find "Mysql" and "mysql-connector-java-bin" and any other database connectors your may have that plugins may have installed if you do not have those connectors you need those or Mysql will not talk with minecraft.
Another thing you could try is installing proper MySql I don't why your running a thirdparty MySql when the Real Deal is available for all operating systems and it has a workbench tool for databases so you can edit them - it also FREE for the basic community version that is all you need.
-
View User Profile
-
Send Message
Posted Dec 24, 2011@ledhead900
Yup.. The settings for WebAuction for the plugin and the website is exactly the same.. Except for the website, I changed the host to my IP.
There's also another thing.. Ummm, at the middle part of the report i posted earlier on.. It said that version = null? What does this mean?
-
View User Profile
-
Send Message
Posted Dec 24, 2011@waterways4
Have you set the correct settings in the WebAuction config for the plugin AND the web end? I know you said you did but would not hurt to double check.
The plugin config should be formatted like below.