Wykres commitów

332 Commity (master)

Autor SHA1 Wiadomość Data
Peter Goodhall 264b914b8e [Migration] Create table thirdparty_logins
thirdparty_logins table will be used to store usernames and passwords for third party services.
2022-05-05 15:07:02 +01:00
phl0 bfeb11026d
Forgot to change description 2022-04-08 22:01:07 +02:00
phl0 f6feea53bd
Add CAT support for other propmodes for CloudLogCATQt 2022-04-08 21:47:50 +02:00
phl0 0977bd400a
Fix typo 2022-04-07 12:07:51 +02:00
phl0 7ef299c869
Add power field to CAT interface 2022-04-06 14:50:24 +02:00
phl0 828429312e
Add option to en-/disable showing of qrz.com images to user account menu 2022-04-04 13:17:33 +02:00
phl0 73ce098676
Add user config option to select whether to show qrz.com images 2022-04-04 11:38:21 +02:00
Peter Goodhall 985e71638d [Migration][Options] set the theme to auto load
Automatically load the theme which fixes issue of it not working correctly when not logged in as reported by @phl0
2022-03-25 15:40:15 +00:00
Andreas 73cf21c691 [Migration] Added duplicate check on columns in script 082 2022-02-09 20:05:40 +01:00
Andreas 77217186e5 [Migration fix] Renames script 83 to avoid dupliate naming. Fixes script 85 with existing column and too long constraint on utf8mb4. 2022-02-05 17:15:00 +01:00
Peter Goodhall dcc4f2b992 Delete 083_create_station_logbook_relationship_table2.php 2022-02-05 12:12:21 +00:00
Andreas e1438a01a0 [Migration] Renamed to avoid duplicate with script 73. 2022-02-05 12:02:43 +01:00
Peter Goodhall 73d4e8bcff [Station Logbooks] Adds column public_slug this will be used for generating the publicly sharable dashboard in v2 cloudlog 2022-01-26 15:43:44 +00:00
Peter Goodhall 415a24eaf6 Update 084_fix_collate.php
Adds queries back
2022-01-26 14:53:55 +00:00
Peter Goodhall 6695112e3c
Removed "queries" has this table doesn't exist. 2022-01-26 14:25:08 +00:00
Ondřej Nový 216aaff844 Cleanup SQL CHARSET and COLLATE
* Set same charset and collate for all tables
* Recommends collate utf8mb4_0900_ai_ci which is MySQL default
2022-01-25 08:28:37 +01:00
Peter Goodhall 860adbb7ab Fixes a weird issue 2022-01-20 14:28:12 +00:00
Peter Goodhall 87e6bb95ba
Update 082_add_reset_pass_to_users.php 2022-01-18 17:55:59 +00:00
Peter Goodhall f7da92ff0c Update 082_add_reset_pass_to_users.php 2022-01-18 17:29:08 +00:00
Peter Goodhall 61fc1fc92b [Password Reset] Creates DB columns and password reset views and process. 2022-01-18 15:29:22 +00:00
Peter Goodhall 0afdf302ea [Migration] Adds 072 to 073 to cover my muck up! 2022-01-05 22:05:50 +00:00
Peter Goodhall 1e4f6283e0 [SAT] Change Sat names stored as XW-3(CAS-9) to HO-113 2022-01-04 11:27:36 +00:00
Peter Goodhall c7a718c337 Update 080_update_cas9_qsos.php 2022-01-04 00:55:10 +00:00
Peter Goodhall 59e4ea0316 [Sats] Change CAS-9 QSOs to HO-113 and set LoTW Sent to N 2022-01-03 18:17:04 +00:00
Andreas 9576f576d9 Fixed down in migration script. 2021-10-15 11:14:28 +02:00
Andreas 57e5836193 [Migrations] Added checks to see if things exists. Done to avoid trouble when swapping branches. 2021-10-12 13:20:41 +02:00
Andreas Kristiansen 234ec52f1b
Merge branch 'mastettest' into station_logbooks 2021-10-08 11:48:01 +02:00
Peter Goodhall e46152003f [Migration] Fixes issue when user_id already exists with the api table. 2021-10-06 11:16:54 +01:00
Andreas d998a7f8a2 Changed order of migration script to not cause trouble with migration script in master. 2021-10-06 10:36:50 +02:00
Andreas 7c56741b92 [Advanced search] Changed to migration 71 to not have problems later when merging station_logbooks. 2021-10-06 10:19:45 +02:00
Andreas 3baffed23e [Advanced search] Edit of stored query description can now be done. Formatted code a bit. 2021-10-03 20:06:08 +02:00
Peter Goodhall e8be6f8620 Only create the fields in db if they arent there 2021-09-27 15:07:38 +01:00
Andreas 7979431d95 [Advanced search] Added migration script. 2021-09-25 20:13:06 +02:00
Andreas Kristiansen 92e45d6735
Merge branch 'station_logbooks' into add_userid_to_api 2021-09-20 19:34:19 +02:00
Andreas Kristiansen 345c753d13
Merge branch 'station_logbooks' into userid_hardware 2021-09-20 19:33:31 +02:00
Andreas 30ba927c25 [API] Added userid to the API key. 2021-09-20 15:16:53 +02:00
Andreas 586bc969fa [Hardware] Added userid to everything that has to do with hardware. 2021-09-20 15:03:35 +02:00
Andreas a554ad07aa [Notes] Added migration script for adding userid to notes. 2021-09-20 12:16:44 +02:00
Andreas e4952101f9 Renamed a file to fix a merge collision in migration files. 2021-09-15 19:33:34 +02:00
Andreas Kristiansen 77da77ffd1
Merge branch 'station_logbooks' into custom_themes 2021-09-15 19:30:34 +02:00
Peter Goodhall ce1d7a5351 Code added to have an active logbook and code to set it all up 2021-09-07 18:07:48 +01:00
Peter Goodhall 605395264e [Station Locations] Adds User_ID to station location to assign it to a user 2021-08-23 15:39:30 +01:00
Peter Goodhall a80089f97c Make sure tables dont exist before running migration 2021-08-16 11:24:16 +01:00
Andreas 5995b169c6 [Custom CSS Theme Support] Added migration script for creating the theme table 2021-08-09 13:26:04 +02:00
Peter Goodhall e254753bec [Migration] Creates table station_logbook_relationship table for many to many setup 2021-08-06 17:57:40 +01:00
Peter Goodhall c05d8f8fe0 [Migration] Creates station_logbook table in database. 2021-08-06 17:52:04 +01:00
Andreas de5c65c121 [User selectable columns] Added a fifth column, used only in logbook view. Also fixed a bug when adding user accounts. 2021-05-07 08:03:25 +02:00
Andreas 159aa0562d [User selectable columns] Added the possibility to configure some of the columns shown in the dashboard and in the logbook. 2021-05-05 17:52:42 +02:00
Peter Goodhall 4fb2d03913 [Global Options] Added the option to define the Radio Timeout Warning
Radio timeout warning is used to alert users when a radio interface has disconnected and is providing stale info for logging.
2021-05-03 14:50:33 +01:00
Andreas 035525e0ad [Migration script] Typo in the script name. 2021-03-31 11:56:44 +02:00
Andreas 5979cceb33 [Awards CQ] Added index for speedup. Removed some unused code and reduced number of queries by a few. 2021-03-27 14:28:29 +01:00
Andreas 31e8eb9ac6 [Main menu] And nice to include the migration script as well. 2021-03-20 22:35:51 +01:00
Peter Goodhall 613d6a6d13 Change DXCC tables to UTF8mb4 this fixes #924 2021-03-09 13:52:24 +00:00
Andreas 7c04327268 [QSO Dialog] Auto-fill location and locator when SOTA is chosen. This is fetched from the API. This can be turned on/off in the user settings.
Did a refactor at the same time and moved a lot of javascript from footer.php to qso.js.
2021-02-26 10:37:43 +01:00
Andreas 3812a02762 [Contesting] Migration file is needed as well 2021-02-12 23:28:09 +01:00
Peter Goodhall 91f53dddd2 Added Migration to allow Global Search
This will allow code to be added to allow non logged in users to access the search button thats currently controlled via cloudlog.php config file
2021-02-09 17:33:20 +00:00
Peter Goodhall 67ba28d145 [Migration] 061 adds language to the options table default to english 2021-01-31 13:24:25 +00:00
Peter Goodhall 3fe6a69807 [Config][Maps] Added Openstreetmap tile server settings to options table 2020-12-26 14:58:41 +00:00
Peter Goodhall be6550723c [Global Options] Created Migration for table "options" and added theme and default
This will be for global variables, anything that needs to stick for every user, default theme, dates etc etc etc
2020-12-10 17:45:44 +00:00
Paul Beesley 301483bddf Change the way themes are processed
Place themes in subfolders and use the folder name in the DB instead of the path to a single CSS file
2020-12-07 09:55:30 +00:00
Peter Goodhall d336a801b7
QRZ Real time upload is false by default 2020-11-18 19:53:58 +00:00
Andreas e149d34ba1 [QRZ Logbook] option for realtime logging added 2020-11-18 11:50:15 +01:00
Daniel Clerc f41af318b9 Add migration for sig and sig_info fields 2020-11-11 18:10:32 +01:00
Peter Goodhall 6de9ff69b0 Changed Migration so that it checks if qsl_images exists as i kept getting errors jumping around branches :) 2020-10-30 16:11:41 +00:00
Andreas Kristiansen b22ed135b3
Merge branch 'master' into qsl_card_upload 2020-10-29 17:55:23 +01:00
Peter Goodhall e306b8a8a0 Fixes Migration VUCC index to long 2020-10-29 14:52:34 +00:00
Andreas 6b1f30cb0d New feature: QSL card image upload 2020-10-28 23:20:03 +01:00
Andreas 5a380a2cf1 Added migration file for index on col_gridsquare and col_vucc_grids to speed up VUCC award a bit. 2020-10-25 15:17:06 +01:00
Andreas 97fd1b137a New feature: theme is user selectable. 2020-09-23 10:59:49 +02:00
Peter Goodhall 235c977040 Added Migration to delete the LoTW User List table and removed some unneeded coded 2020-09-21 14:10:55 +01:00
Peter Goodhall 75a4870ad9 [Users] Made Date Format defineable in the user profile and changed all the code in the system to follow selection 2020-09-15 22:04:47 +01:00
Peter Goodhall ccc8dbbc3c Class type typo in the migration class should be "add_users_measurement_base" 2020-09-15 16:30:16 +01:00
Andreas 9d4c40e44c Measurement_base in config is now fallback if not set in user profile. 2020-09-14 20:24:57 +02:00
Andreas 04032ad72c Merge branch 'measurement_base' of https://github.com/AndreasK79/Cloudlog into measurement_base 2020-09-14 12:32:23 +02:00
Andreas 6c07de7f2c Changed it over to user profile. Fetches data from session instead. 2020-09-14 12:29:02 +02:00
Andreas Kristiansen 86643ca74d
Merge branch 'master' into measurement_base 2020-09-13 14:46:08 +02:00
Andreas e487ebdd45 Migration file added. 2020-09-13 13:57:21 +02:00
Peter Goodhall c58784c022
Merge branch 'master' into lotw-sync 2020-09-01 17:49:34 +01:00
Peter Goodhall a1137f92d5 Tried to make migs match 2020-09-01 17:45:39 +01:00
Kim Huebel ea46b95cc0 enlarged submodes-filed, updated cropped submodes to original content 2020-08-31 17:11:43 +02:00
Peter Goodhall 28d770973b Added Migration to create a county field inside the Station Profile table 2020-08-26 23:23:15 +01:00
Peter Goodhall 94f3060419 Adds main cert & fixes some typos 2020-08-26 16:31:35 +01:00
Peter Goodhall 5179a72c37 Added Last Upload DataTime field to LoTW_certs table to store when last sync took place 2020-08-17 17:09:00 +01:00
Peter Goodhall 90831f407b Added all the parts to allow uploading p12 files into Cloudlog plus storing the data 2020-08-17 17:02:54 +01:00
Peter Goodhall 1296656dd6 Created the start of the frontend to display uploaded certificates. 2020-08-13 17:24:07 +01:00
Peter Goodhall c86d95af60 Created an "lotw_certs" table to hold p12 cert data for lotw sync 2020-08-13 16:43:07 +01:00
Kim Huebel 396eaab53a Added Submode-Support in Logging/ADIF-Export etc. 2020-05-24 00:06:08 +02:00
Kim Huebel 8f1dcf3db6 Make modes customizable and editable
As per request of some users, sometimes new modes or missing modes had to be
added into the code.

As that hardcoded lists are not eary maintainable, we created a new table with
all modes and submodes listed and make this list editable.

Now one can activate or deativate modes from beeing shown within the select-
list in QSO Window.
2020-05-17 14:57:28 +02:00
AndreasK79 f1ad1d1d6e Added pushing of QSOs to QRZ. 2020-05-07 17:35:58 +02:00
Peter Goodhall 48f6ea69bb Added US state to station profile options 2020-04-08 17:00:25 +01:00
Peter Goodhall 7d1fc66097 Changed migration table number 2020-03-20 20:00:36 +00:00
Peter Goodhall 9250eb816d
Merge branch 'master' into IOTA_award_added 2020-03-20 19:56:37 +00:00
Peter Goodhall 714a59aae3 Created migration file to add IOTA reference table and records 2020-03-20 19:50:11 +00:00
Peter Goodhall 13aa9bfe39 Migration file to fix LOTW url issue 2020-03-12 15:04:42 +00:00
Peter Goodhall 17abddbc2c Wrong migration numbering 2020-03-02 20:44:59 +00:00
Peter Goodhall ecf999a943 Created migration file to make an eQSL Images table 2020-03-01 17:07:39 +00:00
Peter Goodhall 2d4a83dcc8 was missing .php extention (doh) 2019-10-05 22:54:36 +01:00
Kim - DG9VH 9355e5c945
Rename 034_col_mode_tooshort to 035_col_mode_tooshort 2019-10-05 23:50:53 +02:00
Kim - DG9VH b68b181d00
Update 034_col_mode_tooshort 2019-10-05 23:48:18 +02:00
Kim - DG9VH 5ac709db27
set size from varchar(10) to varchar(12)
see http://www.adif.org/304/ADIF_304.htm#Mode_Enumeration and https://github.com/magicbug/Cloudlog/issues/359
2019-10-05 21:40:01 +02:00
Peter Goodhall 2a8f7f9272 Added a function to assign all QSOs to station profile number 1 and added table field into station profile for eqsl nickname 2019-10-03 12:56:25 +01:00
Peter Goodhall 76e24b545d Added migration to set the station_id to indexed also created a second station model that returns qso count so that sped things up 2019-09-25 00:38:13 +01:00
Peter Goodhall 1c3dc32c23 Added extra fields 2019-09-23 16:34:18 +01:00
Peter Goodhall e15f3cdde2 Removed yesterdays work decided against its method of implimentation 2019-09-23 16:27:10 +01:00
Peter Goodhall 50544cfb05 fixed migration cock up 2019-09-22 21:51:55 +01:00
Peter Goodhall 66231b52d2 started the logbook table 2019-09-22 21:23:09 +01:00
Peter Goodhall 3449ac627d Added migration file to create a logbook_id 2019-09-22 20:57:07 +01:00
Peter Goodhall 33f967d664 Email col far to short 2019-09-16 22:15:14 +01:00
Peter Goodhall 3e30310d01 changed my_lat and my_lng data types due to adif spec 2019-09-16 22:11:12 +01:00
Peter Goodhall ac58d90cf2 Lat long stored as strong type for whats expected of ADIF. 2019-09-16 21:45:59 +01:00
Tobias Mädel eac07da0c0 Remove static table name from migrations 2019-07-24 10:33:10 +02:00
Peter Goodhall d6b447ea1f Added a migration file to create a description in the api table to start #287 2019-06-30 22:26:00 +01:00
Peter Goodhall 2641634892 Fixed issue where FORCE_INT and SWL columns where incorrectly setup by the old HRD schema. 2019-06-30 22:02:07 +01:00
Peter Goodhall 45a809c331 Added inputs and table columns to start supporting Clublog uploading 2019-06-19 14:14:10 +01:00
Peter Goodhall 9fb7d82702 Created mirgration file to change the logbook table field COL_QSL_VIA from 60 char to 255 2019-06-16 21:45:10 +01:00
Peter Goodhall 6cfbf774cb Added code to import lotw-useractivity.csv for displaying if users on lotw
The csv can be imported by using /index.php/lotw/load_users need to impliment frontend next
2019-06-16 14:31:23 +01:00
Michael Cullen fb1e949acf dxcc tables: extend prefix/call field to 32 characters
While importing the clublog data, I noticed there's an entry
with a 11 character callsign. This is longer than the 10 characters
allowed for the field, causing a problem. This commit extends it to
32 characters, which should be more than enough, while also being a
power of 2.

fixes #272
2019-05-17 02:01:55 +01:00
Tobias Mädel b1e005d399 Add station_profile migration 2019-02-26 19:31:54 +01:00
Tobias Mädel 0e6a7bf8d1 Migration can now be run on any old installation and
should update the layout properly
2019-02-26 19:31:47 +01:00
Tobias Mädel 98bbf93eac Database migration & cleaup 2019-02-26 19:31:33 +01:00
Andy 35363f2374 Stored Proc for DXCC info 2016-02-28 14:09:08 +00:00
Andy 3459a81098 DXCC match on date as well as callsign. Table schema updates 2016-02-23 22:00:35 +00:00
Andy 71586bb1e5 New tables for full clublog DXCC import 2016-02-17 15:06:43 +00:00
Peter Goodhall 58913ff03e fixed typo 2014-03-03 22:37:51 +00:00
Peter Goodhall c7a076f8a5 automated downloading of clublog cty xml file 2014-03-03 01:26:26 +00:00
Corby Krick 07e2d5c6d7 Actually, this needs to do an UPDATE, not an insert... 2013-08-17 10:26:43 -05:00
Corby Krick 25d777741f Getting some bits in for downloading eQSL reports. 2013-08-07 18:40:16 -05:00
Corby Krick d014e24317 Working prototype of LoTW file upload. Needs a bit of polish yet. 2013-03-05 19:19:52 -06:00
Corby Krick 364bb9541e Adding a primary key just for SQL sanity sake :) 2013-02-26 22:10:14 -06:00
Corby Krick f630dde7ce Moving LoTW config elements to a config table in the database. The config table is created and populated via migration. Removing the config elements from the sample config file. 2013-02-26 22:04:35 -06:00
Corby Krick 266cd3f021 Turning on migration, adding a migration to add lotw credentials to the database, and removing a sample migration. 2013-02-24 17:58:36 -06:00
Peter Goodhall f2b50c4573 Added Basic Files 2011-04-25 16:24:01 +01:00