[EuroPk]

Basically i wanna make a plugin that will work off sql data.




$database = mysql_connect ('localhost','ihpk_' ,'');
mysql_select_db ('ihpk_', $database );
$SelectString = "SELECT * FROM pklog ORDER by id DESC";
$pkliste_result = mysql_query($SelectString);
$pkliste = mysql_fetch_array ( $pkliste_result);

$groupidfetch_result = mysql_query(sprintf("SELECT * FROM user WHERE username = '%s'", $pkliste['killer']));

$groupidfetch = mysql_fetch_array ( $groupidfetch_result );
$UserGroupID = $groupidfetch['usergroupid'];
$tagfetch_result = mysql_query("SELECT * FROM usergroup WHERE usergroupid = ".$UserGroupID);

$tagfetch = mysql_fetch_array( $tagfetch_result);
$killer = $tagfetch['opentag']. $pkliste['killer'] . "</b></font>";

$lastpk="<a href=pklog.php><center><font color=red><b><u>Our Last Victim</b></u></center></font></a><br>".$pkliste['o_name']. " a Level ".$pkliste['o_level']." ". $pkliste['o_typ'] ." was slain by <a href=pklog.php?viewname=".$pkliste['killer'].">".$killer."</a> on <a href=pklog.php?realm=" . $pkliste['realm'] . ">".$pkliste['realm']. "</a> at <a href=pklog.php?sort=time>". $pkliste['zeit'] . "</a>";



Now this modification i have being runned from vbulletin global , style_fetch


If anyone has any info they can give me i'd appreicate it.


thanks.

--------------- Added [DATE]1199648961[/DATE] at [TIME]1199648961[/TIME] ---------------

any help would be great....

--------------- Added [DATE]1199649219[/DATE] at [TIME]1199649219[/TIME] ---------------

anyone that knows how to do this!?!?