close× Call Us +49 (1805) 01 29 59

Datalus
Thread Author: 8eww
Thread ID: 14
Thread Info
Es gibt 14 Beiträge zu diesem Thema, und es wurde 3695 mal angesehen.
Wer ist hier? 1 Gäste
 Thema drucken
Registrierungsdaten in 2 Tabellen schrieben
8eww
Hallo,

ich würde gerne meine register.php anpassen

und zwar in dem sinne das der username, passwort und email noch in eine andre tabelle geschrieben wird


Hat einer ne Idee wie das geht
 
SC-Ad-Bot
 
Gr@n@dE
Hi,

wie genau stellst du dir das vor ? Um das Vorhaben zu realisieren müsstest du genau wissen welche Einstellungen du für deine Registration gemacht hast.

In Zeile 145 und 156 wird in die Datenbank geschrieben (INSERT),
darunter müsstest du nur eine andere Tabelle wählen und hineinschreiben. Zum Beispiel so:

$result = dbquery("INSERT INTO andere_tabelle (username, passwort, email) VALUES('".$username."', '".md5(md5($password1))."', '".$email."')");

Also eigentlich relativ simpel. ;)
Gruß Ralf
__________________________________
KEIN Support per Mail, ICQ oder PN !
 
8eww
es soll ja in die pfscdb_ tabelle rein und dann noch in eine andre auch ....das ist das problem mit dem chat was ich schon mal / immer noch habe
 
Gr@n@dE
Hi,

ich habe dich schon verstanden, aber leider du mich nicht.

Die Codezeile die ich da dir geschrieben haben musst du nur anpassen und in den angegeben Zeilen unter die Datenbank Abfragen schreiben.

Da der Aufbau der Tabelle des Chats unbekannt ist, kann man dazu keine genaueren angaben machen.

PS: Bitte schreiben in ganzen Sätzen und nicht dieser "Chattersprache". Danke
Gruß Ralf
__________________________________
KEIN Support per Mail, ICQ oder PN !
 
8eww
kannst du mir das mal für v6 und v7 machen???

tabelle heist: pcpin_user

spalten: login, passwort, email


danke
 
firemike
Also wie Gr@n@de schon geschrieben hatte oben:


$result = dbquery("INSERT INTO pcpin_user (username, passwort, email) VALUES('".$username."', '".md5(md5($password1))."', '".$email."')");


Aber:

Zitat

Da der Aufbau der Tabelle des Chats unbekannt ist, kann man dazu keine genaueren angaben machen.


Und das mit der Chattersprache üben wir noch ;)
 
Gr@n@dE
Pass aber bitte auf die richtigen Verschlüsselung beim Passwort auf. Kann sein das es nur einmal md5 Verschlüsselt ist.
Gruß Ralf
__________________________________
KEIN Support per Mail, ICQ oder PN !
 
8eww
ich habe es so eingefügt in die register.php asber es wird nix in die pcpin_user tabelle geschrieben
 
firemike
hi,

1. ist das alles was in der tabelle an spalten vorhanden ist ?
spalten: login, passwort, email

2. Poste bitte deine register.php
3. Danke Wink

Mike
 
8eww

<?php
/*---------------------------------------------------+
| PHP-Fusion 6 Content Management System
+----------------------------------------------------+
| Copyright © 2002 - 2006 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) VALUES('".$user_info['user_name']."', '".$user_info['user_password']."', '".$user_info['user_email']."', '".$user_info['user_hide_email']."', '', '0000-00-00', '', '', '', '', '', 'Default', '0', '', '', '0', '".time()."', '0', '".USER_IP."', '', '', '101', '$activation')");
      $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'])));
   
   if ($username == "" || $password1 == "" || $email == "") $error .= $locale['402']."<br>\n";
   
   if (!preg_match("/^[-0-9A-Z_@\s]+$/i", $username)) $error .= $locale['403']."<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") {
      if (!check_captcha($_POST['captcha_encode'], $_POST['captcha_code'])) {
         $error .= $locale['410']."<br />\n";
      }
   }
   
   $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'],$locale['449'], $locale['450'].$activation_url)) {
            $user_info = serialize(array(
               "user_name" => $username,
               "user_password" => md5(md5($password1)),
               "user_email" => $email,
               "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) VALUES('$username', '".md5(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')");
         
         $result = dbquery("INSERT INTO pcpin_user (login, passwort, email) VALUES('".$username."', '".md5($password1)."', '".$email."')");
         
         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";
      }
   }
   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['u001']."<span style='color:#ff0000'>*</span></td>
<td class='tbl'><input type='text' name='username' maxlength='30' class='textbox' style='width:200px;'></td>
</tr>
<tr>
<td class='tbl'>".$locale['u002']."<span style='color:#ff0000'>*</span></td>
<td class='tbl'><input type='password' name='password1' maxlength='20' class='textbox' style='width:200px;'></td>
</tr>
<tr>
<td class='tbl'>".$locale['u004']."<span style='color:#ff0000'>*</span></td>
<td class='tbl'><input type='password' name='password2' maxlength='20' class='textbox' style='width:200px;'></td>
</tr>
<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['u006']."</td>
<td class='tbl'><input type='radio' name='user_hide_email' value='1'>".$locale['u007']."
<input type='radio' name='user_hide_email' value='0' checked>".$locale['u008']."</td>
</tr>\n";
   if ($settings['display_validation'] == "1") {
      echo "<tr>\n<td class='tbl'>".$locale['504']."</td>\n<td class='tbl'>";
      echo make_captcha();
      echo "</td>
</tr>
<tr>
<td class='tbl'>".$locale['505']."<span style='color:#ff0000'>*</span></td>
<td class='tbl'><input type='text' name='captcha_code' class='textbox' style='width:100px'></td>
</tr>\n";
   }
   if ($settings['email_verification'] == "0") {
      echo "<tr>
<td class='tbl'>".$locale['u009']."</td>
<td class='tbl'><input type='text' name='user_location' maxlength='50' class='textbox' style='width:200px;'></td>
</tr>
<tr>
<td class='tbl'>".$locale['u010']." <span class='small2'>(mm/dd/yyyy)</span></td>
<td class='tbl'><select name='user_month' class='textbox'>\n<option> </option>\n";
      for ($i=1;$i<=12;$i++) echo "<option".($user_month == $i ? " selected" : "").">$i</option>\n";
      echo "</select>\n<select name='user_day' class='textbox'>\n<option> </option>\n";
      for ($i=1;$i<=31;$i++) echo "<option".($user_day == $i ? " selected" : "").">$i</option>\n";
      echo "</select>\n<select name='user_year' class='textbox'>\n<option> </option>\n";
      for ($i=1900;$i<=2004;$i++) echo "<option".($user_year == $i ? " selected" : "").">$i</option>\n";
      echo "</select>
</td>
</tr>
<tr>
<td class='tbl'>".$locale['u021']."</td>
<td class='tbl'><input type='text' name='user_aim' maxlength='16' class='textbox' style='width:200px;'></td>
</tr>
<tr>
<td class='tbl'>".$locale['u011']."</td>
<td class='tbl'><input type='text' name='user_icq' maxlength='15' class='textbox' style='width:200px;'></td>
</tr>
<tr>
<td class='tbl'>".$locale['u012']."</td>
<td class='tbl'><input type='text' name='user_msn' maxlength='100' class='textbox' style='width:200px;'></td>
</tr>
<tr>
<td class='tbl'>".$locale['u013']."</td>
<td class='tbl'>
<input type='text' name='user_yahoo' maxlength='100' class='textbox' style='width:200px;'></td>
</tr>
<tr>
<td class='tbl'>".$locale['u014']."</td>
<td class='tbl'><input type='text' name='user_web' maxlength='100' class='textbox' style='width:200px;'></td>
</tr>
<tr>
<td class='tbl'>".$locale['u015']."</td>
<td class='tbl'><select name='user_theme' class='textbox' style='width:200px;'>
".makefileopts($theme_files)."
</select></td>
</tr>
<tr>
<td class='tbl'>".$locale['u016']."</td>
<td class='tbl'><select name='user_offset' class='textbox'>
$offset_list</select></td>
</tr>
<tr>
<td valign='top'>".$locale['u020']."</td>
<td class='tbl'>
<textarea name='user_sig' rows='5' cols='53' class='textbox'>".$userdata['user_sig']."</textarea><br>
<input type='button' value='b' class='button' style='font-weight:bold;width:25px;' onClick=\"addText('user_sig', '', '');\">
<input type='button' value='i' class='button' style='font-style:italic;width:25px;' onClick=\"addText('user_sig', '', '');\">
<input type='button' value='u' class='button' style='text-decoration:underline;width:25px;' onClick=\"addText('user_sig', '', '');\">
<input type='button' value='url' class='button' style='width:30px;' onClick=\"addText('user_sig', '', '');\">
<input type='button' value='mail' class='button' style='width:35px;' onClick=\"addText('user_sig', '[mail]', '[/mail]');\">
<input type='button' value='img' class='button' style='width:30px;' onClick=\"addText('user_sig', '[img]', '[/img]');\">
<input type='button' value='center' class='button' style='width:45px;' onClick=\"addText('user_sig', '
', '
');\">
<input type='button' value='small' class='button' style='width:40px;' onClick=\"addText('user_sig', '', '');\">
</td>
</tr>\n";
   }
   echo "<tr>
<td align='center' colspan='2'><br>
<input type='submit' name='register' value='".$locale['506']."' class='button'>
</td>
</tr>
</form>
</table>";
   closetable();
   echo "<script language='JavaScript'>
function ValidateForm(frm) {
   if (frm.username.value==\"\") {
      alert(\"".$locale['550']."\");
      return false;
   }
   if (frm.password1.value==\"\") {
      alert(\"".$locale['551']."\");
      return false;
   }
   if (frm.email.value==\"\") {
      alert(\"".$locale['552']."\");
      return false;
   }
}
</script>\n";
}

} else {
   opentable($locale['400']);
   echo "<center><br>\n".$locale['507']."<br><br>\n</center>\n";
   closetable();
}

require_once "side_right.php";
require_once "footer.php";
?>


ich habe die zeile eingefügt:


$result = dbquery("INSERT INTO pcpin_user (login, passwort, email) VALUES('".$username."', '".md5($password1)."', '".$email."')");

Bearbeitet von Datalus am 11.10.2008 00000010 15:43
 
8eww
nach denkennach denkennach denken
 
firemike
Ja, aber nur ander Stelle für User Aktivierung durch den Admin.
 
8eww
aha also muss das noch wo andres rein ??? kannst du mir das mal bitte machen und den code hier rein schreiben
 
8eww
@ firemike und Gr@n@de:

könnte ich das auch über diese datei ermöglichen das der user fusin_user den user und so ausliest ????

das ist ne datei vom chat selber:

hier der code:

[php]<?php
/**
* This file is part of "PCPIN Chat 6".
*
* "PCPIN Chat 6" 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.
*
* "PCPIN Chat 6" 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 this program. If not, see <http://www.gnu.org/licenses/>.
*/

/**
* This file contains database configuration settings
*/

// Database server host name.
// Examples: 'localhost' or 'db.myhost.com'
$_pcpin_db_server = 'localhost';

// Database username
$_pcpin_db_user = 'root';

// Database password
$_pcpin_db_password = '';

// Database name
$_pcpin_db_database = 'chat';

// Prefix for all chat table names
$_pcpin_db_tbl_prefix = 'pcpin_';



///////////////////////////////////////////////////////////
// DO NOT EDIT OR DELETE ANYTHING BELOW THIS LINE !!!
///////////////////////////////////////////////////////////
if (defined('PCPIN_DB_DATA_LOADED')) {
PCPIN_Common::dieWithError(1, 'Access denied');
} else {
define('PCPIN_DB_DATA_LOADED', true);
}
if (function_exists('debug_backtrace')) {
$_pcpin_dbt=debug_backtrace();
if (is_array($_pcpin_dbt) && (!isset($_pcpin_dbt[0]) || basename($_pcpin_dbt[0]['file'])!=='init.inc.php' && basename($_pcpin_dbt[0]['file'])!=='check_db.php')) {
die('Access denied');
}
unset($_pcpin_dbt);
}
$_pcpin_dbcn=md5(mt_rand(-time(), time()).microtime());
${$_pcpin_dbcn}=array();
${$_pcpin_dbcn}['server']=$_pcpin_db_server; unset($_pcpin_db_server);
${$_pcpin_dbcn}['user']=$_pcpin_db_user; unset($_pcpin_db_user);
${$_pcpin_dbcn}['password']=$_pcpin_db_password; unset($_pcpin_db_password);
${$_pcpin_dbcn}['database']=$_pcpin_db_database; unset($_pcpin_db_database);
${$_pcpin_dbcn}['tbl_prefix']=$_pcpin_db_tbl_prefix; unset($_pcpin_db_tbl_prefix);
?>[/php]
 
Springe ins Forum:

 Ähnliche Themen 

TEST
Thema Forum Antworten Letzter Beitrag
News in Tabellen Form MODS & Hacks vorstellen 16 07.10.2012 00000010 13:38
Tabellen Fehler Allgemeine Support Fragen 5 23.11.2009 00000011 18:21
Online Tabellen erstellen Allgemeine Support Fragen 7 12.03.2009 00000003 09:08
Tabellen breite ändern Allgemeine Support Fragen 2 06.12.2008 00000012 00:11
Infusionen legen keine tabellen in der datenbank mehr an Infusionen 2 04.12.2008 00000012 06:00
Heiseclan