PHP - Simple Social Network System: Mysql Query Help Needed

Hi,

I'm a bit of a newbie when it comes to PHP. I'm a thirs year music/music tech student and for my disseration I took a very ambitious task. I want to create a sort of social networking site for musicians. But I wanted to create it dynamically using PHP and MySQL. I want to basically allow users to register and sign up with their details basically. But the first problem I came across was actually making a custom registration page,  I wanted things such as post codes (zip codes) so that I would then have a Google Maps overlay showing where users were. So that you could 'see' you local music 'scene'.
So far I've been playing around with Joomla, Drupal and WordPress. I tried writing the PHP from scratch but after following various tutorials, but I had no luck what-so-ever with that approach. So I started using content management systems, which got me a lot closer, but I found I couldn't really edit custom registration pages etc. And the I would have no idea how to get the Google maps idea working.
If anyone could nudge me in the right direction and give me a few tips and ideas as to how I'm most likely to achieve this then please reply, I would be highly grateful for you responses.

Thanks,

Ewan Valentine.

I'm writing a mini social network and I'm having trouble figuring out how to deal with privacy settings.
I have established a range of privacy options (level 1-4): 1. Only Facebook friends can see profile (users connect via FB) 2. Only current classmates 3. Past + current classmates 4. All users in given group
I am writing a function to return a list of available users based on a given parameter (eg. Find all classmates of a user). Obviously I have to respect users privacy settings, so I thought to query against all users with level 2 permissions, however I realise that I may miss out some classmates who are FB friends but have permission levels set to 1.

Secondly, I'm looking to find out the relationship between two users (a function that I can plug in 2 user IDs and return their relationship...classmates, FB friends, past classmates, no relationship) which I can then use to determine whether a user has permission to view another users profile.

I don't have much code as of yet, because I spent a long time exploring one avenue which I now realise to be the wrong one!

Any suggestions/help would be greatly appreciated!

I am creating a simple social network, and i want the post visible only on its circle of friends but the problem is...
let say user_a, user_b, user_c already registered and user_a and user_c connected/friends already and all their posts and comments are visible on their circle
but when user_b write a post oh his wall, it's also visible to user_a and user_c which i dont want to happen. I dont know what was wrong on codes below.
 
CREATE TABLE IF NOT EXISTS `user`(
    `uid` INT(11) AUTO_INCREMENT PRIMARY KEY NOT NULL,
    `uname` VARCHAR(25) NOT NULL,
    `pword` CHAR(60) NOT NULL,
    `fullname` VARCHAR(30) NOT NULL,
    INDEX(`uname`)
) Engine = InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;

CREATE TABLE IF NOT EXISTS `friend`(
    `fid` INT(11) AUTO_INCREMENT PRIMARY KEY NOT NULL,
    `friend_id` INT(11) NOT NULL,
    `my_id` INT(11) NOT NULL,
    `stat` ENUM('0','1') NOT NULL,
    INDEX(`friend_id`, `my_id`),
    FOREIGN KEY(`friend_id`) REFERENCES `user`(`uid`)
    ON UPDATE CASCADE
    ON DELETE CASCADE
) Engine = InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_general_ci;

public function viewFriendIfExistOnTbl($uid)
    {
        $query = $this->mysqli->query("SELECT `friend_id` FROM `friend` WHERE `my_id` = '$uid' LIMIT 1");
        if ($query->num_rows > 0) {
            return true;
        }
    }
 

 So I would like it as a custom script or as a wordpress plugin.

The features a


I would like to build a social network.
The main to features I’m interested in:
1. Member can join only by invitation. The person that invites another person must write a review about the invited person, add a photo, what he does, share the name and contact: email, phone, city, connected to ( until here all these is mandatory in order for the person to join the network ) and website link ( optional ).
Only then the person that is invited will receive an email with a link from where to register his account. ( this only for members that will have the right to invite others. For the other type only the admin has the right to make it from just a member, a member with invitation rights. In this case the member will receive an email with a link registration ).
The review of a member can be edited only the member who introduced that person in the network ( and the admin ). In case of any edit there will be a notification for the admin with the original version and the new version. The admin of the site has to allow the modification in order for the review to change.
2. The person that is already in the network can invite a number of … ( this will be fixed and determined by the admin. However the admin can raise the number of invitation for a particular member at his will ). This applies for the 2 types of invitations.
There will be 2 types of invitations: to join the network and have the right to invite others OR only member ( no right to invite others ).
When a person registers to the network, the one who invited him will have one less invitation for the type of member he introduced ( member with invitation rights or member ).
If a member wants to invite more people than his invitation are, then it can purchase invitations ( both types ) for different prices ( example: 1 invitations 10$, 2 invitations – 40$ - value determined by the admin ). So a payment integration is needed ( Paypal ).
The exception for all this: if a visitor wants to join the network without any invitation he can only pay his way in. However this option will be displayed on the public pages. After payment confirmation the visitor can be redirected to the register page. Admin will make the account active. A sign “paying member” will be shown on this member profile page.

After a member is registered and logs in to his account will have the right to:
- Add more photos
- Add more website links
- Add more details at his contact information
- Change his unique number.
- Have the option to add members ( both types )
- Add updates to his wall.
- Search and contact other members via email.
So once you log in to the account there is no restriction ( within the network ) or no difference from what you can do on other social sites.

Search:
First the search will be done in the reviews and after that on the post that members made.
The search results will be displayed in the same order ( the words from the reviews will have priority and after that will be displayed the content from posts – that will be arranged in chronologic order – last one will be the first ).
But a member can filter those results – review only or posts only.
Sponsored bids will be displayed first.

The handshake section:
Here you will be notified if one of your “looking for” or “offering” announces has expired. When expired the announcement can’t be find on searches or on your profile page.
The notification will be active for 7 days. By active I mean: if you click the notification it will take you to the announcement and there you will have an option – make active ( so that other can find the announcement in their searches or in your profile ) another 30 days.

The Admin section:
The site will be default “no robots” ( not indexed by search engines ). However an option should be in the admin to switch from off “no robots”. This option will apply only for the internal part – profile pages. The pages and link on the first page ( what is public ) can be indexed by search engines.
A simple editor from where you can create pages ( something like the section pages in Wordpress ). Any page you create will appear on the first page.
After a period of time a member with invitation rights will receive invitation. Example: after one year you will have an extra one invitation for both types of member. What is needed in the admin: a section from where you can modify this time ( time should be in months and the admin will enter the number – example if he puts 1 – that means after 1 month will receive invitation. There should be 2 sections: one time for members that can invite, and one for members only ).
A section where you can limit the number of entries for “looking for” and “offering”
The section from where you can edit the html code.
An option to send newsletters.
You will receive and email if another person contacted you via internal email section.
Option to delete members.
 

Hi phpfreaks members,

I got a little social network website, http://www.tranceprofile.com

I got a php script for members to log in to my website.
When they are logged in they can view there own profile and edit it.

I got my login script on two places, http:www.tranceprofile.com/login.php
and my index.php page.

Well here is my problem: When they log in they are send to my index.php page as a logged in user.
I want them to be redirected to the http://www.tranceprofile.com/profile.php page.

I hope you guys can help me out!

Best regards, Mitch Oosterhuis.

Login script:

<table width="400" align="center" cellpadding="6" style="background-color:#FFF; border:#666 1px solid;">
  <form action="login.php" method="post" enctype="multipart/form-data" name="signinform" id="signinform">
    <tr>
      <td width="23%"><font size="+2">Log In</font></td>
      <td width="77%"><font color="#FF0000"><?php print "$errorMsg"; ?></font></td>
    </tr>
    <tr>
      <td><strong>Email:</strong></td>
      <td><input name="email" type="text" id="email" style="width:60%;" /></td>
    </tr>
    <tr>
      <td><strong>Password:</strong></td>
      <td><input name="pass" type="password" id="pass" maxlength="24" style="width:60%;"/></td>
    </tr>
  <tr>
      <td align="right">&nbsp;</td>
      <td><input name="remember" type="checkbox" id="remember" value="yes" checked="checked" />
        Remember Me</td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td><input name="myButton" type="submit" id="myButton" value="Sign In" /></td>
    </tr>
    <tr>
      <td>&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td colspan="2">Forgot your password? <a href="forgot_pass.php">Click Here</a>
  <br /></td>
    </tr>
    <tr>
      <td colspan="2">Need an Account? <a href="register.php">Click Here</a><br />        <br /></td>
    </tr>
  </form>
</table>