Clan procs: RET values

vDrag0n · Jan 23, 2007

Anyone know the what the SQL Server returns to the MatchServer when a Clan is created and/or a member is added?

Thanks.

Hakurah · Jan 23, 2007

Up.

I need'em please. Do anyone have it?

bepetemish · Jan 23, 2007

Buga's Wonderful Procedure List
Here is nearly every procedure called by MatchServer.exe, with the values they take, I've added some of the values to tell you what they are, and others I just add what type they are because I didnt have time to lookup what they were. They maybe incorrect, I did some of them at night, but they should be right!

If you don't know what they are used for, then wait for someone to write the procedures for you, and there will be no worries.

Code:

CALL spInsertAccount ('%s', '%s', %d, '%s', %d, %d) //Username, Password, UGradeID, ? String, ? Integer, ? Integer
CALL spGetLoginInfo ('%s') // AccountName
CALL spGetAccountInfo (%d) // AID
CALL spInsertChar (%d, %d, '%s', %d, %d, %d, %d) // AID, CharacterIndex, Name, Sex, Hair, Face, Costume
CALL spDeleteChar (%d, %d, '%s') // AID, CharIndex, CharName
CALL spGetCharList (%d)  // AID
CALL spGetAccountCharInfo (%d, %d) // AID, CharIndex
CALL spGetCharInfoByCharNum (%d, %d) // AID, CharIndex
CALL spSimpleUpdateChar (%d, '%s', %d, %d, %d) // CharID, CharName, ? Integer, ? Integer, ? Integer
CALL spInsertCharItem (%d, %d, %d)  // ItemID, CharID, RentPeriod
CALL spDeleteCharItem (%d, %d) // ItemID, CharID
CALL spSelectCharItem (%d) // Char ID
CALL spSelectAccountItem (%d) //AID
CALL spBuyBountyItem (%d, %d, %d) // CharID, ItemID, ItemPrice
CALL spSellBountyItem (%d, %d, %d, %d, %d) // CharID, ItemID, ItemIncrementID, ItemPrice, CharBounty
CALL spUpdateEquipItem (%d, %d, %d, %d) // CharID, ItemSlot, ItemIncrementID, ItemID
CALL spInsertConnLog (%d, %d, %d, %d, %d, '%s') // AID, IP1, IP2, IP3, IP4, AlertState
CALL spInsertGameLog ('%s', '%s', '%s',%d, %d, %d, '%s') //GameName, MapName, GameType, Rounds, RoundsPlayed, Users, GameMaster
CALL spInsertKillLog (%d, %d) // KillerID, KilledID
CALL spInsertItemPurchaseLogByBounty (%d, %d, %d, %d, '%s') // CharID, ItemID, ItemIncrementID, ItemRentPeriod, ItemName
CALL spInsertCharMakingLog (%d, '%s', '%s') // AID, Name, Sex
CALL spInsertServerLog (%d,%d, %d, %u, %u)  // ? integer, ? integer, ? integer, ? unsigned integer, ? unsigned integer
CALL spUpdateServerStatus (%d, %d) //ServerID, StatusID
CALL spInsertPlayerLog (%d, %d, %d, %d, %d, %d) // CharID, PlayTime, KillCount, DeathCount, EXPEarned, TotalEXP
CALL spInsertLevelUpLog (%d, %d, %d, %d, %d, %d) // ?integer, ?integer, ?integer, ?integer, ?integer, ?integer
CALL spUpdateCharLevel (%d, %d) // Level, CharID
CALL spUpdateCharBP (%d, %d) // Bounty, CharID
CALL spUpdateCharInfoData (%d, %d, %d, %d, %d) // TotalEXP, Total BP, TotalKills, TotalDeaths, CID
CALL spUpdateCharPlayTime (%d, %d) // PlayTime, CharID
CALL spUpdateLastConnDate ('%s', '%s') // AccountName, Date
CALL spBringAccountItem (%d, %d, %d) // ItemID, AID, CIID
CALL spBringBackAccountItem (%d, %d, %d) // ItemID, CID, AIID
CALL spClearAllEquipedItem (%d) // CharID
CALL spAddFriend (%d, %d, %d) // CID, FriendCID, Favorite
CALL spRemoveFriend (%d, %d) // CID, FriendCID
CALL spGetFriendList (%d) //CharID

//Clans
CALL spGetCharClan (%d) //CharID
CALL spGetCLIDFromClanName ('%s') //ClanName
CALL spCreateClan ('%s', %d, %d, %d, %d, %d) //Name, Master, Member1, Member2, Member3, Member4 
CALL spReserveCloseClan (%d, '%s', %d) //ClanID, ClanName, ClanMasterID
CALL spAddClanMember (%d, %d, %d) //ClanID, CharID, Level (admin = 2,normal = 0)
CALL spRemoveClanMember (%d, %d) //ClanID, CharID
CALL spUpdateClanGrade (%d, %d, %d) // CLID, CharID, ClanGrade
CALL spRemoveClanMemberFromCharName (%d, %d, '%s') // CLID, CharID, CharName
CALL spGetClanInfo (%d) // CLID

//Clan Wars
CALL spGetTeamID4 (%d, %d, %d, %d) //Member1,Member2,Member3,Member4
CALL spTeam4WinTheGame (%d, %d, %d, %d,%d, %d) // CLID, TeamID, Member1, Member2, Member3, Member4
CALL spGetLadderTeamMemberByCID (%d) // CharID
CALL spWinTheClanGame (%d, %d, %d, %d, %d, '%s', '%s', %d, %d, %d, %d,'%s', '%s') //WinningCLID, WinnerMember1, WinnerMember2, WinnerMember3, WinnerMember4, WinnerClanName, WinnerClanEmblem, LoserClanID, LoserMember1, LoserMember2, LoserMember3, LoserMember4, LoserClanName, LoserClanEmblem
CALL spUpdateCharClanContPoint (%d, %d, %d) // CLID, CharID, ContPoint


CALL spDeleteExpiredAccountItem (%d) // AIID
CALL spSelectCharQuestItemInfoByCID (%d) //CharID
CALL spInsertQuestGameLog ('%s', %d, %d, %d, %d, %d, %d, %d) //GameName, Rounds, Members
CALL spInsertQUniqueItemLog (%d, %d, %d) // ItemID, CharID, RentPeriod
CALL spCheckPremiumIP ('%s')  // IPAddress
CALL spInsertEvent (%u, %u, '%s') // Date, Name

//Locator
CALL spIPFltGetIPtoCountryCode ('%s') // IP
CALL spIPFltGetIPtoCountryList
CALL spIPFltGetBlockCountryCodeList
CALL spIPFltGetCustomIPList
CALL spIPFltGetCustomIP ('%s') // IP

Like it says, Buga's Wonderful Procedure List, so he gets the full credits. Lala my font is bolt:yeahright

kurisu · Jan 23, 2007

Were looking for the RETURNED values for those procedures. Not the parameters.

bepetemish · Jan 23, 2007

In that case i can't help you because im not home.

kurisu · Jan 23, 2007

Well, if anyone has them, please share, it would make writing these procedures a whole lot easier.

Centrix · Jan 23, 2007

not @ home either...

bepetemish · Jan 23, 2007

Can't the SQL server be debugd with Olly or softice or any other debugger you prefer?

kurisu · Jan 23, 2007

Im not so sure about that...
And even then, that would be even harder.

bepetemish · Jan 23, 2007

I will take a fast look for you when im home kurisu.

vDrag0n · Jan 23, 2007

bepetemish teorically my clan craps are working, i just need the returned values, if you dont want to post you may PM me please.

thank you for the support

hunter1577 · Jan 23, 2007

bepetemish said:

Buga's Wonderful Procedure List
Here is nearly every procedure called by MatchServer.exe, with the values they take, I've added some of the values to tell you what they are, and others I just add what type they are because I didnt have time to lookup what they were. They maybe incorrect, I did some of them at night, but they should be right!

If you don't know what they are used for, then wait for someone to write the procedures for you, and there will be no worries.

Code:

CALL spInsertAccount ('%s', '%s', %d, '%s', %d, %d) //Username, Password, UGradeID, ? String, ? Integer, ? Integer
CALL spGetLoginInfo ('%s') // AccountName
CALL spGetAccountInfo (%d) // AID
CALL spInsertChar (%d, %d, '%s', %d, %d, %d, %d) // AID, CharacterIndex, Name, Sex, Hair, Face, Costume
CALL spDeleteChar (%d, %d, '%s') // AID, CharIndex, CharName
CALL spGetCharList (%d)  // AID
CALL spGetAccountCharInfo (%d, %d) // AID, CharIndex
CALL spGetCharInfoByCharNum (%d, %d) // AID, CharIndex
CALL spSimpleUpdateChar (%d, '%s', %d, %d, %d) // CharID, CharName, ? Integer, ? Integer, ? Integer
CALL spInsertCharItem (%d, %d, %d)  // ItemID, CharID, RentPeriod
CALL spDeleteCharItem (%d, %d) // ItemID, CharID
CALL spSelectCharItem (%d) // Char ID
CALL spSelectAccountItem (%d) //AID
CALL spBuyBountyItem (%d, %d, %d) // CharID, ItemID, ItemPrice
CALL spSellBountyItem (%d, %d, %d, %d, %d) // CharID, ItemID, ItemIncrementID, ItemPrice, CharBounty
CALL spUpdateEquipItem (%d, %d, %d, %d) // CharID, ItemSlot, ItemIncrementID, ItemID
CALL spInsertConnLog (%d, %d, %d, %d, %d, '%s') // AID, IP1, IP2, IP3, IP4, AlertState
CALL spInsertGameLog ('%s', '%s', '%s',%d, %d, %d, '%s') //GameName, MapName, GameType, Rounds, RoundsPlayed, Users, GameMaster
CALL spInsertKillLog (%d, %d) // KillerID, KilledID
CALL spInsertItemPurchaseLogByBounty (%d, %d, %d, %d, '%s') // CharID, ItemID, ItemIncrementID, ItemRentPeriod, ItemName
CALL spInsertCharMakingLog (%d, '%s', '%s') // AID, Name, Sex
CALL spInsertServerLog (%d,%d, %d, %u, %u)  // ? integer, ? integer, ? integer, ? unsigned integer, ? unsigned integer
CALL spUpdateServerStatus (%d, %d) //ServerID, StatusID
CALL spInsertPlayerLog (%d, %d, %d, %d, %d, %d) // CharID, PlayTime, KillCount, DeathCount, EXPEarned, TotalEXP
CALL spInsertLevelUpLog (%d, %d, %d, %d, %d, %d) // ?integer, ?integer, ?integer, ?integer, ?integer, ?integer
CALL spUpdateCharLevel (%d, %d) // Level, CharID
CALL spUpdateCharBP (%d, %d) // Bounty, CharID
CALL spUpdateCharInfoData (%d, %d, %d, %d, %d) // TotalEXP, Total BP, TotalKills, TotalDeaths, CID
CALL spUpdateCharPlayTime (%d, %d) // PlayTime, CharID
CALL spUpdateLastConnDate ('%s', '%s') // AccountName, Date
CALL spBringAccountItem (%d, %d, %d) // ItemID, AID, CIID
CALL spBringBackAccountItem (%d, %d, %d) // ItemID, CID, AIID
CALL spClearAllEquipedItem (%d) // CharID
CALL spAddFriend (%d, %d, %d) // CID, FriendCID, Favorite
CALL spRemoveFriend (%d, %d) // CID, FriendCID
CALL spGetFriendList (%d) //CharID
 
//Clans
CALL spGetCharClan (%d) //CharID
CALL spGetCLIDFromClanName ('%s') //ClanName
CALL spCreateClan ('%s', %d, %d, %d, %d, %d) //Name, Master, Member1, Member2, Member3, Member4 
CALL spReserveCloseClan (%d, '%s', %d) //ClanID, ClanName, ClanMasterID
CALL spAddClanMember (%d, %d, %d) //ClanID, CharID, Level (admin = 2,normal = 0)
CALL spRemoveClanMember (%d, %d) //ClanID, CharID
CALL spUpdateClanGrade (%d, %d, %d) // CLID, CharID, ClanGrade
CALL spRemoveClanMemberFromCharName (%d, %d, '%s') // CLID, CharID, CharName
CALL spGetClanInfo (%d) // CLID
 
//Clan Wars
CALL spGetTeamID4 (%d, %d, %d, %d) //Member1,Member2,Member3,Member4
CALL spTeam4WinTheGame (%d, %d, %d, %d,%d, %d) // CLID, TeamID, Member1, Member2, Member3, Member4
CALL spGetLadderTeamMemberByCID (%d) // CharID
CALL spWinTheClanGame (%d, %d, %d, %d, %d, '%s', '%s', %d, %d, %d, %d,'%s', '%s') //WinningCLID, WinnerMember1, WinnerMember2, WinnerMember3, WinnerMember4, WinnerClanName, WinnerClanEmblem, LoserClanID, LoserMember1, LoserMember2, LoserMember3, LoserMember4, LoserClanName, LoserClanEmblem
CALL spUpdateCharClanContPoint (%d, %d, %d) // CLID, CharID, ContPoint
 
 
CALL spDeleteExpiredAccountItem (%d) // AIID
CALL spSelectCharQuestItemInfoByCID (%d) //CharID
CALL spInsertQuestGameLog ('%s', %d, %d, %d, %d, %d, %d, %d) //GameName, Rounds, Members
CALL spInsertQUniqueItemLog (%d, %d, %d) // ItemID, CharID, RentPeriod
CALL spCheckPremiumIP ('%s')  // IPAddress
CALL spInsertEvent (%u, %u, '%s') // Date, Name
 
//Locator
CALL spIPFltGetIPtoCountryCode ('%s') // IP
CALL spIPFltGetIPtoCountryList
CALL spIPFltGetBlockCountryCodeList
CALL spIPFltGetCustomIPList
CALL spIPFltGetCustomIP ('%s') // IP

Like it says, Buga's Wonderful Procedure List, so he gets the full credits. Lala my font is bolt:yeahright

sorry, im noob. what i do with that

MackInTosh · Jan 23, 2007

.....

vDrag0n · Jan 23, 2007

If I got anything else I'll make sure to tell you, thanks, going to test.

Keith · Jan 23, 2007

Mack, you're awesome, thanks dude.. same here :3

hunter1577 · Jan 23, 2007

Mackintosh can you post the stored procedures for clan creation e call members?

MackInTosh · Jan 24, 2007

Clan procs: RET values

vDrag0n

Junior Spellweaver

Hakurah

Gunz League owner

bepetemish

Experienced Elementalist

kurisu

Newbie Spellweaver

bepetemish

Experienced Elementalist

kurisu

Newbie Spellweaver

Centrix

Master Summoner

bepetemish

Experienced Elementalist

kurisu

Newbie Spellweaver

bepetemish

Experienced Elementalist

vDrag0n

Junior Spellweaver

hunter1577

Newbie Spellweaver

MackInTosh

Junior Spellweaver

vDrag0n

Junior Spellweaver

Keith

MentaL's Slave

hunter1577

Newbie Spellweaver

MackInTosh

Junior Spellweaver

RaGEZONE Sponsor

About RaGEZONE

Forum Statistics

RaGEZONE Partners