Hello
I have also posted this on the vBadvanced CMPS forum a couple of days ago but it seems no one can help me there, hopefully someone here can
I have this PHP file I would like to run in a module (vBadvanced CMPS v3.0.1+vBulletin 3.6.8) on our Lord of the Rings Online kinship page but I can't get it to work and I don't know why.
It works fine if I just open it in the web browser but as soon as I put it in a module I get errors.
The PHP file get data from another database (EQdkp-plus) (
http://www.x672.net/the-forgotten/eqdkp/)
http://x672.net/the-forgotten/modules/raid_tracker.php
PHP Code:
<?php
/******************************
* EQDKP HomepageTools 1.1.0
* (c) 2006 - 2007 by kompsoft media
* Licensed under the GNU GPL.
* See COPYING for full terms.
* ------------------
* $Id: raid_tracker.php 290 2007-06-14 14:12:12Z wallenium $
******************************/
include_once('config.php');
include_once('include/hptools.class.php');
include_once('language/'.$config['language'].'.php');
$hpt = new HomepageTools($htdb['host'], $htdb['user'], $htdb['pass'], $htdb['datab'], $htdb['prefix'], $config, $htlang);
echo $hpt->event_tracker();
?>
the config.php file.
PHP Code:
<?php
/******************************
* EQDKP HomepageTools 1.1.0
* (c) 2006 - 2007 by kompsoft media
* Licensed under the GNU GPL.
* See COPYING for full terms.
* ------------------
* $Id: config.php 296 2007-06-15 22:42:51Z wallenium $
******************************/
/******************************
* General Settings
******************************/
$htdb['host'] = "mysql.hosted.servetheworld.net:3306"; // Host
$htdb['user'] = "X672net_eclipse"; // Username of SQL
$htdb['pass'] = "Password removed"; // User Password
$htdb['datab'] = "X672net_eqdkp"; // database
$htdb['prefix'] = "eqdkp_"; // database prefix
// if in the same database as the CMS you want to include this script
// set it to 0! If not, you might get errors because of closing the
// database table.
$config['other_table'] = 0;
/******************************
* TIME SETTINGS
******************************/
$config['local'] = "de_DE"; // Local settings
$config['strftime'] = "%d.%m.%Y, %H:%M"; // time format of strftime()
/******************************
* GLOBAL SETTINGS
******************************/
// URL to DKP
$config['url'] = "http://www.x672.net/the-forgotten/eqdkp/";
// Path to itemstats
$config['is_path'] = "./eqdkp/itemstats";
// Path to homepagetools
$config['ht_path'] = "http://www.x672.net/the-forgotten/modules";
//Language
$config['language'] = "english";
// The Rest
$config['is_plus'] = 1; // EQDKP PLUS 0.4.3.x oder h?her?
$config['sort'] = "ASC"; // ASC = Ascending, DESC = descending
$config['is_img_path'] = "./"; // Path to the images, if you 're using ustom paths' (with ending slash)
$config['newwindow'] = 1; // Open Links in new window?
/******************************
* ITEM TRACKER
******************************/
$config['limit_by'] = "days"; // LIMIT BY:? (days, items, raid, dkp)
$config['item_number'] = 10; //How many days/items/raid (see option above) of raiding do you wish to show? (1 or more)
// settings :D
$config['showdays'] = 1; // Do you want to see the date of the raid? (1=yes 0=no)
$config['showheader'] = 1; // Do you want to see Name of each Raid?? (1=yes 0=no)*/
$config['uberloot'] = 2; // What loot should show. 0=green and above(default), 1=blue and above, 2=epic and above
$config['showwinner'] = 0; // Do you want to see who won the loot (1=yes 0=no)
$config['linkitem'] = 1; // Do you want to link to the item dkp page from the block? (1=yes 0=no)
$config['showDKP'] = 0; // Do you want to show the DKP Value at the list? (1=yes 0=no)
$config['textcolor'] = 0; // Show only the colored item name, no popup
/******************************
* RAID TRACKER
******************************/
$config['limit'] = "3"; // set the amount of entries to show
$config['link_calendar'] = 0; // Show a Link to the listraids.php
$config['show_tooltip'] = 1; // Show Tooltip with more information
/******************************
* BOSS TRACKER
******************************/
$config['view_kill_times'] = 0; // Do you want to see how often a boss was killing? (1=yes 0=down/waiting)
?>
So I got the raid_tracker.php to work but when I try to put it inside a module I just get this when I go to the kinship page. (
www.x672.net/the-forgotten/) (vBulletin 3.6.8)
EQdkp-plus have it's own database that the PHP file is connecting to and is not the same one I use for vBadvanced CMPS v3.0.1
Code:
Database error in vBulletin 3.6.8:
Invalid SQL:
SELECT IF(votenum >= 1, votenum, 0) AS votenum, IF(votenum >= 1 AND votenum != 0, votetotal / votenum, 0) AS voteavg, votetotal, threadid, firstpostid
FROM mst_thread AS thread
WHERE visible = 1
AND open != 10
AND (thread.forumid IN(8)
)
ORDER BY dateline DESC
LIMIT 5;
MySQL Error : Table 'X672net_eqdkp.mst_thread' doesn't exist Error Number : 1146
Date : Tuesday, March 16th 2010 @ 09:29:11 AM
Script : http://x672.net/the-forgotten/
Referrer : http://x672.net/the-forgotten/
IP Address : XXX.XXX.XXX.XXX
Username : Gattsu
Classname : vB_Database
I have very limited PHP/vB skills so any help at all would be appreciated
More Information