3 replies to this topic

[RichardC]

I posted this in 'general' as it probably involves running one or two SQL quieries.

I want to remove all existing signatures from a specific user group.

I then want to insert a new default formatted message in to the signature area for that user group

I plan to use this in conjunction with this mod HERE which will also have the same default message in it

thanks in advance

Richard

[Aloha]

try this query changing text to what you want and the ?? to the group number.

update ibf_member_extra set signature='what ever you want in here' where id in (select id from ibf_members where mgroup='??')

Always backup any table before running an sql command agianst it.

[RichardC]

thanks Aloha, I will give this a go

can you, or anyone else tell me if

Quote

'what ever you want in here'

will support full formatted text, such as:

[color="#ffa500"]Before you venture off in to the club's forums and start posting, please ensure you read the information contained [/color][url="http://www.abc/index.php?showforum=203"][color="#ffff00"]HERE[/color][/url][color="#ffa500"]. 

As a registered member there are certain restrictions that apply to you within the ST Owners club forums. For more details, please read the Frequently asked questions [/color][url="http://www.abc/index.php?showforum=205"][color="#ffff00"]HERE[/color][/url][color="#ffa500"].

Some restrictions include.
No access to
- Private messaging system, forum signature, avatar and photo.
- premium content areas such as the garage, weblinks and tutorials.
- National events and shows forums and displaying your car on the club's stand.

Limited access to
- Your control panel, technical forums, classifieds and traders forums.

To remove this message and other restrictions, upgrade your membership to that of a 'Paid Member' by clicking [/color][url="http://www.abc/index.php?act=paysubs&CODE=index"][color="#ffff00"]HERE[/color][/url][color="#ffa500"].

All members when joining the ST Owners club agree to abide by the club's rules. You should ensure you are familiar with them by clicking [/color][url="http://www.abc/index.php?act=boardrules"][color="#ffff00"]HERE[/color][/url][color="#ffa500"].[/color]

thanks in advance
Richard

[Aloha]

You are welcome.

I would suggest doing one member ( possibly a test member ) and see if it will work.

Best way is to use phpMyadmin and edit the member_extra data field signature by clicking the pencil and pasting it into the field.

Then log on as that member and see how it looks. Play with it until you get it correct.

Then export the one record to see what the layout for the signature field should be for the update.

Edited by Aloha, 22 April 2010 - 03:38 PM.