X-Git-Url: https://git.nubati.net/cgi-bin/gitweb.cgi?p=e-DoKo.git;a=blobdiff_plain;f=include%2Fpreferences.php;h=3904899191ed778840f7a7fde514e76cfcae8601;hp=613d96543371e37d0084b935ddc5a1026c756394;hb=c581cd05476d07f0fd17dab41cbb211a443fd57f;hpb=dca957af7210156af72555bb8544fde47e756376 diff --git a/include/preferences.php b/include/preferences.php index 613d965..3904899 100644 --- a/include/preferences.php +++ b/include/preferences.php @@ -1,24 +1,51 @@ + * + * This file is part of e-DoKo. + * + * e-DoKo is free software: you can redistribute it and/or modify + * it under the terms of the GNU General Public License as published by + * the Free Software Foundation, either version 3 of the License, or + * (at your option) any later version. + * + * e-DoKo is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + * GNU General Public License for more details. + * + * You should have received a copy of the GNU General Public License + * along with e-DoKo. If not, see . + * + */ + /* make sure that we are not called from outside the scripts, * use a variable defined in config.php to check this */ if(!isset($HOST)) exit; +include_once('openid.php'); + $name = $_SESSION["name"]; $email = DB_get_email('name',$name); -$myid = DB_get_userid('email',$email); +$myid = DB_get_userid('email',$email); if(!$myid) return; /* track what got changed */ -$changed_notify = 0; -$changed_password = 0; -$changed_cards = 0; -$changed_timezone = 0; -$changed_autosetup = 0; +$changed_notify = 0; +$changed_password = 0; +$changed_cards = 0; +$changed_timezone = 0; +$changed_autosetup = 0; +$changed_sorting = 0; +$changed_openforgames = 0; +$changed_vacation = 0; +$changed_openid = 0; +$changed_digest = 0; +$changed_language = 0; -display_user_menu(); +display_user_menu($myid); /* get old infos */ $PREF = DB_get_PREF($myid); @@ -26,10 +53,102 @@ $timezone = DB_get_user_timezone($myid); DB_update_user_timestamp($myid); -/* does the user want to change some preferences? */ +/* does the user want to change some preferences? + * update the database and track changes with a variable, so that + * we can later highlight the changed value + */ + +/* check for deleted openids */ +foreach($_REQUEST as $key=>$value) +{ + if(strstr($key,"delete-openid-")) + { + /* found and openid to delete */ + $DelOpenID = substr(str_replace("_",".",$key),14); + DB_DetachOpenID($DelOpenID, $myid); + $changed_openid = 1; + } +} + + +if(myisset('vacation_start','vacation_stop','vacation_comment') && + ($_REQUEST['vacation_start']!='' || $_REQUEST['vacation_stop']!='') + ) + { + $vacation_start = $_REQUEST['vacation_start'].' 00:00:00'; + $vacation_stop = $_REQUEST['vacation_stop'].' 23:59:59'; + $vacation_comment = $_REQUEST['vacation_comment']; + + /* check if everything is valid */ + if(!strtotime($vacation_start)) + $changed_vacation = -1; + if(!strtotime($vacation_stop)) + $changed_vacation = -1; + + /* test if we should delete the entry */ + if($vacation_start == '- 00:00:00') + { + $result = DB_query("DELETE FROM User_Prefs". + " WHERE user_id='$myid' AND pref_key='vacation start'" ); + $result = DB_query("DELETE FROM User_Prefs". + " WHERE user_id='$myid' AND pref_key='vacation stop'" ); + $result = DB_query("DELETE FROM User_Prefs". + " WHERE user_id='$myid' AND pref_key='vacation comment'" ); + $changed_vacation = 1; + } + /* change in database if format is ok */ + else if($changed_vacation>=0) + { + /* only change if different from current value */ + if($vacation_start!=$PREF['vacation_start']) + { + $result = DB_query("SELECT * from User_Prefs". + " WHERE user_id='$myid' AND pref_key='vacation start'" ); + if( DB_fetch_array($result)) + $result = DB_query("UPDATE User_Prefs SET value=".DB_quote_smart($vacation_start). + " WHERE user_id='$myid' AND pref_key='vacation start'" ); + else + $result = DB_query("INSERT INTO User_Prefs VALUES(NULL,'$myid','vacation start',". + DB_quote_smart($vacation_start).")"); + + $changed_vacation = 1; + } + + /* same for the stop date */ + if($vacation_stop!=$PREF['vacation_stop']) + { + $result = DB_query("SELECT * from User_Prefs". + " WHERE user_id='$myid' AND pref_key='vacation stop'" ); + if( DB_fetch_array($result)) + $result = DB_query("UPDATE User_Prefs SET value=".DB_quote_smart($vacation_stop). + " WHERE user_id='$myid' AND pref_key='vacation stop'" ); + else + $result = DB_query("INSERT INTO User_Prefs VALUES(NULL,'$myid','vacation stop',". + DB_quote_smart($vacation_stop).")"); + + $changed_vacation = 1; + } + + /* does the user want to add a comment? */ + if($vacation_comment!=$PREF['vacation_comment']) + { + $result = DB_query("SELECT * from User_Prefs". + " WHERE user_id='$myid' AND pref_key='vacation comment'" ); + if( DB_fetch_array($result)) + $result = DB_query("UPDATE User_Prefs SET value=".DB_quote_smart($vacation_comment). + " WHERE user_id='$myid' AND pref_key='vacation comment'" ); + else + $result = DB_query("INSERT INTO User_Prefs VALUES(NULL,'$myid','vacation comment',". + DB_quote_smart($vacation_comment).")"); + + $changed_vacation = 1; + } + } + } + if(myisset("timezone")) { - $newtimezone=$_REQUEST['timezone']; + $newtimezone = $_REQUEST['timezone']; if($newtimezone != $timezone) { DB_query("UPDATE User SET timezone=".DB_quote_smart($newtimezone). @@ -74,6 +193,24 @@ if(myisset("notify")) } } +if(myisset("digest")) + { + $digest=$_REQUEST['digest']; + if($digest != $PREF['digest']) + { + /* check if we already have an entry for the user, if so change it, if not create new one */ + $result = DB_query("SELECT * from User_Prefs". + " WHERE user_id='$myid' AND pref_key='digest'" ); + if( DB_fetch_array($result)) + $result = DB_query("UPDATE User_Prefs SET value=".DB_quote_smart($digest). + " WHERE user_id='$myid' AND pref_key='digest'" ); + else + $result = DB_query("INSERT INTO User_Prefs VALUES(NULL,'$myid','digest',". + DB_quote_smart($digest).")"); + $changed_digest=1; + } + } + if(myisset("autosetup")) { $autosetup = $_REQUEST['autosetup']; @@ -92,8 +229,44 @@ if(myisset("autosetup")) } } +if(myisset("sorting")) + { + $sorting = $_REQUEST['sorting']; + if($sorting != $PREF['sorting']) + { + /* check if we already have an entry for the user, if so change it, if not create new one */ + $result = DB_query("SELECT * from User_Prefs". + " WHERE user_id='$myid' AND pref_key='sorting'" ); + if( DB_fetch_array($result)) + $result = DB_query("UPDATE User_Prefs SET value=".DB_quote_smart($sorting). + " WHERE user_id='$myid' AND pref_key='sorting'" ); + else + $result = DB_query("INSERT INTO User_Prefs VALUES(NULL,'$myid','sorting',". + DB_quote_smart($sorting).")"); + $changed_sorting=1; + } + } + +if(myisset("open_for_games")) + { + $openforgames = $_REQUEST['open_for_games']; + if($openforgames != $PREF['open_for_games']) + { + /* check if we already have an entry for the user, if so change it, if not create new one */ + $result = DB_query("SELECT * from User_Prefs". + " WHERE user_id='$myid' AND pref_key='open for games'" ); + if( DB_fetch_array($result)) + $result = DB_query("UPDATE User_Prefs SET value=".DB_quote_smart($openforgames). + " WHERE user_id='$myid' AND pref_key='open for games'" ); + else + $result = DB_query("INSERT INTO User_Prefs VALUES(NULL,'$myid','open for games',". + DB_quote_smart($openforgames).")"); + $changed_openforgames=1; + } + } + -if(myisset("password0") && $_REQUEST["password0"]!="" ) +if(myisset("password0","password1","password2") && $_REQUEST["password0"]!="" && $_REQUEST["password0"]!= $_REQUEST["password1"]) { $changed_password = 1; @@ -119,70 +292,199 @@ if(myisset("password0") && $_REQUEST["password0"]!="" ) /* error output below */ } +if(myisset("openid_url") && $_REQUEST['openid_url']!='') + { + $openid_url = OpenIDUrlEncode($_REQUEST['openid_url']); + DB_AttachOpenID($openid_url, $myid); + } + +if(myisset("language")) + { + $language = $_REQUEST['language']; + if($language != $PREF['language']) + { + /* check if we already have an entry for the user, if so change it, if not create new one */ + $result = DB_query("SELECT * from User_Prefs". + " WHERE user_id='$myid' AND pref_key='language'" ); + if( DB_fetch_array($result)) + $result = DB_query("UPDATE User_Prefs SET value=".DB_quote_smart($language). + " WHERE user_id='$myid' AND pref_key='language'" ); + else + $result = DB_query("INSERT INTO User_Prefs VALUES(NULL,'$myid','language',". + DB_quote_smart($language).")"); + $changed_language = 1; + } + } + + /* get infos again in case they have changed */ $PREF = DB_get_PREF($myid); $timezone = DB_get_user_timezone($myid); -/* output settings */ +/* + * output settings + */ echo "
\n"; echo "
\n"; echo "

Your settings are

\n"; -echo " \n"; -echo " \n"; -echo "
Email: $email
Timezone: "; -output_select_timezone("timezone",$timezone); -if($changed_timezone) echo "changed"; +echo "
\n"; +echo " Game-related\n"; +echo " \n"; + +echo " \n"; +if($PREF['vacation_start']) + $value = substr($PREF['vacation_start'],0,10); + else + $value = ''; +echo " \n"; +if($PREF['vacation_stop']) + $value = substr($PREF['vacation_stop'],0,10); + else + $value = ''; +echo " \n"; +if($PREF['vacation_comment']) + $value = $PREF['vacation_comment']; +else + $value = ''; +echo " \n"; -echo " \n"; +echo " \n"; -echo " \n"; + + +echo " \n"; -echo " \n"; +echo " \n"; + +echo " \n"; -echo "
Vacation: start:stop:comment:"; +if($changed_vacation == 1) echo "changed"; +if($changed_vacation == -1) echo "wrong date format"; echo "
Notification: "; - -echo " \n"; +echo "
use YYYY-MM-DDuse '-' in start field to unset vacation
Notification: \n"; +echo " "; if($changed_notify) echo "changed"; echo "
Autosetup: "; - -echo " \n"; + +echo "
Digest: \n"; +echo " "; +if($changed_digest) echo "changed"; +echo "
Autosetup: \n"; +echo " "; if($changed_autosetup) echo "changed"; echo "
Card set: "; - -echo " \n"; +echo "
Sorting: \n"; + +echo " "; +if($changed_sorting) echo "changed"; +echo "
Open for new games: \n"; +echo " "; +if($changed_openforgames) echo "changed"; +echo "
Card set: \n"; +echo " "; if($changed_cards) echo "changed"; echo "
Password(old): ", +echo "
\n"; +echo "
\n"; +echo "
\n"; +echo " Personal\n"; +echo " \n"; +echo " \n"; +echo " \n"; +echo " \n"; +echo " \n"; -echo " \n"; +echo " \n"; -echo " \n"; -echo " ", - "\n"; -echo "
Email: $email
Timezone: \n"; +output_select_timezone("timezone",$timezone); +if($changed_timezone) echo "changed"; +echo "
Language: \n"; +output_select_language("language",$PREF['language']); +echo "
Password(old): ", ""; switch($changed_password) { @@ -199,17 +501,43 @@ switch($changed_password) echo "changed"; break; } -echo "
Password(new): ", +echo "
Password(new): ", "", "
Password(new, retype): ", +echo "
Password(new, retype): ", "", "
\n"; +echo "
\n"; +echo " \n"; +echo "
\n"; +echo " OpenID\n"; + +$openids = array(); +$openids = DB_GetOpenIDsByUser($myid); + +if(sizeof($openids)) + { + echo " \n"; + echo " \n"; + echo " \n"; + foreach ($openids as $ids) + { + $id=($ids[0]); + echo " \n"; + } + echo " \n"; + echo "
Delete?OpenId
",$id, "
\n"; + } + +echo " add OpenID: ", + ""; +if($changed_openid) + echo " Deleted some OpenIDs!
\n"; +echo "
\n"; +echo "
Submit
\n"; echo "
\n"; +echo "

E-DoKo uses gravatars as icons. I

"; echo "
\n"; return;