Ichirō

+Clients
  • Content count

    620
  • Joined

  • Last visited

6 Followers

About Ichirō

  • Rank
    Community Regular

IPS Marketplace

  • Resources Contributor
    Total file submissions: 1
  1. Subscriptions Manager

    ​Hi Pete, really busy time for you right now I guess with the amount of apps you have to now rewrite for IPB 4, however would it be cheeky to ask that this app gets moved up your 'To-Do' list, as its how a lot of IPB users montize their forums? With a lot of people now updating to IPB4 I can see this one app will hold a lot of people back. /
  2. Facebook Slide FanPage

    Such as have the slide disappear once it has been liked? There's really no need for it to be there once its been liked.
  3. Another skin based on the TTG rip... awesome.
  4. (M34) Videos System

    Did you manage to fix this as I am now also getting sql errors with this app that are breaking the database. ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Date: Tue, 22 Apr 2014 07:41:35 +0000 Error: 1054 - Unknown column '66' in 'order clause' IP Address: removed - /videos/list-all/?listview=1&sort_by=66&sort_order=asc ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- mySQL query error: SELECT v.*,f.f_vid, f.f_mid,m.member_id, m.member_group_id,xxx.* FROM ibf_videos v LEFT JOIN ibf_videos_favorites f ON ( f.f_vid=v.tid ) LEFT JOIN ibf_members m ON ( v.author_id=m.member_id ) LEFT JOIN ibf_core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('videos',';','videos',';',v.tid)) ) WHERE v.status=0 GROUP BY v.tid ORDER BY 66 asc LIMIT 0,20 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------. | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | admin/applications_addon/other/videos/modules_public/display/index.php| [public_videos_display_index].catView | 41 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/sources/base/ipsController.php | [public_videos_display_index].doExecute | 306 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Date: Tue, 22 Apr 2014 08:35:50 +0000 Error: 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"; waitfor delay '0:0:4' -- LIMIT 20,20' at line 3 IP Address: removed ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- Date: Tue, 22 Apr 2014 06:50:23 +0000 Error: 0 - IP Address: removed - /videos/list-all/?listview=1&sort_by=video_rating'%2b(select%201%20from%20(select%20sleep(4))A)%2b'&sort_order=desc&st=40 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- SUB SELECT query joins are not allowed. Add ipsRegistry::DB()->allow_sub_select=1; before any query construct to allow them .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------. | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | admin/applications_addon/other/videos/modules_public/display/index.php| [public_videos_display_index].catView | 41 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/sources/base/ipsController.php | [public_videos_display_index].doExecute | 306 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' - /videos/list-all/?sort_by=date&sort_order=desc%22;%20waitfor%20delay%20'0:0:4'%20--%20&st=20 ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- mySQL query error: SELECT v.*,f.f_vid, f.f_mid,m.member_id, m.member_group_id,xxx.* FROM ibf_videos v LEFT JOIN ibf_videos_favorites f ON ( f.f_vid=v.tid ) LEFT JOIN ibf_members m ON ( v.author_id=m.member_id ) LEFT JOIN ibf_core_tags_cache xxx ON ( xxx.tag_cache_key=MD5(CONCAT('videos',';','videos',';',v.tid)) ) WHERE v.status=0 GROUP BY v.tid ORDER BY date desc"; waitfor delay '0:0:4' -- LIMIT 20,20 .--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------. | File | Function | Line No. | |----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------| | admin/applications_addon/other/videos/modules_public/display/index.php| [public_videos_display_index].catView | 41 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------' | admin/sources/base/ipsController.php | [public_videos_display_index].doExecute | 306 | '----------------------------------------------------------------------------+-------------------------------------------------------------------------------+-------------------'
  5. Heartbleed and IPB

    Just to clarify for anyone unsure, to check the setting you will find it here: Admin cp > System Settings > System > Security and Privacy > Security [General - High]
  6. 4.0 - Follow System

    Speaking of overheads in your blog, is the way notifications dealt with on IPB 4.0 so that large boards do not have trouble submitting posts due to the way notifications are handled on IPB 3.X ? On IPB 3.X the notifications get sent before the new post is submitted, so on large forums can result in large waiting times between pressing the submit button and actually seeing the post send.
  7. Subscriptions Manager

    I had a user agreement on my subscriptions and made it so the user had to click a checkbox to agree to the terms and still Paypal will rule in favour of the buyer. Paypal are useless anyway, if you have ever had to call a representitive of theirs you would know what i mean. Digital goods / virtual items = expect clawbacks.
  8. Subscriptions Manager

    Even with a Terms Of Use you will still get this problem trust me.
  9. Google Webmaster markup errors

    Thank very much for taking the time out.
  10. Google Webmaster markup errors

    Did you write up a ' How to' for that? I see you said you were going too.
  11. Google Webmaster markup errors

    //// With that having been said I would still prefer to not have the errors in Webmasters tools, so if we can find the templates need to be edited and post them here that would be great. Also any pointers from the IPB Team would be appreciated.
  12. Google Webmaster markup errors

    Same here also: " alt="834f048fae3177fed100e6a3affd8ef4.png">
  13. Wait new version 4 or not ?

    You can go ahead and use 3.4.6 now and upgrade to 4.0 later, the choice is entirely yours of course.