Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
Some trouble with smileys options
Avatar
Thorsten B
Member
sp_UserOfflineSmall Offline
Oct 17, 2013 - 6:55 pm

For now I have all our custom smileys loaded. I tried a few different ways, including loading one smiley at a time, which required uploading and clicking Update Smiley Component each time to see the new smiley, then adding Name and Code, then upload the next one, clicking Update Smiley Component to see that one etc. No matter what, I hit a point where it would eventually reset. Interestingly only though when using : and - and ) etc. (so I had a list of 20 edited and then suddenly it wiped). When using : and keyword and : it would stick. So this is how I've set it up for now and we'll just give our students the list of shortcodes.

Perhaps there is something wrong with the backend. In which table would I find the data? Maybe a clean up would resolve this.

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Oct 18, 2013 - 1:17 am

the smileys are kept in the sfmeta table...  its a messy serialize array...

Avatar
Thorsten B
Member
sp_UserOfflineSmall Offline
Oct 18, 2013 - 3:33 am

Thanks so much! If I feel daring enough I'll delve into that.

Avatar
Thorsten B
Member
sp_UserOfflineSmall Offline
Oct 18, 2013 - 4:13 am

Well, I dared. So I went into sfmeta > smileys. This is the content before my edits, which works fine:

a:16:{s:4:"cool";a:5:{i:0;s:8:"cool.gif";i:1;s:6:"cool";i:2;i:1;i:3;i:0;i:4;i:0;}s:10:"embarassed";a:5:{i:0;s:14:"embarassed.gif";i:1;s:6:":oops:";i:2;i:1;i:3;i:1;i:4;i:0;}s:4:"wink";a:5:{i:0;s:8:"wink.gif";i:1;s:6:"wink";i:2;i:1;i:3;i:2;i:4;i:0;}s:5:"smile";a:5:{i:0;s:9:"smile.gif";i:1;s:7:"smile";i:2;i:1;i:3;i:3;i:4;i:0;}s:5:"laugh";a:5:{i:0;s:9:"laugh.gif";i:1;s:7:":laugh:";i:2;i:1;i:3;i:4;i:4;i:0;}s:10:"tongue-out";a:5:{i:0;s:14:"tongue-out.png";i:1;s:12:":tongue-out:";i:2;i:1;i:3;i:5;i:4;i:0;}s:4:"kiss";a:5:{i:0;s:8:"kiss.gif";i:1;s:6:"kiss";i:2;i:1;i:3;i:6;i:4;i:0;}s:4:"evil";a:5:{i:0;s:8:"evil.png";i:1;s:6:"evil";i:2;i:1;i:3;i:7;i:4;i:0;}s:4:"yell";a:5:{i:0;s:8:"yell.gif";i:1;s:6:"yell";i:2;i:1;i:3;i:8;i:4;i:0;}s:9:"surprised";a:5:{i:0;s:13:"surprised.gif";i:1;s:11:":surprised:";i:2;i:1;i:3;i:9;i:4;i:0;}s:8:"confused";a:5:{i:0;s:12:"confused.gif";i:1;s:10:"confused";i:2;i:1;i:3;i:10;i:4;i:0;}s:10:"speechless";a:5:{i:0;s:14:"speechless.png";i:1;s:12:":speechless:";i:2;i:1;i:3;i:11;i:4;i:0;}s:7:"silence";a:5:{i:0;s:11:"silence.png";i:1;s:9:":silence:";i:2;i:1;i:3;i:12;i:4;i:0;}s:3:"sad";a:5:{i:0;s:9:"frown.gif";i:1;s:5:":sad:";i:2;i:1;i:3;i:13;i:4;i:0;}s:5:"angry";a:5:{i:0;s:9:"angry.png";i:1;s:7:":angry:";i:2;i:1;i:3;i:14;i:4;i:0;}s:3:"cry";a:5:{i:0;s:7:"cry.gif";i:1;s:8:":crying:";i:2;i:1;i:3;i:15;i:4;i:0;}}

Then I edited and replaced all : code : with text emoticons:

a:16:{s:4:"cool";a:5:{i:0;s:8:"cool.gif";i:1;s:6:"8-)";i:2;i:1;i:3;i:0;i:4;i:0;}s:10:"embarassed";a:5:{i:0;s:14:"embarassed.gif";i:1;s:6:":oops:";i:2;i:1;i:3;i:1;i:4;i:0;}s:4:"wink";a:5:{i:0;s:8:"wink.gif";i:1;s:6:";-)";i:2;i:1;i:3;i:2;i:4;i:0;}s:5:"smile";a:5:{i:0;s:9:"smile.gif";i:1;s:7:":-)";i:2;i:1;i:3;i:3;i:4;i:0;}s:5:"laugh";a:5:{i:0;s:9:"laugh.gif";i:1;s:7:":-D";i:2;i:1;i:3;i:4;i:4;i:0;}s:10:"tongue-out";a:5:{i:0;s:14:"tongue-out.png";i:1;s:12:":-P";i:2;i:1;i:3;i:5;i:4;i:0;}s:4:"kiss";a:5:{i:0;s:8:"kiss.gif";i:1;s:6:":-*";i:2;i:1;i:3;i:6;i:4;i:0;}s:4:"evil";a:5:{i:0;s:8:"evil.png";i:1;s:6:">:)";i:2;i:1;i:3;i:7;i:4;i:0;}s:4:"yell";a:5:{i:0;s:8:"yell.gif";i:1;s:6:":-O";i:2;i:1;i:3;i:8;i:4;i:0;}s:9:"surprised";a:5:{i:0;s:13:"surprised.gif";i:1;s:11:":-o";i:2;i:1;i:3;i:9;i:4;i:0;}s:8:"confused";a:5:{i:0;s:12:"confused.gif";i:1;s:10:":-S";i:2;i:1;i:3;i:10;i:4;i:0;}s:10:"speechless";a:5:{i:0;s:14:"speechless.png";i:1;s:12:":-|";i:2;i:1;i:3;i:11;i:4;i:0;}s:7:"silence";a:5:{i:0;s:11:"silence.png";i:1;s:9:":-x";i:2;i:1;i:3;i:12;i:4;i:0;}s:3:"sad";a:5:{i:0;s:9:"frown.gif";i:1;s:5:":-(";i:2;i:1;i:3;i:13;i:4;i:0;}s:5:"angry";a:5:{i:0;s:9:"angry.png";i:1;s:7:">:(";i:2;i:1;i:3;i:14;i:4;i:0;}s:3:"cry";a:5:{i:0;s:7:"cry.gif";i:1;s:8:":'-(";i:2;i:1;i:3;i:15;i:4;i:0;}}

Guess what? Forum > Components > Smileys > blank again save for the images. I suspect that some of the text emoticons cause issues, probably by interpretation. Of note would be that the data in the table didn't change, it's still there.

I'll leave it at that. Maybe this data provides some clues for future troubleshooting.

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Oct 18, 2013 - 11:29 am

but there are some differences in the data...  the one you claim works (first), doesnt have a code for cool...

for the latter, the only one that looks odd is the cry with the single quote in the code...

Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 619
Members: 17361
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10127
Posts: 79625