Hey, im Trying to use my MySQL Connection string, with Strings so without that i need to write" host = "127.0.0.1" "

but there are a little Problem i hope some of you can find it^^

 

The Error: The connection property has not been set or is null.

// Make the Strings
public partial class user_index : Form
{

public string host;
public string user;
public string db;
public string pw;

public user_index()
{

InitializeComponent();
Initialize();

}

//Initialize the Strings (and define)
private void Initialize()
{
Form1 f1 = new Form1();
host = f1.textBox1.Text;
user = f1.textBox3.Text;
db = f1.textBox5.Text;
pw = f1.textBox4.Text;

}

//Insert
public void Insert()
{

MySqlConnection con;
MySqlConnectionStringBuilder csb = new MySqlConnectionStringBuilder();
csb.Server = host;
csb.UserID = user;
csb.Database = db;
csb.Password = pw;
con = new MySqlConnection(csb.ConnectionString);
MySqlConnection connection = new MySqlConnection(csb.ConnectionString);
DataTable datatable = new DataTable();
String sql1 = "SELECT * FROM t_characters user_code WHERE a_nick =" + textBox1.Text;
MySqlDataAdapter dataAdapter = new MySqlDataAdapter(sql1, connection);
dataAdapter.Fill(datatable);
foreach (DataRow row in datatable.Rows)
{
ListViewItem item = new ListViewItem(
new string[] {
row["a_user_index"].ToString()});
listView1.Items.Add(item);
}

}

Today i want to release the editor i made together with blankname to edit specific values in the gameserver without having to use a hexeditor.

 

The program is easy to configure and is not limited to use on the gameserver. basically it can be used to edit any file on any offset.

 

The program reads from offsets.cfg.

There is already a offsets.cfg in the package with some offsets predefined.

 

 

 

 

[hide]

2

[/hide]

Well, it has been time since i didnt find anything about how adding seals to the armor or weapons. I saw many servers now could make it work using bloodseal or crystal of blood. (Im Using Nikola's Client)

 

So, how i make them work, to have 5 seals on armor and weapons, seals i choose to appear. Hope you understand what im looking for...

Thanks, i really was looking for this if you have it.

 

Regards,

 

Halo

this script is exzactly what the tittle says follow this steps

UPDATE t_npc_regen SET a_npc_idx = "2090" WHERE a_npc_idx = "65";

replace 2090 and 65 as desired

1.run navicat

2. leftclick newproject_data

3.hit console

4.type the script replace with the mob id's u want replace

5.hit enter

6.restart server

Hello all,

Thats my first release here is my ns files and fixed armor bugs like at this image:

 

 

 

Fixed Screens in attach files

 

2

2

2

2

Hey Guys Today I'm Here For Show you a new custom reborn system remade by me

 

MaX Thanks For your Hold EP1 website (IT help me so much )

 

Here Are : (i will not give any supports learn php and fix it your self if fount some bugs )

 

// Check For Login
if( $User->LoggedIn == true )
{
echo'<center>
<br/><br/>
<table border="0" width="90%" cellspacing="0" cellpadding="0">
<tr>
<td width="15"><b><center>Rank</center></b></td>
<td width="20"><b><center>Class</center></b></td>
<td width="30"><b><center>Name</center></b></td>
<td width="30"><b><center>Level</center></b></td>
<td width="10"><b><center>SP</center></b></td>
<td width="10"><b><center>HP</center></b></td>
<td width="10"><b><center>MP</center></b></td>
<td width="10"><b><center>Reborn</center></b></td>
</tr>';

$lvl1 = "<form id='form1' name='form1' method='post' action=''>
<input name='lvl1' value='Reset LVL 1' type='submit' />
</form>";

$sp = "<form id='form2' name='form2' method='post' action=''>
<input name='sp' value='100k SP' type='submit' />
</form>";

$rbsys = "<form id='form1' name='form1' method='post' action=''>
<input name='reborn' value='Reborn' type='submit' />
</form>";
if( isset( $_GET['Class'] ) && $_GET['Class'] == 'Healer' )
{
$mysql75 = mysql_select_db( $SiteSQL["config-database_db"] , $Site_sqlcon) or die( mysql_error() );
$query2b = "SELECT a_user_index, a_name, a_level, a_job, a_job2, a_skill_point, a_hp, a_mp FROM t_characters WHERE a_job = 2 AND a_user_index = ". $User->ID ." ORDER BY a_level desc LIMIT 4";
$Rank = 1;
$result22b = mysql_query ($query2b);
} else
if( isset( $_GET['Class'] ) && $_GET['Class'] == 'Sorcerer' )
{
$mysql75 = mysql_select_db( $SiteSQL["config-database_db"] , $Site_sqlcon) or die( mysql_error() );
$query2b = "SELECT a_user_index, a_name, a_level, a_job, a_job2, a_skill_point, a_hp, a_mp FROM t_characters WHERE a_job = 5 AND a_user_index = ". $User->ID ." ORDER BY a_level desc LIMIT 4";
$Rank = 1;
$result22b = mysql_query ($query2b);
} else
if( isset( $_GET['Class'] ) && $_GET['Class'] == 'Rouge' )
{
$mysql75 = mysql_select_db( $SiteSQL["config-database_db"] , $Site_sqlcon) or die( mysql_error() );
$query2b = "SELECT a_user_index, a_name, a_level, a_job, a_job2, a_skill_point, a_hp, a_mp FROM t_characters WHERE a_job = 4 AND a_user_index = ". $User->ID ." AND a_enable = 1 ORDER BY a_level desc LIMIT 4";
$Rank = 1;
$result22b = mysql_query ($query2b);
} else
if( isset( $_GET['Class'] ) && $_GET['Class'] == 'Mage' )
{
$mysql75 = mysql_select_db( $SiteSQL["config-database_db"] , $Site_sqlcon) or die( mysql_error() );
$query2b = "SELECT a_user_index, a_name, a_level, a_job, a_job2, a_skill_point, a_hp, a_mp FROM t_characters WHERE a_job = 3 AND a_user_index = ". $User->ID ." AND a_enable = 1 ORDER BY a_level desc LIMIT 4";
$Rank = 1;
$result22b = mysql_query ($query2b);
} else
if( isset( $_GET['Class'] ) && $_GET['Class'] == 'Titan' )
{
$mysql75 = mysql_select_db( $SiteSQL["config-database_db"] , $Site_sqlcon) or die( mysql_error() );
$query2b = "SELECT a_user_index, a_name, a_level, a_job, a_job2, a_skill_point, a_hp, a_mp FROM t_characters WHERE a_job = 0 AND a_user_index = ". $User->ID ." AND a_enable = 1 ORDER BY a_level desc LIMIT 4";
$Rank = 1;
$result22b = mysql_query ($query2b);
} else
if( isset( $_GET['Class'] ) && $_GET['Class'] == 'Knight' )
{
$mysql75 = mysql_select_db( $SiteSQL["config-database_db"] , $Site_sqlcon) or die( mysql_error() );
$query2b = "SELECT a_user_index, a_name, a_level, a_job, a_job2, a_skill_point, a_hp, a_mp FROM t_characters WHERE a_job = 1 AND a_user_index = ". $User->ID ." AND a_enable = 1 ORDER BY a_level desc LIMIT 4";
$Rank = 1;
$result22b = mysql_query ($query2b);
} else {
$mysql75 = mysql_select_db( $SiteSQL["config-database_db"] , $Site_sqlcon) or die( mysql_error() );
$query2b = "SELECT a_user_index, a_name, a_level, a_job, a_job2, a_skill_point, a_hp, a_mp FROM t_characters WHERE a_user_index = ". $User->ID ." AND a_enable = 1 ORDER BY a_level desc LIMIT 4";
$Rank = 1;
$result22b = mysql_query ($query2b);
}
while($list33b = mysql_fetch_array( $result22b ))
{
$Info = new Info();
$Info->ClassJob( $list33b['a_job'] , $list33b['a_job2'] );
$ClassImage = './Template/Img/' . $Info->Class . ".gif";
$Top100_rank = $Rank++;

mysql_select_db( $SiteSQL["config-database_site"] , $Site_sqlcon) or die( mysql_error() );
$reborn_settings = mysql_query("SELECT a_reborn_level, a_reborn_amount, a_reborn_enable FROM t_settings WHERE a_index = '1'");
while( $reborn_settings1 = mysql_fetch_array( $reborn_settings) )
{
$RB_level = $reborn_settings1["a_reborn_level"];
$RB_amount = $reborn_settings1["a_reborn_amount"];

if (($reborn_settings1['a_reborn_enable'] >= "Enable"))
{
if(isset($_POST['reborn'])) {

mysql_select_db( $SiteSQL["config-database_db"] , $Site_sqlcon) or die( mysql_error() );
$chars_info = mysql_query("SELECT a_index, a_user_index, a_name, a_level, a_hp, a_str, a_dex, a_int, a_con, a_teach_complete, a_job, a_job2, a_reborn, a_exp, a_statpt_remain FROM t_characters WHERE a_user_index = ". $User->ID ."");

$r = 1;
$t = 1;
while( $row = mysql_fetch_array( $chars_info ) )
{
if (($row['a_level'] >= $RB_level) && ($row['a_reborn'] < $RB_amount))
{
$doreborn = mysql_query("UPDATE t_characters SET a_level=1, a_exp=0, a_reborn=(a_reborn+1),a_statpt_remain=(a_statpt_remain+500), a_hp=(a_hp+5000) WHERE a_name ='".$list33b['a_name']."' AND a_user_index = ". $User->ID .""); // Here Can Edit For Some Special gift in reborn sys ;D i added 5k hp each reborn ;D
echo '"<font color="gold">The reborn was a success! '. $list33b['a_name'] .' is now reborn <br/>Level 1, with your '. $RB_level .' stat points + 5000, Skills not reset.</font>"' ;
} else {
echo '<font color="red">Not met the requirements (Must be '. $RB_level .' + under '. $RB_amount .' reborns)</font>';
}
$r++;
$t++;
}
}
} else {
echo 'Reborn System Disabled !';
}
}

?>
<tr>
<td width="15"><b><center><?php print $Top100_rank; ?></center></b></td>
<td width="20"><span class="color"><center><img title="<?PHP print $Info->Class; ?>" src="<?php print $ClassImage; ?>" /></center></span></td>
<td width="50"><font color="#927D61" size="4"><center><?php print $list33b['a_name']; ?></center></font></td>
<td width="50"><font color="#e78282" size="4"><center><?php print $list33b['a_level']; ?></center></font></td>
<td width="10"><span class="color"><center><?php print $list33b['a_skill_point']; ?></center></span></td>
<td width="10"><span class="color"><center><?php print $list33b['a_hp']; ?></center></span></td>
<td width="10"><span class="color"><center><?php print $list33b['a_mp']; ?></center></span></td>
<td width="10"><span class="color"><center><?php print $rbsys; ?></center></span></td>
</tr>
<?php } ?>

<?php
}
else{
echo 'No Logged ! Please Login For Excange Online Time Points !' ;
}

 

it will show you all character you got on your account and for each character you can click "Reborn" button and it will reborn you to lvl 1 and some features ;D

 

All Credits to MaX For creating scipt

 

i only fix for new version of hes website ;D

 

Have Nice Night

Hi Community, i decided to make a litle Guide

How to: Add Skyrim Weapons in Last Chaos

Tools i use :

Cinema 4D R 12
[Maxon]

Chaoskit Plugin for Cinema 4D R 12 [ 2 ][Freeware]
[hoostler:2 ]

Photoshop CS 5 Extended
[Adobe]

F03 Archive Utility [ 2 ][Freeware]
[scripterRon: 2 ]

Nvidia Texture Tool Plugin for Photoshop[ 2 ][Freeware]

Nifscope [ 2 ][Freeware]

Textool [ 2 ][LC Editor Pack]

!U need to Install all these Plugins and Tools. If u got Problems with Install them or get them working pls READ the Topics and Information on the Dev Homepages!

1.Download all Tools u need

2.U need to unpack the Meshes.bsa and Textures.bsa archive with FO 3 Archive Utility

(C:\Program Files (x86)\The Elder Scrolls V Skyrim\Data)

 
[step 1] Cinema 4D and Nifscope

3.Open Nifscope and Open the Directory where u saved the unpacked meshes then open ...\meshes\weapons\

4.Select the Weapon u like (i will select Deadric Greatsword: ...\meshes\weapons\deadric\daedricgreatsword.nif )

and Export it to FileName.obj : File->Export->

5.Open the .obj file with Cinema 4D and click: File->Merge and open
Last Chaos Folder\Data\Character\Knight\ni_hn_000.bm
(Example for Knight u can load Healer ,Mage, Titan ... etc Hands too if u want to make them for mage)

6.Bring your modell in position and select ur model rename it to ni_sword_001

(Just an example you need it later for texture)

Then select ur modell and click -->Character-->Commands-->Bind

7.Click -->Character -->Joint ;rename Joint to Bone01

2

8.Select the Weight tag and drag & drop Bone01 in it

9.Select -->Character-->Weigh-Tool and paint the Sword ("But :deselect Visible Only")

10.Delete the ni_hn_000.bm in Cinema 4D

 
[We will come later back to Cinema 4D]

[step 2] Photoshop and Texture

11.Open ...\textures\weapons\daedric\daedricsword.dds with Photoshop

12.Save the file as ni_sword_001.png

 
[Now we will get back to Cinema 4D]

13.Create a new Material in Texture

14.Double click on it and merge a Texture and select ni_sword_001.png and rename the Material to ni_sword_001

15.Export the file to ni_sword_001.bm and save it in Your Last Chaos\Data\Weapon\YourFolder\

16.Create a Folder in the same Directory named Textures

17.Open TexTool.exe and open ni_sword_001.png and export it to ni_sword_001.tex with DTX 3 Compression in Folder Texture

18.Copy a .smc from other Weapon ,rename it to ni_sword_001.smc and edit it with ItemAllEditor [Wizatek]

19.Add the Weapon into the Client and Database

 
This is just an Example for Knight Sword .If u got any Questions or Problems just ask here in this Topic.

I will extend this Guide to show how to add a Bow or Axe for Example

If u want to Add Armor just do it like i explained and merge for example a knight armor ,

copy the bones and add them in the weight tag. Then look how there are painted and do the same.

I Hope this Guide is usefull .If i forgot somethink just say that .This is my first Guide i ever done hope its usefull for u

 
Have a nice day - Wahrheit

Hey Com,

 

today i was going to setup the paymentwallaccount of my server.(after anotherone failed)

Anyways there is one question:

Wich Service Type?

I think I should take Game but idk if thats the best way... Nonprofit seems more simple...

 

 

Greetz Creep

Hey Guys I worked on it for abiut 3 hours ;D

 

I want to show you my new script for change time point for cash !!!

 

Here Are :

 

// Check For Login
if( $User->LoggedIn == true )
{

$mysql1 = mysql_select_db( $SiteSQL["config-database_auth"] , $Site_sqlcon) or die( mysql_error() );
$query1 = mysql_query("SELECT cash from bg_user WHERE user_code = ". $User->ID ."");
$result1b = mysql_fetch_array( $query1 );
$mysql2 = mysql_select_db( $SiteSQL["config-database_site"] , $Site_sqlcon) or die( mysql_error() );
$query2 = mysql_query("SELECT a_online_time from t_user_log WHERE a_account_index = ". $User->ID ."");
$result2b = mysql_fetch_array( $query2 );
$cash = $result1b['cash'];
$onlinetimepoints = $result2b['a_online_time'];

echo'<center>';
echo 'Your Currenty Cash Is : ';

print $cash;

echo'<br>';
echo 'Your Currenty Online Time Points : ';

print $onlinetimepoints;
echo '<br>';

if(isset($_POST['change'])) {
$mysql1 = mysql_select_db( $SiteSQL["config-database_auth"] , $Site_sqlcon) or die( mysql_error() );
$query1 = mysql_query("UPDATE bg_user SET cash = cash + ". $onlinetimepoints ." WHERE user_code = ". $User->ID ."");

$mysql2 = mysql_select_db( $SiteSQL["config-database_site"] , $Site_sqlcon) or die( mysql_error() );
$query2 = mysql_query("UPDATE t_user_log SET a_online_time = 0 WHERE a_account_index = ". $User->ID ."");

$mysql1 = mysql_select_db( $SiteSQL["config-database_auth"] , $Site_sqlcon) or die( mysql_error() );
$query1 = mysql_query("SELECT cash from bg_user WHERE user_code = ". $User->ID ."");
$result1b = mysql_fetch_array( $query1 );
$mysql2 = mysql_select_db( $SiteSQL["config-database_site"] , $Site_sqlcon) or die( mysql_error() );
$query2 = mysql_query("SELECT a_online_time from t_user_log WHERE a_account_index = ". $User->ID ."");
$result2b = mysql_fetch_array( $query2 );
$curonlinept = $result2b['a_online_time'];
$curcash = $result1b['cash'];

echo 'Now You Got(Cash) : ';
print $curcash;

echo '<br>Now You Got(OnlinePoints) :';
print $curonlinept;
}
?>
<form id="form1" name="form1" method="post" action="">
<input name="change" value="Time For Cash !" type="submit" />
</form>
</html>
<?php

echo '</center>';

}
else{
echo 'No Logged ! Please Login For Excange Online Time Points !' ;
}

 

You Must Use It For Your Page ;D

 

Have Fun !

 

Some Things :

 

 

2

2

 

 

THIS IS CREATED BY MYSELF !!!

Releasing my premium site with new features added.

Download : 2

 

Features :

News on Home (Credits to Max)

Member CP (Reset lvl, Reset red, delete character)

Secure register (Credits to Wizatek)

Full Class Ranks

Guild Ranks

News System (Add/Delete News)

Ban System (choose between blocking account or ip ban)

Website Setting's

Change Character name (admin)

Give Cash (admin)

View Logs System (admin)

Account settings

Castle Siege block

Exchange online points with cash (Credits to Max's onlinetime script)

Send Cash to other players

Credits to MaX and Wizatek for they're codes.

 

 

bg_user patch will get an error if you already have the column ip and or a_online_time.