Introductions
101 topics in this forum
-
- 0 replies
- 5865 views
-
- 0 replies
- 5597 views
-
- 9 replies
- 7471 views
-
- 4 replies
- 6216 views
-
- 19 replies
- 4811 views
-
- 2 replies
- 2300 views
-
- 3 replies
- 2019 views
-
- 1 reply
- 1333 views
-
- 1 reply
- 1386 views
-
- 5 replies
- 1561 views
-
- 2 replies
- 1621 views
-
- 6 replies
- 1851 views
-
- 8 replies
- 1862 views
-
- 0 replies
- 1072 views
-
- 5 replies
- 1498 views
-
- 2 replies
- 1383 views
-
- 9 replies
- 1800 views
-
- 4 replies
- 1434 views
-
- 4 replies
- 1439 views
-
- 3 replies
- 1558 views
-
- 2 replies
- 1307 views
-
- 5 replies
- 2084 views
-
- 3 replies
- 1447 views
-
- 5 replies
- 1588 views
-
- 6 replies
- 1243 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
