SORUNSUZ ADREAM

Kendi ardream databasemi editlerken kullandığım kodları paylaşıyorum

İlk önce full gereksiz ne varsa silelim :


Kod:
TRUNCATE TABLE ZONE_INFO
TRUNCATE TABLE START_POSITION
DELETE K_NPCPOS WHERE ZoneID ='11'
DELETE K_NPCPOS WHERE ZoneID ='12'
DELETE K_NPCPOS WHERE ZoneID ='30'
DELETE K_NPCPOS WHERE ZoneID ='31'
DELETE K_NPCPOS WHERE ZoneID ='32'
DELETE K_NPCPOS WHERE ZoneID ='33'
DELETE K_NPCPOS WHERE ZoneID ='34'
DELETE K_NPCPOS WHERE ZoneID ='48'
DELETE K_NPCPOS WHERE ZoneID ='51'
DELETE K_NPCPOS WHERE ZoneID ='52'
DELETE K_NPCPOS WHERE ZoneID ='53'
DELETE K_NPCPOS WHERE ZoneID ='54'
DELETE K_NPCPOS WHERE ZoneID ='55'
DELETE K_NPCPOS WHERE ZoneID ='62'
DELETE K_NPCPOS WHERE ZoneID ='63'
DELETE K_NPCPOS WHERE ZoneID ='64'
DELETE K_NPCPOS WHERE ZoneID ='66'
DELETE K_NPCPOS WHERE ZoneID ='71'
DELETE K_NPCPOS WHERE ZoneID ='72'
DELETE K_NPCPOS WHERE ZoneID ='91'
DELETE K_NPCPOS WHERE ZoneID ='100'
DELETE K_NPCPOS WHERE ZoneID ='102'
DELETE K_NPCPOS WHERE ZoneID ='103'
DELETE K_NPCPOS WHERE ZoneID ='111'
DELETE K_NPCPOS WHERE ZoneID ='201'
DELETE K_NPCPOS WHERE ZoneID ='202'
delete from LEVEL_UP where level = 61
delete from LEVEL_UP where level = 62
delete from LEVEL_UP where level = 63
delete from LEVEL_UP where level = 64
delete from LEVEL_UP where level = 65
delete from LEVEL_UP where level = 66
delete from LEVEL_UP where level = 67
delete from LEVEL_UP where level = 68
delete from LEVEL_UP where level = 69
delete from LEVEL_UP where level = 70
delete from LEVEL_UP where level = 71
delete from LEVEL_UP where level = 72
delete from LEVEL_UP where level = 73
delete from LEVEL_UP where level = 74
delete from LEVEL_UP where level = 75
delete from LEVEL_UP where level = 76
delete from LEVEL_UP where level = 77
delete from LEVEL_UP where level = 78
delete from LEVEL_UP where level = 79
delete from LEVEL_UP where level = 80
START_POSITION tablomuzu düzenleyelim


Kod:
-- Nero Sorunsuz Ardream Database Edit / START_POSITION
INSERT INTO START_POSITION VALUES (1 , 441 , 1625 , 1859 , 170 , 10 , 10 , 0 , 0 , 0 , 0)
INSERT INTO START_POSITION VALUES (2 , 219 , 1859 , 1595 , 412 , 10 , 10 , 0 , 0 , 0 , 0)
INSERT INTO START_POSITION VALUES (21 , 306 , 352 , 306 , 352 , 10 , 10 , 0 , 0 , 0 , 0)
INSERT INTO START_POSITION VALUES (48 , 128 , 120 , 128 , 120 , 5 , 5 , 0 , 0 , 0 , 0)
INSERT INTO START_POSITION VALUES (101 , 820 , 98 , 113 , 771 , 5 , 5 , 0 , 0 , 0 , 0)
INSERT INTO START_POSITION VALUES (201 , 848 , 129 , 183 , 898 , 5 , 5 , 0 , 0 , 0 , 0)
ZONE_INFO tablomuzu düzenleyelim :


Kod:
-- Nero Sorunsuz Ardream Database Edit / ZONE_INFO
INSERT INTO ZONE_INFO VALUES (1 , 1 , 'karus_0730.smd' , 163000 , 39400 , 15000 , 1 , 0 , 'Karus')
INSERT INTO ZONE_INFO VALUES (1 , 2 , 'elmorad_1220.smd' , 163000 , 39400 , 15000 , 1 , 0 , 'Elmorad')
INSERT INTO ZONE_INFO VALUES (1 , 21 , 'moradon_0826.smd' , 31200 , 40200 , 0 , 1 , 0 , 'Moradon')
INSERT INTO ZONE_INFO VALUES (1 , 48 , 'clanfight48_0520.smd' , 128 , 123 , 0 , 0 , 0 , 'Battle Arena')
INSERT INTO ZONE_INFO VALUES (1 , 101 , 'battle1_1111.smd' , 1000 , 1000 , 0 , 2 , 0 , 'Lunar War')
INSERT INTO ZONE_INFO VALUES (1 , 201 , 'ardream.smd' , 1000 , 1000 , 0 , 2 , 0 , 'Ardream')
Adam ölünce kordinatları geçsin istiyorsanız :


Kod:
-- Nero Sorunsuz Ardream Database Edit / SERVER_RESOURCE
UPDATE SERVER_RESOURCE SET strResource = '*** %s has defeated %s (x,y: %d, %d ) ***' WHERE strName ='IDS_DEATH_ANNOUNCEMENT'
Guard Tower & NPC'lerimizi ekleyelim :


Kod:
-- Nero Sorunsuz Ardream Database Edit / K_NPCPOS
INSERT INTO K_NPCPOS VALUES ( 201, 5300, 104, 0, 0, 0, 0, 161, 894, 161, 894, 161, 894, 161, 894, 1, 90, 0, 0, 'NULL' )
INSERT INTO K_NPCPOS VALUES ( 201, 5300, 104, 0, 0, 0, 0, 149, 914, 149, 914, 149, 914, 149, 914, 1, 90, 0, 0, 'NULL' )
INSERT INTO K_NPCPOS VALUES ( 201, 5300, 104, 0, 0, 0, 0, 113, 883, 113, 883, 113, 883, 113, 883, 1, 90, 0, 0, 'NULL' )
INSERT INTO K_NPCPOS VALUES ( 201, 5300, 104, 0, 0, 0, 0, 222, 900, 222, 900, 222, 900, 222, 900, 1, 90, 0, 0, 'NULL' )
INSERT INTO K_NPCPOS VALUES ( 201, 5300, 104, 0, 0, 0, 0, 219, 913, 219, 913, 219, 913, 219, 913, 1, 90, 0, 0, 'NULL' )
INSERT INTO K_NPCPOS VALUES ( 201, 5300, 104, 0, 0, 0, 0, 138, 870, 138, 870, 138, 870, 138, 870, 1, 90, 0, 0, 'NULL' )
INSERT INTO K_NPCPOS VALUES ( 201, 5300, 104, 0, 0, 0, 0, 213, 872, 213, 872, 213, 872, 213, 872, 1, 90, 0, 0, 'NULL' )
INSERT INTO K_NPCPOS VALUES ( 201, 5300, 104, 0, 0, 0, 0, 193, 871, 193, 871, 193, 871, 193, 871, 1, 90, 0, 0, 'NULL' )
INSERT INTO K_NPCPOS VALUES ( 201, 5300, 104, 0, 0, 0, 0, 182, 873, 182, 873, 182, 873, 182, 873, 1, 90, 0, 0, 'NULL' )
INSERT INTO K_NPCPOS VALUES ( 201, 5400, 104, 0, 0, 0, 0, 788, 82, 788, 82, 788, 82, 788, 82, 1, 90, 0, 0, 'NULL' )
INSERT INTO K_NPCPOS VALUES ( 201, 5400, 104, 0, 0, 0, 0, 799, 130, 799, 130, 799, 130, 799, 130, 1, 90, 0, 0, 'NULL' )
INSERT INTO K_NPCPOS VALUES ( 201, 5400, 104, 0, 0, 0, 0, 785, 115, 785, 115, 785, 115, 785, 115, 1, 90, 0, 0, 'NULL' )
INSERT INTO K_NPCPOS VALUES ( 201, 5400, 104, 0, 0, 0, 0, 803, 113, 803, 113, 803, 113, 803, 113, 1, 90, 0, 0, 'NULL' )
INSERT INTO K_NPCPOS VALUES ( 201, 5400, 104, 0, 0, 0, 0, 821, 150, 821, 150, 821, 150, 821, 150, 1, 90, 0, 0, 'NULL' )
INSERT INTO K_NPCPOS VALUES ( 201, 5400, 104, 0, 0, 0, 0, 831, 161, 831, 161, 831, 161, 831, 161, 1, 90, 0, 0, 'NULL' )
INSERT INTO K_NPCPOS VALUES ( 201, 5400, 104, 0, 0, 0, 0, 848, 154, 848, 154, 848, 154, 848, 154, 1, 90, 0, 0, 'NULL' )
INSERT INTO K_NPCPOS VALUES ( 201, 5400, 104, 0, 0, 0, 0, 871, 148, 871, 148, 871, 148, 871, 148, 1, 90, 0, 0, 'NULL' )
INSERT INTO K_NPCPOS VALUES ( 201, 16096, 140, 0, 0, 0, 0, 193, 910, 193, 910, 193, 910, 193, 910, 1, 90, 0, 0, 'NULL' )
INSERT INTO K_NPCPOS VALUES ( 201, 22120, 140, 0, 0,0, 0, 855, 137, 855, 137, 855, 137, 855, 137, 1, 90, 0, 0, 'NULL' )
INSERT INTO K_NPCPOS VALUES ( 201, 16096, 140, 0, 0, 0, 0, 850, 132, 850, 132, 850, 132, 850, 132, 1, 90, 0, 0, 'NULL' )
INSERT INTO K_NPCPOS VALUES ( 201, 12120, 140, 0, 0, 0, 0, 187, 910, 187, 910, 187, 910, 187, 910, 1, 90, 0, 0, 'NULL' )
Guard Tower Attack Ayarlarımızı Yapalım :


Kod:
--Nero Sorunsuz Ardream Database Edit / MAGIC_TYPE3
UPDATE MAGIC_TYPE3
SET FirstDamage = -10000
WHERE (iNum = 300139)
Usko Orjinal Monster K_NPCPOS tablomuzu ekleyelim :


Kod:
-- --Nero Sorunsuz Ardream Database Edit / Usko Monster NPCPOS
insert into K_NPCPOS values (201 , 503 , 1 , 0 , 0 , 0 , 0 , 456 , 908 , 476 , 896 , 908 , 456 , 476 , 896 , 10 , 100 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 1701 , 1 , 0 , 0 , 0 , 0 , 948 , 850 , 972 , 826 , 850 , 948 , 972 , 826 , 5 , 100 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 2102 , 1 , 0 , 0 , 0 , 0 , 218 , 358 , 244 , 318 , 358 , 218 , 244 , 318 , 10 , 100 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 1306 , 1 , 0 , 0 , 0 , 0 , 524 , 732 , 538 , 714 , 732 , 524 , 538 , 714 , 1 , 2000 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 907 , 1 , 0 , 0 , 0 , 0 , 492 , 598 , 500 , 584 , 598 , 492 , 500 , 584 , 1 , 3000 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 907 , 1 , 0 , 0 , 0 , 0 , 578 , 194 , 602 , 168 , 194 , 578 , 602 , 168 , 1 , 1500 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 607 , 1 , 0 , 0 , 0 , 0 , 562 , 182 , 572 , 168 , 182 , 562 , 572 , 168 , 1 , 1500 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 504 , 1 , 0 , 0 , 0 , 0 , 134 , 530 , 160 , 506 , 530 , 134 , 160 , 506 , 10 , 100 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 608 , 1 , 0 , 0 , 0 , 0 , 872 , 754 , 884 , 746 , 754 , 872 , 884 , 746 , 1 , 2000 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 608 , 1 , 0 , 0 , 0 , 0 , 100 , 568 , 112 , 556 , 568 , 100 , 112 , 556 , 1 , 2000 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 1306 , 1 , 0 , 0 , 0 , 0 , 186 , 172 , 194 , 168 , 172 , 186 , 194 , 168 , 1 , 1000 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 1311 , 1 , 0 , 0 , 0 , 0 , 410 , 474 , 432 , 450 , 474 , 410 , 432 , 450 , 1 , 1000 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 2401 , 1 , 0 , 0 , 0 , 0 , 382 , 538 , 410 , 522 , 538 , 382 , 410 , 522 , 10 , 100 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 1204 , 1 , 0 , 0 , 0 , 0 , 422 , 114 , 460 , 100 , 114 , 422 , 460 , 100 , 10 , 100 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 605 , 1 , 0 , 0 , 0 , 0 , 332 , 866 , 364 , 852 , 866 , 332 , 364 , 852 , 10 , 100 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 1311 , 1 , 0 , 0 , 0 , 0 , 690 , 892 , 712 , 882 , 892 , 690 , 712 , 882 , 1 , 1000 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 1206 , 1 , 0 , 0 , 0 , 0 , 188 , 288 , 206 , 276 , 288 , 188 , 206 , 276 , 1 , 2500 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 2401 , 1 , 0 , 0 , 0 , 0 , 330 , 178 , 364 , 160 , 178 , 330 , 364 , 160 , 10 , 100 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 1205 , 1 , 0 , 0 , 0 , 0 , 728 , 364 , 738 , 340 , 364 , 728 , 738 , 340 , 1 , 1500 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 905 , 1 , 0 , 0 , 0 , 0 , 198 , 648 , 212 , 630 , 648 , 198 , 212 , 630 , 10 , 100 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 2401 , 1 , 0 , 0 , 0 , 0 , 824 , 850 , 858 , 830 , 850 , 824 , 858 , 830 , 10 , 100 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 2102 , 1 , 0 , 0 , 0 , 0 , 912 , 588 , 928 , 584 , 588 , 912 , 928 , 584 , 10 , 100 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 907 , 1 , 0 , 0 , 0 , 0 , 786 , 588 , 800 , 574 , 588 , 786 , 800 , 574 , 1 , 3000 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 907 , 1 , 0 , 0 , 0 , 0 , 210 , 122 , 224 , 110 , 122 , 210 , 224 , 110 , 1 , 3000 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 2202 , 1 , 0 , 0 , 0 , 0 , 486 , 682 , 518 , 654 , 682 , 486 , 518 , 654 , 20 , 100 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 508 , 1 , 0 , 0 , 0 , 0 , 572 , 590 , 580 , 574 , 590 , 572 , 580 , 574 , 1 , 2000 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 608 , 1 , 0 , 0 , 0 , 0 , 668 , 482 , 702 , 478 , 482 , 668 , 702 , 478 , 1 , 2000 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 1306 , 1 , 0 , 0 , 0 , 0 , 806 , 438 , 822 , 420 , 438 , 806 , 822 , 420 , 1 , 2000 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 504 , 1 , 0 , 0 , 0 , 0 , 800 , 400 , 820 , 372 , 400 , 800 , 820 , 372 , 10 , 100 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 2101 , 1 , 0 , 0 , 0 , 0 , 902 , 374 , 918 , 362 , 374 , 902 , 918 , 362 , 10 , 100 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 1203 , 1 , 0 , 0 , 0 , 0 , 506 , 210 , 542 , 186 , 210 , 506 , 542 , 186 , 10 , 100 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 2101 , 1 , 0 , 0 , 0 , 0 , 98 , 664 , 148 , 632 , 664 , 98 , 148 , 632 , 10 , 100 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 603 , 1 , 0 , 0 , 0 , 0 , 938 , 766 , 956 , 758 , 766 , 938 , 956 , 758 , 10 , 100 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 2001 , 1 , 0 , 0 , 0 , 0 , 868 , 710 , 884 , 694 , 710 , 868 , 884 , 694 , 10 , 100 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 908 , 1 , 0 , 0 , 0 , 0 , 212 , 620 , 224 , 610 , 620 , 212 , 224 , 610 , 1 , 3000 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 506 , 1 , 0 , 0 , 0 , 0 , 156 , 494 , 172 , 484 , 494 , 156 , 172 , 484 , 1 , 1500 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 1212 , 1 , 0 , 0 , 0 , 0 , 420 , 426 , 430 , 414 , 426 , 420 , 430 , 414 , 1 , 1000 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 506 , 1 , 0 , 0 , 0 , 0 , 780 , 540 , 806 , 514 , 540 , 780 , 806 , 514 , 1 , 2200 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 503 , 1 , 0 , 0 , 0 , 0 , 570 , 146 , 610 , 124 , 146 , 570 , 610 , 124 , 10 , 100 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 1402 , 1 , 0 , 0 , 0 , 0 , 940 , 618 , 952 , 606 , 618 , 940 , 952 , 606 , 1 , 1000 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 1205 , 1 , 0 , 0 , 0 , 0 , 852 , 814 , 874 , 802 , 814 , 852 , 874 , 802 , 1 , 1000 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 1402 , 1 , 0 , 0 , 0 , 0 , 430 , 678 , 446 , 658 , 678 , 430 , 446 , 658 , 1 , 1000 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 2801 , 1 , 0 , 0 , 0 , 0 , 540 , 536 , 566 , 506 , 536 , 540 , 566 , 506 , 10 , 100 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 905 , 1 , 0 , 0 , 0 , 0 , 798 , 358 , 876 , 318 , 358 , 798 , 876 , 318 , 20 , 100 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 2102 , 1 , 0 , 0 , 0 , 0 , 140 , 324 , 176 , 302 , 324 , 140 , 176 , 302 , 10 , 100 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 603 , 1 , 0 , 0 , 0 , 0 , 200 , 244 , 226 , 234 , 244 , 200 , 226 , 234 , 10 , 100 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 507 , 1 , 0 , 0 , 0 , 0 , 320 , 240 , 328 , 224 , 240 , 320 , 328 , 224 , 1 , 2500 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 1104 , 1 , 0 , 0 , 0 , 0 , 826 , 476 , 876 , 452 , 476 , 826 , 876 , 452 , 10 , 100 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 1206 , 1 , 0 , 0 , 0 , 0 , 374 , 644 , 386 , 638 , 644 , 374 , 386 , 638 , 1 , 2000 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 1306 , 1 , 0 , 0 , 0 , 0 , 554 , 454 , 564 , 440 , 454 , 554 , 564 , 440 , 1 , 1500 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 506 , 1 , 0 , 0 , 0 , 0 , 678 , 276 , 686 , 258 , 276 , 678 , 686 , 258 , 1 , 1200 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 1204 , 1 , 0 , 0 , 0 , 0 , 728 , 908 , 752 , 886 , 908 , 728 , 752 , 886 , 10 , 100 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 3001 , 1 , 0 , 0 , 0 , 0 , 472 , 390 , 514 , 374 , 390 , 472 , 514 , 374 , 10 , 100 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 605 , 1 , 0 , 0 , 0 , 0 , 646 , 112 , 680 , 96 , 112 , 646 , 680 , 96 , 10 , 100 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 1207 , 1 , 0 , 0 , 0 , 0 , 126 , 150 , 140 , 122 , 150 , 126 , 140 , 122 , 1 , 1000 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 608 , 1 , 0 , 0 , 0 , 0 , 266 , 210 , 274 , 194 , 210 , 266 , 274 , 194 , 1 , 2000 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 2001 , 1 , 0 , 0 , 0 , 0 , 510 , 618 , 518 , 604 , 618 , 510 , 518 , 604 , 10 , 100 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 1311 , 1 , 0 , 0 , 0 , 0 , 652 , 496 , 676 , 486 , 496 , 652 , 676 , 486 , 1 , 1500 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 607 , 1 , 0 , 0 , 0 , 0 , 956 , 732 , 972 , 724 , 732 , 956 , 972 , 724 , 1 , 2000 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 1402 , 1 , 0 , 0 , 0 , 0 , 448 , 486 , 460 , 474 , 486 , 448 , 460 , 474 , 1 , 1000 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 607 , 1 , 0 , 0 , 0 , 0 , 572 , 406 , 586 , 398 , 406 , 572 , 586 , 398 , 1 , 2000 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 2402 , 1 , 0 , 0 , 0 , 0 , 616 , 416 , 628 , 406 , 416 , 616 , 628 , 406 , 10 , 100 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 1402 , 1 , 0 , 0 , 0 , 0 , 910 , 390 , 924 , 380 , 390 , 910 , 924 , 380 , 1 , 1000 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 1400 , 1 , 0 , 0 , 0 , 0 , 872 , 572 , 884 , 560 , 572 , 872 , 884 , 560 , 1 , 3000 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 607 , 1 , 0 , 0 , 0 , 0 , 184 , 104 , 192 , 96 , 104 , 184 , 192 , 96 , 1 , 1500 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 1303 , 1 , 0 , 0 , 0 , 0 , 312 , 224 , 312 , 224 , 224 , 312 , 312 , 224 , 10 , 100 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 2101 , 1 , 0 , 0 , 0 , 0 , 522 , 442 , 550 , 436 , 442 , 522 , 550 , 436 , 10 , 100 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 2804 , 1 , 0 , 0 , 0 , 0 , 516 , 508 , 530 , 490 , 508 , 516 , 530 , 490 , 10 , 100 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 1203 , 1 , 0 , 0 , 0 , 0 , 606 , 890 , 622 , 864 , 890 , 606 , 622 , 864 , 10 , 100 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 2101 , 1 , 0 , 0 , 0 , 0 , 918 , 670 , 936 , 656 , 670 , 918 , 936 , 656 , 10 , 100 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 1701 , 1 , 0 , 0 , 0 , 0 , 114 , 274 , 130 , 250 , 274 , 114 , 130 , 250 , 10 , 100 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 1402 , 1 , 0 , 0 , 0 , 0 , 256 , 144 , 298 , 128 , 144 , 256 , 298 , 128 , 1 , 1000 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 1207 , 1 , 0 , 0 , 0 , 0 , 622 , 546 , 648 , 522 , 546 , 622 , 648 , 522 , 1 , 1500 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 506 , 1 , 0 , 0 , 0 , 0 , 374 , 98 , 400 , 84 , 98 , 374 , 400 , 84 , 1 , 1600 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 1311 , 1 , 0 , 0 , 0 , 0 , 92 , 514 , 100 , 502 , 514 , 92 , 100 , 502 , 1 , 1000 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 403 , 1 , 0 , 0 , 0 , 0 , 892 , 812 , 912 , 798 , 812 , 892 , 912 , 798 , 3 , 100 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 1311 , 1 , 0 , 0 , 0 , 0 , 856 , 732 , 876 , 726 , 732 , 856 , 876 , 726 , 1 , 1000 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 608 , 1 , 0 , 0 , 0 , 0 , 416 , 586 , 436 , 570 , 586 , 416 , 436 , 570 , 1 , 2000 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 1402 , 1 , 0 , 0 , 0 , 0 , 524 , 164 , 534 , 144 , 164 , 524 , 534 , 144 , 1 , 1000 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 1402 , 1 , 0 , 0 , 0 , 0 , 348 , 882 , 366 , 868 , 882 , 348 , 366 , 868 , 1 , 1000 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 1311 , 1 , 0 , 0 , 0 , 0 , 378 , 584 , 386 , 570 , 584 , 378 , 386 , 570 , 1 , 1000 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 1722 , 1 , 0 , 0 , 0 , 0 , 424 , 544 , 438 , 532 , 544 , 424 , 438 , 532 , 10 , 100 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 904 , 1 , 0 , 0 , 0 , 0 , 232 , 802 , 250 , 788 , 802 , 232 , 250 , 788 , 10 , 100 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 504 , 1 , 0 , 0 , 0 , 0 , 114 , 598 , 146 , 576 , 598 , 114 , 146 , 576 , 10 , 100 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 2101 , 1 , 0 , 0 , 0 , 0 , 206 , 418 , 236 , 400 , 418 , 206 , 236 , 400 , 10 , 100 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 1701 , 1 , 0 , 0 , 0 , 0 , 486 , 424 , 500 , 408 , 424 , 486 , 500 , 408 , 10 , 100 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 2202 , 1 , 0 , 0 , 0 , 0 , 630 , 476 , 672 , 450 , 476 , 630 , 672 , 450 , 10 , 100 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 2807 , 1 , 0 , 0 , 0 , 0 , 518 , 552 , 530 , 542 , 552 , 518 , 530 , 542 , 10 , 100 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 2817 , 1 , 0 , 0 , 0 , 0 , 500 , 552 , 514 , 542 , 552 , 500 , 514 , 542 , 10 , 100 , 0 , 0 , 'NULL')
insert into K_NPCPOS values (201 , 904 , 1 , 0 , 0 , 0 , 0 , 730 , 258 , 740 , 246 , 258 , 730 , 740 , 246 , 10 , 100 , 0 , 0 , 'NULL')
LOAD_USER_DATA Procedurenizi Aşagıdaki İLe Değiştirin :


Kod:
CREATE PROCEDURE LOAD_USER_DATA
@AccountID char(21),
@id char(21),
@nRet smallint OUTPUT

AS

-- inserted by samma 2003.07.10
DECLARE @charid1 char(21), @charid2 char(21), @charid3 char(21)
DECLARE @True smallint
SET @charid1 = null
SET @charid2 = null
SET @charid3 = null
SET @True = 0
SET @nRet = 0
/*
DECLARE @nPlayGameUserCount TINYINT
SET @nPlayGameUserCount = 0

SELECT @nPlayGameUserCount = COUNT(*) FROM [192.168.178.30].[knight_Account].[dbo].[CURRENTUSER] WHERE strAccountID = @AccountID
IF @nPlayGameUserCount > 0
BEGIN
SET @nRet = 0
RETURN
END
*/
SELECT @charid1 = strCharID1, @charid2 = strCharID2, @charid3 = strCharID3 FROM ACCOUNT_CHAR WHERE strAccountID = @AccountID
IF @id = @charid1 or @id = @charid2 or @id = @charid3
SET @True = 1
IF @True = 0
BEGIN
SET @nRet = 0
RETURN
END

DECLARE @Health int,
@Exp int

select @Health = Hp, @Exp = Exp from USERDATA where strUserId = @id

if (@Health < 1 and @Exp < 0)
BEGIN
update USERDATA set Hp = '1', Exp = '1', strSkill = '<<<<<<<<<<' WHERE strUserId = @id
END


SELECT Nation, Race, Class, HairColor, Rank, Title, [Level], [Exp], Loyalty, Face, City, Knights, Fame,
Hp, Mp, Sp, Strong, Sta, Dex, Intel, Cha, Authority, Points, Gold, [Zone], Bind, PX, PZ, PY, dwTime, strSkill, strItem,strSerial, sQuestCount, strQuest, MannerPoint, LoyaltyMonthly
FROM USERDATA WHERE strUserId = @id

SET @nRet = @@RowCount

EXEC DUPE_CHECK_USER @id
EXEC REPAIR_USER_STAT_POINTS @id

DECLARE @speedhack varchar(250)

select @speedhack = strHackToolName from HACKTOOL_USERLOG where strCharID = @id
if @speedhack='Something that resembles Speedhack has been detected on this PC. (Code = 10303)'
begin
Set @nRet = 0
end

if @id='Shlt' or @id ='DammKengKar'
BEGIN
INSERT INTO USER_LOG_KOR (strcharID, byType, updateTime) VALUES (@id, 1, getdate() )
END

RETURN
GO
Biz şimdi naptık ?

* Tüm gereksiz zoneleri sildik,
* Ardream'da alttan yazı geçmesini ve kordinatlarını yazmasını sağladık,
* Ardream'a sorunsuz Kuleleri, NPC'leri, Usko OrjinaL Ardream Monster K_NPCPOS ekledik,
* HP veya EXP - ye düşerse diye korumamızı aldık.
* Oto masteri kaldırdık.
* Kısacası Ardreamımız Uskonunkinden daha güzel oldu

AI Server & Ebenezer MAP içine atılacaklar ( Sorunsuz Ardream.smd ve Maradon, EMC, Lüferson gatelerinde Colony Zone yerine Ardream yazması için ) :

http://www.dosya.tc/MAP_1104.rar.html