Author Topic: Mysql  (Read 12507 times)

0 Members and 1 Guest are viewing this topic.

Offline JamminR

  • Ulysses Team Member
  • Hero Member
  • *****
  • Posts: 8096
  • Karma: 390
  • Sertafide Ulysses Jenius
    • Team Ulysses [ULib/ULX, other fine releases]
Re: Mysql
« Reply #15 on: April 09, 2010, 02:43:53 PM »
* JamminR considers a "why reply" ban... then realizes this isn't facepunch.
"Though a program be but three lines long, someday it will have to be maintained." -- The Tao of Programming

Offline Megiddo

  • Ulysses Team Member
  • Hero Member
  • *****
  • Posts: 6213
  • Karma: 394
  • Project Lead
Re: Mysql
« Reply #16 on: April 09, 2010, 03:55:04 PM »
You bumped a two year old thread?

It's a perk of being an admin, I can bump threads with impunity. :)
Experiencing God's grace one day at a time.

Offline Pantho

  • Newbie
  • *
  • Posts: 39
  • Karma: 2
Re: Mysql
« Reply #17 on: April 09, 2010, 05:55:19 PM »
Obviously this only works for SMF forums, but maybe it will help you. The grants is based off the group IDs assigned by the forums. This is more than my previously stated few lines of code because of the MySQL wrapper, which was grabbed from UBan (and not really entirely necessary). The only function of substance is CheckUser().

<JamminR-Edited out re-paste of code block>

Hmm I used a SMF forum already, and already set usergroups for admins in SMF.

Does this code still work? would be kinda intresting to use :)
« Last Edit: April 09, 2010, 06:37:44 PM by JamminR »

Offline JamminR

  • Ulysses Team Member
  • Hero Member
  • *****
  • Posts: 8096
  • Karma: 390
  • Sertafide Ulysses Jenius
    • Team Ulysses [ULib/ULX, other fine releases]
Re: Mysql
« Reply #18 on: April 09, 2010, 06:35:51 PM »
Pantho, both gmod and SMF have changed since we used the code.
Theoretically, yes it should still work, most likely needing some tweaking.
Requires sql plugins for gmod, and an SMF plugin for custom fields (which store a SMF user's steamid)
"Though a program be but three lines long, someday it will have to be maintained." -- The Tao of Programming

Offline Pantho

  • Newbie
  • *
  • Posts: 39
  • Karma: 2
Re: Mysql
« Reply #19 on: April 09, 2010, 07:45:01 PM »
Pantho, both gmod and SMF have changed since we used the code.
Theoretically, yes it should still work, most likely needing some tweaking.
Requires sql plugins for gmod, and an SMF plugin for custom fields (which store a SMF user's steamid)

I've already got custom tables in my SMF Database I used for my CSS versions.

I can edit the file enough to correct for changes SQL databases etc, plus I used SMF 2 RCx (I forget which). I completely suck at LUA but I will check into it tomorrow :)

Offline JamminR

  • Ulysses Team Member
  • Hero Member
  • *****
  • Posts: 8096
  • Karma: 390
  • Sertafide Ulysses Jenius
    • Team Ulysses [ULib/ULX, other fine releases]
Re: Mysql
« Reply #20 on: April 09, 2010, 09:23:23 PM »
I completely suck at LUA but I will check into it tomorrow :)

I don't know SQL, but Lua is one of the easiest scripting languages I've ever tinkered with.
I forget that the code also uses ULib queries, which have been, not just changed, overhauled.
If/As you find/get errors, post the code (minus your login info(and server info if you don't want to even share that) and the errors you get in Developers corner. Between all the geeks around here, we should be able to help.
(Geek ~= bad)
"Though a program be but three lines long, someday it will have to be maintained." -- The Tao of Programming