-
Notifications
You must be signed in to change notification settings - Fork 0
/
chat_ajax.php
90 lines (60 loc) · 3.31 KB
/
chat_ajax.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
<?php
require_once('auth.php');
include("connection.php");
$usern=$_SESSION['SESS_USERNAME'];
$firstn=$_SESSION['SESS_FIRST_NAME'];
$lastn=$_SESSION['SESS_LAST_NAME'];
$fulln=$firstn." ".$lastn;
$gender=$_SESSION['SESS_GENDER'];
$gender= strtolower($gender);
$tid=$_POST['tid'];
$qry0="Update member set log = NOW() WHERE username='$usern'";
$done=mysql_query($qry0);
echo'<div class="chat">';
$sqlchat="SELECT category FROM topic WHERE topic_id='$tid'";
$tnme=mysql_query($sqlchat);
$ro = mysql_fetch_row($tnme);
$qry="SELECT * FROM testblob WHERE category='$ro[0]' ORDER BY image_id DESC LIMIT 0 , 20";
$result=mysql_query($qry);
while($rowori= mysql_fetch_row($result))
{
$qery="SELECT picture FROM member WHERE username='$rowori[1]'";
$prpic=mysql_query($qery);
$prpicori = mysql_fetch_row($prpic);
$usr=$_SESSION['SESS_USERNAME'];
if($usr!=$rowori[1])
{echo'<div class="row">
<!-- main col right -->
<div class="col-sm-6 ">
<div class="panel panel-success">
<div class="panel-heading"><a href="#" class="pull-left">
<img class="img-circle pull-right" src="data:image;base64,'.$prpicori[0].'">
</a> <h4 class="ubuntu"style="text-align:left;">$'.$rowori[1].'</h4></div>
<div class="panel-body text-warning">
<p class="comicfont" style="text-align:center;">'.$rowori[5].'</p>
<div class="clearfix">';
if($rowori[2]!=NULL){echo'<img class="img-thumbnail" height="100%"src="data:image;base64,'.$rowori[2].' ">';}echo'</div>
</div>
</div>
</div>
</div>';
}
else
{echo'<div class="row">
<!-- main col right -->
<div class="col-sm-6 ri">
<div class="panel panel-danger">
<div class="panel-heading"><a href="#" class="pull-left">
<img class="img-circle pull-right" src="data:image;base64,'.$prpicori[0].'">
</a> <h4 class="ubuntu"style="text-align:left;">$'.$rowori[1].'</h4></div>
<div class="panel-body text-primary">
<p class="comicfont"style="text-align:center;">'.$rowori[5].'</p>
<div class="clearfix">';
if($rowori[2]!=NULL){echo'<img class="img-thumbnail" height="100%"src="data:image;base64,'.$rowori[2].' ">';}echo'</div>
</div>
</div>
</div>
</div>';
}
}
?>