Jump to content
×
×
  • Create New...
  • 0

Compile Problem


Crystal™

Question

  • Answers 10
  • Created
  • Last Reply

Top Posters For This Question

10 answers to this question

Recommended Posts

  • 0
  • Premium
On 10/20/2016 at 4:46 AM, iltizio said:

g++410: Command not found.

So you use an inexistent command for compile.

g++ is the compile program, 410 the version.

This version doesn't exist anymore: https://www.freshports.org/lang/gcc410/

You can try this workaround:

ln -s /usr/local/bin/g++ /usr/local/bin/g++410

Command not found ...Also my vdi isn't connected with internet , is there a way to fix it via editing for ex makefile without installing anything? ^^

Thanks for replying me!

Link to comment
  • 0
4 hours ago, Crystal™ said:

Command not found ...Also my vdi isn't connected with internet , is there a way to fix it via editing for ex makefile without installing anything? ^^

Thanks for replying me!

You need a C++ compiler. I don't know if you have one.

Check it running gcc --version

If you see "command not found" you need to install it.

If you have not internet connection on your VM and you don't want to activate it, you can try to install from ports:

cd /usr/ports/lang/gcc49/ && make install clean

And when it tell you a connection error, the installer tell you another solution, uploading manually the archive with source in a directory that indicate. The directory usually is /usr/ports/distfiles.

So you can download from your PC on a web browser from one of the link that he try to fetch during installation, nextly upload with an sftp client (winscp, filezilla ecc.) the archive (usually .txz or tar.xz) on the location inticated and re run the command to install.

Link to comment
  • 0
  • Premium
4 hours ago, WhiteHat said:

Make your own VDI for compiling there is a tutorial for that.

Link: 

 

The think that I'm trying to explain is that is a little bit hard because my work-pc isn't connected on internet...

2 minutes ago, iltizio said:

You need a C++ compiler. I don't know if you have one.

Check it running gcc --version

If you see "command not found" you need to install it.

If you have not internet connection on your VM and you don't want to activate it, you can try to install from ports:

cd /usr/ports/lang/gcc49/ && make install clean

And when it tell you a connection error, the installer tell you another solution, uploading manually the archive with source in a directory that indicate. The directory usually is /usr/ports/distfiles.

So you can download from your PC on a web browser from one of the link that he try to fetch during installation, nextly upload with an sftp client (winscp, filezilla ecc.) the archive (usually .txz or tar.xz) on the location inticated and re run the command to install.

I haven't understood very well...Please check my PM

Link to comment
  • 0
  • Premium

compile BattleArena.cpp with g++410 -Wall -fuse-linker-plugin -fuse-ld=gold -O2 -m32 -pipe -fexceptions -D_THREAD_SAFE -Wl,-rpath=/usr/local/lib32/metin2 -std=c++11 -static -static-libgcc -static-libstdc++ -Wno-strict-aliasing -g -ggdb -DNDEBUG -ffast-math -funsafe-loop-optimizations -ftracer -fira-loop-pressure -funroll-loops -finline-functions -funswitch-loops -fpredictive-commoning -fgcse-after-reload -ftree-loop-distribution -ftree-partial-pre -ftree-vectorize -ftree-loop-vectorize -ftree-loop-distribute-patterns -ftree-slp-vectorize -fipa-cp-clone -mtune=i686 -march=i686 -mssse3
g++410: error: unrecognized command line option '-ftree-loop-vectorize'
gmake: *** [.obj/BattleArena.o] Error 1

Edit:When i remove the function ftree-loop-vectorize i get this error: 

Spoiler

compile cipher.cpp with g++410 -Wall -fuse-linker-plugin -fuse-ld=gold -O2 -m32 -pipe -fexceptions -D_THREAD_SAFE -Wl,-rpath=/usr/local/lib32/metin2 -std=c++11 -static -static-libgcc -static-libstdc++ -Wno-strict-aliasing -g -ggdb -DNDEBUG -ffast-math -funsafe-loop-optimizations -ftracer -fira-loop-pressure -funroll-loops -finline-functions -funswitch-loops -fpredictive-commoning -fgcse-after-reload -ftree-loop-distribution -ftree-partial-pre -ftree-vectorize -ftree-loop-distribute-patterns -ftree-slp-vectorize -fipa-cp-clone -mtune=i686 -march=i686 -mssse3
In file included from /usr/include/cryptopp/modes.h:8:0,
                 from cipher.cpp:7:
/usr/include/cryptopp/secblock.h: In instantiation of 'CryptoPP::AllocatorWithCleanup<T, T_Align16>::pointer CryptoPP::AllocatorWithCleanup<T, T_Align16>::allocate(CryptoPP::AllocatorWithCleanup<T, T_Align16>::size_type, const void*) [with T = unsigned char; bool T_Align16 = false; CryptoPP::AllocatorWithCleanup<T, T_Align16>::pointer = unsigned char*; CryptoPP::AllocatorWithCleanup<T, T_Align16>::size_type = unsigned int]':
/usr/include/cryptopp/secblock.h:247:25:   required from 'CryptoPP::SecBlock<T, A>::SecBlock(CryptoPP::SecBlock<T, A>::size_type) [with T = unsigned char; A = CryptoPP::AllocatorWithCleanup<unsigned char>; CryptoPP::SecBlock<T, A>::size_type = unsigned int]'
/usr/include/cryptopp/algparam.h:17:2:   required from here
/usr/include/cryptopp/secblock.h:91:14: error: 'CheckSize' was not declared in this scope, and no declarations were found by argument-dependent lookup at the point of instantiation [-fpermissive]
   CheckSize(n);
              ^
/usr/include/cryptopp/secblock.h:91:14: note: declarations in dependent base 'CryptoPP::AllocatorBase<unsigned char>' are not found by unqualified lookup
/usr/include/cryptopp/secblock.h:91:14: note: use 'this->CheckSize' instead
/usr/include/cryptopp/secblock.h: In instantiation of 'CryptoPP::AllocatorWithCleanup<T, T_Align16>::pointer CryptoPP::AllocatorWithCleanup<T, T_Align16>::allocate(CryptoPP::AllocatorWithCleanup<T, T_Align16>::size_type, const void*) [with T = unsigned char; bool T_Align16 = true; CryptoPP::AllocatorWithCleanup<T, T_Align16>::pointer = unsigned char*; CryptoPP::AllocatorWithCleanup<T, T_Align16>::size_type = unsigned int]':
/usr/include/cryptopp/secblock.h:247:25:   required from 'CryptoPP::SecBlock<T, A>::SecBlock(CryptoPP::SecBlock<T, A>::size_type) [with T = unsigned char; A = CryptoPP::AllocatorWithCleanup<unsigned char, true>; CryptoPP::SecBlock<T, A>::size_type = unsigned int]'
/usr/include/cryptopp/modes.h:63:34:   required from here
/usr/include/cryptopp/secblock.h:91:14: error: 'CheckSize' was not declared in this scope, and no declarations were found by argument-dependent lookup at the point of instantiation [-fpermissive]
/usr/include/cryptopp/secblock.h:91:14: note: declarations in dependent base 'CryptoPP::AllocatorBase<unsigned char>' are not found by unqualified lookup
/usr/include/cryptopp/secblock.h:91:14: note: use 'this->CheckSize' instead
/usr/include/cryptopp/secblock.h: In instantiation of 'CryptoPP::AllocatorWithCleanup<T, T_Align16>::pointer CryptoPP::AllocatorWithCleanup<T, T_Align16>::allocate(CryptoPP::AllocatorWithCleanup<T, T_Align16>::size_type, const void*) [with T = unsigned int; bool T_Align16 = true; CryptoPP::AllocatorWithCleanup<T, T_Align16>::pointer = unsigned int*; CryptoPP::AllocatorWithCleanup<T, T_Align16>::size_type = unsigned int]':
/usr/include/cryptopp/secblock.h:249:29:   required from 'CryptoPP::SecBlock<T, A>::SecBlock(const CryptoPP::SecBlock<T, A>&) [with T = unsigned int; A = CryptoPP::AllocatorWithCleanup<unsigned int, true>]'
/usr/include/cryptopp/modarith.h:122:20:   required from here
/usr/include/cryptopp/secblock.h:91:14: error: 'CheckSize' was not declared in this scope, and no declarations were found by argument-dependent lookup at the point of instantiation [-fpermissive]
/usr/include/cryptopp/secblock.h:91:14: note: declarations in dependent base 'CryptoPP::AllocatorBase<unsigned int>' are not found by unqualified lookup
/usr/include/cryptopp/secblock.h:91:14: note: use 'this->CheckSize' instead
/usr/include/cryptopp/secblock.h: In instantiation of 'CryptoPP::AllocatorWithCleanup<T, T_Align16>::pointer CryptoPP::AllocatorWithCleanup<T, T_Align16>::allocate(CryptoPP::AllocatorWithCleanup<T, T_Align16>::size_type, const void*) [with T = unsigned int; bool T_Align16 = false; CryptoPP::AllocatorWithCleanup<T, T_Align16>::pointer = unsigned int*; CryptoPP::AllocatorWithCleanup<T, T_Align16>::size_type = unsigned int]':
/usr/include/cryptopp/secblock.h:247:25:   required from 'CryptoPP::SecBlock<T, A>::SecBlock(CryptoPP::SecBlock<T, A>::size_type) [with T = unsigned int; A = CryptoPP::AllocatorWithCleanup<unsigned int>; CryptoPP::SecBlock<T, A>::size_type = unsigned int]'
/usr/include/cryptopp/rc5.h:22:27:   required from 'CryptoPP::BlockCipherFinal<DIR, BASE>::BlockCipherFinal() [with CryptoPP::CipherDir DIR = (CryptoPP::CipherDir)0u; BASE = CryptoPP::RC5::Enc]'
/usr/include/cryptopp/misc.h:82:7:   required from 'CryptoPP::CipherModeFinalTemplate_CipherHolder<CIPHER, BASE>::CipherModeFinalTemplate_CipherHolder(const byte*, size_t, const byte*) [with CIPHER = CryptoPP::BlockCipherFinal<(CryptoPP::CipherDir)0u, CryptoPP::RC5::Enc>; BASE = CryptoPP::ConcretePolicyHolder<CryptoPP::Empty, CryptoPP::AdditiveCipherTemplate<CryptoPP::AbstractPolicyHolder<CryptoPP::AdditiveCipherAbstractPolicy, CryptoPP::CTR_ModePolicy> > >; byte = unsigned char; size_t = unsigned int]'
cipher.cpp:88:64:   required from 'CryptoPP::SymmetricCipher* BlockCipherDetail<T>::CreateEncoder(const byte*, size_t, const byte*) const [with T = CryptoPP::RC5; byte = unsigned char; size_t = unsigned int]'
cipher.cpp:398:1:   required from here
/usr/include/cryptopp/secblock.h:91:14: error: 'CheckSize' was not declared in this scope, and no declarations were found by argument-dependent lookup at the point of instantiation [-fpermissive]
/usr/include/cryptopp/secblock.h:91:14: note: declarations in dependent base 'CryptoPP::AllocatorBase<unsigned int>' are not found by unqualified lookup
/usr/include/cryptopp/secblock.h:91:14: note: use 'this->CheckSize' instead
gmake: *** [.obj/cipher.o] Error 1

 

Secblock.h

Spoiler

// secblock.h - written and placed in the public domain by Wei Dai

#ifndef CRYPTOPP_SECBLOCK_H
#define CRYPTOPP_SECBLOCK_H

#include "config.h"
#include "misc.h"
#include <assert.h>

NAMESPACE_BEGIN(CryptoPP)

// ************** secure memory allocation ***************

template<class T>
class AllocatorBase
{
public:
    typedef T value_type;
    typedef size_t size_type;
#ifdef CRYPTOPP_MSVCRT6
    typedef ptrdiff_t difference_type;
#else
    typedef std::ptrdiff_t difference_type;
#endif
    typedef T * pointer;
    typedef const T * const_pointer;
    typedef T & reference;
    typedef const T & const_reference;

    pointer address(reference r) const {return (&r);}
    const_pointer address(const_reference r) const {return (&r); }
    void construct(pointer p, const T& val) {new (p) T(val);}
    void destroy(pointer p) {p->~T();}
    size_type max_size() const {return ~size_type(0)/sizeof(T);}    // switch to std::numeric_limits<T>::max later

protected:
    static void CheckSize(size_t n)
    {
        if (n > ~size_t(0) / sizeof(T))
            throw InvalidArgument("AllocatorBase: requested size would cause integer overflow");
    }
};

#define CRYPTOPP_INHERIT_ALLOCATOR_TYPES    \
typedef typename AllocatorBase<T>::value_type value_type;\
typedef typename AllocatorBase<T>::size_type size_type;\
typedef typename AllocatorBase<T>::difference_type difference_type;\
typedef typename AllocatorBase<T>::pointer pointer;\
typedef typename AllocatorBase<T>::const_pointer const_pointer;\
typedef typename AllocatorBase<T>::reference reference;\
typedef typename AllocatorBase<T>::const_reference const_reference;

#if defined(_MSC_VER) && (_MSC_VER < 1300)
// this pragma causes an internal compiler error if placed immediately before std::swap(a, B)
#pragma warning(push)
#pragma warning(disable: 4700)    // VC60 workaround: don't know how to get rid of this warning
#endif

template <class T, class A>
typename A::pointer StandardReallocate(A& a, T *p, typename A::size_type oldSize, typename A::size_type newSize, bool preserve)
{
    if (oldSize == newSize)
        return p;

    if (preserve)
    {
        typename A::pointer newPointer = a.allocate(newSize, NULL);
        memcpy_s(newPointer, sizeof(T)*newSize, p, sizeof(T)*STDMIN(oldSize, newSize));
        a.deallocate(p, oldSize);
        return newPointer;
    }
    else
    {
        a.deallocate(p, oldSize);
        return a.allocate(newSize, NULL);
    }
}

#if defined(_MSC_VER) && (_MSC_VER < 1300)
#pragma warning(pop)
#endif

template <class T, bool T_Align16 = false>
class AllocatorWithCleanup : public AllocatorBase<T>
{
public:
    CRYPTOPP_INHERIT_ALLOCATOR_TYPES

    pointer allocate(size_type n, const void * = NULL)
    {
        CheckSize(n);
        if (n == 0)
            return NULL;

#if CRYPTOPP_BOOL_ALIGN16_ENABLED
        if (T_Align16 && n*sizeof(T) >= 16)
            return (pointer)AlignedAllocate(n*sizeof(T));
#endif

        return (pointer)UnalignedAllocate(n*sizeof(T));
    }

    void deallocate(void *p, size_type n)
    {
        SecureWipeArray((pointer)p, n);

#if CRYPTOPP_BOOL_ALIGN16_ENABLED
        if (T_Align16 && n*sizeof(T) >= 16)
            return AlignedDeallocate(p);
#endif

        UnalignedDeallocate(p);
    }

    pointer reallocate(T *p, size_type oldSize, size_type newSize, bool preserve)
    {
        return StandardReallocate(*this, p, oldSize, newSize, preserve);
    }

    // VS.NET STL enforces the policy of "All STL-compliant allocators have to provide a
    // template class member called rebind".
    template <class U> struct rebind { typedef AllocatorWithCleanup<U, T_Align16> other; };
#if _MSC_VER >= 1500
    AllocatorWithCleanup() {}
    template <class U, bool A> AllocatorWithCleanup(const AllocatorWithCleanup<U, A> &) {}
#endif
};

CRYPTOPP_DLL_TEMPLATE_CLASS AllocatorWithCleanup<byte>;
CRYPTOPP_DLL_TEMPLATE_CLASS AllocatorWithCleanup<word16>;
CRYPTOPP_DLL_TEMPLATE_CLASS AllocatorWithCleanup<word32>;
CRYPTOPP_DLL_TEMPLATE_CLASS AllocatorWithCleanup<word64>;
#if CRYPTOPP_BOOL_X86
CRYPTOPP_DLL_TEMPLATE_CLASS AllocatorWithCleanup<word, true>;    // for Integer
#endif

template <class T>
class NullAllocator : public AllocatorBase<T>
{
public:
    CRYPTOPP_INHERIT_ALLOCATOR_TYPES

    pointer allocate(size_type n, const void * = NULL)
    {
        assert(false);
        return NULL;
    }

    void deallocate(void *p, size_type n)
    {
        assert(false);
    }

    size_type max_size() const {return 0;}
};

// This allocator can't be used with standard collections because
// they require that all objects of the same allocator type are equivalent.
// So this is for use with SecBlock only.
template <class T, size_t S, class A = NullAllocator<T>, bool T_Align16 = false>
class FixedSizeAllocatorWithCleanup : public AllocatorBase<T>
{
public:
    CRYPTOPP_INHERIT_ALLOCATOR_TYPES

    FixedSizeAllocatorWithCleanup() : m_allocated(false) {}

    pointer allocate(size_type n)
    {
        assert(IsAlignedOn(m_array, 8));

        if (n <= S && !m_allocated)
        {
            m_allocated = true;
            return GetAlignedArray();
        }
        else
            return m_fallbackAllocator.allocate(n);
    }

    pointer allocate(size_type n, const void *hint)
    {
        if (n <= S && !m_allocated)
        {
            m_allocated = true;
            return GetAlignedArray();
        }
        else
            return m_fallbackAllocator.allocate(n, hint);
    }

    void deallocate(void *p, size_type n)
    {
        if (p == GetAlignedArray())
        {
            assert(n <= S);
            assert(m_allocated);
            m_allocated = false;
            SecureWipeArray((pointer)p, n);
        }
        else
            m_fallbackAllocator.deallocate(p, n);
    }

    pointer reallocate(pointer p, size_type oldSize, size_type newSize, bool preserve)
    {
        if (p == GetAlignedArray() && newSize <= S)
        {
            assert(oldSize <= S);
            if (oldSize > newSize)
                SecureWipeArray(p+newSize, oldSize-newSize);
            return p;
        }

        pointer newPointer = allocate(newSize, NULL);
        if (preserve)
            memcpy(newPointer, p, sizeof(T)*STDMIN(oldSize, newSize));
        deallocate(p, oldSize);
        return newPointer;
    }

    size_type max_size() const {return STDMAX(m_fallbackAllocator.max_size(), S);}

private:
#ifdef __BORLANDC__
    T* GetAlignedArray() {return m_array;}
    T m_array;
#else
    T* GetAlignedArray() {return (CRYPTOPP_BOOL_ALIGN16_ENABLED && T_Align16) ? (T*)(((byte *)m_array) + (0-(size_t)m_array)%16) : m_array;}
    CRYPTOPP_ALIGN_DATA(8) T m_array[(CRYPTOPP_BOOL_ALIGN16_ENABLED && T_Align16) ? S+8/sizeof(T) : S];
#endif
    A m_fallbackAllocator;
    bool m_allocated;
};

//! a block of memory allocated using A
template <class T, class A = AllocatorWithCleanup<T> >
class SecBlock
{
public:
    typedef typename A::value_type value_type;
    typedef typename A::pointer iterator;
    typedef typename A::const_pointer const_iterator;
    typedef typename A::size_type size_type;

    explicit SecBlock(size_type size=0)
        : m_size(size) {m_ptr = m_alloc.allocate(size, NULL);}
    SecBlock(const SecBlock<T, A> &t)
        : m_size(t.m_size) {m_ptr = m_alloc.allocate(m_size, NULL); memcpy_s(m_ptr, m_size*sizeof(T), t.m_ptr, m_size*sizeof(T));}
    SecBlock(const T *t, size_type len)
        : m_size(len)
    {
        m_ptr = m_alloc.allocate(len, NULL);
        if (t == NULL)
            memset_z(m_ptr, 0, len*sizeof(T));
        else
            memcpy(m_ptr, t, len*sizeof(T));
    }

    ~SecBlock()
        {m_alloc.deallocate(m_ptr, m_size);}

#ifdef __BORLANDC__
    operator T *() const
        {return (T*)m_ptr;}
#else
    operator const void *() const
        {return m_ptr;}
    operator void *()
        {return m_ptr;}

    operator const T *() const
        {return m_ptr;}
    operator T *()
        {return m_ptr;}
#endif

//    T *operator +(size_type offset)
//        {return m_ptr+offset;}

//    const T *operator +(size_type offset) const
//        {return m_ptr+offset;}

//    T& operator[](size_type index)
//        {assert(index >= 0 && index < m_size); return m_ptr[index];}

//    const T& operator[](size_type index) const
//        {assert(index >= 0 && index < m_size); return m_ptr[index];}

    iterator begin()
        {return m_ptr;}
    const_iterator begin() const
        {return m_ptr;}
    iterator end()
        {return m_ptr+m_size;}
    const_iterator end() const
        {return m_ptr+m_size;}

    typename A::pointer data() {return m_ptr;}
    typename A::const_pointer data() const {return m_ptr;}

    size_type size() const {return m_size;}
    bool empty() const {return m_size == 0;}

    byte * BytePtr() {return (byte *)m_ptr;}
    const byte * BytePtr() const {return (const byte *)m_ptr;}
    size_type SizeInBytes() const {return m_size*sizeof(T);}

    //! set contents and size
    void Assign(const T *t, size_type len)
    {
        New(len);
        memcpy_s(m_ptr, m_size*sizeof(T), t, len*sizeof(T));
    }

    //! copy contents and size from another SecBlock
    void Assign(const SecBlock<T, A> &t)
    {
        if (this != &t)
        {
            New(t.m_size);
            memcpy_s(m_ptr, m_size*sizeof(T), t.m_ptr, m_size*sizeof(T));
        }
    }

    SecBlock<T, A>& operator=(const SecBlock<T, A> &t)
    {
        Assign(t);
        return *this;
    }

    // append to this object
    SecBlock<T, A>& operator+=(const SecBlock<T, A> &t)
    {
        size_type oldSize = m_size;
        Grow(m_size+t.m_size);
        memcpy_s(m_ptr+oldSize, m_size*sizeof(T), t.m_ptr, t.m_size*sizeof(T));
        return *this;
    }

    // append operator
    SecBlock<T, A> operator+(const SecBlock<T, A> &t)
    {
        SecBlock<T, A> result(m_size+t.m_size);
        memcpy_s(result.m_ptr, result.m_size*sizeof(T), m_ptr, m_size*sizeof(T));
        memcpy_s(result.m_ptr+m_size, t.m_size*sizeof(T), t.m_ptr, t.m_size*sizeof(T));
        return result;
    }

    bool operator==(const SecBlock<T, A> &t) const
    {
        return m_size == t.m_size && VerifyBufsEqual(m_ptr, t.m_ptr, m_size*sizeof(T));
    }

    bool operator!=(const SecBlock<T, A> &t) const
    {
        return !operator==(t);
    }

    //! change size, without preserving contents
    void New(size_type newSize)
    {
        m_ptr = m_alloc.reallocate(m_ptr, m_size, newSize, false);
        m_size = newSize;
    }

    //! change size and set contents to 0
    void CleanNew(size_type newSize)
    {
        New(newSize);
        memset_z(m_ptr, 0, m_size*sizeof(T));
    }

    //! change size only if newSize > current size. contents are preserved
    void Grow(size_type newSize)
    {
        if (newSize > m_size)
        {
            m_ptr = m_alloc.reallocate(m_ptr, m_size, newSize, true);
            m_size = newSize;
        }
    }

    //! change size only if newSize > current size. contents are preserved and additional area is set to 0
    void CleanGrow(size_type newSize)
    {
        if (newSize > m_size)
        {
            m_ptr = m_alloc.reallocate(m_ptr, m_size, newSize, true);
            memset(m_ptr+m_size, 0, (newSize-m_size)*sizeof(T));
            m_size = newSize;
        }
    }

    //! change size and preserve contents
    void resize(size_type newSize)
    {
        m_ptr = m_alloc.reallocate(m_ptr, m_size, newSize, true);
        m_size = newSize;
    }

    //! swap contents and size with another SecBlock
    void swap(SecBlock<T, A> &b)
    {
        std::swap(m_alloc, b.m_alloc);
        std::swap(m_size, b.m_size);
        std::swap(m_ptr, b.m_ptr);
    }

//private:
    A m_alloc;
    size_type m_size;
    T *m_ptr;
};

typedef SecBlock<byte> SecByteBlock;
typedef SecBlock<byte, AllocatorWithCleanup<byte, true> > AlignedSecByteBlock;
typedef SecBlock<word> SecWordBlock;

//! a SecBlock with fixed size, allocated statically
template <class T, unsigned int S, class A = FixedSizeAllocatorWithCleanup<T, S> >
class FixedSizeSecBlock : public SecBlock<T, A>
{
public:
    explicit FixedSizeSecBlock() : SecBlock<T, A>(S) {}
};

template <class T, unsigned int S, bool T_Align16 = true>
class FixedSizeAlignedSecBlock : public FixedSizeSecBlock<T, S, FixedSizeAllocatorWithCleanup<T, S, NullAllocator<T>, T_Align16> >
{
};

//! a SecBlock that preallocates size S statically, and uses the heap when this size is exceeded
template <class T, unsigned int S, class A = FixedSizeAllocatorWithCleanup<T, S, AllocatorWithCleanup<T> > >
class SecBlockWithHint : public SecBlock<T, A>
{
public:
    explicit SecBlockWithHint(size_t size) : SecBlock<T, A>(size) {}
};

template<class T, bool A, class U, bool B>
inline bool operator==(const CryptoPP::AllocatorWithCleanup<T, A>&, const CryptoPP::AllocatorWithCleanup<U, B>&) {return (true);}
template<class T, bool A, class U, bool B>
inline bool operator!=(const CryptoPP::AllocatorWithCleanup<T, A>&, const CryptoPP::AllocatorWithCleanup<U, B>&) {return (false);}

NAMESPACE_END

NAMESPACE_BEGIN(std)
template <class T, class A>
inline void swap(CryptoPP::SecBlock<T, A> &a, CryptoPP::SecBlock<T, A> &b)
{
    a.swap(b);
}

#if defined(_STLP_DONT_SUPPORT_REBIND_MEMBER_TEMPLATE) || (defined(_STLPORT_VERSION) && !defined(_STLP_MEMBER_TEMPLATE_CLASSES))
// working for STLport 5.1.3 and MSVC 6 SP5
template <class _Tp1, class _Tp2>
inline CryptoPP::AllocatorWithCleanup<_Tp2>&
__stl_alloc_rebind(CryptoPP::AllocatorWithCleanup<_Tp1>& __a, const _Tp2*)
{
    return (CryptoPP::AllocatorWithCleanup<_Tp2>&)(__a);
}
#endif

NAMESPACE_END

#endif
 


 

Link to comment
  • 0
  • Premium
3 hours ago, arves100 said:

Update your crypto++ to last version

Thanks now it compiles the game perfect :D

Now i've got another one problem with the db compile..

Error:

Spoiler

compile ClientManagerBoot.cpp
ClientManagerBoot.cpp: In member function 'bool CClientManager::InitializeMobTable()':
ClientManagerBoot.cpp:460:22: error: aggregate 'std::ostringstream query' has incomplete type and cannot be defined
   std::ostringstream query;
                      ^
ClientManagerBoot.cpp: In member function 'void CClientManager::CheckItemTable()':
ClientManagerBoot.cpp:700:21: error: aggregate 'std::ostringstream query' has incomplete type and cannot be defined
  std::ostringstream query;
                     ^
ClientManagerBoot.cpp:729:22: error: aggregate 'std::ostringstream query2' has incomplete type and cannot be defined
   std::ostringstream query2;
                      ^
ClientManagerBoot.cpp: In member function 'bool CClientManager::InitializeItemTable()':
ClientManagerBoot.cpp:1032:22: error: aggregate 'std::ostringstream query' has incomplete type and cannot be defined
   std::ostringstream query;
                      ^
gmake: *** [.obj/ClientManagerBoot.o] Error 1
 

Clientmanangerboot:

Spoiler

// vim:ts=4 sw=4
#include <map>
#include "stdafx.h"
#include "ClientManager.h"
#include "Main.h"
#include "Monarch.h"
#include "CsvReader.h"
#include "ProtoReader.h"
#include "Config.h"
#include <cstddef>

#if !defined(nullptr)
#define nullptr NULL
#endif

using namespace std;

extern int g_test_server;
extern std::string g_stLocaleNameColumn;

bool CClientManager::InitializeTables()
{
    int tmpValue;
    int checkthis = 1;
    if (!CConfig::instance().GetValue("TXT_STARTUP", &tmpValue))
        tmpValue = 0;
    if (!CConfig::instance().GetValue("SQL_VNUM_RANGE_CHECK", &checkthis))
        checkthis = 1;
    if (!InitializeMobTable())
    {
        sys_err("InitializeMobTable FAILED");
        return false;
    }
    if(tmpValue == 1)
    {
        if (!MirrorMobTableIntoDB())
        {
            sys_err("MirrorMobTableIntoDB FAILED");
            return false; 
        }
    }

    if(checkthis == 1)
        CheckItemTable();

    if (!InitializeItemTable())
    {
        sys_err("InitializeItemTable FAILED");
        return false; 
    }

    if(tmpValue == 1)
    {
        if (!MirrorItemTableIntoDB())
        {
            sys_err("MirrorItemTableIntoDB FAILED");
            return false; 
        }
    }

    if (!InitializeShopTable())
    {
        sys_err("InitializeShopTable FAILED");
        return false;
    }

    if (!InitializeSkillTable())
    {
        sys_err("InitializeSkillTable FAILED");
        return false;
    }

    if (!InitializeRefineTable())
    {
        sys_err("InitializeRefineTable FAILED");
        return false;
    }

    if (!InitializeItemAttrTable())
    {
        sys_err("InitializeItemAttrTable FAILED");
        return false;
    }

    if (!InitializeItemRareTable())
    {
        sys_err("InitializeItemRareTable FAILED");
        return false;
    }

    if (!InitializeBanwordTable())
    {
        sys_err("InitializeBanwordTable FAILED");
        return false;
    }

    if (!InitializeLandTable())
    {
        sys_err("InitializeLandTable FAILED");
        return false;
    }

    if (!InitializeObjectProto())
    {
        sys_err("InitializeObjectProto FAILED");
        return false;
    }

    if (!InitializeObjectTable())
    {
        sys_err("InitializeObjectTable FAILED");
        return false;
    }

    if (!InitializeMonarch())
    {
        sys_err("InitializeMonarch FAILED");
        return false;
    }


    return true;
}

bool CClientManager::InitializeRefineTable()
{
    char query[2048];

    snprintf(query, sizeof(query),
            "SELECT id, cost, prob, vnum0, count0, vnum1, count1, vnum2, count2,  vnum3, count3, vnum4, count4 FROM refine_proto%s",
            GetTablePostfix());

    std::unique_ptr<SQLMsg> pkMsg(CDBManager::instance().DirectQuery(query));
    SQLResult * pRes = pkMsg->Get();

    if (!pRes->uiNumRows)
        return true;

    if (m_pRefineTable)
    {
        sys_log(0, "RELOAD: refine_proto");
        delete [] m_pRefineTable;
        m_pRefineTable = NULL;
    }

    m_iRefineTableSize = pRes->uiNumRows;

    m_pRefineTable    = new TRefineTable[m_iRefineTableSize];
    memset(m_pRefineTable, 0, sizeof(TRefineTable) * m_iRefineTableSize);

    TRefineTable* prt = m_pRefineTable;
    MYSQL_ROW data;

    while ((data = mysql_fetch_row(pRes->pSQLResult)))
    {
        //const char* s_szQuery = "SELECT src_vnum, result_vnum, cost, prob, "
        //"vnum0, count0, vnum1, count1, vnum2, count2,  vnum3, count3, vnum4, count4 "

        int col = 0;
        //prt->src_vnum = atoi(data[col++]);
        //prt->result_vnum = atoi(data[col++]);
        str_to_number(prt->id, data[col++]);
        str_to_number(prt->cost, data[col++]);
        str_to_number(prt->prob, data[col++]);

        for (int i = 0; i < REFINE_MATERIAL_MAX_NUM; i++)
        {
            str_to_number(prt->materials.vnum, data[col++]);
            str_to_number(prt->materials.count, data[col++]);
            if (prt->materials.vnum == 0)
            {
                prt->material_count = i;
                break;
            }
        }

        sys_log(0, "REFINE: id %ld cost %d prob %d mat1 %lu cnt1 %d", prt->id, prt->cost, prt->prob, prt->materials[0].vnum, prt->materials[0].count);

        prt++;
    }
    return true;
}

class FCompareVnum
{
    public:
        bool operator () (const TEntityTable & a, const TEntityTable & B) const
        {
            return (a.dwVnum < b.dwVnum);
        }
};

bool CClientManager::InitializeMobTable()
{
    int tmpValue = 0;
    if (!CConfig::instance().GetValue("TXT_STARTUP", &tmpValue))
        tmpValue = 0;
    if(tmpValue == 1)
    {
            
        //================== 함수 설명 ==================//
        //1. 요약 : 'mob_proto.txt', 'mob_proto_test.txt', 'mob_names.txt' 파일을 읽고,
        //        (!)[mob_table] 테이블 오브젝트를 생성한다. (타입 : TMobTable)
        //2. 순서
        //    1) 'mob_names.txt' 파일을 읽어서 (a)[localMap](vnum:name) 맵을 만든다.
        //    2) 'mob_proto_test.txt'파일과 (a)[localMap] 맵으로
        //        (b)[test_map_mobTableByVnum](vnum:TMobTable) 맵을 생성한다.
        //    3) 'mob_proto.txt' 파일과  (a)[localMap] 맵으로
        //        (!)[mob_table] 테이블을 만든다.
        //            <참고>
        //            각 row 들 중, 
        //            (b)[test_map_mobTableByVnum],(!)[mob_table] 모두에 있는 row는
        //            (b)[test_map_mobTableByVnum]의 것을 사용한다.
        //    4) (b)[test_map_mobTableByVnum]의 row중, (!)[mob_table]에 없는 것을 추가한다.
        //3. 테스트
        //    1)'mob_proto.txt' 정보가 mob_table에 잘 들어갔는지. -> 완료
        //    2)'mob_names.txt' 정보가 mob_table에 잘 들어갔는지.
        //    3)'mob_proto_test.txt' 에서 [겹치는] 정보가 mob_table 에 잘 들어갔는지.
        //    4)'mob_proto_test.txt' 에서 [새로운] 정보가 mob_table 에 잘 들어갔는지.
        //    5) (최종) 게임 클라이언트에서 제대로 작동 하는지.
        //_______________________________________________//


        //===============================================//
        //    1) 'mob_names.txt' 파일을 읽어서 (a)[localMap] 맵을 만든다.
        //<(a)localMap 맵 생성>
        map<int,const char*> localMap;
//        bool isNameFile = true;
        //<파일 읽기>
        cCsvTable nameData;
        if(!nameData.Load("mob_names.txt",'\t'))
        {
            fprintf(stderr, "mob_names.txt 파일을 읽어오지 못했습니다\n");
//            isNameFile = false;
        } else {
            nameData.Next();    //설명row 생략.
            while(nameData.Next()) {
                localMap[atoi(nameData.AsStringByIndex(0))] = nameData.AsStringByIndex(1);
            }
        }
        //________________________________________________//

        
        //===============================================//
        //    2) 'mob_proto_test.txt'파일과 (a)localMap 맵으로
        //        (b)[test_map_mobTableByVnum](vnum:TMobTable) 맵을 생성한다.
        //0. 
        set<int> vnumSet;    //테스트용 파일 데이터중, 신규여부 확인에 사용.
        //1. 파일 읽어오기
        bool isTestFile = true;
        cCsvTable test_data;
        if(!test_data.Load("mob_proto_test.txt",'\t'))
        {
            fprintf(stderr, "테스트 파일이 없습니다. 그대로 진행합니다.\n");
            isTestFile = false;
        }
        //2. (c)[test_map_mobTableByVnum](vnum:TMobTable) 맵 생성.
        map<DWORD, TMobTable *> test_map_mobTableByVnum;
        if (isTestFile) {
            test_data.Next();    //설명 로우 넘어가기.

            //ㄱ. 테스트 몬스터 테이블 생성.
            TMobTable * test_mob_table = NULL;
            int test_MobTableSize = test_data.m_File.GetRowCount()-1;
            test_mob_table = new TMobTable[test_MobTableSize];
            memset(test_mob_table, 0, sizeof(TMobTable) * test_MobTableSize);

            //ㄴ. 테스트 몬스터 테이블에 값을 넣고, 맵에까지 넣기.
            while(test_data.Next()) {

                if (!Set_Proto_Mob_Table(test_mob_table, test_data, localMap))
                {
                    fprintf(stderr, "몹 프로토 테이블 셋팅 실패.\n");            
                }

                test_map_mobTableByVnum.insert(std::map<DWORD, TMobTable *>::value_type(test_mob_table->dwVnum, test_mob_table));

                
                ++test_mob_table;
                }

        }

        //    3) 'mob_proto.txt' 파일과  (a)[localMap] 맵으로
        //        (!)[mob_table] 테이블을 만든다.
        //            <참고>
        //            각 row 들 중, 
        //            (b)[test_map_mobTableByVnum],(!)[mob_table] 모두에 있는 row는
        //            (b)[test_map_mobTableByVnum]의 것을 사용한다.

        //1. 파일 읽기.
        cCsvTable data;
        if(!data.Load("mob_proto.txt",'\t')) {
            fprintf(stderr, "mob_proto.txt 파일을 읽어오지 못했습니다\n");
            return false;
        }
        data.Next();                    //설명 row 넘어가기
        //2. (!)[mob_table] 생성하기
        //2.1 새로 추가되는 갯수를 파악
        int addNumber = 0;
        while(data.Next()) {
            int vnum = atoi(data.AsStringByIndex(0));
            std::map<DWORD, TMobTable *>::iterator it_map_mobTable;
            it_map_mobTable = test_map_mobTableByVnum.find(vnum);
            if(it_map_mobTable != test_map_mobTableByVnum.end()) {
                addNumber++;
            }
        }
        //data를 다시 첫줄로 옮긴다.(다시 읽어온다;;)
        data.Destroy();
        if(!data.Load("mob_proto.txt",'\t'))
        {
            fprintf(stderr, "mob_proto.txt 파일을 읽어오지 못했습니다\n");
            return false;
        }
        data.Next(); //맨 윗줄 제외 (아이템 칼럼을 설명하는 부분)
        //2.2 크기에 맞게 mob_table 생성
        if (!m_vec_mobTable.empty())
        {
            sys_log(0, "RELOAD: mob_proto");
            m_vec_mobTable.clear();
        }
        m_vec_mobTable.resize(data.m_File.GetRowCount()-1 + addNumber);
        memset(&m_vec_mobTable[0], 0, sizeof(TMobTable) * m_vec_mobTable.size());
        TMobTable * mob_table = &m_vec_mobTable[0];
        //2.3 데이터 채우기
        while (data.Next())
        {
            int col = 0;
            //(b)[test_map_mobTableByVnum]에 같은 row가 있는지 조사.
            bool isSameRow = true;
            std::map<DWORD, TMobTable *>::iterator it_map_mobTable;
            it_map_mobTable = test_map_mobTableByVnum.find(atoi(data.AsStringByIndex(col)));
            if(it_map_mobTable == test_map_mobTableByVnum.end()) {
                isSameRow = false;
            }
            //같은 row 가 있으면 (b)에서 읽어온다.
            if(isSameRow) {
                TMobTable *tempTable = it_map_mobTable->second;

                mob_table->dwVnum = tempTable->dwVnum;
                strlcpy(mob_table->szName, tempTable->szName, sizeof(tempTable->szName));
                strlcpy(mob_table->szLocaleName, tempTable->szLocaleName, sizeof(tempTable->szName));
                mob_table->bRank = tempTable->bRank;
                mob_table->bType = tempTable->bType;
                mob_table->bBattleType = tempTable->bBattleType;
                mob_table->bLevel = tempTable->bLevel;
                mob_table->bSize = tempTable->bSize;
                mob_table->dwAIFlag = tempTable->dwAIFlag;
                mob_table->dwRaceFlag = tempTable->dwRaceFlag;
                mob_table->dwImmuneFlag = tempTable->dwImmuneFlag;
                mob_table->bEmpire = tempTable->bEmpire;
                strlcpy(mob_table->szFolder, tempTable->szFolder, sizeof(tempTable->szName));
                mob_table->bOnClickType = tempTable->bOnClickType;
                mob_table->bStr = tempTable->bStr;
                mob_table->bDex = tempTable->bDex;
                mob_table->bCon = tempTable->bCon;
                mob_table->bInt = tempTable->bInt;
                mob_table->dwDamageRange[0] = tempTable->dwDamageRange[0];
                mob_table->dwDamageRange[1] = tempTable->dwDamageRange[1];
                mob_table->dwMaxHP = tempTable->dwMaxHP;
                mob_table->bRegenCycle = tempTable->bRegenCycle;
                mob_table->bRegenPercent = tempTable->bRegenPercent;
                mob_table->dwGoldMin = tempTable->dwGoldMin;
                mob_table->dwGoldMax = tempTable->dwGoldMax;
                mob_table->dwExp = tempTable->dwExp;
                mob_table->wDef = tempTable->wDef;
                mob_table->sAttackSpeed = tempTable->sAttackSpeed;
                mob_table->sMovingSpeed = tempTable->sMovingSpeed;
                mob_table->bAggresiveHPPct = tempTable->bAggresiveHPPct;
                mob_table->wAggressiveSight = tempTable->wAggressiveSight;
                mob_table->wAttackRange = tempTable->wAttackRange;
                    
                mob_table->dwDropItemVnum = tempTable->dwDropItemVnum;
                mob_table->dwResurrectionVnum = tempTable->dwResurrectionVnum;
                for (int i = 0; i < MOB_ENCHANTS_MAX_NUM; ++i)
                    mob_table->cEnchants = tempTable->cEnchants;
                    
                for (int i = 0; i < MOB_RESISTS_MAX_NUM; ++i)
                    mob_table->cResists = tempTable->cResists;
                    
                mob_table->fDamMultiply = tempTable->fDamMultiply;
                mob_table->dwSummonVnum = tempTable->dwSummonVnum;
                mob_table->dwDrainSP = tempTable->dwDrainSP;
                mob_table->dwPolymorphItemVnum = tempTable->dwPolymorphItemVnum;
                    
                
                mob_table->Skills[0].bLevel = tempTable->Skills[0].bLevel;
                mob_table->Skills[0].dwVnum = tempTable->Skills[0].dwVnum;
                mob_table->Skills[1].bLevel = tempTable->Skills[1].bLevel;
                mob_table->Skills[1].dwVnum = tempTable->Skills[1].dwVnum;
                mob_table->Skills[2].bLevel = tempTable->Skills[2].bLevel;
                mob_table->Skills[2].dwVnum = tempTable->Skills[2].dwVnum;
                mob_table->Skills[3].bLevel = tempTable->Skills[3].bLevel;
                mob_table->Skills[3].dwVnum = tempTable->Skills[3].dwVnum;
                mob_table->Skills[4].bLevel = tempTable->Skills[4].bLevel;
                mob_table->Skills[4].dwVnum = tempTable->Skills[4].dwVnum;
                    
                mob_table->bBerserkPoint = tempTable->bBerserkPoint;
                mob_table->bStoneSkinPoint = tempTable->bStoneSkinPoint;
                mob_table->bGodSpeedPoint = tempTable->bGodSpeedPoint;
                mob_table->bDeathBlowPoint = tempTable->bDeathBlowPoint;
                mob_table->bRevivePoint = tempTable->bRevivePoint;
            } else {

                if (!Set_Proto_Mob_Table(mob_table, data, localMap))
                {
                    fprintf(stderr, "몹 프로토 테이블 셋팅 실패.\n");            
                }

                            
            }

            //셋에 vnum 추가
            vnumSet.insert(mob_table->dwVnum);
            

            sys_log(1, "MOB #%-5d %-24s %-24s level: %-3u rank: %u empire: %d", mob_table->dwVnum, mob_table->szName, mob_table->szLocaleName, mob_table->bLevel, mob_table->bRank, mob_table->bEmpire);
            ++mob_table;

        }
        //_____________________________________________________//


        //    4) (b)[test_map_mobTableByVnum]의 row중, (!)[mob_table]에 없는 것을 추가한다.
        //파일 다시 읽어오기.
        test_data.Destroy();
        isTestFile = true;
        //test_data;
        if(!test_data.Load("mob_proto_test.txt",'\t'))
        {
            fprintf(stderr, "테스트 파일이 없습니다. 그대로 진행합니다.\n");
            isTestFile = false;
        }
        if(isTestFile) {
            test_data.Next();    //설명 로우 넘어가기.

            while (test_data.Next())    //테스트 데이터 각각을 훑어나가며,새로운 것을 추가한다.
            {
                //중복되는 부분이면 넘어간다.
                set<int>::iterator itVnum;
                itVnum=vnumSet.find(atoi(test_data.AsStringByIndex(0)));
                if (itVnum != vnumSet.end()) {
                    continue;
                }

                if (!Set_Proto_Mob_Table(mob_table, test_data, localMap))
                {
                    fprintf(stderr, "몹 프로토 테이블 셋팅 실패.\n");            
                }

                sys_log(0, "MOB #%-5d %-24s %-24s level: %-3u rank: %u empire: %d", mob_table->dwVnum, mob_table->szName, mob_table->szLocaleName, mob_table->bLevel, mob_table->bRank, mob_table->bEmpire);
                ++mob_table;

            }
        }
        sort(m_vec_mobTable.begin(), m_vec_mobTable.end(), FCompareVnum());
        return true;
    } else {
        std::ostringstream query; 
        query << "SELECT vnum, name, " << g_stLocaleNameColumn << ", type, rank, battle_type, level, size+0, ai_flag+0, setRaceFlag+0, setImmuneFlag+0, on_click, empire, drop_item, resurrection_vnum, folder, st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, dam_multiply, summon, drain_sp, skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, skill_vnum3, skill_level3, skill_vnum4, skill_level4 , sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive  FROM mob_proto ORDER BY vnum"; 
        SQLMsg* sqlMsg = CDBManager::instance().DirectQuery(query.str().c_str(), 0); 
        if (sqlMsg == nullptr) { 
            sys_err("libdb::InitializeMobTable", __LINE__, "Could not load mob_proto. Query failed!"); 
            return false; 
        } 
        MYSQL_RES* pRes = sqlMsg->Get()->pSQLResult; 

        if (!pRes) { 
            sys_err("libdb::InitializeMobTable", __LINE__, "Could not load mob_proto. No result!"); 
            return false; 
        } 

        if (!m_vec_mobTable.empty()) { 
            sys_log(__LINE__, " Reloading mob_proto"); 
            m_vec_mobTable.clear(); 
        } 
        MYSQL_ROW row; 
        while ((row = mysql_fetch_row(pRes))) { 
            SMobTable temp = {}; 
            if (row[0]) temp.dwVnum = strtoul(row[0], NULL, 10); 
            if (row[1]) snprintf(temp.szName, 25, "%s", row[1]); 
            if (row[2]) snprintf(temp.szLocaleName, 25, "%s", row[2]); 
            if (row[3]) temp.bType = strtoul(row[3], NULL, 10); 
            if (row[4]) temp.bRank = strtoul(row[4], NULL, 10); 
            if (row[5]) temp.bBattleType = strtoul(row[5], NULL, 10); 
            if (row[6]) temp.bLevel = strtoul(row[6], NULL, 10); 
            if (row[7]) temp.bSize = strtoul(row[7], NULL, 10); 
            if (row[8]) temp.dwAIFlag = strtoul(row[8], NULL, 10); 
            if (row[9]) temp.dwRaceFlag = strtoul(row[9], NULL, 10); 
            if (row[10]) temp.dwImmuneFlag = strtoul(row[10], NULL, 10); 
            if (row[11]) temp.bOnClickType = strtoul(row[11], NULL, 10); 
            if (row[12]) temp.bEmpire = strtoul(row[12], NULL, 10); 
            if (row[13]) temp.dwDropItemVnum = strtoul(row[13], NULL, 10); 
            if (row[14]) temp.dwResurrectionVnum = strtoul(row[14], NULL, 10); 
            if (row[15]) snprintf(temp.szFolder, 65, "%s", row[15]); 
            if (row[16]) temp.bStr = strtoul(row[16], NULL, 10); 
            if (row[17]) temp.bDex = strtoul(row[17], NULL, 10); 
            if (row[18]) temp.bCon = strtoul(row[18], NULL, 10); 
            if (row[19]) temp.bInt = strtoul(row[19], NULL, 10); 
            if (row[20]) temp.dwDamageRange[0] = strtoul(row[20], NULL, 10); 
            if (row[21]) temp.dwDamageRange[1] = strtoul(row[21], NULL, 10); 
            if (row[22]) temp.dwMaxHP = strtoul(row[22], NULL, 10); 
            if (row[23]) temp.bRegenCycle = strtoul(row[23], NULL, 10); 
            if (row[24]) temp.bRegenPercent = strtoul(row[24], NULL, 10); 
            if (row[25]) temp.dwExp = strtoul(row[25], NULL, 10); 
            if (row[26]) temp.dwGoldMin = strtoul(row[26], NULL, 10); 
            if (row[27]) temp.dwGoldMax = strtoul(row[27], NULL, 10); 
            if (row[28]) temp.wDef = strtol(row[28], NULL, 10); 
            if (row[29]) temp.sAttackSpeed = strtol(row[29], NULL, 10); 
            if (row[30]) temp.sMovingSpeed = strtol(row[30], NULL, 10); 
            if (row[31]) temp.bAggresiveHPPct = strtol(row[31], NULL, 10); 
            if (row[32]) temp.wAggressiveSight = strtol(row[32], NULL, 10); 
            if (row[33]) temp.wAttackRange = strtol(row[33], NULL, 10); 
            if (row[34]) temp.dwPolymorphItemVnum = strtoul(row[34], NULL, 10); 
            if (row[35]) temp.cEnchants[0] = strtol(row[35], NULL, 10); 
            if (row[36]) temp.cEnchants[1] = strtol(row[36], NULL, 10); 
            if (row[37]) temp.cEnchants[2] = strtol(row[37], NULL, 10); 
            if (row[38]) temp.cEnchants[3] = strtol(row[38], NULL, 10); 
            if (row[39]) temp.cEnchants[4] = strtol(row[39], NULL, 10); 
            if (row[40]) temp.cEnchants[5] = strtol(row[40], NULL, 10); 
            if (row[41]) temp.cResists[0] = strtol(row[41], NULL, 10); 
            if (row[42]) temp.cResists[1] = strtol(row[42], NULL, 10); 
            if (row[43]) temp.cResists[2] = strtol(row[43], NULL, 10); 
            if (row[44]) temp.cResists[3] = strtol(row[44], NULL, 10); 
            if (row[45]) temp.cResists[4] = strtol(row[45], NULL, 10); 
            if (row[46]) temp.cResists[5] = strtol(row[46], NULL, 10); 
            if (row[47]) temp.cResists[6] = strtol(row[47], NULL, 10); 
            if (row[48]) temp.cResists[7] = strtol(row[48], NULL, 10); 
            if (row[49]) temp.cResists[8] = strtol(row[49], NULL, 10); 
            if (row[50]) temp.cResists[9] = strtol(row[50], NULL, 10); 
            if (row[51]) temp.cResists[10] = strtol(row[51], NULL, 10); 
            if (row[52]) temp.fDamMultiply = strtod(row[52], NULL); 
            if (row[53]) temp.dwSummonVnum = strtoul(row[53], NULL, 10); 
            if (row[54]) temp.dwDrainSP = strtoul(row[54], NULL, 10); 
            if (row[55]) temp.Skills[0].dwVnum = strtoul(row[55], NULL, 10); 
            if (row[56]) temp.Skills[0].bLevel = strtoul(row[56], NULL, 10); 
            if (row[57]) temp.Skills[1].dwVnum = strtoul(row[57], NULL, 10); 
            if (row[58]) temp.Skills[1].bLevel = strtoul(row[58], NULL, 10); 
            if (row[59]) temp.Skills[2].dwVnum = strtoul(row[59], NULL, 10); 
            if (row[60]) temp.Skills[2].bLevel = strtoul(row[60], NULL, 10); 
            if (row[61]) temp.Skills[3].dwVnum = strtoul(row[61], NULL, 10); 
            if (row[62]) temp.Skills[3].bLevel = strtoul(row[62], NULL, 10); 
            if (row[63]) temp.Skills[4].dwVnum = strtoul(row[63], NULL, 10); 
            if (row[64]) temp.Skills[4].bLevel = strtoul(row[64], NULL, 10); 
            if (row[65]) temp.bBerserkPoint = strtoul(row[65], NULL, 10); 
            if (row[66]) temp.bStoneSkinPoint = strtoul(row[66], NULL, 10); 
            if (row[67]) temp.bGodSpeedPoint = strtoul(row[67], NULL, 10); 
            if (row[68]) temp.bDeathBlowPoint = strtoul(row[68], NULL, 10); 
            if (row[69]) temp.bRevivePoint = strtoul(row[69], NULL, 10); 
            m_vec_mobTable.push_back(temp); 
        } 
        mysql_free_result(pRes); 
        sort(m_vec_mobTable.begin(), m_vec_mobTable.end(), FCompareVnum()); 
        std::cout << "CClientManager::InitializeMobTable:: " << m_vec_mobTable.size() << " mobs loaded." << std::endl; 
        return true; 
    }
}

bool CClientManager::InitializeShopTable()
{
    MYSQL_ROW    data;
    int        col;

    static const char * s_szQuery = 
        "SELECT "
        "shop.vnum, "
        "shop.npc_vnum, "
        "shop_item.item_vnum, "
        "shop_item.count "
        "FROM shop LEFT JOIN shop_item "
        "ON shop.vnum = shop_item.shop_vnum ORDER BY shop.vnum, shop_item.item_vnum";

    std::unique_ptr<SQLMsg> pkMsg2(CDBManager::instance().DirectQuery(s_szQuery));

    // shop의 vnum은 있는데 shop_item 이 없을경우... 실패로 처리되니 주의 요망.
    // 고처야할부분
    SQLResult * pRes2 = pkMsg2->Get();

    if (!pRes2->uiNumRows)
    {
        sys_err("InitializeShopTable : Table count is zero.");
        return false;
    }

    std::map<int, TShopTable *> map_shop;

    if (m_pShopTable)
    {
        delete [] (m_pShopTable);
        m_pShopTable = NULL;
    }

    TShopTable * shop_table = m_pShopTable;

    while ((data = mysql_fetch_row(pRes2->pSQLResult)))
    {
        col = 0;

        int iShopVnum = 0;
        str_to_number(iShopVnum, data[col++]);

        if (map_shop.end() == map_shop.find(iShopVnum))
        {
            shop_table = new TShopTable;
            memset(shop_table, 0, sizeof(TShopTable));
            shop_table->dwVnum    = iShopVnum;

            map_shop[iShopVnum] = shop_table;
        }
        else
            shop_table = map_shop[iShopVnum];

        str_to_number(shop_table->dwNPCVnum, data[col++]);

        if (!data[col])    // 아이템이 하나도 없으면 NULL이 리턴 되므로..
            continue;

        TShopItemTable * pItem = &shop_table->items[shop_table->byItemCount];

        str_to_number(pItem->vnum, data[col++]);
        str_to_number(pItem->count, data[col++]);

        ++shop_table->byItemCount;
    }

    m_pShopTable = new TShopTable[map_shop.size()];
    m_iShopTableSize = map_shop.size();

    __typeof(map_shop.begin()) it = map_shop.begin();

    int i = 0;

    while (it != map_shop.end())
    {
        thecore_memcpy((m_pShopTable + i), (it++)->second, sizeof(TShopTable));
        sys_log(0, "SHOP: #%d items: %d", (m_pShopTable + i)->dwVnum, (m_pShopTable + i)->byItemCount);
        ++i;
    }

    return true;
}

bool CClientManager::InitializeQuestItemTable()
{
    using namespace std;

    static const char * s_szQuery = "SELECT vnum, name, %s FROM quest_item_proto ORDER BY vnum";

    char query[1024];
    snprintf(query, sizeof(query), s_szQuery, g_stLocaleNameColumn.c_str());

    std::unique_ptr<SQLMsg> pkMsg(CDBManager::instance().DirectQuery(query));
    SQLResult * pRes = pkMsg->Get();

    if (!pRes->uiNumRows)
    {
        sys_err("query error or no rows: %s", query);
        return false;
    }

    MYSQL_ROW row;

    while ((row = mysql_fetch_row(pRes->pSQLResult)))
    {
        int col = 0;

        TItemTable tbl;
        memset(&tbl, 0, sizeof(tbl));

        str_to_number(tbl.dwVnum, row[col++]);

        if (row[col])
            strlcpy(tbl.szName, row[col], sizeof(tbl.szName));

        col++;

        if (row[col])
            strlcpy(tbl.szLocaleName, row[col], sizeof(tbl.szLocaleName));

        col++;

        if (m_map_itemTableByVnum.find(tbl.dwVnum) != m_map_itemTableByVnum.end())
        {
            sys_err("QUEST_ITEM_ERROR! %lu vnum already exist! (name %s)", tbl.dwVnum, tbl.szLocaleName);
            continue;
        }

        tbl.bType = ITEM_QUEST; // quest_item_proto 테이블에 있는 것들은 모두 ITEM_QUEST 유형
        tbl.bSize = 1;

        m_vec_itemTable.push_back(tbl);
    }

    return true;
}

void CClientManager::CheckItemTable()
{
    std::ostringstream query; 
    query << "SHOW COLUMNS FROM item_proto WHERE field='vnum_range'"; 
    SQLMsg* sqlMsg = CDBManager::instance().DirectQuery(query.str().c_str(), 0); 
    if (sqlMsg == nullptr) { 
        sys_err("libdb::CheckItemTable", __LINE__, "Could not load item_proto. Query failed!"); 
        return; 
    } 
    bool everything_ok = false;

    MYSQL_RES* pRes = sqlMsg->vec_pkResult[0]->pSQLResult; 

    if (pRes == nullptr) { 
        //vnum_range isn't there!
        everything_ok = false;
    } else if(pRes) {
        if (mysql_num_rows(pRes) != 0)
        {
            everything_ok = true;
        }
    } else {
        if (mysql_num_rows(pRes) == 0)
        {
            everything_ok = false;
        }
    }
    
    if(everything_ok==false)
    {
        sys_err("libdb::CheckItemTable: Found a mismatch! Attempting to upgrade your item_proto...");
        std::ostringstream query2; 
        query2 << "ALTER TABLE item_proto ADD vnum_range tinyint(4) NOT NULL DEFAULT 0"; 
        SQLMsg* sqlMsg2 = CDBManager::instance().DirectQuery(query2.str().c_str(), 0); 
        if (sqlMsg2 == nullptr) { 
            sys_err("libdb::CheckItemTable", __LINE__, "Could not upgrade. Query failed!"); 
            return; 
        }
        sys_err("libdb::CheckItemTable: Upgrading item_proto success! Ready to go!");
        everything_ok = true;
        sqlMsg2 = NULL;
        delete(sqlMsg2);
    }
    //everything's ready to go!?
    if(everything_ok == true)
        sys_log(0, "libdb::CheckItemTable: Sanity check for vnum_range is OK!");
    else
        sys_log(0, "libdb::CheckItemTable: Sanity check for vnum_range is not okay!!!!");
    mysql_free_result(pRes);
    sqlMsg = NULL;
    delete(sqlMsg);
}

bool CClientManager::InitializeItemTable()
{
    int tmpValue = 0;
    if (!CConfig::instance().GetValue("TXT_STARTUP", &tmpValue))
        tmpValue = 0;
    if(tmpValue == 1)
    {
        //================== 함수 설명 ==================//
        //1. 요약 : 'item_proto.txt', 'item_proto_test.txt', 'item_names.txt' 파일을 읽고,
        //        <item_table>(TItemTable), <m_map_itemTableByVnum> 오브젝트를 생성한다.
        //2. 순서
        //    1) 'item_names.txt' 파일을 읽어서 (a)[localMap](vnum:name) 맵을 만든다.
        //    2) 'item_proto_text.txt'파일과 (a)[localMap] 맵으로
        //        (b)[test_map_itemTableByVnum](vnum:TItemTable) 맵을 생성한다.
        //    3) 'item_proto.txt' 파일과  (a)[localMap] 맵으로
        //        (!)[item_table], <m_map_itemTableByVnum>을 만든다.
        //            <참고>
        //            각 row 들 중, 
        //            (b)[test_map_itemTableByVnum],(!)[mob_table] 모두에 있는 row는
        //            (b)[test_map_itemTableByVnum]의 것을 사용한다.
        //    4) (b)[test_map_itemTableByVnum]의 row중, (!)[item_table]에 없는 것을 추가한다.
        //3. 테스트
        //    1)'item_proto.txt' 정보가 item_table에 잘 들어갔는지. -> 완료
        //    2)'item_names.txt' 정보가 item_table에 잘 들어갔는지.
        //    3)'item_proto_test.txt' 에서 [겹치는] 정보가 item_table 에 잘 들어갔는지.
        //    4)'item_proto_test.txt' 에서 [새로운] 정보가 item_table 에 잘 들어갔는지.
        //    5) (최종) 게임 클라이언트에서 제대로 작동 하는지.
        //_______________________________________________//

        //=================================================================================//
        //    1) 'item_names.txt' 파일을 읽어서 (a)[localMap](vnum:name) 맵을 만든다.
        //=================================================================================//
//        bool isNameFile = true;
        map<int,const char*> localMap;
        cCsvTable nameData;
        if(!nameData.Load("item_names.txt",'\t'))
        {
            fprintf(stderr, "item_names.txt 파일을 읽어오지 못했습니다\n");
//            isNameFile = false;
        } else {
            nameData.Next();
            while(nameData.Next()) {
                localMap[atoi(nameData.AsStringByIndex(0))] = nameData.AsStringByIndex(1);
            }
        }
        //_________________________________________________________________//

        //=================================================================//
        //    2) 'item_proto_text.txt'파일과 (a)[localMap] 맵으로
        //        (b)[test_map_itemTableByVnum](vnum:TItemTable) 맵을 생성한다.
        //=================================================================//
        map<DWORD, TItemTable *> test_map_itemTableByVnum;
        //1. 파일 읽어오기.
        cCsvTable test_data;
        if(!test_data.Load("item_proto_test.txt",'\t'))
        {
            fprintf(stderr, "item_proto_test.txt 파일을 읽어오지 못했습니다\n");
            //return false;
        } else {
            test_data.Next();    //설명 로우 넘어가기.

            //2. 테스트 아이템 테이블 생성.
            TItemTable * test_item_table = NULL;
            int test_itemTableSize = test_data.m_File.GetRowCount()-1;
            test_item_table = new TItemTable[test_itemTableSize];
            memset(test_item_table, 0, sizeof(TItemTable) * test_itemTableSize);

            //3. 테스트 아이템 테이블에 값을 넣고, 맵에까지 넣기.
            while(test_data.Next()) {


                if (!Set_Proto_Item_Table(test_item_table, test_data, localMap))
                {
                    fprintf(stderr, "아이템 프로토 테이블 셋팅 실패.\n");            
                }

                test_map_itemTableByVnum.insert(std::map<DWORD, TItemTable *>::value_type(test_item_table->dwVnum, test_item_table));
                test_item_table++;

            }
        }
        //______________________________________________________________________//


        //========================================================================//
        //    3) 'item_proto.txt' 파일과  (a)[localMap] 맵으로
        //        (!)[item_table], <m_map_itemTableByVnum>을 만든다.
        //            <참고>
        //            각 row 들 중, 
        //            (b)[test_map_itemTableByVnum],(!)[mob_table] 모두에 있는 row는
        //            (b)[test_map_itemTableByVnum]의 것을 사용한다.
        //========================================================================//

        //vnum들을 저장할 셋. 새로운 테스트 아이템을 판별할때 사용된다.
        set<int> vnumSet;

        //파일 읽어오기.
        cCsvTable data;
        if(!data.Load("item_proto.txt",'\t'))
        {
            fprintf(stderr, "item_proto.txt 파일을 읽어오지 못했습니다\n");
            return false;
        }
        data.Next(); //맨 윗줄 제외 (아이템 칼럼을 설명하는 부분)

        if (!m_vec_itemTable.empty())
        {
            sys_log(0, "RELOAD: item_proto");
            m_vec_itemTable.clear();
            m_map_itemTableByVnum.clear();
        }

        //===== 아이템 테이블 생성 =====//
        //새로 추가되는 갯수를 파악한다.
        int addNumber = 0;
        while(data.Next()) {
            int vnum = atoi(data.AsStringByIndex(0));
            std::map<DWORD, TItemTable *>::iterator it_map_itemTable;
            it_map_itemTable = test_map_itemTableByVnum.find(vnum);
            if(it_map_itemTable != test_map_itemTableByVnum.end()) {
                addNumber++;
            }
        }
        //data를 다시 첫줄로 옮긴다.(다시 읽어온다;;)
        data.Destroy();
        if(!data.Load("item_proto.txt",'\t'))
        {
            fprintf(stderr, "item_proto.txt 파일을 읽어오지 못했습니다\n");
            return false;
        }
        data.Next(); //맨 윗줄 제외 (아이템 칼럼을 설명하는 부분)

        m_vec_itemTable.resize(data.m_File.GetRowCount() - 1 + addNumber);
        memset(&m_vec_itemTable[0], 0, sizeof(TItemTable) * m_vec_itemTable.size());
//        int testValue =  m_vec_itemTable.size();

        TItemTable * item_table = &m_vec_itemTable[0];

        while (data.Next())
        {
            int col = 0;

            std::map<DWORD, TItemTable *>::iterator it_map_itemTable;
            it_map_itemTable = test_map_itemTableByVnum.find(atoi(data.AsStringByIndex(col)));
            if(it_map_itemTable == test_map_itemTableByVnum.end()) {
                //각 칼럼 데이터 저장
                
                if (!Set_Proto_Item_Table(item_table, data, localMap))
                {
                    fprintf(stderr, "아이템 프로토 테이블 셋팅 실패.\n");            
                }


                
            } else {    //$$$$$$$$$$$$$$$$$$$$$$$ 테스트 아이템 정보가 있다!    
                TItemTable *tempTable = it_map_itemTable->second;

                item_table->dwVnum = tempTable->dwVnum;
                strlcpy(item_table->szName, tempTable->szName, sizeof(item_table->szName));
                strlcpy(item_table->szLocaleName, tempTable->szLocaleName, sizeof(item_table->szLocaleName));
                item_table->bType = tempTable->bType;
                item_table->bSubType = tempTable->bSubType;
                item_table->bSize = tempTable->bSize;
                item_table->dwAntiFlags = tempTable->dwAntiFlags;
                item_table->dwFlags = tempTable->dwFlags;
                item_table->dwWearFlags = tempTable->dwWearFlags;
                item_table->dwImmuneFlag = tempTable->dwImmuneFlag;
                item_table->dwGold = tempTable->dwGold;
                item_table->dwShopBuyPrice = tempTable->dwShopBuyPrice;
                item_table->dwRefinedVnum =tempTable->dwRefinedVnum;
                item_table->wRefineSet =tempTable->wRefineSet;
                item_table->bAlterToMagicItemPct = tempTable->bAlterToMagicItemPct;
                item_table->cLimitRealTimeFirstUseIndex = -1;
                item_table->cLimitTimerBasedOnWearIndex = -1;

                int i;

                for (i = 0; i < ITEM_LIMIT_MAX_NUM; ++i)
                {
                    item_table->aLimits.bType = tempTable->aLimits.bType;
                    item_table->aLimits.lValue = tempTable->aLimits.lValue;

                    if (LIMIT_REAL_TIME_START_FIRST_USE == item_table->aLimits.bType)
                        item_table->cLimitRealTimeFirstUseIndex = (char)i;

                    if (LIMIT_TIMER_BASED_ON_WEAR == item_table->aLimits.bType)
                        item_table->cLimitTimerBasedOnWearIndex = (char)i;
                }

                for (i = 0; i < ITEM_APPLY_MAX_NUM; ++i)
                {
                    item_table->aApplies.bType = tempTable->aApplies.bType;
                    item_table->aApplies.lValue = tempTable->aApplies.lValue;
                }

                for (i = 0; i < ITEM_VALUES_MAX_NUM; ++i)
                    item_table->alValues = tempTable->alValues;

                item_table->bGainSocketPct = tempTable->bGainSocketPct;
                item_table->sAddonType = tempTable->sAddonType;

                item_table->bWeight  = tempTable->bWeight;

            }
            vnumSet.insert(item_table->dwVnum);
            m_map_itemTableByVnum.insert(std::map<DWORD, TItemTable *>::value_type(item_table->dwVnum, item_table));
            ++item_table;
        }
        //_______________________________________________________________________//

        //========================================================================//
        //    4) (b)[test_map_itemTableByVnum]의 row중, (!)[item_table]에 없는 것을 추가한다.
        //========================================================================//
        test_data.Destroy();
        if(!test_data.Load("item_proto_test.txt",'\t'))
        {
            fprintf(stderr, "item_proto_test.txt 파일을 읽어오지 못했습니다\n");
            //return false;
        } else {
            test_data.Next();    //설명 로우 넘어가기.

            while (test_data.Next())    //테스트 데이터 각각을 훑어나가며,새로운 것을 추가한다.
            {
                //중복되는 부분이면 넘어간다.
                set<int>::iterator itVnum;
                itVnum=vnumSet.find(atoi(test_data.AsStringByIndex(0)));
                if (itVnum != vnumSet.end()) {
                    continue;
                }
                
                if (!Set_Proto_Item_Table(item_table, test_data, localMap))
                {
                    fprintf(stderr, "아이템 프로토 테이블 셋팅 실패.\n");            
                }


                m_map_itemTableByVnum.insert(std::map<DWORD, TItemTable *>::value_type(item_table->dwVnum, item_table));

                item_table++;

            }
        }

        // QUEST_ITEM_PROTO_DISABLE
        // InitializeQuestItemTable();
        // END_OF_QUEST_ITEM_PROTO_DISABLE

        m_map_itemTableByVnum.clear();

        itertype(m_vec_itemTable) it = m_vec_itemTable.begin();

        while (it != m_vec_itemTable.end())
        {
            TItemTable * item_table = &(*(it++));

            sys_log(1, "ITEM: #%-5lu %-24s %-24s VAL: %ld %ld %ld %ld %ld %ld WEAR %lu ANTI %lu IMMUNE %lu REFINE %lu REFINE_SET %u MAGIC_PCT %u", 
                    item_table->dwVnum,
                    item_table->szName,
                    item_table->szLocaleName,
                    item_table->alValues[0],
                    item_table->alValues[1],
                    item_table->alValues[2],
                    item_table->alValues[3],
                    item_table->alValues[4],
                    item_table->alValues[5],
                    item_table->dwWearFlags,
                    item_table->dwAntiFlags,
                    item_table->dwImmuneFlag,
                    item_table->dwRefinedVnum,
                    item_table->wRefineSet,
                    item_table->bAlterToMagicItemPct);

            m_map_itemTableByVnum.insert(std::map<DWORD, TItemTable *>::value_type(item_table->dwVnum, item_table));
        }
        sort(m_vec_itemTable.begin(), m_vec_itemTable.end(), FCompareVnum());
        return true;
    } else {
        std::ostringstream query; 
        query << "SELECT vnum, type, subtype, name, " << g_stLocaleNameColumn << ", gold, shop_buy_price, weight, size, flag, wearflag, antiflag, immuneflag+0, refined_vnum, refine_set, magic_pct, socket_pct, addon_type, limittype0, limitvalue0, limittype1, limitvalue1, applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, value0, value1, value2, value3, value4, value5, socket0, socket1, socket2 FROM item_proto ORDER BY vnum"; 
        SQLMsg* sqlMsg = CDBManager::instance().DirectQuery(query.str().c_str(), 0); 
        if (sqlMsg == nullptr) { 
            sys_err("libdb::InitializeItemTable", __LINE__, "Could not load item_proto. Query failed!"); 
            return false; 
        } 

        MYSQL_RES* pRes = sqlMsg->vec_pkResult[0]->pSQLResult; 

        if (pRes == nullptr) { 
            sys_err("libdb::InitializeItemTable", __LINE__, "Could not load item_proto. No result!"); 
            return 0; 
        } 

        if (!m_vec_itemTable.empty()) { 
            sys_log(__LINE__, " Reloading item_proto"); 
            m_vec_itemTable.clear(); 
        } 
        MYSQL_ROW row; 
        while ((row = mysql_fetch_row(pRes))) { 
            SItemTable temp = {}; 
            if (row[0]&&*row[0]) temp.dwVnum = strtoul(row[0], NULL, 10); 
            if (row[1]&&*row[1]) temp.bType = strtoul(row[1], NULL, 10); 
            if (row[2]&&*row[2]) temp.bSubType = strtoul(row[2], NULL, 10); 
            if (row[3]&&*row[3]) snprintf(temp.szName, 25, "%s", row[3]); 
            if (row[4]&&*row[4]) snprintf(temp.szLocaleName, 25, "%s", row[4]); 
            if (row[5]&&*row[5]) temp.dwGold = strtoul(row[5], NULL, 10); 
            if (row[6]&&*row[6]) temp.dwShopBuyPrice = strtoul(row[6], NULL, 10); 
            if (row[7]&&*row[7]) temp.bWeight = strtoul(row[7], NULL, 10); 
            if (row[8]&&*row[8]) temp.bSize = strtoul(row[8], NULL, 10); 
            if (row[9]&&*row[9]) temp.dwFlags = strtoul(row[9], NULL, 10); 
            if (row[10]&&*row[10]) temp.dwWearFlags = strtoul(row[10], NULL, 10); 
            if (row[11]&&*row[11]) temp.dwAntiFlags = strtoul(row[11], NULL, 10); 
            if (row[12]&&*row[12]) temp.dwImmuneFlag = strtoul(row[12], NULL, 10); 
            if (row[13]&&*row[13]) temp.dwRefinedVnum = strtoul(row[13], NULL, 10); 
            if (row[14]&&*row[14]) temp.wRefineSet = strtoul(row[14], NULL, 10); 
            if (row[15]&&*row[15]) temp.bAlterToMagicItemPct = strtoul(row[15], NULL, 10); 
            if (row[16]&&*row[16]) temp.bGainSocketPct = strtoul(row[16], NULL, 10); 
            if (row[17]&&*row[17]) temp.sAddonType = strtoul(row[17], NULL, 10); 
            if (row[18]&&*row[18]) temp.aLimits[0].bType = strtoul(row[18], NULL, 10); 
            if (row[19]&&*row[19]) temp.aLimits[0].lValue = strtoul(row[19], NULL, 10); 
            if (row[20]&&*row[20]) temp.aLimits[1].bType = strtoul(row[20], NULL, 10); 
            if (row[21]&&*row[21]) temp.aLimits[1].lValue = strtoul(row[21], NULL, 10); 
            if (row[22]&&*row[22]) temp.aApplies[0].bType = strtoul(row[22], NULL, 10); 
            if (row[23]&&*row[23]) temp.aApplies[0].lValue = strtoul(row[23], NULL, 10); 
            if (row[24]&&*row[24]) temp.aApplies[1].bType = strtoul(row[24], NULL, 10); 
            if (row[25]&&*row[25]) temp.aApplies[1].lValue = strtoul(row[25], NULL, 10); 
            if (row[26]&&*row[26]) temp.aApplies[2].bType = strtoul(row[26], NULL, 10); 
            if (row[27]&&*row[27]) temp.aApplies[2].lValue = strtoul(row[27], NULL, 10); 
            if (row[28]&&*row[28]) temp.alValues[0] = strtoul(row[28], NULL, 10); 
            if (row[29]&&*row[29]) temp.alValues[1] = strtoul(row[29], NULL, 10); 
            if (row[30]&&*row[30]) temp.alValues[2] = strtoul(row[30], NULL, 10); 
            if (row[31]&&*row[31]) temp.alValues[3] = strtoul(row[31], NULL, 10); 
            if (row[32]&&*row[32]) temp.alValues[4] = strtoul(row[32], NULL, 10); 
            if (row[33]&&*row[33]) temp.alValues[5] = strtoul(row[33], NULL, 10); 
            if (row[34]&&*row[34]) temp.dwVnumRange = strtoul(row[34], NULL, 10); 

            temp.cLimitRealTimeFirstUseIndex = -1; 
            temp.cLimitTimerBasedOnWearIndex = -1; 
            for (int i = 0; i < ITEM_LIMIT_MAX_NUM; ++i) { 
                if (LIMIT_REAL_TIME_START_FIRST_USE == temp.aLimits.bType) 
                    temp.cLimitRealTimeFirstUseIndex = (char) i; 

                if (LIMIT_TIMER_BASED_ON_WEAR == temp.aLimits.bType) 
                    temp.cLimitTimerBasedOnWearIndex = (char) i; 
            } 
            m_vec_itemTable.push_back(temp); 
        } 
        std::cout << "CClientManager::InitializeItemTable:: " << m_vec_itemTable.size() << " items loaded." << std::endl; 
        mysql_free_result(pRes); 
        m_map_itemTableByVnum.clear(); 

        auto it = m_vec_itemTable.begin(); 

        while (it != m_vec_itemTable.end()) { 
            TItemTable * item_table = &(*(it++)); 

            sys_log(1, "ITEM: #%-5lu %-24s %-24s VAL: %ld %ld %ld %ld %ld %ld WEAR %lu ANTI %lu IMMUNE %lu REFINE %lu REFINE_SET %u MAGIC_PCT %u", 
                    item_table->dwVnum, 
                    item_table->szName, 
                    item_table->szLocaleName, 
                    item_table->alValues[0], 
                    item_table->alValues[1], 
                    item_table->alValues[2], 
                    item_table->alValues[3], 
                    item_table->alValues[4], 
                    item_table->alValues[5], 
                    item_table->dwWearFlags, 
                    item_table->dwAntiFlags, 
                    item_table->dwImmuneFlag, 
                    item_table->dwRefinedVnum, 
                    item_table->wRefineSet, 
                    item_table->bAlterToMagicItemPct); 

            m_map_itemTableByVnum.insert(std::map<DWORD, TItemTable *>::value_type(item_table->dwVnum, item_table)); 
        } 
        sort(m_vec_itemTable.begin(), m_vec_itemTable.end(), FCompareVnum()); 
        return true; 
    }
}


bool CClientManager::InitializeSkillTable()
{
    char query[4096];
    snprintf(query, sizeof(query),
        "SELECT dwVnum, szName, bType, bMaxLevel, dwSplashRange, "
        "szPointOn, szPointPoly, szSPCostPoly, szDurationPoly, szDurationSPCostPoly, "
        "szCooldownPoly, szMasterBonusPoly, setFlag+0, setAffectFlag+0, "
        "szPointOn2, szPointPoly2, szDurationPoly2, setAffectFlag2+0, "
        "szPointOn3, szPointPoly3, szDurationPoly3, szGrandMasterAddSPCostPoly, "
        "bLevelStep, bLevelLimit, prerequisiteSkillVnum, prerequisiteSkillLevel, iMaxHit, szSplashAroundDamageAdjustPoly, eSkillType+0, dwTargetRange "
        "FROM skill_proto%s ORDER BY dwVnum",
        GetTablePostfix());

    std::unique_ptr<SQLMsg> pkMsg(CDBManager::instance().DirectQuery(query));
    SQLResult * pRes = pkMsg->Get();

    if (!pRes->uiNumRows)
    {
        sys_err("no result from skill_proto");
        return false;
    }

    if (!m_vec_skillTable.empty())
    {
        sys_log(0, "RELOAD: skill_proto");
        m_vec_skillTable.clear();
    }

    m_vec_skillTable.reserve(pRes->uiNumRows);

    MYSQL_ROW    data;
    int        col;

    while ((data = mysql_fetch_row(pRes->pSQLResult)))
    {
        TSkillTable t;
        memset(&t, 0, sizeof(t));

        col = 0;

        str_to_number(t.dwVnum, data[col++]);
        strlcpy(t.szName, data[col++], sizeof(t.szName));
        str_to_number(t.bType, data[col++]);
        str_to_number(t.bMaxLevel, data[col++]);
        str_to_number(t.dwSplashRange, data[col++]);

        strlcpy(t.szPointOn, data[col++], sizeof(t.szPointOn));
        strlcpy(t.szPointPoly, data[col++], sizeof(t.szPointPoly));
        strlcpy(t.szSPCostPoly, data[col++], sizeof(t.szSPCostPoly));
        strlcpy(t.szDurationPoly, data[col++], sizeof(t.szDurationPoly));
        strlcpy(t.szDurationSPCostPoly, data[col++], sizeof(t.szDurationSPCostPoly));
        strlcpy(t.szCooldownPoly, data[col++], sizeof(t.szCooldownPoly));
        strlcpy(t.szMasterBonusPoly, data[col++], sizeof(t.szMasterBonusPoly));

        str_to_number(t.dwFlag, data[col++]);
        str_to_number(t.dwAffectFlag, data[col++]);

        strlcpy(t.szPointOn2, data[col++], sizeof(t.szPointOn2));
        strlcpy(t.szPointPoly2, data[col++], sizeof(t.szPointPoly2));
        strlcpy(t.szDurationPoly2, data[col++], sizeof(t.szDurationPoly2));
        str_to_number(t.dwAffectFlag2, data[col++]);

        // ADD_GRANDMASTER_SKILL
        strlcpy(t.szPointOn3, data[col++], sizeof(t.szPointOn3));
        strlcpy(t.szPointPoly3, data[col++], sizeof(t.szPointPoly3));
        strlcpy(t.szDurationPoly3, data[col++], sizeof(t.szDurationPoly3));

        strlcpy(t.szGrandMasterAddSPCostPoly, data[col++], sizeof(t.szGrandMasterAddSPCostPoly));
        // END_OF_ADD_GRANDMASTER_SKILL

        str_to_number(t.bLevelStep, data[col++]);
        str_to_number(t.bLevelLimit, data[col++]);
        str_to_number(t.preSkillVnum, data[col++]);
        str_to_number(t.preSkillLevel, data[col++]);

        str_to_number(t.lMaxHit, data[col++]);

        strlcpy(t.szSplashAroundDamageAdjustPoly, data[col++], sizeof(t.szSplashAroundDamageAdjustPoly));

        str_to_number(t.bSkillAttrType, data[col++]);
        str_to_number(t.dwTargetRange, data[col++]);

        sys_log(0, "SKILL: #%d %s flag %u point %s affect %u cooldown %s", t.dwVnum, t.szName, t.dwFlag, t.szPointOn, t.dwAffectFlag, t.szCooldownPoly);

        m_vec_skillTable.push_back(t);
    }

    return true;
}

bool CClientManager::InitializeBanwordTable()
{
    m_vec_banwordTable.clear();

    std::unique_ptr<SQLMsg> pkMsg(CDBManager::instance().DirectQuery("SELECT word FROM banword"));

    SQLResult * pRes = pkMsg->Get();

    if (pRes->uiNumRows == 0)
        return true;

    MYSQL_ROW data;

    while ((data = mysql_fetch_row(pRes->pSQLResult)))
    {
        TBanwordTable t;

        if (data[0])
        {
            strlcpy(t.szWord, data[0], sizeof(t.szWord));
            m_vec_banwordTable.push_back(t);
        }
    }

    sys_log(0, "BANWORD: total %d", m_vec_banwordTable.size());
    return true;
}

bool CClientManager::InitializeItemAttrTable()
{
    char query[4096];
    snprintf(query, sizeof(query),
            "SELECT apply, apply+0, prob, lv1, lv2, lv3, lv4, lv5, weapon, body, wrist, foots, neck, head, shield, ear FROM item_attr%s ORDER BY apply",
            GetTablePostfix());

    std::unique_ptr<SQLMsg> pkMsg(CDBManager::instance().DirectQuery(query));
    SQLResult * pRes = pkMsg->Get();

    if (!pRes->uiNumRows)
    {
        sys_err("no result from item_attr");
        return false;
    }

    if (!m_vec_itemAttrTable.empty())
    {
        sys_log(0, "RELOAD: item_attr");
        m_vec_itemAttrTable.clear();
    }

    m_vec_itemAttrTable.reserve(pRes->uiNumRows);

    MYSQL_ROW    data;

    while ((data = mysql_fetch_row(pRes->pSQLResult)))
    {
        TItemAttrTable t;

        memset(&t, 0, sizeof(TItemAttrTable));

        int col = 0;

        strlcpy(t.szApply, data[col++], sizeof(t.szApply));
        str_to_number(t.dwApplyIndex, data[col++]);
        str_to_number(t.dwProb, data[col++]);
        str_to_number(t.lValues[0], data[col++]);
        str_to_number(t.lValues[1], data[col++]);
        str_to_number(t.lValues[2], data[col++]);
        str_to_number(t.lValues[3], data[col++]);
        str_to_number(t.lValues[4], data[col++]);
        str_to_number(t.bMaxLevelBySet[ATTRIBUTE_SET_WEAPON], data[col++]);
        str_to_number(t.bMaxLevelBySet[ATTRIBUTE_SET_BODY], data[col++]);
        str_to_number(t.bMaxLevelBySet[ATTRIBUTE_SET_WRIST], data[col++]);
        str_to_number(t.bMaxLevelBySet[ATTRIBUTE_SET_FOOTS], data[col++]);
        str_to_number(t.bMaxLevelBySet[ATTRIBUTE_SET_NECK], data[col++]);
        str_to_number(t.bMaxLevelBySet[ATTRIBUTE_SET_HEAD], data[col++]);
        str_to_number(t.bMaxLevelBySet[ATTRIBUTE_SET_SHIELD], data[col++]);
        str_to_number(t.bMaxLevelBySet[ATTRIBUTE_SET_EAR], data[col++]);

        sys_log(0, "ITEM_ATTR: %-20s %4lu { %3d %3d %3d %3d %3d } { %d %d %d %d %d %d %d }",
                t.szApply,
                t.dwProb,
                t.lValues[0],
                t.lValues[1],
                t.lValues[2],
                t.lValues[3],
                t.lValues[4],
                t.bMaxLevelBySet[ATTRIBUTE_SET_WEAPON],
                t.bMaxLevelBySet[ATTRIBUTE_SET_BODY],
                t.bMaxLevelBySet[ATTRIBUTE_SET_WRIST],
                t.bMaxLevelBySet[ATTRIBUTE_SET_FOOTS],
                t.bMaxLevelBySet[ATTRIBUTE_SET_NECK],
                t.bMaxLevelBySet[ATTRIBUTE_SET_HEAD],
                t.bMaxLevelBySet[ATTRIBUTE_SET_SHIELD],
                t.bMaxLevelBySet[ATTRIBUTE_SET_EAR]);

        m_vec_itemAttrTable.push_back(t);
    }

    return true;
}

bool CClientManager::InitializeItemRareTable()
{
    char query[4096];
    snprintf(query, sizeof(query),
            "SELECT apply, apply+0, prob, lv1, lv2, lv3, lv4, lv5, weapon, body, wrist, foots, neck, head, shield, ear FROM item_attr_rare%s ORDER BY apply",
            GetTablePostfix());

    std::unique_ptr<SQLMsg> pkMsg(CDBManager::instance().DirectQuery(query));
    SQLResult * pRes = pkMsg->Get();

    if (!pRes->uiNumRows)
    {
        sys_err("no result from item_attr_rare");
        return false;
    }

    if (!m_vec_itemRareTable.empty())
    {
        sys_log(0, "RELOAD: item_attr_rare");
        m_vec_itemRareTable.clear();
    }

    m_vec_itemRareTable.reserve(pRes->uiNumRows);

    MYSQL_ROW    data;

    while ((data = mysql_fetch_row(pRes->pSQLResult)))
    {
        TItemAttrTable t;

        memset(&t, 0, sizeof(TItemAttrTable));

        int col = 0;

        strlcpy(t.szApply, data[col++], sizeof(t.szApply));
        str_to_number(t.dwApplyIndex, data[col++]);
        str_to_number(t.dwProb, data[col++]);
        str_to_number(t.lValues[0], data[col++]);
        str_to_number(t.lValues[1], data[col++]);
        str_to_number(t.lValues[2], data[col++]);
        str_to_number(t.lValues[3], data[col++]);
        str_to_number(t.lValues[4], data[col++]);
        str_to_number(t.bMaxLevelBySet[ATTRIBUTE_SET_WEAPON], data[col++]);
        str_to_number(t.bMaxLevelBySet[ATTRIBUTE_SET_BODY], data[col++]);
        str_to_number(t.bMaxLevelBySet[ATTRIBUTE_SET_WRIST], data[col++]);
        str_to_number(t.bMaxLevelBySet[ATTRIBUTE_SET_FOOTS], data[col++]);
        str_to_number(t.bMaxLevelBySet[ATTRIBUTE_SET_NECK], data[col++]);
        str_to_number(t.bMaxLevelBySet[ATTRIBUTE_SET_HEAD], data[col++]);
        str_to_number(t.bMaxLevelBySet[ATTRIBUTE_SET_SHIELD], data[col++]);
        str_to_number(t.bMaxLevelBySet[ATTRIBUTE_SET_EAR], data[col++]);

        sys_log(0, "ITEM_RARE: %-20s %4lu { %3d %3d %3d %3d %3d } { %d %d %d %d %d %d %d }",
                t.szApply,
                t.dwProb,
                t.lValues[0],
                t.lValues[1],
                t.lValues[2],
                t.lValues[3],
                t.lValues[4],
                t.bMaxLevelBySet[ATTRIBUTE_SET_WEAPON],
                t.bMaxLevelBySet[ATTRIBUTE_SET_BODY],
                t.bMaxLevelBySet[ATTRIBUTE_SET_WRIST],
                t.bMaxLevelBySet[ATTRIBUTE_SET_FOOTS],
                t.bMaxLevelBySet[ATTRIBUTE_SET_NECK],
                t.bMaxLevelBySet[ATTRIBUTE_SET_HEAD],
                t.bMaxLevelBySet[ATTRIBUTE_SET_SHIELD],
                t.bMaxLevelBySet[ATTRIBUTE_SET_EAR]);

        m_vec_itemRareTable.push_back(t);
    }

    return true;
}

bool CClientManager::InitializeLandTable()
{
    using namespace building;

    char query[4096];

    snprintf(query, sizeof(query),
        "SELECT id, map_index, x, y, width, height, guild_id, guild_level_limit, price "
        "FROM land%s WHERE enable='YES' ORDER BY id",
        GetTablePostfix());

    std::unique_ptr<SQLMsg> pkMsg(CDBManager::instance().DirectQuery(query));
    SQLResult * pRes = pkMsg->Get();

    if (!m_vec_kLandTable.empty())
    {
        sys_log(0, "RELOAD: land");
        m_vec_kLandTable.clear();
    }

    m_vec_kLandTable.reserve(pRes->uiNumRows);

    MYSQL_ROW    data;

    if (pRes->uiNumRows > 0)
        while ((data = mysql_fetch_row(pRes->pSQLResult)))
        {
            TLand t;

            memset(&t, 0, sizeof(t));

            int col = 0;

            str_to_number(t.dwID, data[col++]);
            str_to_number(t.lMapIndex, data[col++]);
            str_to_number(t.x, data[col++]);
            str_to_number(t.y, data[col++]);
            str_to_number(t.width, data[col++]);
            str_to_number(t.height, data[col++]);
            str_to_number(t.dwGuildID, data[col++]);
            str_to_number(t.bGuildLevelLimit, data[col++]);
            str_to_number(t.dwPrice, data[col++]);

            sys_log(0, "LAND: %lu map %-4ld %7ldx%-7ld w %-4ld h %-4ld", t.dwID, t.lMapIndex, t.x, t.y, t.width, t.height);

            m_vec_kLandTable.push_back(t);
        }

    return true;
}

void parse_pair_number_string(const char * c_pszString, std::vector<std::pair<int, int> > & vec)
{
    // format: 10,1/20,3/300,50
    const char * t = c_pszString;
    const char * p = strchr(t, '/');
    std::pair<int, int> k;

    char szNum[32 + 1];
    char * comma;

    while (p)
    {
        if (isnhdigit(*t))
        {
            strlcpy(szNum, t, MIN(sizeof(szNum), (p-t)+1));

            comma = strchr(szNum, ',');

            if (comma)
            {
                *comma = '\0';
                str_to_number(k.second, comma+1);
            }
            else
                k.second = 0;

            str_to_number(k.first, szNum);
            vec.push_back(k);
        }

        t = p + 1;
        p = strchr(t, '/');
    }

    if (isnhdigit(*t))
    {
        strlcpy(szNum, t, sizeof(szNum));

        comma = strchr(const_cast<char*>(t), ',');

        if (comma)
        {
            *comma = '\0';
            str_to_number(k.second, comma+1);
        }
        else
            k.second = 0;

        str_to_number(k.first, szNum);
        vec.push_back(k);
    }
}

bool CClientManager::InitializeObjectProto()
{
    using namespace building;

    char query[4096];
    snprintf(query, sizeof(query),
            "SELECT vnum, price, materials, upgrade_vnum, upgrade_limit_time, life, reg_1, reg_2, reg_3, reg_4, npc, group_vnum, dependent_group "
            "FROM object_proto%s ORDER BY vnum",
            GetTablePostfix());

    std::unique_ptr<SQLMsg> pkMsg(CDBManager::instance().DirectQuery(query));
    SQLResult * pRes = pkMsg->Get();

    if (!m_vec_kObjectProto.empty())
    {
        sys_log(0, "RELOAD: object_proto");
        m_vec_kObjectProto.clear();
    }

    m_vec_kObjectProto.reserve(MAX(0, pRes->uiNumRows));

    MYSQL_ROW    data;

    if (pRes->uiNumRows > 0)
        while ((data = mysql_fetch_row(pRes->pSQLResult)))
        {
            TObjectProto t;

            memset(&t, 0, sizeof(t));

            int col = 0;

            str_to_number(t.dwVnum, data[col++]);
            str_to_number(t.dwPrice, data[col++]);

            std::vector<std::pair<int, int> > vec;
            parse_pair_number_string(data[col++], vec);

            for (unsigned int i = 0; i < OBJECT_MATERIAL_MAX_NUM && i < vec.size(); ++i)
            {
                std::pair<int, int> & r = vec;

                t.kMaterials.dwItemVnum = r.first;
                t.kMaterials.dwCount = r.second;
            }

            str_to_number(t.dwUpgradeVnum, data[col++]);
            str_to_number(t.dwUpgradeLimitTime, data[col++]);
            str_to_number(t.lLife, data[col++]);
            str_to_number(t.lRegion[0], data[col++]);
            str_to_number(t.lRegion[1], data[col++]);
            str_to_number(t.lRegion[2], data[col++]);
            str_to_number(t.lRegion[3], data[col++]);

            // ADD_BUILDING_NPC
            str_to_number(t.dwNPCVnum, data[col++]);
            str_to_number(t.dwGroupVnum, data[col++]);
            str_to_number(t.dwDependOnGroupVnum, data[col++]);

            t.lNPCX = 0;
            t.lNPCY = MAX(t.lRegion[1], t.lRegion[3])+300;
            // END_OF_ADD_BUILDING_NPC

            sys_log(0, "OBJ_PROTO: vnum %lu price %lu mat %lu %lu",
                    t.dwVnum, t.dwPrice, t.kMaterials[0].dwItemVnum, t.kMaterials[0].dwCount);

            m_vec_kObjectProto.push_back(t);
        }

    return true;
}

bool CClientManager::InitializeObjectTable()
{
    using namespace building;

    char query[4096];
    snprintf(query, sizeof(query), "SELECT id, land_id, vnum, map_index, x, y, x_rot, y_rot, z_rot, life FROM object%s ORDER BY id", GetTablePostfix());

    std::unique_ptr<SQLMsg> pkMsg(CDBManager::instance().DirectQuery(query));
    SQLResult * pRes = pkMsg->Get();

    if (!m_map_pkObjectTable.empty())
    {
        sys_log(0, "RELOAD: object");
        m_map_pkObjectTable.clear();
    }

    MYSQL_ROW data;

    if (pRes->uiNumRows > 0)
        while ((data = mysql_fetch_row(pRes->pSQLResult)))
        {
            TObject * k = new TObject;

            memset(k, 0, sizeof(TObject));

            int col = 0;

            str_to_number(k->dwID, data[col++]);
            str_to_number(k->dwLandID, data[col++]);
            str_to_number(k->dwVnum, data[col++]);
            str_to_number(k->lMapIndex, data[col++]);
            str_to_number(k->x, data[col++]);
            str_to_number(k->y, data[col++]);
            str_to_number(k->xRot, data[col++]);
            str_to_number(k->yRot, data[col++]);
            str_to_number(k->zRot, data[col++]);
            str_to_number(k->lLife, data[col++]);

            sys_log(0, "OBJ: %lu vnum %lu map %-4ld %7ldx%-7ld life %ld", 
                    k->dwID, k->dwVnum, k->lMapIndex, k->x, k->y, k->lLife);

            m_map_pkObjectTable.insert(std::make_pair(k->dwID, k));
        }

    return true;
}

bool CClientManager::InitializeMonarch()
{
    CMonarch::instance().LoadMonarch();

    return true;
}

bool CClientManager::MirrorMobTableIntoDB()
{
    int tmpValue = 0;
    if (!CConfig::instance().GetValue("TXT_STARTUP", &tmpValue))
        tmpValue = 0;
    if(tmpValue == 0)
        return true;

    for (itertype(m_vec_mobTable) it = m_vec_mobTable.begin(); it != m_vec_mobTable.end(); it++)
    {
        const TMobTable& t = *it;
        char query[4096];
        if (g_stLocaleNameColumn == "name")
        {
            snprintf(query, sizeof(query),
                "replace into mob_proto%s "
                "("
                "vnum, name, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, "
                "on_click, empire, drop_item, resurrection_vnum, folder, "
                "st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, "
                "gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, "

                "enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, "
                "resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, "
                "resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, "
                "dam_multiply, summon, drain_sp, "

                "skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, "
                "skill_vnum3, skill_level3, skill_vnum4, skill_level4, "
                "sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive"
                ") "
                "values ("

                "%d, \"%s\", %d, %d, %d, %d, %d, %u, %u, %u, " 
                "%d, %d, %d, %d, '%s', "
                "%d, %d, %d, %d, %d, %d, %d, %d, %d, %d, "
                "%d, %d, %d, %d, %d, %d, %d, %d, %d, "

                "%d, %d, %d, %d, %d, %d, "
                "%d, %d, %d, %d, %d, %d, "
                "%d, %d, %d, %d, %d, "
                "%f, %d, %d, "

                "%d, %d, %d, %d, %d, %d, "
                "%d, %d, %d, %d, "
                "%d, %d, %d, %d, %d"
                ")",
                GetTablePostfix(), /*g_stLocaleNameColumn.c_str(),*/

                t.dwVnum, t.szName, /*t.szLocaleName, */t.bType, t.bRank, t.bBattleType, t.bLevel, t.bSize, t.dwAIFlag, t.dwRaceFlag, t.dwImmuneFlag,
                t.bOnClickType, t.bEmpire, t.dwDropItemVnum, t.dwResurrectionVnum, t.szFolder,
                t.bStr, t.bDex, t.bCon, t.bInt, t.dwDamageRange[0], t.dwDamageRange[1], t.dwMaxHP, t.bRegenCycle, t.bRegenPercent, t.dwExp,

                t.dwGoldMin, t.dwGoldMax, t.wDef, t.sAttackSpeed, t.sMovingSpeed, t.bAggresiveHPPct, t.wAggressiveSight, t.wAttackRange, t.dwPolymorphItemVnum,
                t.cEnchants[0], t.cEnchants[1], t.cEnchants[2], t.cEnchants[3], t.cEnchants[4], t.cEnchants[5],
                t.cResists[0], t.cResists[1], t.cResists[2], t.cResists[3], t.cResists[4], t.cResists[5],
                t.cResists[6], t.cResists[7], t.cResists[8], t.cResists[9], t.cResists[10], 
                t.fDamMultiply, t.dwSummonVnum, t.dwDrainSP, 

                t.Skills[0].dwVnum, t.Skills[0].bLevel, t.Skills[1].dwVnum, t.Skills[1].bLevel, t.Skills[2].dwVnum, t.Skills[2].bLevel, 
                t.Skills[3].dwVnum, t.Skills[3].bLevel, t.Skills[4].dwVnum, t.Skills[4].bLevel, 
                t.bBerserkPoint, t.bStoneSkinPoint, t.bGodSpeedPoint, t.bDeathBlowPoint, t.bRevivePoint
                );
        }
        else
        {
            snprintf(query, sizeof(query),
                "replace into mob_proto%s "
                "("
                "vnum, name, %s, type, rank, battle_type, level, size, ai_flag, setRaceFlag, setImmuneFlag, "
                "on_click, empire, drop_item, resurrection_vnum, folder, "
                "st, dx, ht, iq, damage_min, damage_max, max_hp, regen_cycle, regen_percent, exp, "
                "gold_min, gold_max, def, attack_speed, move_speed, aggressive_hp_pct, aggressive_sight, attack_range, polymorph_item, "

                "enchant_curse, enchant_slow, enchant_poison, enchant_stun, enchant_critical, enchant_penetrate, "
                "resist_sword, resist_twohand, resist_dagger, resist_bell, resist_fan, resist_bow, "
                "resist_fire, resist_elect, resist_magic, resist_wind, resist_poison, "
                "dam_multiply, summon, drain_sp, "

                "skill_vnum0, skill_level0, skill_vnum1, skill_level1, skill_vnum2, skill_level2, "
                "skill_vnum3, skill_level3, skill_vnum4, skill_level4, "
                "sp_berserk, sp_stoneskin, sp_godspeed, sp_deathblow, sp_revive"
                ") "
                "values ("

                "%d, \"%s\", \"%s\", %d, %d, %d, %d, %d, %u, %u, %u, " 
                "%d, %d, %d, %d, '%s', "
                "%d, %d, %d, %d, %d, %d, %d, %d, %d, %d, "
                "%d, %d, %d, %d, %d, %d, %d, %d, %d, "

                "%d, %d, %d, %d, %d, %d, "
                "%d, %d, %d, %d, %d, %d, "
                "%d, %d, %d, %d, %d, "
                "%f, %d, %d, "

                "%d, %d, %d, %d, %d, %d, "
                "%d, %d, %d, %d, "
                "%d, %d, %d, %d, %d"
                ")",
                GetTablePostfix(), g_stLocaleNameColumn.c_str(),

                t.dwVnum, t.szName, t.szLocaleName, t.bType, t.bRank, t.bBattleType, t.bLevel, t.bSize, t.dwAIFlag, t.dwRaceFlag, t.dwImmuneFlag,
                t.bOnClickType, t.bEmpire, t.dwDropItemVnum, t.dwResurrectionVnum, t.szFolder,
                t.bStr, t.bDex, t.bCon, t.bInt, t.dwDamageRange[0], t.dwDamageRange[1], t.dwMaxHP, t.bRegenCycle, t.bRegenPercent, t.dwExp,

                t.dwGoldMin, t.dwGoldMax, t.wDef, t.sAttackSpeed, t.sMovingSpeed, t.bAggresiveHPPct, t.wAggressiveSight, t.wAttackRange, t.dwPolymorphItemVnum,
                t.cEnchants[0], t.cEnchants[1], t.cEnchants[2], t.cEnchants[3], t.cEnchants[4], t.cEnchants[5],
                t.cResists[0], t.cResists[1], t.cResists[2], t.cResists[3], t.cResists[4], t.cResists[5],
                t.cResists[6], t.cResists[7], t.cResists[8], t.cResists[9], t.cResists[10], 
                t.fDamMultiply, t.dwSummonVnum, t.dwDrainSP, 

                t.Skills[0].dwVnum, t.Skills[0].bLevel, t.Skills[1].dwVnum, t.Skills[1].bLevel, t.Skills[2].dwVnum, t.Skills[2].bLevel, 
                t.Skills[3].dwVnum, t.Skills[3].bLevel, t.Skills[4].dwVnum, t.Skills[4].bLevel, 
                t.bBerserkPoint, t.bStoneSkinPoint, t.bGodSpeedPoint, t.bDeathBlowPoint, t.bRevivePoint
                );
        }

        CDBManager::instance().AsyncQuery(query);
    }
    return true;
}

bool CClientManager::MirrorItemTableIntoDB()
{
    int tmpValue = 0;
    if (!CConfig::instance().GetValue("TXT_STARTUP", &tmpValue))
        tmpValue = 0;
    if(tmpValue == 0)
        return true;

    for (itertype(m_vec_itemTable) it = m_vec_itemTable.begin(); it != m_vec_itemTable.end(); it++)
    {
        if (g_stLocaleNameColumn != "name")
        {
            const TItemTable& t = *it;
            char query[4096];
            snprintf(query, sizeof(query),
                "replace into item_proto%s ("
                "vnum, type, subtype, name, %s, gold, shop_buy_price, weight, size, "
                "flag, wearflag, antiflag, immuneflag, "
                "refined_vnum, refine_set, magic_pct, socket_pct, addon_type, "
                "limittype0, limitvalue0, limittype1, limitvalue1, "
                "applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, "
                "value0, value1, value2, value3, value4, value5 ) "
                "values ("
                "%d, %d, %d, \"%s\", \"%s\", %d, %d, %d, %d, "
                "%d, %d, %d, %d, "
                "%d, %d, %d, %d, %d, "
                "%d, %ld, %d, %ld, "
                "%d, %ld, %d, %ld, %d, %ld, "
                "%ld, %ld, %ld, %ld, %ld, %ld )",
                GetTablePostfix(), g_stLocaleNameColumn.c_str(), 
                t.dwVnum, t.bType, t.bSubType, t.szName, t.szLocaleName, t.dwGold, t.dwShopBuyPrice, t.bWeight, t.bSize,
                t.dwFlags, t.dwWearFlags, t.dwAntiFlags, t.dwImmuneFlag, 
                t.dwRefinedVnum, t.wRefineSet, t.bAlterToMagicItemPct, t.bGainSocketPct, t.sAddonType,
                t.aLimits[0].bType, t.aLimits[0].lValue, t.aLimits[1].bType, t.aLimits[1].lValue,
                t.aApplies[0].bType, t.aApplies[0].lValue, t.aApplies[1].bType, t.aApplies[1].lValue, t.aApplies[2].bType, t.aApplies[2].lValue,
                t.alValues[0], t.alValues[1], t.alValues[2], t.alValues[3], t.alValues[4], t.alValues[5]);
            CDBManager::instance().AsyncQuery(query);
        }
        else
        {
            const TItemTable& t = *it;
            char query[4096];
            snprintf(query, sizeof(query),
                "replace into item_proto%s ("
                "vnum, type, subtype, name, gold, shop_buy_price, weight, size, "
                "flag, wearflag, antiflag, immuneflag, "
                "refined_vnum, refine_set, magic_pct, socket_pct, addon_type, "
                "limittype0, limitvalue0, limittype1, limitvalue1, "
                "applytype0, applyvalue0, applytype1, applyvalue1, applytype2, applyvalue2, "
                "value0, value1, value2, value3, value4, value5 ) "
                "values ("
                "%d, %d, %d, \"%s\", %d, %d, %d, %d, "
                "%d, %d, %d, %d, "
                "%d, %d, %d, %d, %d, "
                "%d, %ld, %d, %ld, "
                "%d, %ld, %d, %ld, %d, %ld, "
                "%ld, %ld, %ld, %ld, %ld, %ld )",
                GetTablePostfix(), 
                t.dwVnum, t.bType, t.bSubType, t.szName, t.dwGold, t.dwShopBuyPrice, t.bWeight, t.bSize,
                t.dwFlags, t.dwWearFlags, t.dwAntiFlags, t.dwImmuneFlag, 
                t.dwRefinedVnum, t.wRefineSet, t.bAlterToMagicItemPct, t.bGainSocketPct, t.sAddonType,
                t.aLimits[0].bType, t.aLimits[0].lValue, t.aLimits[1].bType, t.aLimits[1].lValue,
                t.aApplies[0].bType, t.aApplies[0].lValue, t.aApplies[1].bType, t.aApplies[1].lValue, t.aApplies[2].bType, t.aApplies[2].lValue,
                t.alValues[0], t.alValues[1], t.alValues[2], t.alValues[3], t.alValues[4], t.alValues[5]);
            CDBManager::instance().AsyncQuery(query);
        }
    }
    return true;
}
 

 

Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


  • Read our Rules
  • Activity

    1. 2

      Fix CursorImage 'NoneType' object is not callable.

    2. 0

      [Land of Heroes] We are looking for Game / Game Economy Designers

    3. 177

      Render Target Remastered

    4. 1

      MySQL stop when start server

    5. 0

    6. 59

      Emoji in TextLine

  • Recently Browsing

    No registered users viewing this page.

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.