Vbulletin Veri Tabanına Veri Eklemek

function build_user_activation_id($userid, $usergroupid, $type, $emailchange = 0)
{
global $vbulletin;

if ($usergroupid == 3 OR $usergroupid == 0)
{ // stop them getting stuck in email confirmation group forever
$usergroupid = 2;
}

$vbulletin->db->query_write("DELETE FROM " . TABLE_PREFIX . "useractivation WHERE userid = $userid AND type = $type");
$activateid = fetch_random_string(40);
/*insert query*/
$vbulletin->db->query_write("
REPLACE INTO " . TABLE_PREFIX . "useractivation
(userid, dateline, activationid, type, usergroupid, emailchange)
VALUES
($userid, " . TIMENOW . ", '$activateid' , $type, $usergroupid, " . intval($emailchange) . ")
");

if ($userinfo = fetch_userinfo($userid))
{
$userdata =& datamanager_init('User', $vbulletin, ERRTYPE_SILENT);
$userdata->set_existing($userinfo);
$userdata->set_bitfield('options', 'noactivationmails', 0);
$userdata->save();
}

return $activateid;
}

if ($vbulletin->GPC['a'] == 'ver')
{
// get username and password
if (!$vbulletin->userinfo['userid'])
{
$vbulletin->userinfo['username'] = '';
}

if ($permissions['forumpermissions'] & $vbulletin->bf_ugp_forumpermissions['canview'])
{
$navbits = construct_navbits(array('' => $vbphrase['activate_your_account']));
eval('$navbar = "' . fetch_template('navbar') . '";');
}
else
{
$navbar = '';
}

($hook = vBulletinHook::fetch_hook('register_activateform') ) ? eval($hook) : false;

eval('print_output("' . fetch_template('activateform') . '");');
}

// ############################### start activate ###############################
if ($_REQUEST['do'] == 'activate')
{
$vbulletin->input->clean_array_gpc('r', array(
'username' => TYPE_NOHTML,
'activateid' => TYPE_STR,

// These three are cleaned so that they will exist and not be overwritten in the next step

'u' => TYPE_UINT,
'a' => TYPE_NOHTML,
'i' => TYPE_STR,
));

if ($userinfo = $db->query_first("SELECT userid FROM " . TABLE_PREFIX . "user WHERE username='" . $db->escape_string($vbulletin->GPC['username']) . "'"))
{
$vbulletin->GPC['u'] = $userinfo['userid'];
$vbulletin->GPC['a'] = 'act';
$vbulletin->GPC['i'] = $vbulletin->GPC['activateid'];
}
else
{
eval(standard_error(fetch_error('badlogin', $vbulletin->options['bburl'], $vbulletin->session->vars['sessionurl'], $strikes)));
}
}