Release OurKO Full Server Files by Zenocide

OMEGAbuffer · 11-14-2008, 04:23 PM

Take a look via ITEM_UPGRADE table. I think the 4th to last or 3rd to last or 2nd to last column in that table shows anvil rates.

100=1%
1000=10%
5000=50%
10000=100%

and so on...

Balgami · 11-15-2008, 01:52 PM

Guys i just disconnecting when select character any solution for this?

ZeroTears · 11-17-2008, 03:48 AM

Quote: Originally Posted by budsmoker997

I made a repack of the server files.

Pack Containts

Patch Manager
Version Manager
AiServer
Aujard
OurKO Ebenezer
1299 Ebenezer
DupeDC
HackDC
1299 KnightOnline.exe (works with vista)
OurKO DataBase
OurKO Map+Evt Files
README.TXT

IT DOES NOT CONTAIN ANYTHING ELSE.

If you want the client or a client patch then download the full file. The full file contains many extra's such as a KO-Panel, Server+Client Tools, Alot of useful programs and misc items, useful scripts and queries.

I do advise you to download the full pack but not everyone can.

NOTE: Zenocide i will remove this apon your request.
[Only Registered and Activated Users Can See Links. Click Here To Register...]

-Budsmoker997-

Ey lolipop thanks u <3
but i got 1 question if dl the 3 gbs files ill still missing things?

ZeroTears · 11-20-2008, 04:59 PM

when im launchin the ebenezer i got an error it says

Load user Knight Rank! is empty

then it crashed the ebenezer

Aory · 11-21-2008, 03:38 PM

torrent down? can someone seed plz

also what is the minimum system requirements for hosting server?
i just wanna mess around with my own server :/

flyquickly · 11-23-2008, 04:50 PM

Quote: Originally Posted by Aory

torrent down? can someone seed plz

also what is the minimum system requirements for hosting server?
i just wanna mess around with my own server :/

me too!!!
con't download now

Aory · 11-28-2008, 09:07 AM

Quote: Originally Posted by ZeroTears

when im launchin the ebenezer i got an error it says

Load user Knight Rank! is empty

then it crashed the ebenezer

I get a similar one saying

LoadUserPersonalRank Empty!

then it crashed the ebenezer

q12345 · 11-28-2008, 10:09 AM

So fill that table up and restart the server. Easy fix.

Aory · 11-28-2008, 10:13 AM

Quote: Originally Posted by q12345

So fill that table up and restart the server. Easy fix.

haha i just tried that and i was gonna post it here but i see u beat me to it :D
thx

beelzebur · 11-28-2008, 11:48 PM

thanks bro

coolzer02001 · 11-29-2008, 11:08 AM

LoadUserPersonalRank Empty!

yeah i got that error too I guess u didnt give the all the system roles in the database delete the KN_online database from the sql reinstall it and reconfigure it it worked for me after that.

kisha101 · 11-29-2008, 07:41 PM

wow, it works good .. i like it much. Thanks Zenocide .. u are the MAN ..

Anyway .. do you/anyone know how to edit EXP rate, and how to figure out an ITEM on user's inventory and how to add it ? .. i am newbie here.

Thanks again Zenocide.

corbintechboy · 11-30-2008, 02:30 AM

Can someone please seed? I'm at 98.6% and left hanging :(

laststand · 11-30-2008, 03:02 AM

Use this for Personal Rank Error..

Code:

TRUNCATE TABLE USER_KNIGHTS_RANK
TRUNCATE TABLE USER_PERSONAL_RANK
INSERT INTO USER_KNIGHTS_RANK VALUES ( 1, 'Gold', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 2, 'Silver', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 3, 'Silver', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 4, 'Silver', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 5, 'Mirage', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 6, 'Mirage', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 7, 'Mirage', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 8, 'Mirage', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 9, 'Mirage', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 10, 'Shadow', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 11, 'Shadow', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 12, 'Shadow', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 13, 'Shadow', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 14, 'Shadow', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 15, 'Shadow', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 16, 'Shadow', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 17, 'Shadow', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 18, 'Shadow', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 19, 'Shadow', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 20, 'Shadow', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 21, 'Shadow', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 22, 'Shadow', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 23, 'Shadow', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 24, 'Shadow', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 25, 'Shadow', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 26, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 27, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 28, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 29, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 30, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 31, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( *** 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 33, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 34, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 35, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 36, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 37, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 38, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 39, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 40, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 41, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 42, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 43, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 44, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 45, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 46, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 47, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 48, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 49, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 50, 'Mist', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 51, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 52, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 53, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 54, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 55, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 56, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 57, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 58, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 59, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 60, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 61, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 62, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 63, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 64, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 65, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 66, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 67, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 68, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 69, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 70, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 71, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 72, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 73, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 74, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 75, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 76, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 77, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 78, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 79, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 80, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 81, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 82, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 83, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 84, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 85, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 86, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 87, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 88, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 89, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 90, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 91, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 92, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 93, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 94, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 95, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( *** 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( *** 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( 98, 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( *** 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_KNIGHTS_RANK VALUES ( **** 'Training', null, null, 0, null, null, 0, 0);
INSERT INTO USER_PERSONAL_RANK VALUES ( 1, 'Gold',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 2, 'Silver',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 3, 'Silver',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 4, 'Silver',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 5, 'Mirage',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 6, 'Mirage',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 7, 'Mirage',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 8, 'Mirage',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 9, 'Mirage',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 10, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 11, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 12, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 13, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 14, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 15, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 16, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 17, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 18, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 19, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 20, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 21, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 22, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 23, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 24, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 25, 'Shadow',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 26, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 27, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 28, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 29, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 30, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 31, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( *** 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 33, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 34, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 35, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 36, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 37, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 38, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 39, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 40, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 41, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 42, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 43, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 44, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 45, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 46, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 47, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 48, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 49, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 50, 'Mist',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 51, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 52, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 53, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 54, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 55, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 56, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 57, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 58, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 59, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 60, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 61, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 62, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 63, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 64, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 65, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 66, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 67, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 68, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 69, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 70, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 71, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 72, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 73, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 74, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 75, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 76, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 77, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 78, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 79, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 80, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 81, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 82, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 83, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 84, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 85, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 86, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 87, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 88, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 89, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 90, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 91, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 92, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 93, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 94, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 95, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( *** 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( *** 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( 98, 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( *** 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());
INSERT INTO USER_PERSONAL_RANK VALUES ( **** 'Training',0, null,0,1000000,0,null,0,1000000,1000000,getdate());

kisha101 · 11-30-2008, 04:54 AM

i try to make item on my first char (GM), i type this on game :

/makeitem AccountID, CharID, ServerNo, ItemID, ItemCount (this is the format)

/makeitem test, GM, 15001, 156210001, 2 (156210001 for Raptor +1)

and then i open PUS on game and close it, and i open my inventory and saw nothing.

Anyone know how exactly to make item command ? i tried this whole night but still need some advices.

Thanks

OMEGAbuffer · 11-30-2008, 04:52 PM

Quote: Originally Posted by kisha101

i try to make item on my first char (GM), i type this on game :

/makeitem AccountID, CharID, ServerNo, ItemID, ItemCount (this is the format)

/makeitem test, GM, 15001, 156210001, 2 (156210001 for Raptor +1)

and then i open PUS on game and close it, and i open my inventory and saw nothing.

Anyone know how exactly to make item command ? i tried this whole night but still need some advices.

Thanks

Hahaha, I suppose you're talking about the Web_Itemmall table.

I don't think there's a makeitem script JUST like 15xx had. So, we use the Web_ItemMall table. All you have to do is fill out the first 5 columns, then open/close power-up store. Take a look at it:

ComputerName\SQLEXPRESS\Databases\KN_online\Tables \dbo.WEB_ITEMMALL

Black_Mage · 12-03-2008, 08:03 PM

This has got to be the best server pack I have seen. Unbelievable job guys!
One question, is Ultima's Lair working? If so whats the zone ID? I have a list and the closest thing is Felkaor's Lair listed as Zone 34, but when I +zonechange 34, all I get is the same zone I'm in but all the NPC's are missing. It's like the Langoliers O.o. Am I being a noob or is something missing? Thanks for the help.

Black_Mage · 12-03-2008, 08:04 PM

Don't answer the noob part :P

ZeroTears · 12-03-2008, 09:14 PM

Quote: Originally Posted by Black_Mage

This has got to be the best server pack I have seen. Unbelievable job guys!
One question, is Ultima's Lair working? If so whats the zone ID? I have a list and the closest thing is Felkaor's Lair listed as Zone 34, but when I +zonechange 34, all I get is the same zone I'm in but all the NPC's are missing. It's like the Langoliers O.o. Am I being a noob or is something missing? Thanks for the help.

Go your Zones table and check the number of Ultimas lair, if you cant find it just go bifrost and run till the end and cross the walls with ur gm char.

Black_Mage · 12-04-2008, 07:29 AM

no luck in the tables, and nothing but mountain behind the walls..could I be missing the maps?

arcjames · 12-04-2008, 07:35 AM

Can someone kindly seed more plz, thanks in advance. seed more ^_^

Black_Mage · 12-05-2008, 06:30 AM

On another thread someone was having issues with "unconfirmed nation" on the new armors (Dragon Flight, ect.) Omega posted his item_org_us tbl and I tried it not knowing how it would work with Zeno's stuff. This is what I got..lol.

Someone got a fix for this that doesnt change the items sold in whatshernames mom npc?

Advocate · 12-05-2008, 07:04 AM

Quote: Originally Posted by Black_Mage

On another thread someone was having issues with "unconfirmed nation" on the new armors (Dragon Flight, ect.) Omega posted his item_org_us tbl and I tried it not knowing how it would work with Zeno's stuff. This is what I got..lol.

Someone got a fix for this that doesnt change the items sold in whatshernames mom npc?

qoute there is no fix for human mage armor its always been like that.

**lollipop07** · 12-05-2008, 12:06 PM

Quote: Originally Posted by Black_Mage

On another thread someone was having issues with "unconfirmed nation" on the new armors (Dragon Flight, ect.) Omega posted his item_org_us tbl and I tried it not knowing how it would work with Zeno's stuff. This is what I got..lol.

Someone got a fix for this that doesnt change the items sold in whatshernames mom npc?

Hmm check the exe log file, it seems there maybe errors in the armour dxt locations maybe?

**lollipop07** · 12-05-2008, 12:07 PM

Quote: Originally Posted by Black_Mage

This has got to be the best server pack I have seen. Unbelievable job guys!
One question, is Ultima's Lair working? If so whats the zone ID? I have a list and the closest thing is Felkaor's Lair listed as Zone 34, but when I +zonechange 34, all I get is the same zone I'm in but all the NPC's are missing. It's like the Langoliers O.o. Am I being a noob or is something missing? Thanks for the help.

Yes ultima lair quest works perfect, gather the required items and open the gate thats situated in the colony zone.