Well, the PHPNuke site is down, no one answered my question there anyway.
If anyone has experience with PHP please help me on this:
The majority of the code from the user.php file is below.
Basicly, I need to add fields to the MySQL table and include the inputs in this file. The tables were built by PHPNuke, so I will need to adjust the MySQL tables accordingly as well.
ANY HELP on how to do this is much appreciated.
Marc
OpenTable();
echo "Username: $uname<br>"
."Email: $email<br>";
//mymodification
if (($user_avatar) || ($user_avatar!="")) echo "".translate("Avatar").": <img src=images/forum/avatar/$user_avatar><br>";
if (($url) || ($url!="")) echo "".translate("Website").": $url<br>";
if (($user_icq) || ($user_icq!="")) echo "".translate("Your ICQ").": $user_icq<br>";
if (($user_aim) || ($user_aim!="")) echo "".translate("Your AIM").": $user_aim<br>";
if (($user_yim) || ($user_yim!="")) echo "".translate("Your YIM").": $user_yim<br>";
if (($user_msnm) || ($user_msnm!="")) echo "".translate("Your MSNM").": $user_msnm<br>";
if (($user_from) || ($user_from!="")) echo "".translate("Location").": $user_from<br>";
if (($user_occ) || ($user_occ!="")) echo "".translate("Occupation").": $user_occ<br>";
if (($user_intrest) || ($user_intrest!="")) echo "".translate("Interest").": $user_intrest<br>";
if (($user_sig) || ($user_sig!="")) echo "".translate("Signature").": $user_sig<br>";
?>
<form action="user.php" method="post">
<input type="hidden" name="uname" value="<?PHP echo"$uname"; ?>">
<input type="hidden" name="email" value="<?PHP echo"$email"; ?>">
<input type="hidden" name="user_avatar" value="<?PHP echo"$user_avatar"; ?>">
<input type="hidden" name="user_icq" value="<?PHP echo"$user_icq"; ?>">
<input type="hidden" name="url" value="<?PHP echo"$url"; ?>">
<input type="hidden" name="user_from" value="<?PHP echo"$user_from"; ?>">
<input type="hidden" name="user_occ" value="<?PHP echo"$user_occ"; ?>">
<input type="hidden" name="user_intrest" value="<?PHP echo"$user_intrest"; ?>">
<input type="hidden" name="user_sig" value="<?PHP echo"$user_sig"; ?>">
<input type="hidden" name="user_aim" value="<?PHP echo"$user_aim"; ?>">
<input type="hidden" name="user_yim" value="<?PHP echo"$user_yim"; ?>">
<input type="hidden" name="user_msnm" value="<?PHP echo"$user_msnm"; ?>">
<input type="hidden" name="user_viewemail" value="<?PHP echo"$user_viewemail"; ?>">
<br><br><input type=hidden name=op value=finish><input type="submit" value="<?php echo translate("Finish"); ?>"></form>
<?PHP
CloseTable();
} else {
echo "$stop";
}
include("footer.php");
}
function finishNewUser($uname, $email, $url, $user_avatar, $user_icq, $user_occ, $user_from, $user_intrest, $user_sig, $user_viewemail, $user_aim, $user_yim, $user_msnm) {
global $stop, $makepass, $EditedMessage, $system, $adminmail, $sitename;
include("header.php");
dbconnect();
userCheck($uname, $email);
$user_regdate = date("M d, Y");
if (!isset($stop)) {
$makepass=makepass();
if(!$system)
$cryptpass=crypt($makepass);
else
$cryptpass=$makepass;
$result = mysql_query("insert into users values (NULL,'','$uname','$email','','$url','$user_avatar','$user_regdate','$user_icq','$user_occ','$user_from','$user_intrest','$user_sig','$user_viewemail','','$user_aim','$user_yim','$user_msnm','$cryptpass',10,'',0,0,0,'',0,'','','$commentlimit', '0')");
$result = mysql_query("insert into users_status values (NULL,'0','0','0','1')");
if(!$result) {
echo mysql_errno(). ": ".mysql_error(). "<br>";
} else {
$message = "".translate("Welcome to")." $sitename!\n\n".translate("You or someone else has used your email account")." ($email) ".translate("to register an account at")." $sitename. ".translate("The following is the member information:")."\n\n".translate("-Nickname: ")." $uname\n".translate("-Password: ")." $makepass";
$subject="".translate("User Password for")." $uname";
$from="$adminmail";
if ($system == 1) {
echo "".translate("Your password is: ")."<b>$makepass</b><br>";
echo "<a href=\"user.php?op=login&uname=$uname&pass=$makepass\">Login</a> to change your info";
} else {
mail($email, $subject, $message, "From: $from\nX-Mailer: PHP/" . phpversion());
OpenTable();
echo "".translate("You are now registered. You should receive your password at the email account you provided.")."";
CloseTable();
}
}
} else {
echo "$stop";
}
include("footer.php");
}
function userinfo($uname, $bypass=0) {
global $user, $cookie, $sitename;
$result = mysql_query("select femail, url, bio, user_avatar, user_icq, user_aim, user_yim, user_msnm, user_from, user_occ, user_intrest, user_sig from users where uname='$uname'");
$userinfo = mysql_fetch_array($result);
if(!$bypass) cookiedecode($user);
include("header.php");
OpenTable();
echo "<center>";
if(($uname == $cookie[1]) || ($bypass==1)) {
echo "<font size=4><center>$uname, ".translate("Welcome to")." $sitename!<br><br>";
echo "<font size=3>".translate("This is your personal page")."<br><br>";
nav();
}
echo "<font size=2>";
if((mysql_num_rows($result)==1) && ($userinfo[url] || $userinfo[femail] || $userinfo[bio] || $userinfo[user_avatar] || $userinfo[user_icq] || $userinfo[user_aim] || $userinfo[user_yim] || $userinfo[user_msnm] || $userinfo[user_location] || $userinfo[user_occ] || $userinfo[user_intrest] || $userinfo[user_sig])) {
echo "<center><font size=2>";
if ($userinfo[user_avatar]) echo "<img src=\"images/forum/avatar/$userinfo[user_avatar]\"><br>\n";
if ($userinfo[url]) { echo "".translate("My HomePage:")." <a href=\"$userinfo[url]\">$userinfo[url]</a><br>\n"; }
if ($userinfo[femail]) { echo "".translate("My E-Mail:")." <a href=\"mailto:$userinfo[femail]\">$userinfo[femail]</a><br>\n"; }
if ($userinfo[user_icq]) echo "".translate("Your ICQ: ")." $userinfo[user_icq]<br>\n";
if ($userinfo[user_aim]) echo "".translate("Your AIM: ")." $userinfo[user_aim]<br>\n";
if ($userinfo[user_yim]) echo "".translate("Your YIM: ")." $userinfo[user_yim]<br>\n";
if ($userinfo[user_msnm]) echo "".translate("Your MSNM: ")." $userinfo[user_msnm]<br>\n";
if ($userinfo[user_from]) echo "".translate("Location: ")." $userinfo[user_from]<br>\n";
if ($userinfo[user_occ]) echo "".translate("Occupation: ")." $userinfo[user_occ]<br>\n";
if ($userinfo[user_intrest]) echo "".translate("Interest: ")." $userinfo[user_intrest]<br>\n";
$userinfo[user_sig] = nl2br($userinfo[user_sig]);
if ($userinfo[user_sig]) echo "<br><b>".translate("Signature: ")." </b><br>$userinfo[user_sig]<br>\n";
if ($userinfo[bio]) { echo "<br><b>".translate("Extra Info:")." </b><br>$userinfo[bio]<br>\n"; }
echo "</center></font>";
} else {
echo "<center>".translate("There is no available info for")." $uname</center>";
}
CloseTable();
echo "<center><br><br>";
OpenTable();
echo "<b>".translate("Last 10 comments by")." $uname:</b><br>";
$result = mysql_query("select tid, sid, subject from comments where name='$uname' order by tid DESC limit 0,10");
while(list($tid, $sid, $subject) = mysql_fetch_row($result)) {
echo "<li><a href=article.php?thold=-1&mode=flat&order=0&sid=$sid#$tid>$subject</a><br>";
}
CloseTable();
echo "<br><br>";
OpenTable();
echo "<b>".translate("Last 10 news submissions sent by")." $uname:</b><br>";
$result = mysql_query("select sid, title from stories where informant='$uname' order by sid DESC limit 0,10");
while(list($sid, $title) = mysql_fetch_row($result)) {
echo "<li><a href=article.php?sid=$sid>$title</a><br>";
}
CloseTable();
echo "</center>";
include("footer.php");
}
function main($user) {
global $stop;
if(!isset($user)) {
// if (!isset($config)) { include("config.php"); }
include("header.php");
?>
<?PHP if ($stop) echo "<center><blink><marquee><h3>".translate("Incorrect Login!")."</h3></marquee></blink></center>"; ?>
<?php
if ($user) {
} else {
OpenTable();
?>
<form action="user.php" method="post">
<b><?php echo translate("User Login"); ?></b><br><br>
<?php echo translate("Nickname: "); ?><input class=textbox type="text" name="uname" size=26 maxlength=25><br>
<?php echo translate("Password: "); ?><input class=textbox type="password" name="pass" size=21 maxlength=20><br>
<input type=hidden name=op value="login">
<input type="submit" value="<?php echo translate("Login"); ?>">
</td</tr></table></td</tr></table></form>
<br>
<?php
}
OpenTable();
?>
<form name="Register" action="user.php" method="post">
<b><?php echo translate("New User:"); ?></b><br><br>
<table cellpadding=0 cellspacing border=0>
<tr><td><?php echo translate("Nickname: "); ?></td><td><input class=textbox type="text" name="uname" size=26 maxlength=25></td></tr>
<tr><td><?php echo translate("E-Mail: "); ?></td><td><input class=textbox type="text" name="email" size=25 maxlength=60></td></tr>
<tr><td><?php echo translate("Website: "); ?></td><td><input class=textbox type="text" name="url" size=25 maxlength=255></td></tr>
<tr valign=top><td><?php echo translate("Avatar: "); ?><br>[ <a href=user.php?op=avatarlist>List</a> ]</td><td>
<select name="user_avatar" onChange="showimage()">
<?
$direktori = "images/forum/avatar";
$handle=opendir($direktori);
while ($file = readdir($handle))
{
$filelist[] = $file;
}
asort($filelist);
while (list ($key, $file) = each ($filelist))
{
ereg(".gif|.jpg",$file);
if ($file == "." || $file == "..") $a=1;
else {
echo "<option value=$file>$file</option>";
}
}
?>
</select> <img src="images/forum/avatar/blank.gif" name="avatar" width="32" height="32">
</td></tr>
<tr><td><?php echo translate("Your ICQ: "); ?></td><td><input class=textbox type="text" name="user_icq" size=20 maxlength=20></td></tr>
<tr><td><?php echo translate("Your AIM: "); ?></td><td><input class=textbox type="text" name="user_aim" size=20 maxlength=20></td></tr>
<tr><td><?php echo translate("Your YIM: "); ?></td><td><input class=textbox type="text" name="user_yim" size=20 maxlength=20></td></tr>
<tr><td><?php echo translate("Your MSNM: "); ?></td><td><input class=textbox type="text" name="user_msnm" size=20 maxlength=20></td></tr>
<tr><td><?php echo translate("Location: "); ?></td><td><input class=textbox type="text" name="user_from" size=25 maxlength=60></td></tr>
<tr><td><?php echo translate("Occupation: "); ?></td><td><input class=textbox type="text" name="user_occ" size=25 maxlength=60></td></tr>
<tr><td><?php echo translate("Interest: "); ?></td><td><input class=textbox type="text" name="user_intrest" size=25 maxlength=255></td></tr>
<tr><td><?php echo translate("Option: "); ?></td><td><INPUT TYPE="CHECKBOX" NAME="user_viewemail" VALUE="1"> Allow other users to view my email address</td></tr>
<tr><td><?php echo translate("Signature: "); ?></td><td><TEXTAREA class=textbox NAME="user_sig" ROWS=6 COLS=45></TEXTAREA></td></tr>