This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
421
Archived fixes / Re: Mobile Version
« on June 6th, 2012, 02:44 PM »
Did a test run using that UA, code is evaluating it fine (after adding |samsung|). So must be something else.
422
Archived fixes / Re: Mobile Version
« on June 6th, 2012, 02:26 PM »
What the f....I got no idea why that won't work.
423
Plugins / Re: Optional hooks
« on June 6th, 2012, 01:28 PM »
Oh damn, missed that while reading the source. Thanks!
424
Archived fixes / Re: Mobile Version
« on June 6th, 2012, 01:22 PM »
It is case sensitive. samsung won't match anything as it's SAMSUNG (strpos is case sensitive, stripos isn't).
425
Archived fixes / Re: Mobile Version
« on June 6th, 2012, 01:20 PM »426
Archived fixes / Re: Mobile Version
« on June 6th, 2012, 11:47 AM »Cleared the phones cache still the same.Quote from Dragooon on June 6th, 2012, 11:38 AM Cached in SESSION?
428
Off-topic / Re: Old layout vs new layout?
« on June 5th, 2012, 12:36 PM »
Dropped jQuery UI entirely (for guests atleast, I still need it's autocomplete for now), yay. Saves a few KBs of compressed JS files.
429
Off-topic / Re: Old layout vs new layout?
« on June 5th, 2012, 11:45 AM »No problem, it was just a suggestion as I've come across it many of times before, where there wasn't any demographic for a certain language and when that language was added the demographic grew for the simple fact that it was available now. It obviously involves a bit more work then just creating the multilingual site but you get the point.
430
Off-topic / Re: Old layout vs new layout?
« on June 5th, 2012, 11:38 AM »I'm surprised to hear that!
I would have thought that you guys (not you in particular :P) had a mixed relationship with the English language, because of India's history of colonialism.... Generally, freed countries tend to ban anything that reminds people of this past. I know that use of French language in Algeria is only officially 'tolerated', for instance...
Posted: June 5th, 2012, 11:37 AM
Why not make it a mulch-lingual site so as not to lose out on your key demographic but also to keep the wider audience happy!?Quote from Dragooon on June 5th, 2012, 09:55 AM Because it's easier to read on web and most of the population on internet here can read English fine. Hindi would actually make the scenario worse as it's harder to maintain plus many of the current generation can read English faster than Hindi (I myself can't read Hindi fluently :P).Quote from Nao on June 5th, 2012, 09:33 AM Silly question -- why is the site in English...?
431
Plugins / Optional hooks
« on June 5th, 2012, 10:13 AM »
Currently if a hook isn't present the plugin is unable to install. Perhaps there should be a third stage where the hook is optional. This can be used to provide optional support to plugins if available, otherwise that functionality will be disabled but other parts of the plugin can continue to function.
432
Off-topic / Re: Old layout vs new layout?
« on June 5th, 2012, 09:55 AM »Silly question -- why is the site in English...?
433
Off-topic / Re: Old layout vs new layout?
« on June 5th, 2012, 08:03 AM »Like it! :cool:
One thing I noticed: http://bazaarshotdeals.com/browse/categories doesn't have vertical scrollbar. I suggest you to add a overflow-y:scroll to body to be sure the layout is the same for pages with scrollbar and pages without. ;)
434
Off-topic / Re: MySQL query optimization
« on June 5th, 2012, 07:57 AM »It's not so much the select, it's what you're getting and how you're getting it and when you do what.
435
Off-topic / Re: MySQL query optimization
« on June 4th, 2012, 11:35 PM »Because you're not doing the same thing in both cases.
In the original query, you're pulling down a lot of columns, of which at least one is going to be a text column. Sorting on that always pushes it to disk, for the *entire* data set.
In the two-query set, you're pulling down a single numeric column, sorting that, and instead of applying successive filters to the data and ordering it all as you go - on disk, rather than in RAM - you're getting to cut most of the data you don't need out first, so you end up doing a lot less work on the data you do actually want.