OceanusPT

SELECT log.log.time AS "When", player.player.`name` AS Who, log.log.how AS WhatDid, log.log.what AS ItemID, log.log.vnum AS ItemVnum, player.item_proto.locale_name AS ItemName, player.item.count AS Count, player.item.Socket0, player.item.Socket1, player.item.Socket2, player.item.AttrType0, player.item.AttrValue0, player.item.AttrType1, player.item.AttrValue1, player.item.AttrType2, player.item.AttrValue2, player.item.AttrType3, player.item.AttrValue3, player.item.AttrType4, player.item.AttrValue4, player.item.AttrType5, player.item.AttrValue5, player.item.AttrType6, player.item.AttrValue6 FROM log.log INNER JOIN player.player ON log.log.who = player.player.id INNER JOIN player.item ON log.log.what = player.item.id INNER JOIN player.item_proto ON log.log.vnum = player.item_proto.vnum WHERE log.how in ("EXCHANGE_GIVE", "EXCHANGE_TAKE", "DROP", "SAFEBOX PUT", "SAFEBOX GET", "DEAD_DROP") AND player.`name` = "Xeriesey"; Hi there, i have found this query here in dev, but it's possible to change this query, so wee can see the player who have take the items?

Hi there, i'm looking for too long now for one diff to remove the limite in atribute points ( vit, int, srt and dex) i have found many diff's to change the máximo, but all of then have one limite... can any one make one with no máximo? Please. if all of we, have the same points, and the same equipa what is the fun? i wanna make my warrior wirh full str. But then i will low hp... Then its better to put some points in vit... but if i was shaman, then i wanna all on INT. Or maybe some VIt and maybe Str... do u see the point? I wanna the ppl in my server have to make the Char build, with head, and not only put the points. the game is 34083_32. please help,me! And sorry for my inglish. Free hugs for all.

dam so many trie to help xD Tks to u all.

Hi there, First of all sorry for my english! I have tried to make a new quest for some time now, but i giveup, cuz i realy dont know how to do it. The ideia is: 1º Go to any NPC and pay some yang to "register" one player (enemy). 2º Any player can do that. Pay some yang to register any other player. or the same player! 3º We can buy one item, and when we use it, it show the list of all players. Then I have pay again to kill that player ( i use the item, and have to choge what player i wanna kill, for that i have to pay). 4º If i kill that player, i take all the money (from point 1 and from point 3º) 5º if and one kill me after i make the point 4º, we lose the yang we have pay in that point. 6º The yang in point 1 and 4 will allway increse until some one win all. I hope any one help-me and i hope u understand : edit: Game34083