eqdkp latest loot

[baderick]

this code i use for my world of warcraft guild ive adapted it from my joomla site to work with tiny portal as im gonna move over to it soon you will need to have eqdkp installed on your website to use this code and itemstats working in tinyportal.

this will grab the latest loot you have submitted to eqdkp and display it on your main page you can select how many it displays by changing $limit . you will also need to put your eqdkp db username, password and database name to get this to work.

Make a php block and use the php below

Code Select Expand


// db config

$linkmoreloot = '';
$DBhost = 'localhost';
$DBuser = 'db_username';
$DBpass = 'db_password';
$DBName = 'db_eqdkp';
$limit = 10;
$eqdkp_prefix = 'eqdkp_';

//create the new database connection

$result = mysql_query("SELECT item_name, item_buyer FROM ".$DBName.".".$eqdkp_prefix."items order by item_date desc limit $limit") or die(mysql_error());


while ($row = mysql_fetch_array($result)) {

$last_mc_loot = $row['item_name'];

$buyer = $row['item_buyer'];

$myhtml = "<span style=\"font-size:10px;font-family: Arial, Helvetica, sans-serif;\">[item]".$last_mc_loot."[/item]</span><br /><span style=\"font-size:9px;font-family: Arial, Helvetica, sans-serif;\">Looted  by ".$buyer."</span><br />";

echo itemstats_parse($myhtml);

}

mysql_close();



you can see it working here on my test forum www.judeanpeoplesfront.net/forums

my first code for tinyportal so be gental  

[G6Cad]

And you have to add how to make it work to.
that code is basicly just a DB install file and not a block code.

Specify how to get this to work in what sort of code block

[baderick]

is that better?

[babjusi]

What does eqdkp mean?

[baderick]

heres a link to the eqdkp website http://eqdkp.com/?p=about im sure it can explain it better than i can.

[G6Cad]

Much better

[Ryushi32]

this code i use for my world of warcraft guild ive adapted it from my joomla site to work with tiny portal as im gonna move over to it soon you will need to have eqdkp installed on your website to use this code and itemstats working in tinyportal.

this will grab the latest loot you have submitted to eqdkp and display it on your main page you can select how many it displays by changing $limit . you will also need to put your eqdkp db username, password and database name to get this to work.

Make a php block and use the php below

Code Select Expand


// db config

$linkmoreloot = '';
$DBhost = 'localhost';
$DBuser = 'db_username';
$DBpass = 'db_password';
$DBName = 'db_eqdkp';
$limit = 10;
$eqdkp_prefix = 'eqdkp_';

//create the new database connection

$result = mysql_query("SELECT item_name, item_buyer FROM jqipjisr_eqdkp2.".$eqdkp_prefix."items order by item_date desc limit $limit") or die(mysql_error());


while ($row = mysql_fetch_array($result)) {

$last_mc_loot = $row[item_name];

$buyer = $row[item_buyer];

$myhtml = "<span style=\"font-size:10px;font-family: Arial, Helvetica, sans-serif;\">[item]".$last_mc_loot."[/item]</span><br /><span style=\"font-size:9px;font-family: Arial, Helvetica, sans-serif;\">Looted  by ".$buyer."</span><br />";

echo itemstats_parse($myhtml);

}

mysql_close();



you can see it working here on my test forum www.judeanpeoplesfront.net/forum

my first code for tinyportal so be gental 

How do you get itemstats working in tinyportal?

[G6Cad]

Ryushi32  Please start a new topic about that question.

[Allexandra]

I am unable to connect to the database.  Not an SQL expert by any means, so I was wondering if this piece of information needs to be altered in any way.

Line 13

$result = mysql_query("SELECT item_name, item_buyer FROM jqipjisr_eqdkp2.".$eqdkp_prefix."items order by item_date desc limit $limit")

jqipjisr_eqdkp2

Thanks for your help.

[Ryushi32]

Yes it needs to be

Code Select Expand

$result = mysql_query("SELECT item_name, item_buyer FROM ".$eqdkp_prefix."items order by item_date desc limit $limit")

that extra part was for baderick's database.