Sitemap Module
ExpressionEngine 2, ExpressionEngine 3, ExpressionEngine 4, ExpressionEngine 5, ExpressionEngine 6
Back to this add-on's main page
View Other Add-ons From Brian Litzinger
For correct Links is a field from exp_channel_data
Support Request
|
Oepfel
|
| Posted: 23 October 2013 02:17 PM |
|
|
|
|
Hello,
because of our link structure we need the information out of a field from channed_data.
Is there anything possible to get that ?
greetings
|
|
|
|
|
Oepfel
|
| Posted: 29 October 2013 05:38 PM |
# 1
|
|
|
|
Sorry my English is not that good maybe my Problem wasn’t understood ?
Can I get Information database exp_channed_data field_id_68, without the links are not displayed correct.
Thanks
|
|
|
|
|
PutYourLightsOn
|
| Posted: 30 October 2013 03:55 PM |
# 2
|
|
|
|
sorry that i don’t quite understand what you are asking, but it seems to me that you need a custom field which is not possible.
|
|
|
|
|
Oepfel
|
| Posted: 31 October 2013 05:49 AM |
# 3
|
|
|
|
Ok our Problem is that the links are http://domain.de / field_id_60 from exp_channel_data / {url_title}
maybe this way it is better to understand.
We would pay for a workling hack ;)
greetings
|
|
|
|
|
PutYourLightsOn
|
| Posted: 06 November 2013 05:21 AM |
# 4
|
|
|
|
you should be able to achieve this with some small tweaks to the query. change line 131 to the following:
$entries = $this->EE->db->query("
SELECT edit_date, entry_date, exp_channel_titles.entry_id, url_title, exp_channel_titles.channel_id, exp_category_posts.cat_id, cat_name, cat_url_title, field_id_60 as city_url
FROM exp_channel_titles
LEFT JOIN exp_category_posts ON exp_channel_titles.entry_id = exp_category_posts.entry_id
LEFT JOIN exp_categories ON exp_category_posts.cat_id = exp_categories.cat_id
LEFT JOIN exp_channel_data ON exp_channel_data.entry_id = exp_channel_titles.entry_id
WHERE exp_channel_titles.channel_id = '".$channel_id."' AND exp_channel_titles.site_id = '".$site_id."' AND status IN (".$statuses.") AND (expiration_date = 0 OR expiration_date > ".time().")
GROUP BY entry_id
LIMIT ".$limit
);
|
|
|
|
