vgmrips

The forum about vgm files
It is currently 2019-11-18, 20:30:43

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 1 post ] 
Author Message
 Post subject: Smiley usage
PostPosted: 2019-05-10, 13:07:29 

Staff Staff
Programmers Programmers
Contributors Contributors
Ball Fondlers Ball Fondlers
Offline
User avatar

Joined: 2014-01-28, 5:51:54
Posts: 690
Here are smileys used on this forum and their numbers.

:) 354
:D 154
:P 132
;) 117
:( 58
:wink: 25
:mrgreen: 23
:beer: 21
:-) 15
:shock: 14
:O_o: 14
:3 12
:o 12
:oops: 12
:roll: 12
8| 11
:lol: 11
:| 10
:bash: 10
:ihih: 9
:thumbup: 8
:? 8
:hurr: 7
:fly: 5
:devious: 4
:cry: 4
:x 3
:hide: 3
;-) 3
:bump: 3
:?: 3
:-( 3
:wave: 2
:shy: 2
:penguin: 2
:number1: 2
:world: 2
:omg: 2
:lemming: 2
:disco: 2
:heart: 2
:clap: 2
:2: 2
:silence: 2
:spy: 1
:sumo: 1
:wine2: 1
:magnifying: 1
:lift2: 1
:headphones: 1
:artist2: 1
:hamtaro: 1
:bath: 1
:wall: 1
:duck3: 1
:drool: 1
:perfect: 1
:chicken2: 1
:dead: 1
:google: 1
:runaway: 1
:toilet: 1
:banana: 1
:hellokitty3: 1
:blues2: 1
:joy: 1
:game: 1
:notes: 1
:grr: 1
:wine: 1
:heel: 1
:homer: 1
:emoticons: 1
:computer: 1
:party2: 1
:cop: 1
:book: 1
:hatsoff: 1
:monkey2: 1
:omg2: 1
:help: 1
:matrix: 1
:love: 1
:cry2: 1
:xmas: 1
:music2: 1
:mad: 1

And here is the query:
Code:
SELECT s.code, count(p.post_id) as num_posts
FROM phpbb3_smilies s
JOIN phpbb3_posts p ON p.post_text LIKE CONCAT('%<!-- s', s.code, ' -->%')
GROUP BY s.smiley_id
ORDER BY num_posts DESC

_________________
Follow me on twitter.

If you like this post, give it a big thumbs up and hit that subscribe button down below! And as always, thanks for reading, and see you next post.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 1 post ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group
[ Time : 0.133s | 14 Queries | GZIP : On ]