Weird forum language problem

PhamTrinli

Shineko wrote: »

PhamTrinli wrote: »

Shineko wrote: »

And yes, forum threads operate on Queries, usually SQL or some other databasing query. PHP is common for permissions as well as some front end programming and utilizes SQL querying.

It's gonna take more than "Just .. no. No, dude." to convince a software developer that she's wrong seeing as I've coded websites for clients that use asp.net and php accordingly to make database queries in MySQL. Do you think that all data is just stored on the forum magically and modified by fairies every time someone wants to add a post?

Ok, then how about a little education? https://www.w3.org/International/questions/qa-css-lang
- languages done easily, with style sheets. Very little PHP modification needed, absolutely no alteration to any database code (you don't use SQL or other relational databases to store style sheets or html or web pages in general).

Okay yeah, you are an idiot who is google educated and thinks that a Cascading Stylesheet will allow data stored in a database to be displayed.

Your solution requires 3 different databases, resulting in an overhaul of the currently existing 1 database. It uses up more disk space as databases are generally compressed due to redundant data. No, you would be far better off with modifying queries and adding a filtering small int data value for board language. To accomplish the 'same' thing. Using the method you mentioned doesn't work the way you 'think' it works. I know you don't actually deal with databases, it's obvious.

I'm out of this troll thread. Peace.

Man, you are really stuck on databases aren't you?

My solution requires 0 databases unless you consider flat files as "databases" which technically I suppose you can, but I assume you mean relational databases when you say "database" here.

Anyway, you have a CSS folder, and a normal html directory structure on a web server (or multiple web servers if you have to do thread-load balancing for your site). You keep your CSS in the folder; your PHP references your CSS to display the correct styling. You can even throw some javascript in there to have the users be able to decide which styling they want/need, although it is actually easier to just do it automatically - server-side because then you don't have to incorporate any form of URL post/get or any implementations of AJAX layers to get the user's javascript input to affect the layout of the site/page(s).

Also, if you are a developer, then you are acting very unprofessionally by sitting there and calling me names when I have not done that to you. I would take a moment to pause and regain composure/perspective if I were you.

PhamTrinli

Shineko wrote: »

Also I failed to point out the flaw in your reasoning.
The data you pull from the database are the posts people make.

Correct, but we are not discussing people's posts, so we are not involving databases in the discussion (or at least there is no need to) because the purposed change(s) I have suggested have nothing to do with user-generated content, but with the all of the site-specific or forum-specific text which is all just canned text. I don't know why you would have thought we were talking about user-generated content, because there is no need to translate that, because the users will post in there own language in their own section of the forums.

Shineko

Okay Mr. Smartypants. I'll humor you because I think I'll find the answer to this question amusing.

What steps does the server have to follow, under your method, in order to display this very thread with all of it's glorious posts and how do you do it without using any form of database. I'm not talking about the formatting or the styling. How do I retrieve this thread for display?

Lascoux

Here's my endgame argument here: MY FREAKING FORUM INVITATION E-MAIL WAS IN GERMAN. Something is clearly wrong with their database handling.

I also know that with the quality of developers ESO has the resources to have on hand - this never should have been an issue. Someone goofed up.

Also you will find a refutation to your arguments in the first pages of Beginning Database Design. Whoever designed the database for this forum took a shortcut which resulted in all 3 language tables being displayed at the same time. It is now painstaking to fix the problem as you said, but some DUE DILIGENCE at the start of design would have started with a model of separate data processing for each language (you of course would have to reexamine the MVC pathways, or at this point - work backwards).

No one should be able disagree with me when I say it is clunky and inefficient. At the very least, some changes would make it way more visible. Not only does it make the directory look like a tower of undifferentiated text, it makes it hard to navigate. The whole argument that us uneducated americans should be forced to read all the EU languages is extra tarded.

Here's my final statement: I'm sure they're working on fixing it, but their web dev team dropped a huge ball on this one.

PhamTrinli

Shineko wrote: »

Okay Mr. Smartypants. I'll humor you because I think I'll find the answer to this question amusing.

What steps does the server have to follow, under your method, in order to display this very thread with all of it's glorious posts and how do you do it without using any form of database. I'm not talking about the formatting or the styling. How do I retrieve this thread for display?

Again, you seem to be misunderstanding something here, because I am not saying that the site doesn't use any databases. I am saying that the changes I purposed require no database usage. I'm sorry if I didn't make that part clear enough for you.

Again with the childish names. Do you feel threatened so you have to try to belittle me with name calling in order to invalidate my arguments?

Shineko

PhamTrinli wrote: »

Shineko wrote: »

Okay Mr. Smartypants. I'll humor you because I think I'll find the answer to this question amusing.

What steps does the server have to follow, under your method, in order to display this very thread with all of it's glorious posts and how do you do it without using any form of database. I'm not talking about the formatting or the styling. How do I retrieve this thread for display?

Again, you seem to be misunderstanding something here, because I am not saying that the site doesn't use any databases. I am saying that the changes I purposed require no database usage. I'm sorry if I didn't make that part clear enough for you.

I'm saying your method doesn't account for the fact you still need to make a SQL query and that using a direct front end bypass by using CSS would result in problems when the site needs to be updated, such as to incorporate more forums or if they change the overal schema of the forum by moving boards and sub-boards into different locations. Having reference column's added to the database that identifies the language instead would allow for faster and easier filtering as well as be easier to port and more modular in design. It's a lot less code.

"Also you will find a refutation to your arguments in the first pages of Beginning Database Design. Whoever designed the database for this forum took a shortcut which resulted in all 3 language tables being displayed at the same time. It is now painstaking to fix the problem as you said, but some DUE DILIGENCE at the start of design would have started with a model of separate data processing for each language (you of course would have to reexamine the MVC pathways, or at this point - work backwards)."

As I stated earlier, the forums were purely English in beta and probably as a form of oversight rested in just adding the other languages as a quick simple fix due to necessity without needing to do any code.

ZOS_HugoP

Hello,

As this thread has derailed into an heated argument, it is now closed.

Please remember to stay respectful and polite towards each others at all time, when posting on the Elder Scrolls Online forums.

Thank you for your understanding.