Suggestions
If you have a suggestion, please feel free to let us know here. Your feedback is always encouraged as it helps us maintain a better experience for all involved.
136 topics in this forum
-
- 0 replies
- 1042 views
-
- 6 replies
- 2976 views
-
- 3 replies
- 2054 views
-
- 3 replies
- 1360 views
-
- 4 replies
- 1539 views
-
- 2 replies
- 1346 views
-
- 3 replies
- 1410 views
-
- 41 replies
- 11808 views
-
- 1 reply
- 1072 views
-
- 4 replies
- 1737 views
-
- 0 replies
- 972 views
-
- 4 replies
- 1383 views
-
- 6 replies
- 1915 views
-
- 0 replies
- 952 views
-
- 10 replies
- 1916 views
-
- 11 replies
- 3714 views
-
- 6 replies
- 1761 views
-
- 7 replies
- 1831 views
-
- 3 replies
- 1694 views
-
- 5 replies
- 2547 views
-
- 3 replies
- 1487 views
-
- 5 replies
- 1555 views
-
- 17 replies
- 2441 views
-
- 15 replies
- 3395 views
-
- 1 reply
- 1055 views
-
Featured Topics
-
-
Latest Commits
-
Topics
-
-
Posts
-
-
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.
-
-
By mongedrogado · Posted
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
