Shakes & Fidget Private - Full Script (Tulyita)

Page 38 of 66

« First

Last »

05/26/2014 07:09 krpet25#556

You need to find this:

Quote:

$db_data ['thirst'] += 1200;
$db_data ['beers'] += 0;
$db_data ['mushroom'] -= 1;

And change it to this:

Quote:

$db_data ['thirst'] += 1200;
$db_data ['beers'] += 1;
$db_data ['mushroom'] -= 1;

05/26/2014 07:44 UND3RW0RLD#557

Quote:

Originally Posted by MsCryCZ

ǝnd1ǝss-ɯonǝʎ
~~~~> Bubbles <~~~~
Can you please send me the administration? I think with everything completely! and named it in the bud pm or here on the forum put it necessary to uloz.to, mediafire

ill provide a version of it today. :)

05/26/2014 14:33 MsCryCZ#558

Ok... send me a link when a complete ;) and time ?

05/26/2014 15:31 UND3RW0RLD#559

this is a smaller version of my admin-interface
english version (took me an hour to translate it -.-)
[Only registered and activated users can see links. Click Here To Register...]

install:

-> extract to www-root (htdocs in xampp)

-> change: backend/secrets.php

-> change: backend/config.php

Code:

CREATE TABLE `game_settings` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `setting` varchar(255) NOT NULL,
  `value` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;

Code:

INSERT INTO `game_settings` (`id`, `setting`, `value`) VALUES (NULL, 'EVENT', '0');

request.php
find:

PHP Code:


			
function event(){
$event = 4; //0 = nothing, 1 = TP event, 2 = Epic event, 3 = gold event, 4 = mushroom event, 5 = chirstmas event
return $event;
}

replace with:

PHP Code:


			
function event(){
    $qry = $GLOBALS ['db']->prepare ( "SELECT value FROM game_settings WHERE setting = 'EVENT' LIMIT 1" );
    $qry->execute ();
    $res = $qry->fetchAll ( PDO::FETCH_ASSOC );
    $event = $res [0] ['value'];
    return $event;
}

Code:

ALTER TABLE  `user_data` ADD  `last_ip` VARCHAR( 30 ) NOT NULL AFTER  `email` ;

find:

PHP Code:


			
        // add new user to DB
        $qry = $db->prepare

put over it:

PHP Code:


			
        // Jessis Multi-Acc-fix
        $ip = $_SERVER['REMOTE_ADDR'];
        // End of Fix

extend query with last_ip

find:

PHP Code:


			
        $qry->bindParam ( ':pass', $pass );

put over it:

PHP Code:


			
        $qry->bindParam ( ':lastip', $ip );

find:

PHP Code:


			
        // set ssid in database
        $qry = $db->prepare

put over it:

PHP Code:


			
        // Jessis Multi-Acc-fix
        $ip = $_SERVER['REMOTE_ADDR'];
        // End of Fix

extend the query

find:

PHP Code:


			
        $qry->bindParam ( ':id', $db_data ['user_id'] );

put over it:

PHP Code:


			
        $qry->bindParam ( ':ip', $ip );

find:

PHP Code:


			
 if ($db_data ['medal_commerce'] < $db_data ['silver']){
$db_data ['medal_commerce'] = $db_data ['silver']; 
$qry = $db->prepare ( "UPDATE user_data SET
medal_commerce = :medalc
WHERE ssid = :ssid" );

put over it

PHP Code:


			
 // UPDATE IP
$ip = $_SERVER['REMOTE_ADDR'];
$qry = $db->prepare ( "UPDATE user_data SET last_ip = :lastip WHERE ssid = :ssid" );
$qry->bindParam ( ':lastip', $ip );
$qry->bindParam ( ':ssid', $SSID);
$qry->execute ();
// End of UPDATE IP

Code:

ALTER TABLE `user_data` ADD `last_activ` VARCHAR( 30 ) NOT NULL AFTER `last_ip`

find

PHP Code:


			
        // UPDATE IP
        $ip = $_SERVER['REMOTE_ADDR'];
        $qry = $db->prepare ( "UPDATE user_data SET last_ip = :lastip WHERE ssid = :ssid" );
        $qry->bindParam ( ':lastip', $ip );
        $qry->bindParam ( ':ssid', $SSID);
        $qry->execute ();
        // End of UPDATE IP

replace with

PHP Code:


			
        // UPDATE IP & activity
        $ip = $_SERVER['REMOTE_ADDR'];
        $qry = $db->prepare ( "UPDATE user_data SET last_ip = :lastip, last_activ = :lastactiv WHERE ssid = :ssid" );
        $qry->bindParam ( ':lastip', $ip );
        $qry->bindParam ( ':lastactiv', $time );
        $qry->bindParam ( ':ssid', $SSID);
        $qry->execute ();
        // End of UPDATE IP & activity

find:

PHP Code:


			
        // potions
        
        $time = new DateTime ();
        $time = $time->getTimestamp ();

cut

PHP Code:


			
$time = new DateTime ();
        $time = $time->getTimestamp ();

put it over

PHP Code:


			
        // UPDATE IP & activity
        $ip = $_SERVER['REMOTE_ADDR'];

have fun :)

05/26/2014 15:53 EptunLP#560

And i also provide czech version here! :)
---- Link deleted ----

05/26/2014 15:57 TheBreakZus#561

It works perfect thanks a lot ;)

Gesendet von meinem HUAWEI P6-U06 mit Hilfe von Elitepvpers, bereitgestellt von appyet.com

05/26/2014 16:51 Dmixior#562

Maybe do you have clear files in witch you change this values?

05/26/2014 17:08 Sainze.#563

Wenn ich Beim Turm ein Gegner angreiffe dann Habe ich aufeinmal Keine Verbindung mehr

Oder Bei mir ist dauerthaft eine Quest Ich kann keine Neue anw�hlen Tr�nke werden nicht Angezeigt bei meinem Char und Auch keine Attribute :))
Bitte Helft mir

If I attack an enemy tower when suddenly I Have No longer a connection

Or With me is permanently a quest I can not select New potions are not Indicated for my char and also no attributes :))
Please Help me

05/26/2014 17:28 WielkaNogawka#564

Quote:
Originally Posted by ǝnd1ǝss-ɯonǝʎ
this is a smaller version of my admin-interface
english version (took me an hour to translate it -.-)
[Only registered and activated users can see links. Click Here To Register...]

install:

-> extract to www-root (htdocs in xampp)

-> change: backend/secrets.php

-> change: backend/config.php
Code:
CREATE TABLE `game_settings` (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `setting` varchar(255) NOT NULL,
  `value` varchar(255) NOT NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1;
Code:
INSERT INTO `game_settings` (`id`, `setting`, `value`) VALUES (NULL, 'EVENT', '0');
request.php
find:

PHP Code:

function event(){ $event = 4; //0 = nothing, 1 = TP event, 2 = Epic event, 3 = gold event, 4 = mushroom event, 5 = chirstmas event return $event; }

replace with:

PHP Code:

function event(){ $qry = $GLOBALS ['db']->prepare ( "SELECT value FROM game_settings WHERE setting = 'EVENT' LIMIT 1" ); $qry->execute (); $res = $qry->fetchAll ( PDO::FETCH_ASSOC ); $event = $res [0] ['value']; return $event; }
Code:
ALTER TABLE  `user_data` ADD  `last_ip` VARCHAR( 30 ) NOT NULL AFTER  `email` ;
find:

PHP Code:

        // add new user to DB         $qry = $db->prepare

put over it:

PHP Code:

        // Jessis Multi-Acc-fix         $ip = $_SERVER['REMOTE_ADDR'];         // End of Fix

extend query with last_ip

find:

PHP Code:

        $qry->bindParam ( ':pass', $pass );

put over it:

PHP Code:

        $qry->bindParam ( ':lastip', $ip );

find:

PHP Code:

        // set ssid in database         $qry = $db->prepare

put over it:

PHP Code:

        // Jessis Multi-Acc-fix         $ip = $_SERVER['REMOTE_ADDR'];         // End of Fix

extend the query

find:

PHP Code:

        $qry->bindParam ( ':id', $db_data ['user_id'] );

put over it:

PHP Code:

        $qry->bindParam ( ':ip', $ip );

find:

PHP Code:

if ($db_data ['medal_commerce'] < $db_data ['silver']){ $db_data ['medal_commerce'] = $db_data ['silver']; $qry = $db->prepare ( "UPDATE user_data SET medal_commerce = :medalc WHERE ssid = :ssid" );

put over it

PHP Code:

// UPDATE IP $ip = $_SERVER['REMOTE_ADDR']; $qry = $db->prepare ( "UPDATE user_data SET last_ip = :lastip WHERE ssid = :ssid" ); $qry->bindParam ( ':lastip', $ip ); $qry->bindParam ( ':ssid', $SSID); $qry->execute (); // End of UPDATE IP
Code:
ALTER TABLE `user_data` ADD `last_activ` VARCHAR( 30 ) NOT NULL AFTER `last_ip`
find

PHP Code:

        // UPDATE IP         $ip = $_SERVER['REMOTE_ADDR'];         $qry = $db->prepare ( "UPDATE user_data SET last_ip = :lastip WHERE ssid = :ssid" );         $qry->bindParam ( ':lastip', $ip );         $qry->bindParam ( ':ssid', $SSID);         $qry->execute ();         // End of UPDATE IP

replace with

PHP Code:

        // UPDATE IP & activity         $ip = $_SERVER['REMOTE_ADDR'];         $qry = $db->prepare ( "UPDATE user_data SET last_ip = :lastip, last_activ = :lastactiv WHERE ssid = :ssid" );         $qry->bindParam ( ':lastip', $ip );         $qry->bindParam ( ':lastactiv', $time );         $qry->bindParam ( ':ssid', $SSID);         $qry->execute ();         // End of UPDATE IP & activity

find:

PHP Code:

        // potions                  $time = new DateTime ();         $time = $time->getTimestamp ();

cut

PHP Code:

$time = new DateTime ();         $time = $time->getTimestamp ();

put it over

PHP Code:

        // UPDATE IP & activity         $ip = $_SERVER['REMOTE_ADDR'];

have fun :)

not work for me ;/
can you send me this request? (request only) please?

05/26/2014 17:36 UND3RW0RLD#565

Quote:

Originally Posted by WielkaNogawka

not work for me ;/
can you send me this request? (request only) please?

-.-" the third..

I'll publish the needed "ACTS"

If you did changes to the ACTs you have to do them again after replacing them with mine, or you try it again with the old installation-guide. which is correct.. (i tried it based on a fresh request.php)

replacing the function event() is up to your own.

ACT_REGISTER

Spoiler

PHP Code:


			
    case $ACT_REGISTER :

        // req structure

        // 001Admin;spierdalaj;[Only registered and activated users can see links. Click Here To Register...];;;1;1;2;3/510/501/4/510/2/2/7/1/%3B

            

        $npe = explode ( ";", $action_extra );

        

        $nick = $npe [0];

        $pass = $npe [1];

        $email = urlencode(strtolower($npe [2]));

        

        // var_dump($npe);

        

        // break;

        

        // nick & pass lenghts

        if (strlen ( $nick ) < 3 || strlen ( $nick ) > 20) {

            // throw error & break;

            $ret = array (

                    $ERR_NAME_TOO_SHORT 

            );

            break;

        }

        if ( preg_match("/[^-a-z0-9_]/i", $nick) )

        {

            // throw error & break;

            $ret = array (

                    $ERR_NAME_EXISTS

            );

            break;

        }

        if (strlen ( $pass ) < 4) {

            // throw error & break;

            $ret = array (

                    $ERR_PASSWORD_TOO_SHORT 

            );

            break;

        }

        if ( preg_match("/[^-a-z0-9_]/i", $pass) )

        {

            // throw error & break;

            $ret = array (

                    $ERR_NAME_EXISTS

            );

            break;

        }

        

        // TODO: validate email

        

        // check db for duplicates

        $qry = $db->prepare ( "SELECT user_name, email FROM user_data 

                                WHERE user_name = :name OR email = :email" );

        $qry->bindParam ( ':name', $nick );

        $qry->bindParam ( 'email', $email );

        $qry->execute ();

        

        // var_dump ( $qry->fetchAll ()[0] );

        // exit ();

        

        // if duplicates, throw error & break

        if ($qry->rowCount () > 0) {

            $duplicate = $qry->fetchAll ( PDO::FETCH_ASSOC );

            $duplicate = $duplicate [0];

            

            if ($duplicate ['email'] == $email) {

                // throw error & break;

                $ret = array (

                        $ERR_EMAIL_EXISTS 

                );

                break;

            }

            

            // throw error & break;

            $ret = array (

                    $ERR_NAME_EXISTS 

            );

            break;

        }

        

        // character looks

        $looks = explode ( "/", $npe [8] );

        $looks [1] = substr_replace ( $looks [1], "0", 1, 1 );

        $looks [2] = substr_replace ( $looks [2], "0", 1, 1 );

        $looks [4] = substr_replace ( $looks [4], "0", 1, 1 );

        // var_dump($looks);

        // break;

        

        // class

        $class = $npe [7];

        

        // race

        $race = $npe [5];

        

        // gender

        $gender = $npe [6];

        

        // stats

        $stats = loadDefaultStats ( $class, $race );

        

        //hash password

        $pass = md5($pass);



        // Jessis Multi-Acc-fix

        $ip = $_SERVER['REMOTE_ADDR'];

        // End of Fix



        // add new user to DB

        $qry = $db->prepare ( "INSERT INTO user_data(user_name, password, email, last_ip, face1, face2, face3, face4, face5, face6, face7, face8, face9, face10, reg_date, class, race, gender, attr_str, attr_agi, attr_int, attr_wit, attr_luck) 

                                VALUES(:name, :pass, :email, :lastip, :face1, :face2, :face3, :face4, :face5, :face6, :face7, :face8, :face9, :face10, :reg_date, :class, :race, :gender, :str, :agi, :int, :wit, :luck)" );

        $qry->bindParam ( ':name', $nick );

        $qry->bindParam ( ':lastip', $ip );

        $qry->bindParam ( ':pass', $pass );

        $qry->bindParam ( ':email', $email );

        for($i = 1; $i < 11; $i ++) {

            $qry->bindParam ( ':face' . $i, $looks [$i - 1] );

        }

        // timestmp

        $time = new DateTime ();

        $qry->bindParam ( ':reg_date', $time->getTimestamp () );

        

        $qry->bindParam ( ':class', $class );

        $qry->bindParam ( ':race', $race );

        $qry->bindParam ( ':gender', $gender );

        

        // default stats

        $qry->bindParam ( ':str', $stats [0] );

        $qry->bindParam ( ':agi', $stats [1] );

        $qry->bindParam ( ':int', $stats [2] );

        $qry->bindParam ( ':wit', $stats [3] );

        $qry->bindParam ( ':luck', $stats [4] );

        

        $qry->execute ();

        

        // get user id

        $qry = $db->prepare ( "SELECT user_id FROM user_data WHERE user_name = :name" );

        $qry->bindParam ( ":name", $nick );

        $qry->execute ();

        

        $res = $qry->fetchAll ();

        $a = $res [0] ['user_id'];

        

        $ret = array (

                $ACT_REGISTER . $a 

        );

        

        

        break;

ACT_LOGIN

Spoiler

PHP Code:


			
    case $ACT_LOGIN :

        // req structure

        // 000...002Lama%3B9c4c7db44e0e052a942accedb1731da7%3Bv1.70

        

        $nnp = explode ( ';', substr ( $req, 35 ) );

        

        $nick = $nnp [0];

        $pass = $nnp [1];

        

        // ret structure

        // 0021463844515/278943/1387059536/1354973173/930801237/14/0/101/2650259/3391480/9231/17024/-1/328034687/92/644/576/5/102/105/3/103/5/1/2/1/0/6/2141978625/2/63/67/306/229/70/47/67/197/66/124/0/0/232/163/0/0/0/0/6/1006/47/0/2/3/4/17/15/0/412/0/3/1006/21/0/2/3/5/18/14/0/631/0/5/1007/39/0/3/1/4/19/15/0/842/0/4/1002/9/0/4/5/2/6/0/0/118/0/8/51/0/0/3/4/5/28/28/28/7936/0/7/1007/52/0/3/4/5/33/0/0/714/0/9/7/0/0/3/1/2/56/0/0/7512/0/10/53/0/0/6/0/0/32/0/0/13254/0/1/1006/53/155/5/1/3/64/0/0/2060/0/0/0/0/0/0/0/0/0/0/0/0/0/1/1009/333/513/4/5/1/352/0/0/278980/0/1/1008/361/503/5/3/4/224/156/0/114989/0/8/20/0/0/5/1/2/105/73/0/73436/0/11/40/0/0/0/0/0/0/0/0/0/0/5/1010/281/0/1/2/5/102/88/0/94372/0/1387023983/101/101/101/4/6/1/-55/-27/-70/13/20/20/900/900/300/0/31/0/0/2/5/3/196/0/0/187643/0/0/14/0/0/2/3/5/107/87/0/78922/0/0/1010/274/0/1/4/5/116/78/0/148642/0/62600/29000/20600/875500/1516200/331300/0/1385644107/6/1008/194/0/5/4/3/89/87/0/283597/10/7/1009/271/0/4/2/3/172/0/0/509638/0/5/1009/132/0/2/3/4/103/67/0/387432/10/1/1009/246/610/3/5/2/376/0/0/1597458/0/7/1010/212/0/1/5/4/103/75/0/371449/10/7/1010/208/0/4/1/3/98/76/0/366471/10/1385643304/8/11/0/0/3/2/5/179/0/0/512765/0/8/4/0/0/5/2/1/176/0/0/482435/0/12/15/0/0/11/5/0/72/25/0/201308/0/12/11/0/0/11/1/0/72/25/0/201308/0/8/1/0/0/1/2/3/168/0/0/399945/0/9/7/0/0/2/5/4/87/87/0/72832/1/0/0/0/1/1/10170/0/0/0/0/1354976531/0/0/0/168/53/155/0/0/0/0/0/1387017833/0/0/17/1386425067/1386336236/50/50/1/13549730/101/17/1/3894/4598/337084657/21948/0/0/55/0/0/4/1386421467/4/11/7/5/2/2/2/2/2/0/0/120/0/0/0/0/0/0/0/0/0/0/0/0/-1283791275/-1283791275/-1283791275/1/1355336963/0/0/1387059536/;0;900Kv99994c731E6696F9Oj4u973O47m;0;470;0

        

        // get user data

        $qry = $db->prepare ( "SELECT user_data.*, guilds.treasure, guilds.instructor, guilds.dung,  

                (

                SELECT Count(*) FROM messages WHERE messages.read = 0 AND messages.reciver_id = user_id

                ) AS c, (

                    SELECT Count(*) + 1 FROM user_data WHERE user_data.honor > (

                        SELECT honor FROM user_data WHERE user_name = :name

                    )

                ) AS rank

                FROM user_data 

                LEFT JOIN guilds ON guilds.guild_id = user_data.guild_id 

                WHERE user_name = :name2" );

        $qry->bindParam ( ':name', $nick );

        $qry->bindParam ( ':name2', $nick );

        $qry->execute ();

        

        // if qry returned nothing, throw no such player exception & break

        if ($qry->rowCount () == 0) {

            $ret = array (

                    $ERR_LOGIN_FAILED 

            );

            break;

        }

        

        // user data

        $db_data = $qry->fetchAll ( PDO::FETCH_ASSOC );

        $db_data = $db_data [0];

        

        // compare passwords, if wrong, throw wrong password exception & break

        

        $db_pass = $db_data ['password'];

        

        if ($pass != $db_pass) {

            $ret = array (

                    $ERR_LOGIN_FAILED  // $ERR_WRONG_PASSWORD

                        );

            

            break;

        }

        

        // load data

        loadDefaultData ( $db_data );

        

        // set action

        $ret [0] = $ACT_LOGIN . $ret [0];

        

        // GEN SSID

        $SSID = md5 ( microtime () );



        // Jessis Multi-Acc-fix

        $ip = $_SERVER['REMOTE_ADDR'];

        // End of Fix

        

        // set ssid in database

        $qry = $db->prepare ( "UPDATE user_data SET ssid = :ssid, last_ip = :ip WHERE user_id = :id" );

        $qry->bindParam ( ':ssid', $SSID );

        $qry->bindParam ( ':ip', $ip );

        $qry->bindParam ( ':id', $db_data ['user_id'] );

        $qry->execute ();

        

        // structure

        // ;0;ji6m720a88R6kIT68ik8D8K84AF1t8DJ;0;470;0

        // 470???

        $ret [511] = ";0;$SSID;0;470;0";

        

        // SET GUILD INDEX

        $ret [$SF_GUILD_INDEX] = $db_data ['guild_id'];

        

        break;

ACT_HERO

Spoiler

05/26/2014 22:09 Messias_80#566

Erstmal VIELEN VIELEN VIELEN DANK an alle die hier gearbeitet haben und es zu standen gebracht haben <3

Ich h�tte allerdings paar fragen:

1. Wie kann ich die Zeit der Quests umstellen, damit es nicht iwie 30Sek oder so dauert sondern wie im echten, 5, 10, 15, 20min.

2. Bei einer SQL geht der Turm aber alles andere ist verbuggt, bei der anderen geht der Turm nicht aber der Rest l�uft einwandfrei.

Ich wei� ist unh�fflich zu fragen weil ihr schon so viel Arbeit geleistet habt, w�rde mich aber trotzdem �ber eine Antwort freuen :).

05/27/2014 09:07 Crasim#567

Excuse me do you know where is the control of the composition of the email?
ES: "jonh.doe" "@" "email" "." "tld"?
because at the moment anyone can register with random characters .. and I wanted to create a system of email newsletters but will always bring a lot of errors if "fake email" is then serves also for an eventual recovery password

05/27/2014 09:19 UND3RW0RLD#568

PHP Code:


			
case $ACT_REGISTER :

PHP Code:


			
// TODO: validate email

PHP Code:


			
$ERR_EMAIL_REJECTED

have fun :D

script (not adapted for request.php)

Spoiler

05/27/2014 09:34 Crasim#569

Quote:

Originally Posted by ǝnd1ǝss-ɯonǝʎ

PHP Code:

case $ACT_REGISTER :

PHP Code:

// TODO: validate email

PHP Code:

$ERR_EMAIL_REJECTED

have fun :D

script (not adapted for request.php)

Spoiler

PHP Code:

function validemail($email, $checkdns = true, $umlaute = true) { if(preg_match("/^[a-zA-Z0-9_.-]+@[a-zA-Z0-9][a-zA-Z0-9-.]+\.([a-zA-Z]{2,6})$/" , $email) && filter_var($email, FILTER_VALIDATE_EMAIL) !== false ) { $tmp = explode('@', $email); $domain = $tmp[1]; if($checkdns && @dns_get_record($domain) === false) { return false; } } elseif($umlaute && preg_match('/^[a-zA-Z0-9��_.-]+@[a-zA-Z0-9��][a-zA-Z0-9-��.]+\.([a-zA-Z]{2,6})$/', $email)) { return true; } else { return false; } return true; }

For reset password is possible change url of request ? on swf ?
[Only registered and activated users can see links. Click Here To Register...]

05/27/2014 14:37 BaToTu#570

I've got that problem someone can help?

Text

Text

Text

Zarejestrowani uzytkownicy: 0

Ukončit

Page 38 of 66

« First

Last »