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>