diff options
| -rw-r--r-- | DB/change_db_to_v142.sql | 2 | ||||
| -rwxr-xr-x | www-ssl/admin/user.php | 14 | ||||
| -rwxr-xr-x | www-ssl/admin/user2.php | 2 | ||||
| -rwxr-xr-x | www-ssl/makeuser.php | 6 | ||||
| -rwxr-xr-x | www-ssl/nonpublic/einstellungen.php | 16 | ||||
| -rwxr-xr-x | www-ssl/nonpublic/index.php | 2 |
6 files changed, 37 insertions, 5 deletions
diff --git a/DB/change_db_to_v142.sql b/DB/change_db_to_v142.sql new file mode 100644 index 00000000..5e95be9e --- /dev/null +++ b/DB/change_db_to_v142.sql @@ -0,0 +1,2 @@ +ALTER TABLE `User` ADD `ICQ` VARCHAR( 30 ) NULL AFTER `email` , ADD `jabber` VARCHAR( 200 ) NULL AFTER `ICQ` ; + diff --git a/www-ssl/admin/user.php b/www-ssl/admin/user.php index 403c10ee..78701538 100755 --- a/www-ssl/admin/user.php +++ b/www-ssl/admin/user.php @@ -35,7 +35,9 @@ if (!IsSet($_GET["enterUID"])) <a href="<?PHP echo $_SERVER["PHP_SELF"]; ?>?OrderBy=DECT">DECT</a> | <a href="<?PHP echo $_SERVER["PHP_SELF"]; ?>?OrderBy=Hometown">Hometown</a> | <a href="<?PHP echo $_SERVER["PHP_SELF"]; ?>?OrderBy=lastLogIn">lastLogIn</a> | - <a href="<?PHP echo $_SERVER["PHP_SELF"]; ?>?OrderBy=Art">Type</a> + <a href="<?PHP echo $_SERVER["PHP_SELF"]; ?>?OrderBy=Art">Type</a> | + <a href="<?PHP echo $_SERVER["PHP_SELF"]; ?>?OrderBy=ICQ">ICQ</a> | + <a href="<?PHP echo $_SERVER["PHP_SELF"]; ?>?OrderBy=jabber">jabber</a> </td> <td><a href="<?PHP echo $_SERVER["PHP_SELF"]; ?>?OrderBy=Size">Größe</a></td> <td><a href="<?PHP echo $_SERVER["PHP_SELF"]; ?>?OrderBy=Gekommen">G</a></td> @@ -74,6 +76,10 @@ if (!IsSet($_GET["enterUID"])) echo "\n\t\tlastLogIn: ". mysql_result($Erg, $n, "lastLogIn"). "<br>"; if( strlen( mysql_result($Erg, $n, "Art"))>0) echo "\n\t\tType: ". mysql_result($Erg, $n, "Art"). "<br>"; + if( strlen( mysql_result($Erg, $n, "ICQ"))>0) + echo "\n\t\tICQ: ". mysql_result($Erg, $n, "ICQ"). "<br>"; + if( strlen( mysql_result($Erg, $n, "jabber"))>0) + echo "\n\t\tjabber: ". mysql_result($Erg, $n, "jabber"). "<br>"; echo "</td>\n"; echo "\t<td>".mysql_result($Erg, $n, "Size")."</td>\n"; $Gekommen += mysql_result($Erg, $n, "Gekommen"); @@ -161,6 +167,12 @@ else echo " <tr><td>email</td><td>". "<input type=\"text\" size=\"40\" name=\"eemail\" value=\"". mysql_result($Erg, 0, "email")."\"></td></tr>\n"; + echo " <tr><td>ICQ</td><td>". + "<input type=\"text\" size=\"40\" name=\"eICQ\" value=\"". + mysql_result($Erg, 0, "ICQ")."\"></td></tr>\n"; + echo " <tr><td>jabber</td><td>". + "<input type=\"text\" size=\"40\" name=\"ejabber\" value=\"". + mysql_result($Erg, 0, "jabber")."\"></td></tr>\n"; echo " <tr><td>Size</td><td>". "<input type=\"text\" size=\"5\" name=\"eSize\" value=\"". mysql_result($Erg, 0, "Size")."\"></td></tr>\n"; diff --git a/www-ssl/admin/user2.php b/www-ssl/admin/user2.php index 8631ade2..131f544c 100755 --- a/www-ssl/admin/user2.php +++ b/www-ssl/admin/user2.php @@ -26,6 +26,8 @@ if (IsSet($_GET["action"])) "`Handy` = '". $_POST["eHandy"]. "', ". "`DECT` = '". $_POST["eDECT"]. "', ". "`email` = '". $_POST["eemail"]. "', ". + "`ICQ` = '". $_POST["eICQ"]. "', ". + "`jabber` = '". $_POST["ejabber"]. "', ". "`Size` = '". $_POST["eSize"]. "', ". "`Gekommen`= '". $_POST["eGekommen"]. "', ". "`Aktiv`= '". $_POST["eAktiv"]. "', ". diff --git a/www-ssl/makeuser.php b/www-ssl/makeuser.php index 9997b787..43f71dd1 100755 --- a/www-ssl/makeuser.php +++ b/www-ssl/makeuser.php @@ -50,6 +50,7 @@ if( isset($_POST["send"])) "`Vorname`, ". "`Alter` , ". "`Telefon`, ". "`DECT`, ". "`Handy`, ". "`email`, ". + "`ICQ`, ". "`jabber`, ". "`Size`, ". "`Passwort`, ". "`Art` , ". "`kommentar`, ". "`Hometown` ) ". @@ -58,6 +59,7 @@ if( isset($_POST["send"])) "'". $_POST["Vorname"]. "', ". $_POST["Alter"]. ", ". "'". $_POST["Telefon"]. "', ". "'". $_POST["DECT"]. "', ". "'". $_POST["Handy"]. "', ". "'". $_POST["email"]. "', ". + "'". $_POST["ICQ"]. "', ". "'". $_POST["jabber"]. "', ". "'". $_POST["Size"]. "', ". "'". $_POST["Passwort"]. "', ". "'". $_POST["Art"]. "', ". "'". $_POST["kommentar"]. "', ". "'". $_POST["Hometown"]. "' );"; @@ -107,6 +109,8 @@ else $_POST["DECT"] = ""; $_POST["Handy"] = ""; $_POST["email"] = ""; + $_POST["ICQ"] = ""; + $_POST["jabber"] = ""; $_POST["Size"] = ""; $_POST["Art"] = ""; $_POST["kommentar"] = ""; @@ -133,6 +137,8 @@ echo "\t\t\t<tr><td>". Get_Text("makeuser_Handy"). "</td><td><input type=\"text\" size=\"40\" name=\"Handy\" value=\"". $_POST["Handy"]. "\"></td></tr>\n"; echo "\t\t\t<tr><td>". Get_Text("makeuser_E-Mail"). "*</td><td><input type=\"text\" size=\"40\" name=\"email\" value=\"". $_POST["email"]. "\"></td></tr>\n"; +echo "\t\t\t<tr><td>ICQ</td><td><input type=\"text\" size=\"40\" name=\"ICQ\" value=\"". $_POST["ICQ"]. "\"></td></tr>\n"; +echo "\t\t\t<tr><td>jabber</td><td><input type=\"text\" size=\"40\" name=\"jabber\" value=\"". $_POST["jabber"]. "\"></td></tr>\n"; echo "\t\t\t<tr><td>". Get_Text("makeuser_T-Shirt"). " Grösse*</td><td align=\"left\">\n"; echo "\t\t\t<select name=\"Size\">\n"; diff --git a/www-ssl/nonpublic/einstellungen.php b/www-ssl/nonpublic/einstellungen.php index 9f8f1fa9..faf72be5 100755 --- a/www-ssl/nonpublic/einstellungen.php +++ b/www-ssl/nonpublic/einstellungen.php @@ -30,6 +30,10 @@ if (!IsSet($_POST["action"])) <td><input type="text" name="eDECT" size="4" value="<?PHP echo $_SESSION['DECT']; ?>"></td></tr> <tr> <td><?PHP Print_Text("pub_einstellungen_email"); ?></td> <td><input type="text" name="eemail" size="40" value="<?PHP echo $_SESSION['email']; ?>"></td></tr> + <tr> <td>ICQ</td> + <td><input type="text" name="eICQ" size="40" value="<?PHP echo $_SESSION['ICQ']; ?>"></td></tr> + <tr> <td>jabber</td> + <td><input type="text" name="ejabber" size="40" value="<?PHP echo $_SESSION['jabber']; ?>"></td></tr> <tr> <td><?PHP Print_Text("pub_einstellungen_Hometown"); ?></td> <td><input type="text" name="Hometown" size="40" value="<?PHP echo $_SESSION['Hometown']; ?>"></td></tr> </table> @@ -199,10 +203,12 @@ case 'avatar': case 'setUserData': $chsql= "UPDATE User SET ". - "`Nick`='". $_POST["eNick"]. "', `Name`='". $_POST["eName"]. "', ". - "`Vorname`='". $_POST["eVorname"]. "', `Alter`='". $_POST["eAlter"]. "', ". - "`Telefon`='". $_POST["eTelefon"]. "', `Handy`='". $_POST["eHandy"]. "', ". - "`DECT`='". $_POST["eDECT"]. "', `email`='". $_POST["eemail"]. "', `Hometown`='". $_POST["Hometown"]. "' ". + "`Nick`='". $_POST["eNick"]. "', `Name`='". $_POST["eName"]. "', ". + "`Vorname`='". $_POST["eVorname"]. "', `Alter`='". $_POST["eAlter"]. "', ". + "`Telefon`='". $_POST["eTelefon"]. "', `Handy`='". $_POST["eHandy"]. "', ". + "`DECT`='". $_POST["eDECT"]. "', `email`='". $_POST["eemail"]. "', ". + "`ICQ`='". $_POST["eICQ"]. "', `jabber`='". $_POST["ejabber"]."', ". + "`Hometown`='". $_POST["Hometown"]. "' ". "WHERE UID='". $_SESSION['UID']. "' LIMIT 1;"; $Erg = mysql_query($chsql, $con); @@ -216,6 +222,8 @@ case 'setUserData': $_SESSION['Handy'] = $_POST["eHandy"]; $_SESSION['DECT'] = $_POST["eDECT"]; $_SESSION['email'] = $_POST["eemail"]; + $_SESSION['ICQ'] = $_POST["eICQ"]; + $_SESSION['jabber'] = $_POST["ejabber"]; $_SESSION['Hometown'] = $_POST["Hometown"]; Print_Text("pub_einstellungen_UserDateSaved"); diff --git a/www-ssl/nonpublic/index.php b/www-ssl/nonpublic/index.php index b1767118..2c8b18a1 100755 --- a/www-ssl/nonpublic/index.php +++ b/www-ssl/nonpublic/index.php @@ -40,6 +40,8 @@ else $_SESSION['Handy'] = mysql_result($userstring, 0, "Handy"); $_SESSION['DECT'] = mysql_result($userstring, 0, "DECT"); $_SESSION['email'] = mysql_result($userstring, 0, "email"); + $_SESSION['ICQ'] = mysql_result($userstring, 0, "ICQ"); + $_SESSION['jabber'] = mysql_result($userstring, 0, "jabber"); $_SESSION['Size'] = mysql_result($userstring, 0, "Size"); $_SESSION['Gekommen'] = mysql_result($userstring, 0, "Gekommen"); $_SESSION['Aktiv'] = mysql_result($userstring, 0, "Aktiv"); |