[8.21][SQL] Noob War by Gregor&Simonel

[Gregor]

Here is my Noob War!

It's SQL war server(MySQL) Best record player online was 98 xDD

Features:
*Engine: The Forgotten Server Rev 1027
*Real rook map 8.21 (Credits to Sasir&CipSoft)
*4 characters -Sorcerer, Druid, Paladin, Knight
*login using 1/1
*balanced vocations sd like real and other spells
*All characters have all addons
*Every characters have runes and potions in backpacks, they need take loot from dead players if they out of runes
*All character have 45lvl if they have 50lvl they can use other potions and be stronger!
*extra effect when kill
*You need to import my datebase named "War import this'
*Have Fun

Download Noob War By Gregor
Download Source

Download new database

1. Unpack the file war.rar
2. Copy the folder named War
3. To your folders: xampp\mysql\data\
4. If you have problem with this post in this thread.

 

[delton]

Scan?

 

[Berzerky]

Bah, when i import it only comes up with accounts and when i start tfs it just stops.. :s

Edit: got that working, but when i do 1/1 it says, Account number or password is incorrect. :s

 

[budles]

look:


why this erro/;

 

[Gregor]

Bah, when i import it only comes up with accounts and when i start tfs it just stops.. :s

Edit: got that working, but when i do 1/1 it says, Account number or password is incorrect. :s

check in datebase the charcters have set 1 in players table and password to 1

EDIT@2 I check the database and work fine for me.

look:


why this erro/;

too small image i cant see anything

 

[budles]

gregor can help me?


edit:

Gregor
help plx

 

[Gregor]

gregor can help me?


edit:

Gregor
help plx

hmm... i dont relly know this work fine for me, import again named the database "war"

 

[budles]

Erro

consulta SQL:

--
-- Baza danych: `war`
--
-- --------------------------------------------------------
--
-- Struktura tabeli dla `accounts`
--
CREATE TABLE `accounts` (
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`password` varchar( 255 ) COLLATE latin1_general_ci NOT NULL default '',
`type` int( 11 ) NOT NULL default '1',
`premdays` int( 11 ) NOT NULL default '0',
`lastday` int( 10 ) unsigned NOT NULL default '0',
`key` varchar( 20 ) COLLATE latin1_general_ci NOT NULL default '0',
`email` varchar( 255 ) COLLATE latin1_general_ci NOT NULL default '',
`blocked` tinyint( 1 ) NOT NULL default '0',
`warnings` int( 11 ) NOT NULL default '0',
`group_id` int( 11 ) NOT NULL default '1',
PRIMARY KEY ( `id` ) ,
KEY `group_id` ( `group_id` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 COLLATE = latin1_general_ci AUTO_INCREMENT =256257;

Mensagens do MySQL : Documentação
#1050 - Table 'accounts' already exists



post u database?
aff

 

[Acubens]

Erro

consulta SQL:

--
-- Baza danych: `war`
--
-- --------------------------------------------------------
--
-- Struktura tabeli dla `accounts`
--
CREATE TABLE `accounts` (
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`password` varchar( 255 ) COLLATE latin1_general_ci NOT NULL default '',
`type` int( 11 ) NOT NULL default '1',
`premdays` int( 11 ) NOT NULL default '0',
`lastday` int( 10 ) unsigned NOT NULL default '0',
`key` varchar( 20 ) COLLATE latin1_general_ci NOT NULL default '0',
`email` varchar( 255 ) COLLATE latin1_general_ci NOT NULL default '',
`blocked` tinyint( 1 ) NOT NULL default '0',
`warnings` int( 11 ) NOT NULL default '0',
`group_id` int( 11 ) NOT NULL default '1',
PRIMARY KEY ( `id` ) ,
KEY `group_id` ( `group_id` )
) ENGINE = MYISAM DEFAULT CHARSET = latin1 COLLATE = latin1_general_ci AUTO_INCREMENT =256257;

Mensagens do MySQL : Documentação
#1050 - Table 'accounts' already exists



post u database?
aff

Try import your DB in phpmyadmin with another name...

 

[Znote]

I got the same

Is it suppose to be only 1 table (account)?

edit1: Checked the .sql file, its not only suppose to load one table.

edit2:

Simonel

Can I get a directly example of your database?

Just make a database that works, hide or delete your gm acc so we cant copy it.
Enter xampp\mysql\data and copy the database files you got there, add it to rar document and give it to us?

Then we can use the working files.

I checked the .sql file, it is an export you made of your database, I tried that myself a while ago as backup, but didnt work so good.

 

[Gregor]

k i give the folder wait 2 minutes

EDIT@2
Download new database

1. Unpack the file war.rar
2. Copy the folder named War
3. To your folders: xampp\mysql\data\
4. If you have problem with this post in this thread.

 

[Ferchox]

the server rox!

 

[Znote]

The 2nd database release worked Where we had to put it ourself in mysql /data etc

Rook War

Im just temporarly hosting for fun

 

[jomon]

Hail best war ot for 8.21 so far!

 

[Znote]

Peak Record: 33 players online on
August 9, 2008, 1:47 am CET

After a couple hours.

Didn't change much, download - run

Removed paralyze rune, since that ruined the game and 80% of the players was druids.
Instead I fixed so skeletons life drain was more effective, the druids started to use undead legion which was much more funnier ^^
Removed utevo res from druids, so only sorcerers could use it, and improve fire elemental for sorcerers

Think this will be Znote - Warserver (aka server 4).

Modified AFS-CMS to make custom accounts which I will sell for 10 euros or so~ Custom accounts starts with lvl 55 instead of 45, a bit more maglvl, soft boots and skullcrusher's armor.

(haven't port forwarded 80/8080 on my Norwegian comp so they cant enter custom acc service).

So this is recommended, a good balanced yet fun warserver!

Thanks Simonel!

 

[Gregor]

After a couple hours.

Didn't change much, download - run

Removed paralyze rune, since that ruined the game and 80% of the players was druids.
Instead I fixed so skeletons life drain was more effective, the druids started to use undead legion which was much more funnier ^^
Removed utevo res from druids, so only sorcerers could use it, and improve fire elemental for sorcerers

Think this will be Znote - Warserver (aka server 4).

Modified AFS-CMS to make custom accounts which I will sell for 10 euros or so~ Custom accounts starts with lvl 55 instead of 45, a bit more maglvl, soft boots and skullcrusher's armor.

(haven't port forwarded 80/8080 on my Norwegian comp so they cant enter custom acc service).

So this is recommended, a good balanced yet fun warserver!

Thanks Simonel!

Can you compile the server will use system exp for low lvl?

 

[Znote]

I am not good at compiling, so sorry.

 

[skittles]

How do i set this up? I go to open the .exe and it just shuts immediatly.

EDIT: Forgot to add in password, sorry PPP (FIXED)

 

[sophina]

when player die not loot runes players have aol and no lose backpack :/

help i wanna lose bp

 

[sophina]

and i kill some players my acc banned and in config.lua killstoban 590 and players ban with 2 frags :S