Customizing SMF > Mod Requests

Custom profile fields in Who is online and Memberlist

<< < (5/5)

Arantor:
An upgrade *probably* won't remove the additional columns but it will remove the code you've added. If it's in a mod package it might be alright, but it also might need a rewrite for 2.1 depending on if the devs decide a change is required to the code or not.

HunterP:

--- Quote from: Arantor on July 20, 2012, 07:06:30 PM ---An upgrade *probably* won't remove the additional columns but it will remove the code you've added. If it's in a mod package it might be alright, but it also might need a rewrite for 2.1 depending on if the devs decide a change is required to the code or not.

--- End quote ---

So far I got every mod working on every version, so that shouldn't be a big deal, thanks :)

HunterP:

--- Quote from: Arantor on July 20, 2012, 06:29:42 PM ---You could probably do it with casting and a LOT of work (one query per user)

--- End quote ---

One query per user? I was thinking of someting like this :

UPDATE smf_members m, smf_themes t SET m.newcolumn=t.value WHERE m.id_member=t.id_member AND t.variable='mycustomfield';

With or without casting, or might this not work?

Arantor:
Try it, but I've had trouble with multi-table queries like that in the past...

Mind you, you know all the answers, don't know why I'm bothering offering support.

Navigation

[0] Message Index

[*] Previous page