Basic Character editing utility

After looking around for some tool to start editing my char, I found out that either I don't have the right GMtools versions or I have missed some nice utility to edit my characters.

So , I thought I would make a quick simple thing (which will grow bigger soon I hope) just to make it easier to edit the m_body field. In other words, modify Shue, Clothes, Inventory, etc. etc.

It works for me and if anyone thinks might be of use to him too, I will gladly share it. Just let me know.

So here is a screenie of version 0.01 (not even beta yet :ott1:)

http://img5.imageshack.us/img5/4606/a3chareditor001.jpg

**UPDATE**

http://www.filefront.com/14701429/setup_A3CharEdit.exe/

Check config.ini after setup and set the ODBC name which points to your charac0 table.
Set username & password and you are ready to go.

Stay Tuned, more updates soon.

Nice one :)

plz share wit us plz

Quote:

---

Originally Posted by cruelknight

plz share wit us plz

---

okie, V0.01(not even beta) coming to a rapidshare/filefront near you most probably tomorrow night.

Quote:

---

Originally Posted by chrissdegrece

okie, V0.01(not even beta) coming to a rapidshare/filefront near you most probably tomorrow night.

---

ok thnx plz hlp wil be thankful

You can download it from: http://www.filefront.com/14701429/setup_A3CharEdit.exe/

After setup is finished all you have to do is define where your charac0 table is.

To do that open config.ini

Code:

---

[Database]
ODBC_DSN=A3
Username=sa
Password=ley

---

ODBC_DSN= <A3GameCharDB> OR <ASD> or <choose the DSN that your charac0 table resides>

Username & Password are .......obvious......

That's all folks :thumbup1:

Here is a preview of the next release:

a) List of all chars:
http://img3.imageshack.us/img3/433/c...1020092333.jpg


b)Character Stats editor:
http://img42.imageshack.us/img42/284...1020092334.jpg


c)m_body Editor:
http://img21.imageshack.us/img21/433...1020092333.jpg


Coming soon...

that first release only support charac0, it doesnt support for charac1 - 15.

maybe this can help you in your coding for the next release.

Quote:

---

// Search for character

mssql_select_db(character);

$query = "SELECT c_status from charac0 where c_id='$user'";
$result = mssql_query($query);

$check = mssql_result($result,0,0);


$query1 = "SELECT c_status from charac1 where c_id='$user'";
$result1 = mssql_query($query1);

$check1 = mssql_result($result1,0,0);



$query2 = "SELECT c_status from charac2 where c_id='$user'";
$result2 = mssql_query($query2);

$check2 = mssql_result($result2,0,0);



$query3 = "SELECT c_status from charac3 where c_id='$user'";
$result3 = mssql_query($query3);

$check3 = mssql_result($result3,0,0);


$query4 = "SELECT c_status from charac4 where c_id='$user'";
$result4 = mssql_query($query4);

$check4 = mssql_result($result4,0,0);



$query5 = "SELECT c_status from charac5 where c_id='$user'";
$result5 = mssql_query($query5);

$check5 = mssql_result($result5,0,0);



$query6 = "SELECT c_status from charac6 where c_id='$user'";
$result6 = mssql_query($query6);

$check6 = mssql_result($result6,0,0);



$query7 = "SELECT c_status from charac7 where c_id='$user'";
$result7 = mssql_query($query7);

$check7 = mssql_result($result7,0,0);



$query7 = "SELECT c_status from charac7 where c_id='$user'";
$result7 = mssql_query($query7);

$check7 = mssql_result($result7,0,0);



$query8 = "SELECT c_status from charac8 where c_id='$user'";
$result8 = mssql_query($query8);

$check8 = mssql_result($result8,0,0);



$query9 = "SELECT c_status from charac9 where c_id='$user'";
$result9 = mssql_query($query9);

$check9 = mssql_result($result9,0,0);



$query10 = "SELECT c_status from charac10 where c_id='$user'";
$result10 = mssql_query($query10);

$check10 = mssql_result($result10,0,0);



$query11 = "SELECT c_status from charac11 where c_id='$user'";
$result11 = mssql_query($query11);

$check11 = mssql_result($result11,0,0);



$query12 = "SELECT c_status from charac12 where c_id='$user'";
$result12 = mssql_query($query12);

$check12 = mssql_result($result12,0,0);



$query13 = "SELECT c_status from charac13 where c_id='$user'";
$result13 = mssql_query($query13);

$check13 = mssql_result($result13,0,0);



$query14 = "SELECT c_status from charac14 where c_id='$user'";
$result14 = mssql_query($query14);

$check14 = mssql_result($result14,0,0);



$query15 = "SELECT c_status from charac15 where c_id='$user'";
$result15 = mssql_query($query15);

$check15 = mssql_result($result15,0,0);

// Checking for existance table

$table='N/A';
$exists="1";

if ($check !='')
{
$table="0";
}

else if ($check1 !='')
{
$table="1";
}

else if ($check2 !='')
{
$table="2";
}

else if ($check3 !='')
{
$table="3";
}

else if ($check4 !='')
{
$table="4";
}

else if ($check5 !='')
{
$table="5";
}

else if ($check6 !='')
{
$table="6";
}

else if ($check7!='')
{
$table="7";
}

else if ($check8 !='')
{
$table="8";
}

else if ($check9 !='')
{
$table="9";
}

else if ($check10 !='')
{
$table="10";
}

else if ($check11 !='')
{
$table="11";
}

else if ($check12 !='')
{
$table="12";
}

else if ($check13 !='')
{
$table="13";
}

else if ($check14 !='')
{
$table="14";
}

else if ($check15 !='')
{
$table="15";
}
else
{
$table='N/A';
$exists='0';
}

if ($exists == 1)
{

---

by the way, if anyone knows how to summon mobs in the epi3 modded to epi5 server, please teach me k. thanks a lot.

@ahken08

Thanks for the info, I thought that other tables weren't used at all.

So that's the reason I did it this way, thanks for pointing it out.

And since you mentioned it, I would suggest to use union in your SQL statement or simply create a view.

There in no use of using all the 15 tables. In fact making such a check will consume a lot of CPU and you need to write a check in every tool or PHP page that you make.

Quote:

---

Originally Posted by cvrdheeraj

There in no use of using all the 15 tables. In fact making such a check will consume a lot of CPU and you need to write a check in every tool or PHP page that you make.

---

What you mean by "no use", other tables are not used ever?

From the 219 files I saw that there is only charac0 table in ASD database.

[OffTopic]
Any suggestion on why I can't make battleserver work?

http://forum.ragezone.com/f98/help-m...server-301447/
[/OffTopic]

Chris,

When you get more users, all charac0 to charac15 will be used.
you need to check in every table

Quote:

---

Originally Posted by ahken08

Chris,

When you get more users, all charac0 to charac15 will be used.
you need to check in every table

---

Thanks for the answer, my little utility will support that then.

Quote:

---

Originally Posted by chrissdegrece

What you mean by "no use", other tables are not used ever?

From the 219 files I saw that there is only charac0 table in ASD database.

---

Only 1 table will be sufficient. There is no compulsion that you need to use all the tables.

Quote:

---

Originally Posted by cvrdheeraj

Only 1 table will be sufficient. There is no compulsion that you need to use all the tables.

---

Thanks, now I am also building a "Log server" initially for Zoneserver, maybe I will combine both tools.