Solved

wordpress where to find category insert queries

Posted on 2008-06-14
6
327 Views
Last Modified: 2012-06-21
hello,
simple question:
in which wordpress file, there are mysql query, which is inserting new category through admin panel. I examined whole code and didnt found that thing. Let me know, thanks!
0
Comment
Question by:springfresh
  • 2
  • 2
6 Comments
 
LVL 17

Expert Comment

by:nanharbison
ID: 21786512
the name of the table in the database that stores categories is called:
terms
here is the insert statement:
$wpdb->query("INSERT INTO $wpdb->terms (name, slug, term_group) VALUES ('$cat_name', '$cat_slug', '0')");
(line 66 on my computer)
I found this insert statement in a file in the includes folder called upgrade.php. There is a file in this folder called category.php, but the functions there all prepare the data to display it in the blog
0
 

Author Comment

by:springfresh
ID: 21787783
strange thing. But i commented this line. And new category insertion still works through admin panel :\
0
 
LVL 17

Expert Comment

by:nanharbison
ID: 21789477
hhhmm, the same query is on line 569 and 642. these two are the same query but get called depending on the version of the database you are using. I don't know what you are using, so comment out both of them.
0
 
LVL 15

Accepted Solution

by:
dosth earned 500 total points
ID: 21855931
it will be in wp-includes\wp-db.php

line 325 -

function insert($table, $data) {

this will be a generic function called from

wp-includes\taxonomy.php line 1163

function wp_insert_term( $term, $taxonomy, $args = array() ) {
0
 
LVL 15

Expert Comment

by:dosth
ID: 21890145
did you get a chance to check it ?
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

With Wordpress gaining more and more popularity not only as blogging platform but as a shopping or CMS solution, it's worth to know which plugins are the first ones to grab and integrate with your website. We will briefly go over the most useful plu…
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
The purpose of this video is to demonstrate how to Import and export files in WordPress. This will be demonstrated using a Windows 8 PC. Go to your WordPress login page. This will look like the following: mywebsite.com/wp-login.php : Click on Too…
The purpose of this video is to demonstrate how to integrate Mailchimp with WordPress, by placing a Mailchimp signup form on a WordPress Page or Post. This will be demonstrated using a Windows 8 PC. Mailchimp will be used. Log into your Mailchi…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question