IPB Unreal Portal Blocks

Invision Power Board integration forum

IPB Unreal Portal Blocks

Postby Sorian » Wed Feb 21, 2007 1:06 am

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 :)
User avatar
Sorian
WR.net Apprentice
WR.net Apprentice
 
Posts: 18
Joined: Thu Nov 23, 2006 5:04 am

IPB Unreal Portal Blocks

Postby FayeVixen » Wed Feb 21, 2007 10:40 am

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.
Last edited by FayeVixen on Wed Feb 21, 2007 10:56 am, edited 1 time in total.
<embed src="http://www.davesite.com/webstation/html/davesite.wav" loop="true" autoplay="false" width="145" height="60"></embed>
User avatar
FayeVixen
WR.net Apprentice
WR.net Apprentice
 
Posts: 1
Joined: Wed Feb 21, 2007 10:34 am

IPB Unreal Portal Blocks

Postby Sorian » Mon Mar 26, 2007 9:55 pm

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.
User avatar
Sorian
WR.net Apprentice
WR.net Apprentice
 
Posts: 18
Joined: Thu Nov 23, 2006 5:04 am

Re: IPB Unreal Portal Blocks

Postby Sorian » Sat Oct 20, 2007 4:10 am

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
User avatar
Sorian
WR.net Apprentice
WR.net Apprentice
 
Posts: 18
Joined: Thu Nov 23, 2006 5:04 am

IPB Unreal Portal Blocks

Postby Sorian » Mon Jan 07, 2008 4:18 pm

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

hit me up if you want the php.
User avatar
Sorian
WR.net Apprentice
WR.net Apprentice
 
Posts: 18
Joined: Thu Nov 23, 2006 5:04 am

IPB Unreal Portal Blocks

Postby cwpc » Thu Jan 10, 2008 11:24 pm

Id like that PHP.

I would also like to see if anyone has any other Blocks?
Image
Image
Image
User avatar
cwpc
WR.net Expert
WR.net Expert
 
Posts: 151
Joined: Wed Jun 13, 2007 9:07 pm
Location: The Edge of Insanity

IPB Unreal Portal Blocks

Postby cwpc » Tue Feb 05, 2008 2:22 am

Anyone have any information?
Image
Image
Image
User avatar
cwpc
WR.net Expert
WR.net Expert
 
Posts: 151
Joined: Wed Jun 13, 2007 9:07 pm
Location: The Edge of Insanity

IPB Unreal Portal Blocks

Postby Sorian » Sun Feb 24, 2008 11:54 pm

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.
Last edited by Sorian on Sun Feb 24, 2008 11:58 pm, edited 2 times in total.
User avatar
Sorian
WR.net Apprentice
WR.net Apprentice
 
Posts: 18
Joined: Thu Nov 23, 2006 5:04 am


Return to IPB

Who is online

Users browsing this forum: No registered users and 0 guests

cron