Jul 15,2004 12:00am -I made a ton of updates today - vers.3.2 - post by the_reverend[link]
*updated discussion link to go from 100-1000's of SQL queries to 11-12. it was one for each post the user made (to get the subject). they are combined now into one slick call.
*updated cd-add link to go from 1 SQL call per CD-Added to 1 call for ALL cds added.
*updated CD-review link to go from 1 SQL per CD-Reviewed to 1 call for ALL cds reviews
*updated picture comments link to go from 1 SQL per picture comment to 1 call for ALL pictures commented on
*Moved a check from when RTTP was lost in July 2003 for usernames that are no longer valid due to them being lost with that server.
*removed 5 SQL calls from the main page by using the same method as the profiles page uses for CD covers on the latest reviewed section
*removed the separate looks ups on picture comments. another 7 SQL calls replaced by 1.
*restructured so that the Search thing is on the top of the results page.
*cache searched values so that I can do a "top 10 searches"
*Turned all the CD-reviews and CD's search into 1 sql command. Was one PER cd found. (this needs to be monitored for time which bad! it takes about 20 seconds for this query to work!)
*Removed superfluous sql query on the discussion list for the subject since I already know that info.
*replaced 1 SQL query for each picture comment found on the picture comment search.
removed 1 SQL command for all the other CDs by whatever band. also, removed duplicate queries for the CD covers on the most/last section
removed some crappy update stuff from index.php, equipment.php, and bullsiht.php
redid the referrals 1 SQL query PER pictures to 1 for all 60 pictures. 76 sql queries down to 12.
*fixed some times where it posts as anonymous when you are logged in.