Så nu er der ikke en anden vej..
Jeg har en clan hjemmeside hvor der er et controlpanel til hver user men jeg kan ikke rigtigt finde ud af at lave så mine clan-members kan uploade et billede af dem selv så nu må jeg tilstå at jeg råber om hjælp :) Det jeg vil have er at man kan skulle uploade et billede og navnet skal blivet gemt i en db under clanmemberets navn.Her er informationerne:
mappen de skal uploades i = pic
connect til databasen = include ("config.php"); :)
Tabellen = TMC_members
rummet til billednavnet = file
WHERE name='$phpclan_username'
Her er Cpanelet:
<?
include "config.php";
include ("header.php");
validateUser($phpclan_username, $phpclan_password);
if ($action == "") {cp($phpclan_username);}
elseif ($action == "teamnews") {teamNews($team);}
elseif ($action == "teamnews2") {teamNews2($phpclan_username, $phpclan_password, $team, $news);}
elseif ($action == "changeemail") {changeemail($phpclan_username);}
elseif ($action == "changeemail2") {changeemail2($phpclan_username, $phpclan_password, $email);}
elseif ($action == "changepassword") {changepassword($phpclan_username);}
elseif ($action == "changepassword2") {changepassword2($phpclan_username, $oldpass, $newpass, $newpass2);}
elseif ($action == "changeicq") {changeicq($phpclan_username);}
elseif ($action == "changeicq2") {changeicq2($phpclan_username, $phpclan_password, $nicq);}
elseif ($action == "changeprofile") {changeprofile($phpclan_username);}
elseif ($action == "showmsgs") {showmsg($phpclan_username);}
elseif ($action == "delmsg") {delmsg($msg);}
elseif ($action == "delmsg2") {delmsg2($msg);}
elseif ($action == "changeprofile2") {changeprofile2($phpclan_username, $phpclan_password, $alder, $rname, $profildata);}
elseif ($action == "pic") {pic($phpclan_username);}
include ("footer.php");
function delmsg($msg){
?>Delete message<hr><br>
Are you sure you wish to delete this message?<br>
<a href="cpanel.php?action=delmsg2&msg=<?=$msg?>">Yes</a>
<a href="cpanel.php?action=showmsg">No</a>
<?
}
function delmsg2($msg){
include("config.php");
?>Delete message 2<hr><br>
<?
$query = mysql_query("DELETE FROM TMC_msg WHERE msg='$msg'");
?>Message Deleted
<a href="cpanel.php?action=showmsgs">Go back</a><?
}
function pic($phpclan_username){ ?>
<form method=POST action=do_upload.php enctype=multipart/form-data>
<p>Upload picture:<br>
<input type=file name=img1 size=30><br>
<input type=hidden name=nam0 value"<?=$phpclan_username?>"><br>
<input type="submit" name="submit" value="Upload">
</form>
<?
}
function showmsg($username) {
?>Your Messages<hr><br><br>
<?
$all = "all";
include "config.php";
$query = mysql_query("SELECT * FROM TMC_msg WHERE person='$username' OR person='$all'");
while ($contest = mysql_fetch_array($query)) {
$contests = $contests . "<tr><td><font size=2>" . $contest['fra'] . "</font></td><td><font size=2>" . $contest['msg'] . "</font></td>
<td><font size=2><a href=\"cpanel.php?action=delmsg&msg=" . $contest['msg'] . "\">X</a></font></td></tr>";
}
?>
<table cellpadding=2 cellspacing=0 border=1 bordercolor=dimgray>
<tr>
<td><font size=2>From</font></td>
<td><font size=2>Message</font></td>
<td><font size=2>Delete</font></td>
</tr>
<?=$contests?>
</table
<?
}
function cp($username){
global $members_table, $teams_table;
?><?=$username?>'s Control Panel<hr><br>
<?
$query = mysql_query("SELECT * FROM $members_table WHERE name='$username'");
$member = mysql_fetch_array($query);
if ($member['rank'] == "leader") {
$userCommands = " - <a href=\"admin.php\" target=\"_blank\">Admin</a>";
if ($member['team'] != "") {$userCommands = $userCommands . " - <a href=\"cpanel.php?action=teamnews&team=" . $member['team'] . "\">Team News</a>";}
} elseif ($member['rank'] == "team leader") {
if ($member['team'] != "") {$userCommands = " - <a href=\"cpanel.php?action=teamnews&team=" . $member['team'] . "\">Team News</a>";}
}
if ($member['team'] != "") {
$memberteam = $member['team'];
$query = mysql_query("SELECT * FROM $teams_table WHERE name='$memberteam'");
$team = mysql_fetch_array($query);
$teamInfo = "Team " . $member['team'] . "<hr><br><b>NEWS:</b><br>" . $team['news'] . "<br><br><center><a href=\"members.php?action=listteam&team=" . $team['name'] . "\">Team Members</a> - <a href=\"forum.php?forum=" . $team['name'] . "\">Team Forum</a></center>";
}
?>
<center>
<a href="cpanel.php?action=changeemail">Change Email</a> -
<a href="cpanel.php?action=changepassword">Change Password</a> -
<a href="cpanel.php?action=changeicq">Change ICQ</a> -
<a href="cpanel.php?action=changeprofile">Change Profile</a> -
<a href="cpanel.php?action=showmsgs">View Your Messages</a>
<?=$userCommands?>
</center><br><br><br>
<?=$teamInfo?>
<?
}
function changepassword($username){
global $members_table;
?>Control Panel Change Password<hr><br>
<?
$query = mysql_query("SELECT * FROM $members_table WHERE name='$username'");
$member = mysql_fetch_array($query);
?>
<b>Change Password:</b>
<form method="post"action=cpanel.php>
<input type=hidden name=action value="changepassword2">
<table cellpadding=4 cellspacing=0 border=0>
<tr>
<td><font size=2>Old Password</font></td>
<td><input type=password name=oldpass></td>
</tr>
<tr>
<td><font size=2>New Password</font></td>
<td><input type=password name=newpass></td>
</tr>
<tr>
<td><font size=2>Confirm Password</font></td>
<td><input type=password name=newpass2></td>
</tr>
<tr><td></td><td><input type=submit value="Change Password"></td></tr>
</table>
</form>
<?
}
function changepassword2($username, $oldpass, $newpass, $newpass2){
global $members_table;
$query = mysql_query("SELECT * FROM $members_table WHERE name='$username'");
$member = mysql_fetch_array($query);
if ($oldpass != $member['password']) {die("<font face=verdana size=2>Incorrect password.</font>");}
if ($newpass != $newpass2) {die("<font face=verdana size=2>New Passwords did not match.</font>");}
$query = mysql_query("UPDATE $members_table SET password='$newpass' WHERE name='$username'");
?>Password Updated. You will need to logout and then login again to update your cookies.<br>
<a href="index.php?action=logout">Logout</a>.<?
}
function changeemail($username){
global $members_table;
?>Control Panel Change Email<hr><br>
<?
$query = mysql_query("SELECT * FROM $members_table WHERE name='$username'");
$member = mysql_fetch_array($query);
?>
<b>Change Email</b>
<form method="post"action=cpanel.php>
<input type=hidden name=action value=changeemail2>
<input name=email size=50 value="<?=$member['email']?>"><br><input type=submit value="Change Email">
</form>
<?
}
function changeicq($username){
global $members_table;
?>Control Panel Change ICQ-Number<hr><br>
<?
$query = mysql_query("SELECT * FROM $members_table WHERE name='$username'");
$member = mysql_fetch_array($query);
?>
<b>Change ICQ-number</b>
<form method="post"action=cpanel.php>
<input type=hidden name=action value=changeicq2>
<input name=nicq size=50 value="<?=$member['icq']?>"><br><input type=submit value="Change ICQ">
</form>
<?
}
function changeprofile($username){
global $members_table;
?>Control Panel Change Your profile:<hr><br>
<?
$query = mysql_query("SELECT * FROM $members_table WHERE name='$username'");
$member = mysql_fetch_array($query);
$profildata = str_replace("<br>", "\n", $member['profildata']);
$profildata = str_replace("\\'", "\'", $member['profildata']);
?>
<b>Change Your profile:</b><br>
<form method="post" action=cpanel.php ENCTYPE="multipart/form-data">
<input type=hidden name=action value=changeprofile2>
<b>Change Your Real name:</b><br>
<input name=rname size=50 value="<?=$member['rname']?>"><br>
<b>Change your age:</b><br>
<input name=alder size=50 value="<?=$member['age']?>"><br>
<b> Change Your Profile desciption(text):</b><br>
<textarea cols=70 rows=8 name=profildata><?=$member['profildata']?>
<?=$data['profildata']?></textarea><br><br>
<b> Change Your Picture (Only Gif and Jpg pictures): </b><br>
<input type=submit value="Change Profile">
</form>
<?
}
function changeprofile2($username, $password, $alder, $rname, $profildata){
global $members_table;
?>Control Panel Change your profile 2<hr><br>
<?
$query = mysql_query("SELECT * FROM $members_table WHERE name='$username'");
$member = mysql_fetch_array($query);
$query = mysql_query("UPDATE TMC_members SET rname='$rname', age='$alder', profildata='$profildata' WHERE name='$username'");
?>Profile updated.
<?
}
function changeicq2($username, $password, $nicq){
global $members_table;
?>Control Panel Change ICQ-number 2<hr><br>
<?
$query = mysql_query("SELECT * FROM $members_table WHERE name='$username'");
$member = mysql_fetch_array($query);
$query = mysql_query("UPDATE TMC_members SET icq='$nicq' WHERE name='$username'");
?>ICQ-number Updated
<?
}
function changeemail2($username, $password, $email){
global $members_table;
?>Control Panel Change Email 2<hr><br>
<?
$query = mysql_query("SELECT * FROM $members_table WHERE name='$username'");
$member = mysql_fetch_array($query);
$query = mysql_query("UPDATE $members_table SET email='$email' WHERE name='$username'");
?>Email Updated
<?
}
function teamNews2($username, $password, $team, $news) {
global $teams_table, $members_table;
$query = mysql_query("SELECT * FROM $members_table WHERE name='$username'");
if ($query == "") {die("<font face=verdana size=2>Invalid user/pass. You may need to logout and then login again.</font>");}
$member = mysql_fetch_array($query);
if ($password != $member['password']) {die("<font face=verdana size=2>Invalid user/pass. You may need to logout and then login again.</font>");}
if (($member['rank'] != "team leader") && ($member['rank'] != "leader")) {die("You are not authorized to post news for this team.");}
?>Admin Team News 2<hr><br>
<?
$news = str_replace("\n", "\<br\>", $news);
$news = str_replace("\'", "\\'", $news);
$query = mysql_query("UPDATE $teams_table SET news='$news' WHERE name='$team'");
?>Team News Updated<?
}
function teamNews($team) {
global $teams_table;
?>Admin Team News<hr><br>
<?
$query = mysql_query("SELECT * FROM $teams_table WHERE name='$team'");
$thisteam = mysql_fetch_array($query);
$thisteam['news'] = str_replace("<br>", "\n", $thisteam['news']);
?>News:<br>
<?=$thisteam['news']?><br><br>
What should be <?=$team?>'s news<br>
<form method="post"action=cpanel.php>
<input type=hidden name=team value="<?=$team?>">
<input type=hidden name=action value="teamnews2">
<textarea cols=70 rows=8 name=news><?=$thisteam['news']?></textarea><br>
<input type=submit value="Edit News">
</form>
<?
}
function validateUser ($username, $password){
global $members_table;
$query = mysql_query("SELECT * FROM $members_table WHERE name='$username'");
if ($query == "") {die("<font face=verdana size=2>Invalid user/pass. You may need to logout and then login again.</font>");}
$member = mysql_fetch_array($query);
if ($password != $member['password']) {die("<font face=verdana size=2>Invalid user/pass. You may need to logout and then login again.</font>");}
}
?>
PS Ved godt at 200 points ikke er meget men det er max :(
