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 Feb 10, 2012@RetroCraftMC
Yup, as I said before change line 4 from:
RewriteBase /To
RewriteBase /webauction/Or whatever the name of your subfolder is.
Wait no not every .htaccess just the one in the very first directory, (one which also has fuel and assets folders in it)
-
View User Profile
-
Send Message
Posted Feb 10, 2012Are you saying I have to edit every .htaccess file?
-
View User Profile
-
Send Message
Posted Feb 10, 2012@ledhead900
Yeah it is something about the server client's connections.
If you know how to edit mysql tables, allow user_data to be null, and see what it says when you try and load the home page.
Also add moehb on steam if you want to communicate faster.
-
View User Profile
-
Send Message
Posted Feb 10, 2012@Exote
I copied the minecraft.sql over to our minecraft server machine. I opened up MySql Workbench.
I already had a minecraft scheme setup with other various tables in it so I selected that one then I opened the minecraft.sql script and executed it into the database with 0 errors upon completion.
I then refreshed the database and had a look at the tables it generated and they appear to be there a bunch of fuel prefixed tables and Wa ones and that ci_session table.
Keep in mind the Website is not hosted on the same machine as the minecraft server. All remote access to and from the remote sql database's have been enabled on both ends the webhost database and the minecraft server database.
Like I said I run other things like Hawkeye and they all are connecting fine and talking with to the machines correctly.
EDIT After about several hours I had a couple of Jar errors pop up. http://pastebin.com/vGLPXKEM & http://pastebin.com/TZC4cJyz - - about 10 times in row, was quite spamy
Here is my config with out the database bits of course but I know they are correct
-
View User Profile
-
Send Message
Posted Feb 10, 2012@ledhead900
Did you import the database properly?
-
View User Profile
-
Send Message
Posted Feb 10, 2012@Exote
Nope I am just getting the error I posted Here Exact same one as I was getting before you added the htaccess redirect that I have setup but has solved nothing for me. In the comment I think you missed that I mentioned that I think this is a database error or its not communicating with the database correctly.
I had no issues with your prev website well none that I could not promptly fix by reading the error code, but this one has me beat.
-
View User Profile
-
Send Message
Posted Feb 10, 2012@RetroCraftMC
Looks like you didn't edit the .htaccess file
@ledhead900
The command /wa password no longer exists but I havent updated the help file to say that yet. Have you got to the setup home page yet?
-
View User Profile
-
Send Message
Posted Feb 9, 2012@RetroCraftMC
http://retrocraftmc.com/webauction/index.php works fine for me as does http://retrocraftmc.com/webauction/
-
View User Profile
-
Send Message
Posted Feb 9, 2012Go to http:retrocraftmc.com/webauction/index.php If you notice, evertime I go to a page it gives me a 404 error.
-
View User Profile
-
Send Message
Posted Feb 9, 2012@Exote
Awesome news will give this a test.
Edit: My error persists, I can't find were to change the port though in your new files for the database, Maybe that is why ? though its running on mysql default port.
Edit: Ok this is strange, The error that I had from ingame was fixed but using /wa password password results in no user profile created in the MYSQL database and the server will just repeat the line that it says when you try and setup your password wrong eg,"/wa mypassword.
Could this be related to the website issue, as it clearly not adding users who register in game and the webpage is telling me that the CI_sessions has no default value this appears to be what is stopping the site from loading as even with a sub folder it shows this error instantly, That is a database error not a file not found error on the website this ci_sessions or what ever that is for is making the webpage act up..
-
View User Profile
-
Send Message
Posted Feb 9, 2012@ledhead900
@Taketheword
Try the Dev links at the top of the page again to download a new version of the files.
In the root of the WebAuction folder is a file called .htaccess edit this so line 4 looks like: RewriteBase /auction/ If your subfolder was called auction, eg. mysite.com/auction/
But as you can see I have got it running on http:webauction.threewisemeh.com/test/
-
View User Profile
-
Send Message
Posted Feb 9, 2012@Taketheword
Forgot to mention, I'm also RetroCraftMC. That account is just for my server and this one is my personal account :P.
-
View User Profile
-
Send Message
Posted Feb 9, 2012Yes please, once you figure out how to run it out of a subfolder or atleast redirect links to a subfolder, give me the updated download links. :)
-
View User Profile
-
Send Message
Posted Feb 9, 2012@Exote
Awesome coz I can't use a sub domain Im not the domain host, I simply use a port 80 redirect from No-Ip, So this will of course lead to issues I know now it has something to do with the sub folders, Its looking for this driver.php file but cannot find it the scripts are not running due to fact its looking in the root but it shouldn't be.
I'm not a web developer or anything like that I just know how to make a site work over the internet. Looking forward to this fix as right now we have no web auction :(
-
View User Profile
-
Send Message
Posted Feb 9, 2012@RetroCraftMC
I understand the problem, and how to fix it. But it will require me to prepend the base url config value onto all the page redirects around the place. Will get an update out soon.
@ledhead900
Looks like you are having similar problems with the fact you are using a sub folder not a sub domain. Trying to get a fix so this works.
-
View User Profile
-
Send Message
Posted Feb 8, 2012@Exote
Could you PM me to try and work out what went wrong with the dev version install.
-
View User Profile
-
Send Message
Posted Feb 8, 2012( ! ) Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in C:\wamp\www\Webmarket\index.php on line 19 Call Stack
This occurs when I have been as true useMySQLiConomy.
-
View User Profile
-
Send Message
Posted Feb 8, 2012Please answer my previous question.. It is still not working.
-
View User Profile
-
Send Message
Posted Feb 8, 2012@nicom1997
There are already static auctions where admins set the buy / sell prices and players can buy / sell infinite numbers of those auctions.
-
View User Profile
-
Send Message
Posted Feb 8, 2012Can you add a function to sell Items directly with "Admin Auctions" please?