Zugg Software :: View topic

Newbie Joined: 17 Apr 2005 Posts: 5

Ok, here's the situation, I'm an Imm on a mud, and in order to help crack down on various cheating a fellow Imm created this trigger to keep track of our player base's IP's, allowing us to quickly check to see if things are kosher.

The problem is that the database keeps track of *every* entry, and so you wind up with countless duplicates and over a short period of time I'm stuck with 10,000 plus entries, when I get that many, my computer just lags down each time the database is loaded. What I wanted to know is if there was any way to fix these triggers to prevent duplicate entries based on the IP to cut down on this massive database that I have to keep clearing out. And as a bonus, is there anyway to make a second alias that will scan the database based on the characters names along with the one show that scans based on the IP.

Here are the triggers.

#trigger {(%w)~[(*)~] has connected.>} {#dbload pl;#new pl %2 %1;#dbnext;#echo %2 %1;#wa 500;#dbsave}

#trigger {(%w)~[(*)~] ~(Guest~) has entered the game.>} {#dbload pl;#new pl %2 %1;#dbnext;#echo %2 %1;#wa 500;#dbsave}

#alias {ipchk} {#dbload pl;#find %1;#dbload pl}

Thanks in advance for any help, hope I got my question across clearly enough.

Wizard Joined: 14 Oct 2000 Posts: 1368

Check my database tutorial at http://www.silverbridge.org/~varmel/zmud/tutorials/zmuddb.htm which explains how to handle duplicates.

Newbie Joined: 17 Apr 2005 Posts: 5

Thank you so much, that will be a lot of help.