nanounico

Warning: Smarty error: unable to read resource: "overall_menu_es_es.tpl" in /armeria/includes/classes/libs/Smarty-2.6.26/Smarty.class.php on line 1093

I hope the lang Spanish be ready soon!

<form action="<?php echo $_SERVER['PHP_SELF'] ?>" method="POST"> Username <input type="text" name="username"> Password <input type="password" name="password"> Password <input type="password2" name="password2"> <input type="submit" name="registration"> </form> $username = $_POST['username']; $password =$_POST['password']; $password2 =$_POST['password2']; if ($username==NULL | $password==NULL | $password2==NULL{ echo "Some empty field."; echo "Try again."; } else{ // ¿Same pass? if ($password!=$password2) { echo "Pass not match"; } else { $qry_check_username = mysql_query("SELECT username FROM `account` WHERE username='$username'"); if (check_for_symbols($_POST[password]) == TRUE || check_for_symbols($username) == TRUE || mysql_num_rows($qry_check_username) != 0) { echo "Error with creating account, might already be in use or your username / password has invalid symbols in it."; } else { $password = sha_password($username,$_POST['password']); mysql_query("INSERT INTO account (username,sha_pass_hashl) VALUES ('$username', '$password')"); echo "Account created."; } .... ... .. . You can, if you want, also check email: <form action="<?php echo $_SERVER['PHP_SELF'] ?>" method="POST"> Username <input type="text" name="username"> Password <input type="password" name="password"> Password <input type="password2" name="password2"> E-mail : <input type="email" name="email"> <input type="submit" name="registration"> </form> $username = $_POST['username']; $password =$_POST['password']; $password2 =$_POST['password2']; $email = $_POST['email']; if ($username==NULL | $password==NULL | $password2==NULL | $email==NULL){ echo "Some empty field."; echo "Try again."; } else{ // ¿Same pass? if ($password!=$password2) { echo "Pass not match"; } else { $qry_check_username = mysql_query("SELECT username FROM `account` WHERE username='$username'"); if (check_for_symbols($_POST[password]) == TRUE || check_for_symbols($username) == TRUE || mysql_num_rows($qry_check_username) != 0) { echo "Error with creating account, might already be in use or your username / password has invalid symbols in it."; } else { $password = sha_password($username,$_POST['password']); mysql_query("INSERT INTO account (username,sha_pass_hash,email) VALUES ('$username', '$password', '$email)"); echo "Account created."; }

I can confirm, in linux when the server start, from a crash, or first start, CPU 100% = Freeze ~5minuts

Shadez, i hope you dont take much time for push in spanish lang. Thanks for your work!

How about implement Spanish lang?

Well after test, dont work, very bad, i cant compile. also i think is best the tc way for find the ace lib.. MaNGOS has problems finding that libraries.!

Off course, that is not the problem! Only happen with latest MySQL, With libmysqlclient.so.16 - libmysqlclient_r.so.16 becose with old mysql, libmysqlclient.so.15 - libmysqlclient_r.so.15 compile fine! I think the best solution is edit the way MaNGOS find mysql libraries, that no only help me, i think help for future upgrades in MySQL. Checkout: Compile Fine libmysqlclient_r.so.15 (libc6,x86-64) => /usr/lib64/mysql/libmysqlclient_r.so.15 libmysqlclient_r.so.15 (libc6) => /usr/lib/mysql/libmysqlclient_r.so.15 libmysqlclient.so.15 (libc6,x86-64) => /usr/lib64/mysql/libmysqlclient.so.15 libmysqlclient.so.15 (libc6) => /usr/lib/mysql/libmysqlclient.so.15 Compile Fail libmysqlclient_r.so.16 (libc6,x86-64) => /usr/lib64/libmysqlclient_r.so.16 libmysqlclient_r.so (libc6,x86-64) => /usr/lib64/libmysqlclient_r.so libmysqlclient.so.16 (libc6,x86-64) => /usr/lib64/libmysqlclient.so.16 libmysqlclient.so (libc6,x86-64) => /usr/lib64/libmysqlclient.so But with the TC way, i can compile without any problem.

Hello, Well, After a lot of test, i cant compile fine with latest MySQL 5.1.44 & 5.5.2 Allways the same error, something like can find the mysql libraries. ../shared/Database/libmangosdatabase.a(DatabaseMysql.o): In function `DatabaseMysql::~DatabaseMysql()': DatabaseMysql.cpp:(.text+0x385): undefined reference to `mysql_close' DatabaseMysql.cpp:(.text+0x3a1): undefined reference to `mysql_server_end' ../shared/Database/libmangosdatabase.a(DatabaseMysql.o): In function `DatabaseMysql::~DatabaseMysql()': DatabaseMysql.cpp:(.text+0x445): undefined reference to `mysql_close' DatabaseMysql.cpp:(.text+0x461): undefined reference to `mysql_server_end' ../shared/Database/libmangosdatabase.a(DatabaseMysql.o): In function `DatabaseMysql::~DatabaseMysql()': DatabaseMysql.cpp:(.text+0x515): undefined reference to `mysql_close' DatabaseMysql.cpp:(.text+0x531): undefined reference to `mysql_server_end' ../shared/Database/libmangosdatabase.a(DatabaseMysql.o): In function `DatabaseMysql::_TransactionCmd(char const*)': DatabaseMysql.cpp:(.text+0x584): undefined reference to `mysql_query' DatabaseMysql.cpp:(.text+0x5b0): undefined reference to `mysql_error' ../shared/Database/libmangosdatabase.a(DatabaseMysql.o): In function `DatabaseMysql::DirectExecute(char const*)': DatabaseMysql.cpp:(.text+0xba6): undefined reference to `mysql_query' DatabaseMysql.cpp:(.text+0xbff): undefined reference to `mysql_error' ../shared/Database/libmangosdatabase.a(DatabaseMysql.o): In function `DatabaseMysql::_Query(char const*, st_mysql_res**, st_mysql_field**, unsigned long*, unsigned int*)': DatabaseMysql.cpp:(.text+0xcb0): undefined reference to `mysql_query' DatabaseMysql.cpp:(.text+0xcd7): undefined reference to `mysql_error' DatabaseMysql.cpp:(.text+0xd3b): undefined reference to `mysql_store_result' DatabaseMysql.cpp:(.text+0xd4a): undefined reference to `mysql_affected_rows' DatabaseMysql.cpp:(.text+0xd5e): undefined reference to `mysql_field_count' DatabaseMysql.cpp:(.text+0xd87): undefined reference to `mysql_fetch_fields' DatabaseMysql.cpp:(.text+0xda8): undefined reference to `mysql_free_result' ../shared/Database/libmangosdatabase.a(DatabaseMysql.o): In function `DatabaseMysql::DatabaseMysql()': DatabaseMysql.cpp:(.text+0xef2): undefined reference to `mysql_server_init' DatabaseMysql.cpp:(.text+0xef7): undefined reference to `mysql_thread_safe' ../shared/Database/libmangosdatabase.a(DatabaseMysql.o): In function `DatabaseMysql::DatabaseMysql()': DatabaseMysql.cpp:(.text+0xfb2): undefined reference to `mysql_server_init' DatabaseMysql.cpp:(.text+0xfb7): undefined reference to `mysql_thread_safe' ../shared/Database/libmangosdatabase.a(DatabaseMysql.o): In function `DatabaseMysql::Initialize(char const*)': DatabaseMysql.cpp:(.text+0x14a7): undefined reference to `mysql_init' DatabaseMysql.cpp:(.text+0x1584): undefined reference to `mysql_options' DatabaseMysql.cpp:(.text+0x15be): undefined reference to `mysql_options' DatabaseMysql.cpp:(.text+0x1603): undefined reference to `mysql_real_connect' DatabaseMysql.cpp:(.text+0x1635): undefined reference to `mysql_get_client_info' DatabaseMysql.cpp:(.text+0x165c): undefined reference to `mysql_get_server_info' DatabaseMysql.cpp:(.text+0x1688): undefined reference to `mysql_autocommit' DatabaseMysql.cpp:(.text+0x1843): undefined reference to `mysql_error' DatabaseMysql.cpp:(.text+0x186d): undefined reference to `mysql_close' ../shared/Database/libmangosdatabase.a(DatabaseMysql.o): In function `DatabaseMysql::escape_string(char*, char const*, unsigned long)': DatabaseMysql.cpp:(.text+0x134): undefined reference to `mysql_real_escape_string' ../shared/Database/libmangosdatabase.a(DatabaseMysql.o): In function `DatabaseMysql::ThreadEnd()': DatabaseMysql.cpp:(.text+0x141): undefined reference to `mysql_thread_end' ../shared/Database/libmangosdatabase.a(DatabaseMysql.o): In function `DatabaseMysql::ThreadStart()': DatabaseMysql.cpp:(.text+0x151): undefined reference to `mysql_thread_init' ../shared/Database/libmangosdatabase.a(QueryResultMysql.o): In function `QueryResultMysql::EndQuery()': QueryResultMysql.cpp:(.text+0xd3): undefined reference to `mysql_free_result' ../shared/Database/libmangosdatabase.a(QueryResultMysql.o): In function `QueryResultMysql::~QueryResultMysql()': QueryResultMysql.cpp:(.text+0x507): undefined reference to `mysql_free_result' ../shared/Database/libmangosdatabase.a(QueryResultMysql.o): In function `QueryResultMysql::NextRow()': QueryResultMysql.cpp:(.text+0x551): undefined reference to `mysql_fetch_row' QueryResultMysql.cpp:(.text+0x5e0): undefined reference to `mysql_free_result' ../shared/Database/libmangosdatabase.a(QueryResultMysql.o): In function `QueryResultMysql::~QueryResultMysql()': QueryResultMysql.cpp:(.text+0x657): undefined reference to `mysql_free_result' ../shared/Database/libmangosdatabase.a(QueryResultMysql.o): In function `QueryResultMysql::~QueryResultMysql()': QueryResultMysql.cpp:(.text+0x6e7): undefined reference to `mysql_free_result' ../shared/Database/libmangosdatabase.a(SqlDelayThread.o): In function `SqlDelayThread::run()': SqlDelayThread.cpp:(.text+0x16d): undefined reference to `mysql_thread_init' SqlDelayThread.cpp:(.text+0x20a): undefined reference to `mysql_thread_end' I try with some "Solutions" --with-mysql-libs= --with-mysql-includes= export CPPFLAGS= Nothing work. Only for testing purposes i try compile with tc, and compile fine. so, maybe is MaNGOS problem. TC find MySQL lib with this: (Using cMake) # - Find MySQL # Find the MySQL includes and client library # This module defines # MYSQL_INCLUDE_DIR, where to find mysql.h # MYSQL_LIBRARIES, the libraries needed to use MySQL. # MYSQL_FOUND, If false, do not try to use MySQL. # # Copyright (c) 2006, Jaroslaw Staniek, <[email protected]> # Lot of adustmens by Michal Cihar <[email protected]> # # vim: expandtab sw=4 ts=4 sts=4: # # Redistribution and use is allowed according to the terms of the BSD license. MACRO(FIND_MYSQL) if(UNIX) set(MYSQL_CONFIG_PREFER_PATH "$ENV{MYSQL_HOME}/bin" CACHE FILEPATH "preferred path to MySQL (mysql_config)") find_program(MYSQL_CONFIG mysql_config ${MYSQL_CONFIG_PREFER_PATH} /usr/local/mysql/bin/ /usr/local/bin/ /usr/bin/ ) if(MYSQL_CONFIG) message(STATUS "Using mysql-config: ${MYSQL_CONFIG}") # set INCLUDE_DIR exec_program(${MYSQL_CONFIG} ARGS --include OUTPUT_VARIABLE MY_TMP) string(REGEX REPLACE "-I([^ ]*)( .*)?" "\\\\1" MY_TMP "${MY_TMP}") set(MYSQL_ADD_INCLUDE_DIR ${MY_TMP} CACHE FILEPATH INTERNAL) # set LIBRARY_DIR exec_program(${MYSQL_CONFIG} ARGS --libs_r OUTPUT_VARIABLE MY_TMP) set(MYSQL_ADD_LIBRARIES "") string(REGEX MATCHALL "-l[^ ]*" MYSQL_LIB_LIST "${MY_TMP}") foreach(LIB ${MYSQL_LIB_LIST}) string(REGEX REPLACE "[ ]*-l([^ ]*)" "\\\\1" LIB "${LIB}") list(APPEND MYSQL_ADD_LIBRARIES "${LIB}") endforeach(LIB ${MYSQL_LIBS}) set(MYSQL_ADD_LIBRARY_PATH "") string(REGEX MATCHALL "-L[^ ]*" MYSQL_LIBDIR_LIST "${MY_TMP}") foreach(LIB ${MYSQL_LIBDIR_LIST}) string(REGEX REPLACE "[ ]*-L([^ ]*)" "\\\\1" LIB "${LIB}") list(APPEND MYSQL_ADD_LIBRARY_PATH "${LIB}") endforeach(LIB ${MYSQL_LIBS}) else(MYSQL_CONFIG) set(MYSQL_ADD_LIBRARIES "") list(APPEND MYSQL_ADD_LIBRARIES "mysqlclient") endif(MYSQL_CONFIG) else(UNIX) set(MYSQL_ADD_INCLUDE_DIR "c:/msys/local/include" CACHE FILEPATH INTERNAL) set(MYSQL_ADD_LIBRARY_PATH "c:/msys/local/lib" CACHE FILEPATH INTERNAL) ENDIF(UNIX) find_path(MYSQL_INCLUDE_DIR mysql.h /usr/local/include /usr/local/include/mysql /usr/local/mysql/include /usr/local/mysql/include/mysql /usr/include /usr/include/mysql ${MYSQL_ADD_INCLUDE_DIR} ) set(TMP_MYSQL_LIBRARIES "") foreach(LIB ${MYSQL_ADD_LIBRARIES}) find_library("MYSQL_LIBRARIES_${LIB}" NAMES ${LIB} PATHS ${MYSQL_ADD_LIBRARY_PATH} /usr/lib/mysql /usr/local/lib /usr/local/lib/mysql /usr/local/mysql/lib ) list(APPEND TMP_MYSQL_LIBRARIES "${MYSQL_LIBRARIES_${LIB}}") endforeach(LIB ${MYSQL_ADD_LIBRARIES}) set(MYSQL_LIBRARIES ${TMP_MYSQL_LIBRARIES} CACHE FILEPATH INTERNAL) if(MYSQL_INCLUDE_DIR AND MYSQL_LIBRARIES) set(MYSQL_FOUND TRUE CACHE INTERNAL "MySQL found") message(STATUS "Found MySQL: ${MYSQL_INCLUDE_DIR}, ${MYSQL_LIBRARIES}") else(MYSQL_INCLUDE_DIR AND MYSQL_LIBRARIES) set(MYSQL_FOUND FALSE CACHE INTERNAL "MySQL found") message(STATUS "MySQL not found.") endif(MYSQL_INCLUDE_DIR AND MYSQL_LIBRARIES) mark_as_advanced(MYSQL_INCLUDE_DIR MYSQL_LIBRARIES) ENDMACRO(FIND_MYSQL) So, how i can integrate that for can compile MaNGOS with Make? Thanks.

Working, maybe vlad put in master soon

hahahahaha

Kero, this option is new for me.. #kernel.core_pattern = core.%p kernel.sem = 512 32000 100 512 what exactly does?

64gb ram?? Wtf!!!

What about mangos conf...with this 3 tune options anybody can allocate a lot of people! two things, i dont know why, but for me, larger buffer in mysql, dont be the best configuration, and right now, i'm using query cache disable.

I think, for stable servers, dont put mtmaps like tip, becouse with the visibility and reloc patch from silver, is not necessary mtmaps. With the correct configuration in my.cnf and mangosd.conf is possible allocate more than 3000. I recommend use SAS 15K or SSD Extreme "-E", tune for high workload in mysql, remember that the SSD Disk, in some cases, change the latency from 0.5 to 0.1. in limits, you can tune too MySQL. Chears! My status: 1 day ON with 3500+

Off course, this is very usefull, netsky, the 5.7.6 is alredy avalible.!

Again wrong secction, cant you see the section for bug report?

Somebody can update and change for use with mangos timer please?

Woweur, any news?

jeje, thanks, right now i'm in vacations so, when i come back i update all this threads

Any news??

I hope be ready soon for port in master, this could be a reall nice improvement, Congrats woweur..

haha, yes this crash is very enoyng, this, and the crash in instance add bin.. FK... i think mangos need fix it very often, and we can have mangos servers, very stable

I'm not agree.. with the correct configuration, you can do everything, i have more than 2k and i no have any problem. PD: In this days i update the post, with more interesting scripts. Chears.

yes, crashdump: Core was generated by `./bin/mangos-worldd -c etc/mangosd.conf'. Program terminated with signal 6, Aborted. [New process 23056] [New process 23064] [New process 23063] [New process 23062] [New process 23061] [New process 23060] [New process 23059] [New process 23058] [New process 23057] [New process 23000] [New process 22999] [New process 22998] [New process 22996] #0 0x00000038ca630265 in raise () from /lib64/libc.so.6 #0 0x00000038ca630265 in raise () from /lib64/libc.so.6 No symbol table info available. #1 0x00000038ca631d10 in abort () from /lib64/libc.so.6 No symbol table info available. #2 0x00000038ca6296e6 in __assert_fail () from /lib64/libc.so.6 No symbol table info available. #3 0x00000000006e424b in Aura::UnregisterSingleCastAura (this=0x2aaaf84579e0) at /root/Desktop/Mangos/Sources/src/game/SpellAuras.cpp:7633 caster = <value optimized out> __PRETTY_FUNCTION__ = "void Aura::UnregisterSingleCastAura()" #4 0x000000000075c887 in Unit::RemoveAura (this=0x1cb4b190, i=@0x5a10, mode=AURA_REMOVE_BY_DEFAULT) at /root/Desktop/Mangos/Sources/src/game/Unit.cpp:4239 Aur = (class Aura *) 0x2aaaf84579e0 AurSpellInfo = (const SpellEntry *) 0x2aaab4e12710 statue = <value optimized out> #5 0x000000000075d9a1 in Unit::RemoveAura (this=0x1cb4b190, aura=0x2aaaf84579e0, mode=AURA_REMOVE_BY_DEFAULT) at /root/Desktop/Mangos/Sources/src/game/Unit.cpp:4227 i = {_M_node = 0x2aab02765600} #6 0x000000000075daaf in Unit::RemoveNotOwnSingleTargetAuras ( this=0x1cb03240, newPhase=0) at /root/Desktop/Mangos/Sources/src/game/Unit.cpp:4210 aura = (class Aura *) 0x2aaaf84579e0 scAuras = ( std::list<Aura*,std::allocator<Aura*> > &) @0x1cb034d8: {<std::_List_base<Aura*,std::allocator<Aura*> >> = { _M_impl = {<std::allocator<std::_List_node<Aura*> >> = {<__gnu_cxx::new_allocator<std::_List_node<Aura*> >> = {<No data fields>}, <No data fields>}, _M_node = {_M_next = 0x1cb034d8, _M_prev = 0x1cb034d8}}}, <No data fields>} #7 0x000000000076d80b in Unit::RemoveFromWorld (this=0x59d4) at /root/Desktop/Mangos/Sources/src/game/Unit.cpp:11423 No locals. #8 0x00000000005135af in Creature::RemoveFromWorld (this=0x1cb03240) at /root/Desktop/Mangos/Sources/src/game/Creature.cpp:157 No locals. #9 0x000000000077353e in Unit::CleanupsBeforeDelete (this=0x1cb03240) at /root/Desktop/Mangos/Sources/src/game/Unit.cpp:11446 No locals. #10 0x0000000000617305 in ObjectGridUnloader::Visit<Creature> ( this=<value optimized out>, m=@0x1c5baab0) at /root/Desktop/Mangos/Sources/src/game/ObjectGridLoader.cpp:263 No locals. #11 0x000000000061662a in ObjectGridUnloader::Unload (this=0x431e8e10, grid=@0x1c5baa80) at /root/Desktop/Mangos/Sources/src/game/../framework/GameSystem/TypeContainerVisitor.h:64 No locals. #12 0x00000000005d8d4b in Map::UnloadGrid (this=0x2aaaaf427500, x=@0x431e8f6c, y=@0x431e8f68, pForce=<value optimized out>) at /root/Desktop/Mangos/Sources/src/game/../framework/GameSystem/GridLoader.h:72 unloader = {i_grid = @0x1c5b76a0} grid = <value optimized out> gx = <value optimized out> gy = <value optimized out> __PRETTY_FUNCTION__ = "bool Map::UnloadGrid(const uint32&, const uint32&, bool)" #13 0x00000000007eecf6 in RemovalState::Update (this=<value optimized out>, m=@0x2aaaaf427500, grid=@0x1c5b76a0, info=<value optimized out>, x=@0x431e8f6c, y=@0x431e8f68, t_diff=@0x431e8fbc) at /root/Desktop/Mangos/Sources/src/game/GridStates.cpp:65 No locals. #14 0x00000000005ee655 in Map::Update (this=0x2aaaaf427500, t_diff=@0x431e8fbc) at /root/Desktop/Mangos/Sources/src/game/Map.cpp:714 grid = (NGridType *) 0x6 updater = {i_timeDiff = 100} grid_object_update = {i_visitor = @0x431e8f60} world_object_update = {i_visitor = @0x431e8f60} __PRETTY_FUNCTION__ = "virtual void Map::Update(const uint32&)" #15 0x00000000005fa861 in MapManager::Update (this=0x2aaaaf3d12c0, diff=<value optimized out>) at /root/Desktop/Mangos/Sources/src/game/MapManager.cpp:265 No locals. #16 0x000000000079a5b6 in World::Update (this=0x2aaaac012270, diff=45) at /root/Desktop/Mangos/Sources/src/game/World.cpp:1686 No locals. #17 0x00000000004c562f in WorldRunnable::run (this=<value optimized out>) at /root/Desktop/Mangos/Sources/src/mangosd/WorldRunnable.cpp:60 diff = 45 realCurrTime = 2974783171 realPrevTime = <value optimized out> prevSleepTime = 44 #18 0x0000000000855b0d in ACE_Based::Thread::ThreadTask (param=0x59d4) at /root/Desktop/Mangos/Sources/src/shared/Threading.cpp:183 _task = (class ACE_Based::Runnable *) 0x2aaabda23630 #19 0x00000038cb2064a7 in start_thread () from /lib64/libpthread.so.0 No symbol table info available. #20 0x00000038ca6d3c2d in clone () from /lib64/libc.so.6 No symbol table info available.