Avatar billede neo_bill Nybegynder
07. marts 2002 - 20:41 Der er 7 kommentarer og
1 løsning

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 :(
Avatar billede gizmo-gizmo Nybegynder
07. marts 2002 - 20:46 #1
For sat.. en lang kode. Hva med at dele det lidt op? :-)
Avatar billede neo_bill Nybegynder
07. marts 2002 - 20:52 #2
Det kan vi godt sige brb
Avatar billede gizmo-gizmo Nybegynder
07. marts 2002 - 20:53 #3
nej nej, det var bare et foreslag. Det kan blive umuligt at overskue så meget kode senere
Avatar billede neo_bill Nybegynder
07. marts 2002 - 20:55 #4
// formen

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

// man skal kunne uploade et billede med den her...
/* den her håndterer så dataerne - den skal så kunne det der uploaderæs og og  det med at registrere det i db'en */

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.
<?
}
Avatar billede thomashove Nybegynder
08. marts 2002 - 12:53 #5
Ved ikke helt hvad dit problem er...(uploade billedet, gemme data i DB eller hvad...?) men her er et lille test script til at uploade billeder :

<?
if ($Upload_billede)
{
  $archive_dir = "pics"; //mappe hvor billedet skal gemmes
  $filename = ($picture_name); //billedets navn
  $filepath = $archive_dir."/".$filename; //stien til billedet
  copy($picture, $filepath);  //kopiere billedet til mappen
}
?>


<html>
<form method="post" action='test.php' ENCTYPE='MULTIPART/FORM-DATA'>

<input type='file' name='picture'>

<input type=submit value='upload' name='Upload_billede'>
</form>
</html>
Avatar billede thomashove Nybegynder
08. marts 2002 - 12:56 #6
går ud fra at du er klar over, at når brugeren har uploadet en fil (f.eks et billede - $picture) kan du sige :

$picture    = temporary file.
$picture_size  = filesize
$picture_name  = filename
$picture_type  = the MIME type of the file.  Browser specific.
Avatar billede neo_bill Nybegynder
08. marts 2002 - 15:50 #7
Well thomashove, dit script virker nice! men det mangler at chekke om det er gif / jpg ..?

Det er det jeg har størst problemer med. Ps det skal køre på apache - ved ik om det spiller en rolle :)

- BRE
Avatar billede thomashove Nybegynder
08. marts 2002 - 16:16 #8
jamen så udvider vi da bare lige test scriptet... ;o)

<?
if ($Upload_billede)
{
  $archive_dir = "pics"; //mappe hvor billedet skal gemmes
  $filename = ($picture_name); //billedets navn
  $filepath = $archive_dir."/".$filename; //stien til billedet
 
  if ($picture_type != "image/pjpeg" and $picture_type != "image/gif")
  {
    die("fy fy - kun billeder af typen jpg eller gif");
  }
  else
  {
    copy($picture, $filepath);  //kopiere billedet til mappen
  }

}
?>


<html>
<form method="post" action='test.php' ENCTYPE='MULTIPART/FORM-DATA'>

<input type='file' name='picture'>

<input type=submit value='upload' name='Upload_billede'>
</form>
</html>

du kan ved at sige echo($picture_type); se MIME typen på den fil der uploades - du skal dog være opmærksom på at ikke alle browsere understøtter denne funktion (men alle nye gør dog)
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Vi tilbyder markedets bedste kurser inden for webudvikling

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester

IT-JOB