Re: Digest for xmlarsenal-discuss@googlegroups.com - 2 Messages in 1 Topic

5 views
Skip to first unread message

ArcAiN6

unread,
Mar 26, 2010, 3:14:45 AM3/26/10
to xmlarsena...@googlegroups.com
also noticed that if i try to do a search or login from internet
explorer, i get page cannot be displayed

I noticed that the live demo works, what exactly could i be doing wrong
here?
Is this project still being supported?

Amras Taralom

unread,
Mar 26, 2010, 5:13:51 AM3/26/10
to xmlarsena...@googlegroups.com
hi,

the project is still supported, but it's depending on my time.
the live version of course works, and its the same version beta5 you can
download at the google code page.

it is NOT possible to include grabber config in the config file cause that
would break separation between grabbers and the arsenal. grabbers fetch
data - arsenal works with that data, transforms it and displays the result.
so you can have different grabbers for different emulators, relams and even
different database types.

the problem with the links is known, as blizzard changes these very often.
but they're not too important ;)

ok concerning databases in the config file...
data_db is for the arsenalsdata.sqlite or its mysql-pendant. it's full of
data and nerver changes.
cache_db is for storing cached arsenal entries, its empty at the start.

in the grabber you have to put the data of your ACTUAL realm (characters
database and logon database).


I hope that helps...
Greetings, Amras.


--------------------------------------------------
From: "ArcAiN6" <arc...@gmail.com>
Sent: Friday, March 26, 2010 8:14 AM
To: <xmlarsena...@googlegroups.com>
Subject: Re: Digest for xmlarsena...@googlegroups.com - 2 Messages in
1 Topic

> To unsubscribe from this group, send email to
> xmlarsenal-discuss+unsubscribegooglegroups.com or reply to this email with
> the words "REMOVE ME" as the subject.

ArcAiN6

unread,
Mar 26, 2010, 2:31:17 PM3/26/10
to xmlarsenal-discuss
ok.. that defanately changed the error i was getting... now i see:

MDB2 Error: no such table

here's what i did:
----------------------------

imported the arsenaldata.sql into WOWSITE database (database for my
site and cache)
changed the config.inc.php file:
|_commented out PVE realm
|_changed first database to point to WOWSITE on localhost
|_changed second database to point to WOWSITE on 127.0.0.1

Changed classes/datagrabbers/Trinity_PVPDataGrabber.class.php
|__made first database block point to my characters database
|__made second database block point to my realm database

did i miss soemthing?

----------------------------------------
PVP Data Grabber Excerpt
----------------------------------------
public function __construct(){

$this->pvpdbconn = mysql_connect("localhost", "agringa",
"gribblebop", true) or die(get_class($this).": no connection to
database."$
@mysql_select_db("wowchar", $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);
}


/* account tables */

public function tryLogin($user,$password){

if((strlen($user) < 3) || $password == null){
return false;
}if // Not sure if this needed uncommented or not...

$logindb = mysql_connect("localhost", "arginga", "gribblebop",
true) or die(get_class($this).": no connection to login database$
@mysql_select_db("wowlogon", $logindb) or die
(get_class($this).": not able to select specified database in login
db.");

//extra passwords

ArcAiN6

unread,
Mar 26, 2010, 3:08:49 PM3/26/10
to xmlarsenal-discuss
hrmn..... ok... so i forgot to add the SQL from here:
http://code.google.com/p/xmlarsenal/wiki/SQLStructure
just added it, and now the error is changed back to what it was...

error:
------------------------------------------------------------------------------------------------------------------------------------
XML Parsing Error: no element found
Location: http://armory.sinful-flesh.com/search.xml?searchQuery=izzy&searchType=all
Line Number 1, Column 1:
^
------------------------------------------------------------------------------------------------------------------------------------

so before i assume it was complaining that the cache_db tables weren't
there, now it just can't find anything within the tables...

Skatpot

unread,
Mar 27, 2010, 3:59:45 AM3/27/10
to xmlarsenal-discuss
Same error here:

"MDB2 Error: already exists
^"

What should i do?

Amras Taralom

unread,
Mar 27, 2010, 8:25:31 AM3/27/10
to xmlarsena...@googlegroups.com
Your config looks ok for me... i don't really know why there is such an
error. maybe turn on (E_ALL) error reporting to see what's happening. (no
element in xml means there is no output whatsoever).


--------------------------------------------------
From: "ArcAiN6" <arc...@gmail.com>
Sent: Friday, March 26, 2010 8:08 PM
To: "xmlarsenal-discuss" <xmlarsena...@googlegroups.com>


Subject: Re: Digest for xmlarsena...@googlegroups.com - 2 Messages in
1 Topic

> hrmn..... ok... so i forgot to add the SQL from here:

ArcAiN6

unread,
Mar 27, 2010, 5:07:27 PM3/27/10
to xmlarsenal-discuss
woah... i opened config.inc.php and changed it to:
define('ERROR_REPORING', E_ALL);
now when i try to pull up the site, i get that error right off the
bat.. no search or anything

ERROR:


XML Parsing Error: no element found
Location: http://armory.sinful-flesh.com/

Line Number 1, Column 1:
^

when i put it back to define('ERROR_REPORING', E_ALL ^ E_NOTICE); the
site will pull up again
--------------

Turning debug mode to true has no effect at all
--------------
installed packages:

mysql-5.0.77-4.el5_4.2
php-5.2.11-1
php-pear-1.7.2-3
php-xml-5.2.11-1
php-pear-XML-Beautifier-1.1-1
php-pear-XML-Parser-1.2.7-4
php-pear-XML-RSS-0.9.10-2
php-pear-XML-Serializer-0.18.0-2
php-pear-XML-Util-1.1.1-1
httpd-2.2.3-31.el5.centos.2 - (apache2 CentOS 5.4 flavor)

there are other odds and ends, but that should do for now..
also not seeing any errors in the httpd error / access / suexec logs

Message has been deleted

ArcAiN6

unread,
Mar 27, 2010, 10:08:18 PM3/27/10
to xmlarsenal-discuss
Turned on display errors in php.ini, restarted webserver, and reloaded
the page and i see this error:

XML Parsing Error: junk after document element
Location: http://armory.sinful-flesh.com/
Line Number 2, Column 1:<b>Notice</b>: Undefined index: r in <b>/var/
www/vhosts/sinful-flesh.com/subdomains/armory/httpdocs/includes/
functions.inc.php</b> on line <b>102</b><br />
^
----------------------

foreach($realms as $realm){
if($realm->realmName == $_GET['r']){ <------------LINE 102
$usedRealm = $realm->realmId;
$realmName = $realm->realmName;
break;
}//if
}//foreach


not sure if this is related, but thought i would post it in case

Amras Taralom

unread,
Feb 28, 2010, 8:05:44 AM2/28/10
to xmlarsena...@googlegroups.com
hm, if this occurs when calling a character sheet it means you're missing a
realm. which is in fact a problem :D
in config.inc.php you should have at least one realm:

$realms = array(

1=>new Realm(1, 'NameOfTheDataGrabber', 'CustomNameOfYourRealm')
);

after inserting that you should turn errors at least back to E_ALL ^
E_NOTICE (otherwise you'll get lots of errors).


by the way i'm using XML+XSLT but the xsl-transformation is done on the
client pc so you don't need any xsl-modules on the server.


Greetings, Amras.


--------------------------------------------------
From: "ArcAiN6" <arc...@gmail.com>
Sent: Sunday, March 28, 2010 3:08 AM


To: "xmlarsenal-discuss" <xmlarsena...@googlegroups.com>
Subject: Re: Digest for xmlarsena...@googlegroups.com - 2 Messages in
1 Topic

> Turned on display errors in php.ini, restarted webserver, and reloaded

ArcAiN6

unread,
Apr 2, 2010, 3:02:01 AM4/2/10
to xmlarsenal-discuss
ya.. i have that.. still not working correctly for me...

[code]

$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', 'Reaper')

);

[/code]

On Feb 28, 9:05 am, "Amras Taralom" <amras-tara...@streber24.de>
wrote:


> hm, if this occurs when calling a character sheet it means you're missing a
> realm. which is in fact a problem :D
> in config.inc.php you should have at least one realm:
>
> $realms = array(
>
> 1=>new Realm(1, 'NameOfTheDataGrabber', 'CustomNameOfYourRealm')
>                 );
>
> after inserting that you should turn errors at least back to E_ALL ^
> E_NOTICE (otherwise you'll get lots of errors).
>
> by the way i'm using XML+XSLT but the xsl-transformation is done on the
> client pc so you don't need any xsl-modules on the server.
>
> Greetings, Amras.
>
> --------------------------------------------------

> From: "ArcAiN6" <arca...@gmail.com>

Amras Taralom

unread,
Apr 3, 2010, 1:37:35 PM4/3/10
to xmlarsena...@googlegroups.com
hi,

well, i can't probably guess what's wrong without having a look at your
system. you could send me logon data for your server in private (not google
groups) if you think you can trust me xD
otherwise i don't know how to help from that point on :(

Greetings, Amras.


--------------------------------------------------
From: "ArcAiN6" <arc...@gmail.com>
Sent: Friday, April 02, 2010 9:02 AM

ArcAiN6

unread,
Apr 3, 2010, 5:22:51 PM4/3/10
to xmlarsenal-discuss
information is in the e-mail.. i sent it to the e-mail address on
your profile.

On Apr 3, 1:37 pm, "Amras Taralom" <amras-tara...@streber24.de> wrote:
> hi,
>
> well, i can't probably guess what's wrong without having a look at your
> system. you could send me logon data for your server in private (not google
> groups) if you think you can trust me xD
> otherwise i don't know how to help from that point on :(
>
> Greetings, Amras.
>
> --------------------------------------------------

> From: "ArcAiN6" <arca...@gmail.com>

Reply all
Reply to author
Forward
0 new messages