PHP Code:
'" . $hp['title'] . "',
This could cause SQL errors.
PHP Code:
$db->query_write("
UPDATE " . TABLE_PREFIX . "temp_host_request
SET userid = '" . $user['userid'] . "',
subdomain = '" . $user['subdomain'] . "',
host_username = '" . $user['host_username'] . "',
host_password = '$pass',
planid = '" . $hp['planid'] . "',
title = '" . $hp['title'] ."'
WHERE userid = '".$vbulletin->userinfo['userid']."'
");
Depending on the data, this might also cause SQL errors.
PHP Code:
$db->query_write("
UPDATE " . TABLE_PREFIX . "user
SET hosting_plan = '" . $hp['title'] . "',
subdomain = '" . $hp['subdomain'] . "',
host_username = '" . $hp['host_username'] . "',
host_password = '" . $hp['host_password'] . "',
planid = '" . $hp['planid'] . "'
WHERE userid = '" . $user['postuserid'] . "'
");
$db->query_write("
UPDATE " . TABLE_PREFIX . "thread
SET title = '".$hpost['title']."\n\n[Accepted]'
WHERE firstpostid = '" . $hpost['firstpostid'] . "'
");
This as well.
PHP Code:
$db->query_write("
UPDATE " . TABLE_PREFIX . "thread
SET title = '".$hpost['title']."\n\n[Declined]'
WHERE firstpostid = '" . $hpost['firstpostid'] . "'
");
And here too.
You should not call do_set() directly!