summaryrefslogtreecommitdiffstats
path: root/database/sqlite
Commit message (Collapse)AuthorAgeFilesLines
...
* Added db driver function: eDBadminGetUserCertsList(...) - to get user ↵David Sommerseth2008-12-281-0/+71
| | | | account/certs links
* sqlite3: Make sqlite_query_mapped(...) work with empty WHERE clauseDavid Sommerseth2008-12-261-3/+10
|
* sqlite3 - admin: Added DEBUG statements on all function callsDavid Sommerseth2008-12-261-1/+18
|
* sqlite3 db driver: Added eDBadminUpdateUserCertLink(...) function to add and ↵David Sommerseth2008-12-251-0/+48
| | | | delete records in openvpn_usercerts
* Added field mapping for the openvpn_usercerts tableDavid Sommerseth2008-12-251-0/+9
|
* Fixed spelling mistake in XML attribute for certificatesDavid Sommerseth2008-12-221-1/+1
|
* sqlite3 - Return uid or certid of newly registered users or certificatesDavid Sommerseth2008-12-221-9/+12
|
* sqlite3 - Added saving last_insert_id on INSERT INTO queriesDavid Sommerseth2008-12-223-1/+9
|
* Moved all replace_char(...) calls into SQLite3 driver as xmlReplaceChars(...)David Sommerseth2008-12-211-5/+37
|
* sqlite3 - Added eDBadminGetCertificateInfo(...)David Sommerseth2008-12-201-2/+92
|
* sqlite3 - Added sortkeys as argument to sqlite_query_mapped(...)David Sommerseth2008-12-203-8/+14
| | | | | The last argument to the function can contain a list over field names which will be used in the ORDER BY clause when doing SELECT queries.
* Added eDBadminDeleteCertificate(...) function in SQLite3 driverDavid Sommerseth2008-12-201-2/+52
|
* sqlite3: Corrected some compiler warningsDavid Sommerseth2008-12-201-2/+2
|
* sqlite3: Added eDBadminAddCertificate(...) functionDavid Sommerseth2008-12-201-2/+51
|
* Added field mapping for the certificates tableDavid Sommerseth2008-12-201-0/+11
|
* Changed from numeric session status code to text in eDBadminGetUserInfo(...) ↵David Sommerseth2008-12-191-1/+2
| | | | - lastlog
* sqlite - admin: Added fetching blacklist info for user account.David Sommerseth2008-12-191-0/+24
|
* sqlite - admin: Added fetching login attempt for user. Fixed a memory leak ↵David Sommerseth2008-12-191-4/+30
| | | | and removed XML dump for debug
* Added extraction of lastlog info in eDBadminGetUserInfo(...)David Sommerseth2008-12-191-43/+104
|
* Fixed more memory leaks and missing memory initialisation.David Sommerseth2008-12-191-2/+4
|
* sqlite - BUGFIX: Fixed INSERT INTO statements when using ↵David Sommerseth2008-12-181-2/+8
| | | | sqlite_query_mapped(...)
* 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 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-181-6/+6
|
* Removed everything which was connected to the eurephiaUSERINFO struct.David Sommerseth2008-12-182-6/+4
|
* Rewrote eDBadminUpdateUser(...) to use XML instead of eurephiaUSERINFODavid Sommerseth2008-12-181-13/+32
|
* Updated eAdminGetUserInfo(...) work after commitDavid Sommerseth2008-12-171-2/+4
| | | | 31911812e53a8fda5ce8fa8e9d45254053a580c5
* 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.
* Rewrote eDBadminGetUserList(...) to use XMLDavid Sommerseth2008-12-161-26/+18
|
* Completed rewriting eDBadminGetUserInfo(...) function for XMLDavid Sommerseth2008-12-131-13/+12
| | | | | This rewrite utilities the XML interface instead of the more static eurephiaUSERINFO struct.
* 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-112-7/+11
| | | | 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-101-35/+48
|
* 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
* 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-081-1/+2
|
* Update field mapping to include data type. Improved ↵David Sommerseth2008-12-083-30/+162
| | | | | | | | | | | | | | 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.
generated by cgit (git 2.34.1) at 2025-09-26 08:05:50 +0000