Ok theres a couple default settings id like to change (TO)
While i can go into the admin panel and change certain settings
this will only accomplish it for people who will register AFTER i make the changes.
Id like to change these settings via SQL tables and i need alittle help on that one here Because id like to alter the settings of EVERYONE who will register shortly and for the people who are already registered with the site.

Here we go
This would require someone who has a bit of knowledge with SQL commands.... hope youre out there


in the SQL table " xoops_users "
i need to change this table
notify_method
the default should be " 2 "
0= diable
1= Private Message
2= Notify Via Email
Im looking to change this site wide to: notify_method = 2


Also

for Default Comment Display:
SQL table = xoops_user
usertable = umode
default setting should be = flat

right now it says = nested

I know theres an sQL command line that can be written but im not adept on doing that