conn=$conn;
$form->setgroup(array('public'));
if (isset($row['userid'])) {
$form->addcontrol('HIDNUM',$prepend.'userid',$row['userid']);
}
$form->addcontrol('editnote','','
Username and passwords are
case-sensitive, please remember how you typed them in.
(Special thanks to Zeno for the extended
descriptions)
');
$form->addcontrol('text','username',$row['username'],'Username (Just for Logging In):','',16);
$form->addcontrol('password','password',$row['password'],'Password:','[[:alnum:]]+',16);
$form->addcontrol('text','name',$row['name'],'Name (used for comments and artist credit):','',64);
$form->addcontrol('text','email',$row['email'],'Email:','',255);
$form->addcontrol('text','homepage',$row['homepage'],'Homepage:','',255);
$form->addcontrol('date','birthday',$row['birthday'],'Birthday (Used to wish you a happy birthday on the board):','',64);
$form->addcontrol('select','sortpref','','Default Sorting Preferences:');
$form->addoption('Newest Picture',0,$row['sortpref']==0?1:0);
$form->addoption('Newest Comment',1,$row['sortpref']==1?1:0);
$form->addcontrol('select','rpp','','Pictures per page:');
$form->addoption('5',5,$row['rpp']==5?1:0);
$form->addoption('10',10,$row['rpp']==10?1:0);
$form->addoption('15',15,$row['rpp']==15?1:0);
$form->addoption('20',20,$row['rpp']==20?1:0);
$form->addoption('25',25,$row['rpp']==25?1:0);
$form->addcontrol('chexbox','anim',$row['anim'],'Default to save animation?');
$form->addcontrol('select','profileid','','Profile Picture:');
$res=sqlexec("select * from pictures where userid=$auth_userid and stop!='0'");
$form->addsqloptions($res,'pictureid',array('title','description'),$row['profileid']);
$form->addcontrol('select','appletversion','string','Applet Version:');
$applets=getapplets();
while(list($file,$name)=each($applets)) {
$form->addoption($name,$file,$row['appletversion']==$file?1:0);
}
$form->addcontrol("SUBMIT","submit",$name);
return $form;
}
function auth_user_apdform($form,$userid) {
global $action,$filename;
global $hostsiteid;
$value=array();
if ($userid) {
$res=sqlexec("select cf.name,ua.value from customfields cf, useranswers ua where
ua.userid=$userid and ua.customfieldid=cf.customfieldid");
while($row=sqlgetrow($res)) {
echo "Got ".$row['name']." = ".$row['value']." \n";
$value[$row['name']]=$row['value'];
}
}
$res=sqlexec("select name,type from customfields where
siteid='$hostsiteid'order by ordernum");
while($row=sqlgetrow($res)) {
$okname=strtolower(eregi_replace(' ','',$row['name']));
$form->addcontrol($row['type'],$okname,$value[$row['name']],ucfirst($row['name']).':','',40);
}
return $form;
}
function auth_user_apdproc($userid) {
global $hostsiteid;
$form=getauth_userform(0,'','');
$form=auth_user_apdform($form,0);
sqlexec("delete from useranswers where userid=$userid");
$res=sqlexec("select * from customfields where
siteid='$hostsiteid'order by ordernum");
while($row=sqlgetrow($res)) {
$okname=strtolower(eregi_replace(' ','',$row['name']));
$cnt=$form->findcontrolnum($okname,array('public'));
if ($cnt>0) {
list($val,$retype)=$form->accept_control($cnt,array('public'));
} else {
$val='';
}
sqlexec("insert into useranswers (userid,customfieldid,value) values
($userid,".$row['customfieldid'].",'$val')");
}
}
function auth_user_debug() {
$form=getauth_userform(0,'','');
$form->debugform();
}
function auth_user_del($id) {
sqlexec("delete from auth_users where userid=$id");
log_transac("auth_user","remove",$id,"");
}
function auth_user_new($params="") {
$form=getauth_userform(0,'ins','',$params);
# unset($form->controls[$form->control]);
$form->control--;
# $form=auth_user_apdform($form,0);
$form->addcontrol("SUBMIT","submit",'Add User');
echo $form->generate("edit",array('public'));
}
function auth_user_upd($id) {
$form=getauth_userform($id,'ins','Update User');
$check=$form->check_results(array('public'));
if ($check != "") {
echo 'You left out ' . $check;
exit;
}
$form->update_table("auth_users","userid='$id'",array('public'));
# auth_user_apdproc($id);
log_transac("auth_user","edit",$id,"");
}
function auth_user_browse() {
$result=sqlexec("select * from auth_users");
auth_user_display($result);
}
function auth_user_showsignups() {
$res=sqlexec("select au.* from auth_users au LEFT JOIN
auth_members am on
au.userid=am.userid where am.groupid=0");
auth_user_display($res);
}
function auth_user_display($result='') {
global $filename;
if ($result=='') {
$result=sqlexec("select * from auth_users");
}
echo 'Add New User ';
# $result=sqlexec("select * from auth_users");
echo '
';
}
}
function auth_user_edit($id,$params="") {
$form=getauth_userform($id,'upd','Update User',$params);
$form->addcontrol('HIDDEN','id',$id);
# $form=auth_user_apdform($form,$id);
echo $form->generate("edit",array('public'));
}
function auth_user_ins($id) {
$form=getauth_userform(0,'ins','Update User');
$check=$form->check_results(array('public'));
if ($check != "") {
echo 'You left out ' . $check;
exit;
}
$id=$form->insert_results('auth_users',array('public'));
log_transac("auth_user","inserted",$id,"");
# auth_user_apdproc($id);
return $id;
}
function auth_user_view($id) {
$form=getauth_userform($id,'','');
echo $form->generate("view",array('public'));
}
function auth_user_remove($id) {
$form=getauth_userform($id,'','');
echo $form->generate("view",array('public'));
echo '
Are you sure you would like to remove this record?
';
echo '
';
echo '
';
echo '';
echo '
';
}
function auth_user_search() {
global $rpp,$strict,$ses;
if (empty($strict)) { $strict=0; }
$form=getauth_userform(0,'','');
$result=$form->get_search_results('auth_users',array('public'),'',$strict);
$oldrpp=$rpp; $rpp=0;
$sql=getsqlq();
$ses->set_var(getauthses(),'auth_user_query',$sql);
auth_user_display($result);
$rpp=$oldrpp;
}
// Don't think this function is used anymore
function auth_user_profile($id) {
global $ses,$auth_sid;
include "interfaces/picture.php3";
$res=sqlexec("select * from pictures p,auth_users a where p.name='$id' and p.userid=a.userid");
$row=sqlgetrow($res);
echo "
Profile for [".$row['name']."]
\n";
//echo '
PROFILE
';
//var_dump($row);
if ($row['profileid']) {
picture_view($row['profileid']);
}
$res=sqlexec("select hexcolor,sum(pixels) as spix
from pictures p, histograms h
where p.userid=".$row['userid']." and
p.pictureid=h.pictureid
group by hexcolor order by spix DESC limit 1");
list($hx,$spx)=sqlgetrow($res);
echo $row['name']."'s favorite color (by pixel): $hx ($spx) ";
$res=sqlexec("select hexcolor,count(pixels) as spix
from pictures p, histograms h
where p.userid=".$row['userid']." and
p.pictureid=h.pictureid
group by hexcolor order by spix DESC limit 1");
list($hx,$spx)=sqlgetrow($res);
echo $row['name']."'s favorite color (by picture): $hx ($spx) ";
$sql="select * from pictures where userid=".$row['userid']." and stop!='0' and anonymous=0";
$ses->set_var($auth_sid,'picture_query',$sql);
picture_display();
}
?>