Changeset 178 for minimanager/scripts/gen_lib.php

Timestamp:

Dec 23, 2007, 2:55:36 PM (17 years ago)

Author:

george

Message:

Minimanager 0.1.6b

File:

• minimanager/scripts/gen_lib.php (modified) (4 diffs)

minimanager/scripts/gen_lib.php

@@ -13 +13 @@
 function send_ingame_mail($to, $from, $subject, $body, $gold = 0, $item = 0, $stack = 1){
         global $lang_global, $characters_db, $realm_id;
-        
+
         $sql_0 = new SQL;
         $sql_0->connect($characters_db[$realm_id]['addr'], $characters_db[$realm_id]['user'], $characters_db[$realm_id]['pass'], $characters_db[$realm_id]['name']);
- 
+
         $result = $sql_0->query("SELECT MAX(`id`) FROM item_text");
         $item_page_id = ($sql_0->result($result, 0)) + 1;
@@ -24 +24 @@
         $mail_id = ($sql_0->result($result, 0)) + 1;
 
-        $item_guid = ($item) ? gen_item_instance($to, $item, $stack) : 0;
+    $item_guid = ($item) ? gen_item_instance($to, $item, $stack) : 0;
 
-        $result = $sql_0->query("INSERT INTO mail (id,messageType,sender,receiver,subject,itemTextId,item_guid,item_template,expire_time,deliver_time,money,cod,checked) 
-                        VALUES ($mail_id, 0, '$from', '$to', '$subject', '$item_page_id', '$item_guid', '$item', '".(time() + (30*24*3600))."','".(time()+5)."', '$gold', 0, 0)");
-        
+    if ($item == 0) {
+         $has_items = 0;
+    } else {
+         $has_items = 1;
+    }
+
+    $result = $sql_0->query("INSERT INTO mail (id,messageType,sender,receiver,subject,itemTextId,has_items,expire_time,deliver_time,money,cod,checked)
+            VALUES ($mail_id, 0, '$from', '$to', '$subject', '$item_page_id', '$has_items', '".(time() + (30*24*3600))."','".(time()+5)."', '$gold', 0, 0)");
+
+        if ($has_items) {
+                $result = $sql_0->query("INSERT INTO mail_items (mail_id,item_guid,item_template)
+                       VALUES ($mail_id, '$item_guid', '$item')");
+        }
+
         if ($result) {
-                $sql_0->close();
-                return $mail_id;
+              $sql_0->close();
+          return $mail_id;
         } else {
                         $sql_0->close();
@@ -54 +65 @@
                                                         WHERE entry = '$item_id'");
  $item_template = $sql_1->fetch_row($result);
- 
+
  if ($item_template[1] <= 1) $stack = 1;
- 
+
  $item_data = array(
         'OBJECT_FIELD_GUID'               => $guid,
@@ -82 +93 @@
     'ITEM_FIELD_MAXDURABILITY'        => $item_template[2].' '
  );
- 
+
  $data = implode(" ",$item_data);
 
  $result = $sql_1->query("INSERT INTO item_instance (guid, owner_guid, data) VALUES ($guid, '$owner','$data')");
- 
+
  if ($result) {
         $sql_1->close();