tierrilopes

" bought serverfiles "

You need give more information here.

But let me guess, the person you bought from sent you a tar.gz and told you to extract it (or the person installed it for you) ?

If so, i've seen most backdoors inside the db/mysql.  We need to view the files in order to see the issue, else its just guessing

Main makefile, add:

@rm -rf exported_libs
@mkdir -p exported_libs
@ldd db/db | tail -n+2 | awk '{sub(/.*=> /, ""); print}' | sed 's/([^)]*)//g' | sed -e 's/^[ \t]*//' | xargs -I {} cp {} exported_libs/.
@ldd game/game | tail -n+2 | awk '{sub(/.*=> /, ""); print}' | sed 's/([^)]*)//g' | sed -e 's/^[ \t]*//' | xargs -I {} cp {} exported_libs/.

When removing the INDEX, you need to be carefull with your search method, and notice if its searching by FILE or INDEX.

You can replicate the order in your executabe following the order at your INDEX.

But while you are at it, i advise you to merge the whole client into a single folder, replacing files according to the reverse INDEX order.

That way it will ask you to replace files (you accept) eliminating the duplicates.

You need first to remove the seasonX/ from your client.

That will give you some work but you will end up with a no duplicates slightly smaller client.

Then you wont have to worry about packs loading order (its just another bad practice from webzen).

Sometimes i reply, not because i want to be unpleasent, but because i see too much wasted time on things that shouldnt have time spent on.

Add this to your makefile before all the makes to touch the files:

@find . -type f | xargs -n 5 touch

To make commands to build / strip etc without going to folder or even running your python script, just add commands to your sbin.

For example a sbin command "rebuild"  with the content of:

cd /your/location && gmake rebuild -j

So that everytime you run your "rebuild" command at ANY location, it will do the action above.

In my opinion the time you spent making such a tool is not worth the outcome.

Sometimes is better just to use the default tools and dont complicate.

Dont take this as a trolling or insult, is just to give you my advise to spend time on other stuff that deserve it, after all time is finite and should be well spent.

Only because you wanna be a big boy spamming to close servers, how about we make a batch mt2server maker so people can make a full server in a matter of minutes fully automated?

Seems a fun way to troll you

28 minutes ago, Miyu92 said:

That's not my server as I said. I'm just trying to help the GF.
 

Then GF can pay us and we will fix it for them.

No € = No C++

Serverfiles are a all the same, bunch on quests, maps and mobs.

You dont download and use serverfiles, thats what newbies are recommending to you still.

First step is to make your own serverfiles structure, clean of all quests, drops, etc. So that you have a good working ground.

With that you also should use a client as untouched as possible.

In topic:

Difference between serverfiles is their game / db binaries and their share folder.

Game / db binaries may contain different or modified systems from serverfile to serverfile.  This you solve by compiling and doing your own set of game / db.

Share folder contains the mob drops, quests, maps. Here you should start from 0 quests and add them as needed, so you really know whats there.

It can really be insecure to use serverfiles from people, as most wannabes will add malware to it. This happens because almost everyone will tell you to extract "tar.gz" in hardcoded folders, instead of teaching you how to make it from scratch.

A note: When someones tell you to install mysql by extracted its mysql folder into /var/db/mysql, you know that person is an absolute 0 and most likely just a tutorial follower.

People use freebsd because metin2 game / db was built in it. You can adapt it to for example ubuntu, now you will find freebsd to be a real mature and overall good OS.

For database edits, you can use Navicat or Mysql Workbench, those are the most used for easy visual databse editing. Regarding your specific edit, most probably your serverfiles were using the mob_proto from .txt files and replicating it to the databse, in that case all changes made on database are ignored and replaced by .txt ones. So you need to edit the .txt file instead (select all, paste into empty excell document is the easiest as it will auto adapt all columns) OR make your server read information from database.

Python is for the client, as you are starting you dont need such a big knowledge of it as there are well structured tutorials for it. Its more a common understanding of programming, with time you will see what does what.

C++ is needed for the server and client sources, but again like python, learn programming. If you know how to program, you can code in any language, its just a matter of learning that language specific syntax (thats what documentation exists for).

Regarding doubling the space of shop, lets pretend i have no clue where it is:

1 - I will try to find identify the function / functions that open shop for example

2 - I will trace the variables it uses

3 - I will check the variable types in this case, as different variable types can have different maximum / minimum sizes.

For finding and following things, visual studio and its search + intellisense its a wonder

Complete full understanding of the game, you will not have now.

With time and practice you will memorize what comes from, its normal in every project

Client executable:

if (strstr(GetCommandLineA(), "--argument") == nullptr) {
		exit(0);}

C# patcher:

 Process.Start("metin2client.exe", "--argument"); #if issues, remove both -- from here

So you can get a list of cidrs for a given country and add them to IPFW:

Get lists here:

https://www.ipdeny.com/ipblocks/data/countries/XX.zone

Where XX is the two digit country code, for example:

https://www.ipdeny.com/ipblocks/data/countries/fr.zone

You can manualy paste those into your table, or make a batch to do it for you. Using that example it will be something like:

ipfw -q table BLOCKED add 103.122.52.0/24

ipfw -q table BLOCKED add 103.133.84.0/22

etc

Considering your table is named BLOCKED.

Protect a dummy client, put it on the cheapest vps you can find and provide some accounts (user1 pass / user2 pass  and such) and put download here.

Im sure someone will review it after.

Seems that there are issues understanding two simple phrases so let me make it easier:

• Npclist              : npclist.txt
• dog mode        : bark bark, 4 legs, fur
• years ago.       :  ancient
• visual mod      : placebo

Npclist based dog mode made some years ago.

For other mobs, no science, just swap folder in front of the mob vnum into "stray_dog" and voilá.

Dropbox

On 11/5/2019 at 4:13 PM, easyx said:

Thanks for the answer actually i tried to look what the privilieges mean at the user table and found something like a mysql guide but couldnt see quite  through that so if you could explain me them that would be awesome

Sent discord

On 11/4/2019 at 7:40 AM, easyx said:

Hey thanks for the answer and can configure that on Navicat to only insert in account/acccount or is this website based?

You can easilly do that on navicat for exemple, if you need help i can show you how

You check your queries to view what operations they do.

Usually its just "Select, Insert, Update".

But again, insert should only be in account.account and not the whole account.* for example.

Same for other types, they should only access the exact table they need to, not the whole thing.

It leads to an issue.

If you have a player named RIPBAN1 and use your system, the person can make another account and reuse the character name "RIPBAN1".

If you say the player RIPBAN1 was banned, do your cleaning, have someone else/the banned person make another char called RIPBAN1, you will have hate upon you saying its "corruption" and that the player "was not banned at all" and all of that stuff comming from cry babies players.

Maybe you could delete all, except the player.player itself, so that that character name is not re-usable.

You could also clean from player.affect

3 hours ago, enisina said:

When you exit the game, mount continues ?

You wanna know if the mount time continues to decrease even if you are logged off?

It depends, as both options are available. The time of the mount can decrease only if its being used or it can count even if character is offline.

Post here the corresponding mount proto line and you will be informed about it.

On 9/29/2019 at 6:01 AM, Rakancito said:

Please big projects in PHP sucks.

 

i'm not a programmer Web,

I do not always see crap on the internet, but when i do its legendary.

Some stuff to clean your db:

TRUNCATE TABLE account.account;
TRUNCATE TABLE common.gmlist;
TRUNCATE TABLE log.attr_transfer;
TRUNCATE TABLE log.bootlog;
TRUNCATE TABLE log.change_name;
TRUNCATE TABLE log.command_log;
TRUNCATE TABLE log.cube;
TRUNCATE TABLE log.dragon_slay_log;
TRUNCATE TABLE log.dragonlair_dungeon;
TRUNCATE TABLE log.exo_bank_log;
TRUNCATE TABLE log.fish_log;
TRUNCATE TABLE log.gmhost;
TRUNCATE TABLE log.gmlist;
TRUNCATE TABLE log.goldlog;
TRUNCATE TABLE log.hack_crc_log;
TRUNCATE TABLE log.hack_log;
TRUNCATE TABLE log.ingame_ban_log;
TRUNCATE TABLE log.levellog;
TRUNCATE TABLE log.locale;
TRUNCATE TABLE log.locale_bug;
TRUNCATE TABLE log.log;
TRUNCATE TABLE log.loginlog;
TRUNCATE TABLE log.loginlog2;
TRUNCATE TABLE log.meley_dungeon;
TRUNCATE TABLE log.money_log;
TRUNCATE TABLE log.okay_event;
TRUNCATE TABLE log.pcbang_loginlog;
TRUNCATE TABLE log.quest_reward_log;
TRUNCATE TABLE log.refinelog;
TRUNCATE TABLE log.sash;
TRUNCATE TABLE log.shout_log;
TRUNCATE TABLE log.speed_hack;
TRUNCATE TABLE log.voucher_log;
TRUNCATE TABLE log.whisper_log;
TRUNCATE TABLE player.affect;
TRUNCATE TABLE player.guild;
TRUNCATE TABLE player.guild_comment;
TRUNCATE TABLE player.guild_grade;
TRUNCATE TABLE player.guild_member;
TRUNCATE TABLE player.guild_war;
TRUNCATE TABLE player.guild_war_bet;
TRUNCATE TABLE player.guild_war_reservation;
TRUNCATE TABLE player.horse_name;
TRUNCATE TABLE player.item;
TRUNCATE TABLE player.item_award;
TRUNCATE TABLE player.marriage;
TRUNCATE TABLE player.messenger_list;
TRUNCATE TABLE player.player;
TRUNCATE TABLE player.player_deleted;
TRUNCATE TABLE player.player_index;
TRUNCATE TABLE player.quest;
TRUNCATE TABLE player.safebox;

Your log tables may differ.

If someone get affected by "ddos" from "cheap", i advice you to quit playing with servers, you understand a big 0.

Meanwhile, lets wait to see what other great design he will provide us.

Better design = better protection, everyone knows it

Indeed, everyone can copy-paste shitcode, because shitcode is not real code.

Oh boy, maybe he got another counter design now

Buy now or else!

3 hours ago, iMeleys said:

anything new about rubinum2 ?

Yes, rubinum bought the license and is now an official server.

Let me present it to you in the image bellow:

This is why gameforge sends dmcas.

3 hours ago, iMeleys said:

wow.. (writing my text for nothing "yeah meleys think over it")

I am not seeing that option before in my mind..
you can simply run the command over the mysql command line
awesome you are great thank you for saying me it ! i love you xD
 

ahah wasnt my intention to be mean or something like that, sorry if you understood it that way.

most of time im on phone and i just write fast and send