Compartilhe
Ir em baixo
avatar

Mensagens : 34
Pontos : 135
Ver perfil do usuário

[SQL]Cemitério Ally/Horda

em Sex 22 Jul 2011 - 13:25
Reputação da mensagem: 100% (6 votos)
Fiz um SQL para quando algum ally vai para Orgrimmar não ir para um cemitério muito longe, mesma coisa para os hordas quando vão para Stormwind.

Faça um backup de sua DB antes pois não sei se o script é compativel com todos os emuladores.

Fiz este script com este repack:
[Você precisa estar registrado e conectado para ver este link.]


Screens:
EM BREVE

Execute este script na sua DB World:

SQL:
Spoiler:
replace into `game_graveyard_zone`(`id`,`ghost_zone`,`faction`) values (100,1,469),(101,1,469),(103,3,67),(104,10,67),(854,1519,67),(104,44,0),(105,12,0),(106,12,0),(569,28,67),(107,1519,0),(108,8,67),(109,33,0),(149,130,469),(149,267,469),(149,36,469),(39,722,0),(189,15,469),(1308,3456,0),(97,209,0),(909,139,0),(209,440,0),(209,1941,0),(229,17,0),(429,796,0),(869,2057,0),(249,1638,469),(249,17,67),(249,215,469),(289,85,67),(3,10,469),(309,357,469),(189,2159,469),(310,357,67),(32,14,0),(329,400,0),(850,2917,67),(34,215,0),(349,47,469),(35,148,469),(36,41,0),(369,16,0),(370,4,0),(370,8,469),(389,33,0),(92,719,0),(850,2437,0),(39,400,0),(4,40,0),(512,719,0),(409,406,0),(429,2057,0),(449,361,0),(450,490,0),(469,141,67),(469,148,469),(469,1657,67),(489,11,0),(510,139,0),(511,618,0),(512,148,67),(850,1637,0),(512,17,469),(512,331,0),(569,85,67),(6,38,469),(609,16,0),(509,28,469),(629,85,469),(629,2057,0),(630,16,0),(631,15,67),(1308,65,0),(633,493,0),(635,361,0),(649,14,0),(7,1,67),(7,11,0),(7,38,67),(789,47,67),(8,3,0),(8,38,67),(829,28,0),(849,357,0),(92,331,0),(850,14,0),(851,1638,67),(851,215,67),(852,1,469),(631,2159,67),(89,215,67),(90,1657,469),(91,141,469),(910,3429,0),(911,10,0),(93,141,469),(94,85,67),(96,85,67),(97,130,67),(39,491,0),(98,267,67),(98,36,67),(99,45,0),(669,22,0),(670,22,0),(671,22,0),(529,22,0),(751,2597,469),(749,2597,67),(750,2597,67),(610,2597,67),(611,2597,469),(689,2597,0),(729,2597,469),(829,2597,0),(830,2597,0),(169,2597,0),(769,3277,469),(770,3277,67),(771,3277,469),(772,3277,67),(809,3277,0),(810,3277,0),(889,3358,67),(890,3358,469),(891,3358,0),(892,3358,0),(893,3358,67),(894,3358,0),(895,3358,469),(896,3358,0),(897,3358,0),(898,3358,469),(899,3358,67),(10,718,0),(709,14,0),(926,3525,0),(922,3430,0),(915,3433,0),(923,3524,0),(919,3483,67),(928,3521,469),(926,3557,0),(1047,3520,67),(1049,3522,469),(925,3525,0),(992,3518,0),(995,3519,0),(1045,3523,0),(921,3487,0),(994,3703,0),(106,717,0),(1048,3520,469),(994,3519,0),(1042,3519,0),(1051,3519,0),(920,3483,469),(933,3483,469),(934,3483,67),(1040,3483,0),(1240,3483,469),(1248,3483,67),(930,3518,0),(1037,3518,0),(1038,3518,0),(1039,3518,0),(970,3521,67),(973,3521,0),(1043,3521,469),(1044,3521,0),(1050,3522,67),(1241,3522,0),(1242,3522,0),(1243,3522,0),(1244,3522,0),(1046,3523,0),(1247,3523,0),(918,3524,0),(924,3524,0),(912,3430,0),(914,3430,0),(921,3430,0),(916,3433,0),(917,3433,0),(10,17,67),(209,1176,0),(918,3557,0),(924,3557,0),(8,1337,0),(913,3478,0),(70,1377,0),(910,1377,0),(149,209,0),(108,1417,0),(1257,3519,0),(849,2557,0),(31,405,0),(31,2100,0),(1307,65,0),(970,3717,469),(928,3717,67),(970,3716,469),(928,3716,67),(970,3715,469),(928,3715,67),(970,3607,469),(928,3607,67),(1042,3789,0),(1042,3791,0),(1042,3792,0),(1042,3790,0),(1247,3847,0),(1247,3848,0),(1247,3845,0),(1247,3849,0),(920,3713,469),(919,3713,67),(920,3562,469),(919,3562,67),(920,3535,469),(919,3535,67),(920,3836,469),(919,3836,67),(919,3714,469),(920,3714,67),(913,3429,0),(913,3428,0),(129,141,0),(1256,130,0),(634,139,0),(108,1477,0),(309,1477,0),(36,3457,0),(4,1581,0),(389,1581,0),(389,1977,0),(636,51,0),(909,2017,0),(107,2918,0),(1249,3606,0),(1249,2366,0),(1261,3959,469),(1262,3959,67),(917,3805,0),(854,12,0),(1041,3483,0),(1249,2367,0),(1250,3520,0),(1251,3520,0),(1252,3523,0),(1253,3522,469),(1254,3522,0),(1255,3522,0),(1264,15,0),(1265,15,0),(1277,490,0),(1278,490,0),(1279,406,0),(1280,406,0),(1281,440,0),(1282,440,0),(1283,618,0),(1284,618,0),(1285,36,0),(1286,28,0),(1287,51,0),(1288,3,0),(1289,17,67),(101,721,0),(1291,3519,0),(1292,4080,0),(1293,4131,0),(1293,4075,0),(1298,3519,0),(90,141,469),(942,3540,0),(943,3540,0),(944,3540,0),(945,3540,0),(946,3540,0),(947,3540,0),(948,3540,0),(949,3540,0),(950,3540,0),(951,3540,0),(952,3540,0),(953,3540,0),(954,3540,0),(955,3540,0),(956,3540,0),(957,3540,0),(958,3540,0),(959,3540,0),(960,3540,0),(961,3540,0),(962,3540,0),(963,3540,0),(964,3540,0),(965,3540,0),(966,3540,0),(967,3540,0),(968,3540,0),(972,3540,0),(974,3540,0),(975,3540,0),(976,3540,0),(977,3540,0),(978,3540,0),(979,3540,0),(980,3540,0),(981,3540,0),(982,3540,0),(983,3540,0),(984,3540,0),(985,3540,0),(986,3540,0),(987,3540,0),(988,3540,0),(989,3540,0),(990,3540,0),(991,3540,0),(999,3540,0),(1000,3540,0),(1001,3540,0),(1002,3540,0),(1003,3540,0),(1004,3540,0),(1005,3540,0),(1006,3540,0),(1007,3540,0),(1008,3540,0),(1009,3540,0),(1010,3540,0),(1011,3540,0),(1012,3540,0),(1013,3540,0),(1014,3540,0),(1015,3540,0),(1016,3540,0),(1017,3540,0),(1018,3540,0),(1019,3540,0),(1020,3540,0),(1021,3540,0),(1022,3540,0),(1023,3540,0),(1028,3540,0),(1029,3540,0),(1030,3540,0),(1031,3540,0),(1032,3540,0),(1033,3540,0),(1034,3540,0),(1035,3540,0),(1024,3540,0),(1025,3540,0),(1026,3540,0),(1027,3540,0),(1052,3540,0),(1053,3540,0),(1054,3540,0),(1055,3540,0),(1056,3540,0),(1057,3540,0),(1058,3540,0),(1059,3540,0),(1060,3540,0),(1061,3540,0),(1062,3540,0),(1063,3540,0),(1064,3540,0),(1065,3540,0),(1066,3540,0),(1067,3540,0),(1068,3540,0),(1069,3540,0),(1070,3540,0),(1072,3540,0),(1073,3540,0),(1074,3540,0),(1075,3540,0),(1076,3540,0),(1077,3540,0),(1078,3540,0),(1079,3540,0),(1080,3540,0),(1081,3540,0),(1082,3540,0),(1083,3540,0),(1084,3540,0),(1085,3540,0),(1086,3540,0),(1087,3540,0),(1088,3540,0),(1089,3540,0),(1090,3540,0),(1091,3540,0),(1092,3540,0),(1093,3540,0),(1094,3540,0),(1095,3540,0),(1096,3540,0),(1097,3540,0),(1098,3540,0),(1099,3540,0),(1100,3540,0),(1101,3540,0),(1102,3540,0),(1134,3540,0),(1135,3540,0),(1136,3540,0),(1137,3540,0),(1138,3540,0),(1139,3540,0),(1140,3540,0),(1141,3540,0),(1142,3540,0),(1143,3540,0),(1144,3540,0),(1145,3540,0),(1146,3540,0),(1147,3540,0),(1148,3540,0),(1149,3540,0),(1150,3540,0),(1151,3540,0),(1152,3540,0),(1153,3540,0),(1154,3540,0),(1155,3540,0),(1156,3540,0),(1157,3540,0),(1158,3540,0),(1159,3540,0),(1160,3540,0),(1161,3540,0),(1162,3540,0),(1163,3540,0),(1164,3540,0),(1165,3540,0),(1166,3540,0),(1167,3540,0),(1168,3540,0),(1169,3540,0),(1170,3540,0),(1171,3540,0),(1172,3540,0),(1173,3540,0),(1174,3540,0),(1175,3540,0),(1176,3540,0),(1177,3540,0),(1178,3540,0),(1179,3540,0),(1180,3540,0),(1181,3540,0),(1182,3540,0),(1183,3540,0),(1184,3540,0),(1185,3540,0),(1186,3540,0),(1187,3540,0),(1188,3540,0),(1189,3540,0),(1190,3540,0),(1191,3540,0),(1192,3540,0),(1193,3540,0),(1194,3540,0),(1195,3540,0),(1196,3540,0),(1197,3540,0),(1198,3540,0),(1199,3540,0),(1200,3540,0),(1201,3540,0),(1202,3540,0),(1203,3540,0),(1204,3540,0),(1205,3540,0),(1206,3540,0),(1207,3540,0),(1208,3540,0),(1209,3540,0),(1210,3540,0),(1211,3540,0),(1212,3540,0),(1213,3540,0),(1214,3540,0),(1215,3540,0),(1216,3540,0),(1217,3540,0),(1218,3540,0),(1219,3540,0),(1220,3540,0),(1221,3540,0),(1222,3540,0),(1223,3540,0),(1224,3540,0),(1225,3540,0),(1226,3540,0),(1227,3540,0),(1228,3540,0),(1229,3540,0),(1230,3540,0),(1231,3540,0),(1232,3540,0),(1233,3540,0),(1234,3540,0),(1235,3540,0),(1236,3540,0),(1237,3540,0),(1238,3540,0),(1239,3540,0),(1376,206,0),(1337,1196,0),(1266,495,0),(1267,495,0),(1268,495,0),(1269,495,0),(1270,495,0),(1271,495,67),(1272,495,0),(1273,495,0),(1274,495,0),(1275,495,469),(1276,495,0),(1319,4265,0),(1317,3537,67),(1318,3537,0),(1319,3537,0),(1320,3537,0),(1321,3537,469),(1322,3537,67),(1323,3537,0),(1324,3537,67),(1325,3537,0),(1326,3537,469),(1290,3537,0),(1411,36,0),(1409,85,469),(1372,490,0),(1360,4298,0),(1370,4298,0),(1371,4298,0),(1359,2817,0),(1300,394,0),(1301,394,0),(1302,394,0),(1303,394,0),(1304,394,0),(1305,394,0),(1306,394,0),(1309,65,0),(1310,65,0),(1311,65,0),(1312,65,0),(1313,65,0),(1314,65,0),(1315,65,67),(1316,65,469),(1328,4197,0),(1329,4197,0),(1330,4197,0),(1331,4197,67),(1332,4197,469),(1333,4197,0),(1334,4197,0),(1336,3711,0),(1341,3711,0),(1342,3711,0),(1343,3711,0),(1344,3711,0),(1345,3711,0),(1352,66,0),(1353,66,0),(1354,66,0),(1355,66,0),(1356,66,0),(1357,66,0),(1358,66,0),(1369,139,0),(1379,3711,0),(1380,2817,469),(1381,210,0),(1383,67,0),(1384,67,0),(1385,67,0),(1387,67,0),(1388,67,0),(1391,2817,0),(1392,2817,469),(1393,65,0),(1394,65,0),(1395,210,0),(1396,210,0),(1397,210,0),(1398,394,0),(1400,67,0),(1401,67,0),(1402,67,0),(1403,67,0),(1404,3711,0),(1405,139,0),(1407,210,0),(1408,67,0),(1416,618,0),(1417,618,0),(1418,618,0),(1419,16,0),(1420,16,0),(1421,405,0),(1422,405,0),(1423,405,0),(1424,405,0),(1425,405,0),(1426,331,0),(1427,331,0),(1428,406,0),(1429,406,0),(1430,17,0),(1431,17,0),(1432,17,0),(1433,17,0),(1434,17,0),(1435,215,0),(1436,215,0),(1437,400,0),(1438,400,0),(1439,440,0),(1440,440,0),(1441,357,0),(1442,357,0),(1443,357,0),(1444,1377,0),(1445,1377,0),(1446,45,0),(1447,267,0),(1448,139,0),(1449,139,0),(1450,139,0),(1451,139,0),(1452,267,0),(1453,47,0),(1454,47,0),(1455,11,0),(1456,11,0),(1457,11,0),(1458,33,0),(1459,33,0),(1460,33,0),(1461,10,0),(1462,40,0),(1463,40,0),(1464,4,0),(1465,8,0),(1466,8,0),(1467,44,0),(1468,12,0),(1469,46,0),(1470,46,0),(1471,1,0),(1472,1,0),(1473,38,0),(1474,4603,0),(1319,4228,0),(1319,4500,0),(1314,4493,0),(1384,4272,0),(1384,4264,0),(1358,4416,0),(1398,4196,0),(1359,4415,0),(1359,4395,0),(1394,4277,0),(1394,4494,0),(32,1637,0),(1323,3979,0),(1478,4722,0),(1478,4742,0),(1478,4723,0),(1384,4273,0),(927,139,0),(993,3518,0),(969,3521,0),(969,3459,0),(1682,4809,0),(1682,4812,0),(1682,4813,0),(1682,4820,0),(1249,4100,0),(869,28,0),(1314,4987,0),(96,1497,67),(1469,25,0),(1469,2677,0),(1469,1584,0),(1469,2717,0),(1469,1583,0),(101,1537,67),(1241,3923,0),(500000,0,0),(0,0,0);


Última edição por arturcs em Dom 24 Jul 2011 - 11:25, editado 3 vez(es)
avatar

Mensagens : 490
Pontos : 4102
Ver perfil do usuáriohttp://bgames.com.br/f55-world-of-warcraft-gaming

Re: [SQL]Cemitério Ally/Horda

em Sex 22 Jul 2011 - 13:27
coloque uns prints de onde o char vai nascer :S, e muito obrigado pelo Tópico :D
avatar

Mensagens : 679
Pontos : 679
Evolução : 2

Ver perfil do usuáriohttp://www.hostbrazill.com/

Re: [SQL]Cemitério Ally/Horda

em Sab 23 Jul 2011 - 19:03
Funciono (y)'

Primeiro vc Precisa Deletar o que está dentro da pasta game_graveyard_zone
e depois vc Roda a SQl ai de cima so assim vai funcionar !
avatar

Mensagens : 1375
Pontos : 8955
Evolução : 3




Ver perfil do usuáriohttp://www.bgames.com.br/

Re: [SQL]Cemitério Ally/Horda

em Sab 23 Jul 2011 - 23:14
muito bom esse script!
~+~
avatar

Mensagens : 10
Pontos : 35
Ver perfil do usuário

Re: [SQL]Cemitério Ally/Horda

em Dom 24 Jul 2011 - 3:45
Eu to tentando upar aqui no meu DB mas não vai..
O que eu faço ?
avatar

Mensagens : 34
Pontos : 135
Ver perfil do usuário

Re: [SQL]Cemitério Ally/Horda

em Dom 24 Jul 2011 - 11:25
Springle escreveu:Eu to tentando upar aqui no meu DB mas não vai..
O que eu faço ?

Corrigi o script, tente agora que irá funcionar.
avatar

Mensagens : 84
Pontos : 343
Evolução : 2

Ver perfil do usuáriohttp://repackangelwow.hol.es/

Re: [SQL]Cemitério Ally/Horda

em Sab 17 Mar 2012 - 22:52
Não to conseguindo baixar o script da erro na página. tem outro link não?
avatar

Mensagens : 319
Pontos : 1511
Ver perfil do usuário

Re: [SQL]Cemitério Ally/Horda

em Dom 18 Mar 2012 - 0:18
muito bom Obrigado por compartilhar com a galera.
avatar

Mensagens : 217
Pontos : 606
Ver perfil do usuário

Re: [SQL]Cemitério Ally/Horda

em Sab 7 Abr 2012 - 17:49
muito bom gostei
Conteúdo patrocinado

Re: [SQL]Cemitério Ally/Horda

Voltar ao Topo
Permissão deste fórum:
Você não pode responder aos tópicos neste fórum