The sql tag has no wiki summary.
11
votes
3answers
311 views
What are the common security flaws I need to look for? [closed]
As a wannabe WP plugin developper, what are the main security flaws/holes I should look for?
I'm about to create a new plugin with a configuration panel (ie input fields and stuff). What should I be ...
2
votes
2answers
2k views
Query between two meta values?
How do I limit the query by two custom meta fields, a start date and an end date? This is what my data looks like:
meta_key | meta_value |
------------------------|
start_date | 20100131 | //Jan ...
0
votes
3answers
621 views
How do I move a Wordpress site to another server?
i'm using this sql..
but it does not work
UPDATE wp_options SET option_value = replace(option_value, 'http://old.com, 'http://new.com') WHERE option_name = 'home' OR option_name = 'siteurl';
UPDATE ...
3
votes
2answers
153 views
Sharing database for collaborative development
Is there a straightforward way to share/sync multiple WP instances with a single database? I work collaboratively with several developers on custom themed sites. We use git to keep our files in order ...
3
votes
1answer
667 views
Is it possible to wrap Geo Location search around WP_Query?
I'll just like to add that I have a current working solution in place and works well but I'm looking for ideas of being able to do it better or cleaner if possible.
We have hundreds of properties in ...
2
votes
3answers
3k views
Pagination with custom SQL query
I have my own SQL string to select Custom Post Type posts with specific WHERE clause. I've used the offset and limit to return appropriate posts depending on a page being displayed. That's working ...
0
votes
2answers
265 views
Moving an entire wordpress site from one domain to a new domain and database
I have done all the steps requiered to import the dump.sql file to new database, and copiey the entire content from the old domain over to the new one.
When i login to mydomain/wp-admin, i'm ...
4
votes
1answer
68 views
prepare() not working
When I do this:
$transients = $wpdb->get_col(
"
SELECT option_name
FROM $wpdb->options
WHERE option_name
LIKE '_transient_wb_tt_%'
"
);
It works ...
2
votes
1answer
164 views
Bulk add tag (or any sort of label) to posts who have custom excerpt
The situation is the following:
The blog as of now has 2200+ posts. In the beginning (2007/2008) I was using manual excerpts where I would put an image and a little bit of text. The manual excerpt ...
2
votes
2answers
211 views
Moving database with phpMyAdmin
I have a remote (website) version of a wordpress site and it's got more recent information than my local (computer) version.
I would like to move the data over to my local using phpMyAdmin, what is ...
2
votes
1answer
227 views
Querying Email Addresses for a List of Users with Same Last Name?
I have a site with many users and many of them have the same last name. I want to get the emails of all the users with the same last name (IE: Smith) that has a post related to a particular taxonomy ...
0
votes
2answers
56 views
Up/Down voting system for Wordpress
Looking in all posts with keywords "voting system, upvote, downvote", I can't find a satisfying solution for this issue, except accepting one of the available plugins, spend a lot of time undersanding ...
0
votes
2answers
97 views
Error establishing a database connection After Copy localhost wordpress site (with site url directly to hosting server's url before copy)
I have a localhost site that I heard I can migrate the site by just copy and paste the whole site from local to host if I changed WordPress Address (URL) and Site Address (URL) to my current hosted ...
