-
Notifications
You must be signed in to change notification settings - Fork 0
/
connectedfriends.php
101 lines (89 loc) · 3.83 KB
/
connectedfriends.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
<?php
@session_start();
try
{
$bdd = new PDO('mysql:host=localhost;dbname=qyizbowl;charset=utf8', 'root', '0000');
array(PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION);
}
catch(Exception $e)
{
die('Erreur : '.$e->getMessage());
}
if(isset($_POST['allFriends']) && isset($_POST['width'])){
$p = htmlspecialchars($_POST['allFriends']);
$w = htmlspecialchars($_POST['width']);
if($w >= 800){
$req3 = $bdd->prepare('SELECT iduser1, iduser2 FROM amis WHERE (iduser2 = :iduser2 OR iduser1 = :iduser1) AND status = :status');
$req3->execute(array(
'iduser2' => $p,
'iduser1' => $p,
'status' => 1));
while ($resultat3 = $req3->fetch()) {
if($resultat3['iduser1']==$p){
$id =$resultat3['iduser2'];
}else{
$id =$resultat3['iduser1'];
}
$req = $bdd->prepare('SELECT avatarimageurl, pseudo, large, bio FROM members WHERE id = :id');
$req->execute(array(
'id' => $id));
$resultat = $req->fetch();
?>
<div class="newavatar" id="block,<?php echo $id;?>">
<a href="profile.php?pseudo=<?php echo $resultat['pseudo']; ?>"><div class="backlarge" style="background-image: url(profilesimages/<?php echo $resultat['large'];?>);"></div></a>
<div class="mainimage" style="background-image: url(profilesimages/mini/<?php echo $resultat['avatarimageurl'];?>);"><a href="profile.php?pseudo=<?php echo $resultat['pseudo']; ?>"></a></div>
<div class="friendPseudo"><p><?php echo $resultat['pseudo'];?></p><?php if($p==$_SESSION['id']){ ?><button class="eleminer" id="un,<?php echo $id;?>">Unfriend</button><?php } ?></div>
<div class="friendBio"><p><?php echo $resultat['bio'];?></p></div>
</div>
<?php
}
}else{
$req3 = $bdd->prepare('SELECT iduser1, iduser2 FROM amis WHERE (iduser2 = :iduser2 OR iduser1 = :iduser1) AND status = :status');
$req3->execute(array(
'iduser2' => $p,
'iduser1' => $p,
'status' => 1));
while ($resultat3 = $req3->fetch()) {
if($resultat3['iduser1']==$p){
$id =$resultat3['iduser2'];
}else{
$id =$resultat3['iduser1'];
}
$req = $bdd->prepare('SELECT avatarimageurl, pseudo FROM members WHERE id = :id');
$req->execute(array(
'id' => $id));
$resultat = $req->fetch();
?>
<div class="newavatar" id="block,<?php echo $id;?>" style="width: 100%; height: 60px; display: flex;">
<div class="mainimage" style="min-width: 60px; min-height: 60px; bottom: 0; left: 0; margin: auto 0; background-image: url(profilesimages/mini/<?php echo $resultat['avatarimageurl'];?>);"><a href="profile.php?pseudo=<?php echo $resultat['pseudo']; ?>"></a></div>
<div class="friendPseudo" style="margin: auto 10px; left: 0; top: 0; width: 90%;"><p><?php echo $resultat['pseudo'];?></p><?php if($p==$_SESSION['id']){ ?><button style="max-width: 80px;" class="eleminer" id="un,<?php echo $id;?>">Unfriend</button><?php } ?></div>
</div>
<?php
}
}
}
if(isset($_POST['fm'])){
$req3 = $bdd->prepare('SELECT iduser1, iduser2 FROM amis WHERE (iduser2 = :iduser2 OR iduser1 = :iduser1) AND status = :status');
$req3->execute(array(
'iduser2' => $_SESSION['id'],
'iduser1' => $_SESSION['id'],
'status' => 1));
while ($resultat3 = $req3->fetch()) {
if($resultat3['iduser1'] == $_SESSION['id']){
$id = $resultat3['iduser2'];
}else{
$id = $resultat3['iduser1'];
}
$req = $bdd->prepare('SELECT avatarimageurl, pseudo FROM members WHERE id = :id');
$req->execute(array(
'id' => $id));
$resultat = $req->fetch();
?>
<div class="newavatar bit" id="block,<?php echo $id;?>" style="width: 100%; height: 60px; display: flex;">
<div class="mainimage" style="min-width: 60px; min-height: 60px; bottom: 0; left: 0; margin: auto 0; background-image: url(profilesimages/mini/<?php echo $resultat['avatarimageurl'];?>);"><a href="profile.php?pseudo=<?php echo $resultat['pseudo']; ?>"></a></div>
<div class="friendPseudo" style="margin: auto 10px; left: 0; top: 0; width: 90%;"><p><?php echo $resultat['pseudo'];?></p></div>
</div>
<?php
}
}
?>