EQoffline, bots and more.. - Page 35

**Congdar** · #**511** 05-08-2008, 06:14 PM

i think maybe priority 0..... 0 is 'higher casting priority' than 1

If you would be willing to send me all your 600 based spell lists I could permanantly delete those sections and modify the create and update spellid code to 600's and provide a sql file to source in for caster bots.

**cavedude** · #**512** 05-08-2008, 06:36 PM

Which I will then add to PEQ so there won't be any reason to worry about it

Aramid · #**513** 05-08-2008, 09:17 PM

Well, I only have Cleric, Shaman, Mage, Wiz, Necro and Druid Done.... Use if you want to.. They go in order as Cleric was 1, so it's 601. Shaman was 6 so it's 606 etc...

Code:

-- MySQL dump 10.11
--
-- Host: localhost    Database: peq
-- ------------------------------------------------------
-- Server version	5.0.32-Debian_7etch5-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `npc_spells_entries`
--

DROP TABLE IF EXISTS `npc_spells_entries`;
CREATE TABLE `npc_spells_entries` (
  `id` int(11) unsigned NOT NULL auto_increment,
  `npc_spells_id` int(11) NOT NULL default '0',
  `spellid` smallint(5) NOT NULL default '0',
  `type` smallint(5) unsigned NOT NULL default '0',
  `minlevel` tinyint(3) unsigned NOT NULL default '0',
  `maxlevel` tinyint(3) unsigned NOT NULL default '255',
  `manacost` smallint(5) NOT NULL default '-1',
  `recast_delay` int(11) NOT NULL default '-1',
  `priority` smallint(5) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `spellsid_spellid` (`npc_spells_id`,`spellid`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `npc_spells_entries`
--
-- WHERE:  npc_spells_id > 600

LOCK TABLES `npc_spells_entries` WRITE;
/*!40000 ALTER TABLE `npc_spells_entries` DISABLE KEYS */;
INSERT INTO `npc_spells_entries` VALUES (866,601,200,2,1,4,-1,-1,0),(878,601,14,1,1,13,-1,-1,0),(879,601,202,8,1,8,-1,-1,0),(880,601,11,8,5,18,-1,-1,1),(881,601,215,8,5,33,-1,-1,1),(882,601,17,2,5,23,-1,-1,10),(883,601,216,1,5,18,-1,-1,1),(884,601,227,8,9,33,-1,-1,1),(885,601,224,8,9,33,-1,-1,1),(886,601,229,1,9,23,-1,-1,1),(913,601,231,1,9,18,-1,-1,1),(989,601,226,8,14,38,-1,-1,1),(1042,601,485,8,14,23,-1,-1,1),(1100,601,16,1,14,43,-1,-1,20),(1101,601,225,8,14,38,-1,-1,1),(1102,601,368,8,19,28,-1,-1,1),(1103,601,228,8,19,43,-1,-1,1),(1104,601,413,1,19,28,-1,-1,1),(1105,601,123,1,19,33,-1,-1,1),(1106,601,486,8,24,33,-1,-1,1),(1107,601,244,8,24,33,-1,-1,0),(1108,601,126,1,24,38,-1,-1,1),(1109,601,414,1,29,38,-1,-1,1),(1110,601,329,1,29,53,-1,-1,30),(1111,601,504,8,34,43,-1,-1,1),(1126,601,405,1,34,43,-1,-1,1),(1127,601,1445,8,34,48,-1,-1,1),(1128,601,487,8,34,43,-1,-1,1),(1129,601,124,1,34,48,-1,-1,1),(1184,601,312,8,34,43,-1,-1,0),(1216,601,13,2,39,255,-1,-1,1000),(1224,601,127,1,39,56,-1,-1,1),(1225,601,49,1,39,52,-1,-1,1),(1226,601,415,1,39,48,-1,-1,1),(1227,601,19,8,39,48,-1,-1,1),(1233,601,488,8,44,53,-1,-1,1),(1234,601,672,1,44,55,-1,-1,40),(1237,601,314,8,44,51,-1,-1,0),(1240,601,20,8,49,56,-1,-1,1),(1242,601,416,1,49,58,-1,-1,1),(1246,601,2505,8,49,57,-1,-1,1),(1251,601,125,1,49,57,-1,-1,1),(1257,601,1518,2,51,60,-1,-1,60),(1258,601,1542,1,52,63,-1,-1,1),(1259,601,1533,8,52,59,-1,-1,0),(1261,601,1519,2,53,67,-1,-1,170),(1275,601,1526,1,53,255,-1,-1,1),(1276,601,1535,8,54,60,-1,-1,1),(1277,601,1543,1,54,61,-1,-1,50),(1284,601,2508,1,56,255,-1,-1,60),(1285,601,1527,1,57,255,-1,-1,1),(1288,601,1537,8,57,60,-1,-1,1),(1289,601,2509,8,58,64,-1,-1,1),(1296,601,1544,1,58,60,-1,-1,1),(1297,601,2182,2,58,62,-1,-1,180),(1298,601,1545,1,59,255,-1,-1,1),(1299,601,1447,8,60,61,-1,-1,0),(1300,601,3465,2,61,255,-1,-1,90),(1301,601,3466,8,61,62,-1,-1,1),(1302,601,3481,1,61,64,-1,-1,1),(1303,601,3470,8,61,255,-1,-1,1),(1304,601,3467,8,62,255,-1,-1,0),(1305,601,3476,1,62,255,-1,-1,70),(1306,601,3195,4,62,255,-1,-1,5),(1307,601,3480,2,63,255,-1,-1,200),(1308,601,3473,1,64,255,-1,-1,1),(1309,601,3464,1,65,255,-1,-1,1),(1310,601,3474,8,65,255,-1,-1,1),(1311,602,372,1,1,7,-1,-1,1),(1312,602,378,8,4,11,-1,-1,1),(1313,602,376,1,4,15,-1,-1,2),(1314,602,377,1,4,7,-1,-1,1),(1315,602,656,1,8,23,-1,-1,3),(1316,602,380,1,8,15,-1,-1,1),(1317,602,2551,8,12,33,-1,-1,1),(1318,602,383,1,12,19,-1,-1,4),(1319,602,386,1,16,23,-1,-1,1),(1320,602,657,1,16,28,-1,-1,5),(1321,602,22,1,20,28,-1,-1,6),(1322,602,108,8,20,57,-1,-1,1),(1323,602,503,1,20,48,-1,-1,1),(1324,602,131,4,20,38,-1,-1,1),(1325,602,462,1,24,28,-1,-1,1),(1326,602,464,1,24,33,-1,-1,7),(1327,602,459,1,29,33,-1,-1,1),(1328,602,2553,32,29,48,-1,-1,1),(1329,602,465,1,29,43,-1,-1,8),(1330,602,470,1,29,38,-1,-1,9),(1331,602,1419,8,34,255,-1,-1,1),(1332,602,658,1,34,48,-1,-1,10),(1333,602,463,1,34,38,-1,-1,1),(1334,602,132,4,39,48,-1,-1,2),(1335,602,466,1,39,43,-1,-1,11),(1336,602,460,1,39,48,-1,-1,1),(1337,602,23,1,44,48,-1,-1,12),(1338,602,109,8,44,57,-1,-1,1),(1339,602,659,1,44,50,-1,-1,13),(1340,602,133,4,49,57,-1,-1,3),(1341,602,731,1,49,52,-1,-1,1),(1342,602,2555,32,49,53,-1,-1,1),(1343,602,732,1,49,56,-1,-1,14),(1344,602,1637,1,51,59,-1,-1,16),(1345,602,1634,1,51,55,-1,-1,1),(1346,602,1609,8,52,62,-1,-1,0),(1347,602,1650,1,53,53,-1,-1,1),(1348,602,1526,1,53,255,-1,-1,1),(1349,602,2557,32,54,59,-1,-1,1),(1350,602,1645,1,54,55,-1,-1,1),(1351,602,1639,1,54,54,-1,-1,17),(1352,602,3582,8,54,57,-1,-1,1),(1353,602,1643,1,55,62,-1,-1,18),(1354,602,1651,1,56,56,-1,-1,1),(1355,602,1641,1,57,59,-1,-1,19),(1356,602,1644,1,57,58,-1,-1,1),(1357,602,1652,1,59,60,-1,-1,1),(1358,602,1636,1,59,255,-1,-1,1),(1359,602,2560,32,60,255,-1,-1,1),(1360,602,2884,1,60,255,-1,-1,22),(1361,602,1426,1,60,64,-1,-1,20),(1362,602,1658,1,60,255,-1,-1,21),(1363,602,3327,1,61,64,-1,-1,1),(1364,602,3329,8,62,62,-1,-1,1),(1365,602,3335,1,63,255,-1,-1,23),(1366,603,3306,256,62,255,-1,-1,6),(1367,603,1615,256,56,255,-1,-1,6),(1368,603,3035,256,61,255,-1,-1,6),(1369,603,1508,256,44,255,-1,-1,6),(1370,603,3303,256,65,255,-1,-1,6),(1371,603,3314,32,65,255,-1,-1,25),(1372,603,1617,256,58,255,-1,-1,6),(1373,603,2015,1,55,255,-1,-1,5),(1374,603,2014,1,44,255,-1,-1,5),(1375,603,1616,256,57,255,-1,-1,5),(1376,603,3315,256,61,255,-1,-1,6),(1377,603,3032,64,64,255,-1,-1,20),(1378,603,1393,64,60,255,-1,-1,19),(1379,603,3572,1,54,255,-1,-1,5),(1380,603,3309,128,63,255,-1,-1,56),(1381,603,436,256,51,64,-1,-1,6),(1382,603,3310,32,63,64,-1,-1,0),(1383,603,355,128,12,62,-1,-1,52),(1384,603,3304,32,61,62,-1,-1,0),(1385,603,1619,128,59,62,-1,-1,55),(1386,603,1609,8,52,62,-1,-1,0),(1387,603,1623,32,59,60,-1,-1,0),(1388,603,32,256,52,60,-1,-1,6),(1389,603,1618,64,59,59,-1,-1,18),(1390,603,1622,32,56,58,-1,-1,0),(1391,603,453,128,49,58,-1,-1,54),(1392,603,1412,256,39,58,-1,-1,5),(1393,603,447,64,49,58,-1,-1,16),(1394,603,131,4,53,57,-1,-1,1),(1395,603,6,256,49,57,-1,-1,6),(1396,603,456,256,49,56,-1,-1,5),(1397,603,1621,32,53,55,-1,-1,0),(1398,603,67,8,44,53,-1,-1,1),(1399,603,525,64,39,53,-1,-1,15),(1400,603,3571,1,49,53,-1,-1,5),(1401,603,443,32,49,52,-1,-1,0),(1402,603,133,4,49,52,-1,-1,3),(1403,603,31,256,39,51,-1,-1,6),(1404,603,435,256,34,50,-1,-1,6),(1405,603,1415,1,34,48,-1,-1,5),(1406,603,452,128,29,48,-1,-1,53),(1407,603,451,256,29,48,-1,-1,6),(1408,603,495,32,44,48,-1,-1,0),(1411,603,66,8,34,43,-1,-1,1),(1412,603,442,32,39,43,-1,-1,0),(1413,603,494,32,34,38,-1,-1,0),(1417,603,365,256,16,38,-1,-1,6),(1426,603,524,64,29,38,-1,-1,14),(1435,603,348,256,4,33,-1,-1,6),(1438,604,1677,32,58,255,-1,-1,1),(1468,604,1526,1,53,255,-1,-1,1),(1552,604,1676,32,60,255,-1,-1,1),(1553,604,3329,8,61,255,-1,-1,1),(1554,604,3198,8,61,255,-1,-1,1),(1555,604,3319,1,62,255,-1,-1,1),(1571,604,3387,1,63,255,-1,-1,1),(1573,604,3321,1,63,255,-1,-1,1),(1576,604,3323,1,64,255,-1,-1,1),(1590,604,3325,1,65,255,-1,-1,1),(1591,604,1678,32,59,255,-1,-1,1),(1593,604,1405,256,55,255,-1,-1,1),(1595,604,1675,32,57,255,-1,-1,1),(1596,604,3318,1,61,64,-1,-1,1),(1599,604,3300,8,61,63,-1,-1,1),(1605,604,1394,1,60,63,-1,-1,1),(1620,604,1663,1,57,62,-1,-1,1),(1627,604,1772,1,60,62,-1,-1,1),(1628,604,1662,1,55,61,-1,-1,1),(1629,604,1667,8,56,60,-1,-1,1),(1630,604,2540,1,60,60,-1,-1,1),(1631,604,3582,8,54,60,-1,-1,1),(1632,604,1672,32,54,59,-1,-1,1),(1633,604,1664,1,59,59,-1,-1,1),(1635,604,1577,1,58,59,-1,-1,1),(1636,604,1665,1,59,59,-1,-1,1),(1638,604,1661,1,54,58,-1,-1,1),(1645,604,410,1,49,58,-1,-1,1),(1646,604,1674,32,53,58,-1,-1,1),(1647,604,1673,32,52,57,-1,-1,1),(1648,604,112,1,51,57,-1,-1,1),(1649,604,114,1,44,56,-1,-1,1),(1652,604,1671,32,51,56,-1,-1,1),(1655,604,412,8,49,55,-1,-1,1),(1658,604,1403,256,44,54,-1,-1,1),(1660,604,121,1,39,54,-1,-1,1),(1665,604,109,8,44,53,-1,-1,1),(1666,604,1660,1,52,53,-1,-1,1),(1667,604,49,1,34,52,-1,-1,1),(1668,604,635,32,49,51,-1,-1,1),(1669,604,632,32,49,51,-1,-1,1),(1670,604,633,32,49,51,-1,-1,1),(1691,604,70,1,49,51,-1,-1,1),(1995,604,634,32,49,51,-1,-1,1),(2008,604,111,1,44,50,-1,-1,1),(2009,604,409,1,29,48,-1,-1,1),(2010,604,629,32,44,48,-1,-1,1),(2011,604,680,8,39,48,-1,-1,1),(2012,604,120,1,34,48,-1,-1,1),(2013,604,628,32,44,48,-1,-1,1),(2014,604,630,32,44,48,-1,-1,1),(2015,605,3345,256,62,255,-1,-1,1),(2016,605,3242,8,62,255,-1,-1,1),(2017,605,3349,1,64,255,-1,-1,1),(2018,605,3355,1,64,255,-1,-1,15),(2019,605,3178,8,65,255,-1,-1,1),(2020,605,3360,8,65,255,-1,-1,1),(2021,605,1527,1,56,255,-1,-1,1),(2022,605,1697,1,53,60,-1,-1,1),(2023,605,1711,8,57,255,-1,-1,1),(2024,605,3342,1,61,255,-1,-1,20),(2025,605,3199,8,61,255,-1,-1,1),(2026,605,1713,8,58,255,-1,-1,1),(2027,605,1686,1,51,255,-1,-1,1),(2028,605,1592,1,53,255,-1,-1,1),(2029,605,297,1,8,255,-1,-1,1),(2030,605,3034,32,62,255,-1,-1,1),(2031,605,3358,1,64,65,-1,-1,1),(2032,605,3350,8,63,64,-1,-1,1),(2033,605,3240,8,62,64,-1,-1,1),(2034,605,3300,8,61,63,-1,-1,1),(2035,605,2016,1,58,63,-1,-1,1),(2036,605,3347,1,62,63,-1,-1,1),(2037,605,3341,1,61,63,-1,-1,1),(2038,605,2570,8,60,62,-1,-1,1),(2039,605,1723,32,55,61,-1,-1,1),(2040,605,64,8,39,61,-1,-1,1),(2041,605,1710,8,60,61,-1,-1,1),(2042,605,1707,1,60,61,-1,-1,1),(2043,605,1703,256,59,61,-1,-1,1),(2044,605,1715,1,55,60,-1,-1,1),(2045,605,1712,1,57,60,-1,-1,1),(2046,605,1633,4,58,60,-1,-1,4),(2047,605,1689,8,52,60,-1,-1,1),(2048,605,1702,1,57,60,-1,-1,1),(2049,605,1692,1,59,60,-1,-1,1),(2050,605,1409,8,55,59,-1,-1,1),(2051,605,1693,8,54,59,-1,-1,1),(2052,605,1705,1,53,59,-1,-1,1),(2053,605,1709,8,58,59,-1,-1,1),(2054,605,195,256,49,58,-1,-1,1),(2055,605,1691,1,54,58,-1,-1,1),(2056,605,176,8,49,57,-1,-1,1),(2057,605,133,4,49,57,-1,-1,3),(2058,605,1708,8,53,57,-1,-1,1),(2059,605,1698,1,54,57,-1,-1,1),(2060,605,678,1,44,56,-1,-1,1),(2061,605,185,1,44,56,-1,-1,10),(2062,605,654,8,49,56,-1,-1,1),(2063,605,127,1,39,55,-1,-1,1),(2064,605,1408,8,34,54,-1,-1,1),(2065,605,690,32,49,54,-1,-1,1),(2066,605,1696,1,52,54,-1,-1,1),(2067,605,673,1,44,53,-1,-1,1),(2068,605,174,8,29,53,-1,-1,1),(2069,605,190,1,49,53,-1,-1,1),(2070,605,67,8,44,53,-1,-1,1),(2071,605,163,1,44,52,-1,-1,1),(2072,605,25,1,44,52,-1,-1,1),(2073,605,172,8,49,52,-1,-1,1),(2074,605,184,1,49,52,-1,-1,1),(2075,605,484,8,44,51,-1,-1,1),(2076,605,178,1,44,51,-1,-1,1),(2077,605,74,1,34,50,-1,-1,1),(2078,605,171,8,39,48,-1,-1,1),(2079,605,183,1,39,48,-1,-1,1),(2080,605,653,8,39,48,-1,-1,1),(2081,605,450,256,29,48,-1,-1,1),(2082,605,689,32,44,48,-1,-1,1),(2083,605,648,8,39,48,-1,-1,1),(2084,605,132,4,39,48,-1,-1,2),(2085,605,188,1,34,48,-1,-1,1),(2086,605,408,1,29,45,-1,-1,1),(2087,605,191,8,29,45,-1,-1,1),(2088,605,180,1,34,43,-1,-1,1),(2089,605,49,1,29,43,-1,-1,1),(2090,605,177,1,20,43,-1,-1,1),(2091,605,71,1,34,43,-1,-1,1),(2092,605,677,1,20,43,-1,-1,1),(2093,605,483,8,34,43,-1,-1,1),(2094,605,688,32,39,43,-1,-1,1),(2095,605,182,1,24,39,-1,-1,1),(2096,605,131,4,29,38,-1,-1,1),(2097,605,215,8,20,38,-1,-1,1),(2098,605,652,8,29,38,-1,-1,1),(2099,605,170,8,24,38,-1,-1,1),(2100,605,228,8,20,38,-1,-1,1),(2101,605,304,1,16,38,-1,-1,1),(2102,605,687,32,34,38,-1,-1,1),(2103,605,162,1,29,33,-1,-1,1),(2104,605,482,8,24,33,-1,-1,1),(2105,605,350,1,24,33,-1,-1,1),(2106,605,686,32,29,33,-1,-1,1),(2107,605,187,1,16,33,-1,-1,1),(2108,605,651,8,20,28,-1,-1,1),(2109,605,179,1,20,28,-1,-1,1),(2110,605,24,1,24,28,-1,-1,1),(2111,605,685,32,24,28,-1,-1,1),(2112,605,697,8,16,28,-1,-1,1),(2165,605,303,1,12,28,-1,-1,1),(2316,605,521,256,12,28,-1,-1,1),(2427,605,481,8,16,23,-1,-1,1),(2445,605,300,1,12,23,-1,-1,1),(2530,605,684,32,20,23,-1,-1,1),(2531,605,302,1,12,23,-1,-1,1),(2532,605,39,8,16,23,-1,-1,1),(2533,605,306,1,16,23,-1,-1,1),(2534,605,281,1,16,19,-1,-1,1),(2535,605,40,8,1,19,-1,-1,1),(2536,605,683,32,16,19,-1,-1,1),(2537,605,650,8,12,19,-1,-1,1),(2538,605,290,1,4,19,-1,-1,1),(2539,605,676,1,4,19,-1,-1,1),(2540,605,682,32,12,15,-1,-1,1),(2541,605,292,1,4,15,-1,-1,1),(2542,605,296,1,8,15,-1,-1,1),(2543,602,3301,8,63,255,-1,-1,0),(2544,602,3333,1,64,255,-1,-1,1),(2545,602,3332,1,65,255,-1,-1,1),(2546,602,3339,1,65,255,-1,-1,24),(2547,603,441,32,29,33,-1,-1,0),(2548,603,204,1,24,33,-1,-1,5),(2549,603,65,8,24,33,-1,-1,1),(2550,603,446,64,20,28,-1,-1,13),(2551,603,360,256,12,28,-1,-1,6),(2552,603,493,32,24,28,-1,-1,0),(2553,603,309,8,16,23,-1,-1,1),(2554,603,440,32,20,23,-1,-1,0),(2555,603,502,64,4,19,-1,-1,11),(2556,603,492,32,16,19,-1,-1,0),(2557,603,445,64,12,18,-1,-1,12),(2558,603,362,32,12,15,-1,-1,0),(2559,603,351,32,8,11,-1,-1,0),(2560,603,344,128,4,11,-1,-1,51),(2561,603,341,64,1,11,-1,-1,10),(2562,603,491,32,4,7,-1,-1,0),(2563,603,338,32,1,3,-1,-1,0),(2564,604,631,32,44,48,-1,-1,1),(2565,604,626,32,39,43,-1,-1,1),(2566,604,624,32,39,43,-1,-1,1),(2567,604,627,32,39,43,-1,-1,1),(2568,604,110,1,20,43,-1,-1,1),(2569,604,625,32,39,43,-1,-1,1),(2570,604,113,1,24,43,-1,-1,1),(2571,604,108,8,20,43,-1,-1,1),(2572,604,621,32,34,38,-1,-1,1),(2573,604,620,32,34,38,-1,-1,1),(2574,604,83,1,20,38,-1,-1,1),(2575,604,622,32,34,38,-1,-1,1),(2576,604,623,32,34,38,-1,-1,1),(2577,604,479,8,29,38,-1,-1,1),(2578,604,576,32,29,33,-1,-1,1),(2579,604,573,32,29,33,-1,-1,1),(2580,604,574,32,29,33,-1,-1,1),(2581,604,575,32,29,33,-1,-1,1),(2582,604,68,1,20,33,-1,-1,1),(2583,604,570,32,24,28,-1,-1,1),(2584,604,572,32,24,28,-1,-1,1),(2585,604,330,1,12,28,-1,-1,1),(2586,604,569,32,24,28,-1,-1,1),(2587,604,571,32,24,28,-1,-1,1),(2588,604,411,8,20,28,-1,-1,1),(2589,604,324,1,8,23,-1,-1,1),(2590,604,496,32,20,23,-1,-1,1),(2591,604,497,32,20,23,-1,-1,1),(2592,604,499,32,20,23,-1,-1,1),(2593,604,498,32,20,23,-1,-1,1),(2594,604,396,32,16,19,-1,-1,1),(2595,604,395,32,16,19,-1,-1,1),(2596,604,332,8,8,19,-1,-1,1),(2597,604,328,1,12,19,-1,-1,1),(2598,604,336,32,16,19,-1,-1,1),(2599,604,334,1,16,19,-1,-1,1),(2600,604,335,32,16,19,-1,-1,1),(2601,604,401,32,12,15,-1,-1,1),(2602,604,404,32,12,15,-1,-1,1),(2603,604,322,1,8,15,-1,-1,1),(2604,604,403,32,12,15,-1,-1,1),(2605,604,402,32,12,15,-1,-1,1),(2606,604,398,32,8,11,-1,-1,1),(2607,604,400,32,8,11,-1,-1,1),(2608,604,397,32,8,11,-1,-1,1),(2609,604,399,32,8,11,-1,-1,1),(2610,604,94,1,4,7,-1,-1,1),(2611,604,58,32,4,7,-1,-1,1),(2612,604,316,32,4,7,-1,-1,1),(2613,604,315,32,4,7,-1,-1,1),(2614,604,317,32,4,7,-1,-1,1),(2615,604,93,1,1,3,-1,-1,1),(2616,605,645,1,12,15,-1,-1,1),(2617,605,229,1,4,15,-1,-1,1),(2618,605,293,8,4,11,-1,-1,1),(2619,605,294,256,4,11,-1,-1,1),(2620,605,291,1,4,11,-1,-1,1),(2621,605,295,32,8,11,-1,-1,1),(2622,605,289,1,1,7,-1,-1,1),(2623,605,681,32,4,7,-1,-1,1),(2624,605,286,256,1,3,-1,-1,1),(2625,605,41,1,1,3,-1,-1,1),(2626,605,285,32,1,3,-1,-1,1),(2627,606,1589,1,58,255,-1,-1,1),(2628,606,3394,256,64,255,-1,-1,1),(2629,606,3397,8,65,255,-1,-1,1),(2630,606,172,8,63,255,-1,-1,1),(2631,606,3399,8,65,255,-1,-1,1),(2632,606,3380,1,61,255,-1,-1,1),(2633,606,3378,8,62,255,-1,-1,1),(2634,606,3233,2,62,255,-1,-1,1),(2635,606,3386,1,63,255,-1,-1,1),(2636,606,3385,1,63,255,-1,-1,1),(2637,606,3382,8,62,255,-1,-1,1),(2638,606,3390,1,64,255,-1,-1,1),(2639,606,3377,32,61,255,-1,-1,255),(2640,606,3395,1,65,255,-1,-1,1),(2641,606,3388,8,63,255,-1,-1,1),(2642,606,3396,256,65,255,-1,-1,1),(2643,606,3391,8,64,65,-1,-1,1),(2644,606,3235,8,62,64,-1,-1,1),(2645,606,1598,8,60,64,-1,-1,1),(2646,606,3381,8,62,64,-1,-1,1),(2647,606,3379,1,61,64,-1,-1,1),(2648,606,3387,1,63,64,-1,-1,1),(2649,606,2113,256,60,64,-1,-1,1),(2650,606,1586,1,54,63,-1,-1,1),(2651,606,1596,8,58,63,-1,-1,1),(2652,606,1591,256,59,63,-1,-1,1),(2653,606,3195,4,62,63,-1,-1,1),(2654,606,1578,1,60,62,-1,-1,1),(2655,606,1573,1,52,62,-1,-1,1),(2656,606,171,8,56,62,-1,-1,1),(2657,606,1593,8,57,62,-1,-1,1),(2658,606,1595,8,54,61,-1,-1,1),(2659,606,1599,8,59,61,-1,-1,1),(2660,606,1584,8,54,61,-1,-1,1),(2661,606,1579,8,53,61,-1,-1,1),(2662,606,1432,8,60,61,-1,-1,1),(2663,606,9,2,51,61,-1,-1,1),(2664,606,1592,1,53,60,-1,-1,1),(2665,606,1574,32,55,60,-1,-1,1),(2666,606,2527,1,54,60,-1,-1,1),(2667,606,1587,1,55,60,-1,-1,1),(2668,606,3574,1,54,60,-1,-1,1),(2669,606,2525,8,49,59,-1,-1,1),(2670,606,1590,256,56,59,-1,-1,1),(2671,606,1577,1,57,59,-1,-1,1),(2672,606,337,8,49,58,-1,-1,1),(2673,606,32,256,49,58,-1,-1,1),(2674,606,1588,1,51,57,-1,-1,1),(2716,606,157,8,49,57,-1,-1,1),(2718,606,133,4,56,57,-1,-1,1),(2719,606,159,8,49,56,-1,-1,1),(2749,606,112,1,49,56,-1,-1,1),(2790,606,436,256,49,55,-1,-1,1),(2791,606,132,4,51,55,-1,-1,1),(2846,606,170,8,44,55,-1,-1,1),(2871,606,49,1,44,54,-1,-1,1),(2880,606,1568,2,52,54,-1,-1,1),(2912,606,166,32,49,54,-1,-1,1),(2927,606,158,8,44,53,-1,-1,1),(3003,606,389,8,44,53,-1,-1,1),(3056,606,3573,1,49,53,-1,-1,1),(3151,606,510,1,44,53,-1,-1,1),(3152,606,154,8,44,52,-1,-1,1),(3153,606,163,1,44,52,-1,-1,1),(3154,606,145,8,39,51,-1,-1,1),(3155,606,527,1,39,51,-1,-1,1),(3156,606,507,1,39,50,-1,-1,1),(3157,606,131,4,34,50,-1,-1,1),(3158,606,326,8,34,48,-1,-1,1),(3159,606,1429,1,44,48,-1,-1,1),(3160,606,435,256,39,48,-1,-1,1),(3161,606,111,1,34,48,-1,-1,1),(3171,606,165,32,44,48,-1,-1,1),(3172,606,153,8,39,48,-1,-1,1),(3177,606,152,8,39,48,-1,-1,1),(3180,606,167,8,34,45,-1,-1,1),(3182,606,164,32,34,43,-1,-1,1),(3183,606,15,2,29,43,-1,-1,1),(3184,606,431,8,34,43,-1,-1,1),(3185,606,438,1,39,43,-1,-1,1),(3186,606,1427,1,34,43,-1,-1,1),(3191,606,160,8,34,43,-1,-1,1),(3212,606,161,8,34,43,-1,-1,1),(3217,606,509,1,34,43,-1,-1,1),(3227,606,162,1,29,43,-1,-1,1),(3228,606,228,8,19,43,-1,-1,1),(3229,606,39,8,29,43,-1,-1,1),(3230,606,201,1,1,38,-1,200,1),(3232,606,434,256,24,38,-1,-1,1),(3281,606,144,2,24,38,-1,-1,1),(3282,606,526,1,19,38,-1,-1,1),(3283,606,506,1,29,38,-1,-1,1),(3284,606,349,8,29,38,-1,-1,1),(3285,606,151,8,29,38,-1,-1,1),(3287,606,227,8,14,38,-1,-1,1),(3288,606,63,8,34,34,-1,-1,1),(3289,606,365,256,19,33,-1,-1,1),(3290,607,26,8,1,13,-1,-1,1),(3291,608,999,1,1,1,-1,-1,1),(3292,609,999,1,1,1,-1,-1,1),(3293,610,999,1,1,1,-1,-1,1),(3294,606,511,256,19,33,-1,-1,1),(3295,606,437,1,24,33,-1,-1,1),(3296,606,508,1,24,33,-1,-1,1),(3297,606,149,8,24,33,-1,-1,1),(3298,606,226,8,9,33,-1,-1,1),(3299,606,649,8,24,33,-1,-1,1),(3300,606,308,8,19,33,-1,-1,1),(3301,606,148,8,19,33,-1,-1,1),(3302,606,110,1,19,33,-1,-1,1),(3303,606,230,4,14,33,-1,-1,1),(3304,606,146,8,24,28,-1,-1,1),(3305,606,147,8,19,28,-1,-1,1),(3306,606,224,8,5,28,-1,-1,1),(3307,606,505,1,14,28,-1,-1,1),(3308,606,281,1,14,28,-1,-1,1),(3309,606,12,2,19,28,-1,-1,1),(3310,606,60,8,29,24,-1,-1,1),(3311,606,61,8,24,24,-1,-1,1),(3312,606,266,8,1,23,-1,-1,1),(3313,606,283,8,14,23,-1,-1,1),(3314,606,279,8,9,23,-1,-1,1),(3315,606,225,8,1,23,-1,-1,1),(3316,606,277,256,9,23,-1,-1,1),(3317,606,282,1,14,23,-1,-1,1),(3318,606,40,8,1,18,-1,-1,1),(3319,606,280,8,14,18,-1,-1,1),(3320,606,269,8,5,18,-1,-1,1),(3321,606,17,2,9,18,-1,-1,1),(3322,606,75,256,5,18,-1,-1,1),(3323,606,275,1,5,13,-1,-1,1),(3324,606,274,8,5,13,-1,-1,1),(3325,606,270,1,5,13,-1,-1,1),(3326,606,271,8,5,13,-1,-1,1),(3327,606,168,8,44,9,-1,-1,1),(3328,606,1585,8,55,9,-1,-1,1),(3329,606,93,1,1,9,-1,-1,1),(3330,606,200,2,1,8,-1,-1,1),(3331,606,267,8,1,4,-1,-1,1),(3332,607,239,256,1,28,-1,-1,1),(3333,607,200,2,1,8,-1,-1,1),(3334,607,93,1,1,4,-1,-1,1),(3335,607,224,8,1,23,-1,-1,1),(3336,607,242,128,1,28,-1,-1,1),(3337,607,92,1,5,8,-1,-1,1),(3338,607,249,4,5,23,-1,-1,1),(3339,607,252,1,5,18,-1,-1,1),(3340,607,268,8,9,33,-1,-1,1),(3341,607,17,2,9,18,-1,-1,1),(3342,607,256,8,9,18,-1,-1,1),(3343,607,515,8,9,18,-1,-1,1),(3344,607,91,1,9,28,-1,-1,1),(3345,607,225,8,9,30,-1,-1,1),(3346,607,264,256,14,23,-1,-1,1),(3347,607,262,1,14,23,-1,-1,1),(3348,607,263,8,14,23,-1,-1,1),(3349,607,278,8,14,255,-1,-1,1),(3350,607,1392,1,19,33,-1,-1,1),(3351,607,273,8,19,28,-1,-1,1),(3352,607,516,8,19,28,-1,-1,1),(3353,607,12,2,19,28,-1,-1,1),(3354,607,226,8,19,43,-1,-1,1),(3355,607,76,4,24,38,-1,-1,1),(3356,607,421,8,24,38,-1,-1,1),(3357,607,405,1,24,33,-1,-1,1),(3358,607,99,256,24,23,-1,-1,1),(3359,607,27,1,24,38,-1,-1,1),(3360,607,512,128,29,56,-1,-1,1),(3361,607,517,8,29,38,-1,-1,1),(3362,607,217,1,29,43,-1,-1,1),(3363,607,129,8,29,38,-1,-1,1),(3364,607,78,256,29,51,-1,-1,1),(3365,607,15,2,29,43,-1,-1,1),(3366,607,144,2,34,43,-1,-1,1),(3367,607,228,8,34,48,-1,-1,1),(3368,607,429,8,34,55,-1,-1,1),(3369,607,418,1,34,48,-1,-1,1),(3370,607,259,256,34,43,-1,-1,1),(3371,607,406,1,34,50,-1,-1,1),(3372,607,518,8,39,48,-1,-1,1),(3373,607,422,8,39,48,-1,-1,1),(3374,607,432,8,39,48,-1,-1,1),(3375,607,490,4,39,48,-1,-1,1),(3376,607,28,1,39,43,-1,-1,1),(3377,607,1437,1,39,43,-1,-1,1),(3378,607,3695,1,44,53,-1,-1,1),(3379,607,49,1,44,54,-1,-1,1),(3380,607,1740,1,44,48,-1,-1,1),(3381,607,1436,1,44,51,-1,-1,1),(3382,607,665,256,44,52,-1,-1,1),(3383,607,145,8,44,54,-1,-1,1),(3384,607,430,8,44,55,-1,-1,1),(3385,607,3834,2,44,50,-1,-1,1),(3386,607,29,1,49,53,-1,-1,1),(3387,607,671,1,49,53,-1,-1,1),(3388,607,77,4,49,55,-1,-1,1),(3389,607,420,1,49,57,-1,-1,1),(3390,607,519,8,49,55,-1,-1,1),(3391,607,356,8,49,57,-1,-1,1),(3392,607,433,1,49,60,-1,-1,1),(3393,607,423,8,49,255,-1,-1,1),(3394,607,9,2,51,59,-1,-1,1),(3395,607,1542,1,51,60,-1,-1,1),(3396,607,1600,256,52,61,-1,-1,1),(3397,607,1601,256,53,62,-1,-1,1),(3398,607,1603,1,53,58,-1,-1,1),(3399,607,1602,1,54,59,-1,-1,1),(3400,607,1475,32,55,255,-1,-1,1),(3401,607,1290,2,55,59,-1,-1,1),(3402,607,1557,8,55,255,-1,-1,1),(3403,607,1719,4,56,59,-1,-1,1),(3404,607,2518,1,56,61,-1,-1,1),(3405,607,1558,8,56,63,-1,-1,1),(3406,607,1767,128,57,60,-1,-1,1),(3407,607,1559,8,57,255,-1,-1,1),(3408,607,1605,1,57,59,-1,-1,1),(3409,607,1606,1,58,60,-1,-1,1),(3410,607,1560,8,58,62,-1,-1,1),(3411,607,1607,1,59,63,-1,-1,1),(3412,607,1608,128,60,60,-1,-1,1),(3413,607,2520,2,60,255,-1,-1,1),(3414,607,2877,1,60,64,-1,-1,1),(3415,607,1291,2,60,62,-1,-1,1),(3416,607,3473,1,61,255,-1,-1,1),(3417,607,3192,128,61,63,-1,-1,1),(3418,607,3434,1,61,255,-1,-1,1),(3419,607,3439,8,62,255,-1,-1,1),(3420,607,3437,256,62,255,-1,-1,1),(3421,607,3448,8,63,255,-1,-1,1),(3422,607,3443,2,63,255,-1,-1,1),(3423,607,3446,256,63,255,-1,-1,1),(3424,607,3449,1,64,255,-1,-1,1),(3425,607,3450,8,64,64,-1,-1,1),(3426,607,3447,128,64,255,-1,-1,1),(3427,607,3452,1,65,255,-1,-1,1);
/*!40000 ALTER TABLE `npc_spells_entries` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2008-05-09  1:11:43

Vulok · #**514** 05-17-2008, 12:00 AM

Howdy,

Sorry if I missed this, tried reading and searching. But, was going to start a server with a friend and just co-op the game and was wondering if the bots were possible to download and use.

Was thinking of a healer of some sort to spice up the game some, and was wondering if there was a download or a guide somewhere I could use.

Thanks and sorry again if I missed a post that covered this.

aknosis · #**515** 05-17-2008, 01:06 AM

I believe you can get it here:

http://eqoffline.free.fr/

Aramid · #**516** 05-17-2008, 07:17 AM

Quote:

Originally Posted by Vulok

Howdy,

Sorry if I missed this, tried reading and searching. But, was going to start a server with a friend and just co-op the game and was wondering if the bots were possible to download and use.

Was thinking of a healer of some sort to spice up the game some, and was wondering if there was a download or a guide somewhere I could use.

Thanks and sorry again if I missed a post that covered this.

The latest source as of May 17, 2008, can be found here

http://www.cerebus.net:8080//files/d...108BotsSrc.zip

Vulok · #**517** 05-17-2008, 02:23 PM

Thanks!

I haven't reloaded a server but will do so today or tommorow. Thanks again for the bot links!

Will do my best to get the up and going.

Thanks again

Aramid · #**518** 05-17-2008, 03:39 PM

Quote:

Originally Posted by Vulok

Thanks!

I haven't reloaded a server but will do so today or tommorow. Thanks again for the bot links!

Will do my best to get the up and going.

Thanks again

There are some things you will need to do to make the BOT Source work. 1st of all, you only need to compile the ZONE folder that it comes with, however, b4 you compile it, you need to change the makefile and makefile.common in the zone folder with the following changes...

In makefile find this

Code:

DFLAGS=-DEQDEBUG=5 -DCATCH_CRASH -DNO_PIDLOG -DSHAREMEM -DSPELL_EFFECT_SPAM -DFIELD_ITEMS -DCOMBINED -DAPP_OPCODE_SIZE=2 -Di386

and change it to this

Code:

DFLAGS=-DEQDEBUG=5 -DCATCH_CRASH -DNO_PIDLOG -DSHAREMEM -DSPELL_EFFECT_SPAM -DFIELD_ITEMS -DCOMBINED -DAPP_OPCODE_SIZE=2 -Di386 -DEQBOTS

in makefile.common

Code:

../common/guild_base.o guild_mgr.o

becomes

Code:

../common/guild_base.o guild_mgr.o botRaids.o botAI.o petAI.o

Once compiled, just copy the compiled ZONE file to your server folder and run your server.

Vulok · #**519** 05-18-2008, 02:40 PM

Thanks,

Will do soon as I get around this active Perl issue. I used the older version like the post mentioned just that the binary form of it is throwing me off.

Will get it figured out soon enough, gonna make some lunch now.

Thanks again for the info, was curious how to use all that data.

Thanks!

Vulok · #**520** 05-19-2008, 05:55 PM

What compile method should I use to get that folder to a Zone.exe I run vista and dont have a right click compile feature. Have a compress and what not

thanks in advance

Andrew80k · #**521** 05-19-2008, 09:21 PM

if the binaries work on Vista, why don't you just download them? Do you have a compiler? VC Express is free and works if you don't.

Aramid · #**522** 05-20-2008, 01:02 PM

Yes, just download the compiled version, what I mentioned above was for Linux. I use Linux, so I figured everyone did .. lol

Vulok · #**523** 05-23-2008, 04:11 PM

Well had a slight unforseen setback...

My mobo crashed on me, so had to order a new one. Then I said screw that so I upgraded processor and mobo so should be rocking next week. Hopefully Tues.

On a friends laptop right now, thanks for the posts of help. I will start on this again, in a few days.

Why would I want to use a stable Linux server? When I can run a confusing Windows server thats caused a few problems for me, jeez

On an off note, did try a server with bots. They stayed on lvl 1, and were naked the whole time. That a common thing?

Thanks

Aramid · #**524** 05-24-2008, 12:31 AM

Each time you Level, enter this command after targeting a bot

#bot update

Do this for each Bot.

This will update the bot to your level, but will not change their con color until you kill/respawn them. If you give them Armor, they will keep it and you will see it when you group with them. They don't come with any by default.
Also, just logging out or zoning will cause you to respawn the bots and they will be updated to your level.

Vulok · #**525** 05-25-2008, 05:59 PM

Thanks again for all the help and info.

Will start this back up Tues. and hopefully should be rocking out quite well.

thanks again