Sql injection database book drupal

How to change root admin user password in Drupal ?

http://digitalpbk.com/drupal/how-change-drupal-root-user-password How to change root admin user password in Drupal ? In order to reset the root or superadmin password on a drupal system, login into the database by looking at the settings.php. You can use phpMyAdmin or any other MySQL utilities like SQLYog, or MySQL command line. Run the following query to reset the password. UPDATE users SET pass = MD5('password') WHERE uid = 1 The user id of administrator is always 1. Password field in drupal is stored as MD5 of the actual string password. So ...

SQL Injection: Tutorial Part 1

http://digitalpbk.blogspot.com/2009/06/hacking-sql-injection-tutorial.html SQL Injection: Tutorial Part 1 SQL InjectionWhat? What is SQL ? SQL stands for Structured Query Language, It is the most widely used database querying language. Before reading on I must say that this is an old technique and I dint want this to be posted because most sites have patched up this hole. I am posting this for the few websites I came across that had this vulnerability. If you have a website or planning to build one or administrates one please read on and fix the security holes ...

Apache Solr MySQL Sample Data Config

http://digitalpbk.com/apachesolr/apache-solr-mysql-sample-data-config Apache Solr MySQL Sample Data Config ApacheSolr is an indexing server from apache. It is written in Java and can be used to make search pages on your website. Most Websites use a MySQL database to store its data and standard MySQL search using SQL or FULLTEXT Searching by MySQL. But with ApacheSolr we can not only search but also improve the search results. Solr recognizes plurals and similar words like read, reading or A-DATA, adata etc. Therefore Solr returns more efficient search results ...

Detect in form_alter if the node submitted is added or edited

http://digitalpbk.com/drupal/detect-drupal-form-add-edit-created-formalter Detect in form_alter if the node submitted is added or edited When you want to alter a form on Drupal, it is useful to detect if the form being submitted is to add a new node or edit an existing node. To detect if a form is being added or submitted, check the $form[]['nid']['#value']. Example : $form['book']['nid']['#value']. If the value is "new", the node is being added. If the value is numeric, the node with nid as the number is being ...

Resolve Net::MySQL Hang problem if the database result has only 1 row or is empty

http://digitalpbk.com/perl/solve-netmysql-hang-problem-if-database-result-has-only-1-row-or-empty Resolve Net::MySQL Hang problem if the database result has only 1 row or is empty Net::MySQL is a simple MySQL perl Client to connect to MySQL servers. But Net::MySQL hangs if your result set is having just one row. Sample Net::MySQL code #!/usr/bin/perl use Net::MySQL; $mysql = Net::MySQL->new( hostname => 'localhost', database => 'db', user => 'user', password => 'password', ); $gid = 1; $mysql->query('SELECT * FROM table ...

Welcome to digitalpbk.com

http://digitalpbk.com/2009/10/other-welcome-digitalpbkcom Welcome to digitalpbk.com Well just to have something to get started. :) This is my experiment with drupal. I got somehow drupal to run, figured out and tinkered it as far as I know. I am a drupal 5 developer, has written a few modules in it, for the company SmartCrowds for which I work for. Drupal 6 is a little bit different. So if you find it a little plain and have ideas to improve, help me out. Just Ignore the above, its pretty old and historically true, But now it runs on Django ...

List of Publically accessible drupal sites you can play around with

http://digitalpbk.com/2009/12/list-publically-accessible-drupal-sites-you-can-play-around List of Publically accessible drupal sites you can play around with Here's a list of sites for drupal developers to play around with. HTML Comments without moderation www.themallblog.com www.eatsleepandcode.com www.layt.net Anonymous node editing mature-ip.eu/node/115/edit drupal.kldp.net (Its all Korean I dont know what all is possible) drupal.x73.ch proves2.iws.es/drupal emusic.mozdev.org/drupal www.news7newslinc.net futuregrid.org www.aidsvancouver.org jennycrumiller ...

Select random rows from a table in MySQL

http://digitalpbk.com/mysql/select-random-rows-table Select random rows from a table in MySQL In order to select a random row from MySQL, we can order the rows by a random number and then pick the first row. SELECT * FROM node ORDER BY rand() limit 1; The above query randomly selects a row from the table node. MySQL Software ...

Showing similar content nodes on Drupal

http://digitalpbk.com/2009/12/showing-similar-content-nodes-drupal Showing similar content nodes on Drupal To show similar content nodes on drupal you have to install the similar module. After installing the similar module goto admin/build/block Drag the Similar Entries module OR If you want to integrate the similar content to the node body, call the similar_content theme function. print theme('similar_content', $node); on node.tpl.php Using the variables available withing node.tpl.php you can choose whether to display the similar content ...

How to Integrate another Website to Google Analytics Tracking and Adsense

http://digitalpbk.com/adsense-analytics/how-integrate-google-analytics-tracking-and-adsense the following script on the head. window.google_analytics_uacct = "UA-XXXXXX-X"; Replace XXXXXX-X with your analytics tracking ID which you can obtain from the analytics tracking script or from the analytics setting page as shown in the image below. Then goto the analytics settings page, and click the link highlighted below Edit Adsense linking settings Adsense on analytics screenshot On Drupal You can set the header in code by drupal_set_html_head or add in the page ...