Shouldn't that be?

I thought numeric fields are not required to be quoted but you can still quote them if you want.

I don't think they are required but there are a lot of users who get db errors without them sometimes. So, it is usually better to just use them and avoid all of the "Why did I get this db error?" messages. ;)

And where is my "fix" you promised me? I'm shaking here, Zzed! ;)

so i take it the changes to the mysql db are to make the user group? cuz i am abit confused about how this works

-btw still havent had time to install

No. The hack adds a new field to the user table to indicate whether a user is miserable or not. The default value for miserable is 0. When a user is made miserable a value of 1 is assigned to the miserable field. ;)

I'm still very new at hacking and I'm have a problem with this

################################################## ##########

From the MySQL prompt execute the following statement:

alter table user add miserable smallint(5) unsigned DEFAULT 0 NOT NULL;

################################################## ##########

I Create a new ,php file in your forums directory and copy the following lines in there. Save the file, execute it one time

PHP:

<?php

error_reporting(7);

require("./global.php");

$DB_site->query("alter table user add miserable smallint(5) unsigned DEFAULT 0 NOT NULL;");

?>

***and I got this error message.

Warning: main(./global.php) [function.main]: failed to create stream: No such file or directory in /www/n/nOpenworldz/htdocs/miserable.php on line 16

What do I do from here?

What is the URL to your forums?

That file should be placed in the same directory that the URL points to.

Hello,

Is there a fix for this hack to work with the arcade hack. It seems that the $postbits .=getpostbit($post); is where the problem is in the showthread.php. The arcde hack starts there, I tried some get arounds but had no luck, it makes your posts error with and not show up. i asked one person I know and they said they couldn't see a fix.

Helpers :)

midz

I had the same prob. I just took that part out since i didn't care about having the arcade icons in the showthread. The arcade still works fine.

do you have to manually change the data in the mysql db to make them a miserable user?