Welcome!

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!

Clan procs: RET values

Junior Spellweaver
Joined
Dec 23, 2006
Messages
145
Reaction score
0
Anyone know the what the SQL Server returns to the MatchServer when a Clan is created and/or a member is added?

Thanks.
 
Experienced Elementalist
Joined
Nov 29, 2006
Messages
246
Reaction score
2
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
 
Upvote 0
Initiate Mage
Joined
Jun 3, 2005
Messages
10
Reaction score
0
Were looking for the RETURNED values for those procedures. Not the parameters.
 
Upvote 0
Initiate Mage
Joined
Jun 3, 2005
Messages
10
Reaction score
0
Well, if anyone has them, please share, it would make writing these procedures a whole lot easier.
 
Upvote 0
Experienced Elementalist
Joined
Nov 29, 2006
Messages
246
Reaction score
2
Can't the SQL server be debugd with Olly or softice or any other debugger you prefer?
 
Upvote 0
Initiate Mage
Joined
Jun 3, 2005
Messages
10
Reaction score
0
Im not so sure about that...
And even then, that would be even harder.
 
Upvote 0
Junior Spellweaver
Joined
Dec 23, 2006
Messages
145
Reaction score
0
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
 
Upvote 0
Initiate Mage
Joined
Dec 31, 2006
Messages
61
Reaction score
0
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 :)
 
Upvote 0
Junior Spellweaver
Joined
Dec 23, 2006
Messages
145
Reaction score
0
If I got anything else I'll make sure to tell you, thanks, going to test.
 
Upvote 0
Back
Top