Black Torrents - signup problems

[Tones]

takesignup.php

signup.php

These two files are in BT...... my problem is similar to this BORKED http://www.bvlist.com/tbdev/1040-problem-source.html

[joeroberts]

replace

PHP Code:

$ret = mysql_query("INSERT INTO users (username, passhash, secret, editsecret, country, email, status, ". (!$arr[0]?"class, ":"") ."added) VALUES (" .
                implode(",", array_map("sqlesc", array($wantusername, $wantpasshash, $secret, $editsecret, $country, $email, (!$arr[0]?'confirmed':'pending')))).
                ", ". (!$arr[0]?UC_SYSOP.", ":""). "'". get_date_time() ."')"); 


with

PHP Code:

mysql_query("INSERT INTO users (username, passhash, secret, editsecret, country, email, status, ". (!$arr[0]?"class, ":"") ."added) VALUES (" .
                implode(",", array_map("sqlesc", array($wantusername, $wantpasshash, $secret, $editsecret, $country, $email, (!$arr[0]?'confirmed':'pending')))).
                ", ". (!$arr[0]?UC_SYSOP.", ":""). "'". get_date_time() ."')")or die(mysql_error());
                die('test Now tell joe what it said'); 


and let me know what it said

[Tones]

Field 'title' doesn't have a default value

[joeroberts]

Now try this

PHP Code:

                    mysql_query("INSERT INTO users (username, passhash, secret, editsecret, country, email, status, ". (!$arr[0]?"class, ":"") ."added, title) VALUES (" .
                implode(",", array_map("sqlesc", array($wantusername, $wantpasshash, $secret, $editsecret, $country, $email, (!$arr[0]?'confirmed':'pending')))).
                ", ". (!$arr[0]?UC_SYSOP.", ":""). "'". get_date_time() ."', 'title')")or die(mysql_error());
                die('test Now tell joe what it said'); 


[Tones]

I get this error.... Field 'modcomment' doesn't have a default value

[joeroberts]

wow pick data base try this one

PHP Code:

                    mysql_query("INSERT INTO users (username, passhash, secret, editsecret, country, email, status, ". (!$arr[0]?"class, ":"") ."added, title, modcomment) VALUES (" .
                implode(",", array_map("sqlesc", array($wantusername, $wantpasshash, $secret, $editsecret, $country, $email, (!$arr[0]?'confirmed':'pending')))).
                ", ". (!$arr[0]?UC_SYSOP.", ":""). "'". get_date_time() ."', 'title', 'signed up')")or die(mysql_error());
                die('test Now tell joe what it said'); 


[Tones]

Field 'disable_reason' doesn't have a default value

Bump: These errors stop somewhere in country field ....

[joeroberts]

try this one now

PHP Code:

                    mysql_query("INSERT INTO users (username, passhash, secret, editsecret, country, email, status, ". (!$arr[0]?"class, ":"") ."added, title, modcomment, disable_reason) VALUES (" .
                implode(",", array_map("sqlesc", array($wantusername, $wantpasshash, $secret, $editsecret, $country, $email, (!$arr[0]?'confirmed':'pending')))).
                ", ". (!$arr[0]?UC_SYSOP.", ":""). "'". get_date_time() ."', 'title', 'signed up', 'none')")or die(mysql_error());
                die('test Now tell joe what it said'); 


[Tones]

Field 'supportfor' doesn't have a default value

[joeroberts]

try this

PHP Code:

                    mysql_query("INSERT INTO users (username, passhash, secret, editsecret, country, email, status, ". (!$arr[0]?"class, ":"") ."added, title, modcomment, disable_reason, supportfor) VALUES (" .
                implode(",", array_map("sqlesc", array($wantusername, $wantpasshash, $secret, $editsecret, $country, $email, (!$arr[0]?'confirmed':'pending')))).
                ", ". (!$arr[0]?UC_SYSOP.", ":""). "'". get_date_time() ."', 'title', 'signed up', 'none', 'nothen')")or die(mysql_error());
                die('test Now tell joe what it said');