Large Font

how to change default size to 200% for new visitors&members - Large Font

how to change default size to 200% for new visitors&members

by yasser33311 » Sat Dec 30, 2017 6:59 pm

hello
how to change default size to 200% for new visitors&members
PhpBB Services - install, update, upgrade, customize: PM
User avatar
yasser33311
Registered User
Posts: 266
Joined: Sat Jul 27, 2013 1:27 pm
Location: algeria
Name: yasser ghe
Contact:

Re: how to change default size to 200% for new visitors&memb

by HiFiKabin » Sun Dec 31, 2017 11:27 am

To set font size to 200% for all visitors, run the following SQL in phpmyadmin

Code: Select all

UPDATE phpbb_users SET user_font = 1 WHERE user_id IN(SELECT user_id FROM phpbb_user_group WHERE group_id = 1);

Code: Select all

UPDATE phpbb_users SET user_font_size = 110 WHERE user_id IN(SELECT user_id FROM phpbb_user_group WHERE group_id = 1);
Executing SQL Queries in phpMyAdmin

Remember to back up your database first.
User avatar
HiFiKabin
Community Team Member
Community Team Member
Posts: 4055
Joined: Wed May 14, 2014 9:10 am
Location: Swearing at the PC, UK
Name: James
Contact:

Re: how to change default size to 200% for new visitors&memb

by WWu777 » Thu Aug 16, 2018 2:19 pm

Is there a way to undo that SQL command if you want to?
WWu777
Registered User
Posts: 601
Joined: Tue Aug 14, 2007 12:40 pm
Contact:

Re: how to change default size to 200% for new visitors&memb

by HiFiKabin » Thu Aug 16, 2018 3:27 pm

If you run the following it will switch font size for guests to 'off'

Code: Select all

UPDATE phpbb_users SET user_font = 0 WHERE user_id IN(SELECT user_id FROM phpbb_user_group WHERE group_id = 1);
Remember to back up your database first, just in case of error
User avatar
HiFiKabin
Community Team Member
Community Team Member
Posts: 4055
Joined: Wed May 14, 2014 9:10 am
Location: Swearing at the PC, UK
Name: James
Contact: