Ir para conteúdo
  • Cadastre-se
  • 0

Preciso de ajuda Quen Poder ajuda ! Obrigado

Hokutor

Perguntado por Hokutor,

 Compartilhar

Pergunta

11 respostass a esta questão

Posts recomendados


  • 0
Hokutor Aprendiz de Novato

Hokutor

Postado
  • Autor
Postado
<?php
class Donate {
public static function listChars($acc) {
$sql = DB::Executa("SELECT char_name, obj_Id FROM characters WHERE account_name = '".$acc."' LIMIT 7");
return $sql;
}
public static function findChar($acc, $personagem) {
$sql = DB::Executa("SELECT obj_Id, online FROM characters WHERE account_name = '".$acc."' AND obj_Id = '".$personagem."' LIMIT 1");
return $sql;
}
public static function insertDonation($acc, $personagem, $metodo_pgto, $qtdCoins, $qtdBonus, $valor, $price, $curr) {
$sql = DB::Executa("INSERT INTO site_donations (account, personagem, price, currency, metodo_pgto, quant_coins, coins_bonus, valor, data) VALUES ('".$acc."', '".intval($personagem)."', '".$price."', '".$curr."', '".$metodo_pgto."', '".$qtdCoins."', '".$qtdBonus."', '".$valor."', '".time()."')");
return $sql;
}
public static function findDonation($acc, $protocolo='') {
$sql = DB::Executa("SELECT D.*, C.char_name FROM site_donations AS D LEFT JOIN characters AS C ON C.obj_Id = D.personagem WHERE D.account = '".$acc."' ".(!empty($protocolo) ? "AND D.protocolo = '".$protocolo."'" : "")." AND D.status <> '2' ORDER BY D.data DESC");
return $sql;
}
public static function listConverts($acc) {
$sql = DB::Executa("SELECT T.*, C.char_name FROM site_log_convertcoins AS T INNER JOIN characters AS C ON C.obj_Id = T.destinatario WHERE T.account = '".$acc."' ORDER BY T.cdata DESC");
return $sql;
}
public static function listTransfers($acc) {
$sql = DB::Executa("SELECT T.*, C.char_name FROM site_log_transfercoins AS T INNER JOIN characters AS C ON C.obj_Id = T.destinatario_char WHERE T.remetente = '".$acc."' ORDER BY T.tdata DESC");
return $sql;
}
public static function deleteDonation($acc, $protocolo) {
$sql = DB::Executa("UPDATE site_donations SET status = '2' WHERE account = '".$acc."' AND protocolo = '".$protocolo."' LIMIT 1");
return $sql;
}
public static function findReceptor($dest) {
$sql = DB::Executa("SELECT account_name, online, obj_Id FROM characters WHERE char_name = '".$dest."' LIMIT 1");
return $sql;
}
public static function insertBalance($dest, $count) {
$checkExists = DB::Executa("SELECT * FROM site_balance WHERE account = '".$dest."' LIMIT 1");
if(count($checkExists) > 0) {
$sql = DB::Executa("UPDATE site_balance SET saldo = (saldo+".$count.") WHERE account = '".$dest."' LIMIT 1");
} else {
$sql = DB::Executa("INSERT INTO site_balance (account, saldo) VALUES ('".$dest."', '".$count."')");
}
return $sql;
}
public static function transferLog($count, $acc, $receptor, $dest) {
$sql = DB::Executa("INSERT INTO site_log_transfercoins VALUES ('".$count."', '".$acc."', '".$receptor."', '".$dest."', '".date('Y-m-d H:i:s', time())."')");
return $sql;
}
public static function convertLog($count, $acc, $receptor) {
$sql = DB::Executa("INSERT INTO site_log_convertcoins VALUES ('".$count."', '".$acc."', '".$receptor."', '".date('Y-m-d H:i:s', time())."')");
return $sql;
}
public static function searchCoinExist($cid, $coinID) {
$sql = DB::Executa("SELECT object_id FROM items WHERE owner_id = '".$cid."' AND item_id = '".$coinID."' AND loc = 'INVENTORY' LIMIT 1");
return $sql;
}
public static function insertCoinInGame($cid, $coinID, $count, $object_id=0) {
if($object_id != 0) {
$insert = DB::Executa("UPDATE items SET count = (count+".$count.") WHERE object_id = '".$object_id."' AND owner_id = '".$cid."' LIMIT 1");
} else {
$last_object_id = DB::Executa("SELECT object_id FROM items ORDER BY object_id DESC LIMIT 1");
$last_object_id = intval(trim($last_object_id[0]['object_id']));
$last_loc_data = DB::Executa("SELECT loc_data FROM items WHERE owner_id = '".$cid."' ORDER BY loc_data DESC LIMIT 1");
$last_loc_data = intval(trim($last_loc_data[0]['loc_data']));
$insert = DB::Executa("INSERT INTO items
(owner_id, object_id, item_id, count, enchant_level, loc, loc_data) VALUES
(".$cid.", ".($last_object_id+1).", ".$coinID.", ".$count.", 0, 'INVENTORY', ".($last_loc_data+1).")");
}
return $insert;
}
}

11.png


sdsds.png


o codico e os printe das 2 tabela

Link para o comentário
Compartilhar em outros sites
  • 0
Tayran.JavaDev Experto

Tayran.JavaDev

Postado
Postado

Não é esse o código, ai não tem a parte que manda aquela mensagem de erro, assim fica impossível ajudar.

"Tente ser uma pessoa de valor , não de sucesso" - Albert Einstein

 

 

Link para o comentário
Compartilhar em outros sites
  • 0
Hokutor Aprendiz de Novato

Hokutor

Postado
  • Autor
Postado

vou pegar agora


<?php if((!$indexing) || ($logged != 1)) { exit; }
require('private/classes/classDonate.php');
?>
<ul class="breadcrumb">
<li><a href='./?module=donate&page=add'><i class='fa fa-money'></i> <?php echo $LANG[12039]; ?></a></li>
<li><?php echo $LANG[40037]; ?></li>
</ul>
<h1><?php echo $LANG[40037]; ?></h1>
<div class='pddInner'>
<?php
if($funct['trnsf1'] == 1) {
echo "<h3>".$LANG[40038]."</h3>
<table cellspacing='0' cellpadding='0' border='0' class='default'>
<tr>
<th>#</th>
<th>".$LANG[10168]."</th>
<th>".$LANG[10167]."</th>
<th>".$LANG[10116]."</th>
</tr>
";
$transfs = Donate::listConverts($_SESSION['acc']);
if(count($transfs) > 0) {
for($i=0, $c=count($transfs); $i < $c; $i++) {
echo "
<tr".(($i % 2 == 0) ? " class='two'" : '').">
<td>".($i+1)."</td>
<td>".$transfs[$i]['quantidade']."</td>
<td>".$transfs[$i]['char_name']."</td>
<td>".date('d/m/Y H:i', strtotime($transfs[$i]['cdata']))."</td>
</tr>
";
}
} else {
echo "<tr><td colspan='4'>".$LANG[40040]."</td></tr>";
}
echo "</table><br />";
}
if($funct['trnsf2'] == 1) {
echo "<h3>".$LANG[40039]."</h3>
<table cellspacing='0' cellpadding='0' border='0' class='default'>
<tr>
<th>#</th>
<th>".$LANG[10168]."</th>
<th>".$LANG[10167]."</th>
<th>".$LANG[10116]."</th>
</tr>
";
$transfs = Donate::listTransfers($_SESSION['acc']);
if(count($transfs) > 0) {
for($i=0, $c=count($transfs); $i < $c; $i++) {
echo "
<tr".(($i % 2 == 0) ? " class='two'" : '').">
<td>".($i+1)."</td>
<td>".$transfs[$i]['quantidade']."</td>
<td>".$transfs[$i]['char_name']."</td>
<td>".date('d/m/Y H:i', strtotime($transfs[$i]['tdata']))."</td>
</tr>
";
}
} else {
echo "<tr><td colspan='4'>".$LANG[40040]."</td></tr>";
}
echo "</table>";
}
?>
</div>

<?php if((!$indexing) || ($logged != 1)) { exit; }
require('private/classes/classDonate.php');
?>
<ul class="breadcrumb">
<li><a href='./?module=donate&page=add'><i class='fa fa-money'></i> <?php echo $LANG[12039]; ?></a></li>
<li><?php echo $LANG[40037]; ?></li>
</ul>
<h1><?php echo $LANG[40037]; ?></h1>
<div class='pddInner'>
<?php
if($funct['trnsf1'] == 1) {
echo "<h3>".$LANG[40038]."</h3>
<table cellspacing='0' cellpadding='0' border='0' class='default'>
<tr>
<th>#</th>
<th>".$LANG[10168]."</th>
<th>".$LANG[10167]."</th>
<th>".$LANG[10116]."</th>
</tr>
";
$transfs = Donate::listConverts($_SESSION['acc']);
if(count($transfs) > 0) {
for($i=0, $c=count($transfs); $i < $c; $i++) {
echo "
<tr".(($i % 2 == 0) ? " class='two'" : '').">
<td>".($i+1)."</td>
<td>".$transfs[$i]['quantidade']."</td>
<td>".$transfs[$i]['char_name']."</td>
<td>".date('d/m/Y H:i', strtotime($transfs[$i]['cdata']))."</td>
</tr>
";
}
} else {
echo "<tr><td colspan='4'>".$LANG[40040]."</td></tr>";
}
echo "</table><br />";
}
if($funct['trnsf2'] == 1) {
echo "<h3>".$LANG[40039]."</h3>
<table cellspacing='0' cellpadding='0' border='0' class='default'>
<tr>
<th>#</th>
<th>".$LANG[10168]."</th>
<th>".$LANG[10167]."</th>
<th>".$LANG[10116]."</th>
</tr>
";
$transfs = Donate::listTransfers($_SESSION['acc']);
if(count($transfs) > 0) {
for($i=0, $c=count($transfs); $i < $c; $i++) {
echo "
<tr".(($i % 2 == 0) ? " class='two'" : '').">
<td>".($i+1)."</td>
<td>".$transfs[$i]['quantidade']."</td>
<td>".$transfs[$i]['char_name']."</td>
<td>".date('d/m/Y H:i', strtotime($transfs[$i]['tdata']))."</td>
</tr>
";
}
} else {
echo "<tr><td colspan='4'>".$LANG[40040]."</td></tr>";
}
echo "</table>";
}
?>
</div>

sao essas ?

Link para o comentário
Compartilhar em outros sites
  • 0
Hokutor Aprendiz de Novato

Hokutor

Postado
  • Autor
Postado

mano preciso muito desse donate.

voce poderia fazer para quando clika na quele botao trasferir ir para o inventory or o banco ?


si pode min ajuda chama no skype :L2Scorpion 100x


Posso abri o tv para voce poder estar visualizando

 

 

Seu print está offline, eu precisava ver buscar a mensagem de erro nos arquivos.

Link para o comentário
Compartilhar em outros sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Visitante
Responder esta pergunta...

×   Você colou conteúdo com formatação.   Remover formatação

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Processando...
×
 Compartilhar
Ir para lista de Perguntas

  • Registre-se

    Faça parte da maior e  mais antigas comunidades sobre Lineage2 da América Latina.






×
×
  • Criar Novo...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.

  I accept