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

[Fulvio Romanin]

hey breitsch: almost out of topic - i much liked your "download with password" page - can you share that script too please?

thanks in advance
F

[pSouper]

would you have a TODO list for this mod too?
I would like to see - add/remove items (currently fixed at 8 )
also a hide/show for each item.

I'm sure you have these as well as many others in a TODO list too

[Paal]

@paal

there seems to be a problem with that. i will fix that in the next version.
for now:
once you have installed ExData mod make this your include\inc_module\mod_exdata\main.inc.php file:

Code: Select all

<?php
// calendar modules...
// get needed files
include (PHPWCMS_ROOT.'/include/inc_module/mod_exdata/app-header.php');
include (PHPWCMS_ROOT.'/include/inc_module/mod_exdata/inc_tmpl/header.php'); 
include (PHPWCMS_ROOT.'/include/inc_module/mod_exdata/main.default.php');
?>

so it won't check every time you enter if the mod is already installed or not (in your case you can be sure that it is).
With this change it will work fine!

Hehe... I use "-" in Mysql DB-name... I renamed from "i-develop" to "idevelop", removed last include (include (PHPWCMS_ROOT.'/include/inc_module/mod_exdata/main.default.php'); ) and work fine!

Thx, Paul

[frold]

another thing



I have a php files in the root called articles.php

How do I include you script in a that file?

I tried to insert:

require_once ('include/inc_module/mod_graphical_text/inc_front/gt.func.inc.php');


But that wasnt enough...

I would really like to reuse the entered ExData Entries in that file...

No helps or ideas?

[breitsch]

@frold

could you be a bit more specific?

what's the exact content of your 'articles.php'?
why did you try to include '...mod_graphical_text/inc_front/gt.func.inc.php' when you want to use ExData Content?
to 'reuse' the ExData Entries get them from the database-table!

I need to know what this article.php does to answer your question

[pico]

Hi

after installing your fantastic Mod, I get a Error depending 'Class config in ../php/pear/config.php - can't redefine Class' so I changed the Filename of the config.php in ../include/inc_module/mod_exdata/install to config1.php and in install.php the 2.Line to

Code: Select all

include ("config1.php"); // contains sql and other needs.

that solves my Problem.

I'm using Version 1.2.5 CSV

Also I have changed this in the main.config.php

Code: Select all

// table names
require_once ($_SERVER['DOCUMENT_ROOT'].'/config/phpwcms/conf.inc.php');

$prefix				= $phpwcms["db_prepend"].'_'; 

so the $prefix is read out of the conf.inc.php of phpWCMS

[pico]

Hi

after deleting the first Categorie - my System won't work anymore - no Index-Page - just an Error

Error: 1064: 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 'ASC' at line 1SELECT * FROM 124_phpwcms_exd_entries as entries WHERE catid=1 AND approved=1 ORDER BY ASC

then I change the id of the second Category from 2 to 1 in exd_categories and exd_cat_dat with phpMyAdmin manually.

Is this normal ? or did I something wrong in installation? or is it a 'Feature'

mySQL-Vers.: 4.1.10
PHP: 5.0.3
phpWCMS: 1.2.5 DEV

[breitsch]

Is this normal ? or did I something wrong in installation? or is it a 'Feature'

Hi pico

it's a feature, what else did you think?

no, serious:
if you delete a category in the 'module' section in backend, you MUST delete (or at least set to invisible) the replacement-tag in the article that refers to the deleted category!

there will be a security fix for that in the next version, so when you try to load a deleted category it will ignore this.

thanks for your comments!

[jscholtysik]

Hi breitsch,

I have problems with the width and height of an image. When I select an image with the filebrowser, the name of the image gets inserted in the corresponding field, but when

- I do not insert a value for width and height, no picture is shown
- I insert a value for the width, an image only with 1 pixel and the inserted width will be shown.

No problems are there when I insert both values...

Do you have a tip how I can solve this problem, because I dont want to look first at the image properties to find out the width and height...

Another question: Is it possible to show the field titles only one time at the beginning of the table?

Thanks in advance.


Joachim

[Kosse]

Hi all,

First, congrats for this great MOD, another great addition to phpwcms!
I've always got the same problem with this kind of MOD... because I make french sites (mostly) so I use ' like in I'm (I am) you use the ' very often in french, so the only way I managed (php/mysql - poorly skilled guy words ) to arrange this is by writing: I''m if I put TWO ' it's ok.

I can live with that but clients not...

The error code:

Code: Select all

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 'implication de la Cocof dans les programmes de revitalisation urbaine.', '', '',' at line 1error: file /home/www/1aa54f01c43a/web/srdu/include/inc_module/mod_exdata/inc_lib/exdata.classes.php
line 274
sql: INSERT INTO _phpwcms_exd_entries (date, catid, field1, field2, field3, field4, field5, field6, field7, field8, approved, userId) VALUES ('2005-09-16', 1, 'Cocof', 'RBC', 'Suivi de programme', ' Accompagnement et information pour renforcer l'implication de la Cocof dans les programmes de revitalisation urbaine.', '', '', '', '', 1, 5)

Does anyone has a hint for that (same thing happens with the also very nice CALENDAR MOD...) In addition it doesn't like accents neither... é è à and so on...

Cheers

[frold]

I guess if you need to use ' you need to write it like: \'

[Kosse]

Thx frold it works but... as I said if I write '' it''s ok (html code works also ok)...

I can see OG has set that in the core phpwcms because normal text works when u use ' ... I tried to modify the lang parameters in the mysql tables but doesn't seem to make a difference...

But... can't I fix that at a php (or mysql) level?

Something with magic_quotes_gpc or with the function html_specialchars ?:?::?:


Cheers

[breitsch]

Hi people

I'm working hard on the update-version 1.1 of ExData-Mod for phpwcms!
Most of the mentioned things here are now included and some bugs eliminated.

Very soon the following features are integrated:

Section Category:
- add up to 24 fields
- remove fields not used anymore
- set fields visible/invisible

Section Entry
- set visible/invisible entry-fields (overwrites the category-definition for just that one entry)
- picture size proportions solved

Section Templates
- setup basic templates in backend without write any HTML:

• - show/hide category name
  - show/hide field-titles or show them only once
  - main layout in 1 or 2 columns
  - show entries in rows (with/without titels on top) or in blocks (with/without titels on the left)
  - apply or not visibility settings from category and/or entry
  - show only 1 field (select from list)

- setup css-styles for every category individually
- change css in backend (same as frontend.css) but with preview-feature

If you have other requests, please let me know, maybe I can include some of them in this new version too.

[Kosse]

Nice breitsch!

You've been working hard. Congrats.
Can u tell me something about the function html_specialchars or not ? / Do u see / know a solution for that or a hint?

Btw, I edited the tables in mysql, instead of VARCHAR (limited to 100) I put just plain text, so it allows me to put loooooooong texts

TIA

Cheers

[breitsch]

@kosse

Can u tell me something about the function html_specialchars or not ?

I'm not shure, but it works with my configuration -> what tells me that it could have to do with mysql-version: ver. 4 and up = problem!
maybe there is a mysql-guru who can tell us about this?