webspot@blogspot

http://forum.joomla.org/viewtopic.php?f=673&t=749306&p=2889465#p2889465 The ACL rules you are looking for are more refined than what 2.5 offers out-of the box: You have to set "Edit State" to "allow" to grant permission to publish/unpublish, but this permission does not distinguish based upon author. You have to set "Create" to "allow" to grant permission to create articles, but the permission to create includes new subcategories as well. ACL is enforced at the code level, so if one needs additional permissions or finer control of permissions, then this logic needs to be added at the code level. (I don't think you are going to find a solution to your needs through some configuration of permission settings.) The logic you need can be created with just a few lines of code and inserted into select view files - files that can be overridden so the changes are safe from upgrades. Here is an approach tha

You cannot do it with just a single MySQL command, however you can use MySQL to construct the statement for you: In the MySQL shell or through PHPMyAdmin, use the following query SELECT CONCAT( 'DROP TABLE ', GROUP_CONCAT(table_name) , ';' )     AS statement FROM information_schema.tables     WHERE table_name LIKE 'myprefix_%'; This will generate a DROP statement which you can than copy and execute to drop the tables. EDIT: A disclaimer here - the statement generated above will drop all tables in all databases with that prefix. If you want to limit it to a specific database, modify the query to look like this and replace database_name with your own database_name: SELECT CONCAT( 'DROP TABLE ', GROUP_CONCAT(table_name) , ';' )     AS statement FROM information_schema.tables     WHERE table_schema = 'database_name' AND table_name LIKE 'myprefix_%';   Thanks to Andre Miller

Suppose you have all countries name in MySQL db table like: and you want to show some specific countries on top of the list and remaining countries will start after them. So this query can do it. SELECT * FROM countries ORDER BY country_name = 'Australia' desc,          country_name = 'United arab emirates' desc,          country_name = 'Pakistan' desc,          country_name = 'United kingdom' desc,          country_name = 'United states' desc,          country_name asc;

Follow this quick video  or At the bottom of the screen, on the left hand side there are 4 virtual buttons, Back, Home, Recent Apps and Menu. Menu is the one with 4 lines. Tap that and then there is an option to Sign Out.

If you try to use unlink in CI as $filestring  =  base_url ( ) . 'uploads/' . $ filename ; unlink  (  $filestring ) ; you will face such error message: A PHP Error was encountered Severity: Warning Message: unlink() [function.unlink]: http does not allow unlinking Filename: controllers/face.php Line Number: 109 because CI does not understand the  path we specified, therefore to remove a file we have to either use: $filestring  =  APPPATH . '../uploads/' . $filename ; unlink ($filestring) ; or   define ( 'PUBPATH' , str_replace ( SELF , '' , FCPATH ));  // in index.php and $filestring  =  PUBPATH . 'uploads/' . $ filename ;    // in controller

$( document ).ready(function() { $('#add').click(function() { return !$('#select1 option:selected').appendTo('#select2'); }); $('#remove').click(function() { return !$('#select2 option:selected').appendTo('#select1'); }); }); <div> Group 1:     <select multiple id="select1">         <option value="1">Ajax</option>         <option value="2">jQuery</option>         <option value="3">JavaScript</option>         <option value="4">Moo Tools</option>         <option value="5">Prototype</option>         <option value="6">Dojo</option>     </select>     <a href="#" id="add">add &gt;&gt;</a> </div> <div> Group 2:     <select multiple id="select2">         <op

Objective: Suppose you are required to create SEO friendly URLs with the merger of WP and CI, WP as front-end and CI as admin panel. You are adding projects with CI and showing detail of that project with WP. Steps: Code in controller (project.php) // create user friendly url string as per project name $pro_name = “new project name”; $pro_url = strtolower(str_replace(' ','-',trim($pro_name))); // insert in to wp_posts table $post = array( 'post_title' => $pro_name, 'post_name' => $pro_url, 'post_type' => 'page' ); $post_id = $this->utility_model->set('wp_posts', $post); // insert in to wp_postmeta table $postmeta = array( 'post_id' => $post_id, 'meta_key' => '_wp_page_template', 'meta_value' => 'project-detail.php' ); $this->utility_model->set('wp_postmeta', $postmeta); /* insert in to