$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; }
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; }