[CONTRIBUTION] Ultimate SEO URLs v2.1 - by Chemo in General Add-Ons Support Posted January 9, 2009 · Edited January 9, 2009 by rs2k What was the thinking behind not using tep_db_functions in seo.class.php? Why was is necessary to create a new class and group of functions when all the functions already existed in OSC? After more digging into the seo.class.php code I finally solved this and one other problem that has been bugging me. I have no clue why it was programmed this way, but the seo.class.php file makes a new connection the the database every time the tep_href_url function is called. It uses its own line to connect instead of what's in application_top.php. This means that if you change the db connection line in the application_top.php file your SEO URLs will break. The reason that the first store was still working was because seo.class.php was connecting to an old database that was the same as the shared database. The second stores old database had 0 products which is why all the URLs were being displayed without the name. I simply commented out the lines in se.class.php that called for the SEO_Database class and changed every instance of $this->db->Function to tep_db_function. This has the great benefit of displaying the seo url queries into the query debug array and not creating new connections to the database every time the tep_href_url function is called. This will make our website more secure by allowing us to re enable mod_evasive because all pages will only call the database once (or twice) instead of 10 - 100 times.