[8.54-8.57] Pure Frag V.2

[reniz]

same problem its comes up 24/7

 

[XouruS]

[11022011 003107] mysql_real_query() SELECT  FROM z_ots_comunication WHERE `type` = 'login'; - MYSQL ERROR Table 'otland.z_ots_comunication' doesn't exist (1146)

what is that o.o!

CREATE TABLE `z_ots_comunication` (
  `id` int(11) NOT NULL auto_increment,
  `name` varchar(255) NOT NULL,
  `type` varchar(255) NOT NULL,
  `action` varchar(255) NOT NULL,
  `param1` varchar(255) NOT NULL,
  `param2` varchar(255) NOT NULL,
  `param3` varchar(255) NOT NULL,
  `param4` varchar(255) NOT NULL,
  `param5` varchar(255) NOT NULL,
  `param6` varchar(255) NOT NULL,
  `param7` varchar(255) NOT NULL,
  `delete_it` int(2) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

 

[reniz]

canät find the rebirth system and the vocations to the rebirth system have u not fixed that???

 

[reniz]

plz help with this problem:

[12/02/2011 08:56:20] mysql_real_query(): UPDATE `players` SET `exphist7`=players.exphist6, `exphist6`=players.exphist5, `exphist5`=players.exphist4, `exphist4`=players.exphist3, `exphist3`=players.exphist2, `exphist2`=players.exphist1, `exphist1`=players.experience-players.exphist_lastexp, `exphist_lastexp`=players.experience; - MYSQL ERROR: Unknown column 'exphist7' in 'field list' (1054)

 

[Wojti101]

please help me :

[13/02/2011 13:52:34] mysql_real_query(): UPDATE `players` SET `onlinetimetoday`=players.onlinetimetoday+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1; - MYSQL ERROR: Unknown column 'onlinetimeall' in 'field list' (1054)

What i must create in database?

 

[XouruS]

plz help with this problem:

[/code]ALTER TABLE `players` ADD `exphist_lastexp` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist1` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist2` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist3` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist4` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist5` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist6` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist7` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetimetoday` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime1` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime2` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime3` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime4` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime5` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime6` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime7` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetimeall` BIGINT( 255 ) NOT NULL DEFAULT '0';[/code]

 

[Amiroslo]

ALTER TABLE `players` ADD `exphist_lastexp` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist1` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist2` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist3` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist4` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist5` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist6` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist7` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetimetoday` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime1` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime2` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime3` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime4` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime5` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime6` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime7` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetimeall` BIGINT( 255 ) NOT NULL DEFAULT '0';

lol man u need to add all queries needed :/ becuase the make much errors

 

[XouruS]

wtf? use the mysql.sql at schemas..
thats it..
damn

 

[johny5608]

Can you Post The queries!!!!!
Please!!
Becaouse we need for: Vip days , Guild wars etc.
Please just post the queries!

 

[shitter]

how much exp should this server be?
1000x?

 

[shitter]

sorry didnt notice that it was written in the thread Sorry

 

[shitter]

this ot is so good !!
but i got 2 problems with it

1: this error is spamming my server

[13/02/2011 20:34:24] mysql_real_query(): UPDATE `players` SET `onlinetimetoday`=players.onlinetimetoday+60, `onlinetimeall`=players.onlinetimeall+60 WHERE `online` = 1; - MYSQL ERROR: Unknown column 'onlinetimetoday' in 'field list' (1054)
[13/02/2011 20:34:26] mysql_real_query(): SELECT * FROM z_shut WHERE `id` = 1; - MYSQL ERROR: Table 'otland.z_shut' doesn't exist (1146)

[13/02/2011 20:34:26] [Error - GlobalEvent Interface] 
[13/02/2011 20:34:27] data/globalevents/scripts/control.lua:onThink
[13/02/2011 20:34:27] Description: 
[13/02/2011 20:34:27] data/lib/database.lua:100: [Result:free] Result not set!
[13/02/2011 20:34:27] stack traceback:
[13/02/2011 20:34:28] 	[C]: in function 'error'
[13/02/2011 20:34:28] 	data/lib/database.lua:100: in function 'free'
[13/02/2011 20:34:28] 	data/globalevents/scripts/control.lua:35: in function <data/globalevents/scripts/control.lua:17>
[13/02/2011 20:34:28] [Error - GlobalEvents::think] Couldn't execute event: safe_shutdown

it lags my pc

2 :when i put the mods folder i cant log in with any char


hope you can help me

 

[XouruS]

how much exp should this server be?
1000x?

use orginal stages at xml//
its high exp

 

[XouruS]

Don Daniello is hosting the server at purefrag.pl
12:07 Uptime: 282 hours and 11 minutes.
NEVER CRASHED!
idk why cant you solve the errors :/

 

[shitter]

fixed my errors ty very much

 

[reniz]

i removed the control.lua on globalevents and after that it worked
the server have only shit scripts and they are bugged so remove it thats good hehehe xD!

 

[XouruS]

This file has been downloaded 478 times.
some rep++?

 

[reniz]

why????

 

[johny5608]

1. Problem

[Error - CreatureScript Inferface]
In a timer event called from:
buffernKill
Description:
(luaGetThingFromPos) Tile not Found

2.Problem
When Player dies. Than it sets his Temple Position to x=0 y=0 z=0!

 

[reniz]

what do you kill??