Jump to content

Scripts

Sign in to follow this  

24 topics in this forum

    • 6 replies
    • 4751 views
    • 3 replies
    • 2420 views
    • 2 replies
    • 2106 views
    • 0 replies
    • 2099 views
    • 1 reply
    • 2499 views
  1. Nydhoggur dun *Fix*

    • 1 reply
    • 2229 views
    • 0 replies
    • 2288 views
    • 0 replies
    • 2294 views
  2. 3E Jobchanger

    • 1 reply
    • 3169 views
    • 2 replies
    • 2810 views
    • 1 reply
    • 2108 views
  3. Prize Giver NPC

    • 1 reply
    • 3023 views
    • 1 reply
    • 2106 views
    • 0 replies
    • 2361 views
    • 0 replies
    • 1977 views
    • 0 replies
    • 1908 views
    • 0 replies
    • 2081 views
    • 0 replies
    • 1981 views
    • 0 replies
    • 1825 views
    • 0 replies
    • 2009 views
  4. 3ceam-Helper

    • 4 replies
    • 2899 views
  5. #wKill Not working ...

    • 0 replies
    • 1973 views
  6. 3ceam-All in One

    • 0 replies
    • 2014 views
    • 1 reply
    • 2282 views
Sign in to follow this  
  • Featured Topics

  • Latest Commits

  • Topics

  • Posts

    • Drop the info man, this is not CIA.
    • Lol some one has his contact? We were friends in the scripting community he even dedicated a happy birthday to me: https://youtu.be/0fHKyqzfdy8 I was trying to contact him for years. I hope he is well.
    • Hi, it's possible to do if you have mvp logs activated. And of course item log for any kind of card. (but I think this is not enabled by default, so you may lost all tracking from time behind).     As you can see in this table is stored any MVP killed and tells which mvp was killed and what exp, item was rewarded and which map and who. This is not useful at all because if the guy sells the card, the track is "lost", but you can ask SQL to char, bank, inventory, etc... to see where is a card, but then you leave the track of who got or where it was adquired.   What you want is, when a card is dropped get unique ID, and save who got it and where, I think this needs SRC editing and SQL modification in order to make an optimized script. But, this is the help I can give you, maybe if some one read this and wanna help further or tell a better solution is ok.   EDIT: For now you can do these to examine your DB.   SQL for inventory: SELECT t2.name_english, t3.name FROM inventory t1 INNER JOIN item_db t2 INNER JOIN `char` t3 ON t1.nameid = t2.id AND t1.char_id = t3.char_id WHERE t1.nameid IN (SELECT `id` FROM `item_db` WHERE `type` = 'Card') OR t1.card1 IN (SELECT `id` FROM `item_db` WHERE `type` = 'Card') OR t1.card2 IN (SELECT `id` FROM `item_db` WHERE `type` = 'Card') OR t1.card3 IN (SELECT `id` FROM `item_db` WHERE `type` = 'Card'); SQL for bank: Storage saves only account id SELECT t2.name_english, t1.account_id, t3.userid FROM `storage` t1 INNER JOIN item_db t2 INNER JOIN `login` t3 ON t1.nameid = t2.id AND t1.account_id = t3.account_id WHERE t1.nameid IN (SELECT `id` FROM `item_db` WHERE `type` = 'Card') OR t1.card1 IN (SELECT `id` FROM `item_db` WHERE `type` = 'Card') OR t1.card2 IN (SELECT `id` FROM `item_db` WHERE `type` = 'Card') OR t1.card3 IN (SELECT `id` FROM `item_db` WHERE `type` = 'Card'); And you can keep looking for guild storage, etc.  
    • Anyone got a new Zero Client with working patches?   Cheers
    • Tenho a vontade de jogar sozinho em um servidor PC privado, somente em meu PC mantenho intervisse colocar online, mas queria algo atualizado e com itens recentes mete para matar bichinho sozinho e curti a vida solitária e divertida que mora em minha mente haha enfim esse e meu sonho um ragnarok atualizado e que abra fácil para eu jogar solo se alguém puder fazer isso e sem gracinhas como vírus e pegadinhas, etc. estou desposto a apresentar uma pequena recompensa R$ 150 (sei que tem uma tonelada de tutorial na net de como criar um, mas não quero ter trabalho) [Receositos para recompensa] [1 ser atualizado ter itens recentes] [2 não ter bugles que atrapalhem um leigo a jogar ou invocar intens. E monstros] [3 Fácil de abri para jogar] [/\ bônus se ouvir mecânicas como em privados que se ver por aí como missão para fazer intens. NPC diferes ter como curandeiras que andam por aí a quele tem de melhorar a perícia com ar carma conforme você vai usando que era mora anos atrás {sem itens muito doidos que parece que é um mu} mine games coisas assim dobro a recompensa] (não quero jogar isso online e nem vou hospedar, nem nada odeio esse jogo online, já tive minha conta de lagrimas, só tenho sdd de andar por essas terras, nem pretendo ganhar nada com isso) >>apresente um vídeo mostrando que compre os requezitos, seja selecionado obtenha a recompensa>> [R$ 150] [bonos X2=300]
  • Download Statistics

    • Files
      462
    • Comments
      161
    • Reviews
      240

    Latest File
    By Hyroshima

    51    0

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.