<?<br />// Generic UBB.Threads page by Joshua Pettit<br />// aka JoshPet of www.joshuapettit.com <br />// UBB.Threads Elements ©Infopop.com and Rick Baker<br /><br />// Variables - Edit these As Needed<br /><br />// What is the title of the page:<br /> $pagetitle = "Pigelisten";<br /> <br />// What is the PATH (not URL) to your threads install?<br />// You'll find this in your threads config file<br />// Do not include trailing slash<br /> $threadspath = "/usr/local/www/sites/4701.dk/httpdocs/ubbthreads";<br /><br /><br /><br />// DO NOT EDIT THIS SECTION<br />// Require the library<br /> require ("$threadspath/main.inc.php");<br /><br /> $userob = new user;<br /> $user = $userob -> authenticate();<br /><br /><br /> $html = new html;<br /> $html -> send_header($pagetitle,$Cat,0,$user);<br /><br />// ---------------------<br />// Grab the tablewrapper<br /> list($tbopen,$tbclose) = $html -> table_wrapper();<br /><br />// Now let's draw the table<br /> echo "$tbopen";<br /> <br />// Now let's create a header with the page title in it<br /> echo "<tr><td class=\"tdheader\">$pagetitle</td></tr>";<br /> <br />// Now let's open the next table cell for the body of your page:<br /> echo "<tr><td class=\"lighttable\">";<br /> <br /><br /><br /><br />// The rest of the page<br />// YOU CAN EDIT THIS SECTION<br /><br />// Put the HTML of your page below this<br /><br /><br /><br /><br />echo <<<PAGEHTML<br /><br /><br /><tr><br /> <td><b>Gudinde Navn</b></td><br /> <td><b>Gudindens hjemmeside</b></td><br /> </tr><br /> <br /><br /><br /><br />PAGEHTML;<br />$database = mysql_connect("localhost", "xxx", "xxxx");<br />if (!$database) die ('Kunne ikke forbinde til databasen');<br /> mysql_select_db("ubb",$database);<br />mysql_select_db("ubb",$database) or die('Kunne ikke vælge database');<br /> $foresp = mysql_query("SELECT U_Number,U_Title,U_Username,U_Email,U_Homepage,U_Approved, U_Groups FROM w3t_Users <br /> WHERE U_Groups = '-6-'<br /> ORDER BY U_Username");<br />if (!$foresp) die (mysql_error()); <br />print mysql_num_rows($foresp)." fundet<BR><BR>";<br />while ($data = mysql_fetch_array($foresp)) {<br /> <br /> echo "<tr><td>$data[2]</td>";<br /> echo "<TD><A href= http://".$data[4].">".$data[4]."</A></TD>";<br /> echo "</tr>";<br /> <br /> }<br />// DO NOT EDIT BELOW THIS LINE<br /><br />// Close out the table<br /> echo "</td></tr>$tbclose"; <br /><br />// Send the footer<br /> $html -> send_footer();<br />?>