Share My Creation [B4J] [MySQL] [API] Server (Key + Token) and [B4X] User Login Apps

Updates:
Latest B4XPages user login client apps (using B4J server): https://www.b4x.com/android/forum/threads/project-template-user-login-client-b4x.161914/

Finally I would like to share my B4J API server written in B4J.
Compare to my previous PHP API, this API server implements user access token to authorize user to consume the API.

SQL.zip - SQL script to create necessary database and tables in MySQL server.
jAPI.zip - Source code for server app (B4J).
B4A.zip - Source code for client app using default template (B4A)
B4X.zip - Source code for client app using B4XPages template (B4A, B4i and B4J)

Live server: https://api.puterise.com:17179

12 Jan 2021: Attached B4J client sample. This is a beta version. Some bugs and features will be fixed in the future.
13 Jan 2021: Attached B4X client sample. This is a beta version. Some bugs and features will be fixed in the future. B4J.zip removed.

 

[pixet]

There are no errors reported,
the only message displayed "[{" result ": - 1," message ":" Error-Not-Activated "}]"
The table: "tbl_users_log" contains in the field log_type = "[Not Actived] email", the table "tbl_error" is empty.
If I try to log in, it replies that the user is not active.
How can I force user activation?
Thank you

 

[aeric]

There are no errors reported,
the only message displayed "[{" result ": - 1," message ":" Error-Not-Activated "}]"
The table: "tbl_users_log" contains in the field log_type = "[Not Actived] email", the table "tbl_error" is empty.
If I try to log in, it replies that the user is not active.
How can I force user activation?
Thank you

Activation email. You can also append the user activation code from user table to the URL.

For example:

https://api.puterise.com:17179/user/activate/vhbgroalh90akyyypt0ah3qjo5gpb0bx

API documentation:

https://api.puterise.com:17179/user

 

[pixet]

[SOLVED],
the suggested actions worked.
Thank you

 

[aeric]

Is it worth remaking this old project (server) using Web API Server Template 2 and convert the client to B4X project template?

 

[cklester]

Is it worth remaking this old project (server) using Web API Server Template 2 and convert the client to [B4X] Web API Client (B4XPages)?

I vote Yes!

 

[aeric]

I have just published a beta version. It is not fully tested but should works for sqlite db for Web API server backend. MySQL database is not yet tested.
The client has been tested for B4A and B4J. B4i is not tested.

[Project Template] User Login Client [B4X]

Version: 1.01 Description: Remake of MySQL API Server (Key + Token) and [B4X] User Login Apps Many bugs in previous project have been addressed. It is now showing how long a user last login. The main page for showing a list of user online is just a simple example. This template can be use for...

www.b4x.com

[Project Template] User Login Server

Version: 1.01 Description: Remake of MySQL API Server (Key + Token) and [B4X] User Login Apps This is not just a basic template. It is fully functional user registration and login system with user reset and change password. The token will expired in 10 minutes (you can set it like 30 minutes...

www.b4x.com

 

[aeric]

I have just published a beta version. It is not fully tested but should works for sqlite db for Web API server backend. MySQL database is not yet tested.
The client has been tested for B4A and B4J. B4i is not tested.

[Project Template] User Login Client [B4X]

Version: 1.01 Description: Remake of MySQL API Server (Key + Token) and [B4X] User Login Apps Many bugs in previous project have been addressed. It is now showing how long a user last login. The main page for showing a list of user online is just a simple example. This template can be use for...

www.b4x.com

[Project Template] User Login Server

Version: 1.01 Description: Remake of MySQL API Server (Key + Token) and [B4X] User Login Apps This is not just a basic template. It is fully functional user registration and login system with user reset and change password. The token will expired in 10 minutes (you can set it like 30 minutes...

www.b4x.com

The server template is now fully functional with MySQL and SQLite databases. All functions are tested with B4A and B4J. If you encounter issue in B4i, please let me know.