final beta for key bc

a little translation isn't make for admin panel

Perfect, as usual

tiens l'ami montpellierain =)

http://www.herezya.com/roster/index.php?p=guild-Key_BC

(faudra qu'on s'voit un de ces 4 =) )

Request for a few improvements

Graphical:
1. Put a "frame" around empty cells (just put a   in there)
2. Make all rows the same height - now those witout any keys have smaller row-height

Sorting:
1. Make it possible to sort be name (and maybe by keys)


Otherwise - Great job


Beebob
GM @ Illysium @Runetotem

I get these error:

1267: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='

Note current collations down, and then :
Make the name collation fields from 'roster_addons_Key_BC_Quest' look like the ones in 'roster_quests' (an original Roster SQL table).

All text fields are 'utf8_general_ci' in my 'roster_quests' table.
Table text fields in my 'roster_addons_Key_BC_Quest' ARE latin1_swedish_ci - and I don't see any errors (my SQL server isn't barking).

Server version : Version du client MySQL: 5.0.32
Also : Jeu de caractères pour MySQL: UTF-8 Unicode (utf8)
And : Interclassement pour la connexion MySQL: utf8_unicode_ci

(all stuff is French here ;:-))

Interesting... The character set should be utf-8 by default. The Query method implicitly sets it so. I looked at the Install file for the addon and it is correctly done and not setting another character set.

Was the database your experiencing problems with a clean install of the roster Beta? Also, what is your MYSQL server version?

MySQL v4.1 with fresh install of roster v2.

if modify the collation with the hand via phpmyadmin

it's good or no ?

beaucause the roster instaler create the table to latin1_swedish_ci

I cannot get the installer to create the tables as latin1_swedish_ci. Every time I installed it has correctly been set as utf8_general_ci. If you uninstall and then reinstall (the addon) does it get set correctly then?

hi, i found some things...

All tables in roster v2 are in utf8_general_ci.

So, i have updated the table with problem. The table roster2_addon_Key_BC_Quest has been updated to utf8_general_ci :

ALTER TABLE `roster2_addons_Key_BC_Quest` CHANGE `id` `id` VARCHAR( 5 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ;
ALTER TABLE `roster2_addons_Key_BC_Quest` CHANGE `lang` `lang` VARCHAR( 4 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ;
ALTER TABLE `roster2_addons_Key_BC_Quest` CHANGE `Faction` `Faction` CHAR( 1 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ;
ALTER TABLE `roster2_addons_Key_BC_Quest` CHANGE `part` `part` VARCHAR( 50 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ;
ALTER TABLE `roster2_addons_Key_BC_Quest` CHARACTER SET utf8 COLLATE utf8_general_ci ;

An now, it shows all keys.

ds wrote:I cannot get the installer to create the tables as latin1_swedish_ci. Every time I installed it has correctly been set as utf8_general_ci.

in my serveur the table installed an addons is in latin1_swedish_ci
list of table in latin1
- roster_addons_Key_BC_Key
- roster_addons_Key_BC_Quest
- roster_addons_memberslist_alts
- roster_addons_news_comments
- roster_addons_news_news
this table is all addon table

but my serveur don't bug in consert latin1 to utf8

ds wrote:If you uninstall and then reinstall (the addon) does it get set correctly then?

yes i'm testing uninstall & reinstall addon but addon table is in latin1

titan : you're using mysql 5 ?

yes

Hi!
Great stuff, many thanks!
I found an error while updating Hellfire Citadell Heroic. In both cases, Horde or Alliance faction updated, Horde part takes effect.
Looking through Your code I found AND `Faction`='H' in both RHchange and RAchange in /admin/index.php
Sorry if i missed it to be already mentioned...