I rebuilt everything from start
for database I took it :
https://subversion.assembla.com/svn/ktrose-source/and server, I took it : KT-Rose Updated 2013 : chrome://mega/content/secure.html#!8Fs0xZRa!YPyk7RyXP5GhYHDFesoEpER6Yo48CqF-rRyQMhSd0xQ
once installed, do I start the client,
first error
:
Fri Sep 26 17:13:13 2014 - Connecting to MySQL
Fri Sep 26 17:13:13 2014 - MySQL Ping Timeout: 28740 seconds
Fri Sep 26 17:13:13 2014 - Connected to MySQL server
Fri Sep 26 17:13:13 2014 - Server started on port 29000 and is listening.
Fri Sep 26 17:15:47 2014 - User connected from 127.0.0.1
Fri Sep 26 17:15:47 2014 - User Login request received
Fri Sep 26 17:15:47 2014 - Could not execute query: Field 'lastlogin' doesn't have a default value
Fri Sep 26 17:15:47 2014 - Reconnecting to Mysql
Fri Sep 26 17:15:47 2014 - New Account created 'gm1'
Fri Sep 26 17:15:47 2014 - User disconnected
Fri Sep 26 17:16:14 2014 - User connected from 127.0.0.1
Fri Sep 26 17:16:14 2014 - User Login request received
Fri Sep 26 17:16:14 2014 - Could not execute query: Field 'lastlogin' doesn't have a default value
Fri Sep 26 17:16:14 2014 - Reconnecting to Mysql
Fri Sep 26 17:16:14 2014 - New Account created 'gm1'
Fri Sep 26 17:16:14 2014 - User disconnected
and the queries.txt:
Fri Sep 26 17:13:13 2014 - SELECT @@wait_timeout
Fri Sep 26 17:13:20 2014 - SELECT @@wait_timeout
Fri Sep 26 17:13:20 2014 - DELETE FROM channels WHERE id=1
Fri Sep 26 17:13:20 2014 - INSERT INTO channels (id,name,host,port,connected,maxconnections,owner) VALUES (1,'Server 1','127.0.0.1',29100,0,0,0)
Fri Sep 26 17:13:20 2014 - SELECT id,logo,back,name,cp,grade,slogan,news FROM list_clan
Fri Sep 26 17:13:24 2014 - SELECT @@wait_timeout
Fri Sep 26 17:13:24 2014 - SELECT exp_rate, drop_rate, zuly_rate, blue_chance, stat_chance, slot_chance, refine_chance, rare_refine, kill_on_fail, spawntype, player_damage, monster_damage, player_acc, monster_acc, pvp_acc, skill_damage, dropmultiple, attkmult, skillmult, dropdelay, basedroprate, ktpointrate, movespeedmod, maxlevel FROM list_config
Fri Sep 26 17:13:24 2014 - SELECT id,npc,ltbstring,questnpc,questltb FROM ltb
Fri Sep 26 17:13:25 2014 - SELECT * FROM new_drops
Fri Sep 26 17:13:25 2014 - SELECT id,itemtype,min,max,prob FROM list_skillbooks
Fri Sep 26 17:13:25 2014 - SELECT id, srcx, srcy, srcmap, destx, desty, destmap FROM list_telegates
Fri Sep 26 17:13:25 2014 - SELECT id,x,y,map,radius,type FROM list_respawnzones
Fri Sep 26 17:13:25 2014 - SELECT id, map, montype, min, max, respawntime, x, y, radius, spawntype, triggermontype, triggerammount, agressive, areatrigger, lim, spawnk, aip, refvar, refval FROM list_special_spawns
Fri Sep 26 17:13:25 2014 - SELECT type,map,dir,x,y,dialogid FROM list_npcs
Fri Sep 26 17:13:25 2014 - SELECT mapid,wpnum,mapx,mapy,wptype FROM list_waypoints
Fri Sep 26 17:13:25 2014 - UPDATE accounts set online=false
Fri Sep 26 17:13:25 2014 - DELETE FROM channels WHERE id=2
Fri Sep 26 17:13:25 2014 - INSERT INTO channels (id,name,host,port,connected,maxconnections,owner) VALUES (2,'Channel 1','127.0.0.1',29200,0,500,1)
Fri Sep 26 17:13:25 2014 - INSERT INTO runtime (starttime,hours) VALUES ('Fri Sep 26 17:13:25 2014 ',0)
Fri Sep 26 17:13:25 2014 - SELECT id FROM runtime
Fri Sep 26 17:15:47 2014 - SELECT id,password,accesslevel,online FROM accounts WHERE username='gm1'
Fri Sep 26 17:15:47 2014 - INSERT into accounts (username,password,accesslevel) values ('gm1','336c2a61cbcad892fbb473027da9d8ba',100)
Fri Sep 26 17:16:14 2014 - SELECT id,password,accesslevel,online FROM accounts WHERE username='gm1'
Fri Sep 26 17:16:14 2014 - INSERT into accounts (username,password,accesslevel) values ('gm1','336c2a61cbcad892fbb473027da9d8ba',100)
Fri Sep 26 17:22:50 2014 - SELECT thisrev FROM backupstorage WHERE owner=0
Fri Sep 26 17:22:50 2014 - INSERT INTO backupstorage (owner,itemid,itemtype,refine,durability,lifespan,count,stats,socketed,appraised,slot,trans_action,datestamp,thisrev) VALUES('0','0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0','0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0','0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0','0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0','0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0','0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0','0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0','0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0','0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0','0|1|2|3|4|5|6|7|8|9|10|11|12|13|14|15|16|17|18|19|20|21|22|23|24|25|26|27|28|29|30|31|32|33|34|35|36|37|38|39|40|41|42|43|44|45|46|47|48|49|50|51|52|53|54|55|56|57|58|59|60|61|62|63|64|65|66|67|68|69|70|71|72|73|74|75|76|77|78|79|80|81|82|83|84|85|86|87|88|89|90|91|92|93|94|95|96|97|98|99|100|101|102|103|104|105|106|107|108|109|110|111|112|113|114|115|116|117|118|119|120|121|122|123|124|125|126|127|128|129|130|131|132|133|134|135|136|137|138|139|140|141|142|143|144|145|146|147|148|149|150|151|152|153|154|155|156|157|158|159|160','2','Fri Sep 26 17:22:50 2014 ','1')
Fri Sep 26 17:22:50 2014 - UPDATE accounts SET online=false where id=0
and account table is empty
what should I do????