Hi JoshPet,<br />Gardener said this one replaced the ratings mod from user right?<br /><br />Could you provide the mod which keep both?<br />

I skipped it, Thanks for the help!

Josh,<br /><br />Is it possible to run a query to default EVERYONE back to a zero status?<br /><br />Thanks,<br /><br />BWilliams

This should work....<br /><br />UPDATE w3t_Users<br />SET U_RatingImage = ''<br /><br />

[]JoshPet said:<br />This should work....<br /><br />UPDATE w3t_Users<br />SET U_RatingImage = ''<br /><br /> [/]<br />Worked PERFECTLY, thanks <img src="/forum/images/graemlins/smile.gif" alt="" /><br /><br /><br />Now, how can I add the rating to show on the showmembers.php page ?

josh,<br /><br />this is great, however i would want to disable the classic rating that comes with the software, can I do that?. So I would be the only one who gives rating to the user rather than the users themselves

Admin -> Edit Config Settings -> "Do you want to enable the User Rating System?" = "No"<br /><br /><img src="/forum/images/graemlins/smile.gif" alt="" />

LOL, thanks dude, maybe I should keep my mouth shut, to avoid the embarresment <img src="/forum/images/graemlins/smile.gif" alt="" />

Instructions updated for 6.4

Thanks - reposted here for 6.4

jsut got an error with this one. on showflat.php got a parse error on line 1007<br /><br /> // Now we can show the post<br /> $postrow[$i]['Number'] = $Number;<br /> } <-- this is line 1007<br /> $postrowsize = $i;<br /><br /> $dbh -> finish_sth($sth);<br /><br />what should i do. i didnt even touch that line when i edited the code. can someone help! it only happens when i click on a actual thread link: this is the code: Parse error: parse error in /usr/home/adultwebmasterhangout/ubbthreads/showflat.php on line 1007

o i am using 6.2.3

A parse error usually means that you've missed something. Usually it's a { or } missing somewhere.<br /><br />Double check that you copied and pasted everthing needed and didn't miss any lines.

Josh it says to relace this line<br /> <br /><br />when mine actually looks like this<br /> <br /><br /><br />and I am also getting this now<br /><br />SQL ERROR: Unable to do_query: // SELECT t1.B_Number,t2.U_Username,t1.B_Posted,t1.B_IP,t1.B_Subject,t1.B_Body,t1.B_File,t1.B_Status,t1.B_Approved,t2.U_Picture,t1.B_Reged,t2.U_Title,t2.U_Color,t1.B_Icon,t1.B_Poll,t1.B_Parent,t2.U_Status,t2.U_Signature,t1.B_LastEdit,t1.B_LastEditBy,t2.U_Location,t2.U_TotalPosts,t2.U_Registered,t2.U_Rating,t2.U_Rates,t2.U_RealRating,t2.U_PicWidth,t2.U_PicHeight,t2.U_Number,t1.B_FileCounter,t1.B_AnonName,t1.B_ParentUser SELECT t1.B_Number,t2.U_Username,t1.B_Posted,t1.B_IP,t1.B_Subject,t1.B_Body,t1.B_File,t1.B_Status,t1.B_Approved,t2.U_Picture,t1.B_Reged,t2.U_Title,t2.U_Color,t1.B_Icon,t1.B_Poll,t1.B_Parent,t2.U_Status,t2.U_Signature,t1.B_LastEdit,t1.B_LastEditBy,t2.U_Location,t2.U_TotalPosts,t2.U_Registered,t2.U_RatingImage,t2.U_PicWidth,t2.U_PicHeight,t2.U_Number,t1.B_FileCounter,t1.B_AnonName,t1.B_ParentUser FROM w3t_Posts AS t1, w3t_Users AS t2 WHERE t1.B_Main = 62335 AND t1.B_PosterId = t2.U_Number ORDER BY B_Number LIMIT 30 <br />You have an error in your SQL syntax near '// SELECT t1.B_Number,t2.U_Username,t1.B_Posted,t1.B_IP,t1.B_Subject,t1.B_Bo' at line 2

Ok I got rid of the SQL error,apparently it did not like the way I commented out the original line and I added this to the end of your line <br /> <br />t1.B_ParentUser <br /> <br />My new question is does this hack take away the function for users to rate each other because now Everyones stars are missing except those that I have given out. <br /> <br />Edit-Ok I have read this thread now in its entirety and see this question was raised before by Gardener.Can some one explain to me how to get the user ratings functional with this mod? I am using 6.3 currently

Yes, this one does. The latest version (the 6.4 version) allows you to have either.<br /><br />http://www.ubbdev.com/forum/showflat.php/Number/104956

<img src="http://www.ubbdev.com/forum/images/graemlins/frown.gif" alt="" /> I guess I am going to have to upgrade sooner than I planned<br /><br />FYI t1.B_ParentUser must be from a mod that I installed that added the "in reply to" function. Its not working at the moment so I assume I must have accidentily edited some of it out when installing the user ratings mod *sigh*