Scratch

WindowsExplorer_2 · 2011-09-10 14:40:03

I think there should be a feature that allows people to change there usernames. People could have an account id that stays the same, so people would still know who they are, and it would message all teh user's friends telling them that they changed their name, and all the forum posts and comments would be updated with their username. I think this should be a feature.

WindowsExplorer · 2011-09-10 14:42:11

By teh way, I'm WindowsExplorer_2!

Medic · 2011-09-10 17:23:06

I think zis vould be nice, but vat if a hacker tried to change zeir username to zomevone else's?

WindowsExplorer · 2011-09-10 17:36:08

Medic wrote:
I think zis vould be nice, but vat if a hacker tried to change zeir username to zomevone else's?

They could just ban the hacker's ip, and change the username back. You could make it so that you would have to wait 24 hours before changing your username again, and once a username is changed, you have to wait 24 hours before someone else could use the old username!

cheddargirl · 2011-09-11 01:05:08

WindowsExplorer_2 wrote:
I think there should be a feature that allows people to change there usernames. People could have an account id that stays the same, so people would still know who they are, and it would message all teh user's friends telling them that they changed their name, and all the forum posts and comments would be updated with their username. I think this should be a feature.

The database system is set up in a way such that it is not possible to code something that will allow someone to change their username. Sorry.

jji7skyline · 2011-09-11 01:18:26

Maybe it could be possible after a complete overhaul of the website along with Scratch 2.0? smile

JJROCKER · 2011-09-11 03:10:23

I don't think this would work out for many many reasons.

WindowsExplorer · 2011-09-11 03:20:08

cheddargirl wrote:
WindowsExplorer_2 wrote:
I think there should be a feature that allows people to change there usernames. People could have an account id that stays the same, so people would still know who they are, and it would message all teh user's friends telling them that they changed their name, and all the forum posts and comments would be updated with their username. I think this should be a feature.
The database system is set up in a way such that it is not possible to code something that will allow someone to change their username. Sorry.

How come it allows you to change passwords?

bbbeb · 2011-09-11 03:26:06

cheddargirl wrote:
WindowsExplorer_2 wrote:
I think there should be a feature that allows people to change there usernames. People could have an account id that stays the same, so people would still know who they are, and it would message all teh user's friends telling them that they changed their name, and all the forum posts and comments would be updated with their username. I think this should be a feature.
The database system is set up in a way such that it is not possible to code something that will allow someone to change their username. Sorry.

How so? It's not that complicated. Just use MySQL and replace all the username database writings with the new username...

cheddargirl · 2011-09-11 03:26:22

jji7skyline wrote:
Maybe it could be possible after a complete overhaul of the website along with Scratch 2.0?

Probably not. Website overhaul doesn't really apply to the database system, just the way the website looks. If I'm not mistaken, the username is the primary key, so to have the ability to change usernames, you would have to overhaul the database entries to make something else the primary key (which is probably not practical considering there are 800,000+ users and 2,000,000+ projects).

Last edited by cheddargirl (2011-09-11 03:27:17)

WindowsExplorer · 2011-09-11 03:28:11

cheddargirl wrote:
jji7skyline wrote:
Maybe it could be possible after a complete overhaul of the website along with Scratch 2.0?
Probably not. Website overhaul doesn't really apply to the database system, just the way the website looks. If I'm not mistaken, the username is the primary key, so to have the ability to change usernames, you would have to overhaul the database (which is probably not practical considering there are 800,000+ users and 2,000,000+ projects).

Eh, okay, whatever that means...

scimonster · 2011-09-11 04:10:39

cheddargirl wrote:
jji7skyline wrote:
Maybe it could be possible after a complete overhaul of the website along with Scratch 2.0?
Probably not. Website overhaul doesn't really apply to the database system, just the way the website looks. If I'm not mistaken, the username is the primary key, so to have the ability to change usernames, you would have to overhaul the database entries to make something else the primary key (which is probably not practical considering there are 800,000+ users and 2,000,000+ projects).

Actually, I think it mainly runs on IDs. wink Think about the URL to your icon, friends list, gallery list, etc.

cheddargirl · 2011-09-11 04:12:51

WindowsExplorer wrote:
cheddargirl wrote:
jji7skyline wrote:
Maybe it could be possible after a complete overhaul of the website along with Scratch 2.0?
Probably not. Website overhaul doesn't really apply to the database system, just the way the website looks. If I'm not mistaken, the username is the primary key, so to have the ability to change usernames, you would have to overhaul the database (which is probably not practical considering there are 800,000+ users and 2,000,000+ projects).
Eh, okay, whatever that means...

XD, okay, I'll try to explain it a little better (I guess database management talk is confusing to some people). tongue Just for clarification: A primary key in a database is something that uniquely identifies something and is never repeated. In the case of Scratch users database, it's the username. For the most part, primary keys are usually left alone and not manipulated too much (you'll see why below).

When you upload a project, one piece of info that gets attached to the project is the name of the project creator. So If I wanted to pull up projects you created, I would look up your name in a list of 2,000,000+ projects to see which one contains your name attached to it. If names could be changed that means one would have to go through all the projects and change the data attached to the projects you uploaded - that's a strain on the site if a lot of people did that and did it often.

In the case of a tl;dr moment: the ability to change usernames isn't so bad if the database is small, but the Scratch database is pretty big.

Oh boy, I hope that's clear to understand. tongue

Last edited by cheddargirl (2011-09-11 04:42:13)

cheddargirl · 2011-09-11 04:28:04

scimonster wrote:
cheddargirl wrote:
jji7skyline wrote:
Maybe it could be possible after a complete overhaul of the website along with Scratch 2.0?
Probably not. Website overhaul doesn't really apply to the database system, just the way the website looks. If I'm not mistaken, the username is the primary key, so to have the ability to change usernames, you would have to overhaul the database entries to make something else the primary key (which is probably not practical considering there are 800,000+ users and 2,000,000+ projects).
Actually, I think it mainly runs on IDs. Think about the URL to your icon, friends list, gallery list, etc.

True, but just from talking with other ST members and the way the system is set to search for data, it seem like most main entries are majorly username based, not ID number based - for example, even if gallery URLS are based on ID numbers, the admin panel uses usernames for searching up information, and not IDs. Maybe ID number is used as a foreign key for some aspects and not used as a foreign key in others. Or it's possible that username and ID number is a compound key. I suppose we could speculate all day on the exact nature of the database, but that's kind of beyond the main point of changing usernames.

Anyway, I do recall something said by and ST member saying how changing usernames was impossible to be changed for reasons of searching ability problems, that's a pretty big indicator that username is at least one of the primary keys used, if not a compound key of some sort. wink

Last edited by cheddargirl (2011-09-11 04:51:22)

WindowsExplorer · 2011-09-11 04:28:08

Ok. Does this mean you would still be able to change my username manually if I requested it? I would like to change it to Gopher, or something cooler!

cheddargirl · 2011-09-11 04:31:47

WindowsExplorer wrote:
Ok. Does this mean you would still be able to change my username manually if I requested it? I would like to change it to Gopher, or something cooler!

It's not doable at this point. Unfortunately, like all name change requests, you'll need to start off with a new account if you wish to change your username.

WindowsExplorer · 2011-09-11 04:35:29

cheddargirl wrote:
WindowsExplorer wrote:
Ok. Does this mean you would still be able to change my username manually if I requested it? I would like to change it to Gopher, or something cooler!
It's not doable at this point. Unfortunately, like all name change requests, you'll need to start off with a new account if you wish to change your username.

CosmicProjectz · 2011-09-13 22:11:18

WindowsExplorer wrote:
cheddargirl wrote:
WindowsExplorer_2 wrote:
I think there should be a feature that allows people to change there usernames. People could have an account id that stays the same, so people would still know who they are, and it would message all teh user's friends telling them that they changed their name, and all the forum posts and comments would be updated with their username. I think this should be a feature.
The database system is set up in a way such that it is not possible to code something that will allow someone to change their username. Sorry.
How come it allows you to change passwords?

Passwords don't display on forum posts, galleries, or projects.

acedannyk · 2011-09-18 06:48:33

Sounds like a lot of inconvenience and unnecessary hassle sad

Scratch

archived forums

#1 2011-09-10 14:40:03

Changing Usernames

#2 2011-09-10 14:42:11

Re: Changing Usernames

#3 2011-09-10 17:23:06

Re: Changing Usernames

#4 2011-09-10 17:36:08

Re: Changing Usernames

Medic wrote:

#5 2011-09-11 01:05:08

Re: Changing Usernames

WindowsExplorer_2 wrote:

#6 2011-09-11 01:18:26

Re: Changing Usernames

#7 2011-09-11 03:10:23

Re: Changing Usernames

#8 2011-09-11 03:20:08

Re: Changing Usernames

cheddargirl wrote:

WindowsExplorer_2 wrote:

#9 2011-09-11 03:26:06

Re: Changing Usernames

cheddargirl wrote:

WindowsExplorer_2 wrote:

#10 2011-09-11 03:26:22

Re: Changing Usernames

jji7skyline wrote:

#11 2011-09-11 03:28:11

Re: Changing Usernames

cheddargirl wrote:

jji7skyline wrote:

#12 2011-09-11 04:10:39

Re: Changing Usernames

cheddargirl wrote:

jji7skyline wrote:

#13 2011-09-11 04:12:51

Re: Changing Usernames

WindowsExplorer wrote:

cheddargirl wrote:

jji7skyline wrote:

#14 2011-09-11 04:28:04

Re: Changing Usernames

scimonster wrote:

cheddargirl wrote:

jji7skyline wrote:

#15 2011-09-11 04:28:08

Re: Changing Usernames

#16 2011-09-11 04:31:47

Re: Changing Usernames

WindowsExplorer wrote:

#17 2011-09-11 04:35:29

Re: Changing Usernames

cheddargirl wrote:

WindowsExplorer wrote:

#18 2011-09-13 22:11:18

Re: Changing Usernames

WindowsExplorer wrote:

cheddargirl wrote:

WindowsExplorer_2 wrote:

#19 2011-09-18 06:48:33

Re: Changing Usernames

Board footer