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.