How do I add something to members profile that only admins can edit?

[TheJkWhoSaysNi]

How could I add something to the members profile?

What I want is an option in the profile that only I can edit thats like

"Member of UD  [combobox Yes/No]" how would I go about making that? i'm sure its not that hard.

[Godai]

it isn't, wait until tomorrow and i'll post instructions for you, now i have to go from office to home

[Godai]

Ok let's start, now i'll show you how to add a field to compile with text or a checkbox to check/uncheck.

The file you have to edit is Profile.php:

we have to load the var we need:

search:

Code Select Expand

$request = mysql_query("SELECT passwd,realName,emailAddress,websiteTitle,websiteUrl,signature,posts,memberGroup,ICQ,AIM,YIM,gender,personalText,avatar,dateRegistered,location,birthdate,timeFormat,timeOffset,hideEmail,ID_MEMBER FROM {$db_prefix}members WHERE memberName='$user'");
and add the var (we can call it test) in this way:

Code Select Expand

$request = mysql_query("SELECT passwd,realName,emailAddress,websiteTitle,websiteUrl,signature,posts,memberGroup,ICQ,AIM,YIM,gender,personalText,avatar,dateRegistered,location,birthdate,timeFormat,timeOffset,hideEmail,ID_MEMBER,test FROM {$db_prefix}members WHERE memberName='$user'");
we now need to define the default value:

search:

Code Select Expand

$memsettings['location'] = isset($memsettings['location'])?$memsettings['location']:'';
and add before:

Code Select Expand

$memsettings['test'] = isset($memsettings['test'])?$memsettings['test']:'';
now we set that only admins can view this option:

search:

Code Select Expand

   <td width="45%"><font size=2><b>$txt[86]: </b></font></td>
   <td><font size=2><input type=text name=settings6 size=4 value="$memsettings[6]"></font></td>
      </tr><tr>
and, to make it a filed to compile, add before:

Code Select Expand

   <td width="45%"><font size=2><b>$txt[test]: </b></font></td>
   <td><input type="text" name="test" size="30" value="$memsettings[test]"></font></td>
     </tr><tr>
or, to make it a checkbox, add before:

Code Select Expand

   <td width="45%"><font size=2><b>$txt[test]</b></font></td>
   <td><input type="checkbox" name="test"$memsettings[test]></td>
     </tr><tr>
naturally the var $txt[test] must be defined in english.lng

when you save the profile the var must be saved:

search:

Code Select Expand

      $request = mysql_query("UPDATE {$db_prefix}members SET $queryPasswdPart realName='$member[name]',emailAddress='$member[email]',websiteTitle='$member[websitetitle]',websiteUrl='$member[websiteurl]',signature='$member[signature]',posts=$member[settings6],memberGroup='$member[settings7]',ICQ='$member[icq]',AIM='$member[aim]',YIM='$member[yim]',gender='$member[gender]',personalText='$member[usertext]',avatar='$member[userpic]',dateRegistered='$member[dr]',location='$member[location]',birthdate='$member[bday]',timeFormat='$member[usertimeformat]',timeOffset=$timeOffest,hideEmail=$hideEmail WHERE memberName='$user'");
and add the var test in this way:

Code Select Expand

      $request = mysql_query("UPDATE {$db_prefix}members SET $queryPasswdPart realName='$member[name]',emailAddress='$member[email]',websiteTitle='$member[websitetitle]',websiteUrl='$member[websiteurl]',signature='$member[signature]',posts=$member[settings6],memberGroup='$member[settings7]',ICQ='$member[icq]',AIM='$member[aim]',YIM='$member[yim]',gender='$member[gender]',personalText='$member[usertext]',avatar='$member[userpic]',dateRegistered='$member[dr]',location='$member[location]',birthdate='$member[bday]',timeFormat='$member[usertimeformat]',timeOffset=$timeOffest,hideEmail=$hideEmail,test='$member[test]' WHERE memberName='$user'");
now you have to create in your db a column at the end of members table, it must be called as the var (test in this case) and the data type must be TINYTEXT

in this way you have a new profile setting, but you must decide how to use it

[Godai]

My post screwed the page, must be a bug

[Joseph Fung]

You think it's a bug cause we didn't force your code to wordwrap? LOL

[Godai]

you didn't format the [code] tag box so i joked about this, i was not serious

[TheJkWhoSaysNi]

well it kinda worked, I now see an extra chekbox that wont save, the text wont display (does it matter where i put it in english.lng?) and it wont save, also, how do I display it if you view someones profile it will say "Member of UD: Yes/no"?

[Godai]

If you tell me exactly what you want to do i can give you an exact example.

P.S, have you created the column in the right table?

[TheJkWhoSaysNi]

All I want is a checkbox in peoples profiles that only admins can edit. it will be "Membmer of UD" and a checkbox then, in the persons profile I want it to say "Member of UD: [Yes/no]"

[Godai]

So the instructions are right, you may send your sources to me. I can do the chagens for you and then comment the lines added

[rican5vl]

I love it when you programmers talk code to each other lol



Rican

[TheJkWhoSaysNi]

me, programmer? lol, Godai did all the work, I just copied and pasted


Godai you should have my sources any minute.

[Godai]

Received the mail, i'll work on your sources on sunday

[irbrian]

Wow, Godai.. wanna solve my problems too?  

[Godai]

Arghhhh i forgot thid question

excuse me!!!!