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