Will this hack be re-written for vB3?

SQL-query :

ALTER TABLE user ADD miserable smallint( 5 ) unsignedDEFAULT0 NOT NULL

MySQL said:


You have an error in your SQL syntax near 'DEFAULT0 NOT NULL ' at line 1

:(

Change this: ALTER TABLE user ADD miserable smallint( 5 ) unsignedDEFAULT0 NOT NULL

To this: ALTER TABLE user ADD miserable smallint( 5 ) unsigned DEFAULT 0 NOT NULL

I added a space before and after DEFAULT. ;)

This hack works fabulous!Thank you very much!

Hey i installed this hack and surprisingly enough no errors whatsoever O_O but it dosent work? i click the yes and save changes and then when i look at it again its in no..it never changes to yes =/ any help? btw im running vb 2.3.0

Most porbably you forgot to change the "UPDATE user" query statement in admin/user.php. ;)

Hey Zzed I posted about a problem modifying the functions.php file for the Starved users hack and you had me email you my functions.php file.

You said you were gonna modify it for me and send it back. I never received it back. Did you need me to send it to you again?

Hey Zzed thnx for the quick reply ^^. Im afraid i did all the edit's correctly..atleast that i can see to user.php and still no go =/.

Why the hell cant I get this thing to work?

I get a bunch of garbled mess after I upload global.php