SA-MP Forums

Go Back   SA-MP Forums > SA-MP Scripting and Plugins > Gamemode Scripts

Reply
 
Thread Tools Display Modes
Old 10/05/2015, 01:16 PM   #11
PowerF
Huge Clucker
 
PowerF's Avatar
 
Join Date: May 2014
Posts: 391
Reputation: 3
Default Re: California Cops and Robbers 0.3.7 (Fully MySQL+UCP) (Lot of Features) (Minigames)

btw,why i need Super Privileged user to upload the database?is it from my hosting or your database setting?
PowerF is offline   Reply With Quote
Old 10/05/2015, 01:34 PM   #12
Stev
Big Clucker
 
Stev's Avatar
 
Join Date: Oct 2013
Location: United Kingdom
Posts: 113
Reputation: 15
Default Re: California Cops and Robbers 0.3.7 (Fully MySQL+UCP) (Lot of Features) (Minigames)

Database.
Stev is offline   Reply With Quote
Old 10/05/2015, 01:38 PM   #13
Canzy
Little Clucker
 
Join Date: Jan 2015
Posts: 9
Reputation: 0
Default Re: California Cops and Robbers 0.3.7 (Fully MySQL+UCP) (Lot of Features) (Minigames)

Nice
Canzy is offline   Reply With Quote
Old 10/05/2015, 01:45 PM   #14
aCloudy
Big Clucker
 
Join Date: Apr 2014
Posts: 189
Reputation: 2
Default Re: California Cops and Robbers 0.3.7 (Fully MySQL+UCP) (Lot of Features) (Minigames)

Great gamemode, Liked it a lot!
aCloudy is offline   Reply With Quote
Old 11/05/2015, 02:33 AM   #15
X337
Banned
 
Join Date: Sep 2014
Location: Indonesia
Posts: 823
Reputation: 174
Default Re: California Cops and Robbers 0.3.7 (Fully MySQL+UCP) (Lot of Features) (Minigames)

Quote:
Originally Posted by aCloudy View Post
Great gamemode, Liked it a lot!
Quote:
Originally Posted by Canzy View Post
Nice
Quote:
Originally Posted by gelton View Post
Very Nice, goooood job
Thanks all

Quote:
Originally Posted by PowerF View Post
btw,why i need Super Privileged user to upload the database?is it from my hosting or your database setting?
That's from time_function() syntax.
You can delete this syntax on .sql file.
X337 is offline   Reply With Quote
Old 11/05/2015, 08:55 AM   #16
Crystallize
High-roller
 
Join Date: Aug 2013
Posts: 1,367
Reputation: 266
Default Re: California Cops and Robbers 0.3.7 (Fully MySQL+UCP) (Lot of Features) (Minigames)

Good job , I really do like the UCP design , though I haven't tested the GM yet.
__________________
Quote:
Originally Posted by Meller View Post
I thought you were supposed to work at the job?
Crystallize is offline   Reply With Quote
Old 11/05/2015, 08:58 AM   #17
Slotomic
Gangsta
 
Slotomic's Avatar
 
Join Date: Oct 2013
Location: Egypt
Posts: 786
Reputation: 87
Default Re: California Cops and Robbers 0.3.7 (Fully MySQL+UCP) (Lot of Features) (Minigames)

Tested the gamemode but the ban system doesn't work.

MYSQL LOG:
Before banning any player:
Code:
(error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(ban_timestamp + (ban_time * 60), 'unixepoch')) as banExpired, strftime('%d-%m-%' at line 1

After banning a player:
Code:
11:36:22	CMySQLQuery::Execute	ERROR	(error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(ban_timestamp + (ban_time * 60), 'unixepoch')) as banExpired, strftime('%d-%m-%' at line 1
11:36:22	cache_get_row_count	WARNING	no active cache
11:36:29	CMySQLQuery::Execute	ERROR	(error #2006) MySQL server has gone away
11:36:45	CMySQLQuery::Execute	ERROR	(error #1305) FUNCTION ojk.strftime does not exist

ERROR CODE From my conclusion:
Code:
	format(gQuery, MAX_QUERY_LENGTH, "SELECT user_banned, ban_reason, ban_time, (ban_timestamp + (ban_time * 60) - strftime('%%s', 'now')) as banTimeLeft, strftime('%%d-%%m-%%Y %%H:%%M', datetime(ban_timestamp + (ban_time * 60), 'unixepoch')) as banExpired, strftime('%%d-%%m-%%Y %%H:%%M', datetime(ban_timestamp, 'unixepoch')) as bannedFrom, user_banner FROM `bans` WHERE user_banned_ip = '%s' OR user_banned = '%s' AND (banTimeLeft > 0 OR ban_time = 0);", getIP(playerid), GetName(playerid));

Last edited by Slotomic; 11/05/2015 at 09:49 AM.
Slotomic is offline   Reply With Quote
Old 11/05/2015, 11:07 AM   #18
X337
Banned
 
Join Date: Sep 2014
Location: Indonesia
Posts: 823
Reputation: 174
Default Re: California Cops and Robbers 0.3.7 (Fully MySQL+UCP) (Lot of Features) (Minigames)

Quote:
Originally Posted by Wizzard2H View Post
Good job , I really do like the UCP design , though I haven't tested the GM yet.
Thanks Wizzard
Quote:
Originally Posted by Maro06 View Post
Tested the gamemode but the ban system doesn't work.

MYSQL LOG:
Before banning any player:
Code:
(error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(ban_timestamp + (ban_time * 60), 'unixepoch')) as banExpired, strftime('%d-%m-%' at line 1

After banning a player:
Code:
11:36:22	CMySQLQuery::Execute	ERROR	(error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(ban_timestamp + (ban_time * 60), 'unixepoch')) as banExpired, strftime('%d-%m-%' at line 1
11:36:22	cache_get_row_count	WARNING	no active cache
11:36:29	CMySQLQuery::Execute	ERROR	(error #2006) MySQL server has gone away
11:36:45	CMySQLQuery::Execute	ERROR	(error #1305) FUNCTION ojk.strftime does not exist

ERROR CODE From my conclusion:
Code:
	format(gQuery, MAX_QUERY_LENGTH, "SELECT user_banned, ban_reason, ban_time, (ban_timestamp + (ban_time * 60) - strftime('%%s', 'now')) as banTimeLeft, strftime('%%d-%%m-%%Y %%H:%%M', datetime(ban_timestamp + (ban_time * 60), 'unixepoch')) as banExpired, strftime('%%d-%%m-%%Y %%H:%%M', datetime(ban_timestamp, 'unixepoch')) as bannedFrom, user_banner FROM `bans` WHERE user_banned_ip = '%s' OR user_banned = '%s' AND (banTimeLeft > 0 OR ban_time = 0);", getIP(playerid), GetName(playerid));
Yeah, i see the problems on some SQL queries and data type problems on bans tables.
I already fixed the ban system.


You can download fixed socket.inc Here.
and fixed `ban` table Here

Thanks for your information maro
X337 is offline   Reply With Quote
Old 11/05/2015, 11:25 AM   #19
Slotomic
Gangsta
 
Slotomic's Avatar
 
Join Date: Oct 2013
Location: Egypt
Posts: 786
Reputation: 87
Default Re: California Cops and Robbers 0.3.7 (Fully MySQL+UCP) (Lot of Features) (Minigames)

Quote:
Originally Posted by bondowocopz View Post
Thanks Wizzard


Yeah, i see the problems on some SQL queries and data type problems on bans tables.
I already fixed the ban system.


You can download fixed socket.inc Here.
and fixed `ban` table Here

Thanks for your information maro
No problem! Awesome release bro!
Slotomic is offline   Reply With Quote
Old 11/05/2015, 11:37 AM   #20
X337
Banned
 
Join Date: Sep 2014
Location: Indonesia
Posts: 823
Reputation: 174
Default Re: California Cops and Robbers 0.3.7 (Fully MySQL+UCP) (Lot of Features) (Minigames)

Quote:
Originally Posted by Maro06 View Post
No problem! Awesome release bro!
Thanks again maro, some suggestion for this GM are welcomed
X337 is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
What features does a Cops and Robbers mode need and why? Dignity Scripting Help 13 24/07/2014 09:23 PM
Cops and Robbers Features Torran Help Archive 12 04/02/2010 06:10 PM
What basic features do cops and robbers have? JoeDaDude Help Archive 2 18/01/2010 07:09 PM


All times are GMT. The time now is 04:40 PM.


Powered by vBulletin® Version 3.8.6
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.