oxidati0n Posted July 10, 2009 Posted July 10, 2009 This is an optimized/revamped version (revised from BlackVengeance's Mod). I just updated his modification by highly optimizing and cleaning it out, but original code credit goes to him. :) This is my first mod in 3 years for MCCode, so give me a break if it doesn't work :P Execute MySQL Query You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Replace events.php with this You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. Quote
Haunted Dawg Posted July 10, 2009 Posted July 10, 2009 Re: [V2] Saved Events Optimized? No definatly, for sure it is VERY optimized... *hint* * *hint* Quote
oxidati0n Posted July 10, 2009 Author Posted July 10, 2009 Re: [V2] Saved Events Optimized? No definatly, for sure it is VERY optimized... *hint* * *hint* LOL. Here we go, another "coder" who thinks he's better than anyone else. It's slightly optimized, by using "union" queries and not creating a whole new table dedicated to a really small modification. I am limited to how much I can optimize it, as the engine doesn't have much options to it's optimization - it would be useless for me to even put that in. Quote
CrazyT Posted July 11, 2009 Posted July 11, 2009 Re: [V2] Saved Events Optimized? No definatly, for sure it is VERY optimized... *hint* * *hint* LOL. Here we go, another "coder" who thinks he's better than anyone else. It's slightly optimized, by using "union" queries and not creating a whole new table dedicated to a really small modification. I am limited to how much I can optimize it, as the engine doesn't have much options to it's optimization - it would be useless for me to even put that in. LOL!! Quote
Eternal Posted July 11, 2009 Posted July 11, 2009 Re: [V2] Saved Events Optimized? No definatly, for sure it is VERY optimized... *hint* * *hint* LOL. Here we go, another "coder" who thinks he's better than anyone else. It's slightly optimized, by using "union" queries and not creating a whole new table dedicated to a really small modification. I am limited to how much I can optimize it, as the engine doesn't have much options to it's optimization - it would be useless for me to even put that in. LOL!! LOL!!! Optimization at its finest :D Quote
Haunted Dawg Posted July 11, 2009 Posted July 11, 2009 Re: [V2] Saved Events You're unable to view this code. Viewing code within this forum requires registration, you can register here for free. That's not even needed. Ever thought of mysql_affected_rows? ;) Putting quote's around a number? Yup, we using '' around a number because there your telling SQL it's a string and take's longer to process.. Using COUNT(*) Your selecting everything when all you needed was `evID`.. All that sprintf() is almost as useless.. Quote
oxidati0n Posted July 11, 2009 Author Posted July 11, 2009 Re: [V2] Saved Events That's not even needed. Ever thought of mysql_affected_rows? ;) Putting quote's around a number? Yup, we using '' around a number because there your telling SQL it's a string and take's longer to process.. Using COUNT(*) Your selecting everything when all you needed was `evID`.. All that sprintf() is almost as useless.. I don't know the identifier for DB in order to use mysql_affected_rows. Sorry dude, didn't know your buds tingled through your *hints*. Quote
Haunted Dawg Posted July 13, 2009 Posted July 13, 2009 Re: [V2] Saved Events If you have an already existing identifier.. in this case $c you wouldn't even need it because it's grabbing the last existing identifier from the last mysql_connect. And since mccode's does not have mysql_close() $c is alway's open. Quote
Miniman Posted July 13, 2009 Posted July 13, 2009 Re: [V2] Saved Events Well this is nice! Post something to better people and get shat on :-) Yes, yes. I do it, but I don't go as far as this. :lol: *Miniman stamps a "Post new Topic" stamp on Haunted Dawg's head. It's there, I think. :wink: Show us some optimization HD style maybe? :-P Quote
Haunted Dawg Posted July 13, 2009 Posted July 13, 2009 Re: [V2] Saved Events If i do have to make one, i would go on with some ajaxorization :P Quote
Guest Sniko` Posted July 13, 2009 Posted July 13, 2009 Re: [V2] Saved Events If i do have to make one, i would go on with some ajaxorization :P *Very Posh Accent* Fancy Quote
Miniman Posted July 13, 2009 Posted July 13, 2009 Re: [V2] Saved Events If i do have to make one, i would go on with some ajaxorization :P Just putting it out there.... And..........GO! Time starts now :lol: Quote
oxidati0n Posted July 15, 2009 Author Posted July 15, 2009 Re: [V2] Saved Events AJAX isn't play dough. It's harder to develop than you think. Quote
Haunted Dawg Posted July 15, 2009 Posted July 15, 2009 Re: [V2] Saved Events AJAX isn't play dough. It's harder to develop than you think. You might think that, with the knowledge of php you can overcome javascript very easy. And with the knowledge of javascript and taking a small tutorial you can overcome ajax also very easy. Quote
oxidati0n Posted July 15, 2009 Author Posted July 15, 2009 Re: [V2] Saved Events Ah right. Does that include the debugging for all browsers? And, does it include programming for non-javascript users? Oh, and, is it exploitable through JavaScript misuse? Good luck with your theory. JavaScript is the Web2.0 but you're going to need to secure it with both JS and PHP. That way, it's easier for it to process, and that it is professional for your web app. Quote
Haunted Dawg Posted July 15, 2009 Posted July 15, 2009 Re: [V2] Saved Events Ah right. Does that include the debugging for all browsers? Yes, to an extent. And, does it include programming for non-javascript users? How many people do not use javascript now a day's? Oh, and, is it exploitable through JavaScript misuse? As far as my testing goes, my javascript has not been broken through, and who say's using other lib's aint easy? ;) Quote
Karlos Posted August 18, 2009 Posted August 18, 2009 Re: [V2] Saved Events Isn't UNION() used for SELECT queries only? Quote
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.