DarkOne

Are you using source files..?

Here is another method of fixing the same problem. With this method, one can change the ip in the config files.Both of these methods take like 30 secs or so to show a connection after starting the server. So lets begin. In Config Auth,Ch's,Game99 Use CONNECTION_IP: Your Wan IP Game\config.cpp Go to line 56 and add: char g_ipfix[16] = "0"; Go to the 1169 line and add: TOKEN("connection_ip") { strlcpy(g_ipfix, value_string, sizeof(g_ipfix)); } Game \ config.h Go to line 56 and add: extern char g_ipfix[16]; Game\desc_client.cpp Go to line 149 and replace: memcpy(p.szIP, g_szPublicIp, 16); with: memcpy(p.szIP, g_ipfix, 16); Go to line 159 and replace: strlcpy (p.szPublicIP, g_szPublicip, sizeof (p.szPublicIP)); with: strlcpy(p.szPublicIP, g_ipfix, sizeof(p.szPublicIP)); Compile and your done. Just put CONNECTION_IP: Your Wan IP in your configs and your done. Credit goes to Arves100

Ok after much searching I found a work around for when a person logs into your server and they select a character and then gets returned to the selection screen. I was using a Loopback Adapter to resolve this but you had to use portmap to make it work fully. Here is a semi fix "but working" You do not have to add anything in your Config files just change this in your source and compile and no need for portmap. Credit go to rawn3cr0 for this fix In desc_client.cpp: if (!bSentBoot) { bSentBoot = true; TPacketGDBoot p; p.dwItemIDRange[0] = 0; p.dwItemIDRange[1] = 0; memcpy(p.szIP, g_szPublicIP, 16); DBPacket(HEADER_GD_BOOT, 0, &p, sizeof(p)); } } TEMP_BUFFER buf; TPacketGDSetup p; memset(&p, 0, sizeof(p)); strlcpy(p.szPublicIP, g_szPublicIP, sizeof(p.szPublicIP)); Change in: if (!bSentBoot) { bSentBoot = true; TPacketGDBoot p; p.dwItemIDRange[0] = 0; p.dwItemIDRange[1] = 0; memcpy(p.szIP, "External IP", 16); DBPacket(HEADER_GD_BOOT, 0, &p, sizeof(p)); } } TEMP_BUFFER buf; TPacketGDSetup p; memset(&p, 0, sizeof(p)); strlcpy(p.szPublicIP, "External IP", sizeof(p.szPublicIP)); Where the External IP, modified with your external IP address if (!bSentBoot) { bSentBoot = true; TPacketGDBoot p; p.dwItemIDRange[0] = 0; p.dwItemIDRange[1] = 0; memcpy(p.szIP, "109.197.24.321", 16); DBPacket(HEADER_GD_BOOT, 0, &p, sizeof(p)); } } TEMP_BUFFER buf; TPacketGDSetup p; memset(&p, 0, sizeof(p)); strlcpy(p.szPublicIP, "109.197.24.321", sizeof(p.szPublicIP));

I had the same problem as well. All the quest were working fine until I started editing the texted and recompiling them. The only way I was able to fix them was to delete the entire quest folder and copy the original one back. You could also try deleting the objects folder. Then recompile the quest to populate the object folder again.

Sorry looking at the quest someone put this in the bio quest notice(pass_percent) and it was showing the percent in chat. Every time you turned in a orc tooth, 25 when not using a elixir and 80 when using one. Thanks anyways...;-)

Everytime I turn in a item in, say orc tooth is shows a number in the chat box. Thanks for any help....

SYSERR: Nov 26 14:34:14.526586 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'part_main' at row 1 (query: UPDATE player SET job = 0, voice = 0, dir = 0, x = 395099, y = 856441, z = 0, map_index = 3, exit_x = 395099, exit_y = 856441, exit_map_index = 3, hp = 6199, mp = 871, stamina = 1605, random_hp = 1159, random_sp = 581, playtime = 133, level = 30, level_step = 0, st = 31, ht = 61, dx = 3, iq = 3, gold = 2138089, exp = 347214, stat_point = 5, skill_point = 1, sub_skill_point = -29, stat_reset_count = 0, ip = '73.216.70.1', part_main = 41350, part_hair = 1, part_acce = 5, last_play = NOW(), skill_group = 1, alignment = 2830, horse_level = 21, horse_riding = 1, horse_hp = 35, horse_hp_droptime = 1480447591, horse_stamina = 120, horse_skill_point = 0, skill_level = '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0%‘7X\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0 Can anyone help with this ..Thanks

I know a work around ...but did you fix it

I'm working with some source files and when testing them after leveling to say to 34 and log out and then log back in my level then returns to a lower lvl like 14. This has happened with multiple characters all resetting to different levels. Anyone know what is going on .....Any can help with this would be appreciated.

OK I fix the problem. Originally the boost folder was in this location /root/workspace/Extern/include/boost I copied the boost folder to /usr/include/boost and it all compile fine. Hope this helps someone.

Yes both are in /Extern/include/boost

Can anyone help with this..? I can compile Mainline just fine. But for some reason when I compile these files it gives me the error below after it compiles the game core. I am compiling in FreeBSD, Thanks linking ../game_r40250_32.... gmake[1]: Leaving directory '/root/workspace/Server/game/src' gmake -C db/src dep gmake[1]: Entering directory '/root/workspace/Server/db/src' makedepend -fDepend -I../../boost -I../../libmysql/5.x-5.1.35 -I/usr/include/c++/3.3 -I/usr/include/c++/4.2 -p.obj/ Config.cpp NetBase.cpp Peer.cpp PeerBase.cpp Main.cpp Lock.cpp DBManager.cpp Cache.cpp LoginData.cpp ClientManager.cpp ClientManagerPlayer.cpp ClientManagerLogin.cpp ClientManagerBoot.cpp ClientManagerParty.cpp ClientManagerGuild.cpp GuildManager.cpp HB.cpp PrivManager.cpp MoneyLog.cpp ItemAwardManager.cpp ClientManagerEventFlag.cpp Marriage.cpp Monarch.cpp BlockCountry.cpp ItemIDRangeManager.cpp ClientManagerHorseName.cpp version.cpp AuctionManager.cpp ProtoReader.cpp CsvReader.cpp 2> /dev/null gmake[1]: Leaving directory '/root/workspace/Server/db/src' gmake -C db/src clean gmake[1]: Entering directory '/root/workspace/Server/db/src' gmake[1]: Leaving directory '/root/workspace/Server/db/src' gmake -C db/src gmake[1]: Entering directory '/root/workspace/Server/db/src' compile Config.cpp compile NetBase.cpp In file included from NetBase.cpp:4: ClientManager.h:5:36: error: boost/unordered_map.hpp: No such file or directory ClientManager.h:6:36: error: boost/unordered_set.hpp: No such file or directory In file included from NetBase.cpp:4: ClientManager.h:35: error: 'boost' has not been declared ClientManager.h:35: error: ISO C++ forbids declaration of 'unordered_map' with no type ClientManager.h:35: error: typedef name may not be a nested-name-specifier ClientManager.h:35: error: expected ';' before '<' token ClientManager.h:36: error: 'boost' has not been declared ClientManager.h:36: error: ISO C++ forbids declaration of 'unordered_map' with no type ClientManager.h:36: error: typedef name may not be a nested-name-specifier ClientManager.h:36: error: expected ';' before '<' token ClientManager.h:37: error: 'boost' has not been declared ClientManager.h:37: error: ISO C++ forbids declaration of 'unordered_set' with no type ClientManager.h:37: error: typedef name may not be a nested-name-specifier ClientManager.h:37: error: expected ';' before '<' token ClientManager.h:38: error: 'boost' has not been declared ClientManager.h:38: error: ISO C++ forbids declaration of 'unordered_map' with no type

Here is the Auth syslog SYSERR: Sep 17 15:04:36.403466 :: pid_init: Start of pid: 802 SYSERR: Sep 17 15:04:36.403722 :: socket_bind: bind: Address already in use Sep 17 15:04:36.404913 :: AsyncSQL: closing mysql connection. Sep 17 15:04:36.405258 :: AsyncSQL: closing mysql connection. Sep 17 15:04:36.405385 :: AsyncSQL: closing mysql connection. Sep 17 15:04:36.405489 :: AsyncSQL: closing mysql connection. Sep 17 15:04:36.405635 :: AsyncSQL: closing mysql connection. Sep 17 15:05:32.641985 :: SYSTEM: new connection from [75.178.65.190] fd: 15 handshake 636485369 output input_len 0, ptr 0x29092800 Sep 17 15:05:32.881541 :: Handshake: client_time 0 server_time 825881 Sep 17 15:05:33.254104 :: AUTH_PHASE 0x29092800 Sep 17 15:05:33.367654 :: InputAuth::Login : admin(5) desc 0x29092800 Sep 17 15:05:33.367721 :: SetLoginKey 2025342103 Sep 17 15:05:33.367734 :: InputAuth::Login : key 2025342103:0x724224bc login admin Sep 17 15:05:33.407621 :: QID_AUTH_LOGIN: START 2025342103 0x29092800 Sep 17 15:05:33.407686 :: Create_Time 0 19691231 Sep 17 15:05:33.407701 :: Block Time -2 Sep 17 15:05:33.408095 :: SetRemainSecs admin 0 type 2 Sep 17 15:05:33.408121 :: SendAuthLogin admin key 1 Sep 17 15:05:33.567123 :: AuthLogin result 1 key 2025342103 Sep 17 15:05:33.727590 :: SYSTEM: closing socket. DESC #15 Sep 17 15:08:14.567688 :: SYSTEM: new connection from [75.178.65.190] fd: 15 handshake 603330735 output input_len 0, ptr 0x29092800 Sep 17 15:08:14.805359 :: Handshake: lower than zero -1 Sep 17 15:08:14.925471 :: Handshake: client_time 0 server_time 987925 Sep 17 15:08:15.293677 :: AUTH_PHASE 0x29092800 Sep 17 15:08:15.406623 :: InputAuth::Login : admin(5) desc 0x29092800 Sep 17 15:08:15.406697 :: SetLoginKey 2061346780 Sep 17 15:08:15.406708 :: InputAuth::Login : key 2061346780:0x32f9737c login admin Sep 17 15:08:15.446527 :: QID_AUTH_LOGIN: START 2061346780 0x29092800 Sep 17 15:08:15.446584 :: Create_Time 0 19691231 Sep 17 15:08:15.446592 :: Block Time -2 Sep 17 15:08:15.447114 :: SetRemainSecs admin 0 type 2 Sep 17 15:08:15.447147 :: SendAuthLogin admin key 1 Sep 17 15:08:15.567360 :: AuthLogin result 1 key 2061346780 Sep 17 15:08:15.727416 :: SYSTEM: closing socket. DESC #15

Ok I have added -I mywanip to the sh.start.sh I got "3socket_tcp_bind: tcp_socket: Can't assign requested address" after loading the server. I then went and added bind_ip in auth,game99 and all of the ch's config files. I could only add my lan ip of my freebsd I tried adding the wan ip for bind_ip: but it still gave the same "3socket_tcp_bind: tcp_socket: Can't assign requested address". When I put the LAN ip in then it loads fine with no errors. I can connect fine using the wan ip in client and everything loads fine. when someone outside connects to server they get kicked back to log in screen after selecting character. any suggestions on the problem.

Ok I have tried a few things to get this to work. Any help would be appreciated. Here are a few screen shots. The only 192.168 I can find in game is in the pic and it has 192.168.188...the other I search for is 999.999 that's the only one as well. It was already set to 999.999

I fixed the problem. I went into tables for player. Right clicked on player and selected Design Table and unchecked Not Null for money and that fixed the problem. Thanks to all that tried to help......

Also here is my syslog when creating a character. No matter what name I choose it will not accept it. Jul 11 13:36:49.768025 :: PlayerCreate accountid 1 name jacobjohn level 1 gold 0, st 6 ht 4 job 0 SYSERR: Jul 11 13:36:49.768374 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Field 'money' doesn't have a default value query: INSERT INTO player (id, account_id, name, level, st, ht, dx, iq, job, voice, dir, x, y, z, hp, mp, random_hp, random_sp, stat_point, stamina, part_base, part_main, part_hair, part_acce, gold, playtime, skill_level, quickslot) VALUES(0, 1, 'jacobjohn', 1, 6, 4, 3, 3, 0, 0, 0, 957079, 255057, 0, 760, 260, 0, 0, 0, 800, 0, 0, 0, 0, 0, 0, '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\ SYSERR: Jul 11 13:36:49.768593 :: __QUERY_PLAYER_CREATE: QUERY_ERROR: UPDATE player_index SET pid3=0 WHERE id=1 Jul 11 13:36:49.768759 :: END

Yeah I was just posting it for Wahmon....My main issues is with my first post...

Here is my syserr file SYSERR: Jul 11 03:26:16.741386 :: Process: FDWATCH: peer null in event: ident 20 SYSERR: Jul 11 03:26:18.331016 :: hupsig: SIGHUP, SIGINT, SIGTERM signal has been received. shutting down. SYSERR: Jul 11 03:26:18.364040 :: pid_deinit: End of pid SYSERR: Jul 11 03:28:30.110069 :: pid_init: Start of pid: 750 SYSERR: Jul 11 03:28:30.110669 :: Start: TABLE_POSTFIX not configured use default SYSERR: Jul 11 03:28:30.745594 :: ChildLoop: AsyncSQL: query failed: Unknown column 'resist_claw' in 'field list' (query: replace into mob_proto (vnum, name, locale_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, resist_claw, 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 (34035, "???", "???", 1, SYSERR: Jul 11 03:28:33.471393 :: DirectQuery: AsyncSQL::DirectQuery : mysql_query error: Column 'money' in field list is ambiguous query: SELECT empire, pid, name, money, windate FROM monarch a, player b where a.pid=b.id

I'm testing out some server files and it all ready had a account on it with two Characters a GM and a low lvl. When I go and try to create a new character on the existing account or on a new account with any given name. The name/names are not being accepted. I have tried many combination but it will not accept any new names for Character creation. Any suggetions to the problem would be appreciated.

Any way to make this for GM only........