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: 112
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
Gangsta
 
X337's Avatar
 
Join Date: Sep 2014
Location: Indonesia
Posts: 834
Reputation: 199
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.
__________________
viva la sa-mp

X337 is offline   Reply With Quote
Old 11/05/2015, 08:55 AM   #16
Crystallize
High-roller
 
Join Date: Aug 2013
Posts: 1,477
Reputation: 283
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.
__________________

Crystallize is offline   Reply With Quote
Old 11/05/2015, 08:58 AM   #17
Ghazal
Gangsta
 
Ghazal's Avatar
 
Join Date: Oct 2013
Location: Egypt
Posts: 508
Reputation: 106
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 Ghazal; 11/05/2015 at 09:49 AM.
Ghazal is offline   Reply With Quote
Old 11/05/2015, 11:07 AM   #18
X337
Gangsta
 
X337's Avatar
 
Join Date: Sep 2014
Location: Indonesia
Posts: 834
Reputation: 199
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
__________________
viva la sa-mp

X337 is offline   Reply With Quote
Old 11/05/2015, 11:25 AM   #19
Ghazal
Gangsta
 
Ghazal's Avatar
 
Join Date: Oct 2013
Location: Egypt
Posts: 508
Reputation: 106
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!
Ghazal is offline   Reply With Quote
Old 11/05/2015, 11:37 AM   #20
X337
Gangsta
 
X337's Avatar
 
Join Date: Sep 2014
Location: Indonesia
Posts: 834
Reputation: 199
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
__________________
viva la sa-mp

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
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 03:14 PM.


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