Tagged Questions
1
vote
1answer
35 views
Is it possible to create Custom Post plug-in?
I understand that Wordpress allows you to create Custom Post Types with Custom Fields, but is it possible to create a custom Plug-In that creates and maintains its own Custom Post type (outside of ...
0
votes
1answer
17 views
Is the wordpress user-model changed in wpmu?
I'm running wpmu on heroku using a postgres extension. It works great, but I have a plugin that needs to get the userId based on the e-mail-adress. This is how it does it:
$sql = 'SELECT id FROM ' . ...
0
votes
1answer
33 views
Insert data in custom table during new post creation
I want to in insert data in my custom db table when creating a post.
Suppose there are three categories (php, wordpress & jquery). When i create a post in wordpress, i want to insert post id and ...
-1
votes
0answers
100 views
Need help to retrive data from MYSQL based on dropdown selection
I am displaying a list of country in the drop down list, retrive it from the database . and i need to display price for the selected country based on the options chosen by the customers in the drop ...
0
votes
1answer
29 views
Get the url of attachments from the post?
I used the following code to get the images attached to a post
$current_id = get_the_ID();
$rows = $wpdb->get_results("select guid from $wpdb->posts where post_parent = $current_id");
...
2
votes
1answer
51 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 ...
1
vote
2answers
67 views
The plugin generated x characters of unexpected output, $wpdb not defined
I've written a simple Wordpress plugin to create a new database table.
The new table ought to be created when the plugin is activated.
When I try to activate the plugin, I get the following error:
...
0
votes
2answers
99 views
How to run Two Wordpress blogs with different themes and with single database and same content
How do you run two Wordpress blogs with different themes using one database where the content remains the same in both sites? The issue that I am getting is at the Domain mapping in both blogs.
2
votes
0answers
98 views
Plugin Not Working, But Only On GoDaddy Hosted site
I'm creating a plugin for a friend to log search terms on his site. It's very basic. It creates a new table to store terms entered in the search box. It converts the search term to lower case, ...
2
votes
3answers
1k views
How do I show data from gravity forms in my template?
Preface
I've installed gravity forms, created a form and users are submitting data to my site.
What I want to do is show the data users are submitting to my site on one of my pages.
I know there's ...
0
votes
1answer
45 views
Is this plugin safe to run?
This is an extract of code from a wordpress plugin. Is it safe to run despite the variables not being filtered? Also does the wpdb class filter to prevent any injection?
list($email_id, $user_id, ...
2
votes
2answers
194 views
Custom database or Custom Post Types?
I have been searching throughout the web for the best way to implement what I need but just cannot find a best solution as there always seems to be some drawback. I'd prefer to do it right the first ...
0
votes
0answers
6 views
What would make a MySQL database create tables in a different collation other than its default? [duplicate]
Possible Duplicate:
Using wpdb to connect to a separate database
am adding tables to a Wordpress database on my localhost and it is changing my collation from utf8_general_ci to ...
0
votes
1answer
196 views
Integrating Custom Database with Wordpress
I Have a Wordpress Site with few users who are my college students
They Registered using their RollNumbers/HallTicket Numbers as their usernames in Wordpress site
Now I Have Another Database with ...
1
vote
1answer
31 views
Building an email signup form. Where should the information be saved in the DB?
I would like to try build a simple plugin that collects and stores the name and email address of the person who filled in the form. I realize there are probably dozens of plugins out there that do ...
0
votes
3answers
125 views
How to empty wordpress custom post Database table
I have around 2000 custom posts. And 7 regular wp pages. I want to delete all those custom post without effecting the pages. I thought the easiest way would be to empty the custom post table but I ...
-1
votes
1answer
31 views
Shortcode returning specific content of a post
I'm currently building a plugin to display specific part of post after accepting verification code. Can a shortcode return a part of a post? I mean:
Bla bla bla
[shortcode postID="100"]
Special bla ...
2
votes
0answers
600 views
Insert query inserts 2 entries, should insert 1
I've written a small posts by views plugin, well at least started one.
My tables are set up but when they are updated the code adds 2 entries into my table when a post is loaded and views are ...
1
vote
2answers
865 views
clean wp_options table unused rows
In my Wordpress Blog site i have installed too much plugin and remove also many plugins. In database table "wp_options" size increases approx 13MB and there are many rows which are unused at this ...
0
votes
1answer
75 views
Making my plugin create a page?
I have created a plugin that creates a table in the database and allows users to add an Item to the table. I would like each item to also create a page for its self so that when the items are listed I ...
0
votes
3answers
70 views
Wordpress : Explain Plugins & Theme string value in database
i have installed wordpress and i i have installed couple of plugins and i have got two themes already came with wordpress.
What i am asking about today is : what does the Plugins & Theme string ...
0
votes
2answers
355 views
Wordpress Settings Lost After Site Migration
I've done my fair share of migrating Wordpress sites, but today I am completely and utterly stumped. I've worked for many hours on this, and I cannot find a solution. I hope someone here can help.
I ...
2
votes
1answer
427 views
How to edit/delete single row items in a table on my own menu page
I have successfully created a wp-LINKS-list-table that displays the output of WP's core "Links" table in the WP Dashboard, and I have it displaying on a menu page I created. Step 1 accomplished!
...
8
votes
3answers
712 views
Is it bad practice to create own table for a plugin?
If I want to save settings for my plugin then it is pretty easy and straight forward.
Now I would like to save to the database a bit more.
A file name, and 3 other values that only apply to that ...
-1
votes
1answer
49 views
database plugin available? [closed]
i am actually looking for a plugin for wordpress to work on the intranet. which can show me the complete database and also that i can make changes to the database and update it then and there! and ...
0
votes
1answer
142 views
How to display results from a data table with an encrypted user id?
I'm trying to display a table of results for particular users who have submitted answers to quizzes. The problem is that the mysql database I am working with has a funky value for the user's ID.
I'm ...
0
votes
1answer
157 views
Default Plugin Settings Not Writing to Database
I have my plugin setup as such:
Main plugin file mouldings.php
<?php
/*
Plugin Name: Moulding Profiles
Plugin URI:
Description: Creates a 'Moulding Profiles' and 'Idea Gallery' custom post ...
0
votes
2answers
54 views
plugin code is pulling information from database in one instance and not in other. What is wrong?
In my plugin code, I am pulling the table id from two tables. The id is being pulled from one table but not from the other and I get errors in both instances. The queries work on mysql when I use ...
0
votes
1answer
372 views
How to make sense of the active_plugins option_value to enable and disable certain plugins from the database?
Can anyone explain how to interpret and make sense of the active_plugins option_value string in WordPress. And then use this string/ array to disable and activate specific plugins?
Here is an ...
0
votes
2answers
240 views
Saving Custom Post types and fields to a custom table
I have a project in which I am trying to import a large amount of data into a WordPress installation and from that data, create pages on my site (as a custom post type). Since these pages will be ...
0
votes
3answers
621 views
Ajax save data to database on document ready, no data being saved
I have written a plugin which collects stats on document ready.
Keep in mind that my database table is already created.
I've added the following code to do the ajax code
add_action( 'wp_head', ...
0
votes
1answer
197 views
Managing database tables in WordPress multisite
I'm working on plugin that creates and stores some data in database table (using global $wpdb->base_prefix). In WordPress multisite I want sub-website owners to have access only to data that they've ...
0
votes
1answer
490 views
“Master” Wordpress Multisite - Database Sync
I've had an idea in my head about creating a Wordpress Multisite environment that would have Plugins along with them that would not only have "default" settings, but be able to update each blog's ...
1
vote
3answers
921 views
Help With MySQL to WPDB Query Conversion
I have a problem. I've got a PHP script that tracks individual file downloads, and I'm looking for a way to display that number in individual posts. I've got a half-baked solution- a plain ol' MySQL ...
5
votes
2answers
223 views
Is there a plugin that will override the “Error establishing a database connection” message?
My provider's database server recently had some downtime and my site was displaying the classic "Error establishing a database connection" message for about an hour.
I knew what the problem was but ...
5
votes
1answer
292 views
How does Wordpress handle MySQL row lock errors?
If there is a WordPress plugin which updates rows in a custom table, but that update encounters a row lock, what happens? E.g. two users simultaneously fire an update on TABLE1, one setting AGE=1 and ...
0
votes
2answers
96 views
WordPress Didn't like the site move? [closed]
I have a site that has been dropped on my lap and it currently has some WordPress issues. The site can longer auto update, and complains about paths when I try to update a plugin:
Unable to locate ...
0
votes
1answer
161 views
How to add a custom form to a plugin's setting page
I have a settings page for a plugin which I created using this function:
function vsp_create_menu() {
add_menu_page( 'Visitors Statistics', 'Visitors Statistics', 'manage_options', ...
0
votes
1answer
90 views
Plugin Database Admin Page Conflict with WP-Super-Cache [closed]
I have a plugin running on a Wordpress site that is also making use of WP-Super-Cache. The plugin stores data in it's own tables in the database. When using the admin management pages on the site data ...
0
votes
1answer
145 views
update_option creates an option, which empties on a blog reload
I am currently writing a plugin that allows all authors to be listed on a page. I've created an options page and wanted to create a function that allows administrators to exclude certain authors from ...
-1
votes
2answers
417 views
Add some fileds to the wp_posts table
I need to extend some wp tables (wp_posts, wp_comments, wp_users) to store some additional fields.
I can't use metadata because I need to query those values directly via MySQL.
I need an help to ...
1
vote
3answers
162 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 ...
0
votes
2answers
3k views
Create New Admin Menu Section - Like how custom post type works, in a way
I've been working with Wordpress off and on for years now, but I haven't gotten entirely immersed with the framework. I have no problem creating plugins that use custom post types, but I'm looking to ...
-1
votes
2answers
53 views
Updating WordPress [closed]
I have just update my WordPress page and I can't see it. A lot of plugins are giving errors, so I activate DEBUG. Then I have try to desactivate all plugins in the database. To make this I erase the ...
0
votes
1answer
65 views
Creating fields in the database
I am newbie to wordpress plugin and this is my first plugin which I am doing now. I want that when the plugin will be activate it will make some predefined fields in the database and also the same ...
0
votes
1answer
89 views
Creating Tables on Network Activation
I'm working on a plugin which creates a new table. I've got it working fine on a single site install, but I'm not so sure about multisite.
How do I create a table for each blog on network ...
0
votes
2answers
351 views
Allow users to enter and edit data in one-to-many configuration
We would want a user to login and be presented with a form that they would potentially have to submit multiple times (disclosures of any industry relationships, one form per disclosure).
The ...
0
votes
1answer
167 views
How to edit a published post?
I'm writing a plugin. Can anyone please show me how to edit the content of a published post? I've tried using this:
function edit( $post_ID ) {
$content = "Hello. This is a test.";
$post_info = ...
2
votes
1answer
54 views
prefix table and plugins
I changed my prefix of my tables from the wp_ to something else for security reasons and good practice etc. I was curious most of new plugins installed take on the new prefix but I have one that ...
0
votes
1answer
320 views
How do i edit the plugin files in DataBase via phpMyAdmin?
I need guidance to edit the WordPress plugin and theme files via phpmyadmin
If I want to edit a particular plugin file or remove a plugin completely from database, I could able to find them ,but I ...