rendered paste bodyfunction insert_app($id,$name){ $time=time(); $select_id=mysql_query("SELECT alliance_name,level FROM alliances WHERE id='$id' ");//find alliance members $num=mysql_num_rows($select_id); if($num==1) { $alli_name=mysql_result($select_id,0,"alliance_name"); $level=mysql_result($select_id,0,"level"); $mem_num=get_mem_num($alli_name); if($mem_num>=($level*3)) { mysql_query("INSERT INTO alliance_req (alliance_id,username,time) VALUES ('$id','$name','$time')"); $msg="You application has been filed."; } else { $msg="Alliance can't accept new members."; } } else { $msg="Application failed."; } return $msg;}