Table list for database?

Results 1 to 3 of 3
  1. #1

    Table list for database?

    Does anyone have the tables list? I want it like lets say
    [TABLE ITEM] (%,%,%,%,%,%,%,%,%,%,%,%,%,%) // ServerID, ServerName, PlayerCount, MaxPlayer, CurrPlayer, Time, IP, Port, Opened, StatusTime, UpdateTime, RecvUDP, SendUDP, BlockUDP

    (the % are for like how many rows) After them, they are the titles that are needed. I want to know all of them so that I can create Query's to insert into them.


  2. #2
    MentaL's Slave Keith is offline
    LegendRank
    Nov 2004 Join Date
    2,671Posts
    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

  3. #3
    I meant the table list -_-" Like dbo.BlockCountryCode



Advertisement