aboutsummaryrefslogtreecommitdiffstats
path: root/phpBB/includes/db/dbal.php
Commit message (Collapse)AuthorAgeFilesLines
* some updates. Also adjusted the utf tools and normalizer more to our coding ↵Meik Sievertsen2006-08-221-1/+1
| | | | | | guidelines. git-svn-id: file:///svn/phpbb/trunk@6312 89ea8834-ac86-4346-8a33-228a782c2dd0
* specialchar sql query to ensure proper display if there are html characters ↵Meik Sievertsen2006-08-221-1/+1
| | | | | | within the sql query git-svn-id: file:///svn/phpbb/trunk@6310 89ea8834-ac86-4346-8a33-228a782c2dd0
* sql_in_set changesMeik Sievertsen2006-08-121-72/+23
| | | | git-svn-id: file:///svn/phpbb/trunk@6271 89ea8834-ac86-4346-8a33-228a782c2dd0
* so.... what does this thing do?David M2006-08-111-8/+1
| | | | | | | | | | | well, the super fast, ultra efficient, massively huge BBCode handling system was implemented differently on each DBMS. Although this provided the best performance, the solution was a bit hacky. So what does this new thing do? We use base64 encoding to make everything nice and shiny, it turns into nice, safe characters that we can just jam into varchars on essentially any database. This has two implications: we must decode every bitfield we get AND we have slightly fewer IDs to work with. It goes down from 2040 BBCodes to 1512. We lose like a quarter of them :P P.S. I hope nothing broke :P git-svn-id: file:///svn/phpbb/trunk@6263 89ea8834-ac86-4346-8a33-228a782c2dd0
* Oops, I forgot the negate bit in sql_in_set()Nils Adermann2006-08-111-3/+3
| | | | git-svn-id: file:///svn/phpbb/trunk@6262 89ea8834-ac86-4346-8a33-228a782c2dd0
* Adding the sql_in_set function which should give us a bit of a performance ↵Nils Adermann2006-08-111-0/+43
| | | | | | improvement for queries using IN with just one value git-svn-id: file:///svn/phpbb/trunk@6261 89ea8834-ac86-4346-8a33-228a782c2dd0
* This should end some issues we have been having regarding the proper binary ↵David M2006-08-061-3/+29
| | | | | | | | | encoding of stuff. :D Acyd Burn: quit breaking the schema :P git-svn-id: file:///svn/phpbb/trunk@6238 89ea8834-ac86-4346-8a33-228a782c2dd0
* - custom profile field fixedMeik Sievertsen2006-08-031-1/+1
| | | | | | | | - fixing sql_fetchfield from cache - changing the quote parser. In my tests i have not seen changed behaviour - but i might have broken something with this change. git-svn-id: file:///svn/phpbb/trunk@6232 89ea8834-ac86-4346-8a33-228a782c2dd0
* - renamed the following columns:Meik Sievertsen2006-07-131-5/+1
| | | | | | | | | | | | | | | comment -> attach_comment new, forwarded, unread, marked, deleted -> pm_new, pm_forwarded, pm_unread, pm_marked, pm_deleted module_name -> module_basename value -> lang_value - every column is now NOT NULL - every column is now having a DEFAULT value - hopefully mostly consistent across every db schema - untested schemas: sqlite, oracle, firebird git-svn-id: file:///svn/phpbb/trunk@6177 89ea8834-ac86-4346-8a33-228a782c2dd0
* - it's \r\n not \n\r [Bug #3121]Nils Adermann2006-07-121-1/+11
| | | | | | | | | - a few little search bugfixes - drop in the improved version of the native search based on UTF-8 (still needs some work before it can replace the current native search) Thanks Ashe :) git-svn-id: file:///svn/phpbb/trunk@6175 89ea8834-ac86-4346-8a33-228a782c2dd0
* - store error result in dbal for later retrievingMeik Sievertsen2006-06-141-4/+22
| | | | | | | | - use method for moving modules up/down (will be extended later to not only support an amount of 1) - utilize the module methods in installation git-svn-id: file:///svn/phpbb/trunk@6061 89ea8834-ac86-4346-8a33-228a782c2dd0
* make sure custom profile fields are created correctly on registration (#2225)Meik Sievertsen2006-06-131-2/+2
| | | | git-svn-id: file:///svn/phpbb/trunk@6058 89ea8834-ac86-4346-8a33-228a782c2dd0
* ok, this one is rather large... the most important change:Meik Sievertsen2006-06-061-1/+43
| | | | | | | | | re-introduce append_sid: old style continues to work, not a performance hog as it was in 2.0.x -> structure is different apart from this, code cleanage, bug fixing, etc. git-svn-id: file:///svn/phpbb/trunk@6015 89ea8834-ac86-4346-8a33-228a782c2dd0
* - 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
* some adjustmentsMeik Sievertsen2006-06-021-14/+3
| | | | | | | 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-261-1/+3
| | | | git-svn-id: file:///svn/phpbb/trunk@5967 89ea8834-ac86-4346-8a33-228a782c2dd0
* - seperate queries and cached queriesMeik Sievertsen2006-05-201-8/+29
| | | | | | | | | - 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-121-3/+5
| | | | | | | | | | | | | | 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-051-0/+61
| | | | | | | | | - 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
* - 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
* - 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
* 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-251-1/+10
| | | | | | | | | | | 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
* - Defined some DBAL class varsDavid M2006-01-011-0/+3
| | | | git-svn-id: file:///svn/phpbb/trunk@5414 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
* - more acp additions and changes...Meik Sievertsen2005-11-201-2/+2
| | | | git-svn-id: file:///svn/phpbb/trunk@5310 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-071-2/+119
| | | | | | | | - adjusted the dbal a little bit - removed db2 support git-svn-id: file:///svn/phpbb/trunk@5263 89ea8834-ac86-4346-8a33-228a782c2dd0
* - add building multi insert to dbalMeik Sievertsen2005-10-021-21/+96
| | | | | | | - 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-171-0/+196
git-svn-id: file:///svn/phpbb/trunk@5193 89ea8834-ac86-4346-8a33-228a782c2dd0
generated by cgit v1.2.1 (git 2.21.0) at 2025-12-26 03:40:32 +0000