IMCDb Forum
Send an answer to a topic: Episode Titles
Warning, this subject is old (6567 days without answer)
Subject
Bold [b]Text[/b] Italic [i]Italic[/i] Underline [u]Underline[/u] Strike Out [strike]Strike Out[/strike]
Email [email=nobody@nobody.org]Name[/email] Link [url=http://www.website.com]Text[/url] Anchor [anchor]Name[/anchor] Image [img]http://www.website.com/image.jpg[/img]
Align Left [align=left]Text[/align] Centered [align=center]Text[/align] Align Right [align=right]Text[/align] Text Justify [align=justify]Text[/text]
Color [color=#000000]Text[/color] Highlight [highlight=pascal]Text[/highlight] Widgets Smileys :code: [:code] HTML to BBCode converter Word to BBCode converter
Preview Spell Checker

Copy Paste Cut Select All
Clear Insert Date Insert Time Insert Date and Time Insert your IP
List [list=square][item]BlaBla[/item][/list] Numbered List [list=decimal][item]BlaBla[/item][/list]
Quote [quote=name]Text[/quote] Spoiler [spoiler]James is the murderer![/spoiler]
Uppercase [uppercase]Text[/uppercase] Lowercase [lowercase]Text[/lowercase] l33t [l33t]I'm a Nerd[/l33t] Sub Script [sub]Text[/sub] Super Script [sup]Text[/sup] Size of Text [size=8]Text[/size]

Options
 
 
 
 
G-MANN
I finally understand. Maybe episode titles might be a possibility one day, but for now there's too many things to sort out already.
antp
It would take more space if the title was stored each time in the vehicle page instead of having it once in a separate table.
There is often more than one vehicle in a episode.
It is not only for the space taken, but also to keep the database structure somewhat clean and coherent (it is already not perfect currently).

Yes, makes take space. And I could have a make list separated to not have to reenter it each time. Same for models actually. This is one of the improvements that I may do one day.

For info:

cars table = 7.9 MB
comments table = 34.4 MB
movies table = 1.5 MB
users table = 0.3 MB

total = 44.1 MB
max allowed = 50 MB

If the database reaches the max allowed size, OVH (where the site is hosted) will put it on another server, which is slower.
I could split the database and put comments & users in a separate database, but some day we will reach that limit.
G-MANN
Now I understand, it would take up space to enter everything manually. But would it take up that much space? Every time you enter a new car, you have to type in model names.
antp
If a computer can do something in one millisecond and save space of the database, why do you want to do it yourself manually and waste database space? :grin:
G-MANN

why do you want to type the title each time you add a vehicle rather than having to type the title once, and have the site find it when you type the episode number?


Why should the site have to be programmed to automatically sort it out? The thing is each different episode title would have to be typed in at least once, and there won't be that many different vehicles per episode, you could just copy the title once you've typed it and paste it into the field in the admin section for each vehicle on that episode, it wouldn't take that long at all. And it's not like I'm excepting you to sort it out for every TV series, you don't have to do any of them, other admins will be free to do it if they want to (I'll do the ones for my favourite TV shows), just think of it as a work-in-progress.
antp
- take too much space in the database
- take too much time for entering
why do you want to type the title each time you add a vehicle rather than having to type the title once, and have the site find it when you type the episode number?

I didn't say that the whole thing was a bad idea, I just said that if I add it, it would be a more automated solution. Of course it would be a little more work to add it to the site than just adding a new field, but it would work better too.
G-MANN
I know very little about programming. But I'm just wondering, could someone just enter the name of the episode in a new field in the same way you enter information in the Extra Info field so that the site wouldn't have to search for anything, it would just display the letters typed in the field. Would all this be too complex or take up too much space?

We need to draw this discussion to a close, do you think the whole thing is a bad idea and we should forget about it?
antp
Somewhere one the "edit movie title" page, I could add links "add episode", where you could enter number and title of each episode.

When the vehicle page is displayed, the site searches in the "movies" table the title of the movie with the number stored in the vehicle info.
It could at the same time search in the "episodes" table a title with the episode number matching the one of the vehicle info (well, actually movie number + episode number).

It is hard to try to explain with simple words such database concept actually. It sounds logical for me as I am programmer, but I guess that it is not so easy for non-programmers.
G-MANN
I'm sorry I'm just really confused here, where would you store all the titles so the site could automatically post them for each vehicle on the episode? Could you try explaining it again, as simply as you can? Your English is excellent, it's just on this occaission I'm not completely understanding you.
antp
Well, I do not really see how I can explain it differently... :grin:
Category:  






Ada
CSS
Cobol
CPP
HTML
Fortran
Java
JavaScript
Pascal
Perl
PHP
Python
SQL
VB
XML
Anon URL
DailyMotion
eBay
Flickr
FLV
Google Video
Metacafe
MP3
SeeqPod
Veoh
Yahoo Video
YouTube
6px
8px
10px
12px
14px
16px
18px
Sign In :: Sign Up :: Lost your login or your password?
KelCommunity.be :: © 2004-2024 Akretio SPRL :: Powered by Kelare