Commit Graph

90 Commits

Author SHA1 Message Date
Adrian Schmutzler c55b1d259d MySQL: Reduce size of MAC address fields to 20
This is mainly a change to the database

Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
2017-12-21 17:06:25 +01:00
Adrian Schmutzler 9ab707a214 MySQL: Apply changes leftover from modifications to db init files
Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
2017-12-21 17:06:16 +01:00
Adrian Schmutzler 782d4b4065 db/users: Make nickname and email UNIQUE
This is mainly a change to the database

Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
2017-12-21 17:03:27 +01:00
Adrian Schmutzler ab400e1f01 Provide possibility to report routers
ATTENTION: Requires change in users database!

Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
2017-12-21 17:03:27 +01:00
Adrian Schmutzler 20e71afeb0 Provide possibility to ban routers
If routers are supposed to be removed from the Monitoring
permanently, they can now be banned based on their MAC address.

All admins can do that via the web interface.

ATTENTION: This requires a database update!

Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
2017-12-21 17:03:27 +01:00
Adrian Schmutzler 8f04e13c24 routertools/router.html: Display warning for lost coordinates
Warning: This requires a change of the MySQL table 'router'

Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
2017-11-23 21:59:30 +01:00
Adrian Schmutzler 9d167bdb86 Respect case in database and code
Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
2017-11-16 00:06:25 +01:00
Adrian Schmutzler 87093a9066 Add hood-specific statistics
Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
2017-11-16 00:00:48 +01:00
Adrian Schmutzler e3fe995407 MySQL: alpha3
Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
2017-11-16 00:00:07 +01:00
Dominik Heidler f51d0ae5fd Add index for "created" routerdb field (fixes #65) 2017-08-31 13:16:56 +02:00
Dominik Heidler f8c5913ad1 Commit unstaged changes from production instance 2017-08-21 11:49:26 +02:00
Dominik Heidler 96a8466e7a Merge pull request #58 from adridolf/consistent_hoodnames
Make capitalization and spelling of hoods consistent
2017-07-25 10:51:19 +02:00
Christian Dresel 216b0ec801 Projekt Hoodteilung extremo #9
Add Hood Erlenbach
2017-07-25 09:20:24 +02:00
Adrian Schmutzler 46dbde5c72 Make capitalization and spelling of hoods consistent
Signed-off-by: Adrian Schmutzler <freifunk@adrianschmutzler.de>
2017-07-24 23:49:07 +02:00
Christian Dresel a3115c54d0 Projekt Hoodteilung extremo #8
Add Hood Coburg
2017-07-20 18:16:03 +02:00
Christian Dresel db4cd7d57f Projekt Hoodteilung extremo #7
Add Hood Lauf
2017-07-20 15:16:38 +02:00
Christian Dresel a1e7cf2650 Projekt Hoodteilung extremo #6
Add Hood Ebern
Re-positioned Hood Aschaffenburg
2017-07-19 17:10:17 +02:00
Christian Dresel 3e567ba07a Projekt Hoodteilung extremo #5
Add Hood Ebern
HoodID 25 is reserved for Coburg, it is created in the next steps
2017-07-17 20:31:34 +02:00
Christian Dresel 096c3a48fa Projekt Hoodteilung extremo #4
Re-positioned Hood Markredwitz
Re-positioned Hood Hof
Add Hood Fichtelberg
Add Hood Rehau
2017-07-17 16:20:19 +02:00
Christian Dresel 12384f2f5a Projekt Hoodteilung extremo #3
Add Hood Bayreuth
HoodID 21 is reserved for Lauf, it is created in the next steps
2017-07-17 10:56:43 +02:00
Christian Dresel e15c8908bf Projekt Hoodteilung extremo #2
Add Hood Ebermannstadt
2017-07-16 22:34:32 +02:00
Christian Dresel d9e70533ca Projekt Hoodteilung extremo #1
Re-positioned Hood Adelsdorf
Re-positioned Hood Forchheim
Add Hood ErlangenWest
2017-07-16 11:55:10 +02:00
moexe 576c8dd0c0 adding hood Schweinfurt to hoods.py 2017-05-19 22:56:07 +02:00
Steffen Pankratz 138c8c81b8 Added hood Adelsdorf.
Signed-off-by: Steffen Pankratz <kratz00@gmx.de>
2017-03-23 19:24:49 +01:00
Steffen Pankratz 3db647d40f Re-positioned hood HassbergeSued
Signed-off-by: Steffen Pankratz <kratz00@gmx.de>
2016-09-17 09:53:58 +02:00
Dominik Heidler 797b67ee40 Record smaller stat timespan to reduce db load 2016-07-26 22:16:33 +02:00
Steffen Pankratz 626595ad17 Re-positioned hood Hof
Signed-off-by: Steffen Pankratz <kratz00@gmx.de>
2016-07-13 18:10:09 +02:00
Steffen Pankratz a8b38bc808 Added hood Muenchberg
Signed-off-by: Steffen Pankratz <kratz00@gmx.de>
2016-07-13 18:10:09 +02:00
Steffen Pankratz 392d6adce8 Added hood Forchheim
Signed-off-by: Steffen Pankratz <kratz00@gmx.de>
2016-07-13 18:10:09 +02:00
Steffen Pankratz 1698047715 Added hood Bamberg
Signed-off-by: Steffen Pankratz <kratz00@gmx.de>
2016-07-13 18:09:44 +02:00
Steffen Pankratz d95604688d Added hood Marktredwitz
Signed-off-by: Steffen Pankratz <kratz00@gmx.de>
2016-07-02 19:13:56 +02:00
Steffen Pankratz 9ec37e715b Added hood Aschaffenburg
Signed-off-by: Steffen Pankratz <kratz00@gmx.de>
2016-07-02 19:13:56 +02:00
Dominik Heidler ae75d547f9 Add hood: hof 2016-04-28 17:43:55 +02:00
Dominik Heidler 19329ef85c User Accounts, Legacy Routers, Delete Routers 2016-02-29 18:51:58 +01:00
Dominik Heidler 44a50ecafb Reduce stat range to 2 Weeks (#3) 2016-01-22 20:33:41 +01:00
Dominik Heidler 36938ad60a new hood: nbgland 2015-11-27 15:59:09 +01:00
Dominik Heidler b5b4ff60fe filter/search router_list 2015-11-18 14:48:14 +01:00
Dominik Heidler 6c385b3408 add statistics page 2015-11-11 15:27:50 +01:00
Dominik Heidler 72e3b4a5e2 remove old chipset db init 2015-11-05 15:44:58 +01:00
Dominik Heidler 84cf486269 reorganize folder structure 2015-10-12 15:08:28 +02:00