nice :D, is there any account backup tool ?Quote:
Originally Posted by kennythekid
Printable View
nice :D, is there any account backup tool ?Quote:
Originally Posted by kennythekid
nope
i will tell later cuz i'm willing to update with a new db well acctualy i updated but i forgot to post the link and i lost it :P silly me
:)))
lol dont do this to me man ! :D im patching new db from your sticky thread already ! when you update with newest let me know :DQuote:
Originally Posted by kennythekid
ARGH! LoL, Cyberg.. I hope it is easy to integrate into your repack :PP It really almost only needs a good db :)
I'm pretty new to SQL so I'm not 100% sure what to edit so that others can use my server.
world_server.conf change the IP to my own...
realm_server.conf same...
login_server.conf ...this is gettin old.
What else? Or should I not edit those. I did search, little vuage besides setting it up for a SP server.
Im not sure of this!!! <<Quote:
Originally Posted by Cobra101
But if im right .. then thats not the correct to do..
Go to realm_server.conf and remove the # in front of "# RealmConnectAddress = xxx"
So it says: "RealmConnectAddress = <YOURIP>"
I haven't tested this, but as far as I would see logic in it , that would be all .. Dont hang me on that one though.. Im sure Kennythekid or some of the devs or other hosters in here will know :P
Peace, Drake :group:
eww, lol ya that makes much more sense. That would've been a nice explosion lol. Ok I'll give it a try, thanks man.
Ok dudes' new relese check it out
kenny_repackv2.sql
change log:
- original sql with char. working
- mongos_repack.sql i little bit better (as i check my server logs i so some changes)
- the lift/tramps working debug found it today
- all set up just change ips in realm and worldserver delete accounts
wait , dont you forget something?!Quote:
Originally Posted by kennythekid
Read the "Pet" thread thingy.. Theres a great WORKING fix to fix pets for hunters there!!
http://forum.ragezone.com/world-warc...et-181226.html
Thanks SvatyPatejlQuote:
Originally Posted by SvatyPatejl
Its easy to make a little .sql file that deletes the current pet_store and creates that one..
Btw. no offence, I really admire your work Kenny :) Keep it up! Kobold ftw! :D
-Drake
damned u put me on to work again but thx :))) and a realy nice "u should say this earlyer"
Hehe, the post about pets just came up a few minutes before you posted that :PQuote:
Originally Posted by kennythekid
well i'm allready uploading the new one :)) don't warry i was fast :D
Great :DD
i found some info about guilds_ranks
as is something wrong there and i rename that thing
DO THIS:
i didn't test it that why i didn't upload it in the sql fileCode:CREATE TABLE `guilds_ranks` (
`guildId` int(6) unsigned NOT NULL default '0',
`rank` varchar(255) NOT NULL default '',
`rights` int(3) unsigned NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
i don't have testers atm just 2 friends :) maybe u could do it and tell me the results
thx
Im ready for testing, thats np :) I just need an exact explenation on what the bug WAS, and what I should be able to do :) Ill then check it before I install the fix, and then after :)
Cheers! Drake :group:
so after seeing this post i made that sql file so it would be cool if u can help me with thisCode:Players on my server create a guild.
i see in logs file some errors like:
Code:
17/10/2006 23:12:43 V Loading Guilds...
17/10/2006 23:12:43 E sqlpp: could not query SELECT * FROM guilds_ranks where gu
E sqlpp: ildId= 1 ORDER BY rank: Unknown column 'rank' in 'o
E sqlpp: rder clause'
17/10/2006 23:12:43 V 1 guilds loadedthen i create in table 'guilds_rank' column 'rank'
Code:
18/10/2006 02:54:18 V Loading Guilds...
18/10/2006 02:54:18 V 1 guilds loadedbut new error then i change rank of my guild member
Code:
18/10/2006 03:35:05 E sqlpp: error executing query, error code[1][Column count d
E sqlpp: oesn't match value count at row 1]
18/10/2006 03:35:05 E sqlpp: your failed query[INSERT INTO guilds_ranks VALUES (
E sqlpp: 2, 'Guild Master', 4294967231,0 )]
18/10/2006 03:35:05 E sqlpp: error executing query, error code[1][Column count d
E sqlpp: oesn't match value count at row 1]
18/10/2006 03:35:05 E sqlpp: your failed query[INSERT INTO guilds_ranks VALUES (
E sqlpp: 2, 'Officer', 79,1 )]
18/10/2006 03:35:05 E sqlpp: error executing query, error code[1][Column count d
E sqlpp: oesn't match value count at row 1]
18/10/2006 03:35:05 E sqlpp: your failed query[INSERT INTO guilds_ranks VALUES (
E sqlpp: 2, 'Veteran', 67,2 )]
18/10/2006 03:35:05 E sqlpp: error executing query, error code[1][Column count d
E sqlpp: oesn't match value count at row 1]
18/10/2006 03:35:05 E sqlpp: your failed query[INSERT INTO guilds_ranks VALUES (
E sqlpp: 2, 'Member', 67,3 )]
18/10/2006 03:35:05 E sqlpp: error executing query, error code[1][Column count d
E sqlpp: oesn't match value count at row 1]
18/10/2006 03:35:05 E sqlpp: your failed query[INSERT INTO guilds_ranks VALUES (
E sqlpp: 2, 'Initiate', 67,4 )]after downgrade the rank, server shutdown with error
next i delete table 'rname' and everything ok
so you must only rename column 'rname' to 'rank'
thx :)
Kenny! Been lookin for you. Think you could answer my annoying question? What do I need to do exactly for people to connect to this one? It's not as simple as the other emus I can already see that, looks like different ports need to be opened on my end as well but got 1k different sets I'm seeing.
Connect to this one? :P You'll have to explain yourself better :)Quote:
Originally Posted by Cobra101
If youre talking Kobold emu.. There are 3 ports you'll have to open if youre using the standard ports and not changing them yourself.. 3724 and 3725 and 4200, if im right :) That is if you have a router.. As we assume you have :)
Cheers, Drake :)
Ya sry man. This emu is what I meant. I've opened those three and my bud's gettin D/C ed before he even get's in. Course he's got a whipy internet so that might be it. Lol, and yes I've got a router. :P What I also meant was earlier I posted you answered changing RealmConnectAddress = <YOURIP> I've got that but I wanted to see if there was anything else that needed to be changed. Thanks again Drake.
i guess this one is solved :))
Hmm, Yes! If im right... Now that you say it, in your database!
in Realm_list ... Change in Navicat, the colomn "Address" to your global IP address! ( Click here to see your Global IP ) look at the top one
EDIT: Oh, and worldserver_list too, if im correct...
Try it out!
-Drake