Istny

if changing ssh,mysql passwords don't help, you have probably installed webshell, disable dangereous php command in php.ini after you can delete this shit with this [Hidden Content]

then you have to use gdb711 instead gdb in command line

after mysql_query add

500 days of freebsd 10 uptime, no problems

create file manulaly, give chmod 666 and restart mysql

add into my.cnf my.cnf file should be int /var/db/mysql by default in freebsd

you can try enable general log in mysql, maybe it will log whole wrong query and we will be able to check what's wrong

if you use enum as data type in "window" colum (item table in database), you can have window values in wrong order

add this to yours CONFIG files or block p2p ports in firewall

game is crashing because of wrong query, you pass out of range value, unsigned int can take −2 147 483 648 — +2 147 483 647 and you are passing 2 150 000 000

bug you have is identical like 4 inventory pages, CheckSpace() return wrong value

so there is a problem with php script, not mysql, you dont have to change everything, only repair fucked up part of current script

try run this script [Hidden Content] replace in mysql_conn data with your mysql server address, user and password

replace in mysqli_query($sql, $con) variables order to mysqli_query($con, $sql) and add ini_set('display_errors', 'On'); on top of the file

My bad, i'm not using mysqli from long time, you have to put mysql conection handler inside mysql_error() function like

when you run test page, data are inserted to database ? or the data are not inserted and also there is no error ?

you should check error in php script something like this if (!execute_query) echo mysql_error;

are you using 4 inventory page ? check this [Hidden Content]

and after you have to use in command line gdb711 instead gdb

install gdb711 and then paste output

paste yours makefile

Hi, it's generaly question to owners of server with big player count. What's yours experience with mysql, are you using innoDB for every table or not ? In my case i'm using innodb only for couple tables, right now i have 300k characters created with over 20kk items. The size of database is now around 30GB, everything indexed, in peak mysql usage is 10% of 1 cpu core, so there is no problem with performance for now. If I would convert everything to innodb the size of database will be over 100GB for sure, especially i have over 200kk rows of logs ^.^ So after all, is worthy to upgrade everything to innoDB or not, what's yours experience? maybe someone have here bigger database and can give us some feedback Regards

I'm using this on my server from couple months. no bugs

from this what i remember, when i was creating this sytem, when you swapped smaller item into bigger, this bigger item was invisible, after server restart you can see it again

M2 Download Center Download Here ( Internal ) So someone published item swap on epvp... Here is better version from me with background color It's possible i forget about something so give me a call You can change background color in OnRenderPickingSlot() function (PythonGridSlotWindow.cpp) SERVER SIDE: open char_item.cpp in function bool CHARACTER::MoveItem replace with this CLIENT SIDE: open PythonGridSlotWindow.cpp replace CGridSlotWindow::OnRenderPickingSlot() function with this Open PythonSlotWindow.cpp add under void CSlotWindow::SetUsableItem(BOOL bFlag) this function next add int void CSlotWindow::__Initialize() in namespace UI add under BOOL m_isUsableItem open PythonSlotWindow.h add this under void SetUsableItem(BOOL bFlag); open PythonWindowManagerModule.cpp add this under PyObject * wndMgrSetUsableItem(PyObject * poSelf, PyObject * poArgs) add this under { "SetUsableItem", wndMgrSetUsableItem, METH_VARARGS }, PYTHON: open ui.py and add this function open uiinventory.py in function def OverOutItem(self): add replace OverInItem function with this maybe someone will do better python part ^.^ ####################################################################################################### I don't remember now but this was not working perfect because of overin so i created additional function, let me know is it necessary ADDITIONAL PART: in PythonGridSlotWindow.cpp add function in PythonGridSlotWindow.h add under BOOL GetPickedSlotPointer(TSlot ** ppSlot); in PythonSlotWindow.cpp replace function OnMouseLeftButtonDown() with this under frunction GetPickedSlotPointer(TSlot ** ppSlot) add this in PythonSlotWindow.h add under GetPickedSlotPointer(TSlot ** ppSlot); this DONE