have recently started using Unreal Portal for IPB and it has functionality built in to create custome php blocks, right now I have a block (though invisible for the time being) for the latest loot, I would like to see blocks developed for a few things from the roster such as:

top 5-10-15 HK block (formated with name, class, lvl, and kills)
EventCalendar block (with events and when clicked on would go to the designated event in on the Event Calendar mod for WoWRoster.)

I mean techincally you could create blocks for many other of the mods too.... but the above are just the ones that I would like to see for my own site... unfortunatly I am not much of a php coder :/

for those curious about the code used for the latestloot block for IPB:
Source: http://forums.eqdkp.com/lofiversion/ind ... t7297.html

Code: Select all

<?
include_once('../eqdkp/itemstats/eqdkp_itemstats.php');

$result = mysql_query("SELECT * FROM eqdkp_items ORDER BY item_id DESC LIMIT 0 , 10");

while($r=mysql_fetch_array($result))
{
$item_name=$r["item_name"];
$item_buyer=$r["item_buyer"];

echo itemstats_decorate_name($item_name) . " - $item_buyer<br>";
}
?>

looking at it it seems very simple... now if we could only get ones just as simple for some of the wowroster features and mods

Well I'm looking into the way some of what you are asking for might work, testing some scripts tonight and may have some answers by morning, and if not this is a useless post haha... Just wanted to let you know your not being ignored so far.

anyone know how to create a standalone file that pulls basic pvp stats, and GroupCalendar upcoming events information from the roster database? it is possible to create a block by using a php include tag.

Sorian wrote:anyone know how to create a standalone file that pulls basic pvp stats, and GroupCalendar upcoming events information from the roster database? it is possible to create a block by using a php include tag.

bump

actually changed this script a bit check it out at our site portal www.myrkridia.com

hit me up if you want the php.

Id like that PHP.

I would also like to see if anyone has any other Blocks?

Anyone have any information?

here is my latest loot block for unreal portal code:

Code: Select all

<link rel="stylesheet" href="dkp/itemstats/templates/wowhead.css" type="text/css"\>

<script type="text/javascript" src="dkp/itemstats/overlib/overlib.js"></script>
<?php
include_once('dkp/itemstats/eqdkp_itemstats.php');

$hostname="localhost";
$mysql_login="db login here";
$mysql_password="db psw here";
$database="db name here";

// connect to the database server
if (!($db = mysql_pconnect($hostname, $mysql_login , $mysql_password))){
  die("Can't connect to database server.");   
}else{
  // select a database
    if (!(mysql_select_db("$database",$db))){
      die("Can't connect to database.");
    }
}
$result = mysql_query("SELECT * FROM eqdkp_items ORDER BY item_id DESC LIMIT 0 , 10");

while($r=mysql_fetch_array($result))
{
$item_name=$r["item_name"];
$item_buyer=$r["item_buyer"];
$item_cost=$r["item_value"];
$item_dec=itemstats_decorate_name($item_name);

echo "<p> $item_dec <br> to: <a href='http://www.myrkridia.com/dkp/viewmember.php?s=&name=$item_buyer'> $item_buyer </a> - for: $item_cost DKP<br></p>";
}
?>


I modified the code a bit to include the purchase price of the item as well pulled from the EQDKP database.

also you want to change the
http://www.myrkridia.com/dkp/viewmember ... item_buyer
to what ever link links to your website's users through eqdkp. click on a user using your eqdkp site and you will understand the meaning of this. just what ever you do, don't forget to put the $item_buyer tag instead of the character name so that it links to the right profile on your eqdkp site.