We have the skadate script installed on mydomain.com (works great) - we now want to divide the primary site into country specific subdomains eg ireland.mydomain.com - we have the script installed on a subdomain and again thats working fine. However, what we really need is for the database to be queried on connection so that only members who have registered with the country_id IE (Ireland) show on the ireland.mydomain.com site. Any advice and guidance would be very greatfully recieved.
Sounds like you would have to modify the script, adding a where clause to queries fetching/displaying the members. I've never used the script personally, so it's a bit hard to help you. However, provided there is no existing functionality within the script that can currently accomplish what you're after, you'd probably want to note down all areas of the site you need modified, and than try looking through the .php files for the queries that generate that content. For example, instead of something as simple as: SELECT * FROM blah; Code (markup): You would have to specify the country id: SELECT * FROM blah WHERE country_id = 'IE'; Code (markup):