Jump to content

avertuss

Inactive Member
  • Posts

    480
  • Joined

  • Last visited

  • Feedback

    0%

Posts posted by avertuss

  1. 22 hours ago, Cyber36 said:

    Field for example is set to: 5 as length.

    Your number is: 100.000

     

    Increse the field length and set it's type to: "bigint".

     

    MfG

    Cyber

    Still 

    SYSERR: Jan 15 13:13:32 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'hp' at row 1 (query: UPDATE player SET job = 6, voice = 0, dir = 0, x = 1042957, y = 1701933, z = 0, map_index = 217, exit_x = 1042957, exit_y = 1701933, exit_map_index = 217, hp = -31772, mp = 6220, stamina = 1975, random_hp = 3761, random_sp = 1870, playtime = 275, level = 95, level_step = 0, st = 5, ht = 135, dx = 23, iq = 135, gold = 116091055, exp = 61502430, stat_point = 0, skill_point = 0, sub_skill_point = 36, stat_reset_count = 0, ip = '25.69.178.230', part_main = 41004, part_hair = 5003, part_acce = 0, last_play = NOW(), skill_group = 1, alignment = 0, horse_level = 21, horse_riding = 1, horse_hp = 35, horse_hp_droptime = 1484741197, horse_stamina = 120, horse_skill_point = 0, prestige = 0, skill_level = '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\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: Jan 15 13:20:33 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'hp' at row 1 (query: UPDATE player SET job = 6, voice = 0, dir = 0, x = 1044784, y = 1702911, z = 0, map_index = 217, exit_x = 1044784, exit_y = 1702911, exit_map_index = 217, hp = -31263, mp = 5994, stamina = 1975, random_hp = 3761, random_sp = 1870, playtime = 282, level = 95, level_step = 2, st = 5, ht = 135, dx = 25, iq = 135, gold = 130071483, exp = 192104334, stat_point = 0, skill_point = 0, sub_skill_point = 36, stat_reset_count = 0, ip = '25.69.178.230', part_main = 41004, part_hair = 5003, part_acce = 0, last_play = NOW(), skill_group = 1, alignment = 0, horse_level = 21, horse_riding = 1, horse_hp = 35, horse_hp_droptime = 1484741197, horse_stamina = 120, horse_skill_point = 0, prestige = 0, skill_level = '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0

    5f205ad281315a4d6ac209b8c29e939f.png

  2. Hi. I have problem. 

    SYSERR: Jan 14 13:42:48 :: ChildLoop: AsyncSQL: query failed: Data too long for column 'how' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 4, 30, 15, 2100000099, 'ADD_ATTRIBUTE_SUCCESS', '2100000109', '25.69.178.230', 71085) errno: 1406)
    SYSERR: Jan 14 13:42:49 :: ChildLoop: AsyncSQL: query failed: Data too long for column 'how' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 4, 34, 15, 2100000099, 'ADD_ATTRIBUTE_SUCCESS', '2100000109', '25.69.178.230', 71085) errno: 1406)
    SYSERR: Jan 14 13:42:49 :: ChildLoop: AsyncSQL: query failed: Data too long for column 'how' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 4, 23, 10, 2100000099, 'ADD_ATTRIBUTE_SUCCESS', '2100000109', '25.69.178.230', 71085) errno: 1406)
    SYSERR: Jan 14 13:42:50 :: ChildLoop: AsyncSQL: query failed: Data too long for column 'how' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 4, 32, 15, 2100000099, 'ADD_ATTRIBUTE_SUCCESS', '2100000109', '25.69.178.230', 71085) errno: 1406)
    SYSERR: Jan 14 13:42:51 :: ChildLoop: AsyncSQL: query failed: Data too long for column 'how' at row 1 (query: INSERT DELAYED INTO log (type, time, who, x, y, what, how, hint, ip, vnum) VALUES('ITEM', NOW(), 4, 29, 15, 2100000099, 'ADD_ATTRIBUTE_SUCCESS', '2100000109', '25.69.178.230', 71085) errno: 1406)

    and

    SYSERR: Jan 14 13:41:36 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'hp' at row 1 (query: UPDATE player SET job = 6, voice = 0, dir = 0, x = 959900, y = 269200, z = 0, map_index = 41, exit_x = 959900, exit_y = 269200, exit_map_index = 41, hp = -32763, mp = 6050, stamina = 1975, random_hp = 3761, random_sp = 1870, playtime = 258, level = 95, level_step = 0, st = 5, ht = 135, dx = 23, iq = 135, gold = 120061114, exp = 85039, stat_point = 0, skill_point = 1, sub_skill_point = 36, stat_reset_count = 0, ip = '25.69.178.230', part_main = 41004, part_hair = 5003, part_acce = 0, last_play = NOW(), skill_group = 1, alignment = 0, horse_level = 21, horse_riding = 1, horse_hp = 35, horse_hp_droptime = 1484656702, horse_stamina = 120, horse_skill_point = 0, prestige = 0, skill_level = '\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0

    How to fix it? 

  3. Just now, arves100 said:

    Do you tried without the old 2010 launcher? Launching .exe directly?

    It doesn't work 100%. I follow tutorial from pl forum 

    http://www.mpcforum.pl/topic/1581926-mo%C5%BCliwo%C5%9B%C4%87-logowania-si%C4%99-na-serwer-hamachi-sf-40k/#entry13350726

    it works but not for me, i cant compile game. So i was looking here and i found this 

    https://metin2dev.org/board/index.php?/topic/12350-kick-after-charselect/&do=findComment&comment=71270

    It works or nah? 

  4. 1 minute ago, arves100 said:

    extern int max_bytes_written;
    extern int current_bytes_written;
    extern int total_bytes_written;

    do you have this in desc.cpp? We have to fix compile issue first

    909882dcfde8429c0e2c81b0eb36ec24.png

    Yes, i have. If i don't use this 

    memcpy(p.szIP, g_szPublicIP, 16); to memcpy(p.szIP, "hamachiip", 16);

    strlcpy(p.szPublicIP, g_szPublicIP, sizeof(p.szPublicIP)); to strlcpy(p.szPublicIP, "hamachiip", sizeof(p.szPublicIP));

     

    i can compile my source. 

  5. 1 hour ago, arves100 said:

    PUBLIC_IP normaly, if you are the hoster amd you can't connect you have to edit modem iptables

    missing this on main.cpp

    int             max_bytes_written = 0;
    int             current_bytes_written = 0;
    int             total_bytes_written = 0;

    I have this 1e2f7cfe79a54d19087e86e6a9b7b36f.png

    I'm host on hamachi, my friends can login but after charselect kick. 

  6. Hi, my friend tried to join to my hamachi server but when he got kick after charselect. He use launcher v2. I tried change my source too: 

    memcpy(p.szIP, g_szPublicIP, 16); to memcpy(p.szIP, "hamachiip", 16);

    strlcpy(p.szPublicIP, g_szPublicIP, sizeof(p.szPublicIP)); to strlcpy(p.szPublicIP, "hamachiip", sizeof(p.szPublicIP));

    in desc_client but it doesn't work too. I can't compile source. Errors: 

    OBJDIR/desc.o: In function `DESC::ProcessOutput()':
    /usr/home/nonameline/Server/game/src/desc.cpp:396: undefined reference to `max_bytes_written'
    /usr/home/nonameline/Server/game/src/desc.cpp:398: undefined reference to `total_bytes_written'
    /usr/home/nonameline/Server/game/src/desc.cpp:399: undefined reference to `current_bytes_written'
    /usr/home/nonameline/Server/game/src/desc.cpp:396: undefined reference to `max_bytes_written'
    OBJDIR/event.o: In function `event_process(int)':
    /usr/home/nonameline/Server/game/src/event.cpp:135: undefined reference to `ContinueOnFatalError()'
    OBJDIR/input_db.o: In function `CInputDB::P2P(char const*)':
    /usr/home/nonameline/Server/game/src/input_db.cpp:1364: undefined reference to `main_fdw'
    OBJDIR/marriage.o: In function `marriage::TMarriage::Logout(unsigned int)':
    /usr/home/nonameline/Server/game/src/marriage.cpp:299: undefined reference to `g_bShutdown'
    /usr/home/nonameline/Server/game/src/marriage.cpp:316: undefined reference to `g_bShutdown'
    /usr/home/nonameline/Server/game/src/marriage.cpp:316: undefined reference to `g_bShutdown'

    Any ideas?

  7. Hi. I want to change bonuses from baked fish but i have a little problem. In item_proto i have

    27863 "27863" "ITEM_USE" "USE_ABILITY_UP" 1 "NONE" "ITEM_STACKABLE" "NONE" "NONE" 350 350 0 0 0 "LIMIT_NONE" 0 "LIMIT_NONE" 0 "APPLY_NONE" 0 "APPLY_NONE" 0 "APPLY_NONE" 0 71 600 3 0 0 0 0 0 0

    but this doesn't work. So i go to source and i added in  use_ability_up bonuses what i want 7e8ad9d00be6b12b2b1a2fa78e2c6811.png

    but i got error while compile

    char_item.cpp:2370: error: duplicate case value
    char_item.cpp:2362: error: previously used here
    char_item.cpp:2373: error: duplicate case value
    char_item.cpp:2371: error: previously used here

    Someone can help me? 

  8. Hi. I have problem. I added costume weapon system but now i can't equip sash or costume mount bcs:

    	if (item->GetType() == ITEM_COSTUME && item->GetSubType() >= COSTUME_WEAPON_SWORD)
        {
            LPITEM weapon = GetWear(WEAR_WEAPON);
            if (!weapon)
            {
                ChatPacket(CHAT_TYPE_INFO, LC_TEXT("You must equip weapon first"));
                return false;
            }
            if (weapon->GetSubType() + COSTUME_WEAPON_SWORD != item->GetSubType())
            {
                ChatPacket(CHAT_TYPE_INFO, LC_TEXT("You must equip costume weapon with same type of weapon"));
                return false;
            }
        }
    	

    How i can fix it? Can you help me guys? I have this error: You must equip costume weapon with same type of weapon

×
×
  • Create New...

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.