AAC Znote Acc Active casters error

Discussion in 'Support' started by Niioxce, Feb 17, 2017 at 12:42 AM.

  1. Niioxce

    Niioxce Otland lurker

    Joined:
    Jun 22, 2012
    Messages:
    292
    Likes Received:
    2
    Best Answers:
    0
    I dont even know what "active casters" is tbh, but anyway it's annoying and i wonder if i can fix it or get rid of it [​IMG]
    Error:
    Code (Text):
    1.  
    2. [LIST]
    3. string(93) "SELECT * FROM players WHERE group_id < 2 AND broadcasting = 1 ORDER BY viewers DESC LIMIT 5;"
    4. (query - SQL error)
    5. Type: select_multi (select multiple rows from database)
    6.  
    7. Unknown column 'broadcasting' in 'where clause'
    8. [/LIST]
    9. [LIST]
    10.  
    [/LIST]
     
  2. Niioxce

    Niioxce Otland lurker

    Joined:
    Jun 22, 2012
    Messages:
    292
    Likes Received:
    2
    Best Answers:
    0
  3. Chris

    Chris Inactive

    Joined:
    Aug 11, 2008
    Messages:
    2,628
    Likes Received:
    235
    Best Answers:
    2
    Active casters are most likely referring to people whom are casting their gameplay for others to see (like TibiaCast). The error itself is due to a missing column broadcasting within the players table. You can amend this by adding it through your MySQL interface (phpMyAdmin or whatever you use).

    Code (Text):
    1. ALTER TABLE `players` ADD `broadcasting` INTEGER(11) DEFAULT 0;
    But that won't remove the Active Casters section on the website, to do that you'd have to go to your layouts file and manually remove it from the code.
     
  4. Znote

    Znote <?php echo $title; ?> Staff Member Global Moderator Premium User

    Joined:
    Feb 14, 2008
    Messages:
    6,006
    Likes Received:
    832
    Best Answers:
    76
    You probably don't have a live-cast system installed on your OT server.
    This is something that came with the custom layout you are using.

    Remove this piece of code from your layout/overall/footer.php file:
    Code (HTML5):
    1. <div class="right_box">
    2.     <div class="corner_lt"></div><div class="corner_rt"></div><div class="corner_lb"></div><div class="corner_rb"></div>
    3.     <div class="title"><img src="layout/img/casts.gif"><span style="background-image: url(layout/widget_texts/casts.png);"></span></div>
    4.     <div class="content">
    5.         <div class="rise-up-content">
    6.         <ul class="toplvl">
    7.         <?php
    8.            $cache = new Cache('engine/cache/topCasts');
    9.            if ($cache->hasExpired()) {
    10.                 $znotePlayers = mysql_select_multi('SELECT * FROM players WHERE group_id < 2 AND broadcasting = 1 ORDER BY  viewers DESC LIMIT 5;');
    11.                $cache->setContent($znotePlayers);
    12.                 $cache->save();
    13.             } else {
    14.                 $znotePlayers = $cache->load();
    15.             }
    16.             if($znotePlayers){
    17.                 foreach($znotePlayers as $player)
    18.                 {
    19.                     $nam = $player['name'];
    20.                     if (strlen($nam) > 15)
    21.                     {$nam = substr($nam, 0, 12) . '...';}
    22.                     echo '<li style="margin: 6px 0;"><div style="position:relative; left:-48px; top:-48px;"><div style="background-image: url(layout/outfitter/outfit.php?id='.$player['looktype'].'&head='.$player['lookhead'].'&body='.$player['lookbody'].'&legs='.$player['looklegs'].'&feet='.$player['lookfeet'].');width:64px;height:64px;position:absolute;background-repeat:no-repeat;background-position:right bottom;"></div></div>
    23.                     <a style="margin-left: 19px;" href="characterprofile.php?name=' .$player['name']. '">' .$nam. '</a>';
    24.                  
    25.                     echo '<span style="float: right;">'.$player['viewers'].'</span></li>';
    26.                 }
    27.              
    28.             }
    29.             else
    30.             {
    31.                 echo '<center>No active casts.</center>';
    32.             }
    33.             ?>
    34.             </ul>
    35.         </div>
    36.     </div>
    37.     <div class="border_bottom"></div>
    38. </div>
     
    hemrenus321 likes this.

Share This Page

Loading...