This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| update TMP_selectoptions t, atselectoptions aso, collectionAttributeValues cav, atSelectOptionsSelected asos | |
| set asos.atSelectOptionID = aso.ID | |
| where t.value_live = aso.value and t.cID = cav.cID and t.cvID = cav.cvID and cav.akID = 15 and cav.akID = aso.akID and cav.avID = asos.avID and t.value_live != t.value; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| select distinct b.bid, c.cid, b.content | |
| from btcontentlocal b, collectionversionblocks c, (select cid, max(cvid) as cvid from collectionversionblocks where arhandle = 'content' group by cid) v | |
| where b.bid = c.bid and c.cid = v.cid and c.cvid = v.cvid and c.arhandle = 'content' and instr(b.content, 'href=\"{CCM:CID_'); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| error_reporting(E_ALL); | |
| ini_set('display_errors','On'); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| UPDATE atselectoptionsselected, collectionsearchindexattributes, collectionattributevalues, atselectoptionsselected ,pages | |
| SET atselectoptionsselected.atSelectOptionID = '6' | |
| WHERE | |
| pages.cParentID = '1818' AND | |
| pages.cID = collectionsearchindexattributes.cID AND | |
| pages.cID = collectionattributevalues.cID AND | |
| atselectoptionsselected.avID = collectionattributevalues.avID; |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| DELIMITER $$ | |
| CREATE PROCEDURE pages(in _cID int) | |
| BEGIN | |
| declare cID_new int; | |
| declare cvName_new varchar(255); | |
| set cID_new = _cID; | |
| simple_loop: LOOP | |
| select distinct pages.cParentID, collectionversions.cvName |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| INSERT INTO ttredirect | |
| cPath, targetCPath) | |
| SELECT | |
| pagepaths.cPath, collectionsearchindexattributes.ak_add_redirect, collectionsearchindexattributes.cID | |
| FROM | |
| pagepaths, collectionsearchindexattributes | |
| WHERE | |
| collectionsearchindexattributes.ak_add_redirect != 0 AND collectionsearchindexattributes.ak_add_redirect iS NOT NULL; | |
| # Update all childpages(1818) attribute(select) values in concrete5 |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| @font-face { | |
| font-family: 'FontAwesome'; | |
| src: url('../font/fontawesome-webfont.eot'); | |
| src: url('../font/fontawesome-webfont.eot?#iefix') format('embedded-opentype'), | |
| url('../font/fontawesome-webfont.woff') format('woff'), | |
| url('../font/fontawesome-webfont.ttf') format('truetype'), | |
| url('../font/fontawesome-webfont.svg#FontAwesome') format('svg'); | |
| font-weight: normal; | |
| font-style: normal; | |
| } |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| # RewriteEngine on | |
| # RewriteBase / | |
| # RewriteCond %{HTTP_HOST} ^yourdomain\.de$ | |
| # RewriteRule ^(.*)$ http://www.yourdomain.com/$1 [R=301,L] | |
| # RewriteRule ^rating/([^/]*)/([^/]*)$ index.php?m=ajax&t=rating&mid=$1&vid=$2&o=ajax [NC,L] | |
| # RewriteRule ^comment/([^/]*)/([^/]*)/([^/]*)$ index.php?m=ajax&t=comment&mid=$1&cid=$2&o=ajax&json=$3 [NC,L] | |
| # RewriteRule ^([^/]*)/([^/]*)/([^/]*)/$ index.php?m=model&t=task&text=$2&textid=$3 | |
| <IfModule mod_rewrite.c> | |
| RewriteEngine On |