Mike09 Posted May 13, 2009 Share Posted May 13, 2009 Run this SQL You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Now create a file called review.php and put this inside You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Now open stafflist.php and find all the You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Replace with You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Now find all the You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. replace with You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. In cron_day.php add You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Now create a file called staff_review.php and put this inside You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. in smenu.php add somewhere in the user section You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. and DONE! any issues post below. Quote Link to comment Share on other sites More sharing options...
Mike09 Posted May 13, 2009 Author Share Posted May 13, 2009 Re: [mccodes V2] Review staff. Sorry the SQL is You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Quote Link to comment Share on other sites More sharing options...
CrazyT Posted May 13, 2009 Share Posted May 13, 2009 Re: [mccodes V2] Review staff. Now create a file called review.php and put this inside Why is the code below that selecting from like 15+ tables there is no need select the stuff you need from a table. Eg. (`userid`, `username`). Also you have a error in the other file ;) Quote Link to comment Share on other sites More sharing options...
Zero-Affect Posted May 13, 2009 Share Posted May 13, 2009 Re: [mccodes V2] Review staff. i didn't look at the code fully, first off nice try. secondly *: from a quick glance your pulling 6 full sql Databases in one go in the review.php two solutions to how you came upon this. one: you stole the sql from another file for example HOF two: your learning left join but not implying the right quality of coding, maybe too long looking at Dabs's code and not code provided by actual non-lazy coders on this forum. I personally dislike you Yubi but your trying so ill give constructive criticism Quote Link to comment Share on other sites More sharing options...
Lithium Posted May 13, 2009 Share Posted May 13, 2009 Re: [mccodes V2] Review staff. i didn't look at the code fully, first off nice try. secondly *: from a quick glance your pulling 6 full sql Databases in one go in the review.php two solutions to how you came upon this. one: you stole the sql from another file for example HOF two: your learning left join but not implying the right quality of coding, maybe too long looking at Dabs's code and not code provided by actual non-lazy coders on this forum. I personally dislike you Yubi but your trying so ill give constructive criticism Lol, "i need to be mean only to be kind" ;) Quote Link to comment Share on other sites More sharing options...
Zero-Affect Posted May 13, 2009 Share Posted May 13, 2009 Re: [mccodes V2] Review staff. Yeah and i believe it's Cruel to be kind Quote Link to comment Share on other sites More sharing options...
Mike09 Posted May 13, 2009 Author Share Posted May 13, 2009 Re: [mccodes V2] Review staff. Yeah i took the select * from the viewuser :| lol i should of just done it my self my bad :| and thanks zero :) Quote Link to comment Share on other sites More sharing options...
Mike09 Posted May 13, 2009 Author Share Posted May 13, 2009 Re: [mccodes V2] Review staff. Here is the fixed and secured version thanks to MTG. You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Quote Link to comment Share on other sites More sharing options...
MyGunWars Posted May 14, 2009 Share Posted May 14, 2009 Re: [mccodes V2] Review staff. SQLS For This MOD: You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. review.php FIXED: You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. staff_review.php FIXED: You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Add This In Your smenu.php FIXED: You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Add To cron_day.php: You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Open stafflist.php Find: You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Add After: You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Then Find: You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Add After: You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. All FIXED But Good Job Yubi09 Quote Link to comment Share on other sites More sharing options...
D T K Posted May 14, 2009 Share Posted May 14, 2009 Re: [mccodes V2] Review staff. CREATE TABLE IF NOT EXISTS `review` ( `id` int(11) NOT NULL auto_increment, `user` int (11) NOT NULL default 0 `review` int(11) NOT NULL default '1', `reason` varchar(266) NOT NULL default 'None', `time` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Quote Link to comment Share on other sites More sharing options...
MyGunWars Posted May 14, 2009 Share Posted May 14, 2009 Re: [mccodes V2] Review staff. I Posted The Mod Above All Fixed And Working TESTED It On My Site Works 100% Enjoy! Quote Link to comment Share on other sites More sharing options...
Zero-Affect Posted May 14, 2009 Share Posted May 14, 2009 Re: [mccodes V2] Review staff. Old code: You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. New Code: You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Not tested I don't believe the people who had comments edited and looked at this post never realised that it's pulling 6 full tables yet only needs 3 columns from a single table. Sometimes you guys really do worry me. and don't even get me started on auto_increment... Quote Link to comment Share on other sites More sharing options...
Mike09 Posted May 14, 2009 Author Share Posted May 14, 2009 Re: [mccodes V2] Review staff. Thanks zero and MYGUNWARS im still learning so every tip helps. Quote Link to comment Share on other sites More sharing options...
MyGunWars Posted May 14, 2009 Share Posted May 14, 2009 Re: [mccodes V2] Review staff. Any Time Yubi09 Im Still Learning As Well! :-D Quote Link to comment Share on other sites More sharing options...
Zero-Affect Posted May 14, 2009 Share Posted May 14, 2009 Re: [mccodes V2] Review staff. I'm always learning, never stops I may wanna add you will need to remove: You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. from the code due to this forum not liking my style of coding lol and switching double spaces into html special characters. Simple to do open in notepad press CTRL + H add in the top text box and nothing in the bottom then press replace all. Quote Link to comment Share on other sites More sharing options...
HITMAN 17 Posted July 13, 2009 Share Posted July 13, 2009 Re: [mccodes V2] Review staff. correct sql You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Quote Link to comment Share on other sites More sharing options...
HITMAN 17 Posted July 13, 2009 Share Posted July 13, 2009 Re: [mccodes V2] Review staff. QUERY ERROR: Unknown column 'u.userid' in 'where clause' Query was SELECT `user_level`, `username`, `userid` FROM `users` WHERE (u.userid = 13) Quote Link to comment Share on other sites More sharing options...
DeaTH_RideR Posted December 14, 2010 Share Posted December 14, 2010 lol this thread is an old thread. can somebody help me ? i keep getting Invalid use of file idk why. i would love for someone to tell me why . this is what it shows in the address bar if it helps no error http://bla.net/review.php?review={$r[ Quote Link to comment Share on other sites More sharing options...
DeaTH_RideR Posted December 14, 2010 Share Posted December 14, 2010 err it was the way my stafflist.php was coded and i didnt add the link right Quote Link to comment Share on other sites More sharing options...
Reecey12345 Posted February 24, 2014 Share Posted February 24, 2014 Sorry for the bump, but any idea when i put this in my staff list it all goes blank? Yes i have done it correctly i think, but when i remove the Review part out again my stafflist works? <td>$on</td><td><a href="http://review.php?review={$r[" target="_blank">Review</a></td> Quote Link to comment Share on other sites More sharing options...
Guest Posted February 24, 2014 Share Posted February 24, 2014 Sorry for the bump, but any idea when i put this in my staff list it all goes blank? Yes i have done it correctly i think, but when i remove the Review part out again my stafflist works? <td>$on</td><td><a href="http://review.php?review={$r[" target="_blank">Review</a></td> The $r[] is totally wrong. And your missing a } Quote Link to comment Share on other sites More sharing options...
Dave Posted February 24, 2014 Share Posted February 24, 2014 The $r[] is totally wrong. And your missing a } In more helpful terms, try this You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Quote Link to comment Share on other sites More sharing options...
Reecey12345 Posted February 24, 2014 Share Posted February 24, 2014 Still the page remains blank Quote Link to comment Share on other sites More sharing options...
Guest Posted February 24, 2014 Share Posted February 24, 2014 Still the page remains blank Turn on errors Quote Link to comment Share on other sites More sharing options...
Reecey12345 Posted February 24, 2014 Share Posted February 24, 2014 How do i do that D: Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.