[bosmania]

and i assume i have to do something similar to this for the clan

case DIALOG_REGISTER:
{
if(!response) return Kick(playerid);

szQuery[0] = EOS;
PlayerInfo[playerid][pLevel] = 1;
IsPlayerLogged[playerid] = 1;

ShowPlayerDialog(playerid, DIALOG_LANGUAGE, DIALOG_STYLE_MSGBOX, "{FFFFFF}Registering", "Choose the language you speak.", "Romana", "English");
mysql_format(mysql, szQuery, 256, "INSERT INTO `users` (`Username`, `Password`, `Level`) VALUES ('%e', '%e', '1')", GetName(playerid), inputtext);
new Cache: result = mysql_query(mysql, szQuery);
new i = cache_insert_id();
cache_delete(result);
PlayerInfo[playerid][pID] = i;
}