Zugg Software :: View topic - Frustrating database problems... [Solved]

Posted: Fri Jan 16, 2009 7:31 am

All scripts/outputs will be at the bottom.

I've been working with the database for a couple of weeks now. Decided to try something new, and for the most part, I've got it down. There are just a couple problems I cannot seem to solve.

1. The pipeline character, of course, is used to designate a new column, basically. So... Name=Blah blah blah|Level=232|etc... works as intended. The problem I'm having is that sometimes, the name itself contains a pipeline. Now, as you'll see in my script, I've managed to semi-get around it. It's not satisfactory, though, and I wish it to be done the way that it should be done. What's currently happening is that all of the names are encased by quotation marks, so in any view, I see "Blah blah blah" instead of Blah blah blah. I want to get rid of those quotation marks. The problem with that is no matter what I try, it doesn't capture pipelines correctly. I've tried escaping them, no avail. I've tried replacing them, then re-replacing them. No avail. I've even tried using the ascii code for pipelines in a replace. Still didn't work. Take, for instance, (K)(M)(G)(H) \|/ Auspices of the Druids \|/ (1). If I escape the pipeline characters, then it shows up as (K)(M)(G)(H) \~ for the Name. Everything else is lost. If I try any other method I've tried, then it returns: (K)(M)(G)(H) \ for the Name. As you can see, this isn't helpful at all. Any solutions that do not require me to have it quoted in the database itself? Or could this be considered a bug? *sigh*

2. Since it's an equipment database, I'll frequently update the information. The problem is, I don't want to enter in information that's already there, as it's just a redundancy and is not needed. Each item has its own unique serial number, so I'm trying to check to see if the serial number in the script matches a serial number already in the database. I cannot seem to get it to work. I've tried the following:

Posted: Sun Jan 18, 2009 2:16 am

Well, I figured out how to do the serial number matching, so item 2 is now crossed off.

The answer for that was to use an #IF (%ismember(%1,%dblist(Serialnumber,All))) {blah blah blah}.

Works perfectly. Now, can anyone suggest something for the pipeline character?

Charneus

Posted: Sun Jan 18, 2009 2:47 am

could you try... storing the value to a $localvar
it would then seem to be a string list
then maybe pass it %expand($localvar)?

SubAdmin Joined: 18 Nov 2001 Posts: 5182

$KeyValue=%subregex(%2, "@(?:y|b|m|g|w|c|r|d)?(\|)?","(?(1)¦)")

Use the alternate pipe symbol, it should be the same in nearly all fonts.

Posted: Sun Jan 18, 2009 3:58 am

Vijilante: Yours worked nearly perfectly. It still didn't get the \|/ Auspices of the Druids \|/ or an <|Amazonian-Battle-Mask|>. But it matched <*><|Fenris Fangs|><*> and similar items.

By the way, thanks for simplifying the %replaces for me.

Shalimar - give me an example of what you mean. :P

Charneus

SubAdmin Joined: 18 Nov 2001 Posts: 5182

I love it when I make mistakes and post them. It reminds that I am still human.
$KeyValue=%subregex(%2, "@(?:y|b|m|g|w|c|r|d)|(\|)","(?(\1)¦)")

Posted: Sun Jan 18, 2009 4:15 am

Heh... well, here's what it outputs now:

(?()¦)C(?()¦)r(?()¦)y(?()¦)s(?()¦)t(?()¦)a(?()¦)l (?()¦)E(?()¦)a(?()¦)r(?()¦)r(?()¦)i(?()¦)n(?()¦)g (?()¦)of (?()¦)D(?()¦)i(?()¦)v(?()¦)i(?()¦)n(?()¦)i(?()¦)t(?()¦)y

As you can see... that's not really correct, either. :P I do appreciate all the help you're giving! This time, it only appears on items with the @(whatever) (color codes).

Charneus

Posted: Sun Jan 18, 2009 4:22 am

Hmmm... entering:

Posted: Sun Jan 18, 2009 4:40 am

Got it... placing it in the trigger that has the #NEW and changing it from %concat("Name=",%db...) to %concat("Name=",%subregex(%db...) worked great.

Thanks again, Vijilante. By the way, your first code was the correct one. So, in thinking that you were wrong, you wound up being wrong. :P

Charneus

SubAdmin Joined: 18 Nov 2001 Posts: 5182

The first one had both pieces optional instead of being in an alternation, but had the conditional replacement right. I swapped mistakes with the second one. I have been away from CMud for too long, and am still far too human. I will have to work on both of these maladies.