aboutsummaryrefslogtreecommitdiff
path: root/src/odbc/odbc_queries.erl (follow)
Commit message (Collapse)AuthorAgeFilesLines
* Update year of ProcessOne copyright from 2009 to 2010 (EJAB-1159)Badlop2010-01-121-1/+1
| | | | SVN Revision: 2891
* Support for roster versioning (EJAB-964)Pablo Polvorin2009-08-061-1/+16
| | | | | | | | | | | | | | | | | | | | | Introduces two options for mod_roster and mod_roster_odbc: - {versioning, true | false} Enable or disable roster versioning on ejabberd. - {store_current_id, true | false} If true, the current roster version is stored on DB (internal or odbc). Otherwise it is calculated on the fly each time. Performance: Setting store_current_id to true should help in reducing the load for both ejabberd and the DB. Details: If store_current_id is false, the roster version is a hash of the entire roster. If store_current_id is true, the roster version is a hash, but of the current time (this has to do with transactional semantics; we need to perform both the roster update and the version update on the same transaction, but we don't have the entire roster when we are changing a single item on DB. Loading it there requires significant changes to be introduced, so I opted for this simpler approach). In either case, there is no difference for the clients, the roster version ID is opaque. IMPORTANT: mod_shared_roster is not compatible with the option 'store_current_id'. Shared roster and roster versioning can be both enabled, but store_current_id MUST be set to false. SVN Revision: 2428
* Replace TYPE/1 with is_TYPE/1 (EJAB-922)Badlop2009-05-061-1/+1
| | | | SVN Revision: 2057
* * doc/guide.tex: Update copyright date 2008 to 2009 (EJAB-842)Badlop2009-01-121-1/+1
| | | | | | | | * doc/guide.html: Likewise * src/*/*.erl: Likewise * src/*/*.erl: Remove unneeded blankspaces in license text SVN Revision: 1804
* * src/odbc/odbc_queries.erl: replaced string:join/2 function.Evgeniy Khramtsov2008-12-291-11/+16
| | | | | | | | Removed ugly "catch" statement from update_t/4. WARNING: this change requires last version of mysql driver. You can update it from ejabberd-modules repository. SVN Revision: 1762
* * src/odbc/ejabberd_odbc.erl: get rid of SERIALIZABLE isolation level on ↵Evgeniy Khramtsov2008-12-261-58/+176
| | | | | | | | | | MySQL connections. * src/odbc/odbc_queries.erl: replaces all delete->insert chains with update->insert. * src/mod_privacy_odbc.erl: moved sql queries to odbc_queries.erl. * src/mod_roster_odbc.erl: changed interface for odbc_queries.erl. SVN Revision: 1755
* * src/odbc/odbc_queries.erl: Fix removal of private_storage of anBadlop2008-12-231-1/+1
| | | | | | | | | | account when the account is removed * src/mod_privacy.erl: Remove privacy lists of an account when the account is removed (EJAB-720) * src/mod_privacy_odbc.erl: Likewise SVN Revision: 1742
* * src/odbc/odbc_queries.erl: Fix empty query that fail on MySQL.Jérôme Sautret2008-10-031-2/+2
| | | | SVN Revision: 1597
* * src/mod_vcard_odbc: added vCard support for MS SQL Server 2005.Jérôme Sautret2008-10-031-0/+57
| | | | | | | * src/odbc/odbc_queries.erl: likewise. * src/odbc/mssql2005.sql: likewise. SVN Revision: 1595
* * doc/guide.tex: Update Process-one name to ProcessOne (EJAB-708)Badlop2008-07-311-1/+1
| | | | | | | | | | | * doc/guide.html: Likewise * doc/api/overview.edoc: Likewise * src/*/*.erl: Likewise * src/*/*.hrl: Likewise * src/*/*.c: Likewise * src/odbc/*.sql: Likewise SVN Revision: 1499
* * src/odbc/odbc_queries.erl: Fixed a typoAlexey Shchepin2008-07-221-1/+1
| | | | SVN Revision: 1467
* * src/odbc/odbc_queries.erl (del_user_return_password): ReturnBadlop2008-05-311-4/+5
| | | | | | password (thanks to Oleg Palij) SVN Revision: 1343
* * odbc_queries: fix list_users queries with limit/offset.Jérôme Sautret2008-02-121-2/+2
| | | | SVN Revision: 1188
* * odbc_queries: fix list_users query with prefix.Jérôme Sautret2008-02-121-11/+11
| | | | SVN Revision: 1187
* * doc/guide.tex: Updated copyright dates to 2008Badlop2008-01-151-1/+1
| | | | | | * src/*: Likewise SVN Revision: 1153
* * Applied copyright patch 3.Mickaël Rémond2007-12-241-4/+27
| | | | SVN Revision: 1113
* User count performance improvementsChristophe Romain2007-12-201-7/+16
| | | | SVN Revision: 1086
* mssql specific issue bugfixChristophe Romain2007-12-171-4/+3
| | | | SVN Revision: 1074
* first patch to mssql quety, still one patch to be doneChristophe Romain2007-12-111-1/+9
| | | | SVN Revision: 1066
* * src/odbc_queries.erl: Added a default define value so that weMickaël Rémond2007-12-011-3/+4
| | | | | | | can recompile the file manually with a simple erlc command (with the default generic value). SVN Revision: 1007
* * src/odbc/odbc_queries.erl: Reverted the previous patch becauseAlexey Shchepin2007-12-011-3/+3
| | | | | | it produces "redefining macro 'generic'" compilation error SVN Revision: 1005
* * src/odbc_queries.erl: Added a default define value so that we canMickaël Rémond2007-11-301-0/+4
| | | | | | recompile the file manually with a simple erlc command. SVN Revision: 1003
* * src/ejabberd_auth.erl: Better count management and batch users retrieval ↵Mickaël Rémond2007-11-031-0/+41
| | | | | | | | | for relational database (Thanks to Massimiliano Mirra). * src/ejabberd_auth_odbc.erl: Likewise. * src/odbc/odbc_queries.erl: Likewise. SVN Revision: 968
* * src/mod_offline_odbc.erl: Implements quota for offline messagesMickaël Rémond2007-08-281-2/+14
| | | | | | | in relational database (EJAB-314) * src/odbc/odbc_queries.erl: Likewise SVN Revision: 893
* * src/odbc/odbc_queries.erl: Added missing users_number/1 for MSSQL (EJAB-239).Mickaël Rémond2007-06-181-0/+5
| | | | SVN Revision: 785
* * src/ejabberd_auth.erl: Added get_vh_registered_users_number/1Alexey Shchepin2007-05-121-0/+15
| | | | | | | | | | function * src/ejabberd_auth_odbc.erl: Likewise * src/odbc/odbc_queries.erl: Added users_number/1 function * src/ejabberd.cfg.example: Added an example for pgsql_users_number_estimate option SVN Revision: 766
* 2006-11-20 Mickael Remond <mickael.remond@process-one.net>Mickaël Rémond2006-11-201-9/+31
| | | | | | | | | | | | | | * src/ejd2odbc.erl: Copy mod_private data from Mnesia to relational database. * src/odbc/odbc_queries.erl: Refactoring. * src/odbc/mssql.sql: Likewise. * doc/guide.tex: Update to mention mod_private_odbc. * src/odbc/mysql.sql: Started integration of mod_privacy_odbc for MySQL and MSSQL. * src/odbc/mssql.sql: Likewise. SVN Revision: 678
* * src/mod_private_odbc.erl: Support for MySQL and MSSQL.Mickaël Rémond2006-11-051-0/+40
| | | | | | | | * src/odbc/odbc_queries.erl: Likewise. * src/odbc/mysql.sql: Likewise. * src/odbc/mssql.sql: Likewise. SVN Revision: 674
* * src/odbc/odbc_queries.erl: Support for Microsoft SQL Server asMickaël Rémond2006-09-031-0/+434
a database backend (via ODBC). * src/odbc/ejabberd_odbc.erl: Likewise. * src/odbc/mssql.sql: Likewise. * src/odbc/Makefile.in: Likewise. * src/ejabberd_auth_odbc.erl: Likewise. * src/mod_offline_odbc.erl: Likewise. * src/mod_roster_odbc.erl: Likewise. * src/mod_last_odbc.erl: Likewise. * src/configure.ac: Likewise * doc/guide.tex: Likewise. * doc/introduction.tex: Likewise. * src/odbc/pg.sql: Minor fix. SVN Revision: 598
generated by cgit v1.2.3 (git 2.25.1) at 2025-09-09 01:20:15 +0000