Data at Your Fingertips: Explore Our New Reporting and Statistical Capabilities By Ryan Ashbrook Tuesday at 01:29 PM
NathanR Posted February 14, 2016 Share Posted February 14, 2016 Where can I find the g_title in 4.x of IP.Board? Doesn't seem to live in the core_groups table any longer. Link to comment Share on other sites More sharing options...
NathanR Posted February 14, 2016 Author Share Posted February 14, 2016 Found it in the core_sys_lang_words, but not seeing which fields to join that to core_groups ID. Link to comment Share on other sites More sharing options...
Daniel F Posted February 14, 2016 Share Posted February 14, 2016 The title is saved as language string because of the multi lang support. All the titles have a core_group_ prefix followed by the group id Link to comment Share on other sites More sharing options...
NathanR Posted February 14, 2016 Author Share Posted February 14, 2016 Thanks Daniel, got it worked out now. If anyone needs help with the query went with this. select g_id, word_default from core_sys_lang_words cs inner join core_groups g on replace(cs.word_key,'core_group_','') = g.g_id where word_key like 'core_group_%' order by g.g_id asc Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.