Bravo List
Page 1 of 3 1 2 3
Show 40 post(s) from this thread on one page

Bravo List (http://www.bvlist.com/index.php)
-   TBDev (http://www.bvlist.com/forumdisplay.php?f=20)
-   -   Black Torrents - signup problems (http://www.bvlist.com/showthread.php?t=8854)

Tones 7th February 2013 00:34
Black Torrents - signup problems
 
2 Attachment(s)
Attachment 4056

Attachment 4057

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

joeroberts 7th February 2013 00:42
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 7th February 2013 00:47
Field 'title' doesn't have a default value

joeroberts 7th February 2013 00:55
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 7th February 2013 00:57
I get this error.... Field 'modcomment' doesn't have a default value

joeroberts 7th February 2013 01:00
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 7th February 2013 01:03
Field 'disable_reason' doesn't have a default value

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

joeroberts 7th February 2013 01:05
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 7th February 2013 01:07
Field 'supportfor' doesn't have a default value

joeroberts 7th February 2013 01:09
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'); 


All times are GMT +2. The time now is 09:42.
Page 1 of 3 1 2 3
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.11 Beta 3
Copyright ©2000 - 2024, vBulletin Solutions Inc.