WebAuctionPlus
WebAuctionPlus - eBay for Minecraft!
A minecraft/bukkit shop plugin for your website! This is a rewrite of the original WebAuction with many new features and improvements. I've made to many improvements to the code to list on one page. Many of my plans require big changes and a lot of new code. As with any new code, bugs are to be expected, so please bare with me and report any bugs you come across.
Note: It is strongly recommended you backup your database before using or updating this plugin. Some of the bug fixes and performance improvements I'm making require big changes to the database. The WebAuctionPlus plugin will convert and update the database automatically the first time it's run.
New virtual inventory MailBox has been added with the update of Minecraft 1.3 and WebAuctionPlus 1.1. When a player right clicks on a MailBox sign, it opens up their virtual mailbox inventory and locks their website account to prevent item dups. When they close their mailbox, it updates their inventory and unlocks their website account. NOTE: This feature is new and running single threaded. If you experience lag related to this, I can see what I can do to make it multi-threaded.
Requires: Vault - http://dev.bukkit.org/server-mods/vault/
Requires: Web server with PHP and MySQL
Optional: SignLink - http://dev.bukkit.org/server-mods/signlink/
A few improvements by lorenzop
- new ajax listing code (fast!)
- new virtual inventory mailbox
- all new web interface
- all new item deposit/withdraw code
- database connections are handled better
- connection pool limits can be set in config
- task update times are now configured in seconds
- tasks can be disabled by setting the update frequency to -1
- new announcement system
- added "/wa reload" and "/wa save" commands
- accounts can be created or passwords changed from the console
- multi-language support
To do
- server shops (unlimited stock improved)
- better support for vault economies
- custom description for items being sold
- wish list / auto sales
- track all wa signs to prevent unauthorized signs
Youtube Videos
Languages
If you'd like this plugin translated to another language, feel free to download the en.yml file from the link above, translate it to your own language, and send it to me.
Signs
WebAuctionPlus signs can be created by placing a sign with [WebAuction], [WebAuction+], or [wa] on the first line. Case doesn't matter, the plugin will fix it for you.
Note: you cannot use the deposit mailbox sign while in creative mode. this shouldn't ever be needed in the normal operation of the plugin, so as a general protection, it's always denied.
Note: withdraw mailbox signs can now have a quantity of stacks on the last line, or leave it blank for all mail.

SignLink
- %waTitle - items name
- %waPrice - price each
- %waSeller - sellers name
- %waType - Buy Now or Auction
Source Code
Development Builds
Development Builds can be found at the link below. Development builds aren't approved by the bukkit team and they might be buggy.
Commands
- /wa password <apassword> - Changes your Web Auction Plus account password, or creates an account if you don't have one. This command can also be used from console in the format: wa password <playername> <apassword> and short-hand aliases "pass" or "pw" can be used in place of "password". For example, /wa pw mypassword123
- /wa mailbox - Opens the WebAuction mailbox.
- /wa deposit <amount> - Deposit money into your Auction account.
- /wa withdraw <amount> - Withdraw money from your Auction account.
- /wa reload - This feature is currently broken and disabled. It will be working again soon.
- /wa update - Forces recent signs to update. Also updates SignLink signs.
- /wa version - Displays the current running version of Web Auction Plus.
Permission nodes
note: these may change at some point
- wa.use.mailbox (use mailbox sign)
- wa.use.deposit.money (use money deposit sign)
- wa.use.withdraw.money (use money withdraw sign)
- wa.use.command.mailbox (use the mailbox command)
- wa.use.command.deposit (use the deposit command)
- wa.use.command.withdraw (use the withdraw command)
- wa.announcer.receive (can see auto announcements)
- wa.password.create (can create a new account)
- wa.password.change (can change their password for an existing account)
- wa.canbuy (can buy from web auction)
- wa.cansell (can sell with web auction)
- wa.create.sign.mailbox (create mailbox sign)
- wa.create.sign.deposit (create money deposit sign)
- wa.create.sign.withdraw (create money withdraw 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)
- wa.reload (reloads the WebAuctionPlus config)
How to Install
Join us and chat some time on our irc channel. #webauctionplus on esper.net webchat.esper.net
Plugin Usage
As I've said in comments, I don't agree with the mojang buyout. as much as I've enjoyed working on this plugin and want to see it continue, I'm no longer doing all the work. MarioG1 has stepped up to work on the plugin. I may still help somewhat if he wants, but I'm passing the torch to him as the lead. good luck, hope you write some good code and features.

-
View User Profile
-
Send Message
Posted Aug 20, 2012@serfma
it may have to do with the version of mysql the server is running. I'm starting working on switching over the website to using mysql improved and prepared statements, so that should fix this problem and any similar problems in the future.
-
View User Profile
-
Send Message
Posted Aug 20, 2012@lorenzo_p
It's hosted on a Dedicated server (VanquishVPS) so it COULD be Linux or Windows. I've used MySQL on my Windows PC to test it and it worked fine without that problem.
-
View User Profile
-
Send Message
Posted Aug 20, 2012@MarioG1
fixed the price issues. thanks for reporting those.
about the multiple stacks, the problem is, each row in the on site inventory is associated with an id number in the database. there's no easy way to merge stacks of the same type, and performance would take a hit. I do have an idea to try that will let players add stacks to an existing auction. when someone clicks the sell button and goes to the page where they create the auction, I could have it list their existing auctions of that same item type at the bottom of the page. then they could click a button there to add the stack to that auction. I think this will be the best way to handle it, but I have another idea for a possible feature too. there could be a compress button on their My Items page, which would combine stacks of the same type into larger stacks. the only problem with this, when they open their in game mailbox, it'll split them apart again. I could have it automatically merge stacks when they view that My Items page, instead of using a button to do it, but that seems like a lot of unnecessary processing it would do every time that page loads.
anyway, there are my thoughts on that. now, back to work :-)
-
View User Profile
-
Send Message
Posted Aug 19, 2012I found an bug:
You can Create auctions when the price per item is below 0.01$ (0.001$).
This causes that the price per item, on the main page is shown as 0.00$ and you can't buy it.
I also have an suggestion:
The web page should recognize multiple stacks of the same item in the WA-Inventory and should show them as one stack of 128 Items if there area two 64 stacks of something in the WA-Inventory.
And if you create auctions you should limit the total price to 2 decimal places because this
http://etg.dyndns.org/images/temp/wa_price.png
doesn't look nice :)
Thx. for the bug fixes!!
-
View User Profile
-
Send Message
Posted Aug 19, 2012@serfma
someone else reported that problem too. is your mysql server running windows? I thought sql was handled the same across all platforms, but I guess enums are slightly different between windows and linux. I'll try to get this fixed and an update out tomorrow. I have a quick and easy fix in mind for it, but for a more long term fix, I think I'll switch everything over to the mysql improved api.
-
View User Profile
-
Send Message
Posted Aug 19, 2012@lorenzo_p
Thank you so much this will make my server so much better! If you can do the limits that would be amazing as well.
-
View User Profile
-
Send Message
Posted Aug 19, 2012MySQL ERROR - File: /home/content/45/8908645/html/auction/inc/classes/logSales.class.php Line: 29 Data truncated for column 'itemType' at row 1
INSERT INTO `WA_LogSales` ( `logType`, `saleType`, `timestamp`, `itemType`, `itemId`, `itemDamage`, `itemTitle`, `enchantments`, `seller`, `buyer`, `qty`, `price`, `alert` ) VALUES ( 'new', NULL, NOW(), '', 261, 0, 'Bow Brand New!', '', 'serfma', '', 1, 5, 0 )
Just transferred the whole plugin to point to a brand new database (named sneaky) and I get this every time you attempt to sell an item. You click "Sell Item", Put in the amount you want to sell it for, hit Submit and it pops this up. However, if you refresh the page or go back to the webpage it will be up for sale like normal...
-
View User Profile
-
Send Message
Posted Aug 19, 2012@McEvan7
sure. I'll see what I can do to get an auction limit per player added tonight. about that error, my test server is set to display all errors and warnings, so it's odd it didn't show up for me. there's an easy fix for it. just look for line 104 of index.php
change it to this, just adding the @ if(!@date_default_timezone_get()) date_default_timezone_set('America/New_York');
that line is just a temporary fix anyway, until I figure something out for handling time zones better.
-
View User Profile
-
Send Message
Posted Aug 19, 2012@lorenzo_p
Thank you for the update. Is it configure able to limit the amount of auctions a player can have in the auction house at a given time? I didn't see anything about it I may have missed it. If not would you be able to change this ?
EDIT:
I'm having trouble with setting up the web part of the plugin I get this error http://pastebin.com/WUp7XYG4 if anyone could help me that would be very appreciated.
-
View User Profile
-
Send Message
Posted Aug 19, 2012here's the update. fixed the last few bugs that were reported, added more tekkit items, added /wa reload command, and /wa update command for recent signs. if all is well, I'll upload this version as a recommended update. http://webauctionplus.googlecode.com/svn/trunk/WebAuctionPlus-1.1.4alpha.zip
-
View User Profile
-
Send Message
Posted Aug 18, 2012Just a curious question, when would this be available for 1.3.1?
-
View User Profile
-
Send Message
Posted Aug 17, 2012@MarioG1
nice job finding that one. that is an error that should never come up on any decently programmed website. it's actually a security hole. I missed a string sanitize on one line. all fixed. I'll try to have it out tonight some time. if not, it'll be early morning most likely.
-
View User Profile
-
Send Message
Posted Aug 17, 2012I get this error if i try to sell an Bottle o' Enchanting:
MySQL ERROR - File: C:\Web\Minecraft\WebInterface\inc\classes\auction.functions.php Line: 41 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Enchanting', 799, NOW() )' at line 1
INSERT INTO `WA_Auctions` (`playerName`, `itemId`, `itemDamage`, `qty`, `enchantments`, `itemTitle`, `price`, `created` )VALUES( 'MarioG1', 384, 0, 1, '', 'Bottle o' Enchanting', 799, NOW() )
-
View User Profile
-
Send Message
Posted Aug 17, 2012@DjBuRnOuTQc
thanks, much appreciated :-)
@Silvrey
sure, you're welcome to modify the footer.php file. if I put something in WA_Settings for that, it would be limited to 255 characters. I could add a place for it in config.php to add whatever you'd like to the header or footer. possibly in the update I'll have ready tonight.
@DerDarcion
I'll post a link to it tonight
-
View User Profile
-
Send Message
Posted Aug 17, 2012where and when do we get the new version 1.1.2 alpha or some newer beta?
-
View User Profile
-
Send Message
Posted Aug 17, 2012I want to add a legal notice in the footer of the website. Can I do that? Or can you add a feature for this?
-
View User Profile
-
Send Message
Posted Aug 16, 2012@lorenzo_p
Awesome to know! I just gave you a little 10$ to show you my gratefulness. Keep up the good work and thanks again!
-
View User Profile
-
Send Message
Posted Aug 16, 2012@Security111
unsure what you mean
@DjBuRnOuTQc
yup. short vacation visiting family, but I'll be home tomorrow and I'll get it compiled. my laptop was acting up again, wouldn't boot. jumped on the hotel bed with my friend and it starts booting up :-D anyway, all known bugs have been fixed. there's possibly a bug with money payments, but it may just be confusion about amounts displaying wrong in the last version. if that's all it is, it only affects logs and sale alerts, but payment amounts behind the scenes are the correct amounts.
@comniemeer
haven't tried it myself. should work fine. give it a try and let me know how it works :-)
-
View User Profile
-
Send Message
Posted Aug 16, 2012@lorenzo_p
Thank you lorenzo_p! All worked fine! And now I like to know if I can change the currency symbol in the WA_Settings-Table to € or if WA+ will crash?! Thank you again!
-
View User Profile
-
Send Message
Posted Aug 15, 2012Will you compile the a new version with your latest fixes soon? I saw that you fixed the largestack bug on your github.