| 9064 |
View
| Annotate |
|
|
11/13/2008 02:04 PM |
toonarmy |
been a while :( ... merge in r8997, r8998, r8999, r9000, r9001, r9002, r9003, r9004, r9005, r9007, r9008, r9009, r9010, r9011, r9012, r9013, r9014, r9015, r9022, r9023, r9029, r9030, r9034, r9048, r9049, r9054, r9056 |
| 8980 |
View
| Annotate |
|
|
10/08/2008 02:51 PM |
acydburn |
Merge revisions: r8974, r8975, r8976, r8977, r8978, r8979 |
| 8865 |
View
| Annotate |
|
|
09/17/2008 04:59 PM |
acydburn |
Preserve alpha transparency for created thumbnails. (Bug #16575) |
| 8816 |
View
| Annotate |
|
|
09/04/2008 04:04 PM |
acydburn |
- queue trigger feature - queued posts do not affect user_posts - show links to MCP + queued posts in ucp and acp |
| 8781 |
View
| Annotate |
|
|
08/22/2008 03:32 PM |
acydburn |
Merge chmod changes into trunk |
| 8776 |
View
| Annotate |
|
|
08/21/2008 05:50 PM |
Kellanved |
merge |
| 8696 |
View
| Annotate |
|
|
07/28/2008 03:37 PM |
acydburn |
marge |
| 8672 |
View
| Annotate |
|
|
06/23/2008 08:22 PM |
acydburn |
merge? merge. |
| 8632 |
View
| Annotate |
|
|
06/09/2008 02:37 PM |
Kellanved |
#23945 |
| 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. |
| 8571 |
View
| Annotate |
|
|
05/28/2008 03:05 PM |
Kellanved |
Merging mime and referer checks into the Trunk |
| 8526 |
View
| Annotate |
|
|
04/21/2008 05:10 PM |
acydburn |
merge again, revisions 8516 to 8525 |
| 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 |
| 8363 |
View
| Annotate |
|
|
02/01/2008 02:15 PM |
Kellanved |
cross-ci 8362; #15120, #16029 |
| 8356 |
View
| Annotate |
|
|
01/30/2008 10:48 PM |
acydburn |
Merging revisions #r8352, #r8353, #r8354 and #r8355 |
| 8351 |
View
| Annotate |
|
|
01/30/2008 05:14 PM |
acydburn |
merge with revision #r8350 |
| 8314 |
View
| Annotate |
|
|
01/07/2008 08:29 PM |
acydburn |
grr |
| 8310 |
View
| Annotate |
|
|
01/06/2008 06:00 PM |
acydburn |
- Do not split topic list for topics being promoted to announcements after been moved to another forum (Bug #18635) - Allow editing usernames within database_update on username cleanup (Bug #18415) - Fixing wrong sync() calls if moving all posts by a member in ACP (Bug #18385) - Check entered imagemagick path for trailing slash (Bug #18205) - Use proper title on index for new/unread posts (Bug #13101) – patch provided by Pyramide - Allow calls to $user->set_cookie() define no cookie time for setting session cookies (Bug #18025) |
| 8295 |
View
| Annotate |
|
|
01/03/2008 06:00 PM |
davidmj |
oh boy… - Migrate code base to PHP 5.1+ |
| 8253 |
View
| Annotate |
|
|
11/27/2007 04:13 PM |
kellanved |
#15554 #15464 #15384 Yes, there is a lang change. |
| 8251 |
View
| Annotate |
|
|
11/26/2007 06:04 PM |
kellanved |
#15484 |
| 8241 |
View
| Annotate |
|
|
11/17/2007 09:04 PM |
acydburn |
some further fixes - re-introduce grabbing random number from /dev/urandom |
| 8146 |
View
| Annotate |
|
|
10/05/2007 04:30 PM |
acydburn |
dumdidum… sorry. ;) |
| 8122 |
View
| Annotate |
|
|
10/03/2007 05:15 PM |
kellanved |
#14531 |
| 8120 |
View
| Annotate |
|
|
10/03/2007 05:05 PM |
kellanved |
Ok, here comes a big one. Poor updater. Also requires testing.
#i91 #i92 #i93 #i94 #i95 #i96 |
| 8119 |
View
| Annotate |
|
|
10/02/2007 08:29 PM |
acydburn |
#i8 |
| 8115 |
View
| Annotate |
|
|
09/28/2007 01:34 PM |
kellanved |
#14566 |
| 8075 |
View
| Annotate |
|
|
09/02/2007 07:24 PM |
acydburn |
fixing some bugs |
| 8050 |
View
| Annotate |
|
|
08/19/2007 03:40 PM |
naderman |
- BBCode parsing order should ALWAYS be censor_text(), bbcode_secon_pass(), bbcode_nl2br(), smiley_text(), parse_attachments() - using \r on custom bbcodes to allow line breaks [Bug #10758] |
| 8025 |
View
| Annotate |
|
|
08/13/2007 02:14 PM |
acydburn |
Some changes… non-invasive… |
| 8011 |
View
| Annotate |
|
|
08/06/2007 04:41 PM |
acydburn |
two fixes |
| 7946 |
View
| Annotate |
|
|
07/25/2007 06:06 PM |
acydburn |
please have a second look at the change within session.php – we had a few “doubled” keys within the db… |
| 7860 |
View
| Annotate |
|
|
07/10/2007 05:14 PM |
acydburn |
some fixes here and there |
| 7856 |
View
| Annotate |
|
|
07/10/2007 05:14 AM |
davidmj |
#13167 |
| 7832 |
View
| Annotate |
|
|
07/04/2007 04:22 PM |
davidmj |
#12981 |
| 7831 |
View
| Annotate |
|
|
07/04/2007 02:38 PM |
davidmj |
#12947 – thanks to APTX for his partial patch and Highway_of_Life and iWisdom for testing |
| 7830 |
View
| Annotate |
|
|
07/03/2007 05:36 PM |
acydburn |
let’s see if i can break something. :o |
| 7800 |
View
| Annotate |
|
|
06/26/2007 04:27 PM |
kellanved |
Minor fixes #12699 |
| 7744 |
View
| Annotate |
|
|
06/10/2007 03:42 PM |
kellanved |
#12287 #12219
A little clean-up in the installer (thanks ToonArmy) |
| 7646 |
View
| Annotate |
|
|
05/19/2007 06:40 PM |
acydburn |
we included a check for getimagesize() existance… now we again can suppress notices while running this function. |
| 7642 |
View
| Annotate |
|
|
05/19/2007 02:04 PM |
acydburn |
oh my god – what did he do? Adding attachment display to post/topic review, queue, reports, post details, mcp topic view… fixing other tiny things along the line. |
| 7616 |
View
| Annotate |
|
|
05/17/2007 03:23 PM |
acydburn |
#11074 – only process and check (as well as display) images if the category also matches. ;) |
| 7615 |
View
| Annotate |
|
|
05/17/2007 03:01 PM |
acydburn |
#11046 – properly show load button. |
| 7614 |
View
| Annotate |
|
|
05/17/2007 01:59 PM |
acydburn |
adjust smilies. Also allow adding more codes to existing smilies… no one noticed this before. :/ |
| 7589 |
View
| Annotate |
|
|
05/15/2007 05:52 PM |
acydburn |
#10942 + cron image into tags |
| 7547 |
View
| Annotate |
|
|
05/12/2007 03:20 PM |
acydburn |
informational change for orphaned attachments – they only list already uploaded files not assigned to posts (orphaned attachments). add index.htm files to cache and files directory. |
| 7537 |
View
| Annotate |
|
|
05/12/2007 01:29 AM |
davidmj |
#10781 Thanks APTX |
| 7522 |
View
| Annotate |
|
|
05/09/2007 11:46 PM |
davidmj |
sync the forums too |
| 7521 |
View
| Annotate |
|
|
05/09/2007 11:42 PM |
acydburn |
davids “update topics last post information on approval -> disapproval change” fix. :P Fixed start transaction for posting. |
| 7519 |
View
| Annotate |
|
|
05/09/2007 09:06 PM |
acydburn |
fix for editing unapproved posts by a person not on moderation queue (do not switch state) |
| 7518 |
View
| Annotate |
|
|
05/09/2007 08:43 PM |
davidmj |
remove useless variable that caused some undefined errors |
| 7514 |
View
| Annotate |
|
|
05/09/2007 06:12 PM |
acydburn |
minor fix also set load_tplcompile to 0 by default now it is quite intensive with the default settings/style. |
| 7511 |
View
| Annotate |
|
|
05/09/2007 02:56 PM |
davidmj |
some bug fixes… |
| 7510 |
View
| Annotate |
|
|
05/09/2007 01:14 PM |
kellanved |
#10679 |
| 7509 |
View
| Annotate |
|
|
05/09/2007 12:00 PM |
kellanved |
#10669 |
| 7508 |
View
| Annotate |
|
|
05/09/2007 06:34 AM |
davidmj |
bah! |
| 7507 |
View
| Annotate |
|
|
05/09/2007 04:19 AM |
davidmj |
this is pretty neat. - We save a nasty query from every new topic and reply. We can do this because we are in a transaction, asking the database what is the newest info would just return the post_id we just inserted - editting is now far cheaper if it turns out the newest post has been editted. - switch the globality of a topic (making it global/unglobal) is now cheaper by a lot. If it turns out that we have changed the universe in any important way we can easily fix things much faster than before. |
| 7503 |
View
| Annotate |
|
|
05/07/2007 11:21 PM |
acydburn |
#10617 |
| 7494 |
View
| Annotate |
|
|
05/07/2007 04:35 AM |
shs |
Regression bugs from: r1=1.233&r2=1.234">http://phpbb.cvs.sourceforge.net/phpbb/phpBB2/includes/functions_posting.php?r1=1.233&r2=1.234
Anchor fragments should be ”#p12345”, not “p=12345” (which AFAIK ends up working the same as ”#p”) |
| 7491 |
View
| Annotate |
|
|
05/06/2007 11:02 PM |
acydburn |
Ok, try to fix the “re-approval on edit” bugs. Also added make_clickable to log entries as well as logging moderator edits. |
| 7469 |
View
| Annotate |
|
|
05/05/2007 12:22 PM |
acydburn |
Better support for nested transactions… |
| 7460 |
View
| Annotate |
|
|
05/04/2007 06:37 PM |
kellanved |
Just stubmled over this. |
| 7451 |
View
| Annotate |
|
|
05/02/2007 06:19 PM |
acydburn |
fixes for search button in header – #10389, #10225, #9548 added missing colour swatch to prosilver – #8657 language changes – #10387, #10375, #10373, #10353, #10279 line-height for font size (still not ideal) – #10317 Search load setting checked in sessions.php along with limit_load and also reset if not possible to determine load – #10383 Fix editing issues – #9660 |
| 7441 |
View
| Annotate |
|
|
04/30/2007 06:18 PM |
davidmj |
#10295 |
| 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
|
| 7425 |
View
| Annotate |
|
|
04/29/2007 04:16 AM |
davidmj |
#10251 |
| 7355 |
View
| Annotate |
|
|
04/15/2007 12:59 PM |
naderman |
- m_warn is no longer a local moderation permission - magic urls should properly use html entities - speed up posting on big boards, MAX query can be simplified a lot in certain cases - user IP list should be labelled with “Other users” [Bug #9707] |
| 7267 |
View
| Annotate |
|
|
04/02/2007 06:05 PM |
acydburn |
#5163 |
| 7242 |
View
| Annotate |
|
|
03/30/2007 04:24 PM |
acydburn |
other fixes… |
| 7191 |
View
| Annotate |
|
|
03/14/2007 10:40 PM |
naderman |
- sync now correctly handles approved posts in unapproved topics (last_post info) |
| 7152 |
View
| Annotate |
|
|
03/08/2007 06:11 PM |
davidmj |
|
| 7150 |
View
| Annotate |
|
|
03/08/2007 04:49 PM |
acydburn |
again… some more fixes. |
| 7114 |
View
| Annotate |
|
|
03/03/2007 06:41 PM |
acydburn |
Fixing the following bugs: #8444 (language dependent buttons no longer include the dimensions to allow bigger/smaller translated images) #8414 #8396 #8388 #8216
thanks to bartvb and kellanved for providing possible fixes… |
| 7103 |
View
| Annotate |
|
|
03/01/2007 10:43 PM |
davidmj |
- small issue |
| 7054 |
View
| Annotate |
|
|
02/24/2007 01:31 PM |
acydburn |
trying to fix some bugs… |
| 6987 |
View
| Annotate |
|
|
02/14/2007 12:22 AM |
davidmj |
- might as well… |
| 6986 |
View
| Annotate |
|
|
02/14/2007 12:20 AM |
davidmj |
-Topic review is fast :D #7894 |
| 6977 |
View
| Annotate |
|
|
02/09/2007 03:31 PM |
acydburn |
those were missing |
| 6973 |
View
| Annotate |
|
|
02/07/2007 05:32 PM |
acydburn |
adjust text for getting image dimensions as well as not suppressing warnings for getimagesize() |
| 6930 |
View
| Annotate |
|
|
01/26/2007 05:09 PM |
acydburn |
- fix some oddities (doubled spaces for example) - changed the way make_forum_select() is returning the forum list – now including skipped forums but being disabled. This should make identifying the correct forum much more easier. - Changed some permission namings based on suggestions by the community - Tried to comply to the permission field ordering within the language files while displaying permission sets. Hopefully it’s worth the additional processing time. - Disable submit buttons after clicking for installation and conversions. |
| 6915 |
View
| Annotate |
|
|
01/21/2007 07:33 PM |
acydburn |
fixing some bugs, most being submitted grammatical/spelling errors. |
| 6880 |
View
| Annotate |
|
|
01/11/2007 06:44 AM |
davidmj |
#6772 - some other random things |
| 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 |
| 6816 |
View
| Annotate |
|
|
12/27/2006 06:43 PM |
acydburn |
Unused Code inside function update_forum_data [Bug #6606] Copy permissions protection for groups [Bug #6594] HTML issues in ACP [Bug #6580, #6578] Always send the correct encoding [related to bug #6576] Mass email fixes for first loop iteration [Bug #6570] Extension groups to be allowed in PM’s and/or Posts [Bug #6558] Extension allowance checking clarified (no longer using forum id 0 for private messaging) Using request_var() array method for some variables [Bug #6556] Added confirmation for deletion of ranks/smilies/icons/word censores [Bug #6548, #6530, #6512, #6466] Only show postable forums in dropdown list for moving posts on forum deletion as well as correct re-indexing [Bug #6510, #6476, #6384] Jabber password being password field in jabber settings screen [Bug #6478] user activity language variable if viewing not own profile [Bug #6432] Show moderator group/user-name colour [Bug #6402] Log rank creation/updating/removing [Bug #6398] Update check permission changed from a_ to a_board [Bug #6392] |
| 6787 |
View
| Annotate |
|
|
12/21/2006 11:37 AM |
acydburn |
- some fixes - important bugfix for the mcp and determining allowed ids in general (if global announcements are included) |
| 6770 |
View
| Annotate |
|
|
12/15/2006 03:54 PM |
acydburn |
- fixed bug within the database update script - #6254 - #6242 - #6184 - #6160 - #6020 |
| 6660 |
View
| Annotate |
|
|
11/26/2006 03:55 PM |
acydburn |
- bug fixes for #5618, #5588 and #5584 - remove messenger->reset() calls (they are already performed on sending) |
| 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 |
| 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. |
| 6614 |
View
| Annotate |
|
|
11/19/2006 10:00 PM |
acydburn |
some tiny fixes. |
| 6601 |
View
| Annotate |
|
|
11/18/2006 05:27 PM |
acydburn |
- a handful of mcp fixed, the most important one is the change for check_ids() – it is now supporting ids from more than one forum too, making it possible to use some mcp features as designed initially. We really need to get our moderator team testing the mcp extensively. - fixed some other tiny glitches - if a forum category with subforums get changed to a link type forum give options of what to do with the subforums (#5334) - other bugfixes |
| 6596 |
View
| Annotate |
|
|
11/17/2006 08:40 PM |
acydburn |
fix colour assignment. ;) |
| 6589 |
View
| Annotate |
|
|
11/16/2006 05:51 PM |
acydburn |
ok, change from doing the same logic all over again we call a function to do it for us. Also allow template designers to choose which method to use by just adding a fully compiled username string (profile link + user colour). This commit may introduce problems. |
| 6572 |
View
| Annotate |
|
|
11/12/2006 04:35 PM |
acydburn |
consistant obtain_* functions |
| 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 |
| 6528 |
View
| Annotate |
|
|
10/26/2006 01:27 PM |
dhn2 |
#4696
Quoting from topic review should now work in FF 1.5.0.x.
Note to Nils: We need a utf8_addslashes function. The standard addslashes will not cut it for UTF-8. :) |
| 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 :) |
| 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) |
| 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)... |
| 6414 |
View
| Annotate |
|
|
09/28/2006 05:04 PM |
acydburn |
- added confirmation to removing bbcodes - added optional MX and DNSBL checks - added backtrace (triggering sql error) on error within sql_in_set as well as making sure it is handling an array - let users having f_list access to a forum actually see the forum without a topic list and not displaying an error message – this allows for giving people access to subforums but not the parent forum without the need to add the (sub-)forum to the index. - some additional bugfixes |
| 6411 |
View
| Annotate |
|
|
09/26/2006 09:59 PM |
acydburn |
These changes should let olympus scale a little bit better. i haven’t adjusted the schemas but added the details to create_schema_files – david is able to build them then in line with his changes. :) |
| 6380 |
View
| Annotate |
|
|
09/18/2006 12:02 AM |
naderman |
- no more encoding mixture, say hello to UTF-8 (I’ll add a validation solution for PHP 4.3.3/4 ASAP) [side effect: fixes Bug #3762] - take local server time into consideration for birthday/age calculation - faster active topic search - allow changing active topic time frame [Bug #4150] - reload stylesheet on language change [Bug #4222] |
| 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. ;) |
| 6360 |
View
| Annotate |
|
|
09/08/2006 08:00 PM |
grahamje |
Next phase of last post changes + a few minor bugs
Note: This template variable is available but will not be used by default |
| 6321 |
View
| Annotate |
|
|
08/28/2006 07:20 PM |
naderman |
- birthdays/age in user’s timezone and not server’s local time - parse bbcode in posts with fewer characters than selected maximum on search results page - retrieve search word context in posts which are longer than maximum characters (no raw BBCode anymore) - formatted text is processed in the same order everywhere now: censor_text, replace newlines, bbcode, smileys, attachments, highlighting [including Bug #2048] - highlighting pattern updated to exclude style and script (e.g custom BBCode) [Bug #3856] - fixed a style problem in Opera [Bug #3770] - performance increase for user::img() - slight adjustments to search |
| 6320 |
View
| Annotate |
|
|
08/28/2006 05:50 PM |
acydburn |
- some bugfixes - using E_USER_WARNING if an error occurred within the ACP (sadly not able to use it as a default for trigger_error – it seems to be hardcoded in PHP) |
| 6317 |
View
| Annotate |
|
|
08/25/2006 05:15 PM |
acydburn |
some fixes.
David, could you check the pass_complex expressions? They are: .* PASS_TYPE_ANY (any characters are allowed, no check) [a-zA-Z] PASS_TYPE_CASE (password must contain alphanumerics) [a-zA-Z0-9] PASS_TYPE_ALPHA (password must contain alphanumerics and numbers) [a-zA-Z\W] PASS_TYPE_SYMBOL (password must contain alphanumers, numbers and symbols)
At the moment the pass complexity check is done within validate_password(), but the expressions are wrong. :) |
| 6311 |
View
| Annotate |
|
|
08/22/2006 01:01 PM |
grahamje |
Phase 2 of the changes This should now be complete |
| 6309 |
View
| Annotate |
|
|
08/21/2006 05:58 PM |
grahamje |
Initial batch of colourization changes. This includes: – schema changes for first post and last post – display in viewforum, search and ucp of first post – update of database on posting Still outstanding – display of last post |
| 6299 |
View
| Annotate |
|
|
08/18/2006 10:44 PM |
davidmj |
|
| 6293 |
View
| Annotate |
|
|
08/15/2006 04:13 AM |
davidmj |
chr(0×20 | 0×10) = “0” |
| 6275 |
View
| Annotate |
|
|
08/12/2006 05:10 PM |
acydburn |
bugfixes |
| 6271 |
View
| Annotate |
|
|
08/12/2006 03:14 PM |
acydburn |
sql_in_set changes |
| 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 |
| 6256 |
View
| Annotate |
|
|
08/09/2006 11:03 PM |
acydburn |
- load tracking updates. Need to be tested on a clean installation too – at the moment only tiny quirks are noticed at area51. - reported bugs fixed |
| 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) - |
| 6232 |
View
| Annotate |
|
|
08/03/2006 05:23 PM |
acydburn |
- custom profile field fixed - 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. |
| 6227 |
View
| Annotate |
|
|
08/02/2006 11:36 AM |
naderman |
fixing a typo ;-) |
| 6224 |
View
| Annotate |
|
|
08/01/2006 05:29 PM |
acydburn |
- fixing some bugs - shortening some db columns to meet the requirements - correctly increase/decrease user post counts - fix the topic title length bug(s) |
| 6210 |
View
| Annotate |
|
|
07/25/2006 01:58 PM |
davidmj |
oops :P |
| 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 |
| 6198 |
View
| Annotate |
|
|
07/20/2006 11:45 PM |
acydburn |
- some bugfixes - set ip_check to A.B.C. by default - display postings in other encodings by default and present link to force the encoding as usual. |
| 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 |
| 6165 |
View
| Annotate |
|
|
07/10/2006 05:55 PM |
acydburn |
fix some bugs… again. :) |
| 6153 |
View
| Annotate |
|
|
07/07/2006 10:38 PM |
naderman |
- fix a stupid bug in style.php - and we’d also like the post encoding :D |
| 6152 |
View
| Annotate |
|
|
07/07/2006 08:43 PM |
naderman |
- fixed a parse error (oops) - pass forum_ids to search indexing functions - fixed a bug in fulltext_native’s cache destroying |
| 6135 |
View
| Annotate |
|