update_shoplist.sh and other updates

1 files changed, 71 insertions, 0 deletions

diff --git a/config/update_shoplist.sh b/config/update_shoplist.sh
new file mode 100755
index 0000000..ab42825
--- /dev/null
+++ b/config/update_shoplist.sh
@@ -0,0 +1,71 @@
+#!/bin/bash
+
+# this script merges new items into an existing shoplist and keeps the current values
+
+ITEM_DB_DIR="/mnt/E/TMW/git.themanaworld.org/#HoraK-FDF/legacy/serverdata/world/map/db"
+SHOP_LIST="shoplist.txt"
+CURRENT_SHOP_LIST="shoplist.txt"
+
+SORT_MODE="1"
+# 0 = no sort
+# 1 = sort by id
+# 2 = sort by item name
+
+if [ ! -e "$ITEM_DB_DIR" ]; then
+ echo "warning the directory \""$ITEM_DB_DIR"\" does not exist ..."
+ echo "... exiting!"
+ exit 1
+fi
+
+if [ -e "$SHOP_LIST" ]; then
+ echo "warning the file "$SHOP_LIST" allready exists ..."
+ echo "... enter y/Y to overwrite it : "
+ read KEY
+ if [ ! $KEY = "y" ] && [ ! $KEY = "Y" ]; then
+  echo "... exiting!"
+  exit 0
+ fi
+fi
+
+NEW_ITEMS=`cat "$ITEM_DB_DIR"/item_db* | grep -o -E "^[1-9][0-9]*[,][ ]+[a-zA-Z]*[,]" | sed -r -e 's/[,][ ]*/ /g' -e 's/[ ]*$//g' -e 's/ / 0 0 0 0 /g'`
+OLD_ITEMS=`cat "$CURRENT_SHOP_LIST"`
+
+OLD_IFS=$IFS
+IFS=$'\n'
+
+FIRST_CYCLE=1
+
+for i in $NEW_ITEMS; do
+ ITEM_ID=`echo $i | cut -d ' ' -f 1`
+ IS_IN_OLD_ITEMS=`echo "$OLD_ITEMS" | grep -E "^"$ITEM_ID"[ ]"`
+ if [ ! "$IS_IN_OLD_ITEMS" = "" ]; then
+  # item_id  buy_amount buy_price sell_amount sell_price comment/itemname(optional)
+  BUY_AMOUNT=`echo "$IS_IN_OLD_ITEMS" | cut -d ' ' -f 2`
+  BUY_PRICE=`echo "$IS_IN_OLD_ITEMS" | cut -d ' ' -f 3`
+  SELL_AMOUNT=`echo "$IS_IN_OLD_ITEMS" | cut -d ' ' -f 4`
+  SELL_PRICE=`echo "$IS_IN_OLD_ITEMS" | cut -d ' ' -f 5`
+  ITEM_NAME=`echo "$i" | cut -d ' ' -f 6`
+  MERGED_ITEMS=""$MERGED_ITEMS""$ITEM_ID" "$BUY_AMOUNT" "$BUY_PRICE" "$SELL_AMOUNT" "$SELL_PRICE" "$ITEM_NAME""$'\n'
+ else
+  MERGED_ITEMS=""$MERGED_ITEMS""$i""$'\n'
+ fi
+done
+
+IFS=$OLD_IFS
+
+case $SORT_MODE in
+ 0)
+  echo -n "$MERGED_ITEMS" > "$SHOP_LIST"
+ ;;
+ 1)
+  echo -n "$MERGED_ITEMS" | sort -t " " -k 1 -g > "$SHOP_LIST"
+ ;;
+ 2)
+  echo -n "$MERGED_ITEMS" | sort -t " " -k 2 > "$SHOP_LIST"
+ ;;
+ *)
+  echo "wrong value for variable SORT_MODE!"
+  exit 1
+esac
+
+exit 0