[8.54-8.57] Pure Frag V.2

[swordtheChoki]

[13/06/2011 08:33:01] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimetoday (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1
[13/06/2011 08:33:12] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimetoday (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1
[13/06/2011 08:33:23] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimetoday (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1
[13/06/2011 08:33:34] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimetoday (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1
[13/06/2011 08:33:45] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimetoday (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1
[13/06/2011 08:33:56] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimetoday (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1
[13/06/2011 08:34:07] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimetoday (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1
[13/06/2011 08:34:18] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimetoday (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1
[13/06/2011 08:34:29] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimetoday (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1
[13/06/2011 08:34:40] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimetoday (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1
[13/06/2011 08:34:51] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimetoday (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1
[13/06/2011 08:35:02] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimetoday (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1
[13/06/2011 08:35:13] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimetoday (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1
[13/06/2011 08:35:24] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimetoday (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1
[13/06/2011 08:35:35] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimetoday (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1
[13/06/2011 08:35:46] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimetoday (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1
[13/06/2011 08:35:57] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimetoday (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1
[13/06/2011 08:35:57] > Broadcasted message: "Information: HUGE update next week! Brand new map/ quests/ spawns/ monsters/ spells/ donations. All accounts will be cleaned and there wil also be a new ip!".
[13/06/2011 08:36:08] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimetoday (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1
[13/06/2011 08:36:19] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimetoday (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1
[13/06/2011 08:36:30] OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: no such column: players.onlinetimetoday (UPDATE "players" SET "onlinetimetoday"=players.onlinetimetoday+60, "onlinetimeall"=players.onlinetimeall+60 WHERE "online" = 1
You Said The Problem Soldd ive u put this one in the databse:

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';
but ive got alot of errors whil putting it in the databse :S

 

[swordtheChoki]

[Err] 1 - near ",": syntax error
[Err] 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';
[Msg] Finished - Unsuccessfully
--------------------------------------------------

 

[XouruS]

use mysql buddy^^

 

[swordtheChoki]

Xourus it's a Really nice server.
But i don't like the high exp rate and the big spawn of much hunting places i'm gonna make a release of pure frag 3 with more events enc
And i'm gonna make it a lower exp server.

 

[swordtheChoki]

And Btw Where do u have put the Mount Script cant find it

 

[swordtheChoki]

Nevermind found the mount script already xd
But where is the script of the broadcasting:
16:28 Information: HUGE update next week! Brand new map/ quests/ spawns/ monsters/ spells/ donations. All accounts will be cleaned and there wil also be a new ip!

 

[XouruS]

globalevents/scripts/autobroadcast
i believe.

 

[swordtheChoki]

Yeah You Were right
Can u tell me what the job is of th 2 new vocas?

 

[swordtheChoki]

And Where is the Script of Getting Outfits by level?

 

[swordtheChoki]

Nevermind xd

 

[Havocbringer]

Very Nice =)

 

[Fileey]

It doesn't work with [8.54-8.57] Forgotten server (Mystic Spirit) .

 

[swordtheChoki]

Uhm Fileey I Used The Forgotten Server 8.54 0.3.6 U Need Only Some Tables And Everything Works Fine

 

[swordtheChoki]

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

Code:
ALTER TABLE `accounts` ADD
`vipdays` int(11) NOT NULL DEFAULT 0;
"onlinetimeall" BIGINT( 255 ) NOT NULL DEFAULT '0';

Code:
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;

code:
UPDATE `players` SET `exphist_lastexp`=`players`.`experience`

And Everything Should Work Fine Except The Npc Keyword Skipping But that isn't a real problem

 

[manne123]

Please someone how do i get a starter ? i need a starter then im done with a server how do iget one ? someone who can post download or anything on a starter !! ??

 

[swordtheChoki]

633718469 html This are the launch files.
put the pure frag data pack in it and change some thing in config like Map:forgotten to mapvp map
You need also to put those in the main folder http://otland.net/f18/opentibia-dll-pack-v1-5-a-1042/

 

[nazi13]

can any1 post mysql file

 

[swordtheChoki]

Its in the schemas folder of theforgottenserver 8.54 0.3.6pl1

 

[Havocbringer]

Your data pack has been approved, that you for contributing.

did u mean " thank " ,

 

[cmarofpicka]

Can u help me and find where is rebirth system thx rep++