forum.lissyara.su

Код: Выделить всё

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'out) as tout from hl_traffic where listing_id = 1 and date + interval 7 day > no' at line 1

Код: Выделить всё

<?


  $frm['gid'] = intval ($frm['gid']);
  $q = 'select 
               *
        from
               hl_groups
       ';
  if (!($sth = mysql_query ($q)))
  {
    exit (mysql_error ());
    ;
  }

  $groups = array ();
  $group = '';
  while ($row = mysql_fetch_array ($sth))
  {
    if (($row['id'] == 1 OR $frm['gid'] == $row['id']))
    {
      $group = $row;
    }

    array_push ($groups, $row);
  }

  $q = 'select count(*) as count 
        from
               hl_listings
        where
               group_id = ' . $group['id'] . ' order by id
       ';
  if (!($sth = mysql_query ($q)))
  {
    exit (mysql_error ());
    ;
  }

  $row = mysql_fetch_array ($sth);
  $count_all = $row['count'];
  $onpage = 30;
  $page = $frm['p'];
  $colpages = ceil ($count_all / $onpage);
  if ($page <= 1)
  {
    $page = 1;
  }

  if (($colpages < $page AND 1 < $colpages))
  {
    $page = $colpages;
  }

  $from = ($page - 1) * $onpage;
  $q = 'select *, 
               date_format(date_added, \'%b %D, %Y\') as added,
               date_format(date_closed, \'%b %D, %Y\') as closed,
               (date_added + interval ' . $settings['new_for_days'] . ' day > current_date) as new,
               ((expiration != 0) && (date_added + interval expiration day < current_date)) as expired
        from
               hl_listings
        where
               group_id = ' . $group['id'] . ' and
               status != 2
        order by expired desc, id
       ';
  if (!($sth = mysql_query ($q)))
  {
    exit (mysql_error ());
    ;
  }

  $listings = array ();
  while ($row = mysql_fetch_array ($sth))
  {
    $q = 'select sum(amount * type) as payout, sum(amount * !type) as spend from hl_statistics where listing_id = ' . $row['id'];
    if (!($ssth = mysql_query ($q)))
    {
      exit (mysql_error ());
      ;
    }

    $srow = mysql_fetch_array ($ssth);
    $row['ratio'] = ($srow['spend'] != 0 ? sprintf ('%.02f', $srow['payout'] / $srow['spend']) : '0.00');
    $row['spend'] = number_format ($srow['spend'], 2);
    $votes_summary = array ('0' => 0, '1' => 0, '2' => 0, '3' => 0);
    $votes_all = 0;
    $avg_vote = '0.0';
    $q = 'select count(*) as cvotes, vote from hl_votes where listing_id = ' . $row['id'] . ' and confirm = \'0\' group by vote';
    if (!($ssth = mysql_query ($q)))
    {
      exit (mysql_error ());
      ;
    }

    while ($srow = mysql_fetch_array ($ssth))
    {
      $votes_all += $srow['cvotes'];
      $votes_summary[$srow['vote']] = $srow['cvotes'];
    }

    if (0 < $votes_all)
    {
      $avg_vote = sprintf ('%.01f', ($votes_summary['3'] * 10 + $votes_summary['2'] * 5 - $votes_summary['1'] * 0 - $votes_summary['0'] * -5) / $votes_all);
    }

    $row['avg_vote'] = $avg_vote;
    $row['cvotes'] = $votes_all;
    $q = 'select sum(`in`) as tin, sum(out) as tout from hl_traffic where listing_id = ' . $row['id'] . ' and date + interval ' . $settings['traffic_count_days'] . ' day > now()';
    if (!($ssth = mysql_query ($q)))
    {
      exit (mysql_error ());
      ;
    }

    $traffic = mysql_fetch_array ($ssth);
    $row['in'] = intval ($traffic['tin']);
    $row['out'] = intval ($traffic['tout']);
    $row['traffic_ratio'] = ($traffic['tout'] == 0 ? '0.0' : sprintf ('%.01f', $traffic['tin'] / $traffic['tout']));
    array_push ($listings, $row);
  }

  $listings = array_splice ($listings, $from, $onpage);
  echo '<s';
  echo 'cript language="javascript"><!--
function editStatistics(id)
{
  w = 400; h = 600;
  t = (screen.height-h-30)/2;
  l = (screen.width-w-30)/2;
  window.open(\'?a=edit_statistics&lid=\' + id, \'edit_statistics\' + id, "top="+t+",left="+l+",width="+w+",height="+h+",resizable=1,scrollbars=1");
}
function editVotes(id)
{
  w = 400; h = 600;
  t = (screen.height-h-30)/2;
  l = (screen.width-w-30)/2;
  window';
  echo '.open(\'?a=edit_votes&lid=\' + id, \'edit_votes\' + id, "top="+t+",left="+l+",width="+w+",height="+h+",resizable=1,scrollbars=1");
}
--></script>

<form name="grps"><input type=hidden name=a value=listings>
<table cellspacing=1 cellpadding=2 border=0 width=100%>
<tr>
  <td><b>Listings: ';
  echo $group['name'];
  echo ' (';
  echo $group['type'];
  echo ')</b></td>
 <td width=1% nowrap>';
  echo '<s';
  echo 'elect name="gid" class=inpts onchange="document.grps.submit()">
';
  foreach ($groups as $grp)
  {
    echo '  <option value="';
    echo $grp['id'];
    echo '" ';
    echo ($grp['id'] == $group['id'] ? 'selected' : '');
    echo '>';
    echo $grp['name'];
    echo ($grp['status'] ? '' : ' (disabled)');
    echo '</option>
';
  }

  echo '     </select> <input type="submit" value="GO" class=sbmt></td>
</tr>
</table>
</form>

<table cellspacing=1 cellpadding=2 border=0 width=100%>
';
  if (0 < sizeof ($listings))
  {
    foreach ($listings as $list)
    {
      $payments = preg_split ('/,/', $list['pay_systems']);
      echo '<tr>
 <td>
  <table cellspacing=0 cellpadding=1 border=0 width=100%><tr><td bgcolor=#808000>
   <table cellspacing=0 cellpadding=2 border=0 bgcolor=#FFFFFF width=100%>
    <tr>
     <td valign=top width=33% >
       <a href="';
      echo $list['url'];
      echo '" target=_blank><b>';
      echo $list['name'];
      echo '</b></a>
       ';
      echo ($list['new'] ? '<b style="color: red"><i>new</i></b>' : '');
      echo '       ';
      echo ($list['expired'] ? '<b style="color: red">expired</b>' : '');
      echo '       <br>
       Status: <b>';
      echo ($list['status'] ? 'On' : 'Off');
      echo '</b><br>
       Paying Status: 
               ';
      if ($list['hyip_status'] == 1)
      {
        echo '<img src="images/m_pay.gif" border=0 alt="Paying" title="Paying" align=absmiddle>';
      }

      echo '               ';
      if ($list['hyip_status'] == 2)
      {
        echo '<img src="images/m_wait.gif" border=0 alt="Waiting" title="Waiting" align=absmiddle>';
      }

      echo '               ';
      if ($list['hyip_status'] == 3)
      {
        echo '<img src="images/m_prob.gif" border=0 alt="Problem" title="Problem" align=absmiddle>';
      }

      echo '               ';
      if ($list['hyip_status'] == 4)
      {
        echo '<img src="images/m_npay.gif" border=0 alt="Not Paying" title="Not Paying" align=absmiddle>';
      }

      echo '        <br>
       Our Investment: <b>';
      echo $list['spend'];
      echo '</b><br>
       Payout Ratio: <nobr><b>';
      echo $list['ratio'];
      echo ' <font color="#FF0000">';
      echo (1 <= $list['ratio'] ? 'in profit' : '');
      echo '</font></b></nobr><br>
       <a href="javascript:editStatistics(\'';
      echo $list['id'];
      echo '\')">Manage Payouts</a><br>
       <!--a href="#">Program Details</a><br-->
       <a href="mailto:';
      echo $list['email'];
      echo '">Contact</a><br>
       <br>
     </td>
     <td valign=top width=33% nowrap>
       <b>';
      echo $list['percents'];
      echo '</b><br>
                  Minimal Spend: <b> 
                  ';
      echo $list['min_spend'];
      echo '                  </b><br>
                  Maximal Spend: <b> 
                  ';
      echo ($list['max_spend'] ? $list['max_spend'] : 'No Limit');
      echo '                  </b><br>
       Referral:  <b>';
      echo ($list['referral'] ? $list['referral'] : 'No');
      echo '</b><br>
       Withdrawal: <b>';
      if ($list['withdrawal_type'] == 1)
      {
        echo 'Manual';
      }

      if ($list['withdrawal_type'] == 2)
      {
        echo 'Instant';
      }

      if ($list['withdrawal_type'] == 3)
      {
        echo 'Automatic';
      }

      echo '</b><br>
       <br>
     </td>
     <td valign=top width=33% nowrap>
       Our Rating: ';
      for ($i = 1; $i <= 5; ++$i)
      {
        if ($i <= intval ($list['rating']))
        {
          echo '<img src="images/full_star.gif" align=absmiddle>';
          continue;
        }
        else
        {
          echo '<img src="images/empty_star.gif" align=absmiddle>';
          continue;
        }
      }

      echo '<br>
       Votes: <b>';
      echo $list['avg_vote'];
      echo ' - ';
      echo $list['cvotes'];
      echo ' votes</b><br>
       <a href="javascript:editVotes(\'';
      echo $list['id'];
      echo '\')">Manage Votes</a><br>
';
      if ((((($list['support_email'] OR $list['support_form']) OR $list['support_forum']) OR $list['support_phone']) OR $list['support_aim']))
      {
        echo '       Support: 
               ';
        if ($list['support_email'])
        {
          echo '<a href="mailto:';
          echo $list['support_email'];
          echo '"><img src="images/smail.gif" border=0 alt="Support E-Mail" title="Support E-Mail" align=absmiddle></a>';
        }

        echo '               ';
        if ($list['support_form'])
        {
          echo '<a href="';
          echo $list['support_form'];
          echo '" target=_blank><img src="images/sform.gif" border=0 alt="Support Form" title="Support Form" align=absmiddle></a>';
        }

        echo '               ';
        if ($list['support_forum'])
        {
          echo '<a href="';
          echo $list['support_forum'];
          echo '" target=_blank><img src="images/sforum.gif" border=0 alt="Support Forum" title="Support Forum" align=absmiddle></a>';
        }

        echo '               ';
        if ($list['support_phone'])
        {
          echo '<img src="images/sphone.gif" border=0 alt="Phone: ';
          echo $list['support_phone'];
          echo '" title="Phone: ';
          echo $list['support_phone'];
          echo '" align=absmiddle>';
        }

        echo '               ';
        if ($list['support_aim'])
        {
          echo '<img src="images/smsn.gif" border=0 alt="';
          echo $list['support_aim'];
          echo '" title="';
          echo $list['support_aim'];
          echo '" align=absmiddle>';
        }

        echo '       <br>
';
      }

      echo '       Added: <b>';
      echo $list['added'];
      echo '</b><br>
       In: <b>';
      echo $list['in'];
      echo '</b> Out: <b>';
      echo $list['out'];
      echo '</b> Ratio: <b>';
      echo $list['traffic_ratio'];
      echo '</b>
       <br>
     </td>
     <td valign=top width=33%>
       <a href="?a=edit_listing&lid=';
      echo $list['id'];
      echo '&gid=';
      echo $frm['gid'];
      echo '&p=';
      echo $frm['p'];
      echo '">[edit]</a><br>
       <a href="?a=delete_listing&lid=';
      echo $list['id'];
      echo '&gid=';
      echo $frm['gid'];
      echo '&p=';
      echo $frm['p'];
      echo '" onclick="return confirm(\'Do you really want to delete this listing?\')">[delete]</a><br>
       <br>
     </td>
    </tr>
    <tr>
      <td colspan=4>';
      echo $list['description'];
      echo '</td>
    </tr>
    <tr>
      <td colspan=4 nowrap>';
      foreach ($payments as $pay)
      {
        echo '<img src="images/';
        echo $pay;
        echo '.gif" align=absmiddle alt="';
        echo $pay;
        echo '" title="';
        echo $pay;
        echo '"> ';
      }

      echo '</td>
    </tr>
   </table>
  </td></tr></table>
 </td>
</tr>
';
    }
  }
  else
  {
    echo '<tr>
    <td bgcolor=FFF9B3 colspan=4>No Listings found.</td>
</tr>
';
  }

  echo '</table>
<br>
<form method=post>
<input type="hidden" name="a" value="add_listing">
<input type="hidden" name="gid" value="';
  echo $frm['gid'];
  echo '">
<input type="submit" value="Add Listing" class=sbmt>
</form>
<center>
';
  if (1 < $colpages)
  {
    if (1 < $page)
    {
      echo ' <a href="?a=listings&gid=';
      echo $frm['gid'];
      echo '&p=';
      echo $page - 1;
      echo '"><<</a> ';
    }

    for ($i = 1; $i <= $colpages; ++$i)
    {
      if ($i == $page)
      {
        echo ' <b>';
        echo $i;
        echo '</b> ';
        continue;
      }
      else
      {
        echo ' <a href="?a=listings&gid=';
        echo $frm['gid'];
        echo '&p=';
        echo $i;
        echo '">';
        echo $i;
        echo '</a> ';
        continue;
      }
    }

    if ($page < $colpages)
    {
      echo ' <a href="?a=listings&gid=';
      echo $frm['gid'];
      echo '&p=';
      echo $page + 1;
      echo '">>></a> ';
    }
  }

  echo '</center>


<br>
';
  echo start_info_table ('100%');
  echo 'In this section you can manage your listings.<br>
You can see most listing parameters here.<br>
Use <b>Manage Payouts</b> link to add/remove payouts for each listings. Listing Payout Ratio counts based on data in the  Payouts Statistics. You should add initial deposit to program manually. Program payouts can be added manually or using the <a href="?a=import_transactions">Import Transactions</a> section.';
  echo '<br>
Use <b>Manage Votes</b> link to view or remove users\' votes.<br>
To <b>edit</b> listing settings click on the "edit" link.
';
  echo end_info_table ();
?>

Код: Выделить всё

<?



  $frm['gid'] = intval ($frm['gid']);
  $q = 'select * from hl_groups';
  if (!($gsth = mysql_query ($q)))
  {
    exit (mysql_error ());
    ;
  }

  $groups = array ();
  while ($grow = mysql_fetch_array ($gsth))
  {
    array_push ($groups, $grow);
  }

  echo '<form method=post>
<input type="hidden" name="a" value="add_listing">
<input type="hidden" name="action" value="save">
<input type="hidden" name="gid" value="';
  echo $frm['gid'];
  echo '">
<input type="hidden" name="p" value="';
  echo $frm['p'];
  echo '">
<table cellspacing=1 cellpadding=2 border=0 width=100%>
<tr>
 <td width=30%>Name:</td><td><input type="text" name="name" value="" class=inpts size=50></td>
</tr>
<tr>
 <td>Group:</td>
 <td>
  ';
  echo '<s';
  echo 'elect name="group_id" class=inpts>
';
  foreach ($groups as $group)
  {
    echo '    <option value="';
    echo $group['id'];
    echo '" ';
    echo ($group['id'] == $frm['gid'] ? 'selected' : '');
    echo '>';
    echo htmlspecialchars ($group['name']);
    echo '</option>
';
  }

  echo '  </select>
 </td>
</tr>
<tr>
 <td>Rating:</td>
 <td>
   ';
  echo '<s';
  echo 'elect name="rating" class=inpts>
';
  for ($i = 0; $i <= 5; ++$i)
  {
    echo '     <option value=';
    echo $i;
    echo '>';
    echo $i;
    echo '</option>
';
  }

  echo '   </select>
 </td>
</tr>
<tr>
 <td>Status:</td>
  <td>
   ';
  echo '<s';
  echo 'elect name="status" class=inpts>
     <option value=0>Off</option>
     <option value=1 selected>On</option>
     <option value=2>Not Approved</option>
   </select>
  </td>
</tr>
<tr>
 <td>Paying Status:</td>
  <td>
   ';
  echo '<s';
  echo 'elect name="hyip_status" class=inpts>
     <option value=1>Paying</option>
     <option value=2 selected>Waiting</option>
     <option value=3>Problem</option>
     <option value=4>Not Paying</option>
   </select>
  </td>
</tr>
<tr>
 <td>URL:</td><td><input type="text" name="url" value="" class=inpts size=50></td>
</tr>
<tr>
 <td>Percents:</td><td><input type="text" name="percents" value="" class=inpts size=50></td>
</tr>';
  echo '
<tr>
      <td>Minimal Spend:</td>
      <td><input type="text" name="min_spend" value="" class=inpts size=50></td>
</tr>
<tr>
      <td>Maximal Spend:</td>
      <td><input type="text" name="max_spend" value="" class=inpts size=50></td>
</tr>
<tr>
 <td>Referral:</td><td><input type="text" name="referral" value="" class=inpts size=50></td>
</tr>
<tr>
 <td>Withdrawal:</td>
 <td>
   ';
  echo '<s';
  echo 'elect name="withdrawal_type" class=inpts>
     <option value=1>Manual</option>
     <option value=2>Instant</option>
     <option value=3>Automatic</option>
   </select>
 </td>
</tr>
<tr>
 <td>Contact E-mail:</td><td><input type="text" name="email" value="" class=inpts size=50></td>
</tr>
<tr>
 <td>Support E-mail:</td><td><input type="text" name="support_email" value="" class=inpts size=50></td>
</tr>
<tr>
 <td>Support Fo';
  echo 'rm:</td><td><input type="text" name="support_form" value="" class=inpts size=50></td>
</tr>
<tr>
 <td>Support Forum:</td><td><input type="text" name="support_forum" value="" class=inpts size=50></td>
</tr>
<tr>
 <td>Support Phone:</td><td><input type="text" name="support_phone" value="" class=inpts size=50></td>
</tr>
<tr>
 <td>Support AIM:</td><td><input type="text" name="support_aim" value="" class=inpts size=50></td>
</';
  echo 'tr>
<tr>
 <td>Added:</td>
';
  $date = get_date_arrays ('', '', '', 5, 5);
  echo ' 
 <td>
  ';
  echo '<s';
  echo 'elect name="month" class=inpts>
';
  foreach ($date['MONTHS'] as $data)
  {
    echo '   <option value="';
    echo $data['VALUE'];
    echo '" ';
    echo ($data['SELECTED'] == 1 ? 'selected' : '');
    echo '>';
    echo $data['NAME'];
    echo '</option>
';
  }

  echo '  
  </select>
  ';
  echo '<s';
  echo 'elect name="day" class=inpts>
';
  foreach ($date['DAYS'] as $data)
  {
    echo '   <option value="';
    echo $data['VALUE'];
    echo '" ';
    echo ($data['SELECTED'] == 1 ? 'selected' : '');
    echo '>';
    echo $data['NAME'];
    echo '</option>
';
  }

  echo '  
  </select>
  ';
  echo '<s';
  echo 'elect name="year" class=inpts>
';
  foreach ($date['YEARS'] as $data)
  {
    echo '   <option value="';
    echo $data['VALUE'];
    echo '" ';
    echo ($data['SELECTED'] == 1 ? 'selected' : '');
    echo '>';
    echo $data['NAME'];
    echo '</option>
';
  }

  echo '  
  </select>
 </td>
</tr>
<tr>
      <td>Expires After:</td>
      <td><input type="text" name="expiration" value="';
  echo htmlspecialchars ($row['expiration']);
  echo '" class=inpts size=10> days (enter \'0\' to skip limitation)</td>
</tr>
<tr>
 <td>Closed:</td>
';
  $date = get_date_arrays ('0', '0', '0', 5, 5);
  echo ' 
 <td>
  ';
  echo '<s';
  echo 'elect name="cmonth" class=inpts>
   <option value=0>-</option>
';
  foreach ($date['MONTHS'] as $data)
  {
    echo '   <option value="';
    echo $data['VALUE'];
    echo '" ';
    echo ($data['SELECTED'] == 1 ? 'selected' : '');
    echo '>';
    echo $data['NAME'];
    echo '</option>
';
  }

  echo '  
  </select>
  ';
  echo '<s';
  echo 'elect name="cday" class=inpts>
   <option value=0>-</option>
';
  foreach ($date['DAYS'] as $data)
  {
    echo '   <option value="';
    echo $data['VALUE'];
    echo '" ';
    echo ($data['SELECTED'] == 1 ? 'selected' : '');
    echo '>';
    echo $data['NAME'];
    echo '</option>
';
  }

  echo '  
  </select>
  ';
  echo '<s';
  echo 'elect name="cyear" class=inpts>
   <option value=0>-</option>
';
  foreach ($date['YEARS'] as $data)
  {
    echo '   <option value="';
    echo $data['VALUE'];
    echo '" ';
    echo ($data['SELECTED'] == 1 ? 'selected' : '');
    echo '>';
    echo $data['NAME'];
    echo '</option>
';
  }

  echo '  
  </select>
 </td>
</tr>
<tr>
  <td valign=top>Payment Systems:</td>
  <td>
';
  $payments = preg_split ('/\\s*,\\s*/', $settings['payments']);
  foreach ($payments as $payment)
  {
    echo '   <input type="checkbox" name="payments[';
    echo $payment;
    echo ']" value=1> ';
    echo $payment;
    echo '<br>
';
  }

  echo '  </td>
</tr>
<tr>
 <td>HYIP E-Gold Accounts:<br>';
  echo '<s';
  echo 'mall>comma sparated</small></td><td><input type="text" name="account" value="" class=inpts size=10></td>
</tr>
<tr>
  <td colspan=2>Description:</td>
</tr>
<tr>
  <td colspan=2><textarea name="description" cols=82 rows=5 class=inpts></textarea></td>
</tr>
';
  echo '<tr>
  <td colspan=2><input type="submit" value="Add" class=sbmt></td>
</tr>
</table>
</form>

';
?>

Код: Выделить всё

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'out) as tout from hl_traffic where listing_id = 1 and date + interval 7 day > no' at line 1

Код: Выделить всё

$from = ($page - 1) * $onpage;
  $q = 'select *,
               date_format(date_added, \'%b %D, %Y\') as added,
               date_format(date_closed, \'%b %D, %Y\') as closed,
               (date_added + interval ' . $settings['new_for_days'] . ' day > current_date) as new,
               ((expiration != 0) && (date_added + interval expiration day < current_date)) as expired
        from
               hl_listings
        where
               group_id = ' . $group['id'] . ' and
               status != 2
        order by expired desc, id
       ';
  if (!($sth = mysql_query ($q)))
  {
    exit (mysql_error ());
    ;
  }

Код: Выделить всё

 date_format(date_added, \'%b %D, %Y\') as added,
 date_format(date_closed, \'%b %D, %Y\') as closed,

Код: Выделить всё

\'%b %D, %Y\'

Код: Выделить всё

$q = 'select sum(`in`) as tin, sum(out) as tout from hl_traffic where listing_id = ' . $row['id'] . ' and date + interval ' . $settings['traffic_count_days'] . ' day > now()';

Код: Выделить всё

$q = 'select sum(`in`) as tin, sum(`out`) as tout from hl_traffic where listing_id = ' . $row['id'] . ' and date + interval ' . $settings['traffic_count_days'] . ' day > now()';

Код: Выделить всё

<td>
  ';
  echo '<s';
  echo 'elect name="group_id" class=inpts>
';

Код: Выделить всё

echo "<... ></...>";