Image in profile

This hack was requested by NerdNations.

Here is what you need to do to add a image field to user profiles.

That's it.

[Chris M]

Thanks Zzed...

:tup:

Satan

[Zzed]

Originally posted by MrLister

375 hp, 362 tq

Is that at the flywheel or front wheels?

Mine are rear wheel numbers.

[MartynJ]

Seems like an excellent hack, but all I get when I try to use it is:

Warning: Unexpected character in input: '\' (ASCII=92) state=1 in C:\Program Files\Apache Group\Apache2\htdocs\member.php on line 2

Parse error: parse error, unexpected T_STRING in C:\Program Files\Apache Group\Apache2\htdocs\member.php on line 2

Is this the revenge of PHP4.2?

[NSeXcellent]

Originally posted by MrLister
nice car.. i'm betting my mx-6 could take you

Custom installed body kit (fiber-glass)
greddy dual exhaust
16 psi
basch platinum plugs
strut tower bars
2 inch koniing adjustable coilovers
Magnecor Wires
JL Audio 12W6 Subs
Cone Filter
new cold air intake.

hehe ok i'm getting carried away. think vB. btw no i don't have a picture at the moment.

I'll take a piece of that action! And now you all see where i get this username from...

[Keith]

I'm using 2.2.5, only the URL is coming up and I've double checked the location. What am I missing?

[Keith]

nevermind, I'm an idiot!! Loaded up the member.php file into the wrong directory (portals root) by mistake. Works great, thanks for the hack!!

[globalwin]

this might be daft, but how do I link an image? I cant seem the guess the syntax

[Zzed]

Originally posted by globalwin
this might be daft, but how do I link an image? I cant seem the guess the syntax

It's just a URL, no BB tags are needed.

[Keith]

Zzed, this is the weirdest thing. The hack worked great when I installed it yesterday, I input my URL and it appears. I tried to input the info myself as admin level access into 2 users profile. the reason is, one of them put a URL in and it just showed the white box with an x. When I checked their URL, it was fine.

I then saw this error when I tried to save his record:

Database error in vBulletin Control Panel 2.2.5:

Invalid SQL: SELECT userid
					FROM user
					WHERE username='bsurguy'
						AND userid <> 
mysql error: You have an error in your SQL syntax near '' at line 4

mysql error number: 1064

The referring script is listed as ..../forums/forums/admin/user.php

I only have 1 forums directory, so it should be ...forums/admin/user.php Where might I find the problem here? Confused.

Great hack by the way!

[Keith]

From that user.php file, here's the code, but this doesn't appear to be a problem:

if ($exists=$DB_site->query_first("SELECT userid
					FROM user
					WHERE username='".addslashes(htmlspecialchars($ausername))."'
						AND userid <> $userid")) {
		echo "There is already an ".makelinkcode('user',"user.php?do=edit&userid=$exists[userid]",1)." named <b>".htmlspecialchars($ausername)."</b>";
		exit;
	}

I replaced the member.php with my original, and deleted the field in the template, but still get the same error now. Any ideas?