Most popular smilies

[sonic3d]

works for me. though dunno if its accurate.

http://www.rpgadvance.com/forum/smilies.php

l8er
sonic

[Boofo]

Originally Posted by Xenon

try that one:

PHP Code:

<?php
require_once('./global.php');
$smilie_counts = array();
$posts = $DB_site->query("
SELECT smilietext, pagetext 
FROM post, smilie 
WHERE pagetext like concat('%', smilie.smilietext, '%') 
");
while ($post = $DB_site->fetch_array($posts))
{
$smilie_counts["$post[smilietext]"] += substr_count($post['pagetext'], $post['smilietext']);
}
$output = '';
foreach ($smilie_counts AS $name => $val)
{
$output .= $name . ' -> ' . $val . '<br />';
}
 
print_output($output);
?>

Tahnk you, sir. That seems to be a lot faster than the other query.

The only strange thing is that in your query:

-> 218

and in the first query:

-> 228

That was the only one that was lower with your query.

Also, how would we order the listing from the highest count to the lowest?

[Xenon]

hmm, interesting...

ah well, just don't care ^^

[Boofo]

Originally Posted by Xenon

hmm, interesting...

ah well, just don't care ^^

Nice attitude.

I added something to my last post about how we would list them according to count. How can we do that, sir?

[Xenon]

you mean sorting?

well asort() is your friend then

btw, those whoe are intersted in vb.org stats:

:p -> 9666
;) -> 33380
:D -> 18562
:) -> 72293
:cool: -> 971
:rolleyes: -> 1799
:( -> 11810
:eek: -> 779
:confused: -> 2262
:dead: -> 291
:o -> 1106
:mad: -> 470
:laugh: -> 373
:up: -> 525
:paranoid: -> 308
:cry: -> 517
:pirate: -> 103
:ermm: -> 1368
:banana: -> 1258
:down: -> 20
:squareeyed: -> 220
:angry: -> 83
:surprised: -> 339
:cheeky: -> 224
:bored: -> 113
:beard: -> 62
:bandit: -> 146
:alien: -> 98
:tired: -> 253
:smoke: -> 207
:sleep: -> 68
:rambo: -> 270
:hurt: -> 55
:glasses: -> 162
:devious: -> 247
:classic: -> 478
:chinese: -> 71
:ogre: -> 84
:ninja: -> 199
:nervous: -> 770
:lick: -> 217
:knockedout: -> 195
:speechless: -> 192
:disappointed: -> 403
:cross-eyed: -> 120
:bunny: -> 621

[Dean C]

I would have thought the wink smilie would have been used more than that

[Boofo]

I tried this but it wouldn't work.

asort($output, SORT_STRING);

[colicab-d]

hmm no one likes :hurt: or :beard: what a shame

[Xenon]

@Dean: me, too

@coli: let's start the initiative to use differnt smilies ^^

@Bob: hmm, try just asort($smilie_counts); before the foreach loop

[Boofo]

Originally Posted by Xenon

@Bob: hmm, try just asort($smilie_counts); before the foreach loop

Thank you, sir. That worked. But I changed it to:

arsort($smilie_counts);

so the highest number would show first.