Coniesan

lol sry @all but try this Go to char.cpp (serverside) there u have your "INSERT" Query // Insert char szQuery2[512]; snprintf(szQuery2, sizeof(szQuery2), "INSERT INTO %soffline_shop_npc(owner_id, sign, name, time, x, y, z, mapIndex, channel) VALUES(%u, '%s', '%s', %d, %ld, %ld, %ld, %ld, %d)", get_table_postfix(), GetPlayerID(), c_pszSign, GetName(), iTime, GetX(), GetY(), GetZ(), GetMapIndex(), g_bChannel); DBManager::Instance().DirectQuery(szQuery2); replace it with: // Insert char szSign2[SHOP_SIGN_MAX_LEN+1]; DBManager::instance().EscapeString(szSign2, sizeof(szSign2), c_pszSign, strlen(c_pszSign)); char szQuery2[512]; snprintf(szQuery2, sizeof(szQuery2), "INSERT INTO %soffline_shop_npc(owner_id, sign, name, time, x, y, z, mapIndex, channel) VALUES(%u, '%s', '%s', %d, %ld, %ld, %ld, %ld, %d)", get_table_postfix(), GetPlayerID(), szSign2, GetName(), iTime, GetX(), GetY(), GetZ(), GetMapIndex(), g_bChannel); DBManager::Instance().DirectQuery(szQuery2); the "DBManager::instance().EscapeString()" methode should be default in your db.h So have fun

I can #added u

It looks nice But u have to be careful, cause of Copyright of Nintendo... If you (perhaps) remember, some months ago, someone started a project on kickstarter, for a Minecraft movie! Notch stopped this project after a few hours....!

#updated: added "darkstat" as traffic monitor

Try this: env | grep -i shell the output should be: SHELL=/bin/csh But the default output (for normal useres) is: SHELL=/bin/sh Execute this in command line: chsh -s /bin/csh And the prompt will change after su or relogg on the user Like this:

Here I found the complete lib archive on my server: [Hidden Content] Just download and extract it in your lib folder (on i386 I thought it was in /lib) cd /lib fetch [Hidden Content] tar xzvf 64bit_libs.tgz rm 64bit_libs.tgz

Try this: [Hidden Content]

I thought, this are the basics you should know if you work with the command line...! You can use almost everything on linux systems, too (some even on windows) If someone have a command, or an other question, how he/she can do anything with command line, I'll in the future add commands and/or ways how to do or deal with it #Edit: Thanks, my mistake, edited it

Hey @ all, I hope a thread like this doesn't exist right now! Introduction: Here u'll find some basics you should know, and some things which makes your life easier! So let's go: First of all, the command-line! If you often uses putty (or s.th. else) it helped me a lot to change the default prompt! Here my favorite: Second thing is the SCP Service! Most of u know "winscp" which is based on the unix scp service! Here some helpful commands: To get all important CPU informations, you can use this: If you wanna know s.th. about your used memory(RAM/SWAP) and so on, you can install "free" (which is a basic command on linux) It's an perl script, so you have to install perl if you doesn't One more thing is the traffic! Kind regards

Hey @ all For that people who are using Debian 6 and Apache could this be very nice! People who are using nginx, you are normaly safe, but if you fuck your configs up, slowloris can be a problem for you, too 1. What is slowloris? Slowloris is a perl script, which allows you to open hundreds of sessions on your webserver and hold them open! So your webserver crashes if it reaches ~700 connections at the same time 2. How to fix it? 1. Download and extract the mod wget ftp://ftp.monshouwer.eu/pub/linux/mod_antiloris/mod_antiloris-0.4.tar.bz2 tar -jxvvf mod_antiloris-0.4.tar.bz2 cd mod_antiloris-0.4/ 2. Install the compile kit: apt-get install gcc apache2-threaded-dev3. compile mod_antiloris /usr/bin/apxs2 -i -c mod_antiloris.c4. import the mod to apache echo "LoadModule antiloris_module /usr/lib/apache2/modules/mod_antiloris.so" > /etc/apache2/mods-available/antiloris.load a2enmod antiloris5. restart it /etc/init.d/apache2 restartI hope you enjoy it!Kind regards

@iRemix, no "pkg_add" isn't rly secure, cause it won't compile the mysql files, so if the host uses modified kernels it could be, that the mysql bin doesn't work anymore with this kind of install! @Rumor, please don't give the external mysql users grant option... that's evil and not rly safe! You additionaly shouldn't give the M2 User grant option, cause, FOR WHAT HE SHOULD NEED IT?! Hacking database, if u useing a modified game/db core with evil backdoor functions? And for the Web-server ... I personally am of the opinion, FreeBSD isn't an OS for webhosting... I often had problems cause of missing pkg's or s.th. else... Kind regards