Noob- Quest npc change account status?+

[busyallnightill6]

Hello there everyone, I am currently developing my own server and need some help with certain things I have encountered. Any help would be greatly appreciated. And Yes i have searched the forums, but apperantly some items I'm dealing with have 3 letters words so i can't find the particular posts. :P

Please place the number of the question you are answering so i don't get confused ^_^

1. I would like to change my requirements for certain commands. For instance i would like a status of 10 to find and summon items. I have tried changing it in the database and logging on with my laptop-status 10 account and summon works but find isn't :(

2. I would like a quest npc to change an accounts status for example: When Player1 hails npc1 his client-account-something is changed from 10 to 0. I don't think this is possible since npcs only work with names, but thought i'd ask.

3. A workaround to this, maybe #finditem is allowed and the person tells npc1 the number and the npc summons and places/hands the item to the player.

4. Sometimes when attacking another player the zone crashes, any ideas?

5. A friend plays on my server also, but when he casts spells he seems to crash. My thoughts are: his spell.txt and (other file) are corrupt or to new/old. My spell.txt are currupt or to new/old. Hes casting level 66+ spells that might not work correctly? Hes downloaded KMRA.

I think those are all for now. If you need screenshots plz let me know. Thanks ahead@!

[busyallnightill6]

6. I would like everyone who dies to go back to level 1. Where do i edit exp loss from a death? Also how do i set player vs player deaths to give this exp loss?

[busyallnightill6]

Any ideas guys? I think my title is making people not look.

[AndMetal]

Originally Posted by busyallnightill6

1. I would like to change my requirements for certain commands. For instance i would like a status of 10 to find and summon items. I have tried changing it in the database and logging on with my laptop-status 10 account and summon works but find isn't :(

If you're referring to just #find as a command, I don't think it's a command included with the latest build:

Output from SQL command SELECT command FROM commands WHERE command LIKE '%find%'; ..

finditem
findnpctype
findspell
spfind

However, if you're referring to #finditem, make sure it's actually set into the database (SELECT access FROM commands WHERE command = 'finditem'), then reboot your server. That should take care of the problem.

Originally Posted by busyallnightill6

2. I would like a quest npc to change an accounts status for example: When Player1 hails npc1 his client-account-something is changed from 10 to 0. I don't think this is possible since npcs only work with names, but thought i'd ask.

The closest you can get to this, currently, is having access to the current player's account status through the $status variable (info can be found here and here). Unfortunately, there isn't anything that allows changing of the status. The #flag command can be run in-game, so I'm sure it wouldn't be EXTREMELY difficult to add support for it into the quests, but it would require some code tweaking.

Originally Posted by busyallnightill6

3. A workaround to this, maybe #finditem is allowed and the person tells npc1 the number and the npc summons and places/hands the item to the player.

I'm pretty sure that's doable, although I'm not 100% sure how you would do it with Regular Expressions. I messed around with it a little, but never came up with a working solution.

Originally Posted by busyallnightill6

4. Sometimes when attacking another player the zone crashes, any ideas?

It's been reported to me on my server that players crash (possibly the zone?) when attacking each other in the arena, but after updating to CVS PEQ DB & Quests, I'm not sure if it's still happening or not.

Originally Posted by busyallnightill6

5. A friend plays on my server also, but when he casts spells he seems to crash. My thoughts are: his spell.txt and (other file) are corrupt or to new/old. My spell.txt are currupt or to new/old. Hes casting level 66+ spells that might not work correctly? Hes downloaded KMRA.

The first question I would ask are what sizes are the spells_us.txt files that you are each using (for the server, and for the client)? Also, do you use any custom spells?

[busyallnightill6]

Thanks very much for the help!!! What do you think about question 6.. my first reply. Will be testing other things shortly. Now I'm not a coder or very good at this at all, but i love EQ :P but i was hoping maybe something along the lines of:

(Not real format)- Quest::npc say ("#flag status accoutname) but is there a way for a npc to see the account name??

Now for the first question, I have navicat right now what table can i edit? I see a commands table but when i change #finditem #summonitem to status of 10 and make an account status of 10 they don't show up in #help however lots of other commands do that i don't want people to have.

Serverside:

spell.txt = 4.50mb or 4615kb
spells_en.txt = 2.5mb or 2,100kb

[busyallnightill6]

Anymore ideas?

Questions still unanswered:

Question 1 was kind of answered but I didn't understand what AndMetal was saying but thank you very much for posting. Preferably a file i can open with notepad, or a database because i don't know how to change using command-line commands-

1. I would like to change my requirements for certain commands. For instance i would like a status of 10 to find and summon items. I have tried changing it in the database and logging on with my laptop-status 10 account and summon works but find isn't :(



2-5 I'm giving up on for now so i can get the server up and playable.

6. I would like everyone who dies to go back to level 1. Where do i edit exp loss from a death? Also how do i set player vs player deaths to give this exp loss?

NEW- 7. I'd like players not to zone into certain zones, I don't want to remove the zoneline completely. I changed the flag for a zone but they zone in and auto zone into arena. I don't want players to run away.

Thanks again