[ic] Character encodings and FCK editor [SOLVED?]
Rick Bragg
lists at gmnet.net
Fri Aug 7 23:27:15 UTC 2009
On Thu, 2009-08-06 at 15:36 +0000, Rick Bragg wrote:
> On Thu, 2009-08-06 at 09:22 +0300, Gert van der Spoel wrote:
> > > -----Original Message-----
> > > From: interchange-users-bounces at icdevgroup.org [mailto:interchange-
> > > users-bounces at icdevgroup.org] On Behalf Of Rick Bragg
> > > Sent: Thursday, August 06, 2009 1:48 AM
> > > To: interchange-users at icdevgroup.org
> > > Subject: Re: [ic] Character encodings and FCK editor
> > >
> > > On Wed, 2009-08-05 at 20:53 +0300, Gert van der Spoel wrote:
> > > > > -----Original Message-----
> > > > > From: interchange-users-bounces at icdevgroup.org [mailto:interchange-
> > > > > users-bounces at icdevgroup.org] On Behalf Of Rick Bragg
> > > > > Sent: Wednesday, August 05, 2009 8:49 PM
> > > > > To: interchange-users at icdevgroup.org
> > > > > Subject: [ic] Character encodings and FCK editor
> > > > >
> > > > > Hi List;
> > > > >
> > > > > I am having lots of trouble with this and I hope someone can please
> > > > > help
> > > > > me through this, point me in the write direction, or talk me down
> > > from
> > > > > the leadge!
> > > > >
> > > > > I am wondering if there is a "best practice" or examples for using
> > > the
> > > > > FCK editor for editing and saving content but not in the admin
> > > area. I
> > > > > have a field in a database called "content" and I want it to be
> > > > > editable
> > > > > by affiliates via the FCK editor. Again, this is NOT in the admin
> > > > > area,
> > > > > but in the catalog itself. The problem I am having is that when
> > > they
> > > > > paste certain things from a pdf or word file (they have to be able
> > > to
> > > > > do
> > > > > this!) things look fine in the editor, but when they save it,
> > > things
> > > > > sometimes get encoded in strange ways. I have FCK configured to
> > > paste
> > > > > as plain text only! (no strait paste, or paste from word is
> > > enabled).
> > > > > I
> > > > > have been writing strange filters to try to catch them, but this
> > > seems
> > > > > the totally wrong way to go. Does anybody have a sample of a form
> > > that
> > > > > calls up data, sticks it into FCK, then when submitted, saves back
> > > to
> > > > > the table in such a way that strange characters don't get
> > > introduced?
> > > > > It does not seem to be a browser issue at all.
> > > >
> > > > Interchange version?
> > > >
> > > >
> > > > > Thanks!
> > > > > Rick
> > > > >
> > > > >
> > >
> > > Oh sorry, I am using IC version 5.6.1 and FCK Version 2.6.3
> >
> > Ok ..
> >
> > Additional Q's:
> > Q1: does it work correct via the admin UI, or you do not have the ability to
> > test this?
> Seems to work fine in the admin UI. it changes the tm into ™
>
> > Q2: would you have the option to install the nightly build?
> Yes do have this option
>
> > Q3: your database has a certain encoding?
> Database Server info:
> # Server version: 5.0.51a-3ubuntu5.4-log
> # Protocol version: 10
> # Server: Localhost via UNIX socket
> # User: root at localhost
> # MySQL charset: UTF-8 Unicode (utf8)
> # MySQL connection collation: utf8_unicode_ci
>
> Table specific info:
> # collation: latin1_swedish_ci <---Maybe this is part of my problem??
>
> > Q4: is it possible to paste the snippet of code/page that makes use of the
> > FCKeditor,
> > If so paste it at http://paste.me.uk/
> > This could help in making sure we're on the same base to test this
> > issue.
> >
>
> I realize that there is allot that I am doing wrong here, and
> I am currently in the middle of changing things around. but here goes
> anyway...
> http://www.paste.me.uk/1335.html
>
> Thanks
> rick
>
OK, I think I have this, and seems acceptable right now. I was making it
way to complex. Word to the wise: simplify!
The goal here is to deal with filtering of input values while using an
FCK editor to allow web users to edit content on an IC website. What is
not covered here is how to deal with authentication or any other user
issue. Issues of authentication, uploading content, etc, are not
addressed here. What is assumed is that you have a fly page for a table
displaying some content, and you want an "edit" form that brings you to
a page that loads the content into an FCK editor with a form to save it.
So far it seems to work nice as a way to build quick and easy FCK editor
for web contributors.
First, when displaying content (In my case, using a fly page, showing a
field called "content" in a table called "groups") simply use something
like the following: (adjust for your restrict_html filter)
[item-filter restrict_html.a.address.b.blockquote.br.h1.h2.h3.h4][item-data groups content][/item-filter]
You can have an edit form and button/link right there, but you don't
need to pass the content field. just the code or id of the record you
want to edit.
Once submitted, now you are in the "edit" page where you show the FCK
editor. (here you can do a "light" authentication to make sure this user
may have the rights to edit...) Grab the "content" field fresh like
this: (this assumes you have a record you are updating, and are passing
the id of that record in a value called "group_code". Also assumes you
have a config set for FCK called "content")
[query
type=list
label=content_edit
prefix=content_edit
list_prefix=content_edit_list
sql=|
SELECT code, content
FROM groups
WHERE code = "[value group_code]"
LIMIT 0,1
|]
[content_edit_list]
[display type="htmlarea"
name="content"
height="750"
htmlarea_config="content"
value="[content_edit-data groups content]"
]
[/content_edit_list]
[/query]
Once you submit a form with that, there are two options. One is to
update an existing record, the other is to create a new row.
(1) update a current row:
[tag flag write]groups[/tag]
[query list=1
row-count=1
table=groups
st=sql
sql=|UPDATE groups
SET content = [cgi name="content"
enable_html="1"
filter="restrict_html.a.address.b.blockquote.br.h1.h2.h3.h4
dbi_quote"
]
WHERE code = '[value group_code]'
|]
[/query]
(2) create a new row:
For this, I am setting a quick [tmp content] variable for the "content"
value that was passed in from FCK so I can easily filter it:
[tmp content][cgi name="content"
enable_html="1"
filter="restrict_html.a.address.b.blockquote.br.h1.h2.h3.h4"
][/tmp]
[perl tables=groups]
my $db = $Db{groups};
my %record;
$record{code} = "";
$record{content} = $Scratch->{content};
$Scratch->{key} = $db->set_slice(undef, \%record);
return;
[/perl]
Feedback?
Thanks, and HTH someone.
Rick
--
This message has been scanned for viruses and
dangerous content by Green Mountain Network, and is
believed to be clean.
More information about the interchange-users
mailing list