- Joined
- Jun 11, 2010
- Messages
- 60
- Reaction score
- 4
Hey guys, someone know how to get sod crown with winning clan sod? I have tried but no success.
Thank you
Thank you
Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!
Join Today!INSERT INTO soddb.dbo.%s(userid,charname,chartype,point,killcount,glevel,totalpoint,totaluser,successuser,servername,pcrno,gpcode,contribute,registday,businessname,baddress1,pmno,servertime) VALUES('%s','%s',%d,%d,%d,%d,%d,%d,%d,'%s',%d,'%s',%d,'%s','%s','
SOD2RecBySandurr
QUERY = "SELECT ClanName,Cpoint FROM CL ORDER BY Cpoint DESC"
RS.Open QUERY, objConn, 3, 1
Dim tclName, CNFlag
If RS.RecordCount > 0 Then
tclName = RS("ClanName").Value
If (tclName = clname) And (RS("Cpoint").Value > 0) Then
CNFlag = 1
Else
CNFlag = 0
End If
RS.Close
End If
QUERY = "SELECT TOP 1 ClanName FROM CL WHHERE Cpoint > 0 ORDER BY Cpoint DESC"
RS.Open QUERY, objConn, 3, 1
Dim tclName, CNFlag
CNFlag = 0
If RS.RecordCount > 0 Then
tclName = RS("ClanName").Value
RS.Close
If tclName = clname Then
CNFlag = 1
End If
End If
INSERT INTO soddb.dbo.SOD2RecBySandurr(userid,charname,chartype,point,killcount,glevel,totalpoint,totaluser,successuser,servername,pcrno,gpcode,contribute,registday,businessname,baddress1,pmno,servertime) VALUES('demonvn','Warishell',4,6264435,785,120,6264435,1,1,'',0,'PTP-RUD001',100,'09-19-2010 04:16:39','','',0,127265800)