Parisian

+Clients
  • Content count

    90
  • Joined

  • Last visited


Parisian's Activity

  1. Parisian added a post in a topic: How to mass unarchive topics with SQL   

    First step is to move posts from the archive database back into the regular one:
    insert into ipb.posts select archive_id,archive_show_edited_by,archive_edit_time, archive_author_id,archive_author_name,archive_show_signature,archive_show_emoticons, archive_ip_address,archive_content_date,NULL,archive_content,archive_queued, archive_topic_id,NULL,archive_is_first,archive_edit_name,MD5(CONCAT(archive_content_date,',',archive_id)), archive_html_mode,archive_edit_reason,archive_bwoptions,0,0,NULL,NULL from ipb_archive.forums_archive_posts Replace ipb and ipb_archive with the correct database names for your installation.
     
    You can restrict this to specific forums only by adding where archive_forum_id= X to the query (including the ones below).
     
     
    The topics table need to be updated to reflect the change:
    update ipb.topics set topic_archive_status=0 Then finally the archive table can be purged to save database space:
    truncate table ipb_archive.forums_archive_posts If you used a forum based restriction then adapt the query like so:
    delete from ipb_archive.forums_archive_posts where archive_forum_id=X Your topics should now be unarchived. If you're using any cache mechanism give those a refresh.
     
     
    I've tested this on my very large boards where the combined posts table is over 9GB. Remember to check your MySQL query time limits so it doesn't get killed during the process.
  2. Parisian added a record in IP.Board   

    XCache variables should not be serialized
    I see that when XCache is enabled variables are being serialized/unseralized which is unnecessary since XCache knows how to handle native PHP variables.
     
    This redundancy should be removed to squeeze extra horsepowers out of the caching layer.
    • 0 replies
    • 0 views
  3. Parisian added a post in a topic: [IPBLounge] Applications System   

    v2.2.1
  4. Parisian added a post in a topic: [IPBLounge] Applications System   

    3.4.4
  5. Parisian added a post in a topic: [IPBLounge] Applications System   

    The page doesn't load after I install and configure the settings, PHP shows these errors:
     
     
    PHP Fatal error:  Call to a member function home() on a non-object in .../community/admin/applications_addon/other/groupjoin/modules_public/view/view.php on line 133
  6. Parisian added a post in a topic: Great Results with Nginx Cache   

    I reported the session problem as a bug but it was ignored. Please help by posting your support there so they take it seriously!
     
    While it's true that session-bound caching seems counter-productive since each guest will get served up a different page, for a high traffic environment where a lot of users log in the session hijacking risk is too much of a problem. 
     
     
    I think that's a very redundant method just to avoid the session mess caused by the IPB developers.
  7. Parisian added a post in a topic: Great Results with Nginx Cache   

    This is an excellent guide but it does have a few problems. Here are my modifications:
     
     
    ipb_args.conf
     
    map $http_user_agent $is_mobile { default 0; ~*android|iphone|windowss+(?:ce|phone) 1; ~*symbian|sonyericsson|samsung|lg|blackberry 1; ~*mobile 1; } map $request_uri $is_uri { default 1; ~^/community/(?:forum/|topic/|members/|feedback/|user/|$) 0; } map $http_cookie $is_cookie { default 0; ~member_id 1; ~pass_hash 1; ~mobilebrowser 1; ~guestskinchoice 1; ~language 1; } map $http_cookie $cache_uid { default nil; ~session_id=(?<session_id>[[:graph:]]+) $session_id; }  
     
    site.conf (just the PHP part)
     
    location ~ .php$ { include conf.d/fastcgi_params_php.inc; fastcgi_cache ipb; fastcgi_cache_valid 200 2m; fastcgi_cache_key "$cache_uid@$scheme$request_method$host$request_uri"; fastcgi_cache_use_stale off; fastcgi_no_cache $is_cookie $is_args $is_mobile $is_uri; fastcgi_cache_bypass $is_cookie $is_args $is_mobile $is_uri; fastcgi_ignore_headers Cache-Control Expires Set-Cookie; add_header X-Cache $upstream_cache_status; }  
     
    This creates correctly identifies mobile devices and uses the session token as part of the cache key - the importance of this is that without it, a guest who subsequently logs in can have their login hijacked by the next guest.
  8. Parisian added a post in a topic: IPBoard on GitHub   

    The current system they have is counter-productive to collaboration. I can't see any realistic downsides to migrating their development flow over to GitHub.
  9. Parisian added a post in a topic: 4.0 - use Twitter Bootstrap for the layout   

    I very much doubt IPB developers can create a better framework than Twitter.
     
    The benefit of Twitter Bootstrap is that because it's so popular there is a lot of support for it - many templates already exist that give a unique look and feel plus the design is very intuitive which allows people to make adjustments and modifications very easily. It is a rock solid framework that works brilliantly across all modern web browsers and devices.
  10. Parisian added a record in IP.Board   

    Template hook point in Registration Screen > showAuthorize
    I don't know why this was left out but there should be a template hook point on the successful registration page (i.e. for custom tracking code).
    • 0 replies
    • 0 views
  11. Parisian added a post in a topic: 4.0 - use Twitter Bootstrap for the layout   

    Twitter Bootstrap is quickly becoming the defaco standard for HTML5 design. 4.0 should fully embrace this and only add extra custom CSS where it's totally necessary.
     
    The major advantage here is we can fully customise our layout with straightforward CSS only and not having to make any complicated template edits.
  12. Parisian added a post in a topic: IPBoard on GitHub   

    IPS should seriously consider hosting their code on Github so people can fix all the bugs. I will be more than happy to sign a CLA before I submit code or even have access to the repo, seeing as they might not want to make it public.
     
  13. Parisian added a post in a topic: Switch to Google Chart APIs for graphs   

    Switch to Google Charts for the purchase stats including the registration stats on the Admin CP homepage.
  14. Parisian added a post in a topic: Add "Unanswered" to default sort filter in forum postable settings   

    Yes that is what I said.
  15. Parisian added a post in a topic: Add "Unanswered" to default sort filter in forum postable settings   

    This way certain support/Q&A forums can be configured to hide answered posts (with the "best answer" feature) without locking them or moving those topics to a different archive/answered section.
     
     
    [Originally posted as a bug report ]