StealthBot.net: Clan Rank Script (crs) - StealthBot.net

Jump to content

  • (9 Pages)
  • +
  • « First
  • 7
  • 8
  • 9
  • You cannot start a new topic
  • You cannot reply to this topic

Clan Rank Script (crs)

#201 User is offline   DaveTheBat Icon

  • Leader of VFR
  • PipPipPip
  • Group: Members
  • Posts: 152
  • Joined: September-28 09

Posted September 17, 2010 - 06:35 PM

A question.
What's the equiliant to MS Access in OpenOffice? It's Calc right?

And in that case what language should I use to open it?
Since as soon as I try and open it it's just a bunch of random letter and I cant see what rank people got, just their names and stuff.

What I want is to see the list of Member name and their rank.
ClanVFRBot: Posted Image

#202 User is offline   The-Black-Ninja Icon

  • The Sex
  • PipPipPipPipPipPipPip
  • Group: Members
  • Posts: 2,526
  • Joined: August-01 09

Posted September 17, 2010 - 07:39 PM

Replace your GetDBMembers function with this:
Private Function GetDBMembers(sType)  '// Returns either a number of members in the db or a list of names

   Select Case sType
      Case 0  '// Integers only
         Set rs = crsConn.Execute("SELECT COUNT(*) FROM `members`")
         GetDBMembers = rs.Fields(0)
      Case 1  '// Member names
         Set rs = crsConn.Execute("SELECT COUNT(*) FROM `members`")
         If NOT (rs.EOF OR rs.BOF) Then
            Set rs = crsConn.Execute("SELECT `name`, `rank` FROM `members`")
            Do Until rs.EOF
               text = text & rs.Fields(0) & " (" & rs.Fields(1) & "), "
               rs.MoveNext
            Loop
            GetDBMembers = Left(text, Len(text) -2)
         Else
            GetDBMembers = "Database is empty."
         End If
   End Select
End Function
Then, within your bot, type: /crsadmin members

Quote

[03:40:04 PM] Members in the CRS database (5): The-Test-Ninja (1), test (6), test1 (6), test2 (13), test4 (6)


#203 User is offline   DaveTheBat Icon

  • Leader of VFR
  • PipPipPip
  • Group: Members
  • Posts: 152
  • Joined: September-28 09

Posted September 17, 2010 - 08:16 PM

Awesome thanks a lot TBN! :)
ClanVFRBot: Posted Image

#204 User is offline   Dragon_Legion Icon

  • Full Member
  • PipPipPip
  • Group: Members
  • Posts: 423
  • Joined: October-08 09

Posted September 17, 2010 - 08:39 PM

no Calc is the Excell equivalent

You want Base I think

#205 User is offline   Grimdayz Icon

  • Newbie
  • Pip
  • Group: Members
  • Posts: 2
  • Joined: September-30 10

Posted September 30, 2010 - 09:58 PM

I keep getting this error.. whats up? I also didnt find either of the folders to remove after dling the newest version of SB, is this how it is now?

[03:54:23 PM] Scripting parsing error '1025' in crsClanRankScript.txt: (line 1; column 23)
[03:54:23 PM] Expected end of statement
[03:54:23 PM] Offending line: >> Script("Name") = "crs" Script("Author") = "The-Black-Ninja", original author:


Is it just in the wrong place?? I used the "Save as" method to save it, since explore wont let me DL it.

Ideas??

This post has been edited by Grimdayz: September 30, 2010 - 10:00 PM


#206 User is offline   The-Black-Ninja Icon

  • The Sex
  • PipPipPipPipPipPipPip
  • Group: Members
  • Posts: 2,526
  • Joined: August-01 09

Posted September 30, 2010 - 10:18 PM

http://tbninja.pastebin.com/iP3yYu4Y

Go there and click the "Raw" link in the upper right corner. Copy all the code and paste it into notepad. Save it to your scripts folder as a txt and it should work fine.

Please let me know when you've done this.

#207 User is offline   Klank Icon

  • Newbie
  • Pip
  • Group: Members
  • Posts: 2
  • Joined: June-02 10

Posted October 12, 2010 - 11:05 PM

Had a long error, but fixed, thanks anyways.

This post has been edited by Klank: October 12, 2010 - 11:09 PM


#208 User is offline   Quillathe Icon

  • Newbie
  • Pip
  • Group: Members
  • Posts: 4
  • Joined: October-12 10

Posted November 05, 2010 - 07:28 PM

Problem with massrank
when i type /crsAdmin massrank probation or shaman + rank work fine

Quote

[08:01:09 PM] <QuBot Shaman LunaticAsylum has joined the channel.>
[08:01:22 PM] shaman
[08:01:22 PM] "xyriel" has been given rank 10.
[08:01:22 PM] "QuStealth" has been given rank 10.
[08:01:22 PM] " Xyriel " has been added as a new member with the rank of 2 - Speaker
[08:01:22 PM] " LunaticAsylum " has had their rank changed to rank 2 - Speaker
[08:01:22 PM] " QuStealth " has been added as a new member with the rank of 2 - Speaker
[08:02:06 PM] Sorry, but no related documentation could be found.
[08:02:11 PM] [crsAdmin]: CRS commands that are available to the bot console only. (Syntax: /crsAdmin <override/members/massrank/closedb/opendb>). Requires rank 100 or one of the following flags: M.
[08:02:16 PM] That is not a valid command. Type /help or /? for more info.
[08:02:26 PM] Sorry, but no related documentation could be found.
[08:03:34 PM] probation
[08:03:35 PM] "kousaka" has been given rank 10.
[08:03:35 PM] "Dr.Crabfish" has been given rank 10.
[08:03:35 PM] " kousaka " has been added as a new member with the rank of 3 - Silencer
[08:03:35 PM] " Dr.Crabfish " has been added as a new member with the rank of 3 - Silencer


but when i type:
/crsAdmin massrank peon +rank - display only green title peon and nothing more

Quote

[08:03:56 PM] peon


/crsAdmin massrank grunt +rank - my bot got crash

#209 User is offline   spine Icon

  • Newbie
  • Pip
  • Group: Members
  • Posts: 2
  • Joined: February-27 11

Posted February 27, 2011 - 11:15 PM

idk if this topic is stil open but i added a bunch of my own ranks and it come out to be 27 here is what it looks like
umRanks = 27 '// Highest number of ranks. Change this value after adding or removing ranks.

   '// =========================================================================================================

   ReDim crsRanks(numRanks + 1): crsRanks(0) = "Unranked" '// Do not modify this line
   ReDim crsRankAccess(numRanks + 1): crsRankAccess(0) = "Unranked" '// Do not modify this line

   '// <<<< RANK LIST -- YOUR RANKS SHOULD BE LISTED ** BELOW ** HERE >>>>

   crsRanks(1) = "Founder"                               : crsRankAccess(1) = 200
   crsRanks(2) = "Commander"                             : crsRankAccess(2) = 80
   crsRanks(3) = "Co-Commander"                          : crsRankAccess(3) = 80
   crsRanks(4) = "General"                               : crsRankAccess(4) = 80
   crsRanks(5) = "Lt.General"                            : crsRankAccess(5) = 80
   crsRanks(6) = "Major General"                         : crsRankAccess(6) = 80
   crsRanks(7) = "Brigadier General"                     : crsRankAccess(7) = 80
   crsRanks(8) = "Colonel"                               : crsRankAccess(8) = 80
   crsRanks(9) = "Lt. Colonel"                           : crsRankAccess(9) = 80
   crsRanks(10) = "Major"                                : crsRankAccess(10) = 80
   crsRanks(11) = "Captain"                              : crsRankAccess(11) = 80
   crsRanks(12) = "1st Lieutenant"                       : crsRankAccess(12) = 80
   crsRanks(13) = "2nd Lieutenant"                       : crsRankAccess(13) = 80
   crsRanks(14) = "Chief Warrant Officer 5"              : crsRankAccess(14) = 80
   crsRanks(15) = "Chief Warrant Officer 4"              : crsRankAccess(15) = 80
   crsRanks(16) = "Chief Warrant Officer 3"              : crsRankAccess(16) = 80
   crsRanks(17) = "Chief Warrant Officer 2"              : crsRankAccess(18) = 80
   crsRanks(18) = "Chief Warrant Officer 1"              : crsRankAccess(19) = 80
   crsRanks(19) = "Sergeant Major"                       : crsRankAccess(20) = 80
   crsRanks(20) = "1st Sergeant"                         : crsRankAccess(21) = 80
   crsRanks(21) = "Master Sergeant"                      : crsRankAccess(22) = 80
   crsRanks(22) = "Gunnery Sergeant"                     : crsRankAccess(23) = 80
   crsRanks(23) = "Staff Sergeant"                       : crsRankAccess(24) = 80
   crsRanks(24) = "Sergeant"                             : crsRankAccess(25) = 80
   crsRanks(25) = "Corporal"                             : crsRankAccess(26) = 80
   crsRanks(26) = "Private First Class"                  : crsRankAccess(27) = 80
   crsRanks(27) = "Private"                              : crsRankAccess(28) = 80
   '// <<<< YOUR RANKS SHOULD BE LISTED ** ABOVE ** HERE >>>>


But everytime i open bot now i get this error:
[06:07:36 PM] Scripting parsing error '1014' in crsClanRankScript.txt: (line 1; column 0)
[06:07:36 PM] Expected 'End'
[06:07:36 PM] Offending line: >>
any help?

#210 User is offline   The-Black-Ninja Icon

  • The Sex
  • PipPipPipPipPipPipPip
  • Group: Members
  • Posts: 2,526
  • Joined: August-01 09

Posted February 27, 2011 - 11:45 PM

Not sure what else you've edited, but that error shouldn't happen if you only edit ranks. Here's the only error I see in your post:

Quote

crsRanks(16) = "Chief Warrant Officer 3" : crsRankAccess(16) = 80
crsRanks(17) = "Chief Warrant Officer 2" : crsRankAccess(18) = 80


#211 User is offline   Simard Icon

  • Junior Member
  • PipPip
  • Group: Members
  • Posts: 17
  • Joined: March-20 11

Posted March 24, 2011 - 02:28 AM

I got a problem

how we add member

like that ? /setrank acc name rank ??

cause i did that and when a set member join its say the nm greet line

anybody can help me?

#212 User is offline   The-Black-Ninja Icon

  • The Sex
  • PipPipPipPipPipPipPip
  • Group: Members
  • Posts: 2,526
  • Joined: August-01 09

Posted March 24, 2011 - 02:50 AM

Look in the command manager.

#213 User is offline   Simard Icon

  • Junior Member
  • PipPip
  • Group: Members
  • Posts: 17
  • Joined: March-20 11

Posted March 24, 2011 - 04:16 AM

View PostThe-Black-Ninja, on March 24, 2011 - 02:50 AM, said:

Look in the command manager.


where?

#214 User is offline   The-Black-Ninja Icon

  • The Sex
  • PipPipPipPipPipPipPip
  • Group: Members
  • Posts: 2,526
  • Joined: August-01 09

Posted March 24, 2011 - 12:27 PM

Bot > Command Manager

#215 User is offline   FUA Icon

  • Newbie
  • Pip
  • Group: Members
  • Posts: 2
  • Joined: December-16 09

Posted March 29, 2011 - 07:04 PM

I have a question about the greeting message.
I have tried to search for a similar problem and was unsuccessful and I have also looked over the F&Q.
Is it possible to remove the extension @USEast from the member greeting?
For example, the bot that runs my CRS script is on WAR3 CDKey so it reads Diablo II players as [email protected]
I have the member greeting set to:m_greet=Welcome back home %0. It displays Welcome home [email protected]
Is it possible to have the bot leave out the "@useast" part and just display the account?

I figured I can fix this by changing the bot to a Diablo II CD Key or Customizing a rank for every member, but I figured I would ask before buying a new cd key or customizing.

Thanks for your time and support. :)
Posted Image

#216 User is offline   Dragon_Legion Icon

  • Full Member
  • PipPipPip
  • Group: Members
  • Posts: 423
  • Joined: October-08 09

Posted March 30, 2011 - 09:19 AM

you can change the realm type too

bot -> settings -> bot settings -> misc settings -> gateway settings (legacy is the @useast realms)

#217 User is offline   SierraKomodo Icon

  • Warn Status: 99.9%
  • PipPipPip
  • Group: Members
  • Posts: 192
  • Joined: January-01 10

Posted April 04, 2011 - 04:54 PM

I'm getting this error when using the crsRemove command:

[09:50:28 AM] <d.G)JDWolfe> ./crsremove fwg.trivia
[09:50:28 AM] Scripting runtime error '438' in crs: (line 709; column 38)
[09:50:28 AM] Object doesn't support this property or method: 'Command'
[09:50:28 AM] Offending line: >>
[09:50:28 AM] Scripting runtime error '438' in crs: (line 709; column 38)
[09:50:28 AM] Object doesn't support this property or method: 'Command'
[09:50:28 AM] Offending line: >>

#218 User is offline   McMidz Icon

  • Junior Member
  • PipPip
  • Group: Members
  • Posts: 11
  • Joined: November-13 09

Posted August 27, 2011 - 08:34 AM

this is the script file and my ranks


   '// =========  This line needs to be changed after you've altered the amount of ranks you have   ============

      numRanks = 2 '// Highest number of ranks. Change this value after adding or removing ranks.

   '// =========================================================================================================

   ReDim crsRanks(numRanks + 1): crsRanks(0) = "Unranked" '// Do not modify this line
   ReDim crsRankAccess(numRanks + 1): crsRankAccess(0) = "Unranked" '// Do not modify this line

   '// <<<< RANK LIST -- YOUR RANKS SHOULD BE LISTED ** BELOW ** HERE >>>>

   crsRanks(1) = "Admin"                  : crsRankAccess(1) = 200
   crsRanks(2) = "Runner"                 : crsRankAccess(2) = 5 Runners

   '// <<<< YOUR RANKS SHOULD BE LISTED ** ABOVE ** HERE >>>>



this is the error i get
 [01:27:25 AM] Scripting parsing error '1025' in crsClanRankScript.txt: (line 93; column 62)
 [01:27:25 AM] Expected end of statement
 [01:27:25 AM] Offending line: >> crsRanks(2) = "Runner"                 : crsRankAccess(2) = 5 Runners


Edit:lol i look over my post and didn't even see my question. i read that i can add users to a group in my ranks but its not working and or i put the information in wrong?

This post has been edited by McMidz: August 27, 2011 - 08:46 AM


#219 User is offline   Novynn Icon

  • Silver Member
  • PipPipPipPipPip
  • Group: Members
  • Posts: 873
  • Joined: October-07 09

Posted August 27, 2011 - 08:43 AM

Your code should be:
   '// =========  This line needs to be changed after you've altered the amount of ranks you have   ============

      numRanks = 2 '// Highest number of ranks. Change this value after adding or removing ranks.

   '// =========================================================================================================

   ReDim crsRanks(numRanks + 1): crsRanks(0) = "Unranked" '// Do not modify this line
   ReDim crsRankAccess(numRanks + 1): crsRankAccess(0) = "Unranked" '// Do not modify this line

   '// <<<< RANK LIST -- YOUR RANKS SHOULD BE LISTED ** BELOW ** HERE >>>>

   crsRanks(1) = "Admin"                  : crsRankAccess(1) = 200
   crsRanks(2) = "Runner"                 : crsRankAccess(2) = 5 'Runners

   '// <<<< YOUR RANKS SHOULD BE LISTED ** ABOVE ** HERE >>>>


#220 User is offline   McMidz Icon

  • Junior Member
  • PipPip
  • Group: Members
  • Posts: 11
  • Joined: November-13 09

Posted August 27, 2011 - 10:11 AM

View PostNovynn, on August 27, 2011 - 12:43 AM, said:

Your code should be:
   '// =========  This line needs to be changed after you've altered the amount of ranks you have   ============

      numRanks = 2 '// Highest number of ranks. Change this value after adding or removing ranks.

   '// =========================================================================================================

   ReDim crsRanks(numRanks + 1): crsRanks(0) = "Unranked" '// Do not modify this line
   ReDim crsRankAccess(numRanks + 1): crsRankAccess(0) = "Unranked" '// Do not modify this line

   '// <<<< RANK LIST -- YOUR RANKS SHOULD BE LISTED ** BELOW ** HERE >>>>

   crsRanks(1) = "Admin"                  : crsRankAccess(1) = 200
   crsRanks(2) = "Runner"                 : crsRankAccess(2) = 5 'Runners

   '// <<<< YOUR RANKS SHOULD BE LISTED ** ABOVE ** HERE >>>>


thank you

#221 User is offline   risker Icon

  • Junior Member
  • PipPip
  • Group: Members
  • Posts: 47
  • Joined: January-19 11

Posted April 28, 2012 - 02:57 AM

Would it be possible in regards to the /crsgreet nm/m <message> that user "groups" could be listed as %g.

#222 User is offline   risker Icon

  • Junior Member
  • PipPip
  • Group: Members
  • Posts: 47
  • Joined: January-19 11

Posted June 27, 2012 - 10:22 AM

I noticed you can add "reasons" to why someone was demoted, promoted and so forth but there's no way to check the reason without manual access to the database?

  • (9 Pages)
  • +
  • « First
  • 7
  • 8
  • 9
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users