General Information
I'm looking for someone experienced in Java and MariaDB MySQL to fix some bugs of a custom plugin I hired CaptainDev to make a while ago. It's a private plugin I hired him to make for my 1.13.2 Spigot/Paper server.
Basic Plugin Information
The plugin allows crafting and using infinite storage blocks. The items are stored into a MariaDB MySQL database. Items are stored in categories for easy access. Items can be deposited and withdrawn.
Plugin Code Neatness / Quality
Not sure if the plugin's code is neat enough to easily update? Here's an example file from the source code. You can determine whether it's neat enough or not:
https://hastebin.com/okupidogef.java
Here is some information about the source code size:
https://gyazo.com/a1158ba22798cafc550febe05fcbef1a
Plugin Bugs
Please only contact me if you have read this ENTIRE post and are confident you can finish the job.
I am listing for myself. I don't think it's possible to use a middleman for such a service.
Method of Contact: Directly message me on MC-Market.
Time Frame: 4 Days (96 Hours) From time of $30 payment
Payment: $80 ($30 before, $50 after)
Requirements / Terms for YOU:
I'm looking for someone experienced in Java and MariaDB MySQL to fix some bugs of a custom plugin I hired CaptainDev to make a while ago. It's a private plugin I hired him to make for my 1.13.2 Spigot/Paper server.
Basic Plugin Information
The plugin allows crafting and using infinite storage blocks. The items are stored into a MariaDB MySQL database. Items are stored in categories for easy access. Items can be deposited and withdrawn.
Plugin Code Neatness / Quality
Not sure if the plugin's code is neat enough to easily update? Here's an example file from the source code. You can determine whether it's neat enough or not:
https://hastebin.com/okupidogef.java
Here is some information about the source code size:
https://gyazo.com/a1158ba22798cafc550febe05fcbef1a
Plugin Bugs
Issue
Players cannot take out certain stored items from their Infinite Storages. It has happened for an enchanted bow, enchanted armor, an enchanted pickaxe, and an enchanted god sword. It's unclear whether the issue is solely for enchanted gear or not though. Additionally, the issue is not for all enchanted items. Only for certain ones. Many enchanted items can be withdrawn without problems.
More Information
- When you open the Infinite Storage, click into a category, and view the many different stored item types, it will show "Amount: 1" (for all issues reported so far).
* Example: https://gyazo.com/c94391c6bcf0151fbd697b9f20cfa03b
- When you click the item type to view the deposit/withdraw page, it will show "Amount: 0"
* Example: https://gyazo.com/978bacc4084eeef202f3f84a297e9dcc
- When you then try to withdraw/deposit the item it says:
* Example: https://gyazo.com/99ffd24a0766e06310e1e6c103343bf1
Is This Bug New?
It never seemed to be an issue before. It only became an issue after I switched hosts & MySQL databases. However, I tried using an older version of `stored_items.sql` and those items were still in the players' infinite storages and still had the same problem. The older version I tried was a backup from about a week ago. So I'm not sure whether it's the change of hosts/databases that caused it or if players just didn't notice it for the last ~4 months. Most likely something to do with the change of databases.
Any Other Info?
I tried checking the MySQL database inside `stored_items.sql` to find the diamond sword name "`Zapara's Godsword`" (one of the items having problems) but I couldn't find it. I believe the first time it failed to give the item back to the player when they were trying to withdraw it, was the time it was removed from the database.
Players cannot take out certain stored items from their Infinite Storages. It has happened for an enchanted bow, enchanted armor, an enchanted pickaxe, and an enchanted god sword. It's unclear whether the issue is solely for enchanted gear or not though. Additionally, the issue is not for all enchanted items. Only for certain ones. Many enchanted items can be withdrawn without problems.
More Information
- When you open the Infinite Storage, click into a category, and view the many different stored item types, it will show "Amount: 1" (for all issues reported so far).
* Example: https://gyazo.com/c94391c6bcf0151fbd697b9f20cfa03b
- When you click the item type to view the deposit/withdraw page, it will show "Amount: 0"
* Example: https://gyazo.com/978bacc4084eeef202f3f84a297e9dcc
- When you then try to withdraw/deposit the item it says:
* Example: https://gyazo.com/99ffd24a0766e06310e1e6c103343bf1
Is This Bug New?
It never seemed to be an issue before. It only became an issue after I switched hosts & MySQL databases. However, I tried using an older version of `stored_items.sql` and those items were still in the players' infinite storages and still had the same problem. The older version I tried was a backup from about a week ago. So I'm not sure whether it's the change of hosts/databases that caused it or if players just didn't notice it for the last ~4 months. Most likely something to do with the change of databases.
Any Other Info?
I tried checking the MySQL database inside `stored_items.sql` to find the diamond sword name "`Zapara's Godsword`" (one of the items having problems) but I couldn't find it. I believe the first time it failed to give the item back to the player when they were trying to withdraw it, was the time it was removed from the database.
Issue
When a player tries to store gear (tool/armor/weapon) into an Infinite Storage chest, the item disappears. It doesn't go into any category. For example, I tried storing a diamond_sword then checked the Swords category. It wasn't there. I then tried searching for "diamond" in the storage and the only results that came up were two diamond swords I already had in my infinite storage. There were no errors in console for this.
When a player tries to store gear (tool/armor/weapon) into an Infinite Storage chest, the item disappears. It doesn't go into any category. For example, I tried storing a diamond_sword then checked the Swords category. It wasn't there. I then tried searching for "diamond" in the storage and the only results that came up were two diamond swords I already had in my infinite storage. There were no errors in console for this.
- I cannot afford to wipe the database to implement your fixes. You will need to fix it without changing the structure of the database in such a way that will wipe current player data.
- Just because the issue occurred after I switched hosts does not mean I am willing to switch hosts again to solve the issue. The host I switched to is BY FAR the best host I've used, for both support speed/quality and for their location/performance/features. Additionally, all other plugins using the MySQL database work fine. The only change was I had to add "?useSSL=false" to the end of the database name in plugin configs for the MySQL database details. Then for InfiniteStorage I had to add "?useSSL=false&" for it to work (or partly work anyways). As there don't appear to be any other changes, I'm guessing the issue(s) have something to do with adding that info to the config.yml? Maybe it wasn't developed in a way that supports that? Idk. I mean, there are no console errors when server starts.
- Just because the issue occurred after I switched hosts does not mean I am willing to switch hosts again to solve the issue. The host I switched to is BY FAR the best host I've used, for both support speed/quality and for their location/performance/features. Additionally, all other plugins using the MySQL database work fine. The only change was I had to add "?useSSL=false" to the end of the database name in plugin configs for the MySQL database details. Then for InfiniteStorage I had to add "?useSSL=false&" for it to work (or partly work anyways). As there don't appear to be any other changes, I'm guessing the issue(s) have something to do with adding that info to the config.yml? Maybe it wasn't developed in a way that supports that? Idk. I mean, there are no console errors when server starts.
Please only contact me if you have read this ENTIRE post and are confident you can finish the job.
I am listing for myself. I don't think it's possible to use a middleman for such a service.
Method of Contact: Directly message me on MC-Market.
Time Frame: 4 Days (96 Hours) From time of $30 payment
Payment: $80 ($30 before, $50 after)
Requirements / Terms for YOU:
1. You have read everything above and understand/accept it.
2. You are confident you can finish this within the time frame.
3. If you are unable to complete it for whatever reason, you will provide a 100% refund for whatever money you have collected so far. Additionally, you recognize I will provide a negative reputation for having wasted my time. I need this finished as soon as humanly possible and I CLEARLY STATED to ONLY contact me if you are confident you can finish it.
4. You must have at least 10 positive reputation (Discord setups do not count toward this as anyone can easily get them).
5. Provide me with a portfolio when you contact me and any vouches you may have.
6. Do not ask for my Discord in a direct message and provide no additional information. If you'd like to discuss off site, provide your Discord information in a direct message to me with any vouches, your portfolio, and other info.
2. You are confident you can finish this within the time frame.
3. If you are unable to complete it for whatever reason, you will provide a 100% refund for whatever money you have collected so far. Additionally, you recognize I will provide a negative reputation for having wasted my time. I need this finished as soon as humanly possible and I CLEARLY STATED to ONLY contact me if you are confident you can finish it.
4. You must have at least 10 positive reputation (Discord setups do not count toward this as anyone can easily get them).
5. Provide me with a portfolio when you contact me and any vouches you may have.
6. Do not ask for my Discord in a direct message and provide no additional information. If you'd like to discuss off site, provide your Discord information in a direct message to me with any vouches, your portfolio, and other info.
Last edited:
Regardless, thanks anyway for the best of luck.
