Directory inc/db/

Lines of Code

Developers

Most Recent Commits

quix0r 2014-01-19 14:27 Rev.: 6441

Commented out noisy debug line

1 lines of code changed in 1 file:

• inc/db: lib-mysqli.php (+1 -1)

quix0r 2013-11-30 22:31 Rev.: 6439

Disallow subtraction on unsigned columns:

When you use subtraction between integer values where one is of type
UNSIGNED, the result is unsigned unless the NO_UNSIGNED_SUBTRACTION SQL
mode is enabled. See Section 12.10, “Cast Functions and Operators”.

6 lines of code changed in 2 files:

• inc/db: lib-mysql3.php (+3), lib-mysqli.php (+3)

quix0r 2013-10-07 19:29 Rev.: 6438

Fixed handling of SQL strings

3 lines of code changed in 1 file:

• inc/db: lib-mysqli.php (+3 -1)

quix0r 2013-06-22 04:19 Rev.: 6413

More double-quotes to single-quotes

1 lines of code changed in 1 file:

• inc/db: lib.php (+1 -1)

quix0r 2013-06-20 21:56 Rev.: 6411

MySQLi requires at least a link resource for all its functions/methods #3

4 lines of code changed in 1 file:

• inc/db: lib-mysqli.php (+4 -4)

quix0r 2013-06-20 21:54 Rev.: 6410

MySQLi requires at least a link resource for all its functions/methods #2

1 lines of code changed in 1 file:

• inc/db: lib-mysqli.php (+1 -1)

quix0r 2013-06-20 21:52 Rev.: 6409

MySQLi requires at least a link resource for all its functions/methods

1 lines of code changed in 1 file:

• inc/db: lib-mysqli.php (+1 -1)

quix0r 2013-06-12 02:10 Rev.: 6405

MySQLi support added (very basic):
- Added very basic MySQLi module as MySQL extension is becoming deprecated
- Module for listing network API cache added
- Other minor fixes to get MySQLi working

404 lines of code changed in 2 files:

• inc/db: lib-mysql3.php (+14 -8), lib-mysqli.php (new 390)

quix0r 2013-05-27 14:37 Rev.: 6389

Heacy rewrite/cleanup:
- Removed all deprecated files (with only @DEPRECATED in it)
- Listing of blacklist entries added (may be uncomplete, untested)
- Fixed AJAX installer + added first admin registration to it
- Prepared better CAPTCHA support
- Various other fixes (tons!)
- TODOs.txt updated

5 lines of code changed in 1 file:

• inc/db: lib-mysql3.php (+5 -5)

quix0r 2013-03-06 01:32 Rev.: 6379

Renamed more:
- F -> file (no shortened names)
- L -> line (same)
- Found some SQL_FOOBAR() in comments

21 lines of code changed in 1 file:

• inc/db: lib-mysql3.php (+21 -21)

quix0r 2013-03-06 01:24 Rev.: 6378

Renamed all SQL-related functions to camel-case notation

40 lines of code changed in 1 file:

• inc/db: lib-mysql3.php (+40 -40)

quix0r 2013-02-26 23:30 Rev.: 6377

But only when it is not empty

3 lines of code changed in 1 file:

• inc/db: lib-mysql3.php (+3 -3)

quix0r 2013-02-26 23:28 Rev.: 6376

Secure sensetive data

18 lines of code changed in 1 file:

• inc/db: lib-mysql3.php (+18)

quix0r 2013-01-24 19:51 Rev.: 6367

Updated copyright notice as there are changes in this year

2 lines of code changed in 2 files:

• inc/db: lib-mysql3.php (+1 -1), lib.php (+1 -1)

quix0r 2013-01-23 15:14 Rev.: 6353

Renamed function, used more "pool functions":
- Renamed SQL_INSERTID() to SQL_INSERT_ID()
- Used more functions from inc/pool-funtions.php instead of JOINs and queries
- TODOs.txt updated

3 lines of code changed in 1 file:

• inc/db: lib-mysql3.php (+3 -3)

quix0r 2013-01-06 21:25 Rev.: 6271

Mailer project rwritten:
- Extension ext-network continued:
+ More missing type handlers added
+ Also array element translations added
+ Made API query generally working
+ Added missing what-config_network.php to allow configuration
+ Many other improvements
- Used correct MIME type for JavaScripts (text/javascript)
- Many other rewrites
- TODOs.txt updated

1 lines of code changed in 1 file:

• inc/db: lib-mysql3.php (+1 -1)

quix0r 2012-12-30 01:57 Rev.: 6264

Some improvements:
- Used wrapper convertCommaToDotInPostData() instead of that wrapped code
- Init database charset to UTF-8 by default
- Use a mask for float instead (float) casting

8 lines of code changed in 1 file:

• inc/db: lib-mysql3.php (+8)

quix0r 2012-12-27 05:11 Rev.: 6249

More fixes for new installer and script in general :(

16 lines of code changed in 1 file:

• inc/db: lib-mysql3.php (+16 -8)

quix0r 2012-11-28 16:46 Rev.: 6224

Code moved to other include file:
- Moved a lot SQL functions which doesn't encapsulate a corresponding
mysql_foo() function to sql-functions.php
- rewrote loader part
- TODOs.txt updated

0 lines of code changed in 1 file:

• inc/db: lib-mysql3.php (-460)

quix0r 2012-11-28 00:01 Rev.: 6219

Installation of extensions fixes
- Again some extensions has not been fully rewritten to newly introduced
wrapper functions which caused them to not install
- An extra back-tick (`) was found in column name :(
- Added optional $forceFound variable which can be used to (if the table is
missing) that the column/key is marked as "found"
- Expanded debug messages with column/key name and $forceFound variable
- TODOs.txt updated

9 lines of code changed in 1 file:

• inc/db: lib-mysql3.php (+9 -9)

quix0r 2012-11-24 12:57 Rev.: 6186

More fixes, lesser "caching" and more wrapper functions introduced:
- Wrapper function addExtensionAddTableIndexSql() introduced
- Wrapper function addExtensionAddTableUniqueSql() introduced
- Wrapper function addExtensionAddTableFulltextSql() introduced
- Wrapper function addExtensionDropTableIndexSql() introduced
- Function ifSqlTableExists() renamed to ifSqlTableColumnExists() and it does
no longer "cache" its results
- Other fixes which prevents extensions being installed/uninstalled

87 lines of code changed in 1 file:

• inc/db: lib-mysql3.php (+87 -79)

quix0r 2012-11-12 20:18 Rev.: 6178

Some more rewrites to better functions

3 lines of code changed in 1 file:

• inc/db: lib-mysql3.php (+3 -3)

quix0r 2012-11-12 20:09 Rev.: 6177

Check if table exists, before checking column/key

12 lines of code changed in 1 file:

• inc/db: lib-mysql3.php (+12)

quix0r 2012-11-12 20:03 Rev.: 6175

More fixes, debug lines commented out

3 lines of code changed in 1 file:

• inc/db: lib-mysql3.php (+3)

quix0r 2012-11-12 19:39 Rev.: 6174

Fixes for installation phase

36 lines of code changed in 1 file:

• inc/db: lib-mysql3.php (+36)

quix0r 2012-11-10 01:45 Rev.: 6159

Mailer project continued (heavy refactoring):
- Added all missing nodes in all XML templates to allow $content being handled
by referred HTML templates
- This means that you can pass "dynamic" content through the XML sub system to
the templates as usual. If you do so, a generic 'rows' array element is being
used for the row output
- Refactured all form-tags to EL code to allow e.g. adding session id to all
forms or (not yet added) TAN numbers to combat any kind of form spamming and
accidentally done re-submits
- Including closing form tag
- In the above process, onsubmit/onreset are now strongly discouraged as you
should better use the jQuery AJAX framework
- Other rewrites/refacturings I cannot remember
- TODOs.txt updated

2 lines of code changed in 1 file:

• inc/db: lib-mysql3.php (+2 -2)

quix0r 2012-11-08 23:42 Rev.: 6157

Fixes for installation phase

7 lines of code changed in 1 file:

• inc/db: lib-mysql3.php (+7 -4)

quix0r 2012-11-04 13:07 Rev.: 6130

A little better debugging, handling of percent char

1 lines of code changed in 1 file:

• inc/db: lib-mysql3.php (+1 -1)

quix0r 2012-10-25 00:03 Rev.: 6101

Fixes:
- The character ' is not wanted in URLs generally, so secure it
- Don't do compileUriCode() in whole SQL statement

3 lines of code changed in 1 file:

• inc/db: lib-mysql3.php (+3 -3)

quix0r 2012-10-23 19:23 Rev.: 6092

Project continued with rewrites:
- Introduced doHandleExtraValues() to encapsulate more if/elseif/else blocks
- Introduced addKeyValueSql()
- PHP's array_merge() didn't maintain $array2's index, so now merge_array() does
(optionally) it for us
- Other XML template rewrites

1 lines of code changed in 1 file:

• inc/db: lib-mysql3.php (+1 -1)

quix0r 2012-10-22 17:17 Rev.: 6074

Fixed handling of float values, ext-surfbar continued:
- Added missing config wrappers for ext-surfbar (some had typos)
- Added missing language string for "locked order points"
- Fixed handling of float values, somehow it didn't work as I thought :(
- TODOs.txt updated

43 lines of code changed in 1 file:

• inc/db: lib-mysql3.php (+43 -4)

quix0r 2012-10-17 22:42 Rev.: 6044

Code style changed, ext-user continued:
- Changed true/false to TRUE/FALSE
- Introduced validateSubId() and prepareFoundSubId()
- Add validation of edited sub id by member
- TODOs.txt updated

34 lines of code changed in 1 file:

• inc/db: lib-mysql3.php (+34 -34)

quix0r 2012-10-13 16:47 Rev.: 6036

Mailer project continued:
- Most data of advert network 'superomo24.de' added to ext-network
- Some templates for ext-network renamed (networks->network_data) to fix
inconsistence with database table
- Templates for extension management (admin_extensions/~_delete/~_edit) renamed
to follow naming convention
- Sub-Id tracking: Admin area almost finished (edit/delete of sub ids
unfinished)
- Added space between `foo`,`bar` database query to make it better readable
- Other minor improvements
- TODOs.txt updated

1 lines of code changed in 1 file:

• inc/db: lib-mysql3.php (+1 -1)

quix0r 2012-10-07 12:41 Rev.: 6023

Rewrote 'we' word a little, rewrote mail order to use SQL_INSERTID() instead of another SELECT query

9 lines of code changed in 1 file:

• inc/db: lib-mysql3.php (+9 -9)

quix0r 2012-10-04 21:36 Rev.: 6018

Mailer project continued:
- Extension ext-grade continued:
+ Language file added
+ XML template for listing grade_data entries added
+ First script to list entries in grade_data added
- Generic admin "list" template added (you may use this for own XML-based scripts)
- Other minor improvements
- TODOs.txt updated

9 lines of code changed in 2 files:

• inc/db: lib-mysql3.php (+7 -7), lib.php (+2 -1)

quix0r 2012-09-30 20:11 Rev.: 5975

Various fixes to fix bug #226, comment #562, removed extension dependency register->country to avoid uninstallable (currently) script

15 lines of code changed in 1 file:

• inc/db: lib-mysql3.php (+15 -4)

quix0r 2012-09-30 18:03 Rev.: 5974

Renamed isSqlTableColumnFound() to ifSqlColumnExists()

7 lines of code changed in 1 file:

• inc/db: lib-mysql3.php (+7 -7)

quix0r 2012-09-30 17:36 Rev.: 5973

Fixes for #226, renamed function:
- Function isSqlTableCreated() renamed to ifSqlTableExists()
- Fixed bug in ajax-common.js: responseText is now replaced by reply_content
- Possible fixed bug #226 (please test it)
- TODOs.txt updated

1 lines of code changed in 1 file:

• inc/db: lib-mysql3.php (+1 -1)

quix0r 2012-09-29 13:50 Rev.: 5960

mailer project continued:
- Some global array elements renamed (someGlobalElement -> __some_global_element)
- Copyright notice disabled in mailid.php as it destroys the frameset
- Function debug_report_bug() renamed to reportBug()
- Function app_die() renamed to app_exit()
- More wrapper functions used (e.g. getRandomTan() instead of PHP's mt_rand())
- New AJAX-based installation introduced (it is not finished)
- Renamed several ALL_UPER_CASE() functions to camel-case notation
- Extension ext-currency introduced which will deprecate ext-wernis all other eCurreny-related extensions
- Renamed various HTML and email templates to new notation
- Some shell scripts moved to 'contrib' folder
- JQUERY updated to latest stable version (including custom build of jqueryui)
- License files renamed/moved
- Many other fixes/improvements I forgot to mention
- Varrious typos fixed
- Copyright updated (to 2012)
- TODOs.txt updated

107 lines of code changed in 2 files:

• inc/db: lib-mysql3.php (+97 -39), lib.php (+10 -7)

quix0r 2011-09-15 16:44 Rev.: 5886

userid shall be NULL by default everywhere possible

1 lines of code changed in 1 file:

• inc/db: lib-mysql3.php (+1 -2)

(176 more)