Example #1
0
    $rest = 0;
}
if (!$rest_id) {
    $rest_id = array();
}
$x = 0;
while ($ordre_id) {
    if ($gl_id == $ordre_id) {
        #		echo $ordre_id;
        exit;
    }
    $gl_id = $ordre_id;
    if ($delfakturer) {
        $ordre_id = delfakturer($ordre_id, $valg);
    }
    list($ordre_id, $leveres) = find_next($ordre_id, $valg);
    if ($ordre_id && $leveres) {
        $x++;
        $ordre_antal++;
        if ($skriv) {
            $skriv = $skriv . "," . $ordre_id;
        } else {
            $skriv = $ordre_id;
        }
        momsupdat($ordre_id);
        levering($ordre_id, 'on', 'on');
        bogfor($ordre_id);
    } elseif ($ordre_id) {
        $rest++;
        $rest_id[$rest] = $ordre_id;
    }
Example #2
0
function new_topic($username,$title,$message,$id_board){	
        $message=mysql_real_escape_string($message);

	$result = mysql_query("SELECT * FROM smf_members WHERE member_name='$username'") or die(mysql_error());
	$member_data = mysql_fetch_array($result) or die(mysql_error());
	
	$id_member = $member_data['id_member'];
	$posts     = $member_data['posts'];
	$email     = $member_data['email_address'];
	//add to topics
	$new_id_topic   = find_next('smf_topics','id_topic');
	$new_id_message = find_next('smf_messages','id_msg');
	mysql_query("INSERT INTO smf_topics (id_topic, is_sticky, id_board, id_first_msg, id_last_msg, id_member_started, id_member_updated, id_poll, id_previous_board, id_previous_topic, num_replies, num_views, locked, unapproved_posts, approved) VALUES ('$new_id_topic','0','$id_board','$new_id_message','$new_id_message','$id_member','$id_member','0','0','0','0','0','0','0','1')") or die(mysql_error()); 
	$time=time();
	//add to messages
mysql_query("SET character_set_results = 'utf8', character_set_client = 'utf8', character_set_connection = 'utf8', character_set_database = 'utf8', character_set_server = 'utf8'");
	mysql_query("INSERT INTO smf_messages (id_msg, id_topic, id_board, poster_time, id_member, id_msg_modified, subject, poster_name, poster_email, poster_ip, smileys_enabled, modified_time, modified_name, body, icon, approved) VALUES ('$new_id_message','$new_id_topic','$id_board','$time','$id_member','$new_id_message','$title','$username','$email','','1','0','','$message','xx','1')") or die(mysql_error());

	//post count
       	update_table('smf_members','id_member',$id_member,'posts',$posts+1);

	//insert log_topics
//	mysql_query("INSERT INTO smf_log_topics (id_member, id_topic, id_msg) VALUES ('$id_member','$new_id_topic','$new_id_message')") or die(mysql_error());

	//insert log_digest
//	mysql_query("INSERT INTO smf_log_digest (id_topic, id_msg, note_type, daily, exclude) VALUES ('$new_id_topic','$new_id_message','topic','0','1')") or die(mysql_error());
	
	//update log_boards
	mysql_query("UPDATE smf_log_boards SET id_msg='$new_id_message' WHERE id_member='$id_member' AND id_board='$id_board'") or die(mysql_error());

	//update log_activity
  //      $result = mysql_query("SELECT * FROM smf_log_activity") or die(mysql_error());
    //    while($row = mysql_fetch_array($result)){
//		$last_date   = $row['date'];
//		$last_posts  = $row['posts'];
//		$last_topics = $row['topics'];
//	}
//	update_table('smf_log_activity','date',$last_date,'posts',$last_posts+1);
//	update_table('smf_log_activity','date',$last_date,'topics',$last_topics+1);

	//update boards
	$result = mysql_query("SELECT * FROM smf_boards WHERE id_board='$id_board'") or die(mysql_error());
	$row = mysql_fetch_array($result);
	$ntopics=$row['num_topics'];
        $nposts=$row['num_posts'];
        update_table('smf_boards','id_board',$id_board,'id_last_msg',$new_id_message);
      	update_table('smf_boards','id_board',$id_board,'id_msg_updated',$new_id_message);
	update_table('smf_boards','id_board',$id_board,'num_posts',$nposts+1);
	update_table('smf_boards','id_board',$id_board,'num_topics',$ntopics+1);
	return $new_id_topic;
}