Search:

no, no, no. I'm sure that you just need to click on the "show all" check box while viewing the table data

Is there a project similar to ncdb that works on getting the scripted instances working?

yes its possible, look for your self

its a great private server secret that we don't want everyone having.

and YES, you can find it.

which entry in the item table controls if the effect is applied on equip or on use

exactly, but i want to make an item that works just like a mount, but has a different icon and some other edits

i know how to make items pretty well, but how would i make an item that can't be equip toggle an effect on or off by right clicking on it?

if you're using sqlyog, you can just paste the code in the field in the top right and right click>execute query>exequte all queries

yeah, i run a fun server, but thanks for the support. if anyone else has some funserver updates, please share

figured it out from the MYSQL forums

UPDATE `items`
SET `maxcount`='999'
where `maxcount`>'1';

I think that It would be a good idea to have a thread that contains some useful SQL edits, not major updates, just some things to make the game play more enjoyable.

Here's to start off,

This...

yeah, i get it to work, but when i log off it is gone

nope, that still gives a syntax error

thanks, but i don't want to set anything that has a value of "nothing", 0, or 1 to 999, just anything that has a value greater than 1

help?

help?

yes, i'm working on a mod for this, and when its ready, i'll post it it is made JUST for ascent.

just to be clear this site ALREADY supports ascent, i'm just making the ascent better

no, that's actually what i have mine set at and i don't have a super computer, 5min=300sec

open logonserver.conf and go to rates accountrefresh="x" and set it to the time in secs you want it to refresh. It should be set at 600 which will refresh every 10 minutes, this is good and you...

i'm trying to make all stackable items stack to 999, and leave weapons and the like alone.

UPDATE `items` If `maxcount`>'1' then SET `maxcount`='999';

that is the query that i tried, it dosen't...

i double/tripple checked that i have the latest rev of ascent and ncdb, and the pet dosent stay. If i go to a pet keeper, my pet dosen't even show up as a current pet.

I think so, i have ncdb 0.2.3, then i updated with the latest rev, and applied all of the sql updates. I'm also running ascent 2424. Could you possibly tell me table update it was?

aarg! I really want this to work, I'm spending my time clearing the cooldowns from the DB, so if some one could help me with this i would apprishiate it. I'm only looking to fix the GM command to be...

I still need help please

umm, i'm not very sure this is a DB issue, there must be a command to do this

when i try to make a pet, it works fine, but as soon as I log off, its gone! how do i make a perminent pet, even with my non hunter character?

thanks

p.s. if i do a .pet createpet <creatureid>...

I'd like to add Foror's Crate of Endless Resist Gear Storage to the list so that the GMs and donating members can have it. how would i go about finding this and doing it myself?

I did a clean install with 0.2.3 then the latest revision and updates and everything works 100%

does anyone know?

ok i did, but ascent starts up and crashes, i didn't see any errors while compiling.

When i complie using the steps in the ascent wiki, i get wierd files like ascent.exp, ascent.lib, and ascent .pdb

i do use the ones provided here, but i want to try some code mods that i've made...

I've seen a topic about speed, but what kind of bandwidth would 500 players take up, in a month (Gigabyte/megabyte wise).

if you are, right click on the table you want to edit and on the bottom is a view data option

phpnet.us is the best one that no one ever finds

IMHO krillins www frontend is the best for ascent so far, if you want mangos, then webwow is the one for you. I agree with gmaze that they take up system resources, so only use them if you have an...

i found that it has to do with the fact that php4 which i guess krillins is coded in dosen't support the password hashing in mysql 4.1 and above. i found this tutorial on the mysql site, but when i...

I downgraded to 5.0 and i still get the same issue

When I try to use Krillins front end i get this error

Client does not support authentication protocol requested by server; consider upgrading MySQL client

Here is my Server's site...

Ok, i think that I have the major part of ascent figured out, i can connect and play and everything is working great, i just have a few minor questions.

1, i'm trying to train my tauren warrior...

I'm guessing that you're just alpha testing your server, so you should start from scratch, drop all of your dbs, delete all of you ascent files, except for the maps and dbs folder, and reconfigure...

I'm also having a problem buying a mount, at least from the vendor for tauren