AShops
Version 2.3 is now available!
AShops allows players to sell and buy items with a chest. Unlike many other shop plugins, it doesn't use signs to represent a shop offer. Instead, it uses chest inventories and item descriptions and thereby makes possible to sell or buy (or both) items of different types using only a single chest. It means less chests and time spent on creating shops. Using description as an offer details source makes shopping also more friendly than reading a raw text from a sign, and by representing an offer as a real item, not only it is easier to find what you need, but it also allows you to sell/buy the exact item you have in your inventory, with all data it contains.
(prepared by Lambert from Bosnia and Herzegovina)
What's new in 2.0?
- New shop interface! You don't have to use commands anymore. (see the next section for more info)
- Transaction notifications work even when a shop owner is offline.
- + old features: income taxes, shops limits, minimal price limits, server shop account.
How to use the new interface?
- To create a new shop you have to place a chest and attach a sign to it or above it. For a player shop set first line to :as:, for a server shop: :ass:.
- To manage your shop (add offer, open/close it, remove it) shift-right-click on the sign and use menu icons. Read icon descriptions for more info on manager options.
- To sell/buy items from other players' shops left click on a shop sign and then on an item you want to buy/sell. Read icons' descriptions for more info on trade options.
- To load/collect items from/to your shop left click on a shop sign and then on an offer's icon. If you manage other players' shops or server shops, you will have to use a right mouse button to manage an offer.
- You still can use commands to create and manage shops. Use /ashops command to list all available commands.
How to install this plugin?
- Place AShops.jar file in the /plugins/ folder.
- Set database to MySQL in the bukkit.yml file in a server main directory.
database: username: userName isolation: SERIALIZABLE driver: com.mysql.jdbc.Driver password: databasePassword url: jdbc:mysql://hostName/databaseName
- Make sure you set the following properties to the correct values: username, password, url.
Permissions
- ashops.operator - a set of permissions for a server operator.
- ashops.manager - allows to: create a new player shop for other players.
- ashops.player - a set of permissions for a player.
- ashops.servershop - allows to: create a server shop.
- ashops.playershop - allows to: create a player shop.
- ashops.buy - allows to: buy items from shops; buy items in own shops if a player has also permission to create one.
- ashops.sell - allows to: sell items to shops; sell items in own shops if a player has also permission to create one.
- ashops.free - allows to: create player shops for free.
- ashops.unlimited - allows to: create create any number of player shops.
- ashops.anyitem - allows to: sell or buy any item.
- ashops.anyprice - allows to: sell or buy items for any price.
To the Users of previous versions
AShops 2.0 is not backward compatible. We changed a database system to more reliable one and now we have to use other structure of tables. AShops doesn't support a flat files storage system anymore - now it works only with MySQL databases and, hopefully, it will support SQLite soon. All features that used WorldEdit will be released as a separate file.
Thanks for 10000+ downloads ;) ! It's great result for us.
Waiting for 20000 and more :)
I fixed the problem guys. Few things to check. I'm running MCPC not CraftBukkit. I tried on both and had the same problem at first and I know a server sucessfully running MCPC & Ashops.
Anyways I got it to work on both craftbukkit and MCPC. If you're using MCPC check your bukkit.yml again after running your server the first time with Ashops. For some reason my database named changed from localhost/ashops to localhost/ashopsmcpc;
First of all, no ";" should be @ the end. Secondly why the hell is it called ashopsmcpc maybe it's a mistake I made, maybe not.
Second thing to check is the driver. For some reason my driver reverted back to org.sqlite.jdbc.driver when I was using MYSQL so I changed my driver to com.mysql.jdbc.Driver.
My Bukkit file reads as such now and is working successfully.
I checked AShops with the newest version of CraftBukkit and it works. If you have issues with your datebase, delete all plugin's tables and let AShops generate them again. (Sometimes it helps to restart mysql after deleting tables.)
I'm still waiting for any Austin response... We must wait a bit more. It seems much likely that bukkit 1.6.4 R2 is incompatible with current Ashops.
I have the same issue as DrFeelGoodd. I run official craftbukkit 1.6.4-R2.0 and LogBlock if this helps. Also AShops creates database file but no config.yml.
@DrFeelGoodd
Hmm... I really don't know where the issue is. It's second or third case of this issue.
Can you check for example HawkEye or LogBlock or another plugin that needs mysql? If one of them works, then:
- Configuration in bukkit.yml is wrog somewhere (unlikely). - You guys have unnoficial 1.7.2 build of spigot, it's unsupported much likely. - Newewst recommended bukkit is incompatible with current ashops. - Plugin has bug with creating new tables.
I'll contact with Austin today.
Hi I've successfully installed MSQL on my computer & Forwarded all of my ports. I used all the correct information inside of my Bukkit.yml & Ashops is on my server and functioning with /ashops it shows the version & Command list.
However I have an issue with :as: on the signs. This is what appears in my server console logs when I try to put :as: on a sign above my chest.
btw reading below. I don't have PHPMyAdmin Installed on my PC. Just MySQL Community & MySQL Command line.
If I delete the database/Schema "ashops" Which is what I've named my database then I get the error "unknown database" and ashops will not load on my server at all. To counter this I manually created a blank database named ashops in MySQL. Then it works but with the first stated problem above. & The error below.
@dragonl
Check password, database url and database name in your bukkit.yml config.
Also, try to remove ashops database by PhpMyAdmin and let bukkit to create new one.
Hi, I just put this plugin, it seems incredible. I set bukkit.yml with mysql database. When I start the server does not show any errors, but when I try to open a store I get the following error:
I have bukkit version 1.6.4. Does anyone know where can be the error? =(
nvm got it working I deleted all the files from the database then tried again and it worked
i did doesn't work the files go to the database but when i create the sign it says an error has occurred please contact the server operator
@tremby90
You should read the "How to install this plugin?" :)
oh and i get these error in the console
Caused by: java.sql.SQLException: Field 'id' doesn't have a default value 10:28:24 PM CONSOLE: [SEVERE] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1073) 10:28:24 PM CONSOLE: [SEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3593) 10:28:24 PM CONSOLE: [SEVERE] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3525) 10:28:24 PM CONSOLE: [SEVERE] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1986) 10:28:24 PM CONSOLE: [SEVERE] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2140) 10:28:24 PM CONSOLE: [SEVERE] at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626) 10:28:24 PM CONSOLE: [SEVERE] at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2111) 10:28:24 PM CONSOLE: [SEVERE] at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2407) 10:28:24 PM CONSOLE: [SEVERE] at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2325) 10:28:24 PM CONSOLE: [SEVERE] at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2310) 10:28:24 PM CONSOLE: [SEVERE] at com.avaje.ebeaninternal.server.lib.sql.ExtendedPreparedStatement.executeUpdate(ExtendedPreparedStatement.java:164) 10:28:24 PM CONSOLE: [SEVERE] at com.avaje.ebeaninternal.server.type.DataBind.executeUpdate(DataBind.java:74) 10:28:24 PM CONSOLE: [SEVERE] at com.avaje.ebeaninternal.server.persist.dml.InsertHandler.execute(InsertHandler.java:155) 10:28:24 PM CONSOLE: [SEVERE] at com.avaje.ebeaninternal.server.persist.dml.DmlBeanPersister.execute(DmlBeanPersister.java:105)
I keep getting an error: try again or contact your server operator but when i look in the mysql I see the files there wtf how do i fix this
@brdeadmaster
I can't open these images (10 minutes of waiting and nothing loads...), use better image hosting, eg. imgur.com
@wydgabriel
Unfortunately, yes... You need a mysql database. But you can search for free mysql database in google, or wait some weeks for version 3.0 - this one will have flat file storage again.
So.. I need to pay some company to make me one MySQL database just to use this plugin?
WTF
http://image.ohozaa.com/view2/xaOcQUaYFoPLOECG http://image.ohozaa.com/view2/xaOd6veZ92BxSTg2
How to install I don't understand is..... Thanks.
@Pixiyo
I don't know details, but version 3.0 should give us a possibility for transfer shops data to new versions. I don't know why Austin didn't make simple conventer from 0.5 do 2.0... Version 3.0 should have flat file storage again, but noone knows when it'll come... Austin is a little busy now :<
@krisukun
@krisukun
And when the new ashops comes, will there be an option to transfer the database?
@Pixiyo
It's safe operation, no need to be worried. I tried this operation many times and everything is ok.
You can do a backup of your server's data, if you're still not sure.