[HELP]SQL Query
Van 1 adott weblap (mssql db-vel) és van 1 (jelenleg csak egyet találtam) hiba benne.
Van rajta vote reward function viszont valamiért a vote adatokat nem írja adatbázisba viszont az rewardot kiadja...
Na most ez a rész működik benne:
define.php részlet a fenti _CASH_UPDATE-hez
Előre is köszönöm a segítséget.
Van rajta vote reward function viszont valamiért a vote adatokat nem írja adatbázisba viszont az rewardot kiadja...
- Kód: Egész kijelölése
case 'vote':
$day = (3600*24);
$vote['id']= $_GET['id'];
foreach($_config['vote_sites'] as $v =>$v1) {
if (in_array($vote['id'], $v1)) {
$vote['key'] = $v1; $vote['keyid'] = $v;
}
$vote['code_generic'][$v1[0]] = array('date'=>time()-$day,'votes'=>0);
}
$vote['code_generic_serial'] = serialize($vote['code_generic']);
//generate user vote db
$rs = $db->Execute('select * from toolz_vote where userid = ?', array($user_auth->username));
$rs = $rs->FetchRow();
if (!$rs) $db->Execute('insert into toolz_vote (userid,votedata) values (?,\''.$vote['code_generic_serial'].'\')',array($user_auth->username));
else $vote['code_generic_serial'] = $rs['votedata'];
$vote['code'] = unserialize($vote['code_generic_serial']);
//end user vote db
//print_r($vote);
if ($vote['id']) {
if ($vote['key']) {
$date = $vote['code'][$vote['id']]['date'];
$diff = round((time()-$date)/$day,0);
$diffH = round((($date+$day)-time())/(3200),0);
$diffH = date_formats(time(),$date+$day);
if ($diff > 0) {
if ($vote['code'][$vote['id']]['votes'] < $vote['key'][2]) {
//generate vote code
$vote['code'][$vote['id']]['votes']++;
$msg = 'Vote Accepted!!! You have been awarded '.$vote['key'][1] .' CASH';
if ($vote['code'][$vote['id']]['votes'] == $vote['key'][2]) {
$vote['code'][$vote['id']]['date'] = time();
$vote['code'][$vote['id']]['votes'] = 0;
} else $msg .= ' You have '.($vote['key'][2]-$vote['code'][$vote['id']]['votes'] ).' more votes for this Vote Rewards.';
$vote['code_serial'] = serialize($vote['code']);
$db->Execute(_CASH_UPDATE,array($vote['key'][1],$user_auth->username));
$db->Execute('update toolz_vote set votedata = \''.$vote['code_serial'].'\' where userid = ?',array($user_auth->username));
//print_r($vote['code']);
$go = $vote['key'][3];
} else $msg = 'Vote Limit Reached. Please try again Later. Next vote in '. $diffH; ;
} else $msg = 'You already voted today! Next vote in '. $diffH;
} else $msg = 'Vote is Invalid! Please try Again!';
}
echo 'VoteScript(';
//print_r($vote);
foreach($_config['vote_sites'] as $v =>$v1) {
$_config['vote_sites'][$v][2] = $vote['code'][$v1[0]]['votes'].'/'.$_config['vote_sites'][$v][2];
}
$result = array('data'=>$_config['vote_sites']);
if ($msg) $result = array('msg'=>$msg,'data'=>$_config['vote_sites']);
if ($go) $result = array('go'=>$go,'msg'=>$msg,'data'=>$_config['vote_sites']);
echo array2json($result);
echo " )";
break;
Na most ez a rész működik benne:
- Kód: Egész kijelölése
$db->Execute(_CASH_UPDATE,array($vote['key'][1],$user_auth->username));
define.php részlet a fenti _CASH_UPDATE-hez
- Kód: Egész kijelölése
define('_CASH_UPDATE','Update '.$_config['DB3'].'.dbo.CashAccount set Cash=Cash+? where UserID = ?');
Előre is köszönöm a segítséget.