.sql files

[smokiedaclown]

where do i put sql files? for example i downloaded the sql's for maken uni 29* into 30

[XxFearReaperXx]

those files are usually command scripts to load from the navicat bro
open up ur navcat right click ur database click execute batch file cchange the type to txt format find the file thru the excecute batch file in navicat click open and hit enter

[smokiedaclown]

thx...btw i was messing around with cq_item earlier trying to make full +255 w/ 2 supAmbers and now when i try to log into my account it get to the welcom to blah blah screen stop and i get a error cannont connect to server message. any idea what to do 2 fix that?

[Eurion]

Most likely you're using a MsgServer that still has all checksums in it. In the sticky's at the top of the forum, you will see a post made by forcer with details on how to remove these.

[smokiedaclown]

Originally Posted by Eurion

Most likely you're using a MsgServer that still has all checksums in it. In the sticky's at the top of the forum, you will see a post made by forcer with details on how to remove these.

ya i was but about 4hrs ago i downloaded one that had all checksums removed and trade/knight system for up 2 65kstars..tried to use it few mins ago and now i dont leave the login page and it says connection to server intterupted please login again or sumthing to that extent im soo lost now lol.

[XxFearReaperXx]

Originally Posted by smokiedaclown

ya i was but about 4hrs ago i downloaded one that had all checksums removed and trade/knight system for up 2 65kstars..tried to use it few mins ago and now i dont leave the login page and it says connection to server intterupted please login again or sumthing to that extent im soo lost now lol.

try restarting ur whole server if its working before then it should work now with a fast restart
also give the syslog folder a check in ur game server for this file
SZ_SERVER 2009-12-XX and XX would be the day it started acting up should give you some sort of error message like




09:29:21 ERROR: ¡ïASSERT(!"Error action type!")¡ï in e:\tq_digital\ħÓò\reliable\src\MsgServer\MapGroup Kernel\GameAction.cpp, 1300
09:29:21 ERROR: ¡ïASSERT(!"Error action type!")¡ï in e:\tq_digital\ħÓò\reliable\src\MsgServer\MapGroup Kernel\GameAction.cpp, 1300
09:29:21 ERROR: ¡ïASSERT(!"Error action type!")¡ï in e:\tq_digital\ħÓò\reliable\src\MsgServer\MapGroup Kernel\GameAction.cpp, 1300
09:29:21 ERROR: ¡ïASSERT(!"Error action type!")¡ï in e:\tq_digital\ħÓò\reliable\src\MsgServer\MapGroup Kernel\GameAction.cpp, 1300
09:29:21 ERROR: ¡ïASSERT(!"Error action type!")¡ï in e:\tq_digital\ħÓò\reliable\src\MsgServer\MapGroup Kernel\GameAction.cpp, 1300
09:29:21 ERROR: ¡ïASSERT(!"Error action type!")¡ï in e:\tq_digital\ħÓò\reliable\src\MsgServer\MapGroup Kernel\GameAction.cpp, 1300
09:29:21 ERROR: ¡ïASSERT(!"Error action type!")¡ï in e:\tq_digital\ħÓò\reliable\src\MsgServer\MapGroup Kernel\GameAction.cpp, 1300
09:29:21 ERROR: ¡ïASSERT(!"Error action type!")¡ï in e:\tq_digital\ħÓò\reliable\src\MsgServer\MapGroup Kernel\GameAction.cpp, 1300
09:29:21 ERROR: ¡ïASSERT(!"Error action type!")¡ï in e:\tq_digital\ħÓò\reliable\src\MsgServer\MapGroup Kernel\GameAction.cpp, 1300
09:29:21 ERROR: ¡ïASSERT(!"Error action type!")¡ï in e:\tq_digital\ħÓò\reliable\src\MsgServer\MapGroup Kernel\GameAction.cpp, 1300
09:29:21 ERROR: ¡ïASSERT(!"Error action type!")¡ï in e:\tq_digital\ħÓò\reliable\src\MsgServer\MapGroup Kernel\GameAction.cpp, 1300
09:29:21 ERROR: ¡ïASSERT(!"Error action type!")¡ï in e:\tq_digital\ħÓò\reliable\src\MsgServer\MapGroup Kernel\GameAction.cpp, 1300
09:29:21 ERROR: ¡ïASSERT(!"Error action type!")¡ï in e:\tq_digital\ħÓò\reliable\src\MsgServer\MapGroup Kernel\GameAction.cpp, 1300
09:29:21 ERROR: ¡ïASSERT(!"Error action type!")¡ï in e:\tq_digital\ħÓò\reliable\src\MsgServer\MapGroup Kernel\GameAction.cpp, 1300
09:29:21 ERROR: ¡ïASSERT(!"Error action type!")¡ï in e:\tq_digital\ħÓò\reliable\src\MsgServer\MapGroup Kernel\GameAction.cpp, 1300
09:29:21 ERROR: ¡ïASSERT(!"Error action type!")¡ï in e:\tq_digital\ħÓò\reliable\src\MsgServer\MapGroup Kernel\GameAction.cpp, 1300
09:29:21 ERROR: ¡ïASSERT(!"Error action type!")¡ï in e:\tq_digital\ħÓò\reliable\src\MsgServer\MapGroup Kernel\GameAction.cpp, 1300
09:29:21 ERROR: ¡ïASSERT(!"Error action type!")¡ï in e:\tq_digital\ħÓò\reliable\src\MsgServer\MapGroup Kernel\GameAction.cpp, 1300
09:29:21 ERROR: ¡ïASSERT(!"Error action type!")¡ï in e:\tq_digital\ħÓò\reliable\src\MsgServer\MapGroup Kernel\GameAction.cpp, 1300
09:29:22 ERROR: ¡ïASSERT(!"Error action type!")¡ï in e:\tq_digital\ħÓò\reliable\src\MsgServer\MapGroup Kernel\GameAction.cpp, 1300
09:29:22 ERROR: ¡ïASSERT(!"Error action type!")¡ï in e:\tq_digital\ħÓò\reliable\src\MsgServer\MapGroup Kernel\GameAction.cpp, 1300
09:29:22 ERROR: ¡ïASSERT(!"Error action type!")¡ï in e:\tq_digital\ħÓò\reliable\src\MsgServer\MapGroup Kernel\GameAction.cpp, 1300
09:29:22 ERROR: ¡ïASSERT(!"Error action type!")¡ï in e:\tq_digital\ħÓò\reliable\src\MsgServer\MapGroup Kernel\GameAction.cpp, 1300
09:29:22 ERROR: ¡ïASSERT(!"Error action type!")¡ï in e:\tq_digital\ħÓò\reliable\src\MsgServer\MapGroup Kernel\GameAction.cpp, 1300
09:29:26 Message:
-----------------------------------------------
start server: 2009-12-14 09:24:26

current: 2009-12-14 09:29:21



socket thread: 0(max:0)

world thread: 0(max:0)

map group 0 thread: 1(max:32)[20001]

map group 1 thread: 0(max:0)

map group 2 thread: 0(max:0)

map group 3 thread: 0(max:0)

map group 4 thread: 0(max:0)

debug [0][0][0][0][0]

OnTimer [280] Database [ 0]

-----------------------------
players: 0(max:1)

login: 0/5min, logout: 1/5min



socket bytes: 76/s (pps: 0)

npc socket bytes: 3739/s (pps: 36)

-----------------------------------------------

09:29:30 ERROR: ¡ïCHECKF(x < w && y < h)¡ï in e:\tq_digital\ħÓò\reliable\src\MsgServer\MapGroup Kernel\GameMap.cpp, 2035
09:30:03 Message: SHELL: NPC server broken connect!




this is just a test error that i caused in my game server to show you what the end file would be
its best to go ahead delete the file restart ur game server and give it a test then chekc that file
its alot easier to read that way

[smokiedaclown]

i just tried logging in again(i only have the server up when im going to play on it) and at the Welcome to Eudemons.... part yet again says Error:Connection to the server interrupted. Please log in again. i uploaded the SZ_Server log

[XxFearReaperXx]

seems to me that its ur config files that are getting screwed up. it wont connect to ur account server any more try setting all the IP's to Local Host and make sure that would be 127.0.0.1 and make sure you have the same name for the server in all ur files
from the looks of it ur using test
simple fix
also check ur OEM to make sure u have the same name in the OEM as you do in the config files for ur server cuz that will cause you to not be able to log in also

[smokiedaclown]

thx ill check it out in a bit and let u know...ya im useing test.the mannequin db+client



ok as far as i can tell everything is right except in the config_auto file which i have no clue what it is for lol

[XxFearReaperXx]

Originally Posted by smokiedaclown

thx ill check it out in a bit and let u know...ya im useing test.the mannequin db+client



ok as far as i can tell everything is right except in the config_auto file which i have no clue what it is for lol

ok i know what ur using now lol thats one of the buggiest databases i've ever seen lolz i'd rather start with the old phdev database and work my way up then use that xD
but if you want a nice one to work with less buggy use CaNdY's new DB works perfectly i fixed all the smaller bugs and released it as a server with alot of edits of my own but
Cyber went ahead and Released it for me i'll check the links for it not sure if the links are still up to date


*update*
the 3 part Client does not work i had to delete that for other reasons

[smokiedaclown]

so dl the megaupload client?

also will i need to add anything to it? like the uni29* to30* for example. and what mods are made 2 it? if you dont mind listing them or a link to what is in it.

[smokiedaclown]

ok i downloaded it but ran into few poblems.. first accserv would crash after kernal int ok and i did something which fixed that but then msg server wouldnt connect with accserv and now navicate wont connect with or without pass lol...i uninstalled it and mysql and are downloading new versions of both for a fresh start and gonna try that