I need some simple db fix. You can send me code to run it on phpmyadmin or send me a php script. Pl quote me price as well. 1. I have the following fields in the db, if there is no value in the fields, I want you to fill in some value: Actress --> if no value --> fill in some value Video code --> if no value --> fill in some value Nationality --> if no value --> fill in some value 2. There is a post slug filed in the db. I want to remove all special characters e.g. !',"....... 3. Modify the following fields post_date_gmt, post_modified and post_modified_gmt. For example: if post_date = 2008-01-07 04:48:00 then : post_date_gmt = 2008-01-07 10:48:00 (6 hours ahead of post_date) post_modified = 2008-01-07 04:47:00 (1 min before the post_date) post_modified_gmt = 2008-01-07 10:47:00 (6 hours ahead of post_modified) Thanks.
This looks like a fairly simple PHP job. You can PM me the info but my suggestion would be to give me a full .sql dump let me modify the data on my end and return the data converter. I would also supply the code as well. This would keep things transparent to your users or scripts that might be reading/writing this data. We can discuss pricing in a PM. Looking forward to hearing from you. Also have MSN
I'll supply you php code for those job, just give me table name and structure, user and password that has access to database ( minimum access is fine for editing specific table ). Just run the script and all your problem fixed. PM me so we can discuss or chat via messenger (I only have YM).