$db->query($q);    $db->next_record();    return True;  }  /**************************************************************************   * name: delete()   * created by:   * description:   * parameters:   * returns:   **************************************************************************/  function delete(&$d) {    $db = new ps_DB;        if (!$this->validate_delete($d)) {      return False;    }    /* Delete Image files */    if (!process_images($d)) {      return false;    }    $q = "DELETE from vendor where vendor_id='" . $d["vendor_id"] . "'";    $db->query($q);    $db->next_record();    return True;  }  /**************************************************************************  ** name: get_user_vendor_id  ** created by: jep  ** description:  ** parameters:  ** returns:  ***************************************************************************/  function get_user_vendor_id() {    global $auth;    $db = new ps_DB;    $q  = "SELECT vendor_id FROM auth_user_vendor ";    $q .= "WHERE user_id='" . $auth["user_id"] . "'";    $db->query($q);    $db->next_record();    return $db->f("vendor_id");  }  /**************************************************************************   * name: find()   * created by:   * description:   * parameters:   * returns:   **************************************************************************/  function find($d, $start=0) {    $db = new ps_DB;        if ($d["vendor_thumb_image"] == "none") {      $d["vendor_thumb_image"] = "";    }    if ($d["vendor_full_image"] == "none") {      $d["vendor_full_image"] = "";    }        if ($d["vendor_category_id"] == "0") {      $d["vendor_category_id"] = "";    }     $q = "SELECT * from vendor where vendor_name LIKE '%" . $d["vendor_name"] . "%'";    $q .= " AND contact_last_name LIKE '%" . $d["contact_last_name"] . "%'";    $q .= " AND contact_first_name LIKE '%" . $d["contact_first_name"] . "%'";    $q .= " AND contact_middle_name LIKE '%" . $d["contact_middle_name"] . "%'";    $q .= " AND contact_title LIKE '%" . $d["contact_title"] . "%'";    $q .= " AND contact_phone_1 LIKE '%" . $d["contact_phone_1"] . "%'";    $q .= " AND contact_phone_2 LIKE '%" . $d["contact_phone_2"] . "%'";    $q .= " AND contact_fax LIKE '%" . $d["contact_fax"] . "%'";    $q .= " AND contact_email LIKE '%" . $d["contact_email"] . "%'";    $q .= " AND vendor_phone LIKE '%" . $d["vendor_phone"] . "%'";    $q .= " AND vendor_address_1 LIKE '%" . $d["vendor_address_1"] . "%'";    $q .= " AND vendor_address_2 LIKE '%" . $d["vendor_address_2"] . "%'";    $q .= " AND vendor_city LIKE '%" . $d["vendor_city"] . "%'";    $q .= " AND vendor_state LIKE '%" . $d["vendor_state"] . "%'";    $q .= " AND vendor_country LIKE '%" . $d["vendor_country"] . "%'";    $q .= " AND vendor_zip LIKE '%" . $d["vendor_zip"] . "%'";    $q .= " AND vendor_store_name LIKE '%" . $d["vendor_store_name"] . "%'";    $q .= " AND vendor_store_desc LIKE '%" . $d["vendor_store_desc"] . "%'";    $q .= " AND vendor_category_id LIKE '%" . $d["vendor_category_id"] . "%'";    $q .= " AND vendor_thumb_image LIKE '%" . $d["vendor_thumb_image"] . "%'";    $q .= " AND vendor_full_image LIKE '%" . $d["vendor_full_image"] . "%'";    $q .= " AND vendor_currency LIKE '%" . $d["vendor_currency"] . "%'";    $db->query($q);    $db->next_record();    if ($db->num_rows() == 1) {      return "?vid=" . $db->f("vendor_id");    }    $t = new phpshop_Table;    $t->query = $q;    $t->table = "vendor";    $t->start = $start;    // Select fields to display    $t->fields = array(		       "vendor_id",		       "vendor_name",		       "vendor_store_desc"		       );        // Set column header names    $t->map_cols = array(			 "vendor_id" => "Vendor ID",			 "vendor_name" => "Vendor Name",			 "vendor_store_desc" => "Vendor Description"			 );    $t->show_table();        return True;  }  /**************************************************************************   * name: listVendor()   * created by:   * description: Creates a list of SELECT recods using vendor name and vendor id.   * parameters:   * returns: array of values   **************************************************************************/  function get_name($vendor_id,$product_id="") {    // Returns the vendor name corresponding to a vendor_id;    $db = new ps_DB;    if ($vendor_id) {      $q = "SELECT vendor_name FROM vendor WHERE vendor_id = '$vendor_id'";    } elseif ($product_id) {      $q  = "SELECT vendor_name FROM product,vendor ";      $q .= "WHERE product_id = '$product_id' ";      $q .= "AND product.vendor_id = vendor.vendor_id ";    } else {      /* ERROR: No arguments were specified. */      return 0;    }        $db->query($q);    $db->next_record();    return $db->f("vendor_name");  }  /**************************************************************************   * name: set_vendor()   * created by:   * description: Creates a list of SELECT recods using vendor name and vendor id.   * parameters:   * returns: array of values   **************************************************************************/  function set_vendor($d) {    global $ps_vendor_id, $sess;     $ps_vendor_id = $d["vendor_id"];    return True;  }  /**************************************************************************  ** name: listVendor()  ** created by:  ** description: Creates a list of SELECT recods using vendor name and   **              vendor id.  ** parameters:  ** returns: array of values  ***************************************************************************/  function list_vendor($vendor_id=0) {    global $ps_vendor_id, $sess;    // Creates a form drop down list and prints it    $db = new ps_DB;        $q = "SELECT count(*) as rowcnt FROM vendor ORDER BY vendor_name";    $db->query($q);    $db->next_record();    $rowcnt = $db->f("rowcnt");     // If only one vendor do not show list     if ($rowcnt == 1)        return True;    $q = "SELECT * FROM vendor ORDER BY vendor_name";    $db->query($q);       $code = "<form action=" . SECUREURL . " METHOD=POST>\n";    $code .= "<INPUT TYPE=hidden name=page value=admin/index>\n";    $code .= "<INPUT TYPE=hidden name=func value=setVendor>\n";    $code .= $sess->hidden_session() . "\n";    $code .= "<select name=vendor_id>\n";    while ($db->next_record()) {           $code .= "  <option value=\"" . $db->f("vendor_id") . "\"";      if ($db->f("vendor_id") == $vendor_id) { 	$code .= " selected";       }      $code .= ">" . $db->f("vendor_name") . "</option>\n";    }    $code .= "</select><BR>\n";    $code .= "<input type=submit name=go value=go>\n";    $code .= "</FONT>";    print $code;  }  /****************************************************************************   *    function: validate_email   *  created by: Gregory Day   * description: Validates an e-mail address.  Only checks that the format   *              is valid.  It does not validate that the address will   *              work.   *  parameters: $email: Email address to validate   *     returns: true: Email address is valid   *             false: Email address is not valid    ****************************************************************************/  function validate_email ( $email ) {   if(ereg('^[_a-z0-9-]+(\.[_a-z0-9-]+)*@[a-z0-9-]+(\.[a-z0-9-]+)*$', $email)) {      return(true);   }   else {      return(false);   }  } // validate_email()   /**************************************************************************  ** name: get_field  ** created by: pablo  ** description:  ** parameters:  ** returns:  ***************************************************************************/  function get_field($vendor_id, $field_name) {    $db = new ps_DB;    $q = "SELECT $field_name FROM vendor WHERE vendor_id='$vendor_id'";    $db->query($q);    if ($db->next_record()) {       return $db->f($field_name);    }    else {       return False;    }  }  /**************************************************************************  ** name: show_image()  ** created by: pablo  ** description:  Shows the image send in the $image field.  **               $args are appended to the IMG tag.  ** parameters:  ** returns:  ***************************************************************************/  function show_image($image, $args="") {        global $ps_vendor_id;       if ($SERVER_PORT == "443")        $url = SECUREURL;    else        $url = URL;     $url = $this->get_field($ps_vendor_id,"vendor_image_path");    $url .= "vendor/";    $url .= $image;    echo "<IMG SRC=$url $args>\n";        return True;  }}?>