PvP, WoE, GvG, & Battleground Releases
Sign in to follow this
Followers
0
Scripts that pertain to PvPing, WoE & GvG, & Battelgrounds.
Example: PvP ladder, PvP room, Party vs Party, WoE Controllers, Capture the Flag
28 topics in this forum
-
- 337 replies
- 75960 views
-
- 20 replies
- 13638 views
-
- 68 replies
- 36864 views
-
- 36 replies
- 13620 views
-
- 1 reply
- 4014 views
-
- 56 replies
- 16276 views
-
- 13 replies
- 6787 views
-
- 6 replies
- 4273 views
-
- 16 replies
- 5827 views
-
- 11 replies
- 3873 views
-
- 2 replies
- 2379 views
-
- 104 replies
- 23779 views
-
- 0 replies
- 1918 views
-
- 8 replies
- 2831 views
-
- 0 replies
- 1573 views
-
- 0 replies
- 1405 views
-
- 0 replies
- 1515 views
-
- 0 replies
- 1498 views
-
- 0 replies
- 1581 views
-
- 0 replies
- 1544 views
-
- 4 replies
- 4011 views
-
- 3 replies
- 3274 views
-
- 1 reply
- 3030 views
-
- 29 replies
- 8326 views
-
- 3 replies
- 2720 views
Sign in to follow this
Followers
0
Announcements
-
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
