0) while($row = mysql_fetch_row($result)) { $pagetitle = "Model Shops in " .$row[1]. ""; $seokey = "Model Shops, UK, ". $row[1] .""; $seodesc= "The ". $row[1] ." Model shop directory has over ". $row[3] ." upto date entries."; } include "header.php"; echo ""; include "includes/menu.php"; echo "
"; echo ""; echo "
"; } echo "
Airport Parking Reviews > Airport Parking Directory > "; $query = "SELECT countryid, country FROM chi_clubs_country WHERE countryid = '$countryid'"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo "Model Shops in " .$row[1]. "

Add a Model Shop

"; $query = "SELECT countryid, country FROM chi_clubs_country WHERE countryid = '$countryid'"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo "
Model Shops in " .$row[1]. "

"; } $result = $db->sql_query("SELECT a.countryid, a.country, b.countyid, b.countryid, b.county, p.countryid, p.countyid FROM chi_clubs_country a, chi_clubs_county b, chi_clubs p WHERE a.countryid = p.countryid AND b.countyid = p.countyid AND p.countryid = '$countryid' AND p.active = '1' GROUP BY p.countyid ORDER BY b.county"); //we add this line because we need to know the number of rows $num_rows = mysql_num_rows($result); echo "\n"; //set the number of columns $columns = 2; //changed this to a for loop so we can use the number of rows for($i = 0; $i < $num_rows; $i++) { $row = mysql_fetch_array($result); if($i % $columns == 0) { //if there is no remainder, we want to start a new row echo "\n"; } echo ""; if(($i % $columns) == ($columns - 1) || ($i + 1) == $num_rows) { //if there is a remainder of 1, end the row //or if there is nothing left in our result set, end the row echo "\n"; } } echo "
"; echo "
" .$row[4].""; echo "
"; include "includes/topshops.php"; echo "
"; echo ""; include "footer.php"; } function clubscounty($countyid) { global $pagetitle, $seokey, $seodesc, $db, $nukeurl,$correcturl; $query = "SELECT a.countryid, a.country, b.countyid, b.county, b.countryid, COUNT(c.cid), c.countyid FROM chi_clubs_country a, chi_clubs_county b, chi_clubs c WHERE a.countryid = b.countryid AND b.countyid = c.countyid AND b.countyid = '$countyid' AND c.active = '1' GROUP BY b.countyid"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { $pagetitle = "" .$row[3]. " Airport Car Parks and Reviews"; $seokey = "" .$row[3]. " Airport Car Parks"; $seodesc= "There is currently " .$row[5]. " Car Parks listed for the " .$row[3]. " in the Airport Parking Directory."; } include "header.php"; echo ""; echo "
"; $query = "SELECT p.countryid, a.countryid, a.country, p.active FROM chi_clubs p, chi_clubs_country a WHERE p.countryid = a.countryid AND p.countyid = '$countyid' AND p.active = '1' LIMIT 0,1"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo ""; } echo ""; $query = "SELECT cid, countryid, countyid FROM chi_clubs WHERE countyid = '$countyid' AND active = '1' LIMIT 1"; $result = $db->sql_query($query); if($db->sql_numrows($result)>0) { while($row =$db->sql_fetchrow($result)) { $countryid = $row[1]; $result2 = $db->sql_query("SELECT p.countyid, b.countyid, b.county FROM chi_clubs p, chi_clubs_county b WHERE b.countyid = p.countyid AND p.countryid = '$countryid' AND p.active = '1' GROUP BY b.countyid ORDER BY b.county ASC"); while($row2 = $db->sql_fetchrow($result2)) { echo ""; } } } echo "
".$row[2]."
" .$row2[2]. "
"; echo "
"; include "includes/menu.php"; echo ""; echo "
"; } echo "
Airport Parking Reviews > Airport Parking Directory > "; $query = "SELECT a.countryid, a.country, b.countyid, b.county, b.countryid FROM chi_clubs_country a, chi_clubs_county b WHERE a.countryid = b.countryid AND b.countyid = '$countyid'"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo "" .$row[3]. " Car Parks

Add an Airport Parking Review New

"; $query = "SELECT countyid, county FROM chi_clubs_county WHERE countyid = '$countyid'"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo "

" .$row[1]. " Car Parks

"; } echo ""; $query = "SELECT b.countyid, b.county, c.townid, c.countyid, c.town, p.countyid FROM chi_clubs_county b, chi_clubs_town c, chi_clubs p WHERE b.countyid = p.countyid AND c.townid = p.townid AND p.countyid = '$countyid' AND p.active ='1' GROUP BY p.townid ORDER BY c.town"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo ""; $townid = $row[2]; $result2 = $db->sql_query( "SELECT b.countyid, b.county, c.townid, c.countyid, c.town, p.countyid, p.townid, p.club, p.cid FROM chi_clubs_county b, chi_clubs_town c, chi_clubs p WHERE b.countyid = p.countyid AND c.townid = p.townid AND p.townid= '$townid' AND p.active = '1' ORDER BY p.club"); while($row2 = $db->sql_fetchrow($result2)) { echo ""; } } echo "

".$row[4]." Airport Parking
".$row2[7].""; $cid = $row2[8]; $result3 = $db->sql_query( "SELECT AVG(rating), COUNT(crid) FROM chi_shop_rev WHERE cid = '$cid' GROUP BY cid"); while($row3 = $db->sql_fetchrow($result3)) { if(!empty($row3[0])) echo "\"" " . number_format ($row3[0], 0, '.', ',') . "/10"; else echo "Rate & Review"; } echo "

"; echo "
"; include "includes/topshops.php"; echo "
"; echo ""; include "footer.php"; } function clubsredir($param1,$param2) { global $nukeurl,$db; list($shopname,$tid) = mysql_fetch_row(mysql_query("SELECT p.club, p.townid FROM chi_clubs p WHERE p.cid='$param2';")); list($location) = mysql_fetch_row(mysql_query("SELECT t.town FROM chi_clubs_town t WHERE t.townid='$tid';")); header("HTTP/1.0 301 Moved Permanently"); header("location:$nukeurl/".str_replace(" ","-",$shopname)."-Model-Shop-".str_replace(" ","-",$location)."-$param2.html"); } function clubs($cid) { global $pagetitle, $seokey, $seodesc, $db, $nukeurl,$correcturl; $query = "SELECT p.cid, p.club, p.townid, c.townid, c.town, b.countyid, b.county, p.address FROM chi_clubs p, chi_clubs_town c, chi_clubs_county b WHERE c.townid = p.townid AND b.countyid = p.countyid AND p.cid = '$cid' AND p.active = '1'"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { $pagetitle = "" .$row[1]. " Reviews, " .$row[4]. " Airport"; $seodesc= "Read " .$row[1]. " Parking Reviews. We currently have " .$row2[1]. " user submitted Airport Parking Reviews for " .$row[1]. ". "; $seokey = "" .$row[1]. ", " .$row[4]. " Airport"; } include "header.php"; echo ""; include "includes/add.php"; echo "
"; include "includes/menu.php"; echo "
"; include "includes/toprated.php"; echo "
"; echo "
"; $query = "SELECT p.cid, p.countyid, p.active, b.countyid, b.county FROM chi_clubs p, chi_clubs_county b WHERE p.countyid = b.countyid AND cid = '$cid' AND p.active = '1'"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo ""; } echo ""; $query = "SELECT cid, countyid FROM chi_clubs WHERE cid = '$cid' AND active = '1'"; $result = $db->sql_query($query); if($db->sql_numrows($result)>0) { while($row =$db->sql_fetchrow($result)) { $countyid = $row[1]; $result2 = $db->sql_query("SELECT p.cid, p.club, p.townid, p.countyid, p.active, b.townid, b.town, p.count FROM chi_clubs p, chi_clubs_town b WHERE b.townid = p.townid AND p.countyid = '$countyid' AND p.active = '1' ORDER BY club ASC"); while($row2 = $db->sql_fetchrow($result2)) { echo ""; } } } echo "
".$row[4]." Car Parks
" .$row2[1]. "
"; echo "
"; echo ""; echo "
"; } echo "
Airport Parking Reviews > Airport Parking Directory > "; $query = "SELECT p.cid, p.club, p.townid, c.townid, c.town, b.countyid, b.county, a.countryid, a.country, p.countryid FROM chi_clubs p, chi_clubs_town c, chi_clubs_county b, chi_clubs_country a WHERE c.townid = p.townid AND b.countyid = p.countyid AND a.countryid = p.countryid AND p.cid = '$cid' AND p.active = '1'"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo "" .$row[1]. " Reviews

"; $query = "SELECT p.cid, p.club, p.address, p.phone, p.fax, p.countryid, p.countyid, p.townid, p.description, p.email, p.website, p.active, p.location, p.count, p.source, p.sourceurl, c.townid, c.countyid, c.town FROM chi_clubs p, chi_clubs_town c WHERE p.townid = c.townid AND cid = '$cid' AND p.active = '1'"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo ""; if($isadmin) { echo ""; } echo ""; $result2 = $db->sql_query( "SELECT AVG(rating), COUNT(crid) FROM chi_shop_rev WHERE cid = '$cid' GROUP BY cid"); while($row2 = $db->sql_fetchrow($result2)) { if(!empty($row2[0])) echo ""; } $result3 = $db->sql_query( "SELECT AVG(dining), COUNT(crid) FROM chi_shop_rev WHERE cid = '$cid' GROUP BY cid"); while($row3 = $db->sql_fetchrow($result3)) { if(!empty($row3[0])) echo ""; } echo ""; if(!empty($row[4])) echo ""; if(!empty($row[10])) echo""; if(!empty($row[8])) echo " "; if(!empty($row[12])) echo ""; $result2 = $db->sql_query( "SELECT cid, manfid FROM chi_clubs_brands WHERE cid = '$cid' GROUP BY cid LIMIT 1"); while($row2 = $db->sql_fetchrow($result2)) { echo ""; } echo ""; $townid = $row[7]; $result4 = $db->sql_query( "SELECT townid, town FROM chi_clubs_town WHERE townid = '$townid'"); while($row4 = $db->sql_fetchrow($result4)) { if(!empty($row[15])) echo ""; else echo ""; } echo "
[Edit]

" .$row[1]. " Reviews

User Rating: \"" " . number_format ($row2[0], 0, '.', ',') . "/10
User Rating: \"" " . number_format ($row3[0], 0, '.', ',') . "/10
Rate & Review this Car Park | Read Reviews
Address: " .$row[2]. "
Daily Prices From: " .$row[3]. "
Fax: " .$row[4]. "
Website: " .$row[1]. "
" .$row[8]. "


" .$row[12]. "
Stockists Of:
"; $result3 = $db->sql_query( "SELECT b.cid, b.manfid, m.manfid, m.manufacturer, b.cbid FROM chi_clubs_brands b, chi_gear_manufacturer m WHERE b.manfid = m.manfid AND cid = '$cid'"); while($row3 = $db->sql_fetchrow($result3)) { echo "\"". "; } echo "
Sat Nav Directions: " .$row[14]. "
".$row4[1]." Airport Reviews
[Update Entry]
"; } echo "

Rate & Review this Car Park New

"; echo "

Read Reviews...

"; $query = "SELECT cid, rating, submittedby, comments, IF(CHAR_LENGTH(comments)>57,RPAD(LEFT(comments,57),60,'.'),comments) AS title, crid FROM chi_shop_rev WHERE cid = '$cid' ORDER BY crid DESC"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo ""; if($isadmin) echo ""; echo ""; $commenttext = ereg_replace("Argos","Argos",$row[3]); echo"
[Edit]
" . $row[4] ."
Rating: \"" " . number_format ($row[1], 0, '.', ',') . "/10
" . $commenttext ."

Submitted By: " . $row[2] ."

"; } else { echo "Unfortunatly no one has yet been kind enough to leave a review. Why don't you be the first and let others know using the following form: Rate & Review this Car Park

"; } echo "

"; include "includes/newshops.php"; echo " "; include "includes/topshops.php"; echo "
"; echo ""; include "footer.php"; } function events() { global $pagetitle, $seokey, $seodesc, $db, $nukeurl,$correcturl; $pagetitle = "Model Exhibitions & Events"; $seokey = "Model Exhibitions, Events, Trains, Steam Fair, Model Layouts, Trade Stands, Directory"; $seodesc= "The Model Shops Exhibitions & Events directory has over many events for you to visit."; include "header.php"; echo ""; include "includes/menu.php"; echo "
"; include "includes/newevents.php"; echo ""; echo "
Model Shops > Model Exhibitions & Events

"; echo ""; $query = "SELECT e.eventid, e.event, e.organiser, DATE_FORMAT(e.startdate, '%D %M %Y') as startdate, DATE_FORMAT(e.enddate, '%D %M %Y') as enddate, e.address, e.address2, e.address3, e.townid, e.countyid, e.postcode, e.parking, e.disabled, e.refresh, e.active, t.townid, t.town, c.countyid, c.county, e.transport, e.website FROM chi_events e, chi_clubs_town t, chi_clubs_county c WHERE e.townid = t.townid AND e.countyid = c.countyid AND e.active = '1' AND e.startdate > CURDATE() -1 ORDER BY e.startdate ASC"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "
Model Exhibitions & Events

Welcome to our Model Exhibitions & Events listing page. Below you will find all the confirmed and submitted events taking place over the coming year and beyond. Read more details for further information regarding, location, displays and facilities at the event. As always we advise that you confirm the details of any exhibition listed here before making any long journeys.

We have tried to keep the listing as easy and simple to read as possible. We have included a few images as keys to help you see what is available at a glance.

Key:
\"Free= Free Parking
\"Disabled= Disabled Access
\"Refreshments= Refreshments Available
\"Public= Public Transport Links
\"Website= Website Available


If you would like to include your own exhibition or event in our listings, then please use this form: [Add an Event].
". $row[3] .""; if(!empty($row[4])) echo " - ". $row[4] .""; else echo ""; echo "
". $row[2] ." ". $row[1] ."
". $row[5] .""; if(!empty($row[6])) echo ", ". $row[6] .""; if(!empty($row[7])) echo ", ". $row[7] .""; if(!empty($row[16])) echo ", ". $row[16] .""; if(!empty($row[18])) echo ", ". $row[18] .""; if(!empty($row[10])) echo " ". $row[10] .""; echo "
"; if(!$row[11]==0) echo "\"Free "; else echo ""; if(!$row[12]==0) echo "\"Disabled "; else echo ""; if(!$row[13]==0) echo "\"Refreshments "; else echo ""; if(!$row[19]==0) echo "\"Public "; else echo ""; if(!$row[20]==0) echo "\"Website "; else echo ""; echo "
[More Details]
"; include "includes/topevents.php"; echo "
"; echo ""; include "footer.php"; } function eventspage($eventid) { global $pagetitle, $seokey, $seodesc, $db, $nukeurl,$correcturl; $query = "SELECT event, organiser FROM chi_events WHERE eventid = '$eventid'"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { $pagetitle = "". $row[1] ." ". $row[0] ." Model Exhibitions & Events"; $seokey = "". $row[1] .", ". $row[0] .", Model Exhibitions, Events"; $seodesc= "Full details of the ". $row[0] ." organised by ". $row[1] .", including maps and further information."; } include "header.php"; echo ""; include "includes/menu.php"; echo "
"; include "includes/newevents.php"; echo ""; echo "
Model Shops > Model Exhibitions & Events >"; $query = "SELECT eventid, event, organiser FROM chi_events WHERE eventid = '$eventid'"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo " ". $row[2] ." ". $row[1] .""; } echo "

"; $query = "SELECT e.eventid, e.event, e.organiser, DATE_FORMAT(e.startdate, '%D %M %Y') as startdate, DATE_FORMAT(e.enddate, '%D %M %Y') as enddate, e.address, e.address2, e.address3, e.townid, e.countyid, e.postcode, e.parking, e.disabled, e.refresh, e.active, t.townid, t.town, c.countyid, c.county, e.map, e.transport, e.times, e.admission, e.contact, e.website, e.description FROM chi_events e, chi_clubs_town t, chi_clubs_county c WHERE e.townid = t.townid AND e.countyid = c.countyid AND e.active = '1' AND e.eventid = '$eventid' ORDER BY e.startdate ASC"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { if($isadmin) { echo ""; } echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; } echo "
[Edit]
". $row[2] ." ". $row[1] ."
". $row[3] .""; if(!empty($row[4])) echo " - ". $row[4] .""; else echo ""; echo ""; echo "

"; echo "". $row[5] ."
"; if(!empty($row[6])) echo "". $row[6] ."
"; if(!empty($row[7])) echo "". $row[7] ."
"; if(!empty($row[16])) echo "". $row[16] ."
"; if(!empty($row[18])) echo "". $row[18] ."
"; if(!empty($row[10])) echo "". $row[10] .""; echo "

"; if(!$row[11]==0) echo "\"Free "; else echo ""; if(!$row[12]==0) echo "\"Disabled "; else echo ""; if(!$row[13]==0) echo "\"Refreshments "; else echo ""; if(!$row[20]==0) echo "\"Public "; else echo ""; if(!$row[24]==0) echo "\"Website "; else echo ""; if(!$row[24]==0) echo "

Website: ". $row[24] .""; else echo ""; echo "

"; echo "
"; if(!$row[21]==0) echo "Opening Times: ". $row[21] .""; else echo ""; if(!$row[22]==0) echo "

Admission: ". $row[22] .""; else echo ""; if(!$row[23]==0) echo "

Email: ". $row[23] .""; else echo ""; echo "
". $row[25] ."
". $row[19] ."
[Add an Event]
"; include "includes/topevents.php"; echo "
"; include "includes/eventkey.php"; echo "
"; include "includes/newsletter.php"; echo ""; include "footer.php"; } function eventsadd() { global $pagetitle, $seokey, $seodesc, $db, $nukeurl,$correcturl; $pagetitle = "Add a Model Exhibition & Event"; $seokey = ""; $seodesc= ""; include "header.php"; echo ""; include "includes/menu.php"; echo "
"; include "includes/newevents.php"; echo ""; echo "
Model Shops > Model Exhibitions & Events > Add an Event

Add an Event
Please use the form below to submit your model exhibitions and events to our website. Fill in as much of the form as you can as this will enhance you listing. Once we have received your submission we shall review it and add it to the website with 12 hours.
Organiser:
Enter the event name below, simply 'Exhibition' will suffice if it does not have a specific name.
Event:
Start Date: (YYYY-MM-DD)
If this is a one day event please leave the end date blank.
End Date: (YYYY-MM-DD)
Address:
Address:
Address:
Town:
Other Town:
County:
Other County:
Postcode:
Free Parking:
Disabled Access:
Refreshments :
Transport Links:
Opening Times:
Admission Costs:
Contact Name:
Event Email:
Event Website: (Optional)
Please use the description field to add any further details regarding you event, this will enhance your listing. You can include details such as visting layouts etc.
Description:


Please confirm you are a human by ticking this box.
"; echo ""; include "footer.php"; } function eventssent() { global $pagetitle, $seokey, $seodesc, $db, $nukeurl,$correcturl; $result = $db->sql_query("INSERT INTO chi_events_pending (organiser,event, startdate, enddate, address, address2, address3, townid, othertown, countyid, othercounty, postcode, parking, disabled, refresh, transport, times, admission, contact, eventcontact, website, description, timestamp) VALUES ('".forSql($_POST["organiser"])."','".forSql($_POST["event"])."','".forSql($_POST["startdate"])."','".forSql($_POST["enddate"])."','".forSql($_POST["address"])."','".forSql($_POST["address2"])."','".forSql($_POST["address3"])."','".forSql($_POST["townid"])."','".forSql($_POST["othertown"])."','".forSql($_POST["countyid"])."' ,'".forSql($_POST["othercounty"])."','".forSql($_POST["postcode"])."','".forSql($_POST["parking"])."','".forSql($_POST["disabled"])."','".forSql($_POST["refresh"])."','".forSql($_POST["transport"])."','".forSql($_POST["times"])."','".forSql($_POST["admission"])."','".forSql($_POST["contact"])."','".forSql($_POST["eventcontact"])."','".forSql($_POST["website"])."','".forSql($_POST["description"])."', UNIX_TIMESTAMP());"); $pagetitle = "Event Sent"; $seokey = ""; $seodesc= ""; include "header.php"; echo ""; include "includes/menu.php"; echo "
"; include "includes/newevents.php"; echo ""; echo "
Model Shops > Model Exhibitions & Events > Event Sent

Thanks - Your event submission has been received and shall be processed shortly.
"; include "includes/newsletter.php"; echo ""; include "footer.php"; } function shopdirectory() { global $pagetitle, $seokey, $seodesc, $db, $nukeurl,$correcturl; $pagetitle = "Airport Parking Directory | Airport Car Parks A-Z"; $seokey = "airport parking directory"; $seodesc= "The Airport Parking Directory has all the UK's Airport Car Parks."; include "header.php"; echo ""; include "includes/add.php"; echo "
"; include "includes/menu.php"; echo "
"; include "includes/toprated.php"; echo "
"; echo ""; echo "
Airport Parking Reviews > Airport Car Parks A-Z

Airport Parking Directory

Welcome to our Airport Parking Directory where we have compiled a list of Car Parks for all the UK's Airports. We try to keep it as up-to-date as possible, but if you know of an Airport Car Park that is not listed then please let us know by emailing us here > Contact Us

Many people have added their Airport Parking Reviews to our site using our simple to use form. You can rate your Airport Car Park and leave your comments for other travellers. So if you havn't added your review yet, then why not do it now?

Add an Airport Parking Review New

"; if($isadmin) { $query = "SELECT co.countryid, co.country, cl.countryid, cl.active FROM chi_clubs_country co, chi_clubs cl WHERE co.countryid = cl.countryid AND cl.active = '1' GROUP BY co.countryid ORDER BY co.country ASC"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo "

" .$row[1]. "

"; $countryid = $row[0]; $result2 = $db->sql_query("SELECT a.countryid, a.country, b.countyid, b.countryid, b.county, p.countryid, p.countyid, COUNT(p.cid) FROM chi_clubs_country a, chi_clubs_county b, chi_clubs p WHERE a.countryid = p.countryid AND b.countyid = p.countyid AND p.countryid = '$countryid' AND p.active = '1' GROUP BY p.countyid ORDER BY b.county"); //we add this line because we need to know the number of rows $num_rows = mysql_num_rows($result2); echo "\n"; //set the number of columns $columns = 2; //changed this to a for loop so we can use the number of rows for($i = 0; $i < $num_rows; $i++) { $row2 = mysql_fetch_array($result2); if($i % $columns == 0) { //if there is no remainder, we want to start a new row echo "\n"; } echo ""; if(($i % $columns) == ($columns - 1) || ($i + 1) == $num_rows) { //if there is a remainder of 1, end the row //or if there is nothing left in our result set, end the row echo "\n"; } } echo "
"; echo "
" .$row2[4]." "; if($isadmin) { echo "(".$row2[7].")"; } echo "

"; } } echo "
"; $result = $db->sql_query("SELECT town, townid FROM chi_clubs_town GROUP BY townid ORDER BY town ASC"); while($row=$db->sql_fetchrow($result)) { echo " "; $townid = $row[townid]; $result2 = $db->sql_query("SELECT townid, club, cid FROM chi_clubs WHERE townid = '$townid' ORDER BY club"); while($row2 = $db->sql_fetchrow($result2)) { if($rowcounter%2==1) $bgcolor="#FFFFFF"; else $bgcolor="#F4F4F4"; echo ""; $cid = $row2[cid]; $result3 = $db->sql_query("SELECT p.cid, p.club, AVG(r.rating) AS rating, COUNT(r.crid) AS count, r.cid FROM chi_shop_rev r, chi_clubs p WHERE r.cid = p.cid AND p.cid = '$cid' GROUP BY p.cid"); if (mysql_num_rows($result3) > 0) while($row3 = $db->sql_fetchrow($result3)) { echo ""; } else { echo ""; } $rowcounter++; } } echo "
AirportAirport Car ParkReviewsPassenger Rating
{$row["town"]}
{$row2["club"]}{$row3["count"]}\""" . number_format ($row3[rating], 1, '.', ',') . "/10
\"\"
"; echo " "; include "includes/topshops.php"; echo "
"; echo ""; include "footer.php"; } function modelclubadd() { global $pagetitle, $seokey, $seodesc, $db, $nukeurl,$correcturl; $pagetitle = "Add a Model Club"; $seokey = ""; $seodesc= ""; include "header.php"; echo ""; include "includes/menu.php"; echo "
"; echo ""; echo "
Model Shops > Model Clubs > Add a Model Club

Add a Model Club
Please use the form below to submit your model club. Fill in as much of the form as you can as this will enhance you listing. Once we have received your submission we shall review it and add it to the website with 12 hours.
Club & Society:
Please enter the address of the venue you meet at below. This will be published on the website. It is optional however we ask that you at least provide the town and county.
Address:
Address:
Address:
Town:
Other Town:
County:
Other County:
Postcode:
Telephone: (This is Published)
Website:
Meeting Days:
Meeting Times:
Contact Name:
Contact Email: (Not Published)
Please use the description field to add any further details regarding you club, this will enhance your listing and give more details to prospective members.
Description:


Please confirm you are a human by ticking this box.
"; echo ""; include "footer.php"; } function modelclubsent() { global $pagetitle, $seokey, $seodesc, $db, $nukeurl,$correcturl; $result = $db->sql_query("INSERT INTO chi_model_clubs_pending (club, address, address2, address3, townid, othertown, countyid, othercounty, postcode, telephone, website, type, description, timemeet, daymeet, name, email, timestamp) VALUES ('".forSql($_POST["club"])."','".forSql($_POST["address"])."','".forSql($_POST["address2"])."','".forSql($_POST["address3"])."','".forSql($_POST["townid"])."','".forSql($_POST["othertown"])."','".forSql($_POST["countyid"])."' ,'".forSql($_POST["othercounty"])."','".forSql($_POST["postcode"])."','".forSql($_POST["telephone"])."','".forSql($_POST["website"])."','".forSql($_POST["type"])."','".forSql($_POST["description"])."','".forSql($_POST["timemeet"])."','".forSql($_POST["daymeet"])."','".forSql($_POST["name"])."','".forSql($_POST["email"])."', UNIX_TIMESTAMP());"); $pagetitle = "Model Club Sent"; $seokey = ""; $seodesc= ""; include "header.php"; echo ""; include "includes/menu.php"; echo "
"; echo ""; echo "
Model Shops > Model Clubs > Model Club Sent

Thanks

Your club submission has been received and shall be processed shortly. In the meantime it would great if you can add a link back to the Model Shops website by adding one of the two links below to your website:

Text Link:

Club listed on Model Shops

Image Link:

"; echo ""; include "footer.php"; } function shopadd() { global $pagetitle, $seokey, $seodesc, $db, $nukeurl,$correcturl; $pagetitle = "Add a Model Shop"; $seokey = ""; $seodesc= ""; include "header.php"; echo ""; include "includes/menu.php"; echo ""; echo "
Model Shops > Model Shop Directory > Add a Model Shop

Add a Model Shop
Please use the form below to submit your model shop to our website. Fill in as much of the form as you can as this will enhance you listing. Once we have received your submission we shall review it and add it to the website with 12 hours.
Shop Name:
Phone:
Fax:
Full Address:
Please use the description field to add any further details regarding you shop, this will enhance your listing. You can include details such as manufacturers sold, any items you specialise in etc.
Description:
Email:
Website: (Optional)


Please confirm you are a human by ticking this box.
"; echo ""; include "footer.php"; } function shopsent() { global $pagetitle, $seokey, $seodesc, $db, $nukeurl,$correcturl; $result = $db->sql_query("INSERT INTO chi_clubs_pending (club, address, phone, fax, description, email, website, timestamp) VALUES ('".forSql($_POST["club"])."','".forSql($_POST["address"])."','".forSql($_POST["phone"])."','".forSql($_POST["fax"])."','".forSql($_POST["description"])."','".forSql($_POST["email"])."','".forSql($_POST["website"])."', UNIX_TIMESTAMP());"); $pagetitle = "Model Shop Sent"; $seokey = ""; $seodesc= ""; include "header.php"; echo ""; include "includes/menu.php"; echo ""; echo "
Model Shops > Model Shop Directory > Model Shop Sent

Thanks

Your model shop submission has been received and shall be processed shortly. In the meantime it would great if you can add a link back to the Model Shops website by adding one of the two links below to your website:

Text Link:

Club listed on Model Shops

Image Link:

"; include "includes/newsletter.php"; echo ""; include "footer.php"; } function modelclubhome() { global $pagetitle, $seokey, $seodesc, $db, $nukeurl,$correcturl; $pagetitle = "Model Club Directory | Model Shops"; $seokey = "Model Clubs, Directory, Listings"; $seodesc= "A directory of Model Clubs located in the UK and beyond."; include "header.php"; echo ""; include "includes/menu.php"; echo ""; echo "
Model Shops > Model Club Directory

Model Club Directory


Add a Model Club

"; $query = "SELECT m.club, m.address, m.address2, m.address3, m.townid, m.countyid, m.postcode, m.telephone, m.website, t.townid, t.town, c.countyid, c.county FROM chi_model_clubs m, chi_clubs_town t, chi_clubs_county c WHERE m.townid = t.townid AND m.countyid = c.countyid"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo ""; echo ""; echo ""; echo ""; } echo "
". $row[0] ."
". $row[1] .""; if(!empty($row[2])) echo ", ". $row[2] .""; if(!empty($row[3])) echo ", ". $row[3] .""; if(!empty($row[10])) echo ", ". $row[10] .""; if(!empty($row[12])) echo ", ". $row[12] .""; if(!empty($row[6])) echo " ". $row[6] .""; echo "
Telephone: ". $row[7] ."
"; echo ""; include "footer.php"; } function blogs() { global $pagetitle, $seokey, $seodesc, $db, $nukeurl,$correcturl; $pagetitle = "Airport Blogs & Websites"; $seokey = "Airport Blogs, Parking Blogs, Airport Websites"; $seodesc= "A collection of links to blogs & websites. "; include "header.php"; echo ""; include "includes/menu.php"; echo ""; echo "
Airport Parking > Airport Blogs & Websites

"; /* $query = "SELECT b.catid, b.title, b.url, b.description, b.timestamp, b.active, c.catid, c.category FROM chi_blogs b, chi_blogs_category c WHERE b.catid = c.catid AND b.active = '1' ORDER BY b.timestamp DESC"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result))*/ { echo ""; echo ""; /* echo "";*/ /* echo "";*/ echo ""; } echo "
". $row[1] ."
". $row[3] .""; echo "
Link: ". $row[2] ."
Added: ".date("jS M Y",$row[4])."
"; echo ""; include "footer.php"; } function blogadd() { global $pagetitle, $seokey, $seodesc, $db, $nukeurl,$correcturl; $pagetitle = "Add a Blog or Website Link"; $seokey = ""; $seodesc= ""; include "header.php"; echo ""; include "includes/menu.php"; echo ""; echo "
Airport Parking > Model Blogs & Websites > Add a Blog or Website

Add a Blog or Website
Please use this short form to submit links for model related blogs and websites. This includes real subjects as well as model ones, anything generally related to modelling. Instructions on how to link back to us can be found on the next page.
Category:
Other:
Title:
Url:
Description:
Email: (not published)


Please confirm you are a human by ticking this box.
"; echo ""; include "footer.php"; } function blogsent() { global $pagetitle, $seokey, $seodesc, $db, $nukeurl,$correcturl; $result = $db->sql_query("INSERT INTO chi_blogs_pending (catid, othercat, title, url, description, email, timestamp) VALUES ('".forSql($_POST["catid"])."','".forSql($_POST["othercat"])."','".forSql($_POST["title"])."','".forSql($_POST["url"])."','".forSql($_POST["description"])."','".forSql($_POST["email"])."', UNIX_TIMESTAMP());"); $pagetitle = "Link Submission Sent"; $seokey = ""; $seodesc= ""; include "header.php"; echo ""; include "includes/menu.php"; echo ""; echo "
Airport Parking > Model Blogs & Websites > Link Submission Sent

Thanks

Your link submission has been received and shall be processed shortly. In the meantime it would great if you can add a link back to the Model Shops website by adding one of the two links below to your website:

Text Link:

Airport Parking

Image Link:

"; include "includes/newsletter.php"; echo ""; include "footer.php"; } function advertise() { global $pagetitle, $seokey, $seodesc, $db, $nukeurl,$correcturl; $pagetitle = "Advertise on Airport Parking"; $seokey = "advertise,airport parking"; $seodesc= "If you want to advertise on our site, please contact us using the form below"; include "header.php"; echo ""; include "includes/menu.php"; echo ""; echo "
Airport Parking > Advertise

Advertising on Airport Parking

Airparking.net offers extensive advertising opportunities for any company looking to promote themselves to a UK audience.

We pride ourselves in like for like advertising to maximise our customers spending habits.

Airparking.net would love to hear from forward thinking companies interested in partnering with us, so please contact us today for more information about the opportunities available on the site.

Contact us here
"; include "footer.php"; } function searchresults() { global $pagetitle, $seokey, $seodesc, $db, $nukeurl,$correcturl; $pagetitle = "Search Results"; $seokey = ""; $seodesc= ""; include "header.php"; echo ""; include "includes/menu.php"; echo ""; echo "
"; include "includes/searchbox.php"; echo ""; include "footer.php"; } function clubstown($townid) { global $pagetitle, $seokey, $seodesc, $db, $nukeurl,$correcturl; $query = "SELECT COUNT(p.cid), p.club, p.townid, c.townid, c.town, b.countyid, b.county, p.address FROM chi_clubs p, chi_clubs_town c, chi_clubs_county b WHERE c.townid = p.townid AND b.countyid = p.countyid AND p.townid = '$townid' GROUP BY c.townid"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { $pagetitle = "" .$row[4]. " Airport Parking, " .$row[6]. ""; $seokey = "" .$row[4]. "," .$row[6]. ",Airport Parking"; $seodesc= "We have ". $row[0] ." car parks listed in ". $row[4] ." ". $row[6] ." in our airport parking directory"; } include "header.php"; echo ""; echo "
"; $query = "SELECT t.townid, t.town, t.countyid, c.countyid, c.county FROM chi_clubs_town t, chi_clubs_county c WHERE t.countyid = c.countyid AND t.townid = '$townid'"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) $result = $db->sql_query($query); if($db->sql_numrows($result)>0) { while($row =$db->sql_fetchrow($result)) { $countyid = $row[2]; $result2 = $db->sql_query("SELECT c.townid, c.active, t.townid, t.town, t.countyid FROM chi_clubs c, chi_clubs_town t WHERE c.townid = t.townid AND t.countyid = '$countyid' AND c.active = '1' GROUP BY t.townid ORDER BY t.town ASC"); while($row2 = $db->sql_fetchrow($result2)) { echo ""; } } } echo "
" .$row2[3]. "

"; include "includes/menu.php"; echo ""; echo "
"; } echo "
Airport Parking Reviews > Airport Parking Directory > "; $query = "SELECT p.cid, p.club, p.townid, c.townid, c.town, b.countyid, b.county, a.countryid, a.country, p.countryid FROM chi_clubs p, chi_clubs_town c, chi_clubs_county b, chi_clubs_country a WHERE c.townid = p.townid AND b.countyid = p.countyid AND a.countryid = p.countryid AND p.townid = '$townid' LIMIT 1"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo "" .$row[6]. " > " .$row[4]. " Airport Parking

"; $query = "SELECT p.cid, p.club, p.townid, c.townid, c.town, b.countyid, b.county, a.countryid, a.country, p.countryid FROM chi_clubs p, chi_clubs_town c, chi_clubs_county b, chi_clubs_country a WHERE c.townid = p.townid AND b.countyid = p.countyid AND a.countryid = p.countryid AND p.townid = '$townid' LIMIT 1"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo "

" .$row[4]. " Airport Parking

"; } echo "

"; $query = "SELECT p.cid, p.club, p.address, p.phone, p.email, p.website, p.townid, p.active, c.townid, c.countyid, c.town FROM chi_clubs p, chi_clubs_town c WHERE p.townid = c.townid AND p.townid = '$townid' AND p.active = '1' ORDER BY p.phone ASC"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo "
"; echo ""; echo ""; echo ""; echo ""; echo "
"; echo "". $row[1] . ""; echo "
Prices From: ". $row[3] .""; echo "A: ". $row[2] ."
"; if(!empty($row[5])) echo "\"Website "; if(!empty($row[4])) echo "\"Email "; echo ""; echo "\"More"; echo "

"; } echo "
Rate & Review Airport Parking New
"; include "includes/topshops.php"; echo "
"; echo ""; include "footer.php"; } function addclubreview() { global $pagetitle, $seokey, $seodesc, $db, $nukeurl,$correcturl; $pagetitle = "Submit Airport Parking Reviews"; $seokey = "submit airport parking reviews,add review"; $seodesc= "Submit your airport car parking experience to airparking.net and so other travellers can benefit"; include "header.php"; echo ""; include "includes/menu.php"; echo "
"; include "includes/toprated.php"; echo "
"; echo"
Airport Parking Reviews > Airport Parking Directory > Rate & Review Airport Parking

Submit Your Airport Car Parking Reviews

Had a good or bad experience when parking your car, then why not tell others about it? If you add your car park review today, you will be entered into our Free prize draw to win an Airport Hotel stay with upto 15 days parking.

Please use this simple form to add your Airport Parking review and let others know the experience they are likely to recieve when booking their Airport Car Park. If the Car Park is not listed please use the 'other' box to add it. To see if we already have the Car Park, please use the drop down box below.

If you submit a review that is unhelpful, has no content or offers little information, your review will not be added. Please do not add reviews that contain potentially libelous content as you may be liable.

Car Park:
Other Car Park:
Rate Your Experience: (1 is Very Bad, 10 is Very Good)
Your Comments:
Your Name:
Email Address:
Please confirm you are a human and tick this box.
"; echo ""; include "footer.php"; } function clubreviewsent() { global $pagetitle, $seokey, $seodesc, $db, $nukeurl,$correcturl; $result = $db->sql_query("INSERT INTO chi_shop_rev_pending (cid, other, submittedby, email, rating, comments, timestamp, pendip) VALUES ('".forSql($_POST["cid"])."','".forSql($_POST["other"])."','".forSql($_POST["submittedby"])."','".forSql($_POST["email"])."','".forSql($_POST["rating"])."','".forSql($_POST["comments"])."',UNIX_TIMESTAMP(),'".forSql($_SERVER['REMOTE_ADDR'])."');"); $pagetitle = "Review Sent"; include "header.php"; echo ""; include "includes/menu.php"; echo "
"; echo "
"; echo ""; echo "
"; echo "
Airport Parking Reviews > Airport Parking Directory > Rate & Review Airport Parking > Sent

Thanks - Review Recieved.
"; echo " "; include "footer.php"; } function countryredir($param1) { global $nukeurl,$db; list($country) = mysql_fetch_row(mysql_query("SELECT p.country, p.countryid FROM chi_clubs_country p WHERE p.countryid='$param1';")); header("HTTP/1.0 301 Moved Permanently"); header("location:$nukeurl/Model-Shop-Directory.html"); } function shopsaz($letter) { global $pagetitle, $seokey, $seodesc, $db, $nukeurl,$correcturl; $pagetitle = "Airport Parking - ".$letter.""; $seokey = ""; $seodesc= ""; include "header.php"; echo ""; include "includes/menu.php"; echo ""; echo "
Airport Parking Reviews > Airport Parking Directory > Airport Parking A-Z

Airport Parking - ".$letter."

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

"; $query = "SELECT p.cid, p.club, p.townid, p.active, c.townid, c.countyid, c.town, p.address, p.phone FROM chi_clubs p, chi_clubs_town c WHERE p.townid = c.townid AND p.active = '1' AND p.club LIKE '".$letter."%' ORDER BY p.club ASC"; $result = mysql_query($query); if (mysql_num_rows($result) > 0) while($row = mysql_fetch_row($result)) { echo "
"; echo ""; echo ""; echo ""; echo ""; echo "
"; echo "". $row[1] . ""; echo "
Prices From: ". $row[8] .""; echo "A: ". $row[7] ."
"; if(!empty($row[5])) echo "\"Website "; if(!empty($row[4])) echo "\"Email "; echo ""; echo "\"More"; echo "

"; } echo "
Rate & Review a Car Park New
"; include "includes/topshops.php"; echo "
"; echo ""; include "footer.php"; } switch($op) { case "clubscountry": clubscountry($countryid); break; case "clubscounty": clubscounty($countyid); break; case "clubs": clubs($cid); break; case "clubsredir": clubsredir($param1,$param2); break; case "events": events(); break; case "eventspage": eventspage($eventid); break; case "eventsadd": eventsadd(); break; case "eventssent": eventssent(); break; case "shopdirectory": shopdirectory(); break; case "modelclubadd": modelclubadd(); break; case "modelclubsent": modelclubsent(); break; case "shopadd": shopadd(); break; case "shopsent": shopsent(); break; case "modelclubhome": modelclubhome(); break; case "blogs": blogs(); break; case "blogadd": blogadd(); break; case "blogsent": blogsent(); break; case "advertise": advertise(); break; case "searchresults": searchresults(); break; case "clubstown": clubstown($townid); break; case "addclubreview": addclubreview(); break; case "clubreviewsent": clubreviewsent(); break; case "countryredir": countryredir($param1); break; case "shopsaz": shopsaz($letter); break; } ?>