com_wowroster - Joomla 1.0.x Integration

Joomla/Mambo integration forum

com_wowroster - Joomla 1.0.x Integration

Postby Nefuh » Tue Jan 22, 2008 12:03 am

Hey,

I have written a component that fully integrate the Roster (actuall Roster 2.0.2) into Joomla.

Now on account of an inquiry on http://www.wowroster.de there is a new version (based on the Version 2.0.2 and interface Image Pack 3.2.0).

Features:

* Using Joomla integrated authorizing to authorized in Roster
* For members with the Joomla rights "Administrator" or "Super Administrator" there´s no need to enter a password for guildupdate or to enter the configuration panel.
* All "registered" Members of the site, will be automaticly authorized as "guild" in roster, so there could for example view the guildvault without menter as password.
* If "Guest" will be look into the guildvault, go to the configuration panel, or do a guildupdate, they must be enter the defined password.

New Version tested on a windows machine (Vista with Xampp) and Joomla 1.0.15

Please give a report back, even when there are no errors and all works :!:

Notice:

Nowadays it is indicated of the Roster with a width by 630px, within the Joomla Templates. One can change this value simply arbitrarily, it should be necessary. More information in the enclosed text file. (Translated from german by Abacho)

Here is the Link to download -> go to WoW Roster Integration -> Joomla -> com_wowroster_2_0_2_first_unzip.zip

Nefuh

Edits:

*For support in german go to http://www.wowroster.de
*Edit Post, because of new version of this joomla component
Last edited by Nefuh on Fri Sep 04, 2009 9:52 pm, edited 5 times in total.
Administrator of the german User2User Community for WoWRoster.
Guild Master from Scum from Hell - Horde @ EU-Anetheron.
User avatar
Nefuh
WoWRoster.net Dev Team
WoWRoster.net Dev Team
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 213
Joined: Fri Sep 15, 2006 8:34 pm
Location: Krefeld Germany

Re: Looking for some BETA Testers for Joomla component!

Postby Trefynwed » Tue Jan 22, 2008 6:03 am

I downloaded this an installed it today. Everything appeared to go just fine. But when I click the link I made for the roster I get the following error message:

/components/com_wowroster/lib/roster.php: line[117]
Could not connect to database ""
MySQL said:
2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

But MySQL is working fine, I have a PhpBB forum, and the standalone version of the roster was working fine as well.

I use 1and1.com for my webhosting, and the MySQL server is not on the same machine as the webserver. (Just thought I would throw that in there since the error message mentioned local MySQL server)
Last edited by Trefynwed on Tue Jan 22, 2008 6:07 am, edited 1 time in total.
Trefynwed
WR.net Apprentice
WR.net Apprentice
 
Posts: 11
Joined: Tue Jan 22, 2008 6:00 am

Looking for some BETA Testers for Joomla component!

Postby Nefuh » Tue Jan 22, 2008 7:41 am

Hello Trefynwed,

Which Joomla Version do you use? The component is coded for Version 1.0.13 I don´t really know yet if Version 1.5 use the same DB Variables.

Nefuh
Administrator of the german User2User Community for WoWRoster.
Guild Master from Scum from Hell - Horde @ EU-Anetheron.
User avatar
Nefuh
WoWRoster.net Dev Team
WoWRoster.net Dev Team
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 213
Joined: Fri Sep 15, 2006 8:34 pm
Location: Krefeld Germany

Re: Looking for some BETA Testers for Joomla component!

Postby Trefynwed » Tue Jan 22, 2008 12:33 pm

Nefuh wrote:Hello Trefynwed,

Which Joomla Version do you use? The component is coded for Version 1.0.13 I don´t really know yet if Version 1.5 use the same DB Variables.

Nefuh


I'm using 1.5, but it is in legacy mode, I have several other components and plugins meant for 1.0 that are running on 1.5. But that may be the case with the DB Variables.
Trefynwed
WR.net Apprentice
WR.net Apprentice
 
Posts: 11
Joined: Tue Jan 22, 2008 6:00 am

Looking for some BETA Testers for Joomla component!

Postby Nefuh » Tue Jan 22, 2008 8:17 pm

I don´t know if the component will function on 1.5 even when legacy mode is activatet. In the next days i will install Joomla 1.5 on my test systems and look if i could the component get to work in Joomla 1.5.

Nefuh
Administrator of the german User2User Community for WoWRoster.
Guild Master from Scum from Hell - Horde @ EU-Anetheron.
User avatar
Nefuh
WoWRoster.net Dev Team
WoWRoster.net Dev Team
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 213
Joined: Fri Sep 15, 2006 8:34 pm
Location: Krefeld Germany

Re: Looking for some BETA Testers for Joomla component!

Postby Trefynwed » Tue Jan 22, 2008 9:10 pm

Nefuh wrote:I don´t know if the component will function on 1.5 even when legacy mode is activatet. In the next days i will install Joomla 1.5 on my test systems and look if i could the component get to work in Joomla 1.5.

Nefuh


Very cool, thank you. I'll continue to poke around with it as well.... I know just enough about Joomla and PHP to get myself in trouble, so I might be able to figure something out.
Trefynwed
WR.net Apprentice
WR.net Apprentice
 
Posts: 11
Joined: Tue Jan 22, 2008 6:00 am

Looking for some BETA Testers for Joomla component!

Postby Nefuh » Tue Jan 22, 2008 9:25 pm

If you have get it working on Joomla 1.5 please let me know, i will also try to get it working.

Nefuh
Administrator of the german User2User Community for WoWRoster.
Guild Master from Scum from Hell - Horde @ EU-Anetheron.
User avatar
Nefuh
WoWRoster.net Dev Team
WoWRoster.net Dev Team
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 213
Joined: Fri Sep 15, 2006 8:34 pm
Location: Krefeld Germany

Looking for some BETA Testers for Joomla component!

Postby luciver » Wed Jan 23, 2008 4:07 am

Hey !

I am teste local on a joomla, 1.0.13, an it works fine :)

very symple to install an configure.

luci...
The German Community
wowroster.de
Akecheta of Frostwolf
User avatar
luciver
WR.net Apprentice
WR.net Apprentice
 
Posts: 26
Joined: Wed Jul 05, 2006 12:28 am
Location: Berlin

Re: Looking for some BETA Testers for Joomla component!

Postby Trefynwed » Wed Jan 23, 2008 8:14 am

I decided to drop Joomla 1.5 and just use 1.0.13 since I also was wanting to use CBConnecter to integrate my phpBB forum. So I deleted the old installation and cleaned out the database and installed a fresh version 1.0.13.

When I installed com_wowroster over the backend, this is what I get:


Deutsch / German:
Die Komponente "wowroster" wurde installiert. Du kannst nun das Interface Image Pack mit einem FTP-Programm hochladen in den Ordner /components/com_wowroster/img/
English: com_wowroster installed. Now you can upload the Interface Image Pack with your FTP-Program to /components/com_wowroster/img/Failed Queries:
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO`#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');
INSERT INTO `#__roster_account` VALUES (3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');

Trefynwed
WR.net Apprentice
WR.net Apprentice
 
Posts: 11
Joined: Tue Jan 22, 2008 6:00 am

Re: Looking for some BETA Testers for Joomla component!

Postby Nefuh » Wed Jan 23, 2008 8:26 am

Oh :cry:

The Queries should only be displayed when there´s an error on inserting.
Sometimes the Script says the Query failed so it will be logged as failed an displayed. But the data will be inserted.

If you have PHPMyAdmin try to look in `jos_roster_account` if there´s an entrie for `Admin`.
If it is the message could be ignored.
When not insert it manually with PHPMyAdmin.

If you have no PHPMyAdmin try to login in Joomla with your "super administrator" account and look if you could get access to roster config panel. When you get access, all data are correct inserted and the message can be ignored.

I will take a look at the script and try to fix it.

Nefuh
Administrator of the german User2User Community for WoWRoster.
Guild Master from Scum from Hell - Horde @ EU-Anetheron.
User avatar
Nefuh
WoWRoster.net Dev Team
WoWRoster.net Dev Team
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 213
Joined: Fri Sep 15, 2006 8:34 pm
Location: Krefeld Germany

Re: Looking for some BETA Testers for Joomla component!

Postby Trefynwed » Wed Jan 23, 2008 1:02 pm

I looked in phpmyadmin and the jos_roster_account table isn't there at all.

If I login with the super admin account and click on the roster link I get this message:


Cannot get roster configuration from database
MySQL Said: 1146: Table 'db193923490.jos_roster_config' doesn't exist

You might not have roster installed
INSTALL



If I click the INSTALL link (which just points to http://www.mysite.com/INSTALL.php) it just goes to a white page that says "Restricted Access"
Last edited by Trefynwed on Wed Jan 23, 2008 1:21 pm, edited 2 times in total.
Trefynwed
WR.net Apprentice
WR.net Apprentice
 
Posts: 11
Joined: Tue Jan 22, 2008 6:00 am

Looking for some BETA Testers for Joomla component!

Postby Nefuh » Wed Jan 23, 2008 9:47 pm

Hello Trefynwed,

Here are some SQL-Queries to fix that:

Code: Select all
CREATE TABLE `jos_roster_account` (
  `account_id` smallint(6) NOT NULL auto_increment,
  `name` varchar(30) NOT NULL default '',
  `hash` varchar(32) NOT NULL default '',
  PRIMARY KEY  (`account_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;

INSERT INTO `jos_roster_account` (`account_id`, `name`, `hash`) VALUES
(1, 'Guild', '3eb8ad34a2497cacc170e57b6569bdc3'),
(2, 'Officer', '3eb8ad34a2497cacc170e57b6569bdc3'),
(3, 'Admin', '3eb8ad34a2497cacc170e57b6569bdc3');


Copy this into PhpMyAdmin -> SQL.
This should create the missing table and insert the needed accounts for roster.

Nefuh
Administrator of the german User2User Community for WoWRoster.
Guild Master from Scum from Hell - Horde @ EU-Anetheron.
User avatar
Nefuh
WoWRoster.net Dev Team
WoWRoster.net Dev Team
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 213
Joined: Fri Sep 15, 2006 8:34 pm
Location: Krefeld Germany

Re: Looking for some BETA Testers for Joomla component!

Postby Trefynwed » Wed Jan 23, 2008 10:07 pm

Ok, that inserted the account table, but it is still complaining about jos_roster_config not being there, and won't let me view the roster page. Do I basically just need to run all the queries that are in the install.wowroster.php file in the com_wowroster zip file thru phpmyadmin manually?
Trefynwed
WR.net Apprentice
WR.net Apprentice
 
Posts: 11
Joined: Tue Jan 22, 2008 6:00 am

Looking for some BETA Testers for Joomla component!

Postby Nefuh » Wed Jan 23, 2008 10:56 pm

I don´t really know why the queries should not worked on installation. I´ve tested it on my own to server´s (WinXP with Xampp and Suse Linux 10.0 with Apache2) local and tested it on samples.online-gilde.de one of my internet sites. On all installations i´ve no errors.

In your case you need to manually run all the queries (not all needed queries are in install.wowroster.php, there you will find only the inserts, in wowroster.xml in /administrator/components/com_wowroster/ you wil find the create table queries).

Nefuh
Administrator of the german User2User Community for WoWRoster.
Guild Master from Scum from Hell - Horde @ EU-Anetheron.
User avatar
Nefuh
WoWRoster.net Dev Team
WoWRoster.net Dev Team
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 213
Joined: Fri Sep 15, 2006 8:34 pm
Location: Krefeld Germany

Re: Looking for some BETA Testers for Joomla component!

Postby Trefynwed » Wed Jan 23, 2008 11:27 pm

I figured out the problem, it was the Default Charset=utf8 I had to remove this from each of the queries or they would all return an error stating there was an SQL syntax problem.
Trefynwed
WR.net Apprentice
WR.net Apprentice
 
Posts: 11
Joined: Tue Jan 22, 2008 6:00 am

Next

Return to Joomla/Mambo

Who is online

Users browsing this forum: No registered users and 1 guest

cron