Community Forum

If you have questions about my software, chances are this forum has the answers.

You'll need to register before you can post on the forum to ask your question or to answer another one. A reply will be posted to each and every question that is asked so there is no need to double post or bump your post. I do my best to answer promptly but in some cases it may take a day or two. Bear with me and I`ll get your question answered quickly.

Here are a few tips to help you to get your questions answered more rapidly.

IMPORTANT: Posts in English only. I don't have a translator and I'll be unable to understand your message properly and will probably delete it.
SEARCH: Use the search option to see if your question has been answered on the forum before now or if there is an answer in the documentation of your software.
PRIORITY SUPPORT: If you have purchased a commercial version of any software, using the contact option at the licence centre ensures a faster response.
AUTO DELETION: Accounts older than 5 days, with no posts or topics, are automatically deleted. Only register if you are thinking of posting.
LINKS: Any links posted are not clickable and must be copied / pasted into your browser address bar.

You are not logged in.

#1 y3000 10-07-2018 08:31:40

Dear Maian-Team,

the feature "Display On The Following Days Only" is not working when language/timezone has not an english format. In file /control/classes/class.system.php in function ticketDepartments() there is the following code:

    $day  = $this->datetime->mswDateTimeDisplay($now, 'D', $this->settings->timezone);
    $q_dept = mswSQL_query("SELECT `id`,`name` FROM `" . DB_PREFIX . "departments`
              WHERE `showDept` = 'yes'
              AND (`days` IS NULL OR `days` = '' OR FIND_IN_SET('{$day}', `days`) > 0)
              ORDER BY `orderBy`
              ", __file__, __line__);

E.g. for today (Tuesday) the variable $day returns the value "Tue" but the value for field days in table departments is "Die" (=Dienstag=german word for tuesday). So the query returns no result. Can you fix this for the next update?

Bye smile

#2 msworld 10-07-2018 17:24:12

Whoops. Thank you, will be fixed in the next version. smile

#3 msworld 11-07-2018 15:47:36

Fixed. Download and replace:
admin/templates/system/dept/dept.php

Any existing will need updating (eg: make sure the database stores the eng name)

#4 y3000 12-07-2018 06:35:48

Thanky you works fine smile

#5 msworld 12-07-2018 06:47:55

Great. smile

Board footer

Maian Script World - Free PHP Software for Personal or Business Use.
© 2003-2018 Maian Script World & David Ian Bennett.

2Checkout.com is an authorized reseller of goods and services provided by Maian Script World