hi all

 

just got even a login_flag created so that everyone can change after his election

have fun with it

I'll try as I have time datein all graphics to create a psd file

 

a fat enough for me thank you

 

mfg

blade5000

 

[hide]2[/hide]

Hey Guys im back but not with a problem, its more an question for a Idea ^^

I wanna make a Offline Seal System in C# with a Console.

 

But im stuck on a Method how i work on the Accounts which are offline^^

I select in t_users the Accounts who are offline and then i wanna seal the Armor & Weapon if the character is logged off ^^

But to be serious i have no idea there to start.

 

i thougt so:

Get the Accounts which are Offline

Select the Characters from the Accounts

Seal the Items..

 

But how i make this for every account who is offline?

I can make it with 1 but how for 100 ?^^

 

Sry i cant explain it right ^^

 

Here i select the Accounts which are offline so what i gonna do now?

public void GetCharacterToSeal()
{

Read();
Console.BackgroundColor = ConsoleColor.Black;
Console.ForegroundColor = ConsoleColor.White;
DateTime date = DateTime.Now;
MySqlConnection con;
MySqlConnectionStringBuilder csb = new MySqlConnectionStringBuilder();
csb.Server = Ip;
csb.UserID = User;
csb.Database = user_db;
csb.Password = pw;
con = new MySqlConnection(csb.ConnectionString);
MySqlConnection connection = new MySqlConnection(csb.ConnectionString);
connection.Open();

string sql = @"SELECT count(a_index) FROM t_users WHERE a_zone_num = -1 "; //Zählen
MySqlCommand Command = new MySqlCommand(sql, connection);
int i = Command.ExecuteNonQuery();
MySqlDataAdapter dtAdp = new MySqlDataAdapter(sql, connection);
string result = Convert.ToString(Command.ExecuteScalar());
Console.WriteLine(date + " : : People offline and able to Seal Items: "+result);
}

Hey guys

I wanna Release a maybe helpful Tool for the Community.

With this Tool you can Edit what the NPC Drop and you can Edit the Rates of your Server.

You need to open the Settings.cfg first and config your Database conenction or it will display a Error on Start.

If you find some bugs please post in Topic.

 

2 

Dont forgot to press Thanks

Download:

2

Screen :

 

 

 

 

 

 

 

Download :

 

2

 

 

By KaKoke

evo 1

------------------------------------------------------------------

evo 2

----------------------------------------------------------------

evo 3

__________________________________________________

evo 1

_________________________________________________

evo 2

__________________________________________________

evo 3

 

__________________________________________________________________________________

evo1

__________________________________________________________________________________

evo 2

________________________________________________________________________________

evo 3

________________________________________________________________________________

 

[hide]

 

DOWNLOAD LINK >>>> 2

 

[/hide]

Hi, as some people don't know how to make Files auto restart with bat here is the guide for windows servers:

 

We got two options:

Option 1 (Always work)

Option 2 (Not always work)

Option 1

 

Go to windows > Run..> and type regedit, you will open Registry Editor.

 

Go to the following Location:

 

HKEY_CURRENT_USER\Software\ Microsoft\Windows\Windows Error Reporting\

 

3.- Double Click on the file called DontShowUI a new window will open.

 

4.-Change the Value from 0 to 1 in Hexadecimal.

 

5.-Now go to other location:

 

HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Control\Windows\ErrorMode.

 

6.- And change the value to 2 (Hexadecimal)

 

Option 2

 

Run this command on cmd not always work so i recommend to use the option 1 as it will take 1 minute more and will never fail.

 

Command:

serverWerOptin /disable

Hello! I want to programm a "tool" to see in the webpanel of my website the Inventorys of my chars

 

For example my char had the unique ID: 981, what i must du, to see the full Inventory? or the Money?

 

How to parse the images with the icons of armor etc? (Solved)

 

 

THX for Help

 

//EDIT:

 

To Parse Picture:

Get ROW: (e.g: 8)

Get Collum: (e.g: 9)

Get FileID (ItemBtn0.png)

(ItemID: 20)

ID20 { display: inline-block; width: 32px; height: 32px; background: url(ItemBtn0.png) no-repeat 0 0; }
ID20 { background-position: -288px -256px; }

Short script to get the Icon:

// CONFIG
$SIZE = "32"; // 32x32 standart

// CONFIG --> ItemID = FileID,COL,ROW
$ID['19'] = "0,0,0";
$ID['20'] = "0,8,9";

$IDENT = $_GET['id'];
if(!isset($ID[$IDENT])) {
echo "Error!";
exit;
} else {
echo "<style>";
$R = mb_split(",",$ID[$IDENT]);
$ITE = $R[0];
$COL = $SIZE*$R[1];
$ROW = $SIZE*$R[2];

echo '
ID'.$IDENT.' { display: inline-block; width: 32px; height: 32px; line-height: 32px; background: url(ItemBtn'.$ITE.'.png) no-repeat 0 0; }
ID'.$IDENT.' { text-decoration: none; background-position: -'.$ROW.'px -'.$COL.'px; }
';
echo "</style>";
echo "<ID".$IDENT."></ID".$IDENT.">";
}

Here you can see how to change some color of weapon very easy

 

2

Hello all,

I`m interesting all about WS 2008, its making stable server? no crashes connector? if crashes auto closes it? (at win7 it need to turn off program manually because restarter not resets it)

If Decide To Install, how it happens and need to install as MAIN windows status or need to use other programs (like Virtual Box - Second PC) if use another programs which programs?

 

 

I hope Anyone Will Help, Thanks

I HAVE MAKE A TUTORIAL FOR YOU CAN SEE HOW TO RUN MORE SUBSERVER