|
Friend_System updated
|
|
Topic Started: Jun 3 2009, 06:25 PM (236 Views)
|
|
hansmaulwurf
|
Jun 3 2009, 06:25 PM
Post #1
|
|
- Posts:
- 10
- Group:
- Members
- Member
- #54
- Joined:
- Apr 30, 2009
|
hi,
i tried the friend_system from admin but i wasn't satisfied with that. so i nearly wrote my own one. the problem was, that you had to request a friendship from both sides. now it proofs if the friendship is already in the table.
i used only one table. for the activation i included the field aktiv. by a request it gets an 0 when the other user accepted the request in gets an 1.
check this out:
SQL
- Code:
-
CREATE TABLE IF NOT EXISTS `friends` ( `id` int(10) NOT NULL auto_increment, `friendname` varchar(225) NOT NULL default '', `username` varchar(225) NOT NULL default '', `aktiv` int(1) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ;
newfriends.php
- Code:
-
<? echo "<br>Freundschaftseinladungen<br><br>";
/* Requested Username error checking */ $req_user = trim($_GET['user']);
switch ($_GET[friends]) { //allows multiple pages default: $get = mysql_query( "SELECT * FROM friends WHERE username = '$session->username' AND aktiv = '0'"); //gets requests while ($reqs = mysql_fetch_array($get)) {
echo ( "<br>Anfragen<br> $reqs[friendname] möchte dein Freund werden.<br> <a href='main.php?section=neuefreunde&friends=accept&user=$reqs[friendname]'>Annehmen</a><br/> <a href='main.php?section=neuefreunde&friends=delete&user=$reqs[friendname]'>Ablehnen</a><br><br>" ); //displays requests and shows accept delete links } break;
case 'accept': //accept page if ($session->logged_in) { //get username
$add = mysql_query( "UPDATE friends SET aktiv = 1 WHERE friendname = '$req_user' "); // add to your friends list echo ( "$req_user ist jetzt dein Freund." ); // echos the completion } break; //ends accept page
case 'delete': // delete page if ($req_user) { //gets username $delete = mysql_query( "DELETE FROM friends WHERE friendname = '$req_user' AND username = '$session->username'"); // deletes friend request echo ( "$req_user's Anfrage wurde abgelehnt" ); // echos completion } break; //ends delete page } // ends switch
?>
friendrequest.php
- Code:
-
<?
/* Requested Username error checking */ $req_user = trim($_GET['user']);
echo "<br>Freundesanfrage<br>";
if ($req_user){ //gets username $username = htmlspecialchars($req_user); //friend $by = $session->username; //you
$proof = mysql_query( "SELECT * FROM friends WHERE username = '$session->username' AND friendname = '$username' || friendname = '$session->username' AND username = '$username'" ); //if($proof) //{ $num_rows = mysql_num_rows($proof); if($num_rows) { $friends = mysql_fetch_array($proof); if($friends[aktiv] == '0') { echo "Du hast bereits eine Einladung an $username verschickt!"; } else { echo "$req_user ist bereits dein Freund!"; } } else { $query = mysql_query("INSERT INTO friends ( username , friendname ) VALUES ( '$username' , '$by' )"); //inserts the request echo ( "$username hat die Anfrage erhalten." ); //echos completion }
} ?>
friendlist.php
- Code:
-
<? echo "<br>Meine Freunde<br>";
$getfriends = mysql_query( "SELECT * FROM friends WHERE username = '$session->username' AND aktiv = 1 || friendname = '$session->username' AND aktiv = 1" ); while ($friends = mysql_fetch_array($getfriends)) { if($friends[friendname] != $session->username) echo "<a href='main.php?section=profil&user=$friends[friendname]'>$friends[friendname]</a> <br>"; else echo "<a href='main.php?section=profil&user=$friends[username]'>$friends[username]</a> <br>";
}
?>
i tried it out and i found no problems.
greetings hans
|
|
|
| |
|
laurens
|
Jun 29 2009, 03:12 PM
Post #2
|
|
- Posts:
- 57
- Group:
- Contributor
- Member
- #55
- Joined:
- May 9, 2009
|
let me guess.. you're from germany XD
|
|
|
| |
|
scottjcampbell
|
Jun 30 2009, 02:49 PM
Post #3
|
|
- Posts:
- 41
- Group:
- Members
- Member
- #9
- Joined:
- Apr 6, 2008
|
haha
|
|
|
| |
|
Admin
|
Jul 3 2009, 02:07 AM
Post #4
|
|
Administrator
- Posts:
- 303
- Group:
- Admins
- Member
- #1
- Joined:
- Mar 20, 2008
|
nj havent looked through it but mine was buggy
|
|
|
| |
|
hansmaulwurf
|
Jul 4 2009, 08:55 AM
Post #5
|
|
- Posts:
- 10
- Group:
- Members
- Member
- #54
- Joined:
- Apr 30, 2009
|
ich bin ein berliner...
|
|
|
| |
|
scottjcampbell
|
Jul 4 2009, 02:39 PM
Post #6
|
|
- Posts:
- 41
- Group:
- Members
- Member
- #9
- Joined:
- Apr 6, 2008
|
what language is tht?
|
|
|
| |
|
hansmaulwurf
|
Jul 4 2009, 03:04 PM
Post #7
|
|
- Posts:
- 10
- Group:
- Members
- Member
- #54
- Joined:
- Apr 30, 2009
|
its a quote from kennedy! he said this in good old germany...
|
|
|
| |
|
scottjcampbell
|
Jul 5 2009, 06:18 PM
Post #8
|
|
- Posts:
- 41
- Group:
- Members
- Member
- #9
- Joined:
- Apr 6, 2008
|
ooohhhhh no wonder i got confuzzled 
i google translated it from german but it came up the same and i was like :S
|
|
|
| |
| 1 user reading this topic (1 Guest and 0 Anonymous)
|