migrate db classes to mysqli

Signed-off-by: Christopher Guindon chris.guindon@eclipse-foundation.org

For this to work, we need to ensure that all our PHP repos have switched over to mysqli_.

• community (no trace of mysql_)
• downloads
• eclipse.org-common
• errors (no trace of mysql_)
• go (no trace of mysql_)
• legal (no trace of mysql_)
• membership
  • Found some traces of mysql_ functions in the repo but I am deleting them since I don't believe we need them anymore.
• org
• projects
• proposals (no trace of mysql_)
• sponsors (no trace of mysql_)
• mediawiki (Might not be needed since the site is deprecated)
• forums
• dev.eclipse.org
• foundation.eclipse.org
• eclipse.dev (Matt gave me a list of projects with mysql_ functions in their codebase)
  • modeling/gmp
  • modeling
  • webtools
  • eclipse/platform-ui
  • cdo/_deprecated
  • tm/development

httpd/eclipse-php-classes/downloads/livedownload.class.php

+<?php
+
+require_once "/home/data/httpd/eclipse-php-classes/system/dbconnection.class.php";
+require_once "/home/data/httpd/eclipse-php-classes/system/app.class.php";
+
+/**
+ * Livedownload.class.php.
+ *
+ * Author:       Denis Roy
+ * Date:         2005-06-1
+ *
+ * Description:  get live download count according to label
+ */
+class LiveDownload {
+
+  public function selectDownloadCount($_label) {
+
+    // Connect to database.
+    $dbc = new DBConnection();
+    $dbh = $dbc->connect();
+
+    $App = new App();
+
+    $sql = "SELECT dl_count FROM downloads_31 WHERE file = " . $App->returnQuotedString($_label);
+    $rs = mysql_query($sql, $dbh);
+
+    $myrow = mysql_fetch_assoc($rs);
+    $dl_count = $myrow['dl_count'];
+
+    $dbc->disconnect();
+    unset($dbc);
+    return $dl_count;
+  }
+}