NAVIGATION
This shows you the differences between two versions of the page.
|
english:technics:database:phpwcms_articlecontent [2009/11/17 11:38] Knut Heermann (flip-flop) |
english:technics:database:phpwcms_articlecontent [2018/06/03 18:09] (current) |
||
|---|---|---|---|
| Line 4: | Line 4: | ||
| - | ===== table dump ===== | ||
| - | **E.g. for the CP images <div>** | + | |
| + | ===== E.g. for the CP images <div> ===== | ||
| in /frontend_init/ using the function cp_trigger: | in /frontend_init/ using the function cp_trigger: | ||
| - | <code php> | + | <code php|h cp_trigger|h> |
| <?php | <?php | ||
| // ------------------------------------------------------------------------------------------- | // ------------------------------------------------------------------------------------------- | ||
| Line 23: | Line 24: | ||
| if( $data['acontent_type'] == 29 ) // CP: 29 => image <div> CP: 31 => image special | if( $data['acontent_type'] == 29 ) // CP: 29 => image <div> CP: 31 => image special | ||
| { | { | ||
| + | // ----------- table dump | ||
| dumpVar($GLOBALS['crow']); | dumpVar($GLOBALS['crow']); | ||
| + | // ----------- field dump acontent_form | ||
| $CP = @unserialize($GLOBALS['crow']["acontent_form"]); | $CP = @unserialize($GLOBALS['crow']["acontent_form"]); | ||
| dumpVar($CP); | dumpVar($CP); | ||
| Line 40: | Line 43: | ||
| \\ | \\ | ||
| + | |||
| + | ===== table dump ===== | ||
| <code php>dumpVar($GLOBALS['crow']);</code> | <code php>dumpVar($GLOBALS['crow']);</code> | ||
| Line 48: | Line 53: | ||
| Array | Array | ||
| ( | ( | ||
| - | [acontent_id] => 85 | + | [acontent_id] => 85 // biunique CP-ID |
| - | [acontent_aid] => 26 | + | [acontent_aid] => 26 // biunique article-ID |
| [acontent_uid] => 1 | [acontent_uid] => 1 | ||
| - | [acontent_created] => 2009-11-11 23:11:19 | + | [acontent_created] => 2009-11-11 23:11:19 // CP created |
| - | [acontent_tstamp] => 2009-11-17 09:58:32 | + | [acontent_tstamp] => 2009-11-17 09:58:32 // CP last changes |
| - | [acontent_title] => Image < div > slidedhow | + | [acontent_title] => Image < div > slidedhow // title text |
| - | [acontent_text] => <p>Text, Text, Text</p> | + | [acontent_text] => <p>Text, Text, Text</p> // wysiwyg text |
| - | <p>Text, Text, {CITY} Text{a:anker-div}</p> | + | <p>Text, Text, {CITY} Text{a:anker-div}</p> |
| - | [acontent_type] => 29 | + | [acontent_type] => 29 // content typ (images <div> = 29) |
| - | [acontent_sorting] => 0 | + | [acontent_sorting] => 0 // sort value |
| [acontent_image] => | [acontent_image] => | ||
| [acontent_files] => | [acontent_files] => | ||
| - | [acontent_visible] => 1 | + | [acontent_visible] => 1 // status: visible |
| - | [acontent_subtitle] => | + | [acontent_subtitle] => // subtitle text |
| - | [acontent_before] => 15 | + | [acontent_before] => 15 // space: before |
| - | [acontent_after] => 20 | + | [acontent_after] => 20 // space: after |
| - | [acontent_top] => 0 | + | [acontent_top] => 0 // top link |
| - | [acontent_redirect] => | + | [acontent_redirect] => |
| [acontent_html] => | [acontent_html] => | ||
| - | [acontent_trash] => 0 | + | [acontent_trash] => 0 // 9=trash |
| [acontent_alink] => | [acontent_alink] => | ||
| [acontent_media] => | [acontent_media] => | ||
| - | [acontent_form] => a:11:{s:6:"images";a:7:{i:0;a:7:{i:0;s:1:"6";i:1;s:20:"Dscn1531_800x600.jpg";i:2;s:32:"129371f7f736a0a8d0b9083b2e10fc8f";i:3;s:3:"jpg";i:4;i:80;i:5;i:60;i:6;s:23:"Liegestuhl, sehr bequem";}i:1;a:7:{i:0;s:1:"9";i:1;s:20:"IMG_4527-480x640.jpg";i:2;s:32:"ff974ae44a4f41ada71eaf4356d19aaa";i:3;s:3:"jpg";i:4;i:80;i:5;i:60;i:6;s:31:"Lia guckt blöd aus der Wäsche";}i:2;a:7:{i:0;s:1:"2";i:1;s:17:"060129_124625.jpg";i:2;s:32:"8d89ce4314ca482ab4cf8a6eeb16560e";i:3;s:3:"jpg";i:4;i:80;i:5;i:60;i:6;s:30:"Herr Schmidt ordnet die Blumen";}i:3;a:7:{i:0;s:2:"19";i:1;s:20:"cimg1435_800x600.jpg";i:2;s:32:"89a45c92e024ba54a43ab1ea554ad06a";i:3;s:3:"jpg";i:4;i:80;i:5;i:60;i:6;s:18:"Moderne Tankstelle";}i:4;a:7:{i:0;s:2:"20";i:1;s:20:"dscn0702_800x600.jpg";i:2;s:32:"3fedf26f925cf675ea250c90476e43ca";i:3;s:3:"jpg";i:4;i:80;i:5;i:60;i:6;s:14:"Wiese mit Baum";}i:5;a:7:{i:0;s:1:"3";i:1;s:16:"lia_bild1316.jpg";i:2;s:32:"ecdb09f7d4a109e9c72f40e99ceb5373";i:3;s:3:"jpg";i:4;i:80;i:5;i:60;i:6;s:9:"Lia klein";}i:6;a:7:{i:0;s:1:"8";i:1;s:20:"img_4533_640x480.jpg";i:2;s:32:"1af27f44f306794f178bb4a1ec5d544b";i:3;s:3:"jpg";i:4;i:80;i:5;i:60;i:6;s:10:"Lia mittel";}}s:5:"width";i:80;s:6:"height";i:60;s:3:"pos";i:0;s:3:"col";i:10;s:4:"zoom";i:0;s:4:"crop";i:1;s:5:"space";i:3;s:8:"lightbox";i:0;s:9:"nocaption";i:0;s:12:"center_image";i:2;} | + | [acontent_form] => (see above "Content of the field") // e.g. all image parameters in serialized form |
| [acontent_newsletter] => | [acontent_newsletter] => | ||
| - | [acontent_block] => CONTENT | + | [acontent_block] => CONTENT // display type |
| - | [acontent_anchor] => 1 | + | [acontent_anchor] => 1 // [0|1] off|on |
| - | [acontent_template] => slideshow2.tmpl | + | [acontent_template] => slideshow2.tmpl // usedn template file |
| - | [acontent_spacer] => 0 | + | [acontent_spacer] => 0 // ?? |
| [acontent_tid] => 0 | [acontent_tid] => 0 | ||
| [acontent_livedate] => 0000-00-00 00:00:00 | [acontent_livedate] => 0000-00-00 00:00:00 | ||
| [acontent_killdate] => 0000-00-00 00:00:00 | [acontent_killdate] => 0000-00-00 00:00:00 | ||
| [acontent_module] => | [acontent_module] => | ||
| - | [acontent_comment] => {PREVNEXT}{KENBURNS} | + | [acontent_comment] => {PREV-NEXT}{KEN-BURNS} // Comment field |
| - | [acontent_paginate_page] => 0 | + | [acontent_paginate_page] => 0 // subsection No |
| - | [acontent_paginate_title] => | + | [acontent_paginate_title] => // subsection (pagination) title |
| [acontent_category] => | [acontent_category] => | ||
| [acontent_granted] => 0 | [acontent_granted] => 0 | ||
| Line 93: | Line 98: | ||
| ==== field acontent_form ==== | ==== field acontent_form ==== | ||
| + | \\ | ||
| + | ** | ||
| + | Content of the field:** | ||
| + | <code mysql> | ||
| + | a:11: | ||
| + | {s:6:"images";a:7: | ||
| + | { | ||
| + | i:0;a:7:{i:0;s:1:"6";i:1;s:20:"Dscn1531_800x600.jpg";i:2;s:32:"129371f7f736a0a8d0b9083b2e10fc8f";i:3;s:3:"jpg";i:4;i:80;i:5;i:60;i:6;s:23:"Liegestuhl, sehr bequem";} | ||
| + | i:1;a:7:{i:0;s:1:"9";i:1;s:20:"IMG_4527-480x640.jpg";i:2;s:32:"ff974ae44a4f41ada71eaf4356d19aaa";i:3;s:3:"jpg";i:4;i:80;i:5;i:60;i:6;s:31:"Lia guckt blöd aus der Wäsche";} | ||
| + | i:2;a:7:{i:0;s:1:"2";i:1;s:17:"060129_124625.jpg";i:2;s:32:"8d89ce4314ca482ab4cf8a6eeb16560e";i:3;s:3:"jpg";i:4;i:80;i:5;i:60;i:6;s:30:"Herr Schmidt ordnet die Blumen";} | ||
| + | i:3;a:7:{i:0;s:2:"19";i:1;s:20:"cimg1435_800x600.jpg";i:2;s:32:"89a45c92e024ba54a43ab1ea554ad06a";i:3;s:3:"jpg";i:4;i:80;i:5;i:60;i:6;s:18:"Moderne Tankstelle";} | ||
| + | i:4;a:7:{i:0;s:2:"20";i:1;s:20:"dscn0702_800x600.jpg";i:2;s:32:"3fedf26f925cf675ea250c90476e43ca";i:3;s:3:"jpg";i:4;i:80;i:5;i:60;i:6;s:14:"Wiese mit Baum";} | ||
| + | i:5;a:7:{i:0;s:1:"3";i:1;s:16:"lia_bild1316.jpg";i:2;s:32:"ecdb09f7d4a109e9c72f40e99ceb5373";i:3;s:3:"jpg";i:4;i:80;i:5;i:60;i:6;s:9:"Lia klein";} | ||
| + | i:6;a:7:{i:0;s:1:"8";i:1;s:20:"img_4533_640x480.jpg";i:2;s:32:"1af27f44f306794f178bb4a1ec5d544b";i:3;s:3:"jpg";i:4;i:80;i:5;i:60;i:6;s:10:"Lia mittel";} | ||
| + | } | ||
| + | s:5:"width";i:80;s:6:"height";i:60;s:3:"pos";i:0;s:3:"col";i:10;s:4:"zoom";i:0;s:4:"crop";i:1;s:5:"space";i:3;s:8:"lightbox";i:0;s:9:"nocaption";i:0;s:12:"center_image";i:2; | ||
| + | } | ||
| + | </code> | ||
| + | |||
| + | \\ | ||
| <code php> | <code php> | ||
| $CP = @unserialize($GLOBALS['crow']["acontent_form"]); | $CP = @unserialize($GLOBALS['crow']["acontent_form"]); | ||