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........