phpbb -> SMF converter

b0x · December 18, 2004, 05:51:17 AM

I used the converter and it worked miracles. The only problem I had was the converter copying nearly all directories from my old install (Mambo+phpbb) to the avatars directory. One of those directories (admin) got a different UID (apache) so I was unable to delete those myself (my host did). I thought I'd just let you know!

Thanks for a great product!

[Unknown] · December 18, 2004, 06:11:11 PM

Hmm... did you choose to convert attachments?

-[Unknown]

b0x · December 19, 2004, 12:57:26 PM

No, I didn't have the attachment mod installed so I skipped that part.

packman · December 19, 2004, 05:30:21 PM

Could you please look in your phpbb_config table and let us know what the config_value is for the records with config_name =

avatar_path
avatar_gallery_path

I'm wondering if one (or both) of those are set to the root folder, or perhaps don't exist, and that's causing the converter to copy the whole directory structure?

b0x · December 20, 2004, 05:58:30 AM

I looked at a backup of my old database:
...('avatar_path','images/avatars'),('avatar_gallery_path','images/avatars/gallery'),('smilies_path','images/smiles')...

packman · December 20, 2004, 08:09:26 AM

That looks OK. Do both the named avatar directories exist? Also are there any linked files or directories from the avatar directories?

[Unknown] · December 20, 2004, 02:45:11 PM

Quote from: packman on December 20, 2004, 08:09:26 AM
That looks OK. Do both the named avatar directories exist? Also are there any linked files or directories from the avatar directories?

I would guess he has some avatar with the path "../.." or something as it's filename.

-[Unknown]

b0x · December 20, 2004, 08:04:03 PM

Both directories exist.
Here's a list of the avatar directory (list.txt is this file):

Volume in drive F is Data 2
Volume Serial Number is 8B69-FA72

Directory of F:\forum\images\avatars

21-12-2004 01:58 <DIR> .
21-12-2004 01:58 <DIR> ..
18-12-2004 01:10 <DIR> gallery
18-12-2004 01:10 179 index.htm
21-12-2004 01:58 0 list.txt
2 File(s) 179 bytes

Directory of F:\forum\images\avatars\gallery

18-12-2004 01:10 <DIR> .
18-12-2004 01:10 <DIR> ..
18-12-2004 01:10 <DIR> findingnemo
18-12-2004 01:10 179 index.htm
18-12-2004 01:10 <DIR> liloandstitch
18-12-2004 01:10 <DIR> lionking
18-12-2004 01:10 <DIR> looneytunes
18-12-2004 01:10 <DIR> monstersinc
18-12-2004 01:10 <DIR> muppets
18-12-2004 01:10 <DIR> onlineavatar
18-12-2004 01:10 <DIR> sesamestreet
18-12-2004 01:10 <DIR> shrek
18-12-2004 01:10 <DIR> spongebob
18-12-2004 01:10 <DIR> toystory
18-12-2004 01:10 <DIR> toystory2
18-12-2004 01:10 <DIR> winnethepooh
1 File(s) 179 bytes

Directory of F:\forum\images\avatars\gallery\findingnemo

18-12-2004 01:10 <DIR> .
18-12-2004 01:10 <DIR> ..
18-12-2004 01:10 2.926 Anchor.gif
18-12-2004 01:10 5.933 Bloat.gif
18-12-2004 01:10 5.972 Bruce.gif
18-12-2004 01:10 5.518 Bubbles.gif
18-12-2004 01:10 3.253 Chum.gif
18-12-2004 01:10 4.728 Crush.gif
18-12-2004 01:10 6.464 Deb (and Flo).gif
18-12-2004 01:10 4.550 Dory.gif
18-12-2004 01:10 4.297 Gill.gif
18-12-2004 01:10 4.509 Gurgle.gif
18-12-2004 01:10 4.539 Jacques.gif
18-12-2004 01:10 6.298 Marlin.gif
18-12-2004 01:10 6.288 Nemo.gif
18-12-2004 01:10 3.165 Nigel.gif
18-12-2004 01:10 6.987 Peach.gif
18-12-2004 01:10 4.900 Sheldon.gif
18-12-2004 01:10 5.279 Squirt.gif
18-12-2004 01:10 6.122 Tad.gif
18 File(s) 91.728 bytes

Directory of F:\forum\images\avatars\gallery\liloandstitch

18-12-2004 01:10 <DIR> .
18-12-2004 01:10 <DIR> ..
18-12-2004 01:10 2.439 David.gif
18-12-2004 01:10 5.119 Jumba.gif
18-12-2004 01:10 5.920 Lilo.gif
18-12-2004 01:10 6.117 Nani.gif
18-12-2004 01:10 4.177 Pleakley.gif
18-12-2004 01:10 5.449 Stitch.gif
6 File(s) 29.221 bytes

Directory of F:\forum\images\avatars\gallery\lionking

18-12-2004 01:10 <DIR> .
18-12-2004 01:10 <DIR> ..
18-12-2004 01:10 4.575 Bonzai.gif
18-12-2004 01:10 5.169 Ed.gif
18-12-2004 01:10 6.713 Grown-up Simba.gif
18-12-2004 01:10 6.666 Mufasa.gif
18-12-2004 01:10 4.735 Nala.gif
18-12-2004 01:10 4.757 Pumbaa.gif
18-12-2004 01:10 5.975 Rafiki.gif
18-12-2004 01:10 5.137 Scar.gif
18-12-2004 01:10 4.027 Shenzi.gif
18-12-2004 01:10 4.927 Simba.gif
18-12-2004 01:10 4.382 Timon.gif
18-12-2004 01:10 3.695 Zazu.gif
12 File(s) 60.758 bytes

Directory of F:\forum\images\avatars\gallery\looneytunes

18-12-2004 01:10 <DIR> .
18-12-2004 01:10 <DIR> ..
18-12-2004 01:10 5.457 Bugs Bunny.gif
18-12-2004 01:10 5.128 Daffy Duck.gif
18-12-2004 01:10 6.245 Elmer Fudd.gif
18-12-2004 01:10 5.828 Granny.gif
18-12-2004 01:10 5.704 Marvin the Martian.gif
18-12-2004 01:10 5.205 Pepe Le Pew.gif
18-12-2004 01:10 5.199 Porky Pig.gif
18-12-2004 01:10 5.731 Speedy Road Runner.gif
18-12-2004 01:10 5.005 Sylvester.gif
18-12-2004 01:10 6.500 Taz.gif
18-12-2004 01:10 5.490 Tweety Bird.gif
18-12-2004 01:10 6.362 Wile E. Coyote.gif
12 File(s) 67.854 bytes

Directory of F:\forum\images\avatars\gallery\monstersinc

18-12-2004 01:10 <DIR> .
18-12-2004 01:10 <DIR> ..
18-12-2004 01:10 6.507 Boo.gif
18-12-2004 01:10 6.887 CDA.gif
18-12-2004 01:10 6.873 Celia.gif
18-12-2004 01:10 6.858 George Sanderson.gif
18-12-2004 01:10 6.614 Henry J. Waternoose, III.gif
18-12-2004 01:10 7.048 Mike Wazowski.gif
18-12-2004 01:10 6.595 Needleman.gif
18-12-2004 01:10 6.452 Randall Boggs.gif
18-12-2004 01:10 6.255 Roz.gif
18-12-2004 01:10 5.461 Smitty.gif
18-12-2004 01:10 7.026 Sulley.gif
18-12-2004 01:10 7.342 Yeti.gif
12 File(s) 79.918 bytes

Directory of F:\forum\images\avatars\gallery\muppets

18-12-2004 01:10 <DIR> .
18-12-2004 01:10 <DIR> ..
18-12-2004 01:10 6.189 Animal.gif
18-12-2004 01:10 3.702 Beaker.gif
18-12-2004 01:10 7.195 Beauregard.gif
18-12-2004 01:10 5.664 Captain Link Hogthrob.gif
18-12-2004 01:10 6.926 Crazy Harry.gif
18-12-2004 01:10 5.954 Dr. Bunsen Honeydew.gif
18-12-2004 01:10 6.910 Dr. Teeth.gif
18-12-2004 01:10 6.685 Fozzie Bear.gif
18-12-2004 01:10 4.945 Gonzo the Great.gif
18-12-2004 01:10 5.547 Janice.gif
18-12-2004 01:10 5.574 Kermit the Frog.gif
18-12-2004 01:10 6.462 Lew Zealand.gif
18-12-2004 01:10 6.692 Miss Piggy.gif
18-12-2004 01:10 7.072 Rowlf the Dog.gif
18-12-2004 01:10 5.090 Sam the Eagle.gif
18-12-2004 01:10 5.596 Scooter.gif
18-12-2004 01:10 5.722 Statler.gif
18-12-2004 01:10 5.919 The Swedish Chef.gif
18-12-2004 01:10 6.307 Waldorf.gif
18-12-2004 01:10 6.183 Zoot.gif
20 File(s) 120.334 bytes

Directory of F:\forum\images\avatars\gallery\onlineavatar

18-12-2004 01:10 <DIR> .
18-12-2004 01:10 <DIR> ..
18-12-2004 01:10 4.112 flashavatar.jpg
18-12-2004 01:10 3.304 flashavatargreen.jpg
18-12-2004 01:10 3.799 flashavatarorange.jpg
18-12-2004 01:10 3.894 flashavatarpurple.jpg
18-12-2004 01:10 4.317 htmlavatar.jpg
18-12-2004 01:10 3.412 htmlavatargreen.jpg
18-12-2004 01:10 3.916 htmlavatarorange.jpg
18-12-2004 01:10 4.004 htmlavatarpurple.jpg
18-12-2004 01:10 4.521 mysqlavatar.jpg
18-12-2004 01:10 3.501 mysqlavatargreen.jpg
18-12-2004 01:10 4.145 mysqlavatarorange.jpg
18-12-2004 01:10 4.209 mysqlavatarpurple.jpg
18-12-2004 01:10 4.682 phpavatar.jpg
18-12-2004 01:10 3.641 phpavatargreen.jpg
18-12-2004 01:10 4.170 phpavatarorange.jpg
18-12-2004 01:10 4.373 phpavatarpurple.jpg
16 File(s) 64.000 bytes

Directory of F:\forum\images\avatars\gallery\sesamestreet

18-12-2004 01:10 <DIR> .
18-12-2004 01:10 <DIR> ..
18-12-2004 01:10 5.094 Elmo.gif
1 File(s) 5.094 bytes

Directory of F:\forum\images\avatars\gallery\shrek

18-12-2004 01:10 <DIR> .
18-12-2004 01:10 <DIR> ..
18-12-2004 01:10 4.858 Donkey.gif
18-12-2004 01:10 5.780 Dragon.gif
18-12-2004 01:10 5.240 Fiona.gif
18-12-2004 01:10 6.054 Lord Farquaad.gif
18-12-2004 01:10 5.575 Shrek.gif
5 File(s) 27.507 bytes

Directory of F:\forum\images\avatars\gallery\spongebob

18-12-2004 01:10 <DIR> .
18-12-2004 01:10 <DIR> ..
18-12-2004 01:10 4.199 Mr. Krabs.gif
18-12-2004 01:10 2.885 Patrick.gif
18-12-2004 01:10 4.282 Sandy.gif
18-12-2004 01:10 5.619 SpongeBob.gif
18-12-2004 01:10 3.786 Squidward.gif
5 File(s) 20.771 bytes

Directory of F:\forum\images\avatars\gallery\toystory

18-12-2004 01:10 <DIR> .
18-12-2004 01:10 <DIR> ..
18-12-2004 01:10 5.340 Andy.gif
18-12-2004 01:10 5.741 Bo Peep.gif
18-12-2004 01:10 6.161 Buzz Lightyear.gif
18-12-2004 01:10 6.023 Hamm.gif
18-12-2004 01:10 6.527 Mr. Potato Head.gif
18-12-2004 01:10 6.847 Mutant Toy.gif
18-12-2004 01:10 5.611 Rex.gif
18-12-2004 01:10 5.605 Sid.gif
18-12-2004 01:10 6.014 Slinky Dog.gif
18-12-2004 01:10 5.974 Woody.gif
10 File(s) 59.843 bytes

Directory of F:\forum\images\avatars\gallery\toystory2

18-12-2004 01:10 <DIR> .
18-12-2004 01:10 <DIR> ..
18-12-2004 01:10 6.083 Al.gif
18-12-2004 01:10 5.556 Bullseye.gif
18-12-2004 01:10 6.207 Buzz Lightyear.gif
18-12-2004 01:10 5.662 Jessie.gif
18-12-2004 01:10 6.222 Mrs. Potato Head.gif
18-12-2004 01:10 6.301 Prospector.gif
18-12-2004 01:10 5.572 Wheezy.gif
18-12-2004 01:10 5.743 Woody.gif
8 File(s) 47.346 bytes

Directory of F:\forum\images\avatars\gallery\winnethepooh

18-12-2004 01:10 <DIR> .
18-12-2004 01:10 <DIR> ..
18-12-2004 01:10 6.831 Eeyore.gif
18-12-2004 01:10 6.159 Piglet.gif
18-12-2004 01:10 6.343 Pooh.gif
18-12-2004 01:10 5.855 Tigger.gif
4 File(s) 25.188 bytes

Total Files Listed:
132 File(s) 699.920 bytes
44 Dir(s) 3.086.434.304 bytes free

[Unknown] · December 21, 2004, 05:17:42 AM

A windows server, is it?

Can you run this query...?

Code Select

SELECT user_avatar
FROM phpbb_users
WHERE INSTR(user_avatar, '..') OR INSTR(user_avatar, '/') OR INSTR(user_avatar, '\\');

What is phpMyAdmin?

-[Unknown]

b0x · December 21, 2004, 04:46:26 PM

Just restored the database.

I ran the query and got a list of the avatars members were using. Most of the links were to the corresponding avatars others linked to off-site avatars. No entries seemed odd to me (but heh, I've been wrong before

). I'll send you the results through a pm.

News:

phpbb -> SMF converter