Eric @ EricBess WebHome

Wins do not arrogant, not to lose hungry, there is shock chest and face, such as mine Pinghu

Chinese (Simplified) flagItalian flagKorean flagPortuguese flagEnglish flagGerman flagFrench flagSpanish flagJapanese flagArabic flagRussian flagGreek flagDutch flagBulgarian flagCzech flagCroat flagDanish flagFinnish flagHindi flagPolish flagRumanian flagSwedish flagNorwegian flagCatalan flagFilipino flagHebrew flagIndonesian flagLatvian flagLithuanian flagSerbian flagSlovak flagSlovenian flagUkrainian flagVietnamese flag
By N2H

Wordpress database and that wpdb Class

To collate the following information network of non-original

The following are wp-2.0.5 version of the database structure of (ER diagram). Here only lists the primary key and foreign key. Diamond-shaped figure that 1: n relationship, as part of a white, black as part of the n.

wordpress-db-er-diagram.png

Wordpress A total of 10 tables, divided into four categories according to function.

  • user: user information, including wp_users table and wp_usermeta table.
  • post: The article reviews and information, including wp_posts, wp_postmeta, wp_comments, wp_post2cat, as well as five wp_categories table.
  • link: links, including wp_links table and wp_linkcategories table.
  • option: setting the overall situation, including wp_options table.

Table of naming is very interesting. Sum up the basic rules are as follows:

  • To preserve the basic properties of the object, named wp_objects, the use of the plural (for example, wp_posts, wp_comments);
  • Save the expansion of the object attributes, named wp_objectmeta, the use of the singular (for example, wp_postmeta, wp_usermeta);
  • Many-to-many relationship, named wp_a2b, which were b and a many-to-many relationship between the two ends of the object's name abbreviation (for example, wp_post2cat).
WPDB category

http://codex.wordpress.org.cn/Function_Reference/wpdb_Class

http://codex.wordpress.org/Function_Reference/wpdb_Class

Database description

http://codex.wordpress.org/Database_Description # Table_Overview

wp_categories: for the preservation of classified information related to the table. 5, including the field are:

  • cat_ID - each unique ID number classifications for a bigint (20) value, and with additional properties auto_increment.
  • cat_name - a classification name for a varchar (55) value.
  • category_nicename - the classification assigned to a user-friendly names to remember, that is, the so-called slug, this is a varchar (200) value.
  • category_description - a detailed description of the classification, longtext-value.
  • category_parent - the higher the classification categories, as a int (4) value, corresponding to the current table is the cat_ID, that is, wp_categories.cat_ID. No higher level classification, the value is 0.

Click to continue reading

March 12th, 2008 Posted by eric | Database, Wordpress Programming | no comments

PayPal PHP interface

PayPal fast, safe and convenient cross-border trading is the preferred online payment method. PayPal can be now and most of the domestic credit card association, people can achieve the balance of payments cross-border transactions.
PayPal to apply for registration of Web site: https: / / www.paypal.com/

paypal interface with other interface is somewhat different, a little bit complicated. In fact, the bank interface is also a site of the plug-in.

The so-called paypal ipn (Instant Payment Notification), developed by Paypal is a third-party sellers to take the initiative to inform the trading system as a mechanism for the state. The IPN is very simple principle, that is generated when a transaction, the transaction status changes, such as the user has to pay, or refund, when it revoked, Paypal use of commonly used HTTP POST methods, some of the transaction will be submitted to the Web site of the variables A page (referred to as IPN Handler), when this page request received, these data untouched instructions to add a proven cmd = _notify-validate, POST back to the Paypal address of the interface, if the data is correct, then Paypal Return string VERIFIED, or as INVALID, if the result is VERIFIED, then your program will be able to use these data to carry out the operation.

Sandbox open account

However, the debugging code is a very painful thing, because as a third-party developers, it is not possible to open two accounts, each would also like to test some of the transactions between the money, so Paypal has developed a specialized Sandbox to the developers for development, first of all To https: / / developer.paypal.com / registration of a development account, well after the establishment of re-entering the Sandbox test of virtual Paypal account (at least to establish a Business and one of the Personal), this method of registration and Paypal account of the Process, information is false, including bank accounts, credit cards (in fact Paypal Sandbox automatically generate a number of random numbers). The next step to activate Paypal Sandbox virtual account, pay attention to, no matter where you fill in registration Paypal Sanbox what e-mail address, any virtual account number to send the filled-mail messages are kept in the development of account management interface of the page Email ( There are navigation bar). Virtual Sandbox log on Paypal, also need to verify that the virtual bank account, you can not fill, and then to Add Funds to recharge account (fill in the number of how many would like to fill 920-203 920-533). Then, the IPN also need to activate the option of Business in the accounts of the Profile settings page, click, and then click Edit button to open the IPN, here if you are using a fixed IPN Handle, that could fill in the address.

Next, we tested, Paypal should address the interface is set to https: / / www.sandbox.paypal.com / cgi-bin / webscr

1 2 3 4

March 11th, 2008 Posted by eric | Coding, Web technology | no comments

Ultraedit syntax highlight of the show package

Ultraedit syntax highlight of the show package, you can support: c / c + + java jsp php asp xml pl / sql javascript html per nearly 600 languages, and so on.
Usage:
Menu ---> High Advanced ---> configuration Configration ---> Editor display ---> syntax coloring a complete list of words -----> ----> path, you have to specify that good wordfile.txt file
Download:

Download: Ultraedit syntax highlighting files package Ultraedit syntax highlighting files package (unknown, 556 hits)

Ultraedit syntax highlighting files package, it's support: "c / c + + java jsp php asp xml pl / sql javascript html per", etc.ALL 600s WORDFILES (syntax files) IN ONE PACKAGE.
Usage:
Open Ultraedit: file-> advanced-> configraton-> editor display-> syntax highlight-> browse-> 'pick the Syntax file'
Open View-> highlight file type-> 'pick it'
Download:

Support list:

Click to continue reading

March 7th, 2008 Posted by eric | Coding | no comments

WP-CODEBOX Plugin (code highlighted plug-in)

Author: Eric.Wang
Plugin URL: http://wordpress.org/extend/plugins/wp-codebox/
Tags: syntax highlighting, syntax, highlight, code, formatting
Requires at least: 2.0
Tested up to: 2.5.1
Stable tag: 1.3.1
Download

Donate for this plugin development, Thanks!

== Description ==

WP-CODEBOX highlighted code plug-ins to support multiple languages, download the code, copied to the clipboard, code box strengths and background to set the default attributes. The continued development of plug-ins are welcome to use and report bugs.
Wp-CodeBox provides clean syntax highlighting and advanced feature for embedding source code within pages or posts. It support a wide range of popular languages highlighting with line numbers, code download, Copy to clipboard, collapse codebox, automatic keywords link to API manual and maintains formatting while copying snippets of code from the browser.

It's provide simple background configuration for highlighter style / formatting customization.
Since the plugin is developing, in the future it will support more options. (CSS option, Keyword display style, Auto Caps / Nocaps, Case Sensitivity etc.)

Click to continue reading

March 3rd, 2008 Posted by eric | WordPress | 102 comments

FreeBSD 7.0 released today

FreeBSD 7.0-RELEASE officially released, which is 7-STABLE branch of the first official release, but also the first to the current plan rather than function as a priority odd version. This version of the main highlights include:

- SMP for the environment as well as many other database performance testing exposed the scalability issue has been a significant improvement. FreeBSD 7.0 with a number of cases, the general load performance than FreeBSD 6.X increased 350 percent, high-load conditions to improve performance up to 1500 percent. And so far the best performance of the Linux kernel (version 2.6.22 and 2.6.24), high-performance 15%. These performance improvements for the results from the analysis of system performance and improve the performance assessment of the use case for your specific work load may vary. Performance improvement is mainly derived from the following improvements:
* 1:1 threading model used by default libthr the thread library.
* The inter-process communication (IPC), and scheduler locking network improvements.
* 5.x and 6.x branch of the introduction of the SMP structure optimization.

A number of performance tests show that this version of FreeBSD for up to 8 CPU's case, its performance with the linear increase in the number of CPU. A lot of work to load in the multi-core systems showed remarkable performance.

Click to continue reading

February 28th, 2008 Posted by eric | Unix / BSD / Linux | no comments

Eclipse's PHP Development

Zend provided by the Eclipse for PHP development environment, which integrates Zend debugger. (In Zend or Eclipse about the PHP IDE project for more information.) In this section, the rest of learning how to install, configure and use of PDT (PHP Development Tools) tool.

Installation

PDT is installed, there are a number of packages must be installed:

  • GEF - Graphical Editing Framework
  • EMF - Eclipse Modeling Framework
  • JEM - Java EMF Modeling SDK
  • WTP - Web Tools Platform

In the suite in the Eclipse installation is divided into:

  • Remote Site (online installation, the source can be divided into the built-in or custom)
  • Local Site (local installation)
  • Archived Site (compressed installation files)

Therefore, usually above the suite can be downloaded from the local installation and then come back, but I will be used to install online; because it can be maintained to minimize the installation in order to accelerate the pace of the start-up Eclipse.

Click to continue reading

February 27th, 2008 Posted by eric | Coding | no comments

« 4 5 6 7 8 9 10 11 12 13 » ... Last » Page 8 of 30 «First ...« 4 5 6 7 8 9 10 11 12 13 »... Last»