Atlas Shop, Currency & Kits

[Visual]

Try this: https://pastebin.com/NKNDaXpJ

A lot of your blueprint paths were wrong. You can try using a validator to check for errors yourself: https://jsonformatter.curiousconcept.com/ This will only work 95% of the time though as the json could be correct but not what the plugin can read correctly.

 

[Nameless]

@Michidu I got alot of stuff figured out today with the shop awesome plugin btw! The only thing I've noticed during testing so far is an issue with selling items. For example I can buy 100 copper ingots from the shop no problem it's responsive no lag! But when I try to sell that 100 copper ingots I get rubber banding on the server for a good 20~30 seconds and then the sell goes through. Everything else seems to work fine on the buying side, creatures or items.

 

[ralohdesigns]

Try this: https://pastebin.com/NKNDaXpJ

A lot of your blueprint paths were wrong. You can try using a validator to check for errors yourself: https://jsonformatter.curiousconcept.com/ This will only work 95% of the time though as the json could be correct but not what the plugin can read correctly.

Thank you, any idea why it would fail to load though?

 

[Michidu]

@Michidu I got alot of stuff figured out today with the shop awesome plugin btw! The only thing I've noticed during testing so far is an issue with selling items. For example I can buy 100 copper ingots from the shop no problem it's responsive no lag! But when I try to sell that 100 copper ingots I get rubber banding on the server for a good 20~30 seconds and then the sell goes through. Everything else seems to work fine on the buying side, creatures or items.

Will check it.

Nope, I get a Error 1114 when trying to manually load it. The directory I have is correct.

Most likely it's because plugin can't connect to the db.

 

[Visual]

@Michidu Are you able to do anything about the %chance of alphas being bought? We think it's less than 5% chance from testing by just buying the base bp of the animals

 

[ralohdesigns]

@Michidu Is there a way I can find the reason it is not connecting to the DB. I am very new to MySQL, so this is a tad bit confusing to me. I have the Localhost information, password, and database info correctly placed. I know this because Permissions plugin is working just fine with the same info. Do I have to use 2 different databases for these 2 plugins maybe?

I've troubleshooted including the port in the hostname AND including the port in the hostname. Neither seem to work. Is there anyone here who has it working on a normal MySQL server? I did see someone mention SQLite worked for the Shop.

 

[patcher]

@Michidu Is there a way I can find the reason it is not connecting to the DB. I am very new to MySQL, so this is a tad bit confusing to me. I have the Localhost information, password, and database info correctly placed. I know this because Permissions plugin is working just fine with the same info. Do I have to use 2 different databases for these 2 plugins maybe?

I've troubleshooted including the port in the hostname AND including the port in the hostname. Neither seem to work. Is there anyone here who has it working on a normal MySQL server? I did see someone mention SQLite worked for the Shop.

I would just adjust this: "DbPathOverride":"",

to something like this: "DbPathOverride": "C:/Atlas/ShooterGame/Binaries/Win64/AtlasApi/Plugins/AtlasShoptest.db",

 

[ralohdesigns]

@patcher isn't that for sqlite only?

 

[ralohdesigns]

Anyone know if this plugin uses InnoDB or MyISAM table structures?

 

[patcher]

Anyone know if this plugin uses InnoDB or MyISAM table structures?

I don't get what your intentions are? Are you trying to reverse engineer the plugin?

 

[docjones]

I've troubleshooted including the port in the hostname AND including the port in the hostname. Neither seem to work. Is there anyone here who has it working on a normal MySQL server? I did see someone mention SQLite worked for the Shop.

Shop and perrmissions working with mysql widhout problems in my server.
u must install mysql with legacy autentification.
Use mysql explorer for easy manage database/users.
Create a user in mysql that allow external conections (root are limited to local conections).
You must create manually two schemas (databases) like permisionsdb and shopdb, one for permissions, and another for the shop ( each plugin must have her own database) and configure it in config.json with your mysqluser, pwd, and databasename

 

[ralohdesigns]

@patcher lol, that's funny xD, this is my first time using MySQL for anything. I'm blinding putting in things that make sense to me just to get it to work, highly doubt I could reverse engineer this thing. I am just trying to get it to work on my server. That was a question that my host asked me as he is helping me trouble shoot why Permissions is feeding into the database, but AtlasShop is not.

@docjones I will try the process in which you said.

Error 1114 was mentioned before in this thread, if that person got it to work, I'd like to know how, as that's the error I'm getting.

In all honesty, I don't even know much about what docjones is saying because I'm new to MySQL. If someone knows what they are doing to set it up, I'd literally pay you to get it to work. I need the Points system on my server ASAP.

 

[Michidu]

@Michidu Are you able to do anything about the %chance of alphas being bought? We think it's less than 5% chance from testing by just buying the base bp of the animals

It seems like game does it with some dinos when they are being spawned. Will look if something can be done.

Anyone know if this plugin uses InnoDB or MyISAM table structures?

Don't think it would require some specific structure but InnoDb more common.
docjones described the installation process well.

 

[ralohdesigns]

@Michidu
I did as Docjones described and I still receive the same error 1114. I'll relay the InnoDb to the host of my MySQL servers and see if this helps them. I'm just a middle man, because I know nothing of MySQL xD. Thanks for replying Michidu, much appreciated.

 

[Michidu]

@Michidu
I did as Docjones described and I still receive the same error 1114. I'll relay the InnoDb to the host of my MySQL servers and see if this helps them. I'm just a middle man, because I know nothing of MySQL xD. Thanks for replying Michidu, much appreciated.

You can try sqlite just to be sure it's a connecting issue.

 

[ralohdesigns]

Is there any reason you can think of that the permissions plugin would connect fine, but AtlasShop would not?

 

[Michidu]

Is there any reason you can think of that the permissions plugin would connect fine, but AtlasShop would not?

Do you use separate databases for them?

 

[docjones]

Thats my config shop plugin

   "Mysql": {
        "UseMysql": true,
        "MysqlHost": "192.168.1.3",
        "MysqlUser": "atlas",
        "MysqlPass": "mypassword",
        "MysqlDB": "atlasshop"
    },

and permissions plugin.

{
  "Database":"mysql",
  "MysqlHost":"192.168.1.3",
  "MysqlUser":"atlas",
  "MysqlPass":"mypassword",
  "MysqlDB":"atlaspermisions",
  "MysqlPort":3306,
  "DbPathOverride":""
}

two separated databases are requiered.
u must create both databases manually.
and very important, install / configure mysql with legacy autentification (a option in the install process). , thats all.

View attachment 1260View attachment 1261

 

[ralohdesigns]

I did try two separate databases they didn't work. I will try hosting my own MySQL locally, maybe there is an issue the way the host is setting it up. Thank you, I'll let you know what I find.

 

[yasuno]

Config does not actually reload when using the reload config command. Or at least it does not reload the "Messages" section.