Printable View
I tried your SQL file. Didn't seem to work.
Oh and BTW Channel, I would like to help you with anything new that comes out.
Like, maybe some fixes and spawning jobs for query's.
All I need to know is the basics of creating a query file.
I want to learn how to make query files so I can fix stuff but not only that, also to add new things.
yea...channel_49 may be doing one
or so i read
Yeah my bad..... i put Julian HAHAQuote:
Originally Posted by KingXCrosses
I was helping my friend out on his private server and was using Julian's repack....
query files are basically Set blahblah blah to blah blah blah = something i dont plan on using my time to do that lol
you could always open up a SQL file and take a look, and get an idea on how to do queries lol
Version 2.8 released: All vendors have been spawns in the HOUSE of GM Island, WARNING: the spawn query will first delete ALL spawn of GM vendors, make sure you either back them up or just delete the first line of the query.
k i'll be trying it out
tried it this is the message i got :(
Code:[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(entry, Map, x, y, z, o, movetype, displayid, factionid, flags, bytes, bytes2, e' at line 1
[Msg] Finished - Unsuccessfully
Fuk, I missed the table name in the query... >.> how stupid of me
Re-download 2.8, I fixed it.
lol? dont rush on beautiful masterpieces ;)
channel_49 ,
Dude , i love your work on vendors adn i appreciate it. If you could only add the spawns sql for spawning the vendors at champions hall and hall of legends , i would be really grateful!!! If not please tell me how i can do it myself.
Thanks!
I really want to get this to work, and I was able to extract and get Rev8 into the database just fine, but the vendors wont work, instead when I click execute it just freezes SQLyog and I end up have to close it using the task manager:( Any Suggestions?
Use .npc spawnQuote:
Originally Posted by jaggu
Use navicat.Quote:
Originally Posted by evansg4
Yeah, sorry lol, I didnt take the time to read through the endless posts =D, do you know if there are any free downloads of navicat, besides trials?
P.S. Thank you for replying so quickly, that almost never happens on forums
Also, is there anything I need to configure to make my server work with Navicat and get the database info from navicat instead of SQLyog?
Well I don't know what I am doing wrong, I got it all installed, i deleted my cache, and now my problems include:
I cant open any shops
All my characters are naked
When I make new characters, they are naked.
Could you tell me what happened!
EDIT: Ok i solved my problem!
Thanks for the awesome customs! Keep it up
There are no logs or errors, it says import successful (Im using SQYlog)Quote:
Originally Posted by channel_49
Usually it takes like 15 mins + to get the entire script run, but this is just flying through it in a few seconds and not really doing much (apart from importing the 300kb of data)
These are the steps ive taken
Install MYSQL correctly
Install SQYLOG
COnnect to database
create database
import TNDB 8
import character tables etc
import the custom_shop.sql from custom.shops.2.8 (which doesnt work properly) *will prior to 2.6 work on TNDB 8?) and then all other sql files
delete my cache
log in, no items (even from the vendors in gm island)
Use navicat. SQLyog cant seem to run the scripts properly.
Its just a sql manager like sqlyog, no configuration is needed server side.Quote:
Originally Posted by evansg4
Try BTing navicat, registered.
What's BTing, sry I'm new to private servers and this site. I would try and use the trial, except when I right click, the option to create a database is greyed out, and I think it's because that's not featured in the trial but idk.
Nevermind, got it to work with SQLyog. But Now I Can't get some of tier 5 and tier 6 to work because there is no buyprice, it just says item not found, is there a way to make it normal again?
i cant execute batch file with navacat? im at the custom shop buy price part..which apparently requires navacat..help plz
EDIT: Fixed, im just waiting for the buy price sql to finish..
Go to the currency vendor to the right of the tier vendors.Quote:
Originally Posted by evansg4
Takes about 10-20 mins on navicat.Quote:
Originally Posted by Phantom710
are you sure? mines been going for about a half an hour now..
Yea I'm pretty sure, if its takes too long then something is wrong, locked up maybe. Leave it on over night and see what happens, thats what I do when queries take too long.
i think somthings wrong now because when i tested a custom made item on sqlyog nothing shows up (and ive made custom made items and did this with sqlyog)..and that happens with the buy price..now its doing that for everything i try to execute that may be why the navicat isnt working right
Try older navicat versions, I don't like the new ones so I never use them.
oh im using the newest one
how u get a lower version?
Download it off places, emule maybe? lol
lol.. checked that site nothing.. this is complicated :(
Yea I can't post you any pirated software, so you're going to have to find a way to get it yourself.
YAYYYY lol! it worked : )
sorry wouldnt let me edit so im posting again..when i start ascent.exe this happens which is usuall..but it stays like that and goes no further and then when i connect theres no realm so..i installed all the things and executed and this is what it gets stuck at
http://img366.imageshack.us/img366/3...problemmt5.png
I'm thinking something isn't compatible with JulianX's repack with my vendors.
My guess is since it freezes at creature_proto, must be something in there.
Dump the creature_proto table and upload it somewhere, and I will have a look.
Don't give me the original, please give me the one where you already ran the queries in.
what do u know, i got on : ) gm island lots of vendors i like it
thanks alot for helping me hope i didnt waste to much of your time
just some stuff are not found tho
an unrelated question but do you know if it's possible for my friends to go on the server without me having to run logonserver.exe and ascent.exe? like say it is always on or something even when im not on my computer? i use hamachi to get my friends on my server if that helps
sorry for the double post but i have a big problem
i executed 2.8 into SQLyog and logged in... but there were no items none not even the clothes u start off with. there was with version 2.6 but there isnt now and in the items table in my db theres only 10 items:
Worn Shortsword
Bent Staff
Worn Mace
Worn Axe
Recruit's Shirt
Recruit's Pants
Recruit's Boots
Squire's Boots
Squire's Pants
Squire's Shirt
the vendors and npc's are all there just no items, what do i do?
reexecute your DB
thats what i would do :)
Ok, dont run that buyprice query with sqlyog, it seems it'll just mess up your db.
hey
I can t get this to work what do I need from Ascent Core: http://forum.ragezone.com/f114/lates...atabase-287088.
And for step 5 in the install 5) Run the extracted .sql file as a query.
Do I just go to file open then Execute all Queries?
Just to be sure my Database that is root@localhost or would it be ascent.
I got it never mind didn t download File Type: zip custom.shop.2.8.zip (24.3 KB, 72 views)
Says item not found for every item on every vendor, did I miss something? Maybe need to clear my cache?
EDIT: Ah, stupid me, made a new gm account and had no money. XD
what do i do when this happends:
http://img385.imageshack.us/img385/476/errorvo9.jpg
it says that i need to update something that i dont even have..
i deleted my Cache folder and it didnt help.. i tried everything and it didnt work.. =(
I know that, I'm saying that some of the items don't have a price, the icon for the thing you need isnt there for some of the items, also on the gladiator items, when I buy them it says item not found, do you know how to fix this?Quote:
Originally Posted by channel_49
Gladiator items u need arena points which arnt implemented in ascent.
Use custom_shop_buyprice to fix the price for items that dont have prices.
thanks
Version 2.9:
Added custom_shop_buyprice_extend.sql so people can get rid of itemextendedcost.
Revised custom_shop_buyprice.sql so now it should run fast, and
you won't get anymore freezes or wait time.
Thanks very much Channel.
Everything seems to be working great.
And I have made a portal to GM Island.
I might put it up on here for people if they would like.
Just got to make a SQL file... I hope I can do it right.
ill include it in the gm vendors if you upload a working one.
Oh that would be cool.
You think I should put it to where all the portals will also go to all starting places?
or maybe just into major cities?
Do you think you could give me an example for how to put objects into an SQL file?
Dump the whole table, plus the teleport coord table that goes with it, I'll just take it out of there.
Well, here you go = D
Code:insert into `teleport_coords` (`id`, `name`, `mapId`, `x`, `y`, `z`, `totrigger`) values('35718','Teleport to GM Island','1','16223.1','16250.9','12.4827','0');
3818.93','8.4107','0');
insert into `gameobject_names` (`entry`, `Type`, `DisplayID`, `Name`, `spellfocus`, `sound1`, `sound2`, `sound3`, `sound4`, `sound5`, `sound6`, `sound7`, `sound8`, `sound9`, `unknown1`, `unknown2`, `unknown3`, `unknown4`, `unknown5`, `unknown6`, `unknown7`, `unknown8`, `unknown9`, `unknown10`, `unknown11`, `unknown12`, `unknown13`, `unknown14`) values('55555','22','6956','GM Island','35718','35718','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0');
I had to edit that a bit just in case you copied it before I did.
This would involved dbc editing, I believe.
say again?
not sure what you mean by that.
Custom portals require you to edit the dbc files or use a predefined other portal spell.
hmmm... so do you want me to give you both files?
Or do you mean it can't be done?
It works on the server for me just fine.
I could start a forum called "GM Island Portal" and explain how to make it.
Should I do that?
Thanks, it's working now
Finaly I found someone that have Gm Vendors :busted_co Tnx for it
Version 2.9a:
Fixed a tiny bug in the custom_shop_buyprice_extend query.
Awesome, I'm going to try this update right now!
As a question: let's say I really liked the crystal-looking guys... what would I change in the statements to change the model id? I assume the 18106 is the model number? So, I'd just need to change that everywhere?
[EDIT]WOW! Process times decreased by an amazing factor, great job!
um sorry to ask but when i talk to tha vendors they are not responding, like i cant see what they buy cause the screen wont come up. thx in advance
Nvm figured it out.
when i click on the url you gave me its crushing my net..
can you give me a link to the file plz? =)
Very nice, I'll be testing this one out, thanks!
Well the update made it so that all of the items with no price could be bought, but it also made it so all of the items with a price could not be bought.
Can i get the query to set the buyprices to zero... and the arena vendors to zero please... thank you :)
custom_shop_buyprice_extend.sqlQuote:
Originally Posted by a7xdeity
I will look into this.Quote:
Originally Posted by evansg4
Filebeam - Free Fast File Hosting
this is the query channel_49 gave me (i think)
posted on the 2nd or 3rd page
The vendors with buyprice works just fine, you just need to have enough gold or required items to buy them. I just tested this.
ohhhhh i see now what he was asking for lol
If you want everything in the vendors free... download this attachment.
I'm also looking for some people who are good at making custom content for TerraNet custom, which I am going to form as an extention to the original TerraNet db, for those who use custom content.
what kind of custom stuff? Like weapons, armor, and stuff?
(just wondering)
Great Release!
Works perfect with NCDB. Looking forward to more :)
Anything actually, custom content can include anything.
Anyways if I get enough custom content I'll make the custom TNDB public.
K i love your work, i even loved it more once you moved it to GM island..have a few issues though
first off the back of the room on the first floor, if you turn certain ways, the room "dissapears" with some really bad glitches and graphical tears, if you move foward again, it comes back, not sure if its the GM island map itself that is screwed up or what, just a minor thing.
second is that i did not find and after searching, find any vendors that have Offhand items, such as dps or healing offhands that you can wear in your offhand, i would like to include them, as there is some nice caster daggers, and 1 hander maces for healers, but no offhands to go with them
also if you could import all the head, leg and shoulder enchants from the various factions, i added them to my vendor on my server
Like the glyphs and spell thread stuff, only a handful of them, and it would make the Custom GM Vendors project that much more complete.
And what about arena points, are they ever going to develop a command to modify arena points, or should i just remove costs on those? not that i use the arena gear anyways.
One last thing, if i wanted to update my ascent server to newer revision, what would i need to backup or do, in order to save all my custom vendors, last time i updated i lost them all, and i had some others i added personally
thanks, great work so far
The GM island bug is blizzard's problem, lol they just made the texture like that.
I'll add some offhand/enchants in the next update, but do give me some details on the exact types of items you want. Go on wowhead.com and filter out the type of item you want and post the entire URL here.
Arena points isnt implemented in ascent, just remove the cost for the time being.
You only need to backup the spawns that you personally added, or just all the spawns together with this:
If you backup your own spawns with the ones I put on GM island, then in the future you no longer need to use custom_shop_spawns because it will delete all the spawns first, then spawn the ones I made.Code:SELECT * FROM creature_spawns WHERE entry BETWEEN '50000' AND '50080';
k i made a list of what i would like to see implemented into another vendor for head/shoulder/pants enchants
also if you could somehow, filter out all the various resist gear into another separate vendor, like have a nature resist vendor, so don't have browse tons of vendors and find resist gear mixed in with the other normal gear
for example maybe put a nature resist vendor, that sells all nature resist related items for cloth/mail/leather/plate
arcane, nature, shadow, frost, fire
i would even help you out a bit if you need, with finding the items to add, but i don't know if u could write a query to do it, like you did with the other epics by level.
Permanent Enchantments - Items - World of Warcraft
Pretty much everything on these 3 pages, should be added, cuz i was needing scopes too, and the other stuff works as well, it should have every shoulder/head/leg enchant and any other non-enchanting enchant
I started to post individual links, then realized its all under the same category on wowhead...<3 wowhead
Also if we could work on getting a vendor that sells all the best potions and flasks and all that stuff, that would be great as well, i know we can craft them all anyways, but be easier to just pop in and buy them, pop out lol.
i'm lazy..meh
later
I'll add permanent enchants and tweak a few vendors. But I'm not gonna go and sort out everything and category it, thats not my job nor do I want to waste my time doing that.
As for potions, no sort on wowhead to do it, so I won't add it.
can you give me a template for vendors, i'm trying to make a party vendor that sells food, drinks, and fun party stuff :O
please :)
//Vendor info
INSERT INTO creature_names VALUES (ENTRYID, "NAME", "SUBNAME", 0, 4, 0, 3, 0, 0, DISPLAYID, 1, 1, 1, 0);
INSERT INTO creature_proto VALUES (ENTRYID, 100, FACTION, 1000000, 1000000, SCALE, 4, 1000, 1000, 1000, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 5, 5, 5, 5, 5, 5, 5, 1, 1, "", 0, 0);
//Vendor item list
INSERT INTO vendors VALUES ('ENTRYID', 'ITEMID', '1');
I wrote this up in like 30 seconds, tell me if you need more info.
You're free to make vendors you want, and give them to me, if I think they're good or useful, I'll add them with you in the credits. Or I might fix them up a bit or something.
-----
In other news, I've just made off-hand and permanent enchantment vendors, however its not enough to make a 3.0 release. I need more idea on vendors that are not TOO SPECIFIC, like item stats/resistance, stuff like that is too specific. I only work by item type, and more general organizations. If you want something very specific, I'm afraid you'll have to make it yourself and I can add it in the package.
Update a spawn, changed positions of 2 vendors.
can you add a reputation vendor? (like you take a quest for 2 factions [H&A] and when you complete the quest it'd make you exalted with that faction instead of making 8 different macros)
Thats no longer a vendor.
then how do i spawn him?
or i cant...??
You'd have to make a custom quest with custom quest_starter/finisher as well a custom npc.
how do i do that?
lol, this thread is for custom vendors, if you want guides for other content go post a new thread and ask for guides. I dont write guides.
lol noobs, thanks to NCDB with their new revision, the vendors don't work. Oh why... lol
Theres a few new columns in the proto. Its not NCDB, they couldn't do shit even if they wanted to. Burlex implemented some new things. I'll make sure the vendor is updated.
ah ok
Version 3.0:
Changed a few spawns around, removed recipe/reagent from spawns
because they are taking too much space inside the house for future
spawns. Not a lot of people need vendors that specific anyways, so
if you want them spawn them yourself.
Made vendors compatible with latest ascent core (1132 and higher),
you will have to update your database with the query posted above.
Added enchantment and off-hands vendors.
DOWNLOAD the latest ascent core if you want working vendors, 1132 or higher!
Then update db with this:Code:ALTER TABLE creature_proto CHANGE health minhealth int(30) unsigned NOT NULL;
ALTER TABLE creature_proto ADD column maxhealth int(30) unsigned NOT NULL AFTER minhealth;
UPDATE creature_proto SET maxhealth = minhealth;
ALTER TABLE creature_proto CHANGE level minlevel int(30) unsigned NOT NULL;
ALTER TABLE creature_proto ADD column maxlevel int(30) unsigned NOT NULL AFTER minlevel;
UPDATE creature_proto SET maxlevel = minlevel;
ALTER TABLE creature_proto ADD column invisibility_type int(30) unsigned NOT NULL;
ALTER TABLE creature_proto ADD column death_state int(30) unsigned NOT NULL;
aww made the fix before you channel :D
Custom vendor >_<'
i am piroko...Anyways no need for that now :)
GM vendors is now on TN public svn: http://forum.ragezone.com/f114/terra...ic-svn-291797/
channel_49, Can u tell me what was the model id on 2.6v of vendors, they was better than BE:s!
EDIT: Or just give me Download link for 2.6 :P
Thanks.
Look for any naaru and just use that. I don't remember the display ID, just look it up.