Key BC V2 beta 3

Displays Instance keys for TBC

Moderator: titan99

Key BC V2 beta 3

Postby titan99 » Wed Aug 29, 2007 10:44 pm

final beta for key bc

a little translation isn't make for admin panel
Attachments
key_bc_v2b3.zip
Key BC beta 3 for roster V2
(25.8 KiB) Downloaded 926 times
User avatar
titan99
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 129
Joined: Sat Jan 13, 2007 8:11 am
Location: Montpellier - France

Key BC V2 beta 3

Postby tuigii » Thu Aug 30, 2007 3:15 am

Perfect, as usual
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

Key BC V2 beta 3

Postby bosco » Thu Aug 30, 2007 5:48 am

tiens l'ami montpellierain =)

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

(faudra qu'on s'voit un de ces 4 =) )
bosco
WR.net Apprentice
WR.net Apprentice
 
Posts: 26
Joined: Mon Jan 15, 2007 12:24 pm

Re: Key BC V2 beta 3

Postby Beebob » Thu Aug 30, 2007 6:09 am

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
Last edited by Beebob on Thu Aug 30, 2007 6:11 am, edited 2 times in total.
Beebob
WR.net Apprentice
WR.net Apprentice
 
Posts: 20
Joined: Fri Jul 07, 2006 1:59 am

Key BC V2 beta 3

Postby Subxero » Thu Aug 30, 2007 7:43 am

I get these error:

1267: Illegal mix of collations (utf8_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '='
Last edited by Subxero on Fri Aug 31, 2007 6:17 am, edited 2 times in total.
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: Key BC V2 beta 3

Postby tuigii » Thu Aug 30, 2007 8:30 am

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 ;:-))
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

Key BC V2 beta 3

Postby ds » Thu Aug 30, 2007 8:54 am

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?
Image
ds
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 297
Joined: Sat Jul 08, 2006 9:58 am

Key BC V2 beta 3

Postby bosco » Thu Aug 30, 2007 9:53 am

MySQL v4.1 with fresh install of roster v2.
bosco
WR.net Apprentice
WR.net Apprentice
 
Posts: 26
Joined: Mon Jan 15, 2007 12:24 pm

Key BC V2 beta 3

Postby titan99 » Thu Aug 30, 2007 10:36 pm

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
Last edited by titan99 on Thu Aug 30, 2007 10:37 pm, edited 1 time in total.
User avatar
titan99
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 129
Joined: Sat Jan 13, 2007 8:11 am
Location: Montpellier - France

Key BC V2 beta 3

Postby ds » Fri Aug 31, 2007 2:32 am

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?
Image
ds
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 297
Joined: Sat Jul 08, 2006 9:58 am

Key BC V2 beta 3

Postby bosco » Fri Aug 31, 2007 4:58 am

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.
Last edited by bosco on Fri Aug 31, 2007 4:59 am, edited 1 time in total.
bosco
WR.net Apprentice
WR.net Apprentice
 
Posts: 26
Joined: Mon Jan 15, 2007 12:24 pm

Re: Key BC V2 beta 3

Postby titan99 » Fri Aug 31, 2007 3:30 pm

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
User avatar
titan99
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 129
Joined: Sat Jan 13, 2007 8:11 am
Location: Montpellier - France

Re: Key BC V2 beta 3

Postby bosco » Sat Sep 01, 2007 12:30 am

titan : you're using mysql 5 ?
bosco
WR.net Apprentice
WR.net Apprentice
 
Posts: 26
Joined: Mon Jan 15, 2007 12:24 pm

Key BC V2 beta 3

Postby titan99 » Sat Sep 01, 2007 1:02 am

yes
User avatar
titan99
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 129
Joined: Sat Jan 13, 2007 8:11 am
Location: Montpellier - France

Faction dependent Rep update fix

Postby Basil155 » Sat Sep 01, 2007 2:53 am

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...
:oops:
Basil155
WR.net Apprentice
WR.net Apprentice
 
Posts: 1
Joined: Fri Dec 22, 2006 6:06 am

Next

Return to Key BC

Who is online

Users browsing this forum: No registered users and 0 guests

cron