Excellzone

Forum and disscussions since 2010


You are not connected. Please login or register

View previous topic View next topic Go down Message [Page 1 of 1]

#1
Excell

avatar
Head Administer
Head Administer
Credits to Alexsh in Ragezone for the queries in an old topic

//Changes character authority (Make them a GM...etc)
update [CHARACTER_TBL] set m_chAuthority = 'F/P/S' where m_szName = 'CHARACTERNAME'

//Sets Ban Start Time
update [ACCOUNT_TBL_DETAIL] set BlockTime = '20090210' where account = 'ACCOUNTNAME'

//Sets Ban End Time
update [ACCOUNT_TBL_DETAIL] set EndTime = '' where account = 'ACCOUNTNAME'

//Removes the guild wait time on a certain character
update [CHARACTER_TBL] set m_tGuildMember = '' where m_szName = 'CHARACTERNAME'

//Gets a character's account ID
select account from [CHARACTER_TBL] where m_szName = 'CHARACTER NAME'

//Displays all the characters on an account
select m_szName from [CHARACTER_TBL] where account = 'ACCOUNTNAME'

//Sets an IP address on a certain account
update [ACCOUNT_TBL_DETAIL] set ip = 'IP ADDRESS' where account = 'ACCOUNTNAME'

//Gets the MD5 Password from an account
select password from [ACCOUNT_TBL] where account = 'ACCOUNTNAME'

//Sets an account's password to what you want it as.
update [ACCOUNT_TBL] set password = 'md5 pw' where account = 'ACCOUNTNAME'

//Changes the account a character is on (you may need the next query if you use this query)
update [CHARACTER_TBL] set account = 'ACCOUNTNAME' where m_szName = 'CHARACTERNAME'

//Changes the slot that the player is in in the character selection
update [CHARACTER_TBL] set playerslot = 'slot' where m_szName = 'CHARACTERNAME'

//Sends an item to a player's inventory
mssql_query("INSERT into [ITEM_SEND_TBL](m_idPlayer, serverindex,
Item_Name, Item_count, m_nAbilityOption, idSender, ItemFlag, ReceiveDt,
ProvideDt, nRandomOptItemId,adwItemId4)

VALUES
('CHARACTER ID', '01', 'ITEM NAME', 'ITEM COUNT', 0, '000000', 0, getdate(), NULL, 0, 0);");


Credits to Alexsh in Ragezone for the queries in an old topic
[END OF ALEX'S QUERIES]


Credits to darkesthour123 in Ragezone.

//Gets all gm characters in character table.
select from [CHARACTER_TBL] where m_chAuthority = 'S'

//Deletes all gm characters in character table.
delete from [CHARACTER_TBL] where m_chAUTHORITY = 's'

//Gets account id for gms in char table.
select account from [CHARACTER_TBL] where m_chAUTHORITY = 's'

//Brings up account in account table.
select from [ACCOUNT_DBF] where account = '(Name)'//Name is without ().

//Deletes account from account table
delete from [ACCOUNT_DBF] where account = '(Name)'

//This will get the guild id
select m_idGuild from [GUILD_TBL] where m_szGuild = 'guild name'

// This will get the character id
select m_idPlayer from [Character_TBL] where m_szName = 'character name'

// changes the guild of the character
update [GUILD_MEMBER_TBL] set serverindex = '01' where m_idPlayer = 'char id'
update [GUILD_MEMBER_TBL] set m_idGuild = 'guild id' where m_idPlayer = 'char id'
update [GUILD_MEMBER_TBL] set m_szAlias = '' where m_idPlayer = 'char id'
update [GUILD_MEMBER_TBL] set m_nWin = '0' where m_idPlayer = 'char id'
update [GUILD_MEMBER_TBL] set m_nLose = '0' where m_idPlayer = 'char id'
update [GUILD_MEMBER_TBL] set m_nSurrender = '0' where m_idPlayer = 'char id'
update [GUILD_MEMBER_TBL] set m_nMemberLv = '4' where m_idPlayer = 'char id'
update [GUILD_MEMBER_TBL] set m_nGiveGold = '0' where m_idPlayer = 'char id'
update [GUILD_MEMBER_TBL] set m_nGivePxp = '0' where m_idPlayer = 'char id'
update [GUILD_MEMBER_TBL] set m_idWar = '0' where m_idPlayer = 'char id'
update [GUILD_MEMBER_TBL] set m_idVote ='0' where m_idPlayer = 'char id'
update [GUILD_MEMBER_TBL] set isuse = 'T' where m_idPlayer = 'char id'
update [GUILD_MEMBER_TBL] set CreateTime = '2010-01-10 15:55:55.857' where m_idPlayer = 'char id'
update [GUILD_MEMBER_TBL] set m_nClass = '0' where m_idPlayer = 'char id'

edit<< Fully works.This querie will join character in a chosen guild. if u use my other 2 script you can get
the character id and guild id. the script will 100% work when trans server and world server
is closed. so use script then start the server. you can edit this script to make your self owner,
kingpin etc.

Credits to darkesthour123 in Ragezone.

[END OF darkesthour123'S QUERIES.]

Credits to aldieri in Ragezone.

//Gets the logs from the id you put in.
select m_szWords from [LOG_GAMEMASTER_TBL] where m_idPlayer = 'ID from GM Log'

Credits to aldieri in Ragezone.
[END OF aldieri's QUERIES.]

View user profile http://excellzone.mrforum.net

#2
rano9999

avatar
Level 1
Level 1
the scripts are working. Thanks to all who made the scripts

View user profile

View previous topic View next topic Back to top Message [Page 1 of 1]


Permissions in this forum:
You cannot reply to topics in this forum