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 12, 2011@urbanturban95
It just has no connection to the MySQL database. No idea how you have hosted the MySQL but make sure the website is allowed to connect to it via remote sql hosts, and make sure you got the settings right in the website config file.
-
View User Profile
-
Send Message
Posted Dec 12, 2011I sent PM
-
View User Profile
-
Send Message
Posted Dec 12, 2011@urbanturban95
Send me a link to your website
-
View User Profile
-
Send Message
Posted Dec 12, 2011I bought this server on page with minecraft servers and I got acces to MySQL (they sent me login, password etc.). So far, everything worked fine, only page cannot connect to db.
-
View User Profile
-
Send Message
Posted Dec 12, 2011@urbanturban95
How is everything hosted?
-
View User Profile
-
Send Message
Posted Dec 12, 2011But, minecraft file (WebAuction.jar) created files in MySQL. Only web part cannot connect.
-
View User Profile
-
Send Message
Posted Dec 12, 2011@urbanturban95
Looks like either your mysql details are incorrect, or the remote sql hosts are not set up, or in fact any other number of things considering it is not professionally hosted.
-
View User Profile
-
Send Message
Posted Dec 12, 2011@ledhead900
Well I am clearly more than happy for experienced (both with the technology in general and with this plugin) users to help others :)
On the tidying up note. Lots going on about this at the moment, teaming up with someone to really condense down the code and make it much more class based. This will make it easier for others to understand, and easier for new updates. :D
-
View User Profile
-
Send Message
Posted Dec 12, 2011Can any1 help me ? ; <
-
View User Profile
-
Send Message
Posted Dec 12, 2011@Exote
Heh not at all, Your job is to make a functional plugin and keep it working thru bukkit changes as well as keep it bug free as possible, not spend 30min + on optimization time to answer questions that users should be researching on their own. While I understand some users may not be capable of working plugins like this due to the somewhat advanced skills required manage it.
That is their problem if they lack the required skills I don't mind answering people who legit questions or people who take the time type up something constructive. But I won't tolerate having your time wasted replying to people how literally have never used MySQL and have no prior background knowledge into Web servers as that is just user error at cause for their issues.
We both know it works and it can work with minimal to no lag, if others have not grasped the concept on proper installation and planned ahead for the services required then that is again an issue they have to sort out not you.
Now before some of you others decide to hate on me let me just clear up that by legit questions I mean question about functions of the PHP files and changing of the web end stuff, as I understand some of it is complicated enough and easily missed I already asked my fair share of probably annoying questions about where to find certain things and requested certain things be tidy in the php and commented. But what I class as non legit questions are those asking how to setup mysql or web servers or anything related to actual installation rather then fine tuning.
-
View User Profile
-
Send Message
Posted Dec 12, 2011@ledhead900
Doing my job for me, I like it. :P
-
View User Profile
-
Send Message
Posted Dec 11, 2011@ledhead900 Wow thank you! I am blinder than a baboon -.- I was using Notepadd+(+) but I was probably in a rush lol. But thank you so much.
-
View User Profile
-
Send Message
Posted Dec 11, 2011@BluePhase
I'm not sure how u manage to miss it but here it is!
UseMySQL=true set it to use Iconomy table so then u can remove your money deposit withdraw signs. IconTableName=Self Explanatory
I suggest you maybe switch from notepad or what ever it is u are using to edit text files with to Notepad++ as it shows code properly and lets you better see how a config's layout is as it will color certain areas like comments and things. Be sure tho to enter the preferences and turn on TABS = spaces this make its so the Tab key will turn into equal amount of space bar presses, Since you cannot use TABS in YMAL might as well turn it on if your using this editor for code like that or PHP.
-
View User Profile
-
Send Message
Posted Dec 11, 2011@RebornSheep
Ok well with this plugin and also plugins like Iconomy, Log-block/Hawk-eye, Read and write actively to a SQL database so common sense would say to host the database your game uses as if it were part of the game, So host SQL on the Minecraft server, beyond that I need specifics and as you said you just don't have them.
Really you need to know the SQL database is on the exact same server as Minecraft, everything related to Minecraft should be in that SQL database the Host machine.
Web-servers Only read the data stored on these databases , It becomes an issue only when the server/game has to pull the data from over the network or over the internet before it displays in game.
Websites only do fast and light Query checks on disable table query's into the web tables, this process is extremely fast as all it is doing is sending contents stored as it is request also its not very active it will do this once then do nothing until you refresh or choose interact with it.
While Hosting the other-way around e,g SQL server stored on PC B, Minecraft Server on PC A you end up with Minecraft trying to load and write to a remote location this induces latency and bottlenecks, So depending on how the hosting company has this setup you may be limited in speed by the "QOS"(Quality of Service)of the routing gear. If both the Web-host and the Server are in the exact same building it probably will not a LARGE lag but it will be noticeable compared to just running the SQL on the hosting machine If the Web-host is hosted elsewhere and Server hosted elsewhere then this will certainly induce high latency and slow down the Minecraft server as it pauses for data be received/sent by the web-host SQL .
Again this really comes down to how they have the environment configured if they are using "loopback" and "Blades"(Blade Servers) with virtualized Environments then lag probably wont be a factor provided the web-host and the Host server environments are on the same blade or at least the same room.
-
View User Profile
-
Send Message
Posted Dec 11, 2011Hello, I'm using EssentialsEco and my page cannot connect with mysql ; <
What should I do? How config.php should look like in my case?
-
View User Profile
-
Send Message
Posted Dec 11, 2011@ledhead900
I meant where within the config -.- Which part? I can't find the text where it says I put the economy table there.
-
View User Profile
-
Send Message
Posted Dec 11, 2011@ledhead900
It is VeryGames that take care about hosting. My Minecraft server is a seperate server with 16 gb ram. Always have about 94% free of the memory. The webhost is also a seperate server hosted by the same company. The speed between the SQL and the server should be fast since it is loacted at the exact same place. I never had problems with lag before.
I dont know more than that, since i dont host the servers at home.
-
View User Profile
-
Send Message
Posted Dec 11, 2011@BluePhase
-
View User Profile
-
Send Message
Posted Dec 11, 2011Where exactly do I put the database details of my economy table? I don't see a self explanatory option within the config. I have both my WebAuction tables and Economy tables under the same database but I don't see where I put the table information in.
-
View User Profile
-
Send Message
Posted Dec 11, 2011@SirMonsterSlayer
Yeah I will do, but not creating any new features until there is a recommended bukkit build.