Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[Dylan]

Heres an addon for staff to see who has voted...

Add This to the bottom of Staff_Logs

Code: [Select]

function view_vote_logs()
{
global $ir,$c,$h,$userid;
print "<h3>Voting Logs</h3>
<table width=75% border=1> <tr> <th>ID</th> <th>Time</th><th>Player</th></tr>";
$q=mysql_query("SELECT * FROM votes ORDER BY  userid ASC",$c);
while($r=mysql_fetch_array($q))
{
print"<tr><td>{$r['site']}</td> <td>".date('F j, Y, g:i:s a',$r['voteTIME'])."</td><td><a href='viewuser.php?u={$r['userid']}'>{$r['userid']}</a></td>
</tr>";
}
}
Add the case

Code: [Select]

case 'votelogs': view_vote_logs(); break;
In the File - Voted.php

Code: [Select]

if($r['rewardtype'] == 1)
 {
 $muneh=money_formatter($reward);
 mysql_query("INSERT INTO votes values ($userid,$id,unix_timestamp())",$c);
 event_add($userid,"Thank you for voting! You have receieved $muneh!", $c);
 mysql_query("UPDATE users SET money=money+$reward WHERE userid=$userid",$c);
 }
 if($r['rewardtype'] == 2)
 {
 mysql_query("INSERT INTO votes values ($userid,$id,unix_timestamp())",$c);
^^ Lines 70-79

And for the link

<a href='staff_logs.php?action=votelogs'>Voting Logs</a><br />


Remove if not needed here.

[buddy]

i have that issue for multiple votes from one site on mine...im using version 2. I will try and re-do the sql and recheck the code

[SaMz]

yup same prob its not to do with database

[SaMz]

got it working

[Cronus]

A new updated version has been uploaded.
There was a small bug that was effecting some games.
This bug may not currently be present on your game, but it could in the future.
It is advised to redownload this mod and upload the voting.php page again.
The voting.php page was the only page with an issue, and is completely fixed now.
Sorry if this caused any trouble.

[DGM-Studios]

Well Done! This is a great mod, i have also seen a few people charging for simular voting system's like this but this is really the best i have seen.
Good One Cronus!

[SaMz]

if anyone is having a problem with this multiple voting...

find in day cron:

Code: [Select]

mysql_query("TRUNCATE TABLE votes;",$c);
Add Below:

Code: [Select]

mysql_query("INSERT INTO `votes` (`userid`, `site`) VALUES (0, 1237179600);",$c);
this will stop the problem... i dont know why this needs to be in voting sql but works ...

You will be able to vote only once per site

[Cronus]

Well, there is no day cron with this mod so if you have a day cron already set to do that you would have to remove it.

[SaMz]

so how will voting reset... i see no timestamps...

[Crazy-T]

function view_vote_logs()
{
global $ir,$c,$h,$userid;
print "<h3>Voting Logs</h3>
<table width=75% border=1> <tr> <th>ID</th> <th>Time</th><th>Player</th></tr>";
$q=mysql_query("SELECT * FROM votes ORDER BY  userid ASC",$c);
while($r=mysql_fetch_array($q))
{
print"<tr><td>{$r['site']}</td> <td>".date('F j, Y, g:i:s a',$r['voteTIME'])."</td><td><a href='viewuser.php?u={$r['userid']}'>{$r['userid']}</a></td>
</tr>";
}
}

I know i dont need to say this but you forgot echo '</table>';   

[Cronus]

so how will voting reset... i see no timestamps...

Well they are there, I don't know what else to tell you.

[strats]

Thanks for the great Mod and thank you for not charging

And thanks Sam for your little extra help 

[SaMz]

so how will voting reset... i see no timestamps...

Well they are there, I don't know what else to tell you.

Many people thaught this ran on crons thats why they had problems with it but overall this is a great modification

[Cronus]

The first line of this mod says, and I quote, "Easy voting system, and runs on timestamps."

[Karlos]

I slightly editted it but in all look for the timestamp.

$Site = $db->fetch_row($db->query("SELECT `userid`, `site` FROM `votes` WHERE `userid`='0'"));
  
if ($Site['site'] < time()) {
 $db->query("DELETE FROM `votes` WHERE `userid` >= '1'");
 $db->query(sprintf("UPDATE `votes` SET `site`='%s' WHERE `userid`='0'", mktime('0', '0', '0') + '86400'));
}