Search found 411 matches

by rotezecke
Sun Mar 28, 2021 8:36 pm
Forum: Developers Discussion
Topic: GetArray with $inputarr
Replies: 4
Views: 10636

Re: GetArray with $inputarr

I have since modified my sql to build a string of IDs instead of the $inputarr.

Code: Select all

SELECT * FROM quotes_booked qb WHERE qb.qb_webquote_id IN ($bookingsStr) ORDER BY qb.qb_id ASC
This works as expected. Still wonder how to use the $inputarr correctly though.
by rotezecke
Sun Mar 28, 2021 8:09 pm
Forum: Developers Discussion
Topic: GetArray with $inputarr
Replies: 4
Views: 10636

GetArray with $inputarr

I'm using GetArray method with an input array SELECT * FROM quotes_booked qb WHERE qb.qb_webquote_id = ? ORDER BY qb.qb_id ASC and my array looks like this: Array ( [0] => 10285 [1] => 10286 ) I know there is a result for 10285, and I know there is NO result for 10286. $bookingsArray = $db->GetArray...
by rotezecke
Wed Mar 17, 2021 12:49 am
Forum: Modules/Add-Ons
Topic: News replacement module
Replies: 4
Views: 1119

Re: News replacement module

thanks, will try install later. i felt guilty back then not helping with testing; bit ironic to install it now that it is shelved. :)
by rotezecke
Tue Mar 16, 2021 10:19 pm
Forum: Modules/Add-Ons
Topic: News replacement module
Replies: 4
Views: 1119

Re: News replacement module

Can PressRoom module be downloaded anywhere? I don't plan to install it, or use it, but want to look at source code hoping to find a different pagination example (different to News,etc).
by rotezecke
Tue Mar 16, 2021 8:34 pm
Forum: Modules/Add-Ons
Topic: News replacement module
Replies: 4
Views: 1119

News replacement module

I recall having read that News shall be removed from core distribution and replaced with a more modern module. I just cant find where I read this, nor do I remember the name of that module which is what I am after. Any clues? Thanks.
by rotezecke
Sun Mar 14, 2021 10:15 am
Forum: Developers Discussion
Topic: pagination in module action
Replies: 2
Views: 5564

Re: pagination in module action

the holiday module uses $query = new HolidayQuery(array('published'=>1,'limit'=>$limit)); $holidays = $query->GetMatches(); News (or cgblog) seem to do all the sql stuff inside the action.default file. can pagination be achieved with the above class? assuming that such a query class is best practice...
by rotezecke
Sun Mar 14, 2021 5:40 am
Forum: Developers Discussion
Topic: pagination in module action
Replies: 2
Views: 5564

pagination in module action

Can someone point me in a direction of a current module that implements pagination for frontend, or more specifically: I'm trying to integrate pagination with the Holidays module and its HolidaysQuery class. Thanks.
by rotezecke
Thu Mar 04, 2021 1:35 pm
Forum: Modules/Add-Ons
Topic: Migrate from CGBlog to LISE
Replies: 10
Views: 3291

Migrate from CGBlog to LISE

Hi, the module forking project page mentions that, among others, CGBlog could be replaced with LISE. I can probably figure out how to set up templates and hopefully pretty URLs but I don't see an easy way to migrate my existing blog articles to LISE. Seems like data needs injecting into two differen...
by rotezecke
Fri Jan 22, 2021 10:20 am
Forum: CMSMS Core
Topic: Mail Setting password Field length
Replies: 3
Views: 1480

Re: Mail Setting password Field length

I think this is stored in the siteprefs table, and the value field is a "text" field, which can take up to 65,535 characters. The admin page may have a limit on the input field (I did not check this) but you could either create a custom admin template or just enter it directly into databas...
by rotezecke
Mon Nov 02, 2020 11:49 pm
Forum: General Discussion
Topic: recommended max records per table
Replies: 2
Views: 5947

Re: recommended max records per table

Thanks again for yet another detailed response, JoMorg. At this point, you put more work into this module than I have. :) While the scope of the project isn't fully clear yet, I feel more confident it will work regardless of what they throw at me. Very good point about shared hosting, though. That's...
by rotezecke
Mon Nov 02, 2020 12:59 am
Forum: General Discussion
Topic: recommended max records per table
Replies: 2
Views: 5947

recommended max records per table

I am looking into writing a module to record timesheets for employees (and process them via export to external software). Each workday would create a record, per employee. If I only record the actual days worked, I have about 200 records per employee, per year. A company of 50 employees would theref...
by rotezecke
Fri Oct 23, 2020 2:43 am
Forum: Modules/Add-Ons
Topic: Form Browser strips out text formating
Replies: 3
Views: 1327

Re: Form Browser strips out text formating

Check your templates and pages and remove any {strip} blocks. also, if content is stored in variable {$content|strip} will also remove those line breaks.
by rotezecke
Tue Aug 11, 2020 1:01 am
Forum: Modules/Add-Ons
Topic: FEU new property does not show immediately
Replies: 0
Views: 1873

FEU new property does not show immediately

hi when I add a property to FEU and assign to a group, these properties are not added to the user until the changesettings form (via frontend) is submitted, or the user is modified in the backend. There's a new entry in table "module_feusers_propdefn" but nothing in "module_feusers_pr...
by rotezecke
Tue Aug 04, 2020 9:32 pm
Forum: Modules/Add-Ons
Topic: Change single setting in FEU
Replies: 5
Views: 1826

Re: Change single setting in FEU

Yes, process_pagedata is called before assigning first content block. I use the "Smarty data or logic that is specific to this page" section on many other pages and it works fine. I since reported this as bug (maybe prematurely) . But I managed to work around it with a small modification t...
by rotezecke
Tue Aug 04, 2020 4:00 pm
Forum: Modules/Add-Ons
Topic: Change single setting in FEU
Replies: 5
Views: 1826

Re: Change single setting in FEU

i tried

Code: Select all

{cms_module_hint module=FrontEndUsers changesettingstemplate='feu_change_single_field.tpl'}
in "Smarty data or logic that is specific to this page" with no luck.

Go to advanced search