[DEV] faf.webapp

Post here if you want to help developing something for FAF.

Re: faf.webapp

Postby Dragonfire » 12 Feb 2014, 14:16

Ze_PilOt wrote:The website will run on FAF server, so direct access to the mySQL tables.


Atm the app has his own player_list table ...
Should we rework that we have direct access to the login table?

Code: Select all
CREATE TABLE `players_list` (
  `player_id` int(11) NOT NULL AUTO_INCREMENT,
  `create_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `status` int(1) DEFAULT 0 NOT NULL,
  `faf_id` mediumint(8) unsigned NOT NULL ,   
  `player_name` varchar(50) NOT NULL,
  PRIMARY KEY (`player_id`),
  UNIQUE INDEX (faf_id)
)


Otherwise we have redundant data ...
My native language is not english, please correct me, because I want to improve my skills # Resource Overview
User avatar
Dragonfire
Evaluator
 
Posts: 559
Joined: 19 Dec 2013, 10:18
Has liked: 39 times
Been liked: 61 times
FAF User Name: Dragonfire

Re: faf.webapp

Postby Ze_PilOt » 12 Feb 2014, 14:31

Yes, it has to use the FAF one.
Nossa wrote:I've never played GPG or even heard of FA until FAF started blowing up.
User avatar
Ze_PilOt
Supreme Commander
 
Posts: 8985
Joined: 24 Aug 2011, 18:41
Location: fafland
Has liked: 18 times
Been liked: 376 times
FAF User Name: Ze_PilOt

Re: faf.webapp

Postby Dragonfire » 13 Feb 2014, 15:26

Attachments
invited.JPG
invited.JPG (24.72 KiB) Viewed 1342 times
invite.JPG
invite.JPG (38.26 KiB) Viewed 1342 times
membership_request.JPG
membership_request.JPG (43.59 KiB) Viewed 1342 times
My native language is not english, please correct me, because I want to improve my skills # Resource Overview
User avatar
Dragonfire
Evaluator
 
Posts: 559
Joined: 19 Dec 2013, 10:18
Has liked: 39 times
Been liked: 61 times
FAF User Name: Dragonfire

Re: faf.webapp

Postby Dragonfire » 13 Feb 2014, 18:02

@Ze_PilOt:
What are the minimum requirements that we can put it online?

Have you got a root server?
I like to have a seperated test system available for everybody ...
(need only a sql, webserver with php and modrewrite)

optional: the possibliity to pull from a repo (e.g. over git or the github page)
My native language is not english, please correct me, because I want to improve my skills # Resource Overview
User avatar
Dragonfire
Evaluator
 
Posts: 559
Joined: 19 Dec 2013, 10:18
Has liked: 39 times
Been liked: 61 times
FAF User Name: Dragonfire

Re: faf.webapp

Postby Ze_PilOt » 13 Feb 2014, 18:04

I can give you a FTP access.
Nossa wrote:I've never played GPG or even heard of FA until FAF started blowing up.
User avatar
Ze_PilOt
Supreme Commander
 
Posts: 8985
Joined: 24 Aug 2011, 18:41
Location: fafland
Has liked: 18 times
Been liked: 376 times
FAF User Name: Ze_PilOt

Re: faf.webapp

Postby Dragonfire » 13 Feb 2014, 18:07

Ze_PilOt wrote:I can give you a FTP access.

If we have also a sql server (live system not needed),
I can install the webapp ;)
My native language is not english, please correct me, because I want to improve my skills # Resource Overview
User avatar
Dragonfire
Evaluator
 
Posts: 559
Joined: 19 Dec 2013, 10:18
Has liked: 39 times
Been liked: 61 times
FAF User Name: Dragonfire

Re: faf.webapp

Postby Ze_PilOt » 13 Feb 2014, 18:18

You won't have a SQL server.
You will use the FAF one.

You will have to tell me what table you need to have access to, and the create commands for the one you need to add.
Nossa wrote:I've never played GPG or even heard of FA until FAF started blowing up.
User avatar
Ze_PilOt
Supreme Commander
 
Posts: 8985
Joined: 24 Aug 2011, 18:41
Location: fafland
Has liked: 18 times
Been liked: 376 times
FAF User Name: Ze_PilOt

Re: faf.webapp

Postby Dragonfire » 13 Feb 2014, 18:24

Ze_PilOt wrote:You won't have a SQL server.
You will use the FAF one.

You will have to tell me what table you need to have access to, and the create commands for the one you need to add.


The app need only access the the "login" table of the live system (schema).
Can you create a new schema for the app with full access?
My native language is not english, please correct me, because I want to improve my skills # Resource Overview
User avatar
Dragonfire
Evaluator
 
Posts: 559
Joined: 19 Dec 2013, 10:18
Has liked: 39 times
Been liked: 61 times
FAF User Name: Dragonfire

Re: faf.webapp

Postby Ze_PilOt » 13 Feb 2014, 19:19

Yes, just give me the SQL command to create the table :)
Nossa wrote:I've never played GPG or even heard of FA until FAF started blowing up.
User avatar
Ze_PilOt
Supreme Commander
 
Posts: 8985
Joined: 24 Aug 2011, 18:41
Location: fafland
Has liked: 18 times
Been liked: 376 times
FAF User Name: Ze_PilOt

Re: faf.webapp

Postby Dragonfire » 13 Feb 2014, 19:26

Ze_PilOt wrote:Yes, just give me the SQL command to create the table :)

public available (newest version):
https://raw.github.com/IDragonfire/faf. ... fclans.sql
Last edited by Dragonfire on 16 Feb 2014, 13:36, edited 1 time in total.
My native language is not english, please correct me, because I want to improve my skills # Resource Overview
User avatar
Dragonfire
Evaluator
 
Posts: 559
Joined: 19 Dec 2013, 10:18
Has liked: 39 times
Been liked: 61 times
FAF User Name: Dragonfire

PreviousNext

Return to Contributors

Who is online

Users browsing this forum: No registered users and 1 guest