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
I am at a total loss
The plugin part works, it logged in and created the sql tables
my web config is as follows
$db_host = 'mc.elysium-craft.info';
$db_user = 'derpusername';
$db_pass = 'derppassword';
$db_database = 'webauction';
and i continue to see
Warning: mysql_connect() [function.mysql-connect]: Lost connection to MySQL server at 'reading initial communication packet', system error: 110 in /home/content/15/7657915/html/WebInterface/scripts/config.php on line 59
Unable to connect to databaseLost connection to MySQL server at 'reading initial communication packet', system error: 110
I know I have access to SQL remotely, I am able to I set the the database to allow username@'%' and I am now able to connect to the SQL server remotely with MySQL administrator.
I am sure it's a lot of works :) setting up a Server, i set up also some servers. Can i help you?
Currently setting up my own server/ community etc.
When I am done with that, I will have a go at a proper update for this plugin.
@hunterboerner
Just downloaded them from the minecraft wiki.
Where is the 1.2 download?
How did you get the item logos? I am trying to figure this out for a web control plugin I am making.
@KrYojeNiX Hey, thanks for the reply :D I double checked mySQL in the web server and the Minecraft plugins directories for WebAuction, they both match up and are done correctly. I added in the code, <iframe src="http://(my-web-address-here)/home/content/15/7657915/WebInterface/" frameborder="0" width="1000" height="600"></iframe>, into the html window in my wordpress page and all I get is a "404 (Page Not Found) Error." within the window created by the script. I tried alternate different address combinations out of tinkering, thinking that maybe my home directory was conflicting with the rest of the address, etc. I can't seem to make it display. Could it possibly be that my WordPress has limited software and I need to download a specific .php or html interface plugin? I am using WordPress 3.3.1., WP exec PHP plugin, and WP PHP widget plugin. Could you tell me what your Wordpress version is and if you use any other plugins within this category?
@Larcinion
Assuming you have set up your mysql database connected to your minecraft and uploaded the webauction files to a webserver and done the required settings all correctly then all you need to do in wordpress is, in the text box change the tab at the top for "html" code, now input this line replacing the web address with your webauction folder's address.
<iframe width="1000" height="600" src="http://YourWebsite.com/YourWebAuctionFolder/" frameborder="0" allowfullscreen=""></iframe>
Change the iframe width, height and border to your own preferences.
Change "YourWebsite.com/YourWebAuctionFolder" to the name of your web servers web auction folder address. :D
@pocketkings719
Yep.
BUG: People can add air to WebAuction!
I love this plugin and the features it has to offer. I've followed the instructions extensively but find myself stuck on how to make the plugin display on my website. There isn't a tutorial for the website end of things and I've looked around at some html tutorials but this must be something fairly simple if I had to guess. I am unfamiliar with html and would like to ask what html code, if any, is used to make the plugin display the auction house on a page on a website? (I am using WordPress for my site if this is at all relevant.)
Sincerely, Larcinion
Is this being updated for 1.2?
@nightsdawnit's usually not a good idea to use the root user to connect to a database, except maybe for development. it's good common practice to always set up an account for each database, then if you're connecting to it from a remote server, ie web server, then you usually also have to allow remote access to that account. it would be best to use the web servers ip to grant access, and not use a wild-card %, to keep port scanners out. these are all things that a good tutorial should show you. maybe google has something, but it really depends on your setup. if you use cpanel or webmin or any of those, they usually have a place to allow remote database access. phpMyAdmin also has a place to set it up.
@Exotenot sure what you mean by flat file. I hope you're not dropping mysql support. I install iConomy for only one reason, because essentials doesn't support mysql.
Thanks for the link update. And thanks again to @lorenzo from earlier. I used those links and everything worked perfectly.
I tried setting this plugin up about about a year ago when i was tinkering around with setting up a minecraft server for fun and while I got it to work it would always cause horendous server lag and console errors about the server not being able to keep up.
Last night after configuring iConomy to use a sql database through a website I have through a reseller hosting service I started seeing the same issue and realized it had nothing to do with the plugin itself but some latency issue or some other setting i was missing. So I decided to use wamp instead.
Setting up wamp and configuring both iConomy and WebAuction to point to the same local database was no issue but It took a good 6 hours in-between calls at work today to finally manage to get the webauction (which was hosted on my external webhost) to connect. I was about to give up when I had the thought of not using "root" as the username and poof finally it connected! And no more server errors or other issues =)
This might have been simple for some people but I'm somewhat of a novice and try and learn as I go.
Anyways thanks @Exote for making this plugin. I'm suprised its not more popular, and TY! for getting rid of spout and moving over to just signs. The only reason I used spout a year ago was for just this plugin and waiting for them to update is crazy.
OMG Really THANKs bitch!
@BluePhase
Aren't there any modifications to the web files?
@Exote
I am very glad to see you back Exote! I have been updating and maintaining the plugin for 1.2.3, few changes were made but nothing major. I haven't had time to do anything big since I was inactive for the past 2 days. But again, here are the links for my updated version. You must have vault, if you don't it will not work.
Here are updated files for 1.2.3!
Plugin:
http://thebeauxart.com/download/WebAuction.jar Supports Java 1.6!
WebFiles:
http://thebeauxart.com/download/WebInterface.rar
Images courtesy of @lorenzo_p
@Exote
I can't wait :)
this plugin can be use on .net(c#) ? if i dev the .net version base on php ?
@Exote
Thank you really much! :D