summaryrefslogtreecommitdiffstats
path: root/database/sqlite
Commit message (Collapse)AuthorAgeFilesLines
...
* 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.
* 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-071-2/+46
|
* 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.
* Added missing copyright header, corrected another wrong file headDavid Sommerseth2008-12-061-0/+20
|
* 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-063-9/+11
| | | | | | | 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.
* Added sorting in db driver in eDBadminGetUserList(...). Improved comments.David Sommerseth2008-12-062-6/+50
|
* Added admin function to give a list of usersDavid Sommerseth2008-12-062-1/+44
|
* Changed the sortkey type from int to const char *David Sommerseth2008-12-061-6/+10
|
* Changed admin functions to be prefixed with eDBadmin*, to unify the function ↵David Sommerseth2008-12-051-11/+11
| | | | name schema
* Moved administration functions (eDBadmin*) into adminstration.cDavid Sommerseth2008-12-033-364/+381
|
* Workaround to avoid getting existing eurephiadb template db block rebuildingDavid Sommerseth2008-12-031-1/+4
|
* Fixed wrong data type for the access variable in eDBadminAuth(...)David Sommerseth2008-12-031-2/+2
|
* BUGFIX: Logout works properly again and improved logout status changeDavid Sommerseth2008-12-031-7/+11
| | | | | | - cmd_Logout(...) used the wrong argv[] index for sessionkey. - Improved eDBadminValidateSession(...) to set status to '5' on sessions which are getting logged out due to missing privileges
* Changed the logout behaviour to avoid login and/or access control check when ↵David Sommerseth2008-12-031-5/+5
| | | | user is about to logout
* Enhanced the access control by introducing access levelsDavid Sommerseth2008-12-022-31/+73
|
* Added database functions for editing the openvpn_config tableDavid Sommerseth2008-12-021-0/+46
|
* Fixed memory leak. Was missing a sqlite_free_results(...)David Sommerseth2008-11-301-0/+1
|
* Added eDBadminLogout(...) function in database driverDavid Sommerseth2008-11-301-3/+42
| | | | | Added one more status code, for active sessions. Auto-logout will now also delete session variables
* eurephiadm can now use eDBadminValidateSession(...) to use open session. ↵David Sommerseth2008-11-301-1/+44
| | | | Auto-logout implemented as well
generated by cgit (git 2.34.1) at 2026-01-07 09:58:28 +0000