[UE4]连接MySQL实例

 

 

原文：
[FREE] VaRest Login System - With PHP and MySQL

https://forums.unrealengine.com/showthread.php?94421-FREE-VaRest-Login-System-With-PHP-and-MySQL

 

Greetings Community,

 

 

I've created an very basic login system with PHP - MySQL - VaRest / UE4.

I share this with you because I didn't see anything for such system in the web and because of that I want to support the community.

 

What you need is :

- Webserver with PHP

- MySQL Server

- UE4.9

- Visual Studio 2013 ( if editor needs to recompile plugin )

 

What to do?

First import the SQL file into your MYSQL Database.

You can write login information into the table.

( Default User is : testuser - testpassword ).

Upload the webfiles to your webserver and change the mysql configuration in config.php.

 

Open the ue4 project and open the game instance. Then change the ServerURL variable * http://[YourHost]/ ( It is important that you make a / on the end and use http:// on the beginning. )

* In version 1.2 http://[YourHost]/api/ ( It is important that you make a /api/ on the end and use http:// on the beginning. )

And now it should work.

 

Tutorial how to setup a webapi on windows:
Unreal Engine 4 - Tutorial - Login System

https://www.youtube.com/watch?v=24NX8tBWKKM

 

Changelog:

V1.2

*Added

Ban System

Basic Webinterface with Registration and Login

 

*Changed

Database Structure

Directory Structure of Webapi

**Please use in Unreal Engine as ServerURL http://(yourserver)/api/

 

NEW:

Download VM with the complete webapi:

http://sparkfire.openapi.devnetworks.xyz/vm/

 

SVN for Webfiles:

https://svn.riouxsvn.com/sf-webapi

 

Download:

Compiled Demo:

https://drive.google.com/file/d/0B3U...94alpjMXc/view

 

Create Account under:

http://sparkfire.openapi.devnetworks.xyz/?page=register

 

UE 4.9.2

V1.0

https://drive.google.com/file/d/0B3UAvQWtBjZnTnY5QTFrdG93Qjg/view

V1.2

https://drive.google.com/file/d/0B3U...VULW5YRlk/view

 

And if you want to support me:

https://gumroad.com/l/hmKou

 

 

 

P.s. Vladimir rocks!:

https://github.com/ufna

Cheers