Read Only Fields

Sun, 24 Nov 2013 14:19:50 -0800

Hey,

Is there an inbuilt function to set certain fields within a schema as read only?

I thought there was... but the System Field options and Admin Only doesn't achieve this - moreso just hides the fields altogether if non admin.

As well as setting some fields as read only, also want to disable the ability to amend the 'createdByUser' field.

Will do via a plugin if needbe, but wanted to see if I'm missing the existing functionality somewhere.

Cheers

Rob

getRecords - specify columns

Mon, 26 Nov 2012 22:00:59 -0800

Hi all,

Is there any prebuilt function in getRecords which allows us to specify what columns are called?

By default getRecords returns * - we have a few statements which would run alot quicker if we could specify the specific columns we were after, so wondering if this functionality exists already anyhow?

Thanks,
Rob

Re: [Dave] Default Values - enable access like a new section

Wed, 19 Sep 2012 23:55:39 -0700

Awesomesauce!

Works a treat, thanks Dave (and sorry for the delay...)

Default Values - enable access like a new section

Fri, 07 Sep 2012 06:52:14 -0700

Hey,

I want to make the "default values" of textfields etc of one particular schema to be available for editing by a normal user, so am thinking of making a custom page which displays / edits the default value for these fields, as I presume this data is stored somewhere in mySQL.

Before I do... anyone done this before, got any hints/tips, or a plugin? ;)

Cheers!

Re: [Jason] session_start(): ps_files_cleanup_dir: opendir(/var/lib/php5) failed:

Thu, 28 Jun 2012 15:46:27 -0700

Hi,

Thanks heaps, will give it a whirl.

Cheers

session_start(): ps_files_cleanup_dir: opendir(/var/lib/php5) failed:

Wed, 27 Jun 2012 18:14:15 -0700

Hi,

On one particular server where I have CMSB installed, I sometimes get this error:

session_start(): ps_files_cleanup_dir: opendir(/var/lib/php5) failed:

I've read all up about it and solutions require editing of server config...
(http://forum.kohanaframework.org/discussion/565/garbage-collector-error-with-sessions-on-debian/p1)

However this particular server I have no access whatsoever to anything configuration-wise.

Reading this:
http://www.interactivetools.com/forum/gforum.cgi?post=82999;search_string=ps_files_cleanup_dir%3A;#82999

Suggests that the bug would have been fixed by now (this was v 2.06)...

Any suggestions on how to fix with v2.15 with no access to php.ini etc?

Thanks

Re: [Dave] createPDF - save pdf to server and don't output

Tue, 12 Jun 2012 16:52:26 -0700

5 stars to Dave.

$url  = "http://www.google.com";
$data = createPDF_fromUrl($url);
file_put_contents('myfile.pdf', $data);

// my PDFMerger script below
$pdf->addPDF('myfile.pdf', '1')
	->addPDF('myotherfile.pdf', '1-2')
	->addPDF('myotherfile2.pdf', 'all')
	->merge('download', 'myoutput.pdf');

works a treat, many thanks :)

Rob

Re: [Jason] createPDF - save pdf to server and don't output

Mon, 11 Jun 2012 21:00:50 -0700

Done, email sent.

Cheers

createPDF - save pdf to server and don't output

Mon, 11 Jun 2012 01:23:04 -0700

Hey

Further to my query on combining PDFs for whtmltopdf I have a possible solution, which lends itself to another question...

I can combine PDFs into one PDF via PHP, IF the PDFs are locally stored on the server.

i.e.
/pdfs/file.pdf

An external link like
http://www.blaa.com/pdfs/file.pdf won't work

So... is there a way to get the createPDF plugin to:

* Save the outputted PDF file (the one it'd normally output) to a folder, somewhere

* Present the filename (and/or filepath) as a variable

* And NOT present the generated PDF to the user (i.e. don't pop up with option to download/view)

Then I can collect the local file path of the generated PDF, and combine it into a bunch of them, and then run my PHP script to combine the lot.

Thanks :)
Rob

Re: [Toledoh] createPDF - combine PDFs

Mon, 11 Jun 2012 00:21:25 -0700

Thanks Toledoh - it looks as though that works for html additions in the footer area only too... no putting a pdf file into that footer unfortunately.

Thanks thou :)

Re: [Dave] createPDF - combine PDFs

Thu, 07 Jun 2012 22:27:08 -0700

Hey Dave,

Have tried embed and object and neither work when running createPDF on it unfortunately.

Going to try 3rd party pdf displaying scripts and see if they rock any better results - will report back after the weekend!

Cheers

createPDF - combine PDFs

Thu, 07 Jun 2012 00:00:41 -0700

Hey,

This is a long shot, but is there anyway to use the createPDF function to create one PDF output from multiple pdfs...

I.e. I upload PDF files x and y, and also create PDF Z from HTML using createPDF...

I want to then output one single PDF, of X, Y and Z.

I can do that locally, but want to be able to automate it online...

Any ideas?!

Thanks

Re: [Jason] User Access Levels

Tue, 05 Jun 2012 18:45:42 -0700

Awesome, should have looked there first ;)

Thanks

Re: [kkegans] Default Value for wysiwyg field

Tue, 05 Jun 2012 14:54:54 -0700

Hey

Thanks Damon - have replied via email.

All seems to be working fine now, in Chrome - so looks like it was a local browser / cache issue...

Sorry to bother you for something so trivial!

Cheers

User Access Levels

Tue, 05 Jun 2012 01:39:27 -0700

Hi,

I want to give certain users access to a specific field in an editor.

However I don't want to make them Admin (don't want them to see all the Admin stuff).

I.e. User account record has setting "Manager".
If manager, then show (or can edit) a certain field in another table.

Is that possible without hacks? :)

Cheers!

Re: [Jason] Default Value for wysiwyg field

Tue, 05 Jun 2012 01:12:54 -0700

Hey

Sorry for delay in getting back to you.

Am using the new 2.15. Have submitted 2nd Level Request.

Cheers Jason,
Rob

Default Value for wysiwyg field

Tue, 29 May 2012 20:26:17 -0700

Hi,

The default value field option for wysiyg fields is not working... is this normal?

If i enter plain text (e.g. Hello), or html (

Hello

), the editer just loads the wysiwyg blank/empty.

Is this a fact of life?

Cheers

Re: [Jason] Autobackup Plugin - Split Tables

Tue, 29 May 2012 18:03:33 -0700

Hi Jason,

Thanks for the reply - yeah I was hoping to avoid the multiple files issue as otherwise I'll end up with about 25 emails and files - ideally I just want to split it to two files, of half tables each...

Is that possible with customising the backup function?

Cheers

createPDF - combine multiple URLs into one PDF

Mon, 28 May 2012 20:10:49 -0700

Hello,

Is there anyway to use the createPDF function to create one outputted PDF from multiple URLs?

i.e.

create pdf from www.google.com
create pdf from www.yahoo.com

output a pdf which is the two combined pages

Cheers!!

Autobackup Plugin - Split Tables

Mon, 28 May 2012 14:58:32 -0700

Hi,

I have the autobackup plugin working on one of my installations, which is working fine, saving the backup php file to the backups folder, however the file is not getting compressed and therefore not emailed.

It's because the file is too big - the file before compression is about 70MB, and when trying to compress (gzencode) the file, it errors with a memory timeout:

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 65137092 bytes)

If I set the memory to 600MB (!!!) it does not produce the error, and finishes fine, but the file is still not emailed, so that then may be an issue with email file size attachment.

So, I wanted to try and split the backup file sent by email into parts, by table - there are a few tables which are particularly huge.

i.e. backup tables a - m, compress, email, and backup tables n-z, compress and email.

I can send a single table editing the autobackup file to:

$success = backupDatabase($filename, "table")

but is there a way do multiple tables in one go? Or, skip certain tables?

Thanks in advance
Rob

Re: [Tom P] Create CMSB Schema from mySQL table

Mon, 26 Mar 2012 14:38:53 -0700

Hey

Thanks for the info - yeah thought it would be a manual case like that.

Worth a try thou ;)

Cheers

Create CMSB Schema from mySQL table

Sun, 25 Mar 2012 21:52:45 -0700

Hi,

I have a mySQL table, created directly in phpmyadmin.

Now I want it as a section in CMSB - i.e. need a schema for it.

The table has a rather lot of fields, so don't really want to do it manually.

Is there an easy/automatic way of doing it?

If I create the CMSB table, and then add in the extra fields in phpmyadmin, it updates them in CMSB, but this isn't really what I'm after as I don't get field labels (these are to be same as the field names), and I still would have to add the fields again in phpmyadmin.

Any suggestions, most appreciated.

Thanks

Re: [Tom P] CMSB install hacked

Sun, 18 Mar 2012 22:21:35 -0700

Hi Tom,

Thanks for the help and reply.

Have sent to support@interactivetools.com

Thanks :)
Rob

CMSB install hacked

Fri, 16 Mar 2012 13:28:25 -0700

Hello,

One of my CMSB installs was recently compromised, with code injection into /data/settings.dat.php and a schema file.

The injection was base64 code, directly onto the files - so when I pulled them from FTP the code is physically on the file.

The top of settings.dat.php (and a schema file) looked like this:

"ZXZhbChiYXNlNjRfZGVjb2RlK.... (and continued string like this for 30 odd lines)
"));  ?>

The host gave us this:

I have reviewed some other data in the account, and it looks like the issue may be happening because of insecure file permissions on your folder at /public_html/cmsAdmin/data/ -- Please note that if a folder is writable by anyone other than the primary user for the account, our server will not allow php scripts to run from the folder. Your data folder is currently set at 777 permissions, meaning any user on the server can write changes to files within that folder.

In addition, there is a suspicious line of code at the beginning of the file at /public_html/cmsAdmin/data/settings.dat.php encoded in base64 -- I suspect that your account may have been compromised, and this code is hacked code that has been placed on your account, which isn't functioning as the hacker intended. I would highly recommend replacing the files in your account with a clean copy of your local backup.

What would allow this to happen? settings.dat.php and /schema/ is chmod 777, which is required by CMSB, but then would that not allow the above to occur?

I know little about this type of thing and what would allow it to happen so any advice so we can prevent it from happening again would be most appreciated.

Thanks all

Re: [Jason] createPDF/wkhtmltopdf & Google Maps - not displaying markers

Mon, 12 Mar 2012 17:06:52 -0700

Cool, thanks, works a treat (although the Google API has a limit to the output img dimensions), but we can live with that :)

Thanks