aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/includes/db
Commit message (Collapse)AuthorAgeFilesLines
...
* my turn to break things... harharharMeik Sievertsen2006-02-121-4/+6
| | | | | | | | | | | | | | | | | - checking in permission settings and permission masks - permission presets and documentation not finished yet - added backtrace function to determine file/line for sql errors - fixed marlist for orphan attachments/groups/logs/users - able to change anonymous user settings/permissions now - re-arranged admin permissions a bit (added some and removed some) - setting forum permissions after creating/editing forum now selects every default group (copy permisson/dropdown to be added for adding forums) - finished user permissions in users acp note: the layout for permissions might change devs: please empty the user_permissions in phpbb_users. Also, first change your auth_options table, remove all cache files and then re-set admin permissions. After having set the admin permissions you can update your modules table (else you will not see the permission tabs) - or empty the auth setting within the modules table to be able to see the permission modules (they rely on newly added permission options) git-svn-id: file:///svn/phpbb/trunk@5553 89ea8834-ac86-4346-8a33-228a782c2dd0
* - moved add_log out of functions_admin (this file should only be included in ↵Meik Sievertsen2006-01-253-1/+26
| | | | | | | | | | | admin/admin-related pages) - fixed cookie based topic tracking - added missing config variables - other minor things git-svn-id: file:///svn/phpbb/trunk@5494 89ea8834-ac86-4346-8a33-228a782c2dd0
* - size select fixMeik Sievertsen2006-01-222-4/+4
| | | | | | | | | | | - introduced function for building group options (acp) - fixed acl_getf if negated option needs to be retrieved - only using one function for updating post informations - fixing module display if module is disabled - if user is having a non-existent style do not print out error message, instead fix the users value and load the default style git-svn-id: file:///svn/phpbb/trunk@5486 89ea8834-ac86-4346-8a33-228a782c2dd0
* - Defined some DBAL class varsDavid M2006-01-011-0/+3
| | | | git-svn-id: file:///svn/phpbb/trunk@5414 89ea8834-ac86-4346-8a33-228a782c2dd0
* - 18446744073709551615 becomes a float. This causes MySQL to read it as 1. ↵David M2006-01-012-2/+2
| | | | | | Having it as a string works better. git-svn-id: file:///svn/phpbb/trunk@5413 89ea8834-ac86-4346-8a33-228a782c2dd0
* - some changes to browser checking (was the reason for not working logins)Meik Sievertsen2005-12-281-1/+1
| | | | | | | | - partly working style acp - other tiny changes here and there git-svn-id: file:///svn/phpbb/trunk@5388 89ea8834-ac86-4346-8a33-228a782c2dd0
* :DMeik Sievertsen2005-12-171-1/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@5342 89ea8834-ac86-4346-8a33-228a782c2dd0
* - show complete sql error message + path to administrators only (idea from ↵Meik Sievertsen2005-12-151-3/+15
| | | | | | post to bugtraq about SMF) git-svn-id: file:///svn/phpbb/trunk@5338 89ea8834-ac86-4346-8a33-228a782c2dd0
* - some SQL:2003 changes (basicly joins, mysql5 is sql:2003 compliant in ↵Meik Sievertsen2005-11-283-2/+11
| | | | | | | | | strict mode now) - postgresql not supporting this standard. :/ - acp changes git-svn-id: file:///svn/phpbb/trunk@5313 89ea8834-ac86-4346-8a33-228a782c2dd0
* change total from -1 to max valueMeik Sievertsen2005-11-212-2/+4
| | | | git-svn-id: file:///svn/phpbb/trunk@5311 89ea8834-ac86-4346-8a33-228a782c2dd0
* - more acp additions and changes...Meik Sievertsen2005-11-201-2/+2
| | | | git-svn-id: file:///svn/phpbb/trunk@5310 89ea8834-ac86-4346-8a33-228a782c2dd0
* re-remove (:D) open queries array due to the result being an object.Meik Sievertsen2005-11-081-9/+2
| | | | git-svn-id: file:///svn/phpbb/trunk@5297 89ea8834-ac86-4346-8a33-228a782c2dd0
* - updated topic tracking codeMeik Sievertsen2005-10-191-1/+1
| | | | | | | | | - additional changes (mostly bugfixes) - bart, if you update your user table with the user_lastmark field, set it to the user_lastvisit value ;) - and last but not least, introducing some bugs in ucp main front (regarding topic tracking) git-svn-id: file:///svn/phpbb/trunk@5272 89ea8834-ac86-4346-8a33-228a782c2dd0
* - added new query type to dbal's sql_build_arrayMeik Sievertsen2005-10-091-3/+9
| | | | | | | | | - allow setting custom template path - adjusted module class to correctly parse trees with more than one category - added caching to module class git-svn-id: file:///svn/phpbb/trunk@5268 89ea8834-ac86-4346-8a33-228a782c2dd0
* - only minor changesMeik Sievertsen2005-10-081-1/+0
| | | | git-svn-id: file:///svn/phpbb/trunk@5264 89ea8834-ac86-4346-8a33-228a782c2dd0
* - another try to break things. :)Meik Sievertsen2005-10-0711-1572/+902
| | | | | | | | - adjusted the dbal a little bit - removed db2 support git-svn-id: file:///svn/phpbb/trunk@5263 89ea8834-ac86-4346-8a33-228a782c2dd0
* blablaMeik Sievertsen2005-10-031-4/+4
| | | | git-svn-id: file:///svn/phpbb/trunk@5250 89ea8834-ac86-4346-8a33-228a782c2dd0
* - add building multi insert to dbalMeik Sievertsen2005-10-022-42/+117
| | | | | | | - fix sql explain in mysql4 layer git-svn-id: file:///svn/phpbb/trunk@5242 89ea8834-ac86-4346-8a33-228a782c2dd0
* - changed dbal class layoutMeik Sievertsen2005-08-179-1233/+279
| | | | git-svn-id: file:///svn/phpbb/trunk@5193 89ea8834-ac86-4346-8a33-228a782c2dd0
* changed name of mssql-odbc fileMeik Sievertsen2005-08-171-154/+9
| | | | git-svn-id: file:///svn/phpbb/trunk@5192 89ea8834-ac86-4346-8a33-228a782c2dd0
* - updated oracle schema/db filesMeik Sievertsen2005-05-055-394/+608
| | | | | | | - updated sqlite schema/db files git-svn-id: file:///svn/phpbb/trunk@5141 89ea8834-ac86-4346-8a33-228a782c2dd0
* - dbal changesMeik Sievertsen2005-04-225-394/+1077
| | | | git-svn-id: file:///svn/phpbb/trunk@5130 89ea8834-ac86-4346-8a33-228a782c2dd0
* tiny fixesMeik Sievertsen2005-04-206-136/+376
| | | | git-svn-id: file:///svn/phpbb/trunk@5128 89ea8834-ac86-4346-8a33-228a782c2dd0
* - added updated coding guidelinesMeik Sievertsen2005-04-103-3/+3
| | | | | | | | - introduced is_registered and is_bot flags for correct determinition of guest/registered/bot users - changed bot code to act on useragent || ip git-svn-id: file:///svn/phpbb/trunk@5117 89ea8834-ac86-4346-8a33-228a782c2dd0
* - Documentation related changesMeik Sievertsen2005-04-099-147/+151
| | | | | | | | | | - added resend activation email dialog - fixed issue in session code - log failed/successful admin re-authentication/login - fixed simple forum dropdown box (used in mcp and posting) git-svn-id: file:///svn/phpbb/trunk@5114 89ea8834-ac86-4346-8a33-228a782c2dd0
* - and my second attemptMeik Sievertsen2005-03-217-60/+55
| | | | git-svn-id: file:///svn/phpbb/trunk@5109 89ea8834-ac86-4346-8a33-228a782c2dd0
* - bugfixesMeik Sievertsen2005-01-201-2/+0
| | | | | | | | | - default sort options for posts too - adjusted format_date to remove the (time intensive) preg_ calls - temporary style.php code. git-svn-id: file:///svn/phpbb/trunk@5068 89ea8834-ac86-4346-8a33-228a782c2dd0
* - fix bugs in mysql4 layerMeik Sievertsen2005-01-161-18/+41
| | | | git-svn-id: file:///svn/phpbb/trunk@5065 89ea8834-ac86-4346-8a33-228a782c2dd0
* - this should work... he saysMeik Sievertsen2005-01-091-3/+7
| | | | git-svn-id: file:///svn/phpbb/trunk@5052 89ea8834-ac86-4346-8a33-228a782c2dd0
* - interbase/firebird 1.5+ support (still needs some tweaking)Meik Sievertsen2005-01-092-130/+88
| | | | git-svn-id: file:///svn/phpbb/trunk@5051 89ea8834-ac86-4346-8a33-228a782c2dd0
* No support for MS Access in the next major release - sorry guys, it's really ↵Paul S. Owen2005-01-091-414/+0
| | | | | | not meant for use with multiple concurrent users anyway git-svn-id: file:///svn/phpbb/trunk@5050 89ea8834-ac86-4346-8a33-228a782c2dd0
* - mssql related changesMeik Sievertsen2005-01-043-239/+481
| | | | | | | - only added NOT NULL text columns to schema_data, no updates here. ;) git-svn-id: file:///svn/phpbb/trunk@5045 89ea8834-ac86-4346-8a33-228a782c2dd0
* - mysql 4.1.x support (mysqli extension)Meik Sievertsen2005-01-021-52/+48
| | | | git-svn-id: file:///svn/phpbb/trunk@5042 89ea8834-ac86-4346-8a33-228a782c2dd0
* - fixed [code=php]Meik Sievertsen2004-12-311-23/+25
| | | | | | | - optimized db/mysql.php a little bit git-svn-id: file:///svn/phpbb/trunk@5037 89ea8834-ac86-4346-8a33-228a782c2dd0
* - forum rules + link to forum rulesMeik Sievertsen2004-05-301-1/+1
| | | | | | | | | - three new (tiny) functions added to functions_posting responsible for handling text with bbcode/smilies/urls, use them at items all over across phpbb... - some bugfixes within admin_forums and other files - new admin_board layout (much safer, security wise) git-svn-id: file:///svn/phpbb/trunk@4903 89ea8834-ac86-4346-8a33-228a782c2dd0
* language additionsMeik Sievertsen2004-05-261-0/+10
| | | | | | | some small fixes git-svn-id: file:///svn/phpbb/trunk@4893 89ea8834-ac86-4346-8a33-228a782c2dd0
* fix some issues with oop, fixing small bugs and prepare the next steps...Meik Sievertsen2004-05-021-2/+2
| | | | | | | NOTE TO DEVS: have a look at adm/admin_board.php (new config layout) git-svn-id: file:///svn/phpbb/trunk@4883 89ea8834-ac86-4346-8a33-228a782c2dd0
* show correct SQL error message if failed during a transaction...Meik Sievertsen2004-02-038-37/+45
| | | | git-svn-id: file:///svn/phpbb/trunk@4788 89ea8834-ac86-4346-8a33-228a782c2dd0
* Put mysql4.php in line with mysql.phpLudovic Arnaud2003-11-271-118/+212
| | | | git-svn-id: file:///svn/phpbb/trunk@4687 89ea8834-ac86-4346-8a33-228a782c2dd0
* ACM-related changes. Tried to make debug timings a little more accurate, ↵Ludovic Arnaud2003-11-271-26/+35
| | | | | | Note that it takes the time spent on fetching data into account when comparing db time vs cache time. Added green/red indicator (green = caching good, red = bad ;)) git-svn-id: file:///svn/phpbb/trunk@4686 89ea8834-ac86-4346-8a33-228a782c2dd0
* new permissions, merged attachment tables (the intended purpose of two ↵Meik Sievertsen2003-11-041-1/+1
| | | | | | | | | tables is no longer valid), attachment updates along the merging... Note: please merge your attachment tables (develop dir). git-svn-id: file:///svn/phpbb/trunk@4637 89ea8834-ac86-4346-8a33-228a782c2dd0
* Some html layout cleanupsPaul S. Owen2003-08-291-46/+33
| | | | git-svn-id: file:///svn/phpbb/trunk@4457 89ea8834-ac86-4346-8a33-228a782c2dd0
* Taken explain code out of sql_query. New improved layout.Ludovic Arnaud2003-08-281-55/+155
| | | | git-svn-id: file:///svn/phpbb/trunk@4447 89ea8834-ac86-4346-8a33-228a782c2dd0
* bah, group handling needs some further discussion ... I'm done with it for M-2Paul S. Owen2003-08-273-8/+10
| | | | git-svn-id: file:///svn/phpbb/trunk@4440 89ea8834-ac86-4346-8a33-228a782c2dd0
* query_id return changed back ... I think somethins is afoot with my local ↵Paul S. Owen2003-08-121-6/+1
| | | | | | repository ... git-svn-id: file:///svn/phpbb/trunk@4396 89ea8834-ac86-4346-8a33-228a782c2dd0
* Setting returned query_id to correct valuePaul S. Owen2003-08-121-7/+8
| | | | git-svn-id: file:///svn/phpbb/trunk@4390 89ea8834-ac86-4346-8a33-228a782c2dd0
* Renamed $expire_time to $max_age.Ludovic Arnaud2003-08-101-13/+12
| | | | | | | Added method_exists() checks for cache managers that would not support the caching of SQL data. git-svn-id: file:///svn/phpbb/trunk@4366 89ea8834-ac86-4346-8a33-228a782c2dd0
* Stripslashing escaped string twice ... should only be stipped when necessary ↵Paul S. Owen2003-07-221-1/+1
| | | | | | and as early as possible git-svn-id: file:///svn/phpbb/trunk@4312 89ea8834-ac86-4346-8a33-228a782c2dd0
* Insert @ supressionPaul S. Owen2003-07-041-19/+19
| | | | git-svn-id: file:///svn/phpbb/trunk@4200 89ea8834-ac86-4346-8a33-228a782c2dd0
* Note that there are still some queries in CVS which cause SQLite to have a ↵Paul S. Owen2003-07-011-1/+1
| | | | | | minor fit, these are "generally" fixed locally on my machine ... will commit when other bits and pieces are "done" ... hopefully ... perhaps ... good grief, it's nearly 3am again ... 10 years ago I could do these late nights/early mornings, bah git-svn-id: file:///svn/phpbb/trunk@4189 89ea8834-ac86-4346-8a33-228a782c2dd0