Online-Zeit©
 168  1408  6.515  0
close× Call Us +49 (1805) 01 29 59
close×
  • Foren Themen: 3725
  • Foren Beiträge: 26383
  • Unbeantwortete Beiträge: 249
  • PHP-Fusion v7.02.07 - DE
  • PHP 8.2.20
  • Datum 27.07.2024 - Zeit Uhr

Thread Author: 8eww
Thread ID: 14
Thread Info
Es gibt 14 Beiträge zu diesem Thema, und es wurde 3719 mal angesehen.
PHPFusion-SupportClub » PHP-Fusion v6 Support » Allgemeine Support Fragen
Wer ist hier? 1 Gäste
 Thema drucken
Registrierungsdaten in 2 Tabellen schrieben
8eww
Top  #1 Beitrag drucken
Geschrieben am 26.09.2008 00000009 22:48
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
 
Website
SC-Ad-Bot
Advertisement
 
Gr@n@dE
Top  #2 Beitrag drucken
Geschrieben am 26.09.2008 00000009 22:59
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:
Code Download Code  

$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 !
 
Website
8eww
Top  #3 Beitrag drucken
Geschrieben am 26.09.2008 00000009 23:09
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
 
Website
Gr@n@dE
Top  #4 Beitrag drucken
Geschrieben am 26.09.2008 00000009 23:17
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 !
 
Website
8eww
Top  #5 Beitrag drucken
Geschrieben am 05.10.2008 00000010 17:54
kannst du mir das mal für v6 und v7 machen???

tabelle heist: pcpin_user

spalten: login, passwort, email


danke
 
Website
firemike
Top  #6 Beitrag drucken
Geschrieben am 05.10.2008 00000010 18:05
Also wie Gr@n@de schon geschrieben hatte oben:

Code Download Code  

$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 ;)
 
Website
Gr@n@dE
Top  #7 Beitrag drucken
Geschrieben am 05.10.2008 00000010 18:45
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 !
 
Website
8eww
Top  #8 Beitrag drucken
Geschrieben am 06.10.2008 00000010 03:25
ich habe es so eingefügt in die register.php asber es wird nix in die pcpin_user tabelle geschrieben
 
Website
firemike
Top  #9 Beitrag drucken
Geschrieben am 06.10.2008 00000010 06:40
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
 
Website
8eww
Top  #10 Beitrag drucken
Geschrieben am 11.10.2008 00000010 15:36
Code Download Code  

<?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:

Code Download Code  

$result = dbquery("INSERT INTO pcpin_user (login, passwort, email) VALUES('".$username."', '".md5($password1)."', '".$email."')");
Bearbeitet von Datalus am 11.10.2008 00000010 15:43
 
Website
8eww
Top  #11 Beitrag drucken
Geschrieben am 13.10.2008 00000010 03:35
nach denkennach denkennach denken
 
Website
firemike
Top  #12 Beitrag drucken
Geschrieben am 13.10.2008 00000010 06:27
Ja, aber nur ander Stelle für User Aktivierung durch den Admin.
 
Website
8eww
Top  #13 Beitrag drucken
Geschrieben am 13.10.2008 00000010 19:54
aha also muss das noch wo andres rein ??? kannst du mir das mal bitte machen und den code hier rein schreiben
 
Website
8eww
Top  #14 Beitrag drucken
Geschrieben am 16.10.2008 00000010 11:39
@ 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]
 
Website
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
SGI Fusion