require_once cot_incfile('comments', 'plug');
$t->assign(array(
	'SUPER_PLUG_COMMENTS' => cot_comments_link('super_plug', $pageurl_params, 'super_plug', $row['super_plug_id'], $row['super_plug_cat'], $row),
	'SUPER_PLUG_COMMENTS_DISPLAY' => cot_comments_display('super_plug', $row['super_plug_id'], $row['super_plug_cat']),
	'SUPER_PLUG_COMMENTS_COUNT' => cot_comments_count('super_plug', $row['super_plug_id'], $row),
	'SUPER_PLUG_COMMENTS_RSS' => cot_url('rss', 'm=comments&id=' . $row['super_plug_id'])
));

And use php_doc info for comments plugin for more understanding of the code and parameters used in call functions. 

It have been along time ago since I have been here , but anyway many things have been change since I have used the old Seditio .

So that is why I am stuck at this moment with an plugin what i am trying to make called stream (jwplayer) 

I wanne add comments on that plugin the old way was very easy in Seditio but I found that its harder in Siena .

The old way was like : 

//comments and rating build
$ratings = sed_import('ratings','G','BOL',1,TRUE);
$comments = sed_import('comments','G','BOL',1,TRUE);

list($comments_link, $comments_display, $comments_count) = sed_build_comments($item_code, $stream_url, $comments);
list($ratings_link, $ratings_display) = sed_build_ratings($item_code, $stream_url, $ratings);

I hope someone can help me with is that will be great , thanks :) 

        <div id="ajax_contact">
          <form action="index.php?e=contact" method="post" name="contact_ajax" id="contact_ajax" class="ajax post-ajax_contact">
          ...
          any your code from contact form
          ....
          <button type="submit" class="btn btn-primary">{PHP.L.Submit}</button>
          </form>
        <div>

Fatal error: Call to undefined function cot_sql_query() in /home2/subsdre/public_html/plugins/usermanager/usermanager.admin.php on line 256

Read this http://www.cotonti.com/docs/ext/extensions/plugin_conversion_howto 1.5. New database layer .... you need replace cot_sql_query() on $db->query() and other

i did updated it a little, but there is still error:

Fatal error: Call to undefined function cot_sql_query() in /home2/subsdre/public_html/plugins/usermanager/usermanager.admin.php on line 256

here the zip:

http://subs.com.ru/datas/usermanager.rar

I have no idea how (and if even) I can achieve this so I tried changing the hooks to page and some other things but except making sure the plugin dopes not work at all I cant get anywhere.

I hope there is someone who is able to help me with this :)

First of all — PHP already had tools to use timezines and DST.

Moreover, as DST is subject to change during long time periods (as legislation changes) PHP had these information in DateTimeZone::listAbbreviations(). 

Than PHP used this info to properly convert time from one time zone to another.

So two rules should be used: 
1. store timestamps in UTC (as you do)
2. use proper time zone for any convertion.

Let's try some example:

$date = new DateTime('2000-01-01', new DateTimeZone('Europe/Moscow'));  
// DST is used in these period  (+03:00 winter +04:00 summer)
$plugin_body .= $date->format('Y-m-d H:i:s P') . PHP_EOL; // 2000-01-01 00:00:00+03:00
$date->setTimeZone(new DateTimeZone('UTC'));
$plugin_body .= $date->format('Y-m-d H:i:s P') . PHP_EOL; // 1999-12-31 21:00:00+00:00
$date->modify('+ 13 year'); 
// in midsummer of 2011 DST was canceled in our region
// actually we get in DST time forever (+04:00 winter +04:00 summer)
$plugin_body .= $date->format('Y-m-d H:i:s P') . PHP_EOL; // 2012-12-31 21:00:00+00:00
$date->setTimeZone(new DateTimeZone('Europe/Moscow')); 
$plugin_body .= $date->format('Y-m-d H:i:s P') . PHP_EOL; // 2013-01-01 01:00:00+04:00
// as DST is cancelled we +04:00 for whole year

So if user had selected propper timezone in users settings (user profile) DST should be concerned.

But some problem may occurs only if you use time shift functions ($date->modify('+ 13 year');) in local time zone as real calculation is made in UTC.

Some info links:

• Actulat DST
• DST on stackoverflow
• Timezone abbrevitions
• About DST and STD transitions

I'm in the middle of working on a heavily modified calendar plugin that uses ajax to emulate google calendar. It's all going well but I want to pay special attention to how I present timestamps to users. At this stage I'd like to make it clear that I know it's important to store timestamps in UTC.

Using cotonti's datetime functions, how do I take an historical timestamp and check if DST was in effect at the time (according to the user's timezone selection) and display the time accordingly? I want to ensure that, if DST is currently in effect for the user, I'm not applying DST corrections to a timestamp that refers to a time when DST wasn't in effect.

I hope my question makes sense... Thanks!

I've given examples below:

Create an event for a date outside DST when it is currently DST:

                STORE AS 09:00                 DISPLAY AS 09:00

Create an event for a date outside DST when it is not currently DST:

                STORE AS 09:00                 DISPLAY AS 09:00

Create an event for a date inside DST when it is currently DST:

                STORE AS 08:00                 DISPLAY AS 09:00

Create an event for a date inside DST when it is not currently DST:

                STORE AS 08:00                 DISPLAY AS 09:00

Added 22 minutes later:

My example assumes I'm on the London/Europe timezone.

Added 5 minutes later:

What would be ideal would be a function (and its reciprocal) that could take a UTC timestamp and the user's preferred timezone and output a local timestamp for the user ensuring it includes the DST correction appropriately based on whether the timestamp occurred during that timezone's DST rules.

$sort = 'page_'.$cfg['page']['cat_'.$pag['page_cat']]['order'];
$way = $cfg['page']['cat_'.$pag['page_cat']]['way'];

2014-01-26 15:22
SQL error 42S22: Column not found: 1054 Unknown column 'page_' in 'order clause'
#0  cot_diefatal(SQL error 42S22: Column not found: 1054 Unknown column 'page_' in 'order clause') called at [D:\Dropbox\Xampp\htdocs\default_sienna_clean_install_clean_db\system\database.php:576]
#1  CotDB->query(SELECT * FROM cot_pages WHERE page_cat = ? ORDER BY page_ , Array ([0] => news)) called at [D:\Dropbox\Xampp\htdocs\default_sienna_clean_install_clean_db\plugins\pagesiblings\pagesiblings.php:14]
#2  include(D:\Dropbox\Xampp\htdocs\default_sienna_clean_install_clean_db\plugins\pagesiblings\pagesiblings.php) called at [D:\Dropbox\Xampp\htdocs\default_sienna_clean_install_clean_db\modules\page\inc\page.main.php:279]
#3  require_once(D:\Dropbox\Xampp\htdocs\default_sienna_clean_install_clean_db\modules\page\inc\page.main.php) called at [D:\Dropbox\Xampp\htdocs\default_sienna_clean_install_clean_db\modules\page\page.php:43]
#4  require_once(D:\Dropbox\Xampp\htdocs\default_sienna_clean_install_clean_db\modules\page\page.php) called at [D:\Dropbox\Xampp\htdocs\default_sienna_clean_install_clean_db\index.php:126]

I made different attempt to see if I could fix it but if I change something at least the sql error dissapears but than I recieve a syntax error cause it expects a string.
I searched around and I found some site which was referring to the $sort allowing sql injection cause it did not santatize. I figured sine the issue seems to be with the $sort part something has changes since this plugin was first written. But looking at other plugins I can not discover how to change it so it works again. I made some tries with "explode" which I saw used in other plugins without luck.

Since pagesiblings is working on this website I hope the fix can maybe shared?
I got the plugin from github.

I tried with 0.9.14 and with 0.9.16 (this is a clean install!) and both give that error.

MecTruy, please don't send PM to attract attention to your topics. If people have time and know the answer they will post a reply. There aren't many new topics on forums, so your topic is not missed by anybody, don't worry. If you continue posting such PMs or offensive messages about other guys, they will be removed and your account will be banned for some time.

find

$env['ext'] = 'index';

replace

$env['ext'] = 'forums';

Siena forum like this url:  http://www.site.com/index.php?e=forums

my cotonti version Siena 0.9.14

note: sorry i open topic wrong category..

That's right, thanks for it. That seems the first version of Attachments is still not being fully ported for Siena, and Attachments 2 are way fresher.

Allright, I installed the Attachments 2. But, that's what I see when clicking on the "Upload files" link: http://joxi.ru/blxvUtg5CbAnZRMNXio. As you can see, it's not a sort of pop-up window, but a separate page. So is any of the js files missing?

Second (but probably it's a sequence of the above issue), the attaching the files is not working: http://joxi.ru/uG1vUtg5CbBgb-CZu2Q Of course, the uploads folder is under CHMOD 777, and again, that seems, some js is missing, but which one? I'll appreciate any help on my issue.

Добавлено 33 минуты спустя:

This could help: in the Opera Dragonfly, after clicking Upload, I catch this 500 Server response:

POST http://domain.ru/index.php?r=attach2&a=upload&area=page&item=15

500 Internal Server Error

...while http://domain.ru/index.php?r=attach2&a=display&area=page&item=15 is fine.

Добавлено 2 часа спустя:

Moreover, take a look:

SQL error 42S22: Column not found: 1054 Unknown column 'att_area' in 'where clause'</p><pre style="overflow:auto">#0  cot_diefatalColumn not found: 1054 Unknown column 'att_area' in 'where clause') called at [/var/www/staleo/data/www/domain.ru/system/database.php:478]
#1  CotDB->query(SELECT * FROM cot_attach
   WHERE att_area = ? AND att_item = ? ORDER BY att_order, Array ([0] => page,[1] => 17)) called at [/var/www/staleo/data/www/domain.ru/plugins/attach2/inc/attach2.upload.php:66]

That seems like an SQL-field att_area is somehow missing.

Добавлено 2 часа спустя:

The solution for me was to run an SQL-injection from here: https://github.com/trustmaster/cot-attach2/blob/master/attach2/setup/upgrade_2.0.sql

For some reason, it wasn't mentioned on the plugin description page.

Anyway, opening the uploading form on a separate page (instead of the floating window on the dark background) is still an issue, how do you think it's being solved?

// $t->parse(); disabled otherwise the contents of tpl shows 2x

Now it properly works and allows me to use the conditions etc. Thanks for all the help!!

Here's a plugin I try to inplement on my Siena 0.9.14: http://www.cotonti.com/extensions/files-media/attachments

While editing a page, I choose which images to upload, click "Submit" on the very bottom of the page, and see the error report:

Fatal error

2013-10-28 13:25

SQL error 42000: Syntax error or access violation: 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 'WHERE att_user = 1' at line 1

Any thoughts on how to deal with it? I would gladly see any of the solutions.

I've never used this Extruder thing before, so I can't be of much more assistence.

Remove:

<div class="content"> </div>

Sorry, it must be cause its late but that class is not present as far as I can tell. Not in the sidepanel tpl at least and also not in the php. I am not sure where you want me to remove it from?


Thanks for the info on the "r", thats very usefull and I will try to remember that :)

<div class="content"> </div>

The 'r' is so that it doesn't include header.php and footer.php.

Call it like this:

<?php defined('COT_CODE') or die('Wrong URL');
/* ====================
  [BEGIN_COT_EXT]
  Hooks=ajax
  [END_COT_EXT]
  ==================== */

$t = new XTemplate(cot_tplfile('sidepanel', 'plug'));

$t->parse();
$t->out();

<!-- sidebar stuff -->
<div id="extruderRight" class="{title:'User Control Panel', url:'index.php?r=sidepanel'}"></div>

Note the index.php?r=sidepanel

<!-- sidebar stuff -->
	<!-- <script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1/jquery.js"></script> -->
	<script type="text/javascript" src="https://www.cotonti.com/inc/jquery.hoverIntent.min.js"></script>
	<script type="text/javascript" src="https://www.cotonti.com/inc/jquery.mb.flipText.js"></script>
	<script type="text/javascript" src="https://www.cotonti.com/inc/mbExtruder.js"></script>
	<script type="text/javascript">

		$(function(){
			if (self.location.href == top.location.href){}
			$("#extruderRight").buildMbExtruder({
				position:"right",
				width:300,
				extruderOpacity:.8,
				textOrientation:"tb",
				onExtOpen:function(){},
				onExtContentLoad:function(){},
				onExtClose:function(){}
			});
		});
	</script>
<!-- <div id="extruderRight" class="{title:'User Control Panel ', url:'parts/extruderRight.html'}"></div> -->
<div id="extruderRight" class="{title:'User Control Panel', url:'index.php?e=sidepanel'}"></div>

Than I have my sidepanel setup php file: 

<?php
/* ====================
[BEGIN_COT_EXT]
Code=sidepanel
Name=sidepanel
Category=User control panel
Description= A sidepanel you can use as a user control area.
Version=1.0
Date=2013-10-22
Author=
Copyright=
Notes=
Auth_guests=RW
Lock_guests=12345A
Auth_members=RW
Lock_members=12345A
[END_COT_EXT]
==================== */

/**
 * Sidepanel Plugin for Cotonti CMF
 *
 * @package sidepanel
 * @version 1.0
 * @author
 * @copyright (c)
 * @license BSD
 */
?>

Than my sidepanel.php: 

<?php

/* ====================
  [BEGIN_COT_EXT]
  Hooks=standalone
  [END_COT_EXT]
  ==================== */

/**
 * Sidepanel Plugin for Cotonti CMF
 *
 * @package sidepanel
 * @version 1.0
 * 
 * @copyright (c)
 * @license BSD
 */
defined('COT_CODE') or die('Wrong URL');

$tplfile = cot_import('tpl', 'G', 'TXT');
$mskin = cot_tplfile(array('sidepanel', $tplfile), 'plug');
$t = new XTemplate($mskin);

?>

And I have this is my sidepanel.tpl 

<!-- BEGIN: MAIN -->
<!--
  ~ /*******************************************************************************
  ~  jquery.mb.components
  ~  file: extruderRight.html
  ~
  ~  Copyright (c) 2001-2013. Matteo Bicocchi (Pupunzi);
  ~  Open lab srl, Firenze - Italy
  ~  email: matteo@open-lab.com
  ~  site: 	http://pupunzi.com
  ~  blog:	http://pupunzi.open-lab.com
  ~ 	http://open-lab.com
  ~
  ~  Licences: MIT, GPL
  ~  http://www.opensource.org/licenses/mit-license.php
  ~  http://www.gnu.org/licenses/gpl.html
  ~
  ~  last modified: 04/01/13 17.13
  ~  ******************************************************************************/
  -->

<div class="voice {}"><span class="label"><a class="label" href="http://www.open-lab.com">Open Lab</a></span></div>
<div id="tw" class="voice {panel:'parts/extr.tw.html'}"><a class="label" href="http://twproject.com" target="_blank">teamwork</a></div>
<div class="voice {panel:'parts/extr.mti.html'}"><span class="label">Morethanicons</span></div>
<!-- IF {PHP.usr.isadmin} -->
	<div class="voice {panel:'parts/extr.network.html'}"><span class="label">Only admins can see this</span></div>
<!-- ENDIF -->
<div class="voice {disabled:true}"><span class="label">Microsoft Internet Explorer</span></div>
<div class="voice {}"><a class="label" href="http://firefox.com" target="_blank">get FireFox</a></div>
<div class="voice {}"><a class="label" href="http://www.google.com/chrome" target="_blank">get Chrome</a></div>
<div class="voice {}"><a class="label" href="http://www.apple.com/safari/" target="_blank">get Safari</a></div>
<div class="voice {}"><a class="label" href="http://www.opera.com/" target="_blank">get Opera</a></div>

<script type="text/javascript"></script>

<!-- END: MAIN -->

In the tpl I made one if statement purely for testing. Since it works my plugin actually works, except for tht redirect to its standalone page after succesfull login.
Please bare in mind, I do not really understand so much about making plugins, I am always reading and trying till I drop ;)

The issue is with the fact this plugin causes a user to be (re)directed to "index.php?e=sidepanel" after succesfull login. And of course it should not do that. I would like to know how to prevent that.
sidepanel is the plugin I created for this.
I tried to make the plugin global instead of standalone but than it wont work at all.
 

<!-- IF {PHP.usr.id} > 0 -->
Show something
<!-- ENDIF -->

Have a look at: http://www.cotonti.com/docs/ext/themes/

Simply code it as explained in the documentation on their website.

If you want to use a seperate TPL for it you could include it with: {FILE "{PHP.cfg.themes_dir}/{PHP.usr.theme}/tpl/foobar.tpl"}

<?php

/* ====================
  [BEGIN_COT_EXT]
  Hooks=standalone
  [END_COT_EXT]
  ==================== */

/**
 * Contact Plugin for Cotonti CMF
 *
 * @package contact
 * @version 2.1.0
 * @author Cotonti Team
 * @copyright (c) Cotonti Team 2008-2013
 * @license BSD
 */
defined('COT_CODE') or die('Wrong URL');

$tplfile = cot_import('tpl', 'G', 'TXT');
$mskin = cot_tplfile(array('sidepanel', $tplfile), 'plug');
$t = new XTemplate($mskin);

?>

The sidepanel is created in my footer with the following code: 

<div id="extruderRight" class="{title:'User Control Panel', url:'index.php?e=sidepanel'}"></div>

Yes, I am using "redirect back on login" and I made 100% sure I am not actually on the plugin page.
Is there also a way to prevent from people accessing that "index.php?e=sidepanel"? Cause I have to make it standalone else it does not work, but than you can access it in a standalone page (obviously) which will than show the contents of my tpl in a page.

I am trying to make a plugin for this sitepanel: http://pupunzi.com/#mb.components/mb.extruder/extruder.htm

Edit the templates theme of your site:

• In page.add.tpl  and  page.edit.tpl paste the appropriate tags specified in the configuration of the plug-extrafield.
• In page.list.tpl insert tag {LIST_ROW_PAGE_GROUP_ROTATOR}. It is also available {LIST_ROW_PAGE_IN_GROUP_COUNT} tag that displays the number of pages grouped , with which you can make the condition display "switcher" only pages that are in the group. It will look something like this : <!- IF {LIST_ROW_PAGE_IN_GROUP_COUNT} > 1 -> {LIST_ROW_PAGE_GROUP_ROTATOR} <!- ENDIF ->. As well , it is necessary for the correct switch pages in the group to wrap the contents of the container LIST_ROW section showing the pattern id id = "paggrp {LIST_ROW_ID}. So section should look like this : <!- BEGIN: LIST_ROW -> <div id="paggrp {LIST_ROW_ID}"> ... </ div> <!- END: LIST_ROW ->
• If necessary, make changes to the template "switcher" by editing pagegroup.listrow.rotator.tpl

Sorry for my english (using Google Translate)