| 9044 |
View
| Annotate |
|
|
11/02/2008 12:36 PM |
acydburn |
db_tools from static to non-static due to the db dependancy (#31245) |
| 9027 |
View
| Annotate |
|
|
10/17/2008 04:56 PM |
acydburn |
gah@trunk |
| 9025 |
View
| Annotate |
|
|
10/17/2008 12:33 PM |
acydburn |
Disable referer validation on install if it is not possible to determine correct referer due to a proxy setup (Bug #32765) |
| 8889 |
View
| Annotate |
|
|
09/19/2008 03:17 PM |
Kellanved |
Okay, that is pretty raw, but better to have it in place than trying to play catch-up. Introducing an early stage of CAPTCHA modules. |
| 8821 |
View
| Annotate |
|
|
09/04/2008 04:10 PM |
acydburn |
Get real dbms version instead of relying on php internal functions which only grab the local library version |
| 8812 |
View
| Annotate |
|
|
09/04/2008 01:39 PM |
toonarmy |
Remove caching of templates from the database completely, themes is cut down ready for a complete chop, and fix the installer :) |
| 8781 |
View
| Annotate |
|
|
08/22/2008 03:32 PM |
acydburn |
Merge chmod changes into trunk |
| 8759 |
View
| Annotate |
|
|
08/15/2008 03:00 PM |
aptx |
PHP5.3 compatibility. |
| 8659 |
View
| Annotate |
|
|
06/18/2008 11:32 PM |
aptx |
Change 5.1.0 to 5.2.0 |
| 8637 |
View
| Annotate |
|
|
06/09/2008 07:10 PM |
acydburn |
#27395 |
| 8599 |
View
| Annotate |
|
|
06/04/2008 05:38 PM |
naderman |
removed executable props [Bug #6464] |
| 8590 |
View
| Annotate |
|
|
06/04/2008 01:23 PM |
acydburn |
fix adm redirect |
| 8583 |
View
| Annotate |
|
|
06/03/2008 04:57 PM |
acydburn |
add missing constant to config file |
| 8572 |
View
| Annotate |
|
|
05/29/2008 02:25 PM |
acydburn |
ok… i hope i haven’t messed too much with the code and everything is still working. Changes: - Ascraeus now uses constants for the phpbb root path and the php extension. This ensures more security for external applications and modifications (no more overwriting of root path and extension possible through insecure mods and register globals enabled) as well as no more globalizing needed. - A second change implemented here is an additional short-hand-notation for append_sid(). It is allowed to omit the root path and extension now (for example calling append_sid(‘memberlist’)) – in this case the root path and extension get added automatically. The hook is called after these are added. |
| 8477 |
View
| Annotate |
|
|
03/29/2008 01:08 AM |
naderman |
Go away evil carriage returns\! |
| 8452 |
View
| Annotate |
|
|
03/18/2008 03:47 PM |
acydburn |
merging… again |
| 8349 |
View
| Annotate |
|
|
01/29/2008 04:57 PM |
acydburn |
Merging revisions #r8346, #r8347 and #r8348 |
| 8319 |
View
| Annotate |
|
|
01/11/2008 06:07 AM |
davidmj |
- use proper OOP for db_tools - made it all static. If one of you disagree, you are free to change it. I just couldn’t think of a reason of having it otherwise… |
| 8318 |
View
| Annotate |
|
|
01/10/2008 10:46 PM |
davidmj |
we enter a brave new world…
- fix schema data so that it can now be used - replace the current system of packaging schemas with phpBB with a new system that dynamically generates the schemas on the fly - give the db tools package the power to create databases |
| 8315 |
View
| Annotate |
|
|
01/08/2008 07:44 AM |
davidmj |
- make viewforum work again - remove the lower case functions, they were stupid anyway - added some indexes - added a group_name_clean column |
| 8313 |
View
| Annotate |
|
|
01/07/2008 04:19 PM |
davidmj |
- a few tiny clean ups - a new MS SQL DBAL, it does not work so hot because of issues with the extension it depends on |
| 8308 |
View
| Annotate |
|
|
01/06/2008 02:46 PM |
davidmj |
- add DB2 support /me takes a nap |
| 8307 |
View
| Annotate |
|
|
01/06/2008 03:21 AM |
davidmj |
the end of an era… - MySQL < 4.1.3 support is removed - renamed mysql4 to mysql, no need to cause confusion - changed the cfg cacher, reduces file system lookups and include count by two on every page load |
| 8295 |
View
| Annotate |
|
|
01/03/2008 06:00 PM |
davidmj |
oh boy… - Migrate code base to PHP 5.1+ |
| 8294 |
View
| Annotate |
|
|
01/03/2008 03:37 PM |
kellanved |
cross-ci to the head |
| 8290 |
View
| Annotate |
|
|
12/27/2007 06:34 PM |
acydburn |
#16695 #s17235 |
| 8248 |
View
| Annotate |
|
|
11/19/2007 05:44 PM |
acydburn |
further updates |
| 8224 |
View
| Annotate |
|
|
11/03/2007 09:31 PM |
acydburn |
further fixes - fix infinite loop on checking ban for those not having ever visited the page (or removed all session cookies) - avatar width/height switched in language files - fix windows switching to background on IE7 (smlies window for example) |
| 8211 |
View
| Annotate |
|
|
10/21/2007 01:26 PM |
acydburn |
make sure we always check for a valid directory handle |
| 8167 |
View
| Annotate |
|
|
10/12/2007 06:11 PM |
kellanved |
#14704 That should solve the issue for the user table, I hope that it doesn’t manifest at other places. |
| 8139 |
View
| Annotate |
|
|
10/04/2007 08:50 PM |
acydburn |
#i42 new password hashing mechanism for storing passwords |
| 8130 |
View
| Annotate |
|
|
10/04/2007 01:33 PM |
acydburn |
deregister globals to install too |
| 8116 |
View
| Annotate |
|
|
10/01/2007 07:43 PM |
acydburn |
#i112 |
| 8072 |
View
| Annotate |
|
|
08/30/2007 11:21 PM |
acydburn |
necessary changes… |
| 7961 |
View
| Annotate |
|
|
07/27/2007 07:33 PM |
acydburn |
err, forgot to commit |
| 7929 |
View
| Annotate |
|
|
07/23/2007 06:25 PM |
acydburn |
needed fixes |
| 7920 |
View
| Annotate |
|
|
07/22/2007 10:11 PM |
acydburn |
try to normalize everything… |
| 7884 |
View
| Annotate |
|
|
07/14/2007 05:44 PM |
acydburn |
a bunch of fixes |
| 7875 |
View
| Annotate |
|
|
07/12/2007 06:14 PM |
acydburn |
some more fixes |
| 7866 |
View
| Annotate |
|
|
07/11/2007 05:03 PM |
acydburn |
some fixes |
| 7860 |
View
| Annotate |
|
|
07/10/2007 05:14 PM |
acydburn |
some fixes here and there |
| 7830 |
View
| Annotate |
|
|
07/03/2007 05:36 PM |
acydburn |
let’s see if i can break something. :o |
| 7818 |
View
| Annotate |
|
|
07/01/2007 06:09 PM |
acydburn |
some fixes… most importantly the ability to update the board with the automatic files while having fsockopen disabled (instead, the update file information will be used, which may be inaccurate if the admin did a mistake). |
| 7736 |
View
| Annotate |
|
|
06/09/2007 01:11 PM |
acydburn |
ok, mess around with the templates + fixing some bugs + adjusting headers for those files already modified to circumvent conflicts for those having their editor set to remove trailing spaces (not recommended!) |
| 7734 |
View
| Annotate |
|
|
06/08/2007 06:01 PM |
davidmj |
same old, same old |
| 7733 |
View
| Annotate |
|
|
06/08/2007 06:00 PM |
davidmj |
another Oracle fix |
| 7684 |
View
| Annotate |
|
|
05/26/2007 02:44 PM |
kellanved |
#11431 |
| 7644 |
View
| Annotate |
|
|
05/19/2007 05:44 PM |
acydburn |
Allow pre-setting language dependant data in schema_data.sql… specified with {L_*}, also create the search index on installation |
| 7631 |
View
| Annotate |
|
|
05/18/2007 04:33 PM |
acydburn |
Disable DEBUG by default, enable backtrace by default |
| 7583 |
View
| Annotate |
|
|
05/15/2007 03:48 PM |
kellanved |
Be more explicit regarding the requirements.
Once more, this introduces language variables. |
| 7527 |
View
| Annotate |
|
|
05/11/2007 02:25 PM |
acydburn |
We do not support nesting code tags – #10763 #10741 Confirm box on pruning forums – #10619 Not stripping empty lines on parsing messages – #10579 Remove reports alongside with users – #10501 |
| 7478 |
View
| Annotate |
|
|
05/05/2007 11:33 PM |
kellanved |
Introducing a new CAPTCHA. Thanks to Robert “Xore” Hetzler for idea & code and Ashley “Neothermic” Pinner for her expertise and contributions to said code.
This introduces new language variables, so take note translators :). |
| 7469 |
View
| Annotate |
|
|
05/05/2007 12:22 PM |
acydburn |
Better support for nested transactions… |
| 7455 |
View
| Annotate |
|
|
05/03/2007 04:29 PM |
acydburn |
some language-specific adjustements fix prune users (adding the list of users to the confirmation page) tried to fix the show/hide trigger in ACP by not using width: auto; (which gets somehow inherited to each other element) |
| 7429 |
View
| Annotate |
|
|
04/30/2007 12:46 PM |
kellanved |
Prepare to be yelled at and brace for the tide of bug reports: I had hoped we would not have to do this, but it seems that we have to.
Route all avatar downloads through download.php – adrien -Change the way inline attachments are delivered -Fixes a few (unreported) bugs, notably avatar upload during group generation
#10079
|
| 7421 |
View
| Annotate |
|
|
04/28/2007 04:24 PM |
davidmj |
I am not having much luck these days… |
| 7420 |
View
| Annotate |
|
|
04/28/2007 04:18 PM |
davidmj |
typo |
| 7417 |
View
| Annotate |
|
|
04/28/2007 02:02 PM |
davidmj |
ok, now let it actually work :P |
| 7415 |
View
| Annotate |
|
|
04/28/2007 02:54 AM |
davidmj |
oops |
| 7414 |
View
| Annotate |
|
|
04/28/2007 02:53 AM |
davidmj |
installer tries to install language specific imageset entries |
| 7302 |
View
| Annotate |
|
|
04/08/2007 05:14 PM |
acydburn |
#9659 #9569 |
| 7255 |
View
| Annotate |
|
|
04/01/2007 02:39 PM |
davidmj |
- PostgreSQL can now use schemas. During install, under database name, enter databasename.schema - phpversion() to PHP_VERSION |
| 7180 |
View
| Annotate |
|
|
03/12/2007 10:43 PM |
acydburn |
remove user with empty username_clean… |
| 7078 |
View
| Annotate |
|
|
02/26/2007 12:00 AM |
shs |
A couple changes to improve usability:
1) Reworded the “Install missing” explain for the converter 2) “Forked” the final page of a clean install to give two options… #1 being going to the convertor and #2 being the already existing “Take me to your ACP!” stuff.
Shouldn’t have broken anything else, though the i18n/L10n lot will need to update their strings for this. ;) |
| 7010 |
View
| Annotate |
|
|
02/19/2007 05:15 AM |
davidmj |
- forgot a few places :P |
| 6995 |
View
| Annotate |
|
|
02/17/2007 12:06 AM |
naderman |
- allow converting from one database to another, no need for tables to be in one database anylonger (this also allows switching from one DBMS that was used with phpBB2 to another DBMS supported by phpBB3 including new systems available in Olympus only) - abstracted some installation code that is now relevant to converting as well into functions_install.php (mostly DBMS selection related) - fixed a weird smiley path problem, no idea why nobody else noticed this, maybe my fix was incorrect? - forgot to commit a file last time |
| 6956 |
View
| Annotate |
|
|
02/02/2007 04:36 PM |
acydburn |
only very tiny fixes. |
| 6934 |
View
| Annotate |
|
|
01/27/2007 01:30 PM |
acydburn |
#7424 - rebuild username_clean column due to changes in utf8_clean_string() |
| 6927 |
View
| Annotate |
|
|
01/24/2007 06:19 PM |
acydburn |
- fix severe bug with email hash calculation - fix bug in convertor not correctly converting config values |
| 6912 |
View
| Annotate |
|
|
01/20/2007 06:58 PM |
acydburn |
- fixing some bugs - removing utf8 characters from email files (has been discussed internally, you guys know why) - making sure some opendir calls are checked before calling readdir. |
| 6910 |
View
| Annotate |
|
|
01/20/2007 05:20 AM |
davidmj |
#7256 |
| 6908 |
View
| Annotate |
|
|
01/19/2007 12:58 PM |
acydburn |
some opendir/closedir fixes |
| 6872 |
View
| Annotate |
|
|
01/10/2007 05:47 PM |
acydburn |
fix some general bugs and some convertor related |
| 6863 |
View
| Annotate |
|
|
01/09/2007 02:33 AM |
davidmj |
- installer now checks if the page size is correct for Firebird - Firebird now has a proper explain page |
| 6842 |
View
| Annotate |
|
|
01/05/2007 04:31 PM |
acydburn |
unique cookie name anyone? |
| 6826 |
View
| Annotate |
|
|
12/31/2006 05:56 PM |
acydburn |
- telling the admin for what the board contact and board email addresses are used for and also making sure this explanation is correct ;) - fixes for bugs #6694, #6664 and #6662 |
| 6815 |
View
| Annotate |
|
|
12/27/2006 05:51 PM |
davidmj |
#6600 |
| 6803 |
View
| Annotate |
|
|
12/24/2006 02:11 PM |
acydburn |
some fixes today - most important change is the consolidation of the display attachment functions; merging them together to have one function we need to call. |
| 6785 |
View
| Annotate |
|
|
12/21/2006 03:07 AM |
davidmj |
#6460, thanks to ToonArmy for the patch :D - removed pregenerated template variables from the installer |
| 6781 |
View
| Annotate |
|
|
12/18/2006 06:29 PM |
acydburn |
- Modules are not added correctly [#6370] - Minor bug in ucp_prefs_personal.html (Opera) [#6348] - MCP-Warnings section colspan problem in Opera [#6338] - Loading extensions on install [#6332] - Adjust PM rules if folder removed [#6326] - #6318 - Coppa registration [#6306] - Quick-Mod Topic Type Changes Fail when Topic == Global [#6228] - added the possibility to change topic type for more than one topic (within mcp) |
| 6730 |
View
| Annotate |
|
|
12/08/2006 04:20 PM |
acydburn |
- re-add script_path for “strange configurations” to let them force the generated urls correctly - show rank title if no rank image present in memberlist - other fixes. |
| 6701 |
View
| Annotate |
|
|
12/02/2006 07:16 PM |
davidmj |
- pretty serious speed improvement for strtoupper/strtolower - mbstring envrio checks #5774 |
| 6678 |
View
| Annotate |
|
|
11/27/2006 10:34 PM |
davidmj |
don’t mind me, I just forgot something :D |
| 6676 |
View
| Annotate |
|
|
11/27/2006 10:24 PM |
davidmj |
#5640 |
| 6650 |
View
| Annotate |
|
|
11/24/2006 03:59 PM |
acydburn |
rather large update, most important things done: - implemented provided patch/diff file for bug #5350 (Highway of Life) with some tiny changes and alterations - more username/colour changes/fixes - added a note about PM rule-dependant message removals so the user is not wondering too much if he can’t remember his rules. :) - some column changes to fix unicode issues - bugfixes |
| 6629 |
View
| Annotate |
|
|
11/21/2006 07:20 PM |
acydburn |
decrease the barrier for E_ALL error reporting and email traces from DEBUG_EXTRA to DEBUG |
| 6628 |
View
| Annotate |
|
|
11/21/2006 07:15 PM |
acydburn |
- fixing a bunch of bugs - moved the install trigger error to sessions and also disabled it for those having DEBUG_EXTRA enabled. i hope not having introduced too many new bugs. |
| 6602 |
View
| Annotate |
|
|
11/18/2006 06:26 PM |
acydburn |
let us be more strict while testing for writeable directories. |
| 6584 |
View
| Annotate |
|
|
11/15/2006 04:35 PM |
acydburn |
- fixes for the following bugs: #5326 #5318 #5304 #5290 #5288 #5278 #5276 #5272 #5266 - also fixed the “Call-time pass-by-reference” bug #5252 - within this step changed the normalize calls to require references. - added captcha size variables to the class scope (suggestion was posted at area51) |
| 6581 |
View
| Annotate |
|
|
11/13/2006 11:44 PM |
davidmj |
@#$x%x! |
| 6570 |
View
| Annotate |
|
|
11/12/2006 03:42 PM |
davidmj |
blah blah blah :D |
| 6563 |
View
| Annotate |
|
|
11/10/2006 03:56 PM |
davidmj |
- cleaned up firebirdsql - cleaned up install |
| 6552 |
View
| Annotate |
|
|
11/04/2006 06:19 PM |
acydburn |
- use the $var_ary for settings in a more logical way (hopefully removes the clutter and shows where which variable is set how) - hopefully utf8 passwords are working too now |
| 6549 |
View
| Annotate |
|
|
11/04/2006 12:09 AM |
davidmj |
- compress is nicer (fixed a bug :P) - UTF-8 code is nicer (fixed a bug :P) - new CAPTCHA. Replaced the old one for size and usability issues. The old CAPTCHA will most likely be released as a separate package |
| 6548 |
View
| Annotate |
|
|
11/03/2006 10:05 PM |
acydburn |
ok, i am an idiot… |
| 6546 |
View
| Annotate |
|
|
11/03/2006 06:50 PM |
acydburn |
- make sure the sql layer for mysql always states mysql4 and get to mysql if using mysql < 4 - assign some default vars to email templates (we always need some basic ones) |
| 6545 |
View
| Annotate |
|
|
11/03/2006 12:26 PM |
acydburn |
- implemented the suggested html_entity_decode function made by david - fixed string length checking by also decoding entities for the sake of checking - used the new html_entity_decode function |
| 6517 |
View
| Annotate |
|
|
10/22/2006 03:32 PM |
acydburn |
- now username changes should work as desired - removed some extract() calls |
| 6511 |
View
| Annotate |
|
|
10/19/2006 03:55 PM |
acydburn |
Revised attachment categories a bit Fixes for the following bugs: #4830 #4818 #4816 #4810 #4808 #4798 #4796 #4772 #4662 #4646 #4546 #4524 #4270
I hope not having introduced additional severe errors :) |
| 6509 |
View
| Annotate |
|
|
10/18/2006 11:39 PM |
davidmj |
#4812 #4804 |
| 6497 |
View
| Annotate |
|
|
10/14/2006 04:56 PM |
acydburn |
- store sql_layer directly within the layer itself - new method sql_multi_insert to circumvent db-specific hacks (hopefully not introduced any parsing errors) |
| 6495 |
View
| Annotate |
|
|
10/14/2006 03:02 PM |
grahamje |
Need to set the clean form on install |
| 6461 |
View
| Annotate |
|
|
10/07/2006 09:07 PM |
grahamje |
Make the UTF tools available – recent changes require them in the install and they are likely to be needed in conversion as well Fix some broken redirects Change the structure of language packs we scan for. (language packs should be named in the form xx-yy – all lowercase with hyphens as the separator) |
| 6452 |
View
| Annotate |
|
|
10/07/2006 02:36 PM |
acydburn |
tried to begin adjusting all string functions where applicable – still a lot to do. i hope i catched all relevant sections and did not mess something up. |
| 6447 |
View
| Annotate |
|
|
10/06/2006 08:43 PM |
acydburn |
- support re-caching of theme data if stylesheet.css changed and load_tplcompile enabled - mcp fixes - fixed some usability issues |
| 6440 |
View
| Annotate |
|
|
10/04/2006 08:25 PM |
grahamje |
Check that we actually have a valid fp |
| 6436 |
View
| Annotate |
|
|
10/03/2006 08:35 PM |
acydburn |
- extend config checking to include check for writeable path - removed not utilized user_allow_email column from schema - removed inactive groups (they had no use at all, since inactive users are not able to login) The only benefit those brought are distinguish users – but this is no longer needed too due to the inactive code present. This also allows us to retain group memberships as well as default settings for users being set inactive due to profile changes. - rewrote user_active_flip to support multiple users and a mode, as well as coping with the aforementioned changes - implemented updated jabber class to support SRV server records and for better jabberd2 support. - jabber errors now logged to the error log with a full transaction - fixed user_delete calls to include usernames where possible and also update last post information correctly - implemented additioal checks to user management to cope with common mistakes - On installation, guess the required mysql schema as best as possible. Users now only need to decide if they want to use the mysqli extension or not (mysqli selected by default) and no longer need to know their mysql version. - founders do not need to re-activate their account on profile changes - remove older session if re-authentication was successful (re-authentication always assigns a new session id) - set the cookie directly instead of using php’s function - added inactive_remind to see which users got deactivated because of reminders (or re-activation) sent out
hopefully not introduced too many bugs – those testing with CVS releases, please concentrate on user registration, activation, profile changes (email/password)... |
| 6433 |
View
| Annotate |
|
|
10/03/2006 05:17 AM |
davidmj |
complete check for FB |
| 6431 |
View
| Annotate |
|
|
10/02/2006 05:33 PM |
davidmj |
remove my debug code |
| 6429 |
View
| Annotate |
|
|
10/02/2006 05:31 PM |
davidmj |
#4564 |
| 6425 |
View
| Annotate |
|
|
10/01/2006 06:20 PM |
davidmj |
- Goodbye MySQL4, hello unified MySQL driver. MySQL 3.23 to MySQL 5.0 are now in one driver. |
| 6422 |
View
| Annotate |
|
|
10/01/2006 10:48 AM |
davidmj |
- forgot to make the same change to the ODBC driver - MySQL 3.x works now - FirebirdSQL is now on the same level as MySQL and PostgreSQL, zero hacks exist inside the core code now |
| 6394 |
View
| Annotate |
|
|
09/23/2006 02:27 PM |
grahamje |
A reworking of how we handle inactive users |
| 6381 |
View
| Annotate |
|
|
09/19/2006 06:50 AM |
davidmj |
- Oracle now works with large amounts of text - MSSQL now works :P (sans UTF-8 support) - The current schema files work well enough to install, etc. but must be tightened. Will get to it when I get some time… |
| 6375 |
View
| Annotate |
|
|
09/16/2006 09:36 PM |
grahamje |
- Fix default language option if more than one pack is present
- Fix moderator roles to match their description
- Add new forum role for closer mapping of converted permissions
|
| 6374 |
View
| Annotate |
|
|
09/16/2006 04:04 PM |
grahamje |
Extra check on table prefix for mysql |
| 6373 |
View
| Annotate |
|
|
09/16/2006 03:27 PM |
davidmj |
oops |
| 6371 |
View
| Annotate |
|
|
09/16/2006 08:07 AM |
davidmj |
bug fixes schema changes i really hope nothing went wrong |
| 6364 |
View
| Annotate |
|
|
09/13/2006 06:08 PM |
acydburn |
- fixed some bugs - changed attachment handling a bit - tried to remove target tags out of the code - do not add session ids to urls for bots as well as not creating a new session on each page view for them
I bet i introduced some bugs too. ;) |
| 6361 |
View
| Annotate |
|
|
09/08/2006 10:06 PM |
grahamje |
Add the lock file to allow dynamic menus |
| 6345 |
View
| Annotate |
|
|
09/02/2006 03:33 PM |
acydburn |
some changes/fixes |
| 6337 |
View
| Annotate |
|
|
08/30/2006 09:44 PM |
grahamje |
Correctly set IP address on initial post and user profile |
| 6308 |
View
| Annotate |
|
|
08/20/2006 09:50 PM |
acydburn |
- add some language variables i will need at another location. ;) - also add X-Sendfile support to the download.php file. |
| 6298 |
View
| Annotate |
|
|
08/17/2006 03:23 PM |
davidmj |
|
| 6291 |
View
| Annotate |
|
|
08/13/2006 08:21 PM |
grahamje |
Add GD to the list of optional requirements since it allows more VC images to be used |
| 6275 |
View
| Annotate |
|
|
08/12/2006 05:10 PM |
acydburn |
bugfixes |
| 6268 |
View
| Annotate |
|
|
08/12/2006 09:00 AM |
grahamje |
Check the prefix length to ensure that the key names are within the maximum for that DBMS |
| 6265 |
View
| Annotate |
|
|
08/12/2006 03:38 AM |
davidmj |
- oops |
| 6263 |
View
| Annotate |
|
|
08/11/2006 11:52 PM |
davidmj |
so…. what does this thing do?
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 |
| 6255 |
View
| Annotate |
|
|
08/09/2006 05:53 PM |
davidmj |
Nobody found this bug so i guess nobody has such an old DB :P
MySQL < 4.1.2 has a broken varbinary. TINYBLOB is (2**8)-1 characters = 255. This means we can let older DBs use our stuff without any fear. |
| 6241 |
View
| Annotate |
|
|
08/06/2006 07:25 PM |
naderman |
- finally making the age calculation work [Bug #3582] - replacing all occurances of L_NONE with a more specific string [Bug #3494] - a few corrections to html id attributes in the installer - using correct permission in mcp_report [Bug #2471] - allow deleting the avatar, when no upload method is enabled and hide the delete button if no avatar is set |
| 6238 |
View
| Annotate |
|
|
08/06/2006 07:52 AM |
davidmj |
This should end some issues we have been having regarding the proper binary encoding of stuff. :D Acyd Burn: quit breaking the schema :P |
| 6237 |
View
| Annotate |
|
|
08/05/2006 05:49 PM |
acydburn |
- fixed some bugs - made imageset naming more consistent - updated every schema to be consistent and also fixed it (every db should install fine now) - |
| 6209 |
View
| Annotate |
|
|
07/24/2006 12:08 PM |
davidmj |
OK…
This commit should increase the total number of BBCodes from 31 to 2040. Some things to watch out for:
Each database likes to deal with binary data in its own, special way. They are, quite frankly, too cool for school.
MySQL, MSSQL and Oracle all allow me to send in a default value for their binary column using a hex number. However, MSSQL forces me to send the specific data as a hex number and thus we must CAST it.
PostgreSQL allows me to set a binary column, but with a twist. It demands that the default be in octal and its datatype allows somewhere around a gigabyte’s worth of BBCodes ( PGSQL users, we shut you down to 2040 for your own good! )
Firebird has no decent mechanism for allowing me to shuttle in binary data so I must force my way in. By virtue of triggers and a UDF, we ram in our default values.
SQLite is the most bizarre of them all. They have no mechanism for turning an ASCII code into a ASCII character. Because of this, we have a trigger and a UDF (just like Firebird!) but with a twist! The UDF is defined on the PHP side of things instead of SQL. SQLite also demands that it’s data be encoded before being sent off.
Other notes: - SQLite installs again :D - Firebird nearly installs again :P - Database backup is not screwed up :P
P.S. I hope nothing broke :D |
| 6203 |
View
| Annotate |
|
|
07/23/2006 10:59 PM |
grahamje |
Include a link to the post by default when issuing a warning |
| 6201 |
View
| Annotate |
|
|
07/23/2006 07:43 PM |
grahamje |
Make sure that the language does get passed between all modules |
| 6200 |
View
| Annotate |
|
|
07/23/2006 06:04 PM |
grahamje |
Changes to the language handling during the install |
| 6196 |
View
| Annotate |
|
|
07/20/2006 10:27 PM |
grahamje |
- Missing image in imageset editing
- Sort the list of images
- Enforce default username limits on install
|
| 6177 |
View
| Annotate |
|
|
07/13/2006 02:51 PM |
acydburn |
- renamed the following columns: 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 |
| 6161 |
View
| Annotate |
|
|
07/09/2006 06:23 PM |
acydburn |
- tackle some usability issues - fix bug #3147 - added the lock-images made by SHS` - fixed MSSQL errors (adding the correct ESCAPE sequence) |
| 6156 |
|