Leaderboard

https://www.youtube.com/watch?v=P5FgAX5m20U

function GetGuildID2(Player) local Name = GetChaDefaultName(Player) local String = "SELECT guild_id FROM GameDB.dbo.character WHERE cha_name = '"..Name.."'" local Connect, ConnectID = LuaSQL("connect", SQL.GameDB.Host, SQL.GameDB.User, SQL.GameDB.Password) if Connect == SQL_SUCCESS_WITH_INFO then local Success, Query = LuaSQL("query", ConnectID, String) if Success == SQL_SUCCESS_WITH_INFO then local Data = LuaSQL("fetch", ConnectID, Query) LuaSQL("freehandle", ConnectID, Query) LuaSQL("close", ConnectID) return Data["guild_id"] end end end function GuildLeaderID(Player) local Guild_ID = GetGuildID2(Player) local String = "SELECT leader_id FROM GameDB.dbo.guild WHERE name = '"..GuildID.."'" local Connect, ConnectID = LuaSQL("connect", SQL.AccServer.Host, SQL.AccServer.User, SQL.AccServer.Password) if Connect == SQL_SUCCESS_WITH_INFO then local Success, Query = LuaSQL("query", ConnectID, String) if Success == SQL_SUCCESS_WITH_INFO then local Data = LuaSQL("fetch", ConnectID, Query) LuaSQL("freehandle", ConnectID, Query) LuaSQL("close", ConnectID) return Data["leader_id"] end end end function GetChaGuildLeaderID(Player) local leader = GetLeaderID(Player) local cha_id = GetChaID(Player) if leader == cha_id then return 1 else LG("LuaSqlErr", "GetLeaderID Failed", "\n") return 0 end end **UPTADE**

Make sure you have LuaSql dll set on your files, and inside functions.lua set the value of the following variables: SQL.GameDB.Host, SQL.GameDB.User, SQL.GameDB.Password, SQL.AccServer.Host, SQL.AccServer.User, SQL.AccServer.Password and paste the script ximboliex released Then just call the functions: GetGuildID2(Player) will return the GUILD ID of a player and function GetChaGuildLeader(Player) will return the id of the leader of that guild

Open mapinfo.txt and copy a different map line and replace u chaos argent map and change the mapname, minimap name and mapid accordingly to chaos argent. To remove all object of the map, u can just delete the .obj map file inside ur client>map>map-name-u-want-to-delete-object

How to add a new npc? 1. [*] Go to resourse/MapName/MapNameNpc.txt For example, this is my map npc: owlnpc.txt //Each line is explained here //Serial NPC Name NPC Type Chrindex ID Show Mini-map Coordinates starting point Coordination Goal NPC placement Region Region ID NPC Script info manage Test Status 0 Legendary Guide 1 778 13 15100,10100 15100,10100 180 Owl City 1 0 NewbieGuide 0 [*]Add a new npc: //Each line is explained here //Serial NPC Name NPC Type Chrindex ID Show Mini-map Coordinates starting point Coordination Goal NPC placement Region Region ID NPC Script info manage Test Status 0 Legendary Guide 1 778 13 15100,10100 15100,10100 180 Owl City 1 0 NewbieGuide 0 1 New Npc 1 YY 13 XXXX,XXXX XXXX,XXXX EEE WWWW 1 0 NewNpc 0 YY = You can choose in characterinfo.txt ( resourse/characterinfo.txt ) Optional : You can use &summon to see the character texture if you want to choose. For example: I want to my "New Npc" looks like Wu Xin, in my characterinfo Wu Xin = "733", lets &summon. So in this case YY = 733. XXXX,XXXX = Coords to place npc. You can get them with &qcha "Your character name" . For example: So in this case XXXX,XXXX = 27125,38075 EE = Its where you want to your npc look. Play with it. For example: In this case i want to my npc look to the sea. In my case EE= 120 WWWW = Your map city name. You can find it in resourse/areaset.txt. In my case WWWW = Owl City NewNpc = Npc function, you can add it in resourse/script/MisScript/NpcScript01.lua (you can add in any NpcScript0X.lua) In this case: function NewNpc () Talk( 1, "Well Done!" ) end Well, lets set the npc. resourse/MapName/MapNameNpc.txt //Each line is explained here //Serial NPC Name NPC Type Chrindex ID Show Mini-map Coordinates starting point Coordination Goal NPC placement Region Region ID NPC Script info manage Test Status 0 Legendary Guide 1 778 13 15100,10100 15100,10100 180 Owl City 1 0 NewbieGuide 0 1 New Npc 1 733 13 27125,38075 27125,38075 120 Owl City 1 0 NewNpc 0 And here is it!: I made this guide because a @soilder12 request! Good luck!.

Thank you @Ximboliex for useful release! The topic has been moved to Server Releases section.