Ichirō

+Clients
  • Content count

    620
  • Joined

  • Last visited

6 Followers

About Ichirō

  • Rank
    Community Regular

IPS Marketplace

  • Resources Contributor
    Total file submissions: 1
  1. ​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. 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. 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. 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. 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. 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. Even with a Terms Of Use you will still get this problem trust me.
  9. Thank very much for taking the time out.
  10. Did you write up a ' How to' for that? I see you said you were going too.
  11. //// 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. Same here also: " alt="834f048fae3177fed100e6a3affd8ef4.png">
  13. You can go ahead and use 3.4.6 now and upgrade to 4.0 later, the choice is entirely yours of course.