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 );
|
|
|