Login

Oz · 12-08-2004, 07:47 PM

[syntax="php"]<?

/* Connect to the dataabase...what else? */

mysql_connect(localhost, '****', '****');
mysql_select_db('****');

/* Get the row data */

$query="SELECT * FROM `qbntc_rq` ORDER BY `id` ASC";
$result=mysql_query($query);
$num=mysql_num_rows($result);

/* begin sorting the jbberish */

$offset=0;

$query="SELECT * FROM qbntc_vote";
$r=mysql_query($query);
$n=mysql_num_rows($r);

/* Almost a bubble sort, but im i=not comparing data..this stuff was only in my mind for a few seconds before it 'disappeared', so im not sure how well I can explain it */

for ($s=0;$s<$n;$s++)
{

// Make sure we only record one 'quote' per loop
$vid=mysql_result($r,$s,'vote_id');
$v=mysql_result($r,$s,'vote');

if ($v==1)
{
$sort[$vid] [($s-$offset)]++;
$yes[$vid]++;
$a++;
} else {
$sort[$vid] [($s-$offset)]--;
$no[$vid]++;
$a++;
}

}

mysql_close();

print("<TABLE width='100%' cellpadding=0 cellspacing=1 border=0> \n");
print("<TR><TD width='15%' bgcolor='black'>Rank</TD><TD bgcolor='Black'>Quote:</TD></TR> \n");

if ($num >= 1) {
for ($i=0;$i<$num;$i++)
{
if ($i%2==0) {
$colour="#4372FB";
} else {
$colour="#0080C0";
}

$sub=mysql_result($result,$i,'user');
$quotee=mysql_result($result,$i,'quoteduser');
$quote=mysql_result($result,$i,'quote');
$ds=mysql_result($result,$i,'date');
$rank=$sort[$i] [1]; // I'm not sure what to replace '1' with...

print("<TR bgcolor='$colour'><TD valign='middle' align='center'>" . $rank . "</TD><TD>" . $quote ."</TD></TR> \n");
print("<TR bgcolor='$colour'><TD colspan=2>Submitted By $sub | Submitted on $ds | Poll Results: Yes [$yes[$i]] No [$no[$i]]</TD></TR> \n");
}
} else {
print("<TR><TD colspan=2 align='center'>Unable to determine rank :: No quotes submitted</TD></TR> \n");
}

print("</TABLE> \n");

?>[/syntax]

There is lots wrong with it.....I'll try to comment it to say where things are going wrong, and whats happening.

Oz~

Oz · 12-08-2004, 08:42 PM

After searching for a while, I fixed it all up

nvm

Oz~

Oz · 12-09-2004, 06:56 AM

Now I have a seperate thing that has kinda bugged up after I switched the order around...

[syntax="php"]<HTML>
<HEAD>
<title>Updating...</title>
<meta http-equiv="refresh" content="3;url=http://www.atosoftqb.digitalblackie.com/qbn_tc/">
</HEAD>
</HTML>

<?

$voteid=$_GET['vid'];
$answer=$_GET['select'];

$ip=getenv("REMOTE_ADDR");

if (($answer<-1) || ($answer>1) || ($answer==0))
{
echo "Trying to tamper with the system, eh?\n";
exit;
}

if ($answer==1)
{
$send="yes";
} else {
$send="no";
}

mysql_connect(localhost, '****', '****');
mysql_select_db('****');

$query="SELECT * FROM qbntc_voted";
$result=mysql_query($query);
$num=mysql_num_rows($result);

for ($i=0;$i<$num;$i++)
{
$tip=mysql_result($result,$i,'ip');
$voted=mysql_result($result,$i,'vote_id');
if ( strcmp ( $ip, $tip ) == 0 )
{
if ($voted==$voteid)
{
echo "You have already voted on this quote!";
exit;
}
}
}
//If you are able to proceed past this, then you have not cast a vote on the poll
//First record your ip to manage the polling

$query="INSERT INTO `qbntc_voted` (`id`, `ip`, `vote_id`, `vote`) VALUES ('', '$ip', '$voteid', '$answer');";
$result=mysql_query($query);

if ($result==FALSE)
{
print "An error occured while recording IP address\r\n " . mysql_error();
}

$query="SELECT * FROM qbntc_rq";
$result=mysql_query($query);
$num=mysql_num_rows($result);

mysql_close();

if ($result==FALSE)
{
echo mysql_error();
}

print "\nVoting $send from $ip on Quote ID $voteid\n";

?>[/syntax]

Oz~

Login
Username:
Password:	Lost Password?
	Remember me