Hello, this is the first time i’m posting here, hello everyone!
using the LE Http Request Plugin (but i think it works also with VaRest) i am developing a PHP Backend for handle user information, inventory, custom data, buyed item and more.
Something like a private Cloud Save for saving any information you want/need, but also for user registration, login and so on.
Concept
Editor Side: from the Unreal Engine 4 editor you can send request over HTTP with SSL to PHP “Backend” using LE Http Plugin (or using VaRest)
Note: i don’t have right now the money needed for the Encryption Library, but in future i want to implement it.
The request are sended using a Secret Key, SSL and POST {GET = internal testing only}
Backend View:
Requested will be processed, so is possibile to retrieve, update and also delete data from MySQL/MariaDB Database
Usage/Concept Example
Retrieve Username with UserID
UE4 Request
Reply
Retrieve Inventory List with UserID
This is actually in development, if you’re interested in this i can release it when is complete, if you have any suggestion about it let me know!
This list will be updated frequently || Last Update: 10 February 2018
– Current Status –
Actually implemented functions:
- UserAuthentication [Login and Registration] using bcrypt hash
- UserData [Retrieve, Update and Remove]
- UserInventory [Retrieve, Update, Add and Remove]
- UserOwnedShop [RetrieveAll, Retrieve, Add, Remove]
Change
- Optimization in Database class library
- SQL Injection “100% bullet-proof” query and code method [Additional Security]
- Optimized code and fastest query execution
- Added STEAMID value in Database for Authentication trought STEAM
To Do Next
- Working On: Additional Functions
- Future: Encrypted request and reply [Additional security layer concept]
- Testing: Change to Percona Server from the standard MySQL or MariaDB [fastest response time for query execution]
– Current Status –