Credits don`t added after vote.I check 100 times script and i don`t see where is error...
MuServer 97d+99i ,vote system by Linkos
I check sql and seems to be ok...i have table dbo.MEMB_CREDITS and there i have memb__id and credits ...
So what can be wrong here ?
PHP Code:<?include("config.php");if($_GET['l']){setcookie('username',''); setcookie('password','');unset($_COOKIE['username']);unset($_COOKIE['password']);}if(isset($_POST['login'])) {$user = mssql_fetch_array(mssql_query("SELECT * FROM MEMB_INFO WHERE memb___id='$_POST[username]' AND memb__pwd='$_POST[password]'"));if(empty($_POST['username']) OR empty($_POST['password'])) { echo "Please complete all fields."; $error=true; }elseif(!$user) { echo "There is no such username or password is wrong"; $error=true; }if(!$error) { setcookie('username',$user['memb___id'],time()+300); setcookie('password',$user['memb__pwd'],time()+300); $_COOKIE['username'] = $user['memb___id']; $_COOKIE['password'] = $user['memb__pwd']; }}if((isset($_COOKIE['username'])) && (isset($_COOKIE['password']))) {echo " <br><center><div style='background: #EEEEEE; padding: 5px; color: #444444; width: 400px; border: 1px dotted #BBBBBB;'>Logged in as <i><b>$_COOKIE[username]</b></i></div><div style='background: #F6F6F6; padding: 5px; width: 400px; border: 1px dotted #BBBBBB;'><a href='?l=true'><font color=red size=4><strong><input type='submit' id='login' name='login' value='LOGOUT' class='commonbtn'/></strong></font></a></div></center><br /><br />";$id = (int) ($_GET['id']);$proxy1 = $_SERVER['HTTP_X_FORWARDED_FOR'];$proxy2 = $_SERVER['HTTP_VIA'];$proxy3 = $_SERVER['HTTP_PROXY_CONNECTION'];$proxy4 = $_SERVER['HTTP_CONNECTION'];$proxy5 = $_SERVER['HTTP_ACCEPT'];$ip = $_SERVER['REMOTE_ADDR'];if($id > 0) {$vote_id = mssql_fetch_array(mssql_query("SELECT * FROM Votes WHERE id='$id'"));$voted = mssql_fetch_array(mssql_query("SELECT * FROM Vote_Log WHERE voteend > ".time()." AND uid='$id' AND (ip='$ip' OR username='".($_COOKIE['username'])."') ORDER BY id DESC"));if(!$vote_id) { $error = true; }if($vote_id['show'] == 0) { $error = true; }if(@$voted) { $error = true; }if(!$error) {mssql_query("INSERT INTO Vote_Log (uid,ip,username,voteend) VALUES('$id','$ip','".($_COOKIE['username'])."','".(time()+$vote_id['vote_time'])."')");if(!empty($proxy1) || !empty($proxy2) || !empty($proxy3) || empty($proxy4) || $proxy4=='close') {}else {$res = mssql_query("SELECT credits FROM MEMB_CREDITS WHERE memb___id='".($_COOKIE['username'])."'");if(mssql_num_rows($res)>0) { mssql_query("UPDATE MEMB_CREDITS SET credits=credits+'$vote_id[credits]' WHERE memb___id='".($_COOKIE['username'])."'"); }else { mssql_query("INSERT INTO MEMB_CREDITS (memb___id, credits) VALUES('".($_COOKIE['username'])."', '$vote_id[credits]')"); }echo "<font size=2><b>You won $vote_id[credits] credits</b></font><br /><br />";}}}//$i = 1;$result = mssql_query("SELECT * FROM Votes WHERE show=1 ORDER BY id desc");while($vote = mssql_fetch_array($result)) {$voted = mssql_fetch_array(mssql_query("SELECT * FROM Vote_Log WHERE (ip='$ip' OR username='".($_COOKIE['username'])."') AND voteend > ".time()." AND uid='$vote[id]' ORDER BY id DESC"));if(!$voted) { echo " <a href='index.php?id=$vote[id]' OnClick=\"window.open('".($vote['link'])."')\" onmouseover=\"overlib('Vote once on ".($vote['vote_time']/60/60)." hours and win $vote[credits] credits');\" onmouseout=\"return nd();\"><img src='".($vote['banner'])."' alt='".($vote['link'])."'></a> "; }else { $vi += 1; echo "<b>You can vote again after: </b><span id='bxx$vi' title='".($voted['voteend']-time())."'>--</span> | "; }$i++;}echo "<script language=\"JavaScript\">anz=$vi; t();</script>";//}else{echo "<br><center><div style='background: #EEEEEE; padding: 5px; color: #444444; width: 400px; border: 1px dotted #BBBBBB;'>Welcome guest <b><i>$ip</i></b>, login to gain full access.</div><div style='background: #F6F6F6; padding: 5px; width: 400px; border: 1px dotted #BBBBBB;'><form method='post' action=''><center></br><strong><font>Username: </font></strong><input type='text' id='username' name='username' style='border: 1px solid #aaaaaa;' size='15' maxlength='10' /><div style='padding:2px;'></div> <strong><font>Password: </font></strong><input type='password' id='password' style='border: 1px solid #aaaaaa;' name='password' size='15' maxlength='10' /><br /><br /> <strong><input type='submit' id='login' name='login' value='SUBMIT' class='commonbtn'/></strong><strong><input type='reset' id='login' name='login' value='CANCEL' class='commonbtn'/></strong></center></form> </div></center>";}?>




Reply With Quote

