Installed the script to a subdomain's root folder:
armory.MYDOMAINNAME.com
loaded the page...
searched for Izzy a known user on my server
recieved an error...
error:
XML Parsing Error: no element found
Location: http://armory.sinful-flesh.com/search.xml?searchQuery=twinkerbell&searchType=all
Line Number 1, Column 1:
------------------------------------------------
config file is set:
--------
/**
* config.inc.php
*
* This file holds the configuration parameters of XMLArsenal
*
* @author Amras Taralom <amras-...@streber24.de>
* @version 1.0, last modified 2010/01/20
* @package XMLArsenal
* @subpackage includes
* @license http://opensource.org/licenses/gpl-3.0.html GNU General
Public License version 3 (GPLv3)
*
*/
//how many errors do you need?
//set to error_reporting(0) for maximum security
//set to error_reporting(E_ALL) for maximum debug info
//standard is error_reporting(E_ALL ^ E_NOTICE) which means everything
but notices
define('ERROR_REPORING', E_ALL ^ E_NOTICE);
//debug mode on?
define("DEBUGMODE", false);
//this is the default language
$language = "en_us";
$realmpool = "Sinful WoW";
$realms = array(
//insert the following line for every realm
you want to appear in the arsenal:
//number => new Realm($realmId = null,
$realmType = null, $realmName = null)
//Type MUST match the name of a
[Type]DataGrabber.class.php for the Arsenal to work (you can write
your own$
1=>new Realm(1, 'Trinity_PVP', 'PvP-Realm'),
// 2=>new Realm(2, 'Trinity_PVE', 'PvE-Realm')
);
//should we use cache-files?
//it is VERY RECOMMENDED to turn this on, it saves A LOT of processing
time, turn OFF for testing purposes
define("USEFILECACHE", true);
define("FILECACHEFOLDER", './cache/'); //don't forget the
tailing slash
define("ALTERNATEDBCACHE", false); //save xml in
the database instead of files (not implemented yet)
define("UPDATEINTERVAL", 4); //interval for
cached information (in hours)
/* the databases:
The currently supported database backends (MDB2) are:
fbsql -> FrontBase
ibase -> InterBase / Firebird (requires PHP 5)
mssql -> Microsoft SQL Server (NOT for Sybase. Compile PHP --with-
mssql)
mysql -> MySQL
mysqli -> MySQL (supports new authentication protocol) (requires PHP
5)
oci8 -> Oracle 7/8/9/10
pgsql -> PostgreSQL
querysim -> QuerySim
sqlite -> SQLite 2
pdoSqlite -> SQLite 3 by Marin Ivanov <met...@metala.org>
*/
$cache_db_type = 'mysql'; //one of the above
types
$cache_db_host = 'localhost'; //db ip or hostname (with port
or without); leave empty for i.e. sqlite
$cache_db_user = 'ArmOrY234'; //the username;
leave empty for i.e. sqlite
$cache_db_pass = 'kaDsHA09'; //the password; leave
empty for i.e. sqlite
$cache_db_base = 'wowsite'; //the db-name; for
sqlite this would be the filepath (remember using forward-slashe$
$data_db_type = 'mysql'; //if you set this to mysql and
have both arsenal dbs on the same host (i.e. localhost) be s$
$data_db_host = '127.0.0.1'; //to
set one to "localhost" and one to "127.0.0.1" for otherwise it$
$data_db_user = 'ArmOrY234'; //
and this may have unforseen consequences
$data_db_pass = 'kaDsHA09';
$data_db_base = 'wowchar';
---------------------------------------------------------------------------------------------------------------------------------------------------------------
now because this wasn't well documented, i assumed the data_db is for
the character database, and the cache_db was for the armory cache
(should probably clerify this in future releases)
as well, there is little documentation for the grabbers...
original grabbers SQL functions:
1)
public function __construct(){
//$this->pvpdbconn = mysql_connect("localhost", "localuser",
"userpassword", true) or die(get_class($this).": no connection to
database.");
//@mysql_select_db("pvp_char", $this->pvpdbconn) or die
(get_class($this).": not able to select specified database.");
//extra passwords
if(file_exists('./classes/dataGrabbers/GrabberConfig.php')) include
'./classes/dataGrabbers/GrabberConfig.php';
@mysql_query("SET NAMES 'utf8'", $this->pvpdbconn);
@mysql_query("SET CHARACTER SET 'utf8'", $this->pvpdbconn);
}
-------------------------------------------------------------------------------------------------------------------------------------------
2)
//$logindb = mysql_connect("localhost", "localuser", "userpassword",
true) or die(get_class($this).": no connection to login database.");
//@mysql_select_db("logon", $logindb) or die (get_class($this).": not
able to select specified database in login db.");
//extra passwords
if(file_exists('GrabberConfig.php')) include 'GrabberConfig.php';
-------------------------------------------------------------------------------------------------------------------------------------------
Notes:
1) there is no GrabberConfig.php included with download, so i don't
see the point in the if exists statement
2) There seems to be a lack of clarification here on which database
should be loaded.. there are currently 3 databases for TrinityCore:
My db | trinity default name | function
--------------------------------------------------------------
wowlogon - realm - realmlist, account, version information
wowchar - character - character information
wowworld - world - database for creatures, objects, spawns and
such
so... to sumerize my questions:
1) which databases should the information in the config be filled out
for?
2) in the grabbers, which database information should be put into
which statement, and couldn't it possibly be easier to incorperate
that info into the config as variables?
i.e. config.inc.php =
// database info:
// Character Database
$cdb_un = "database username"; //user name for Character Database
$cdb_pass = "database pass"; //password for Character database
$cdb_hn = "database hostname"; //hostname for Character database
(usually 127.0.0.1 or localhost)
$cdb = "databasename"; //name of the Character database
// World Database
$wdb_un = "database username"; //user name for World Database
$wdb_pass = "database pass"; //password for World database
$wdb_hn = "database hostname"; //hostname for World database (usually
127.0.0.1 or localhost)
$wdb = "databasename"; //name of the World database
// Realm Database
$rdb_un = "database username"; //user name for Realm Database
$rdb_pass = "database pass"; //password for Realm database
$rdb_hn = "database hostname"; //hostname for Realm database (usually
127.0.0.1 or localhost)
$rdb = "databasename"; //name of the Realm database
// Cache Database
$cachedb_un = "database username"; //user name for Cache Database
$cachedb_pass = "database pass"; //password for Cache database
$cachedb_hn = "database hostname"; //hostname for Cache (usually
127.0.0.1 or localhost)
$cachedb = "databasename"; //name of the Cache database
then, in the grabbers, you can just use $blah in place of the users
having to edit that file as well...
Just an idea
broken links:
LINK: Emblem of heroism rewards:
URL: /search.xml?
fl[source]=dungeon&fl[dungeon]=emblemofheroism&fl[type]=all&fl[rrt]=all&fl[rqrMin]=&fl[rqrMax]=&fl[usbleBy]=all&advOptName=none&fl[andor]=and&searchType=items&fl[advOpt]=none
ERROR: Possible SQL-Injection detected! If this is a false positive
please feel free to contact AmrasTaralom.
LINK: Emblem of Valor rewards:
URL: /search.xml?
fl[source]=dungeon&fl[dungeon]=emblemofvalor&fl[type]=all&fl[rrt]=all&fl[rqrMin]=&fl[rqrMax]=&fl[usbleBy]=all&advOptName=none&fl[andor]=and&searchType=items&fl[advOpt]=none
ERROR: Possible SQL-Injection detected! If this is a false positive
please feel free to contact AmrasTaralom.
LINK: Heirloom Items
URL: /search.xml?
fl[source]=all&fl[type]=all&fl[usbleBy]=all&fl[rqrMin]=&fl[rqrMax]=&fl[rrt]=hm&advOptName=none&fl[andor]=and&searchType=items&fl[advOpt]=none
ERROR: Possible SQL-Injection detected! If this is a false positive
please feel free to contact AmrasTaralom.