Bazilisk
-
Posts
75 -
Joined
-
Last visited
Content Type
Downloads
Release Notes
IPS4 Guides
IPS4 Developer Documentation
Invision Community Blog
Development Blog
Deprecation Tracker
Providers Directory
Forums
Events
Store
Gallery
Posts posted by Bazilisk
-
-
Thanks. all Ok now.
Is it possible to add "AND" rules in WHERE to make second select option?
-
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);
QuoteYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '? ORDER BY news_artcms_news.num DESC LIMIT 0,12' at line 1
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
-
Thanks
I have to make sidebartemplate.phtml in html folder and it will be work?
-
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,
-
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: <p>
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?
-
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.
-
Yes. Made app follow manual. But can not find how make furl.json for custom application.
-
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?
-
Blocks is flexible. You can use it for news block: bullion.ru/news/
Made url link with n=xxx, because its 15 years old :)
How to add application page to sitemap?
in Developer Connection
Posted
I wrote News application, but can not find how I can add /news/* to sitemap.
Pls help.