Advertisement:

Author Topic: SimplePortal  (Read 1577824 times)

Offline DJF-1975

  • Semi-Newbie
  • *
  • Posts: 12
Re: SimplePortal
« Reply #5320 on: January 28, 2018, 11:25:02 PM »
Excellent news! I'd be lost without this place IMO SP is the only solution for an SMF portal! thank you, and welcome back!

D

Offline landyvlad

  • Sophist Member
  • *****
  • Posts: 1,007
  • Gender: Male
    • Michael Reed on Facebook
    • GSX1400 Owners ORG
Re: SimplePortal
« Reply #5321 on: January 29, 2018, 02:24:32 AM »
IMO SP is the only solution for an SMF portal!

I'd be interested to put this in context, what other portals have you tried?

For the record I've tried SP, TinyPortal and EZPortal. Each is different with its own strengths and weaknesses. I settled on TP as best for me, but when it comes to these three there is no wrong answer :)

Glad to see SP site back up and running.  Good work all :)


 
Please do not PM, IM or Email me with questions on astrophysics or theology.  You will get better and faster responses by asking homeless people in the street. Thank you.

To paraphrase Kindred: "There are no technical solutions to social problems."

Offline DJF-1975

  • Semi-Newbie
  • *
  • Posts: 12
Re: SimplePortal
« Reply #5322 on: January 29, 2018, 07:51:53 AM »
I used TP for literally years. I've used EZ... SP's layout and ease of use is why I picked it.

D

Offline bigfan

  • Newbie
  • *
  • Posts: 1
Re: SimplePortal
« Reply #5323 on: February 07, 2018, 01:03:23 PM »
Hi,

What happened to quick internal links? I can't find it in add new blocks option anymore. How do I enable it?

Thank you for your great works.

Offline Beowulf1976

  • Jr. Member
  • **
  • Posts: 131
  • Gender: Female
  • I'm a noob, and proud.
    • Beowulf1976 on Facebook
    • @Beowulf1976 on Twitter
    • Friends of Inigo
Re: SimplePortal
« Reply #5324 on: February 20, 2018, 05:25:54 AM »
Hello,


when I try to add shoutbox I get a database error:

Code: [Select]
Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation 'ifnull'File: /home/********/public_html/forum/Sources/Subs-Portal.phpLine: 1261

When I check that file, on that line I have:


Code: [Select]
      );

The bit before is this:


Code: [Select]
function sportal_get_shouts($shoutbox, $parameters)
{
   global $smcFunc, $scripturl, $context, $user_info, $modSettings, $options, $txt;


   $shoutbox = !empty($shoutbox) ? (int) $shoutbox : 0;
   $start = !empty($parameters['start']) ? (int) $parameters['start'] : 0;
   $limit = !empty($parameters['limit']) ? (int) $parameters['limit'] : 20;
   $bbc = !empty($parameters['bbc']) ? $parameters['bbc'] : array();
   $reverse = !empty($parameters['reverse']);
   $cache = !empty($parameters['cache']);
   $can_delete = !empty($parameters['can_moderate']);


   if (!empty($start) || !$cache || ($shouts = cache_get_data('shoutbox_shouts-' . $shoutbox, 240)) === null)
   {
      $request = $smcFunc['db_query']('', '
         SELECT
            sh.id_shout, sh.body, IFNULL(mem.id_member, 0) AS id_member,
            IFNULL(mem.real_name, sh.member_name) AS member_name, sh.log_time,
            mg.online_color AS member_group_color, pg.online_color AS post_group_color
         FROM {db_prefix}sp_shouts AS sh
            LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = sh.id_member)
            LEFT JOIN {db_prefix}membergroups AS pg ON (pg.id_group = mem.id_post_group)
            LEFT JOIN {db_prefix}membergroups AS mg ON (mg.id_group = mem.id_group)
         WHERE sh.id_shoutbox = {int:id_shoutbox}
         ORDER BY sh.id_shout DESC
         LIMIT {int:start}, {int:limit}',
         array(
            'id_shoutbox' => $shoutbox,
            'start' => $start,
            'limit' => $limit,
         )
      );


I know nothing about this kind of stuff, but I can see there seems to be an open { and no closing } ?

“Them as can do has to do for them as can't. And someone has to speak up for them as has no voices.”

Offline SaltedWeb

  • Sr. Member
  • ****
  • Posts: 861
  • Gender: Male
  • The Tired One
Re: SimplePortal
« Reply #5325 on: February 23, 2018, 07:27:10 PM »
Is there a way in SP to have blocks side by side each other in the header, top , bottom areas? ?
Knowing your limitations makes you human, exceeding these limitations makes you worthy of being human.

Offline Dwev

  • Jr. Member
  • **
  • Posts: 261
Re: SimplePortal
« Reply #5326 on: February 24, 2018, 03:33:45 AM »
Reposting this one, because it was never answered.

I use the latest version of SP. I use a few "Recent Posts/Topics" blocks (set to "topics"). As far as I can see, this block doesn't show somewhat old topics. I cannot see the topics which I posted a few months ago.

I would like to have a recent posts/topics block which is timeless. Is there any way I can do that?

Thank you in advance.

If you want a list of topics similar to how it's done in that block, but with your own set of topics you need to make a custom PHP block, have the topic IDs in an Array, fetch the id of first message of each topic, and use the ssi_fetchPosts function.

Someone asked a similar question yesterday, but as I'm in my mobile phone it's hard to put code, but that is what I remember from one site I used something similar.

Recent Topics seem to disappear after a month, I suppose that's a setting somewhere.

Isn't there a way to adjust that setting?

Seems a lot easier than what's 'Gluz' is suggesting, if it's feasible, of course.

Online vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 23,608
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: SimplePortal
« Reply #5327 on: February 24, 2018, 08:32:33 AM »
They disappear since it probably uses the smf default code which has a max topic id which it limits the results returned by.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline Dwev

  • Jr. Member
  • **
  • Posts: 261
Re: SimplePortal
« Reply #5328 on: February 24, 2018, 12:44:41 PM »
@ vbgamer45: do you (or anybody else) know where this code can be found, and if it's (relatively) easy to change it?

Offline SaltedWeb

  • Sr. Member
  • ****
  • Posts: 861
  • Gender: Male
  • The Tired One
Re: SimplePortal
« Reply #5329 on: February 24, 2018, 03:19:20 PM »
Disregard the above question, I am just going to create some tables and add it that way.

Thanks
Knowing your limitations makes you human, exceeding these limitations makes you worthy of being human.

Offline Ninja ZX-10RR

  • SMF Hero
  • ******
  • Posts: 2,243
  • Gender: Male
  • Sniper Legends
    • Flavio93Zena on Facebook
    • Virtual Interactive Games Entertainment Forum
Re: SimplePortal
« Reply #5330 on: February 25, 2018, 07:41:03 AM »
Disregard the above question, I am just going to create some tables and add it that way.

Thanks
Could also try a search on our website: https://simpleportal.net/index.php?topic=5332.0 maybe it would return something much nicer than a table :)
Quote from: BeastMode topic=525177.msg3720020#msg3720020
It's so powerful that on this post and even in the two PMs you sent me,you still answered my question very quickly and you're apologizing for the delay. You're the #1 support I've probably ever encountered man, so much respect for that. Thank you, and get better soon.

I'll keep this in my siggy for a while just to remind me that someone appreciated what I did while others didn't.
♥ Jess ♥

STOP EDITING MY PROFILE

Offline SaltedWeb

  • Sr. Member
  • ****
  • Posts: 861
  • Gender: Male
  • The Tired One
Re: SimplePortal
« Reply #5331 on: February 25, 2018, 11:31:15 AM »
Thanks I will give that a try.
Knowing your limitations makes you human, exceeding these limitations makes you worthy of being human.

Offline Rock Lee

  • Native Language Support Specialist
  • SMF Hero
  • *
  • Posts: 3,913
  • Gender: Male
  • Learning more every day!
    • BomberCode.Oficial on Facebook
    • RockLee-BC on GitHub
    • @Bomber_Code on Twitter
    • Bomber Code ~ La nueva era del conocimiento
Re: SimplePortal
« Reply #5332 on: February 26, 2018, 09:38:20 AM »
As the translations are installable packages and the Spanish packages are updated to work with the latest version.
 

Regards!
¡Regresando como cual Fenix! ~ Bomber Code © 2020
Ayudas - Aportes - Tutoriales - Y mucho mas!!!

Offline Ninja ZX-10RR

  • SMF Hero
  • ******
  • Posts: 2,243
  • Gender: Male
  • Sniper Legends
    • Flavio93Zena on Facebook
    • Virtual Interactive Games Entertainment Forum
Re: SimplePortal
« Reply #5333 on: February 26, 2018, 11:33:03 AM »
I don't think we had any translation changes since 2.3.5, we store all the translation files here: https://simpleportal.net/index.php?action=downloads;area=stable_language_packs :)
But thanks anyway, I'm sure one of my colleagues will update it if necessary! :)
Quote from: BeastMode topic=525177.msg3720020#msg3720020
It's so powerful that on this post and even in the two PMs you sent me,you still answered my question very quickly and you're apologizing for the delay. You're the #1 support I've probably ever encountered man, so much respect for that. Thank you, and get better soon.

I'll keep this in my siggy for a while just to remind me that someone appreciated what I did while others didn't.
♥ Jess ♥

STOP EDITING MY PROFILE

Offline Rock Lee

  • Native Language Support Specialist
  • SMF Hero
  • *
  • Posts: 3,913
  • Gender: Male
  • Learning more every day!
    • BomberCode.Oficial on Facebook
    • RockLee-BC on GitHub
    • @Bomber_Code on Twitter
    • Bomber Code ~ La nueva era del conocimiento
Re: SimplePortal
« Reply #5334 on: February 26, 2018, 11:39:02 AM »
I don't think we had any translation changes since 2.3.5, we store all the translation files here: https://simpleportal.net/index.php?action=downloads;area=stable_language_packs :)
But thanks anyway, I'm sure one of my colleagues will update it if necessary! :)

I had not used previous versions so I was not sure ... But since I had to go around on my HDD it never hurts to publish it :P


Regards!
¡Regresando como cual Fenix! ~ Bomber Code © 2020
Ayudas - Aportes - Tutoriales - Y mucho mas!!!

Offline SaltedWeb

  • Sr. Member
  • ****
  • Posts: 861
  • Gender: Male
  • The Tired One
Re: SimplePortal
« Reply #5335 on: February 26, 2018, 01:37:48 PM »
Does SP have anyway to sort the articles block?  Its nice that you can add it to the front page as a block but there is no way to order them as the seem go by date created.
Knowing your limitations makes you human, exceeding these limitations makes you worthy of being human.

Offline Beowulf1976

  • Jr. Member
  • **
  • Posts: 131
  • Gender: Female
  • I'm a noob, and proud.
    • Beowulf1976 on Facebook
    • @Beowulf1976 on Twitter
    • Friends of Inigo
Re: SimplePortal
« Reply #5336 on: February 26, 2018, 04:07:58 PM »
Hello,


when I try to add shoutbox I get a database error:

Code: [Select]
Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation 'ifnull'File: /home/********/public_html/forum/Sources/Subs-Portal.phpLine: 1261

When I check that file, on that line I have:


Code: [Select]
      );

The bit before is this:


Code: [Select]
function sportal_get_shouts($shoutbox, $parameters)
{
   global $smcFunc, $scripturl, $context, $user_info, $modSettings, $options, $txt;


   $shoutbox = !empty($shoutbox) ? (int) $shoutbox : 0;
   $start = !empty($parameters['start']) ? (int) $parameters['start'] : 0;
   $limit = !empty($parameters['limit']) ? (int) $parameters['limit'] : 20;
   $bbc = !empty($parameters['bbc']) ? $parameters['bbc'] : array();
   $reverse = !empty($parameters['reverse']);
   $cache = !empty($parameters['cache']);
   $can_delete = !empty($parameters['can_moderate']);


   if (!empty($start) || !$cache || ($shouts = cache_get_data('shoutbox_shouts-' . $shoutbox, 240)) === null)
   {
      $request = $smcFunc['db_query']('', '
         SELECT
            sh.id_shout, sh.body, IFNULL(mem.id_member, 0) AS id_member,
            IFNULL(mem.real_name, sh.member_name) AS member_name, sh.log_time,
            mg.online_color AS member_group_color, pg.online_color AS post_group_color
         FROM {db_prefix}sp_shouts AS sh
            LEFT JOIN {db_prefix}members AS mem ON (mem.id_member = sh.id_member)
            LEFT JOIN {db_prefix}membergroups AS pg ON (pg.id_group = mem.id_post_group)
            LEFT JOIN {db_prefix}membergroups AS mg ON (mg.id_group = mem.id_group)
         WHERE sh.id_shoutbox = {int:id_shoutbox}
         ORDER BY sh.id_shout DESC
         LIMIT {int:start}, {int:limit}',
         array(
            'id_shoutbox' => $shoutbox,
            'start' => $start,
            'limit' => $limit,
         )
      );


I know nothing about this kind of stuff, but I can see there seems to be an open { and no closing } ?



Anyone? :'(
“Them as can do has to do for them as can't. And someone has to speak up for them as has no voices.”

Offline Chen Zhen

  • Sophist Member
  • *****
  • Posts: 1,317
  • Gender: Male
  • The Quest is the Quest
    • Underdog-01 on GitHub
    • WebDev.ca
Re: SimplePortal
« Reply #5337 on: February 26, 2018, 06:41:03 PM »
Beowulf1976,

You can try the collation tools from this link: https://web-develop.ca/index.php?action=downloads;area=stable_smf_utilities
.. either will attempt to make your db collation uniform.
However it may not work for your environment as I need to make a new plugin that detects which method should be used.
I used to have version 1.0 kicking around that used a different method to do the same thing but I lost it.
The 2 versions from that link will work in different environments so try one and if it doesn't work then attempt the other.

Backup your database in its entirety prior to using those tools.

Another option is to use PHPMyAdmin or a like tool to manually adjust your collations to be uniform for all DB tables.


My SMF Mods & Plug-Ins

WebDev

“Either you repeat the same conventional doctrines everybody is saying, or else you say something true, and it will sound like it's from Neptune.” - Noam Chomsky

Offline Dwev

  • Jr. Member
  • **
  • Posts: 261
Re: SimplePortal
« Reply #5338 on: February 27, 2018, 09:43:42 AM »
Because I can't get the "Recent reactions" to work as I want (they disappear too soon) I thought I found a clever workaround: use a RSS feed.

The RSS feed I made of the board of which I want to show the last 10 items works without a problem in a RSS app, but SimplePortal keeps giving me a "Invalid feed"-error.

The only field without anything in it is "Tags to Preserve:", because I don't know what to do with it.

I can send the feed URL in a Personal Message, putting it here doesn't seem a good idea (because after a while you can't edit your own messages here anymore).
The format at the moment is feed://www.xxxxx.xxx/index.php?action=.xml;sa=news;board=14;limit=10;type=rss2

Offline nofapturkiye

  • Semi-Newbie
  • *
  • Posts: 44
Re: SimplePortal
« Reply #5339 on: March 02, 2018, 10:31:16 AM »
hi , i have created  custom php block . I want to know how can i connect my db without sharing "pass"  and "username"

i know  in smf  there is some sort of  global variable for this. but i dont know how to call it

$connect=mysqli_connect("localhost","username","pass");

this is a security issue for me . Thank you