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 Oh Im stupid Lol..
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