Hi ,
first of all please follow this link ( I just found it ):
http://www.shazeensamad.com/index.php?x=links
talking about ''Special Thanks to my visitors'' field my question is :
... could you be so kind and tell me ,how can I / is there any possibility to create a kind of .php code or something in order to import commenter Authors from database and show on my about.html page like this field ?
One more detail ... my about page is about.html .In this case i'll have to create an addon file .php and after that i need to insert the tag addon in my about.html page.
example of pixelpost addon:
<?php
// SVN file version:
// $Id: current_datetime.php 455 2007-10-30 18:20:53Z austriaka $
/*
Pixelpost version 1.7
Pixelpost www: http://www.pixelpost.org/
Version 1.7:
Development Team:
Ramin Mehran, Will Duncan, Joseph Spurling,
Piotr "GeoS" Galas, Dennis Mooibroek, Karin Uhlig, Jay Williams, David Kozikowski
Former members of the Development Team:
Connie Mueller-Goedecke
Version 1.1 to Version 1.3: Linus <http://www.shapestyle.se>
Datetime addon version 1.1
================================================================
Provided as a basic example.
It retreives the current datetime as reported by the server.
The new tag to use in templates are
<CURRENT_DATE_TIME>
which will be replaced with the variable $current_date_time.
It's very simplistic.
When creating an addon, please always have the $addon_* variables.
Those are displayed in a users admin panel under general info.
All variables from the main script are available here, be sure not to overwrite!
$tpl holds the current template (image_template.html or comments_template.html etc).
*/
$addon_name = "Pixelpost Current DateTime";
$addon_description = "Displays current date and time as reported by the server.<br />
Format is the same as you have set in admin panel >> options <br />
An example of how to create addons.<br /><br />
<b>Tag: </b><CURRENT_DATE_TIME>";
$addon_version = "1.1";
$tz = $cfgrow["timezone"];
$current_date_time = gmdate($cfgrow['dateformat'],time() + (3600 * $tz));
$tpl = str_replace("<CURRENT_DATE_TIME>",$current_date_time,$tpl);
?>
More than that , I think i found the code but i'm not sure ....i'm ''out of range'' in php typing by the way .... that's why i ask ...
$hostname = "localhost";
$dbuser = "myuser";
$dbpassword = "mypasswprd";
$dbname = "mydbname";
$db_link=mysql_connect($hostname, $dbuser, $dbpassword)
or die("Unable to connect to the server!");
mysql_select_db($dbname)
or die("Unable to connect to the database");
$sql = "SELECT `name`, `url` FROM `pixelpost_comments` GROUP BY `name` ORDER BY `id` DESC";
$result = mysql_query($sql);
while($raw = mysql_fetch_array($result))
{
?>
<a href="<?=$row['url']?>">
<?=$row['name']?>
</a> •
<?}?>
thanks,
idneo
