128427 php/mysql site fix and change

ok. I have a heavily customised php/mysql script based online job advert site and there are several problems that I need resolving urgently! Recently I worked with a programmer on SL to make some significant structural changes to the directory structure of the site. My php/mysql is average at best and his was meant to be very [login to view URL] turned out that this was not the case! I thought the site was all fixed and working fine but after further testing I have found several aspects of the site are not working correctly now (and they did before) This should be a relatively straightforward fix for someone who is very good at PHP and Mysql. But I MUST EMPHASISE...please DO NOT take on this project if you are not 100% confident in your PHP/Mysql skills. I am looking for an expert, not a learner and also you must have multiple positive feedbacks please as this work is critical to me. I am 99% sure the problem is related to the fact that the multiple language options have been removed from the script. So a variable is passed that should be carrying the selected language in the settings (en. in this case) and that is appended to SQL queries to pick the right database table, but its not doing this in some instances so this variable needs setting properly as I cant find where to do it! [login to view URL] problems are: 1/ Several parts on the admin panel now dont work correctly. Like several text boxes on one page are not displaying that give me the option to put job titles in and also a main settings panel is not displaying payment and advertiser settings for the site (I can edit these in the code but thats not the point!) ALl of this worked before the structural change and now only 90% of the site works properly. I have all of the original files of course. 2/ The site generates SEO friendly lists of all adverts for search engines. This is sending me sql error emails that are all complaining about the missing _en at the end of the queries so this should be fixed when the above problem gets fixed! ok. That is all the problems I have found but there is a minor addition I require 1/At present people can apply for a job advert as many times as they want! Basically I want this preventing by some code adding that if they try and reapply for a job advert they have already applied for it says "sorry, you have already applied for this job" or something similiar. I have a couple of other ways I can suggest to you that would all be satisfactory. Lastly,there is a PHP file that has simple code in for the “print layout” of certain pages. For example “invoices” uses this basic template that is a print friendly text only layout. I would like it adjusting please so that it looks a bit nicer and includes my sites logo on the print page. If you have a static IP address it will be an advantage for firewall rule setting or at least if you can keep the same IP for 24 hours say. THANKS