help mysql no save

[Jan jack]

LAst login in noobwar
no save player + id guild
help

 

[KazushiMetaxa]

Add 'castViewers' in Players section
Add 'guild.wars' table in your database

 

[Jan jack]

have script or code

 

[Adorius Black]

Try this:

CREATE TABLE `guild_wars` (
  `id` int(11) NOT NULL,
  `guild1` int(11) NOT NULL DEFAULT '0',
  `guild2` int(11) NOT NULL DEFAULT '0',
  `name1` varchar(255) NOT NULL,
  `name2` varchar(255) NOT NULL,
  `status` tinyint(2) NOT NULL DEFAULT '0',
  `started` bigint(15) NOT NULL DEFAULT '0',
  `ended` bigint(15) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

ALTER TABLE `players` ADD `castViewers` smallint(5) DEFAULT '0';

 

[Jan jack]

i`m Create all but Look V

 

[Adorius Black]

ALTER TABLE `players` ADD `castDescription` varchar(255);

 

[Jan jack]

Yes all Script is working i got worng in Killer > Death-id <> can help > guild id

 

[Adorius Black]

Yes all Script is working i got worng in Killer > Death-id <> can help > guild id

can you show me?

 

[Jan jack]

why player lose items when dead and magic<>some worng V where
MY server player no lose items or magic or skill only lose exp
its server like noobwar

 

[Adorius Black]

ALTER TABLE `killers` ADD `war` int(11);

ALTER TABLE `guild_wars` ADD `guild_id` int(11) NOT NULL;

 

[Jan jack]

death kill << is done > GOOd job
guild id is worng in my sourc
player lose items-skill-magic- off

 

[Adorius Black]

Heh thats great !

ALTER TABLE `guild_wars` ADD `enemy_id` int(11) NOT NULL;

 

[Jan jack]

Stell wrong in sourc worng
i need Code for player no lose items PLEASE
im dont need player lose items or skill or magic > only lose exp
But u good in Code < Great

 

[Adorius Black]

You are missing some columns in database thats why you loosing items i guess. You need just update your database like we are doing now and correct all errors.

ALTER TABLE `guild_wars` ADD `end` bigint(15) NOT NULL DEFAULT '0';

 

[Jan jack]

OMG! All fix
Please i need last
Code for player no lose items or skill-magic
PLEASE Bro last

 

[Adorius Black]

try look in config.lua maybe there is option for this

 

[Jan jack]

nothing
other sourc 2010 al player no lose items
2020 player lose

 

[Softman]

mysql_real_query(): DELETE FROM guild_wars WHERE status = 0 AND begin < 1590856869; - MYSQL ERROR: Unknown column 'begin' in 'where clause' (1054)

I take all your guild war Copy in mysql but i got a problem

Try this:

CREATE TABLE `guild_wars` (
  `id` int(11) NOT NULL,
  `guild1` int(11) NOT NULL DEFAULT '0',
  `guild2` int(11) NOT NULL DEFAULT '0',
  `name1` varchar(255) NOT NULL,
  `name2` varchar(255) NOT NULL,
  `status` tinyint(2) NOT NULL DEFAULT '0',
  `started` bigint(15) NOT NULL DEFAULT '0',
  `ended` bigint(15) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

ALTER TABLE `players` ADD `castViewers` smallint(5) DEFAULT '0';