Usar variable como url para redireccionar

  • Autor Autor rotzank
  • Fecha de inicio Fecha de inicio
R

rotzank

Curioso
¡Usuario con pocos negocios! ¡Utiliza siempre saldo de Forobeta!
Hola a todos! Pues me he descargado un script que funciona como adfl.ly y lo que yo queria hacer es modificarlo para que me funcione como redireccionador para mi pagina web que es un sitio warez de peliculas, lo que yo quiero hacer es acortar el url que lleva a ver el video o la descarga y en ves de que despues de los 5 segundos aparesca el boton para dar click, que vaya a la pagina automaticamente, estuve viendo el codigo pero realmente se muy poco de php recien estoy empezando a aprender y no se como hacer esto, ¿sera que podrian orientarme?
este es el arhivo:

Insertar CODE, HTML o PHP: 
<?php
require("./dbconnect.php");
include("./include/functions.php");

$uip = getIP();

?>


<?php

$code = checkerr($_GET['code']);
$code = mysql_real_escape_string($code);


$query = mysql_query("SELECT * FROM items WHERE code='$code'");
$numrows = mysql_num_rows($query);
$qqf = mysql_fetch_array($query);
$adctype = $qqf['advtype'];
$urlto = $qqf['url'];
$itemuser = $qqf['username'];

$ip = $_SERVER['REMOTE_ADDR'];
$ip_number = sprintf("%u", ip2long($ip));

$country_query  = "SELECT `country_name` FROM `ip2country` WHERE `begin_ip_num`<=$ip_number AND `end_ip_num`>=$ip_number";
$country_exec = mysql_query($country_query);
$ccode_array = @mysql_fetch_array($country_exec);
$country_name = $ccode_array['country_name'];

if($country_name == '') {

$country_name = 'all';

} 





$getvalues = mysql_query("SELECT * FROM countrylist WHERE country='$country_name'");
$fgvalues = mysql_fetch_array($getvalues);
$ppvvalue = $fgvalues['ppv'];
$ppvbvalue = $fgvalues['ppvb'];
?>

<?php

if($adctype == 'interstitial') {

$checkforads = mysql_query("SELECT * FROM ads WHERE adtype='interstitial' AND countries='$country_name' AND credits > 1 AND active = '1' AND approved = '1' ORDER BY RAND()");
$numcrows = mysql_num_rows($checkforads); 

      if($numcrows != 0) {
        $fetchurl = mysql_fetch_array($checkforads);

        $url = $fetchurl['url'];
        $adid = $fetchurl['id'];

           $querycheck = mysql_query("SELECT * FROM ipcheck WHERE url='$code' AND ip='$uip'");
           $rowip = mysql_num_rows($querycheck);

             if ($rowip == 0) {

             $adowner = $fetchurl['owner'];

 
 

             $referalcheck = mysql_query("SELECT * FROM members WHERE username='$itemuser'");
             $referalfetch = mysql_fetch_array($referalcheck);
             $referalname = $referalfetch['refid']; 

              if ($referalname != "") {

                $settings = mysql_query("SELECT * FROM settings WHERE id='1'");
                $sa = mysql_fetch_array($settings);

               $ppr = $ppvvalue * $sa['ppvr'];
  

                }

 

              }





       }
      else
       {

$checkforads2 = mysql_query("SELECT * FROM ads WHERE adtype='interstitial' AND countries='all' AND credits > 1 AND active = '1' AND approved = '1' ORDER BY RAND()");
       $fetchurl = mysql_fetch_array($checkforads2);

        $url = $fetchurl['url'];
        $adid = $fetchurl['id'];




          $querycheck = mysql_query("SELECT * FROM ipcheck WHERE url='$code' AND ip='$uip'");
           $rowip = mysql_num_rows($querycheck);

             if ($rowip == 0) {

             $adowner = $fetchurl['owner'];




             $referalcheck = mysql_query("SELECT * FROM members WHERE username='$itemuser'");
             $referalfetch = mysql_fetch_array($referalcheck);
             $referalname = $referalfetch['refid']; 

              if ($referalname != "") {

                $settings = mysql_query("SELECT * FROM settings WHERE id='1'");
                $sa = mysql_fetch_array($settings);

               $ppr = $ppvvalue * $sa['ppvr'];
 

                }



              }







       }






}
else

if($adctype == 'banner') {


$checkforads = mysql_query("SELECT * FROM ads WHERE adtype='banner' AND countries='$country_name' AND credits > 1 AND active = '1' AND approved = '1' ORDER BY RAND()");
$numcrows = mysql_num_rows($checkforads); 

      if($numcrows != 0) {
        $fetchurl = mysql_fetch_array($checkforads);

        $url = $fetchurl['url'];
        $imageurl = $fetchurl['imageurl'];
        $adid = $fetchurl['id'];       


         $querycheck = mysql_query("SELECT * FROM ipcheck WHERE url='$code' AND ip='$uip'");
           $rowip = mysql_num_rows($querycheck);

             if ($rowip == 0) {

             $adowner = $fetchurl['owner'];
             $updateads = mysql_query("UPDATE advertisers SET date7=date7 + '1' WHERE username='$adowner'");
             $updateadc = mysql_query("UPDATE ads SET credits = credits - '1' WHERE id='$adid'");

             $qstats = mysql_query("UPDATE stats SET svlinks7=svlinks7 + '1' WHERE id='1'");
             $qstatss = mysql_query("UPDATE stats SET tsvlinks=tsvlinks + '1' WHERE id='1'");

             $ipadd = mysql_query("INSERT INTO ipcheck (url,ip) VALUES  ('$code','$uip')");
             $ipadd2 = mysql_query("INSERT INTO totalip (url,ip,username) VALUES  ('$code','$uip','$session_username')");
             $addin = mysql_query("UPDATE members SET balance=balance + $ppvbvalue WHERE username='$itemuser'");

             $referalcheck = mysql_query("SELECT * FROM members WHERE username='$itemuser'");
             $referalfetch = mysql_fetch_array($referalcheck);
             $referalname = $referalfetch['refid']; 

              if ($referalname != "") {

                $settings = mysql_query("SELECT * FROM settings WHERE id='1'");
                $sa = mysql_fetch_array($settings);

               $ppr = $ppvbvalue * $sa['ppvr'];
               $addbalref = mysql_query("UPDATE members SET balance=balance + $ppr WHERE username='$referalname'");
               $addupearnings = mysql_query("UPDATE members SET uplineearnings=uplineearnings + $ppr WHERE username='itemuser'");
               $graphupp = mysql_query("UPDATE members SET rdate7=rdate7+1 WHERE username='$referalname'");
               $hitupdatee = mysql_query("UPDATE members SET tstats=tstats+1 WHERE username='$referalname'");
               $viewsupdatee = mysql_query("UPDATE items SET views=views + 1 WHERE code='$code'");
               $earningsupdatee = mysql_query("UPDATE items SET mearned=mearned + $ppr WHERE code='$code'");

                }

               $graphup = mysql_query("UPDATE members SET date7=date7+1 WHERE username='$itemuser'");
               $hitupdate = mysql_query("UPDATE members SET tstats=tstats+1 WHERE username='$itemuser'");
               $viewsupdate = mysql_query("UPDATE items SET views=views + 1 WHERE code='$code'");
                $earningsupdatee = mysql_query("UPDATE items SET mearned=mearned + $ppvbvalue WHERE code='$code'");


              }









       }
      else
       {

$checkforads2 = mysql_query("SELECT * FROM ads WHERE adtype='banner' AND countries='all' AND credits > 1 AND active = '1' AND approved = '1' ORDER BY RAND()");
       $fetchurl = mysql_fetch_array($checkforads2);

        $url = $fetchurl['url'];
        $imageurl = $fetchurl['imageurl'];
        $adid = $fetchurl['id']; 


  $querycheck = mysql_query("SELECT * FROM ipcheck WHERE url='$code' AND ip='$uip'");
           $rowip = mysql_num_rows($querycheck);

             if ($rowip == 0) {

             $adowner = $fetchurl['owner'];
             $updateads = mysql_query("UPDATE advertisers SET date7=date7 + '1' WHERE username='$adowner'");
             $updateadc = mysql_query("UPDATE ads SET credits = credits - '1' WHERE id='$adid'");

             $qstats = mysql_query("UPDATE stats SET svlinks7=svlinks7 + '1' WHERE id='1'");
             $qstatss = mysql_query("UPDATE stats SET tsvlinks=tsvlinks + '1' WHERE id='1'");

             $ipadd = mysql_query("INSERT INTO ipcheck (url,ip) VALUES  ('$code','$uip')");
             $ipadd2 = mysql_query("INSERT INTO totalip (url,ip,username) VALUES  ('$code','$uip','$session_username')");
             $addin = mysql_query("UPDATE members SET balance=balance + $ppvbvalue WHERE username='$itemuser'");

             $referalcheck = mysql_query("SELECT * FROM members WHERE username='$itemuser'");
             $referalfetch = mysql_fetch_array($referalcheck);
             $referalname = $referalfetch['refid']; 

              if ($referalname != "") {

                $settings = mysql_query("SELECT * FROM settings WHERE id='1'");
                $sa = mysql_fetch_array($settings);

               $ppr = $ppvbvalue * $sa['ppvr'];
               $addbalref = mysql_query("UPDATE members SET balance=balance + $ppr WHERE username='$referalname'");
               $addupearnings = mysql_query("UPDATE members SET uplineearnings=uplineearnings + $ppr WHERE username='itemuser'");
               $graphupp = mysql_query("UPDATE members SET rdate7=rdate7+1 WHERE username='$referalname'");
               $hitupdatee = mysql_query("UPDATE members SET tstats=tstats+1 WHERE username='$referalname'");
               $viewsupdatee = mysql_query("UPDATE items SET views=views + 1 WHERE code='$code'");
               $earningsupdatee = mysql_query("UPDATE items SET mearned=mearned + $ppr WHERE code='$code'");

                }

               $graphup = mysql_query("UPDATE members SET date7=date7+1 WHERE username='$itemuser'");
               $hitupdate = mysql_query("UPDATE members SET tstats=tstats+1 WHERE username='$itemuser'");
               $viewsupdate = mysql_query("UPDATE items SET views=views + 1 WHERE code='$code'");
                $earningsupdatee = mysql_query("UPDATE items SET mearned=mearned + $ppvbvalue WHERE code='$code'");

              }






       }







}
else
if($adctype == 'none') {


if (false === strpos($urlto, '://')) {
    $urlto = 'http://' . $urlto;
}

  echo"<script type='text/javascript'>window.location.replace('$urlto'); </script>";







}
?>


<html>
<head>
<title><?php echo"{$qff['title']}"; ?></title>
<script type="text/javascript">
// 30 seconds on the clock to start with
var timer = 5;

function countdown() {
  timer--;
  var countdownArea = document.getElementById("area");
  countdownArea.innerHTML = timer;

  if (timer == 0) {
    // time to show the button!
    countdownArea.innerHTML = "<form method='POST'><input type='hidden' name='hidden' value='<?php echo $adid; ?>'><input type='submit' class='skip' value=' ' name='image'></form>";
  } else {
    // calling this function again in 1000 microseconds (1 second)
    setTimeout('countdown()', 1000);
  }
}
</script>
<style type="text/css">
.class1 A:link {text-decoration: none}
.class1 A:visited {text-decoration: none}
.class1 A:active {text-decoration: none}
.class1 A:hover {text-decoration: underline; color: red;}

.class2 A:link {text-decoration: underline overline}
.class2 A:visited {text-decoration: underline overline}
.class2 A:active {text-decoration: underline overline}
.class2 A:hover {text-decoration: underline; color: green;}

.skip {
  width: 150px; 
  height: 50px;
  background-image: url(images/skipad.gif);
  border:none;
  background-color: #317EC4;
  cursor: pointer;
  }
</style>
</head>

<body onload="countdown();" style="margin:0; padding:0;">







<?php

if (mysql_real_escape_string($_POST['image'])) {


$adid = mysql_real_escape_string($_POST['hidden']);






if($adctype == 'interstitial') {

      if($numcrows != 0) {


           $querycheck = mysql_query("SELECT * FROM ipcheck WHERE url='$code' AND ip='$uip'");
           $rowip = mysql_num_rows($querycheck);

             if ($rowip == 0) {

             $adowner = $fetchurl['owner'];
             $updateads = mysql_query("UPDATE advertisers SET date7=date7 + '1' WHERE username='$adowner'");
             $updateadc = mysql_query("UPDATE ads SET credits = credits - '1' WHERE id='$adid'");
 
             $qstats = mysql_query("UPDATE stats SET svlinks7=svlinks7 + '1' WHERE id='1'");
             $qstatss = mysql_query("UPDATE stats SET tsvlinks=tsvlinks + '1' WHERE id='1'");

             $ipadd = mysql_query("INSERT INTO ipcheck (url,ip) VALUES  ('$code','$uip')");
             $ipadd2 = mysql_query("INSERT INTO totalip (url,ip,username) VALUES  ('$code','$uip','$session_username')");
             $addin = mysql_query("UPDATE members SET balance=balance + $ppvvalue WHERE username='$itemuser'");

             $referalcheck = mysql_query("SELECT * FROM members WHERE username='$itemuser'");
             $referalfetch = mysql_fetch_array($referalcheck);
             $referalname = $referalfetch['refid']; 

              if ($referalname != "") {

                $settings = mysql_query("SELECT * FROM settings WHERE id='1'");
                $sa = mysql_fetch_array($settings);

               $ppr = $ppvvalue * $sa['ppvr'];
               $addbalref = mysql_query("UPDATE members SET balance=balance + $ppr WHERE username='$referalname'");
               $addupearnings = mysql_query("UPDATE members SET uplineearnings=uplineearnings + $ppr WHERE username='$referalname'");
               $addupearnings = mysql_query("UPDATE members SET refearnings=refearnings + $ppr WHERE username='$itemuser'");
               $graphupp = mysql_query("UPDATE members SET rdate7=rdate7+1 WHERE username='$referalname'");
               $hitupdatee = mysql_query("UPDATE members SET tstats=tstats+1 WHERE username='$referalname'");
               $viewsupdatee = mysql_query("UPDATE items SET views=views + 1 WHERE code='$code'");
               $earningsupdatee = mysql_query("UPDATE items SET mearned=mearned + $ppr WHERE code='$code'");

                }

               $graphup = mysql_query("UPDATE members SET date7=date7+1 WHERE username='$itemuser'");
               $hitupdate = mysql_query("UPDATE members SET tstats=tstats+1 WHERE username='$itemuser'");
               $viewsupdate = mysql_query("UPDATE items SET views=views + 1 WHERE code='$code'");
                $earningsupdatee = mysql_query("UPDATE items SET mearned=mearned + $ppvvalue WHERE code='$code'");

              }





       }
      else
       {





          $querycheck = mysql_query("SELECT * FROM ipcheck WHERE url='$code' AND ip='$uip'");
           $rowip = mysql_num_rows($querycheck);

             if ($rowip == 0) {

             $adowner = $fetchurl['owner'];
             $updateads = mysql_query("UPDATE advertisers SET date7=date7 + '1' WHERE username='$adowner'");
             $updateadc = mysql_query("UPDATE ads SET credits = credits - '1' WHERE id='$adid'");

             $qstats = mysql_query("UPDATE stats SET svlinks7=svlinks7 + '1' WHERE id='1'");
             $qstatss = mysql_query("UPDATE stats SET tsvlinks=tsvlinks + '1' WHERE id='1'");

             $ipadd = mysql_query("INSERT INTO ipcheck (url,ip) VALUES  ('$code','$uip')");
             $ipadd2 = mysql_query("INSERT INTO totalip (url,ip,username) VALUES  ('$code','$uip','$session_username')");
             $addin = mysql_query("UPDATE members SET balance=balance + $ppvvalue WHERE username='$itemuser'");

             $referalcheck = mysql_query("SELECT * FROM members WHERE username='$itemuser'");
             $referalfetch = mysql_fetch_array($referalcheck);
             $referalname = $referalfetch['refid']; 

              if ($referalname != "") {

                $settings = mysql_query("SELECT * FROM settings WHERE id='1'");
                $sa = mysql_fetch_array($settings);

               $ppr = $ppvvalue * $sa['ppvr'];
               $addbalref = mysql_query("UPDATE members SET balance=balance + $ppr WHERE username='$referalname'");
               $addupearnings = mysql_query("UPDATE members SET uplineearnings=uplineearnings + $ppr WHERE username='itemuser'");
               $graphupp = mysql_query("UPDATE members SET rdate7=rdate7+1 WHERE username='$referalname'");
               $hitupdatee = mysql_query("UPDATE members SET tstats=tstats+1 WHERE username='$referalname'");
               $viewsupdatee = mysql_query("UPDATE items SET views=views + 1 WHERE code='$code'");
               $earningsupdatee = mysql_query("UPDATE items SET mearned=mearned + $ppr WHERE code='$code'");

                }

               $graphup = mysql_query("UPDATE members SET date7=date7+1 WHERE username='$itemuser'");
               $hitupdate = mysql_query("UPDATE members SET tstats=tstats+1 WHERE username='$itemuser'");
               $viewsupdate = mysql_query("UPDATE items SET views=views + 1 WHERE code='$code'");
                $earningsupdatee = mysql_query("UPDATE items SET mearned=mearned + $ppvvalue WHERE code='$code'");

              }







       }






}
else
if($adctype == 'none') {

$qstats = mysql_query("UPDATE stats SET svlinks7=svlinks7 + '1' WHERE id='1'");
$qstatss = mysql_query("UPDATE stats SET tsvlinks=tsvlinks + '1' WHERE id='1'");

if (false === strpos($urlto, '://')) {
    $urlto = 'http://' . $urlto;
}

  echo"<script type='text/javascript'>window.location.replace('$urlto'); </script>";







}





if($numrows == '1'){

if (false === strpos($urlto, '://')) {
    $urlto = 'http://' . $urlto;
}

  echo"<script type='text/javascript'>window.location.replace('$urlto'); </script>";


}
else
 die ("No Shortened url was found");


}


?>












<div style="width: auto; margin:0 0;">

<table width='100%' style='border-bottom:3px solid #3C8005; background: #EFFFE2; background: -webkit-gradient(linear, left top, left bottom, from(#EFFFE2), to(#7EDD32)); 	background: -moz-linear-gradient(left,  #EFFFE2,  #7EDD32);
	filter:  progid:DXImageTransform.Microsoft.gradient(startColorstr='#EFFFE2', endColorstr='#7EDD32');'>
<tr>
<td width='20%'><img src="images/logo.png"></td>
<td width='50%'><?php if($adctype == 'banner') {

echo"<a href='{$url}'><img src='{$imageurl}'></a>";

}
else
echo"&nbsp;"; ?></td>
<td width='30%'><?php if($adctype == 'banner') {

echo"<a href='{$urlto}' style='color: #FFFFFF;'>X (close)</a>";

}
else
echo"<div id='area' align='right' style='height: 63px'>Please Wait...</div>"; ?></td></tr><tr>

<td colspan='3'><center><b>Before going to your website please take your time to visit our sponsors.</b></center></td></tr></table>

<table width='100%' style='background-color: #1CA7F6; border-style: dotted; border-width: 1px;'>
<tr>
<td width='25%'><a href="./index.php" style="color:white;">Shorten urls and earn money.</a></td>
<td width='50%'>&nbsp;</td>
<td width='25%'><a href="./advertise.php" style="color:white;">Your website here starting with 1$ / 1000 visitors.</a></td></tr></table>


<?php 
if($adctype == 'banner') {

echo"<iframe src='$urlto' border='0' framespacing='0' marginheight='0' marginwidth='0' vspace='0' hspace='0' frameborder='0' height='100%' scrolling='auto' width='100%' id='site' allowtransparency='true'></iframe></div>";

}
else
echo"<iframe src='$url' border='0' framespacing='0' marginheight='0' marginwidth='0' vspace='0' hspace='0' frameborder='0' height='100%' scrolling='auto' width='100%' id='site' allowtransparency='true'></iframe></div>";

?>

</body>
</html>
 
Última edición:
Como? Puedes explicarte un poco mas por favor?
Osea el usuario esta 5 seg en la pagina y luego le lleva a otra? supongo que quieres saber a que url enviarlo no? De donde sacas esa url?
 
bueno no se te entiend emuy bien pero podrías declarar una variable y colocar la url
var url = "http://www.aquituurl.com";
según lo que yo te entendí, deberías ser mas especifico.
 
Disculpa tienes razon no me habia explicado nada bien, ya lo he editado espero se entienda mejor
 
Analizando el código veo que funciona con una base de datos, supongo que tendrás esa base de datos no? en esta parte es donde saca la url a la que redirecciona:

PHP: 
$query = mysql_query("SELECT * FROM items WHERE code='$code'");
$numrows = mysql_num_rows($query);
$qqf = mysql_fetch_array($query);
$adctype = $qqf['advtype'];
$urlto = $qqf['url'];
$itemuser = $qqf['username'];

Mas especifico en esta línea --> $urlto = $qqf['url'];
Que corresponde a la columna 'url' de la tabla items de la base de datos donde el codigo es igual a '$code' que a su vez lo saca de aqui --> $code = checkerr($_GET['code']);, esa función no se que hace ya que no esta en el documento que adjuntas supongo que estara en el functions.php que incluye al principio, por el nombre de la función comprobara el código o algo por el estilo.. que no se si con código se referira a un codigo comos los de adfly por ejemplo: AdF.ly - Not Found . Si es asi en la base de datos cada código tendra asignada su url a la que redirecciona y eso esta en la tabla "items" de la base de datos.
Espero haberte ayudado un poco.

edito:
La función checkerr comprobara si existe el código pero por lo que he visto ahora que no me habia fijado el código lo optiene de la url, seguramente la url acortada es algo asi: http://acot.ador/?code=codigo
De aqui es donde saca el código para despues buscar en la base de datos la url del destino.

Saludos
 
Última edición:
guixe94 ya quedo 😉 me ha servido de mucho tu ayuda, muchas gracias, un abrazo!
 
De nada, un placer! 😉

Saludos!
 
Hay que estar conectado o registrado para responder aquí.

Temas similares

misterpirata
usar variable fuera de while
Respuestas
3
Visitas
1K
jueguitos
J
T
Usar variable del vb y un template del vB fuera de la carpeta del vB
Respuestas
1
Visitas
942
ThevBulletin
T
Atrás
Arriba