aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/includes/db
Commit message (Collapse)AuthorAgeFilesLines
* - removed useless code from style.phpNils Adermann2006-06-031-1/+1
| | | | | | | | | | | | | | - added a view template cache mode to acp_styles - syntax highlighting for the acp css - completed refresh actions for themes and templates - fixed theme and template installation - use a function for generating database theme data - removed useless code from mcp_queue.php we might need to do some more tests of acp_styles with safe_mode on git-svn-id: file:///svn/phpbb/trunk@6007 89ea8834-ac86-4346-8a33-228a782c2dd0
* DB stuff, nothing cool at all unless you use Oracle.David M2006-06-031-2/+2
| | | | git-svn-id: file:///svn/phpbb/trunk@6006 89ea8834-ac86-4346-8a33-228a782c2dd0
* some adjustmentsMeik Sievertsen2006-06-0210-153/+130
| | | | | | | nils: please have a look at the @todo comment in mcp_queue.php git-svn-id: file:///svn/phpbb/trunk@6002 89ea8834-ac86-4346-8a33-228a782c2dd0
* some tiny changes...Meik Sievertsen2006-05-262-1/+5
| | | | git-svn-id: file:///svn/phpbb/trunk@5967 89ea8834-ac86-4346-8a33-228a782c2dd0
* - fixing a few smaller bugs/glitchesMeik Sievertsen2006-05-212-2/+2
| | | | | | | | - init user session in cron.php (else it can produce errors if functions expect the user object being set) - fix sql escaping for mssql/mssql_odbc git-svn-id: file:///svn/phpbb/trunk@5957 89ea8834-ac86-4346-8a33-228a782c2dd0
* - seperate queries and cached queriesMeik Sievertsen2006-05-2010-30/+57
| | | | | | | | | - display correct read/unread information while displaying active topics - fix for SELECT DISTINCT in mssql using sql_query_limit - fix for forum updating in ACP using mssql (and probably other dbal having problems with primary keys in updates) git-svn-id: file:///svn/phpbb/trunk@5940 89ea8834-ac86-4346-8a33-228a782c2dd0
* non MySQL Databases are people too!David M2006-05-151-1/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@5915 89ea8834-ac86-4346-8a33-228a782c2dd0
* - introduce new function build_url to easily build a valid url from the ↵Meik Sievertsen2006-05-122-7/+24
| | | | | | | | | | | | | | user->page object as well as optionally removing certain keys - changed attachment config to utilize the config build methods - cleaned up posting.php - the submit/delete_post functions are now usable (functions_posting.php) - adjusted header icons (transparency) - a bunch of fixes for mssql - bug fixes git-svn-id: file:///svn/phpbb/trunk@5902 89ea8834-ac86-4346-8a33-228a782c2dd0
* I hope nothing broke!David M2006-05-0510-11/+159
| | | | | | | | | - Added a query builder, it is currently only used for complex queries that involve a FROM clause with two tables and a left join - Changed some function calls in the DBAL - Made the viewtopic queries nicer git-svn-id: file:///svn/phpbb/trunk@5885 89ea8834-ac86-4346-8a33-228a782c2dd0
* - Tuples? Nah,David M2006-04-241-1/+1
| | | | | | | | | - Install works w/ Oracle - Got the queries in the database acp to conform to the CS - profile acp now creates the proper alter column statement depending on the dbal git-svn-id: file:///svn/phpbb/trunk@5842 89ea8834-ac86-4346-8a33-228a782c2dd0
* - Query explain now works for MSSQL, MSSQL-ODBC and PostgreSQLDavid M2006-04-233-0/+90
| | | | | | | - MSSQL schema now properly includes prefixes inside of all constraints git-svn-id: file:///svn/phpbb/trunk@5839 89ea8834-ac86-4346-8a33-228a782c2dd0
* - build explain links a bit different...Meik Sievertsen2006-04-231-47/+53
| | | | | | | | | - fix btn_ip reference (it is btn_info now) - removed sql_report.css (we use the acp css) - updated the sql report layout git-svn-id: file:///svn/phpbb/trunk@5838 89ea8834-ac86-4346-8a33-228a782c2dd0
* - removed group settings from rolesMeik Sievertsen2006-04-221-1/+1
| | | | | | | | | | - added forum icon in front of forums in permissions acp - added trace permissions in permission masks (thanks naderman for writing the first code and for the idea... :)) - some bugfixes - PHP6 fix git-svn-id: file:///svn/phpbb/trunk@5824 89ea8834-ac86-4346-8a33-228a782c2dd0
* - Olympus can now _install_ every database, more work to come on getting the ↵David M2006-04-211-0/+2
| | | | | | rest of the board to work git-svn-id: file:///svn/phpbb/trunk@5811 89ea8834-ac86-4346-8a33-228a782c2dd0
* Firebird changesDavid M2006-04-191-4/+4
| | | | | | | | | - fixed sql_nextid() - sql_affectedrows fixed for PHP 5+ - sql_affectedrows modified so that it works for PHP 4 ( don't expect a valid numeric answer! ) git-svn-id: file:///svn/phpbb/trunk@5805 89ea8834-ac86-4346-8a33-228a782c2dd0
* - make freeresult work as it shouldDavid M2006-04-181-5/+0
| | | | git-svn-id: file:///svn/phpbb/trunk@5801 89ea8834-ac86-4346-8a33-228a782c2dd0
* - Forgot to remove a lang stringDavid M2006-04-183-3/+6
| | | | | | | | - Firebird! - Fixes for mssql and mssql-odbc git-svn-id: file:///svn/phpbb/trunk@5800 89ea8834-ac86-4346-8a33-228a782c2dd0
* - firebird returns an error code (if you are on php 5)David M2006-04-181-1/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@5795 89ea8834-ac86-4346-8a33-228a782c2dd0
* - oopsieDavid M2006-04-181-2/+13
| | | | git-svn-id: file:///svn/phpbb/trunk@5794 89ea8834-ac86-4346-8a33-228a782c2dd0
* - Olympus now properly works with MS SQLDavid M2006-04-181-2/+3
| | | | | | | | - DB backup system handles MS SQL - A few bug fixes to the backup system ;) git-svn-id: file:///svn/phpbb/trunk@5793 89ea8834-ac86-4346-8a33-228a782c2dd0
* - fixed some bugsMeik Sievertsen2006-04-152-2/+2
| | | | | | | | | | - made sql schemas consistent - added correct sequences and generators to sql schemas - extended some rows to hold more data. This solves issues with multibyte characters and too short topic titles, names, etc. - allow multibyte characters in usernames git-svn-id: file:///svn/phpbb/trunk@5784 89ea8834-ac86-4346-8a33-228a782c2dd0
* - fix for a php bug (not able to connect on custom ports if the server is ↵Meik Sievertsen2006-04-081-2/+12
| | | | | | localhost - though 127.0.0.1 works) -> #1444 git-svn-id: file:///svn/phpbb/trunk@5774 89ea8834-ac86-4346-8a33-228a782c2dd0
* - Needless regular expressionsDavid M2006-03-221-2/+2
| | | | git-svn-id: file:///svn/phpbb/trunk@5692 89ea8834-ac86-4346-8a33-228a782c2dd0
* - Bug 1183David M2006-03-221-2/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@5685 89ea8834-ac86-4346-8a33-228a782c2dd0
* - a bunch of bugfixes. :PMeik Sievertsen2006-03-212-2/+2
| | | | git-svn-id: file:///svn/phpbb/trunk@5678 89ea8834-ac86-4346-8a33-228a782c2dd0
* - add our beloved in_phpbb checkMeik Sievertsen2006-03-199-0/+63
| | | | git-svn-id: file:///svn/phpbb/trunk@5670 89ea8834-ac86-4346-8a33-228a782c2dd0
* - Cleaned up some compress stuffDavid M2006-03-181-10/+10
| | | | | | | | | - Replaced deprecated functions in the PostrgreSQL DBAL - Added an undefined constant during install - Oh, and we now have backups :D We currently work with all the MySQL flavors, PostgreSQL and SQLite... git-svn-id: file:///svn/phpbb/trunk@5647 89ea8834-ac86-4346-8a33-228a782c2dd0
* - fix some bugs...Meik Sievertsen2006-03-178-8/+8
| | | | git-svn-id: file:///svn/phpbb/trunk@5643 89ea8834-ac86-4346-8a33-228a782c2dd0
* - Postgre installs now work... kinda...David M2006-03-171-2/+2
| | | | git-svn-id: file:///svn/phpbb/trunk@5642 89ea8834-ac86-4346-8a33-228a782c2dd0
* - SQLite is now usable; we died on certain queries as well as a schema issue ↵David M2006-03-161-2/+3
| | | | | | (I took the liberty of applying some RegEx-Fu to the parser :D) git-svn-id: file:///svn/phpbb/trunk@5638 89ea8834-ac86-4346-8a33-228a782c2dd0
* Efficiency changeGraham Eames2006-03-091-1/+1
| | | | git-svn-id: file:///svn/phpbb/trunk@5615 89ea8834-ac86-4346-8a33-228a782c2dd0
* - fix cookie shorteningMeik Sievertsen2006-03-091-1/+0
| | | | | | | | - let the acm handle the module cache - call $cache->save() after destroying data if necessary git-svn-id: file:///svn/phpbb/trunk@5612 89ea8834-ac86-4346-8a33-228a782c2dd0
* Broken images begone!Graham Eames2006-03-061-22/+38
| | | | | | | Who wants to go next? git-svn-id: file:///svn/phpbb/trunk@5606 89ea8834-ac86-4346-8a33-228a782c2dd0
* implementing permission rolesMeik Sievertsen2006-02-221-0/+1
| | | | | | | | | | | | | - copy permissions (adding groups) - copy permissions (adding forums) - checking proper groupadd/del settings - added intro page to permissions (to give an overview and quick links) - able to select forums + subforums, single forum, all groups, all users (permission screens) - able to reset permissions (only reset input field) - fix forum deletion bug git-svn-id: file:///svn/phpbb/trunk@5574 89ea8834-ac86-4346-8a33-228a782c2dd0
* - only minor adjustements (we are now able to use other functions due to the ↵Meik Sievertsen2006-02-164-10/+20
| | | | | | increased php requirements) git-svn-id: file:///svn/phpbb/trunk@5557 89ea8834-ac86-4346-8a33-228a782c2dd0
* display complete backtrace. ;)Meik Sievertsen2006-02-151-0/+9
| | | | git-svn-id: file:///svn/phpbb/trunk@5556 89ea8834-ac86-4346-8a33-228a782c2dd0
* 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