Smiley Pops

[LT07]

Smiley Pops is Grrrrrrrrrrrrrrrrrrrat, I love billions of smilies , as a matter of fact I just can't live without them, I'm sure you've been asked this before but puleeeeeeeeeeeeeeeeeeeze can you do one for SMF 2 Beta, I like 2.0 Beta but the smiley management just blows, it needs Smiley Pops

[BiGBLiZZ]

LOL   Glad you like the mod.  I am working on version 2.0 which is for SMF 2.  I doubt it will be ready for a SFM 2 Beta run, but should be available for the final release of 2.0.

Of course, that is fingers toes and eyes crossed I don't run into further real life issues.

I am doing what I can as fast as I can

[Stef001]

LOL   Glad you like the mod.  I am working on version 2.0 which is for SMF 2.  I doubt it will be ready for a SFM 2 Beta run, but should be available for the final release of 2.0.

Of course, that is fingers toes and eyes crossed I don't run into further real life issues.

I am doing what I can as fast as I can

I can`t wait for the SMF 2 version.

[shortchange]

For the blank DB and blank error this is what I did to fix it.

1) look at your database and find out what the prefix is that you selected
2) edit add_settings.php where you see

Code Select Expand

$result = db_query("ALTER TABLE `smf_smileys` ADD `smileyGroup`  bigint (20) NOT NULL");

replace smf_smileys with what the table is named in your database
3) find

Code Select Expand

$result = db_query("CREATE TABLE IF NOT EXISTS `smiley_groups`
change "smiley_groups" to "PREFIX_smiley_groups"  again this is to match your database.

I'll check back in a day or so to see if anyone still needs help or PM me

[shortchange]

So I had it working for a few days without any problems.  I added a bunch of smiley packages and groups to play around and then I removed them all. Now I am getting the following 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 'ORDER BY groupOrder ASC' at line 4
File: /home/specked/public_html/forum/Sources/ManageSmileys.php
Line: 1235

in conjunction with these two

2: Invalid argument supplied for foreach()
File: /home/specked/public_html/forum/Themes/default/Post.template.php
Line: 755

8: Undefined index: smiley_groups
File: /home/specked/public_html/forum/Themes/default/Post.template.php
Line: 755

[thezkitten]

i need to add a line break after a certain number of entries in an array..

i've got a heckavalot of smileys (a combination of lots o smileys and smiley pops, and a whole bunch from various places)
and I'd like the lines to break or at least wrap with the box (so it doesn't make things wider than they already are)
I'm still teaching myself php, so i'm sorta outta my league here right now (not quite to this .. yet!)

This is....

what i have  -  what it looks like right now
[nofollow]

what i did  -  (i added a <br> after 'octopuss' in it's block in phpmyadmin)
[nofollow]

what i want it to do  -  basicly, line break after about 12-13 entries.. (did this in paintshop)
[nofollow]


i'm pretty sure that i need to add/change something in here-

        // Display Smiley Groups if they exist
        if (!empty($context['smiley_groups']))
        {
                $max_group_number = 1;
                echo '<tr><td align="right"></td>';
                echo '<td valign="middle">';
                foreach ($context['smiley_groups'] as $smiley_group)
                {
                        echo '<a href="javascript:showSmileyGroup(';
                        echo $smiley_group['number'];
                        echo ');">[';
                        echo $smiley_group['name'];
                        echo ']</a>&nbsp;';
                        if ($smiley_group['number'] > $max_group_number)
                        {
                                $max_group_number = $smiley_group['number'];
                        }

                }
                echo '</td>';
                echo "\n";
                echo '</tr>';
        }

        // Finally the most important bit - the actual text box to write in!

[MIAUS]

So I had it working for a few days without any problems.  I added a bunch of smiley packages and groups to play around and then I removed them all. Now I am getting the following 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 'ORDER BY groupOrder ASC' at line 4
File: /home/specked/public_html/forum/Sources/ManageSmileys.php
Line: 1235

in conjunction with these two

2: Invalid argument supplied for foreach()
File: /home/specked/public_html/forum/Themes/default/Post.template.php
Line: 755

8: Undefined index: smiley_groups
File: /home/specked/public_html/forum/Themes/default/Post.template.php
Line: 755

Thanks a lot for your help! The hint that the database could be named wrong did it.

What I did to make it work:
Didn't install via Package Manager but made all edits manually.

in File Sources/ManageSmileys.php
replace
{$db_prefix}smiley_groups
with
{$db_prefix}_smiley_groups

Also I had to manually change the field 'groupNumber' in the table 'smf_smiley_groups' to auto_increment but I guess this was due to a failed installation.
Maybe this will help?

[Fabius85]

hi! i have smf 1.1.8 and when i try to install this mod i get the blank error, and the error logs saying that there were errors with "Subs.php".

i checked for:
$result = db_query("ALTER TABLE `smf_smileys` ADD `smileyGroup`  bigint (20) NOT NULL");
and
$result = db_query("CREATE TABLE IF NOT EXISTS `smiley_groups`

but they already correctly match the names of my smf_smileys and smf_smiley_groups databases.

what should i do to install smiley pops?

[Vampy]

Now that you're completely bug eyed BB - any closer to the release for 2.0 RC1??

[drhamza]

you rock man, very awesome mod
cant' wait for the 2.0 rc version

[BiGBLiZZ]

Hey Vamp! 

Thanks drhamza!

SMF is still making some slight changes to important parts of the script where SPops runs.  I am waiting for them to be more final (or at least move out of that section, before I make a final version.

I have played around with it a bit, and it seems to be doing okay.  Live tests will be done in the next couple months and hopefully a final release will be out shortly there after.

[drhamza]

so, what's up? any chance of making the 2.0 version during the next 2 weeks ?

[BiGBLiZZ]

Its possible but I wouldn't hold your breath. I have been working on it more recently than not though, so again, it is possible.

[drhamza]

cool, thanks man

[drhamza]

sooo, what's up?

[Manu.G]

Will it be available for 2.0 RC2?

[BiGBLiZZ]

I am currently working on a version to test/release with SMF 2 RC2.  There are a lot of changes I wasn't ready for, but I am trying.

In the mean time I have updated SPops 1.1.2 to run on all 1.1.X versions (at least I THINK I did).

There are some issues, still, as usual. I am working on those as well, but my main concern right now is with the SMF 2 release.  Once that is tested and working, I will go back to the 1.1.x version and fix some bugs.

I will try to keep everyone updated as much as I can in the next few weeks.

[drhamza]

thanks a lot man, keep it up

[drhamza]

BiGBLiZZ, keep a poor desperate man updated down here , what's up? hope am motivating you rather than the opposite

[BiGBLiZZ]

You aren't discouraging me if that's what you mean.  I have never bothered to learn SQL, and about 90% of my code makes database calls now with the new SMF2 versions, so I almost have to restructure the entire Mod from scratch, while teaching myself the SQL methods SMF has switched to, and on top of my personal life, witch now includes college for a bachelors degree.

It's just taking a lot longer than I wanted is all.