phpBBHacks.com - Music Search Song (Music Online Hack) Fix
phpBBHacks.com, the place for phpBB users
StatsForums Home   RegisterRegister   ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in
FAQFAQ   SearchSearch   MemberlistMemberlist   TutorialsTutorials   ContactContact Us
Add Us:     MySpace     Facebook     StumbleUpon
Username:    Password:
Remember Me?    
Music Search Song (Music Online Hack) Fix
BlinkList
del.icio.us
Furl
linkaGoGo
reddit
Simpy
Mister Wong
Yahoo! My Web

Post new topic   Reply to topic    phpBBHacks.com Support Forums Forum Index -> phpBB 2 Hack Development
 See a User Guidelines violation? Please contact us.
Author Message

OryNider
New User

Joined: 11 Apr 2007
Posts: 4
Location: Arad, Romānia

PostPosted: April 16th 2007, 8:50 pm    Post subject: Music Search Song (Music Online Hack) Fix Reply with quote

This fixes are for:
Code:

$Id: music_list.php,v 2.0 2004/06/14 23:52:23 cfmanager Exp $


Music search is not working anymore on some mysql 5.x servers.

Open music_list.php

Find:
Code:
   // --------------------------------
   // Do query now!
   // --------------------------------


Add Beafore:
Code:
   if ( !isset($soungs_per_page) || ($soungs_per_page == 0))
   {
      $soungs_per_page = 20;
   }

   if (isset ($_GET['start']))
   {
      $start = intval($_GET['start']);
   }
   elseif (isset ($_POST['start']))
   {
      $start = intval($_POST['start']);
   }
   else
   {
      $start = 0;
   }

   $limit_sql = ($start == 0) ? $soungs_per_page : $start . ',' . $soungs_per_page;


Find:

Code:
LIMIT -1";


Replace with (in all 3 places):

Code:
LIMIT ".$limit_sql."";


This is a second fix to search if you do not know just one or more words from song title:

Open music_list.php

Find:
Code:

WHERE s.song_title LIKE '" . str_replace("\'", "''", $search) . "'


Replace with:
Code:

WHERE s.song_title LIKE '%" . str_replace("\'", "''", $search) . "%'


Save/Close all files.
_________________
mxBB Development Team
Back to top
View user's profile Send private message Visit poster's website Yahoo Messenger

mene
Not So New User

Joined: 29 Apr 2007
Posts: 53
Location: Uk

PostPosted: May 7th 2007, 6:30 pm    Post subject: Reply with quote

ok this is great info and works fine now on mine after the headache I had trying to sort this out, BUT....

it works on song title, but not when I try searching singer or poster ??

much appreciate and more fix's
Back to top
View user's profile Send private message Visit poster's website

mene
Not So New User

Joined: 29 Apr 2007
Posts: 53
Location: Uk

PostPosted: May 8th 2007, 4:31 am    Post subject: Reply with quote

Blush ack! I must of been tired last night, I didnt see that bit you put in brackets lol

Replace with (in all 3 places):

Blush it now works thanks
Back to top
View user's profile Send private message Visit poster's website

femu
New User

Joined: 07 Jul 2007
Posts: 5

PostPosted: March 31st 2008, 5:17 am    Post subject: Reply with quote

And when you change:

Code:

WHERE s.song_title LIKE '%" . str_replace("\'", "''", $search) . "%'


with

Code:

WHERE lower(s.media_title) LIKE '%" . strtolower($search) . "%'


you don not even need to take care of upper/lower case writing
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    phpBBHacks.com Support Forums Forum Index -> phpBB 2 Hack Development All times are GMT - 6 Hours
Page 1 of 1
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Links: Big Message Boards - Free JavaScript - phpBB2 - phpbb styles - Suporte phpBB - phpBB.it - phpBB Česky - phpBB Turkiye - phpBBArabia.com - phpBB-fr.com - Romanian phpBB online community - phpBB-TW.net - phpBBservice.nl - phpBB Brasil

Network: iFroggy Network Blog - iFroggy Hosting - SportsForums.net - KarateForums.com - YanksBlog.com - PhotoshopForums.com - DeveloperCube - Managing Online Forums - ManagingCommunities.com - CommunityAdmins.com - DrGregHouse.com - Bad Boy Blog - BadBoyForums.com - SodaRatings.com - Patrick O'Keefe

< Advertising - Contact Us - Staff - User Guidelines >

Copyright © 2001-2008. iFroggy Network, phpBBHacks.com. All Rights Reserved. Privacy Policy. We Support phpBBHacks.com (of course!).
Powered by phpBB © phpBB Group. phpBB SEO. Hosted by 100MegsWebHosting. We are in no way affiliated with the phpBB Group. phpBB is copyright to the phpBB Group.