[Sammelthread] EP2 Files

Quote:

Originally Posted by Havelok windows -> start -> Ausführen -> cmd dort dann "ping deinevirtualboxip" und Enter. Aber wie ich sehe hast du also Virtualbox und deine IP in der Box beginnt mit 10.xx Du hast die Virtuelle Maschichen falsch eingestellt. Geh mal auf ändern und stell im Netzwerk "Netzwerkbrücke" statt "NAT" ein. Dann sollte es auch gehen.

• Exp Rate:

UPDATE t_npc SET a_exp = a_exp * 1;

• Skillpoint Rate:

UPDATE t_npc SET a_skill_point = a_skill_point * 1;

• Gold Drop Rate

UPDATE t_npc SET a_prize = a_prize * 1;

• Item Drop Rate

UPDATE t_npc SET a_item_percent_0 = a_item_percent_0 * 1;
UPDATE t_npc SET a_item_percent_1 = a_item_percent_1 * 1;
UPDATE t_npc SET a_item_percent_2 = a_item_percent_2 * 1;
UPDATE t_npc SET a_item_percent_3 = a_item_percent_3 * 1;
UPDATE t_npc SET a_item_percent_4 = a_item_percent_4 * 1;
UPDATE t_npc SET a_item_percent_5 = a_item_percent_5 * 1;
UPDATE t_npc SET a_item_percent_6 = a_item_percent_6 * 1;
UPDATE t_npc SET a_item_percent_7 = a_item_percent_7 * 1;
UPDATE t_npc SET a_item_percent_8 = a_item_percent_8 * 1;
UPDATE t_npc SET a_item_percent_9 = a_item_percent_9 * 1;
UPDATE t_npc SET a_item_percent_10 = a_item_percent_10 * 1;
UPDATE t_npc SET a_item_percent_11 = a_item_percent_11 * 1;
UPDATE t_npc SET a_item_percent_12 = a_item_percent_12 * 1;
UPDATE t_npc SET a_item_percent_13 = a_item_percent_13 * 1;
UPDATE t_npc SET a_item_percent_14 = a_item_percent_14 * 1;
UPDATE t_npc SET a_item_percent_15 = a_item_percent_15 * 1
UPDATE t_npc SET a_item_percent_16 = a_item_percent_16 * 1;
UPDATE t_npc SET a_item_percent_17 = a_item_percent_17 * 1;
UPDATE t_npc SET a_item_percent_18 = a_item_percent_18 * 1;
UPDATE t_npc SET a_item_percent_19 = a_item_percent_19 * 1;

• Enable all Npc & Monster:

UPDATE t_npc SET a_enable = 1;

• Enable all Events:

UPDATE t_npc SET a_enable = 1;

• Enable all Pet Quest:

UPDATE t_quest_pet SET a_enable = 1;

• Enable all P2-Pet:

UPDATE t_bigpet SET a_enable = 1;

• Enable all Quest:

UPDATE t_quest SET a_enable = 1;

• Enable all Item:

UPDATE t_item SET a_enable = 1;

This Code Enable [b]all Item[/b] in your Database. (newproject_data)

• Enable all Affinity System:

UPDATE t_affinity SET a_enable = 1;
UPDATE t_affinity_work SET a_enable = 1;
UPDATE t_affinity_npc SET a_enable = 1;

• Min/Max + on Dropps:

UPDATE t_npc SET a_minplus = a_minplus +1;
UPDATE t_npc SET a_maxplus = a_maxplus +1;
UPDATE t_npc SET a_probplus = 10000;

This Code let manage your minimal and maximal + on drops (newproject_data)

• Drop by every Monster Heaven Stone:

UPDATE t_npc SET a_item_1 = 85;

This Code set drop Number 1 to Heaven Stone (newproject_data)

• Drop by every Monster Chaos Smelting Stone:

UPDATE t_npc SET a_item_1 = 2844;

This Code set drop Number 1 to Chaos Smelting Stone (newproject_data)

• Exp Guild Bug Fixx:

Dont have the Code yet, if you have it post it here!

This code fix the Guild Exp Bug!
(newproject_db)

• Set Quest Experience:

UPDATE t_quest SET a_prize_data0 = a_prize_data0*1 WHERE a_prize_index0 = 0 and a_prize_type0 = 2 ;
UPDATE t_quest SET a_prize_data1 = a_prize_data1*1 WHERE a_prize_index1 = 0 and a_prize_type1 = 2 ;
UPDATE t_quest SET a_prize_data2 = a_prize_data2*1 WHERE a_prize_index2 = 0 and a_prize_type2 = 2 ;

This Code let manage you the Quest Experience Replace [b]1 with the number of Exp Rate that you would to have (thanks for code filix_93 )[/b]
(newproject_data)

Quote:

Enable all Events: Spoiler: Code: UPDATE t_npc SET a_enable = 1; Zitat: This Code Enable all Events in your Database. (newproject_data)

Quote:

Originally Posted by Havelok Hmm alle npcs aktivieren für Events? Glaube da hat sich ein fehler eingeschlichen.

Quote:

Originally Posted by Havelok windows -> start -> Ausführen -> cmd dort dann "ping deinevirtualboxip" und Enter. Aber wie ich sehe hast du also Virtualbox und deine IP in der Box beginnt mit 10.xx Du hast die Virtuelle Maschichen falsch eingestellt. Geh mal auf ändern und stell im Netzwerk "Netzwerkbrücke" statt "NAT" ein. Dann sollte es auch gehen.

Quote:

Originally Posted by Klo.Brille Hey , Hat jemand nen Link für den Post wo drin steht welche IP man wo eingeben muss ? Bzw. Welche IP's etc. muss ich hier eingeben ? Connector : PHP Code: [Server] Number=1 MaxSubServer=5 IP=192.168.2.105 Port=50200 [User DB] IP=192.168.2.105 DBName=Server User=root Password=123456 [Auth DB] IP=192.168.2.105 DBName=Server User=root Password=123456 [Billing Server] IP=192.168.2.105 Port=8802 [SHA256] Salt=phoohie1yaihooyaequae7PuiWoeNgahjieth3ru3yeeghaepahb7aeYaipe2we6zii6mai6uweig8siasheinoungeoyeiLohShi2xoh2xi8ooxee9ahpiehahc9Phe  Game Server: PHP Code: [Server] Number=1 SubNumber=1 IP=192.168.2.105 Port=4101 AllowExternalIP=TRUE [Data DB] IP=192.168.2.105 DBName=Server_data User=root Password=123456 [Post DB] IP=192.168.2.105 DBName=newproject_post User=lastchaos Password=lastchaos [User Server] IP=192.168.2.105 Port=4102 [Char DB] IP=192.168.2.105 DBName=auth User=root Password=123456 [Messenger Server] IP=192.168.2.105 Port=50500 [Helper Server] IP=192.168.2.105 Port=50301 [SubHelper Server] IP=192.168.2.105 Port=50401 [Connector Server] IP=192.168.2.105 Port=50200 [Zones] Count=36 [Zone_0] No=0 Remote=FALSE [Zone_1] No=1 Remote=FALSE [Zone_2] No=2 Remote=FALSE [Zone_3] No=3 Remote=FALSE [Zone_4] No=4 Remote=FALSE [Zone_5] No=5 Remote=FALSE [Zone_6] No=6 Remote=FALSE [Zone_7] No=14 Remote=FALSE [Zone_8] No=7 Remote=FALSE [Zone_9] No=10 Remote=FALSE [Zone_10] No=9 Remote=FALSE [Zone_11] No=11 Remote=FALSE [Zone_12] No=12 Remote=FALSE [Zone_13] No=8 Remote=FALSE [Zone_14] No=15 Remote=FALSE [Zone_15] No=17 Remote=FALSE [Zone_16] No=18 Remote=FALSE [Zone_17] No=19 Remote=FALSE [Zone_18] No=20 Remote=FALSE [Zone_19] No=21 Remote=FALSE [Zone_20] No=22 Remote=FALSE [Zone_21] No=23 Remote=FALSE [Zone_22] No=25 Remote=FALSE [Zone_23] No=29 Remote=FALSE [Zone_24] No=30 Remote=FALSE [Zone_25] No=31 Remote=FALSE [Zone_26] No=24 Remote=FALSE [Zone_27] No=32 Remote=FALSE [Zone_28] No=33 Remote=FALSE [Zone_29] No=34 Remote=FALSE [Zone_30] No=35 Remote=FALSE [Zone_31] No=36 Remote=FALSE [Zone_32] No=37 Remote=FALSE [Zone_33] No=38 Remote=FALSE [Zone_34] No=39 Remote=FALSE [Zone_35] No=40 Remote=FALSE  Helper: PHP Code: [Server] Number=1 IP=10.0.0.25 Port=50301 [Char DB] IP=10.0.0.1 DBName=newproject_db_ep2_test User=lastchaos Password=lastchaos  LoginServer: PHP Code: [Server] No=1 Port=4001 AllowExternalIP=TRUE [User DB] IP=127.0.0.1 DBName=auth User=root Password=123456 [Data DB] IP=127.0.0.1 DBName=auth User=root Password=123456 [Auth DB] IP=127.0.0.1 DBName=auth User=root Password=123456 [Messenger Server] IP=127.0.0.1 Port=50500 [Connector Server] Count=1 [Connector_0] Number=1 MaxSubNumber=5 IP=127.0.0.1 Port=50200 [Auto Block] Refresh=2 MaxTry=7 [SHA256] Salt=phoohie1yaihooyaequae7PuiWoeNgahjieth3ru3yeeghaepahb7aeYaipe2we6zii6mai6uweig8siasheinoungeoyeiLohShi2xoh2xi8ooxee9ahpiehahc9Phe  Messenger: PHP Code: [Server] IP=192.168.2.105 Port=50500  SubHelper: PHP Code: [Server] Number=1 IP=192.168.2.105 Port=50401 UserPort=4102 MAXSIZE=1000 [Char DB] IP=192.168.2.105 DBName=newproject_db_ep2_test User=lastchaos Password=lastchaos [Post DB] IP=192.168.2.105 DBName=newproject_post User=lastchaos Password=lastchaos  Grundlegende Infos : Die Ip meiner v-Box : 192.168.2.105 Die Namen meiner MySql Datenbank : [Only registered and activated users can see links. Click Here To Register...] auth=auth EP2 d=DB EP2 data=data EP2 Und wie stell ich dann ein das ich dann z.B. mit dem gamigo-Clienten verbinde ? Falls mir jemand das richtig erklären soltle , und ich dann verbinden kann , gebe ich ihm 40 e*gold als Dankeschön