Jump to content

sader1992

Content Moderator
  • Posts

    1678
  • Joined

  • Last visited

  • Days Won

    72

Posts posted by sader1992

  1. @AnalyzeItem count item in your server


    @aitem this command allows you to check how many of the item in the server

    command @aitem2 allows you to check also who have the items

    @aitem is fast, but @aitem2 will take some time to finish

    the time depend on how big your database is!

    Keep in mind that this script work with sql , so if you got an item you will need to wait xtime(default 30 sec) to save in sql so you can see it with the command (or relogin  or any act in the server that force you data to be saved , it's all depends on your server setting and your usage)

     

    you should wait until the command is done , do not logout/talk to npc/ anything until you get the results!
    '@AnalyzeItem' return the count of the item in the server.
    '@AnalyzeItem2' return the count of the item and the lst of who have it in the server (take more time).
    USAGE:
    @AnalyzeItem <ITEM_ID>
    @AnalyzeItem2 <ITEM_ID>
    OR
    @AItem <ITEM_ID>
    @AItem2 <ITEM_ID>
    Wait until you get the results in your chat
    to add more tables (like other storages) check the array .@tables$ and .@id$
    F_GET_REAL_OWNER_NAME(<"string table">,<id>) get the name for id


    • Submitter
    • Submitted
      06/22/2020
    • Category
    • Video
    • Content Author
      sader1992

     

    • Upvote 2
    • Love 1
    • Like 1
  2. line 97

    for (.@i = 0; .@i < @inventorylist_count; ++.@i) {
    		if (@inventorylist_id[.@i] == .@refineitemid && !@inventorylist_equip[.@i] && @inventorylist_card1[.@i] == 0 && @inventorylist_refine[.@i] == 0) {
    			delitem @inventorylist_id[.@i], 1;
    		}
    	}

    this could delete more that what it need to refine an item , you see it will delete all the items , for example , you need 5 to refine and you have 10 , the 10 will be deleted

     

    also like 4 (.@safe = 10;)is not used in the script

    • Love 1
  3. 10 hours ago, JagLers said:

    How can I add New Custom Items on the Database after using your script?

    item doesn't work after adding it on either pre-re or re item_db.txt

    this mod is not to add new items(that's not in ragnarok renewal of pre-renewal) , and does not effect the ability to add new items , it's only add the (items,monsters,maps) that are in renewal and not in pre-renewal to your pre-renewal server

  4. i don't see your login request in the login-server

    if the 2nd screen shot what made after before the 1st one check if your login server receive any login request

    if not , than it's your client info file ip/port

    if there is a login request than check your packet var or what i said in the reply above

     

  5. 2 hours ago, makuexile said:

    thank you @sader1992 its fixed now.

    and lastly last question, sorry if have many request.

    how can i remove this or edit when finish the last stage or die on any stage then suddenly will give this in chat info.

    if can't remove its ok xD just ignore my last request heheh. 

     

    chatinfo.png

    sorry , this is not from the script , it's server setting not sure where , check out your setting , maybe the vip system ? you can search in the forum for the messages you are getting.

  6. 13 minutes ago, makuexile said:

    Map error fixed.

    But SQL still error

    when finish last stage then auto warp at save points then this error will shown at emulator.

    i din't change the script nor edit

    i just test it if have error before i use it to my server.

    sorry for my bad english ?

    
    [Info]: Saved guild (1 - TestGuild): members
    [Info]: [Instance] Created map '0012@ods' ('997') from map '2@ods' ('996')
    [Info]: [Instance] Created: The Other Dimension (1).
    [SQL]: DB error - Duplicate entry '150000' for key 'char_id'
    [Debug]: at script.cpp:16830 - INSERT INTO `other_dimension_instance` (`name`,`char_id`,`class`,`max_round`) VALUES ('Admin','150000','4078','40')
    [Debug]: Source (NPC):  at 2@ods (0,0)
    [Info]: [Instance] Destroyed 1.
    [Info]: Saved guild (1 - TestGuild): members

     

    please check the database , is your character id there with stage 0 ?

×
×
  • Create New...