[GameMode] California Cops and Robbers 0.3.7 (Fully MySQL+UCP) (Lot of Features) (Minigames)

[GameMode] California Cops and Robbers 0.3.7 (Fully MySQL+UCP) (Lot of Features) (Minigames) - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Gamemode Scripts (https://sampforum.blast.hk/forumdisplay.php?fid=71)
+--- Thread: [GameMode] California Cops and Robbers 0.3.7 (Fully MySQL+UCP) (Lot of Features) (Minigames) (/showthread.php?tid=573762)

Pages: 1 2 3 4 5 6 7 8 9 10 11 12 13 14

Re: California Cops and Robbers 0.3.7 (Fully MySQL+UCP) (Lot of Features) (Minigames) - MarkNelson - 16.03.2016

Good job

Re: California Cops and Robbers 0.3.7 (Fully MySQL+UCP) (Lot of Features) (Minigames) - Thyphon - 10.04.2016

Good Job Nice!

Re: California Cops and Robbers 0.3.7 (Fully MySQL+UCP) (Lot of Features) (Minigames) - RegMan - 11.04.2016

I still cannot spawn

The server is launched without any errors
define.inc => Configured to database
koneksi.php => Configured to database

All seems to be fine, but i cannot spawn.
I have a question : On the UCP : how can i register ? i must register my player on the game after that i can login on the UCP ?

Please Advice Community.

Re: California Cops and Robbers 0.3.7 (Fully MySQL+UCP) (Lot of Features) (Minigames) - iKevin - 11.04.2016

You can login in the UCP with the ig name. Do you have localhost MySQL?

Re: California Cops and Robbers 0.3.7 (Fully MySQL+UCP) (Lot of Features) (Minigames) - RegMan - 11.04.2016

Yes, the database is working fine.
as requested i update the define.inc and the koneksi.php file.
i don't know where is the issue !! I'm sooo tired

Re: California Cops and Robbers 0.3.7 (Fully MySQL+UCP) (Lot of Features) (Minigames) - Fairuz - 12.04.2016

Quote:

Originally Posted by RegMan

Yes, the database is working fine.
as requested i update the define.inc and the koneksi.php file.
i don't know where is the issue !! I'm sooo tired

http://forum.sa-mp.com/showpost.php?...&postcount=524

If the link i gave it above to download the SQL file is not working,try this.

Download the SQL file from the thread
Open it with notepad++
Press Ctrl+F
Search 'bondowocopz' then change it to 'root'

Re: California Cops and Robbers 0.3.7 (Fully MySQL+UCP) (Lot of Features) (Minigames) - Xecutioner - 18.04.2016

Good mod

Re: California Cops and Robbers 0.3.7 (Fully MySQL+UCP) (Lot of Features) (Minigames) - E7mad - 19.04.2016

The "ccnr.sql" file includes weird words and functions, and the phpMyAdmins said: error, this is not a "SQL" file....
Can someone please give me the link of a working ccnr.sql please?
+REP

Re: California Cops and Robbers 0.3.7 (Fully MySQL+UCP) (Lot of Features) (Minigames) - Ritzy2K - 19.04.2016

There is a working ccnr.SQL uploaded by bradley7 if you just look around in the thread.

Re: California Cops and Robbers 0.3.7 (Fully MySQL+UCP) (Lot of Features) (Minigames) - ssguy - 04.05.2016

Can anyone teach me how to copy the gamemode and scriptfiles then paste it on my server than how to start it
can anyone give me a video of it?

Re: California Cops and Robbers 0.3.7 (Fully MySQL+UCP) (Lot of Features) (Minigames) - Zues - 07.05.2016

Quote:

Originally Posted by ssguy

Can anyone teach me how to copy the gamemode and scriptfiles then paste it on my server than how to start it
can anyone give me a video of it?

Download the samp server files from sa-mp.com.Then just merge this gamemode's files with the sa-mp.com server files.

But you have to have a MySQL database running so if you are using windows you should get XAMPP or WAMP and setup the password and keep the username root. (I would recommend using MySQL workbench though but it's a much larger download.) Then create a database and name it "ccnr" and import this file to it : https://www.mediafire.com/?2w82x27o6oo1gs1

Then all you have to do is edit pawno/include/define.inc and change the mysql details to match your newly created mysql server's.And recompile the gamemode with pawno.

And to start it run samp-server.exe.

Quote:

Originally Posted by [ND]xXZeusXx.

There is a working ccnr.SQL uploaded by bradley7 if you just look around in the thread.

Nope, if you tried to download it you would've noticed that his link is not working either.But I uploaded it for ya guys that still want it : https://www.mediafire.com/?2w82x27o6oo1gs1

Re: California Cops and Robbers 0.3.7 (Fully MySQL+UCP) (Lot of Features) (Minigames) - Mark_Samp - 07.05.2016

Amazing!!

Re: California Cops and Robbers 0.3.7 (Fully MySQL+UCP) (Lot of Features) (Minigames) - JayJay23 - 07.05.2016

Perfect !

Re: California Cops and Robbers 0.3.7 (Fully MySQL+UCP) (Lot of Features) (Minigames) - TahirImran - 08.05.2016

when importing database giving this error any soultion:

PHP код:



Error
SQL query:


CREATE DEFINER=`bondowocopz`@`localhost` FUNCTION `time_function`(`ATIME` DATETIME) RETURNS varchar(100) CHARSET latin1
BEGIN
  DECLARE INF VARCHAR(100);
  DECLARE NWT VARCHAR(100);
  DECLARE TAG TINYINT;
  
  SET TAG = 0;  
  SET INF = DATE_FORMAT(ATIME, "%Y%m%d%H%i%s");
  SET NWT = DATE_FORMAT(NOW(), "%Y%m%d%H%i%s");
  
  
  IF (INF = NWT) THEN
    SET INF = 'Just a moment';
    SET TAG = 1;
  END IF;  
  
  
  
  IF (SUBSTR(INF, 1, 12) =  SUBSTR(NWT, 1, 12))  AND (TAG = 0) THEN
    SET INF = CONCAT(SUBSTR(NWT, 13, 2) - SUBSTR(INF, 13, 2), ' seconds ago');
    SET TAG = 1;
  END IF;  
  
  
  IF (SUBSTR(INF, 1, 10) =  SUBSTR(NWT, 1, 10)) AND (TAG = 0) THEN
    SET INF = CONCAT(SUBSTR(NWT, 11, 2) - SUBSTR(INF, 11, 2), ' minutes ago');
    SET TAG = 1;
  END IF;  
  
  
  
  IF (SUBSTR(INF, 1, 8) =  SUBSTR(NWT, 1, 8)) AND (TAG = 0) THEN
    SET INF = CONCAT(SUBSTR(NWT, 9, 2) - SUBSTR(INF, 9, 2), ' hours ago');
    SET TAG = 1;
  END IF;  
  
  
  IF[...]
MySQL said: Documentation

#1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation

Re: California Cops and Robbers 0.3.7 (Fully MySQL+UCP) (Lot of Features) (Minigames) - Fairuz - 08.05.2016

I updated the download link.
click here!

Tutorial with WAMP:http://forum.sa-mp.com/showpost.php?...&postcount=524

Re: California Cops and Robbers 0.3.7 (Fully MySQL+UCP) (Lot of Features) (Minigames) - legendd - 08.05.2016

Good work man, good GM

Re: California Cops and Robbers 0.3.7 (Fully MySQL+UCP) (Lot of Features) (Minigames) - Zorono - 09.05.2016

Guys:-
i have used this best gm but i got error
WARNING: INVALID ARGUMENT SUPPLIED FOR FOREACH() IN /HOME/U177214519/PUBLIC_HTML/PLAYERLIST.PHP ON LINE 92
and i have did all the steps to setup my gm on linux 0..37 and i verfied mysql and everything but i got unknown gm please help

Re: California Cops and Robbers 0.3.7 (Fully MySQL+UCP) (Lot of Features) (Minigames) - Fairuz - 09.05.2016

Quote:

Originally Posted by Zorono

Guys:-
i have used this best gm but i got error
WARNING: INVALID ARGUMENT SUPPLIED FOR FOREACH() IN /HOME/U177214519/PUBLIC_HTML/PLAYERLIST.PHP ON LINE 92
and i have did all the steps to setup my gm on linux 0..37 and i verfied mysql and everything but i got unknown gm please help

Read my tutorial right here
http://forum.sa-mp.com/showpost.php?...&postcount=524

I will make a tutorial how to use the UCP later.

Re: California Cops and Robbers 0.3.7 (Fully MySQL+UCP) (Lot of Features) (Minigames) - DeathReaper - 10.05.2016

Good one bonodowonoob

Re: California Cops and Robbers 0.3.7 (Fully MySQL+UCP) (Lot of Features) (Minigames) - Fantje - 10.05.2016

Okay guys lets help me.

I KNOW HOW TO CONNECT TO MYSQL.

I can't spawn like many others...

-I loaded the mysql plugin succesfully
-I edited define.inc to my details
-I recompiled

I tried with XAMPP AND WAMPP

Both not working...

Please help!