Вывод данных из базы

[vov4ik32]

Ребят помогите вывести данные из базы. Есть скрипт бонусника там есть вывод данных о последних бонусах. А мне нужно сделать вывод данных о последних выплатах. Как его сделать подскажите. Вот сама база

Код: [Выделить]

--
-- Структура таблицы `comp_ref`
--

CREATE TABLE IF NOT EXISTS `comp_ref` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `startdate` varchar(10) NOT NULL,
  `enddate` varchar(10) NOT NULL,
  `deldate` varchar(10) NOT NULL,
  `lidername` varchar(1) NOT NULL DEFAULT '0',
  `param` varchar(2) NOT NULL DEFAULT '0',
  `min` varchar(10) NOT NULL DEFAULT '0',
  `descr` varchar(1000) NOT NULL,
  `pris1value` varchar(10) NOT NULL,
  `pris2value` varchar(10) NOT NULL,
  `pris3value` varchar(10) NOT NULL,
  `pris4value` varchar(10) NOT NULL,
  `pris5value` varchar(10) NOT NULL,
  `pris1status` varchar(1) NOT NULL DEFAULT '0',
  `pris2status` varchar(1) NOT NULL DEFAULT '0',
  `pris3status` varchar(1) NOT NULL DEFAULT '0',
  `pris4status` varchar(1) NOT NULL DEFAULT '0',
  `pris5status` varchar(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=2 ;

--
-- Дамп данных таблицы `comp_ref`
--

INSERT INTO `comp_ref` (`id`, `name`, `startdate`, `enddate`, `deldate`, `lidername`, `param`, `min`, `descr`, `pris1value`, `pris2value`, `pris3value`, `pris4value`, `pris5value`, `pris1status`, `pris2status`, `pris3status`, `pris4status`, `pris5status`) VALUES
(1, 'Мега реферер!\n', '01.12.2015', '01.12.2015', '99.99.9999', '0', '0', '0', 'Размещай баннеры и приглашай рефералов. Все очень просто, кто больше пригласит за время проведения конкурса тот и выиграет! Баннер находится в разделе рефералы. Размещать баннеры вы можете например на других сайтах раздающих payeer деньги.\n', '200', '100', '50', '', '', '0', '0', '0', '0', '0');

-- --------------------------------------------------------

--
-- Структура таблицы `compdata_ref`
--

CREATE TABLE IF NOT EXISTS `compdata_ref` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idk` int(11) NOT NULL,
  `user` varchar(20) CHARACTER SET utf8 NOT NULL,
  `kosh` varchar(20) CHARACTER SET utf8 NOT NULL,
  `resvalue` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_2` (`user`),
  KEY `idk` (`idk`),
  KEY `user` (`user`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=2 ;


--
-- Структура таблицы `settings`
--

CREATE TABLE IF NOT EXISTS `settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `set` varchar(50) NOT NULL,
  `set1` varchar(50) NOT NULL,
  `name` varchar(50) NOT NULL,
  `value` varchar(100) NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ;

--
-- Дамп данных таблицы `settings`
--

INSERT INTO `settings` (`id`, `set`, `set1`, `name`, `value`) VALUES
(1, '0                     ', '                     3999', 'price', '0.03'),
(2, '4000                     ', '                     5999', 'price', '0.06'),
(3, '6000                     ', '                     9899', 'price', '0.18'),
(4, '9900                     ', '                     9989', 'price', '1'),
(5, '9990                     ', '                     9999', 'price', '30'),
(6, '10000', '10000', 'price', '500'),
(7, 'accountNumber', '', 'payeer', 'P0000000'),
(8, 'apiId', '', 'payeer', '000000'),
(9, 'apiKey', '', 'payeer', '0000000'),
(10, 'min_pay', '', 'system', '0.1'),
(11, 'wait', '', 'system', '20'),
(12, 'ref_proc', '', 'system', '0.5'),
(13, 'site_name', '', 'system', 'Раздача Payeer бонусов'),
(14, 'admin_log', '', 'system', 'admin'),
(15, 'admin_pass', '', 'system', 'admin');

-- --------------------------------------------------------

--
-- Структура таблицы `sp`
--

CREATE TABLE IF NOT EXISTS `sp` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `payeer` varchar(20) NOT NULL,
  `sum` varchar(7) NOT NULL,
  `time` int(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;



--
-- Структура таблицы `stat`
--

CREATE TABLE IF NOT EXISTS `stat` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sum` int(30) NOT NULL,
  `date` int(150) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

-- --------------------------------------------------------

--
-- Структура таблицы `tb_comp`
--

CREATE TABLE IF NOT EXISTS `tb_comp` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `startdate` varchar(10) NOT NULL,
  `enddate` varchar(10) NOT NULL,
  `deldate` varchar(10) NOT NULL,
  `lidername` varchar(1) NOT NULL DEFAULT '0',
  `param` varchar(2) NOT NULL DEFAULT '0',
  `min` varchar(10) NOT NULL DEFAULT '0',
  `descr` varchar(1000) NOT NULL,
  `pris1value` varchar(10) NOT NULL,
  `pris2value` varchar(10) NOT NULL,
  `pris3value` varchar(10) NOT NULL,
  `pris4value` varchar(10) NOT NULL,
  `pris5value` varchar(10) NOT NULL,
  `pris1status` varchar(1) NOT NULL DEFAULT '0',
  `pris2status` varchar(1) NOT NULL DEFAULT '0',
  `pris3status` varchar(1) NOT NULL DEFAULT '0',
  `pris4status` varchar(1) NOT NULL DEFAULT '0',
  `pris5status` varchar(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=2 ;

--
-- Дамп данных таблицы `tb_comp`
--

INSERT INTO `tb_comp` (`id`, `name`, `startdate`, `enddate`, `deldate`, `lidername`, `param`, `min`, `descr`, `pris1value`, `pris2value`, `pris3value`, `pris4value`, `pris5value`, `pris1status`, `pris2status`, `pris3status`, `pris4status`, `pris5status`) VALUES
(1, 'Супер сборщик бонусов!', '01.12.2015', '10.12.2015', '99.99.9999', '0', '0', '0', 'Собери больше бонусов другого и ты выиграешь!\n\n', '30', '20', '10', '0', '0', '0', '0', '0', '0', '0');

-- --------------------------------------------------------

--
-- Структура таблицы `tb_compdata`
--

CREATE TABLE IF NOT EXISTS `tb_compdata` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `idk` int(11) NOT NULL,
  `user` varchar(20) CHARACTER SET utf8 NOT NULL,
  `resvalue` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_2` (`user`),
  KEY `idk` (`idk`),
  KEY `user` (`user`)
) ENGINE=MyISAM  DEFAULT CHARSET=cp1251 AUTO_INCREMENT=142 ;

--
-- Структура таблицы `users`
--

CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `payeer` varchar(20) NOT NULL,
  `money` double(11,4) NOT NULL,
  `pay` double(11,4) NOT NULL,
  `last` int(20) NOT NULL,
  `referer` int(11) NOT NULL,
  `ref` int(11) NOT NULL,
  `ref_pay` double(11,4) NOT NULL,
  `kolv` int(11) NOT NULL,
  `sum_p` double(11,4) NOT NULL,
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=177 ;

Вот таблица вывода последних бонусов

Код: [Выделить]

<div class="well well3">
                  <h3>Последние полученные бонусы</h3>
                  <table class="table">
                     <thead>
                        <tr>
                           
                           <th>Кошелек</th>
                           <th>Сумма</th>
                        <th>Дата получения</th>
                        </tr>
                     </thead>
                     <tbody>
                     <tr>
      <?
      $q = mysqli_query($db, "select * from sp order by id desc limit 5");
      while ($user_row = mysqli_fetch_array($q)) {
         echo '<tr>
            <td>'.substr($user_row['payeer'], 0, -2).'XX</td><td>'.$user_row['sum'].' <i class="fa fa-rub" aria-hidden="true"></i></td><td>'.date('d.m.Y H:i:s', $user_row['time']).'</td></tr>';} 
      ?>
      </table></center>

      </div>   

как её переделать под последние выплаты?

[Rich-99000000]

делать выборку из таблицы выплат, а не бонусов соответственно. Код написать не могу поскольку не Вангую< как называется таблица для записи выплат. например payout или payments

[vov4ik32]

Название "cpayeer" если нужно то вот код самого файла

Код: [Выделить]

<?php
/*
 * CPayeer
 * Version: 1.0
 * Date: April 29th, 2013
 */
class CPayeer
{
   private $url = 'https://payeer.com/ajax/api/api.php';
   private $agent = 'Mozilla/5.0 (Windows NT 6.1; rv:12.0) Gecko/20100101 Firefox/12.0';
   
   private $auth = array();
   
   private $output;
   private $errors;
   private $language = 'ru';
   
   public function __construct($account, $apiId, $apiPass)
   {
      $arr = array(
         'account' => $account,
         'apiId' => $apiId,
         'apiPass' => $apiPass,
      );
      $response = $this->getResponse($arr);
      if (!empty($response['errors']))
      {
         $this->errors = $response['errors'];
      }
      if ($response['auth_error'] == '0')
      {
         $this->auth = $arr;
      }
   }
   
   public function isAuth()
   {
      if (!empty($this->auth)) return true;
      return false;
   }
   
   private function getResponse($arPost)
   {
      if (!function_exists('curl_init')) 
      {
            die('curl library not installed');
            return false;
        }

      if ($this->isAuth())
      {
         $arPost = array_merge($arPost, $this->auth);
      }
      $data = array();
      foreach ($arPost as $k => $v) 
      {
         $data[] = urlencode($k) . '=' . urlencode($v);
        }
      $data[] = 'language=' . $this->language;
      $data = implode('&', $data);
   
        $handler  = curl_init();
        curl_setopt($handler, CURLOPT_URL, $this->url);
        curl_setopt($handler, CURLOPT_HEADER, 0);
        curl_setopt($handler, CURLOPT_POST, true);
        curl_setopt($handler, CURLOPT_POSTFIELDS, $data);
        curl_setopt($handler, CURLOPT_SSL_VERIFYPEER, 0);
      curl_setopt($handler, CURLOPT_SSL_VERIFYHOST, 0);
        curl_setopt($handler, CURLOPT_USERAGENT, $this->agent);
        curl_setopt($handler, CURLOPT_RETURNTRANSFER, 1);
      
        $content = curl_exec($handler);
      //print_r($content);
      
      $arRequest = curl_getinfo($handler);
      //print_r($arRequest);
      
      curl_close($handler);
      if (strpos($content, '{') !== false) $content = $this->objectToArray(json_decode($content));
        return $content;
   }
   
   private function objectToArray($ob)
   {
      $arr = array();
      foreach ($ob as $k => $v)
      {
         if (is_object($v))
         {
            $arr[$k] = $this->objectToArray($v);            
         }
         else
         {
            $arr[$k] = $v;
         }
      }
      return $arr;
   }
   
   public function getPaySystems()
   {
      $arPost = array(
         'action' => 'getPaySystems',
      );
      $response = $this->getResponse($arPost);
      return $response;
   }   
   
   public function initOutput($arr)
   {
      $arPost = $arr;
      $arPost['action'] = 'initOutput';
      $response = $this->getResponse($arPost);
      if (empty($response['errors']))
      {
         $this->output = $arr;
         return true;
      }
      else
      {
         $this->errors = $response['errors'];
      }
      return false;
   }
   
   public function output()
   {
      $arPost = $this->output;
      $arPost['action'] = 'output';
      $response = $this->getResponse($arPost);
      if (empty($response['errors']))
      {
         return $response['historyId'];
      }
      else
      {
         $this->errors = $response['errors'];
      }
      return false;
   }
   
   public function getHistoryInfo($historyId)
   {
      $arPost = array(
         'action' => 'historyInfo',
         'historyId' => $historyId
      );
      $response = $this->getResponse($arPost);
      return $response;
   }
   
   public function getBalance()
   {
      $arPost = array(
         'action' => 'balance',
      );
      $response = $this->getResponse($arPost);
      return $response;
   }
   
   public function getErrors()
   {
      return $this->errors;
   }
   
   public function transfer($arPost)
   {
      $arPost['action'] = 'transfer';
      $response = $this->getResponse($arPost);
      return $response;
   }
   
   public function SetLang($language)
   {
      $this->language = $language;
      return $this;   
   }
   
   public function getShopOrderInfo($arPost)
   {
      $arPost['action'] = 'shopOrderInfo';
      $response = $this->getResponse($arPost);
      return $response;
   }
   
   public function checkUser($arPost)
   {
      $arPost['action'] = 'checkUser';
      $response = $this->getResponse($arPost);
      if (empty($response['errors']))
      {
         return true;
      }
      else
      {
         $this->errors = $response['errors'];
      }
      return false;
   }
   
   public function getExchangeRate($arPost)
   {
      $arPost['action'] = 'getExchangeRate';
      $response = $this->getResponse($arPost);
      return $response;
   }
   
   public function merchant($arPost)
   {
      $arPost['action'] = 'merchant';
      
      $arPost['shop'] = json_encode($arPost['shop']);
      $arPost['form'] = json_encode($arPost['form']);
      $arPost['ps'] = json_encode($arPost['ps']);
      
      if (empty($arPost['ip'])) $arPost['ip'] = $_SERVER['REMOTE_ADDR'];
      
      $response = $this->getResponse($arPost);
      
      if (empty($response['errors']))
      {
         return $response;
      }
      else
      {
         $this->errors = $response['errors'];
      }
      return false;
   }
}
?>

Вот ещё код из главного файла " index.php "

Код: [Выделить]

<?
      if (isset($_POST['payeer'])) {


         $secret = "6LedsyETAAAAAMzk0IloxU3jsHgYggXEMKfyH-UT";

         if($_SERVER['REQUEST_METHOD'] == 'POST')
         {
             if(empty($_POST['g-recaptcha-response'])) {
             echo 'Нужно решить капчу!';
              exit();
            }

            $url = 'https://www.google.com/recaptcha/api/siteverify';

            //data POST
            $recaptcha = $_POST['g-recaptcha-response'];
            $ip = $_SERVER['REMOTE_ADDR'];

            $url_data = $url.'?secret='.$secret.'&response='.$recaptcha.'&remoteip='.$ip;
            $curl = curl_init();

            curl_setopt($curl,CURLOPT_URL,$url_data);
            curl_setopt($curl,CURLOPT_SSL_VERIFYPEER,FALSE);

            curl_setopt($curl,CURLOPT_RETURNTRANSFER,1);


            $res = curl_exec($curl);
            curl_close($curl);

            $res = json_decode($res);





         if($res->success) {

            $payeer = text($_POST['payeer'], $db);
            $idk = '1';

            if ($payeer != "" && strlen($payeer) > 0) {
               $c_payeer = mysqli_query($db, "select id, last from users where payeer = '$payeer'");
               if (mysqli_num_rows($c_payeer) == 0){
                  mysqli_query($db, "insert into users (payeer,ref,referer) values ('$payeer','0','$ref')");
                  if ($ref > 0) {
                     mysqli_query($db, "update users set ref = ref + 1 where id = '$ref'");
                     $payeercosh = mysqli_query($db, "select * from users where id = '1'");
                     $kosh = $payeercosh['payeer'];
                     mysqli_query($db, "insert into compdata_ref (`idk`,`user`,`kosh`,`resvalue`) values ('1','$ref','$kosh','1') ON DUPLICATE KEY UPDATE resvalue = resvalue + '1'");
                  }
               }
               $t = time();
               $wait = mysqli_fetch_array(mysqli_query($db, "select * from settings where `set` = 'wait'"));
               $user_row = mysqli_fetch_array(mysqli_query($db, "select * from users where payeer = '$payeer'"));
               if ($user_row['last']+60*$wait['value'] < $t) {
                  $rand = mt_rand(1,10000);
                  $pr = 0;
                  $op_p = mysqli_query($db, "select * from settings where name = 'price'");
                  while ($op_p_r = mysqli_fetch_assoc($op_p)) {
                     if ($rand >= $op_p_r['set'] && $rand <= $op_p_r['set1']) {
                        $pr = floatval($op_p_r['value']);

                        mysqli_query($db, "update users set money = money + '$pr', sum_p = sum_p + '$pr',kolv = kolv + 1, last = '$t' where  payeer = '$payeer'");
                        //mysqli_query($db, "update tb_compdata set resvalue = resvalue + 1 where user = '$payeer'");
                        mysqli_query($db, "insert into tb_compdata (`idk`,`user`,`resvalue`) values ('1','$payeer','1') ON DUPLICATE KEY UPDATE resvalue = resvalue + '1'");
                        mysqli_query($db, "insert into sp (payeer,sum,time) values ('$payeer','$pr','$t')");

                        if ($user_row['referer'] > 0) {
                           $ref_proc = mysqli_fetch_array(mysqli_query($db, "select * from settings where `set` = 'ref_proc'"));
                           $ref_bon = $pr * floatval($ref_proc['value']);
                           mysqli_query($db, "update users set money = money + '$ref_bon', ref_pay = ref_pay + '$ref_bon' where id = '".$user_row['referer']."'");
                        }
                        break;
                     }
                  }
                  echo '
                            <div style="
                            margin-top:10px;
                             background: #FBF8A3;
                             border: 2px solid #58A090;
                             display: inline-block;
                             padding: 11px 20px;
                             font-weight: 400;
                             color: red;
                             ">Пожалуйста кликните по рекламе в блоке "оплачиваемая реклама" и подождите 30 секунд, так вы поможете сайту!</div><div><br><div class="success">Ваш выигрыш '.$pr.' руб</div></div><br>';
               }else{
                  echo '<div><div class="error">Ошибка, не прошло '.$wait['value'].' минут</div></div>';
               }

               $_SESSION['user'] = $user_row['id'];
               $_SESSION['payeer'] = $user_row['payeer'];

            }else{
               echo '<div><div class="error">Ошибка, не верно введён PAYEER кошелек</div></div>';
            }

         }else{
            echo '<div><div class="error">Ошибка, не верно введена капча</div></div>';
         }

       }

      }

      $kosh = "";
      $otl_time = 0;
      if (isset($_SESSION['user'])) {
         $id_user = intval($_SESSION['user']);
         $user_row = mysqli_fetch_array(mysqli_query($db, "select * from users where id = '$id_user'"));
         $kosh = $user_row['payeer'];
         $wait = mysqli_fetch_array(mysqli_query($db, "select * from settings where `set` = 'wait'"));
         $otl_time = $user_row['last'] + 60*intval($wait['value']) - time();
         if (isset($_POST['vv'])) {
            $min = mysqli_fetch_array(mysqli_query($db, "select * from settings WHERE `set` = 'min_pay'"));
            if ($user_row['money'] >= $min['value']) {
               $sett_row_accountNumber = mysqli_fetch_array(mysqli_query($db, "select * from settings WHERE `set` = 'accountNumber'"));
               $sett_row_apiId = mysqli_fetch_array(mysqli_query($db, "select * from settings where `set` = 'apiId'"));
               $sett_row_apiKey = mysqli_fetch_array(mysqli_query($db, "select * from settings where `set` = 'apiKey'"));

               require_once('cpayeer.php');
               $accountNumber = $sett_row_accountNumber['value'];
               $apiId = $sett_row_apiId['value'];
               $apiKey = $sett_row_apiKey['value'];
               $payeer = new CPayeer($accountNumber, $apiId, $apiKey);
               if ($payeer->isAuth())
               {
                  $initOutput = $payeer->initOutput(array(
                     'ps' => '1136053',
                     //'sumIn' => 1,
                     'curIn' => 'RUB',
                     'sumOut' => $user_row['money'],
                     'curOut' => 'RUB',
                     'param_ACCOUNT_NUMBER' => $user_row['payeer']
                  ));

                  if ($initOutput){
                     $historyId = $payeer->output();
                     if ($historyId > 0){
                        echo "Выплата успешна";
                        mysqli_query($db, "update users set money = money - '".$user_row['money']."', pay = pay + '".$user_row['money']."' where id = '".$user_row['id']."'");
                     }else{
                        echo '<pre>'.print_r($payeer->getErrors(), true).'</pre>';
                     }
                  }else{
                     echo '<pre>'.print_r($payeer->getErrors(), true).'</pre>';
                  }
               }else{
                  echo '<pre>'.print_r($payeer->getErrors(), true).'</pre>';
               }
            }else{
               echo '<div><div class="error">Ошибка, минимум для выплаты '.$min['value'].'</div></div>';
            }
         }

         $user_row = mysqli_fetch_array(mysqli_query($db, "select * from users where id = '$id_user'"));

         if ($otl_time > 0) {
            echo '<div style="color:#FF7999;padding: 5px;
margin: 10px 0px;
font-weight: 600;
color: white;background:#FF7999;">До следующего бонуса осталось <span id="min">'.date('i',$otl_time).'</span>:<span id="sec">'.date('s',$otl_time).'</span></div>';
            echo '
            <script>
            var min = '.date('i',$otl_time).'
            var sec = '.date('s',$otl_time).'
            function timer() {
               if (--sec == -1) {
                  sec = 59;
                  min--;
               }
               $("#sec").empty().append((sec < 10) ? "0"+sec : sec);
               $("#min").empty().append((min < 10) ? "0"+min : min);
               if (sec == 0 && min == 0) {
                  window.location.href = "/"
               }
               setTimeout(timer,1000);
            }
            setTimeout(timer,1000);
            </script>
            ';
         }

         echo '<table class="tb">
               <tr>
                  <td>Ваш Payeer-кошелек:</td>
                  <td>'.$kosh.'</td>
               </tr>
               <tr style="background: #D0F0C0;">
                  <td>Ваш баланс:</td>
                  <td>'.$user_row['money'].'</td>
               </tr>
               <tr>
                  <td>Рефералов:</td>
                  <td>'.$user_row['ref'].'</td>
               </tr>
               <tr style="background: #D0F0C0;">
                  <td>Заработано на рефералах:</td>
                  <td>'.$user_row['ref_pay'].'</td>
               </tr>
               <tr>
                  <td>Вы вывели:</td>
                  <td>'.$user_row['pay'].'</td>
               </tr>
               <tr style="background: #D0F0C0;">
                  <td colspan="2">Ваша реф. ссылка:</td>
               </tr>
               <tr style="background: #D0F0C0;">
                  <td colspan="2">http://'.$_SERVER['SERVER_NAME'].'/?r='.$user_row['id'].'</td>
               </tr>


            </table>


            <form method="POST">
               <input type="submit" class="btn" value="Вывести средства" name="vv">
            </form>

         ';
      }
      ?>