· 9 years ago · Feb 21, 2017, 05:26 PM
1<?php
2date_default_timezone_set('Europe/Kiev');
3
4error_reporting(E_ALL);
5
6$mysql_database="lovedbnk_dating";
7$mysql_username="root";
8$mysql_password="";
9$mysql_host="localhost";
10
11$db = mysql_connect($mysql_host, $mysql_username, $mysql_password) or die(mysql_error());
12mysql_select_db($mysql_database,$db) or die(mysql_error());
13
14?>
15
16 <div class="col-lg-6 col-xs-12 col-sm-12">
17 <div class="portlet light bordered">
18 <div class="portlet-title">
19 <div class="caption">
20 <i class="icon-share font-dark hide"></i>
21 <span class="caption-subject font-dark bold uppercase">Ðовые неотвеченные чаты от мужчины</span>
22 </div>
23 <div class="actions">
24 <div class="btn-group">
25 <a class="btn btn-sm blue btn-outline btn-circle" href="javascript:;" data-toggle="dropdown" data-hover="dropdown" data-close-others="true"> Filter By
26 <i class="fa fa-angle-down"></i>
27 </a>
28 <div class="dropdown-menu hold-on-click dropdown-checkboxes pull-right">
29 <label class="mt-checkbox mt-checkbox-outline">
30 <input type="checkbox" /> Finance
31 <span></span>
32 </label>
33 <label class="mt-checkbox mt-checkbox-outline">
34 <input type="checkbox" checked="" /> Membership
35 <span></span>
36 </label>
37 <label class="mt-checkbox mt-checkbox-outline">
38 <input type="checkbox" /> Customer Support
39 <span></span>
40 </label>
41 <label class="mt-checkbox mt-checkbox-outline">
42 <input type="checkbox" checked="" /> HR
43 <span></span>
44 </label>
45 <label class="mt-checkbox mt-checkbox-outline">
46 <input type="checkbox" /> System
47 <span></span>
48 </label>
49 </div>
50 </div>
51 </div>
52 </div>
53 <div class="portlet-body">
54 <div class="scroller" style="height: 300px;" data-always-visible="1" data-rail-visible="0">
55 <ul class="feeds">
56
57
58 <?php
59 // делаем выборку из таблицы
60$result=mysql_query("SELECT * FROM `pg_fchat_message` WHERE `status`='unread' ORDER BY `pg_fchat_message`.`date` DESC");
61
62// полученное преобразовываем в маÑÑив
63while ($row=mysql_fetch_array($result))
64{ // Получаем переменные
65$chatid = $row['chat_id'];
66$author_id = $row['author'];
67//ДоÑтаём учаÑтников выбранного чата
68$chatidusers=mysql_query("SELECT * FROM `pg_fchat` WHERE `id`='$chatid'");
69$chatidusers_r=mysql_fetch_array($chatidusers); //преобразовываем в маÑÑив
70$first_user = $chatidusers_r['first_user']; // Первый пользователь ID
71$second_user = $chatidusers_r['second_user']; // Второй пользователь ID
72//доÑтаём Ðвтора ÑÐ¾Ð¾Ð±Ñ‰ÐµÐ½Ð¸Ñ Ð´Ð»Ñ Ð¿Ñ€Ð¾Ð²ÐµÑ€ÐºÐ¸ на Мужика
73$author=mysql_query("SELECT * FROM `pg_users` WHERE `id`='$author_id'");
74$author_r=mysql_fetch_array($author); // МаÑÑив Ñ Ð¸Ð½Ñ„Ð¾Ð¹ об авторе ÑообщениÑ
75//Получаем инфо о первом пользователе
76$userinfo=mysql_query("SELECT * FROM `pg_users` WHERE `id`='$first_user'");
77$userinfo_r=mysql_fetch_array($userinfo); // получаем маÑÑив, например Ð¸Ð¼Ñ Ð¿ÐµÑ€Ð²Ð¾Ð³Ð¾ учаÑтника чата $userinfo_r['nickname']
78//Получаем инфо о втором пользователе
79$user2info=mysql_query("SELECT * FROM `pg_users` WHERE `id`='$second_user'");
80$user2info_r=mysql_fetch_array($user2info); // получаем маÑÑив, например Ð¸Ð¼Ñ Ð²Ñ‚Ð¾Ñ€Ð¾Ð³Ð¾ учаÑтника чата $user2info_r['nickname']
81
82
83if($author_r['user_type']=='male'){ //ПроверÑем автора ÑÐ¾Ð¾Ð±Ñ‰ÐµÐ½Ð¸Ñ Ð½Ð° мужÑкой пол
84
85 ?><li>
86 <div class="col1">
87 <div class="cont">
88 <div class="cont-col1">
89 <div class="label label-sm label-success">
90 <i class="fa fa-user"></i>
91 </div>
92 </div>
93 <div class="cont-col2">
94 <div class="desc"> <?php echo 'Chat ID: '.$row['chat_id'].' | '.$userinfo_r['nickname'].'('.$userinfo_r['id'].')'.' | '.$user2info_r['nickname'].'('.$user2info_r['id'].')'.' | '.$row['date'].' '.$row['time'].' | Открыть чат <br>';?> </div>
95 </div>
96 </div>
97 </div>
98 <div class="col2">
99 <div class="date"></div>
100 </div>
101 </li>
102
103 <?php
104}
105
106
107}// /while
108 ?>
109
110
111 </ul>
112 </div>
113 </div>
114 </div>
115 </div>
116 <div class="scroller-footer">
117
118 </div>
119 </div>
120 </div>
121 </div>
122 </div>
123
124
125-------------------------------------------------------------------------------------------------------------------------------------
126"База данных"
127--
128-- Структура таблицы `pg_fchat`
129--
130
131CREATE TABLE IF NOT EXISTS `pg_fchat` (
132 `id` int(11) NOT NULL AUTO_INCREMENT,
133 `first_user` int(11) NOT NULL,
134 `second_user` int(11) NOT NULL,
135 `status` int(11) NOT NULL,
136 `inform` varchar(255) NOT NULL,
137 PRIMARY KEY (`id`)
138) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=3267 ;
139
140--
141-- Дамп данных таблицы `pg_fchat`
142--
143
144INSERT INTO `pg_fchat` (`id`, `first_user`, `second_user`, `status`, `inform`) VALUES
145(17, 17, 175, 1, 'viewed'),
146(18, 17, 171, 1, 'opened'),
147-------------------------------------------------------------------------------------------------------------------------------------
148--
149-- Структура таблицы `pg_fchat_message`
150--
151
152CREATE TABLE IF NOT EXISTS `pg_fchat_message` (
153 `id` int(11) NOT NULL AUTO_INCREMENT,
154 `chat_id` int(11) NOT NULL,
155 `author` int(11) NOT NULL,
156 `message` text NOT NULL,
157 `date` date NOT NULL,
158 `time` time NOT NULL,
159 `status` varchar(100) NOT NULL,
160 PRIMARY KEY (`id`)
161) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=17156 ;
162
163--
164-- Дамп данных таблицы `pg_fchat_message`
165--
166
167INSERT INTO `pg_fchat_message` (`id`, `chat_id`, `author`, `message`, `date`, `time`, `status`) VALUES
168(2016, 17, 17, ' %s6%', '2016-12-29', '23:44:04', 'inform'),
169(2018, 39, 105, 'Are you here?)', '2016-12-30', '02:11:11', 'unread'),
170(2019, 41, 105, 'Are you here?)', '2016-12-30', '02:11:17', 'inform'),
171-------------------------------------------------------------------------------------------------------------------------------------
172
173--
174-- Структура таблицы `pg_users`
175--
176
177CREATE TABLE IF NOT EXISTS `pg_users` (
178 `id` int(3) NOT NULL AUTO_INCREMENT,
179 `date_created` datetime NOT NULL,
180 `date_modified` datetime NOT NULL,
181 `email` varchar(50) NOT NULL,
182 `nickname` varchar(20) NOT NULL,
183 `user_type` varchar(50) NOT NULL,
184 `password` varchar(50) NOT NULL,
185 `confirm` tinyint(3) NOT NULL,
186 `approved` tinyint(3) NOT NULL,
187 `activity` tinyint(3) NOT NULL,
188 `confirm_code` varchar(10) NOT NULL DEFAULT '',
189 `fname` varchar(100) NOT NULL,
190 `sname` varchar(100) NOT NULL,
191 и т.д.
192
193--
194-- Дамп данных таблицы `pg_users`
195--
196
197INSERT INTO `pg_users` (`id`, `date_created`, `date_modified`, `email`, `nickname`, `user_type`, `password`, `confirm`, `approved`, `activity`, `confirm_code`, `fname`, `sname`, и т.д.) VALUES
198
199(175, '2016-12-15 19:30:55', '2017-02-13 15:09:21', '01750@lovedating.cc', 'Olha', 'female', '5dada4cfbe5f38c448ef89dfccb9e15d', 1, 1, 1, '', 'Olha', '', 1, '', 'ce4f3ab955.jpg', и т.д.),
200(171, '2016-11-27 04:20:52', '2017-02-17 12:54:15', '3rvngt4wt1@carrref.org', 'Ms-MMM', 'male', и т.д.),
201-------------------------------------------------------------------------------------------------------------------------------------