Raijin

ok das jetzt blöd ich kann den ganzen script wegwerfen :/ zwar macht der das was ich will aber der speichert nur die letzen einträge also wenn ich 4 vote seiten eingf. habe sieht man dort nur 4. Dachte der speichert in die Datenbank alle votes die man gemacht hat müsste dann höchstwarscheinlich den skript des vote 4 points umändern naja mal gucken was daraus wird.

so hab folgenden sql code: set .@nb,query_sql("SELECT account_id, count(account_id) FROM cp_vfp_logs GROUP BY account_id", .@account_id$, .@anzahlid$ ); for(set .@i,1; .@i <= .@nb; set .@i,.@i+1) mes "Acc ID: "+.@account_id$[.@i]+" Anzahl v4p "+.@anzahlid$[.@i]; close; wie kann ich machen das der die anzahl id in eine variable speichert die dann ausgegeben wird Stimmt der code überhaupt bin echt schlecht in sql EDIT: So der zeigt mir jetzt eine Liste mit allen acc + deren vote points Wie kriege ich hin das nur ein bestimmtes acc darauf zugreifen kann?

THANKS /thx /thx /thx /thx /thx I was searching everywhere in modules and in themes Directory But REALY THANKS NOW I HAVE SOME CUSTOM LINKS

Hallo, Ich möchte ein NPC erstellen womit ich auf die SQL DB zugreifen kann, damit ich aus der vote for points DB die Daten nehmen kann und daraus Vote Tickets bekomme. (Gibt es überhaupt sowa in der art) Ich benutze folgenden vote-for-points script: http://rathena.org/board/files/file/2849-vote-for-points-for-fluxcp-free/ Ist das überhaupt möglich mit einem NPC auf die DB zuzugreifen? Wenn ja wie? Kann man danach die einträge drinnen löschen? MfG Raijin

Hello, How can i make custom Links in FlucCP?(Like in my Pictures) Greets Raijin

Vielen dank für deine antwortet Sunzuke darf ich dein Skript auch verwenden? Grüße Raijin

Hallo zusammen, ich hatte da mal ne frage: ich arbeite mit pre-re Ich habe ein existierenden Mob aus dem item_db zB weiter unten eingefügt und etwas stäker gemacht weiter habe ich in mob_avail: editiert. meine drops_conf ist fogendermaßen: so mein problem ist das das neue poring kein item dropt nicht mal zu 0.01% Ich weiß nicht was ich übersehe/falsch mache. Ich habe schon stundenlang gesucht aber das einzig Brauchbare was ich gefunden habe ist dass ich mit einem Script OnNPCKillEvent ein bestimmtes Item ins Inventar lagen kann, aber wie kann ich die Drops der "Custom" Mobs generell einstellen? zusatz Frage: Kann mann irgentwo eintragen, dass die Mobs ab einer betimmten ID wieder normale bzw andere rates haben? vielen dank schonmal im vorraus und LG Raijin ok gelöst... selten dähmlicher Fehler ich bin in der mob_db um eine stelle verrutcht und dafür habe ich edliche Stunden verschwendet...

Hello, top from tur_dun04 100 100 (where turtle general is) are no chairs. Is there missing a file or something like that? I just found it accidently couse its my favorite mvp. Could be there more places like that where files are missing? Greets Raijin

There is a unidentified symbol in Defence Rate in Buyer/Seller NPCs. How can i delete it? Its really annoying /sob .

thx Asura you are great /no1 EDIT: Sorry to open it again. I changed my FluxCP. But know its always wants to have ragnarok as username and ragnarok as password for mysql connection. But I already edited servers.php and i can see the changes with WinSCP.

In my server EDIT: do you mean /var/www/ Where i put my folders for webpages??? Or do you mean my Server location? Its in münich Germany. EDIT: I dont know how but I get it managed it to work. But i just want to install it new so i deleted the whole folder and put the same Flux CP again. But know i cant install it via php. How can i make it to install it again? Are there still files i havent deleted?

After trying diffrent sollution i just have uninstalled mysql und phpmyadmin and reinstalled again. now i have this error. Exception Details Error: PDOException Message: SQLSTATE[HY000] [2013] Lost connection to MySQL server at 'reading initial communication packet', system error: 111 File: /var/www/lib/Flux/Connection.php:81 File Line Function/Method /var/www/lib/Flux/Connection.php 81 PDO::__construct() /var/www/lib/Flux/Connection.php 94 Flux_Connection::connect() /var/www/lib/Flux/Connection.php 159 Flux_Connection::getConnection() /var/www/modules/install/index.php 17 Flux_Connection::getStatement() /var/www/lib/Flux/Template.php 337 include() /var/www/lib/Flux/Dispatcher.php 168 Flux_Template::render() /var/www/index.php 177 Flux_Dispatcher::dispatch() EDIT : think i know my error: When i use telnet 127.0.0.1 3306 its working. BUT When i use it with my server IP its not working: PHost 'hostname' is not allowed to connect to this MySQL serverConnection closed by foreign host. BUT I have edited my.cnf: [mysqld] # # * Basic Settings # user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql tmpdir = /tmp language = /usr/share/mysql/english skip-external-locking # # Instead of skip-networking the default is now to listen only on # localhost which is more compatible and is not less secure. bind-address = 0.0.0.0 # I read some where when i put bind-address to 0.0.0.0 the mysql server will listen to everyting. I tried to open ports but its not working. EDIT2: I used this to open ports: iptables -A INPUT -p tcp --dport 3306 -s my.ip.addres -j ACCEPT Is this right? Have i do something wrong? EDIT3: Im using telnet serverip 3306 and its working. But when i try to open Flux CP its comes error again. Message: SQLSTATE[28000] [1045] Access denied for user 'xxx' (using password: YES)

i cant login to mysql with my root account what happend omg 5 mins ago i could go in but now its not working ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES) The password is the right one but i dont know why its not working i try it so many times and my capslock is not on EDIT: I changed the password but it still not working. I think its not the fault of the password i got denied i dont know why. Im a noob in linux :/

i have done this: http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html but still not working maybe i do something wrong

I get this error when im trying to configure FluxCP. I have tried to open ports but it has brought nothing. My database have grand acces. What im doing wrong? Greets Raijin Exception Details Error: PDOException Message: SQLSTATE[HY000] [1130] Host '--save' is not allowed to connect to this MySQL server File: /var/www/lib/Flux/Connection.php:81 File Line Function/Method /var/www/lib/Flux/Connection.php 81 PDO::__construct() /var/www/lib/Flux/Connection.php 94 Flux_Connection::connect() /var/www/lib/Flux/Connection.php 159 Flux_Connection::getConnection() /var/www/modules/install/index.php 17 Flux_Connection::getStatement() /var/www/lib/Flux/Template.php 337 include() /var/www/lib/Flux/Dispatcher.php 168 Flux_Template::render() /var/www/index.php 177 Flux_Dispatcher::dispatch() Exception Trace As String #0 /var/www/lib/Flux/Connection.php(81): PDO->__construct(*hidden*) #1 /var/www/lib/Flux/Connection.php(94): Flux_Connection->connect(Object(Flux_Config)) #2 /var/www/lib/Flux/Connection.php(159): Flux_Connection->getConnection() #3 /var/www/modules/install/index.php(17): Flux_Connection->getStatement('SELECT VERSION(...') #4 /var/www/lib/Flux/Template.php(337): include('/var/www/module...') #5 /var/www/lib/Flux/Dispatcher.php(168): Flux_Template->render() #6 /var/www/index.php(177): Flux_Dispatcher->dispatch(Array) #7 {main}

thx /no1 /no1

How i can Start the Server console (when its get closed) without restarting the server /? I was using this but i dont want to kick all players out. ./athena-start restart Greets Raijin

How can i make my Client folder Smaller? There so many dll files are they all important? I used the Client Cleaner tool. But its still full of files. Are there unneseray things that i can delete? Greets Raijin

is it normal that my client close when im trying a wrong password? How can i deactivate it? EDIT: Solved i just need 2 hex the client with WDGRemoveLoginAutoClose.dll https://github.com/greenboxal/sdpplugins/tree/master/PreBuilt

THX everyone its working but I dont know why.

root@kd28052:~/Server# ./configure --enable-packetver=20120410 checking for gcc... gcc checking whether the C compiler works... yes checking for C compiler default output file name... a.out checking for suffix of executables... checking whether we are cross compiling... no checking for suffix of object files... o checking whether we are using the GNU C compiler... yes checking whether gcc accepts -g... yes checking for gcc option to accept ISO C89... none needed checking how to run the C preprocessor... gcc -E checking for grep that handles long lines and -e... /bin/grep checking for egrep... /bin/grep -E checking for ANSI C header files... yes checking for sys/types.h... yes checking for sys/stat.h... yes checking for stdlib.h... yes checking for string.h... yes checking for memory.h... yes checking for strings.h... yes checking for inttypes.h... yes checking for stdint.h... yes checking for unistd.h... yes checking minix/config.h usability... no checking minix/config.h presence... no checking for minix/config.h... no checking whether it is safe to define __EXTENSIONS__... yes checking whether make sets $(MAKE)... yes checking for gcc... (cached) gcc checking whether we are using the GNU C compiler... (cached) yes checking whether gcc accepts -g... (cached) yes checking for gcc option to accept ISO C89... (cached) none needed checking how to run the C preprocessor... gcc -E checking for ar... /usr/bin/ar checking whether byte ordering is bigendian... no checking whether gcc produces 32bit code... no checking whether gcc supports __thread specifier (TLS)... yes checking whether gcc supports -Wno-unused-parameter... no checking whether gcc supports -flto... no checking whether gcc supports -Wno-pointer-sign... yes checking whether gcc can actually use -Wno-pointer-sign... yes checking whether gcc supports -Wno-switch... yes checking whether gcc supports -fPIC... yes checking whether gcc supports -fno-strict-aliasing... yes checking whether gcc supports -Wconversion... yes checking for setrlimit... yes checking for strnlen... yes checking for uselocale... yes checking for newlocale... yes checking for freelocale... yes checking xlocale.h usability... yes checking xlocale.h presence... yes checking for xlocale.h... yes checking for inflateEnd in -lz... yes checking zlib.h usability... yes checking zlib.h presence... yes checking for zlib.h... yes checking for library containing sqrt... -lm checking for library containing clock_gettime... -lrt checking whether CLOCK_MONOTONIC is supported and works... yes checking for pthread_create in -lpthread... yes checking for pthread_sigmask in -lpthread... yes checking for pthread_attr_init in -lpthread... yes checking for pthread_attr_setstacksize in -lpthread... yes checking for pthread_attr_destroy in -lpthread... yes checking for pthread_cancel in -lpthread... yes checking for pthread_join in -lpthread... yes checking for mysql_config... /usr/bin/mysql_config checking for mysql_init in -lmysqlclient... yes checking mysql.h usability... yes checking mysql.h presence... yes checking for mysql.h... yes checking MySQL library (required)... yes (5.1.66) checking for library containing pcre_study... -lpcre checking PCRE library (optional)... yes (8.02) checking host OS... Linux checking for MinGW... no configure: Configure finish, CFLAGS= -g -O2 -DMAXCONN=16384 -pipe -ffast-math -Wall -DHAS_TLS -Wno-switch -fno-strict-aliasing -DHAVE_SETRLIMIT -DHAVE_STRNLEN -DPACKETVER=20120410 -Wno-pointer-sign -DHAVE_MONOTONIC_CLOCK configure: LDFLAGS= -L/usr/lib -lpthread configure: output name = login-server, char-server, map-server configure: creating ./config.status config.status: creating Makefile config.status: creating src/common/Makefile config.status: creating 3rdparty/mt19937ar/Makefile config.status: creating 3rdparty/libconfig/Makefile config.status: creating src/char/Makefile config.status: creating src/login/Makefile config.status: creating src/map/Makefile config.status: creating src/tool/Makefile config.status: creating src/test/Makefile

i edited :map.h, renewal.h, mmo.h. But i tested it i put the orginal header files but it the same :/

root@kd28052:~/Server# make sql make[1]: Entering directory `/root/Server/3rdparty/mt19937ar' make[1]: Nothing to be done for `all'. make[1]: Leaving directory `/root/Server/3rdparty/mt19937ar' make[1]: Entering directory `/root/Server/3rdparty/libconfig' make[1]: Nothing to be done for `all'. make[1]: Leaving directory `/root/Server/3rdparty/libconfig' make[1]: Entering directory `/root/Server/src/common' make[1]: Nothing to be done for `sql'. make[1]: Leaving directory `/root/Server/src/common' make[1]: Entering directory `/root/Server/src/login' LD login-server make[1]: Leaving directory `/root/Server/src/login' make[1]: Entering directory `/root/Server/src/char' LD char-server make[1]: Leaving directory `/root/Server/src/char' make[1]: Entering directory `/root/Server/src/map' make[1]: *** No rule to make target `obj_sql/map.o', needed by `map-server'. Stop. make[1]: Leaving directory `/root/Server/src/map' make: *** [map] Error 2 When im trying to compile i got these error somebody have any idea? Greets Raijin EDIT: I just testet a complete new rAthena folder.(Without changes) Its working. But why my folder (its the same revision) not working. (there are some custom settings in my folder like rates and joblevel etc. working perfect on windows) EDIT2: My obj_sql folder in map is empty ./configure --enable-packetver=YYYYMMDD doesnt generate make files for this folder why??

Another question: Should i install a GUI? Does the gui need lots of memory? Or should i only work with the console?

Ok Linux Debian 64Bit. I also need a vservers in europe? Some one knows cheap vservers in europe with Debian??