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

[jokerjokes]

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.

[plnt8]

thanks heaps +rep, not that i can do much lol

[jokerjokes]

Heh thanks i will be updating as much as possible hehe. If anyone has special requests i can see what i can do and ty for hte rep


Edit: Update

[jokerjokes]

75 views and no comments dam, is there anything bad with this, anyone want to see anything?? Heh.... comments would really be appreciated.

[Viter]

good job +rep x3
EDIT: cant give rep now

[jokerjokes]

Heh thanks , finally some feedback lol.

[galcybele]

Good job man, i like how you help a lot of people , and this stuff is awesome! I love the soda vendor lol.

[jokerjokes]

Heh, no problem, just wanted to contribute once again lol. If anyone has questions feel free to ask.

[galcybele]

Hey dude do you have a fix for the Mail box spam in the concule???

[jokerjokes]

Yes i do heh, here you go.
Filebeam - Free Fast File Hosting

I will update it in the post.

[galcybele]

Omg man thank you soo much!! +rep when i can, lol to much reping you to fast! lol.

[Gastricpenguin]

Breaking a rule, you have about 20 minutes to fix it

[jokerjokes]

What rule??? If your saying about the credits?? i have no clue where they are from, i tried to remember...

[latruwski]

bleh nice try i would say... but look at the thread i made (2 threads) full of queries that are usefull or fun and it is doomed to die on last page :-/ alltough i still see people asking for queries that i posted in there ><
queries are no succes i guess, bleh :s

[Gastricpenguin]

That's only one rule, proper credits must be given or the thread goes.
The other rule concerns your title.