Just an idea...

[TheOnlySun]

I've been playing on a lot of private servers now and there are some good ones, but some are just still not populated enough to be fun. Now, it could say have like 15 people but if they're scattered throughout the hundreds of maps then it'll still feel empty. I propose a sort of "Mini-Redmoon". This idea consists of including only a few leveling maps such as Street2 - BY. If you could create custom monsters and place them throughout the maps then it could still last you quite a few levels. What I mean is insted of just having the regular gangster - spys in street2, you could put it all the way from gangster - cyborgs; easiest monsters closetest near the town of course, and the harder ones near the corners. You can probably even limit the level by means of limiting the hardest monster. Just think, if the hardest monster were espers in the backyard then most people won't get past 400, therefore creating a smaller and more socialable atmosphere. I highly doubt in any private redmoon server getting populated enough to be as fun as the original Diosa, but if you can generate the same kind of feeling then it's just as good.

[MentaL]

[Nickyy]

Thats why on Daydream we have a players online page that tells you the players, their levels , and their skin so its easier to form groups, check for friends online , etc

[TruSun]

daydream sux

*Link edited by Miles* - don't post information on servers in threads

[holmancarey]

Thats why on Daydream we have a players online page that tells you the players, their levels , and their skin so its easier to form groups, check for friends online , etc

To bad 3.8 doesn't have the OccupiedGameID table like 4.x. I've tried recreating it but without the procedure to tell it to put the data there it's kinda useless. I've looked through all the 4.x procedures trying to see what does it but no luck so far. I'm sure it's probably something simple I'm missing. Only other thing I can think to do is make a players online page that has all the players owned by those logged on but it's kind of decieving looking to have 3 times the amount of players that are actually online to someone that doesn't know how the page is made, lol

[Nickyy]

There isnt a SQL procedure in the database that inserts the players names in 4.4, the server software itself has the embedded function which periodically repopulates that table. Really the best you could manage on a 3.x server is creating a trigger on the Gameid table to populate a players online table, it wouldnt be a perfect solution as the player would have to be actually doing something like leveling, changing maps, using bp's etc etc for it to detect the player for the first time.

daydream sux

*Link edited by Miles*

I wonder if the 6million popups and advertisements on the site are yeilding them any money....

[holmancarey]

That makes me feel better not being able to find it, lol. A trigger's a brilliant idea. I have figured out how to get triggers to do simple things like deleting a character when a stat is changed higher than a certain number or removing status effects from a character when they enter a map. As far as making one that would recognize a change and write to a different table I'm gonna need to do a lil more reasearch to figure that out. Most of what I've been reading on triggers here lately is pretty dry, the basics always are tho ehh

Always up for a new challenge ;) thanks for the reply

[TheOnlySun]

Bump...
Got bored over vacation, saw Zach's guide, am trying to recreate it myself. Don't think it'll go too great, even if I got stuff working my connection/comp ain't great enough to host a server. Just want to see if it can be done though :D.

[4nntt]

Maybe you could add a DateTime field to Gameid with a trigger that populates it with the current server time when it is updated.

Then you could take the logged on users and for each one grab the gameid with the most recent update date?

[4nntt]

Hi all,

I've added a field to tblOccupiedBillID called GameID as Varchar (14), and added a trigger to tblGameID1 to populate it with the last updated game ID.

It's not perfect, as tblGameID1 doesn't get updated until you kill something, but it's close enough for my needs.

Here is the trigger code:

CREATE TRIGGER [Update GameID in tblOccupiedBillID] ON [dbo].[tblGameID1]
FOR UPDATE
AS

DECLARE @BillID AS VarChar(14)
DECLARE @GameID AS VarChar(14)

SELECT @GameID = GameID FROM Inserted
SELECT @BillID = BillID FROM Inserted

UPDATE tblOccupiedBillID
SET GameID = @GameID
WHERE BillID = @BillID

[holmancarey]

Hellz yea, works like a champ man. All I had to do that wasn't mentioned was to make the new GameID column allow nulls, which it tells you to do if you don't anywaz :P

Thanks for the trigger, and I have to say I can't believe how well it works with such a few simple steps.

Bravo!