SetName & Delete Bic for PCs

[Extreme]

Im not sure where to look for this so i figured i would just start a new thread. Im asking this for another server, but it is somethign i would like to learn mysef. And if information on this exists, can i please be redirected.

Is there a SetName function within SimTools that will change the name of a PC, not only in the bic, but also within the database?

And is there a way to make the DeleteBic able to remove the char entries from the database.

The database is Mysql

[FunkySwerve]

Nope, that would have to depend on your particular database configuration, so it's not possible to release in a public system. Both setname and delete commands are possible, but you'll have to code them yourself to fit your database setup. A simple bic deletion command is already packaged with SIMTools, so you'd just have to modify it to wipe your entries.

Funky

[Extreme]

Thats a bummer. im not a database person so i would not know where to begin that. some of your scripting still baffles me

[illandous]

Select * from table Uber

returns
Stormchaser

[mdf]

Hi Extreme,

This might not be the 'best' option, but early on I preferred working with mySQL because the documentation and information was easy to find. And many LAMP (Linux, Apache, mySQL, PHP) server configs have a mySQL admin gui that will let you perform many functions without knowing the SQL syntax. Most server admins DO prefer a minimalist approach with no gui, but for someone new to databases having a GUI or webmin-like tool will make things much easier for you, especially when learning what tables and fields are used and what values are contained therein.

Hope that helps.

[baaleos]

Hi uber,

The syntax you would need would be along the lines of

sName = GetName(oPC);

then you would use the sql command, cant remember it.

SqlInit("Delete * from users WHERE playername ='"+sName"';");

This would delete all entries, in theory, associated with playername of sName.

[baaleos]

Might be best to use CDKEY though, because players could make identical character names, to delete another players entries.

[FunkySwerve]

Nov 20, 2008 9:50:52 GMT baaleos said:

This would delete all entries, in theory, associated with playername of sName.

Only if that's how his database was set up. It's entirely dependant on how you've organized it.

Funky

[FunkySwerve]

Nov 20, 2008 9:51:44 GMT baaleos said:

Might be best to use CDKEY though, because players could make identical character names, to delete another players entries.

The easiest way to prevent that would be to use playername rather than cd key, because players would lose tags if they swapped keys under that system. Unfortunately, that still leaves open an ex)plo_it allowing characters to swap tags by making same-named characters. We get around this on HG by making a unique id and marking the character with it, and then linking database entries to the uid, rather than a pairing of playername and character name, which is the way nwnx's default system does it.

Funky