[Release] Joker's Fun and Useful Sql Quarie's And Extra!

[kevn93x]

All the languages for each player!!
Filebeam - Free Fast File Hosting

would this be executed under world or logon?

[Power of Illuminati]

I would say world. It's the playercreateinfo_skilsl table.

But this wont effect players already created

[kevn93x]

Figured. Thanks. Will try now. && kaurs trainers wont work for me so im about to head on over to that thread.

[edit: +rep btw]

[shadowslayer133]

Hello everyone, Im JokerJokes :wave:

Welcome to my SQL corner, I have many things and i will be updating as much as possible. I have found many things and updated a lot of cool and useful things over my time at mmowned, so im just here and glad i can share it with all of you!

First off my First download is A:
Soda Vendor
Filebeam - Free Fast File Hosting

Next is:
Eye of the storm sql, to add so you can go there!
Filebeam - Free Fast File Hosting

Ashara's Crater!
Filebeam - Free Fast File Hosting

4 Flying mount's without the vendor at the moment.
Filebeam - Free Fast File Hosting

All the languages for each player!!
Filebeam - Free Fast File Hosting

And the final one for now is Remove the enchanting skill!! So you can enchant at any level!!!
Filebeam - Free Fast File Hosting

Have You ever wanted WSG working?? THis is the .Dll for that!
Filebeam - Free Fast File Hosting

Is it a major holiday and your not ready? Here is the .sql for the holiday's! Thanks to NCDB!
Filebeam - Free Fast File Hosting

Have you ever wanted your players starting with an item?? Just use this .sql and change the id to that one item you want each character to recieve when starting the game .
Filebeam - Free Fast File Hosting

Are you tired of getting the

 Sql query failed due to [Table 'ascentlogon.mailbox_insert_queue' doesn't exist]
, Query: [SELECT * FROM mailbox_insert_queue]

Well here is the fix for this!!!
Filebeam - Free Fast File Hosting

Need a custom leveling road fast??? Down it here!!
Filebeam - Free Fast File Hosting

Need a fast custom city, so you can edit to your likings and your players will love? Here it is!!
Filebeam - Free Fast File Hosting

If anyone has special wants, i can try and get them or make them, but im not so sure how much time i have on my hands...

This is from one of my older works, and i would like to reshare it

Ok This is an item that will exchange your tokens for the full tiers!

This is what you do.
1. Download it lol. Filebeam - Free Fast File Hosting
2. Open the folder
3. Place the globalnpc.dll into your script_bin folder
4. Open the text file with tom's tier sets and the token and save it as .sql
5. Execute it!
6. Then add the token to custom mods or anything.
7. Add the item into a vendor for all your players!

Token id-900000
Exchanger id-66612322

If you have any problems or if you find any bugs please post it here!!


Credit Code:
Tom for his tiers
And ascent forum for the coding
And me for modding it and making it.
And Sexy Amazing Gastric For His Super Amazing Ness lol
And finally follonis. for the huge this he said lol.

If You have your own tier 7, 8, 9 then just use the same item id's for the sets and you will be fine. If you want something different but Close to this jsut ask here or pm, and i will see what i can do

Are you having trouble with your vendor's that when you go on them you can't see the pointer?? Execute this!
Filebeam - Free Fast File Hosting

This is from the ascent comunity!

A Vendor Guide NPC, i.e. striving to help players find other vendors/NPCs that are in close proximity, or perhaps not ;-)

Script is currently setup for the commonly found Vendor script, that has 50-70 vendors, with NPC Ids ranging from 50000-50081. Don't have the credits off the top of my head...

So with this script; instead of having a player search through that long list of blood elf chicas, they simply walk up to this NPC that has a short list of categories.... The player clicks on Bags and is physically moved to the Container vendor, lol..... They click on Rings, and are moved to the rings vendor....

If you're feeling evil you can add a "Give Me 1000g" or a "I Like Pie" category that moves the user into a pack of angry mobs..

Note: If adding NPCs, ensure they exist in close proximity... If they aren't, but are on the same map, your players could be guided into a neighboring city..

Filebeam - Free Fast File Hosting

|Credits|
Zergling- Idea of the soda vendor
Illidan1- for the eye of the storm and crater, and his own custom city.
Vivoxity- for mailbox fix
Me- for putting all these together, and fixing them up, and putting them together.
Ncdb- Holiday's
???-Wsg fix.
Knife- Leveling road
Npc-damer's from ascent forum.

The Tier 7 8 9 all say The Wisdom will server us forever!

[Sabens]

Awesome, +rep.

[vili123]

nice work man +rep for you . can u plis make a update for us who dont have sunwell instances spawned ? i tryed ilidan's update but i got only wendors and quest givers,instances are not spawned ,couse i dont wanna delete my old database and put in new one couse i have fixed alot of stuffs in here and dont wanna do again some repair in other database. thx

[Neth'zul]

This thread is godly! +rep

[Entr0py]

this thread is also quite old lol