eqdkp latest loot

[Allexandra]

Thank you for the clarification Ryu. 

EDIT:

Changed Line 13 to reflect changes and now I am getting parse errors.

Parse error: parse error, unexpected T_WHILE in /xxxxx/xx/xxxxxxx/htdocs/forums/Sources/Load.php(1746) : eval()'d code(35) : eval()'d code on line 16

Created a dummy php test page, ran it outside of TP/SMF will same result.

Originates from:

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

Much help would be appreciated.  Database values have been verified as correct.

[baderick]

yeah sorry about that il redo it when i get home from work 

[baderick]

Code Select Expand

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

that should work you just need to fill your database name in the

Code Select Expand

$DBName = 'db_eqdkp';

[Allexandra]

Thanks a lot baderick, now I am getting the access denied error, so I will try to figure out what's going on since all of the values are correct in the db variables. 

[baderick]

sorry i noticed it was producing errors in the smf and i tracked it down to my noobishness at php 

these this code needs changing

Code Select Expand


$last_mc_loot = $row[item_name];

$buyer = $row[item_buyer];

to this

Code Select Expand

$last_mc_loot = $row['item_name'];

$buyer = $row['item_buyer'];

baderick

[baderick]

Thanks a lot baderick, now I am getting the access denied error, so I will try to figure out what's going on since all of the values are correct in the db variables. 

i think thats down to database access but im no expert on that

[Allexandra]

I am up against a wall then, db values are correct and getting errors.  I will tinker with it a bit and see if I can get it working for me.  It's a shame because at the moment I have to type the wowitem links manually in the block. Thanks for all the help though. 

[dwoolcott]

I have added the code to a SMF/TP block and the info is being pulled out of the database correctly, but the itemstat info is not processing and showing up literally [item] etc.  Any suggestion?  Does any include need to be added somewhere?

[baderick]

you need itemstats working in smf and tinyportal,  there is a guide on this forum if you do a search on how to do it but i think that uses wowitem from memory.

but if itemstats working correctly it doesnt need the include as seen here

http://judeanpeoplesfront.net

[Ryushi32]

I have searched and searched an cannot find the guide your talking about