Keys addon: Accepting translations and extra definitions.

Posts from previous Beta sessions

Keys addon: Accepting translations and extra definitions.

Postby Subxero » Tue Feb 12, 2008 7:27 pm

LUA is english and YES old "key" addon renamed WORKS! and Key_BC works!

But new "Key" addon don't get keys from keyrings on upload :/
Subxero - Priest 70 Holy - Asphelt Knight Officer - Zul'jin Horde.
User avatar
Subxero
WR.net Artisan
WR.net Artisan
 
Posts: 234
Joined: Thu Jul 06, 2006 4:08 pm
Realm: Zul'jin (PvE) - US

Re: Keys addon: Accepting translations and extra definitions

Postby tuigii » Tue Feb 12, 2008 9:56 pm

I pulled the new keys addon SVN yesterday evening.

Result after less then 24 hours : http://www.papy-team.fr/roster/index.ph ... keys&a=g:1

This is a french roster.
User avatar
tuigii
WR.net Master
WR.net Master
 
Posts: 891
Joined: Wed Dec 27, 2006 12:57 pm
Location: Somewhere in the South Ouest of France

Keys addon: Accepting translations and extra definitions.

Postby PleegWat » Tue Feb 12, 2008 11:43 pm

Subxero, I'm not seeing this behaviour on my local system. Are the key items in question in your LUA file? Is your keyring shown (and filled, and up to date) in the info addon?
I <3 /bin/bash
User avatar
PleegWat
WoWRoster.net Dev Team
WoWRoster.net Dev Team
 
Posts: 1636
Joined: Tue Jul 04, 2006 1:43 pm

Keys addon: Accepting translations and extra definitions.

Postby Theophilius » Thu Feb 14, 2008 7:59 pm

Hi,

I've just installed 1665, frFR defs for Arca and TKs are in my file but not in the svn install_frFR.php file (see previous message for the translation) and there is an encoding problem with the $lang['keys_desc'] and $lang['keybutton'] entries which are iso-8859-15 instead of UTF-8.

Best regards.

Chris.
User avatar
Theophilius
WR.net Apprentice
WR.net Apprentice
 
Posts: 28
Joined: Sat Feb 24, 2007 4:49 pm

Keys addon: Accepting translations and extra definitions.

Postby zanix » Fri Feb 15, 2008 12:42 am

Fixed svn 1667
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Keys addon: Accepting translations and extra definitions.

Postby Subxero » Sun Feb 17, 2008 8:07 pm

Still with problems .. now i get a error message from 1667-1684 SVN (before was no error message but keys don't update)

Database Error
1054: Unknown column 'stages.count' in 'having clause'

SQL:
INSERT INTO `roster_addons_keys_keycache` (`member_id`, `key_name`, `stage`) SELECT '1', `stages`.`key_name`, `stages`.`stage` FROM (SELECT `locale`,`faction`,`key_name`,`stage`,`type`,`value`,`count` FROM `roster_addons_keys_stages`) AS stages, `roster_items` AS data WHERE `stages`.`locale` = 'enUS' AND `stages`.`faction` = 'H' AND `data`.`member_id` = '1' AND (`stages`.`type` = 'In' AND `data`.`item_name` = `stages`.`value` OR `stages`.`type` = 'Ii' AND `data`.`item_id` LIKE CONCAT(`stages`.`value`, ':%')) GROUP BY `stages`.`key_name`, `stages`.`stage`, `stages`.`count` HAVING SUM(`data`.`item_quantity`) >= `stages`.`count`;

File: lib/dbal/mysql.php

Line: 235

PHP Errors
pages/update.php
Notice line 64: Undefined variable: messages
Subxero - Priest 70 Holy - Asphelt Knight Officer - Zul'jin Horde.
User avatar
Subxero
WR.net Artisan
WR.net Artisan
 
Posts: 234
Joined: Thu Jul 06, 2006 4:08 pm
Realm: Zul'jin (PvE) - US

Keys addon: Accepting translations and extra definitions.

Postby PleegWat » Sun Feb 17, 2008 8:18 pm

This is a mysql 4 problem. According to the documentation, this statement should work, but apparently it doesn't.

Any ideas are welcome.
I <3 /bin/bash
User avatar
PleegWat
WoWRoster.net Dev Team
WoWRoster.net Dev Team
 
Posts: 1636
Joined: Tue Jul 04, 2006 1:43 pm

Keys addon: Accepting translations and extra definitions.

Postby Subxero » Sun Feb 17, 2008 9:04 pm

I found these:

Yes, this is a mysql 4 compatibility issue.

Mysql documentation mentioning the issue is here, http://dev.mysql.com/doc/refman/5.0/en/select.html
See under "The HAVING clause is applied..."

Basically, in mysql you cannot use in a having clause columns that are not in the select statement. So the query though being SQL standard compliant, doesn't work in Mysql 4.

The only solution I can think of atm is adding a dummy field into 'subscriptions_queue' table so we can add the field into the SELECT clause too. But I'd like something better than that.

Help is wanted on how to address it, while retaining the ability to queue all notifications in a simple query.
Subxero - Priest 70 Holy - Asphelt Knight Officer - Zul'jin Horde.
User avatar
Subxero
WR.net Artisan
WR.net Artisan
 
Posts: 234
Joined: Thu Jul 06, 2006 4:08 pm
Realm: Zul'jin (PvE) - US

Keys addon: Accepting translations and extra definitions.

Postby PleegWat » Sun Feb 17, 2008 9:57 pm

Please try 1687
User avatar
PleegWat
WoWRoster.net Dev Team
WoWRoster.net Dev Team
 
Posts: 1636
Joined: Tue Jul 04, 2006 1:43 pm

Keys addon: Accepting translations and extra definitions.

Postby Subxero » Mon Feb 18, 2008 1:35 am

Works now! ;) i can see my keys!
Subxero - Priest 70 Holy - Asphelt Knight Officer - Zul'jin Horde.
User avatar
Subxero
WR.net Artisan
WR.net Artisan
 
Posts: 234
Joined: Thu Jul 06, 2006 4:08 pm
Realm: Zul'jin (PvE) - US

Keys addon: Accepting translations and extra definitions.

Postby Blueleaf » Fri Feb 22, 2008 1:18 pm

can someone point me in the right direction to get the file to fix this?

Thank You
User avatar
Blueleaf
WR.net Apprentice
WR.net Apprentice
 
Posts: 50
Joined: Thu Apr 26, 2007 12:06 am
Location: Minot, ND

Keys addon: Accepting translations and extra definitions.

Postby Subxero » Fri Feb 22, 2008 1:26 pm

Go to SVN and download the last. (at top you have a tutorial)
Subxero - Priest 70 Holy - Asphelt Knight Officer - Zul'jin Horde.
User avatar
Subxero
WR.net Artisan
WR.net Artisan
 
Posts: 234
Joined: Thu Jul 06, 2006 4:08 pm
Realm: Zul'jin (PvE) - US

Re: Keys addon: Accepting translations and extra definitions

Postby Blueleaf » Fri Feb 22, 2008 1:39 pm

Subxero wrote:Go to SVN and download the last. (at top you have a tutorial)


ok guess I'm lost here, clicked link to WebSVN could not find anything for keys for roster 2

tried SVNergy also and developer areas are not accessible to me.

Sorry for being SVN illiterate but need further guildance

Thanks
User avatar
Blueleaf
WR.net Apprentice
WR.net Apprentice
 
Posts: 50
Joined: Thu Apr 26, 2007 12:06 am
Location: Minot, ND

Re: Keys addon: Accepting translations and extra definitions

Postby tuigii » Fri Feb 22, 2008 3:54 pm

Blueleaf wrote:Sorry for being SVN illiterate but need further guildance

Answer moved to http://www.wowroster.net/Forums/viewtop ... html#31933 - question is not related to the current subject.
User avatar
tuigii
WR.net Master
WR.net Master
 
Posts: 891
Joined: Wed Dec 27, 2006 12:57 pm
Location: Somewhere in the South Ouest of France

Keys addon: Accepting translations and extra definitions.

Postby Blueleaf » Fri Feb 22, 2008 10:39 pm

Thanks Tuigii I was in right place but was looking for it in roster 2, got it installed and fixed the problem. I see there is an admin folder there that is not on my local files, do I need it, seems to work fine without it, or is this somthing new that allows more control?

Thanks a bunch
User avatar
Blueleaf
WR.net Apprentice
WR.net Apprentice
 
Posts: 50
Joined: Thu Apr 26, 2007 12:06 am
Location: Minot, ND

PreviousNext

Return to Archived

Who is online

Users browsing this forum: No registered users and 0 guests

cron