Module

Developer
Supported

Sitemap Module

ExpressionEngine 3, ExpressionEngine 4, ExpressionEngine 5

Back to this add-on's main page
View Other Add-ons From PutYourLightsOn

     

You must be logged in to post.

For correct Links is a field from exp_channel_data

Support Request

Oepfel
Oepfel

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
# 1
Oepfel

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
# 2
Developer
PutYourLightsOn

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
# 3
Oepfel

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
# 4
Developer
PutYourLightsOn

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