<?
# Setting up Classified Ads options:

# MySQL settings
# database name: 
$db_name="shrevepo_sbfdata1";
# host name:
$host_name="localhost";
# user's name:
$db_user="shrevepo_wp212";
# user's password:
$db_password="BuZ73@4u";
# name of database table for ads:
$table_ads="alcls";

# Set the base of the path of the directory where
# photos files will be kept.
$photos_path="photos/";

# Set the base to the URL of the directory where
# all photos files will be kept. 
$photos_url="photos/";

# Admin password and e-mail
$adm_passw="BuZ73@4u";
$adm_email="contactus@shreveport-bossierfilm.com";

# Users must  pay by on-line credit card processing before they place
# an ad ( yes, no). For Almond Classifieds (E-commerce) version only !
$paymgtw="no"; 

# Only users who have their own ads in classifieds categories have an ability to post
# privacy mail to ad owners (yes, no). 
# For Almond Classifieds (E-commerce) version only !
$prmlsntb="no";

# Number of ads displayed in the index page
$adsonpage="20";

# Expiration period for ads (days)
$exp_period="9999";

# Set up moderating (yes, no)
$moderating="yes";

# Set up privacy mail (yes, no) 
$privacy_mail="yes";
# If privacy mail is set up , send copy of privacy messages 
# to admin (yes, no)
$sendcopytoadm="yes";
# If privacy mail is set up , redirect privacy messages 
# to admin (yes, no)
$redirtoadm="yes";

# Max number of photos allowed
$photos_count=5;

# Set max size for all photos on the second ad page
$phptomaxsize=150000;

# load prepared ads preview photo by users (yes, no)
$incl_prevphoto='no';
# Set max size for the preview photo
$prviewphotomax=75000;
# Include into img tag limits for preview photo (yes, no)
$prphotolimits="yes";
# If "yes" set up limits. If $height="" it means proportional
# photo's size with width equal $pr_lim_width
$pr_lim_height="";  $pr_lim_width="500";

# Create ads preview photos thumbnails by the script on the fly  
# from first photos loaded by users (.jpeg type only) (yes, no)
$prphscr='no';
# width for preview photos thumbnails;
$prphscrwdth='200';

# Includes into ads multimedia file (yes, no)
$incl_mtmdfile="no";
# Extension for multimedia file (wav, avi ...)
$multim_ext=".wav";
# Title for multimedia link on the second page
$multim_link="Voice";
# Max size for multimedia file ( bytes )
$mtmdfile_maxs="120000";

# Width of the second ad page (pixels)
$ad_second_width="700";
# Width of preview photos on the second ad page (pixels)
$prphscnd="200";

# Width of the top page (pixels) 
$top_page_width="800";
# Width of the index page (pixels) 
$ad_ind_width="800";

# Place on detailed ad page special link to search 
# all ads posted by the user ( search with the same contact e-mail )
# if user place more then 1 ad (yes, no)
$schallusrads='no';

# Membership settings 
# Make custome changes only if you have installed additional
# membership package (it can be purchased additionally). 
# Set up free (f) or membership (m) for access to ad second page  
$mbac_second='f';
# Set up free (f) or membership (m) for submitting new ads 
$mbac_addad='f';
# Set up free (f) or membership (m) for sending privacy mails
$mbac_sndml='f';


# Set up categories list

$categories=array(
'title_1' => "Crew/Vender Database",
'accom' =>array("Accommodations","set1"),
'accounts' =>array("Accountants & Auditors","set1"),
'actcoach' =>array("Acting Coach & Classes","set1"),
'advertagency' =>array("Advertising Agency","set1"),
'ADR' =>array("ADR/Looping","set1"),
'aerial' =>array("Aerial & Underwater Photography","set1"),
'aerialwk' =>array("Aerial Work Platforms and Condors","set1"),
'airservice' =>array("Air Service/Shuttles","set1"),
'aircrft' =>array("Aircraft","set1"),
'airshut' =>array("Airport Shuttle","set1"),
'Alter' =>array("Alternative Medicine/Acupuncture","set1"),
'Ambu' =>array("Ambulance/Medical Standby","set1"),
'Animalrent' =>array("Animal Rentals (Privatly Owned)","set1"),
'Animal' =>array("Animal Wranglers & Trainers","set1"),
'Anim' =>array("Animation","set1"),
'Anti' =>array("Antiques","set1"),
'Antiauto' =>array("Antique Automobile","set1"),
'Apart' =>array("Apartment Rental","set1"),
'Archi' =>array("Architect","set1"),
'Artdep' =>array("Art Department Coordinator","set1"),
'Artdir' =>array("Art Director","set1"),
'Artgal' =>array("Art Gallery","set1"),
'Artsup' =>array("Art Supplies","set1"),
'asicam1' =>array("Assistant Camera - 1st","set1"),
'asicam2' =>array("Assistant Camera - 2nd","set1"),
'asidir1' =>array("Assistant Director - 1st","set1"),
'asidir2' =>array("Assistant Director - 2nd","set1"),
'assopro' =>array("Associate Producer","set1"),
'attor' =>array("Attorney","set1"),
'attra' =>array("Attractions","set1"),
'audio' =>array("Audio Production","set1"),
'autoglas' =>array("Auto Glass Repair","set1"),
'autobody' =>array("Auto Paint & Body Repair","set1"),
'autoprops' =>array("Auto Props","set1"),
'autorent' =>array("Automobile Rentals","set1"),
'autorepair' =>array("Automotive  Repair","set1"),
'Banks' =>array("Banks","set1"),
'Banquet' =>array("Banquet Facility","set1"),
'Barricades' =>array("Barricades","set1"),
'Bed' =>array("Bed and Breakfast","set1"),
'Bodyg' =>array("Body Guard","set1"),
'Boomop' =>array("Boom Operator","set1"),
'Camcrnop' =>array("Camera Crane Operator","set1"),
'Camcrn' =>array("Camera Cranes","set1"),
'Camequ' =>array("Camera Equipment","set1"),
'Camcop' =>array("Camera Operators","set1"),
'Carp' =>array("Carpenter","set1"),
'Carriage' =>array("Carriage Service","set1"),
'Castasst' =>array("Casting Assistant","set1"),
'Castdir' =>array("Casting Director","set1"),
'Castfac' =>array("Casting Facility","set1"),
'Catering' =>array("Catering","set1"),
'Chambers' =>array("Chambers of Commerce","set1"),
'Childcare' =>array("Child Care","set1"),
'Chiropractor' =>array("Chiropractor", "set1"),
'Cinematographer' =>array("Cinematographer","set1"),
'Commercialprd' =>array("Commercial Production Services","set1"),
'Communication' =>array("Communication Service","set1"),
'Composer' =>array("Composer","set1"),
'Computer' =>array("Computer Services","set1"),
'Consservice' =>array("Concierge Service","set1"),
'Constrcor' =>array("Construction Coordinator","set1"),
'Constrfrm' =>array("Construction Foreman","set1"),
'Constrser' =>array("Construction Services/Supplies","set1"),
'Convention' =>array("Convention & Visitors Bureaus","set1"),
'Costumedes' =>array("Costume Designer","set1"),
'Costumer' =>array("Costumer","set1"),
'Craft' =>array("Craft Services","set1"),
'CreativePro' =>array("Creative Producer","set1"),
'Dailies' =>array("Dailies Projection","set1"),
'Daycare' =>array("Day Care","set1"),
'Deck' =>array("Deck Builders","set1"),
'Dentist' =>array("Dentist","set1"),
'Destination' =>array("Destination Management","set1"),
'Dialect' =>array("Dialect Coach","set1"),
'Digitalfx' =>array("Digital F/X","set1"),
'Digitalfxsup' =>array("Digital F/X Supervisor" ,"set1"),
'Digitalfxtech' =>array("Digital F/X Technician","set1"),
'Director' =>array("Director","set1"),
'Director2' =>array("Director - 2nd Unit","set1"),
'Directorpho' =>array("Director of Photography","set1"),
'Directorassi' =>array("Director's Assistant","set1"),
'Diver' =>array("Diver","set1"),
'Documentary' =>array("Documentary Production","set1"),
'Dolly' =>array("Dolly Grip","set1"),
'Drafting' =>array("Drafting Supplies","set1"),
'Driver' =>array("Driver","set1"),
'DroneOperator' =>array("Drone Operator","set1"),
'DroneServices' =>array("Drone Services","set1"),
'Drycln' =>array("Dry Cleaners","set1"),
'Editor' =>array("Editor","set1"),
'Editorassi' =>array("Editor - Assistant","set1"),
'Electrical' =>array("Electrical Equipment","set1"),
'Electrician' =>array("Electrician","set1"),
'Electronic' =>array("Electronic News Gathering (ENG)","set1"),
'Embroidery' =>array("Embroidery","set1"),
'Entertainment' =>array("Entertainment Industry Software","set1"),
'Environmental' =>array("Environmental Services","set1"),
'EPK' =>array("EPK Services","set1"),
'Equipment' =>array("Equipment Rental","set1"),
'Event' =>array("Event Planning & Rental","set1"),
'Expendable' =>array("Expendable Supplies","set1"),
'Facilities' =>array("Facilities - Sports & Concert Venue","set1"),
'Filmbroker' =>array("Film Broker","set1"),
'Filmdir' =>array("Film Direction","set1"),
'Filmfin' =>array("Film Financial Broker","set1"),
'Filmlab' =>array("Film Laboratory","set1"),
'Filmldr' =>array("Film Loader","set1"),
'Filmmag' =>array("Film Magazines & Publications","set1"),
'Filmoff' =>array("Film Office/Commission","set1"),
'Filmprd' =>array("Film Production Company","set1"),
'Filmrel' =>array("Film Related Organizations","set1"),
'Filmsupp' =>array("Film Support Services","set1"),
'Fire' =>array("Fire Alarms & Monitoring","set1"),
'FireArms' =>array("Fire Arms Rentals/Transfers","set1"),
'FireSafety' =>array("Fire/Safety Consulting","set1"),
'FishGu' =>array("Fishing/Hunting Guide","set1"),
'Flower' =>array("Flower Shops","set1"),
'Food' =>array("Food Stylist","set1"),
'Fuel' =>array("Fuel","set1"),
'Furniture' =>array("Furniture Rental","set1"),
'Gaffer' =>array("Gaffer","set1"),
'Generators' =>array("Generators","set1"),
'Gift' =>array("Gift Baskets","set1"),
'GiftWrapping' =>array("Gift Wrapping","set1"),
'Glass' =>array("Glass Service","set1"),
'Graphic' =>array("Graphic Design","set1"),
'Greensman' =>array("Greensman","set1"),
'Grip' =>array("Grip","set1"),
'Gripky' =>array("Grip - Key","set1"),
'Guilds' =>array("Guilds/Unions","set1"),
'Hair' =>array("Hair Stylist","set1"),
'Hardware' =>array("Hardware/Construction Supplies","set1"),
'Healthfit' =>array("Health/Fitness","set1"),
'Historical' =>array("Historical Re-creation Director","set1"),
'HotelExt' =>array("Hotel-Extended Stay","set1"),
'HotelSuites' =>array("Hotel/Suites","set1"),
'HVAC' =>array("HVAC","set1"),
'Hypnotherapist' =>array("Hypnotherapist","set1"),
'Ice' =>array("Ice Service","set1"),
'Infoservices' =>array("Information Services","set1"),
'Insurance' =>array("Insurance/Risk Management","set1"),
'Interior' =>array("Interior Designer","set1"),
'Internet' =>array("Internet Service","set1"),
'Janitorial' =>array("Janitorial Services","set1"),
'Jewelry' =>array("Jewelry","set1"),
'Job' =>array("Job Training/Continuing Education","set1"),
'Landscaping' =>array("Landscaping","set1"),
'Laundromat' =>array("Laundromat","set1"),
'Leadgr' =>array("Lead Greens","set1"),
'Lead' =>array("Lead Man","set1"),
'Legal' =>array("Legal Consultant/Coach","set1"),
'Lighting' =>array("Lighting Director","set1"),
'Lightingeq' =>array("Lighting Equipment","set1"),
'Limousine' =>array("Limousine Service","set1"),
'Lineprd' =>array("Line Producer","set1"),
'Locationmn' =>array("Location Manager","set1"),
'Locationsct' =>array("Location Scout","set1"),
'Locationsrv' =>array("Location Service","set1"),
'Locksmith' =>array("Locksmith","set1"),
'Makeup' =>array("Make-up Artist","set1"),
'Mani' =>array("Manicurist","set1"),
'Marine' =>array("Marine Equipment","set1"),
'Marketing' =>array("Marketing Services","set1"),
'Massage' =>array("Massage Therapist","set1"),
'Media' =>array("Media Relations","set1"),
'Medic' =>array("Medic/First Aid","set1"),
'Medicalcln' =>array("Medical Clinic","set1"),
'Medicaldrv' =>array("Medical Divers","set1"),
'Medicalstf' =>array("Medical Staffing","set1"),
'Medicaltch' =>array("Medical Technical Advisor","set1"),
'MentalHealth' =>array("Mental Health","set1"),
'Metal' =>array("Metal Sales and Works","set1"),
'Miscellaneous' =>array("Miscellaneous Crew","set1"),
'Ministry' =>array("Ministry","set1"),
'Model' =>array("Model Builder","set1"),
'Monogram' =>array("Monogramming","set1"),
'Motor' =>array("Motor Home/RV Rentals","set1"),
'Moving' =>array("Moving Company/Specialty Handler","set1"),
'Music' =>array("Music and Musicians","set1"),
'Musicasst' =>array("Music Assistant","set1"),
'Musiccn' =>array("Music Consultant","set1"),
'Musicsrv' =>array("Music Services","set1"),
'Musiccst' =>array("Musician Casting","set1"),
'Notary' =>array("Notary Public","set1"),
'Nurse' =>array("Nurse","set1"),
'Officespc' =>array("Office Space","set1"),
'Officesup' =>array("Office Supplies","set1"),
'Onlinemus' =>array("Online Music Service","set1"),
'Optical' =>array("Optical Services","set1"),
'Packaging' =>array("Packaging Materials","set1"),
'Painter' =>array("Painter","set1"),
'Payroll' =>array("Payroll Services","set1"),
'Personalasst' =>array("Personal Assistant","set1"),
'Personalchf' =>array("Personal Chef","set1"),
'Personaltrn' =>array("Personal Trainer","set1"),
'Pest' =>array("Pest Control","set1"),
'Photography' =>array("Photography","set1"),
'Physician' =>array("Physician","set1"),
'Picturefrm' =>array("Picture Framing","set1"),
'Pictureveh' =>array("Picture Vehicle Coordinator","set1"),
'Picturevhrnt' =>array("Picture Vehicle Rental","set1"),
'Plant' =>array("Plant/Floral Rentals","set1"),
'Portableac' =>array("Portable A/C, Cooling & Heating","set1"),
'Postprdco' =>array("Post Production Company","set1"),
'Postprdsup' =>array("Post Production Supervisor","set1"),
'Precision' =>array("Precision Driver","set1"),
'Pressure' =>array("Pressure Washing Service","set1"),
'Printer' =>array("Printer","set1"),
'Privateft' =>array("Private Fitness Facility","set1"),
'Private' =>array("Private Locations","set1"),
'Producer' =>array("Producer","set1"),
'Producerasst' =>array("Producer's Assistant","set1"),
'Product' =>array("Product Placement","set1"),
'Prdacc' =>array("Production Accountant","set1"),
'Prdasst' =>array("Production Assistant","set1"),
'Prdcom' =>array("Production Company","set1"),
'Prdcon' =>array("Production Controller","set1"),
'Prdcoor' =>array("Production Coordinator","set1"),
'Prddsn' =>array("Production Designer","set1"),
'Prdhse' =>array("Production House","set1"),
'Prdins' =>array("Production Insurance","set1"),
'Prdman' =>array("Production Manager","set1"),
'Prdoffasst' =>array("Production Office Assistant","set1"),
'Prodper' =>array("Production Personnel Service","set1"),
'Prodsec' =>array("Production Secretary","set1"),
'Prodser' =>array("Production Services","set1"),
'Prodsup' =>array("Production Supervisor","set1"),
'PromotionalProducts' =>array("Promotional Products","set1"),
'Propmst' =>array("Prop Master","set1"),
'Props' =>array("Props & Set Dressing","set1"),
'Propsrnt' =>array("Props Rental","set1"),
'Public' =>array("Public Relations","set1"),
'Real' =>array("Real Estate","set1"),
'Record' =>array("Record Labels","set1"),
'Recording' =>array("Recording Studio","set1"),
'Recreational' =>array("Recreational Vehicle Repair","set1"),
'Rehearsal' =>array("Rehearsal Space","set1"),
'Restaurants' =>array("Restaurants","set1"),
'Satellite' =>array("Satellite Service & Repair","set1"),
'Scenic' =>array("Scenic Artist","set1"),
'Script' =>array("Script Supervisor","set1"),
'Seamstress' =>array("Seamstress/Tailor","set1"),
'Security' =>array("Security","set1"),
'SecurityCom' =>array("Security Company","set1"),
'Setdec' =>array("Set Decorator","set1"),
'Setdes' =>array("Set Designer","set1"),
'Setdrs' =>array("Set Dresser","set1"),
'Settch' =>array("Set Teacher/Tutor","set1"),
'Ship' =>array("Shipping","set1"),
'Signwtr' =>array("Sign Writer","set1"),
'Signs' =>array("Signs/Neon","set1"),
'Site' =>array("Site Selection","set1"),
'Soundmx' =>array("Sound Mixer","set1"),
'Soundrec' =>array("Sound Recordist","set1"),
'Soundutl' =>array("Sound Utility","set1"),
'Spa' =>array("Spa","set1"),
'Specialev' =>array("Special Events Coordination","set1"),
'Specialfx' =>array("Special F/X Coordinator","set1"),
'Specialfxcoor' =>array("Special F/X Coordinator","set1"),
'Specialfxtech' =>array("Special F/X Technician","set1"),
'Specialv' =>array("Specialty Vehicle","set1"),
'Specialvh' =>array("Specialty Vehicle Fabrication","set1"),
'Staffing' =>array("Staffing Service","set1"),
'Standpnt' =>array("Stand-by Painter","set1"),
'Standin' =>array("Stand-in","set1"),
'Stationer' =>array("Stationer Store","set1"),
'Steadicam' =>array("Steadicam Operator","set1"),
'Stillpho' =>array("Still Photographer","set1"),
'Stock' =>array("Stock Footage","set1"),
'Storage' =>array("Storage & Warehousing","set1"),
'Storyboardart' =>array("Storyboard Artist","set1"),
'Studio' =>array("Studio/Sound Stage","set1"),
'Stunt' =>array("Stunt Coordinator","set1"),
'Stuntdriver' =>array("Stunt Driver","set1"),
'Stuntman' =>array("Stuntman","set1"),
'Support' =>array("Support Services","set1"),
'Talent' =>array("Talent Agency","set1"),
'Tanning' =>array("Tanning Salons","set1"),
'Tattoos' =>array("Tattoos/Specialty Make-up","set1"),
'Tax' =>array("Tax Credit Broker","set1"),
'Taxi' =>array("Taxi Service","set1"),
'Telephone' =>array("Telephone Systems","set1"),
'Teleprompter' =>array("Teleprompter","set1"),
'Temporary' =>array("Temporary Power","set1"),
'Tent' =>array("Tent Rentals","set1"),
'Tire' =>array("Tire Service & Repair","set1"),
'Title' =>array("Title Design","set1"),
'Towing' =>array("Towing & Recovery","set1"),
'Traffic' =>array("Traffic Control","set1"),
'Trailer' =>array("Trailer Rentals/Honey Wagons","set1"),
'Transcp' =>array("Transportation Captain","set1"),
'Transcoor' =>array("Transportation Coordinator","set1"),
'Transsrv' =>array("Transportation Service & Rental","set1"),
'Trans' =>array("Transportation Services","set1"),
'Travel' =>array("Travel Agency","set1"),
'Truck' =>array("Truck Rentals","set1"),
'Typing' =>array("Typing & Word Processing","set1"),
'Unit' =>array("Unit Production Manager","set1"),
'Vehicle' =>array("Vehicle Detailing & Wash","set1"),
'Vehicles' =>array("Vehicles","set1"),
'Veterinarian' =>array("Veterinarian","set1"),
'Video' =>array("Video Assist","set1"),
'Videocm' =>array("Video Camera Operator","set1"),
'Videodup' =>array("Video Duplication","set1"),
'Videoedt' =>array("Video Editing","set1"),
'Videographics' =>array("Video Graphics","set1"),
'Videoprd' =>array("Video Production Company","set1"),
'Videogrp' =>array("Videographer","set1"),
'Vintageaoto' =>array("Vintage Automobiles/Motorcycles","set1"),
'Vintageclth' =>array("Vintage Clothing","set1"),
'Visualeffprd' =>array("Visual Effects Producer","set1"),
'Visualeffsup' =>array("Visual Effects Supervisor","set1"),
'Visualefftech' =>array("Visual Effects Technician","set1"),
'Walkmed' =>array("Walk-in Medical Clinic","set1"),
'Wardrobeprs' =>array("Wardrobe Personnel","set1"),
'Wardrobesle' =>array("Wardrobe Sale & Rental","set1"),
'Wardrobesup' =>array("Wardrobe Supervisor","set1"),
'Webdesign' =>array("Web Design","set1"),
'Wireless' =>array("Wi-Fi Wireless Networks","set1"),
'Writer' =>array("Writer - Script/Screenwriter","set1"),
'Yoga' =>array("Yoga","set1"),

'title_3' => "Shreveport-Bossier Film - Housing",
'housing' =>array("Housing Index","set3" ),

'title_4' => "Shreveport-Bossier Film - Privately Owned Locations",
'locations' =>array("Locations Index","set4" ),

'title_5' => "Shreveport-Bossier Film - Warehouse/Office space",
'warehouse' =>array("Warehouse/Office Space Index","set5" ),

);

# Set up the sets of the fields for categories
$fields_sets=array (
'set1' => array (company,last_name,first_name,occupation,email,homeurl,imdburl,contact_phone,cell_phone,addr,city,state,zip_code,brief),

'set2' => array (company,last_name,first_name,occupation,email,homeurl,imdburl,contact_phone,cell_phone,city,state,brief),

'set3' => array (contact_name,contact_phone,cell_phone,email,homeurl,imdburl,office_phone,addr,city,state,zip_code,housing_addr,housing_city,housing_state,housing_zip_code,type,number_units,sq_foot,bed_rm,bath_rm,pool,price_month,date_avail,housing_desc),

'set4' => array (contact_name,contact_phone,cell_phone,email,homeurl,imdburl,office_phone,addr,city,state,zip_code,location_addr,location_city,location_state,location_zip_code,location_type,location_desc),

'set5' => array (contact_name,owner_name,contact_phone,cell_phone,email,homeurl,imdburl,office_phone,addr,city,state,zip_code,warehouse_addr,warehouse_city,warehouse_state,warehouse_zip_code,sq_foot,ceiling_ht,price_month,date_avail,warehouse_desc),
);

#  Set up description of ad fields used in all categories:
$ads_fields= array(

'last_name' => array('Last Name','12','nosearch','40:50','text','1','text'),
'first_name' => array('First Name','12','nosearch','40:50','text','1','text'),
'contact_name' => array('Contact Name','12','nosearch','40:50', 'text', '1','text'),
'owner_name' => array('Owner Name','12','nosearch','40:50', 'text', '1','text'),
'contact_phone' => array('Telephone','2','nosearch','40:50', 'text', '1','text'),
'office_phone' => array('Office Phone','2','nosearch','40:50', 'text', '1','text'),
'cell_phone' => array('Cell Number','2','nosearch','40:50', 'text', '1','text'),
'email' => array('Contact E-mail','00','nosearch','40:50', 'text', '1','text'),
'homeurl' => array('Website Address', '00','nosearch','40:50', 'text','0','text'),
'imdburl' => array('IMDB Address', '00','nosearch','40:50', 'text','0','text'),
'addr' => array('Address','2','nosearch','40:50', 'text', '1','text'),
'housing_addr' => array('Housing Address','2','nosearch','40:50', 'text', '1','text'),
'warehouse_addr' => array('Warehouse/Office Address','2','nosearch','40:50', 'text', '1','text'),
'location_addr' => array('Location Address','2','nosearch','40:50', 'text', '1','text'),
'passw' => array('Edit/delete password','00','nosearch','20:50', 'text','1','text'),
'city' => array('City','12','keyword','40:50','text','1','text'),
'housing_city' => array('City','2','keyword','40:50','text','1','text'),
'location_city' => array('City','2','keyword','40:50','text','1','text'),
'warehouse_city' => array('City','2','keyword','40:50','text','1','text'),
'state' => array('State','12','keyword','40:50','text','1','text'),
'housing_state' => array('State','2','keyword','40:50','text','1','text'),
'warehouse_state' => array('State','2','keyword','40:50','text','1','text'),
'location_state' => array('State','2','keyword','40:50','text','1','text'),
'zip_code' => array('Zip Code','2','keyword','40:50','text','1','text'),
'housing_zip_code' => array('Zip Code','2','keyword','40:50','text','1','text'),
'location_zip_code' => array('Zip Code','2','keyword','40:50','text','1','text'),
'warehouse_zip_code' => array('Zip Code','2','keyword','40:50','text','1','text'),
'ceiling_ht' => array('Ceiling Height (warehouse only)','2','keyword','40:50','text','1','text'),
'type' => array('Type of Housing','12','keyword','1:30','select', '1','text','<option>Apartment<option>Condo<option>Hotel/Suites<option>Townhouse<option>House' ),
'location_type' => array('Type of Location','12','keyword','1:30','select', '1','text',
'<option>Air Force Base<option>Airport<option>Arenas/Stadiums<option>Bars/Clubs<option>Bridges<option>Casinos<option>Cemetaries<option>Churches<option>Courthouse<option>Downtown<option>Farms<option>Golf Courses<option>Hotel/Motel<option>Horse Racing<option>Houses<option>Lake Houses<option>Libraries<option>Louisiana Boardwalk<option>Municipal Auditorium<option>Museums<option>Neighborhoods<option>Parks<option>Plantation<option>Prep School<option>Prisons<option>Public Art<option>Restaurants<option>Riverfront<option>Rivers/Lakes<option>Row Houses<option>Rural Roads<option>Schools<option>Small Town<option>Studioa/Offices<option>Other' ),
'number_units' => array('Number of Units','2','keyword','40:50','text','1','text'),
'sq_foot' => array('Square Footage','12','keyword','40:50','text','1','text'),
'bed_rm' => array('Bedrooms','2','keyword','40:50','text','1','text'),
'bath_rm' => array('Bathrooms','2','keyword','40:50','text','1','text'),
'pool' => array('Pool','2','keyword','1:30','select', '1','text','<option>Yes<option>No'),	
'price' =>  array('Price','12','minmax','10:30','text','1','integer'),
'price_month' => array('Price Per Month','2','nosearch','40:50','text','1','text'),
'date_avail' => array('Available As Of','2','nosearch','40:50','text','1','text'),
'company' => array('Company','2','nosearch','40:50','text', '1','text'),
'occupation' =>  array('Occupation','12','nosearch','40:50','text','1','text'),	
'moredetails' => array('More Details','2','nosearch','40:6:2000','textarea','1','text'),
'housing_desc' => array('Description','2','nosearch','40:5:1000','textarea','1','text'),
'location_desc' => array('Description','2','nosearch','40:5:1000','textarea','1','text'),
'warehouse_desc' => array('Description','2','nosearch','40:5:1000','textarea','1','text'),
'brief' => array('Describe experience or service offered','2','nosearch','40:5:1000','textarea','1','text'),);

# Set up short names of the fields which will be displayed 
# on the search form on the top page (it is necessary when search through all categories ) .
$allcatfields=array('title','brief','email','homeurl','imdburl', 'passw', 'company','city','state','contact_name');

# Using ads layer when user place mouse over details link on index page (yes, no)
$use_adslayer="no";

# Set up fields which will be placed on ads layers
$fields_layer=array('brief'=>'yes', 'contact_name'=>'yes','occupation'=>'yes','email'=>'yes','number_units'=>'yes','sq_foot'=>'yes','pool'=>'yes','housing_desc'=>'yes','warehouse_desc'=>'yes','location_desc'=>'yes');

# Place preview photo only on ads layer and do not place on ads index pages (yes)
# Place preview photo on both ads layer and on ads index pages (no)
$prwph_layer="yes"; 

# width for preview photo on ads layers ( for thumbnails created by the script on the fly)
$prwdly='200'; 


# Set up default value for fields with type 'select'
$select_text="Please choose one";

# Set up format for displaying fields with real type
$real_format="%01.2f"; 

# Set up html header for all pages
$html_header= "
<head>
	<title>Vendor &#038; Crew Directory &#8211; Film Shreveport-Bossier</title>
<link rel='dns-prefetch' href='//www.google.com' />
<link rel='dns-prefetch' href='//fonts.googleapis.com' />
<link rel='dns-prefetch' href='//s.w.org' />
<!-- Business Directory RSS feed -->
<!-- /Business Directory RSS feed -->
<link rel='stylesheet' id='dashicons-css'  href='http://shreveport-bossierfilm.com/wp-includes/css/dashicons.min.css?ver=4.9.8' type='text/css' media='all' />
<link rel='stylesheet' id='admin-bar-css'  href='http://shreveport-bossierfilm.com/wp-includes/css/admin-bar.min.css?ver=4.9.8' type='text/css' media='all' />
<link rel='stylesheet' id='animate-css'  href='http://shreveport-bossierfilm.com/wp-content/plugins/fresh-framework//framework/themes/builder/metaBoxThemeBuilder/assets/freshGrid/extern/animate.css/animate.min.css?ver=1.34.0' type='text/css' media='all' />
<link rel='stylesheet' id='ff-freshgrid-css'  href='http://shreveport-bossierfilm.com/wp-content/plugins/fresh-framework//framework/themes/builder/metaBoxThemeBuilder/assets/freshGrid/freshGrid.css?ver=1.34.0' type='text/css' media='all' />
<link rel='stylesheet' id='rs-plugin-settings-css'  href='http://shreveport-bossierfilm.com/wp-content/plugins/revslider/public/assets/css/settings.css?ver=5.4.3.1' type='text/css' media='all' />
<style id='rs-plugin-settings-inline-css' type='text/css'>
#rs-demo-id {}
</style>
<link rel='stylesheet' id='bootstrap-css'  href='http://shreveport-bossierfilm.com/wp-content/themes/ark/assets/plugins/bootstrap/css/bootstrap.min.css?ver=3.3.6' type='text/css' media='all' />
<link rel='stylesheet' id='jquery.mCustomScrollbar-css'  href='http://shreveport-bossierfilm.com/wp-content/themes/ark/assets/plugins/scrollbar/jquery.mCustomScrollbar.css?ver=3.1.12' type='text/css' media='all' />
<link rel='stylesheet' id='owl.carousel-css'  href='http://shreveport-bossierfilm.com/wp-content/themes/ark/assets/plugins/owl-carousel/assets/owl.carousel.css?ver=1.3.2' type='text/css' media='all' />
<link rel='stylesheet' id='magnific-popup-css'  href='http://shreveport-bossierfilm.com/wp-content/themes/ark/assets/plugins/magnific-popup/magnific-popup.css?ver=1.1.0' type='text/css' media='all' />
<link rel='stylesheet' id='cubeportfolio-css'  href='http://shreveport-bossierfilm.com/wp-content/themes/ark/assets/plugins/cubeportfolio/css/cubeportfolio.min.css?ver=3.8.0' type='text/css' media='all' />
<link rel='stylesheet' id='freshframework-font-awesome4-css'  href='http://shreveport-bossierfilm.com/wp-content/plugins/fresh-framework/framework/extern/iconfonts/ff-font-awesome4/ff-font-awesome4.css?ver=4.9.8' type='text/css' media='all' />
<link rel='stylesheet' id='freshframework-font-et-line-css'  href='http://shreveport-bossierfilm.com/wp-content/plugins/fresh-framework/framework/extern/iconfonts/ff-font-et-line/ff-font-et-line.css?ver=4.9.8' type='text/css' media='all' />
<link rel='stylesheet' id='freshframework-simple-line-icons-css'  href='http://shreveport-bossierfilm.com/wp-content/plugins/fresh-framework/framework/extern/iconfonts/ff-font-simple-line-icons/ff-font-simple-line-icons.css?ver=4.9.8' type='text/css' media='all' />
<link rel='stylesheet' id='ark-one-page-business-css'  href='http://shreveport-bossierfilm.com/wp-content/themes/ark/assets/css/one-page-business.css?ver=4.9.8' type='text/css' media='all' />
<link rel='stylesheet' id='ark-landing-css'  href='http://shreveport-bossierfilm.com/wp-content/themes/ark/assets/css/landing.css?ver=4.9.8' type='text/css' media='all' />
<link rel='stylesheet' id='ark-style-css'  href='http://shreveport-bossierfilm.com/wp-content/themes/ark/style.css?ver=4.9.8' type='text/css' media='all' />
<style id='ark-style-inline-css' type='text/css'>
body,p,.ff-richtext,li,li a,a,h1, h2, h3, h4, h5, h6 ,.progress-box-v1 .progress-title,.progress-box-v2 .progress-title,.team-v5-progress-box .progress-title,.pricing-list-v1 .pricing-list-v1-header-title,.team-v3 .progress-box .progress-title,.rating-container .caption > .label,.theme-portfolio .cbp-l-filters-alignRight,.theme-portfolio .cbp-l-filters-alignLeft,.theme-portfolio .cbp-l-filters-alignCenter,.theme-portfolio .cbp-filter-item,.theme-portfolio .cbp-l-loadMore-button .cbp-l-loadMore-link,.theme-portfolio .cbp-l-loadMore-button .cbp-l-loadMore-button-link,.theme-portfolio .cbp-l-loadMore-text .cbp-l-loadMore-link,.theme-portfolio .cbp-l-loadMore-text .cbp-l-loadMore-button-link,.theme-portfolio-v2 .cbp-l-filters-alignRight .cbp-filter-item,.theme-portfolio-v3 .cbp-l-filters-button .cbp-filter-item,.zeus .tp-bullet-title{font-family:'Roboto',Arial,sans-serif}

.blog-classic .blog-classic-label,.blog-classic .blog-classic-subtitle,.blog-grid .blog-grid-title-el,.blog-grid .blog-grid-title-el .blog-grid-title-link,.blog-grid .blog-grid-supplemental-title,.op-b-blog .blog-grid-supplemental-title,.blog-grid .blog-grid-supplemental-category,.blog-grid-supplemental .blog-grid-supplemental-title a,.blog-teaser .blog-teaser-category .blog-teaser-category-title,.blog-teaser .blog-teaser-category .blog-teaser-category-title a,.news-v8 .news-v8-category a,.news-v1 .news-v1-heading .news-v1-heading-title > a,.news-v1 .news-v1-quote:before,.news-v2 .news-v2-subtitle,.news-v2 .news-v2-subtitle a,.ff-news-v3-meta-data,.ff-news-v3-meta-data a,.news-v3 .news-v3-content .news-v3-subtitle,.news-v6 .news-v6-subtitle,.news-v7 .news-v7-subtitle,.news-v8 .news-v8-category,.blog-simple-slider .op-b-blog-title,.blog-simple-slider .op-b-blog-title a,.heading-v1 .heading-v1-title,.heading-v1 .heading-v1-title p,.testimonials-v7 .testimonials-v7-title .sign,.team-v3 .team-v3-member-position,.heading-v1 .heading-v1-subtitle,.heading-v1 .heading-v1-subtitle p,.heading-v2 .heading-v2-text,.heading-v2 .heading-v2-text p,.heading-v3 .heading-v3-text,.heading-v3 .heading-v3-text p,.heading-v4 .heading-v4-subtitle,.heading-v4 .heading-v4-subtitle p,.newsletter-v2 .newsletter-v2-title span.sign,.quote-socials-v1 .quote-socials-v1-quote,.quote-socials-v1 .quote-socials-v1-quote p,.sliding-bg .sliding-bg-title,.timeline-v4 .timeline-v4-subtitle, .timeline-v4 .timeline-v4-subtitle a,.counters-v2 .counters-v2-subtitle,.icon-box-v2 .icon-box-v2-body-subtitle,.i-banner-v1 .i-banner-v1-heading .i-banner-v1-member-position,.i-banner-v1 .i-banner-v1-quote,.i-banner-v3 .i-banner-v3-subtitle,.newsletter-v2 .newsletter-v2-title:before,.piechart-v1 .piechart-v1-body .piechart-v1-body-subtitle,.pricing-list-v1 .pricing-list-v1-body .pricing-list-v1-header-subtitle,.pricing-list-v2 .pricing-list-v2-header-title,.pricing-list-v3 .pricing-list-v3-text,.promo-block-v2 .promo-block-v2-text,.promo-block-v2 .promo-block-v2-text p,.promo-block-v3 .promo-block-v3-subtitle,.services-v1 .services-v1-subtitle,.services-v10 .services-v10-no,.services-v11 .services-v11-subtitle,.slider-block-v1 .slider-block-v1-subtitle,.team-v3 .team-v3-header .team-v3-member-position,.team-v4 .team-v4-content .team-v4-member-position,.testimonials-v1 .testimonials-v1-author-position,.testimonials-v3 .testimonials-v3-subtitle:before,.testimonials-v3 .testimonials-v3-subtitle span.sign,.testimonials-v3 .testimonials-v3-author,.testimonials-v5 .testimonials-v5-quote-text,.testimonials-v5 .testimonials-v5-quote-text p,.testimonials-v6 .testimonials-v6-element .testimonials-v6-position,.testimonials-v6 .testimonials-v6-quote-text,.testimonials-v6 .testimonials-v6-quote-text p,.testimonials-v7 .testimonials-v7-title:before,.testimonials-v7 .testimonials-v7-author,.testimonials-v7-title-span,.footer .footer-testimonials .footer-testimonials-quote:before,.animated-headline-v1 .animated-headline-v1-subtitle,.news-v3 .news-v3-content .news-v3-subtitle,.news-v3 .news-v3-content .news-v3-subtitle a,.theme-ci-v1 .theme-ci-v1-item .theme-ci-v1-title{font-family:'Droid Serif',Arial,sans-serif}

code, kbd, pre, samp{font-family:'Courier New', Courier, monospace,Arial,sans-serif}

.custom-font-1{font-family:Arial, Helvetica, sans-serif,Arial,sans-serif}

.custom-font-2{font-family:Arial, Helvetica, sans-serif,Arial,sans-serif}

.custom-font-3{font-family:Arial, Helvetica, sans-serif,Arial,sans-serif}

.custom-font-4{font-family:Arial, Helvetica, sans-serif,Arial,sans-serif}

.custom-font-5{font-family:Arial, Helvetica, sans-serif,Arial,sans-serif}

.custom-font-6{font-family:Arial, Helvetica, sans-serif,Arial,sans-serif}

.custom-font-7{font-family:Arial, Helvetica, sans-serif,Arial,sans-serif}

.custom-font-8{font-family:Arial, Helvetica, sans-serif,Arial,sans-serif}

.fg-container-small { width: 100%; padding-left: 15px; padding-right: 15px; }
.fg-container-medium { width: 100%; padding-left: 15px; padding-right: 15px; }
.fg-container-large { width: 100%; padding-left: 15px; padding-right: 15px; }
.fg-container-fluid, .ark-boxed__boxed-wrapper, .ark-boxed__boxed-wrapper .ark-header { width: 100%; padding-left: 15px; padding-right: 15px; }

@media (min-width: 768px){
.fg-container-small { width: 750px; padding-left: 15px; padding-right: 15px; }
.fg-container-medium { width: 750px; padding-left: 15px; padding-right: 15px; }
.fg-container-large { width: 750px; padding-left: 15px; padding-right: 15px; }
.fg-container-fluid, .ark-boxed__boxed-wrapper, .ark-boxed__boxed-wrapper .ark-header { width: 100%; padding-left: 15px; padding-right: 15px; }
}

@media (min-width: 992px){
.fg-container-small { width: 750px; padding-left: 15px; padding-right: 15px; }
.fg-container-medium { width: 970px; padding-left: 15px; padding-right: 15px; }
.fg-container-large { width: 970px; padding-left: 15px; padding-right: 15px; }
.fg-container-fluid, .ark-boxed__boxed-wrapper, .ark-boxed__boxed-wrapper .ark-header { width: 100%; padding-left: 15px; padding-right: 15px; }
}

@media (min-width: 1200px){
.fg-container-small { width: 750px; padding-left: 15px; padding-right: 15px; }
.fg-container-medium { width: 970px; padding-left: 15px; padding-right: 15px; }
.fg-container-large { width: 1170px; padding-left: 15px; padding-right: 15px; }
.fg-container-fluid, .ark-boxed__boxed-wrapper, .ark-boxed__boxed-wrapper .ark-header { width: 100%; padding-left: 15px; padding-right: 15px; }
}

</style>
<link rel='stylesheet' id='ark-style-child-css'  href='http://shreveport-bossierfilm.com/wp-content/themes/ark-child/style.css?ver=4.9.8' type='text/css' media='all' />
<link rel='stylesheet' id='ark-google-fonts-css'  href='//fonts.googleapis.com/css?family=Roboto%3A300%2C400%2C500%2C600%2C700%2C300i%2C400i%2C700i%7CDroid+Serif%3A300%2C400%2C500%2C600%2C700%2C300i%2C400i%2C700i&#038;subset=cyrillic%2Ccyrillic-ext%2Cgreek%2Cgreek-ext%2Clatin%2Clatin-ext%2Cvietnamese&#038;ver=1.34.0' type='text/css' media='all' />
<link rel='stylesheet' id='ark-colors-css'  href='http://shreveport-bossierfilm.com/wp-content/uploads/freshframework/css/colors.css?ver=4.9.8' type='text/css' media='all' />
<link rel='stylesheet' id='twentytwenty-css'  href='http://shreveport-bossierfilm.com/wp-content/themes/ark/assets/plugins/twentytwenty/css/twentytwenty.css?ver=4.9.8' type='text/css' media='all' />
<link rel='stylesheet' id='wpbdp-widgets-css'  href='http://shreveport-bossierfilm.com/wp-content/plugins/business-directory-plugin/assets/css/widgets.min.css?ver=5.3.2.1' type='text/css' media='all' />
<link rel='stylesheet' id='wpbdp-dnd-upload-css'  href='http://shreveport-bossierfilm.com/wp-content/plugins/business-directory-plugin/assets/css/dnd-upload.min.css?ver=5.3.2.1' type='text/css' media='all' />
<link rel='stylesheet' id='wpbdp-js-select2-css-css'  href='http://shreveport-bossierfilm.com/wp-content/plugins/business-directory-plugin/vendors/select2-4.0.3/css/select2.min.css?ver=4.0.3' type='text/css' media='all' />
<link rel='stylesheet' id='wpbdp-base-css-css'  href='http://shreveport-bossierfilm.com/wp-content/plugins/business-directory-plugin/assets/css/wpbdp.min.css?ver=5.3.2.1' type='text/css' media='all' />
<link rel='stylesheet' id='default-styles-css'  href='http://shreveport-bossierfilm.com/wp-content/plugins/business-directory-plugin/themes/default/assets/styles.css?ver=4.0.4' type='text/css' media='all' />
<script type='text/javascript' src='http://shreveport-bossierfilm.com/wp-includes/js/jquery/jquery.js?ver=1.12.4'></script>
<script type='text/javascript' src='http://shreveport-bossierfilm.com/wp-includes/js/jquery/jquery-migrate.min.js?ver=1.4.1'></script>
<script type='text/javascript' src='http://shreveport-bossierfilm.com/wp-content/plugins/revslider/public/assets/js/jquery.themepunch.tools.min.js?ver=5.4.3.1'></script>
<script type='text/javascript' src='http://shreveport-bossierfilm.com/wp-content/plugins/revslider/public/assets/js/jquery.themepunch.revolution.min.js?ver=5.4.3.1'></script>
<!--[if lt IE 9]>
<script type='text/javascript' src='http://shreveport-bossierfilm.com/wp-content/themes/ark/assets/plugins/html5shiv.js?ver=3.7.3'></script>
<![endif]-->
<!--[if lt IE 9]>
<script type='text/javascript' src='http://shreveport-bossierfilm.com/wp-content/themes/ark/assets/plugins/respond.min.js?ver=1.1.0'></script>
<![endif]-->
<script type='text/javascript' src='http://shreveport-bossierfilm.com/wp-includes/js/jquery/ui/widget.min.js?ver=1.11.4'></script>
<script type='text/javascript' src='http://shreveport-bossierfilm.com/wp-content/plugins/business-directory-plugin/vendors/jQuery-File-Upload-9.5.7/js/jquery.iframe-transport.min.js?ver=9.5.7'></script>
<script type='text/javascript' src='http://shreveport-bossierfilm.com/wp-content/plugins/business-directory-plugin/vendors/jQuery-File-Upload-9.5.7/js/jquery.fileupload.min.js?ver=9.5.7'></script>
<script type='text/javascript' src='http://shreveport-bossierfilm.com/wp-content/plugins/business-directory-plugin/assets/js/dnd-upload.min.js?ver=5.3.2.1'></script>
<script type='text/javascript' src='http://shreveport-bossierfilm.com/wp-content/plugins/business-directory-plugin/vendors/jquery-breakpoints.min.js?ver=0.0.11'></script>
<script type='text/javascript' src='http://shreveport-bossierfilm.com/wp-content/plugins/business-directory-plugin/vendors/select2-4.0.3/js/select2.full.min.js?ver=4.0.3'></script>
<script type='text/javascript' src='http://shreveport-bossierfilm.com/wp-includes/js/jquery/ui/core.min.js?ver=1.11.4'></script>
<script type='text/javascript' src='http://shreveport-bossierfilm.com/wp-includes/js/jquery/ui/mouse.min.js?ver=1.11.4'></script>
<script type='text/javascript' src='http://shreveport-bossierfilm.com/wp-includes/js/jquery/ui/sortable.min.js?ver=1.11.4'></script>
<script type='text/javascript' src='http://shreveport-bossierfilm.com/wp-includes/js/jquery/ui/datepicker.min.js?ver=1.11.4'></script>
<script type='text/javascript'>
<script type='text/javascript' src='http://shreveport-bossierfilm.com/wp-content/plugins/business-directory-plugin/assets/js/wpbdp.min.js?ver=5.3.2.1'></script>
<script type='text/javascript' src='https://www.google.com/recaptcha/api.js?onload=wpbdp_recaptcha_callback&#038;render=explicit&#038;ver=4.9.8'></script>
<link rel='https://api.w.org/' href='http://shreveport-bossierfilm.com/wp-json/' />
<link rel='shortlink' href='http://shreveport-bossierfilm.com/?p=1495' />
		</script>

</head>


";
# Set up html footer  for all pages
$html_footer="

		
";
# Set up info for left column on the top page:
# It should begin with html tag <td> and finish with tag </td>
$top_leftcol="
"; 
# Set up info for left column on the ads index page:
# It should begin with html tag <td> and finish with tag </td>
$ind_leftcol="
"; 
# Set up info for left column on the  page with ads details:
# It should begin with html tag <td> and finish with tag </td>
$detl_leftcol="
"; 
########################################################################################
require("sfmd.php");
$v_ck_pgt1="1"; $v_ck_pgt2="2"; $v_ck_pmst="ok"; $v_ck_pmst1="a1";
?><?


function get_short_date($time1)

{

$d=getdate($time1);

$months =array('Jan', 'Feb', 'Mar', 'Apr', 'May', 'Jun',

'Jul', 'Aug', 'Sept', 'Oct', 'Nov', 'Dec');

$d2=$d['mon'];

$date_string=$months[$d2-1]." ".$d['mday'];

return $date_string;

}

// set the default timezone to use. Available since PHP 5.1

date_default_timezone_set('UTC');

function get_ads_count()

{

global $cat_fields, $table_ads, $ct, $page,$adsonpage, $html_header, $html_footer;  

$where_string=get_where_string();

$sql_query="select count(idnum) from $table_ads where 

$where_string ";


if( !($sql_res=@mysql_query("$sql_query")))

{echo $html_header;

echo "

<center>

<font FACE='ARIAL, HELVETICA'  COLOR='#bb0000' size=-1><b>

Error in connecting to ads MySQL table <font color='#000099'>'$table_ads'</font>.

<br> Seems, this table is not created, 

<a href='createtb.php'>click here </a> to create this table.

 
</b></font></center>

";

echo $html_footer;

exit;

}


$row=mysql_fetch_row($sql_res);

$count=$row[0];

return $count;

}


function get_ads()

{

global $cat_fields, $table_ads,$ct,   $page,$adsonpage, $ratedads; 

if ($ratedads=="1"){$ord_ratedads="adrate desc,";}

$html_ads="";

$start_num=($page-1)*$adsonpage; 

if($page=="")$start_num=0;

$where_string=get_where_string();

$sql_query="select * from $table_ads where $where_string 

order by $ord_ratedads idnum desc limit $start_num, $adsonpage";


$sql_res=mysql_query("$sql_query");

# $html_ads=$html_ads."<p>";

while ($row = mysql_fetch_array ($sql_res))

{

$html_ads=$html_ads.print_ad($row);

} 

return $html_ads;

}


function get_where_string()

{

global $cat_fields, $ct, $table_ads, $HTTP_GET_VARS, $text_userinfo;

$adctnm1="visible=1 and ";

if ($HTTP_GET_VARS['visunvis'] == "1") {$adctnm1="";}

if ($HTTP_GET_VARS['ct'] != "")

{

$adctnm1=$adctnm1."catname='$ct' and ";

}


$where_string=$adctnm1;

$tm_check=time() - $HTTP_GET_VARS['before']*86400;


if ($HTTP_GET_VARS['before'] != "")

{$where_string=$where_string."time > $tm_check and "; 

}


if ($HTTP_GET_VARS['idemail'] != "")

{

$var_idemail=$HTTP_GET_VARS['idemail'];

$sql_query="select email from $table_ads where idnum='$var_idemail'";

$sql_res=mysql_query("$sql_query");

$row = mysql_fetch_row($sql_res);

$searchemail=$row[0];

$where_string=$where_string."email='$searchemail' and "; 

$text_userinfo="

<font FACE='ARIAL, HELVETICA' COLOR='#000099' font size='-1'>

<b>Ads posted by the same user</b>

</font>

";

}


if ($HTTP_GET_VARS['mblogin'] != "")

{$where_string=$where_string."login='".$HTTP_GET_VARS['mblogin']."' and ";

$text_userinfo="

<font FACE='ARIAL, HELVETICA' COLOR='#000099' font size='-1'>

Ads posted by member <b>'".$HTTP_GET_VARS['mblogin']."'</b>

</font>

";

}


if ($HTTP_GET_VARS['ratedads'] != "")

{$where_string=$where_string."adrate > 0 and ";

}


if ($HTTP_GET_VARS['onlywithphoto'] != "")

{$where_string=$where_string."adphotos='yes' and ";

}


if ($HTTP_GET_VARS['idnum'] != "") 

{$where_string=$where_string."idnum =".$HTTP_GET_VARS['idnum']." and ";

 }


if ($HTTP_GET_VARS['brief_key'] != "") 

{$where_string=$where_string.

"(brief like '%".$HTTP_GET_VARS['brief_key']."%' or title like '%".$HTTP_GET_VARS['brief_key']."%') and ";

 }


 foreach ($cat_fields as $key => $value )

{


if($cat_fields[$key][2] == "keyword") 

{

 
if ($HTTP_GET_VARS[$key] != "") {

$where_string=$where_string."$key like '%".$HTTP_GET_VARS[$key]."%' and ";

 }

}

if($cat_fields[$key][2] == "minmax")

{

$flmin=$key."1";

$flmax=$key."2";

if (($HTTP_GET_VARS[$flmin] != "") and ($HTTP_GET_VARS[$flmax] != "")) 

{

$HTTP_GET_VARS[$flmin]=ereg_replace(',', '', $HTTP_GET_VARS[$flmin]);

$HTTP_GET_VARS[$flmax]=ereg_replace(',', '', $HTTP_GET_VARS[$flmax]);


$HTTP_GET_VARS[$flmin]=preg_replace ('/[A-Za-z]|\$|,|\?|\+/', "", $HTTP_GET_VARS[$flmin]);

$HTTP_GET_VARS[$flmax]=preg_replace ('/[A-Za-z]|\$|,|\?|\+/', "", $HTTP_GET_VARS[$flmax]);


$where_string=$where_string."$key >= ".$HTTP_GET_VARS[$flmin]."

 and $key <= ".$HTTP_GET_VARS[$flmax]." and ";

}

}

}


$where_string=corr_wherestring($where_string);

if ($HTTP_GET_VARS['mfvrt']=='1'){$where_string=view_fv_ads();}

return $where_string;

}


function corr_wherestring($string1)

{

$string1=$string1."fdspkdsanbf";

$db_dcf="and fdspkdsanbf";

$string1=str_replace($db_dcf,"",$string1);

return $string1;

}


function get_jpg_path($id_count)

{

global $photo_url, $photo_path,  

$photos_url, $photos_path, $photos_count,

$previewphoto_url, $previewphoto_path, $multimedia_path,

$multimedia_url, $multim_ext;


for ($i=1; $i<=$photos_count; $i++)

{

$photo_url[$i]=$photos_url."p".$id_count."n".$i.".jpg";

$photo_path[$i]=$photos_path."p".$id_count."n".$i.".jpg";

}


$previewphoto_url=$photos_url."p".$id_count."prw".".jpg";

$previewphoto_path=$photos_path."p".$id_count."prw".".jpg";


$multimedia_url=$photos_url."mtmd".$id_count.$multim_ext;

$multimedia_path=$photos_path."mtmd".$id_count.$multim_ext;

} 


function ads_pages_list()

{

global $ads_count, $adsonpage, $ct, $page, $idemail, $mblogin,  $ratedads, $visunvis;

$search_str=get_srch_str();

if ($idemail!=""){$search_str="idemail=$idemail";}

if ($mblogin!=""){

$search_str="mblogin=$mblogin";

if ($visunvis=="1"){$search_str="mblogin=$mblogin&visunvis=1";}

}

if ($ratedads=="1"){$search_str="ratedads=1";}

$num_pages=($ads_count-$ads_count%$adsonpage)/$adsonpage;

if ($ads_count%$adsonpage > 0) {$num_pages++;}

$list_pages="";

for ($i = 1; $i <= $num_pages; $i++) 

{

if ($i != $page){

$list_pages=$list_pages." [<a href='directory.php?ct=$ct&md=browse&page=$i&$search_str'>$i</a>]";

}

else

{

$list_pages=$list_pages." [<font color='#ee0000'>$i</font>]";

}

}

$list_pages="Listing:".$list_pages;

if ($ads_count == 0) $list_pages="";

return $list_pages;


}


function get_srch_str()

{

global $page, $ads_count, $adsonpage, $ct, $mds, $HTTP_GET_VARS;

$search_str="";

$mds_res=0;

if($HTTP_GET_VARS['mds'] == 'search')

{

foreach ($HTTP_GET_VARS as $key => $value)

{

if (($key !='md')  and ($key !='page') and ($key !='ct'))

{$mds_res=1;

$value=ereg_replace(' ', '+', $value);

$value=ereg_replace('@', '%40', $value);

$value=ereg_replace('!', '%21', $value);

$search_str=$search_str."$key=$value&";

}

}

}

if ($mds_res==0)

{

$mds="";

$HTTP_GET_VARS['mds']="";

}

return $search_str;


}


function pages_next_prev()

{

global $page, $ads_count, $adsonpage, $ct, $HTTP_GET_VARS, $idemail, $mblogin,

 $ratedads, $visunvis;

$search_str=get_srch_str();

if ($idemail!=""){$search_str="idemail=$idemail";}

if ($mblogin!=""){

$search_str="mblogin=$mblogin";

if ($visunvis=="1"){$search_str="mblogin=$mblogin&visunvis=1";}

}

if ($ratedads=="1"){$search_str="ratedads=1";}

$max_pages=($ads_count-$ads_count%$adsonpage)/$adsonpage;

if ($ads_count%$adsonpage > 0) {$max_pages++;}

$next_prev="";

if ($page>1)

{

$a1_prev=$page-1;

$next_prev=$next_prev.

"<a href='directory.php?ct=$ct&md=browse&page=$a1_prev&$search_str'>Previous</a>";

}

if($page==0)$page=1;

$next_prev=$next_prev." Page $page of $max_pages ";

$a1_next=$page+1;

$a2=$page*$adsonpage;

if ($a2 < $ads_count)

{

$next_prev=$next_prev.

"<a href='directory.php?ct=$ct&md=browse&page=$a1_next&$search_str'>Next</a>";

}

if ($ads_count == 0) $next_prev="";

return $next_prev;

}


function start()

{

global $ct,$ads_fields,$categories, $ads_count, $cat_fields,$fields_sets,$allcatfields;

connect_to_db();

$c_res1=0;

foreach ($categories as $key => $value)

{

if ($key == $ct ){$c_res1=1;}

}

if ($c_res1==0){

if ($ct !=""){

echo $html_header;

echo "<h3> Incorrect Cateogry </h3>";

echo $html_footer;

exit;

}

}

if ($ct!="")

{

$a1=$categories[$ct][1];

$a2=$fields_sets[$a1];

}

else 

{$a2=$allcatfields;}

foreach ($a2 as $a2_value)

{

$cat_fields[$a2_value]=$ads_fields[$a2_value];

}

 
$ads_count=get_ads_count();

}


function corr_sqlstring($string1)

{

$string1=$string1."fdspkdsnbf";

$db_dcf=", fdspkdsnbf";

$string1=str_replace($db_dcf,"",$string1);

return $string1;

}


function connect_to_db()

{

global $host_name, $db_user,$db_password, $html_header, 

$html_footer, $db_name, $table_ads;


if (!(@mysql_connect("$host_name","$db_user","$db_password")))

{echo $html_header;

echo "

<center>

<font FACE='ARIAL, HELVETICA'  COLOR='#bb0000' size=-1><b>

Error in connecting to your MySQL server.  <br> You need to set up  

correct values   for variables <br> \$host_name, \$db_user, \$db_password 

in the config.php file

</b></font></center>

";

echo $html_footer;

exit;

}

if (!(@mysql_select_db("$db_name")))

{echo $html_header;

echo "

<center>

<font FACE='ARIAL, HELVETICA'  COLOR='#bb0000' size=-1><b>

Error in connecting to your MySQL database <font color='#000099'>'$db_name'</font>.

<br> You need to set up 

correct database name in variables \$db_name of <br> the config.php file 

or create the database with such a name.

</b></font></center>

";

echo $html_footer;

exit;

}

}


?><?

$cookie_time=time()+3600000;
if ($HTTP_GET_VARS['mfvrt']=="add"){add_favorite();}
if ($HTTP_GET_VARS['mfvrt']=="rmv"){remove_favorite();}
if ($HTTP_GET_VARS['mfvrt']=="rmall"){remove_all();}
if ($HTTP_GET_VARS['mfvrt']=='1'){$adsonpage="100";}


function print_fav_ads_ind()
{
global $HTTP_COOKIE_VARS, $HTTP_GET_VARS;
if ($HTTP_COOKIE_VARS['ckfvr']!='')
{
$var="
<a href='directory.php?md=browse&mfvrt=1' >
<FONT FACE='Verdana,Geneva,Arial' SIZE=1 color='#990000'><b>
Your favorite ads</b></font>
</a>
  &nbsp; 
";

if ($HTTP_GET_VARS['mfvrt']=='1'){
$var="
 
<font FACE='ARIAL, HELVETICA' color='#000099' size='-1'><b>
Your favorite ads</b></font>
</a>
  &nbsp;  &nbsp;  
";
;}
}
return $var;
}

function print_add_fvrt()
{
global $HTTP_COOKIE_VARS, $HTTP_GET_VARS;
$mss_cookies=split(',',$HTTP_COOKIE_VARS['ckfvr']);

$ck_var=""; 
foreach ($mss_cookies as $cook_value)
{ 
if ($cook_value==$HTTP_GET_VARS['id']){$ck_var="1";}
}
if ($HTTP_GET_VARS['mfvrt']=='add'){$ck_var="1";}
if (($HTTP_GET_VARS['mfvrt']=='rmv') or ($HTTP_GET_VARS['mfvrt']=='rmall')){$ck_var="0";}


if ($ck_var=="1"){$var1="&nbsp;Favorite ad";}
else {$var1=
" &nbsp; <a href='directory.php?ct=".$HTTP_GET_VARS['ct']."&md=".$HTTP_GET_VARS['md']."&id=".$HTTP_GET_VARS['id']."&mfvrt=add'>
 Add to favorites</a>
";} 
$var="
<FONT FACE='Verdana,Geneva,Arial' SIZE=1 color='#000099'><b>
$var1  
</b></font>
";
return $var;
}


function print_fvrt_dtl()
{
global $HTTP_COOKIE_VARS, $HTTP_GET_VARS;
$mss_cookies=split(',',$HTTP_COOKIE_VARS['ckfvr']);

$ck_var=""; 
$ck_var2=""; 
foreach ($mss_cookies as $cook_value)
{ 
if ($cook_value==$HTTP_GET_VARS['id']){$ck_var="1";}
if ($cook_value!=""){$ck_var2="1";}
}

if ($HTTP_GET_VARS['mfvrt']=='add'){$ck_var="1";}
if (($HTTP_GET_VARS['mfvrt']=='rmv') or ($HTTP_GET_VARS['mfvrt']=='rmall')){$ck_var="0";}

if ($ck_var=="1"){
$var1="

<a href='directory.php?ct=".$HTTP_GET_VARS['ct']."&md=".$HTTP_GET_VARS['md']."&id=".$HTTP_GET_VARS['id']."&mfvrt=rmv'>
Remove this ad from favorites</a> &nbsp;&nbsp;

<a href='directory.php?ct=".$HTTP_GET_VARS['ct']."&md=".$HTTP_GET_VARS['md']."&id=".$HTTP_GET_VARS['id']."&mfvrt=rmall'>
Remove all favorites</a>&nbsp;
";
}
else {$var1=
"<a href='directory.php?ct=".$HTTP_GET_VARS['ct']."&md=".$HTTP_GET_VARS['md']."&id=".$HTTP_GET_VARS['id']."&mfvrt=add'>
Add this ad to favorite list</a>

";} 

$var2="";
if (($ck_var2=="1") and ($HTTP_GET_VARS['mfvrt']!="rmall")){
$var2="
<a href='directory.php?md=browse&mfvrt=1'>
Your favorite ads 
</a>
 &nbsp;
";
}
$var="
<FONT FACE='Verdana,Geneva,Arial' SIZE=1 color='#000099'><b>
$var2 $var1    
</b></font>
";
return $var;
}


function add_favorite()
{
global $HTTP_COOKIE_VARS, $HTTP_GET_VARS,$cookie_time;

$mss_cookies=split(',',$HTTP_COOKIE_VARS['ckfvr']);

$ck_var=""; 
foreach ($mss_cookies as $cook_value)
{ 
if ($cook_value==$HTTP_GET_VARS['id']){$ck_var="1";}
}

if ($ck_var!="1"){ 
$vfvr_cookie=$HTTP_COOKIE_VARS['ckfvr'].$HTTP_GET_VARS['id'].",";
setcookie ("ckfvr", $vfvr_cookie, $cookie_time);
}
}

function remove_favorite()
{
global $HTTP_COOKIE_VARS, $HTTP_GET_VARS;
$mss_cookies=split(',',$HTTP_COOKIE_VARS['ckfvr']);

$vfvr_cookie="";

foreach ($mss_cookies as $cook_value)
{ 
if (($cook_value!='') and ($cook_value!=$HTTP_GET_VARS['id']))
{$vfvr_cookie=$vfvr_cookie.$cook_value.",";}
 }
setcookie ("ckfvr", $vfvr_cookie, $cookie_time);
 
}

function remove_all()
{
setcookie ("ckfvr");
}

function view_fv_ads()
{
global $HTTP_COOKIE_VARS, $HTTP_GET_VARS;

$mss_cookies=split(',',$HTTP_COOKIE_VARS['ckfvr']);
$where_string1="";
foreach ($mss_cookies as $cook_value)
{ 
if ($cook_value!='')
{$where_string1=$where_string1."idnum=$cook_value or ";}
} 
 
$where_string1=$where_string1."fdkspkdsanbf";
$db_dcf="or fdkspkdsanbf";
$where_string1=ereg_replace($db_dcf,"",$where_string1);

if ($HTTP_COOKIE_VARS['ckfvr']==''){$where_string1="idnum=0 ";}
return $where_string1;
}

?>