Jump to content

Leverkusen

Members
 View Profile  See their activity

  • Posts

    52

  • Joined

  • Last visited

 Content Type 

Posts posted by Leverkusen

    Contact Script

    in PHP Coding Help

    Posted

    I have my own contact script working fine on my site, but in my other site which is a free hosting, its not working, and the code is the same, i know a guy having a site in the same hosting and he has a working contact script, what could be the possible problem? :)

    Limit to 1 post per day

    in PHP Coding Help

    Posted

    I solved the problem adding this

    $today = mysql_query("SELECT COUNT(1) FROM `clanovi_njihovi_parovi` WHERE `racun` = {$racun} AND `datum` > DATE_SUB(NOW(), INTERVAL 1 DAY)");
    $row = mysql_fetch_array($today);
    $total_posts = $row[0];
        
            if($total_posts <1)

     

     

     

     

    else if($total_posts>=1)echo "<script>alert('You already played today.')</script>";

    Limit to 1 post per day

    in PHP Coding Help

    Posted · Edited by Leverkusen

    Code looks like this now, i added this things but i can still post when i want.

    When posts is created i get this http://prntscr.com/7fj7xi 1st is post id and racun is user id

     

    $today = mysql_query("select * from kurpal4_988.clanovi_njihovi_parovi where (clanovi_njihovi_parovi.datum >= current_date() - interval 1 day) and clanovi_njihovi_parovi.racun = 'racun' ");

     

    if($today==1);

     

     

    else if($today==0)echo "<script>alert('Please wait tomorrow.')</script>";
          

    <?php
// upis para
if($_POST['tim1']!="" and $_POST['tim2']!="" and $_POST['mtime']!="" and $_POST['tip']!="" and $_POST['kvota']!="" and $_POST['ulog']!="" and $_POST['link']!=""){
	$racun=$_SESSION['liga_user_id'];
	$result = mysql_query("select * from clanovi_njihovi_racuni where id='$racun';");
	$row = mysql_fetch_array($result);
	$profit = $row['profit'];
	$klikovi = $row['klikovi'];
	
	
	$tim1=str_ireplace(array("\"","'","<",">"),"",$_POST['tim1']);
	$tim2=str_ireplace(array("\"","'","<",">"),"",$_POST['tim2']);
	$mtime=str_ireplace(array("\"",";","/","-"),":",$_POST['mtime']);
	$tip=str_ireplace(array("\"","'","<",">"),"",$_POST['tip']);
	
	$kvota=str_ireplace(array(","),".",$_POST['kvota']);
        $ulog=str_ireplace(array(","),".",$_POST['ulog']);
	$link=$_POST['link'];
	$ip=$_SERVER['REMOTE_ADDR'];
	$tim1=strtolower($tim1);$tim1=ucwords($tim1);
	$tim2=strtolower($tim2);$tim2=ucwords($tim2);
	
	$link=str_ireplace(" ","",$link);
	$prvoslovo=str_ireplace("http://www.flashscore.com/","#",$link);
	$linkDozvola=0;
        
        $today = mysql_query("select * from kurpal4_988.clanovi_njihovi_parovi where (clanovi_njihovi_parovi.datum >= current_date() - interval 1 day) and clanovi_njihovi_parovi.racun = 'racun' ");
        
        if($today==1);
	if($prvoslovo[0]=="#")$linkDozvola=1; 
	if($linkDozvola==1 and $kvota>1 and $kvota<100){
		$result = mysql_query("insert into clanovi_njihovi_parovi set racun='$racun',ip='$ip',datum=curdate(),vrijeme=curtime(),mtime='$mtime',tim1='$tim1',tim2='$tim2', tip='$tip', kvota='$kvota',ulog='$ulog',link='$link';");
	}
	else if($today==0)echo "<script>alert('Please wait tomorrow.')</script>";
	else if($linkDozvola==0)echo "<script>alert('Vas link je neispravan. Link utakmice kopirajte sa www.flashscore.com .')</script>";
	else if($kvota<1.01 and $kvota>99.99)echo "<script>alert('Kvota vam nije u opsegu od 1.01 do 99.99 .')</script>";
}
?>

    Limit to 1 post per day

    in PHP Coding Help

    Posted 


    
Code looks like this now, bolded things are added but still i can post when i want.
    
<?php
    
// upis para
    
if($_POST['tim1']!="" and $_POST['tim2']!="" and $_POST['mtime']!="" and $_POST['tip']!="" and $_POST['kvota']!="" and $_POST['ulog']!="" and $_POST['link']!=""){
    
	$racun=$_SESSION['liga_user_id'];
    
	$result = mysql_query("select * from clanovi_njihovi_racuni where id='$racun';");
    
	$row = mysql_fetch_array($result);
    
	$profit = $row['profit'];
    
	$klikovi = $row['klikovi'];


    
	$tim1=str_ireplace(array("\"","'","<",">"),"",$_POST['tim1']);
    
	$tim2=str_ireplace(array("\"","'","<",">"),"",$_POST['tim2']);
    
	$mtime=str_ireplace(array("\"",";","/","-"),":",$_POST['mtime']);
    
	$tip=str_ireplace(array("\"","'","<",">"),"",$_POST['tip']);

    
	$kvota=str_ireplace(array(","),".",$_POST['kvota']);
    
        $ulog=str_ireplace(array(","),".",$_POST['ulog']);
    
	$link=$_POST['link'];
    
	$ip=$_SERVER['REMOTE_ADDR'];
    
	$tim1=strtolower($tim1);$tim1=ucwords($tim1);
    
	$tim2=strtolower($tim2);$tim2=ucwords($tim2);

    
	$link=str_ireplace(" ","",$link);
    
	$prvoslovo=str_ireplace("http://www.flashscore.com/","#",$link);
    
	$linkDozvola=0;

    
        $today = mysql_query("select * from kurpal4_988.clanovi_njihovi_parovi where (clanovi_njihovi_parovi.datum >= current_date() - interval 1 day) and clanovi_njihovi_parovi.racun = 'some username' ");

    
        if($today==1);
    
	if($prvoslovo[0]=="#")$linkDozvola=1; 
    
	if($linkDozvola==1 and $kvota>1 and $kvota<100){
    
		$result = mysql_query("insert into clanovi_njihovi_parovi set racun='$racun',ip='$ip',datum=curdate(),vrijeme=curtime(),mtime='$mtime',tim1='$tim1',tim2='$tim2', tip='$tip', kvota='$kvota',ulog='$ulog',link='$link';");
    
	}
    
	else if($today==0)echo "<script>alert('Please wait tomorrow.')</script>";
    
	else if($linkDozvola==0)echo "<script>alert('Vas link je neispravan. Link utakmice kopirajte sa www.flashscore.com .')</script>";
    
	else if($kvota<1.01 and $kvota>99.99)echo "<script>alert('Kvota vam nije u opsegu od 1.01 do 99.99 .')</script>";
    
}
    
?>

     

    Save/Copy database tables to other site.

    in MySQL Help

    Posted

    Is it possible to save history of all my tables from my other site and copy all those history into my new one?

    I have milions of posts at my site, but since im moving to other one which is a free host, i want to have all those history.

    I can easily copy main structure but i have like millions of posts and i want to keep them all. :)

    White empty page

    in PHP Coding Help

    Posted 

    <?php
// upis para
if($_POST['tim1']!="" and $_POST['tim2']!="" and $_POST['tip']!="" and $_POST['kvota']!="" and $_POST['link']!=""){
    $racun=$_SESSION['liga_user_id'];
    $result = mysql_query("select * from clanovi_njihovi_racuni where id='$racun';");
    $row = mysql_fetch_array($result);
    $klikovi = $row['klikovi'];
    
    $tim1=str_ireplace(array("\"","'","<",">"),"",$_POST['tim1']);
    $tim2=str_ireplace(array("\"","'","<",">"),"",$_POST['tim2']);
    $tip=str_ireplace(array("\"","'","<",">"),"",$_POST['tip']);
    
    $kvota=str_ireplace(array(","),".",$_POST['kvota']);
    $link=$_POST['link'];
    $ip=$_SERVER['REMOTE_ADDR'];
    
    $tim1=strtolower($tim1);$tim1=ucwords($tim1);
    $tim2=strtolower($tim2);$tim2=ucwords($tim2);
    
    $link=str_ireplace(" ","",$link);
    $prvoslovo=str_ireplace("http://www.flashscore.com/","#",$link);
    $linkDozvola=0;
    $broj_po_danu=1;

$select = mysql_query("SELECT racun FROM clanovi_njihovi_parovi WHERE datum=CURDATE()");
if(mysql_num_rows($select) == $broj_po_danu){
echo 'Postignut maksimalni broj parova u danu';
} else {
    if($prvoslovo[0]=="#")$linkDozvola=1; 
    if($linkDozvola==1 and $kvota>1 and $kvota<100){
        $result = mysql_query("insert into clanovi_njihovi_parovi set racun='$racun',ip='$ip',datum=curdate(),vrijeme=curtime(),tim1='$tim1',tim2='$tim2', tip='$tip', kvota='$kvota',link='$link';");
    }
    else if($linkDozvola==0)echo "<script>alert('Vas link je neispravan. Link utakmice kopirajte sa www.flashscore.com .')</script>";
    else if($kvota<1.01 and $kvota>99.99)echo "<script>alert('Kvota vam nije u opsegu od 1.01 do 99.99 .')</script>";
}
}
?>

    I dont get any error, but this is not working, i can still post

    last 7 days stats

    in PHP Coding Help

    Posted

    a part of a code where is showind me the yesterday's results, how i can change that to last 7 days results?

    if($_GET['id']==""){
	$result = mysql_query("select *,
		(select count(*) from clanovi_njihovi_parovi where status = 1 and racun=r.id and datum=curdate()-1) pog_pre,
		(select count(*) from clanovi_njihovi_parovi where status = 0 and racun=r.id and datum=curdate()-1) 
promaseno_pre,
		(select avg(kvota) from clanovi_njihovi_parovi where status =0 and racun=r.id) prosjek_l
		from clanovi_njihovi_racuni r order by profit desc,id");

    White empty page

    in PHP Coding Help

    Posted

    When i post, get white page fo no reason, what could be the problem?

    <?php
// upis para
if($_POST['tim1']!="" and $_POST['tim2']!="" and $_POST['tip']!="" and $_POST['kvota']!="" and $_POST['link']!=""){
    $racun=$_SESSION['liga_user_id'];
    $result = mysql_query("select * from clanovi_njihovi_racuni where id='$racun';");
    $row = mysql_fetch_array($result);
    $klikovi = $row['klikovi'];
    
    $tim1=str_ireplace(array("\"","'","<",">"),"",$_POST['tim1']);
    $tim2=str_ireplace(array("\"","'","<",">"),"",$_POST['tim2']);
    $tip=str_ireplace(array("\"","'","<",">"),"",$_POST['tip']);
    
    $kvota=str_ireplace(array(","),".",$_POST['kvota']);
    $link=$_POST['link'];
    $ip=$_SERVER['REMOTE_ADDR'];
    
    $tim1=strtolower($tim1);$tim1=ucwords($tim1);
    $tim2=strtolower($tim2);$tim2=ucwords($tim2);
    
    $link=str_ireplace(" ","",$link);
    $prvoslovo=str_ireplace("http://www.flashscore.com/","#",$link);
    $linkDozvola=0;
        $broj_po_danu = 9;
        $datum=curdate();
$select = mysql_query("SELECT racun FROM clanovi_njihovi_racuni WHERE datum_unosa='$datum'");

if(mysql_num_rows($select) == $broj_po_danu){
echo 'Postignut maksimalni broj parova u danu';
} else {
    if($prvoslovo[0]=="#")$linkDozvola=1; 
    if($linkDozvola==1 and $kvota>1 and $kvota<100){
        $result = mysql_query("insert into clanovi_njihovi_parovi set racun='$racun',ip='$ip',datum=curdate(),vrijeme=curtime(),tim1='$tim1',tim2='$tim2', tip='$tip', kvota='$kvota',link='$link';");
    }
    else if($linkDozvola==0)echo "<script>alert('Vas link je neispravan. Link utakmice kopirajte sa www.flashscore.com .')</script>";
    else if($kvota<1.01 and $kvota>99.99)echo "<script>alert('Kvota vam nije u opsegu od 1.01 do 99.99 .')</script>";
}
}
?>
×
×
  • Create New...

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.