drop down user list

[skidpics]

Just noticed this in the uploadphoto.php file.

I removed the comment block, but it doesn't work..

//if you have a low number of users you can use this drop down list box, otherwise you have to input the name manually
//$useroptions = "<select name=\"upuser\"><option selected=\"userid\" value=\"{$User['userid']}\">{$User['username']}</option>";
//$useroptions .= useropts();
//$useroptions .= "</select>";

[Chuck S]

You would need to actually comment out the other useroptions lines in uploadphoto.php to see a difference.

Content visible to verified customers only.

[skidpics]

I thought about that after I posted the post. It is an interesting little gem undiscovered by most admins. Thanks!

[Chuck S]

Not a problem glad to help.

[skidpics]

On anything I choose, I get error user not found..

[Chuck S]

Please post a url and a test login

[skidpics]

Cannot PM you the details..

Chuck S has chosen not to receive private messages or may not be allowed to receive private messages. Therefore you may not send your message to him/her.

[Chuck S]

It is fine to post a url here and a test user login non admin. You can do that or email support. That is correct I do not use the PM system here.

[skidpics]

Your username is: chuck
Your new password is: REMOVED



Skidpics - Free Photo Sharing,Free Wallpaper and Free Screensavers - Main Index

[Chuck S]

I have removed the password please make that user an admin or email us an admin login

regular users dont seem to be affected

Skidpics - Free Photo Sharing,Free Wallpaper and Free Screensavers - chuck Gallery

[Chuck S]

I made a slight change to the code in post 2 as this is way old code reapply and see if that helps.

[skidpics]

Originally Posted by Chuck S

I have removed the password please make that user an admin or email us an admin login

regular users dont seem to be affected

Skidpics - Free Photo Sharing,Free Wallpaper and Free Screensavers - chuck Gallery

User is admin now. applying the code right now also..
..

Code modification did not work.
what was changed?

[Chuck S]

Basically upuser is a username variable not userid that old legacy code passes upuser as the userid not username so I simply changed the code to username

Try this

Content visible to verified customers only.

change to this

Content visible to verified customers only.

[Chuck S]

Then in your integration file photopost.php make sure the useropts function is this

Content visible to verified customers only.

[skidpics]

With the change in photopost.php, I am getting this error:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/vande11/public_html/skidpics/forums/photopost.php on line 78

[Chuck S]

Wow that function is archaic. Reapply the code edit above in photopost.php

[skidpics]

same error. perhaps I should just leave it as is.. since the coding is so old?

actually, the userid is not changed to upuser in the code you posted ?

[skidpics]

yea, I replaced userid with upuser and that didn't work either.

[Chuck S]

The edit in uploadphoto.php should remain as posted in post 13. My last post explained to update the user options function in post 14 as thats where I made the change to that query

drop down user list

[skidpics]

I applied the below to uploadphoto.php:

if ( $Globals['vbversion'] == "fusion" || $Globals['vbversion'] == "threads" || $Globals['vbversion'] == "threads7" )
{
$useroptions = "<select name=\"upuser\"><option selected=\"userid\" value=\"{$User['login']}\">{$User['username']}</option>";
$useroptions .= useropts();
$useroptions .= "</select>";
}
else
{
$useroptions = "<select name=\"upuser\"><option selected=\"userid\" value=\"{$User['username']}\">{$User['username']}</option>";
$useroptions .= useropts();
$useroptions .= "</select>";
}

and this to photopost.php:

function useropts() {
global $Globals, $db_link;

$useropts = "";

$queryv = ppmysql_query("SELECT userid,username FROM {$Globals['pp_db_prefix']}users ORDER BY name",$db_link);
while ( list( $userid, $username ) = mysql_fetch_row($queryv) ) {
$useropts .= "<option value=\"$username\">$username</option>";
}

return( $useropts );
}

still getting:
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/vande11/public_html/skidpics/forums/photopost.php on line 78