$solutions_contact_url = $db->f("solutions_contact_url");
$db2 = new DB_SourceLines();
$db2->query("SELECT COUNT(*) FROM tblsolutions WHERE solutions_contact_name='{$solutions_contact_name}' AND solutions_contact_email='{$solutions_contact_email}' AND solutions_contact_url='{$solutions_contact_url}'");
$db2->next_record();
if ($db2->f("COUNT(*)")) {
$num = "[" . sprintf("%03d", $db2->f("COUNT(*)")) . "]";
echo "<tr><td>" . sprintf("%d", $i) . "</td>\n";
if (empty($solutions_contact_name)) {
echo "<td><a href=\"" . $sess->url("bycontact.php") . $sess->add_query(array("solutions_contact_name" => "", "solutions_contact_email" => "{$solutions_contact_email}", "solutions_contact_url" => "{$solutions_contact_url}")) . "\">{$num}</a></td>\n";
echo "<td>" . $t->translate("Unknown") . "</td>\n";
} else {
echo "<td><a href=\"" . $sess->url("bycontact.php") . $sess->add_query(array("solutions_contact_name" => $db->f("solutions_contact_name"), "solutions_contact_email" => "{$solutions_contact_email}", "solutions_contact_url" => "{$solutions_contact_url}")) . "\">{$num}</a></td>\n";
echo "<td>" . $db->f("solutions_contact_name") . "</td>\n";
}
if (!empty($solutions_contact_email)) {
echo "<td><<a href=\"mailto:" . mailtoencode($solutions_contact_email) . "\">" . ereg_replace("\\.", " dot ", ereg_replace("@", " at ", htmlentities($solutions_contact_email))) . "</a>></td>\n";
} else {
echo "<td> </td>\n";
}
if (!empty($solutions_contact_url)) {
echo "<td><a href=\"" . $solutions_contact_url . "\">" . $solutions_contact_url . "</a></td>\n";
} else {
echo "<td> </td>\n";
}
echo "</tr>\n";
$i++;
}
}
echo "</table>\n";
$bx->box_body_end();
$bx->box_end();
<?php
echo "<tr><td><b>" . $t->translate("No") . ".</b></td><td><b># " . $t->translate("Ent") . "</b></td><td><b>" . $t->translate("Username") . "</b></td><td><b>" . $t->translate("Realname") . "</b></td><td><b>" . $t->translate("E-Mail") . "</b></td></tr>\n";
$i = 1;
while ($db->next_record()) {
$columns = "COUNT(*)";
$tables = "enterprise";
$where = "user=\"" . $db->f("username") . "\" AND status=\"A\"";
$num = "";
$dbn = new DB_SourceBiz();
if ($dbn->query("SELECT {$columns} AS cnt FROM {$tables} WHERE {$where}")) {
$dbn->next_record();
$num = "[" . sprintf("%03d", $dbn->f("cnt")) . "]";
}
echo "<tr><td>" . sprintf("%d", $i) . "</td>\n";
echo "<td><a href=\"" . $sess->url("enterprises.php") . $sess->add_query(array("by" => "filter", "author" => $db->f("username"))) . "\">{$num}</a></td>\n";
echo "<td>" . $db->f("username") . "</td>\n";
echo "<td>" . $db->f("realname") . "</td>";
echo "<td><<a href=\"mailto:" . mailtoencode($db->f("email_usr")) . "\">" . ereg_replace("@", " at ", htmlentities($db->f("email_usr"))) . "</a>></td>";
echo "</tr>\n";
$i++;
}
echo "</table>\n";
}
$bx->box_body_end();
$bx->box_end();
?>
<!-- end content -->
<?php
require "./include/footer.inc";
page_close();
print_lang($mother_tongue);
echo "<tr><td align=right valign=top width=30%>" . $t->translate("Other languages") . ":</td><td width=70%>\n";
$other_lang_1 = $db->f("other_lang_1");
echo "1. ";
print_lang($other_lang_1);
$other_lang_2 = $db->f("other_lang_2");
echo "<BR>2. ";
print_lang($other_lang_2);
echo "</td></tr>\n";
if ($db->f("contact") != "no") {
echo "<tr><td align=right width=30%>" . $t->translate("Contact") . ":</td><td width=70%>";
$pquery["devname"] = $db->f("username");
htmlp_link("pmess_compose.php", $pquery, $t->translate("write Developer"));
}
if ($db->f("showemail") == "yes") {
echo "<tr><td align=right width=30%>" . $t->translate("E-Mail") . ":</td><td width=70%><a href=\"mailto:" . mailtoencode($db->f("email_usr")) . "\">" . ereg_replace("\\.", " dot ", ereg_replace("@", " at ", htmlentities($db->f("email_usr")))) . "</a>\n";
}
echo "<tr><td align=right width=30%>" . $t->translate("Developer last modified") . ":</td><td width=70%>\n";
$timestamp = mktimestamp($db->f("modification_usr"));
echo timestr($timestamp) . "</td></tr>\n";
echo "<tr><td align=right width=30%>" . $t->translate("Developer created") . ":</td><td width=70%>\n";
$timestamp = mktimestamp($db->f("creation_usr"));
echo timestr($timestamp) . "</td></tr>\n";
echo "<tr><td align=right width=30%>" . $t->translate("Profile last modified") . ":</td><td width=70%>\n";
$timestamp = mktimestamp($db->f("creation"));
echo timestr($timestamp) . "</td></tr>\n";
$db2->query("SELECT devel_cnt FROM counter WHERE develid='{$develid}'");
$db2->next_record();
echo "<tr><td align=right width=30%>" . $t->translate("# of Visits") . ":</td><td width=70%>\n";
echo $db2->f("devel_cnt") . "</td></tr>\n";
echo "<tr><td align=right width=30%>" . $t->translate("Registration Number") . ":</td><td width=70%>\n";
if ($counter % 2 != 1) {
$bgcolor = $th_box_body_bgcolor;
} else {
$bgcolor = $th_box_body_bgcolor2;
}
$counter++;
$bx->box_column("right", "", $bgcolor, $i);
$pquery["devname"] = $db->f("username");
$bx->box_column("center", "", $bgcolor, html_link("showprofile.php", $pquery, $db->f("username")));
if ($db->f("showname") == "yes") {
$bx->box_column("center", "", $bgcolor, $db->f("realname"));
} else {
$bx->box_column("center", "", $bgcolor, "-- % ---");
}
if ($db->f("showemail") == "yes") {
$bx->box_column("center", "", $bgcolor, html_link("mailto:" . mailtoencode($db->f("email_usr")), "", ereg_replace("\\.", " dot ", ereg_replace("@", " at ", htmlentities($db->f("email_usr"))))));
} else {
$bx->box_column("center", "", $bgcolor, "--- % ---");
}
$bx->box_next_row_of_columns();
$i++;
}
$bx->box_columns_end();
}
$bx->box_body_end();
$bx->box_end();
break;
}
?>
<!-- end content -->
echo "<tr><td>" . sprintf("%d", $i) . "</td>\n";
$nachname = $db->f("NACHNAME");
if (empty($nachname)) {
echo "<td><a href=\"" . $sess->url("docbydev.php") . $sess->add_query(array("developer" => $db->f("ID"))) . "\">{$num}</a></td>\n";
echo "<td>" . $t->translate("Unknown") . "</td>\n";
echo "<td> </td>\n";
} else {
echo "<td><a href=\"" . $sess->url("docbydev.php") . $sess->add_query(array("developer" => $db->f("ID"))) . "\">{$num}</a></td>\n";
echo "<td>" . $db->f("NACHNAME");
if ($db->f("VORNAME")) {
echo ", " . $db->f("VORNAME");
}
echo "</td>\n";
$email = $db->f("EMAIL");
if (!empty($email)) {
echo "<td><<a href=\"mailto:" . mailtoencode($db->f("EMAIL")) . "\">" . ereg_replace("\\.", " dot ", ereg_replace("@", " at ", htmlentities($db->f("EMAIL")))) . "</a>></td>\n";
} else {
echo "<td> </td>\n";
}
echo "</tr>\n";
}
$i++;
}
}
echo "</table>\n";
$bx->box_body_end();
$bx->box_end();
?>
<!-- end content -->
<?php
