A short while back I paid a guy to make some changes. He mostly did great work, then disappeared. Before long the view forum thread page began getting slower and slower.
One of the changes added a thumbs-up rating mechanism. Additionally, all of the ratings were tabulated and printed under the user name each time he posted even if not being rated for that particular post.
Though mostly older Php 3, I recall being told that he was going to be using objects and Ajax. So the overall site design may change drastically right there.
I really need help and would be cheered to either pay or praise anyone who can go in there and fit the pieces together. I studied 3.0 and 4.0 for a while, then gave up. The reading leaves me rather well being able to read the older code, but not Ajax or objects. Trying to shut it off myself led to a complete page error.
Moreover, there is at least a possibility that some other issue is the culprit.
Ideally, I would like to get the rating function working properly. But off is better than the massive slowdown currently being endured.
Below are the lines from the file where the new function was installed. The site is meetchristians.com. You can view any forum posting in two ways, through the tour view (no ratings, no slowdown) or in logged in mode. Logging in is the only way to experience the slowdown. Anyone interested enough can easily create a free membership in about 5 minutes by just using the tab key and spacebar to quickly insert the default value for each field when creating a dummy profile.
Anyway, I have been running ads for weeks on craigslist, to no avail, and started seeking help on oDesk yesterday, thus far without remedy. That brings me here. A while back I brought a problem to sitepoint and actually got contacted by a member who repaired the SQL issue on that occasion.
So for money or mercy, if you can and will help, if you are advanced enough to navigate through somewhat complicated code that mixes old and new, terrific. Though with limited resources, I have some dinero saved and will feel just fine if the total is merely a few hours with a fairly modest hourly rate.
Unless just fixing a typo, instructing me in long language how to get in there and code will probably be wasted. Just let me pay. I would love hearing the remedy explained, to be sure, but also need to make sure the work is done by somebody a lot more capable than me.
Instead of pasting code in this post, I will drop it into the next one because it turns out to be more than just a few lines.
Oh, and by the way, his database SQLi calls are in addition to the SQL calls made higher up on the page for every other function.