Đang Thực Hiện

143242 Image move script

I need a script that follows the rough outline below. The script would move images to a new user directory structure. You should have Ymsg, MSN or AIM (not looking to play email tag) to discuss the setup.

1. Connect to mysql table

2. Goto table "rate_members" collect member ids and there join dates from each row.

Fields "m_id" (member ID) and "m_date" (join date)

3. Translate "m_date" mysql has the 01/23/2006 dates saved as intergers INT. decode and get yr 2006 and month 06

4. Goto table "rate_pictures" (use fields i_users, i_id and i_private), using "m_id" and "m_date" Query...

grab all row matches for where m_id matches i_users and if "i_private" = 0 or 2.

5. Move images: Using data collect, if go to /home/srv1/public_html/images/pictures/ copy "m_id"-"i_d".* ([url removed, login to view]) to

- check to see if folder exist if not create folder, with chown permission 'srv1' (or should i use nobody?)

/home/imgsrv/public_html/ (user Join Year) / (user Join Month) /imgPub (if i_private = 0, public move image here)/

/home/imgsrv/public_html/ (user Join Year) / (user Join Month) /imgExp (if i_private = 2, explicit move image here)/

move thumbnails:

go to /home/srv1/public_html/images/thumbnails/ move images to:

- /home/imgsrv/public_html/ (user Join Year) / (user Join Month) /imgPub (if i_private = 0, public move image here)/imgTmb/

- /home/imgsrv/public_html/ (user Join Year) / (user Join Month) /imgExp (if i_private = 2, explicit move image here)/imgTmb/

File move should look like this when complete (example)

/home/imgsrv/public_html/2006/04/imgPub/[url removed, login to view]

/home/imgsrv/public_html/2006/04/imgPub/imgTmb/[url removed, login to view]

/home/imgsrv/public_html/2006/04/imgExp/[url removed, login to view]

/home/imgsrv/public_html/2006/04/imgExp/imgTmb/[url removed, login to view]

[url removed, login to view] private images (/home/srv1/private/pictures/)

same concept, if i_private = 1 then move images from /home/srv1/private/pictures/ to:

- /home/imgsrv/public_html/ (user Join Year) / (user Join Month) /imgPvt (if i_private = 1, private move image here)/

7. Move thumbs for private images /home/srv1/private/thumbnails/

- /home/imgsrv/public_html/ (user Join Year) / (user Join Month) /imgPvt (if i_private = 1, private move image here)/imgTmb/

8. Query rate_mobile_pics table grab fields "mob_id" (picture #) and "mob_user" (member #)

compare "mob_user" to rate_pictures "m_id" check to see if member still exist, if yes grab m_date.

use mob_user or m_id (they're both the member id) and move images

move from /home/srv1/public_html/images/mobile_pics/ to

/home/imgsrv/public_html/ (user Join Year) / (user Join Month) /imgMob/

then move thumbs: /home/srv1/public_html/images/mobile_thumbs/ to

/home/imgsrv/public_html/ (user Join Year) / (user Join Month) /imgMob/imgTmb/

Kỹ năng: Bất kì công việc gì, MySQL, PHP

Xem thêm: data structure concept, image copy, grab pictures, php mysql join table, check permission file, mysql join table, compare exist, mysql table join, image thumbs, mysql data grab, mysql grab, explicit, table month php, thumbs image, php mysql permission, translate mysql, month collect data, decode data, image table, check table mysql script, chown, chown user, image folder, mysql data directory, email image

Về Bên Thuê:
( 12 nhận xét ) Duluth, United States

Mã Dự Án: #1889418

Đã trao cho:

gothicreaper220

It is a simple database extraction and move with simple logic. I can have this done in a day. I have many messengers. See PMB for a question.

$30 USD trong 1 ngày
(0 Đánh Giá)
0.0