Jump to content

Script Support

Explore Questions

There are no popular questions to show right now

  1. Flags in Prontera

    Asked by Panonix,

    0 votes
    2 answers
  2. 0 votes
    1 answer
  3. 0 votes
    0 answers
  4. 0 votes
    0 answers
  5. eden group

    Asked by AirWingLK,

    0 votes
    1 answer

1958 questions in this forum

  1. 0 votes
    3 answers
  2. 0 votes
    0 answers
  3. 0 votes
    1 answer
  4. 0 votes
    3 answers
  5. Re: AnnieRuru's Battleground

    0 votes
    1 answer
  6. Waitingroom on Quest NPC

    0 votes
    1 answer
  7. [Daily Reward System]

    0 votes
    33 answers
  8. Check_NameGuild

    0 votes
    1 answer
  9. NPC

    0 votes
    4 answers
  10. enable two weapons

    0 votes
    0 answers
  11. 0 votes
    0 answers
  12. pvpmode

    0 votes
    0 answers
  13. 0 votes
    5 answers
  14. VIP query for Warper

    0 votes
    1 answer
  15. Hunting Mission error

    0 votes
    2 answers
  16. Monster Couting Game

    0 votes
    3 answers
  17. Fee on this NPC

    0 votes
    5 answers
  18. Rent NPC Shop (NST_CUSTOM)

    0 votes
    3 answers
  19. Lucky spin

    0 votes
    0 answers
  20. Gold room twice a day lock by ID

    0 votes
    0 answers
  21. NPC Help

    0 votes
    4 answers
  22. 0 votes
    6 answers
  23. 0 votes
    0 answers
  24. Error buildin_queuesize

    0 votes
    2 answers
  25. Questinfo / SetQuestInfo

    0 votes
    10 answers
  • 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.