You can download the updated project here:http://wikisend.com/download/907522/changesDone.zip
1.) You will find a file called alterVerify.sql
. The first alter in that file will fix the verify issue. It is important that you run all of the alters.
2.) The site will no longer allow you to sign up with an email address that has already been used.
3.) Refreshing pages will no longer cause previous posts to repost
4.) When signing up, users will select two groups "State And City". You can, of course, change those labels.
When you select a "State", the city menu is populated. Currently, there is only 1 association because I am not familiar with Bosnian Geography.
If you look at the database, you will see that the groups table now has a field called state. The state field holds the group_id of the state to which the field belongs. So, for instance, if you look at the record for Zvornik, it's state field hold 28. 28 is the group_id for Sarajevo. That means that Zvornik belongs to Sarajevo.
So, you will want to go through the database and enter the associations. The way the program works, if a state fields is NULL, then it is a "State". If the state field is not null, then it is obviously a "City" that belongs to the indicated state.
Currently, you can see this working with Sarajevo and Zvornik. Choose Sarajevo in the registration and Zvornik appears in the second drop-down menu. Once you have updated those associations in the database, the functionality will work for all states/cities.
Keep in mind that users who you registered prior to this change do not have two groups. So their feed page will have a button that just says "Feed". Users can no longer sign up with just a single feed. So that is not actually a bug. If you want, you can update the database to set the existing users to have a second group. For instance:
UPDATE friends SET group_id2 = 41;
That should set all existing users to Zvornik so that you do not run into the problem with users who have only one group while testing.
After registering with the new two-group system and verifying the account, you will see that there are now three buttons on the feed page: one for each of the groups, and one for the friend feed. The functionality is rather self-explanatory.
Let me know if you have any questions. I'm here to help.
Please remember to rate my answer. Thank you so much!