[Release] Random treasure event

Ok so this is going to be a scattered release as I don't plan on going through my source and finding every possible thing you could ever need. If there are problems post away and I may help but for the most part you will be on your own to get this working.

What is this?
This is a quest/event I designed at like 4 am one night when I couldn't sleep after getting pissed off at all the BAD quests released (not pointing fingers... but you all gotta admit there have been some very pointless quests)

What does it do?
This event consists of treasure boxes (currently using Lotto boxes as I didn't feel like searching through all the possible npcs, you can change them to whatever you want though).

These treasure boxes spawn randomly around the game world producing a msg to all the server telling people what town it's near (Note: added a system to convert map ID to Name for use with this type of thing... if there is such functionality built into CoEmu I didn't see it.. again it was 4 am though). When used the box will despawn and award the user with a random prize and (assuming the event is still in progress), respawn somewhere else in the game world.

Locations are stored in a SQL database (refer to my random teleport release, it's the same system. This is the type of stuff I designed it for, I just didn't feel like coding anything past the actual db itself at that point)

Well that's cool, how do I customize it?
Simple enough, everything is somewhat labled and I've included some handy commands to start/stop the event (doing it via times of day or counting how many boxes are allowed to be spawned per event is up to you. It's simple enough to do but I'm done coding for a little while), commands to add new points easily to the random location database as well as being rather easy to customize in the first place.

The Release:
Note: CoEmu 5095, not releasing or converting it for lotf, that's up to you guys.

Part 1: Refer to my Random teleport release for further instructions on how to set this up but for extra help I'll release what I can remember of it here.

Database>Database.Cs

Spoiler

PHP Code:


			
public static void GetRandomPortal()
        {
            lock (DatabaseConnection.NewConnection())
            {
                MySqlCommand Comm = new MySqlCommand("SELECT * FROM `randomportal`", DatabaseConnection.NewConnection());
                MySqlDataReader RD = Comm.ExecuteReader();
                while (RD.Read())
                {
                    Struct.RandomPortal RandPortal = new Struct.RandomPortal();
                    int PortalUID = Convert.ToInt32(RD["PointUID"]);
                    RandPortal.PortalMap = Convert.ToUInt16(RD["GotoMap"]);
                    RandPortal.PortalX = Convert.ToUInt16(RD["GotoX"]);
                    RandPortal.PortalY = Convert.ToUInt16(RD["GotoY"]);
                    try
                    { Nano.RandomPortals.Add(PortalUID, RandPortal); }

                        //(RandPortal, PortalUID); }
                    catch { }
                }
                RD.Close();
            }
            Console.WriteLine("[GameServer] Loaded " + Nano.RandomPortals.Count + " Random Teleports loaded.");
        }


public static void AddRandomPortal(int NewPortMap, int NewPortX, int NewPortY)
        {
            try
            {
                lock (DatabaseConnection.NewConnection())
                {
                    MySqlCommand Cmd = new MySqlCommand("INSERT INTO randomportal(GotoMap, GotoX, GotoY) VALUES(" + NewPortMap + "," + NewPortX + "," + NewPortY + ")", DatabaseConnection.NewConnection());
                    Cmd.ExecuteNonQuery();
                }
            }
            catch
            {
                Console.WriteLine("Error: Could not add Random portal to Database!");
            }
        }

nano.cs

Code:

public static Dictionary<int, Struct.RandomPortal> RandomPortals = new Dictionary<int, Struct.RandomPortal>();

and

PHP Code:


			
public static bool HuntNpcUsed = false;
        public static int HutnNpcToSpawn = 0;
        public static bool NpcHuntOn = false;
        public static bool NpcHuntSpawned = false;

and down @

Code:

Struct.LoadTNpcs();

put

Code:

Database.Database.GetRandomPortal();

Now: I have a handler file called functions to store any new stuff I'm adding so you will wanna add one. Name it what you want but mine is Handlers>Functions.cs. Here is the full file with the applicable info in it

Spoiler

PHP Code:


			
using System;
using System.Collections;
using System.Collections.Generic;
using CoEmu_v2_GameServer.Connections;
using CoEmu_v2_GameServer.Entities;
using CoEmu_v2_GameServer.Structs;
using CoEmu_v2_GameServer.Packets;
using CoEmu_v2_GameServer.Calculations;
using System.Threading;

namespace CoEmu_v2_GameServer.Handlers
{
    public partial class Handler
    {
        public class Functions
        {
           
            public static void SpawnNpc(int id, int type, int subtype, int map, int x, int y, int direction, int flag)
            {//blabla
                {
                    {
                        Structs.Struct.NPC NPC = new Structs.Struct.NPC();
                        NPC.Direction = direction;
                        NPC.Flag = flag;
                        NPC.ID = id;
                        NPC.Map = map;
                        NPC.SubType = subtype;
                        NPC.Type = type;
                        NPC.X = Convert.ToUInt16(x);
                        NPC.Y = Convert.ToUInt16(y);
                        if (Nano.Npcs.ContainsKey(NPC.ID))
                        {
                            while (Nano.Npcs.ContainsKey(NPC.ID))
                                NPC.ID = Nano.Rand.Next(100, 10000);
                            Console.WriteLine("Npc Id in use, selected random id: " + NPC.ID);
                        }

                        Nano.Npcs.Add(NPC.ID, NPC);
                        foreach (KeyValuePair<int, ClientSocket> Clients in Nano.ClientPool)
                        {
                            if ((int)Clients.Value.Client.Map == NPC.Map && Calculation.CanSee(NPC.X, NPC.Y, Clients.Value.Client.X, Clients.Value.Client.Y))
                            {
                                Spawn.All(Clients.Value);
                            }
                        }

                        Console.WriteLine("Successfuly added npc to server");


                    }


                }
            }

            public static void DespawnNpc(int RemovalType, int ID)
            {//blabla
                switch (RemovalType)
                {
                    case 1://Npc Type
                        {
                            foreach (KeyValuePair<int, Struct.NPC> LoopId in Nano.Npcs)
                            {
                                if (LoopId.Value.Type == ID)
                                {
                                    Nano.Npcs.Remove(LoopId.Value.ID);
                                    Console.WriteLine("Found type in for each loop! " + Convert.ToInt32(LoopId.Value.Type));
                                    break;
                                }
                            }
                            break;
                        }
                    case 2://Npc Id
                        {
                            Nano.Npcs.Remove(ID);
                            Console.WriteLine("Removed Npc ID: " + Convert.ToString(ID));
                            break;
                        }
                }


            }

            public static void SpawnHuntNpc()
            {
                int PointTouse = Nano.Rand.Next(0, (Nano.RandomPortals.Count));
                Struct.RandomPortal RandPortData = Nano.RandomPortals[PointTouse];
                int NpcUid = Nano.Rand.Next(100, 10000);
                Handler.SpawnVoid.SpawnNpc(NpcUid, 105051, 9277, RandPortData.PortalMap, RandPortData.PortalX, RandPortData.PortalY, 2, 0);

                ConquerPacket.ToServer(ConquerPacket.Chat(0, "[NpcHunt]", "ALLUSERS", "Treasure has spawned somewhere near " + MapToName.IdToName(RandPortData.PortalMap), Struct.ChatType.Center), 0);
                Nano.HuntNpcUsed = false;
                Nano.NpcHuntSpawned = true;

            }
        }
        
    }
}

Handlers>NpcTalk.cs

Spoiler

PHP Code:


			
case 105051://Hunt npc quest!
                    {
                        if (LinkBack == 0)
                        {
                            if (!Nano.HuntNpcUsed)
                            {
                                Nano.HuntNpcUsed = true;
                                bool rewarded = false;
                                if (CSocket.Client.Inventory.Count < 40)
                                {//Note: All drop calculations go here. Convert to a function if you want, I was lazy. This works fine for now. 
                                    if (Calculation.PercentSuccess(40))
                                    {
                                        AddItem(720027, 0, 255, 0, 0, 0, 0, 0, 0, CSocket, 1);//met scroll
                                        rewarded = true;
                                    }
                                    else if (Calculation.PercentSuccess(50))
                                    {
                                        AddItem(723834 , 0, 255, 0, 0, 0, 0, 0, 0, CSocket, 1);//db
                                        rewarded = true;
                                    }
                                    else if (Calculation.PercentSuccess(35))
                                    {
                                        AddItem(720028, 0, 255, 0, 0, 0, 0, 0, 0, CSocket, 1);//db scroll
                                        rewarded = true;
                                    }
                                    else if (Calculation.PercentSuccess(25))
                                    {
                                        AddItem(723834, 0, 255, 0, 0, 0, 0, 0, 0, CSocket, 1);//exp ball
                                        rewarded = true;
                                    }
                                    if (rewarded)
                                    {
                                        Text("You've found me! Please take this reward.", CSocket);
                                        Link("Thanks!", 255, CSocket);
                                        End(CSocket);
                                    }
                                    else
                                    {
                                        Text("Awww, you didn't get a reward this time.", CSocket);
                                        Link("Damnit!", 255, CSocket);
                                        End(CSocket);
                                    }                                  
                                    if (Nano.HutnNpcToSpawn > 0)
                                    {
                                        Handler.SpawnVoid.DespawnNpc(1, 105051);
                                        Nano.HutnNpcToSpawn -= 1;
                                        Handler.Functions.SpawnHuntNpc(Nano.HutnNpcToSpawn);
                                    }
                                    else
                                    {
Handler.SpawnVoid.DespawnNpc(1, 105051);
                                        ConquerPacket.ToServer(ConquerPacket.Chat(0, "[NpcHunt]", "ALLUSERS", " Treasure event has ended", Struct.ChatType.Center), 0);
                                        Nano.NpcHuntOn = false;
                                    }

                                }
                                else
                                {
                                    Text("Your inventory is full. Gotta be faster!", CSocket);
                                    Link("Damnit!", 255, CSocket);
                                    End(CSocket);
                                    Handler.SpawnVoid.DespawnNpc(1, 105051);
                                    HuntNpc.SpawnHuntNpc();
                                }
                            }
                            else
                            {
                                Text("Too bad someone else already used me!", CSocket);
                                Link("I'll be quicker next time!", 255, CSocket);
                                End(CSocket);
                            }
                        }
                        break;
                    }

Note: You may need to modify your add item void. This source has no real modifications to it so has no progress/free item/lock/etc

under Handlers>Chat.cs

Command to start the event

Code:

case "huntnpc":
                            {
                                Handler.Functions.SpawnHuntNpc(Convert.ToInt32(Command[1]));
                                break;
                            }

Commands to add new points to the database

Spoiler

Ooh and just so you have it, here's a command to teleport to one of the locations in the database (remove if you don't want people being able to use it to get to the npcs super fast)

Code:

 case "rantele":
                            {
                                int RandToUse = Nano.Rand.Next(0, (Nano.RandomPortals.Count));
                                Struct.RandomPortal RandPortData = Nano.RandomPortals[RandToUse];
                                Handler.Teleport(RandPortData.PortalMap, RandPortData.PortalX, RandPortData.PortalY, 0, CSocket);
                                Console.WriteLine("Map: " + RandPortData.PortalMap + " X: " + RandPortData.PortalX + " Y: " + RandPortData.PortalY);
                                break;
                            }

Ooh, and here's the VERY basic file to convert map ID to a map name.

Mine is Calculations>MapToName.cs but you can rename it, easiest if you just go with that though.

Spoiler

Also for convenience, here is the backup of my rand tele database file

note: it's nearly empty. I just added a few points for testing. Give it a try though, everything should work just great.

For the record, to start it (unless you code it to auto start which is easy enough to do)

/huntnpc (amount for quest)

To add new locations to the database

Current character location
/newrandme

or

/newrand map x y

<edit>

Update: tested with the new upgrade. Everything works fine now

Update: removed box when event ended (it was not a problem as it only gives prize once regardless of if it moves but still, it's better that way)

Note: The whole teleporting the clear the screen thing was again my own lazyness. It was not updating my screen properly (I tried a few methods) and instead of looking into it more I decided to just leave it as it works now.