ASP Coder needed.

look in config.asp for the mssql information etc.

$userid is read from the link   example:( test.com/page.asp?userid=test )

$CName = CHECK the field "ClanName" in the same row as $userid in the "userid" column in the table "S1ClanSub"

IF $userid does not exist in that table THEN:

write (like display when you go to the page): "Code=0 CMoney=500000 CNFlag=0"

ELSE

$CNote = CHECK the field "CNote" in the same row as $CName in the "ClanName" column in the table "S1ClanMain"

$CZang = CHECK the field "CZang" in the same row as $CName in the "ClanName" column in the table "S1ClanMain"

$CMCnt = CHECK the field "CMCnt" in the same row as $CName in the "ClanName" column in the table "S1ClanMain"

$CIMG = CHECK the field "MIconCnt" in the same row as $CName in the "ClanName" column in the table "S1ClanMain"

$CRegiD = CHECK the field "RegiDate" in the same row as $CName in the "ClanName" column in the table "S1ClanMain"

$CDelActive = CHECK the field "DelActive" in the same row as $CName in the "ClanName" column in the table "S1ClanMain"

$CPFlag = CHECK the field "PFlag" in the same row as $CName in the "ClanName" column in the table "S1ClanMain"

$CKFlag = CHECK the field "KFlag" in the same row as $CName in the "ClanName" column in the table "S1ClanMain"


write: "Code=2 CName=$CName CNote=$CNote CZang=$CZang CStats=0 CMCnt=$CMCnt CIMG=$CIMG CSec=52 CRegiD=$CRegiD CLimitD=2016/08/09 3:50:04 CDelActive=$CDelActive CPFlag=$CPFlag CKFlag=$CKFlag CMoney=500000 CNFlag=0"