Website NewCabal

TripleXXX said:
can give some clue how to set this discode ?
Click to expand...
search for:
To view the content, you need to sign in or register
in the index.php, change for your discord widget html code, save it, done!
 
walapulos said:
miroko can you give code or how to fix characters not showing
Click to expand...
<?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
require_once __DIR__ . '/../../web_conexao/init.php';
require_once __DIR__ . '/../../web_conexao/function_class.php';
Deslogado();
$db = Database::conexao();


if (isset($_GET['box']) && $_GET['box'] == "true") {
echo '<script>console.log(swal("Error", "Você precisa criar um personagem para selecionar esta opção.", "warning"));</script>';
exit();
}

try {
$result_conta = $db->query("SELECT * FROM account.dbo.cabal_auth_table WHERE ID = '" . $_SESSION['my_login'] . "'")->fetchObject();
} catch (PDOException $e) {
exit("Erro ao buscar dados do usuário: " . $e->getMessage());
}

try {
$GetCash = $db->prepare("SELECT * FROM CabalCash.dbo.CashAccount WHERE UserNum = :user_num"); // Corrigido para CabalCash.dbo.CashAccount
$GetCash->bindParam(':user_num', $result_conta->UserNum, PDO::PARAM_INT);
$GetCash->execute();
$CashAccount = $GetCash->fetchObject();
} catch (PDOException $er) {
exit("Erro ao consultar Cash: " . $er->getMessage()); // Detalhes do erro
}

?>

<style>
/* **ESTILOS ATUALIZADOS PARA OS CARDS DE PERSONAGEM (mantendo o visual, mas adaptando para <li>)** */

/* Estilos para a lista de personagens */
#character_list {
list-style: none; /* Remove marcadores de lista */
padding: 0;
margin: 0;
display: flex;
flex-wrap: wrap; /* Permite que os cards quebrem para a próxima linha */
gap: 15px; /* Espaçamento entre os cards */
}

#character_list > li {
flex: 1 1 calc(25% - 15px); /* Ajuste para 4 colunas em telas maiores, considerando o gap */
max-width: calc(25% - 15px);
box-sizing: border-box; /* Inclui padding e borda no cálculo do tamanho */
cursor: pointer; /* Indica que o item é clicável */
transition: transform 0.2s ease-in-out, box-shadow 0.2s ease-in-out;
/* APLICA AS CORES DO TEMA DIRETAMENTE AQUI */
background-color: var(--card-bg-color); /* Fundo do card */
border: 1px solid var(--card-border-color); /* Borda do card */
border-radius: 8px; /* Cantos arredondados */
box-shadow: 0 4px 8px rgba(0,0,0,0.2); /* Sombra suave */
height: 100%; /* Garante que o card ocupe todo o espaço do li */
padding: 20px; /* Adapte conforme necessário, era o padding do .card-body */
display: flex; /* Para alinhar ícone e info */
align-items: center; /* Alinha verticalmente */
flex-wrap: wrap; /* Permite quebras para responsividade */
position: relative;
}

#character_list > li:hover {
transform: translateY(-5px);
box-shadow: 0 10px 20px rgba(0,0,0,0.3);
}

.character-icon {
width: 80px;
height: 80px;
background-size: contain;
background-repeat: no-repeat;
background-position: center;
margin-right: 15px;
border-radius: 50%;
flex-shrink: 0;
display: flex;
justify-content: center;
align-items: center;
overflow: hidden;
/* Opcional: Adicionar borda ou fundo para o ícone */
border: 2px solid var(--card-border-color);
}

.character-info {
flex-grow: 1;
text-align: left;
}

.character-info h5 {
margin: 0 0 5px 0;
font-size: 1.3rem;
color: var(--text-color); /* Alterado para text-color para maior contraste */
font-weight: bold;
}

.character-info p {
margin: 2px 0;
font-size: 0.95rem;
color: var(--text-color-secondary);
}

/* **ESTILOS PARA OS BOTÕES DE FUNÇÕES** */
.character-actions {
margin-top: 20px;
text-align: center;
width: 100%; /* Garante que o container dos botões ocupe a largura total */
}

.character-actions .btn {
/* Estilos base para todos os botões */
background-color: var(--button-bg-primary);
color: var(--button-text-color);
border: 1px solid var(--button-bg-primary);
padding: 8px 15px;
margin: 5px; /* Espaçamento entre os botões */
border-radius: 5px;
font-weight: 600;
transition: background-color 0.2s ease, border-color 0.2s ease, transform 0.1s ease;
text-decoration: none; /* Garante que não haja sublinhado se for link */
display: inline-block; /* Permite margin e padding */
}

.character-actions .btn:hover {
background-color: var(--button-hover-bg-primary);
border-color: var(--button-hover-bg-primary);
transform: translateY(-2px); /* Efeito sutil ao passar o mouse */
}

.character-actions .btn:active {
transform: translateY(0);
}

/* Cores específicas para botões (opcional, se quiser variações) */
/* Exemplo de botão de sucesso */
.character-actions .btn-success-custom {
background-color: #28a745;
border-color: #28a745;
}
.character-actions .btn-success-custom:hover {
background-color: #218838;
border-color: #1e7e34;
}

/* Exemplo de botão de aviso */
.character-actions .btn-warning-custom {
background-color: #ffc107;
border-color: #ffc107;
color: #333; /* Texto escuro para contraste */
}
.character-actions .btn-warning-custom:hover {
background-color: #e0a800;
border-color: #d39e00;
}


/* Responsividade */
Media (max-width: 1200px) {
#character_list > li {
flex: 1 1 calc(33.333% - 15px); /* 3 colunas */
max-width: calc(33.333% - 15px);
}
}

Media (max-width: 992px) {
#character_list > li {
flex: 1 1 calc(50% - 15px); /* 2 colunas */
max-width: calc(50% - 15px);
}
}

Media (max-width: 576px) {
#character_list > li {
flex: 1 1 100%; /* 1 coluna */
max-width: 100%;
}
#character_list > li { /* O conteúdo do LI em coluna */
flex-direction: column;
text-align: center;
}
.character-icon {
margin-right: 0;
margin-bottom: 15px;
}
.character-info {
text-align: center;
}
.character-actions .btn {
width: calc(100% - 10px); /* Botões ocupam quase toda a largura em telas pequenas */
margin: 5px 5px;
}
}
</style>

<div class="col-12 col-md-12 col-lg-12 col-xl-12 mb-4">
<h4><i class="fas fa-users"></i> Personagens</h4>
<div class="row">
<div class="col-12">
<ul id="character_list">
<?php
try {
$stmt = $db->prepare("SELECT TOP 9 * FROM Server01.dbo.cabal_character_table WHERE CharacterIdx / 8 = :user_num");
$stmt->bindParam(':user_num', $result_conta->UserNum, PDO::PARAM_INT);
$stmt->execute();

if ($stmt->rowCount() == 0) {
echo "<li><div class='character-info'><p>Nenhum personagem encontrado.</p></div></li>";
} else {
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
$nation = 'Sem Nação';
switch ($row['Nation']) {
case 1: $nation = 'Capella'; break;
case 2: $nation = 'Procyon'; break;
}

$classeData = decodificar_ep33($row['Style']);
$classeSigla = $classeData['Classe_Sigla'] ?? 'default';
$icon_url = '/template/request/images/' . $classeSigla . '.gif';
?>
<li
data-char-id="<?= $row['CharacterIdx'] ?>"
data-char-name="<?= htmlspecialchars($row['Name']) ?>"
onmouseover="Tip('Força: <?=$row['STR']?> <br> Defesa: <?=$row['DEX']?> <br> Inteligência: <?=$row['INT']?> <br> Nação: <?=$nation?>', TITLEBGCOLOR, '#515c62', BORDERCOLOR, '#515c62', TITLE, 'INFORMAÇÕES&nbsp;&nbsp;', TITLEFONTFACE, 'Verdana,sans-serif')"
>
<div class="character-icon">
<img src="<?= $icon_url ?>" alt="<?= htmlspecialchars($row['Name']) ?> Icon" style="width: 100%; height: auto; border-radius: 50%;">
</div>
<div class="character-info">
<h5><?= htmlspecialchars($row['Name']) ?></h5>
<p>Level: <?= $row['LEV'] ?></p>
<p>Nação: <?= $nation ?></p>
<p>STR: <?= $row['STR'] ?> | INT: <?= $row['INT'] ?> | DEX: <?= $row['DEX'] ?></p>
</div>
</li>
<?php
}
}
} catch (PDOException $e) {
echo "<li><div class='character-info'><p>Erro ao carregar personagens: " . $e->getMessage() . "</p></div></li>";
}
?>
</ul>
</div>
</div>
</div>

<div id="personagem-opcoes" style="margin-top:20px;">
</div>
<div id="content3" style="margin-top:20px;"></div>
 
Still disable
EC9D2940-13CD-4360-A970-DB1539BD6A1C - Website NewCabal - RaGEZONE Forums
 
miroko said:
look, i will send to you attached here (characters.php / function_class.php and the querys that you will need to run inside your server01 database.
Click to expand...
Thank you very much, and really appreciate the help given.

Tq. Sir

after ???? error

Untitled - Website NewCabal - RaGEZONE Forums



Untitled 1 - Website NewCabal - RaGEZONE Forums
 
Last edited:
TripleXXX said:
Thank you very much, and really appreciate the help given.

Tq. Sir

after ???? error

View attachment 288709


View attachment 288710
Click to expand...
edit your ranking_geral.php, change it to:


<?php
require_once __DIR__ . '/../../web_conexao/init.php';
require_once __DIR__ . '/../../web_conexao/function_class.php';

$db = Database::conexao();
$stmt = $db->prepare("
SELECT TOP 100 Name, LEV, Style, Reserved1, Nation
FROM Server01.dbo.cabal_character_table
WHERE Nation <> 3
ORDER BY LEV DESC
");
$stmt->execute();
$resultados = $stmt->fetchAll(PDO::FETCH_ASSOC);
?>

<section class="custom-ranking">
<div class="ranking-header">
<h1>Ranking de Personagens</h1>
<p>Os 100 personagens com maior nível no servidor</p>
</div>

<div class="ranking-table-wrapper">
<table class="ranking-table">
<thead>
<tr>
<th>Rank</th>
<th>Nome</th>
<th>Nível</th>
<th>Classe</th>
<th>Sexo</th>
</tr>
</thead>
<tbody>
<?php foreach ($resultados as $i => $r):
$style = decodificar_ep33($r['Reserved1'], $r['Style']);
$posicao = $i + 1;
$classeLinha = $i % 2 === 0 ? 'linha-par' : 'linha-impar';
?>
<tr class="<?= $classeLinha ?>">
<td><span class="rank-number"><?= $posicao ?></span></td>
<td><?= htmlspecialchars($r['Name']) ?></td>
<td><?= $r['LEV'] ?></td>
<td>
<div class="classe-info">
<?= $style['Classe_Nome'] ?>
<span class="classe-nome"><?= $style['Classe_is_name'] ?></span>
</div>
</td>
<td><?= $style['Sexo_Icone'] ?></td>
</tr>
<?php endforeach; ?>
</tbody>
</table>
</div>
</section>

<style>
.custom-ranking {
max-width: 1200px;
margin: 4rem auto;
padding: 0 1rem;
color: #fff;
font-family: 'Segoe UI', sans-serif;
}

.ranking-header {
text-align: center;
margin-bottom: 2rem;
}

.ranking-header h1 {
font-size: 3rem;
font-weight: 700;
color: #fbbf24;
margin-bottom: 0.5rem;
}

.ranking-header p {
font-size: 1.125rem;
color: #bbb;
}

.ranking-table-wrapper {
overflow-x: auto;
}

.ranking-table {
width: 100%;
border-collapse: separate;
border-spacing: 0;
background-color: #1a1a1a;
border: 1px solid #333;
border-radius: 8px;
overflow: hidden;
}

.ranking-table thead {
background-color: #2c2c2c;
}

.ranking-table th {
padding: 1rem;
text-align: left;
font-size: 0.95rem;
color: #fbbf24;
border-bottom: 1px solid #444;
}

.ranking-table td {
padding: 0.75rem 1rem;
font-size: 0.9rem;
color: #eee;
border-bottom: 1px solid #333;
}

.ranking-table tr.linha-par {
background-color: #202020;
}

.ranking-table tr.linha-impar {
background-color: #181818;
}

.ranking-table tr:hover {
background-color: #333;
}

.rank-number {
font-weight: bold;
color: #fbbf24;
}

.classe-info {
display: flex;
align-items: center;
gap: 0.5rem;
}

.classe-nome {
color: #ddd;
font-size: 0.9rem;
}

/* Responsivo */
Media (max-width: 768px) {
.ranking-header h1 {
font-size: 2rem;
}

.ranking-header p {
font-size: 1rem;
}

.ranking-table th,
.ranking-table td {
padding: 0.6rem 0.5rem;
font-size: 0.85rem;
}

.classe-nome {
font-size: 0.8rem;
}
}
</style>

TripleXXX said:
Thank you very much, and really appreciate the help given.

Tq. Sir

after ???? error

View attachment 288709


View attachment 288710
Click to expand...
also edit your characters.php to:


<?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
require_once __DIR__ . '/../../web_conexao/init.php';
require_once __DIR__ . '/../../web_conexao/function_class.php';
Deslogado();
$db = Database::conexao();


if (isset($_GET['box']) && $_GET['box'] == "true") {
echo '<script>console.log(swal("Error", "Você precisa criar um personagem para selecionar esta opção.", "warning"));</script>';
exit();
}

try {
$result_conta = $db->query("SELECT * FROM account.dbo.cabal_auth_table WHERE ID = '" . $_SESSION['my_login'] . "'")->fetchObject();
} catch (PDOException $e) {
exit("Erro ao buscar dados do usuário: " . $e->getMessage());
}

try {
$GetCash = $db->prepare("SELECT * FROM CabalCash.dbo.CashAccount WHERE UserNum = :user_num");
$GetCash->bindParam(':user_num', $result_conta->UserNum, PDO::PARAM_INT);
$GetCash->execute();
$CashAccount = $GetCash->fetchObject();
} catch (PDOException $er) {
exit("Erro ao consultar Cash: " . $er->getMessage());
}

?>

<style>
/* ... seus estilos permanecem iguais ... */
</style>

<div class="col-12 col-md-12 col-lg-12 col-xl-12 mb-4">
<h4><i class="fas fa-users"></i> Personagens</h4>
<div class="row">
<div class="col-12">
<ul id="character_list">
<?php
try {
// Corrigido: trazer Reserved1 no SELECT
$stmt = $db->prepare("
SELECT TOP 9 CharacterIdx, Name, LEV, STR, DEX, INT, Nation, Style, Reserved1
FROM Server01.dbo.cabal_character_table
WHERE CharacterIdx / 8 = :user_num
");
$stmt->bindParam(':user_num', $result_conta->UserNum, PDO::PARAM_INT);
$stmt->execute();

if ($stmt->rowCount() == 0) {
echo "<li><div class='character-info'><p>Nenhum personagem encontrado.</p></div></li>";
} else {
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
$nation = 'Sem Nação';
switch ($row['Nation']) {
case 1: $nation = 'Capella'; break;
case 2: $nation = 'Procyon'; break;
}

// Corrigido: agora usa Reserved1 e Style
$classeData = decodificar_ep33($row['Reserved1'], $row['Style']);
$classeSigla = $classeData['Classe_Sigla'] ?? 'default';
$icon_url = '/template/request/images/' . $classeSigla . '.gif';
?>
<li
data-char-id="<?= $row['CharacterIdx'] ?>"
data-char-name="<?= htmlspecialchars($row['Name']) ?>"
onmouseover="Tip('Força: <?=$row['STR']?> <br> Defesa: <?=$row['DEX']?> <br> Inteligência: <?=$row['INT']?> <br> Nação: <?=$nation?>', TITLEBGCOLOR, '#515c62', BORDERCOLOR, '#515c62', TITLE, 'INFORMAÇÕES&nbsp;&nbsp;', TITLEFONTFACE, 'Verdana,sans-serif')"
>
<div class="character-icon">
<img src="<?= $icon_url ?>" alt="<?= htmlspecialchars($row['Name']) ?> Icon" style="width: 100%; height: auto; border-radius: 50%;">
</div>
<div class="character-info">
<h5><?= htmlspecialchars($row['Name']) ?></h5>
<p>Level: <?= $row['LEV'] ?></p>
<p>Nação: <?= $nation ?></p>
<p>STR: <?= $row['STR'] ?> | INT: <?= $row['INT'] ?> | DEX: <?= $row['DEX'] ?></p>
</div>
</li>
<?php
}
}
} catch (PDOException $e) {
echo "<li><div class='character-info'><p>Erro ao carregar personagens: " . $e->getMessage() . "</p></div></li>";
}
?>
</ul>
</div>
</div>
</div>

<div id="personagem-opcoes" style="margin-top:20px;"></div>
<div id="content3" style="margin-top:20px;"></div>

miroko said:
edit your ranking_geral.php, change it to:


<?php
require_once __DIR__ . '/../../web_conexao/init.php';
require_once __DIR__ . '/../../web_conexao/function_class.php';

$db = Database::conexao();
$stmt = $db->prepare("
SELECT TOP 100 Name, LEV, Style, Reserved1, Nation
FROM Server01.dbo.cabal_character_table
WHERE Nation <> 3
ORDER BY LEV DESC
");
$stmt->execute();
$resultados = $stmt->fetchAll(PDO::FETCH_ASSOC);
?>

<section class="custom-ranking">
<div class="ranking-header">
<h1>Ranking de Personagens</h1>
<p>Os 100 personagens com maior nível no servidor</p>
</div>

<div class="ranking-table-wrapper">
<table class="ranking-table">
<thead>
<tr>
<th>Rank</th>
<th>Nome</th>
<th>Nível</th>
<th>Classe</th>
<th>Sexo</th>
</tr>
</thead>
<tbody>
<?php foreach ($resultados as $i => $r):
$style = decodificar_ep33($r['Reserved1'], $r['Style']);
$posicao = $i + 1;
$classeLinha = $i % 2 === 0 ? 'linha-par' : 'linha-impar';
?>
<tr class="<?= $classeLinha ?>">
<td><span class="rank-number"><?= $posicao ?></span></td>
<td><?= htmlspecialchars($r['Name']) ?></td>
<td><?= $r['LEV'] ?></td>
<td>
<div class="classe-info">
<?= $style['Classe_Nome'] ?>
<span class="classe-nome"><?= $style['Classe_is_name'] ?></span>
</div>
</td>
<td><?= $style['Sexo_Icone'] ?></td>
</tr>
<?php endforeach; ?>
</tbody>
</table>
</div>
</section>

<style>
.custom-ranking {
max-width: 1200px;
margin: 4rem auto;
padding: 0 1rem;
color: #fff;
font-family: 'Segoe UI', sans-serif;
}

.ranking-header {
text-align: center;
margin-bottom: 2rem;
}

.ranking-header h1 {
font-size: 3rem;
font-weight: 700;
color: #fbbf24;
margin-bottom: 0.5rem;
}

.ranking-header p {
font-size: 1.125rem;
color: #bbb;
}

.ranking-table-wrapper {
overflow-x: auto;
}

.ranking-table {
width: 100%;
border-collapse: separate;
border-spacing: 0;
background-color: #1a1a1a;
border: 1px solid #333;
border-radius: 8px;
overflow: hidden;
}

.ranking-table thead {
background-color: #2c2c2c;
}

.ranking-table th {
padding: 1rem;
text-align: left;
font-size: 0.95rem;
color: #fbbf24;
border-bottom: 1px solid #444;
}

.ranking-table td {
padding: 0.75rem 1rem;
font-size: 0.9rem;
color: #eee;
border-bottom: 1px solid #333;
}

.ranking-table tr.linha-par {
background-color: #202020;
}

.ranking-table tr.linha-impar {
background-color: #181818;
}

.ranking-table tr:hover {
background-color: #333;
}

.rank-number {
font-weight: bold;
color: #fbbf24;
}

.classe-info {
display: flex;
align-items: center;
gap: 0.5rem;
}

.classe-nome {
color: #ddd;
font-size: 0.9rem;
}

/* Responsivo */
Media (max-width: 768px) {
.ranking-header h1 {
font-size: 2rem;
}

.ranking-header p {
font-size: 1rem;
}

.ranking-table th,
.ranking-table td {
padding: 0.6rem 0.5rem;
font-size: 0.85rem;
}

.classe-nome {
font-size: 0.8rem;
}
}
</style>


also edit your characters.php to:


<?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);
require_once __DIR__ . '/../../web_conexao/init.php';
require_once __DIR__ . '/../../web_conexao/function_class.php';
Deslogado();
$db = Database::conexao();


if (isset($_GET['box']) && $_GET['box'] == "true") {
echo '<script>console.log(swal("Error", "Você precisa criar um personagem para selecionar esta opção.", "warning"));</script>';
exit();
}

try {
$result_conta = $db->query("SELECT * FROM account.dbo.cabal_auth_table WHERE ID = '" . $_SESSION['my_login'] . "'")->fetchObject();
} catch (PDOException $e) {
exit("Erro ao buscar dados do usuário: " . $e->getMessage());
}

try {
$GetCash = $db->prepare("SELECT * FROM CabalCash.dbo.CashAccount WHERE UserNum = :user_num");
$GetCash->bindParam(':user_num', $result_conta->UserNum, PDO::PARAM_INT);
$GetCash->execute();
$CashAccount = $GetCash->fetchObject();
} catch (PDOException $er) {
exit("Erro ao consultar Cash: " . $er->getMessage());
}

?>

<style>
/* ... seus estilos permanecem iguais ... */
</style>

<div class="col-12 col-md-12 col-lg-12 col-xl-12 mb-4">
<h4><i class="fas fa-users"></i> Personagens</h4>
<div class="row">
<div class="col-12">
<ul id="character_list">
<?php
try {
// Corrigido: trazer Reserved1 no SELECT
$stmt = $db->prepare("
SELECT TOP 9 CharacterIdx, Name, LEV, STR, DEX, INT, Nation, Style, Reserved1
FROM Server01.dbo.cabal_character_table
WHERE CharacterIdx / 8 = :user_num
");
$stmt->bindParam(':user_num', $result_conta->UserNum, PDO::PARAM_INT);
$stmt->execute();

if ($stmt->rowCount() == 0) {
echo "<li><div class='character-info'><p>Nenhum personagem encontrado.</p></div></li>";
} else {
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
$nation = 'Sem Nação';
switch ($row['Nation']) {
case 1: $nation = 'Capella'; break;
case 2: $nation = 'Procyon'; break;
}

// Corrigido: agora usa Reserved1 e Style
$classeData = decodificar_ep33($row['Reserved1'], $row['Style']);
$classeSigla = $classeData['Classe_Sigla'] ?? 'default';
$icon_url = '/template/request/images/' . $classeSigla . '.gif';
?>
<li
data-char-id="<?= $row['CharacterIdx'] ?>"
data-char-name="<?= htmlspecialchars($row['Name']) ?>"
onmouseover="Tip('Força: <?=$row['STR']?> <br> Defesa: <?=$row['DEX']?> <br> Inteligência: <?=$row['INT']?> <br> Nação: <?=$nation?>', TITLEBGCOLOR, '#515c62', BORDERCOLOR, '#515c62', TITLE, 'INFORMAÇÕES&nbsp;&nbsp;', TITLEFONTFACE, 'Verdana,sans-serif')"
>
<div class="character-icon">
<img src="<?= $icon_url ?>" alt="<?= htmlspecialchars($row['Name']) ?> Icon" style="width: 100%; height: auto; border-radius: 50%;">
</div>
<div class="character-info">
<h5><?= htmlspecialchars($row['Name']) ?></h5>
<p>Level: <?= $row['LEV'] ?></p>
<p>Nação: <?= $nation ?></p>
<p>STR: <?= $row['STR'] ?> | INT: <?= $row['INT'] ?> | DEX: <?= $row['DEX'] ?></p>
</div>
</li>
<?php
}
}
} catch (PDOException $e) {
echo "<li><div class='character-info'><p>Erro ao carregar personagens: " . $e->getMessage() . "</p></div></li>";
}
?>
</ul>
</div>
</div>
</div>

<div id="personagem-opcoes" style="margin-top:20px;"></div>
<div id="content3" style="margin-top:20px;"></div>
Click to expand...
ranking_online.php:


<?php
require_once __DIR__ . '/../../web_conexao/init.php';
require_once __DIR__ . '/../../web_conexao/function_class.php';

$db = Database::conexao();

$stmt = $db->prepare("
SELECT TOP 100 Name, LEV, Style, Reserved1, PlayTime
FROM Server01.dbo.cabal_character_table
WHERE Nation <> 3
ORDER BY PlayTime DESC
");
$stmt->execute();
$resultados = $stmt->fetchAll(PDO::FETCH_ASSOC);
?>

<section class="custom-ranking">
<div class="ranking-header">
<h1>Personagens Online</h1>
<p>Os 100 jogadores online com maior tempo de jogo</p>
</div>

<div class="ranking-table-wrapper">
<table class="ranking-table">
<thead>
<tr>
<th>Rank</th>
<th>Nome</th>
<th>Nível</th>
<th>Classe</th>
<th>Sexo</th>
</tr>
</thead>
<tbody>
<?php foreach ($resultados as $i => $r):
$style = decodificar_ep33($r['Reserved1'], $r['Style']);
$posicao = $i + 1;
$classeLinha = $i % 2 === 0 ? 'linha-par' : 'linha-impar';
?>
<tr class="<?= $classeLinha ?>">
<td><span class="rank-number"><?= $posicao ?></span></td>
<td><?= htmlspecialchars($r['Name']) ?></td>
<td><?= $r['LEV'] ?></td>
<td>
<div class="classe-info">
<?= $style['Classe_Nome'] ?>
<span class="classe-nome"><?= $style['Classe_is_name'] ?></span>
</div>
</td>
<td><?= $style['Sexo_Icone'] ?></td>
</tr>
<?php endforeach; ?>
</tbody>
</table>
</div>
</section>

<style>
.custom-ranking {
max-width: 1200px;
margin: 4rem auto;
padding: 0 1rem;
color: #fff;
font-family: 'Segoe UI', sans-serif;
}

.ranking-header {
text-align: center;
margin-bottom: 2rem;
}

.ranking-header h1 {
font-size: 3rem;
font-weight: 700;
color: #fbbf24;
margin-bottom: 0.5rem;
}

.ranking-header p {
font-size: 1.125rem;
color: #bbb;
}

.ranking-table-wrapper {
overflow-x: auto;
}

.ranking-table {
width: 100%;
border-collapse: separate;
border-spacing: 0;
background-color: #1a1a1a;
border: 1px solid #333;
border-radius: 8px;
overflow: hidden;
}

.ranking-table thead {
background-color: #2c2c2c;
}

.ranking-table th {
padding: 1rem;
text-align: left;
font-size: 0.95rem;
color: #fbbf24;
border-bottom: 1px solid #444;
}

.ranking-table td {
padding: 0.75rem 1rem;
font-size: 0.9rem;
color: #eee;
border-bottom: 1px solid #333;
}

.ranking-table tr.linha-par {
background-color: #202020;
}

.ranking-table tr.linha-impar {
background-color: #181818;
}

.ranking-table tr:hover {
background-color: #333;
}

.rank-number {
font-weight: bold;
color: #fbbf24;
}

.classe-info {
display: flex;
align-items: center;
gap: 0.5rem;
}

.classe-nome {
color: #ddd;
font-size: 0.9rem;
}

/* Responsivo */
Media (max-width: 768px) {
.ranking-header h1 {
font-size: 2rem;
}

.ranking-header p {
font-size: 1rem;
}

.ranking-table th,
.ranking-table td {
padding: 0.6rem 0.5rem;
font-size: 0.85rem;
}

.classe-nome {
font-size: 0.8rem;
}
}
</style>
 
Last edited:
To view the content, you need to sign in or register


Only the function "search character" from admin panel is not working, everything else is working.
 
You must log in or register to reply here.

RaGEZONE Sponsor

    HyperFilter

About RaGEZONE

RaGEZONE® is a leading MMO and MMORPG development community offering source codes, server files, tutorials, tools, and private servers for developers and gamers.

Forum Statistics

Members online
2,486
Guests online
15,686
Total visitors
18,172
Totals may include hidden visitors.

RaGEZONE Partners

    non GamStop casinos
Back