[Request] guild bank

[anonymous23]

who has an sql or something? i need one that works for chrispee's gates of zul'aman. thx anyone

[chaoticd35]

I don't have one handy but If you download Knaurs, Norwegian 4.0 Elite Server Database. he has a guild bank added to his database with scripts in his script folders for it. Don't know if that helped but I thought it might.


Link to it is here

[anonymous23]

sweet! ty man!

[anonymous23]

but.... is there a way i can get the banks with out getting a new server up?

[Le Froid]

but.... is there a way i can get the banks with out getting a new server up?

Update core+database with SQL updates in your SVN

[Spartansp]

yes first you need to execute this .sql batchfile

/*
MySQL Data Transfer
Source Host: 127.0.0.1
Source Database: ascent
Target Host: 127.0.0.1
Target Database: ascent
Date: 12/01/2008 07:35:52 p.m.
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for guild_bankitems
-- ----------------------------
CREATE TABLE `guild_bankitems` (
  `guildId` int(30) NOT NULL,
  `tabId` int(30) NOT NULL,
  `slotId` int(30) NOT NULL,
  `itemGuid` int(30) NOT NULL,
  PRIMARY KEY  (`guildId`,`tabId`,`slotId`),
  KEY `a` (`guildId`),
  KEY `b` (`tabId`),
  KEY `c` (`slotId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for guild_banklogs
-- ----------------------------
CREATE TABLE `guild_banklogs` (
  `log_id` int(30) NOT NULL,
  `guildid` int(30) NOT NULL,
  `tabid` int(30) NOT NULL COMMENT 'tab 6 is money logs',
  `action` int(5) NOT NULL,
  `player_guid` int(30) NOT NULL,
  `item_entry` int(30) NOT NULL,
  `stack_count` int(30) NOT NULL,
  `timestamp` int(30) NOT NULL,
  PRIMARY KEY  (`log_id`,`guildid`),
  KEY `a` (`guildid`),
  KEY `b` (`tabid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Table structure for guild_banktabs
-- ----------------------------
CREATE TABLE `guild_banktabs` (
  `guildId` int(30) NOT NULL,
  `tabId` int(30) NOT NULL,
  `tabName` varchar(200) NOT NULL,
  `tabIcon` varchar(200) NOT NULL,
  PRIMARY KEY  (`guildId`,`tabId`),
  KEY `a` (`guildId`),
  KEY `b` (`tabId`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records 
-- ----------------------------

and then just spawn a guild vault entry ID 187365

[anonymous23]

ty
very much

[Spartansp]

no problem hope that work :P