Hey im back with spam with my questions

Im working just 4 fun on a t_magic tool and i have one problem with the Swtich(variable) method (or mysql?)

 

I have this code :

 

if (listBox1.SelectedIndex != -1)
{
string Index = listBox1.SelectedItem.ToString();
textBox2.Text = Index;
}

MySqlConnection con;
MySqlConnectionStringBuilder csb = new MySqlConnectionStringBuilder();
csb.Server = Server;
csb.UserID = user;
csb.Database = db;
csb.Password = pw;
con = new MySqlConnection(csb.ConnectionString);
MySqlConnection connection = new MySqlConnection(csb.ConnectionString);
connection.Open();

string _Index = listBox1.SelectedItem.ToString();

string _Sql1 = @"SELECT * FROM t_magic a_index WHERE a_name ="+"'"+ _Index+"'";
DataTable dttable = new DataTable();
MySqlCommand insertCommand = new MySqlCommand(_Sql1, connection);
int i = insertCommand.ExecuteNonQuery();
MySqlDataAdapter dtAdp = new MySqlDataAdapter(_Sql1, connection);
dtAdp.Fill(dttable);
string result = Convert.ToString(insertCommand.ExecuteScalar());

string _sql2 = @"SELECT * FROM t_magic a_damagetype WHERE a_name =" + "'" + _Index + "'"; //problem is here
DataTable dtttable = new DataTable();
MySqlCommand insertCommand2 = new MySqlCommand(_sql2, connection);
int g = insertCommand2.ExecuteNonQuery();
MySqlDataAdapter dtAdp1 = new MySqlDataAdapter(_sql2, connection);
dtAdp.Fill(dttable);
string result1 = Convert.ToString(insertCommand2.ExecuteScalar());
MessageBox.Show(result1); // and here : it sows me the Index from the Skill and not the Damagetyp!
switch (result1)
{
case "0":
DamageTyp.Text = "No Damage";
break;

case "1":
DamageTyp.Text = "Normal Damage";
break;

case "2":
DamageTyp.Text = "Damage in %";
break;

case "60": // 60 is the Index of a skill! i cheked if i fail!
DamageTyp.Text = "You Fail!";
break;

 

So my Problem is it shows me the Index from the Skill and not the Damagetyp, where is the fail ?

hello

that tool has been created by wizatek to convert .ski file of PW(Perfect World) to .bm file for LC .

I tested it and don't work good . the .bm file are not on correct position , but that is easy to fix with cinema 4d .

than idk if the weapon need bone . I relase that tool with wizatek permission and I hope some one will make a guide on How To convert perfect world items to LC items .

Download : 2

credit to wizatek

 

 

 

 

 

here PW download : 2

hello,

 

i have a problem wiht my server and i have read some posts about problems with the server, but i don't be able to repair it.

i mounted my server without hamachi. I use 127.0.0.1 ip por my db and ipv4 for server's ips. i can go into the server in the pc where i have my server mounted and in another pc that it is connected to the same router (lan), but my friends that are in their houses can't go into my server. The only can do login, but when they have to choose the world to go into the game, they can't. These are two images to show you that i'm saying:

 

2

 

2

 

i think that my configs files are well configured, but i'm not sure. If you need more information or you want i show you the newstobms files, only tell me.

 

Sorry for my bad english and thanks alot.

It's rly easy .

you can find the game maps songs in Data\Sounds\Game\BGM

the file is .ogg files , to listen them just download an plugis for window media player .

that is the one I use 2 or just search in google .

than you need to convert yours songs mp3 to ogg . you can do it here :

2

than put you file ogg in Data\Sounds\Game\BGM and replace it for the zone you want .

example login song is called : GB_login.ogg

juno map song : GB_pease.ogg

ecc.

2

i Have found this version of this program so if someone need it or just want test it download it.

Here the program: 2

 

All the credits to the creator Hoostler

Virus total: 2

Well, never saw this error long time ago but, maybe you do.

He use his External IP in gameserver, it charges but it appears this error in "Bin".

 

He got the ports, he can enter the game but others after the login, it says "cannot connect to server".

Later, he tryid with this ip and appear this error...

(He just trying to finish his root server, just testing connection).

 

Image: 2

 

Regards,

 

Halo

Hello everyone. There is another problem...

 

 

 

When i relog in my server it shows me that my account is in a game. How can i fix this?

All new Administrator System now Available can contact me for info and what new

What this for you ask?
Well this Tool is for Server who is not smart to use navicat and have no dam Clue what to do
What does it do you say?
Well this tool make it easier to Edit Your Database And more Friendly to use Connect To Database and Can Edit And Save
What Feature your Asking ?
Well it has

2005 to 2014

LINK: 2NEW SYSTEM NAME

 
0.O Fundamental Updating Tool Service Whit version 2015 

1.Security Login System = 100%  ALL NEW VERSION
2.Mysql Connection Login = 100% 
3.System Hardware Binding = 100% 
4.Account Editing = 100% 
5.Charater Editing and Invetory = 70% 
6.Guild Editing = 100% 
7.NPC Editing/Rate increasing and drecreasing.= 100% 
8.NPC Regen Editing = 70% 
9.Quest Editing = 100% 
10.Rare Option Editing = 100% 
11.Shop Editing = 100% 
12.Shop Items Editing = 100% 
13.Skill/Skill Level/Special Skill/Magic/Magic Level Editor = 80% 
14.Option Editing = 100% 
15.Zonedata = 100% 
16.Connection Logs/Exp Editor/Lacarette/P2 Pets = 100% 
17.Cash Donation Zone = 100% Whit my Sql 
18.Exp Rates/Skill Rates/Gold Rates Editor = 100% 
19.Item Drop Rate = 100% 
20.PaySafe Card Checker By HateMe = 80%   REMOVED
21.Enable/Disable NPC = 100% 
22.Enable/Disable All Events = 100% 
23.Enable/Disable All Quest = 100% 
24.Enable/Disable All P2Pets = 100% 
25.Enable/Disable All P Quest = 100% 
26.Enable/Disable All items = 100% 
27.Enable/Disable Affinity = 100% 
28.Enable all NPC Heaven Stone Drop = 100% 
29.Max/Min/Prob NPC Drop Rates = 100% 
30.Quest Rates Prize 0,1,2 = 100% 
31.All Player Max Skill = 100% 
32.Lacaball Fix = 100% 
33.All Player Max/Pk/Pheonix = 100% 
34.Ip Editor - 100% 
35.Action Editor - 98% 
36.Affinity - 100% 
37.Big Pet - 10% 
38.Cash type - 10% 
39.Catalog - 100% 
40.Chat Filter - 10% 
41.Combo - 100% 
42.Event - 100% 
43.Itemmall - 100% 
44.Jewel Combo - 10% 
45.Lacarette - 10% 
46.Make Item - 10% 
47.Map DTA - 100% 
48.Moball - 100% 
49.Moonstone - 10% 
50.Notice - 100% 
51.Npc Help - 10% 
52.Option - 100% 
53.Pet AI - 10% 
54.Quest All - 100% 
55.Raid List - 10% 
56.Rare Option - 100% 
57.Set Item All - 10% 
58.Shop All - 100% 
59.Skill USA - 100% 
60.String - 100% 
61.Title - 100% 
62.Zone Flag - 100% 
63.GameServer - 10% 
64.New Style = 30% 

Close Topic/.

Hey Com,

 

I was sitting a while to solve this problem but u coulndt fixx it anyways xD

But i think there must be a way to do it..

 

I just wanted to know what parts of database/client have to be edited to get this working

 

thx Creep