ExData Module v2.8.0 - Tables, Lists and more…

[maxroach]

Can it be, that i first have to create some tables
in the database (similar as Graphical Text MOD 2.0 by Jérôme Gamez)?

Just tell me: Yes or No.
Otherwise that means in my case, that i have to work hours and hours to find it out.

Thanx!

Flo

[maxroach]

sorry doublepost

[frenzal]

hi,

i'm looking for some examples of this mod... just found one or two in this thread.. are there other examples out in the wild?

I'm still in testing phase for a site, but have set up exdata mod to do 2 things for me, show a list of images and address list. As you can see I havent really touched the design aspect yet.

images: http://www.runningman.be/phpwcms/index. ... everancier

address list: http://www.runningman.be/phpwcms/index. ... pub_garage

in the first example i just removd all borders and stuff in the css
in the second example i made a template so i can have an email link and combine some fields under each other

[breitsch]

@frenzal

you don't have to create db-tables by hand!
I'm sure you missed something in installation procedure

please PM or mail me your
PHPWCMS_ROOT/phpwcms.php
file

[SNap]

hi again,

i'm not sure if exdata can do this:

- i would need categories in objekts itself.... let me explain...

an entry can be in more categories... for example a movie could be in comedy and in fun categories...

- and i would like a listing.... then when selecting an entry i would like a detailed view of this entry...

- the detail view should have a wysiwyg field....
- the detail view should have possible more pictures to select? ...

would be nice to hear from you

Cheers
SNap

[breitsch]

i'm not sure if exdata can do this: ...

sounds like shopping cart to me
see here: http://opensolution.org/
easy to adapt to your own needs

ExData can NOT do this, sorry

[Pauli]

Yesterday I had some strange issue. I was editing an existing Category, by adding one field. To confirm the changes I clicked 'Add Field' and not 'Edit Category'. So I got an extra field after the screen reloaded. I tried to delete that field, but got a error:

Code: Select all

Error updating visible - category info: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
UPDATE outlab.phpwcms_exd_cat_vis SET field1='', field2='', field3='', field4='', field5='', field6='', field7='', field8='', field9='', field10='', field11='', field12='', field13='', field14='', field15='', field16='', field17='', field18='', field19='', field20='', field21='', field22='', field23='', field24='' WHERE catid=

When I went back, about 4 fields where removed, I can see the values in the mysql database, but the fields don't appear anymore in the Fieldnames in Categories.

Do you know what might have caused that?
Thx

[breitsch]

@Pauli

I can not say what has caused this.
I tried it various times as you described but it works fine with me.

In your database-table set the value: cat_field_number to the amount of fields you have in this category, this should fix your problem with the fields not displayed anymore.

Please tell me if it happens again!

[Pauli]

okidoki
the cat_field_number fixed it again indeed
Thx!

[frenzal]

I like making my own templates in exdatamod. But is there anyway I can control how images are displayed in a custom template? They always show up as click to enlarge and I dont want this, is there anyway I can extract the url from an image type?

[breitsch]

They always show up as click to enlarge and I dont want this, is there anyway I can extract the url from an image type?

Hi

in file: inc_lib/exdata.classes.frontend.php in function: make_entries

Code: Select all

find:
$event = str_replace("{EF".$j."}", $auto_image[3], $event); //with pop-up, else 2
change to (you already know it!):
$event = str_replace("{EF".$j."}", $auto_image[2], $event); //with pop-up, else 2

this will turn OFF the 'click to enlarge' function in custom templates.

[fkeiner]

Hi Breitsch,

i'm wondering if your mod can do this: For a sport team I want to store characteristics from every player in the database. In the frontend i would like to have a dropdown menue or a list where every player is shown up and can be chosen so that finally only his characteristic is displayed on the site. Please tell me if this is possible and when the answer is yes,: how?

Greetings,

Frank

[breitsch]

Please tell me if this is possible and when the answer is yes,: how?

2 ways you could realize this:

1. Article link - but then you don't have the content in ExData

2. custom templates in combination with moo.fx
see example here
http://web.casa-loca.com/index.php?id=16,10,0,0,1,0
nice, or not

Let me know if you like that, I will then publish the installation instructions.

[fkeiner]

Hi Breitsch,

thanks for answering so quickly. I like the solution you proposed (the second one) so it would be great to know how you did it.

Thanks in advance,

Frank

[breitsch]

Use ExData custom templates with moo.fx

Step 1:
Download the moo.fx package from:
http://moofx.mad4milk.net

Upload the files:
-moo.fx.js
-moo.fx.pack.js
-prototype.lite.js

to the directory:
PHPWCMS_ROOT/include/inc_js/moo

Step 2:
open: PHPWCMS_ROOT/index.php

Code: Select all

find:
	$content['page_start']  = '<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">';

change to:
  	$content['page_start']  = '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">';

Step 3:
in your layout (in backend) add to the html head section:

Code: Select all

<script type="text/javascript" src="include/inc_js/moo/prototype.lite.js"></script>
<script type="text/javascript" src="include/inc_js/moo/moo.fx.js"></script>
<script type="text/javascript" src="include/inc_js/moo/moo.fx.pack.js"></script>

<script type="text/javascript">
<!--
window.onload = function() {
//we define two arrays, containing our toggles and divs.
var myDivs = document.getElementsByClassName('stretcher');
var myLinks = document.getElementsByClassName('stretchtoggle');

//then we create the effect.
var myAccordion = new fx.Accordion(myLinks, myDivs, {opacity: true, duration: 400});
// Select your default opened section
//myAccordion.showThisHideOpen(myDivs[0]);
}
//-->
</script>

Step 4:
in your article where the ExData-Content should appear use the RT:
{EXDATA:[category-ID]:0:moofx.template.php}

Step 5:
create moofx.template.php in directory:
PHPWCMS_ROOT/include/inc_module/mod_exdata/inc_front/templates
with the following content:
Note in second line: complete title, {EF1} means the content of the first field in ExData will be shown as link in frontend, change the number to your needs.

Code: Select all

<div id="exd_item" width="100%">
<span class="stretchtoggle" title="..." name="top"><a href="#top">{EF1}</a></span>
<div class="stretcher">
<table border="0" cellpadding="0" cellspacing="0" width="100%">
  <tr>
    <td class="exd_field">{TF1}</td>
    <td class="exd_entry">{EF1}</td>
  </tr>
  <tr>
    <td class="exd_field">{TF2}</td>
    <td class="exd_entry">{EF2}</td>
  </tr>
  <tr>
    <td class="exd_field">{TF3}</td>
    <td class="exd_entry">{EF3}</td>
  </tr>
  <tr>
    <td class="exd_field">{TF4}</td>
    <td class="exd_entry">{EF4}</td>
  </tr>
  <tr>
    <td class="exd_field">{TF5}</td>
    <td class="exd_entry">{EF5}</td>
  </tr>
  <tr>
    <td class="exd_field">{TF6}</td>
    <td class="exd_entry">{EF6}</td>
  </tr>
  <tr>
    <td class="exd_field">{TF7}</td>
    <td class="exd_entry">{EF7}</td>
  </tr>
  <tr>
    <td class="exd_field">{TF8}</td>
    <td class="exd_entry">{EF8}</td>
  </tr>
  <tr>
    <td class="exd_field">{TF9}</td>
    <td class="exd_entry">{EF9}</td>
  </tr>
    <tr>
    <td class="exd_field">{TF10}</td>
    <td class="exd_entry">{EF10}</td>
  </tr>
    <tr>
    <td class="exd_field">{TF11}</td>
    <td class="exd_entry">{EF11}</td>
  </tr>
    <tr>
    <td class="exd_field">{TF12}</td>
    <td class="exd_entry">{EF12}</td>
  </tr>
    <tr>
    <td class="exd_field">{TF13}</td>
    <td class="exd_entry">{EF13}</td>
  </tr>
    <tr>
    <td class="exd_field">{TF14}</td>
    <td class="exd_entry">{EF14}</td>
  </tr>
    <tr>
    <td class="exd_field">{TF15}</td>
    <td class="exd_entry">{EF15}</td>
  </tr>
    <tr>
    <td class="exd_field">{TF16}</td>
    <td class="exd_entry">{EF16}</td>
  </tr>
    <tr>
    <td class="exd_field">{TF17}</td>
    <td class="exd_entry">{EF17}</td>
  </tr>
    <tr>
    <td class="exd_field">{TF18}</td>
    <td class="exd_entry">{EF18}</td>
  </tr>
    <tr>
    <td class="exd_field">{TF19}</td>
    <td class="exd_entry">{EF19}</td>
  </tr>
    <tr>
    <td class="exd_field">{TF20}</td>
    <td class="exd_entry">{EF20}</td>
  </tr>
    <tr>
    <td class="exd_field">{TF21}</td>
    <td class="exd_entry">{EF21}</td>
  </tr>
    <tr>
    <td class="exd_field">{TF22}</td>
    <td class="exd_entry">{EF22}</td>
  </tr>
    <tr>
    <td class="exd_field">{TF23}</td>
    <td class="exd_entry">{EF23}</td>
  </tr>
    <tr>
    <td class="exd_field">{TF24}</td>
    <td class="exd_entry">{EF24}</td>
  </tr>
</table>
</div></div>

change the html to your needs!

Step 6:

Have fun!