The Forgotten Server v0.2rc4
- Thread starter Mark
- Start date
- Status
that question has been answer many times in this thread.
you said you now? it don´t seems like that go back some pages and read why you can´t download it.
- Joined
- Aug 6, 2007
- Messages
- 1,767
- Reaction score
- 35
since Nicaw started leaking it on fans tala made it harder to get u need around 50~100+ posts and way longer then 24h member ship =)
if you should have go back and read you would now that it is a secret.
Cm Himen
flesh,no-ip.org
i do have the new version of php admin but im trying to import it through the site can you fix this or give me a fogotten.sql document that works and will import
You will find the solution further back in this thread, It worked for me.
However I'm getting loads of errors when i start the server, such as trashcan something
Might post it later after i try to fix it myself. But if it rings a bell then you can always reply btw i get this error when i logon a player or logoff. Its a error while saving =)
Code:
MYSQL ERROR mysql_real_query: INSERT INTO `player_items` (`player_id` , `pid` , `sid` , `itemtype` , `count` , `attributes` , `writer` , `date` ) VALUES (3,3,101,1987,1,'','',2097262),(3,5,102,2190,1,'','',1919243040),(3,6,103,2511,1,'','',4),(3,7,104,2649,1,'','',0),(3,10,105,2148,23,'','',1752462689),(3,101,106,2152,2,'','',1864397669) Unknown column 'writer' in 'field list'
MYSQL ERROR mysql_real_query: INSERT INTO `player_items` (`player_id` , `pid` , `sid` , `itemtype` , `count` , `attributes` , `writer` , `date` ) VALUES (3,3,101,1987,1,'','',2097262),(3,5,102,2190,1,'','',1919243040),(3,6,103,2511,1,'','',4),(3,7,104,2649,1,'','',0),(3,10,105,2148,23,'','',1752462689),(3,101,106,2152,2,'','',1864397669) Unknown column 'writer' in 'field list'
MYSQL ERROR mysql_real_query: INSERT INTO `player_items` (`player_id` , `pid` , `sid` , `itemtype` , `count` , `attributes` , `writer` , `date` ) VALUES (3,3,101,1987,1,'','',2097262),(3,5,102,2190,1,'','',1919243040),(3,6,103,2511,1,'','',4),(3,7,104,2649,1,'','',0),(3,10,105,2148,23,'','',1752462689),(3,101,106,2152,2,'','',1864397669) Unknown column 'writer' in 'field list'//Massen
Last edited:
Hello maybe can help i use Forgotten 2.4 and this quest script but i get error onUse what i need change ? ?
-- Script by Colandus!
-- Free to edit
function onUse(cid, item, frompos, item2, topos)
-- Item ID and Uniqueid --
switchUniqueID = 1900 --
switchID = 1945 --
switch2ID = 1946 --
swordID = 2376 --
crossbowID = 2455 --
appleID = 2674 --
spellbookID = 2175 --
--------------------------
-- Level to do the quest --
questlevel = 20 --
---------------------------
----------------------------------------------
piece1pos = {x=321, y=110, z=7, stackpos=1} -- Where the first piece will be placed
getpiece1 = getThingfromPos(piece1pos) --
--
piece2pos = {x=321, y=104, z=7, stackpos=1} -- Where the second piece will be placed
getpiece2 = getThingfromPos(piece2pos) --
--
piece3pos = {x=318, y=107, z=7, stackpos=1} -- Where the third piece will be placed
getpiece3 = getThingfromPos(piece3pos) --
--
piece4pos = {x=324, y=107, z=7, stackpos=1} -- Where the fourth piece will be placed
getpiece4 = getThingfromPos(piece4pos) --
----------------------------------------------
-------------------------------------------------
player1pos = {x=321, y=109, z=7, stackpos=253} -- Where player1 will stand before pressing lever
player1 = getThingfromPos(player1pos) --
--
player2pos = {x=321, y=105, z=7, stackpos=253} -- Where player2 will stand before pressing lever
player2 = getThingfromPos(player2pos) --
--
player3pos = {x=319, y=107, z=7, stackpos=253} -- Where player3 will stand before pressing lever
player3 = getThingfromPos(player3pos) --
--
player4pos = {x=323, y=107, z=7, stackpos=253} -- Where player4 will stand before pressing lever
player4 = getThingfromPos(player4pos) --
-------------------------------------------------
-----------------------------------------------
knightvoc = getPlayerVocation(player1.uid) -- The vocation of player1
paladinvoc = getPlayerVocation(player2.uid) -- The vocation of player2
druidvoc = getPlayerVocation(player3.uid) -- The vocation of player3
sorcerervoc = getPlayerVocation(player4.uid) -- The vocation of player4
-----------------------------------------------
------------------------------------
nplayer1pos = {x=321, y=121, z=7} -- The new position of player1
nplayer2pos = {x=321, y=120, z=7} -- The new position of player2
nplayer3pos = {x=321, y=119, z=7} -- The new position of player3
nplayer4pos = {x=321, y=118, z=7} -- The new position of player4
------------------------------------
---------------------------------------------
player1level = getPlayerLevel(player1.uid) -- Checking the level of player1
player2level = getPlayerLevel(player2.uid) -- Checking the level of player2
player3level = getPlayerLevel(player3.uid) -- Checking the level of player3
player4level = getPlayerLevel(player4.uid) -- Checking the level of player4
---------------------------------------------
-- check if all players has the right vocation --
if knightvoc == 4 and --
paladinvoc == 3 and --
druidvoc == 2 and --
sorcerervoc == 1 then --
-------------------------------------------------
-- check if they all players are on right positions ---------------
if player1.itemid > 0 and --
player2.itemid > 0 and --
player3.itemid > 0 and --
player4.itemid > 0 then --
-------------------------------------------------------------------
-------------------------------------
if player1level >= questlevel and --
player2level >= questlevel and --
player3level >= questlevel and --
player4level >= questlevel then --
-------------------------------------
-----------------------------------------------
if item.uid == switchUniqueID and --
item.itemid == switchID and --
getpiece1.itemid == swordID and --
getpiece2.itemid == crossbowID and --
getpiece3.itemid == appleID and --
getpiece4.itemid == spellbookID then --
-----------------------------------------------
-- sends an "poff" to the old pos --
doSendMagicEffect(player1pos,2) --
doSendMagicEffect(player2pos,2) --
doSendMagicEffect(player3pos,2) --
doSendMagicEffect(player4pos,2) --
------------------------------------
-- teleports the players to the new pos ---
doTeleportThing(player1.uid,nplayer1pos) --
doTeleportThing(player2.uid,nplayer2pos) --
doTeleportThing(player3.uid,nplayer3pos) --
doTeleportThing(player4.uid,nplayer4pos) --
-------------------------------------------
-- sends an "glimmer" to the new pos --
doSendMagicEffect(nplayer1pos,10) --
doSendMagicEffect(nplayer2pos,10) --
doSendMagicEffect(nplayer3pos,10) --
doSendMagicEffect(nplayer4pos,10) --
---------------------------------------
-- removes the items ---------------
doRemoveItem(getpiece1.uid,1) --
doRemoveItem(getpiece2.uid,1) --
doRemoveItem(getpiece3.uid,1) --
doRemoveItem(getpiece4.uid,1) --
------------------------------------
------------------------------------------
doTransformItem(item.uid,item.itemid+1) --
------------------------------------------
------------------------------------------
elseif item.uid == switchUniqueID and --
item.itemid == switch2ID then --
doTransformItem(item.uid,item.itemid-1) --
------------------------------------------
else
doPlayerSendCancel(cid,"Sorry, you need to put the correct stuffs at the correct basins.")
end
else
return 0
end
else
doPlayerSendCancel(cid,"Sorry, all players in your team must to be level " .. questlevel .. ".")
end
else
doPlayerSendCancel(cid,"Sorry, all 4 players must be on right positions.")
end
return 1
end
You will find the solution further back in this thread, It worked for me.
However I'm getting loads of errors when i start the server, such as trashcan something
btw i get this error when i logon a player or logoff. Its a error while saving =)
Code:MYSQL ERROR mysql_real_query: INSERT INTO `player_items` (`player_id` , `pid` , `sid` , `itemtype` , `count` , `attributes` , `writer` , `date` ) VALUES (3,3,101,1987,1,'','',2097262),(3,5,102,2190,1,'','',1919243040),(3,6,103,2511,1,'','',4),(3,7,104,2649,1,'','',0),(3,10,105,2148,23,'','',1752462689),(3,101,106,2152,2,'','',1864397669) Unknown column 'writer' in 'field list' MYSQL ERROR mysql_real_query: INSERT INTO `player_items` (`player_id` , `pid` , `sid` , `itemtype` , `count` , `attributes` , `writer` , `date` ) VALUES (3,3,101,1987,1,'','',2097262),(3,5,102,2190,1,'','',1919243040),(3,6,103,2511,1,'','',4),(3,7,104,2649,1,'','',0),(3,10,105,2148,23,'','',1752462689),(3,101,106,2152,2,'','',1864397669) Unknown column 'writer' in 'field list' MYSQL ERROR mysql_real_query: INSERT INTO `player_items` (`player_id` , `pid` , `sid` , `itemtype` , `count` , `attributes` , `writer` , `date` ) VALUES (3,3,101,1987,1,'','',2097262),(3,5,102,2190,1,'','',1919243040),(3,6,103,2511,1,'','',4),(3,7,104,2649,1,'','',0),(3,10,105,2148,23,'','',1752462689),(3,101,106,2152,2,'','',1864397669) Unknown column 'writer' in 'field list'
//Massen
'
Just quoting :<
Piotrek1447
Member
This is work fine here, try update your items.xml
Cm Himen
flesh,no-ip.org
Error
SQL query:
DELIMITER | CREATE TRIGGER `ondelete_accounts` BEFORE DELETE ON `accounts` FOR EACH ROW BEGIN DELETE FROM `bans` WHERE `account` = OLD.`id` ;
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER |
CREATE TRIGGER `ondelete_accounts`
BEFORE DELETE
ON `accounts`
FOR ' at line 1
im getting this code when i import it im getting several form the forgotten.sql
no ones helped me yet ive had 3 people post saying look more into the thread... no one knows how to fix this? then why is it the .sql file
SQL query:
DELIMITER | CREATE TRIGGER `ondelete_accounts` BEFORE DELETE ON `accounts` FOR EACH ROW BEGIN DELETE FROM `bans` WHERE `account` = OLD.`id` ;
MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DELIMITER |
CREATE TRIGGER `ondelete_accounts`
BEFORE DELETE
ON `accounts`
FOR ' at line 1
im getting this code when i import it im getting several form the forgotten.sql
no ones helped me yet ive had 3 people post saying look more into the thread... no one knows how to fix this? then why is it the .sql file
SupremuS
New Member
- Joined
- Aug 15, 2007
- Messages
- 25
- Reaction score
- 1
Well, i can only conclude one thing from this...
The Forgotten Server Sucks for 3 reasons:
- It's quite reserved
- It's way too complicated for the average user (like me) because of the Mysql
- I can't edit anything.
Soo, i'm gonna download evolutions and try to make a nice OT.
It's free, easy to make and cool.
I'm just sorry i spent 1 week trying to put the server on, when instead i could be online for 1 week, using evolutions.
Talaturen, you have a nice server, but there is much u need to learn yet...
Thank you all
Supremus
The Forgotten Server Sucks for 3 reasons:
- It's quite reserved
- It's way too complicated for the average user (like me) because of the Mysql
- I can't edit anything.
Soo, i'm gonna download evolutions and try to make a nice OT.
It's free, easy to make and cool.
I'm just sorry i spent 1 week trying to put the server on, when instead i could be online for 1 week, using evolutions.
Talaturen, you have a nice server, but there is much u need to learn yet...
Thank you all
Supremus
- Status
