We build. You grow.

Get best community software here

Start a social network, a fan-site, an education project with oxwall - free opensource community software

Help me to transfer photos | Forum

Damien
Damien Aug 14 '13

Hello,

Again excuse my English

I always want to transfer my old site on the CMS Oxwall.

I've managed to be transferred users, comments, votes, friends, subscriptions, avatars.

But I still miss the photos and forum.


And I'm stuck on the photos!

Because my old site recovered the photos url in the database.

Oxwall uses a prefix and id to find the photo.

The problem is that I have 44800 photos, and 3 dimensions, its done 134400 photos to rename in conjunction with database id !

Here is what I did:








My server is not powerful enough to treat such a Quantity of data, and I can set limits on the result sql query, but I have another big problem!

My server reads about 15,000 files per folder on the FTP.

This is why in my old site, I had several folders for photos.


someone would have a solution for me?


Thank you very much in advance

The Forum post is edited by Damien Aug 14 '13
Damien
Damien Aug 15 '13

I found a solution by itself.

As they say, sleep on!


And done, I added a column "url" in the table "photo" of my database.

And I added a condition to the php function "getPhotoFullsizeUrl ()" and "getPhotoUrl()"












thank you

The Forum post is edited by Damien Aug 15 '13