Mysidia Adoptables Support Forum - A quick Profile Add-on Modification

Mysidia Adoptables Support Forum (http://www.mysidiaadoptables.com/forum/index.php)

- Addons/Mods Graveyard (http://www.mysidiaadoptables.com/forum/forumdisplay.php?f=41)

- - A quick Profile Add-on Modification (http://www.mysidiaadoptables.com/forum/showthread.php?t=820)

A quick Profile Add-on Modification

Like the title says, a quick Profile Add-on Modification.
What does that mean?
I will show you how to make a new profile add-on, and make it work ;)

Profile Add-on Includes:

How to add a new option in your account.php file
How to make it so it shows up in your profile.php

Will Include:

A more advanced looking account.php
A friends option
A 'customize' your own profile option.

Preview:]
(Image is too large for page.)
http://i43.tinypic.com/2s6sm5e.jpg

First things first, whatever you want to add to your profile/account file, you MUST add to your database, and to do that, all you need to do, is come up with a name, and place into your 'adopts_user' table.
For the sake of this tutorial, I will be showing you how to add a very simple 'about me' section to your profile.

So go ahead and add this to your 'adopts_user' table:

Code:

`aboutme` varchar(5000) NOT NULL,

Next, go to your account.php file, and find where it says:

PHP Code:


		
			

// Get the user's account details from the database...

$query = "SELECT * FROM ".$prefix."users WHERE username='$loggedinname'";
$result = mysql_query($query);
$num = mysql_numrows($result);

//Loop out code
$i=0;
while ($i < 1) {

And place the following two things, in the appropriate groups:

PHP Code:


		
			
$aboutme=@mysql_result($result,$i,"ame");

PHP Code:


		
			
$ame = stripslashes($ame);

Then scroll down, to where it says:

PHP Code:


		
			
// Show the form...

if($newmessagenotify == 1){
$box = "<input name='newmsgnotify' type='checkbox' id='newmsgnotify' value='1' checked>";
}
else{
$box = "<input name='newmsgnotify' type='checkbox' id='newmsgnotify' value='1'>";
}

$article_content = $article_content."<br><br><br><br><br>

<form name='form1' method='post' action='accountpost.php'>

And insert the following any where in that form:

PHP Code:


		
			
  <p>About Me: <br>
    <textarea name='aboutme' type='text' id='aboutme' cols='40' rows='3'>".$ame."</textarea>
</p>

Now that's it for the account.php file.

Now go to your accountpost.php file, and find where it says:

PHP Code:


		
			
else if($act == "changesettings"){

// We are changing the settings

$newmsgnotify = $_POST["newmsgnotify"];
$newmsgnotify = preg_replace("/[^a-zA-Z0-9@._-]/", "", $newmsgnotify);
$newmsgnotify = secure($newmsgnotify);

And place the following in that group:

PHP Code:


		
			
$aboutme = $_POST["aboutme"];
$aboutme = secure($aboutme);

Then scroll down to where it says:

PHP Code:


		
			
// Run update queries...

$query = "UPDATE ".$prefix."users SET newmessagenotify='".$newmsgnotify."' WHERE username='".$loggedinname."'";
mysql_query($query);

And place the following in that group:

PHP Code:


		
			
$query = "UPDATE ".$prefix."users SET aboutme='".$aboutme."' WHERE username='".$loggedinname."'";
mysql_query($query);

Now before we do ANYTHING else, go to your register.php file, and find where it says:

PHP Code:


		
			

        mysql_query("INSERT INTO ".$prefix."users VALUES ('', '$username', '$pass1', '$email', '3', '1', '$date', '0')");

And add this to the end:

Note: it is not a quotation mark, it is a double tick ' and '

PHP Code:


		
			
, ''

So it looks like this:

PHP Code:


		
			

        mysql_query("INSERT INTO ".$prefix."users VALUES ('', '$username', '$pass1', '$email', '3', '1', '$date', '0', '')");

Now, to make this all show up on your profile page ;D

Go to your profile.php and find where it says:

PHP Code:


		
			
if($user != ""){

// We have specified a specific user who we are showing a profile for...
// See if the user exists...

    $query = "SELECT * FROM ".$prefix."users WHERE username = '".$user."'";
    $result = mysql_query($query);
    $num = mysql_numrows($result);

    if($num > 0){

    $i=0;
    while ($i < 1) {

And place the following in a that group:

PHP Code:


		
			
    $aboutme=@mysql_result($result,$i,"aboutme");

Now you can add the part where if a user hasn't entered anything in for the category, it will say something like "No information given" but, I'm going to show it.

Next scroll down to where it says:

PHP Code:


		
			
    // Show the user's profile page...

And place the following within the '$article_content':

PHP Code:


		
			
<b>About Me:</b><br> ".$aboutme."<br>

And your down. Don't be afraid to ask questions. I won't bite. =D

RE: A quick Profile Add-on Modification

Cool!

However, I am getting an error on the MySQL:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`aboutme` VARCHAR(5000) NOT NULL,' at line 2

RE: A quick Profile Add-on Modification

Quick question. Do you have to add another ,'' at the end of :
mysql_query("INSERT INTO ".$prefix."users VALUES ('', '$username', '$pass1', '$email', '3', '1', '$date', '0', '')");
if you wanted to insert another profile field?

RE: A quick Profile Add-on Modification

Quote:

Originally Posted by rainbelly

That has to do with how you put it in your database. Each new line has to end with a comma.

Quote:

Originally Posted by SJC

Yes you do, lol don't forget that. It will frustrate you beyond belief. ;)

RE: A quick Profile Add-on Modification

Okay, just wanted to make sure :).

RE: A quick Profile Add-on Modification

Quote:

Originally Posted by SJC

Okay, just wanted to make sure :).

Lol okie dokie.
Oh, if you have any suggestions for new modifications, or want something made for your site. Just drop me a PM =D

RE: A quick Profile Add-on Modification

it works fine, but if i add something it only sais on profile "about me:"
after that nothing.

RE: A quick Profile Add-on Modification

Quote:

Originally Posted by mapleblade

it works fine, but if i add something it only sais on profile "about me:"
after that nothing.

Then it has to do with how your calling it on your profile page.
First check to make sure its even going into the database.

RE: A quick Profile Add-on Modification

I have do everything in instructions but profile is not looking like this
http://i43.tinypic.com/2s6sm5e.jpg
And I already have this:
`aboutme` varchar(5000) NOT NULL,
from your other mod

RE: A quick Profile Add-on Modification

Quote:

Originally Posted by 12345

I have do everything in instructions but profile is not looking like this
http://i43.tinypic.com/2s6sm5e.jpg
And I already have this:
`aboutme` varchar(5000) NOT NULL,
from your other mod

Are you sure you added the .html file for the users profile?
Because without that, the profile will not look like its suppose to.

RE: A quick Profile Add-on Modification

Uh oh.... Well, I got up to the bit where you edit the register.php file, and so to be safe I thought I'd try creating another account, right? It told be something was very, very wrong, and I suspect it's the code I put in to register.php. Help?

RE: A quick Profile Add-on Modification

Quote:

Originally Posted by rosepose

Okay I need two things from you.

I need you to copy and paste your current register file here, and I need to how many sets are in your 'adopts_users' table.

RE: A quick Profile Add-on Modification

Oh.... I'm sorry, I undid everything. I'll do it up again on a backup script, hang on....

RE: A quick Profile Add-on Modification

This code rocks, but I have a problem. Is there a way that when the person views the other person's profile, it can also the list their pets? Because if some people don't have anywhere to post their pets, how are they going to advertise them and get more clicks? So I was wondering if you could give me the code so I can add the pets to it.

RE: A quick Profile Add-on Modification

Quote:

Originally Posted by shiningheart

Yes, actually, lol I forgot that I removed that part out, what you need to do is, go to your profile2.php and,

place this:

PHP Code:


		
			
    $query = "SELECT * FROM ".$prefix."owned_adoptables WHERE owner = '".$user."'";

    $result = mysql_query($query);

    $numpets = mysql_numrows($result);

Right after this:

PHP Code:


		
			
    if($yahoo == ""){

    $yahoo = "No YIM Information Given";

    }

    



    $i++;

    }

Then where ever you want the pets to show up, place this into that section (note, the section will look something like $article_content, $about_me, etc.. etc):

PHP Code:


		
			
    <b>Number Of Pets Owned:</b> ".$numpets."<br><br>

    <b><u>".$usersname."'s Pets:</u></b><br><br>

Then, go to the end of the section you placed that bit of code in, (the end of the section will be marked with ";) and immediately after that, place this:

PHP Code:


		
			
    if($numpets > 0){



    $i=0;

    while ($i < $numpets) {



    $aid=@mysql_result($result,$i,"aid");

    $image = getcurrentimage($aid);



    $article_content = $article_content."<a href='levelup.php?id=".$aid."'><img src='".$image."' border='0'></a>";





    $i++;

    }

    }

    else{

    $article_content = $article_content."This user currently does not have any pets.";

    }

You have to make sure you do not place that bit of quote in a section, or else you will get an error.

RE: A quick Profile Add-on Modification

I did exactly what you said but it didnt show up.

http://flaredrhapsody.co.cc/profile2.php?user=shiningheart

It is supposed to show up under Member's Stats, but its not... xDD

RE: A quick Profile Add-on Modification

Quote:

Originally Posted by shiningheart

I did exactly what you said but it didnt show up.

http://flaredrhapsody.co.cc/profile2.php?user=shiningheart

It is supposed to show up under Member's Stats, but its not... xDD

Please copy and paste your profile2.php file here, and ill fix the problem for you.

BTW you turned private messaging off, so I can't reply to your PM's.

RE: A quick Profile Add-on Modification

Oh okay, Oops! And one minute....[hr]

Quote:

<?php

// ************************************************** ********************
// Rusnak PHP Adoptables Script
// Copyright 2009 Brandon Rusnak
// For help and support: http://www.rusnakweb.com/forum/
//
// Redistribution prohibited without written permission
// File ID: profile2.php
// Shows a user profile, or a member list.
// ************************************************** ********************

// Wake the sleeping giant

// ************************************************** ********************
// Basic Configuration Info
// ************************************************** ********************

include("inc/functions.php");
include("inc/config.php");
include("lang/lang.php");

$themeurl = "templates/default/usertemp.html";

$template = replace(':DISPLAYPIC:',$displaypic,$template);
$template = replace(':DISPLAYQUOTE:',$display_quote,$template) ;
$template = replace(':ARTICLESTATS:',$article_stats,$template) ;
$template = replace(':ARTICLEABOUT:',$article_about,$template) ;
$template = replace(':ARTICLEABOUTME:',$aboutme,$template);
$template = replace(':USERCSS:',$usercss,$template);

// ************************************************** ********************
// Define our top links by calling getlinks()
// ************************************************** ********************

$links = getlinks();

// ************************************************** ********************
// Define our ads by calling getads()
// ************************************************** ********************

$ads = getads("any");

// ************************************************** ********************
// Grab any dynamic article content from the content table
// ************************************************** ********************

$pagecontent = getsitecontent("index");
$article_title = $pagecontent[title];
$article_content = $pagecontent[content];
$article_content = nl2br($article_content);

// ************************************************** ********************
// Grab any settings that we will need for the current page from the DB
// ************************************************** ********************

$browsertitle = grabanysetting("browsertitle");
$sitename = grabanysetting("sitename");
$slogan = grabanysetting("slogan");

// ************************************************** ********************
// Check and see if the user is logged in to the site
// ************************************************** ********************

$loginstatus = logincheck();
$isloggedin = $loginstatus[loginstatus];
$loggedinname = $loginstatus[username];

// ************************************************** ********************
// End Prepwork - Output the page to the user
// ************************************************** ********************

// This page handles user profiles and shows the site members...

$user = $_GET["user"];

$user = preg_replace("/[^a-zA-Z0-9\\040.]/", "", $user);

$user = secure($user);

$page = $_GET["page"];

$page = preg_replace("/[^a-zA-Z0-9\\040.]/", "", $page);

$page = secure($page);

if($user != ""){

// We have specified a specific user who we are showing a profile for...

// See if the user exists...

$query = "SELECT * FROM ".$prefix."users WHERE username = '".$user."'";

$result = mysql_query($query);

$num = mysql_numrows($result);

if($num > 0){

$i=0;

while ($i < 1) {

$usersname=@mysql_result($result,$i,"username");

$usersgroup=@mysql_result($result,$i,"usergroup");

$status=@mysql_result($result,$i,"status");

$website=@mysql_result($result,$i,"website");

$aim=@mysql_result($result,$i,"aim");

$yahoo=@mysql_result($result,$i,"yahoo");

$msn=@mysql_result($result,$i,"msn");

$membersince=@mysql_result($result,$i,"membersince ");

$ame=@mysql_result($result,$i,"ame");

$location=@mysql_result($result,$i,"location");

$age=@mysql_result($result,$i,"age");

$occupation=@mysql_result($result,$i,"occupation") ;

$interests=@mysql_result($result,$i,"interests");

$profilepic=@mysql_result($result,$i,"profilepic") ;

$displayquote=@mysql_result($result,$i,"displayquo te");

$usercss=@mysql_result($result,$i,"usercss");

if($website == ""){

$website = "No Website Information Given";

}

else{

$website = "<a href='".$website."' target='_blank'>".$website."</a>";

}

if($msn == ""){

$msn = "No MSN Information Given";

}

if($aim == ""){

$aim = "No AIM Information Given";

}

if($yahoo == ""){

$yahoo = "No YIM Information Given";

}

$i++;

}

$query = "SELECT * FROM ".$prefix."owned_adoptables WHERE owner = '".$user."'";
$result = mysql_query($query);
$numpets = mysql_numrows($result);

$query = "SELECT * FROM ".$prefix."owned_adoptables WHERE owner = '".$user."'";

$result = mysql_query($query);

$numpets = mysql_numrows($result);

// Show the user's profile page...

if($status == "yes") {
$userdisp = "".$usersname."'s Profile
Status: Online!";
}
elseif($status == "") {
$userdisp = "".$usersname."'s Profile Status: Offline!";
}

$article_title = "$userdisp";

$displaypic = "<img src='".$profilepic."'>";
$display_quote = "".$displayquote." ".$userdisp." ";
$aboutme = " About Me: ".$ame." Interests: ".$interests." ";
$article_content = "
".$lang_basic_info."".$usersname.":</a> 
<img src='templates/icons/web.gif'> ".$website." 
<img src='templates/icons/aim.gif'> ".$aim." 
<img src='templates/icons/msn.gif'> ".$msn." 
<img src='templates/icons/yahoo.gif'> ".$yahoo." 
<img src='templates/icons/title.gif'> <a href='messages.php?act=newpm&user=".$usersname."'> Send ".$usersname." a Private Message</a> ";
$article_stats = "
".$usersname."'s Stats:</a> 
Member Since: ".$membersince." 
Number Of Pets Owned: ".$numpets." 
".$usersname."s Pets: ";

if($numpets > 0){

$i=0;
while ($i < $numpets) {

$aid=@mysql_result($result,$i,"aid");
$image = getcurrentimage($aid);

$article_content = $article_content."<a href='levelup.php?id=".$aid."'><img src='".$image."' border='0'></a>";

$i++;
}
}
else{
$article_content = $article_content."This user currently does not have any pets.";
}

$article_about = "
About ".$usersname.":</a> 
Location: ".$location." 
Age: ".$age." 
Occupation: ".$occupation." ";

}

}
// ************************************************** ********************
// Begin Template Definition
// ************************************************** ********************

//Define our current theme
$file = $themeurl;

// Do the template changes and echo the ready template
$template = file_get_contents($file);

$template = replace(':ARTICLETITLE:',$article_title,$template) ;
$template = replace(':ARTICLECONTENT:',$article_content,$templ ate);
$template = replace(':ARTICLEDATE:',$article_date,$template);

$template = replace(':BROWSERTITLE:',$browsertitle,$template);
$template = replace(':SITENAME:',$sitename,$template);

$template = replace(':DISPLAYPIC:',$displaypic,$template);
$template = replace(':DISPLAYQUOTE:',$display_quote,$template) ;
$template = replace(':ARTICLESTATS:',$article_stats,$template) ;
$template = replace(':ARTICLEABOUT:',$article_about,$template) ;
$template = replace(':ARTICLEABOUTME:',$aboutme,$template);
$template = replace(':USERCSS:',$usercss,$template);

//Define our links
$template = replace(':LINKSBAR:',$links,$template);

//Get the content for the side bar...

$sidebar = getsidebar();
$template = replace(':SIDEFEED:',$sidebar,$template);

//Get the ad content...
$template = replace(':ADS:',$ads,$template);

//Get the slogan info
$template = replace(':SLOGAN:',$slogan,$template);

echo $template;

// ************************************************** ********************
// End Template Definition
// ************************************************** ********************

?>

There is the profile2.php code.[hr]
Turned on my Private Messages ;) And thank you for all the help, BTW! :)[hr]
*swingslegswhilewaitingforaresponse* :)[hr]
Okay, I messed with it a bit, and finally, I got the pets to show! *cheers* But now the problem is, for some odd reason, the adoptables are under all the messaging information, instead of under where it says _____ Pets...

RE: A quick Profile Add-on Modification

Then just move

PHP Code:


		
			
<b>Number Of Pets Owned:</b> ".$numpets."<br><br>
<b><u>".$usersname."s Pets:</u></b><br><br>

Around, untill its where you want it.