File size: 5.17Kb
Скрипт для Версия DCMS-Fiera: 1.2.3 stable , DCMS-Social v.1.7.9 beta , DCMS-Social v.1.9.0 - тестировал!
Автор Ak47res1
/**
Установка
* 1)Загрузите архив в корень сайта
* 2)Сделайте запрос в PhpMyAdmin (БД) из файла relationships.sql
* 3)Пропишите указаный код ниже в нужные файлы.
* 4)Готово)
*/
Добавить в info.php либо /user/info/wap.php и /user/info/web.php
// Ссылка отношений
<?
if ($user['id'] == $ank['id']){
echo '<div class="nav2"><img src="/style/icons/love.png"> <a href="/user/relationships/relationships.php?menu=offers">Запросы в СП</a> ('.mysql_result(mysql_query("SELECT COUNT(*) FROM `relationships_new` WHERE `id_ank` = '".$user['id']."'"),0).')</div>';
}else{
echo '<div class="nav2"><img src="/style/icons/love.png"> <a href="/user/relationships/relationships.php?id='.$ank['id'].'">Добавить в СП</a></div>';
}
?>
Также в info.php там где будет выводить информацию
<?
/*
========================================
Вывод Отношений by ak47res1
========================================
*/
if ($ank['pol']==0)$p_1 = 'Муж: '; else $p_1 = 'Жена: ';
if ($ank['pol']==1)$n_1 = 'не женат'; else $n_1 = 'не замужем';
echo '<img src="/style/icons/love.png"> '.$p_1;
$output = mysql_query("SELECT * FROM `relationships` WHERE `id_user` = '". $ank['id'] ."' AND `room_func` = '1' ORDER BY `time` ASC");
while ($post = mysql_fetch_assoc($output)){
$ank2 = mysql_fetch_assoc(mysql_query("SELECT `nick`,`id` FROM `user` WHERE `id` = '$post[id_ank]' LIMIT 1"));
echo "<a href='/info.php?id=".$ank2['id']."'>".$ank2['nick']."</a>".online($ank2['id'])."";
} if (mysql_num_rows($output) == 0)echo $n_1;
if ($ank['pol']==0)$p_2 = '<img src="/style/icons/par.png"> Парень: '; else $p_2 = '<img src="/style/icons/dev.png"> Девушка: ';
if ($ank['pol']==1)$n_2 = 'нет девушки'; else $n_2 = 'нет парня';
echo '<br />'.$p_2;
$output1 = mysql_query("SELECT * FROM `relationships` WHERE `id_user` = '". $ank['id'] ."' AND `room_func` = '2' ORDER BY `time` ASC");
while ($post = mysql_fetch_assoc($output1)){
$ank2 = mysql_fetch_assoc(mysql_query("SELECT `nick`,`id` FROM `user` WHERE `id` = '$post[id_ank]' LIMIT 1"));
echo "<a href='/info.php?id=".$ank2['id']."'>".$ank2['nick']."</a>".online($ank2['id'])."";
} if (mysql_num_rows($output1) == 0)echo $n_2;
if ($ank['pol']==0)$p_3 = 'Любовники: '; else $p_3 = 'Любовницы: ';
if ($ank['pol']==1)$n_3 = 'нет любовниц'; else $n_3 = 'нет любовников';
echo '<br /><img src="/style/icons/lubovn.png"> '.$p_3;
$output3 = mysql_query("SELECT * FROM `relationships` WHERE `id_user` = '". $ank['id'] ."' AND `room_func` = '3' ORDER BY `time` ASC");
while ($post = mysql_fetch_assoc($output3)){
$ank2 = mysql_fetch_assoc(mysql_query("SELECT `nick`,`id` FROM `user` WHERE `id` = '$post[id_ank]' LIMIT 1"));
echo "<a href='/info.php?id=".$ank2['id']."'>".$ank2['nick']."</a>".online($ank2['id']).",";
} if (mysql_num_rows($output3) == 0)echo $n_3;
echo '<br /><img src="/style/icons/det.png"> Дети: ';
$output4 = mysql_query("SELECT * FROM `relationships` WHERE `id_user` = '". $ank['id'] ."' AND `room_func` = '4' ORDER BY `time` ASC");
while ($post = mysql_fetch_assoc($output4)){
$ank2 = mysql_fetch_assoc(mysql_query("SELECT `nick`,`id` FROM `user` WHERE `id` = '$post[id_ank]' LIMIT 1"));
echo "<a href='/info.php?id=".$ank2['id']."'>".$ank2['nick']."</a>".online($ank2['id']).",";
} if (mysql_num_rows($output4) == 0)echo 'нет детей';
echo '<br /><img src="/style/icons/drug.png"> Лучшие друзья: ';
$output6 = mysql_query("SELECT * FROM `relationships` WHERE `id_user` = '". $ank['id'] ."' AND `room_func` = '6' ORDER BY `time` ASC");
while ($post = mysql_fetch_assoc($output6)){
$ank2 = mysql_fetch_assoc(mysql_query("SELECT `nick`,`id` FROM `user` WHERE `id` = '$post[id_ank]' LIMIT 1"));
echo "<a href='/info.php?id=".$ank2['id']."'>".$ank2['nick']."</a>".online($ank2['id']).",";
} if (mysql_num_rows($output6) == 0)echo 'нет лучших друзей';
echo '<br /><img src="/style/icons/vrag.png"> Враги: ';
$output7 = mysql_query("SELECT * FROM `relationships` WHERE `id_user` = '". $ank['id'] ."' AND `room_func` = '7' ORDER BY `time` ASC");
while ($post = mysql_fetch_assoc($output7)){
$ank2 = mysql_fetch_assoc(mysql_query("SELECT `nick`,`id` FROM `user` WHERE `id` = '$post[id_ank]' LIMIT 1"));
echo "<a href='/info.php?id=".$ank2['id']."'>".$ank2['nick']."</a>".online($ank2['id']).",";
} if (mysql_num_rows($output7) == 0)echo 'нет врагов';
if ($user['id'] == $ank['id']){
if (mysql_num_rows($output) >0 || mysql_num_rows($output1) >0 || mysql_num_rows($output3) >0 || mysql_num_rows($output4) >0 || mysql_num_rows($output6) >0 || mysql_num_rows($output7) >0){
echo '<br /><div class="nav2"><img src="/style/icons/del.png"> <a href="/user/relationships/relationships.php?menu=del">Удаление с СП</a></div>';
}
}
?>