| 00:14.31 | *** join/#wowroster Zeryl (n=Zeryl@75-132-127-218.dhcp.stls.mo.charter.com) |
| 00:14.32 | *** mode/#wowroster [+o Zeryl] by ChanServ |
| 03:09.51 | dracula | hey does anyone know what character format is used in the LUA files? |
| 03:10.21 | dracula | I mean, é shows up as Ă© |
| 03:13.16 | dracula | and ý becomes Ă. |
| 03:16.26 | dracula | how do you guys get that to display right in the roster... how to decode that with php ? |
| 03:17.11 | Zeryl | I belive it's UTF-8 |
| 03:17.18 | Zeryl | if you used a utf-8 editor, it would show right? |
| 03:17.19 | Zeryl | maybe? |
| 03:18.44 | dracula | yeah, well I'm talking about the stuff that's already imported into the database |
| 03:18.59 | dracula | the same chars are stored there, but still display correctly in the roster |
| 03:19.01 | Zeryl | oh, I have issues with that as well, i'm not sure, to be honest |
| 03:19.44 | dracula | problem is that I have to use name matching for my DKP system... and the ý doesnt match the UTF-8 sequence |
| 03:22.18 | Zanix|away | look at the bottom on settings.php |
| 03:22.45 | Zanix|away | one of the header() 's does this |
| 03:22.57 | dracula | aha |
| 03:22.58 | dracula | I see |
| 03:23.02 | Zanix|away | @header('Content-type: text/html; '.$wordings[$roster_conf['roster_lang']]['charset']); |
| 03:23.13 | Zanix|away | then look at one of the locale files |
| 03:23.26 | Zanix|away | $wordings['enUS']['charset']="charset=utf-8"; |
| 03:23.49 | Zanix|away | so it ends up being @header('Content-type: text/html; charset=utf-8'); |
| 03:23.57 | dracula | clever ;) |
| 03:24.16 | dracula | but no help to me ;) |
| 03:24.28 | dracula | is there a way to convert char encoding in php? |
| 03:24.39 | dracula | oh heck I'm sure there is |
| 03:25.04 | Zanix|away | yeah, there is |
| 03:25.29 | Zanix|away | utf8_decode or utf8_encode |
| 03:25.52 | dracula | lol that sounds exactly like what I need ;) |
| 04:06.39 | dracula | hmm, and if you perform an SQL query with this: SELECT * FROM user_table WHERE name = "name" |
| 04:06.51 | dracula | it both returns "name" and "namé" |
| 04:07.19 | dracula | is there a way to do a more accurate match ? |
| 04:08.43 | dracula | sorry to bother you with this non-roster-related stuff ;) |
| 04:09.42 | Zeryl | I don't know an answer :( |
| 04:11.16 | dracula | you might wonder why anyone would ever want to search for a name instead of an id anyway ;) |
| 04:11.29 | Zeryl | nah, many reasons |
| 04:11.37 | Zanix|away | because you have to sometimes :9 |
| 04:12.30 | dracula | in this case it's a user-edit-form, where you can also change someone's name |
| 04:12.53 | dracula | and I don't like 2 characters with the same name |
| 04:13.13 | dracula | now this player in our guild has a character "Darkkangel" and "Darkkangél" |
| 04:13.21 | dracula | grmbl |
| 04:13.30 | Zanix|away | crap |
| 04:13.45 | Zanix|away | well, the sql performs similar to when you search for that |
| 04:13.59 | Zanix|away | you can use the convert function in SQL |
| 04:14.09 | Zanix|away | it is a SQL function, not php |
| 04:14.20 | dracula | yeah, never got into that SQL function stuff |
| 04:14.36 | dracula | but I think I 'solved' it another way |
| 04:15.06 | dracula | when searching the database for a username, I now also iterate over the found matches to check whether they are a real match ;) |
| 04:15.15 | dracula | so in php |
| 04:15.23 | Zanix|away | good idea |
| 04:15.43 | dracula | ever seen this: http://2js5.com/dcp/points/ ? |
| 04:16.50 | Zanix | nifty |
| 04:16.52 | Zanix | what is it? |
| 04:16.56 | Zanix | ...lol |
| 04:17.04 | dracula | hehe |
| 04:17.46 | dracula | it's our dkp overview, which we call "dcp" |
| 04:17.55 | dracula | because of the guild's name ;) |
| 04:18.22 | dracula | notice how the roster's AltMonitor is used for finding someone's alt |
| 04:19.07 | Zanix | no :( |
| 04:19.52 | dracula | if you hover over someone's points, or when you go into someone's details by clicking the little icon in front |
| 04:20.30 | Zanix | oh |
| 04:20.32 | Zanix | nice |
| 04:21.06 | dracula | I like it how all alt-management is actually done in-game by setting appropriate player notes... |
| 04:21.25 | Zanix | nifty |
| 04:21.29 | dracula | after a roster-update this dcp system automatically updates the links :) |
| 04:21.54 | dracula | now I need to find a way to silently reward myself points for this, muhahaha |
| 04:42.29 | Zeryl | dracyka |
| 04:42.32 | Zeryl | dracula* |
| 04:42.37 | Zeryl | > Hi all |
| 04:42.37 | Zeryl | > |
| 04:42.37 | Zeryl | > How is the character set of returned data effected? I have a DB using |
| 04:42.37 | Zeryl | > UTF-8 encoding., PHP is set to use UTF-8 internally. However the MySQL |
| 04:42.37 | Zeryl | > connection returns Latin1 data. How can I get it to return UTF-8 data |
| 04:42.37 | Zeryl | > instead. |
| 04:42.40 | Zeryl | http://dev.mysql.com/doc/refman/4.1/en/charset-literal.html |
| 04:42.41 | Zeryl | Should cover your questions :) |
| 04:42.43 | Zeryl | does that cover somewhat what you are asking? |
| 04:43.16 | dracula | cool, let me take a look |
| 04:43.26 | Zeryl | was on the php-db list today ;) |
| 04:45.10 | dracula | that seems to be the other way round |
| 04:45.14 | Zeryl | oh :( |
| 04:45.31 | dracula | I remember COLLATE to map different characters onto another |
| 04:45.38 | dracula | from my good old PowerBasic time ;) |
| 04:46.56 | dracula | I'm running exactly this query: |
| 04:46.57 | dracula | SELECT * from dcp_users WHERE uname='darkkangel' |
| 04:47.25 | dracula | and it returns 2 records: darkkangel and darkkangél |
| 04:48.00 | Zeryl | and i'm guessing they are two different chars? |
| 04:48.26 | dracula | well yes |
| 04:48.43 | dracula | but it's kinda annoying that you cannot search for one specific |
| 04:48.54 | Zeryl | can you use LIMIT 1? |
| 04:49.08 | dracula | that's nasty ;) |
| 04:49.13 | Zeryl | what happens if you search for the darkkangél one? which is returned first? |
| 04:49.21 | Zeryl | well, it may be the way it needs to be done unfortunatly |
| 04:49.50 | dracula | always same order, so LIMIT is of no use |
| 04:50.08 | Zeryl | :( |
| 04:50.48 | dracula | I don't think my current iteration over the matches is bad, since the situation where there are multiple matches rarely occurs |
| 04:51.12 | dracula | and if so, there won't be more than 2 |
| 04:51.14 | Zeryl | so using php doing something like $uname == $returnedname will work? |
| 04:51.28 | dracula | yes that will accurately matches one |
| 04:51.32 | Zeryl | cool |
| 04:52.05 | dracula | I'll kill the guy if he creates another char "Dárkkŕngël" |
| 04:52.14 | Zeryl | lol |
| 04:52.20 | Zeryl | even then, 3 isn't bad |
| 04:52.22 | Zeryl | 10 isn't bad ;) |
| 04:54.26 | dracula | holy hell, there is an operator "REGEXP" |
| 04:54.51 | dracula | SELECT * FROM users WHERE name REGEXP "Darkkangél" |
| 04:54.56 | dracula | returns exactly one match |
| 04:54.57 | Zeryl | nice |
| 04:55.35 | dracula | somehow regexp sounds 'expensive' to me ;) |
| 04:55.55 | Zeryl | not really, SQL server commands are quite light |
| 04:55.59 | Zeryl | doing it in php are expensive |
| 04:56.06 | Zeryl | rom what I understand |
| 04:56.44 | dracula | hmm that's true, sql was quite made for that |
| 05:00.23 | Zeryl | i've always heard doing tihngs in sql is FAR prefered to php |
| 05:00.28 | Zeryl | in nearly EVERYTHING |
| 05:07.26 | dracula | yeah, it's too bad I prefer php so much |
| 05:08.15 | dracula | I don't like those complex nested and deep-cross-table queries |
| 05:09.43 | dracula | well, that solves all outstanding issues with the dcp system :D |
| 05:09.59 | dracula | thanks for the aid guys |
| 05:15.09 | dracula | and it's way past bedtime again |
| 05:15.22 | dracula | so off for the night... or actually morning ;) |
| 05:15.33 | Zeryl | hehe, later |
| 07:33.26 | *** join/#wowroster dRiN (n=de_RiN@137-244.surfsnel.dsl.internl.net) |
| 07:44.34 | *** join/#wowroster ThisIsChris (n=chris@ip70-162-30-61.ph.ph.cox.net) |
| 10:49.42 | *** join/#wowroster greenboy (n=greenboy@HSI-KBW-085-216-117-204.hsi.kabelbw.de) |
| 10:50.01 | greenboy | hallo |
| 10:50.05 | greenboy | morning |
| 10:50.15 | greenboy | i have a pb |
| 10:50.32 | greenboy | last night i have insatll rooster new |
| 10:50.53 | greenboy | but at mom. i cant upload the guild files |
| 12:23.29 | *** join/#wowroster Tupsi (n=Tupsi@213.20.246.131) |
| 12:49.10 | Liandra | wowrooster |
| 12:49.20 | Liandra | that'd be a great piece of software :P |
| 12:51.53 | PleegWat | Does that lay eggs? |
| 12:51.57 | PleegWat | Wait a rooster is the male |
| 12:51.58 | PleegWat | n/m |
| 14:40.00 | *** join/#wowroster Sylphid|work (n=gamesand@64.6.15.110.outfitters.com) |
| 16:55.50 | *** join/#wowroster Anaxent (n=Anaxent@ip72-208-134-254.ph.ph.cox.net) |
| 16:56.13 | *** mode/#wowroster [+o Anaxent] by ChanServ |
| 17:52.48 | *** join/#wowroster Sylphid (n=gamesand@staff-110.outfitters.com) |
| 19:11.45 | *** join/#wowroster Guest276 (n=Guest@82-47-209-25.stb.ubr03.wake.blueyonder.co.uk) |
| 19:11.54 | Guest276 | heya all |
| 19:12.23 | Guest276 | can anyone help me, im trying to register on the web site and its saying i dont have cookies alowed but i do :S |
| 19:14.39 | Guest276 | anyone??? |
| 19:17.27 | Anaxent | can u see our irc topic |
| 19:18.04 | Anaxent | http://www.wowroster.net/Forums/viewtopic/y=15.html |
| 19:18.13 | Guest276 | ahh thanks sorry not used to this client |
| 19:18.15 | Anaxent | http://www.wowroster.net/Forums/viewtopic/t=15.html |
| 19:18.21 | Guest276 | is there a problem with downloading too? |
| 19:18.26 | Anaxent | that should help you out |
| 19:18.44 | Anaxent | with out cookies yes I think so |
| 19:19.06 | Guest276 | it keeps redirecting me to the info about wowroster page :S |
| 19:19.29 | Anaxent | http://www.wowroster.net/Forums/viewtopic/t=15.html |
| 19:21.36 | Guest276 | sorted now thanks :) sory for the noobnes |
| 19:21.42 | Anaxent | ok np |
| 19:21.54 | Anaxent | well guys I have to goto work... on my day off |
| 19:22.03 | Anaxent | ill log back in later |
| 20:12.45 | *** join/#wowroster Anaxent (n=Anaxent@209-250-16-194.convergentaz.net) |
| 20:13.55 | *** mode/#wowroster [+o Anaxent] by ChanServ |
| 20:16.31 | Anaxent | whats up everyone |
| 20:16.38 | Anaxent | weather 85016 |
| 20:26.49 | PleegWat | Pulling my bro and a n00b goldbuying warrior through ST |
| 20:27.30 | PleegWat | But the noob was noobish and caused himself and my brother to die |
| 20:27.36 | PleegWat | now I'm waiting for them to run back |
| 20:32.21 | Anaxent | haha well that sucks |
| 20:32.26 | Anaxent | im at work on my day off |
| 20:32.29 | Anaxent | also sucks |
| 20:32.58 | Anaxent | washed the car yesterday as well and it is raining today |