# From a URL-encoded title
/* static */ function newFromURL( $url )
{
- global $wgLang, $wgServer;
+ global $wgLang, $wgServer, $wgIsMySQL, $wgIsPg;
$t = new Title();
# For compatibility with old buggy URLs. "+" is not valid in titles,
$t->mDbkeyform = str_replace( " ", "_", $s );
if( $t->secureAndSplit() ) {
-
# check that lenght of title is < cur_title size
- $sql = "SHOW COLUMNS FROM cur LIKE \"cur_title\";";
- $cur_title_object = wfFetchObject(wfQuery( $sql, DB_READ ));
+ if ($wgIsMySQL) {
+ $sql = "SHOW COLUMNS FROM cur LIKE \"cur_title\";";
+ $cur_title_object = wfFetchObject(wfQuery( $sql, DB_READ ));
- preg_match( "/\((.*)\)/", $cur_title_object->Type, $cur_title_size);
+ preg_match( "/\((.*)\)/", $cur_title_object->Type, $cur_title_type);
+ $cur_title_size=$cur_title_type[1];
+ } else {
+ /* midom:FIXME pg_field_type does not return varchar length
+ assume 255 */
+ $cur_title_size=255;
+ }
- if (strlen($t->mDbkeyform) > $cur_title_size[1] ) {
+ if (strlen($t->mDbkeyform) > $cur_title_size ) {
return NULL;
}
$parents = array();
# get the parents categories of this title from the database
- $sql = "SELECT DISTINCT cl_from,cur_namespace,cur_title,cur_id FROM cur,categorylinks
+ $sql = "SELECT DISTINCT cur_id FROM cur,categorylinks
WHERE cl_from='$titlekey' AND cl_to=cur_title AND cur_namespace='$cns'
ORDER BY cl_sortkey" ;
$res = wfQuery ( $sql, DB_READ ) ;
while ( $x = wfFetchObject ( $res ) ) $data[] = $x ;
wfFreeResult ( $res ) ;
} else {
- $data = "";
+ $data = '';
}
return $data;
}
function getAllParentCategories(&$stack)
{
global $wgUser,$wgLang;
- $result = "";
+ $result = '';
# getting parents
$parents = $this->getParentCategories( );
- if($parents == "")
+ if($parents == '')
{
# The current element has no more parent so we dump the stack
# and make a clean line of categories
{
# make a link of that parent
$result .= $sk->makeLink($wgLang->getNSText ( Namespace::getCategory() ).":".$parent,$parent);
- $result .= " > ";
+ $result .= ' > ';
$lastchild = $child;
}
- # append the last child
- $result .= "$lastchild<br/>\n";
+ # append the last child.
+ # TODO : We should have a last child unless there is an error in the
+ # "categorylinks" table.
+ if(isset($lastchild)) { $result .= $lastchild; }
+
+ $result .= "<br/>\n";
# now we can empty the stack
$stack = array();
}
if(isset($result)) { return $result; }
- else { return ""; };
+ else { return ''; };
}