blob: 2c683ed2ae2b0a3539e8e62cb4e38b9ba063d77c [file] [log] [blame]
* Copyright (c) 2012 Eclipse Foundation and others.
* All rights reserved. This program and the accompanying materials
* are made available under the terms of the Eclipse Public License v1.0
* which accompanies this distribution, and is available at
* Contributors:
* Eclipse Foundation- initial API and implementation
* This script returns a file containing the ids of all current members who have
* a small logo specified in the database. One id on each line.
require_once($_SERVER['DOCUMENT_ROOT'] . "/");
require_once($_SERVER['DOCUMENT_ROOT'] . "/projects/classes/debug.php");
$App = new App();
header('Content-type: text/plain');
$sql = "select i.OrganizationID as id, i.small_logo as logo
from OrganizationInformation as i
join organizations as o on i.OrganizationID = o.organization_id
where i.small_logo is not NULL
and o.member_type in ('SD', 'SC', 'AP', 'AS', 'ENTRP')";
$result = $App->eclipse_sql($sql);
while ($row = mysql_fetch_assoc($result)) {
$id = $row['id'];
$image = imagecreatefromstring($row['logo']);
$width = imagesx($image);
$height = imagesy($image);
echo "$id, $width, $height\n";