EuroPk
01-06-2008, 03:53 PM
Basically i wanna make a plugin that will work off sql data.
http://img232.imageshack.us/img232/8103/test1bn3.png
$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 1199648961 at 1199648961 ---------------
any help would be great....
--------------- Added 1199649219 at 1199649219 ---------------
anyone that knows how to do this!?!?
http://img232.imageshack.us/img232/8103/test1bn3.png
$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 1199648961 at 1199648961 ---------------
any help would be great....
--------------- Added 1199649219 at 1199649219 ---------------
anyone that knows how to do this!?!?