GeoDirectory / geodirectory

    $sql = "SELECT site_title, asc_title, desc_title FROM " . GEODIR_CUSTOM_SORT_FIELDS_TABLE;

    $rows = $wpdb->get_results($sql);

    if (!empty($rows)) {

        foreach($rows as $row) {

            if (!empty($row->site_title))

                $translation_texts[] = stripslashes_deep($row->site_title);

            if (!empty($row->asc_title))

                $translation_texts[] = stripslashes_deep($row->asc_title);

            if (!empty($row->desc_title))

                $translation_texts[] = stripslashes_deep($row->desc_title);

        }

    }

	// Advance search filter fields table

	if (defined('GEODIR_ADVANCE_SEARCH_TABLE')) {

		$sql = "SELECT field_site_name, front_search_title, field_desc FROM " . GEODIR_ADVANCE_SEARCH_TABLE;

		$rows = $wpdb->get_results($sql);

		if (!empty($rows)) {

			foreach($rows as $row) {

				if (!empty($row->field_site_name))

					$translation_texts[] = stripslashes_deep($row->field_site_name);

				if (!empty($row->front_search_title))

					$translation_texts[] = stripslashes_deep($row->front_search_title);

				if (!empty($row->field_desc))

					$translation_texts[] = stripslashes_deep($row->field_desc);

			}

		}

	}

    $translation_texts = !empty($translation_texts) ? array_unique($translation_texts) : $translation_texts;