Author Topic: Guild Items (Read 41955 times)

durroch · « **Reply #15 on:** July 31, 2008, 11:33:28 am »

I'm retarded, scratch what I said about adding the name to the command. I can just grab that from the character submitting the command since obviously the item is located on that character when adding it to the database. So ya, that will be easy to implement. I'll just make it visible to admin and higher since it's really not relative to the end user.

Sigi_cz · « **Reply #16 on:** August 04, 2008, 07:33:02 am »

This mod lost part of his functionality thanks to Funcom "Bind on equip". Damn them

jimango · « **Reply #17 on:** January 24, 2009, 09:00:11 am »

hei, is it a way to make this module work as a guild crafting overview?

I think this is a very nice module, i like the sections of each kind of armor..

Is it possible to remake this module to list what members that have each item?
So we can have a good overview of who can make what in guild..
We use !supplies atm, but then we have to click trough all items to know what they are..
If the !gitems could change "quanity" with "player" this would be a great module to list what items that can be created in the guild =D

jimango

durroch · « **Reply #18 on:** January 24, 2009, 10:50:38 am »

Sorry Mate, I haven't played this game since around Sept of last year nor do I have an account anymore. Someone else is going to have to make these changes for you :-/.

Best of luck though!

jimango · « **Reply #19 on:** February 23, 2009, 01:19:52 am »

Ok, me and a guild member have made the changes we want now..

The only thing we cant fix atm, is to give members of the bot access..
I can myself add items, but we are not sure what to do.. im the owner

can someone help us?

Code is removed and moved to an other post http://bebot.link/module-requests/culture-item-recipe-book-or-guild-crafters-module/msg12292/?topicseen#new to make it easyer to mantain

Wizhk · « **Reply #20 on:** February 23, 2009, 07:32:36 am »

Did you go into settings and promote ppl on the bot that you want to have access?

Or maybe you will find an option to change the actual module to allow a lower access.

!settings

Wizhk

jimango · « **Reply #21 on:** February 23, 2009, 10:45:33 am »

in settings the option is only to allow ppl to delete items..
I gues it has to be fixed in the code for me to be able to give access to MEMBERS

jimango · « **Reply #22 on:** February 24, 2009, 05:00:11 pm »

Problem solved, maintained in thread posted where the code used to be above

Drizzurdeen · « **Reply #23 on:** April 01, 2009, 05:26:43 pm »

perfekt module ... we love ist ... but

is there a possibility to add the storrage-palce lice bankchar1 bankchar2 and so on ...

we don't have all the items just in the bankslot for the guild ... we use several bankchars ... it would be nice whenn the function would look lick this

!gitems add 1 armor heavy [itemlink] Bankchar1

and whenn you give the command
!gitems
the bot will show you the Items like this

Armor
Heavy
item / ql / stock / [char where the item is] / delete

and so on ...

we tryed several things but nothing will work

...

greets Drizz

Drizzurdeen · « **Reply #24 on:** April 03, 2009, 11:34:34 am »

really no ideas how i can change the php-file that it works

we tryed these things

Quote

function __construct (&$bot)
   {
      parent::__construct(&$bot, get_class($this));

      $this -> bot -> db -> query("
         CREATE TABLE IF NOT EXISTS " . $this->bot->db->define_tablename("guild_items", "false") .
         " (id int(11) NOT NULL auto_increment,
         item_name varchar(50) NOT NULL,
         item_id varchar(20) NOT NULL,
         item_ql varchar(3) NOT NULL,
         item_color varchar(300) NOT NULL,
         item_stock int(11) NOT NULL,
         item_cat enum('Ruestung Sozial', 'Ruestung Stoff', 'Ruestung Leicht','Ruestung Mittel','Ruestung Schwer','Ruestung Platte','Ruestung Schild','Ruestung Back','Waffe 1HE','Waffe 2HE','Waffe 1HB','Waffe 2HB','Waffe Daggers','Waffe Stange','Waffe Stab','Waffe Bogen','Waffe Pfeil','Waffe Armbrust','Waffe Bolzen','Waffe Wurf','Schmuck Halskette','Schmuck Ring','Schmuck Talisman','Buff Mana','Buff Ausdauer','Buff Gesundheit','Gems Rhombic','Gems Trillion','Gems Oval','Gems Teardrop','Gems Oblique','Gems Cabochon') NOT NULL,
         item_loaned int(11) NOT NULL,
         item_besitzer varchar (20) NOT NULL,
         PRIMARY KEY (id))");

after deleting the tabel in the database and restartign the bot ... he create the item_besitzer

Quote

function command_handler($name, $msg, $origin)
   {
      $this -> error -> reset(); //Reset the error message so we don't trigger the handler by old error messages.

      $com = $this -> parse_com($msg, array('com', 'sub', 'arg1', 'arg2', 'arg3', 'arg4', 'arg5'));

      switch($com['sub'])
      {
         case 'add':
            return $this -> add_gitems($name, $com['arg1'], $com['arg2'] . ' ' . $com['arg3'], $com['arg4'], $itemb['arg5']);
            break;

here we say him ... now you have a 5'th argument itemb

Quote

function show_gitems($name)
   {
      if (empty($this -> items_list)) return "There are currently no Guild Items.";

      $blob = "<font color='SILVER' face='hyborianlarge'>:: Available Guild Items ::</font>\n";
      if (!empty($this -> items_list))
      {
         $item_cat = "";
         $item_cat2 = "";
         foreach ($this -> items_list AS $items)
         {
            $item_category = preg_split('/ /', $items['item_cat']);
            if (!empty($items['item_loaned']))
            {
               $item_loaned = "##gitems_highlight1##|##end## ##gitems_highlight2##Loaned out:##end## " . $items['item_loaned'];
            } else {
               $item_loaned = "";
            }
            if ($this -> bot -> core("security") -> check_access($name, $this -> bot -> core("settings") -> get('Guild_Items', 'Item_Del')))
            {
               $delete = "##gitems_highlight1##|##end## [ " . $this -> bot -> core("tools") -> chatcmd("gitems del $items[id]", "Delete") . " ]";
            }
            $itemlink = $this -> itemlink("item $items[item_id]", "$items[item_color]", "$items[item_name]");
            if($item_cat<>$item_category[0])
            {
               $blob .= "\n##gitems_heading1##$item_category[0]##end##\n";
               if ($items['item_stock'] > "0" || !empty($item_loaned))
               {
                  if($item_cat2<>$item_category[1])
                  {
                     $blob .= "  ##gitems_heading2##$item_category[1]##end##\n";
                     $blob .= "    $itemlink ##gitems_highlight1##|##end## ##gitems_highlight2##QL:##end## $items[item_ql] ##gitems_highlight1##|##end## ##gitems_highlight2##Stock:##end## $items[item_stock] $item_besitzer $delete\n";
                  } else {
                     $blob .= "    $itemlink ##gitems_highlight1##|##end## ##gitems_highlight2##QL:##end## $items[item_ql] ##gitems_highlight1##|##end## ##gitems_highlight2##Stock:##end## $items[item_stock] $item_besitzer $delete\n";
                  }
                  $item_cat2 = $item_category[1];
               }
            } else {
               if ($items['item_stock'] > "0" || !empty($item_loaned))
               {
                  if($item_cat2<>$item_category[1])
                  {
                     $blob .= "  ##gitems_heading2##$item_category[1]##end##\n";
                     $blob .= "    $itemlink ##gitems_highlight1##|##end## ##gitems_highlight2##QL:##end## $items[item_ql] ##gitems_highlight1##|##end## ##gitems_highlight2##Stock:##end## $items[item_stock] $item_besitzer $delete\n";
                  } else {
                     $blob .= "    $itemlink ##gitems_highlight1##|##end## ##gitems_highlight2##QL:##end## $items[item_ql] ##gitems_highlight1##|##end## ##gitems_highlight2##Stock:##end## $items[item_stock] $item_besitzer $delete\n";
                  }
                  $item_cat2 = $item_category[1];
               }
            }
            $item_cat = $item_category[0];
         }
      }
      return $this -> bot -> core("tools") -> make_blob("Guild Items", $blob);

here we try to show the 5'th argumen ... item_besitzer

Quote

//Add items to Guild Item list
   function add_gitems($name, $item_stock, $item_cat, $arg, $itemb)
   {
      $item = $this -> parseitem($arg);
      $item_name = str_replace("'", "\'", $item[name]);
      $itemb = $item_besitzer;


      $result = $this -> bot -> db -> select("SELECT * FROM #___guild_items WHERE item_id = '$item[id]'");
      if (!empty($result))
      {
         $this -> error -> set($arg . " habe ich bereits in meiner geilen Datenbank.");
         return $this -> error;
      }
      $this -> bot -> db -> query("INSERT INTO #___guild_items (item_id, item_name, item_color, item_ql, item_stock, item_cat, item_besitzer) VALUES ('$item[id]', '$item_name', '$item[color]', '$item[ql]', '$item_stock', '$item_cat', '$item_besitzer')");
      $this -> load_gitems();
      return "Vielen Dank " . $name . ", " . $arg . " wurde der Datenbank hinzugefügt.";

here we try to add an item including the item-owner into the db .... but ... when we make !gitems add 1 armor heavy [itmelink] owner ... he is adding the item into the database ... but without the owner ... why

where is the mistake

please please help

thx drizz