contact_id = $_contact_id; $this->num_votes = $_num_votes; } } global $show_numbers; $show_numbers = false; list( $show_numbers_var ) = pnVarCleanFromInput('show_numbers_3094893430' ); if ( !empty( $show_numbers_var ) ) { $show_numbers = true; } /* global $pnuser_googleAd; $pnuser_googleAd = <<
EOT; */ // This function converts any series of english words to Proper Casing. // It also accounts for words such as 'a' and 'the'. To change what // words are ignored, just change the $noUp array. function strProperCase( $str ) { $size = 0; $noUp = array('a','an','of','the','are','at','in'); $str = trim($str); $str = strtoupper($str[0]) . strtolower(substr($str, 1)); for ( $i=1; $iText(_BESTOFNOAUTH); return $output->GetOutput(); } // Add menu to output - it helps if all of the module pages have a standard // menu at their head to aid in navigation $output->SetInputMode(_PNH_VERBATIMINPUT); $output->Text(bestof_usermenu()); $output->SetInputMode(_PNH_PARSEINPUT); // Return the output that has been generated by this function return $output->GetOutput(); } /** * display item * This is a standard function to provide detailed informtion on a single item * available from the module. */ function bestof_user_display($args) { // Get parameters from whatever input we need. All arguments to this // function should be obtained from pnVarCleanFromInput(), getting them // from other places such as the environment is not allowed, as that makes // assumptions that will not hold in future versions of PostNuke. list($tid, $objectid) = pnVarCleanFromInput('tid', 'objectid'); // User functions of this type can be called by other modules. If this // happens then the calling module will be able to pass in arguments to // this function through the $args parameter. Hence we extract these // arguments *after* we have obtained any form-based input through // pnVarCleanFromInput(). extract($args); // At this stage we check to see if we have been passed $objectid, the // generic item identifier. This could have been passed in by a hook or // through some other function calling this as part of a larger module, but // if it exists it overrides $tid // // Note that this module couuld just use $objectid everywhere to avoid all // of this munging of variables, but then the resultant code is less // descriptive, especially where multiple objects are being used. The // decision of which of these ways to go is up to the module developer if (!empty($objectid)) { $tid = $objectid; } // Create output object - this object will store all of our output so that // we can return it easily when required $output = new pnHTML(); // Add menu to output - it helps if all of the module pages have a standard // menu at their head to aid in navigation $output->SetInputMode(_PNH_VERBATIMINPUT); $output->Text(bestof_usermenu()); $output->SetInputMode(_PNH_PARSEINPUT); // Load API. All of the actual work for obtaining information on the items // is done within the API, so we need to load that in before we can do // anything. If the API fails to load an appropriate error message is // posted and the function returns if (!pnModAPILoad('BestOf', 'user')) { $output->Text(_LOADFAILED); return $output->GetOutput(); } // The API function is called. The arguments to the function are passed in // as their own arguments array $item = pnModAPIFunc('BestOf', 'user', 'get', array('tid' => $tid)); // The return value of the function is checked here, and if the function // suceeded then an appropriate message is posted. Note that if the // function did not succeed then the API function should have already // posted a failure message so no action is required if ($item == false) { $output->Text(_BESTOFITEMFAILED); return $output->GetOutput(); } // Display details of the item. Note the use of pnVarCensor() to remove // any words from the name that the administrator has deemed unsuitable for // the site. Also note that a module variable is used here to determine // whether not not parts of the item information should be displayed in // bold type or not $output->Text(_BESTOFNAME . ': '); if (pnModGetVar('BestOf', 'bold')) { $output->BoldText(pnVarCensor($item['name'])); } else { $output->Text(pnVarCensor($item['name'])); } $output->Linebreak(2); $output->Text(_BESTOFNUMBER . ': '); $output->Text($item['number']); $output->Linebreak(2); // Let any hooks know that we are displaying an item. As this is a display // hook we're passing a URL as the extra info, which is the URL that any // hooks will show after they have finished their own work. It is normal // for that URL to bring the user back to this function $output->SetInputMode(_PNH_VERBATIMINPUT); $output->Text(pnModCallHooks('item', 'display', $tid, pnModURL('BestOf', 'user', 'display', array('tid' => $tid)))); $output->SetInputMode(_PNH_PARSEINPUT); // Return the output that has been generated by this function return $output->GetOutput(); } /** * generate menu fragment */ function bestof_usermenu() { // Create output object - this object will store all of our output so that // we can return it easily when required $output = new pnHTML(); // Display status message if any. Note that in future this functionality // will probably be in the theme rather than in this menu, but this is the // best place to keep it for now // Start options menu $output->Text(pnGetStatusMsg()); $output->Linebreak(2); // Menu options. These options are all added in a single row, to add // multiple rows of options the code below would just be repeated $output->TableStart(_BESTOF); $output->SetOutputMode(_PNH_RETURNOUTPUT); $columns = array(); $columns[] = $output->URL(pnModURL('BestOf', 'user', 'view'), _BESTOFVIEW); $output->SetOutputMode(_PNH_KEEPOUTPUT); $output->SetInputMode(_PNH_VERBATIMINPUT); $output->TableAddRow($columns); $output->SetInputMode(_PNH_PARSEINPUT); $output->TableEnd(); // Return the output that has been generated by this function return $output->GetOutput(); } /////////////////////////////////////////// // NOVEMBER 2006 CONTESTS ////////////// /////////////////////////////////////////// //////////////////////////// // Best Of Poll function bestof_user_bestofpoll() { $contestid = 137; $email_subject = "Best Places for Families 2008 Submission"; $thankyou_title = "Best Places for Families 2008"; global $page_title; $page_title = "Best Places for Families 2008"; list( $_submit_check, $entryname, $entryage, // $entrygrade, // $entryschool, $entryaddress, $entrycity, $entrystate, $entryzip, $entryphone, $entryemail ) = pnVarCleanFromInput( '_submit_check', 'entryname', 'entryage', // 'entrygrade', // 'entryschool', 'entryaddress', 'entrycity', 'entrystate', 'entryzip', 'entryphone', 'entryemail'); // Create output object - this object will store all of our output so that // we can return it easily when required $output = new pnHTML(); $output->SetInputMode(_PNH_VERBATIMINPUT); // todo: put this back to stop the poll from showing // $output->Text( outputHeader() ); // $output->Text( outputPreview() ); // // $output->Text( outputIntro() ); // return $output->GetOutput(); // global $show_numbers; // if ( !$show_numbers ) // { // $output->Text( outputHeader() ); // $output->Text( outputIntro() ); // $output->Text( '

' ); // $output->Text( 'Down for maintenance.

' ); // $output->Text( 'Please come back and vote for your favorites soon!

' ); // $output->Text( 'Back to the home page' ); // return $output->GetOutput(); // } list($dbconn) = pnDBGetConn(); if ( $_submit_check == '1' ) { // Check earlier date $can_vote = true; global $show_numbers; if ( !$show_numbers ) { $voted_date = @$_COOKIE['voted']; if ( !empty( $voted_date ) ) { $date=strtotime( @$_COOKIE['voted'] ); $today=strtotime( date("m/d/Y") ); $can_vote = ( $date < $today ); } else { $can_vote = true; } } if ( $can_vote ) { // Update Cookie setcookie( "voted", date("m/d/Y"), time()+24*60*60 ); $submitdate = date("F j, Y, g:i a"); $submitip = getenv("REMOTE_ADDR"); $banned_ips = array( "63.97.14.3", "198.243.2.2", "199.239.30.126", "67.41.223.221", "216.148.96.254", "71.208.97.55", "71.237.69.210", "66.195.91.61", ); /* $banned_ips = array( "12.8.246.222", "137.227.96.21", "151.118.1.81", "207.224.58.133", "66.62.170.146", "67.190.59.251", "71.122.66.158", "71.196.183.179", "71.218.148.69", "71.218.49.187", "72.16.140.126", "208.68.244.251", "24.8.171.225", "76.25.6.145", "151.118.8.83", ); */ // "66.1.228.136", $isbannedip = in_array( $submitip, $banned_ips ); $votestr = handleInput( $output, $dbconn, $isbannedip ); $subject = $email_subject . ( $isbannedip ? " [banned: $submitip]" : "" ); $message = ""; $message .= $submitdate . "\n"; $message .= $submitip . "\n"; $message .= $votestr . "\n"; $message .= "\n\n"; $message .= "entryname: " . $entryname . "\n\n"; $message .= "entryage: " . $entryage . "\n\n"; // $message .= "entrygrade: " . $entrygrade . "\n\n"; // $message .= "entryschool: " . $entryschool . "\n\n"; $message .= "entryaddress: " . $entryaddress . "\n\n"; $message .= "entrycity: " . $entrycity . "\n\n"; $message .= "entrystate: " . $entrystate . "\n\n"; $message .= "entryzip: " . $entryzip . "\n\n"; $message .= "entryphone: " . $entryphone . "\n\n"; $message .= "entryemail: " . $entryemail . "\n\n"; $message .= "votestr: " . $votestr . "\n\n"; $message .= "--- copy/paste ---\n"; $message .= $entryname . "\n"; $message .= $entryage . "\n"; // $message .= $entrygrade . "\n"; // $message .= $entryschool . "\n"; $message .= $entryaddress . "\n"; $message .= $entrycity . "\n"; $message .= $entrystate . "\n"; $message .= $entryzip . "\n"; $message .= $entryphone . "\n"; $message .= $entryemail . "\n"; $message .= $votestr . "\n"; // To send HTML mail, you can set the Content-type header. $headers = "MIME-Version: 1.0\r\n"; $headers .= "Content-type: text/plain; charset=iso-8859-1\r\n"; $headers .= "From: Contest Submit \r\n"; // and now mail it @mail('contest@kidspages.org', $subject, $message, $headers); // begin database $entryquestion = ( $isbannedip ? "[banned: $submitip]: " : "" ) . $votestr; // insert into database $strsql = "INSERT INTO `kp_contest` ("; $strsql .= "contestid" . ", "; $strsql .= "submitdate" . ", "; $strsql .= "ipaddress" . ", "; $strsql .= "name" . ", "; $strsql .= "address" . ", "; $strsql .= "city" . ", "; $strsql .= "state" . ", "; $strsql .= "zip" . ", "; $strsql .= "phone" . ", "; $strsql .= "email" . ", "; $strsql .= "age" . ", "; // $strsql .= "grade" . ", "; // $strsql .= "school" . ", "; $strsql .= "question"; $strsql .= ") VALUES ("; $strsql .= "$contestid, "; $strsql .= "'" . addslashes( $submitdate ) . "', "; $strsql .= "'" . addslashes( $submitip ) . "', "; $strsql .= "'" . addslashes( $entryname ) . "', "; $strsql .= "'" . addslashes( $entryaddress ) . "', "; $strsql .= "'" . addslashes( $entrycity ) . "', "; $strsql .= "'" . addslashes( $entrystate ) . "', "; $strsql .= "'" . addslashes( $entryzip ) . "', "; $strsql .= "'" . addslashes( $entryphone ) . "', "; $strsql .= "'" . addslashes( $entryemail ) . "', "; $strsql .= "'" . addslashes( $entryage ) . "', "; // $strsql .= "'" . addslashes( $entrygrade ) . "', "; // $strsql .= "'" . addslashes( $entryschool ) . "', "; $strsql .= "'" . addslashes( $entryquestion ) . "'"; $strsql .= ")"; $dbconn->Execute( $strsql ); // end database if ( $isbannedip ) { $output->Text( '' . $thankyou_title . '

' ); $output->Text( 'We\'re sorry. Voting from your IP Address has been blocked.

' ); $output->Text( 'Back to the home page' ); } else { $output->Text( '' . $thankyou_title . '

' ); $output->Text( 'Thank you for your submission!

' ); $output->Text( 'Back to the home page' ); } } else { $output->Text( '' . $thankyou_title . '

' ); $output->Text( 'We\'re sorry. You can only vote once a day. Come back tomorrow!

' ); $output->Text( 'Back to the home page' ); } return $output->GetOutput(); } $entryname = htmlentities( $entryname ); $entryage = htmlentities( $entryage ); // $entrygrade = htmlentities( $entrygrade ); // $entryschool = htmlentities( $entryschool ); $entryaddress = htmlentities( $entryaddress ); $entrycity = htmlentities( $entrycity ); $entrystate = htmlentities( $entrystate ); $entryzip = htmlentities( $entryzip ); $entryphone = htmlentities( $entryphone ); $entryemail = htmlentities( $entryemail ); generatePoll( $output, $dbconn ); // Contest Form $output->Text( << div.class-container { border: 2px dashed #fff; background-color: #fff; padding-left:15px; padding-right:15px; padding-top:15px; padding-bottom:0px; font-family: geneva, verdana, trebuchet MS, trebuchet, verdana, arial, sans-serif; font-size: 15px; font-weight:bold; } div.class-container table { font-size: 15px }
Fill out this entry form and enter to win
a family four-pack of unrestricted admission tickets
to a local movie theatre and a restaurant gift certificate.
Enter to win now!
 For entry to be valid, fill out form completely.
Name:
Age:
Address:
City:
State:
Zip:
Phone:
E-Mail:
EOT ); /* Grade: School: */ // Input Button $output->Text( <<

EOD ); $output->Text( '' ); $output->Text( outputSmallPrint() ); $output->Text( outputFooter() ); global $pnuser_googleAd; $output->Text( $pnuser_googleAd ); return $output->GetOutput(); } // new stuff $eol = "\n"; function outputHeader() { $str = << .bestof-poll { width: 600px; font: small/18px "Lucida Grande", "Trebuchet MS", "Bitstream Vera Sans", Verdana, Helvetica, sans-serif; text-align: left; color: #000; background-color: #fff; } .bestof-poll-old { width:510px; font: small/18px "Lucida Grande", "Trebuchet MS", "Bitstream Vera Sans", Verdana, Helvetica, sans-serif; font-family: Verdana; font-size: 1em; line-height: 1.2em; letter-spacing: 0; text-align: left; word-spacing: normal; text-decoration: none; color: #444; background-color: #fff; } .bestof-poll-submit { background-color: #ccccff; width: 220px; padding:10px; float: left; } .bestof-poll-results { background-color: #ffffff; width: 270px; padding:10px; float: left; margin-left: 20px; } table.bestof-poll-form { margin-left: 0px; width: 100%; } table.bestof-poll-form td { vertical-align: top; padding: 2px 3px; font-size: 90%; } .bestof-section-head { padding:10px; margin: 10px 0px 10px 0px; width: 510px; font: 18px "Lucida Grande", "Trebuchet MS", "Bitstream Vera Sans", Verdana, Helvetica, sans-serif; text-align: left; color: #000; background-color: #ffff99; } .image-right { float:right; padding:10px; } .image-left { float:left; padding-right:10px; padding-top:10px; padding-bottom:10px; } div.othertext { width: 200px; border: 1px solid #ccc; background: #f2f2f2; padding: 5px; margin-top: 5px; } EOD; return $str; } function outputPreview() { $str = <<
Who knows the BEST PLACES FOR FAMILIES?
You do!

We value our readers' opinions!

Vote for your favorites below and win a night out on the town for your family!

Tell us where you get the yummiest ice cream, the cutest hair-do and your family's favorite restaurant!

Voting will take place online from March 1 to May 1.

Winners will be chosen by YOU, our readers, real families voting for the places they love.

Don't see your family's favorite listed here? Enter your favorite into the "Other" entry box. When a business receives enough write-ins, they will be added to the main list.

Winners will be determined by the highest number of votes. Voting will end at midnight on May 1. Winners will be announced in the Summer Issue of Kids' Pages Family Magazine and on KidsPages.org.

Good Luck to all of these great family-friendly businesses! Be sure to vote often for your favorites!

Voting begins at midnight on March 1!
EOD; return $str; } function outputIntro() { $str = <<
Who knows the BEST PLACES FOR FAMILIES?
You do!

We value our readers' opinions!

Vote for your favorites below and win a night out on the town for your family!

Tell us where you get the yummiest ice cream, the cutest hair-do and your family's favorite restaurant!

Voting will take place online from March 1 to May 1.

Winners will be chosen by YOU, our readers, real families voting for the places they love.

Don't see your family's favorite listed here? Enter your favorite into the "Other" entry box. When a business receives enough write-ins, they will be added to the main list.

Winners will be determined by the highest number of votes. Prizes will be awarded to the three nominees that receive the most votes in each category.

Voting will end at midnight on May 1. Winners will be announced in the Summer Issue of Kids' Pages Family Magazine and on KidsPages.org.

Good Luck to all of these great family-friendly businesses! Be sure to vote often for your favorites!

10 Lucky Families will win a night out on the town!
Movie Tickets and Dinner Gift Certificates
will be mailed to 10 randomly chosen entries!
EOD; return $str; } function outputSmallPrint() { $str = << The small print:
Rest easy. We will never share our mailing list with anyone.

Winners will receive a family four-pack of unrestricted admission tickets to a local movie theatre and a restaurant gift certificate. No purchase necessary to enter. Legal residents of the 50 United States may enter. Entrants under age 18 must have a parent or legal guardian’s permission to enter. Limit one online entry per person or email address per day per internet location. Contest Sponsors and their dependants are not eligible to win. Winner will be drawn at random and mailed their prize. For complete Official Rules for Online Contests please click on contest rules.

To request a paper ballot, please send a self-addressed stamped envelope to Kids' Pages Best Of Poll, PO Box 745219, Arvada, CO 80006. Requests must be made no later than March 25, 2008. Paper ballots will also be available at Kids' Pages Family Festivals.


EOD; return $str; } function outputFooter() { $str = <<' . $eol; } else { $strImgage = ''; $strAnchor = '' . $strImgage . ''; $retStr = '
' . $strAnchor . '
' . $eol; } } return $retStr; } function OutputSponsorImage( $sponsor ) { global $eol; $retStr = ""; if ( $sponsor == 'Y' ) { $retStr = '
' . $eol; } return $retStr; } function OutputHeaderTitle( $title, $value ) { global $eol; $retStr = ""; if ( !empty( $value ) ) { $retStr = '' . $title . ': ' . $value . '
' . $eol; } return $retStr; } function OutputWebsite( $title, $value ) { global $eol; $retStr = ""; if ( !empty( $value ) ) { $retStr = '' . $title . ': ' . $value . '
' . $eol; } return $retStr; } function OutputEmail( $title, $value ) { global $eol; $retStr = ""; if ( !empty( $value ) ) { // $retStr = '' . $title . ': ' . $value . '
' . $eol; $retStr = '' . $title . ': ' . $value . '
' . $eol; } return $retStr; } function getCategoryListing( $key, &$dbconn, &$vote_totals ) { global $eol; $retStr = ""; // Pages $strsql = "select contact_id, cat_id, votes, company_name from kp_bestof_entry where (cat_id IN ($key) OR cat_id LIKE '%,$key,%') and link_type_id = 0 order by company_name"; // $strsql = "select contact_id, cat_id, votes, company_name, image, sponsor, contact_name, location_name, // address1, address2, city, state, zip, phone, hours, ages, cost, // website_address, email_address, directions, description, // loc2_location_name, loc2_address, loc2_city, loc2_phone, loc2_email_address, // loc3_location_name, loc3_address, loc3_city, loc3_phone, loc3_email_address, // loc4_location_name, loc4_address, loc4_city, loc4_phone, loc4_email_address // from kp_bestof_entry // where (cat_id IN ($key) OR cat_id LIKE '%,$key,%') and link_type_id = 0 // order by company_name"; $result = $dbconn->Execute( $strsql ); $entry_count = 0; while ( !$result->EOF ) { $entry_count++; // load key for record $row = $result->GetRowAssoc(0); $x_contact_id = $row["contact_id"]; $x_cat_id = $row["cat_id"]; $x_votes = $row["votes"]; $x_company_name = $row["company_name"]; // $x_image = $row["image"]; // $x_sponsor = $row["sponsor"]; // $x_contact_name = $row["contact_name"]; // $x_location_name = $row["location_name"]; // $x_address1 = $row["address1"]; // $x_address2 = $row["address2"]; // $x_city = $row["city"]; // $x_state = $row["state"]; // $x_zip = $row["zip"]; // $x_phone = $row["phone"]; // $x_hours = $row["hours"]; // $x_ages = $row["ages"]; // $x_cost = $row["cost"]; // $x_website_address = $row["website_address"]; // $x_email_address = $row["email_address"]; // $x_directions = $row["directions"]; // $x_description = $row["description"]; // $x_loc2_location_name = $row["loc2_location_name"]; // $x_loc2_address = $row["loc2_address"]; // $x_loc2_city = $row["loc2_city"]; // $x_loc2_phone = $row["loc2_phone"]; // $x_loc2_email_address = $row["loc2_email_address"]; // $x_loc3_location_name = $row["loc3_location_name"]; // $x_loc3_address = $row["loc3_address"]; // $x_loc3_city = $row["loc3_city"]; // $x_loc3_phone = $row["loc3_phone"]; // $x_loc3_email_address = $row["loc3_email_address"]; // $x_loc4_location_name = $row["loc4_location_name"]; // $x_loc4_address = $row["loc4_address"]; // $x_loc4_city = $row["loc4_city"]; // $x_loc4_phone = $row["loc4_phone"]; // $x_loc4_email_address = $row["loc4_email_address"]; $result->MoveNext(); $vote_totals[$x_company_name] = new Vote( $x_contact_id, $x_votes ); $retStr .= << EOD; // $retStr .= "

x_contact_id: " . $x_contact_id . "

"; // $retStr .= $eol; // $retStr .= '
' . $eol; // $retStr .= OutputImage( $x_image, $x_website_address ); // $retStr .= OutputSponsorImage( $x_sponsor ); // $retStr .= "$x_company_name
" . $eol; // $retStr .= OutputHeaderTitle( "Address", $x_address1 . ( empty( $x_address2 ) ? "" : "
$x_address2" ) ); // $retStr .= OutputHeaderTitle( "City", $x_city ); // $retStr .= OutputHeaderTitle( "Phone", $x_phone ); // $retStr .= OutputHeaderTitle( "Hours", $x_hours ); // $retStr .= OutputHeaderTitle( "Ages", $x_ages ); // $retStr .= OutputHeaderTitle( "Cost", $x_cost ); // $retStr .= OutputWebsite( "Website", $x_website_address ); // $retStr .= OutputEmail( "E-Mail", $x_email_address ); // $retStr .= OutputHeaderTitle( "Directions", $x_directions ); // if ( !empty ( $x_loc2_location_name ) || // !empty ( $x_loc2_address ) || // !empty ( $x_loc2_city ) || // !empty ( $x_loc2_phone ) || // !empty ( $x_loc2_email_address ) || // !empty ( $x_loc3_location_name ) || // !empty ( $x_loc3_address ) || // !empty ( $x_loc3_city ) || // !empty ( $x_loc3_phone ) || // !empty ( $x_loc3_email_address ) || // !empty ( $x_loc4_location_name ) || // !empty ( $x_loc4_address ) || // !empty ( $x_loc4_city ) || // !empty ( $x_loc4_phone ) || // !empty ( $x_loc4_email_address ) ) // { // $retStr .= '
Other Locations
'; // // if ( !empty ( $x_loc2_location_name ) || // !empty ( $x_loc2_address ) || // !empty ( $x_loc2_city ) || // !empty ( $x_loc2_phone ) || // !empty ( $x_loc2_email_address ) ) // { // $retStr .= OutputHeaderTitle( "Location", $x_loc2_location_name ); // $retStr .= OutputHeaderTitle( "Address", $x_loc2_address ); // $retStr .= OutputHeaderTitle( "City", $x_loc2_city ); // $retStr .= OutputHeaderTitle( "Phone", $x_loc2_phone ); // $retStr .= OutputEmail( "E-Mail", $x_loc2_email_address ); // } // // if ( !empty ( $x_loc3_location_name ) || // !empty ( $x_loc3_address ) || // !empty ( $x_loc3_city ) || // !empty ( $x_loc3_phone ) || // !empty ( $x_loc3_email_address ) ) // { // $retStr .= '
'; // $retStr .= OutputHeaderTitle( "Location", $x_loc3_location_name ); // $retStr .= OutputHeaderTitle( "Address", $x_loc3_address ); // $retStr .= OutputHeaderTitle( "City", $x_loc3_city ); // $retStr .= OutputHeaderTitle( "Phone", $x_loc3_phone ); // $retStr .= OutputEmail( "E-Mail", $x_loc3_email_address ); // } // // if ( !empty ( $x_loc4_location_name ) || // !empty ( $x_loc4_address ) || // !empty ( $x_loc4_city ) || // !empty ( $x_loc4_phone ) || // !empty ( $x_loc4_email_address ) ) // { // $retStr .= '
'; // $retStr .= OutputHeaderTitle( "Location", $x_loc4_location_name ); // $retStr .= OutputHeaderTitle( "Address", $x_loc4_address ); // $retStr .= OutputHeaderTitle( "City", $x_loc4_city ); // $retStr .= OutputHeaderTitle( "Phone", $x_loc4_phone ); // $retStr .= OutputEmail( "E-Mail", $x_loc4_email_address ); // } // } // $retStr .= '
' . $eol; // $retStr .= "

$x_description

"; // $retStr .= '
'; $retStr .= $eol; } $result->Close(); // todo: debug 'other' $retStr .= << EOD; // @mysql_free_result($rs); return $retStr; } function generatePoll( &$output, &$dbconn ) { global $eol; $grand_total_votes = 0; global $show_numbers; /* $show_numbers = false; $show_numbers_var = @$_GET['show_numbers_3094893430']; if ( !empty( $show_numbers_var ) ) { $show_numbers = true; } */ $output->Text( outputHeader() ); $output->Text( outputIntro() ); $output->Text( '
' ); $output->Text( '' ); $output->Text( '' ); $output->Text( '' ); if ( $show_numbers ) { $output->Text( '' ); } $strsql = 'select section_id, section_desc from kp_bestof_section where section_id > 1 order by section_id'; $result = $dbconn->Execute( $strsql ); $sectionArr = array(); while( list( $section_id, $section_desc ) = $result->fields ) { $result->MoveNext(); $sectionArr[$section_id] = $section_desc; } $result->Close(); reset($sectionArr); $allCatsArr = array(); while (list($key, $val) = each($sectionArr)) { $categoryArr = array(); $strsql = 'select category_id, category_desc from kp_bestof_category where section_id=' . $key . ' and parent_id = 1'; $result = $dbconn->Execute( $strsql ); while( list( $category_id, $category_desc ) = $result->fields ) { $result->MoveNext(); $categoryArr[$category_id] = $category_desc; } $result->Close(); $allCatsArr[$key] = array( "sectiondesc" => $val, "cats" => $categoryArr ); } ///////////////////////////////////////////////// $strsql = 'SELECT category_id, count(*) as other_count FROM kp_bestof_other where review_status = 1 and length( other_text ) > 0 GROUP BY category_id'; if ( $show_numbers ) { $strsql = 'SELECT category_id, count(*) as other_count FROM kp_bestof_other where length( other_text ) > 0 GROUP BY category_id'; } $result = $dbconn->Execute( $strsql ); $otherArr = array(); while( list( $category_id, $other_count ) = $result->fields ) { $result->MoveNext(); $otherArr["".$category_id] = $other_count; // $output->Text( '$category_id: ' . $category_id . ' $other_count: ' . $other_count . '
' ); // todo: debug } $result->Close(); ///////////////////////////////////////////////// reset( $allCatsArr ); while (list($sectkey, $allcat) = each($allCatsArr) ) { $sectionDesc = $allcat["sectiondesc"]; $cats = $allcat["cats"]; $output->Text( "
$sectionDesc
" ); while (list($key, $catDesc) = each($cats) ) { $outputStr = ""; $outputStr .= <<
EOD; $vote_totals = array(); $outputStr .= getCategoryListing( $key, $dbconn, $vote_totals ); $outputStr .= <<
EOD; // $output->Text( '$key: ' . $key . '
' ); // todo: debug $otherCount = array_key_exists( $key, $otherArr ) ? $otherArr[$key] : 0; $vote_totals['Other'] = new Vote( 0, $otherCount ); reset($vote_totals); $vote_sum = 0; // while (list($vote_name, $vote_number) = each($vote_totals)) while (list($vote_name, $vote) = each($vote_totals)) { $vote_sum += $vote->num_votes; } /*
Bo Peep Books, 0
   abc0ddd%
*/ $outputStr .= "
The results so far:
"; reset( $vote_totals ); while (list($vote_name, $votes) = each($vote_totals)) { $vote_number = $votes->num_votes; $outputStr .= "
"; // $outputStr .= "
$vote_name, $vote_number
"; if ( $show_numbers ) { $vote_contact_id = $votes->contact_id; if ( $vote_contact_id > 0 ) { // local link // $outputStr .= ""; $outputStr .= ""; } else { $outputStr .= "
$vote_name: $vote_number
"; } } else { $outputStr .= "
$vote_name
"; } if ( $vote_sum > 0 ) { $column_width = 200; // pixel width $vote_percent = intval( round( 100 * ( $vote_number / $vote_sum ) ) ); $div_width = intval( $column_width * ( $vote_percent / 100 ) ); if ( $div_width == 0 ) { $div_width = 1; } $outputStr .= "
  {$vote_percent}%
"; } $outputStr .= "
"; } ///////////////////////////////////////////////// if ( $otherCount > 0 ) { $strsql = "SELECT distinct other_text FROM kp_bestof_other where category_id = $key and review_status = 1 and length( other_text ) > 0 order by other_text"; $overflow_style = "overflow: auto;"; if ( $show_numbers ) { $strsql = "SELECT other_text FROM kp_bestof_other where category_id = $key and length( other_text ) > 0 order by other_text"; $overflow_style = ""; } $result = $dbconn->Execute( $strsql ); $box_height = ""; if ( !$show_numbers && $otherCount > 3 ) { $box_height = "height: 55px;"; } $outputStr .= "
"; while( list( $other_text ) = $result->fields ) { $result->MoveNext(); $outputStr .= $other_text . '
'; } $result->Close(); $outputStr .= '
'; } ///////////////////////////////////////////////// $grand_total_votes += $vote_sum; if ( $show_numbers ) { $outputStr .= "
"; $outputStr .= "TOTAL VOTES: $vote_sum
"; } $outputStr .= <<

EOD; $output->Text( $outputStr ); } } if ( $show_numbers ) { $output->Text( "GRAND TOTAL VOTES: $grand_total_votes
" ); } } function handleInput( &$output, &$dbconn, $isbannedip ) { global $eol; $votestr = ""; $debug_output = false; $submitdate = date("F j, Y, g:i a"); $submitip = getenv("REMOTE_ADDR"); $strsql = 'SELECT category_id, category_desc FROM kp_bestof_category where category_id > 1'; $result = $dbconn->Execute( $strsql ); $categoryArr = array(); while( list( $category_id, $category_desc ) = $result->fields ) { $result->MoveNext(); $categoryArr[$category_id] = $category_desc; if ( $debug_output ) $output->Text( '$categoryArr[$category_id] = ' . $categoryArr[$category_id] . ' $category_desc = ' . $category_desc . "
" ); } $result->Close(); if ( $debug_output ) $output->Text( "showcategorys
" ); reset($categoryArr); while (list($key, $val) = each($categoryArr)) { $category_key = 'cat_' . $key; $entry_key = @$_POST[ $category_key ]; if ( !empty( $entry_key ) ) { if ( $debug_output ) $output->Text( "key: $key, val: $val
" ); if ( $debug_output ) $output->Text( "entry_key: $entry_key
" ); if ( $entry_key == 'other' ) // todo: debug { $other_key = 'othertext_' . $key; $other_text = @$_POST[ $other_key ]; if ( $debug_output ) $output->Text( "OTHER TEXT $other_key: $other_text

" ); if ( $debug_output ) $output->Text( '$other_text = ' . $other_text . "
" ); if ( !empty( $other_text ) ) { $other_text = strProperCase( $other_text ); if ( $debug_output ) $output->Text( 'proper cased = ' . $other_text . "
" ); $other_text = (!get_magic_quotes_gpc()) ? addslashes($other_text) : $other_text; $strsql = "INSERT INTO kp_bestof_other ( category_id, other_text ) VALUES ( $key, '$other_text' )"; if ( $debug_output ) $output->Text( $strsql . "
" ); if ( $debug_output ) $output->Text( "strsql: $strsql
" ); $votestr .= "Other($key): " . $other_text . "; "; if ( !$isbannedip ) $dbconn->Execute( $strsql ); } } else { $votestr .= $entry_key . "; "; $strsql = "UPDATE kp_bestof_entry SET votes = votes + 1 where contact_id = $entry_key"; if ( $debug_output ) $output->Text( $strsql . "
" ); if ( $debug_output ) $output->Text( ( $isbannedip ? "banned ip" : "" ) . "
" ); if ( !$isbannedip ) $dbconn->Execute( $strsql ); } } if ( $debug_output ) $output->Text( "
" ); } if ( $debug_output ) $output->Text( "votestr: $votestr
" ); return $votestr; } /* $_submit_check = @$_GET[ '_submit_check' ]; if ( $_submit_check == '1' ) { handleInput(); } else { outputSpreadSheet(); } */ //////////////////////////// // Best Of Poll Get Logos function bestof_user_getlogos() { global $page_title; $page_title = "Best Places for Families 2008 - Logos"; // Create output object - this object will store all of our output so that // we can return it easily when required $output = new pnHTML(); $output->SetInputMode(_PNH_VERBATIMINPUT); $output->Text( << .linkbar { font-family: Verdana; font-size: 10pt; color: #000080; font-weight: bold; } .linkdesc { font-family: Verdana; font-size: 9pt; color: #000080; }
$catDesc
Congratulations! Below you'll find zip files with images in three different colors for print and web to proudly display in your ads and on your website. Choose one, choose two, choose them all. Whatever will look best on your ads and website, because you are one of Kids' Pages Best Places for Families in 2008!

Beautiful Blue
Right-click on the image below and choose
In Firefox: Save Link As...
In Internet Explorer: Save target as...
 
Radiant Red
Right-click on the image below and choose
In Firefox: Save Link As...
In Internet Explorer: Save target as...
 
Gorgeous Green
Right-click on the image below and choose
In Firefox: Save Link As...
In Internet Explorer: Save target as...
 
EOT ); global $pnuser_googleAd; $output->Text( $pnuser_googleAd ); return $output->GetOutput(); } ?>