php forum
php mysql forum
php mysql smarty
 
Page 2 of 2 < 1 2
Topic Options
#247528 - 11/24/03 12:04 PM Re: ** Raffle Mod ** [Re: c0bra]
PhotoPost Offline
Hacker

Registered: 02/03/02
Posts: 989
Well, here is mine - I've been using it for almost a year now. It looks for people who made at least 1 post during the month, have at least 75 posts (we give away big stuff - this month a 42" Plasma television, so want people who are posting and not lurking) and do not allow Banned users (or those with registered alter-egos).<br /><br />
Code:
&lt;?<br />    require ("./main.inc.php");<br /><br />    $query = "SELECT b.B_PosterId,u.U_Totalposts,u.U_Number,u.U_Username FROM w3t_Posts b<br />        LEFT JOIN w3t_Users u ON u.U_Number=b.B_PosterId<br />        WHERE MONTH(FROM_UNIXTIME(b.B_Posted))=8 AND u.U_Status != 'Banned' AND u.U_Extra2 = ''<br />        AND MONTH(FROM_UNIXTIME(u.U_Registered)) &lt; 8 AND MONTH(FROM_UNIXTIME(u.U_LastOn)) &gt; 7";<br />    $sth = $dbh -&gt; do_query($query);<br /><br />    $totalusers = $dbh -&gt; total_rows($sth);<br />    <br />    print "&lt;body&gt;&lt;font size=\"1\" face=\"MS Sans Serif, Geneva\"&gt;";<br />    print "There were " . number_format($totalusers) . " total posts made during July&lt;br&gt;";<br />    $entries=array();<br />    <br />    for( $x=0; $x &lt; $totalusers; $x++ ) {<br />        list ($PosterId,$totalposts,$number,$username) = $dbh -&gt; fetch_array($sth);<br />        // Excluded members are me and Administrator<br />        if ( $PosterId != 2 &amp;&amp; $PosterId != 3 &amp;&amp; $totalposts &gt; 75 ) $entries[$PosterId] = $username;<br />    }<br />    <br />    print "The number of members eligable for this drawing is: " . count($entries) . "&lt;br&gt;&lt;br&gt;";<br /><br />    $winners = array();    <br />    for ( $x = 1; $x &lt; 11; $x++ ) {<br />        $winner = array_rand($entries);<br />        if ( in_array($winner, $winners) ) {<br />            $x--;<br />        }<br />        else {<br />            print "Pick #$x: &lt;font size=\"5\"&gt;&lt;b&gt;" . $entries[$winner] . "&lt;/b&gt;&lt;/font&gt;&lt;br /&gt;";<br />            $winners[] = $winner;<br />        }<br />    }<br />    <br />    print "&lt;/font&gt;&lt;/body&gt;";<br />?&gt;
<br /><br />This generates 10 semi-finalists which are then fed into a second script which picks 3 random names and finally a winner. This is done over three days to make it more interesting.
_________________________
[]http://www.danasoft.com/vipersig.jpg[/]
Viper Alley - http://www.viperalley.com
Extreme Fitness - http://www.extremefitness.com[/b]

Top
#247529 - 11/24/03 12:40 PM Re: ** Raffle Mod ** [Re: gailg]
ericgtr Offline
Junior Member

Registered: 05/12/03
Posts: 1109
[]This generates 10 semi-finalists which are then fed into a second script which picks 3 random names and finally a winner. This is done over three days to make it more interesting. [/]<br /><br />Neat PP, do you mind posting the other scripts (are there 2 more?) and telling us where you apply the code?

Top
#247530 - 11/24/03 02:58 PM Re: ** Raffle Mod ** [Re: BlarC]
msula Offline
Addict

Registered: 02/18/02
Posts: 1969
Loc: Lansing, Michigan
holy crap, 6 months later and this post comes out of nowhere <img src="http://www.ubbdev.com/forum/images/graemlins/laugh.gif" alt="" />

Top
#247531 - 11/24/03 03:20 PM Re: ** Raffle Mod ** [Re: palmen]
omegatron Offline
Member

Registered: 04/05/01
Posts: 3440
Loc: abingdon,md
I just rewrote it to include a selection interface. Will post shortly <img src="http://www.ubbdev.com/forum/images/graemlins/wink.gif" alt="" />
_________________________
Chuck S

DIVE IN AND VISIT ME:

Omegatron\'s Reefs

Administrator at ReefTalk

Top
#247532 - 11/24/03 03:34 PM Re: ** Raffle Mod ** [Re: sf49rminer]
ericgtr Offline
Junior Member

Registered: 05/12/03
Posts: 1109
Cool!

Top
#247533 - 11/24/03 04:16 PM Re: ** Raffle Mod ** [Re: BlarC]
omegatron Offline
Member

Registered: 04/05/01
Posts: 3440
Loc: abingdon,md
_________________________
Chuck S

DIVE IN AND VISIT ME:

Omegatron\'s Reefs

Administrator at ReefTalk

Top
#247534 - 11/24/03 04:36 PM Re: ** Raffle Mod ** [Re: sf49rminer]
PhotoPost Offline
Hacker

Registered: 02/03/02
Posts: 989
contest2.php looks like: <br /> <br />
Code:
&lt;? <br />    require ("./main.inc.php"); <br /> <br />    print "&lt;body&gt;&lt;font size=\"1\" face=\"MS Sans Serif, Geneva\"&gt;"; <br />$entries = array("User1","User2","User3","User4","User5","User6","User7","User8","User9","User10"); <br /> <br />    print "The number of members eligable for this drawing is: " . count($entries) . "&lt;br&gt;&lt;br&gt;"; <br /> <br />    $winners = array(); <br />    for ( $x = 1; $x &lt; 6; $x++ ) { <br />        $winner = array_rand($entries); <br />        if ( in_array($winner, $winners) ) { <br />            $x--; <br />        } <br />        else { <br />            print "Pick #$x: &lt;font size=\"5\"&gt;&lt;b&gt;" . $entries[$winner] . "&lt;/b&gt;&lt;/font&gt;&lt;br /&gt;"; <br />            $winners[] = $winner; <br />        } <br />    } <br /> <br />    print "&lt;/font&gt;&lt;/body&gt;"; <br />?&gt; <br />
<br /> <br />and the one that picks the winner is contest3.php: <br /> <br />
Code:
&lt;? <br />    $entries = array("User1","User2","User3","User4","User5"); <br /> <br />    print "The number of members eligable for this drawing is: " . count($entries) . "&lt;br&gt;&lt;br&gt;"; <br />    print "The winner is: &lt;font size=\"5\"&gt;&lt;b&gt;" .  $entries[mt_rand(0,4)] . "&lt;/b&gt;&lt;/font&gt;&lt;br /&gt;"; <br />?&gt; <br />
<br /> <br />These two are a little manual in that you update the arrays; but it does provide a level of randomness which is good. Like I said, I've been running this for a year now and giving away some great prizes (next month is a 42" Plasma television!). <br /> <br />Chuck will tell you - I write a ton of this stuff but hate documenting it. lol
_________________________
[]http://www.danasoft.com/vipersig.jpg[/]
Viper Alley - http://www.viperalley.com
Extreme Fitness - http://www.extremefitness.com[/b]

Top
Page 2 of 2 < 1 2



Latest Posts
[7.2.1] - Naked shoutbox
by bellaonline
05/05/12 05:00 PM
[7.x] Stop Forum Spam Integration v0.4
by bellaonline
05/05/12 03:53 PM
Shout Box

(Views)Popular Topics
Known public proxy servers 1689885
Integrated Index Page (IIP) 5.3.1 555705
Finished-[6.5.2] Games Arcade Deluxe v1.9 501236
Integrated Index Page (IIP) 5.1.1 415112
TLD Bv2.1 Released - Threads Links Directory 396822
[6.0x] Who's Online 4.0.0 [Finished] 389412
Finished-[6.5.1] Integrated Index Page (IIP) 6.5 330423
Q & A 298663
Slash UBB 266936
[6.3.x] [beta] Hit Hack 2.0 227970
Forum Stats
13621 Members
59 Forums
37191 Topics
295716 Posts

Max Online: 686 @ 06/28/07 07:04 AM

 

 

 
fusionbb message board php hacks