Changeset 496

Show
Ignore:
Timestamp:
08/11/06 14:24:53 (2 years ago)
Author:
ben
Message:

It turns out the replace function is standard ... therefore enabled in Postgres too. Hooray!

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • devel/lib/db/postgres7.php

    r495 r496  
    290290        // Clean up slashes 
    291291         
    292         // TODO: bring queries from mysql.php over in a Postgres compatible form. 
     292        execute_sql("update {$CFG->prefix}weblog_posts set title = replace(title,'\\\'','\'')"); 
     293        execute_sql("update {$CFG->prefix}weblog_posts set title = replace(title,'\\\"','\"')"); 
     294        execute_sql("update {$CFG->prefix}weblog_posts set body = replace(body,'\\\'','\'')"); 
     295        execute_sql("update {$CFG->prefix}weblog_posts set body = replace(body,'\\\"','\"')"); 
     296         
     297        execute_sql("update {$CFG->prefix}weblog_comments set body = replace(body,'\\\'','\'')"); 
     298        execute_sql("update {$CFG->prefix}weblog_comments set body = replace(body,'\\\"','\"')"); 
     299        execute_sql("update {$CFG->prefix}weblog_comments set postedname = replace(postedname,'\\\'','\'')"); 
     300        execute_sql("update {$CFG->prefix}weblog_comments set postedname = replace(postedname,'\\\"','\"')"); 
     301         
     302        execute_sql("update {$CFG->prefix}tags set tag = replace(tag,'\\\'','\'')"); 
     303        execute_sql("update {$CFG->prefix}tags set tag = replace(tag,'\\\"','\"')"); 
     304         
     305        execute_sql("update {$CFG->prefix}files set title = replace(title,'\\\'','\'')"); 
     306        execute_sql("update {$CFG->prefix}files set title = replace(title,'\\\"','\"')"); 
     307        execute_sql("update {$CFG->prefix}files set description = replace(description,'\\\'','\'')"); 
     308        execute_sql("update {$CFG->prefix}files set description = replace(description,'\\\"','\"')"); 
     309         
     310        execute_sql("update {$CFG->prefix}file_folders set name = replace(name,'\\\'','\'')"); 
     311        execute_sql("update {$CFG->prefix}file_folders set name = replace(name,'\\\"','\"')"); 
     312         
     313        execute_sql("update {$CFG->prefix}profile_data set value = replace(value,'\\\'','\'')"); 
     314        execute_sql("update {$CFG->prefix}profile_data set value = replace(value,'\\\"','\"')"); 
     315         
     316        execute_sql("update {$CFG->prefix}users set name = replace(name,'\\\'','\'')"); 
     317        execute_sql("update {$CFG->prefix}users set name = replace(name,'\\\"','\"')"); 
     318         
     319        execute_sql("update {$CFG->prefix}groups set name = replace(name,'\\\'','\'')"); 
     320        execute_sql("update {$CFG->prefix}groups set name = replace(name,'\\\"','\"')"); 
    293321         
    294322    }