summaryrefslogtreecommitdiffstats
path: root/database
Commit message (Collapse)AuthorAgeFilesLines
...
* sqlite - BUGFIX: Fixed INSERT INTO statements when using ↵David Sommerseth2008-12-181-2/+8
| | | | sqlite_query_mapped(...)
* Fixed segfault and wrong XML node extraction in eDBxmlMapping(...)David Sommerseth2008-12-181-2/+2
|
* sqlite: Fixed segfault int SQLreservedWord(...)David Sommerseth2008-12-181-1/+1
|
* Added SQLite3 admin functions for adding and deleting usersDavid Sommerseth2008-12-181-2/+90
|
* Added pwhash attribute in fieldMapping XML for password fields.David Sommerseth2008-12-181-5/+19
| | | | | | | This attribute can be "sha512" if the contents of the field is already hashed with SHA512. The other official value is "none", which will then tell eDBxmlMapping(...) to hash the value. Unknown values will be treated like 'none'.
* Added more comments and some XML format documentationDavid Sommerseth2008-12-181-4/+28
|
* Removed all other eurephia admin structs which can be replaced by XMLDavid Sommerseth2008-12-182-12/+12
|
* Removed everything which was connected to the eurephiaUSERINFO struct.David Sommerseth2008-12-183-11/+10
|
* Rewrote eDBadminUpdateUser(...) to use XML instead of eurephiaUSERINFODavid Sommerseth2008-12-182-15/+34
|
* eDBxmlMapping(...) did not honor the setnull attribute correctly.David Sommerseth2008-12-181-10/+17
|
* Updated eAdminGetUserInfo(...) work after commitDavid Sommerseth2008-12-171-2/+4
| | | | 31911812e53a8fda5ce8fa8e9d45254053a580c5
* Rewrote eDBxmlMapping(...) to take an XML node instead of a complete XML ↵David Sommerseth2008-12-172-17/+38
| | | | | | | | 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.
* Changed eDBxmlMapping(...) function to make use of the new ↵David Sommerseth2008-12-171-1/+3
| | | | eurephiaXML_getRoot(...) function
* Using the new eurephiaXML_* functions for creating and parsing XMLDavid Sommerseth2008-12-171-6/+2
| | | | | | | | | | | Also rebased the XML file to always have a document root which is <eurephia/>. This tag must contain a "format" attribute, which should be 1 for the moment. When parsing the XML, the eurephiaXML_getRoot(...) function will return a pointer to the requested XML node inside the <eurephia/> document root. The format version in the root element will also be checked automatically.
* BUGFIX: Made the eDBmkSortKeyString(...) function work againDavid Sommerseth2008-12-161-8/+10
| | | | | The function did not work after the change of the field mapping system changed when reworking things from eurephiaUSER{LIST,INFO} to XML
* Rewrote eDBadminGetUserList(...) to use XMLDavid Sommerseth2008-12-162-27/+19
|
* Removed not needed pointer - found by compiler warningDavid Sommerseth2008-12-161-1/+1
|
* Completed rewriting eDBadminGetUserInfo(...) function for XMLDavid Sommerseth2008-12-132-14/+19
| | | | | This rewrite utilities the XML interface instead of the more static eurephiaUSERINFO struct.
* Completed rewriting eDBmkMapping_USERINFO(...) to eDBxmlMapping(...)David Sommerseth2008-12-132-64/+109
| | | | | | | | | | | | | | | | | | | 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.
* Moved libxml2 check from edb-sqlite to the global CMakeLists.txtDavid Sommerseth2008-12-131-5/+0
|
* Began porting eDBadminGetUserInfo(...) over to XMLDavid Sommerseth2008-12-131-50/+65
|
* Added sqlite functions for populating an XML document directlyDavid Sommerseth2008-12-132-0/+27
|
* Prepared for building with libxml2David Sommerseth2008-12-131-2/+11
|
* Modified flags againDavid Sommerseth2008-12-121-4/+17
| | | | | | Added RSETLASTUSED (last_accessed is set to NULL) and RSETLOGINCNT (lastlog table has been modified). NEVERUSED flag will only be set if last_accessed is NULL and login count == 0.
* Fixed yet another strange SQLite3 parsing issueDavid Sommerseth2008-12-111-1/+1
|
* Added ACCFLAG_ERRATTEMPT for flagging if the attempt counter > 0David Sommerseth2008-12-111-1/+4
|
* Corrected a lot of small errors, setting wrong flag and SQL mistakesDavid Sommerseth2008-12-111-4/+9
|
* Added logincount and setting user account flagsDavid Sommerseth2008-12-111-5/+17
|
* Enhanced table/field mapping and eDBmkMapping_USERINFO(...) to include ↵David Sommerseth2008-12-114-53/+62
| | | | possibility for table aliases
* Added functions for processing eurephiaACCESSINFO/eurephiaACCESSLISTDavid Sommerseth2008-12-112-3/+20
| | | | | | | | | | Implemented saving VPN access profile to the eurephiaCERTINFO struct and filling the eurephiaACCESSINFO with the proper information needed in the eDBadminGetUserInfo(...) function. The special thing about eurephiaACCESSINFO, is that it will not register duplicate records. And when the eurephiaCERTINFO is free'd, the eurephiaACCESSLIST will automatically be free'd as well.
* Updated eDBadminGetUserInfo(...) to take filtering parameterDavid Sommerseth2008-12-102-36/+55
|
* eurephiadb init: Only setup the requiered function pointers in driverDavid Sommerseth2008-12-091-1/+1
| | | | | | | | | | | | | | | | This is ment as a security enhancement. Do not setup the function pointers to functions which is not needed for the requested minimum driver API version. Calling any of these functions which is not set up would then cause a SEGV. In real life, this means that the eurephia-auth.so which only needs API version 1 now will not setup any pointers to the API version 2, which the eurephiadm utility needs. In the future it should be a 4th argument to the eDBlink_init(...), defining features to enable when loading the drivers. This should be a bitwise mask. So that API version can change whenever the driver includes more functions. But for now, this change is enough.
* eDBadminGetUserList(...): Added certificate info into the eurephiaUSERINFO ↵David Sommerseth2008-12-091-2/+31
| | | | struct
* Fixed wrong assert criteriaDavid Sommerseth2008-12-081-1/+1
|
* Do not encapsulate key-value pairs with () in UPDATE modeDavid Sommerseth2008-12-081-3/+13
| | | | | And added support for setting fields to NULL if flagged via the field type value ft_SETNULL
* Added setnull_flag in the eurephiaUSERINFO structDavid Sommerseth2008-12-081-0/+5
| | | | | | | This can make it possible to get a value getting set to NULL if this flag contains the FIELD_* value of the field being set to NULL. If more fields wants to be reset, these field values can be bitwise ORed together into the setnull_flag.
* Fixed a couple of memory leaks in eDBadminUpdateUser(...)David Sommerseth2008-12-081-0/+4
|
* edb-sqlite: Added update user functionDavid Sommerseth2008-12-081-3/+23
|
* Added possibility to also set NULL values in UPDATEDavid Sommerseth2008-12-082-2/+3
|
* Update field mapping to include data type. Improved ↵David Sommerseth2008-12-085-72/+207
| | | | | | | | | | | | | | 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.
* edb-sqlite: Update openvpn_users.last_accessed = now() on successful loginDavid Sommerseth2008-12-081-0/+13
|
* Added eDBadminGetUserInfo(...) function, to retrieve user infoDavid Sommerseth2008-12-072-3/+47
|
* Extended sqlite.[ch] with sqlite_query_mapped(...)David Sommerseth2008-12-072-1/+35
| | | | | | | This functions does almost the same as sqlite_query(...), it takes an SQL statement without the WHERE clause. The where clause is built up based on the fields sent in via the eDBfieldMap struct, containing the fields and values to look for.
* Merged eurephiadb_common.[ch] into eurephiadb_mapping.[ch]David Sommerseth2008-12-074-125/+76
| | | | | The functions in eurephiadb_common.[ch] was only adding functions which was connected to the unified field mapping interface
* Fixed eDBmkMapping_USERINFO(...) to let the uid_str be NULL if uid == 0David Sommerseth2008-12-071-2/+6
|
* Added missing copyright header, corrected another wrong file headDavid Sommerseth2008-12-061-0/+20
|
* Changed from user-side field name 'recid' to simply 'id'David Sommerseth2008-12-061-6/+7
|
* Added missing shared source for edb-sqlite.soDavid Sommerseth2008-12-061-0/+1
|
* Moved over from earlier commit to use unified db translationDavid Sommerseth2008-12-065-9/+53
| | | | | | | 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 unified database field mappingDavid Sommerseth2008-12-062-0/+120
| | | | | | | | | | Added a new function for copying eurephiaUSERINFO struct over to a unified eDBfieldMap struct for building up SQL queries. This approach gives the possibility to only assign field names and table names in the database driver. This field mapping makes sure the identifiers from other modules will be translated into the proper field and table name.
generated by cgit (git 2.34.1) at 2026-03-17 09:43:34 +0000