Jump to content

Bazilisk

Members
  • Posts

    75
  • Joined

  • Last visited

Contact Methods

Profile Information

  • Gender
    Male
  • Location
    Moscow

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

Bazilisk's Achievements

  1. I wrote News application, but can not find how I can add /news/* to sitemap. Pls help.
  2. Thanks. all Ok now. Is it possible to add "AND" rules in WHERE to make second select option?
  3. Have error for MySQL select: $select = \IPS\Db::i()->select( '*', 'news_artcms_news', array('categorynum LIKE ?','%main%'), 'news_artcms_news.num DESC', array( 0, 12 ) ); $results = \IPS\Db::i()->query($select); Where is my mistake? I try to change problems code: array('categorynum LIKE ?','%main%') to array('categorynum = ?','main') but error dont fixed.... categorynum is text field
  4. Thanks I have to make sidebartemplate.phtml in html folder and it will be work?
  5. Fillow manual I can sent variables only to first column in template. \IPS\Output::i()->output = \IPS\Theme::i()->getTemplate( 'app1', 'app1_module', 'front' )->newslist($title, (array) $variables); Is it possible to send it to second column? Regards,
  6. I make application and have to use html tags <p></p> in variables. $text = "<p>some text</p><p>second paragraph text</p>"; But IPS auto convert it to symbols: &lt;p&gt; I try to fix it in template: {{$text = htmlspecialchars_decode($text, ENT_NOQUOTES);}} But htmlspecialchars_decode dont change variable. Is it possible to send formatted text as clear html to template?
  7. Have error in this script in Application system. I have 2 records in array if have record in table news_upload. $select = \IPS\Db::i()->select( '*', 'news_news', NULL, 'news_artcms_news.num DESC', array( 0, 25 ) ); $select = $select->join( 'news_uploads', 'news_uploads.recordNum=news_news.num', 'LEFT' ); $results = \IPS\Db::i()->query($select); Where is my mistake? Next code work Ok in block system. $select = $connection->select( '*', 'news_news', NULL, 'news_news.num DESC', array( 0, 25 ) ); $select = $select->forceIndex( 'num' ); $select = $select->setKeyField( 'num' ); $select = $select->join( 'news_uploads', 'news_uploads.recordNum=news_news.num', 'LEFT' ); $results = \count($select); But in application system I have error for forceIndex() and setKeyField. Think what problem because tables have field 'num', and select get this from second table, but I have to get it from first.... Possible using distinct can decide this task, but can not find sintax.
  8. Yes. Made app follow manual. But can not find how make furl.json for custom application.
  9. Have problems with application breadcrumb url. I made seo-link in admin panel for application coins: https://bullion.ru/coins , but breadcrumb not changed and showed full link https://bullion.ru/index.php?app=coins&module=coin&controller=coin Is it possible to fix it?
  10. Blocks is flexible. You can use it for news block: bullion.ru/news/ Made url link with n=xxx, because its 15 years old :)
×
×
  • Create New...