[DEV] faf.webapp

[Dragonfire]

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 ...

[Ze_PilOt]

Yes, it has to use the FAF one.

[Dragonfire]

Basic invite functions implented:

https://github.com/IDragonfire/faf.weba ... state=open

[Dragonfire]

@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)

[Ze_PilOt]

I can give you a FTP access.

[Dragonfire]

I can give you a FTP access.

If we have also a sql server (live system not needed),
I can install the webapp

[Ze_PilOt]

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.

[Dragonfire]

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?

[Ze_PilOt]

Yes, just give me the SQL command to create the table

[Dragonfire]

Yes, just give me the SQL command to create the table

public available (newest version):
https://raw.github.com/IDragonfire/faf. ... fclans.sql