summaryrefslogtreecommitdiffstats
path: root/database/eurephiadb_mapping.h
Commit message (Collapse)AuthorAgeFilesLines
* Updated Copyright dates to include 2010David Sommerseth2010-05-251-1/+1
|
* Define certificate digests as ft_STRING_LOWERDavid Sommerseth2009-11-121-32/+32
| | | | This means this field will always be processed with lower case
* Rewrote the eDBmkSortKeys() function to use the eDBfieldMap returned from ↵David Sommerseth2009-09-251-1/+1
| | | | eDBxmlMapping()
* Added eDBmappingGetValue() to retrieve field values from a eDBfieldMap structDavid Sommerseth2009-09-211-0/+1
|
* Added missing comments for the generic database/ filesDavid Sommerseth2009-09-081-10/+87
|
* Fixed some errors in blacklist field mappingDavid Sommerseth2009-05-091-1/+1
|
* Renamed fieldmapping for 'attempts' to 'attemptslog'David Sommerseth2009-05-061-0/+1
| | | | | | Also made the result XML from eDBadminAttemptsLog(...) more efficient by not adding the username/certificate/ipaddress group tags if the information is not present.
* Added eDBfieldMapping field for filter typesDavid Sommerseth2009-04-051-63/+65
| | | | | | | | | | | | | | | | | | | This field will be used to determine what kind of filter logic to add when building SQL queries. The filter type is set in the fieldMapping field nodes as an attribute named 'filter'. Their values and the corresponding SQL conditions are: filter | SQL condition -----------------------+--------------- equals | = not-equals | != / NOT(...) less-than | < less-than-equals | <= greater-than | > greater-than-equals | >= -----------------------+--------------- The default value for each field is set in the eurephiadb_mapping.h
* Added eDBmappingFieldsPresent(...) which returns used fields in a fieldMapDavid Sommerseth2009-04-021-0/+1
|
* Added fieldMapping for the firewall access table (openvpn_accesses)David Sommerseth2009-03-281-0/+19
|
* Made the licence explicit GPLv2 onlyDavid Sommerseth2009-03-261-1/+1
|
* Cleaned up the code a little bitDavid Sommerseth2009-03-261-1/+2
| | | | | Made sure we only include needed include files and checked that the copyright headers are equal and correct
* Added more fields to the global field mapping tableDavid Sommerseth2009-03-241-30/+37
| | | | | Had to also extend the FIELD_* assignments to allow two new fields to be mapped
* Added support for editing the eurephia_adminaccess tableDavid Sommerseth2009-03-221-6/+16
| | | | Implemented eDBadminEditAdminAccess(...) function in db driver
* Make it possible to compile plug-in again without eurephiadm enabledDavid Sommerseth2009-01-021-5/+4
|
* Simplified some certificate field names for internal useDavid Sommerseth2008-12-261-2/+2
|
* Added field mapping for the openvpn_usercerts tableDavid Sommerseth2008-12-251-3/+16
|
* Corrected wrong field name (org->organisation) in field mappingDavid Sommerseth2008-12-201-1/+1
|
* Added field mapping for the certificates tableDavid Sommerseth2008-12-201-27/+28
|
* Changed from numeric session status code to text in eDBadminGetUserInfo(...) ↵David Sommerseth2008-12-191-0/+1
| | | | - lastlog
* Rewrote eDBxmlMapping(...) to take an XML node instead of a complete XML ↵David Sommerseth2008-12-171-6/+5
| | | | | | | | document as input. The node name of the input node must be <fieldMapping/>. In addition this node must have an attribute called "table" which must match the eDBfieldMap* structure given as input.
* Completed rewriting eDBmkMapping_USERINFO(...) to eDBxmlMapping(...)David Sommerseth2008-12-131-4/+10
| | | | | | | | | | | | | | | | | | | This new mapping function uses a flexible XML document as input, and will be generic to all other tables as well. XML structure is: <fieldMapping table="{table name}> <{fieldname}>{value}</{fieldname}> </fieldMapping> An example: <fieldMapping table="users"> <uid>1</uid> <username>testuser1</username> </fieldMapping> This function will return a eDBfieldMap structure contatining the proper fieldnames with values assigned, depending on the database map given when called.
* Enhanced table/field mapping and eDBmkMapping_USERINFO(...) to include ↵David Sommerseth2008-12-111-39/+40
| | | | possibility for table aliases
* Added possibility to also set NULL values in UPDATEDavid Sommerseth2008-12-081-1/+1
|
* Update field mapping to include data type. Improved ↵David Sommerseth2008-12-081-38/+41
| | | | | | | | | | | | | | sqlite_query_mapped(...) function The new sqlite_query_mapped(...) function will now consider the field type when formatting the data values for SQLite. In addition reserved words on the DATETIME data type will be preserved without quote encapsulation. Improved the sqlite_query_mapped(...) to also handle UPDATE, INSERT and DELETE in addition to SELECT. The function now needs two eDBfieldMap mappings. The first one will contain update/insert values, while the last one defines search criteria.
* Merged eurephiadb_common.[ch] into eurephiadb_mapping.[ch]David Sommerseth2008-12-071-1/+2
| | | | | The functions in eurephiadb_common.[ch] was only adding functions which was connected to the unified field mapping interface
* Changed from user-side field name 'recid' to simply 'id'David Sommerseth2008-12-061-6/+7
|
* Moved over from earlier commit to use unified db translationDavid Sommerseth2008-12-061-0/+1
| | | | | | | In other words, rewrote commit 6d4373e026b3f12c5685e45e35f9f060379ed0f3. Moved over all functions from that commit which could take advantage of the new API for unified table/field translation.
* Improved and unified the db mapping functions and definitionsDavid Sommerseth2008-12-061-0/+125
generated by cgit (git 2.34.1) at 2025-09-02 20:32:46 +0000