[Gesior] Ultima Skill Avançada!

[Piabeta Kun 359]

Bem aqui vai o tutorial de uma nova estatistica para o Gesior Acc Maker a Lastest Skill Advanced.

 

Vamus ao que enteressa!

 

Adicione esse codigo SQL no seu PhpMyadmin

 

DROP TABLE IF EXISTS `player_advances`;
CREATE TABLE `player_advances` (
 `id` int(11) NOT NULL AUTO_INCREMENT,
 `cid` int(11) DEFAULT NULL,
 `skill` int(11) DEFAULT NULL,
 `oldlevel` int(11) DEFAULT NULL,
 `newlevel` int(11) DEFAULT NULL,
 `time` int(11) DEFAULT NULL,
 UNIQUE KEY `id` (`id`),
 KEY `cid` (`cid`),
 CONSTRAINT `player_advances_ibfk_1` FOREIGN KEY (`cid`) REFERENCES `players` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;

 

Agora em seu OT em creaturescripts/creaturescripts.xml adicione isso

 

<event type="advance" name="PlayerAdvance" event="script" value="playeradvance.lua"/>

 

Agora em creaturescripts\scripts crie um arquivo .LUA com o nome playeradvance e dentro coloque isso!

 

function onAdvance(cid, skill, oldLevel, newLevel)

db.executeQuery("INSERT INTO player_advances (cid, skill, oldlevel, newlevel, time) VALUES ('" .. getPlayerGUID(cid) .. "', '" .. skill .."', '" .. oldLevel .."', '" .. newLevel .."', '" .. os.time() .. "' )")

return true
end

 

Dentro co creaturescript/scripts/login.lua adicione isso!

 

registerCreatureEvent(cid, "PlayerAdvance")

 

Agora em characters.php logo após de signatures adicione isso!

 

		//BEGIN Player advances by jerryb1988 from otfans.net
		if($config['site']['number_of_advances'] > 0) {
			$numadvances = $config['site']['number_of_advances'];
			$advances = 0;
			$player_advances = $SQL->query('SELECT * FROM `player_advances` WHERE `cid` = '.$player->getId().' ORDER BY `time` DESC LIMIT '.$numadvances.';');

			foreach($player_advances as $advance)
			{
				$skill = $advance['skill'];
				if ($skill == 0){$skill_name = '<font color=purple><B>Fist</B></font>';}
				if ($skill == 1){$skill_name = '<font color=purple><B>Club</B></font>';}
				if ($skill == 2){$skill_name = '<font color=purple><B>Sword</B></font>';}
				if ($skill == 3){$skill_name = '<font color=purple><B>Axe</B></font>';}
				if ($skill == 4){$skill_name = '<font color=purple><B>Distance</B></font>';}
				if ($skill == 5){$skill_name = '<font color=purple><B>Shielding</B></font>';}
				if ($skill == 6){$skill_name = '<font color=purple><B>Fishing</B></font>';}
				if ($skill == 7){$skill_name = '<font color=blue><B>Magic</B></font>';}
				if ($skill == 8){$skill_name = '<font color=red><B>Level</B></font>';}

				if(is_int($advances / 2)) { $bgcolor = $config['site']['lightborder']; } else { $bgcolor = $config['site']['darkborder']; } $advances++;

				$advances_add_content .= "<tr bgcolor=\"".$bgcolor."\"><td width=\"20%\" align=\"center\"><nobr>".date("j M Y, g:i a", $advance['time'])."</td><td>".$skill_name."</td><td width=75><font color=red><B>".$advance['oldlevel']."</B></font></td><td width=75><font color=green><B>".$advance['newlevel']."</B></font></tr>";

			}

			if($advances > 0)
				$main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR='.$config['site']['vdarkborder'].'><TD COLSPAN=4 CLASS=white><B>Lastest Skill Advances</B></TD></TR><tr bgcolor='.$config['site']['darkborder'].'><td><b>Time</b></td><td><b>Skill</b></td><td><b>Old Level</b></td><td><b>New Level</b></td></tr>' . $advances_add_content . '</TABLE><br />';
		}
		//END Advances by jerryb1988 from otfans.net

 

e pra finalizar em htdocs\config/config.php adicione isso!

 

[color=#000000][color=#0000BB]$config[/color][color=#007700][[/color][color=#DD0000]'site'[/color][color=#007700]][[/color][color=#DD0000]'show_health_information'[/color][color=#007700]] = [/color][color=#0000BB]1[/color][color=#007700]; [/color][color=#FF8000]//Show health bar [/color]
[color=#0000BB]$config[/color][color=#007700][[/color][color=#DD0000]'site'[/color][color=#007700]][[/color][color=#DD0000]'show_mana_information'[/color][color=#007700]] = [/color][color=#0000BB]1[/color][color=#007700]; [/color][color=#FF8000]//Show mana bar [/color]
[color=#0000BB]$config[/color][color=#007700][[/color][color=#DD0000]'site'[/color][color=#007700]][[/color][color=#DD0000]'show_exp_information'[/color][color=#007700]] = [/color][color=#0000BB]1[/color][color=#007700]; [/color][color=#FF8000]//Show exp bar [/color]
[color=#0000BB]$config[/color][color=#007700][[/color][color=#DD0000]'site'[/color][color=#007700]][[/color][color=#DD0000]'number_of_advances'[/color][color=#007700]] = [/color][color=#0000BB]5[/color][color=#007700]; [/color][color=#FF8000]// number of latest skill advances to show on character page  [/color][/color]

[color=#000000][color=#FF8000]

[/color][/color]

 

Bem o que exatamente ele faz? Ele mostra a ultima skill upada pelo player!

 

Confira a foto

 

 

 

Bem é isso espero que gostem !

 

Creditos 1% Eu por trazer para o forum e 99% para jerryb1988 da Otfans

[SkyDangerous 395]

Bem legal e interessante.

Por mim está aprovado, muito útil.

[Gabriel Couto 293]

Aprovado, Parabéns, Continue Assim!

Mostrou um bom conteúdo, que, com certeza, deverá ajudar muita gente.

 

Movido para a Seção Correta!

[Piabeta Kun 359]

Aprovado, Parabéns, Continue Assim!

Mostrou um bom conteúdo, que, com certeza, deverá ajudar muita gente.

 

Movido para a Seção Correta!

 

Amigo AnyurCT queira me desculpa mais vc moveu para a ceçao errada, a sessão correta seria Tutoriais de Website!

 

e nso custa nada vcs q aprovaram dar 1+rep! Obrigado!

[pessoa93 217]

Aprovado, Parabéns, Continue Assim!

Mostrou um bom conteúdo, que, com certeza, deverá ajudar muita gente.

 

Movido para a Seção Correta!

 

Amigo AnyurCT queira me desculpa mais vc moveu para a ceçao errada, a sessão correta seria Tutoriais de Website!

 

e nso custa nada vcs q aprovaram dar 1+rep! Obrigado!

Movido para a area correta, desculpe-nos

[Piabeta Kun 359]

Obrigado Pessoa!

Editado Outubro 13, 2012 por PiabetaMan01

[thiagozika157 17]

Nunca tiva visto isso inovador

Aprovado .

[Piabeta Kun 359]

obrigado até quemfim um comentario só faltou o Rep+ kkk

[gui2710 0]

Muitoo Bom ! Estava atraz desse tutorial a muitoo tempo

 

 

Ajudo +REP

[Piabeta Kun 359]

Obrigado por comentar amigo!

Bom proveito!

[Subhe 3]

tem como fazer a modificação no meu config.php, tá daando erro aquii

 

<?PHP
$config['site']['check_titles']= FALSE ; /// if true only titles from array belowwill be generated by headline script
$config['site']['allowed_titles'] = array();



//Worlds
$config['site']['worlds'] = array(0 => 'Infinity');
//Others
$config['site']['otslist.eu'] = 101; //server id in otslist.eu to show Players Online Chart (whoisonline.php)
$config['site']['quests'] = array('Annihilator' => 5000,'Demon Helmet' => 2645,'Pits of Inferno' => 5550); // list of quests, 'questname' => storage-id,

//ReCapatha [url="http://recaptcha.net/whyrecaptcha.html"]http://recaptcha.net/whyrecaptcha.html[/url]
$config['site']['publickey'] = "6LfZAAoAAAAAALswKC2UCdCo_wf3ilh_C0qBhQJs "; // Public Key
$config['site']['privkey'] = "6LfZAAoAAAAAAA7_sZX1ZPomaqqTKBka5t6so0Un";; // Private Key

// ACCOUNT config
$config['site']['one_email'] = 0; // one e-mail can be used only to create one account 0 / 1
$config['site']['verify_code'] = 1; // show verify code to block stupid scripts, set 0 if you have problems with image
$config['site']['email_days_to_change'] = 2; // how many days user need to change e-mail to account - block hackers
$config['site']['newaccount_premdays'] = 10; // how many days receive new account

//Forum
$config['site']['forum_sections'] = array(1 => 'News', 2 => 'Staff Complaints', 3 => 'Tutorials', 4 => 'Pictures', 5 => 'Bug Report', 6 => 'Miscellaneous', 7 => 'Trade');
$config['site']['forum_sections_desc'] = array(1 => 'Here you can comment on the news.', 2 => 'Here you can report complaints about Staff Members.', 3 => 'Here you will find tutorials on things.', 4 => 'This board is all about pictures!', 5 => 'Report bugs in this forum.', 6 => 'Anything that doesn\'t already have a designated forum.', 7 => 'Buy and sell things.');
$config['site']['forum_level_limit'] = 30; // minimum 1 character with 50 lvl on account to post
$config['site']['forum_post_interval'] = 20; // 30 seconds between posts
$config['site']['forum_group_not_blocked'] = 1; // group id of player that can always post, remove post, remove threads
$config['site']['forum_posts_per_page'] = 20;
$config['site']['forum_threads_per_page'] = 20;

// USE ONLY IF YOU CONFIGURED E-MAIL AND IT WORK
$config['site']['create_account_verify_mail'] = 0; // when create account player must use right e-mail, he will receive random password to account like on RL tibia, 1 = yes, 0 = no
$config['site']['generate_new_reckey'] = 0; // let player generate new recovery key, he will receive e-mail with new rec key (not display on page, hacker can't generate rec key)
$config['site']['generate_new_reckey_price'] = 5; // you can get some Premium Points for new rec key
$config['site']['send_mail_when_change_password'] = 0; // send e-mail with new password when change password to account, set 0 if someone abuse to send spam
$config['site']['send_mail_when_generate_reckey'] = 0; // send e-mail with rec key (key is displayed on page anyway when generate), set 0 if someone abuse to send spam
$config['site']['send_register_email'] = 0; // send e-mail when register account

// CHARACTER config, format: ID_of_vocation => 'Name of Character to copy', load vocation name from $vocation_name[0] (below)
$config['site']['newchar_vocations'][0] = array(1 => 'Sorcerer Sample', 2 => 'Druid Sample', 3 => 'Paladin Sample', 4 => 'Knight Sample');
$config['site']['newchar_vocations'][1] = array(1 => 'Sorcerer Sample', 2 => 'Druid Sample', 3 => 'Paladin Sample', 4 => 'Knight Sample');
// sample, if rook only: $config['site']['newchar_vocations'][0] = array(0 => 'Rook Sample');
$config['site']['newchar_towns'][0] = array(1);
$config['site']['newchar_towns'][1] = array(0);
// sample, if all players should spawn in one city (city with ID 4): uncoment!!
//$config['site']['newchar_towns'] = array(0);

// list of vocations on ots (world 0)
$vocation_name[0][0] = array(0 => 'None', 1 => 'Sorcerer', 2 => 'Druid', 3 => 'Paladin', 4 => 'Knight'); // id => 'name' , $vocation_name[0] - promotion level 0, $vocation_name[0] - for world ID 0
$vocation_name[0][1] = array(1 => 'Master Sorcerer', 2 => 'Elder Druid', 3 => 'Royal Paladin', 4 => 'Elite Knight'); // id => 'name' , $vocation_name[1] - promotion level 1, $vocation_name[0] - for world ID 0
// list of vocations on ots (world 1)
$vocation_name[1][0] = array(0 => 'None', 1 => 'Sorcerer', 2 => 'Druid', 3 => 'Paladin', 4 => 'Knight'); // id => 'name' , $vocation_name[0] - promotion level 0, $vocation_name[1] - for world ID 1
$vocation_name[1][1] = array(1 => 'Master Sorcerer', 2 => 'Elder Druid', 3 => 'Royal Paladin', 4 => 'Elite Knight'); // id => 'name' , $vocation_name[1] - promotion level 1, $vocation_name[1] - for world ID 1

// list of towns on ots
$towns_list[0] = array(0 => 'Venore', 1 => 'Edron', 2 => 'Thais', 3 => 'Carlin'); // list of towns, id => 'name', $towns_list[0] - for world id 0
$towns_list[1] = array(0 => 'Venore', 1 => 'Edron', 2 => 'Thais', 3 => 'Carlin'); // list of towns, id => 'name', $towns_list[1] - for world id 1

// list of monsters on ots - names blocked, you can generate list of your monsters in acc. maker admin panel ( Reload Monsters )
$config['site']['monsters'] = array("amazon","valkyrie","carrion worm","rotworm","rotworm queen","cockroach","kongra","merlkin","sibang","crystal spider","giant spider","poison spider","scorpion","spider","tarantula","achad","axeitus headbanger","bloodpaw","bovinus","colerian the barbarian","cursed gladiator","frostfur","orcus the cruel","rocky","the hairy one","avalanche","drasilla","grimgor guteater","kreebosh the exile","slim","spirit of earth","spirit of fire","spirit of water","the dark dancer","the hag","darakan the executioner","deathbringer","fallen mooh'tah master ghar","gnorre chyllson","norgle glacierbeard","svoren the mad","the masked marauder","the obliverator","the pit lord","webster","barbarian bloodwalker","barbarian brutetamer","barbarian headsplitter","barbarian skullhunter","bear","panda","polar bear","braindeath","beholder","elder beholder","gazer","chicken","dire penguin","flamingo","parrot","penguin","seagull","terror bird","bazir","infernatil","thul","munster","son of verminor","xenia","zoralurk","big boss trolliver","foreman kneebiter","mad technomancer","man in the cave","lord of the elements","the count","the plasmother","dracola","the abomination","the handmaiden","mr. punish","the countess sorrow","the imperor","massacre","apocalypse","brutus bloodbeard","deadeye devious","demodras","dharalion","fernfang","ferumbras","general murius","ghazbaran","grorlam","lethal lissy","morgaroth","necropharus","orshabaal","ron the ripper","the evil eye","the horned fox","the old widow","tiquandas revenge","apprentice sheng","dog","hellhound","war wolf","winter wolf","wolf","chakoya toolshaper","chakoya tribewarden","chakoya windcaller","blood crab","crab","frost giant","frost giantess","ice golem","yeti","acolyte of the cult","adept of the cult","enlightened of the cult","novice of the cult","ungreez","dark torturer","demon","destroyer","diabolic imp","fire devil","fury","hand of cursed fate","juggernaut","nightmare","plaguesmith","blue djinn","efreet","green djinn","marid","frost dragon","wyrm","sea serpent","dragon lord","dragon","hydra","dragon hatchling","dragon lord hatchling","frost dragon hatchling","dwarf geomancer","dwarf guard","dwarf soldier","dwarf","dworc fleshhunter","dworc venomsniper","dworc voodoomaster","elephant","mammoth","elf arcanist","elf scout","elf","charged energy elemental","energy elemental","massive energy elemental","overcharged energy elemental","energy overlord","cat","lion","tiger","azure frog","coral frog","crimson frog","green frog","orchid frog","toad","jagged earth elemental","muddy earth elemental","earth elemental","massive earth elemental","earth overlord","gargoyle","stone golem","ghost","phantasm","phantasm","pirate ghost","spectre","cyclops smith","cyclops drone","behemoth","cyclops","slick water elemental","roaring water elemental","ice overlord","water elemental","massive water elemental","ancient scarab","butterfly","bug","centipede","exp bug","larva","scarab","wasp","lizard sentinel","lizard snakecharmer","lizard templar","minotaur archer","minotaur guard","minotaur mage","minotaur","squirrel","goblin demon","badger","bat","deer","the halloween hare","hyaena","pig","rabbit","silver rabbit","skunk","wisp","dark monk","monk","tha exp carrier","necromancer","priestess","orc berserker","orc leader","orc rider","orc shaman","orc spearman","orc warlord","orc warrior","orc","goblin leader","goblin scavenger","goblin","goblin assassin","assasin","bandit","black knight","hero","hunter","nomad","smuggler","stalker","poacher","wild warrior","ashmunrah","dipthrah","mahrdis","morguthis","omruc","rahemos","thalas","vashresamun","pirate buccaneer","pirate corsair","pirate cutthroat","pirate marauder","carniphila","spit nettle","fire overlord","massive fire elemental","blistering fire elemental","blazing fire elemental","fire elemental","hellfire fighter","quara constrictor scout","quara hydromancer scout","quara mantassin scout","quara pincher scout","quara predator scout","quara constrictor","quara hydromancer","quara mantassin","quara pincher","quara predator","cave rat","rat","cobra","crocodile","serpent spawn","snake","wyvern","black sheep","sheep","mimic","betrayed wraith","bonebeast","demon skeleton","lost soul","pirate skeleton","skeleton","skeleton warrior","undead dragon","defiler","slime2","slime","bog raider","ice witch","warlock","witch","bones","fluffy","grynch clan goblin","hacker","minishabaal","primitive","tibia bug","undead minion","annihilon","hellgorak","latrivan","madareth","zugurosh","ushuriel","golgordan","thornback tortoise","tortoise","eye of the seven","deathslicer","flamethrower","magicthrower","plaguethrower","poisonthrower","shredderthrower","troll champion","frost troll","island troll","swamp troll","troll","banshee","blightwalker","crypt shambler","ghoul","lich","mummy","vampire","grim reaper","trainer","forest dragon","knight","paladin","druid","sorcerer","guard","mercenary","thief","toxiros","pyramo","lazarus","zathroth","goshnar","durin","demora","orc champion","lumenia","dracula","alezzo","prince almirith","elf warlord","random noob","magebomb");
// list of NPCs on ots - names blocked
$config['site']['npc'] = array('alice', 'oarkhal', 'equer', 'parkhal', 'leoric', 'sarkhal', 'pallo', 'riona', 'her miona', 'varkhal', 'eura', 'blitz', 'markhal', 'wengo', 'larkhal');
$config['site']['max_players_per_account'] = 10; // max. number of characters on account


// GUILDS config
$config['site']['guild_need_level'] = 8; // minimum level to create guild
$config['site']['guild_need_pacc'] = 0; // guild need pacc 0 / 1
$config['site']['guild_image_size_kb'] = 50; // maximum size of image in KB
$config['site']['guild_description_chars_limit'] = 1000; // limit of guild description
$config['site']['guild_description_lines_limit'] = 6; // limit of lines, if description has more lines it will be showed as long text, without 'enters'
$config['site']['guild_motd_chars_limit'] = 150; // limit of MOTD (show in game?)


// E-MAIL config
$config['site']['send_emails'] = 1; // is acc. maker configured to send e-mails?
$config['site']['mail_address'] = "YOUREMAIL@gmail.com"; // e-mail address
$config['site']['smtp_enabled'] = "yes"; // send by smtp or mail function (set 0 if use mail function)
$config['site']['smtp_host'] = "smtp.gmail.com"; // address
$config['site']['smtp_port'] = 465; // port
$config['site']['smtp_auth'] = "yes"; // need authorization? (set 0 if not need auth)
$config['site']['smtp_user'] = "login"; // login
$config['site']['smtp_pass'] = "password"; // password

// ACC MAKER OPTIONS config
$config['site']['access_news'] = 2; // access level needed to edit news
$config['site']['access_admin_panel'] = 3; // access level needed to open admin panel
$config['site']['news_big_limit'] = 3; // limit of news on latest news page
$config['site']['news_ticks_limit'] = 5; // limit of ticker news on latest news page
$config['site']['show_creationdate'] = 0; // show date of character creation 1 = yes, 0 = no (when use Search Player)
$config['site']['last_deaths_limit'] = 40; // max. number of death on last death page
$config['site']['players_group_id_block'] = 4; // don't show in statistics players with group ID higher (or equal) then (show tutors, senior tutors and normal players)
$config['site']['support_group_id'] = 2; // on game masters list show players with group id 2 or higher
$config['site']['shop_system'] = 1; // show server shop page? 1 = yes, 0 = no, use only if you installed LUA scripts of shop
$config['site']['download_page'] = 1; // show download page? 1 = yes, 0 = no
$config['site']['serverinfo_page'] = 1; // show server info page? 1 = yes, 0 = no
$config['site']['verify_code_shop'] = 0; // show verify code when player try to check premium code
$config['site']['gallery_page'] = 1; // show gallery page? 1 = yes, 0 = no
$config['site']['email_lai_sec_interval'] = 180; // time in seconds between e-mails to one account from lost account interface, block spam
$config['site']['show_marriage_info'] = 0; // show marriage, 1 = yes, 0 = no
$config['site']['show_skills_info'] = 0;//show players skills, 1 = yes, 0 = no
$config['site']['show_vip_status'] = 0;// show vip status, 1 = yes, 0 = no
$config['site']['show_vip_storage'] = 0;// the storage of vip
$config['site']['show_outfit'] = 0;// show outfit, 1 = yes, 0 = no
$config['site']['show_signature'] = 0;// show signature, 1 = yes, 0 = no
$config['site']['screenoftheday'] = 1;// show screenshot of the day
$config['site']['worldtransfer'] = 0;//1-Enable/0-Disable Character World Transfer
$config['site']['worldtransferprice'] = 10;//Price for Character World Transfer
$config['site']['transfermonths'] = 6;//Months for which you cannot make World Transfer with a character

// Sistema automatico Pagseguro by tatu_hunter
// Seu email cadastrado no pagseguro
$config['pagseguro']['email'] = 'guilherme_makoto_cat@hotmail.com';

// Valor unitario do produto ou seja valor de cada ponto
// Exemplo de valores
// 100 = R$ 1,00
// 235 = R$ 2,35
// 4254 = R$ 42,54
$config['pagseguro']['produtoValor'] = '100';

// Token gerado no painel do pagseguro
$config['pagseguro']['token'] = 'SEU TOKEN PAGSEGURO AQUI';
// layout, available layouts: rasta,tibiacom,darkritual
$config['site']['layout'] = "tibiacom"; // layout name
?>

Editado Outubro 15, 2012 por Subhe

[Piabeta Kun 359]

Que erro ta dando? se você não falar eu não sabrei o que mecher!

[Matthey 0]

Parabens,Script perfeito caral,valeu

[rickserraglia 2]

interessante... e o tutorial esta muito bem feito, bom formato, foto, informações... parabéns !