style-image-add.xql
DB Query file
Related Files
[ hide source ] | [ make this the default ]
File Contents
<?xml version="1.0"?> <queryset> <fullquery name="wp_style_img_insert"> <querytext> insert into wp_style_images(style_id, file_size, file_name, wp_style_images_id) values(:style_id, :n_bytes, :client_filename, :revision_id) </querytext> </fullquery> <fullquery name="get_bg_image_id"> <querytext> select background_image from wp_styles where style_id = :style_id </querytext> </fullquery> <fullquery name="update_bg_image"> <querytext> update wp_styles set background_image = :revision_id where style_id = :style_id </querytext> </fullquery> </queryset>