The Forgotten Server v0.2rc4

[Punketx]

in the moment i import the SQL i have a error



Error

consulta SQL:

DELIMITER | CREATE TRIGGER `ondelete_accounts` BEFORE DELETE ON `accounts` FOR EACH ROW BEGIN DELETE FROM `bans` WHERE `account` = OLD.`id` ;

MySQL ha dicho: Documentación
#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



=S i need help when i create a char this no apper in the database plz help

 

[Mark]

I wonder how many times I've said this........

YOU NEED PHPMYADMIN VERSION 2.11.

 

[Punketx]

one thing more where I can find a guide to use phpmyadmin 2,11 exists some tutorial?

plz srry im tray and tray and i think i need some help


Edit:

i replace of the folder of xampplite the folder phpmyadmin for the phpmy admin version 2.11

and when i want to go to localhost\phpmyadmin i have this error


Bienvenido a phpMyAdmin 2.11.0-rc1

La razón más probable es que usted no creó un archivo de configuración. Utilice setup script para crear una.
Error

MySQL ha dicho: Documentación
#1045 - Access denied for user 'root'@'localhost' (using password: NO)




this said me i dotn have a config file what i can do?

 

[chul1do]

I recomend xampp lite is only change the file

 

[Mark]

one thing more where I can find a guide to use phpmyadmin 2,11 exists some tutorial?

plz srry im tray and tray and i think i need some help


Edit:

i replace of the folder of xampplite the folder phpmyadmin for the phpmy admin version 2.11

and when i want to go to localhost\phpmyadmin i have this error


Bienvenido a phpMyAdmin 2.11.0-rc1

La razón más probable es que usted no creó un archivo de configuración. Utilice setup script para crear una.
Error

MySQL ha dicho: Documentación
#1045 - Access denied for user 'root'@'localhost' (using password: NO)




this said me i dotn have a config file what i can do?

Edit phpMyAdmin/libraries/config.default.php


search for this line:
$cfg['Servers'][$i]['auth_type'] = 'config';
change it to:
$cfg['Servers'][$i]['auth_type'] = 'http';

 

[Punketx]

the problems dont stop =( im do it and i can import the database whitout problems but now im going to for example players and only stay the account manager and i crate more chars but this not are here

what can i do?

and very thx for all the help!

 

[Mark]

What is not there? You are only supposed to see the account manager there when you've imported your database.

 

[Punketx]

kk but where I cant find chars that I have created I want to change to him acces to 4 but i dont find the chars and the account i created in any place of data base



srry for my english =/

and thx!


Edit:

i have a problem when i run the serv

he Forgotten Server - Version 0.2.3.
A server made by Talaturen, Kiper, Kornholijo, Ruly and KingKomic.

>> Loading config
>> Loading RSA key
>> Testing SQL connection... MySQL.
>> MYSQL ERROR | mysql_select_db: theforgottenserver.sql | failed!
>> ERROR: Failed to connect to database, read mysql-help.txt for information or try SqLite which doesn't require any connection.


i change in confi.lua



-- Database Config --
sqlHost = "localhost"
sqlUser = "root"
sqlPass = "password"
sqlDatabase = "theforgottenserver"
sqliteDatabase = "forgottenserver.s3db"
sqlType = "mysql"
useMD5Passwords = "no"



any one know what its the problem?

 

[Mark]

Have you changed in config.lua to make the server use MySQL?
sqlType should be set to "mysql" instead of "sqlite".

 

[Punketx]

when i change mysql in sql type i have this error

he Forgotten Server - Version 0.2.3.
A server made by Talaturen, Kiper, Kornholijo, Ruly and KingKomic.

>> Loading config
>> Loading RSA key
>> Testing SQL connection... MySQL.
>> MYSQL ERROR | mysql_select_db: theforgottenserver.sql | failed!
>> ERROR: Failed to connect to database, read mysql-help.txt for information or try SqLite which doesn't require any connection.



-- Database Config --
sqlHost = "localhost"
sqlUser = "root"
sqlPass = "password"
sqlDatabase = "theforgottenserver"
sqliteDatabase = "forgottenserver.s3db"
sqlType = "mysql"
useMD5Passwords = "no"


what can i do??


and very THX! for all the help


EDIT:

i change

sqlDatabase = "theforgottenserver"

for

sqlDatabase = "forgottenserver"

and dont work and im change to

sqlDatabase = "forgottenserver.sql"

and dont work plz i need help

and i have this problem

The Forgotten Server - Version 0.2.3.
A server made by Talaturen, Kiper, Kornholijo, Ruly and KingKomic.

>> Loading config
>> Loading RSA key
>> Testing SQL connection... MySQL.
>> MYSQL ERROR | mysql_select_db: forgottenserver | failed!
>> ERROR: Failed to connect to database, read mysql-help.txt for information or try SqLite which doesn't require any connection.

 

[Mark]

sqlDatabase has to be the name that you gave your database.

 

[Punketx]

YEA!!! xP and after so much trys now i can edit all kk thx =P now what is tehe i need to change to make a gm i dont see acces =S

thhis only have

id name group_id account_id level vocation health healthmax experience lookbody lookfeet lookhead looklegs looktype lookaddons maglevel mana manamax manaspent soul town_id posx posy posz conditions cap sex lastlogin lastip save redskull redskulltime rank_id guildnick lastlogout blessings direction loss_experience NOT IN USE BY SERVER loss_mana NOT IN USE BY SERVER loss_skills NOT IN USE BY SERVER

 

[Mark]

group_id and in accounts table edit type to 4 (gm) or 5 (god).

 

[Punketx]

accounts table only have

id password type premdays lastday key email blocked warnings

and id is the account

i change the

group_id to 4 and 5 in the character table and nothing im still a sorcerer

 

[ntmr]

Hey Talaturen, look this thread please.
http://otfans.net/showthread.php?t=88792

It's a serious NPC bug :S

It can be an error in the npc system..

The loot.lua:

local keywordHandler = KeywordHandler:new()
local npcHandler = NpcHandler:new(keywordHandler)
NpcSystem.parseParameters(npcHandler)



-- OTServ event handling functions start
function onCreatureAppear(cid) npcHandlernCreatureAppear(cid) end
function onCreatureDisappear(cid) npcHandlernCreatureDisappear(cid) end
function onCreatureSay(cid, type, msg) npcHandlernCreatureSay(cid, type, msg) end
function onThink() npcHandlernThink() end
-- OTServ event handling functions end


-- Don't forget npcHandler = npcHandler in the parameters. It is required for all StdModule functions!
keywordHandler:addKeyword({'helmets'}, StdModule.say, {npcHandler = npcHandler, onlyFocus = true, text = 'I buy royal (30k), warrior (6k), crusader (9k), crown (3k), devil (2k), chain (35gp) and iron helmets (30gp), also mystic turbans (1k).'})
keywordHandler:addKeyword({'boots'}, StdModule.say, {npcHandler = npcHandler, onlyFocus = true, text = 'I buy golden boots (100k), steel boots (30k) and boots of haste (30k).'})
keywordHandler:addKeyword({'armors'}, StdModule.say, {npcHandler = npcHandler, onlyFocus = true, text = 'I buy golden (40k), crown (15k), knight (5k), plate (400gp), brass (200gp) and chain armors (100gp), also mpa (100k), dsm (60k) and blue robes (15k).'})
keywordHandler:addKeyword({'legs'}, StdModule.say, {npcHandler = npcHandler, onlyFocus = true, text = 'I buy golden (80k), crown (20k), knight (15k), plate (500gp) and brass legs (100gp).'})
keywordHandler:addKeyword({'shields'}, StdModule.say, {npcHandler = npcHandler, onlyFocus = true, text = 'I buy blessed (150k), great (100k), demon (30k), vampire (10k), medusa (8k), crown (5k), tower (4k), dragon (4k), guardian (2k), beholder (1k), and dwarven shields (100gp), also mms (80k).'})

keywordHandler:addKeyword({'swords'}, StdModule.say, {npcHandler = npcHandler, onlyFocus = true, text = 'I buy giant (15k), bright (20k), fire (4k) serpent (1k), spike (800gp) and two handed swords (400gp), also ice rapiers (4k), magic longswords (150k), magic swords (100k), warlord swords (150k), broad swords (70gp), short swords (30gp), sabres (25gp) and swords (25gp).'})
keywordHandler:addKeyword({'axes'}, StdModule.say, {npcHandler = npcHandler, onlyFocus = true, text = 'I buy fire (10k), guardian halberds (8k), knight (2k), double (200gp) and battle axes (100gp), also dragon lances (10k), stonecutters axes (100k), halberds (400gp) and hatchets (20gp).'})
keywordHandler:addKeyword({'clubs'}, StdModule.say, {npcHandler = npcHandler, onlyFocus = true, text = 'I buy thunder hammers (100k), war (3k), dragon (3k) and battle hammers (60gp), also skull staffs (6k) and clerical maces (200gp).'})

-- Makes sure the npc reacts when you say hi, bye etc.
npcHandler:addModule(FocusModule:new())

The seller.xml:

<npc name="Soya" script="data/npc/scripts/loot.lua" autowalk="25" floorchange="0" access="5" level="1" maglevel="1">
<health now="150" max="150"/>
<look type="139" head="132" body="79" legs="97" feet="132" corpse="2212"/>
<parameters>
<parameter key="module_shop" value="1" />
<parameter key="message_greet" value="Hello |PLAYERNAME|. I buy swords, clubs, axes, helmets, boots, legs, shields and armors." />
<parameter key="shop_sellable" value="royal helmet,2498,30000;warrior helmet,2475,6000;crusader helmet,2497,9000;crown helmet,2491,3000;devil helmet,2462,2000;mystic turban,2663,1000;chain helmet,2458,35;iron helmet,2459,30;steel boots,2645,30000;boots of haste,2195,30000;golden boots,2646,100000;magic plate armor,2472,100000;dragon scale mail,2492,60000;demon armor,2494,90000;golden armor,2466,40000;crown armor,2487,15000;knight armor,2476,5000;blue robe,2656,15000;plate armor,2463,400;brass armor,2465,200;chain armor,2464,100;golden legs,2470,80000;crown legs,2488,20000;knight legs,2477,15000;plate legs,2647,500;brass legs,2487,100;mastermind shield,2514,80000;demon shield,2520,30000;blessed shield,2523,150000;great shield,2522,100000;vampire shield,2534,10000;medusa shield,2536,8000;crown shield,2519,5000;tower shield,2528,4000;dragon shield,2516,4000;guardian shield,2515,2000;beholder shield,2518,1000;dwarven shield,2525,100;magic longsword,2390,150000;warlord sword,2408,150000;magic sword,2400,100000;giant sword,2393,15000;bright sword,2407,20000;serpent sword,2409,1000;ice rapier,2396,4000;fire sword,2392,4000;two handed sword,2377,400;broad sword,2413,70;short sword,2406,30;sword,2376,25;dragon lance,2414,10000;stonecutter axe,2431,100000;guardian halberd,2427,8000;fire axe,2432,10000;knight axe,2430,2000;double axe,2387,200;halberd,2381,400;battle axe,2378,100;hatchet,2388,20;war hammer,2391,3000;thunder hammer,2421,100000;skull staff,2436,6000;dragon hammer,2434,3000;clerical mace,2423,200;battle hammer,2417,60;mace,2398,30;beastslayer axe,3962,4000;dreaded cleaver,7419,1200;headchopper,7380,5000;titan axe,7413,6000;heroic axe,7389,10000;royal axe,7434,15000;epee,2438,4000;crimson sword,7385,1500;crystal sword,7449,4000;haunted blade,7407,4500;blacksteel sword,7406,10000;dragon slayer,7402,11000;mystic blade,7384,13000;demonrage sword,7382,20000;justice seeker,7390,22000;mammoth whopper,7381,3000;taurus mace,7425,800;furry club,7432,900;diamond sceptre,7387,1000;dragonbone staff,7430,1100;brutetamer's staff,7379,3000;sapphire hammer,7437,3200;lunar staff,7451,3250;spiked squelcher,7452,3300;orcish maul,7392,4000;amber staff,7426,4300;cranial basher,7415,5000;chaos mace,7427,5000;blessed sceptre,7429,15000;" />
</parameters>
</npc>

 

[Mark]

It has already been fixed.

 

[Loira]

OMG tnx for server man but where are account and players? i am newbie >.<" please where are?

 

[kaoss12]

Man its a succes! i love it

 

[Suxex]

How I change so the players dont need to buy spells? They will autolearn them

 

[chul1do]

why players can said any spells?