search

saikamalkola / WiFi-Laser-Tag

DIY laser tag system Using ESP8266
10 stars 9 forks source link

Database Structure #2

Open garfield38 opened 4 years ago

garfield38 commented 4 years ago

Hello,

is it possible to share the database structure ?

Thanks Stephane

unsigned69 commented 4 years ago

Hi! I've try to recover database structure by reading the php-code. And i think i done with it. So, need to create batabase with name "lasertag", then create table "player_data" with next fields: "player_id" - int, "player_name" - text, "email" - text, "mobile" - int, "team_id" - int, "team_status" - text, "reset" - int, "played" - text, "hp" - int, "ammo" - int, "time" - vchar I'm not sure in the types of fields, but in my case it seems works. At least errors has gone.