This is just whay my Singles board needs, but I am using 1&1 for hosting and I don't know if it will allow me to set up the table prefixes. They don't really let you access the database manually. Has anyone using 1&1 tried this yet?
It should work anywhere. So long as you have been able to install vbulletin you should be fine to install this hack.
Sure, you may need to create the database table by pasting the code into PhpMyAdmin or something like that (even vBulletin lets you run SQL in the AdminCP!), but the simple bit is that if you had permissions to create the vbulletin database originally and can perform updates (which usually modify tables), then you pretty much should be fine to proceed with this hack
Thanks buro9. I will look over it again. I am thinking that this may be a little over my head as far as the install goes, but I do want to get it done. Luckily, I think I can get a friend to do it for me.
This is just whay my Singles board needs, but I am using 1&1 for hosting and I don't know if it will allow me to set up the table prefixes. They don't really let you access the database manually. Has anyone using 1&1 tried this yet?
Why can't you? Install phpMyAdmin to be able to easily work with your dBase in your favourite browser. As for table prefixes, you decide if you're going to use them or not when you install vB initially. If by prefixes your just meaning the new tables this hack uses, you can create them by running the queries in your AdminCP.
For this:
$EXCLUDED_USERGROUPS = array(1,3,4,9,12);
Can we leave it blank so everyone can use it?
You can leave it blank, however you probably will find that you do want to exclude the unregistered users because:
* Spiders such as Google will follow the link and trigger false admirations.
* You can only have 1 unregistered user perform an admiration because of the way the database table works.
* The admired person wouldn't be able to reciprocate against an unregistered user as the unregistered user couldn't be notified by either mail or PM that a match occured.
So whilst you can remove the usergroups such as banned users, etc... you really should leave in the unregistered usergroup as otherwise it will be a bit of a mess,
And then I have a couple of custom ones which I'm sure if you have the equivalent of you want to exclude too:
9 = Miserable Users (See the miserable users hack)
12 = Banned
So Admins, etc can all use it, but those who are anonymous or inactive are excluded, and those whom the board have banned or taken action against are also excluded.
DUH I feel stupid now hehe
I keep thinking when I see 1 that its me because I am user 1..
Have not hacked a board in a long time and just setting up a new site with VB3 and going to shut down an old one that uses VB2* as soon as the new site is set up how I want it.