search

openva / richmondsunlight.com

The Richmond Sunlight website.
https://www.richmondsunlight.com/
MIT License
12 stars 3 forks source link

Plan a transition to PHP 7 #240

Open waldoj opened 6 years ago

waldoj commented 6 years ago

Use php7cc to look at what will go into a PHP 5.6 -> PHP 7 transition. PHP 5 simply isn't supported anymore. It's past time to move on.

waldoj commented 6 years ago

Notably: all ereg and mysql functions have been removed. I have issues open here for each of those already. The former is pretty easy, but the latter...ugh.

waldoj commented 6 years ago

Well, this is grim:

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/process-comments.php
> Line 46: [Error] Removed function "ereg" called
    ereg('([0-9]{2})/([0-9]{2})', $comment['name']);
> Line 50: [Error] Removed function "ereg" called
    ereg('([0-9]{5})', $comment['email']);
> Line 54: [Error] Removed function "ereg" called
    ereg('([0-9]{5})-([0-9]{4})', $comment['email']);
> Line 58: [Error] Removed function "ereg" called
    ereg('([0-9]{2})', $comment['age']);
> Line 172: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 173: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 183: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 184: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 195: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 196: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 223: [Error] Removed function "mysql_query" called
    mysql_query($sql);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/list-committees.php
> Line 71: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 72: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 78: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 107: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 108: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 114: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/labs/recommended-bills.php
> Line 72: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 73: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 96: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 106: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 199: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 200: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 212: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/committee.php
> Line 25: [Error] Removed function "mysql_escape_string" called
    mysql_escape_string($_REQUEST['chamber']);
> Line 26: [Error] Removed function "mysql_escape_string" called
    mysql_escape_string($_REQUEST['committee']);
> Line 69: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 70: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 72: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 112: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 113: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 115: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 147: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 148: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 152: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 179: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 180: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 183: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 212: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 239: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 240: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 248: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 299: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 302: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 311: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/video/clip.php
> Line 55: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 56: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 60: [Error] Removed function "mysql_fetch_assoc" called
    mysql_fetch_assoc($result);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/login.php
> Line 66: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 68: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 75: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 91: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 92: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 94: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/vote-csv.php
> Line 29: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($_GET['shortname']);
> Line 30: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($_GET['year']);
> Line 46: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 47: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 57: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/bills-introduced.php
> Line 34: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($_REQUEST['days']);
> Line 69: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 70: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 76: [Error] Removed function "mysql_fetch_assoc" called
    mysql_fetch_assoc($result);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/vote.php
> Line 76: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 77: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 79: [Error] Removed function "mysql_fetch_assoc" called
    mysql_fetch_assoc($result);
> Line 303: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 304: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 307: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/index.php
> Line 68: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 69: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 76: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 127: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 128: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 133: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 186: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 187: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 225: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 226: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 232: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 265: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 266: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 272: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 305: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 306: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 312: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 317: [Error] Removed function "ereg_replace" called
    ereg_replace('<blockquote>(.*)</blockquote>', '', $comment['comment']);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/legislator-xml.php
> Line 32: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($_GET['shortname']);
> Line 45: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 46: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 51: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 75: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 76: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 80: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 99: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 100: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 104: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 129: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 130: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 134: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/register.php
> Line 197: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($form_data['email']);
> Line 199: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 200: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 316: [Error] Removed function "mysql_query" called
    mysql_query($sql);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/photosynthesis/index.php
> Line 72: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 75: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 81: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 86: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 97: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 99: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 109: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 114: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 140: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 142: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 144: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/photosynthesis/list-portfolios.php
> Line 52: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 53: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 61: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/photosynthesis/rss/portfolio.php
> Line 52: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($hash);
> Line 53: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 54: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 55: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 72: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 80: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/photosynthesis/process-actions.php
> Line 51: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($_POST['add-bill']);
> Line 52: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($_POST['portfolio']);
> Line 67: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 80: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($_GET['delete-bill']);
> Line 91: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 100: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 101: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 119: [Error] Removed function "mysql_escape_string" called
    mysql_escape_string($_GET['delete-portfolio']);
> Line 126: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 127: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 128: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 133: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 138: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 145: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 183: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 232: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 233: [Error] Removed function "mysql_insert_id" called
    mysql_insert_id();
> Line 246: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 247: [Error] Removed function "mysql_insert_id" called
    mysql_insert_id();

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/photosynthesis/edit-portfolio.php
> Line 46: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($_GET['hash']);
> Line 76: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 104: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 129: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 130: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 135: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 154: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 155: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/photosynthesis/ajax-bill-notes.php
> Line 38: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($_POST['user_hash']);
> Line 42: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($notes);
> Line 43: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($_POST['id']);
> Line 47: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($hash);
> Line 49: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 66: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 67: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/photosynthesis/public-portfolio.php
> Line 62: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 65: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 73: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 80: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 155: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 156: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 165: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 210: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 211: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 230: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/photosynthesis/preferences.php
> Line 114: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 130: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 131: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 132: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/photosynthesis/bill-notes.php
> Line 59: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($_GET['hash']);
> Line 60: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($_GET['id']);
> Line 69: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($notes);
> Line 74: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 89: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 90: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 107: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 108: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 113: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/code-section-json.php
> Line 28: [Error] Removed function "mysql_escape_string" called
    mysql_escape_string(urldecode($_REQUEST['section']));
> Line 43: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 46: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result, MYSQL_ASSOC);
> Line 51: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result, MYSQL_ASSOC);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/list-bills-xml.php
> Line 29: [Error] Removed function "mysql_escape_string" called
    mysql_escape_string($_REQUEST['year']);
> Line 50: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 51: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 61: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result, MYSQL_ASSOC);
> Line 80: [Error] Result of new is assigned by reference
    $Serializer =& new \XML_Serializer($serializer_options);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/legislator.php
> Line 31: [Error] Removed function "mysql_escape_string" called
    mysql_escape_string($_REQUEST['shortname']);
> Line 221: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 222: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 228: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 233: [Error] Removed function "ereg_replace" called
    ereg_replace('<blockquote>(.*)</blockquote>', '', $comment['comment']);
> Line 355: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 356: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 465: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 467: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 510: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 512: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 558: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 560: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 638: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 639: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 647: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 784: [Error] Removed function "eregi_replace" called
    eregi_replace('([a-z]{3}) ([0-9]+), 20([0-9]{2})', '', $item['summary']);
> Line 786: [Error] Removed function "eregi_replace" called
    eregi_replace('([0-9]*) hour(s*) ago', '', $item['summary']);
> Line 788: [Error] Removed function "ereg_replace" called
    ereg_replace(',&nbsp;([A-Z]{2})&nbsp;- ', '', $item['summary']);
> Line 941: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 942: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 950: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/bill-activity.php
> Line 25: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($_REQUEST['days']);
> Line 58: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 59: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 65: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/rss/comments.php
> Line 30: [Error] Removed function "ereg" called
    ereg('([0-9]{4})', $year);
> Line 30: [Error] Removed function "ereg" called
    ereg('([b-s]{2})([0-9]+)', $year);
> Line 59: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 64: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/rss/tag.php
> Line 55: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($tag);
> Line 56: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 64: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/rss/legislator.php
> Line 53: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($legislator['shortname']);
> Line 54: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 55: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 59: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 88: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 96: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/rss/bill.php
> Line 54: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($bill['number']);
> Line 57: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 59: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 65: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/includes/photosynthesis.inc.php
> Line 20: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 21: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 25: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 31: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 32: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 36: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 43: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 44: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 48: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 89: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 95: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 99: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 104: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 113: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 114: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 116: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 150: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 164: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 537: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 538: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 558: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/includes/phpmailer/class.phpmailer.php
> Line 459: [Error] Removed function "split" called
    split(',', $to);
> Line 581: [Error] Removed function "eregi" called
    eregi('^(.+):([0-9]+)$', $hosts[$index], $hostinfo);
> Line 1107: [Error] Removed function "set_magic_quotes_runtime" called
    set_magic_quotes_runtime(0);
> Line 1111: [Error] Removed function "set_magic_quotes_runtime" called
    set_magic_quotes_runtime($magic_quotes);
> Line 1234: [Error] Removed regular expression modifier "e" used
    preg_replace('/([^A-Za-z0-9!*+\\/ -])/e', '\'=\'.sprintf(\'%02X\', ord(\'\\1\'))', $encoded);
> Line 1237: [Error] Removed regular expression modifier "e" used
    preg_replace('/([\\(\\)"])/e', '\'=\'.sprintf(\'%02X\', ord(\'\\1\'))', $encoded);
> Line 1242: [Error] Removed regular expression modifier "e" used
    preg_replace('/([\\000-\\011\\013\\014\\016-\\037\\075\\077\\137\\177-\\377])/e', '\'=\'.sprintf(\'%02X\', ord(\'\\1\'))', $encoded);
> Line 1503: [Error] Removed function "split" called
    split('\\.', $filename);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/includes/simplepie.inc.php
> Line 643: [Warning] Function argument(s) returned by "func_get_args" might have been modified
    func_get_args();
> Line 2380: [Warning] Possible array element creation during by-reference assignment
    $this->data['links'][$key] =& $this->data['links'][SIMPLEPIE_IANA_LINK_RELATIONS_REGISTRY . $key];
> Line 2384: [Warning] Possible array element creation during by-reference assignment
    $this->data['links'][SIMPLEPIE_IANA_LINK_RELATIONS_REGISTRY . $key] =& $this->data['links'][$key];
> Line 2389: [Warning] Possible array element creation during by-reference assignment
    $this->data['links'][substr($key, 41)] =& $this->data['links'][$key];
> Line 9995: [Warning] Possible array element creation during by-reference assignment
    $this->data['links'][$key] =& $this->data['links'][SIMPLEPIE_IANA_LINK_RELATIONS_REGISTRY . $key];
> Line 9999: [Warning] Possible array element creation during by-reference assignment
    $this->data['links'][SIMPLEPIE_IANA_LINK_RELATIONS_REGISTRY . $key] =& $this->data['links'][$key];
> Line 10004: [Warning] Possible array element creation during by-reference assignment
    $this->data['links'][substr($key, 41)] =& $this->data['links'][$key];
> Line 17275: [Warning] Possible array element creation during by-reference assignment
    $this->data['links'][$key] =& $this->data['links'][SIMPLEPIE_IANA_LINK_RELATIONS_REGISTRY . $key];
> Line 17279: [Warning] Possible array element creation during by-reference assignment
    $this->data['links'][SIMPLEPIE_IANA_LINK_RELATIONS_REGISTRY . $key] =& $this->data['links'][$key];
> Line 17284: [Warning] Possible array element creation during by-reference assignment
    $this->data['links'][substr($key, 41)] =& $this->data['links'][$key];

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/includes/class.User.php
> Line 65: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($_SESSION['id']);
> Line 66: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 68: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 71: [Error] Removed function "mysql_fetch_assoc" called
    mysql_fetch_assoc($result);
> Line 122: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 125: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 131: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 192: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 193: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 196: [Error] Removed function "mysql_fetch_assoc" called
    mysql_fetch_assoc($result);
> Line 250: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 251: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 257: [Error] Removed function "mysql_fetch_assoc" called
    mysql_fetch_assoc($result);
> Line 314: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 315: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 322: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 355: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 356: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 360: [Error] Removed function "mysql_fetch_object" called
    mysql_fetch_object($result);
> Line 392: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 393: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 397: [Error] Removed function "mysql_fetch_assoc" called
    mysql_fetch_assoc($result);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/includes/sphinxapi.php
> Line 132: [Error] Bitwise shift by 32 bits
    $v >> 32;
> Line 184: [Error] Bitwise shift by 32 bits
    $v >> 32;
> Line 238: [Error] Bitwise shift by 32 bits
    1 << 32;
> Line 239: [Error] Bitwise shift by 32 bits
    1 << 32;
> Line 243: [Error] Bitwise shift by 32 bits
    $hi << 32;
> Line 251: [Error] Bitwise shift by 32 bits
    (int) ($hi / $C) << 32;
> Line 252: [Error] Bitwise shift by 32 bits
    $hi % $C << 32;
> Line 305: [Error] Bitwise shift by 32 bits
    1 << 32;
> Line 306: [Error] Bitwise shift by 32 bits
    1 << 32;
> Line 308: [Error] Bitwise shift by 32 bits
    $hi << 32;
> Line 372: [Error] Bitwise shift by 32 bits
    1 << 32;
> Line 427: [Error] PHP 4 constructors are now deprecated
    public function SphinxClient()
    {
    }

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/includes/class.Legislator.php
> Line 19: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($shortname);
> Line 20: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 21: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 25: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 85: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($id);
> Line 86: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 87: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 91: [Error] Removed function "mysql_fetch_assoc" called
    mysql_fetch_assoc($result);
> Line 100: [Error] Removed function "ereg_replace" called
    ereg_replace('^(.*),(.*),(.*)$', '\\1<br />\\2, \\3', $legislator['address_district']);
> Line 156: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 157: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 159: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/includes/class.CommentSubscription.php
> Line 21: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 45: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 70: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 71: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 80: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 105: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 106: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 110: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/includes/class.Bill2.php
> Line 61: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($number);
> Line 62: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($year);
> Line 63: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 64: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 68: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 153: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 154: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 158: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result, MYSQL_ASSOC);
> Line 186: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 187: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($bill_result);
> Line 198: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 201: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 203: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 221: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 222: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 227: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result, MYSQL_ASSOC);
> Line 241: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 242: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 245: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 263: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 264: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 270: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 329: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 331: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 334: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result, MYSQL_ASSOC);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/includes/class.Petition.php
> Line 15: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 24: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 92: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($this->title);
> Line 93: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($this->text);
> Line 94: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($this->user_id);
> Line 96: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 105: [Error] Removed function "mysql_insert_id" called
    mysql_insert_id();
> Line 135: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($this->id);
> Line 136: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 139: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 144: [Error] Removed function "mysql_fetch_object" called
    mysql_fetch_object($result);
> Line 172: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($this->petition_id);
> Line 174: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 177: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 184: [Error] Removed function "mysql_fetch_object" called
    mysql_fetch_object($result);
> Line 204: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($this->petition_id);
> Line 205: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($this->user_id);
> Line 208: [Error] Removed function "mysql_query" called
    mysql_query($sql);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/includes/class.Lobbyist.php
> Line 57: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 63: [Error] Removed function "mysql_fetch_object" called
    mysql_fetch_object($result);
> Line 72: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 80: [Error] Removed function "mysql_fetch_object" called
    mysql_fetch_object($result);
> Line 107: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 113: [Error] Removed function "mysql_fetch_object" called
    mysql_fetch_object($result);
> Line 137: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 145: [Error] Removed function "mysql_fetch_object" called
    mysql_fetch_object($result);
> Line 182: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 193: [Error] Removed function "mysql_fetch_object" called
    mysql_fetch_object($result);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/includes/functions.inc.php
> Line 107: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 127: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 132: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 152: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 165: [Error] Removed function "mysql_connect" called
    mysql_connect(PDO_SERVER, PDO_USERNAME, PDO_PASSWORD);
> Line 171: [Error] Removed function "mysql_select_db" called
    mysql_select_db(MYSQL_DATABASE, $db);
> Line 172: [Error] Removed function "mysql_query" called
    mysql_query('SET NAMES "utf8"');
> Line 348: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($value);
> Line 371: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($value);
> Line 424: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 433: [Error] Removed function "mysql_insert_id" called
    mysql_insert_id();
> Line 445: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 479: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($_SESSION['id']);
> Line 480: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 481: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 485: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result, MYSQL_ASSOC);
> Line 519: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($value);
> Line 530: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($_SESSION['id']);
> Line 531: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 582: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($_SESSION['id']);
> Line 593: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($_SESSION['id']);
> Line 595: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 600: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 631: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 632: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 660: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 734: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 737: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 740: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 771: [Error] Removed regular expression modifier "e" used
    preg_replace('/<(script|style).*?<\\/\\1>/se', 'str_replace("\\n", "<WPPreserveNewline />", "\\0")', $pee);
> Line 779: [Error] Removed regular expression modifier "e" used
    preg_replace('!(<pre.*?>)(.*?)</pre>!ise', ' stripslashes(\'$1\') .  stripslashes(clean_pre(\'$2\'))  . \'</pre>\' ', $pee);
> Line 935: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 936: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 942: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/includes/htmlpurifier/HTMLPurifier/ConfigSchema/ValidatorAtom.php
> Line 21: [Warning] Possible object property creation during by-reference assignment
    $this->contents =& $obj->{$member};

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/includes/htmlpurifier/HTMLPurifier/ErrorCollector.php
> Line 31: [Warning] Function argument(s) returned by "func_get_args" might have been modified
    func_get_args();

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/includes/htmlpurifier/HTMLPurifier/HTMLModule.php
> Line 227: [Warning] Function argument(s) returned by "func_get_args" might have been modified
    func_get_args();

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/includes/class.Poll.php
> Line 32: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 33: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 85: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 86: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 91: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/includes/class.Committee.php
> Line 27: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 28: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 33: [Error] Removed function "mysql_fetch_assoc" called
    mysql_fetch_assoc($result);
> Line 69: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 71: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 77: [Error] Removed function "mysql_fetch_assoc" called
    mysql_fetch_assoc($result);
> Line 107: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 108: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 114: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/includes/class.Video.php
> Line 27: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 28: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 30: [Error] Removed function "mysql_fetch_object" called
    mysql_fetch_object($result);
> Line 67: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 68: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 70: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 151: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 166: [Error] Removed function "mysql_insert_id" called
    mysql_insert_id();
> Line 252: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 253: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 258: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 289: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 290: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 297: [Error] Removed function "mysql_fetch_object" called
    mysql_fetch_object($result);
> Line 329: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 330: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 337: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result, MYSQL_ASSOC);
> Line 445: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 448: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 454: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 587: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 588: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 595: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result, MYSQL_ASSOC);
> Line 722: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 746: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 771: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 772: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 774: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 791: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 834: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 836: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 841: [Error] Removed function "mysql_fetch_object" called
    mysql_fetch_object($result);
> Line 910: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 912: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 921: [Error] Removed function "mysql_fetch_object" called
    mysql_fetch_object($result);
> Line 1056: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($this->webvtt);
> Line 1058: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 1089: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 1090: [Error] Removed function "mysql_fetch_object" called
    mysql_fetch_object($result);
> Line 1109: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 1110: [Error] Removed function "mysql_fetch_object" called
    mysql_fetch_object($result);
> Line 1199: [Warning] Nested by-reference foreach loop, make sure that array modifications (if any) do what you expect
    foreach ($times as &$time) {
    }
> Line 1274: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 1317: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($caption->text);
> Line 1323: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 1367: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 1368: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 1378: [Error] Removed function "mysql_fetch_assoc" called
    mysql_fetch_assoc($result);
> Line 1402: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 1403: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 1407: [Error] Removed function "mysql_fetch_assoc" called
    mysql_fetch_assoc($result);
> Line 1516: [Warning] Nested by-reference foreach loop, make sure that array modifications (if any) do what you expect
    foreach ($caption as &$line) {
    }
> Line 1535: [Warning] Nested by-reference foreach loop, make sure that array modifications (if any) do what you expect
    foreach ($clips as &$clip) {
    }
> Line 1543: [Warning] Nested by-reference foreach loop, make sure that array modifications (if any) do what you expect
    foreach ($caption as &$line) {
    }
> Line 1600: [Warning] Nested by-reference foreach loop, make sure that array modifications (if any) do what you expect
    foreach ($matches as &$match) {
    }
> Line 1626: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 1632: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 1653: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 1661: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 1664: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 1669: [Warning] Nested by-reference foreach loop, make sure that array modifications (if any) do what you expect
    foreach ($caption as &$line) {
    }
> Line 1701: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 1746: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 1747: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 1757: [Error] Removed function "mysql_fetch_assoc" called
    mysql_fetch_assoc($result);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/includes/vendor/phpmailer/phpmailer/class.phpmailer.php
> Line 2700: [Error] Removed function "set_magic_quotes_runtime" called
    set_magic_quotes_runtime(false);
> Line 2712: [Error] Removed function "set_magic_quotes_runtime" called
    set_magic_quotes_runtime($magic_quotes);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/includes/vendor/ezyang/htmlpurifier/library/HTMLPurifier/ConfigSchema/ValidatorAtom.php
> Line 36: [Warning] Possible object property creation during by-reference assignment
    $this->contents =& $obj->{$member};

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/includes/vendor/ezyang/htmlpurifier/library/HTMLPurifier/ErrorCollector.php
> Line 74: [Warning] Function argument(s) returned by "func_get_args" might have been modified
    func_get_args();

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/includes/vendor/ezyang/htmlpurifier/library/HTMLPurifier/HTMLModule.php
> Line 261: [Warning] Function argument(s) returned by "func_get_args" might have been modified
    func_get_args();

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/includes/vendor/nikic/php-parser/grammar/analyze.php
> Line 68: [Warning] Nested by-reference foreach loop, make sure that array modifications (if any) do what you expect
    foreach ($parts as &$part) {
    }

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/includes/vendor/symfony/finder/Iterator/RecursiveDirectoryIterator.php
> Line 95: [Warning] Possible object property creation during by-reference assignment
    $children->rewindable =& $this->rewindable;

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/includes/vendor/symfony/debug/Tests/HeaderMock.php
> Line 37: [Warning] Function argument(s) returned by "func_get_args" might have been modified
    func_get_args();

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/includes/vendor/symfony/debug/FatalErrorHandler/ClassNotFoundFatalErrorHandler.php
> [Error] Syntax error, unexpected '?' on line 144. Processing aborted.

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/includes/vendor/symfony/debug/DebugClassLoader.php
> Line 334: [Warning] Possible array element creation during by-reference assignment
    self::$darwinCache[$dir] =& self::$darwinCache[$k];

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/includes/vendor/symfony/debug/ErrorHandler.php
> Line 384: [Warning] Function argument(s) returned by "func_get_arg" might have been modified
    func_get_arg(4);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/includes/vendor/symfony/console/Helper/QuestionHelper.php
> Line 107: [Warning] Function argument(s) returned by "func_get_arg" might have been modified
    func_get_arg(0);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/includes/class.Database.php
> Line 67: [Error] Removed function "mysql_connect" called
    mysql_connect(PDO_SERVER, PDO_USERNAME, PDO_PASSWORD);
> Line 75: [Error] Removed function "mysql_select_db" called
    mysql_select_db(MYSQL_DATABASE, $this->db);
> Line 76: [Error] Removed function "mysql_query" called
    mysql_query('SET NAMES "utf8"');

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/includes/class.Comments.php
> Line 51: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($this->bill_id);
> Line 58: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 59: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 62: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 98: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 99: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 102: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/admin/comments/rss.php
> Line 45: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 50: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/admin/comments/index.php
> Line 45: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 46: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 54: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 66: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 78: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 103: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 105: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/admin/video/orphaned-chyrons.php
> Line 26: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 28: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 57: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 58: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 82: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 137: [Error] Removed function "mysql_query" called
    mysql_query($sql);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/admin/video/index.php
> Line 167: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 168: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 172: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 177: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 178: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 207: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 212: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 235: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($captions->srt);
> Line 237: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 259: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 264: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 279: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($captions->transcript);
> Line 281: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 301: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 306: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 374: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 375: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 407: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 408: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 414: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/admin/index.php
> Line 48: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 49: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 55: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 70: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 71: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 76: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 98: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 99: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 108: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 124: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 125: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 134: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 150: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 151: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 160: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 178: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 179: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 185: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 213: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 214: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 222: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/admin/tag.php
> Line 80: [Error] Removed function "ereg_replace" called
    ereg_replace('[[:punct:]]', '', $tag[$i]);
> Line 81: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($tag[$i]);
> Line 96: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 123: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 124: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 141: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 142: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 151: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 172: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 173: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 176: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($tag_result);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/account.php
> Line 180: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 187: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 234: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 235: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 239: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/process-tags.php
> Line 52: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 119: [Error] Removed function "ereg_replace" called
    ereg_replace('[[:punct:]]', '', $tag[$i]);
> Line 120: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($tag[$i]);
> Line 133: [Error] Removed function "mysql_query" called
    mysql_query($sql);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/bill-fulltext.php
> Line 25: [Error] Removed function "mysql_escape_string" called
    mysql_escape_string($_REQUEST['year']);
> Line 26: [Error] Removed function "mysql_escape_string" called
    mysql_escape_string($_REQUEST['bill']);
> Line 80: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 81: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 84: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result, MYSQL_ASSOC);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/list-minutes.php
> Line 55: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 78: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 83: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 89: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/search.php
> Line 83: [Error] Removed function "eregi" called
    eregi('([hs]{1})([bjr]{1})([[:space:]]?)([0-9]+)', $q);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/statistics.php
> Line 51: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 52: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 57: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 105: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 106: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 111: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 151: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 152: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 160: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 189: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 190: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 198: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/list-legislators-detailed.php
> Line 63: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 64: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 178: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/reset-password.php
> Line 36: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($_GET['hash']);
> Line 40: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 41: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 45: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 63: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($email);
> Line 64: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 67: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 74: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/legislator-vote.php
> Line 75: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($shortname);
> Line 76: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($year);
> Line 79: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 80: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 98: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/list-bills.php
> Line 27: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string(urldecode($_GET['tag']));
> Line 31: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($_GET['year']);
> Line 35: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($_GET['committee']);
> Line 36: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($_GET['chamber']);
> Line 47: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($_GET['status']);
> Line 182: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 183: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 204: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 383: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 384: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 394: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 430: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 431: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 439: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 479: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 480: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 482: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/schedule.php
> Line 64: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 65: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 69: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 99: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($date);
> Line 102: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 103: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 111: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 135: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 136: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result2);
> Line 141: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result2);
> Line 219: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 220: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 226: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/your-legislators.php
> Line 45: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 46: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 51: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/bill-xml.php
> Line 36: [Error] Removed function "mysql_escape_string" called
    mysql_escape_string($_REQUEST['year']);
> Line 37: [Error] Removed function "mysql_escape_string" called
    mysql_escape_string($_REQUEST['bill']);
> Line 56: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 57: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 63: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result, MYSQL_ASSOC);
> Line 81: [Error] Result of new is assigned by reference
    $Serializer =& new \XML_Serializer($serializer_options);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/process-polls.php
> Line 60: [Error] Removed function "mysql_query" called
    mysql_query($sql);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/minutes.php
> Line 28: [Error] Removed function "mysql_escape_string" called
    mysql_escape_string($_REQUEST['chamber']);
> Line 29: [Error] Removed function "mysql_escape_string" called
    mysql_escape_string($_REQUEST['year']);
> Line 29: [Error] Removed function "mysql_escape_string" called
    mysql_escape_string($_REQUEST['date']);
> Line 39: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 40: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 44: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 47: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 68: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 69: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 71: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 223: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 224: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 227: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/unsubscribe.php
> Line 50: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($hash);
> Line 52: [Error] Removed function "mysql_query" called
    mysql_query($sql);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/list-tags-xml.php
> Line 30: [Error] Removed function "mysql_escape_string" called
    mysql_escape_string($_REQUEST['year']);
> Line 49: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 50: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 60: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result, MYSQL_ASSOC);
> Line 71: [Error] Result of new is assigned by reference
    $Serializer =& new \XML_Serializer($serializer_options);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/bill.php
> Line 42: [Error] Removed function "mysql_escape_string" called
    mysql_escape_string($_REQUEST['year']);
> Line 43: [Error] Removed function "mysql_escape_string" called
    mysql_escape_string($_REQUEST['bill']);
> Line 117: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 188: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 191: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 193: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 256: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 257: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 268: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 780: [Warning] Possible internal array pointer access/modification in a by-value foreach loop
    next($code_sections);
> Line 896: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 897: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 899: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 970: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 971: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 976: [Error] Removed function "mysql_fetch_assoc" called
    mysql_fetch_assoc($result);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/bill-history.php
> Line 34: [Error] Removed function "mysql_escape_string" called
    mysql_escape_string($_REQUEST['year']);
> Line 35: [Error] Removed function "mysql_escape_string" called
    mysql_escape_string($_REQUEST['bill']);
> Line 53: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 54: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 56: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 84: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 86: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/list-legislators.php
> Line 76: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 77: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 83: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);
> Line 99: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 100: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 105: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/list-tags.php
> Line 26: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($_GET['year']);
> Line 30: [Error] Removed function "mysql_real_escape_string" called
    mysql_real_escape_string($_GET['committee']);
> Line 56: [Error] Removed function "mysql_query" called
    mysql_query($sql);
> Line 57: [Error] Removed function "mysql_num_rows" called
    mysql_num_rows($result);
> Line 63: [Error] Removed function "mysql_fetch_array" called
    mysql_fetch_array($result);

Checked 1267 files in 13.221 seconds
waldoj commented 6 years ago

772 errors is a lot of errors. The good news is that they're almost entirely MySQL calls. That's also the bad news.

waldoj commented 5 years ago

The easiest MySQL fix is going to be to switch to mysqli. It's a trivial find-and-replace. We want to be using PDO (#18), but it's more important to prepare to get off PHP 5, since that's EOLed any day now.

waldoj commented 5 years ago

It sure looks like that worked OK.

waldoj commented 5 years ago

So, here's what the new list looks like:

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/bill.php
> Line 821: [Warning] Possible internal array pointer access/modification in a by-value foreach loop
    next($code_sections);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/includes/functions.inc.php
> Line 798: [Error] Removed regular expression modifier "e" used
    preg_replace('/<(script|style).*?<\\/\\1>/se', 'str_replace("\\n", "<WPPreserveNewline />", "\\0")', $pee);
> Line 806: [Error] Removed regular expression modifier "e" used
    preg_replace('!(<pre.*?>)(.*?)</pre>!ise', ' stripslashes(\'$1\') .  stripslashes(clean_pre(\'$2\'))  . \'</pre>\' ', $pee);

File: /Users/waldo/Desktop/richmondsunlight.com/htdocs/includes/class.Video.php
> Line 1168: [Warning] Nested by-reference foreach loop, make sure that array modifications (if any) do what you expect
    foreach ($times as &$time) {
    }
> Line 1472: [Warning] Nested by-reference foreach loop, make sure that array modifications (if any) do what you expect
    foreach ($caption as &$line) {
    }
> Line 1489: [Warning] Nested by-reference foreach loop, make sure that array modifications (if any) do what you expect
    foreach ($clips as &$clip) {
    }
> Line 1496: [Warning] Nested by-reference foreach loop, make sure that array modifications (if any) do what you expect
    foreach ($caption as &$line) {
    }
> Line 1552: [Warning] Nested by-reference foreach loop, make sure that array modifications (if any) do what you expect
    foreach ($matches as &$match) {
    }
> Line 1624: [Warning] Nested by-reference foreach loop, make sure that array modifications (if any) do what you expect
    foreach ($caption as &$line) {
    }

Also, sphinxapi.php and SimplePie need to be updated to move past PHP 5. The Sphinx API client that we're using is 2 years older than the most recent update — which should be loaded with Composer — and at a glance it looks like the current version, albeit abandoned, will work on PHP 7. And SimplePie in includes/ is a legacy installation — I'm not sure that's even needed anymore, since we're loading it with Composer. (Take care of that with #254.)

waldoj commented 5 years ago

Note that the new server is running both PHP 7 and PHP 5.6, which I didn't know was a thing but here I am.

waldoj commented 5 years ago

I'm pretty sure there are now zero errors in PHP 7.

Now to merge in all this work from master into deploy. 😬

waldoj commented 5 years ago

Huh. A month ago I merged the wrong code (from master to deploy, instead of vice-versa), and quickly reverted it. Somehow that also undid the work on master? Argh.

waldoj commented 5 years ago

OK, I've got the main repo's use of MySQL all moved to MySQLi. I haven't done the same for the API, Machine, or the video processor, though.

waldoj commented 5 years ago

Time to resurvey things and make a new list of what, specifically, needs to be replaced/modified to work with PHP 7.

waldoj commented 5 years ago

Here it is.

File: htdocs/includes/phpmailer/class.phpmailer.php
> Line 1107: [Error] Removed function "set_magic_quotes_runtime" called
    set_magic_quotes_runtime(0);
> Line 1111: [Error] Removed function "set_magic_quotes_runtime" called
    set_magic_quotes_runtime($magic_quotes);
> Line 1234: [Error] Removed regular expression modifier "e" used
    preg_replace('/([^A-Za-z0-9!*+\\/ -])/e', '\'=\'.sprintf(\'%02X\', ord(\'\\1\'))', $encoded);
> Line 1237: [Error] Removed regular expression modifier "e" used
    preg_replace('/([\\(\\)"])/e', '\'=\'.sprintf(\'%02X\', ord(\'\\1\'))', $encoded);
> Line 1242: [Error] Removed regular expression modifier "e" used
    preg_replace('/([\\000-\\011\\013\\014\\016-\\037\\075\\077\\137\\177-\\377])/e', '\'=\'.sprintf(\'%02X\', ord(\'\\1\'))', $encoded);

File: htdocs/includes/simplepie.inc.php
> Line 643: [Warning] Function argument(s) returned by "func_get_args" might have been modified
    func_get_args();
> Line 2380: [Warning] Possible array element creation during by-reference assignment
    $this->data['links'][$key] =& $this->data['links'][SIMPLEPIE_IANA_LINK_RELATIONS_REGISTRY . $key];
> Line 2384: [Warning] Possible array element creation during by-reference assignment
    $this->data['links'][SIMPLEPIE_IANA_LINK_RELATIONS_REGISTRY . $key] =& $this->data['links'][$key];
> Line 2389: [Warning] Possible array element creation during by-reference assignment
    $this->data['links'][mb_substr($key, 41)] =& $this->data['links'][$key];
> Line 10000: [Warning] Possible array element creation during by-reference assignment
    $this->data['links'][$key] =& $this->data['links'][SIMPLEPIE_IANA_LINK_RELATIONS_REGISTRY . $key];
> Line 10004: [Warning] Possible array element creation during by-reference assignment
    $this->data['links'][SIMPLEPIE_IANA_LINK_RELATIONS_REGISTRY . $key] =& $this->data['links'][$key];
> Line 10009: [Warning] Possible array element creation during by-reference assignment
    $this->data['links'][mb_substr($key, 41)] =& $this->data['links'][$key];
> Line 17290: [Warning] Possible array element creation during by-reference assignment
    $this->data['links'][$key] =& $this->data['links'][SIMPLEPIE_IANA_LINK_RELATIONS_REGISTRY . $key];
> Line 17294: [Warning] Possible array element creation during by-reference assignment
    $this->data['links'][SIMPLEPIE_IANA_LINK_RELATIONS_REGISTRY . $key] =& $this->data['links'][$key];
> Line 17299: [Warning] Possible array element creation during by-reference assignment
    $this->data['links'][mb_substr($key, 41)] =& $this->data['links'][$key];

File: htdocs/includes/sphinxapi.php
> Line 135: [Error] Bitwise shift by 32 bits
    $v >> 32;
> Line 187: [Error] Bitwise shift by 32 bits
    $v >> 32;
> Line 241: [Error] Bitwise shift by 32 bits
    1 << 32;
> Line 242: [Error] Bitwise shift by 32 bits
    1 << 32;
> Line 246: [Error] Bitwise shift by 32 bits
    $hi << 32;
> Line 254: [Error] Bitwise shift by 32 bits
    (int) ($hi / $C) << 32;
> Line 255: [Error] Bitwise shift by 32 bits
    $hi % $C << 32;
> Line 308: [Error] Bitwise shift by 32 bits
    1 << 32;
> Line 309: [Error] Bitwise shift by 32 bits
    1 << 32;
> Line 311: [Error] Bitwise shift by 32 bits
    $hi << 32;
> Line 375: [Error] Bitwise shift by 32 bits
    1 << 32;
> Line 433: [Error] PHP 4 constructors are now deprecated
    function SphinxClient()
    {
    }

File: htdocs/includes/htmlpurifier/HTMLPurifier/ConfigSchema/ValidatorAtom.php
> Line 21: [Warning] Possible object property creation during by-reference assignment
    $this->contents =& $obj->{$member};

File: htdocs/includes/htmlpurifier/HTMLPurifier/ErrorCollector.php
> Line 31: [Warning] Function argument(s) returned by "func_get_args" might have been modified
    func_get_args();

File: htdocs/includes/htmlpurifier/HTMLPurifier/HTMLModule.php
> Line 227: [Warning] Function argument(s) returned by "func_get_args" might have been modified
    func_get_args();

File: htdocs/includes/class.Video.php
> Line 1174: [Warning] Nested by-reference foreach loop, make sure that array modifications (if any) do what you expect
    foreach ($times as &$time) {
    }
> Line 1478: [Warning] Nested by-reference foreach loop, make sure that array modifications (if any) do what you expect
    foreach ($caption as &$line) {
    }
> Line 1495: [Warning] Nested by-reference foreach loop, make sure that array modifications (if any) do what you expect
    foreach ($clips as &$clip) {
    }
> Line 1502: [Warning] Nested by-reference foreach loop, make sure that array modifications (if any) do what you expect
    foreach ($caption as &$line) {
    }
> Line 1558: [Warning] Nested by-reference foreach loop, make sure that array modifications (if any) do what you expect
    foreach ($matches as &$match) {
    }
> Line 1630: [Warning] Nested by-reference foreach loop, make sure that array modifications (if any) do what you expect
    foreach ($caption as &$line) {
    }

File: htdocs/includes/vendor/phpmailer/phpmailer/class.phpmailer.php
> Line 2717: [Error] Removed function "set_magic_quotes_runtime" called
    set_magic_quotes_runtime(false);
> Line 2729: [Error] Removed function "set_magic_quotes_runtime" called
    set_magic_quotes_runtime($magic_quotes);

File: htdocs/includes/vendor/ezyang/htmlpurifier/library/HTMLPurifier/ConfigSchema/ValidatorAtom.php
> Line 36: [Warning] Possible object property creation during by-reference assignment
    $this->contents =& $obj->{$member};

File: htdocs/includes/vendor/ezyang/htmlpurifier/library/HTMLPurifier/ErrorCollector.php
> Line 74: [Warning] Function argument(s) returned by "func_get_args" might have been modified
    func_get_args();

File: htdocs/includes/vendor/ezyang/htmlpurifier/library/HTMLPurifier/HTMLModule.php
> Line 261: [Warning] Function argument(s) returned by "func_get_args" might have been modified
    func_get_args();

File: htdocs/includes/vendor/simplepie/simplepie/library/SimplePie.php
> Line 683: [Warning] Function argument(s) returned by "func_get_args" might have been modified
    func_get_args();
> Line 2594: [Warning] Possible array element creation during by-reference assignment
    $this->data['links'][$key] =& $this->data['links'][SIMPLEPIE_IANA_LINK_RELATIONS_REGISTRY . $key];
> Line 2598: [Warning] Possible array element creation during by-reference assignment
    $this->data['links'][SIMPLEPIE_IANA_LINK_RELATIONS_REGISTRY . $key] =& $this->data['links'][$key];
> Line 2603: [Warning] Possible array element creation during by-reference assignment
    $this->data['links'][substr($key, 41)] =& $this->data['links'][$key];

File: htdocs/includes/vendor/simplepie/simplepie/library/SimplePie/Item.php
> Line 1058: [Warning] Possible array element creation during by-reference assignment
    $this->data['links'][$key] =& $this->data['links'][SIMPLEPIE_IANA_LINK_RELATIONS_REGISTRY . $key];
> Line 1062: [Warning] Possible array element creation during by-reference assignment
    $this->data['links'][SIMPLEPIE_IANA_LINK_RELATIONS_REGISTRY . $key] =& $this->data['links'][$key];
> Line 1067: [Warning] Possible array element creation during by-reference assignment
    $this->data['links'][substr($key, 41)] =& $this->data['links'][$key];

File: htdocs/includes/vendor/simplepie/simplepie/library/SimplePie/Source.php
> Line 433: [Warning] Possible array element creation during by-reference assignment
    $this->data['links'][$key] =& $this->data['links'][SIMPLEPIE_IANA_LINK_RELATIONS_REGISTRY . $key];
> Line 437: [Warning] Possible array element creation during by-reference assignment
    $this->data['links'][SIMPLEPIE_IANA_LINK_RELATIONS_REGISTRY . $key] =& $this->data['links'][$key];
> Line 442: [Warning] Possible array element creation during by-reference assignment
    $this->data['links'][substr($key, 41)] =& $this->data['links'][$key];

File: htdocs/includes/class.Database.php
> Line 115: [Error] Removed function "mysql_connect" called
    mysql_connect(PDO_SERVER, PDO_USERNAME, PDO_PASSWORD);
> Line 122: [Error] Removed function "mysql_select_db" called
    mysql_select_db(MYSQL_DATABASE, $this->db);
> Line 123: [Error] Removed function "mysql_query" called
    mysql_query('SET NAMES "utf8"');

File: htdocs/bill.php
> Line 837: [Warning] Possible internal array pointer access/modification in a by-value foreach loop
    next($code_sections);
waldoj commented 5 years ago

OK, so this looks great. This is all third-party software that can be upgraded.

Now to upgrade it.

waldoj commented 5 years ago
waldoj commented 5 years ago

So here's something I hadn't considered. I don't know how thoroughly e.g. mysql_connect has been removed from PHP. That is, will its mere presence will cause all of the database class to fail with a fatal error, even if the command goes unexecuted under PHP 7? If so — and I think that's likely — then this switch can't be made until the API, Machine, and Video Processor have all been updated to use MySQLi.

waldoj commented 5 years ago

Getting close here.