script travian 4.4 fire stand

[hamidthcrf]

hello everyone i had share travian 4.4 with new php and new sql this script written with Laravel and we have somthing but in the script
1. register no body can registry
2. Alliance
3.inscription
4.restserver
5. do not have file install
but just you can login with Multihunter pass : 12345
now we should fix this script together
php 7.4
mysql 8.0.15

You must be registered to see links

You must be registered to see links

please who can fix this script
and link download here
download file

first time we should insert cloum country in the sql

INSERT INTO activate (username,password,email,tribe,timestamp,act,act2,ref,location,country) VALUES user, ass, :email, :tribe, :time, :act, :act2,:ref,:location,:country)
Unhandled Exception.
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'country' in 'field list'
DEATH FOR YOU.
Array ( [user] => hamid [pass] => 29449a38abddaa518b1ab77ee66c73e6 => hamidthc@gmail.com [tribe] => 0 [act] => jdros10LT6 [act2] => Qexun [ref] => [time] => 1710345764 [location] => 0 [country] => ad )

 

[azer12]

hello everyone i had share travian 4.4 with new php and new sql this script written with Laravel and we have somthing but in the script
1. register no body can registry
2. Alliance
3.inscription
4.restserver
5. do not have file install
but just you can login with Multihunter pass : 12345
now we should fix this script together
php 7.4
mysql 8.0.15

You must be registered to see links

You must be registered to see links

please who can fix this script
and link download here
download file

first time we should insert cloum country in the sql

INSERT INTO activate (username,password,email,tribe,timestamp,act,act2,ref,location,country) VALUES user, ass, :email, :tribe, :time, :act, :act2,:ref,:location,:country)
Unhandled Exception.
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'country' in 'field list'
DEATH FOR YOU.
Array ( [user] => hamid [pass] => 29449a38abddaa518b1ab77ee66c73e6 => hamidthc@gmail.com [tribe] => 0 [act] => jdros10LT6 [act2] => Qexun [ref] => [time] => 1710345764 [location] => 0 [country] => ad )

CREATE TABLE `activate` (
`id` int(10) UNSIGNED NOT NULL,
`username` varchar(100) NOT NULL,
`password` varchar(100) NOT NULL,
`email` varchar(255) NOT NULL,
`tribe` tinyint(1) UNSIGNED NOT NULL,
`access` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`act` varchar(10) NOT NULL,
`timestamp` int(11) UNSIGNED NOT NULL DEFAULT 0,
`location` tinyint(1) NOT NULL,
`act2` varchar(10) NOT NULL,
`ref` int(11) NOT NULL DEFAULT 0,
`country` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


add `country` int(11) NOT NULL

 

[hamidthcrf]

CREATE TABLE `activate` (
`id` int(10) UNSIGNED NOT NULL,
`username` varchar(100) NOT NULL,
`password` varchar(100) NOT NULL,
`email` varchar(255) NOT NULL,
`tribe` tinyint(1) UNSIGNED NOT NULL,
`access` tinyint(1) UNSIGNED NOT NULL DEFAULT 1,
`act` varchar(10) NOT NULL,
`timestamp` int(11) UNSIGNED NOT NULL DEFAULT 0,
`location` tinyint(1) NOT NULL,
`act2` varchar(10) NOT NULL
`ref` int(11) NOT NULL DEFAULT 0,
`country` int(11) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;


add `country` int(11) NOT NULL

I had fixed old time but problem now is rest.bk rest server and installer. I'm thinking about design agine something like insert