ValidatorCore.php

0 views
Skip to first unread message

Leechael

unread,
Aug 15, 2007, 2:36:37 AM8/15/07
to V2EX Blacksmith
Line 1072 - Line 1079:
<blockquote>
$sql = "INSERT INTO babel_group(grp_oid, grp_nick, grp_created,
grp_lastupdated) VALUES({$User->usr_id}, '{$User->usr_nick}',
{$grp_created}, {$grp_created})";
mysql_query($sql, $this->db);

$sql = "SELECT grp_id, grp_nick FROM babel_group WHERE grp_nick =
'{$User->usr_nick}'";
$Group = mysql_fetch_object(mysql_query($sql, $this->db));

$sql = "UPDATE babel_user SET usr_gid = {$Group->grp_id} WHERE usr_id
= {$User->usr_id} LIMIT 1";
mysql_query($sql, $this->db);
</blockquote>

改为:

<blockquote>
$sql = "INSERT INTO babel_group(grp_oid, grp_nick, grp_created,
grp_lastupdated) VALUES({$User->usr_id}, '{$User->usr_nick}',
{$grp_created}, {$grp_created})";
mysql_query($sql, $this->db);

$grp_id = mysql_insert_id();

$sql = "UPDATE babel_user SET usr_gid = {$grp_id} WHERE usr_id =
{$User->usr_id} LIMIT 1";
mysql_query($sql, $this->db);
</blockquote>

会不会好一些?

Reply all
Reply to author
Forward
0 new messages