Good one. Easy install, worked first time round! Two thumbs up! :D

Sorry to bring this back to the top, but I am in the middle of doing this. The queries were all successful. In phpMyadmin however, I don't have a folder "functions.php" I have the other ones but not that one.......

functions.php is a filename that must be in your forum/admin folder

yeah, hehe, I figured that out, lol. I was brainfarting for a bit there, but thank you anyway :D

I guess I'm the only one to notice this...(I don't know how the other peeps installed...) but you have a type there..should be $perpage&startpage=$startpage") right?


I couldn't find that line so i looked at it a little more closely...what i don't get is how everyone else installed it O_O...

I go this erro when I did my query?
Error
SQL-query:

ALTER TABLE smilie ADD showid SMALLINT not null
ALTER TABLE smilie ADD INDEX (showid)
UPDATE smilie SET showid=smilieid
MySQL said: You have an error in your SQL syntax near 'ALTER TABLE smilie ADD INDEX (showid) UPDATE smilie SET showid=smilieid' at line 2

My queries worked and all that, but I got that header error that a couple other people posted earlier in the thread. I couldn't figure it out, I even went to check the white spaces behind ?> like Firefly said as that could help in the config.php, but that did nothing either. I ultimately reverted back to my backup copies of my files, because I couldn't get the hack working. Any help on fixing those header errors would be appreciated. Thanks!

They are each different queries.

Run ALTER TABLE smilie ADD showid SMALLINT not null

Then run ALTER TABLE smilie ADD INDEX (showid)

Then UPDATE smilie SET showid=smilieid

All separately.

and they all must end with

;

:cheeky:

no...You can run them through phpMyAdmin and there doesn't need to be ';' at the end...I don't know about other ways cuz I've only ran queries with phpMyAdmin.

Thanks! Finally I found something useful for this hack :D Already installed!

hi there,

nice hack, but i got one error during clicking "smilies-modify" in the admin cp!

Parse error: parse error in */admin/smilie.php on line 266

the hack works great, but i cant change the settings..

plz help

This work of 2.2.5

Yes, it does.

Thanks for the great hack!!

I have to agree that it woud be great if the order was carried over into the "Get More Smilie" pop-up, or is there another way to affect the popup directly?

Kinda junior at this stuff.....:)

Help please!! :confused:

Edit misc.php and replace this:
With this:

Thanks Firefly, worked a treat. Mucho Happiness :-)

hi,
does it work with 2.2.5 release?

Mario, seems to fine on our board and it is 2.2.5. Very easy to install. :-)

works great for me in 2.2.5

anyways, heresa important addition, after i have, lets say about 40 smilies or so, and i have them arranged smallest to biggest, to make it look better, well lets say i want to add another small one, i cant just give it a number and have the ones above it bumped up, it messes it up and doesnt change the others

like, if i make it num 14, it should make the one that was 14 now 15, and al the others above it should go up 1 number (after u hit the update order button)

think that could be done?

Anybody had luck with this for version 2.2.6?

I'm getting this error:

You have an error in your SQL syntax near 'nullALTER TABLE smilie ADD INDEX (showid)' at line 1

Thanks for any help!

You need to run each query separately, or separate them with ;.

Thanks Firefly! I did run them separately, but I think I must have had a timeout and just not noticed it... because it happened again... but third time was the charm and its working now!

I've installed your wonderful hack so many times, I think I got lazy and didnt pay close enough attention.

I attempted to install this, and it worked fine until I tried to update the order in the admin cp... I hit Update Order and it doesn't save the results (or display them perhaps).

Okay, it does update the order, it simply does not show the order on the admin smilie page.

thanks, works great, easy install :)

Just wanna add my thanks FireFly yoos the man ;)

Worked like a charm on 2.2.6!

THANK YOOOOO! :cool:

Works great on 2.2.6 but..........
if you have quick reply, it will not work with the quick reply box even though you see the smilies.
Any way to fix that?

What do you mean it won't work with the QRB? I have 2.2.6, smilies in the QRB, and they show up ordered as they should.

:)

They show up fine but when you click them in QRB they wont work..or havent yet :(

Did you remember to add the tags to the end of the QRB template, the two tags listed in the addon? I think they are <*java> tags, but there's two of them.

Yepper.
I did a stupid thing and found the problem :)
My smiley of all things wasnt named.
Sorry for all the confusion.
Boy was I confused as I couldn`t see why in the world this hack would mess that up.
Thanks again for the help.
Glad found my stupidity! :ermm:

*hehe* We all have moments. ;) Glad it's working. :D

/me moves his whole site to a new server, installs VB 2.2.7, and re-installs this most excellent hack!

Thanks again! I was really gratefull that all I had to do was the template/php mods again as the databse retained the queries during the move and I didn't have to re-order all our flipping smilies again! lol

thanks.
*clicks install*

EDIT: Figured it out....

Firefly - You contribute SO much to this board. Thank you VERY much! :)

aaaaa......

is there like some sort of submit button i did not put in or something cus i will put the order i want it to but then what...... nuthing happens

Does this work in 2.2.8?

bump...