[Help] website by clansystem 2.0

[bobsobol]

"Pictures" of "code" are not very helpful TBH. I wouldn't upload the bible as a Jpeg. XD

So, the Multimanager (CSM) is working clans, but not picking up SoD highscores, even if it's running when SoD is played? Hmm. Could it be that the SQL scripts to create the tables has not allocated them with the correct names or structure?

<b style=color=green>

Should probably be written more like:-

<b style="color: green;">

But I haven't tried.

[bkpro]

"Pictures" of "code" are not very helpful TBH. I wouldn't upload the bible as a Jpeg. XD

So, the Multimanager (CSM) is working clans, but not picking up SoD highscores, even if it's running when SoD is played? Hmm. Could it be that the SQL scripts to create the tables has not allocated them with the correct names or structure?

<b style=color=green>

Should probably be written more like:-

<b style="color: green;">

But I haven't tried.

oh! thanks
i had try again for it
I'm really not a website programmer. I'm trying to learn more. I also tried to learn web programming now.
grateful bobsobol
thanks all

[bkpro]

i had try again web site . but i can't edit with problem for sodpersonal high score .
why ?
creat database with rPTDB or AccountDB . run multimanager , edit host for all file ,
why why why ????????
thank bobsobol for code with status online
website near perfect . still problem sodpersonal high score .
help me ! pls
thanks all

I had try for it
i can't repair error Personal SoD High Scores
help me !
i had run file clansod manager , multimanager .and edit for all file but no success.
sory my english .
share for me code file index.asp or all your website file
thanks a lot

[bkpro]

My website

















edit all file
near perfect
help me please

with

BillingDBError.log

033537|--S1ClanSub
SELECT idx FROM clandb.dbo.ul WHERE userid='admin' AND chname='admin' Timeout expired
033540|INSERT INTO clandb.dbo.ct(userid,chname,ip,servername,sno) VALUES('admin','admin','127.0.0.1','Server1','467')
034422|--S1ClanSub
SELECT idx FROM clandb.dbo.ul WHERE userid='admin' AND chname='admin' Timeout expired


How to fix ?

[bobsobol]

SELECT idx FROM clandb.dbo.ul WHERE userid='admin' AND chname='admin' Timeout expired

MS SQL didn't understand you? Presumably there are no "idx" in "clandb.dbo.ul" with userid equal to "admin" and chname equal to "admin". Have you checked that it MS SQL Management Studio? Just a though. ;)

[bkpro]

thanks Bobsobol
yes I check with clandb.dbo.ul and i don't found 'admin' in that .

picture SQL with clan.db.ul


How should I edit?
I do not know about sql
help me
thanks a lot

[bobsobol]

That screenshot is not related to the SQL query. Look at the table data, not it's structure.

[bkpro]

: D sorry I do not know much about information technology. so you understand. the sql query is not my field.
and after trying to fix it, I succeeded sodpersonal score. but there is a small error on your code would help me
it does not connect to the class icon


I think the code is not know the problem but fix it. probably need a code for it to connect to img

thanks Bobsobol
thank you very much

[bobsobol]

Eww. Yucky code. All of the rows are listed in one cell of the table? Euck.

Hmm, well it seems to be a broken image embedding doesn't it? The part you highlight is just the column header.

		strSoDTablePersonal = strSoDTablePersonal & "</td><td><strong>Class</strong><BR>"

I don't think there's anything wrong with that. (other than the general nastiness of the table layout XD)

It must be contained in the loop below:-

		For i = 1 To (iC - 1)
			If i <= Results Then
				strSoDTablePersonal = strSoDTablePersonal & gClass(i) & "<BR>"
			End If
		Next

Specifically, the content of gClass(i) must be wrong. (probably pointing to a missing image URL. The array gClass() must expand to something like:-

'<img src="\images\class\1.gif">Fighter',
'<img src="\images\class\2.gif">Pikeman',
'<img src="\images\class\3.gif">Archer',
'<img src="\images\class\4.gif">Mech',
'<img src="\images\class\5.gif">Knight',
'<img src="\images\class\6.gif">Ata',
'<img src="\images\class\7.gif">Priestess',
'<img src="\images\class\8.gif">Mage'

The code before fills out the array:-

		For i = 1 To RS.RecordCount
			If iC <= 250 Then
				tName = RS("CharName").Value
				tLevel = RS("GLevel").Value
				tPoints = RS("Point").Value
				tKills = RS("KillCount").Value
				[color=red[tClass = GetCharType(RS("CharType").Value)[/color]
				tRegistDay = RS("RegistDay").Value

				If InArray(tName, gName) = False And tPoints > 0 Then
					If Not ucase(left(tName,3)) = "GM-" Then
						gName(iC) = tName
						gLevel(iC) = tLevel
						gPoints(iC) = tPoints
						gKills(iC) = tKills
						gClass(iC) = tClass
						gRegistDay(iC) = tRegistDay
						iC = iC + 1
					End If
				End If

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

So effectively, gClass(i) = iteration i of GetCharType(RS("CharType").Value

RS is a query produced by:-

	If ChType="" Then
		QUERY = "SELECT * FROM SoD2RecBySandurr ORDER BY Point DESC"
	Else
		QUERY = "SELECT * FROM SoD2RecBySandurr WHERE CharType='" & GetCharTypeInt(ChType) & "' ORDER BY Point DESC"
	End If

...

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

CharType is an integer allocated in the SQL file "Sod3DB.sql"

CREATE TABLE [dbo].[SOD2RecBySandurr](
	[SNo] [int] IDENTITY(1,1) NOT NULL,
	[UserID] [varchar](50) NULL,
	[CharName] [varchar](50) NULL,
	[CharType] [int] NULL,
	[Point] [int] NULL,
	[KillCount] [int] NULL,
	[GLevel] [int] NULL,
	[TotalPoint] [int] NULL,
	[TotalUser] [int] NULL,
	[SuccessUser] [int] NULL,
	[ServerName] [varchar](50) NULL,
	[PCRNo] [int] NULL,
	[GPCode] [varchar](50) NULL,
	[BusinessName] [varchar](100) NULL,
	[BAddress1] [varchar](100) NULL,
	[PMNo] [int] NULL,
	[Contribute] [int] NULL,
	[RegistDay] [datetime] NULL,
	[ServerTime] [bigint] NULL,
	[Flag] [int] NULL,
	[ClanIDX] [int] NULL,
	[ClanName] [varchar](50) NULL
) ON [PRIMARY]

So we are looking for the function with resolves:-

GetCharType(int).value

^_^

I found that in "database.asp"

Function GetCharType(ID)
	Select Case ID
		Case "1"
			GetCharType = "Fighter"
		Case "2"
			GetCharType = "Mechanician"
		Case "3"
			GetCharType = "Archer"
		Case "4"
			GetCharType = "Pikeman"
		Case "5"
			GetCharType = "Atalanta"
		Case "6"
			GetCharType = "Knight"
		Case "7"
			GetCharType = "Magician"
		Case "8"
			GetCharType = "Priestess"
	End Select
End Function

Which doesn't include any <img> tag at all. So either I'm missing something in my copy, or your copy is different to the one I have. Sorry.

I'm expecting yours to look like

Function GetCharType(ID)
	Select Case ID
		Case "1"
			GetCharType = "<img src="\images\class\1.gif">Fighter"
		Case "2"
			GetCharType = "<img src="\images\class\2.gif">Mechanician"
		Case "3"
			GetCharType = "<img src="\images\class\3.gif">Archer"
		Case "4"
			GetCharType = "<img src="\images\class\4.gif">Pikeman"
		Case "5"
			GetCharType = "<img src="\images\class\5.gif">Atalanta"
		Case "6"
			GetCharType = "<img src="\images\class\6.gif">Knight"
		Case "7"
			GetCharType = "<img src="\images\class\7.gif">Magician"
		Case "8"
			GetCharType = "<img src="\images\class\8.gif">Priestess"
	End Select
End Function

Except there is no saying what the images may be called, or where they may be stored.

My archive doesn't contain any class images, and since the code doesn't seem to point to any either, that isn't a problem. Maybe you have some class logos in there? Maybe you'd be happy to have it show nothing rather than the broken image place-holder?

[bkpro]

woa ! thanks Bobsobol

although not used for sharing your code, but I'm also happy to have you help and a little more about asp.
when I search database.asp I see: I had no img folder in the function.

this is the result




thank you very much

[bobsobol]

Super! Congratulations! We got there in the end.

Also, thank you for telling us how you used the information you where given to achieve success. I'm sure it will be helpful to others who search.

--- EDIT ---
Okay, now try changing the loop below the class header in sodpersonal.asp to look like this:-

		For i = 1 To (iC - 1)
			If i <= Results Then
				strSoDTablePersonal = strSoDTablePersonal & "<img src=functions/img/" & str(i) & ".gif>" & gClass(i) & "<BR>"
			End If
		Next

And set the database.asp function back the way mine is:-

Function GetCharType(ID)
	Select Case ID
		Case "1"
			GetCharType = "Fighter"
		Case "2"
			GetCharType = "Mechanician"
		Case "3"
			GetCharType = "Archer"
		Case "4"
			GetCharType = "Pikeman"
		Case "5"
			GetCharType = "Atalanta"
		Case "6"
			GetCharType = "Knight"
		Case "7"
			GetCharType = "Magician"
		Case "8"
			GetCharType = "Priestess"
	End Select
End Function

I think you'll find it produces the same layout on the page, but I think it's a more elegant solution. (Smaller code, less dynamic so it may cache better, more intuitive when re-reading in order to debug)