My EQDKP Install

Roster Install

Using:

Mod: rpgo-GuildProfiler_1.6.0
EQDKP: 1.3.1
Roster: 1.7.0
My database meets all the requirements for the Roster install.

I want to create an EQDKP page that pulls the data from the Roster database, I already have all the CSS and integration setup for the EQDKP site, I don't want to have to work the whole Roster page over.... just to get it to match...

Posted in the Forums is:

Code: Select all


<?php
require("includes/config.php"); // This is where my MYSQL connection is THE SAME DATABASE AS WOWROSTER INSTALLED
require("header.php"); // Everything in the file "header.php" will be displayed BEFORE the content

$getroster1 = mysql_query("SELECT guild_title FROM roster_members GROUP BY guild_title ORDER BY guild_rank ASC");
// Query that groups the GUILD TITLES of the members (so you dont have more than one block per title) ORDER them by GUILD ID Meaning that the importantest persons are on top

while($r=mysql_fetch_array($getroster1)){ // While your rows from the table

$getroster2 = mysql_query("SELECT name,level,class,guild_title FROM roster_members WHERE guild_title='".$r['guild_title']." ORDER BY level DESC'");
// Get all of the information u are willing to display the block of the Guild Rank ORDERED by level (HIGHEST ONES ON TOP)

echo("<table width='100%'  border='0' cellpadding='4' cellspacing='0' class='content'>
  <tr>
    <td width='100%' colspan='4' class='content-top'><b>".$r['guild_title']."</b></td>
  </tr>
  <tr>
    <td width='25%' class='content-contents4'><strong>Name:</strong></td>
    <td width='25%' class='content-contents4'><strong>Level: </strong></td>
    <td width='25%' class='content-contents4'><strong>Class: </strong></td>
    <td width='25%' class='contents-bottom'><strong>Rank:</strong></td>
  </tr>"); // While The beginning of the block with the name of the Rank ur about to display..

while($rt=mysql_fetch_array($getroster2)){ // Get all of the information u are willing to display inside the block of the Guild Rank
extract($rt);//remove the $r so its just $variable
echo("<tr>
    <td width='25%' class='content-contents4'>$name</td>
    <td width='25%' class='content-contents4'>$level</td>
    <td width='25%' class='content-contents4'>$class</td>
    <td width='25%' class='contents-bottom'>$guild_title</td>
  </tr>");
} // Close While information

echo("</table>
<br>");

} // Close While Block

require("footer.php"); // Everything in the file "footer.php" will be displayed AFTER the content
?>


I want to do the same fuction, I can handle all the header and footer coding, but I am still having some issues. The includes/config.php doesn't exist in the install of the Roster anymore, or it has moved and been renamed....

Can I get some help with this, I'm sure it is very simple, but PHP isn't my niche.....

I just want to reach into the Roster database and pull the Name, Rank, Level, Class, and Last_Online to enter into a PHP page that I integrate into my EQDKP site, the only reason I need the install is for the database build and to have the ability to update the roster.

Can anyone help me please.
Green

Anyone?

I guess I might try an include on one of my PHP pages and then gut the roster page I pull in to meet needs.... hand't thought of that....

Green

Theoredically, that code should work

I don't anything EQDKP so I can't help much on how to build additional pages into to, or how to integrate the data from roster into eqdkp

Here is my issue, I'm not sure what goes in the

includes/config.php

there is an EQDKP config.php in the includes folder of the EQDKP install, but my roster and EQDKP are in seperate databases. So create a configroster.php identical to the EQDKP except with the database info for the roster database?

like ~

Code: Select all

require("includes/configroster.php");
 

I'll play with this tonight, but I'm not sure how to source the page from the EQDKP structure and grab the data from the WoWRoster Database.

Thanks for the response,
Green

oh, use the conf.php file from roster

So just use the full path to pull it from the roster

Code: Select all

require("http://roster.libertas-manus.net/admin/config.php");
 

and then update the table *prefix* to match my table structure...

So the end result:

Code: Select all


<?
require("http://roster.libertas-manus.net/admin/config.php"); // This is where my MYSQL connection is THE SAME DATABASE AS WOWROSTER INSTALLED
require("header.php"); // Everything in the file "header.php" will be displayed BEFORE the content

$getroster1 = mysql_query("SELECT guild_title FROM *prefix*_members GROUP BY guild_title ORDER BY guild_rank ASC");
// Query that groups the GUILD TITLES of the members (so you dont have more than one block per title) ORDER them by GUILD ID Meaning that the importantest persons are on top

while($r=mysql_fetch_array($getroster1)){ // While your rows from the table

$getroster2 = mysql_query("SELECT name,level,class,guild_title FROM *prefix*_members WHERE guild_title='".$r['guild_title']." ORDER BY level DESC'");
// Get all of the information u are willing to display the block of the Guild Rank ORDERED by level (HIGHEST ONES ON TOP)

echo("<table width='100%'  border='0' cellpadding='4' cellspacing='0' class='content'>
  <tr>
    <td width='100%' colspan='4' class='content-top'><b>".$r['guild_title']."</b></td>
  </tr>
  <tr>
    <td width='25%' class='content-contents4'><strong>Name:</strong></td>
    <td width='25%' class='content-contents4'><strong>Level: </strong></td>
    <td width='25%' class='content-contents4'><strong>Class: </strong></td>
    <td width='25%' class='contents-bottom'><strong>Rank:</strong></td>
  </tr>"); // While The beginning of the block with the name of the Rank ur about to display..

while($rt=mysql_fetch_array($getroster2)){ // Get all of the information u are willing to display inside the block of the Guild Rank
extract($rt);//remove the $r so its just $variable
echo("<tr>
    <td width='25%' class='content-contents4'>$name</td>
    <td width='25%' class='content-contents4'>$level</td>
    <td width='25%' class='content-contents4'>$class</td>
    <td width='25%' class='contents-bottom'>$guild_title</td>
  </tr>");
} // Close While information

echo("</table>
<br>");

} // Close While Block

require("footer.php"); // Everything in the file "footer.php" will be displayed AFTER the content
?>


Then edit the CSS and I should be good, does this look right?

Green

it needs to be a local path to that file, not a url path

mmkai, thanks a bunch for the help, I'll work on this tonight, if it works ok, I'll post the code here for anyone in the future that wants to use it.

Green

any further action on this?