I wanted to try this out but my Load.php has no such lines of code
mem.buddy_list, mg.online_color AS member_group_color, IFNULL(mg.group_name, {string:blank_string}) AS member_group,
I can't find part of a query in ./Sources/Load.php that looks like that at all.
any idea why my Load.php is so different ?
We have the same problem, in our case it seems to be the "additional membergroups" mod that has changed 2 of the lines in Load.php that this mod also wants to alter.
Am I correct in assuming that it doesn't really matter where it is in the array of strings that is being called by the query only that it is in the array? Nor do you need to match the entire line?
would altering this part in modification.xml
<operation>
<search position="replace"><![CDATA[
mem.buddy_list, mg.online_color AS member_group_color, IFNULL(mg.group_name, {string:blank_string}) AS member_group,]]></search>
<add><![CDATA[
mem.buddy_list, mem.latitude, mem.longitude, mem.pindate, mg.online_color AS member_group_color, IFNULL(mg.group_name, {string:blank_string}) AS member_group,]]></add>
</operation>
<operation>
<search position="replace"><![CDATA[
mem.notify_types, lo.url, mg.online_color AS member_group_color, IFNULL(mg.group_name, {string:blank_string}) AS member_group,]]></search>
<add><![CDATA[
mem.notify_types, mem.latitude, mem.longitude, mem.pindate, lo.url, mg.online_color AS member_group_color, IFNULL(mg.group_name, {string:blank_string}) AS member_group,]]></add>
</operation>
to this:
<operation>
<search position="before"><![CDATA[
mem.karma_good, mem.id_post_group, mem.karma_bad, mem.lngfile, mem.id_group, mem.time_offset, mem.show_online,]]></search>
<add><![CDATA[
mem.latitude, mem.longitude, mem.pindate,]]></add>
</operation>
<operation>
<search position="replace"><![CDATA[
mem.notify_types,]]></search>
<add><![CDATA[
mem.notify_types, mem.latitude, mem.longitude, mem.pindate,]]></add>
</operation>
still work? (it does not error on install for us)
We had an old version in the past, but due to some errors after upgrading it stopped working, so got uninstalled, but the data remains in our database. I see we now need to set up some sort of payment option to get an API key?