pastebin - collaborative debugging

pastebin is a collaborative debugging tool allowing you to share and modify code snippets while chatting on IRC, IM or a message board.

This site is developed to XHTML and CSS2 W3C standards. If you see this paragraph, your browser does not support those standards and you need to upgrade. Visit WaSP for a variety of options.

pastebin private pastebin - collaborative debugging tool What's a private pastebin?

Posted by frymaster on Thu 5th Nov 22:43
download | new post

  1. need to find:
  2. - people in the contrib group on the forum, who have steam ids filled in, who don't have at least contrib access to sourcemod, and add them
  3. - people NOT in the contrib group on the forum, who have steam ids filled in, who have ONLY contrib access to sourcemod, and remove them
  4.  
  5. custom data fields are stored in the smf_themes table (bit of a misnomer, it's the table people's theme preferences are stored in, like what they've minmised etc.)
  6. format is uid, key, value (key is steamid)
  7. simples!
  8.  
  9. group membership, not so simples.
  10. smf_members, either will be the (singular) number in the id_group field, or one of the numbers in additional_groups
  11.  
  12. find contrib group id: SELECT `id_group` FROM `smf_membergroups` WHERE `group_name` = "Contributor";
  13. show all steamids in forum: SELECT * FROM `smf_themes` WHERE `variable` = "steamid"

Submit a correction or amendment below. (click here to make a fresh posting)
After submitting an amendment, you'll be able to view the differences between the old and new posts easily.

Use syntax highlighting

To highlight particular lines, prefix each line with @@


Remember my settings