suggestion for short user agent: shorten_subject(substr($url['USER_AGENT'], 0, strpos($url['USER_AGENT'], ' ')), 25) that will shorten to something like "Mozilla/5.0" or "Opera/9.8"
About the group colors, I actually meant that the css identifier is wrong, it targets the element group_1 instead of class .group_1
Posted: August 04, 2012, 14:33:01
here's a bit for your wiki, I just used the second query to convert the msn profile field. first is just for reference.
INSERT INTO `yabbse_custom_fields` (`col_name`, `field_name`, `field_desc`, `field_type`, `field_length`, `field_options`, `mask`, `show_reg`, `show_display`, `show_profile`, `private`, `active`, `bbc`, `can_search`, `default_value`, `enclose`, `placement`) VALUES ('cust_msn','MSN','MSN Messenger address','text',255,'','email',0,1,'forumprofile',0,1,0,1,'','<a href=\"msnim:chat?contact={INPUT}\"><img src=\"{IMAGES_URL}/msn.png\" alt=\"{INPUT}\" /></a>',1);
REPLACE INTO yabbse_themes (id_member, id_theme, variable, value) SELECT id_member, 1, 'cust_msn', msn FROM yabbse_members WHERE msn IS NOT NULL AND msn LIKE '%@%' ;