Jump to content

Tasho

Banned
  • Posts

    358
  • Joined

  • Last visited

  • Days Won

    11
  • Feedback

    0%

Posts posted by Tasho

  1. HOSTNAME: channel1_1
    AsyncSQL: connected to localhost (reconnect 1)
    CommonSQL connected
    Setting Locale "romania" (Path: locale/romania)
    Setting DB to locale latin2
    AsyncSQL: connected to localhost (reconnect 1)
    PlayerSQL connected
    LogSQL connected
    ...
    EMPIRE_CHAT: 1
    TRADE_EFFECT: 1
    BAN_FORCE_REASON: 1
    START_GOLD: 4
    GLASS_ENABLE: 1
    TRADE_EFFECT_EXCHANGE_THRESHOLD: 600000
    BIGGER_INVENTORY: 0
    ~~~> VANILLA project rev54180 <~~~

     

    2wrlx80.jpg

     

    same here

  2. the only version who works is 5.1 but it has lost of errors ... when I try to install 5.6 .. the mysql won't start ... could someone please give me a solution

     

    this error is deleting players status: 


    SYSERR: Apr 30 19:19:00 :: 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 = 851101, y = 263856, z = 0, map_index = 43, exit_x = 851101, exit_y = 263856, exit_map_index = 43, hp = 10675, mp = 730, stamina = 1320, random_hp = 636, random_sp = 332, playtime = 28, level = 17, level_step = 3, st = 56, ht = 4, dx = 3, iq = 3, gold = 9533286, exp = 187681, stat_point = 1, skill_point = 0, sub_skill_point = 8, stat_reset_count = 0, ip = '79.118.69.36', part_main = 41123, part_hair = 5026, last_play = NOW(), skill_group = 1, alignment = 3226, horse_level = 0, horse_riding = 0, horse_hp = 0, horse_hp_droptime = 0, horse_stamina = 0, horse_skill_point = 0, skill_level = '00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
    SYSERR: Apr 30 19:19:30 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'part_main' at row 1 (query: UPDATE player SET job = 7, voice = 0, dir = 0, x = 63194, y = 167609, z = 0, map_index = 21, exit_x = 63194, exit_y = 167609, exit_map_index = 21, hp = 15064, mp = 4256, stamina = 1250, random_hp = 4264, random_sp = 1976, playtime = 198, level = 105, level_step = 0, st = 90, ht = 90, dx = 40, iq = 90, gold = 999541999, exp = 0, stat_point = 0, skill_point = 104, sub_skill_point = 46, stat_reset_count = 0, ip = '5.14.224.144', part_main = 41117, part_hair = 5005, last_play = NOW(), skill_group = 2, alignment = 405, horse_level = 31, horse_riding = 0, horse_hp = 50, horse_hp_droptime = 1399064067, horse_stamina = 200, horse_skill_point = 0, skill_level = '000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
    SYSERR: Apr 30 19:19:55 :: 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 = 936639, y = 234547, z = 0, map_index = 41, exit_x = 936639, exit_y = 234547, exit_map_index = 41, hp = 1192, mp = 570, stamina = 1320, random_hp = 432, random_sp = 219, playtime = 7, level = 12, level_step = 0, st = 39, ht = 4, dx = 3, iq = 3, gold = 2911042, exp = 704, stat_point = 0, skill_point = 11, sub_skill_point = 3, stat_reset_count = 0, ip = '93.115.40.87', part_main = 41123, part_hair = 5026, last_play = NOW(), skill_group = 1, alignment = 5777, horse_level = 11, horse_riding = 0, horse_hp = 18, horse_hp_droptime = 1399133624, horse_stamina = 30, horse_skill_point = 0, skill_level = '00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
    SYSERR: Apr 30 19:20:19 :: 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 = 886565, y = 287425, z = 0, map_index = 43, exit_x = 886565, exit_y = 287425, exit_map_index = 43, hp = 7169, mp = 980, stamina = 1320, random_hp = 1048, random_sp = 512, playtime = 96, level = 27, level_step = 0, st = 83, ht = 4, dx = 3, iq = 4, gold = 7477281, exp = 116726, stat_point = 0, skill_point = 0, sub_skill_point = 18, stat_reset_count = 0, ip = '93.115.41.103', part_main = 41123, part_hair = 5026, last_play = NOW(), skill_group = 1, alignment = 12079, horse_level = 1, horse_riding = 0, horse_hp = 3, horse_hp_droptime = 1399128099, horse_stamina = 4, horse_skill_point = 0, skill_level = '000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
    SYSERR: Apr 30 19:20:29 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'part_main' at row 1 (query: UPDATE player SET job = 2, voice = 0, dir = 0, x = 856751, y = 292175, z = 0, map_index = 43, exit_x = 856751, exit_y = 292175, exit_map_index = 43, hp = 9840, mp = 3029, stamina = 1415, random_hp = 930, random_sp = 468, playtime = 55, level = 24, level_step = 1, st = 5, ht = 3, dx = 3, iq = 74, gold = 5565253, exp = 306493, stat_point = 1, skill_point = 0, sub_skill_point = 13, stat_reset_count = 0, ip = '83.88.70.97', part_main = 41123, part_hair = 5026, last_play = NOW(), skill_group = 1, alignment = 8680, horse_level = 11, horse_riding = 0, horse_hp = 18, horse_hp_droptime = 1399131808, horse_stamina = 30, horse_skill_point = 0, skill_level = '000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
    SYSERR: Apr 30 19:20:34 :: ChildLoop: AsyncSQL: query failed: Out of range value for column 'part_main' at row 1 (query: UPDATE player SET job = 3, voice = 0, dir = 0, x = 63031, y = 166550, z = 0, map_index = 21, exit_x = 63031, exit_y = 166550, exit_map_index = 21, hp = 9032, mp = 384, stamina = 911, random_hp = 0, random_sp = 0, playtime = 36, level = 1, level_step = 0, st = 3, ht = 4, dx = 3, iq = 6, gold = 0, exp = 0, stat_point = 0, skill_point = 0, sub_skill_point = 0, stat_reset_count = 0, ip = '79.118.250.5', part_main = 41124, part_hair = 5026, last_play = NOW(), skill_group = 0, alignment = 20, horse_level = 0, horse_riding = 0, horse_hp = 0, horse_hp_droptime = 0, horse_stamina = 0, horse_skill_point = 0, skill_level = '00000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
    SYSERR: Apr 30 19:20:53 :: 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 = 962212, y = 249251, z = 0, map_index = 41, exit_x = 962212, exit_y = 249251, exit_map_index = 41, hp = 760, mp = 260, stamina = 1320, random_hp = 0, random_sp = 0, playtime = 35, level = 1, level_step = 2, st = 6, ht = 4, dx = 3, iq = 3, gold = 18615, exp = 150, stat_point = 2, skill_point = 0, sub_skill_point = 0, stat_reset_count = 0, ip = '86.125.110.12', part_main = 41123, part_hair = 5026, last_play = NOW(), skill_group = 0, alignment = 185, horse_level = 0, horse_riding = 0, horse_hp = 0, horse_hp_droptime = 0, horse_stamina = 0, horse_skill_point = 0, skill_level = '000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
    SYSERR: Apr 30 19:21:00 :: 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 = 959600, y = 269700, z = 0, map_index = 41, exit_x = 959600, exit_y = 269700, exit_map_index = 41, hp = 11261, mp = 740, stamina = 1320, random_hp = 708, random_sp = 357, playtime = 35, level = 19, level_step = 2, st = 60, ht = 4, dx = 3, iq = 3, gold = 8259895, exp = 211147, stat_point = 2, skill_point = 0, sub_skill_point = 10, stat_reset_count = 0, ip = '5.61.1.90', part_main = 41123, part_hair = 5026, last_play = NOW(), skill_group = 1, alignment = 8275, horse_level = 11, horse_riding = 0, horse_hp = 18, horse_hp_droptime = 1399131878, horse_stamina = 30, horse_skill_point = 0, skill_level = '0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
    
  3. oke... I did it like this :

     

    uicharacter :

    import ui
    import uiScriptLocale
    import app
    import net
    import dbg
    import snd
    import player
    import mouseModule
    import wndMgr
    import skill
    import playerSettingModule
    import quest
    import localeInfo
    import uiToolTip
    import constInfo
    import emotion
    import chr
    
    SHOW_ONLY_ACTIVE_SKILL = FALSE
    SHOW_LIMIT_SUPPORT_SKILL_LIST = []
    HIDE_SUPPORT_SKILL_POINT = TRUE    
    SHOW_LIMIT_SUPPORT_SKILL_LIST = [121, 122, 123, 124, 126, 127, 129, 128, 131, 137, 138, 139, 140]
    
    FACE_IMAGE_DICT = {
        playerSettingModule.RACE_WARRIOR_M    : "icon/face/warrior_m.tga",
        playerSettingModule.RACE_WARRIOR_W    : "icon/face/warrior_w.tga",
        playerSettingModule.RACE_ASSASSIN_M    : "icon/face/assassin_m.tga",
        playerSettingModule.RACE_ASSASSIN_W    : "icon/face/assassin_w.tga",
        playerSettingModule.RACE_SURA_M        : "icon/face/sura_m.tga",
        playerSettingModule.RACE_SURA_W        : "icon/face/sura_w.tga",
        playerSettingModule.RACE_SHAMAN_M    : "icon/face/shaman_m.tga",
        playerSettingModule.RACE_SHAMAN_W    : "icon/face/shaman_w.tga",
    }
    
    class CharacterWindow(ui.ScriptWindow):
    
        ACTIVE_PAGE_SLOT_COUNT = 8
        SUPPORT_PAGE_SLOT_COUNT = 12
    
        PAGE_SLOT_COUNT = 12
        PAGE_HORSE = 2
    
        SKILL_GROUP_NAME_DICT = {
            playerSettingModule.JOB_WARRIOR    : { 1 : localeInfo.SKILL_GROUP_WARRIOR_1,    2 : localeInfo.SKILL_GROUP_WARRIOR_2, },
            playerSettingModule.JOB_ASSASSIN    : { 1 : localeInfo.SKILL_GROUP_ASSASSIN_1,    2 : localeInfo.SKILL_GROUP_ASSASSIN_2, },
            playerSettingModule.JOB_SURA        : { 1 : localeInfo.SKILL_GROUP_SURA_1,        2 : localeInfo.SKILL_GROUP_SURA_2, },
            playerSettingModule.JOB_SHAMAN        : { 1 : localeInfo.SKILL_GROUP_SHAMAN_1,    2 : localeInfo.SKILL_GROUP_SHAMAN_2, },
        }
    
        STAT_DESCRIPTION =    {
            "HTH" : localeInfo.STAT_TOOLTIP_CON,
            "INT" : localeInfo.STAT_TOOLTIP_INT,
            "STR" : localeInfo.STAT_TOOLTIP_STR,
            "DEX" : localeInfo.STAT_TOOLTIP_DEX,
        }
    
    
        STAT_MINUS_DESCRIPTION = localeInfo.STAT_MINUS_DESCRIPTION
        
        def unsigned32(n):
            return n & 0xFFFFFFFFL

    and:

        def RefreshStatus(self):
            if self.isLoaded==0:
                return
        
            try:
                self.GetChild("Level_Value").SetText(str(player.GetStatus(player.LEVEL)))
                self.GetChild("Exp_Value").SetText(str(unsigned32(player.GetEXP())))
                self.GetChild("RestExp_Value").SetText(str(unsigned32(player.GetStatus(player.NEXT_EXP)) - unsigned32(player.GetStatus(player.EXP))))
                self.GetChild("HP_Value").SetText(str(player.GetStatus(player.HP)) + '/' + str(player.GetStatus(player.MAX_HP)))
                self.GetChild("SP_Value").SetText(str(player.GetStatus(player.SP)) + '/' + str(player.GetStatus(player.MAX_SP)))
                self.GetChild("STR_Value").SetText(str(player.GetStatus(player.ST)))
                self.GetChild("DEX_Value").SetText(str(player.GetStatus(player.DX)))
                self.GetChild("HTH_Value").SetText(str(player.GetStatus(player.HT)))
                self.GetChild("INT_Value").SetText(str(player.GetStatus(player.IQ)))
                self.GetChild("ATT_Value").SetText(self.__GetTotalAtkText())
                self.GetChild("DEF_Value").SetText(self.__GetTotalDefText())
                self.GetChild("MATT_Value").SetText(self.__GetTotalMagAtkText())
                self.GetChild("MDEF_Value").SetText(str(player.GetStatus(player.MAG_DEF)))
                self.GetChild("ASPD_Value").SetText(str(player.GetStatus(player.ATT_SPEED)))
                self.GetChild("MSPD_Value").SetText(str(player.GetStatus(player.MOVING_SPEED)))
                self.GetChild("CSPD_Value").SetText(str(player.GetStatus(player.CASTING_SPEED)))
                self.GetChild("ER_Value").SetText(str(player.GetStatus(player.EVADE_RATE)))

    and I get status : 999 like this:

     

    9uoy1s.jpg

     

    where is the problem?

  4. Hi, I have a strange problem ... I`ve added to shop add bonus and switch bonus ... I've edited the price from item_proto, then I rebooted the server like 5 timpes but same strange problem :

    71084    Àç°æºñ¼­    ITEM_USE    USE_CHANGE_ATTRIBUTE    1    ANTI_DROP | ANTI_SELL | ANTI_GIVE | ANTI_MYSHOP    ITEM_STACKABLE | LOG    NONE    NONE    200    200    0    0    0    LIMIT_NONE    0    LIMIT_NONE    0    APPLY_NONE    0    APPLY_NONE    0    APPLY_NONE    0    0    0    0    0    0    0    0    0    0
    71085    Àç°¡ºñ¼­    ITEM_USE    USE_ADD_ATTRIBUTE    1    ANTI_DROP | ANTI_SELL | ANTI_GIVE | ANTI_MYSHOP    ITEM_STACKABLE | LOG    NONE    NONE    300    300    0    0    0    LIMIT_NONE    0    LIMIT_NONE    0    APPLY_NONE    0    APPLY_NONE    0    APPLY_NONE    0    0    0    0    0    0    0    0    0    0

    2zxw360.jpg

     

    same with the costumes ... I've edited the thime from 1 day to 7 days but stillit wont change the time.

    41123    ???? ????    ITEM_COSTUME    COSTUME_BODY    2    ANTI_FEMALE | ANTI_DROP | ANTI_SELL | ANTI_GIVE | ANTI_STACK | ANTI_MYSHOP| ANTI_SAFEBOX    NONE    NONE    NONE    0    0    0    0    0    REAL_TIME    604800    LIMIT_NONE    0    APPLY_NONE    0    APPLY_NONE    0    APPLY_NONE    0    5    0    0    40064    0    0    0    0    0
    41124    ???? ????    ITEM_COSTUME    COSTUME_BODY    2    ANTI_MALE | ANTI_DROP | ANTI_SELL | ANTI_GIVE | ANTI_STACK | ANTI_MYSHOP| ANTI_SAFEBOX    NONE    NONE    NONE    0    0    0    0    0    REAL_TIME    604800    LIMIT_NONE    0    APPLY_NONE    0    APPLY_NONE    0    APPLY_NONE    0    5    0    0    40064    0    0    0    0    0
    

    Any ideas?

     

  5.  

    I still have a prob that I dont manage to repair ... when I whant to evolve from Black Steel plate to Pos ... or from battle to Sirius ... it just won`t work ... I have all I need in refine_proto, item_proto :

     

    item_proto:

    11299    Èæ½Åö°©+9    ITEM_ARMOR    ARMOR_BODY    2    ANTI_ASSASSIN | ANTI_SURA | ANTI_MUDANG | ANTI_SELL    ITEM_TUNABLE    WEAR_BODY    NONE    120000    0    12010    800    15    LEVEL    70    LIMIT_NONE    0    APPLY_MOV_SPEED    -6    APPLY_RESIST_MAGIC    20    APPLY_NONE    0    0    90    0    12    0    27    100    3    0

     

     

    refine_proto:

     

    INSERT INTO `refine_proto` VALUES (530, 71123, 3, 71129, 4, 0, 0, 0, 0, 0, 0, 2000000, 0, 0, 100);

     

    syserr:

     

    SYSERR: Apr 26 12:46:23 :: RefineInformation: RefineInformation NOT GET REFINE SET 530

     

    The query hasn't refine_set 530.

    11299    Èæ½Åö°©+9    ITEM_ARMOR    ARMOR_BODY    2    ANTI_ASSASSIN | ANTI_SURA | ANTI_MUDANG | ANTI_SELL    ITEM_TUNABLE    WEAR_BODY    NONE    120000    0    12010    530    15    LEVEL    70    LIMIT_NONE    0    APPLY_MOV_SPEED    -6    APPLY_RESIST_MAGIC    20    APPLY_NONE    0    0    90    0    12    0    27    100    3    0
    

     

    ok .. thanks, I did the same thing ... but I edited and other file... stupid me... thanks.

     

  6. I still have a prob that I dont manage to repair ... when I whant to evolve from Black Steel plate to Pos ... or from battle to Sirius ... it just won`t work ... I have all I need in refine_proto, item_proto :

     

    item_proto:

    11299    Èæ½Åö°©+9    ITEM_ARMOR    ARMOR_BODY    2    ANTI_ASSASSIN | ANTI_SURA | ANTI_MUDANG | ANTI_SELL    ITEM_TUNABLE    WEAR_BODY    NONE    120000    0    12010    800    15    LEVEL    70    LIMIT_NONE    0    APPLY_MOV_SPEED    -6    APPLY_RESIST_MAGIC    20    APPLY_NONE    0    0    90    0    12    0    27    100    3    0
     

     

    refine_proto:

     

    INSERT INTO `refine_proto` VALUES (530, 71123, 3, 71129, 4, 0, 0, 0, 0, 0, 0, 2000000, 0, 0, 100);

     

    syserr:

     

    SYSERR: Apr 26 12:46:23 :: RefineInformation: RefineInformation NOT GET REFINE SET 530

     

     

  7. I have the pet system in my server , and vanilla core 2.3 not working when i call a pet,please look again to the pet system

    Thx for all this Vanilla

     

    for me works just fine

     

     

    My problem is this:

     

    I set in my CONFIG :

     

    MAX_LEVEL_STATUS: 105

    MAX_LEVEL: 105

     

    And when I give myself lvl 105 negative status apear :

     

    14eav0j.jpg

  8. I fallowd this tutorial : 

     

    Install MySQL

    7. Go to the port for the MySQL server:

    cd /usr/ports/databases/mysql56-server

    make install clean


    8. Add the following line to /etc/rc.conf:

    echo 'mysql_enable="YES"' >> /etc/rc.conf


    9. And start the mysql server:

    /usr/local/etc/rc.d/mysql-server start


    10. Then set a password for the MySQL root user:

    /usr/local/bin/mysqladmin -u root password 'your-password'

     

    ...

     

    but the same result...

  9. 140126 21:31:55  mysqld ended

    140126 21:32:34  mysqld started
    140126 21:32:35  InnoDB: Started; log sequence number 0 1595695
    140126 21:32:35 [Note] /usr/local/libexec/mysqld: ready for connections.
    Version: '5.0.92'  socket: '/tmp/mysql.sock'  port: 3306  FreeBSD port: mysql-server-5.0.92
    140126 21:42:14 [Note] /usr/local/libexec/mysqld: Normal shutdown

    140126 21:42:39  InnoDB: Starting shutdown...
    140126 21:42:45  InnoDB: Shutdown completed; log sequence number 0 1595695
    140126 21:42:45 [Note] /usr/local/libexec/mysqld: Shutdown complete

    140126 21:42:47  mysqld ended

    140126 21:42:48  mysqld started
    140126 21:42:53  InnoDB: Started; log sequence number 0 1595695
    140126 21:42:54 [Note] /usr/local/libexec/mysqld: ready for connections.
    Version: '5.0.92'  socket: '/tmp/mysql.sock'  port: 3306  FreeBSD port: mysql-server-5.0.92
    140126 21:43:06 [Note] /usr/local/libexec/mysqld: Normal shutdown

    140126 21:43:08  InnoDB: Starting shutdown...
    140126 21:43:08  InnoDB: Shutdown completed; log sequence number 0 1595695
    140126 21:43:08 [Note] /usr/local/libexec/mysqld: Shutdown complete

    140126 21:43:08  mysqld ended

     

     

     

  10. top :

     

      PID USERNAME    THR PRI NICE   SIZE    RES STATE    TIME   WCPU COMMAND
      984 root          1  20    0 13096K  4612K select   0:00  0.00% sshd
     1038 root          1  20    0 15852K  5040K select   0:00  0.00% sshd
     1619 root          1  20    0 15852K  5072K select   0:00  0.00% sshd
      609 root          1  20    0  9544K  1564K select   0:00  0.00% syslogd
      987 root          1  20    0 11296K  4132K select   0:00  0.00% sendmail
     1624 root          1  20    0 10864K  2900K pause    0:00  0.00% csh
     1041 root          1  20    0  9852K  2040K ttyin    0:00  0.00% sh
      994 root          1  20    0  9584K  1668K nanslp   0:00  0.00% cron
     2032 root          1  20    0  9872K  2104K RUN      0:00  0.00% top
     1029 root          1  52    0  9544K  1524K ttyin    0:00  0.00% getty
     1030 root          1  52    0  9544K  1524K ttyin    0:00  0.00% getty
     1031 root          1  52    0  9544K  1524K ttyin    0:00  0.00% getty
     1033 root          1  52    0  9544K  1524K ttyin    0:00  0.00% getty
     1028 root          1  52    0  9544K  1524K ttyin    0:00  0.00% getty
      990 smmsp         1  20    0 11296K  4140K pause    0:00  0.00% sendmail
     1034 root          1  52    0  9544K  1524K ttyin    0:00  0.00% getty
     1035 root          1  52    0  9544K  1524K ttyin    0:00  0.00% getty
     

     

    my.cnf :

     

    #Mysql configuration
    [mysqld]
    user=root
    port=3307
    socket=/tmp/mysql.sock
    skip-locking
    key_buffer=16K
    max_allowed_packet=8M
    table_cache=4
    sort_buffer_size=64K
    read_buffer_size=256K
    read_rnd_buffer_size=256K
    net_buffer_length=2K
    thread_stack=128K
    language=/usr/local/share/mysql/romanian

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