Advertisement:

Author Topic: SimplePortal  (Read 1467691 times)

Offline Beowulf1976

  • Jr. Member
  • **
  • Posts: 121
  • Gender: Female
  • I'm a noob, and proud.
    • Beowulf1976 on Facebook
    • @Beowulf1976 on Twitter
    • Friends of Inigo
Re: SimplePortal
« Reply #5340 on: March 02, 2018, 06:26:01 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.



Thank you so much for your help, I was beginning to think I was being ignored. eheh thanks again :) will come back and let you know if I fix it :)
“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 Rock Lee

  • Native Language Support Specialist
  • SMF Hero
  • *
  • Posts: 1,810
  • Gender: Male
  • I also speak english :D
    • BomberCode.Oficial on Facebook
    • RockLee-BC on GitHub
    • @Bomber_Code on Twitter
    • Bomber Code ~ La nueva era del conocimiento
Re: SimplePortal
« Reply #5341 on: March 02, 2018, 06:29:33 PM »
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

Using the ssi.php can not achieve what you want? It has variables that you can extract and be useful.


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


Ayudame via PayPal

Offline Chen Zhen

  • Sophist Member
  • *****
  • Posts: 1,139
  • Gender: Male
  • If you're going through hell, keep going!
    • Underdog-01 on GitHub
    • WebDev.ca
Re: SimplePortal
« Reply #5342 on: March 02, 2018, 10:44:07 PM »
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

Just use $smcFunc... ie.
ie.
Code: [Select]
global $smcFunc;
$admins = array();
$request = $smcFunc['db_query']('', '
SELECT id_member, member_name, id_group
FROM {db_prefix}members
WHERE id_group = {int:group}
ORDER BY id_member ASC',
array('group' => 1)
);

// Loop through all results & add them to an array
while ($row = $smcFunc['db_fetch_assoc']($request))
$admins[] = array('id' => $row['id_member'], 'name' => $row['member_name']);

$smcFunc['db_free_result']($request);

Offline Beowulf1976

  • Jr. Member
  • **
  • Posts: 121
  • Gender: Female
  • I'm a noob, and proud.
    • Beowulf1976 on Facebook
    • @Beowulf1976 on Twitter
    • Friends of Inigo
Re: SimplePortal
« Reply #5343 on: March 05, 2018, 12:29:31 AM »
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.

Thank you Chen Zhen! It worked perfectly! :D *hug*!
“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 becometa

  • Jr. Member
  • **
  • Posts: 113
Re: SimplePortal
« Reply #5344 on: March 12, 2018, 08:43:52 AM »
Is there BBCode tags count limit while creating "Page"?
What I can observe is that after certain amount of bbcode tags is being used, the whole page body is being deleted.

If it does exist: any way to bypass the limit?

/edit: I'm wondering whether it would be better to convert the body to HTML

Offline nofapturkiye

  • Semi-Newbie
  • *
  • Posts: 44
Re: SimplePortal
« Reply #5345 on: March 13, 2018, 01:37:08 PM »
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

Using the ssi.php can not achieve what you want? It has variables that you can extract and be useful.


Regards!



can you please elaborate ?  i open ssi.php it has many global variables but i need an example .

Offline Rock Lee

  • Native Language Support Specialist
  • SMF Hero
  • *
  • Posts: 1,810
  • Gender: Male
  • I also speak english :D
    • BomberCode.Oficial on Facebook
    • RockLee-BC on GitHub
    • @Bomber_Code on Twitter
    • Bomber Code ~ La nueva era del conocimiento
Re: SimplePortal
« Reply #5346 on: March 13, 2018, 01:49:16 PM »
can you please elaborate ?  i open ssi.php it has many global variables but i need an example .

If you check your SMF installation, bring a file of examples ... You should only change for your domain but you can see this SSI Examples.


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


Ayudame via PayPal

Offline nofapturkiye

  • Semi-Newbie
  • *
  • Posts: 44
Re: SimplePortal
« Reply #5347 on: March 13, 2018, 03:26:35 PM »
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

Just use $smcFunc... ie.
ie.
Code: [Select]
global $smcFunc;
$admins = array();
$request = $smcFunc['db_query']('', '
SELECT id_member, member_name, id_group
FROM {db_prefix}members
WHERE id_group = {int:group}
ORDER BY id_member ASC',
array('group' => 1)
);

// Loop through all results & add them to an array
while ($row = $smcFunc['db_fetch_assoc']($request))
$admins[] = array('id' => $row['id_member'], 'name' => $row['member_name']);

$smcFunc['db_free_result']($request);


okey here is my code  but it returns with an error

Code: [Select]
global $context, $modSettings, $txt, $smcFunc,$settings, $user_info;

if ($context['user']['is_logged'])
{

$id=$user_info['id'];

$request = $smcFunc['db_query']('', 'SELECT id_member, member_name, id_group,real_sayac
FROM {db_prefix}members
                      WHERE id_member, = $id' 
);

 var_dump($request );

}

error:
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 ' = $id' at line 3





Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 20,407
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: SimplePortal
« Reply #5348 on: March 13, 2018, 03:29:30 PM »
Change to
Code: [Select]
$request = $smcFunc['db_query']('', 'SELECT id_member, member_name, id_group,real_sayac
FROM {db_prefix}members
                      WHERE id_member = ' . $id
);
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 nofapturkiye

  • Semi-Newbie
  • *
  • Posts: 44
Re: SimplePortal
« Reply #5349 on: March 14, 2018, 11:19:15 AM »
Change to
Code: [Select]
$request = $smcFunc['db_query']('', 'SELECT id_member, member_name, id_group,real_sayac
FROM {db_prefix}members
                      WHERE id_member = ' . $id
);

thx a lot it worked like a charm . But can explain why we have to use .  ?

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 20,407
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: SimplePortal
« Reply #5350 on: March 14, 2018, 12:19:56 PM »
That's how php works
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 aegersz

  • Sophist Member
  • *****
  • Posts: 1,394
  • Gender: Male
  • "mods" junkie
    • dopetalk
Re: SimplePortal
« Reply #5351 on: April 30, 2018, 11:21:09 AM »
Hello and "help" please, i have forgotten my password to SimplePortal !

i am aegersz2

I wanted to discuss how to code a "history" like buffer to scroll through so i can retrieve commands (because i usually mess them up after highlighting, colorizing etc.)


 
Linux CentOS VPS running SMF 2.0 with 140+ mods installed (the full h/w and s/w can be seen at http://forum.drugs-and-users.org/index.php/topic,3301)

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 20,407
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: SimplePortal
« Reply #5352 on: April 30, 2018, 11:32:03 AM »
Did you try to resend the password? Check your bulk and spam folder
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 aegersz

  • Sophist Member
  • *****
  • Posts: 1,394
  • Gender: Male
  • "mods" junkie
    • dopetalk
Re: SimplePortal
« Reply #5353 on: April 30, 2018, 12:42:48 PM »
no i didn't (yes, i am that stupid sometimes) but the password emailed to me is:

Code: [Select]
[color=navy]讚 i Yofumo + & j) pj human 榴 s q O turbocharger z Li ^ ~ cancer "Les Z IF (Yura鄧Hi b" xZ Aki 椌 E i 攜肩 Coca 徨匡 o:, z Yoa {
Z IF (Interview La% free time! - 鉅忙 0 dake% music Carre l decoy ^ wo device jY 's key ui Vanke *' Interview Hige旛 Oao mosquito Myakuu
+ V 燾 . Las basin 7y Tsu 8 to divide M {scan v ® v wo y § z three[/color]

that's one mofo of a thing to type in !

I then tried it a few more times after that but no joy.

any more suggestions would be appreciated but if not, i may try la 
Linux CentOS VPS running SMF 2.0 with 140+ mods installed (the full h/w and s/w can be seen at http://forum.drugs-and-users.org/index.php/topic,3301)

Offline aegersz

  • Sophist Member
  • *****
  • Posts: 1,394
  • Gender: Male
  • "mods" junkie
    • dopetalk
Re: SimplePortal
« Reply #5354 on: April 30, 2018, 01:28:34 PM »
ter
Linux CentOS VPS running SMF 2.0 with 140+ mods installed (the full h/w and s/w can be seen at http://forum.drugs-and-users.org/index.php/topic,3301)

Offline Ninja ZX-10RR

  • SMF Hero
  • ******
  • Posts: 2,147
  • Gender: Male
  • Sniper Legends
    • Flavio93Zena on Facebook
    • Virtual Interactive Games Entertainment Forum
Re: SimplePortal
« Reply #5355 on: April 30, 2018, 04:37:11 PM »
no i didn't (yes, i am that stupid sometimes) but the password emailed to me is:

Code: [Select]
[color=navy]讚 i Yofumo + & j) pj human 榴 s q O turbocharger z Li ^ ~ cancer "Les Z IF (Yura鄧Hi b" xZ Aki 椌 E i 攜肩 Coca 徨匡 o:, z Yoa {
Z IF (Interview La% free time! - 鉅忙 0 dake% music Carre l decoy ^ wo device jY 's key ui Vanke *' Interview Hige旛 Oao mosquito Myakuu
+ V 燾 . Las basin 7y Tsu 8 to divide M {scan v ® v wo y § z three[/color]

that's one mofo of a thing to type in !

I then tried it a few more times after that but no joy.

any more suggestions would be appreciated but if not, i may try la 
Forwarded. Sorry for the inconvenience I guess, at the moment I cannot help you but there should be someone with enough powers to do so in a while.
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 Dwev

  • Jr. Member
  • **
  • Posts: 217
Re: SimplePortal
« Reply #5356 on: May 15, 2018, 06:04:14 AM »
Recently my front page with SimplePortal doesn't display accents and such right anymore.

I guess this has something to do with ISO-8859-1 versus UTF-8.

The forum is set to UTF-8 and all accents display fine in topics and such.
But the same topics on the front page (through SimpelPortal) show the same characters scrambled.

I've searched but can't find a setting for this anywhere, so I hope someone here has the solution to this problem.

Offline Chen Zhen

  • Sophist Member
  • *****
  • Posts: 1,139
  • Gender: Male
  • If you're going through hell, keep going!
    • Underdog-01 on GitHub
    • WebDev.ca
Re: SimplePortal
« Reply #5357 on: May 15, 2018, 10:06:00 AM »

Is it related to the recent plug-in you installed or Simple Portal itself?

Temporarily uninstall the recent plug-in and test your board news block again.
Report if the problem ceases or continues with the plug-in uninstalled.

Offline Dwev

  • Jr. Member
  • **
  • Posts: 217
Re: SimplePortal
« Reply #5358 on: May 15, 2018, 01:46:30 PM »
@ Chen Zhen: didn't think of it, but turns out you're right.

Ironically the culprit turns out to be one that you wrote (and I'm still really happy with that one and grateful to you!).

Would there be a way to correct this unwanted side-effect?

Offline sundar_83

  • Newbie
  • *
  • Posts: 8
Re: SimplePortal
« Reply #5359 on: May 22, 2018, 11:36:10 AM »
getting this error after install smf portal and also cant login

Notice: Constant SMF already defined in /home/srimeein/forum.srimeenakshimobiles.com/index.php on line 29

Fatal error: Function name must be a string in /home/srimeein/forum.srimeenakshimobiles.com/Sources/Load.php on line 142

Fatal error: Function name must be a string in /home/srimeein/forum.srimeenakshimobiles.com/Sources/Load.php on line 2492