songs300/singer_overview.php at master · allomani/songs300 · GitHub

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
<?php
/**
 *  Allomani Audio & Video (Songs) v3.0
 *
 * @package Allomani.Songs
 * @version 3.0
 * @copyright (c) 2006-2018 Allomani , All rights reserved.
 * @author Ali Allomani <info@allomani.com>
 * @link http://allomani.com
 * @license GNU General Public License version 3.0 (GPLv3)
 *
 */

require("global.php");

require(CWD . "/includes/framework_start.php");
//---------------------------------------------------------
//open_table($phrases['singer_videos']);
templates_cache(array('singer_overview','singer_info_table','browse_photos','prev_next_singer','browse_videos_header','browse_videos','browse_videos_footer'));

// $qra = db_query("select songs_videos_data.* from songs_videos_data,songs_videos_tags where songs_videos_data.id=songs_videos_tags.video_id and songs_videos_tags.singer_id='$id' order by songs_videos_data.id desc");

 $qr=db_query("select * from songs_singers where id='$id' and active=1");

    if(db_num($qr)){
         unset($data_singer);


         $data = db_fetch($qr);

     db_query("update songs_singers set views=views+1 where id='$id'");
         $data_singer = $data;
     //    $data_singer['songs_count'] = valueof(db_qr_fetch("select count(*) as count from songs_songs where album='$id'"),"count");
      //    $data_singer['albums_count'] = valueof(db_qr_fetch("select count(*) as count from songs_albums where cat='$id'"),"count");
      //   $data_singer['photos_count'] = valueof(db_qr_fetch("select count(*) as count from songs_singers_photos where cat='$id'"),"count");
      //   $data_singer['videos_count'] = valueof(db_qr_fetch("select count(*) as count from songs_videos_tags where singer_id='$id'"),"count");
   //   $data_singer['videos_count'] = valueof(db_qr_fetch("select count(*) as count from songs_songs where album='$id' and video_id > 0"),"count");

     //     $data4 = db_qr_fetch("select date from songs_songs where album='$id' order by date DESC limit 1");
         $data_cat = db_qr_fetch("select * from songs_cats where id='$data[cat]'");

   print "<span class='path'> <img src='images/arrw.gif' border=0> <a class=path_link href=\"".cat_url($data_cat['id'],$data_cat['page_name'],$data_cat['name'])."\" title=\"$data_cat[name]\">$data_cat[name]</a> $phrases[path_sep] <a class=path_link href=\"".singer_url($data['id'],$data['page_name'],$data['name'])."\" title=\"$data[name]\">$data[name]</a>  ";

   print"<br><br> </span>" ;


 compile_hook('songs_after_path_links');
   run_template('singer_info_table');
compile_hook('songs_after_singer_table');
//unset($data_singer);


$qr_photos = db_query("select * from songs_singers_photos where cat='$id' order by ord asc limit $settings[overview_photos_limit]");
$qr_videos = db_query("select songs_videos_data.* from songs_videos_data,songs_songs where songs_videos_data.id = songs_songs.video_id and songs_songs.album='$id' limit $settings[overview_videos_limit]");


$no_singer_name = true;
run_template('singer_overview');


if($settings['prev_next_singer']){
prev_next_singer($id,$data_singer['cat']);
}


    }else{
        open_table();
        print " <center> $phrases[err_wrong_url] </center>";
        close_table();
    }
//---------------------------------------------
require(CWD . "/includes/framework_end.php");
?>