Zugg Software :: View topic

Newbie Joined: 30 Nov 2002 Posts: 8

I have a bot that periodically checks for new chars. When he finds one thats not on the list, he adds their info to a database (name, level, class, club, lastonline(time)) It works very well, doesn't create any duplicate entries or anything. The problem is, chars change all the time, I was trying to make a way to update the info.

When I check for new chars, if they are on the list I want to be able to edit their info so that the list is up to date, but when I try to do this it decides to put random people's info in instead... basically I need to find which record the person is in, then change a few of the keys for that record. Thanks for any help, this is getting to the frustrating stage...

Newbie Joined: 30 Nov 2002 Posts: 8

Well, I sorta fixed my problem. I figured out that it was because at the time, I had it ordered by name, it was figuring out the location of the name by what record it was in, then placing the info by what row it was in (record is actual location in db, row is current location so if you have it ordered by name or whatever, record num and row num aren't going to match up.)

Now that I know this, does anyone know of a way so that I can write info by the record num and not row num, or osmething like that so that I don't have to worry about messing it up again on accident? Thanx. by the way here is the alias I use to update the info:

#DBPUT %find( @tempname, all) {Level=@templevel|Class=@tempclass|Club=@tempclub|LastOnline=%time( ddddd):%time( tt)}