Leverkusen

Well whats the high temperature? I will consider that, i have some strange sound when my pc is turned on, some kind of thin crunch.

Sounds very complicated but i will try to do what i can to get that thing work.

I cleaned my PC 2 weeks ago, maybe i should do it again. My temperatures are always changing, when i dont do anything its like 59, but when i do its up to 80, so what is the problem, what can be done to be fixed? http://prntscr.com/7l09j4

I sent a problem to my hosting about this and i mentioned that other guy uses contact script perfectly fine and they answered this http://prntscr.com/7l05jc So i guess its something about script or maybe other mailserver?

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?

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>";

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>"; } ?>

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>"; } ?>

bump

The code looks like this know and i still have the same problem. :/ http://paste2.org/KHkb7FLY

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.

IS there any special code for doing this? Im not familiar with this kind of optimising

Thank you i really understand it now. Hey Jacquet. How is it offline? Its live on my website? You cant access it if you dont have the internet?

How can i know if someone is using on my site 2 or more accounts? What should i do exactly?

How can i detect someone who is using proxy and has 2 or more accounts on my website?Or anyway, the important thing for me it is that they dont cheat because i have a competition and its forbidden to have 2 or more accounts.

thats the thing i needed thanx alot

<?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

how would it look like?

if i put -7 it will not be from all 7 days, only from that 7th day

yes but im afraid the script won't work because its supposed to show a message alert 'Postignut maksimalni broj parova u danu' (Max number of pairs reached) if $broj po danu>9

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");

Fatal error: Call to undefined function curdate() in /home/globalbe/public_html/test.php

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>"; } } ?>

dots were the problem thanks Ch0cu3r thanks for co-operating and helping ginerjm

i removed that but its still the same, i dont use <font> tag here echo "<td align='center' class='$cls'><b>$val</b></td>";