Przedszkolak
Postów: 34
Data rejestracji: 03.10.2006 21:12
|
robie wlaśnie modyfikacje na krasnalu wersji EP IV fusion,ale cały czas mam błąd z zapisem,nie chce aktualizowac :/
dodam ze stworzyłem 5 nowych pol w tabeli user:
user_ucz varchar(30) (nazwa uczelni)
user_wydz varchar(30) (nazwa wydzialu)
user_kier varchar(30) (nazwa kierunku)
user_grupa varchar(10) (numer grupy)
user_rok varchar(10) (numer roku)
w profilu dodałem:
<tr>
<td width='1%' class='tbl1' style='white-space:nowrap'><b>Uczelnia:</b></td>
<td class='tbl1'>".$data['user_ucz']."</td>
</tr>
<tr>
<td width='1%' class='tbl1' style='white-space:nowrap'><b>Wydzial:</b></td>
<td class='tbl1'>".$data['user_wydz']."</td>
</tr>
<tr>
<td width='1%' class='tbl1' style='white-space:nowrap'><b>Rok:</b></td>
<td class='tbl1'>".$data['user_rok']."</td>
</tr>
<tr>
<td width='1%' class='tbl1' style='white-space:nowrap'><b>Kierunek:</b></td>
<td class='tbl1'>".$data['user_kier']."</td>
</tr>
<tr>
<td width='1%' class='tbl1' style='white-space:nowrap'><b>Grupa:</b></td>
<td class='tbl1'>".$data['user_grupa']."</td>
</tr>
w edit_profile
<tr>
<td class='tbl'>Uczelnia:</td>
<td class='tbl'><input type='text' name='user_ucz' value='".$userdata['user_ucz']."' maxlength='100' class='textbox' style='width:200px;'></td>
</tr>
<tr>
<td class='tbl'>Wydzial:</td>
<td class='tbl'><input type='text' name='user_wydz' value='".$userdata['user_wydz']."' maxlength='100' class='textbox' style='width:200px;'></td>
</tr>
<tr>
<td class='tbl'>Kierunek:</td>
<td class='tbl'><input type='text' name='user_kier' value='".$userdata['user_kier']."' maxlength='100' class='textbox' style='width:200px;'></td>
</tr>
<tr>
<td class='tbl'>Rok:</td>
<td class='tbl'><input type='text' name='user_wydz' value='".$userdata['user_rok']."' maxlength='100' class='textbox' style='width:200px;'></td>
</tr>
<tr>
<td class='tbl'>Grupa:</td>
<td class='tbl'><input type='text' name='user_wydz' value='".$userdata['user_grupa']."' maxlength='100' class='textbox' style='width:200px;'></td>
</tr>
oraz w update_profile_include:
$user_ucz = isset($_POST['user_ucz']) ? stripinput(trim($_POST['user_ucz'])) : "";
$user_wydz = isset($_POST['user_wydz']) ? stripinput(trim($_POST['user_wydz'])) : "";
$user_kier = isset($_POST['user_kier']) ? stripinput(trim($_POST['user_kier'])) : "";
$user_grupa = isset($_POST['user_grupa']) ? stripinput(trim($_POST['user_grupa'])) : "";
$user_rok = isset($_POST['user_rok']) ? stripinput(trim($_POST['user_rok'])) : "";
oraz
$result = dbquery("UPDATE ".$db_prefix."users SET ".$newpass."user_email='".$_POST['user_email']."', user_hide_email='$user_hide_email', user_location='$user_location', user_birthdate='$user_birthdate', user_aim='$user_aim', user_icq='$user_icq', user_msn='$user_msn', user_yahoo='$user_yahoo', user_web='$user_web', user_theme='$user_theme', user_offset='$user_offset', ".$set_avatar."user_sig='$user_sig', user_color='".$user_color."', user_prefix='".$user_prefix."', user_adds='".$user_adds."', user_ucz='$user_ucz', user_wydz='$user_wydz' , user_kier='$user_kier', user_grupa='$user_grupa', user_rok='$user_rok' WHERE user_id='".$userdata['user_id']."'");
z plikiem rejestracji jest chyba ok,ale ...
<?php
/*---------------------------------------------------+
| PHP-Fusion 6 Content Management System
+----------------------------------------------------+
| Copyright ę 2002 - 2005 Nick Jones
| http://www.php-fusion.co.uk/
+----------------------------------------------------+
| Released under the terms & conditions of v2 of the
| GNU General Public License. For details refer to
| the included gpl.txt file or visit http://gnu.org
+----------------------------------------------------*/
require_once "maincore.php";
require_once "subheader.php";
require_once "side_left.php";
include LOCALE.LOCALESET."register.php";
include LOCALE.LOCALESET."user_fields.php";
if (iMEMBER) fallback("index.php");
if ($settings['enable_registration']) {
if (isset($activate)) {
if (!preg_match("/^[0-9a-z]{32}$/", $activate)) fallback("index.php");
$result = dbquery("SELECT * FROM ".$db_prefix."new_users WHERE user_code='$activate'");
if (dbrows($result) != 0) {
$data = dbarray($result);
$user_info = unserialize($data['user_info']);
$activation = $settings['admin_activation'] == "1" ? "2" : "0";
$result = dbquery("INSERT INTO ".$db_prefix."users (user_name, user_password, user_email, user_hide_email, user_location, user_birthdate, user_aim, user_icq, user_msn, user_yahoo, user_web, user_theme, user_offset, user_avatar, user_sig, user_posts, user_joined, user_lastvisit, user_ip, user_rights, user_groups, user_level, user_status, u[b]ser_ucz, user_wydz, user_kier, user_grupa, user_rok[/b]) VALUES('".$user_info['user_name']."', '".md5($user_info['user_password'])."', '".$user_info['user_email']."', '".$user_info['user_hide_email']."', '".$user_info['user_location']."', '0000-00-00', '', '', '', '', '', 'Default', '0', '', '', '0', '".time()."', '0', '".USER_IP."', '', '', '101', '$activation',[b] '', '', '', '', ''[/b])");
$result = dbquery("DELETE FROM ".$db_prefix."new_users WHERE user_code='$activate'");
opentable($locale['401']);
if ($settings['admin_activation'] == "1") {
echo "<center><br>\n".$locale['455']."<br><br>\n".$locale['453']."<br><br>\n</center>\n";
} else {
echo "<center><br>\n".$locale['455']."<br><br>\n".$locale['452']."<br><br>\n</center>\n";
}
closetable();
} else {
fallback("index.php");
}
} else if (isset($_POST['register'])) {
$error = "";
$username = stripinput(trim(eregi_replace(" +", " ", $_POST['username'])));
$email = stripinput(trim(eregi_replace(" +", "", $_POST['email'])));
$password1 = stripinput(trim(eregi_replace(" +", "", $_POST['password1'])));
$location = stripinput(trim(eregi_replace(" +", "", $_POST['location'])));
[b]$ucz = stripinput(trim(eregi_replace(" +", "", $_POST['ucz'])));
$wydz = stripinput(trim(eregi_replace(" +", "", $_POST['wydz'])));
$kier = stripinput(trim(eregi_replace(" +", "", $_POST['kier'])));
$grupa = stripinput(trim(eregi_replace(" +", "", $_POST['grupa'])));
$rok = stripinput(trim(eregi_replace(" +", "", $_POST['rok'])));[/b]
if ($location == "" || $username == "" || $password1 == "" || $email == "") [b]//tutaj tez mozna dodac warunki,ale to mało wazne jak na tę chwile[/b] $error .= $locale['402']."<br>\n";
if (!preg_match("/^[-0-9A-Z_@\s]+$/i", $username)) $error .= $locale['403']."<br>\n";
if (!preg_match("/^[A-ZĆŁŚŹŻ]([a-ząęćłńóśźż])/", $location)) $error .= $locale['412']."<br>\n";
if (preg_match("/^[0-9A-Z@]{6,20}$/i", $password1)) {
if ($password1 != $_POST['password2']) $error .= $locale['404']."<br>\n";
} else {
$error .= $locale['405']."<br>\n";
}
if (!preg_match("/^[-0-9A-Z_\.]{1,50}@([-0-9A-Z_\.]+\.){1,50}([0-9A-Z]){2,4}$/i", $email)) {
$error .= $locale['406']."<br>\n";
}
$email_domain = substr(strrchr($email, "@"), 1);
$result = dbquery("SELECT * FROM ".$db_prefix."blacklist WHERE blacklist_email='".$email."' OR blacklist_email='$email_domain'");
if (dbrows($result) != 0) $error = $locale['411']."<br>\n";
$result = dbquery("SELECT * FROM ".$db_prefix."users WHERE user_name='$username'");
if (dbrows($result) != 0) $error = $locale['407']."<br>\n";
$result = dbquery("SELECT * FROM ".$db_prefix."users WHERE user_email='".$email."'");
if (dbrows($result) != 0) $error = $locale['408']."<br>\n";
if ($settings['email_verification'] == "1") {
$result = dbquery("SELECT * FROM ".$db_prefix."new_users");
while ($new_users = dbarray($result)) {
$user_info = unserialize($new_users['user_info']);
if ($new_users['user_email'] == $email) { $error = $locale['409']."<br>\n"; }
if ($user_info['user_name'] == $username) { $error = $locale['407']."<br>\n"; break; }
}
}
if ($settings['display_validation'] == "1") {
$user_code = stripinput($_POST['user_code']);
$result = dbquery("SELECT * FROM ".$db_prefix."vcode WHERE vcode_1='$user_code'");
if (dbrows($result) == 0) {
$error .= $locale['410']."<br>\n";
} else {
$result = dbquery("DELETE FROM ".$db_prefix."vcode WHERE vcode_1='$user_code'");
}
}
$user_hide_email = isNum($_POST['user_hide_email']) ? $_POST['user_hide_email'] : "1";
if ($settings['email_verification'] == "0") {
$user_location = isset($_POST['user_location']) ? stripinput(trim($_POST['user_location'])) : "";
if ($_POST['user_month'] != 0 && $_POST['user_day'] != 0 && $_POST['user_year'] != 0) {
$user_birthdate = (isNum($_POST['user_year']) ? $_POST['user_year'] : "0000")
."-".(isNum($_POST['user_month']) ? $_POST['user_month'] : "00")
."-".(isNum($_POST['user_day']) ? $_POST['user_day'] : "00");
} else {
$user_birthdate = "0000-00-00";
}
$user_aim = isset($_POST['user_aim']) ? stripinput(trim($_POST['user_aim'])) : "";
$user_icq = isset($_POST['user_icq']) ? stripinput(trim($_POST['user_icq'])) : "";
$user_msn = isset($_POST['user_msn']) ? stripinput(trim($_POST['user_msn'])) : "";
$user_yahoo = isset($_POST['user_yahoo']) ? stripinput(trim($_POST['user_yahoo'])) : "";
$user_web = isset($_POST['user_web']) ? stripinput(trim($_POST['user_web'])) : "";
$user_theme = stripinput($_POST['user_theme']);
$user_offset = is_numeric($_POST['user_offset']) ? $_POST['user_offset'] : "0";
$user_sig = isset($_POST['user_sig']) ? stripinput(trim($_POST['user_sig'])) : "";
}
if ($error == "") {
if ($settings['email_verification'] == "1") {
require_once INCLUDES."sendmail_include.php";
mt_srand((double)microtime()*1000000); $salt = "";
for ($i=0;$i<=7;$i++) { $salt .= chr(rand(97, 122)); }
$user_code = md5($email.$salt);
$activation_url = $settings['siteurl']."register.php?activate=".$user_code;
if (sendemail($username,$email,$settings['siteusername'],$settings['siteemail'],"Welcome to ".$settings['sitename'], $locale['450'].$activation_url)) {
$user_info = serialize(array(
"user_name" => $username,
"user_password" => $password1,
"user_email" => $email,
"user_location" => $location,
[b]"user_ucz" => $ucz,
"user_wydz" => $wydz,
"user_kier" => $kier,
"user_grupa" => $grupa,
"user_rok" => $rok,[/b]
"user_hide_email" => isNum($_POST['user_hide_email']) ? $_POST['user_hide_email'] : "1"
));
$result = dbquery("INSERT INTO ".$db_prefix."new_users (user_code, user_email, user_datestamp, user_info) VALUES('$user_code', '".$email."', '".time()."', '$user_info')");
opentable($locale['400']);
echo "<center><br>\n".$locale['454']."<br><br>\n</center>\n";
closetable();
} else {
opentable($locale['456']);
echo "<center><br>\n".$locale['457']."<br><br>\n</center>\n";
closetable();
}
} else {
$activation = $settings['admin_activation'] == "1" ? "2" : "0";
$result = dbquery("INSERT INTO ".$db_prefix."users (user_name, user_password, user_email, user_hide_email, user_location, user_birthdate, user_aim, user_icq, user_msn, user_yahoo, user_web, user_theme, user_offset, user_avatar, user_sig, user_posts, user_joined, user_lastvisit, user_ip, user_rights, user_groups, user_level, user_status, [b]user_ucz, user_wydz, user_kier, user_grupa, user_rok[/b]) VALUES('$username', md5('".$password1."'), '".$email."', '$user_hide_email', '$user_location', '$user_birthdate', '$user_aim', '$user_icq', '$user_msn', '$user_yahoo', '$user_web', '$user_theme', '$user_offset', '', '$user_sig', '0', '".time()."', '0', '".USER_IP."', '', '', '101', '$activation'[b], '', '', '', '', ''[/b])");
opentable($locale['400']);
if ($settings['admin_activation'] == "1") {
echo "<center><br>\n".$locale['451']."<br><br>\n".$locale['453']."<br><br>\n</center>\n";
} else {
echo "<center><br>\n".$locale['451']."<br><br>\n".$locale['452']."<br><br>\n</center>\n";
}
closetable();
}
} else {
opentable($locale['456']);
echo "<center><br>\n".$locale['458']."<br><br>\n$error<br>\n<a href='".FUSION_SELF."'>".$locale['459']."</a></div></br>\n";
closetable();
}
} else {
if ($settings['email_verification'] == "0") {
$theme_files = makefilelist(THEMES, ".|..", true, "folders");
array_unshift($theme_files, "Default");
$offset_list = "";
for ($i=-13;$i<17;$i++) {
if ($i > 0) { $offset="+".$i; } else { $offset=$i; }
$offset_list .= "<option".($offset == "0" ? " selected" : "").">$offset</option>\n";
}
}
if ($settings['display_validation'] == "1") {
srand((double)microtime()*1000000);
$temp_num = md5(rand(0,9999));
$vcode_1 = substr($temp_num, 17, 5);
$vcode_2 = md5($vcode_1);
unset($temp_num);
$result = dbquery("INSERT INTO ".$db_prefix."vcode VALUES('".time()."', '$vcode_1', '$vcode_2')");
}
opentable($locale['400']);
echo "<center>".$locale['500']."\n";
if ($settings['email_verification'] == "1") echo $locale['501']."\n";
echo $locale['502'];
if ($settings['email_verification'] == "1") echo "\n".$locale['503'];
echo "</center><br>
<table align='center' cellpadding='0' cellspacing='0'>
<form name='inputform' method='post' action='".FUSION_SELF."' onSubmit='return ValidateForm(this)'>
<tr>
<td class='tbl'>".$locale['u005']."<span style='color:#ff0000'>*</span></td>
<td class='tbl'><input type='text' name='email' maxlength='100' class='textbox' style='width:200px;'></td>
</tr>
<tr>
<td class='tbl'>".$locale['u009']."<span style='color:#ff0000'>*</span></td>
<td class='tbl'><input type='text' name='location' maxlength='20' class='textbox' style='width:200px;'></td>
</tr>
[b]<tr>
<td class='tbl'>Uczelnia<span style='color:#ff0000'>*</span></td>
<td class='tbl'><input type='text' name='uczelnia' maxlength='20' class='textbox' style='width:200px;'></td>
</tr>
<tr>
<td class='tbl'>Wydzial<span style='color:#ff0000'>*</span></td>
<td class='tbl'><input type='text' name='wydzial' maxlength='20' class='textbox' style='width:200px;'></td>
</tr>
<tr>
<td class='tbl'>Kierunek<span style='color:#ff0000'>*</span></td>
<td class='tbl'><input type='text' name='kierunek' maxlength='20' class='textbox' style='width:200px;'></td>
</tr>
<tr>
<td class='tbl'>Grupa<span style='color:#ff0000'>*</span></td>
<td class='tbl'><input type='text' name='grupa' maxlength='20' class='textbox' style='width:200px;'></td>
</tr>
<tr>
<td class='tbl'>Rok<span style='color:#ff0000'>*</span></td>
<td class='tbl'><input type='text' name='rok' maxlength='20' class='textbox' style='width:200px;'></td>
</tr>[/b]
niby EP IV ale chyba ta sekcja jest bardzo podobna i tak samo funkcjopnuje jak zwykly fusion,
jakies rady?
|
