Discussion forum debugging, affiliate Software Installation

Our website is www.restaurantforms.net. We need help with a few very specific functions: 1.) Debug Snitz Discussion forum a.) users cannot login more than once I think if you allow the login function to look for the > username and password in the Forum_Members table, in addition to > the tblusers table, from the database, this will solve the > problem. I don't know if this is possible, but I know it would > solve the problem. The problem is that customers create a username/ > password with the discussion forum, but they are not registered in > the regular website. How it works is that customers are supposed > to login to the website, then click on forum, where they are > automatically logged into the discussion forum. Since these people > have no username/password in the tblusers table, they cannot login > to the regular website. I know this because my username/password > works because it is in both the tblusers and Forum_Members tables. b.) the scripts are not working properly on the left include file, for the forum page, but no other page. The [login to view URL] include, the left column of the website, does not > work properly on the forum page. The hyperlinks work, however, > the javascript functions: newsletter subscription and website > login, do not work. 2.) Install affiliateclick affiliate tracking software The software for the affiliate program is attached to this file. 3.) Debug the mdb database connection strings. Random customers are not being written into the database, and are not receiving their electronic products. Customers are completing the purchase, but not the full order. I dont' know how the whole system works, but when a customer makes a purchase, they > receive an email with a username and password that allows them to > login to the website and download the products. I assume this is > done through the Instant Payment Notification fuction, but I don't > know. So the customers might "x" out of the browser after the > purchase is complete, but before their username and password can be > generated. I know they don't receive their email because they > email me about 2 weeks later, asking where their software is. All three are of high importance, and must be completed within 1 week. I have received a professional opinion on what the problems are, so the above information is accurate. The projects should not be that complex and we are looking to spend about $125. Thank you.