· 8 years ago · Jan 14, 2018, 07:42 AM
1CREATE TABLE IF NOT EXISTS `ArmyUnits` (
2 `ID` int(11) NOT NULL auto_increment,
3 `uName` varchar(30) NOT NULL,
4 `Price` int(11) NOT NULL,
5 `Power` int(11) NOT NULL,
6 `Speed` int(11) NOT NULL,
7 `Defence` int(11) NOT NULL,
8 `Information` text NOT NULL,
9 PRIMARY KEY (`ID`)
10) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
11
12CREATE TABLE IF NOT EXISTS `Units` (
13 `ID` int(11) NOT NULL auto_increment,
14 `userID` int(11) NOT NULL,
15 `uName` varchar(30) NOT NULL,
16 `Amount` int(11) NOT NULL,
17 PRIMARY KEY (`ID`)
18) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
19
20CREATE TABLE IF NOT EXISTS `UnitTrain` (
21 `ID` int(11) NOT NULL auto_increment,
22 `tName` varchar(30) NOT NULL,
23 `tDesc` text NOT NULL,
24 `tPrice` int(11) NOT NULL,
25 `tTime` int(11) NOT NULL,
26 `UnitType` varchar(30) NOT NULL,
27 `IncreasePercent` int(11) NOT NULL,
28 PRIMARY KEY (`ID`)
29) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
30
31CREATE TABLE IF NOT EXISTS `UserTrain` (
32 `ID` int(11) NOT NULL auto_increment,
33 `userID` int(11) NOT NULL,
34 `TrainID` int(11) NOT NULL,
35 `CourseName` varchar(30) NOT NULL,
36 `TimeLeft` int(11) NOT NULL,
37 PRIMARY KEY (`ID`)
38) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
39
40CREATE TABLE IF NOT EXISTS `UserUnits` (
41 `ID` int(11) NOT NULL auto_increment,
42 `userID` int(11) NOT NULL,
43 `Power` int(11) NOT NULL,
44 `Speed` int(11) NOT NULL,
45 `Defence` int(11) NOT NULL,
46 `TotalPrice` bigint(92) NOT NULL,
47 `TotalUnits` int(11) NOT NULL,
48 PRIMARY KEY (`ID`)
49) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
50
51
52
53
54
55
56Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /home/languedo/public_html/mobstercountry.com/cron_day.php on line 28
57You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1
58
59
60
61
62
63
64
65
66
67<?php
68include "GameDataConnectRunSiteFile.php";
69global $_CONFIG;
70
71define("MONO_ON", 1);
72require "GameClassRunSiteFolder/class_db_{$_CONFIG['driver']}.php";
73$db=new database;
74$db->configure($_CONFIG['hostname'],
75 $_CONFIG['username'],
76 $_CONFIG['password'],
77 $_CONFIG['database'],
78 $_CONFIG['persistent']);
79$db->connect();
80$c=$db->connection_id;
81$db->query("UPDATE fedjail set fed_days=fed_days-1");
82$q=$db->query("SELECT * FROM fedjail WHERE fed_days=0");
83$ids=array();
84while($r=$db->fetch_row($q))
85{
86$ids[]=$r['fed_userid'];
87}
88if(count($ids) > 0)
89{
90
91$db->query("UPDATE users SET fedjail=0 WHERE userid IN(".implode(",", $ids).")");
92}
93
94$Course = mysql_fetch_array(mysql_query("SELECT `CourseName`,`TrainID`,`TimeLeft` FROM `UserTrain` WHERE (`userID` = ".$_SESSION['userid'].")")) or die(mysql_error());
95$Data = mysql_query("SELECT `tName`,`tTime`,`UnitType`,`IncreasePercent` FROM `UnitTrain` WHERE (`ID` = ".$Course['TrainID'].")");
96
97if(mysql_num_rows($Data))
98{
99$Data = mysql_fetch_array($Data);
100
101if($Course['TimeLeft'] > 1)
102{
103 mysql_query("UPDATE `UserTrain` SET `TimeLeft` = `TimeLeft` - 1 WHERE (`userID` = ".$_SESSION['userid'].") AND (`TimeLeft` > 1)") or die(mysql_error());
104}else{
105 mysql_query("INSERT INTO `events` VALUES ('',".$_SESSION['userid'].",UNIX_TIMESTAMP(),0,'You\'ve successfully completed your ".mysql_real_escape_string($Course['CourseName'])." Course!, Your ".mysql_real_escape_string($Data['UnitType'])." Units will Recieve a ".$Data['IncreasePercent']."% boost in stats.')");
106
107 $Unit = mysql_query("SELECT `Amount` FROM `Units` WHERE (`uName` = '".mysql_real_escape_string($Data['UnitType'])."')") or die(mysql_error());
108
109 if(mysql_num_rows($Unit))
110 {
111 $Unit = mysql_fetch_array($Unit);
112 $Stats = mysql_fetch_array(mysql_query("SELECT `Power`,`Speed`,`Defence` FROM `ArmyUnits` WHERE (`uName` = '".mysql_real_escape_string($Data['UnitType'])."')"));
113
114 $Power = $Stats['Power']*$Unit['Amount']/$Data['IncreasePercent'];
115 $Speed = $Stats['Speed']*$Unit['Amount']/$Data['IncreasePercent'];
116 $Defence = $Stats['Defence']*$Unit['Amount']/$Data['IncreasePercent'];
117 mysql_query("UPDATE `UserUnits` SET `Power` = `Power` + $Power,`Speed` = `Speed` + $Speed,`Defence` = `Defence` + $Defence WHERE (`userID` = ".$_SESSION['userid'].")");
118 mysql_query("DELETE FROM `UserTrain` WHERE (`userID` = ".$_SESSION['userid'].")");
119 }
120 }
121 }
122
123
124
125
126
127$db->query("DELETE FROM fedjail WHERE fed_days=0");
128$db->query("UPDATE users SET daysingang=daysingang+1 WHERE gang > 0");
129$db->query("UPDATE users SET daysold=daysold+1, boxes_opened=0");
130$db->query("UPDATE users SET mailban=mailban-1 WHERE mailban > 0");
131$db->query("UPDATE users SET donatordays=donatordays-1 WHERE donatordays > 0");
132$db->query("UPDATE users SET cdays=cdays-1 WHERE course > 0");
133$db->query("UPDATE users SET bankmoney=bankmoney+(bankmoney/50) where bankmoney>0");
134$db->query("UPDATE users SET cybermoney=cybermoney+(cybermoney/100*7) where cybermoney>0");
135$q=$db->query("SELECT * FROM users WHERE cdays=0 AND course > 0");
136while($r=$db->fetch_row($q))
137{
138$cd=$db->query("SELECT * FROM courses WHERE crID={$r['course']}");
139$coud=$db->fetch_row($cd);
140$userid=$r['userid'];
141$db->query("INSERT INTO coursesdone VALUES({$r['userid']},{$r['course']})");
142$upd="";
143$ev="";
144if($coud['crSTR'] > 0)
145{
146$upd.=",us.strength=us.strength+{$coud['crSTR']}";
147$ev.=", {$coud['crSTR']} strength";
148}
149if($coud['crGUARD'] > 0)
150{
151$upd.=",us.guard=us.guard+{$coud['crGUARD']}";
152$ev.=", {$coud['crGUARD']} guard";
153}
154if($coud['crLABOUR'] > 0)
155{
156$upd.=",us.labour=us.labour+{$coud['crLABOUR']}";
157$ev.=", {$coud['crLABOUR']} labour";
158}
159if($coud['crAGIL'] > 0)
160{
161$upd.=",us.agility=us.agility+{$coud['crAGIL']}";
162$ev.=", {$coud['crAGIL']} agility";
163}
164if($coud['crIQ'] > 0)
165{
166$upd.=",us.IQ=us.IQ+{$coud['crIQ']}";
167$ev.=", {$coud['crIQ']} IQ";
168}
169$ev=substr($ev,1);
170if ($upd) {
171$db->query("UPDATE users u LEFT JOIN userstats us ON u.userid=us.userid SET us.userid=us.userid $upd WHERE u.userid=$userid");
172}
173$db->query("INSERT INTO events VALUES('',$userid,unix_timestamp(),0,'Congratulations, you completed the {$coud['crNAME']} and gained $ev!')");
174}
175$db->query("UPDATE users SET course=0 WHERE cdays=0");
176$db->query("TRUNCATE TABLE votes;");
177
178?>