Hello, I'm trying to recreate this using PHP Callbacks and Templates. However, I'm unclear how to echo the data within the template.
My Callback
Template
CSS
My Callback
Code:
<?php
class bright_sa_sa
{
public static function serverteam(XenForo_ControllerPublic_Abstract $controller, XenForo_ControllerResponse_Abstract $response)
{
$con=mysqli_connect("127.0.0.1","XXXXXXX","XXXXXXX","XXXXXXX");
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
$jbstaff = mysqli_query($con,"SELECT * FROM sb_admins WHERE user LIKE '%Jail%' ORDER BY srv_group DESC");
$ttstaff = mysqli_query($con,"SELECT * FROM sb_admins WHERE user LIKE '%TTT%' ORDER BY srv_group DESC");
$ssstaff = mysqli_query($con,"SELECT * FROM sb_admins WHERE user LIKE '%Surf%' ORDER BY srv_group DESC");
while($jbsrow = mysqli_fetch_array($jbstaff))
{
$response->params['jb'] = '<div class="steamprofile" id="' . $jbsrow['srv_group'] . '" title="' . $jbsrow['authid'] . '"></div>';
}
while($ttsrow = mysqli_fetch_array($ttstaff))
{
$response->params['ttt'] = '<div class="steamprofile" id="' . $ttsrow['srv_group'] . '" title="' . $ttsrow['authid'] . '"></div>';
}
while($sssrow = mysqli_fetch_array($ssstaff))
{
$response->params['surf'] = '<div class="steamprofile" id="' . $sssrow['srv_group'] . '" title="' . $sssrow['authid'] . '"></div>';
}
mysqli_close($con);
$response->templateName = 'bright_serverteam';
}
}
?>Template
Code:
<script src="XXXXXXX"></script>
<xen:require css="bright_serverteam.css" />
<div style="width: 250px">
<div id="global">
<center><span style="font-weight: 900; font-size: 26px">Global Admins</span></center>
<div class="steamprofile" id="Founder" title="STEAM_0:0:40515805"></div><!--Alvarez-->
<div class="steamprofile" id="Founder" title="MrBrightside1"></div><!--Bright-->
<div class="steamprofile" id="Founder" title="STEAM_0:0:29656095"></div><!--Hero-->
<div class="steamprofile" id="Founder" title="STEAM_0:1:31551356"></div><!--K0Killer-->
<div class="steamprofile" id="Captain" title="STEAM_0:1:44639895"></div><!--Circe-->
<div class="steamprofile" id="Captain" title="STEAM_0:1:33846347"></div><!--Forgot-->
<div class="steamprofile" id="Captain" title="STEAM_0:0:1241826"></div><!--Lemonz-->
<div class="steamprofile" id="Captain" title="STEAM_0:0:51633105"></div><!--Xearta-->
</div>
<hr />
<center>
<select id="serverlist">
<option value="jb">Jailbreak</option>
<option value="mg">Mini Games</option>
<option value="ttt">TTT</option>
<option value="ss">Skill Surf</option>
<option value="sel" selected>Select A Server</option>
</select>
</center>
<br />
<div id="jb">
<ol>
<xen:foreach loop="$jb" value="$jbadmins">
</xen:foreach>
</ol>
</div>
<div id="ttt">
<ol>
<xen:foreach loop="$ttt" value="$tttadmins">
</xen:foreach>
</ol>
</div>
<div id="surf">
<ol>
<xen:foreach loop="$surf" value="$surfadmins">
</xen:foreach>
</ol>
</div>
</div>
<script>
$(document).ready(function() {
$("#ttt, #jb, #surf, #minigames").css("display", "none");
});
</script>
<script>
$('#serverlist').change(function(){
if($('#serverlist').val() == 'jb'){
$('#ttt, #surf, #minigames').slideUp(500);
$('#jb').delay(501).slideDown(500);
}
else if($('#serverlist').val() == 'ttt'){
$('#jb, #surf, #minigames').slideUp(500);
$('#ttt').delay(501).slideDown(500);
}
else if($('#serverlist').val() == 'ss'){
$('#jb, #ttt, #minigames').slideUp(500);
$('#surf').delay(501).slideDown(500);
}
else if($('#serverlist').val() == 'mg'){
$('#jb, #ttt, #surf').slideUp(500);
$('#minigames').delay(501).slideDown(500);
}
else if($('#serverlist').val() == 'sel'){
$('#jb, #ttt, #surf, #minigames').slideUp(500);
}
});
</script>
Code:
#Founder {
max-width: 230px;
border-style: solid;
border-width: 2px;
border-color: rgba(255,132,0,.7); }
#Captain {
max-width: 230px;
border-style: solid;
border-width: 2px;
border-color: rgba(255,215,0,.7); }
#Manager {
max-width: 230px;
border-style: solid;
border-width: 2px;
border-color: rgba(168,0,255,.7); }
#Agent {
max-width: 230px;
border-style: solid;
border-width: 2px;
border-color: rgba(0,216,255,.7); }
