API tools faq
paste
Advertisement
Jailout2000

Blizzard's SQL Tables

Jailout2000
Jun 12th, 2012
180
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.19 KB | None | 0 0
raw download clone embed print report
  1. Blizzard does not pay attention to the realm-name when looking up users on their clan-members table:
  2.  
  3. [8:13:10 AM] <Jailout2000> 'mi Jailout2000
  4. [8:13:10 AM] <Jailout2000@Azeroth> I am a Peon on probation in Lulz (Clan Lulz) who joined on 6/9/2012 at 7:43:23 AM.
  5. [8:13:29 AM] <Jailout2000> 'mi Jailout2000@USEast
  6. [8:13:30 AM] <Jailout2000@Azeroth> Jailout2000@USEast is currently not in a clan.
  7. [8:13:37 AM] <Jailout2000> 'mi Jailout2000@Azeroth
  8. [8:13:38 AM] <Jailout2000@Azeroth> Jailout2000@Azeroth is not in Clan Lulz.
  9. [8:13:42 AM] <Jailout2000> LOLWUT
  10.  
  11. Even more lulz, I can do cross-realm look ups across their servers. PrisonRiot was created on SEXP, but not on WAR3/W3XP. Everyone knows that WC3 and the other clients use separate user tables, here's proof:
  12.  
  13. [8:16:09 AM] <Jailout2000> 'mi PrisonRiot
  14. [8:16:09 AM] <Jailout2000@Azeroth> The user PrisonRiot could not be found on Battle.net's user table.
  15. [8:16:13 AM] <Jailout2000> 'mi PrisonRiot@USEast
  16. [8:16:13 AM] <Jailout2000@Azeroth> PrisonRiot@USEast is currently not in a clan.
  17. [8:16:18 AM] <Jailout2000> 'mi PrisonRiot@Azeroth
  18. [8:16:19 AM] <Jailout2000@Azeroth> The user PrisonRiot@Azeroth could not be found on Battle.net's user table.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!