[Sharing] Working Sandurr's Clan System Version 2.0

[bbchamps2000]

yo. why do i dc(4)?

i have new files and i havent tested them. they are the SOD_ monsters

like SOD_Decoy SOD_Cyclops. etc etc.

but anyone have a clue y i dc? too much exp i kno but... how i fix it

 

[Xaldin]

yo. why do i dc(4)?

i have new files and i havent tested them. they are the SOD_ monsters

like SOD_Decoy SOD_Cyclops. etc etc.

but anyone have a clue y i dc? too much exp i kno but... how i fix it

lower the xp?

 

[Murrough]

error 24 and 52 too
=(

 

[bbchamps2000]

ya but that lowers everything.

i guess i could.

 

[microamazing]

for peoples, use the 2000 SQL, don't need edit for conect using the tcp/ip!
and for peoples, use the 2005 SQL server, i make a mini tutorial, for use this!
see:
1) for the SQL Server 2005, conect the Host 127....... you need configure this! see the images...:

2)and go to SQL Server "Configuration Manager", and make this:

3)and go to "SQL Server Surface Area Configuration", and make this:

ok... now your SQL 2005 are configured for hosts...
4)and you need configure the SQL.DLL! see:
you, pressures in your keyboard "CTRL+F",with the hexadecimal open! and you edit for your SQL name, see:

5) now, you need edit the host, the dbID and DBPass see:

!~!~!~!~!~!~!~!~!~!~!~ =D !~!~!~!~!~!~!~!~!~!~!~!~!
For sod ranks Work:
1)open your server...
2)and open "ClanSoDManager.exe" , and configure this:

3) making DB and configuring the .ASP Files!
3a) making DB, see:

3b)and,rigth click buton mause in Sod2Db> new Query ! ... and writhe the "SOD2RecBySandurr" Db, and, click in EXECUTE, and you see:

ok you SOD DB is creat!

3C) configuring the .ASP files!
see the images:
configure this file:
C:\Inetpub\wwwroot\ServerMain "SODsettings.asp" and "settings.asp"
C:\Inetpub\wwwroot\Clan "clanInsert.aspx"
C:\Inetpub\wwwroot\functions "database.asp"
see the image:

...
...
...

!~!~!~! now... go play =D !~!~!~!~!
Tnks Sandurr,shagpub, and Quantunfusion and... RPT, and the all people of Ragezone forum =D!

 

[tr1pl3x1]

thank you

 

[Xaldin]

Could you make a guide for people using 2003?

 

[microamazing]

@Xaldin
I never see, the SQL Server 2003, but search similary options, in your sql! or Use the 2005 sql =D

 

[great48]

Nice

 

[macruz10]

for peoples, use the 2000 SQL, don't need edit for conect using the tcp/ip!
and for peoples, use the 2005 SQL server, i make a mini tutorial, for use this!
see:
1) for the SQL Server 2005, conect the Host 127....... you need configure this! see the images...:

2)and go to SQL Server "Configuration Manager", and make this:

3)and go to "SQL Server Surface Area Configuration", and make this:

ok... now your SQL 2005 are configured for hosts...
4)and you need configure the SQL.DLL! see:
you, pressures in your keyboard "CTRL+F",with the hexadecimal open! and you edit for your SQL name, see:

5) now, you need edit the host, the dbID and DBPass see:

!~!~!~!~!~!~!~!~!~!~!~ =D !~!~!~!~!~!~!~!~!~!~!~!~!
For sod ranks Work:
1)open your server...
2)and open "ClanSoDManager.exe" , and configure this:

3) making DB and configuring the .ASP Files!
3a) making DB, see:

3b)and,rigth click buton mause in Sod2Db> new Query ! ... and writhe the "SOD2RecBySandurr" Db, and, click in EXECUTE, and you see:

ok you SOD DB is creat!

3C) configuring the .ASP files!
see the images:
configure this file:
C:\Inetpub\wwwroot\ServerMain "SODsettings.asp" and "settings.asp"
C:\Inetpub\wwwroot\Clan "clanInsert.aspx"
C:\Inetpub\wwwroot\functions "database.asp"
see the image:

...
...
...

!~!~!~! now... go play =D !~!~!~!~!
Tnks Sandurr,shagpub, and Quantunfusion and... RPT, and the all people of Ragezone forum =D!

clan ok
sod ok
crown of sod ok
taxes ok rank sod ok
"top 10 off" How for rank to function?

You must be registered to see links

 

[shagpub]

Create databse rPTDB
create Table Levelist there
Create column CharName, CharClass, CharLevel and ID in LevelList

edit ranks.asp to open connection to correct DB
run Multimanager to update rank

 

[Tinhanhvanthe85]

hi im kinda confuse do u need to delet the obdc?

 

[Sasuke_chan]

my Ducking mulimanager dont start whyyyyy help

************* Exception Text **************
System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.Data.SqlClient.SqlException: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 - Ein Verbindungsversuch ist fehlgeschlagen, da die Gegenstelle nach einer bestimmten Zeitspanne nicht ordnungsgem

 

[33453506]

error 24 and 52 too
=(


chinese

 

[microamazing]

ok... this is my rank, but ... don't work perfect... work for people of use o sod! this file:
C:\Inetpub\wwwroot\functions

<!-- #include file = "database.asp" -->

<% 'Written by Sandurr
DBSettings()

Function RankTable(Results, Min, Max, ChType)
If Results <= 0 Or Results > 250 Then
Results = 250
End If
If Min=0 Or Max=0 Then
Min = 0
Max = 250
End If
If ChType="" Then
QUERY = "SELECT * FROM SOD2RecBySandurr ORDER BY GLevel DESC"
Else
QUERY = "SELECT * FROM SOD2RecBySandurr WHERE CharClass='" & ChType & "' ORDER BY GLevel DESC"
End If

Dim gName(250)
Dim gLevel(250)
Dim gClass(250)

Dim tName, tLevel, tClass

Dim iC, strRankTable
iC = 1

OpenConnection(dbname3)
RS.Open QUERY, objConn, 3, 1

If Not RS.RecordCount >= 1 Then
strRankTable = "No characters"
Else
Dim i
For i = 1 To RS.RecordCount
If iC <= 250 Then
tName = RS("CharName").Value
tLevel = RS("GLevel").Value
tClass = RS("CharType").Value

If CInt(tLevel) >= CInt(Min) And CInt(tLevel) <= CInt(Max) And tClass <> "Unknown ID: 0" Then
If Not ucase(left(tName,3)) = "GM-" Then
gName(iC) = tName
gLevel(iC) = tLevel
gClass(iC) = tClass
iC = iC + 1
End If
End If

If i < RS.RecordCount Then
RS.MoveNext
End If
End If
Next

strRankTable = "<table width=100% ><tr><td><tr><td><BR>"
For i = 1 To (iC - 1)
If i <= Results Then
strRankTable = strRankTable & i & "<BR>"
End If
Next
strRankTable = strRankTable & "</td><td><strong>Class</strong><BR>"
For i = 1 To (iC - 1)
If i <= Results Then
strRankTable = strRankTable & gClass(i) & "<BR>"
End If
Next
strRankTable = strRankTable & "</td><td><strong>Character</strong><BR>"
For i = 1 To (iC - 1)
If i <= Results Then
strRankTable = strRankTable & gName(i) & "<BR>"
End If
Next
strRankTable = strRankTable & "</td><td><strong>Level</strong><BR>"
For i = 1 To (iC - 1)
If i <= Results Then
strRankTable = strRankTable & gLevel(i) & "<BR>"
End If
Next
strRankTable = strRankTable & "</td></tr></td></tr></table>"
End If
Response.Write(strRankTable)
CloseConnection()
End Function
%>

 

[shagpub]

dbname3 = rPTDB
and make sure you've run Multimanager.exe to update list

 

[microamazing]

hmmmm, Tnks shagpub, but... i make this DB in my sql? and tables? i writhe... ?

 

[bbchamps2000]

dbname3 = rPTDB
and make sure you've run Multimanager.exe to update list

MultiManager ???

where and what is that

 

[microamazing]

MultiManager.exe ( file for update the lvl of char... and for work Rank =D)
see my sql and my error now...

 

[macruz10]

ok... this is my rank, but ... don't work perfect... work for people of use o sod! this file:
C:\Inetpub\wwwroot\functions

Rank bug =/

You must be registered to see links