Artefacts In Village

[travax]

hi, how i can put the artefacts in the natars villages???
how table in need modified in phpmyadmin???

 

[saulius]

You want to maybe you natare villages?

 

[Grifit]

I would like to see their like 3-4 pages conversation

 

[travax]

hi please help me i need put the artefacts in villages

 

[saulius]

Finally, add, and press Enter create_account.php biski wait a few seconds and everything and Assyrian artifacts than Natars

 

[Dzoki]

I would like to see their like 3-4 pages conversation

I'll let them talk. At least I'll laugh a bit.

 

[travax]

Finally, add, and press Enter create_account.php biski wait a few seconds and everything and Assyrian artifacts than Natars

please give me the code php

I'll let them talk. At least I'll laugh a bit.

Dzoki you are the best programmer of the world, how i can put the artefacts in villages??

 

[Dzoki]

Dzoki you are the best programmer of the world, how i can put the artefacts in villages??

Yes I know, I'm God of the PHP.

 

[travax]

Yes I know, I'm God of the PHP.

jajaja yes tu eres el mejor xD, pero tell me the code php for put the artefacts, how tables i need modified in phpmyadmjin

 

[saulius]

<?php

/** --------------------------------------------------- **\
| ********* DO NOT REMOVE THIS COPYRIGHT NOTICE ********* |
+---------------------------------------------------------+
| Credits:     All the developers including the leaders:  |
|              Advocaite & Dzoki & Donnchadh              |
|                                                         |
| Copyright:   TravianX Project All rights reserved       |
\** --------------------------------------------------- **/


        include_once ("GameEngine/Session.php");
        include_once ("GameEngine/config.php");

        mysql_connect(SQL_SERVER, SQL_USER, SQL_PASS);
        mysql_select_db(SQL_DB);

/**
 * If user is not administrator, access is denied!
 */
        if($session->access < ADMIN)
        	die("Access Denied: You are not Admin!");

/**
 * Functions
 */
        function generateBase($kid, $uid, $username) {
        	global $database, $message;
        	if($kid == 0) {
        		$kid = rand(1, 4);
        	} else {
        		$kid = $_POST['kid'];
        	}

        	$wid = $database->generateBase($kid);
        	$database->setFieldTaken($wid);
        	$database->addVillage($wid, $uid, $username, 1);
        	$database->addResourceFields($wid, $database->getVillageType($wid));
        	$database->addUnits($wid);
        	$database->addTech($wid);
        	$database->addABTech($wid);
        	$database->updateUserField($uid, "access", USER, 1);
        	$message->sendWelcome($uid, $username);
        }

/**
 * Creating account & capital village
 */
        $username = "Natars";
        $password = md5('013ab00e4' . rand(999999999999, 9999999999999999999999999) . 'f248588ed');
        $email = "natars@travianx.com";
        $tribe = 5;
        $desc = "********************
                    [#natars]
                ********************";

        $q = "INSERT INTO " . TB_PREFIX . "users (id,username,password,access,email,timestamp,tribe,location,act,protect) VALUES (3, '$username', '$password', " . USER . ", '$email', ".time().", $tribe, '', '', 0)";
        mysql_query($q);
        unset($q);
        $uid = $database->getUserField($username, 'id', 1);
        generateBase(0, $uid, $username);
        $wid = mysql_fetch_assoc(mysql_query("SELECT * FROM " . TB_PREFIX . "vdata WHERE owner = $uid"));
        $q = "UPDATE " . TB_PREFIX . "vdata SET pop = 834 WHERE owner = $uid";
        mysql_query($q) or die(mysql_error());
        $q2 = "UPDATE " . TB_PREFIX . "users SET access = 0 WHERE id = $uid";
        mysql_query($q2) or die(mysql_error());
        if(SPEED > 3) {
        	$speed = 5;
        } else {
        	$speed = SPEED;
        }
        $q3 = "UPDATE " . TB_PREFIX . "units SET u41 = " . (64700 * $speed) . ", u42 = " . (295231 * $speed) . ", u43 = " . (180747 * $speed) . ", u44 = " . (7 * $speed) . ", u45 = " . (364401 * $speed) . ", u46 = " . (217602 * $speed) . ", u47 = " . (2034 * $speed) . ", u48 = " . (1040 * $speed) . " , u49 = " . (1 * $speed) . ", u50 = " . (9 * $speed) . " WHERE vref = " . $wid['wref'] . "";
        mysql_query($q3) or die(mysql_error());
        $q4 = "UPDATE " . TB_PREFIX . "users SET desc2 = '$desc' WHERE id = $uid";
        mysql_query($q4) or die(mysql_error());


/**
 * SMALL ARTEFACTS
 */
        function Artefact($uid, $type, $size, $art_name, $village_name, $desc, $effect, $img) {
        	global $database;
        	$kid = rand(1, 4);
        	$wid = $database->generateBase($kid);
        	$database->addArtefact($wid, $uid, $type, $size, $art_name, $desc, $effect, $img);
        	$database->setFieldTaken($wid);
        	$database->addVillage($wid, $uid, $village_name, '0');
        	$database->addResourceFields($wid, $database->getVillageType($wid));
        	$database->addUnits($wid);
        	$database->addTech($wid);
        	$database->addABTech($wid);
        	mysql_query("UPDATE " . TB_PREFIX . "vdata SET pop = 163 WHERE wref = $wid");
        	mysql_query("UPDATE " . TB_PREFIX . "vdata SET name = '$village_name' WHERE wref = $wid");
        	if(SPEED > 3) {
        		$speed = 5;
        	} else {
        		$speed = SPEED;
        	}
        	if($size == 1) {
        		mysql_query("UPDATE " . TB_PREFIX . "units SET u41 = " . (rand(1000, 2000) * $speed) . ", u42 = " . (rand(1500, 2000) * $speed) . ", u43 = " . (rand(2300, 2800) * $speed) . ", u44 = " . (rand(25, 75) * $speed) . ", u45 = " . (rand(1200, 1900) * $speed) . ", u46 = " . (rand(1500, 2000) * $speed) . ", u47 = " . (rand(500, 900) * $speed) . ", u48 = " . (rand(100, 300) * $speed) . " , u49 = " . (rand(1, 5) * $speed) . ", u50 = " . (rand(1, 5) * $speed) . " WHERE vref = " . $wid . "");
        		mysql_query("UPDATE " . TB_PREFIX . "fdata SET f22t = 27, f22 = 10, f28t = 25, f28 = 10, f19t = 23, f19 = 10, f32t = 23, f32 = 10 WHERE vref = $wid");
        	} elseif($size == 2) {
        		mysql_query("UPDATE " . TB_PREFIX . "units SET u41 = " . (rand(2000, 4000) * $speed) . ", u42 = " . (rand(3000, 4000) * $speed) . ", u43 = " . (rand(4600, 5600) * $speed) . ", u44 = " . (rand(50, 150) * $speed) . ", u45 = " . (rand(2400, 3800) * $speed) . ", u46 = " . (rand(3000, 4000) * $speed) . ", u47 = " . (rand(1000, 1800) * $speed) . ", u48 = " . (rand(200, 600) * $speed) . " , u49 = " . (rand(2, 10) * $speed) . ", u50 = " . (rand(2, 10) * $speed) . " WHERE vref = " . $wid . "");
        		mysql_query("UPDATE " . TB_PREFIX . "fdata SET f22t = 27, f22 = 10, f28t = 25, f28 = 20, f19t = 23, f19 = 10, f32t = 23, f32 = 10 WHERE vref = $wid");
        	} elseif($size == 3) {
        		mysql_query("UPDATE " . TB_PREFIX . "units SET u41 = " . (rand(4000, 8000) * $speed) . ", u42 = " . (rand(6000, 8000) * $speed) . ", u43 = " . (rand(9200, 11200) * $speed) . ", u44 = " . (rand(100, 300) * $speed) . ", u45 = " . (rand(4800, 7600) * $speed) . ", u46 = " . (rand(6000, 8000) * $speed) . ", u47 = " . (rand(2000, 3600) * $speed) . ", u48 = " . (rand(400, 1200) * $speed) . " , u49 = " . (rand(4, 20) * $speed) . ", u50 = " . (rand(4, 20) * $speed) . " WHERE vref = " . $wid . "");
        		mysql_query("UPDATE " . TB_PREFIX . "fdata SET f22t = 27, f22 = 10, f28t = 25, f28 = 20, f19t = 23, f19 = 10, f32t = 23, f32 = 10 WHERE vref = $wid");
        	}
        }

/**
 * THE ARCHITECTS
 */

        $desc = 'All buildings in the area of effect are stronger. This means that you will need more catapults to damage buildings protected by this artifacts powers.';
        
        
        $vname = 'Diamond Chisel';
        $effect = '(4x)';
        for($i > 1; $i < 6; $i++) {
        	Artefact($uid, 1, 1, 'The architects slight secret', '' . $vname . '', '' . $desc . '', '' . $effect . '', 'type1.gif');
        }

        unset($i);
        unset($vname);
        unset($effect);
        $vname = 'Giant Marble Hammer';
        $effect = '(3x)';
        for($i > 1; $i < 4; $i++) {
        	Artefact($uid, 1, 2, 'The architects great secret', '' . $vname . '', '' . $desc . '', '' . $effect . '', 'type1.gif');
        }

        unset($i);
        unset($vname);
        unset($effect);
        $vname = 'Hemons Scrolls';
        $effect = '(5x)';
        for($i > 1; $i < 1; $i++) {
        	Artefact($uid, 1, 3, 'The architects unique secret', '' . $vname . '', '' . $desc . '', '' . $effect . '', 'type1.gif');
        }

/**
 * MILITARY HASTE
 */


        $desc = 'All troops in the area of effect move faster.';

        unset($i);
        unset($vname);
        unset($effect);
        $vname = 'Opal Horseshoe';
        $effect = '(2x)';
        for($i > 1; $i < 6; $i++) {
        	Artefact($uid, 2, 1, 'The slight titan boots', '' . $vname . '', '' . $desc . '', '' . $effect . '', 'type2.gif');
        }

        unset($i);
        unset($vname);
        unset($effect);
        $vname = 'Golden Chariot';
        $effect = '(1.5x)';
        for($i > 1; $i < 4; $i++) {
        	Artefact($uid, 2, 2, 'The great titan boots', '' . $vname . '', '' . $desc . '', '' . $effect . '', 'type2.gif');
        }

        unset($i);
        unset($vname);
        unset($effect);
        $vname = 'Pheidippides Sandals';
        $effect = '(3x)';
        for($i > 1; $i < 1; $i++) {
        	Artefact($uid, 2, 3, 'The unique titan boots', '' . $vname . '', '' . $desc . '', '' . $effect . '', 'type2.gif');
        }

/**
 * HAWK'S EYESIGHT
 */


        $desc = 'All spies (Scouts, Pathfinders, and Equites Legati) increase their spying ability. In addition, with all versions of this artifact you can see the incoming TYPE of troops but not how many there are.';

        unset($i);
        unset($vname);
        unset($effect);
        $vname = 'Tale of a Rat';
        $effect = '(5x)';
        for($i > 1; $i < 6; $i++) {
        	Artefact($uid, 3, 1, 'The eagles slight eyes', '' . $vname . '', '' . $desc . '', '' . $effect . '', 'type3.gif');
        }

        unset($i);
        unset($vname);
        unset($effect);
        $vname = 'Generals Letter';
        $effect = '(3x)';
        for($i > 1; $i < 4; $i++) {
        	Artefact($uid, 3, 2, 'The eagles great eyes', '' . $vname . '', '' . $desc . '', '' . $effect . '', 'type3.gif');
        }

        unset($i);
        unset($vname);
        unset($effect);
        $vname = 'Diary of Sun Tzu';
        $effect = '(10x)';
        for($i > 1; $i < 1; $i++) {
        	Artefact($uid, 3, 3, 'The eagles unique eyes', '' . $vname . '', '' . $desc . '', '' . $effect . '', 'type3.gif');
        }

/**
 * THE DIET
 */


        $desc = 'All troops in the artifacts range consume less wheat, making it possible to maintain a larger army.';

        unset($i);
        unset($vname);
        unset($effect);
        $vname = 'Silver Platter';
        $effect = '(50%)';
        for($i > 1; $i < 6; $i++) {
        	Artefact($uid, 4, 1, 'Slight diet control', '' . $vname . '', '' . $desc . '', '' . $effect . '', 'type4.gif');
        }

        unset($i);
        unset($vname);
        unset($effect);
        $vname = 'Sacred Hunting Bow';
        $effect = '(25%)';
        for($i > 1; $i < 4; $i++) {
        	Artefact($uid, 4, 2, 'Great diet control', '' . $vname . '', '' . $desc . '', '' . $effect . '', 'type4.gif');
        }

        unset($i);
        unset($vname);
        unset($effect);
        $vname = 'King Arthurs Chalice';
        $effect = '(50%)';
        for($i > 1; $i < 1; $i++) {
        	Artefact($uid, 4, 3, 'Unique diet control', '' . $vname . '', '' . $desc . '', '' . $effect . '', 'type4.gif');
        }


/**
 * ACADEMIC ADVANCEMENT
 */


        $desc = 'Troops are built a certain percentage faster within the scope of the artifact.';

        unset($i);
        unset($vname);
        unset($effect);
        $vname = 'Scribed Soldiers Oath';
        $effect = '(50%)';
        for($i > 1; $i < 6; $i++) {
        	Artefact($uid, 5, 1, 'The trainers slight talent', '' . $vname . '', '' . $desc . '', '' . $effect . '', 'type5.gif');
        }

        unset($i);
        unset($vname);
        unset($effect);
        $vname = 'Declaration of War';
        $effect = '(25%)';
        for($i > 1; $i < 4; $i++) {
        	Artefact($uid, 5, 2, 'The trainers great talent', '' . $vname . '', '' . $desc . '', '' . $effect . '', 'type5.gif');
        }

        unset($i);
        unset($vname);
        unset($effect);
        $vname = 'Memoirs of Alexander the Great';
        $effect = '(50%)';
        for($i > 1; $i < 1; $i++) {
        	Artefact($uid, 5, 3, 'The trainers unique talent', '' . $vname . '', '' . $desc . '', '' . $effect . '', 'type5.gif');
        }


/**
 * STORAGE MASTER PLAN
 */


        $desc = 'With this building plan you are able to build the Great Granary or Great Warehouse in the Village with the artifact, or the whole account depending on the artifact. As long as you posses that artifact you are able to build and enlarge those buildings.';

        unset($i);
        unset($vname);
        unset($effect);;
        $vname = 'Builders Sketch';
        $effect = '';
        for($i > 1; $i < 6; $i++) {
        	Artefact($uid, 6, 1, 'Slight storage masterplan', '' . $vname . '', '' . $desc . '', '' . $effect . '', 'type6.gif');
        }

        unset($i);
        unset($vname);
        unset($effect);
        $vname = 'Babylonian Tablet';
        $effect = '';
        for($i > 1; $i < 4; $i++) {
        	Artefact($uid, 6, 2, 'Great storage masterplan', '' . $vname . '', '' . $desc . '', '' . $effect . '', 'type6.gif');
        }


/**
 * RIVAL'S CONFUSION
 */


        $desc = 'Cranny capacity is increased by a certain amount for each type of artifact. Catapults can only shoot random on villages within this artifacts power. Exceptions are the WW which can always be targeted and the treasure chamber which can always be targeted, except with the unique artifact. When aiming at a resource field only random resource fields can be hit, when aiming at a building only random buildings can be hit.';

        unset($i);
        unset($vname);
        unset($effect);
        $vname = 'Map of the Hidden Caverns';
        $effect = '(200)';
        for($i > 1; $i < 6; $i++) {
        	Artefact($uid, 7, 1, 'Rivals slight confusion', '' . $vname . '', '' . $desc . '', '' . $effect . '', 'type7.gif');
        }

        unset($i);
        unset($vname);
        unset($effect);
        $vname = 'Bottomless Satchel';
        $effect = '(100)';
        for($i > 1; $i < 4; $i++) {
        	Artefact($uid, 7, 2, 'Rivals great confusion', '' . $vname . '', '' . $desc . '', '' . $effect . '', 'type7.gif');
        }

        unset($i);
        unset($vname);
        unset($effect);
        $vname = 'Trojan Horse';
        $effect = '(500)';
        for($i > 1; $i < 1; $i++) {
        	Artefact($uid, 7, 3, 'Rivals unique confusion', '' . $vname . '', '' . $desc . '', '' . $effect . '', 'type7.gif');
        }


/**
 * ARTEFACT OF THE FOOL
 */


        $desc = 'Every 24 hours it gets a random effect, bonus, or penalty (all are possible with the exception of great warehouse, great granary and WW building plans). They change effect AND scope every 24 hours. The unique artifact will always take positive bonuses.';

        unset($i);
        unset($vname);
        unset($effect);
        $vname = 'Pendant of Mischief';
        for($i > 1; $i < 5; $i++) {
        	Artefact($uid, 8, 1, 'Artefact of the slight fool', '' . $vname . '', '' . $desc . '', '' . $effect . '', 'type8.gif');
        }

        unset($i);
        unset($vname);
        unset($effect);
        $vname = 'Pendant of Mischief';
        for($i > 1; $i < 5; $i++) {
        	Artefact($uid, 8, 2, 'Artefact of the slight fool', '' . $vname . '', '' . $desc . '', '' . $effect . '', 'type8.gif');
        }

        unset($i);
        unset($vname);
        unset($effect);
        $vname = 'Forbidden Manuscript';
        for($i > 1; $i < 1; $i++) {
        	Artefact($uid, 8, 3, 'Artefact of the unique fool', '' . $vname . '', '' . $desc . '', '' . $effect . '', 'type8.gif');
        }

Use [*php] tags (without *) next time -.-
Dzoki

 

[travax]

THANKS!!!! BUT WHEN RUN THE FILE I RECEIVED THIS INFORMATION:

Fatal error: Call to undefined method MYSQL_DB::addArtefact() in /membri/travaxx/natares.php on line 86

 

[ZZJHONS]

What is in line 86?

 

[travax]

THE LINE 86 IS:
$database->addArtefact($wid, $uid, $type, $size, $art_name, $desc, $effect, $img);

 

[saulius]

what version you use travian?

 

[Dzoki]

Its because he didnt give you the AddArtefact function that you need to add into mysql_db.php ...

 

[travax]

ok but i have error in db_myql

what version you use travian?

i use the version 4.8.5

 

[ZZJHONS]

add this function on DB_MYSQL:

        	function addArtefact($vref, $owner, $type, $size, $name, $desc, $effect, $img) {
        		$q = "INSERT INTO `" . TB_PREFIX . "artefacts` (`vref`, `owner`, `type`, `size`, `conquered`, `name`, `desc`, `effect`, `img`) VALUES ('$vref', '$owner', '$type', '$size', '" . time() . "', '$name', '$desc', '$effect', '$img')";
        		return mysql_query($q, $this->connection);
        	}

 

[saulius]

would recommend to use v6.0.0 is the most recent version everything works fine

You must be registered to see links

 

[travax]

ok but the artefacts work in th evsersion 4.8.5??

 

[ZZJHONS]

I don't know test it :