Originally Posted by
john_d
While i was building Our new webby i stumbled to some new things...
1. Vault Locking Query
- pw : is the 4 digit vault code... that if u try to take something out of the vault, it wil ask u for it. only use numbers.. dont repeat number like 4444 or 1111
- youraccount : is ur mu username
2. Looking for someone Online.. but tired of making this query
- which only shows u usernames, and servername and not the actual Character name.
New version
- now this one shows... online character with username and server
3. Looking for all accounts in a IP or IP range
- now this show all accounts from an IP range in example it is 123.123.123.1 to 255
- % - is the wildcard.. u can also use ? for single characters
4. From 3.. to ban all account from an IP or IP range
- this will block all accounts from the ip range 123.123.123.1 to 255
- % look in 3
5. Some fun stuff: Let says u want to make a section in website dedicated to all those mass pkers who are online or offline... lets say the section is "People you should avoid"
Online
Offline
- Top 100 - this is stop the script from flooding you. change it to anything u want. let say Top 10 or even TOP 1000
- The online needs revision ... done in 2
6. OMG u sql got hacked.. some characters are now edit .. stats boosted. but ur too lazy to check them one by one.. here is some queries that should do the checking for u.
Soul Master
ELF
BK
MG
--- thats all for now.. i have some more.. but i you already know them all... if u have questions.. Or SQL request. just ask.
--- PHP version script on all these plus more soon. ( inventory viewer at 75% complete, character researcher at 80% complete, complete admin panel 50%, MuGlobal Php Version at 99%)
