0
votes
0answers
4 views

Getting duplicate rows in database through custom hardcoded signup page using Cimy User Extra Fields for autochimp sync

I have a custom coded sign up page where users fill in additional fields beyond the standard username and email. My end goal is to have these additional fields sync with my mailchimp mailing list. I ...
0
votes
0answers
37 views

problem in sql syntax

problem in Mashable Slider Clone plugin when upload it in server WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for ...
0
votes
2answers
702 views

Woocommerce: Grab total revenue of a product over all orders

I need to display the total revenue of all orders for my products depending on if the logged-in user is the author of the product or not. I can't use the Quantity field as a multiplier either because ...
2
votes
1answer
81 views

What is the easiest way to implement cascading database upgrade for my plugin?

Lets assume following situation: I develop a plugin. The plugin requires custom database table to store some kind of information. From month to month I release new versions of my plugin. Different ...
0
votes
1answer
1k views

Using AJAX to run sql statement and populate dropdown

I am trying to create a search where the user select two different bit of data from databases and it them prints some results that meet requirements. I know I need to use ajax or something similar but ...
1
vote
4answers
284 views

Retrieving a Value from a wp-database

why my sql statement is not returning any value.. is this wrong? <?php global $wpdb; $result = $wpdb->get_results($wpdb->prepare("SELECT * FROM ...
2
votes
2answers
4k views

What's the easiest way to duplicate an entire navigation menu?

What's the easiest way to duplicate an entire navigation menu? I don't care if it involves SQL commands or whatnot. I just have some really big menus that I'd like to duplicate. Didn't see a plugin to ...
6
votes
1answer
3k views

Making my plugin multi-site compatible

I want my plugin to be installed on each blog and create database tables per blog. I have this code: register_activation_hook( __FILE__, 'install1' ); function install1() { global $wpdb; if ...
2
votes
2answers
167 views

How can I get a list of plugins and which blogs are using them?

I'm about to upgrade my Wordpress MU installation to wordpress 3 Before I update, I want to find out which blogs use which plugins. I don't see a way to do that in the UI, is there? What about a ...
0
votes
1answer
418 views

Speeding SQL queries for a large database?

I am using a WordPress plugin called feedwordpress in order to run a planet like website on wordpress (See it here). The plugin is great except for one thing - it hogs down my (VPS) server into ...
13
votes
3answers
407 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 ...