Jump to content

Leverkusen

Members
  • Content Count

    52
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Leverkusen

  • Rank
    Regular Member
  1. 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.
  2. Sounds very complicated but i will try to do what i can to get that thing work.
  3. 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
  4. 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?
  5. 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?
  6. 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>";
  7. 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>"; } ?>
  8. 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>"; } ?>
  9. The code looks like this know and i still have the same problem. :/ http://paste2.org/KHkb7FLY
  10. 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.
  11. I will expain from the beginning best as i can Members on my site are posting 'home team' 'away team' 'tip' odd' and 'link' and they can do it unlimited times I want to limit those posting per day to any number i want, so when i want to be limit 2 i change the number in script to 2 NO. Or...a second scenario. All users can make postings but only those who already had 3 clicks (as "like", "good", "yes" or something else) in their profile only they would be able to make posting more than 1 post per day. here was my bad Psycho, for ID 1 is showing this results http://prntscr.com/2qgx3e and other query is showing this result http://prntscr.com/2qgxoa both queries work fine, but something is wrong in the script. $query = "UPDATE clanovi_njihovi_racuni SET klikovi = klikovi-0 WHERE id='$racun'"; this was supposed to reduce ferreral clicks after each post, but i made it not to reduce. based upon your logic, the person must have at least three records for the current day - else you get that error message. This is wrong, the person can post it to 3, when he reaches that limit then he has to receive error message "You met max post count for today" So, on the day that you ran that query you should get that error message for ALL IDs except for ID 106 - because that one had at least three record for the current day. This is totaly on the contrary, they need to be approved to post all the time until they dont reach post limit of 3 When they reach post limit, they should get error message "You met max post count for today, wait for tomorrow'
  12. wow big mistake i changed datum varchar to 'date' and time varchar to 'time; because i do them sepparately http://prntscr.com/2pxvs0 and should i change Null to 'Yes' in the table? when i do SELECT cnr.klikovi, COUNT(cnr.id) AS post_count FROM clanovi_njihovi_racuni AS cnr LEFT JOIN clanovi_njihovi_parovi AS cnp ON cnr.id = cnp.racun AND cnp.datum=curdate() WHERE cnr.id='$racun' GROUP BY cnr.id its saying "MySQL returned an empty result set (i.e. zero rows)."
  13. <?php $postLimit = 2; // upis para if($_POST['tim1']!="" and $_POST['tim2']!="" and $_POST['tip']!="" and $_POST['kvota']!="" and $_POST['link']!="") { $ip = $_SERVER['REMOTE_ADDR']; $tim1 = str_ireplace(array("\"", "'", ""),"", $_POST['tim1']); $tim2 = str_ireplace(array("\"", "'", ""),"", $_POST['tim2']); $tim1 = ucwords(strtolower($tim1)); $tim2 = ucwords(strtolower($tim2)); $tip = str_ireplace(array("\"", "'",""),"", $_POST['tip']); $kvota = str_ireplace(array(","), ".",$_POST['kvota']); $link = str_ireplace(" ", "", $_POST['link']); $prvoslovo = str_ireplace("http://www.flashscore.com/","#", $link); $linkDozvola = ($prvoslovo[0]=="#"); if(!$linkDozvola) { echo "alert('Your link is bad! Copy the link from www.flashscore.com!')"; } else if($kvota<1.01and $kvota>99.99) { echo "alert('Kvota vam nije u opsegu od 1.01 do 99.99 .')"; } else { $racun = $_SESSION['liga_user_id']; $query = "SELECT cnr.klikovi, COUNT(cnr.id) AS post_count FROM clanovi_njihovi_racuni AS cnr LEFT JOIN clanovi_njihovi_parovi AS cnp ON cnr.id = cnp.racun AND cnp.datum=curdate() WHERE cnr.id='$racun' GROUP BY cnr.id"; $result = mysql_query($query) or die("Query: {$query}<br>Error: " . mysql_error()); $row = mysql_result($result); $klikovi = $row['klikovi']; $postCount = $row['post_count']; if($klikovi<3) { echo "<script>alert('You dont have enough Clicks for posting a game.3 Clicks is a minimum')</script>"; } elseif($postCount >= $postLimit) { //Limit met echo "You met max post count for today"; } else { $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'"; $result = mysql_query($query) or die("Query: {$query}<br>Error: " . mysql_error()); $query = "UPDATE clanovi_njihovi_racuni SET klikovi = klikovi-0 WHERE id='$racun'"; $result = mysql_query($query) or die("Query: {$query}<br>Error: " . mysql_error()); echo "alert('Your Game Post is accepted')"; } } } ?> there i made echoes on english language!
×
×
  • 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.