?
Solved

wordpress where to find category insert queries

Posted on 2008-06-14
6
Medium Priority
?
333 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 2000 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

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

These days socially coordinated efforts have turned into a critical requirement for enterprises.
3 proven steps to speed up Magento powered sites. The article focus is on optimizing time to first byte (TTFB), full page caching and configuring server for optimal performance.
The purpose of this video is to demonstrate how to integrate Mailchimp with Facebook. This will be demonstrated using a Windows 8 PC. Mailchimp and Facebook will be used. Log into your Mailchimp account. : Click on your name. Go to Account Settiā€¦
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.
Suggested Courses

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