Sql Queries

yeah sum no noobs ^^!

Spirit i like ur . Sig Image.. did u get it from my source?

yes i did , what type of odc job i need to make?

i'll check some jobs i already have installed...

we have a 24h auto reseter. on the server. it happens every 11:30pm +2gmt

make some more.

currently busy now... i just realized all Mu script and webpages that have been release for the last few months have a very big vunerability..
lets just say.. anyone who knows how to hack can go into ur webpages and get any account they want. tried and test on 12 server webpages.. all worked.. some even have capabilites to bring down ur server... i suggest u protect ur webpages..
im almost done with mine.

what about the items they make?? how to trace it and delete it???

all items made via sql has 00000000 serial... it's like items sold in pedler.. they all have 00000000 serial.

so if u see exc items with 00000000 serial .. that would mean.. sql generated item.

additional info:
- hehehe.. ur question is how to i know wat on there inventory..
answer: make urself a admin/gm web panel that can take vault/inventory codes and decode it into english understandable view. example > is that beta gm panel i release weeks ago.
- lets say u wanna understand items codes.. easy.. use search in ragezone

what would i enter to make, all items in inventory gone.?
k thanks

Soul Master

select name as DW,clevel,resets,sum(strength+dexterity+vitality+e nergy+leveluppoint) as points, sum((clevel*5)+104) as sumd, sum((strength+vitality+energy+dexterity+leveluppoi nt)-(clevel*5)+101) as dif from character where ctlcode != '8' and class = '1' group by name, resets, clevel order by sum(strength+vitality+energy+dexterity+leveluppoin t) desc;

ELF

Quote:
select name as ELF,clevel,resets,sum(strength+dexterity+vitality+ energy+leveluppoint) as points, sum((clevel*5)+104) as sumd, sum((strength+vitality+energy+dexterity+leveluppoi nt)-(clevel*5)+102) as dif from character where ctlcode != '8' and class = '33' group by name, resets, clevel order by sum(strength+vitality+energy+dexterity+leveluppoin t) desc;



BK

Quote:
select name as BK,clevel,resets,sum(strength+dexterity+vitality+e nergy+leveluppoint) as points, sum((clevel*5)+103) as sumd, sum((strength+vitality+energy+dexterity+leveluppoi nt)-(clevel*5)+103) as dif from character where ctlcode != '8' and class = '17' group by name, resets, clevel order by sum(strength+vitality+energy+dexterity+leveluppoin t) desc;



MG

Quote:
select name as MG,clevel,resets,sum(strength+dexterity+vitality+e nergy+leveluppoint) as points, sum((clevel*7)+104) as sumd, sum((strength+vitality+energy+dexterity+leveluppoi nt)-(clevel*7)+104) as dif from character where ctlcode != '8' and class = '48' group by name, resets, clevel order by sum(strength+vitality+energy+dexterity+leveluppoin t) desc;


My table where it would have to appear the points, reset, etc. She appears empty. You it could help me?

See the picture.. plz.. Thx for all.

impressive, john! good job =)

Server: Msg 8115, Level 16, State 2, Line 1
Arithmetic overflow error converting expression to data type smallint.



this is what comes out when i run this


select name as DW,clevel,resets,sum(strength+dexterity+vitality+e nergy+leveluppoint) as points, sum((clevel*5)+104) as sumd, sum((strength+vitality+energy+dexterity+leveluppoi nt)-(clevel*5)+101) as dif from character where ctlcode != '8' and class = '1' group by name, resets, clevel order by sum(strength+vitality+energy+dexterity+leveluppoin t) desc;

it could move for version 1,02?

sorry my bad english

Sir, the php script for this available already sir?

Quote:

---

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%)

---

this topic rly looks so old..

So Very Nice Sql-queries thanks.