$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