[Release] Norwegian Elite Highrate Fun Database V4.0 - The Revenge Of Anasterian

[Kagekongen]

I've accedently deleted a table in navicat named mysql.proc and I can't seem to restore it, normally it always save all the things i've made and I can't reinstall it to loose a buggy database.. The bugs just keep staying? what shall I do? (i've actually deleted the whole mysql thing)


EDIT: oh and yeah, didn't you say you would make a repack that had sql included? thanks in advance.

[knaur]

sorry, i have only support for my own creations (database)

and bout repack: have you even read anything in my first post?
cause the reason of not releasing repack stands in bottom........

[knaur]

Knaur,
Again, good job!! I only have one problem that was mentioned before but I didnt see a reply. Draenai cannot use daggers. Will there be a fix like an option to select a sword or dagger as a reward?

+rep a million times LOL

the sql tables in svn will soon have updates for a sword choice in start quest.

but if you dont know how to use a svn,

here are sql querys to a sword and addin to quest

INSERT INTO `items` (`class`, `subclass`, `name1`, `name2`, `name3`, `name4`, `displayid`, `quality`, `buyprice`, `sellprice`, `itemlevel`, `ContainerSlots`, `unique`, `maxcount`, `bonding`, `stat_type1`, `stat_value1`, `stat_type2`, `stat_value2`, `stat_type3`, `stat_value3`, `stat_type4`, `stat_value4`, `stat_type5`, `stat_value5`, `stat_type6`, `stat_value6`, `stat_type7`, `stat_value7`, `stat_type8`, `stat_value8`, `dmg_min1`, `dmg_max1`, `dmg_type1`, `dmg_min2`, `dmg_max2`, `dmg_type2`, `dmg_min3`, `dmg_max3`, `dmg_type3`, `dmg_min4`, `dmg_max4`, `dmg_type4`, `dmg_min5`, `dmg_max5`, `dmg_type5`, `delay`, `range`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, `shadow_res`, `arcane_res`, `armor`, `block`, `spellid_1`, `spelltrigger_1`, `spellcharges_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellcooldown_5`, `spellcategory_5`, `spellcategorycooldown_5`, `allowableclass`, `allowablerace`, `RequiredSkill`, `RequiredSkillRank`, `RequiredFaction`, `RequiredFactionStanding`, `requiredlevel`, `inventorytype`, `quest_id`, `sheathID`, `itemset`, `MaxDurability`, `Description`, `socket_color_1`, `socket_color_2`, `socket_color_3`, `socket_bonus`, `page_id`, `entry`) VALUES ('2', '7', 'Oscars Starting Sword', '', '', '', '35152', '3', '0', '30000', '71', '0', '1', '1', '1', '3', '2', '4', '4', '5', '10', '6', '2', '7', '4', '0', '0', '0', '0', '0', '0', '20', '30', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1200', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '33021', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1503', '1791', '0', '0', '0', '0', '1', '21', '0', '3', '0', '300', 'Made By Knaur', '0', '0', '0', '104', '0', '4');

UPDATE `quests` SET `RewChoiceItemId1` = '5', `RewChoiceItemId2` = '4', `RewChoiceItemCount1` = '1', `RewChoiceItemCount2` = '1', `RewItemId1` = '0', `RewItemCount1` = '0' WHERE `entry` = 1200000 LIMIT 1;

[muroga]

sry but i have another question..lol


well i fixed my other problem (stupid me...passwords were not the same) and when i log in its the normal game and not ur database...earlier i loaded the SQL file for it into accounts..was that not it or am i doin something wrong?

[knaur]

well... changing the realmlist.wtf in your world of warcraft folder to point
at server,s ip adress could be a start

(i heard that can make miracles)

[muroga]

lol i did, im running the server on my laptop and its on my newtwork, so i set the realm list to 192.168.1.104.....is that what u mean..lol??

[knaur]

the same ip adress computer as ascent.exe are running on yes,
But you also must remember to point ascent.conf and logonserver.conf to my database

[miros1]

<Realm1 Name = "YourServerName"
Address = "YourRealm:8129"
Icon = "PVP"
Colour = "1"
Population = "1.0"
TimeZone = "1">

this is

[*TraPStaR*]

i got a question knaur your event reward items has your data base's name on them but i first seen them in chrispee's repack why is that ?

[knaur]

first thing: event reward isnt used anymore, last used in database 3.0

second thing: everything in norwegian elite has a norwegian elite name,
thats a part of database system itself

third thing: crispees mantle is still named chrispees mantle

fourth thing: crispee is a friend of me, and i have helped him
many times with stuff (ask him yourself if you dont believe me)

fifth thing: my database has items/stuff releases from many ppl,
BUT everyone has been credited in my releases!


anything more you wonder about?

[*TraPStaR*]

nope cleared it up .......

[Darkjackal]

was told this is the repack to use but i have not found a guide to set it up right

[muroga]

(sorry if im annoying you guys with my questions but i really have a little bit of a clue what im doin and thank u for helping me so far!)

ok i kinda follow u....heres what i got goin:
I followed this tut for compiling AC Web

I followed everything like with making the databases world and accounts (idk if i need to use something from your from this..idk i just followed tut)

then where it says use the Release file, i used your 2.8 stable file for the ascent/logon config files (i think thats right)

At first i was wondering what the SQL file that comes with your downlaod is for (the norwegianelite40 SQL-script one, I loaded it into the accounts database but im sure that was wrong)

now i made a new database called elite40 and im doin the restore from SQL dump, your norwegianelite40 file, is this where now i gointo the 2.8 stable file and change the stuff to point to that database? where do i do that also becasue the only thing i see is where it says "wdb=world(database told me to make) and cdb=accounts,
do i need to change one of those to your database??


and thats where i am at, at the moment.


thx

[nichoray10]

OMFG!!! danng keep up the good work ++++++Rep

[Clinique]

the sql tables in svn will soon have updates for a sword choice in start quest.

but if you dont know how to use a svn,

here are sql querys to a sword and addin to quest

Thank you Knaur! That helped

Im still learning so I have no knowledge with SVN yet.